{"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-10-21T16:44:47.374Z","last_verified_at":"2026-10-21T14:51:35.454Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-10-14T22:49:50.220Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-14T21:04:23.816Z","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"5b86827e-a848-4295-b242-91ac4e71dc2b","institution_type":"GOVERNMENT","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":"Accounts of the City of Strasbourg","description_en":"This API provides access to the main budget accounts of the City of Strasbourg, as supplied by the Directorate General of Public Finances (Direction Générale des Finances Publiques). Amounts are expressed in thousands of euros. The data covers municipal financial statements and can be used to analyze the city's budgetary situation over time. It is published via the Strasbourg open-data platform, offering free and unauthenticated access to the underlying figures for research, transparency, or civic monitoring purposes.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":40.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","content_changed_at":"2026-10-12T16:58:04.069Z","institution":null,"title_qualifier":null,"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":"5b86827e-a848-4295-b242-91ac4e71dc2b","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-10-24T07:03:29.665Z"},"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-10-21T14:37:10.702Z","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-10-21T14:51:35.248Z","p50_latency_ms":884,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-28T10:04:05.338Z","updated_at":"2026-10-21T14:51:35.248Z","consecutive_successes":25,"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-10-21T14:51:35.248Z"},"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,"description_en":"Fiscal/accounting year of the budget data."},{"name":"dep","type":"text","label":"Code Département","fill_pct":100,"filterable":true,"description":null,"description_en":"Department code of the commune."},{"name":"depcom","type":"text","label":"Code Commune","fill_pct":100,"filterable":true,"description":null,"description_en":"INSEE code identifying the commune."},{"name":"commune","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Name of the commune."},{"name":"population","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Population count of the commune."},{"name":"produits_total","type":"int","label":"Total Produits","fill_pct":100,"filterable":true,"description":null,"description_en":"Total revenue, in thousands of euros."},{"name":"prod_impots_locaux","type":"int","label":"Produits Impôts Locaux","fill_pct":100,"filterable":true,"description":null,"description_en":"Revenue from local taxes, in thousands of euros."},{"name":"prod_autres_impots_taxes","type":"int","label":"Produits Autres Impôts Taxes","fill_pct":100,"filterable":true,"description":null,"description_en":"Revenue from other taxes and duties, in thousands of euros."},{"name":"prod_dotation","type":"int","label":"Produits Dotation","fill_pct":100,"filterable":true,"description":null,"description_en":"Revenue from state grants and allocations, in thousands of euros."},{"name":"charges_total","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Total operating expenses, in thousands of euros."},{"name":"charges_personnel","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Staff/personnel expenses, in thousands of euros."},{"name":"charges_achats","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Expenses on purchases of goods and services, in thousands of euros."},{"name":"charges_financieres","type":"int","label":"Charges Financières","fill_pct":100,"filterable":true,"description":null,"description_en":"Financial (interest) expenses, in thousands of euros."},{"name":"charges_contingents","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Mandatory contributions and levies paid, in thousands of euros."},{"name":"charges_subventions","type":"int","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Subsidies and grants paid out, in thousands of euros."},{"name":"resultat_comptable","type":"int","label":"Résultat Comptable","fill_pct":100,"filterable":true,"description":null,"description_en":"Accounting result (surplus or deficit), in thousands of euros."},{"name":"invest_ressources_total","type":"int","label":"Total Investissement Ressources","fill_pct":100,"filterable":true,"description":null,"description_en":"Total investment resources, in thousands of euros."},{"name":"invest_ress_emprunts","type":"int","label":"Investissement Ressources Emprunts","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment resources from loans, in thousands of euros."},{"name":"invest_ress_subventions","type":"int","label":"Investissement Ressource Subventions","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment resources from subsidies, in thousands of euros."},{"name":"invest_ress_fctva","type":"int","label":"Investissement Ressource FCTVA","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment resources from VAT compensation fund (FCTVA), in thousands of euros."},{"name":"invest_ress_retours","type":"int","label":"Investissement Ressources Retours de Biens Affectés, Concédés","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment resources from return of assigned or conceded assets, in thousands of euros."},{"name":"invest_emplois_total","type":"int","label":"Total des Emplois Investissement","fill_pct":100,"filterable":true,"description":null,"description_en":"Total investment spending, in thousands of euros."},{"name":"invest_empl_equipements","type":"int","label":"Investissement Emploi Equipements","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment spending on equipment, in thousands of euros."},{"name":"invest_empl_remboursement_emprunts","type":"int","label":"Investissement Emploi Remboursement Emprunts","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment spending on loan repayments, in thousands of euros."},{"name":"invest_empl_charges","type":"int","label":"Investissement Emploi Charges à répartir","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment spending on deferred charges, in thousands of euros."},{"name":"invest_empl_immobilisations","type":"int","label":"Investissement Emploi Immobilisations Affectées, Concédées","fill_pct":100,"filterable":true,"description":null,"description_en":"Investment spending on assigned or conceded fixed assets, in thousands of euros."},{"name":"excedent_brut","type":"int","label":"Excédent Brut","fill_pct":100,"filterable":true,"description":null,"description_en":"Gross operating surplus, in thousands of euros."},{"name":"cap_autofinancement","type":"int","label":"Capacité d'autofinancement","fill_pct":100,"filterable":true,"description":null,"description_en":"Self-financing capacity, in thousands of euros."},{"name":"cap_autofinancement_nette","type":"int","label":"Capacité d'autofinancement Nette du remboursement en capital des emprunts","fill_pct":100,"filterable":true,"description":null,"description_en":"Net self-financing capacity after loan principal repayment, in thousands of euros."},{"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,"description_en":"Total outstanding debt as of December 31, in thousands of euros."},{"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,"description_en":"Outstanding bank debt net of toxic-loan support fund aid, in thousands of euros."},{"name":"avance_tresor","type":"int","label":"Avance Trésor","fill_pct":52.6,"filterable":true,"description":null,"description_en":"Advance from the Treasury, in thousands of euros."},{"name":"dette_annuite","type":"int","label":"Annuité de la dette","fill_pct":100,"filterable":true,"description":null,"description_en":"Annual debt service (principal plus interest), in thousands of euros."},{"name":"fond_de_roulement","type":"int","label":"Fonds de Roulement","fill_pct":100,"filterable":true,"description":null,"description_en":"Working capital fund balance, in thousands of euros."},{"name":"taxe_habitation","type":"int","label":"Produits Taxe d'habitation (y compris THLV)","fill_pct":100,"filterable":true,"description":null,"description_en":"Revenue from residence tax (including THLV), in thousands of euros."},{"name":"taxe_habitation_base","type":"int","label":"Base Taxe d'habitation (y compris THLV)","fill_pct":52.6,"filterable":true,"description":null,"description_en":"Tax base for residence tax (including THLV)."},{"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,"description_en":"Revenue from property tax on built properties, in thousands of euros."},{"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,"description_en":"Tax base for property tax on built properties."},{"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,"description_en":"Revenue from property tax on unbuilt properties, in thousands of euros."},{"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,"description_en":"Tax base for property tax on unbuilt properties."},{"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,"description_en":"Revenue from additional tax on unbuilt property tax, in thousands of euros."},{"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,"description_en":"Tax base for additional tax on unbuilt property tax."},{"name":"cotis_fonciere_entreprises","type":"int","label":"Produits Cotisation foncière des entreprises","fill_pct":42.1,"filterable":true,"description":null,"description_en":"Revenue from business property contribution (CFE), in thousands of euros."},{"name":"cotis_fonciere_entreprises_base","type":"int","label":"Base Cotisation foncière des entreprises","fill_pct":42.1,"filterable":true,"description":null,"description_en":"Tax base for business property contribution (CFE)."},{"name":"cotisation_valeur_ajoutee_entreprises","type":"int","label":"Cotisation sur la valeur ajoutée des entreprises","fill_pct":42.1,"filterable":true,"description":null,"description_en":"Revenue from business value-added contribution (CVAE), in thousands of euros."},{"name":"impot_forfait_entreprise_reseau","type":"int","label":"Imposition forfaitaire sur les entreprises de réseau","fill_pct":42.1,"filterable":true,"description":null,"description_en":"Revenue from flat-rate tax on network businesses (IFER), in thousands of euros."},{"name":"taxe_surf_commerciales","type":"int","label":"Taxe sur les surfaces commerciales","fill_pct":42.1,"filterable":true,"description":null,"description_en":"Revenue from tax on commercial floor space (TASCOM), in thousands of euros."},{"name":"compensation_relais_2010","type":"int","label":null,"fill_pct":5.3,"filterable":true,"description":null,"description_en":"2010 transitional compensation amount, in thousands of euros."},{"name":"taxe_professionnelle","type":"int","label":"Produits Taxe Professionnelle","fill_pct":52.6,"filterable":true,"description":null,"description_en":"Revenue from business tax (taxe professionnelle), in thousands of euros."},{"name":"taxe_professionnelle_base","type":"text","label":"Base Taxe Professionnelle","fill_pct":5.3,"filterable":true,"description":null,"description_en":"Tax base for business tax (taxe professionnelle)."},{"name":"geopoint","type":"geo_point_2d","label":null,"filterable":false,"description":null,"description_en":"Geographic coordinates of the commune."}],"field_count":51,"sample_records":[{"dep":"67","annee":"2003","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":267051,"avance_tresor":29610,"charges_total":305242,"dette_annuite":0,"excedent_brut":13063,"prod_dotation":48493,"taxe_non_bati":259,"charges_achats":53677,"produits_total":318603,"taxe_habitation":49003,"charges_personnel":159094,"fond_de_roulement":-5689,"invest_ress_fctva":4572,"taxe_add_non_bati":null,"taxe_foncier_bati":55383,"prod_impots_locaux":106131,"resultat_comptable":13361,"taxe_non_bati_base":null,"cap_autofinancement":18776,"charges_contingents":8521,"charges_financieres":3333,"charges_subventions":53696,"dette_encours_total":117429,"invest_empl_charges":7240,"invest_ress_retours":0,"invest_emplois_total":129596,"invest_ress_emprunts":69000,"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":62374,"invest_ress_subventions":4758,"invest_ressources_total":132072,"compensation_relais_2010":null,"prod_autres_impots_taxes":12946,"cap_autofinancement_nette":-7861,"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":26636,"cotisation_valeur_ajoutee_entreprises":null},{"dep":"67","annee":"2012","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":276136,"avance_tresor":null,"charges_total":359115,"dette_annuite":17768,"excedent_brut":38059,"prod_dotation":62034,"taxe_non_bati":444,"charges_achats":67282,"produits_total":450608,"taxe_habitation":63592,"charges_personnel":187375,"fond_de_roulement":21629,"invest_ress_fctva":7006,"taxe_add_non_bati":0,"taxe_foncier_bati":74220,"prod_impots_locaux":139410,"resultat_comptable":91494,"taxe_non_bati_base":646,"cap_autofinancement":99611,"charges_contingents":14083,"charges_financieres":4003,"charges_subventions":41565,"dette_encours_total":122319,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":115214,"invest_ress_emprunts":0,"taxe_habitation_base":264308,"taxe_professionnelle":null,"dette_encours_bancaire":null,"taxe_add_non_bati_base":0,"taxe_foncier_bati_base":348446,"taxe_surf_commerciales":0,"invest_empl_equipements":97390,"invest_ress_subventions":7122,"invest_ressources_total":97459,"compensation_relais_2010":null,"prod_autres_impots_taxes":17544,"cap_autofinancement_nette":85466,"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":14146,"cotisation_valeur_ajoutee_entreprises":0},{"dep":"67","annee":"2018","depcom":"67482","commune":"STRASBOURG","geopoint":{"lat":48.5712679849,"lon":7.76752679517},"population":281512,"avance_tresor":null,"charges_total":392936,"dette_annuite":27848,"excedent_brut":39900,"prod_dotation":43562,"taxe_non_bati":605,"charges_achats":76692,"produits_total":425901,"taxe_habitation":77149,"charges_personnel":198128,"fond_de_roulement":23610,"invest_ress_fctva":6127,"taxe_add_non_bati":0,"taxe_foncier_bati":85864,"prod_impots_locaux":165650,"resultat_comptable":32964,"taxe_non_bati_base":834,"cap_autofinancement":42410,"charges_contingents":14937,"charges_financieres":2846,"charges_subventions":45551,"dette_encours_total":null,"invest_empl_charges":0,"invest_ress_retours":0,"invest_emplois_total":104372,"invest_ress_emprunts":0,"taxe_habitation_base":303819,"taxe_professionnelle":null,"dette_encours_bancaire":"193863","taxe_add_non_bati_base":0,"taxe_foncier_bati_base":381866,"taxe_surf_commerciales":0,"invest_empl_equipements":73140,"invest_ress_subventions":7023,"invest_ressources_total":90987,"compensation_relais_2010":null,"prod_autres_impots_taxes":21584,"cap_autofinancement_nette":17407,"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":25003,"cotisation_valeur_ajoutee_entreprises":0},{"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}],"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-10-21T14:37:09.187Z","run_id":"a636eebc-2cfb-4ecf-accc-905e5ef097c2","created_at":"2026-07-25T21:01:34.797Z","updated_at":"2026-10-21T14:37:09.187Z","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-10-21T14:37:10.872Z"}],"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":"70a6351f5c70a306c1c57a64658d0176611574a3c4c250b1150a457d7656c268","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-10-24T07:04:34.801Z","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."}}