{"id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","type":"API","name":"Comptes de la Ville de Strasbourg","slug":"comptes-de-la-ville-de-strasbourg","description":"Budget principal de Strasbourg tel que fourni par la Direction Générale des Finances Publiques. Les montants sont en milliers d'euros.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://data.strasbourg.eu/explore/dataset/comptes-des-collectivites/","docs_url":"https://data.strasbourg.eu/explore/dataset/comptes-des-collectivites/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://data.strasbourg.eu/assets/favicon?tstamp=154210176917","primary_source_url":"https://data.strasbourg.eu/explore/dataset/comptes-des-collectivites/","extraction_confidence":"0.00","created_at":"2026-07-25T20:40:21.773Z","updated_at":"2026-09-08T05:42:16.200Z","last_verified_at":"2026-09-07T23:49:29.637Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-08-30T20:04:21.081Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-08T05:42:16.200Z","search_vector":"'budget':7B,34B 'compt':1A 'comptes':28A 'd':26B,53B 'de':2A,5A,9B,29A,32A,36B 'des':18B,45B 'direct':16B 'direction':43B 'en':24B,51B 'euro':27B 'euros':54B 'financ':19B 'finances':46B 'fourni':13B,40B 'generale':44B 'générale':17B 'la':3A,15B,30A,42B 'les':21B,48B 'millier':25B 'milliers':52B 'montant':22B 'montants':49B 'par':14B,41B 'princip':8B 'principal':35B 'publiqu':20B 'publiques':47B 'que':12B,39B 'sont':23B,50B 'strasbourg':6A,10B,33A,37B 'tel':11B,38B 'vill':4A 'ville':31A","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-27T13:48:00.000Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":38.75,"merged_into_entry_id":null,"identity_key":"API|https://data.strasbourg.eu/explore/dataset/comptes-des-collectivites|comptes de la ville de strasbourg","upstream_ref":"data.strasbourg.eu:dataset:comptes-des-collectivites","access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?select=annee%2Cdep%2Cdepcom&where=dep+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://data.strasbourg.eu/explore/dataset/comptes-des-collectivites/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"joinable","level_index":5,"level_label":"Joinable","meaning":"Canonical identifiers and concepts mapped","counts_as_coverage":true,"blocked_by":null,"rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":true,"reached":true,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":true,"reached":true,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":true,"reached":true,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":0,"proven_threshold":80,"institution_id":null,"definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"data.strasbourg.eu","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-09-09T03:42:03.818Z"},"api_details":{"id":"ea98e1fe-d587-4a03-9b51-9a8c03e0ab8e","entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","base_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites","created_at":"2026-07-25T20:40:21.931Z","updated_at":"2026-07-25T20:40:21.931Z"},"dataset_details":{"id":"ca3d423a-627f-43e6-948b-c4f54b8b6f45","entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","upstream_issued":null,"upstream_modified":"2020-08-18T14:10:26.000Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"opendatasoft","source_portal_url":"https://data.strasbourg.eu","created_at":"2026-07-25T21:01:35.432Z","updated_at":"2026-09-02T12:01:03.532Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"reuse":{"license_id":"lo-2.0","license_name":"Licence Ouverte 2.0 (France / Etalab)","license_url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reviewed_at":null},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2018/11/open-licence.pdf","latest_check":{"id":"9ca2a9ae-10e9-45b0-8357-4d566f0cfd71","entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","status":"VERIFIED","last_checked_at":"2026-09-07T23:49:29.324Z","p50_latency_ms":3202,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-28T10:04:05.338Z","updated_at":"2026-09-07T23:49:29.324Z","consecutive_successes":12,"probe_url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-09-07T23:49:29.324Z"},"data_profile":{"id":"e39de0a1-94df-4587-a101-55b8e6a5b03c","entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"comptes-des-collectivites","fields":[{"name":"annee","type":"date","label":"Année","fill_pct":100,"filterable":true,"description":null},{"name":"dep","type":"text","label":"Code Département","fill_pct":100,"filterable":true,"description":null},{"name":"depcom","type":"text","label":"Code Commune","fill_pct":100,"filterable":true,"description":null},{"name":"commune","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"population","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"produits_total","type":"int","label":"Total Produits","fill_pct":100,"filterable":true,"description":null},{"name":"prod_impots_locaux","type":"int","label":"Produits Impôts Locaux","fill_pct":100,"filterable":true,"description":null},{"name":"prod_autres_impots_taxes","type":"int","label":"Produits Autres Impôts Taxes","fill_pct":100,"filterable":true,"description":null},{"name":"prod_dotation","type":"int","label":"Produits Dotation","fill_pct":100,"filterable":true,"description":null},{"name":"charges_total","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"charges_personnel","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"charges_achats","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"charges_financieres","type":"int","label":"Charges Financières","fill_pct":100,"filterable":true,"description":null},{"name":"charges_contingents","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"charges_subventions","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"resultat_comptable","type":"int","label":"Résultat Comptable","fill_pct":100,"filterable":true,"description":null},{"name":"invest_ressources_total","type":"int","label":"Total Investissement Ressources","fill_pct":100,"filterable":true,"description":null},{"name":"invest_ress_emprunts","type":"int","label":"Investissement Ressources Emprunts","fill_pct":100,"filterable":true,"description":null},{"name":"invest_ress_subventions","type":"int","label":"Investissement Ressource Subventions","fill_pct":100,"filterable":true,"description":null},{"name":"invest_ress_fctva","type":"int","label":"Investissement Ressource FCTVA","fill_pct":100,"filterable":true,"description":null},{"name":"invest_ress_retours","type":"int","label":"Investissement Ressources Retours de Biens Affectés, Concédés","fill_pct":100,"filterable":true,"description":null},{"name":"invest_emplois_total","type":"int","label":"Total des Emplois Investissement","fill_pct":100,"filterable":true,"description":null},{"name":"invest_empl_equipements","type":"int","label":"Investissement Emploi Equipements","fill_pct":100,"filterable":true,"description":null},{"name":"invest_empl_remboursement_emprunts","type":"int","label":"Investissement Emploi Remboursement Emprunts","fill_pct":100,"filterable":true,"description":null},{"name":"invest_empl_charges","type":"int","label":"Investissement Emploi Charges à répartir","fill_pct":100,"filterable":true,"description":null},{"name":"invest_empl_immobilisations","type":"int","label":"Investissement Emploi Immobilisations Affectées, Concédées","fill_pct":100,"filterable":true,"description":null},{"name":"excedent_brut","type":"int","label":"Excédent Brut","fill_pct":100,"filterable":true,"description":null},{"name":"cap_autofinancement","type":"int","label":"Capacité d'autofinancement","fill_pct":100,"filterable":true,"description":null},{"name":"cap_autofinancement_nette","type":"int","label":"Capacité d'autofinancement Nette du remboursement en capital des emprunts","fill_pct":100,"filterable":true,"description":null},{"name":"dette_encours_total","type":"int","label":"Dette Encours total de la dette au 31 décembre N","fill_pct":94.7,"filterable":true,"description":null},{"name":"dette_encours_bancaire","type":"text","label":"Dette Encours des dettes bancaires net de l'aide du fonds de soutien pour la sortie des emprunts toxiques","fill_pct":15.8,"filterable":true,"description":null},{"name":"avance_tresor","type":"int","label":"Avance Trésor","fill_pct":52.6,"filterable":true,"description":null},{"name":"dette_annuite","type":"int","label":"Annuité de la dette","fill_pct":100,"filterable":true,"description":null},{"name":"fond_de_roulement","type":"int","label":"Fonds de Roulement","fill_pct":100,"filterable":true,"description":null},{"name":"taxe_habitation","type":"int","label":"Produits Taxe d'habitation (y compris THLV)","fill_pct":100,"filterable":true,"description":null},{"name":"taxe_habitation_base","type":"int","label":"Base Taxe d'habitation (y compris THLV)","fill_pct":52.6,"filterable":true,"description":null},{"name":"taxe_foncier_bati","type":"int","label":"Produits Taxe foncière sur les propriétés bâties","fill_pct":100,"filterable":true,"description":null},{"name":"taxe_foncier_bati_base","type":"int","label":"Base Taxe foncière sur les propriétés bâties","fill_pct":52.6,"filterable":true,"description":null},{"name":"taxe_non_bati","type":"int","label":"Produits Taxe foncière sur les propriétés non bâties","fill_pct":100,"filterable":true,"description":null},{"name":"taxe_non_bati_base","type":"int","label":"Base Taxe foncière sur les propriétés non bâties","fill_pct":52.6,"filterable":true,"description":null},{"name":"taxe_add_non_bati","type":"int","label":"Produits Taxe additionnelle à la taxe foncière sur les propriétés non bâties","fill_pct":47.4,"filterable":true,"description":null},{"name":"taxe_add_non_bati_base","type":"int","label":"Base Taxe additionnelle à la taxe foncière sur les propriétés non bâties","fill_pct":47.4,"filterable":true,"description":null},{"name":"cotis_fonciere_entreprises","type":"int","label":"Produits Cotisation foncière des entreprises","fill_pct":42.1,"filterable":true,"description":null},{"name":"cotis_fonciere_entreprises_base","type":"int","label":"Base Cotisation foncière des entreprises","fill_pct":42.1,"filterable":true,"description":null},{"name":"cotisation_valeur_ajoutee_entreprises","type":"int","label":"Cotisation sur la valeur ajoutée des entreprises","fill_pct":42.1,"filterable":true,"description":null},{"name":"impot_forfait_entreprise_reseau","type":"int","label":"Imposition forfaitaire sur les entreprises de réseau","fill_pct":42.1,"filterable":true,"description":null},{"name":"taxe_surf_commerciales","type":"int","label":"Taxe sur les surfaces commerciales","fill_pct":42.1,"filterable":true,"description":null},{"name":"compensation_relais_2010","type":"int","label":null,"fill_pct":5.3,"filterable":true,"description":null},{"name":"taxe_professionnelle","type":"int","label":"Produits Taxe Professionnelle","fill_pct":52.6,"filterable":true,"description":null},{"name":"taxe_professionnelle_base","type":"text","label":"Base Taxe Professionnelle","fill_pct":5.3,"filterable":true,"description":null},{"name":"geopoint","type":"geo_point_2d","label":null,"filterable":false,"description":null}],"field_count":51,"sample_records":[{"dep":"67","annee":"2007","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":267051,"avance_tresor":24624,"charges_total":311726,"dette_annuite":0,"excedent_brut":50809,"prod_dotation":59735,"taxe_non_bati":313,"charges_achats":48584,"produits_total":348399,"taxe_habitation":56860,"charges_personnel":176775,"fond_de_roulement":-7052,"invest_ress_fctva":9172,"taxe_add_non_bati":null,"taxe_foncier_bati":64952,"prod_impots_locaux":122570,"resultat_comptable":36672,"taxe_non_bati_base":null,"cap_autofinancement":46878,"charges_contingents":7710,"charges_financieres":5075,"charges_subventions":38923,"dette_encours_total":122629,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":116411,"invest_ress_emprunts":0,"taxe_habitation_base":null,"taxe_professionnelle":0,"dette_encours_bancaire":null,"taxe_add_non_bati_base":null,"taxe_foncier_bati_base":null,"taxe_surf_commerciales":null,"invest_empl_equipements":83687,"invest_ress_subventions":11072,"invest_ressources_total":104290,"compensation_relais_2010":null,"prod_autres_impots_taxes":16022,"cap_autofinancement_nette":27201,"taxe_professionnelle_base":null,"cotis_fonciere_entreprises":null,"invest_empl_immobilisations":0,"cotis_fonciere_entreprises_base":null,"impot_forfait_entreprise_reseau":null,"invest_empl_remboursement_emprunts":19677,"cotisation_valeur_ajoutee_entreprises":null},{"dep":"67","annee":"2001","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":267051,"avance_tresor":34613,"charges_total":279707,"dette_annuite":0,"excedent_brut":21335,"prod_dotation":46831,"taxe_non_bati":145,"charges_achats":49247,"produits_total":291955,"taxe_habitation":29239,"charges_personnel":149376,"fond_de_roulement":-493,"invest_ress_fctva":4048,"taxe_add_non_bati":null,"taxe_foncier_bati":30485,"prod_impots_locaux":139969,"resultat_comptable":12249,"taxe_non_bati_base":null,"cap_autofinancement":19204,"charges_contingents":9676,"charges_financieres":3381,"charges_subventions":39396,"dette_encours_total":68097,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":83805,"invest_ress_emprunts":26000,"taxe_habitation_base":null,"taxe_professionnelle":78251,"dette_encours_bancaire":null,"taxe_add_non_bati_base":null,"taxe_foncier_bati_base":null,"taxe_surf_commerciales":null,"invest_empl_equipements":45994,"invest_ress_subventions":4815,"invest_ressources_total":92281,"compensation_relais_2010":null,"prod_autres_impots_taxes":11939,"cap_autofinancement_nette":-12478,"taxe_professionnelle_base":null,"cotis_fonciere_entreprises":null,"invest_empl_immobilisations":0,"cotis_fonciere_entreprises_base":null,"impot_forfait_entreprise_reseau":null,"invest_empl_remboursement_emprunts":31682,"cotisation_valeur_ajoutee_entreprises":null},{"dep":"67","annee":"2002","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":267051,"avance_tresor":37480,"charges_total":281269,"dette_annuite":0,"excedent_brut":17740,"prod_dotation":48002,"taxe_non_bati":215,"charges_achats":53009,"produits_total":288793,"taxe_habitation":44298,"charges_personnel":158261,"fond_de_roulement":-11308,"invest_ress_fctva":4428,"taxe_add_non_bati":null,"taxe_foncier_bati":50176,"prod_impots_locaux":97264,"resultat_comptable":7524,"taxe_non_bati_base":null,"cap_autofinancement":14165,"charges_contingents":8470,"charges_financieres":3072,"charges_subventions":37559,"dette_encours_total":74326,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":84296,"invest_ress_emprunts":42000,"taxe_habitation_base":null,"taxe_professionnelle":0,"dette_encours_bancaire":null,"taxe_add_non_bati_base":null,"taxe_foncier_bati_base":null,"taxe_surf_commerciales":null,"invest_empl_equipements":43561,"invest_ress_subventions":4976,"invest_ressources_total":74514,"compensation_relais_2010":null,"prod_autres_impots_taxes":12553,"cap_autofinancement_nette":-20924,"taxe_professionnelle_base":null,"cotis_fonciere_entreprises":null,"invest_empl_immobilisations":0,"cotis_fonciere_entreprises_base":null,"impot_forfait_entreprise_reseau":null,"invest_empl_remboursement_emprunts":35090,"cotisation_valeur_ajoutee_entreprises":null},{"dep":"67","annee":"2015","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":278937,"avance_tresor":null,"charges_total":359894,"dette_annuite":25123,"excedent_brut":44419,"prod_dotation":52092,"taxe_non_bati":523,"charges_achats":69969,"produits_total":390525,"taxe_habitation":73572,"charges_personnel":196389,"fond_de_roulement":24761,"invest_ress_fctva":14452,"taxe_add_non_bati":0,"taxe_foncier_bati":80072,"prod_impots_locaux":155160,"resultat_comptable":30631,"taxe_non_bati_base":739,"cap_autofinancement":38304,"charges_contingents":14607,"charges_financieres":4284,"charges_subventions":44441,"dette_encours_total":245625,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":175283,"invest_ress_emprunts":37400,"taxe_habitation_base":296904,"taxe_professionnelle":null,"dette_encours_bancaire":null,"taxe_add_non_bati_base":0,"taxe_foncier_bati_base":364964,"taxe_surf_commerciales":0,"invest_empl_equipements":97039,"invest_ress_subventions":12585,"invest_ressources_total":169457,"compensation_relais_2010":null,"prod_autres_impots_taxes":22168,"cap_autofinancement_nette":17399,"taxe_professionnelle_base":null,"cotis_fonciere_entreprises":0,"invest_empl_immobilisations":0,"cotis_fonciere_entreprises_base":0,"impot_forfait_entreprise_reseau":0,"invest_empl_remboursement_emprunts":20906,"cotisation_valeur_ajoutee_entreprises":0},{"dep":"67","annee":"2017","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":280680,"avance_tresor":null,"charges_total":370345,"dette_annuite":26948,"excedent_brut":37131,"prod_dotation":42651,"taxe_non_bati":544,"charges_achats":73368,"produits_total":397380,"taxe_habitation":75761,"charges_personnel":198394,"fond_de_roulement":29054,"invest_ress_fctva":10885,"taxe_add_non_bati":0,"taxe_foncier_bati":84086,"prod_impots_locaux":161649,"resultat_comptable":27035,"taxe_non_bati_base":750,"cap_autofinancement":37150,"charges_contingents":14789,"charges_financieres":3222,"charges_subventions":45892,"dette_encours_total":218700,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":98153,"invest_ress_emprunts":7370,"taxe_habitation_base":298262,"taxe_professionnelle":null,"dette_encours_bancaire":"218248","taxe_add_non_bati_base":0,"taxe_foncier_bati_base":373854,"taxe_surf_commerciales":0,"invest_empl_equipements":64002,"invest_ress_subventions":7696,"invest_ressources_total":85528,"compensation_relais_2010":null,"prod_autres_impots_taxes":27852,"cap_autofinancement_nette":13423,"taxe_professionnelle_base":null,"cotis_fonciere_entreprises":0,"invest_empl_immobilisations":0,"cotis_fonciere_entreprises_base":0,"impot_forfait_entreprise_reseau":0,"invest_empl_remboursement_emprunts":23727,"cotisation_valeur_ajoutee_entreprises":0}],"record_count":"19","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?limit=20","curl":"curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?select=annee%2Cdep%2Cdepcom&where=dep+is+not+null&limit=20","curl":"curl -s 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/records?select=annee%2Cdep%2Cdepcom&where=dep+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (annee, dep, depcom) and filter with ODSQL where clauses."},{"url":"https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/exports/csv","curl":"curl -sL 'https://data.strasbourg.eu/api/explore/v2.1/catalog/datasets/comptes-des-collectivites/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-09-02T12:01:02.106Z","run_id":"6c043426-450e-44c0-9fc3-6a0ff281924e","created_at":"2026-07-25T21:01:34.797Z","updated_at":"2026-09-02T12:01:02.106Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2018/11/open-licence.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":["population","produits_total","charges_total","invest_ressources_total","invest_emplois_total","dette_encours_total"],"entity_identifiers":[]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[{"id":"ae11c2f8-3a04-4c56-8b44-9f2a8e62c4e6","entry_id":"e6ac6211-3c54-4c26-afef-d93e1313b56e","limit_type":"requests_per_day","value":"10000000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-09-02T12:01:03.696Z"}],"source_access":{"status":"accessed_despite_disallow","host":"data.strasbourg.eu","requested_path_prefix":"/api/explore/v2.1/","robots_url":"https://data.strasbourg.eu/robots.txt","user_agent_group":"*","robots_rule":"Disallow: /api/","robots_read_at":"2026-08-25T11:29:16.804Z","decision_ref":"owner decision 2026-08-22, recorded in docs/PROGRESS.md NEEDS-HUMAN: public-sector open-data portals whose purpose is machine access; the directive is an Opendatasoft vendor default reflecting no publisher intent. Concern raised and overruled; see the row.","note":"This answer is derived from a host whose robots.txt DISALLOWS the path Commodity requests, and Commodity requests it anyway under the decision named in `decision_ref`. The rule is quoted verbatim so you can read it yourself. Commodity does not send a user-agent it is not, so any `Allow` granted to a named crawler in that file is not claimed here."},"field_provenance_source_access":{"status":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THIS PLATFORM’S READING OF ITS OWN CONDUCT: that it requests a path this host forbids. No publisher asserts it and none was asked to","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"host":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"the host Commodity addressed, lowercased and stripped of scheme and port by this platform so that one host has one row and one reading","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"requested_path_prefix":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THE PATH THE VERDICT IS ABOUT, derived from the base URLs this platform stores for the host — not `/`, and not an assumed `/api/`. A verdict about a path we do not call would describe someone else’s traffic","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_url":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"where the file was fetched from — composed by this platform from the host, at the one location the protocol fixes, so it can be re-fetched and the reading disputed","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"user_agent_group":{"basis":"stored_sample","derived":false,"upstream_field":"the `User-agent` line the deciding rule sits under","transform":"the group heading that made the rule OURS, verbatim from the stored file. Where it is `*` the directive addresses everyone; a group naming another crawler was not applied, because Commodity does not send a user-agent it is not","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_rule":{"basis":"stored_sample","derived":false,"upstream_field":"the directive line of the matching group","transform":"THE PUBLISHER’S OWN LINE, QUOTED AND UNCUT, as read from robots.txt at the moment below and stored — not fetched for this request, and not part of this response’s payload. It is here so the verdict beside it can be checked rather than taken from us","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_read_at":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"OUR CLOCK when the file was read, never a `Date` header the origin sent. It bounds how stale this reading may be: a publisher can have changed the file since","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"decision_ref":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"WHO DECIDED TO CALL IT ANYWAY, AND WHEN. Recorded by this platform and required by the database before the exception may exist at all, so it can never be anonymous","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"note":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"this platform’s sentence explaining what the reader is holding. Written here, by us, and not a quotation of anybody","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}}},"manifest":{"answer_sha256":"824202796f1c58fd9a5c3931380301f06d34a754e891d43b5ff8096e63c0a645","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":72,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (51 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-09-09T03:42:24.594Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}