{"id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","type":"API","name":"Comptes consolidés des communes depuis 2016","slug":"comptes-consolides-des-communes-depuis-2016","description":"Présentation du jeu de données : Les comptes consolidés des communes 2012-2023 présentent les principaux agrégats des comptes consolidés (budgets principaux et budgets annexes) des communes pour la période 2012-2023. Le calcul des agrégats a été réalisé par l'Observatoire des Finances et de la Ge...","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://data.ampmetropole.fr/explore/dataset/fed-comptes-consolides-des-communes-2012-2020/","docs_url":"https://data.ampmetropole.fr/explore/dataset/fed-comptes-consolides-des-communes-2012-2020/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://s3-eu-west-1.amazonaws.com/aws-ec2-eu-1-opendatasoft-staticfileset/ampmetropole/favicon?tstamp=158498047026","primary_source_url":"https://data.ampmetropole.fr/explore/dataset/fed-comptes-consolides-des-communes-2012-2020/","extraction_confidence":"0.40","created_at":"2026-07-24T19:21:49.782Z","updated_at":"2026-09-06T09:12:45.625Z","last_verified_at":"2026-09-06T09:12:45.625Z","deprecated_at":null,"ranking_score":55,"last_ranked_at":"2026-08-29T11:06:21.880Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-05T09:09:21.780Z","search_vector":"'-2023':23B,42B,159B,178B '2012':22B,41B,87B,158B,177B,223B '2016':6A,11A,142A,147A '2023':89B,225B 'a':183B,271B 'access':116B,252B 'account':9A,67B 'accounts':145A,203B 'aggreg':64B,91B 'aggregates':200B,227B 'agregats':163B,182B 'agrégat':27B,46B 'aix':78B,111B,214B,247B 'aix-marseille-prov':77B,110B 'aix-marseille-provence':213B,246B 'allow':126B 'allowing':262B 'analysi':127B 'analysis':263B 'and':206B,250B 'annex':35B,71B,207B 'annexes':171B 'are':228B 'area':82B,218B 'at':258B 'budget':31B,34B,69B,72B,130B,266B 'budgets':167B,170B,205B,208B 'by':230B,244B 'calcul':44B,93B,180B 'calculated':229B 'commune':4A,21B,37B 'communes':140A,157B,173B 'compt':1A,18B,29B 'comptes':137A,154B,165B 'consolid':7A,66B 'consolidated':143A,202B 'consolides':138A,155B,166B 'consolidé':2A,19B,30B 'cover':83B 'covering':219B 'data':121B,257B 'dataset':60B,196B 'de':15B,56B,100B,151B,192B,236B 'decad':136B 'decade':272B 'depui':5A 'depuis':141A 'des':3A,20B,28B,36B,45B,53B,97B,139A,156B,164B,172B,181B,189B,233B 'donnees':152B 'donné':16B 'du':13B,149B 'et':33B,55B,99B,169B,191B,235B 'ete':184B 'financ':54B,98B 'finances':190B,234B 'financi':120B 'financial':256B 'from':222B 'ge':58B,194B 'gestion':102B,238B 'govern':119B 'government':255B 'is':242B 'it':241B 'jeu':14B,150B 'l':51B,187B 'la':39B,57B,101B,175B,193B,237B 'le':43B,179B 'les':17B,25B,153B,161B 'level':125B,261B 'local':104B,118B,254B 'locales':240B 'main':63B,68B,199B,204B 'marseill':79B,112B 'marseille':215B,248B 'metropole':245B 'metropolitan':81B,217B 'more':269B 'municip':8A,74B,124B,129B 'municipal':144A,260B,265B 'municipalities':210B 'métropol':109B 'observatoir':52B,96B 'observatoire':188B,232B 'of':201B,209B,264B 'over':268B 'par':50B,186B 'period':85B,221B 'periode':176B 'pour':38B,174B 'present':61B 'presentation':148B 'presentent':160B 'presents':197B 'principaux':26B,32B,162B,168B 'provenc':80B,113B 'provence':216B,249B 'provid':115B 'provides':251B 'présentat':12B 'présentent':24B 'publiqu':103B 'publique':239B 'publish':107B 'published':243B 'périod':40B 'realise':185B 'réalisé':49B 'sinc':10A 'since':146A 'than':270B 'the':198B,212B,220B,226B,231B,259B 'this':195B 'to':224B,253B 'trend':131B 'trends':267B 'within':75B,211B 'été':48B","popularity_score":"0.0000","maintenance_score":"0.7000","institution_id":"d014fa31-f333-4e94-80a3-ea8b4459cfd5","institution_type":"MUNICIPALITY","country_code":"FR","official_confidence":40,"proof_summary":"40% - Official domain (ampmetropole.fr)","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-25T07:58:00.000Z","geographic_scope":"LOCAL","name_en":"Consolidated municipal accounts since 2016","description_en":"This dataset presents the main aggregates of consolidated accounts (main budgets and annex budgets) of municipalities within the Aix-Marseille-Provence metropolitan area, covering the period from 2012 to 2023. The aggregates are calculated by the Observatoire des Finances et de la Gestion Publique Locales. It is published by Métropole Aix-Marseille-Provence and provides access to local government financial data at the municipal level, allowing analysis of municipal budget trends over more than a decade.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":50.75,"merged_into_entry_id":null,"identity_key":"API|https://data.ampmetropole.fr/explore/dataset/fed-comptes-consolides-des-communes-2012-2020|comptes consolidés des communes depuis 2016","upstream_ref":"data.ampmetropole.fr:dataset:fed-comptes-consolides-des-communes-2012-2020","access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?select=exer%2Coutre_mer%2Creg_code&where=outre_mer+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://data.ampmetropole.fr/explore/dataset/fed-comptes-consolides-des-communes-2012-2020/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","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":40,"proven_threshold":80,"institution_id":"d014fa31-f333-4e94-80a3-ea8b4459cfd5","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.ampmetropole.fr","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-07T23:43:39.068Z"},"api_details":{"id":"ec86aeb4-c444-4fa4-a642-83e24931eb91","entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","base_url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020","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.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020","created_at":"2026-07-24T19:21:49.945Z","updated_at":"2026-07-24T19:21:49.945Z"},"dataset_details":{"id":"2a90ac5a-9be9-4858-9d89-8d93ef387c8e","entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","upstream_issued":null,"upstream_modified":"2026-08-08T02:24:51.984Z","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.ampmetropole.fr","created_at":"2026-07-24T19:25:11.200Z","updated_at":"2026-09-01T16:46:39.236Z","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/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","latest_check":{"id":"228f672c-3ef7-4a33-b3c1-fa5a9079dc8e","entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","status":"VERIFIED","last_checked_at":"2026-09-06T09:12:45.445Z","p50_latency_ms":2019,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-24T19:29:23.428Z","updated_at":"2026-09-06T09:12:45.445Z","consecutive_successes":15,"probe_url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-09-06T09:12:45.445Z"},"data_profile":{"id":"e172bcd3-fd7a-4303-bb88-82c3a93872ff","entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"fed-comptes-consolides-des-communes-2012-2020","fields":[{"name":"exer","type":"date","label":"Exercice","fill_pct":100,"filterable":true,"description":"Exercice budgétaire","description_en":"Budget year of the record."},{"name":"outre_mer","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Appartenance de la collectivité à l'outre-mer : oui/non","description_en":"Whether the municipality is located overseas (yes/no)."},{"name":"reg_code","type":"text","label":"Code Insee 2025 Région","fill_pct":100,"filterable":true,"description":"Numéro Insee 2025 de la région ou assimilé","description_en":"2025 INSEE code of the region."},{"name":"reg_name","type":"text","label":"Nom 2025 Région","fill_pct":100,"filterable":true,"description":"Nom 2025 de la région ou assimilé","description_en":"2025 name of the region."},{"name":"dep_code","type":"text","label":"Code Insee 2025 Département","fill_pct":100,"filterable":true,"description":"Numéro Insee 2025 du département ou assimilé","description_en":"2025 INSEE code of the department."},{"name":"dep_name","type":"text","label":"Nom 2025 Département","fill_pct":100,"filterable":true,"description":"Nom 2025 du département ou assimilé","description_en":"2025 name of the department."},{"name":"epci_code","type":"text","label":"Code Siren 2025 EPCI","fill_pct":100,"filterable":true,"description":"Numéro Siren 2025 du groupement à fiscalité propre ou de l’établissement public territorial (EPT)","description_en":"2025 SIREN code of the inter-municipal grouping (EPCI/EPT)."},{"name":"epci_name","type":"text","label":"Nom 2025 EPCI","fill_pct":100,"filterable":true,"description":"Nom 2025 du groupement à fiscalité propre ou de l’établissement public territorial (EPT)","description_en":"2025 name of the inter-municipal grouping (EPCI/EPT)."},{"name":"tranche_population","type":"text","label":"Strate population 2025","fill_pct":100,"filterable":true,"description":"Strate de population au 1er janvier 2025 codée (0 si < 100 hab ; 1 si >= 100 hab et < 200 hab ; 2 si >= 200 hab et < 500 hab ; 3 si >= 500 hab et < 2 000 hab ; 4 si >= 2 000 hab et < 3 500 hab ; 5 si >= 3 500 hab et < 5 000 hab ; 6 si >= 5 000 hab et < 10 000 hab ; 7 si >= 10 000 hab et < 20 000 hab ; 8 si >= 20 000 hab et < 50 000 hab ; 9 si >= 50 000 hab et < 100 000 hab ; 10 si >= 100 000 hab)","description_en":"Coded population bracket as of 1 January 2025."},{"name":"rural","type":"text","label":"Commune rurale","fill_pct":100,"filterable":true,"description":"Commune classée comme rural : oui/non","description_en":"Whether the municipality is classified as rural (yes/no)."},{"name":"montagne","type":"text","label":"Commune de montagne","fill_pct":100,"filterable":true,"description":"Commune classée comme montagne : oui/non","description_en":"Whether the municipality is classified as mountain area (yes/no)."},{"name":"touristique","type":"text","label":"Commune touristique","fill_pct":100,"filterable":true,"description":"Commune classée comme touristique : oui/non","description_en":"Whether the municipality is classified as touristic (yes/no)."},{"name":"tranche_revenu_imposable_par_habitant","type":"text","label":"Tranche revenu par habitant","fill_pct":100,"filterable":true,"description":"Tranche de revenu imposable par habitant codée (0 si < 10 000€ ; 1 si >= 10 000€ et < 15 000€ ; 2 si >= 15 000€ et < 20 000 ; 3 si >= 20 000€ et < 25 000€ ; 4 si >= 25 000€ et < 30 000€ ; 5 si >= 30 000€)","description_en":"Coded bracket of taxable income per inhabitant."},{"name":"qpv","type":"text","label":"Présence QPV","fill_pct":100,"filterable":true,"description":"Présence de quartiers prioritaires de la ville : oui/non","description_en":"Whether the municipality contains priority urban areas (QPV, yes/no)."},{"name":"com_code","type":"text","label":"Code Insee 2025 Commune","fill_pct":100,"filterable":true,"description":"Numéro Insee 2025 de la commune","description_en":"2025 INSEE code of the municipality."},{"name":"com_name","type":"text","label":"Nom 2025 Commune","fill_pct":100,"filterable":true,"description":"Nom 2025 de la commune","description_en":"2025 name of the municipality."},{"name":"categ","type":"text","label":"Catégorie","fill_pct":100,"filterable":true,"description":"Catégorie de collectivité : Commune pour commune, PARIS pour la ville de Paris","description_en":"Category of local authority: municipality or Paris."},{"name":"siren","type":"text","label":"Code Siren Collectivité","fill_pct":100,"filterable":true,"description":"Numéro Siren de la commune","description_en":"SIREN number of the municipality."},{"name":"insee","type":"text","label":"Code Insee Collectivité","fill_pct":100,"filterable":true,"description":"Code Insee de la commune","description_en":"INSEE code of the municipality."},{"name":"lbudg","type":"text","label":"Libellé Budget","fill_pct":100,"filterable":true,"description":"Nom de la collectivité sur l'exercice","description_en":"Name of the local authority for the given fiscal year."},{"name":"agregat","type":"text","label":"Agrégat","fill_pct":100,"filterable":true,"description":"Nom de l'agrégat financier","description_en":"Name of the financial aggregate."},{"name":"montant_bp","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat pour le budget principal","description_en":"Value of the aggregate for the main budget."},{"name":"montant_ba","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat pour les éventuels budgets annexes","description_en":"Value of the aggregate for any annex budgets."},{"name":"montant_flux","type":"double","label":"Montant flux BP-BA","fill_pct":100,"filterable":true,"description":"Valeur des éventuels flux croisés entre le budget principal et les budgets annexes pour l'agrégat","description_en":"Value of cross-flows between main and annex budgets for the aggregate."},{"name":"montant","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat en € (Montant BP + Montant BA - Montant croisés BP-BA)","description_en":"Total value of the aggregate in euros (main plus annex minus cross-flows)."},{"name":"montant_en_millions","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat en millions d'€","description_en":"Value of the aggregate in millions of euros."},{"name":"ptot","type":"int","label":"Population totale","fill_pct":100,"filterable":true,"description":"Population Insee totale au 1er janvier de l'exercice","description_en":"Total INSEE population as of 1 January of the fiscal year."},{"name":"euros_par_habitant","type":"double","label":"Montant en € par habitant","fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat en € par habitant","description_en":"Value of the aggregate in euros per inhabitant."},{"name":"presence_budget","type":"text","label":"Compte 2025 Disponible","fill_pct":100,"filterable":true,"description":"Disponibilité du budget principal sur 2025 : 1=oui ; 0=non","description_en":"Whether the main budget data is available for 2025 (1=yes, 0=no)."},{"name":"ordre_analyse1_section1","type":"text","label":null,"fill_pct":10.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse1_section2","type":"text","label":null,"fill_pct":10.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse1_section3","type":"text","label":null,"fill_pct":6.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse2_section1","type":"text","label":null,"fill_pct":12.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse2_section2","type":"text","label":null,"fill_pct":12.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse2_section3","type":"text","label":null,"fill_pct":6.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse3_section1","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse3_section2","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse3_section3","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"ordre_analyse4_section1","type":"text","label":null,"fill_pct":4.1,"filterable":true,"description":"Variable interne OFGL pour data visualisation","description_en":"Internal OFGL variable used for data visualization."},{"name":"annee_join","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Year value used to join with related datasets."},{"name":"ptot_n","type":"int","label":"Population totale du dernier exercice","fill_pct":100,"filterable":true,"description":"Population Insee totale au 1er janvier du dernier exercice","description_en":"Total INSEE population as of 1 January of the latest fiscal year."}],"field_count":41,"sample_records":[{"qpv":"Non","exer":"2022","ptot":6134,"categ":"Commune","insee":"83120","lbudg":"SAINT-ZACHARIE","rural":"Non","siren":"218301208","ptot_n":5949,"agregat":"Dépenses totales hors remb","montant":6574136.9,"com_code":"83120","com_name":"Saint-Zacharie","dep_code":"83","dep_name":"Var","montagne":"Non","reg_code":"93","reg_name":"Provence-Alpes-Côte d'Azur","epci_code":"200054807","epci_name":"Métropole d'Aix-Marseille-Provence","outre_mer":"Non","annee_join":"2022","montant_ba":18486.69,"montant_bp":6563980.21,"touristique":"Non","montant_flux":8330,"presence_budget":"1","euros_par_habitant":1071.7536517769809,"tranche_population":"6","montant_en_millions":6.5741369,"ordre_analyse1_section1":null,"ordre_analyse1_section2":"3","ordre_analyse1_section3":null,"ordre_analyse2_section1":null,"ordre_analyse2_section2":null,"ordre_analyse2_section3":null,"ordre_analyse3_section1":null,"ordre_analyse3_section2":null,"ordre_analyse3_section3":null,"ordre_analyse4_section1":null,"tranche_revenu_imposable_par_habitant":"2"},{"qpv":"Oui","exer":"2022","ptot":20866,"categ":"Commune","insee":"84089","lbudg":"PERTUIS","rural":"Non","siren":"218400893","ptot_n":20032,"agregat":"Dépenses totales hors remb","montant":34810466.79,"com_code":"84089","com_name":"Pertuis","dep_code":"84","dep_name":"Vaucluse","montagne":"Non","reg_code":"93","reg_name":"Provence-Alpes-Côte d'Azur","epci_code":"200054807","epci_name":"Métropole d'Aix-Marseille-Provence","outre_mer":"Non","annee_join":"2022","montant_ba":0,"montant_bp":34810466.79,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":1668.2865326368253,"tranche_population":"8","montant_en_millions":34.81046679,"ordre_analyse1_section1":null,"ordre_analyse1_section2":"3","ordre_analyse1_section3":null,"ordre_analyse2_section1":null,"ordre_analyse2_section2":null,"ordre_analyse2_section3":null,"ordre_analyse3_section1":null,"ordre_analyse3_section2":null,"ordre_analyse3_section3":null,"ordre_analyse4_section1":null,"tranche_revenu_imposable_par_habitant":"2"},{"qpv":"Oui","exer":"2022","ptot":148336,"categ":"Commune","insee":"13001","lbudg":"AIX-EN-PROVENCE","rural":"Non","siren":"211300017","ptot_n":151033,"agregat":"Epargne brute","montant":23119838.62,"com_code":"13001","com_name":"Aix-en-Provence","dep_code":"13","dep_name":"Bouches-du-Rhône","montagne":"Non","reg_code":"93","reg_name":"Provence-Alpes-Côte d'Azur","epci_code":"200054807","epci_name":"Métropole d'Aix-Marseille-Provence","outre_mer":"Non","annee_join":"2022","montant_ba":0,"montant_bp":23119838.62,"touristique":"Oui","montant_flux":0,"presence_budget":"1","euros_par_habitant":155.8612785837558,"tranche_population":"10","montant_en_millions":23.11983862,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"ordre_analyse1_section3":null,"ordre_analyse2_section1":null,"ordre_analyse2_section2":null,"ordre_analyse2_section3":"3","ordre_analyse3_section1":null,"ordre_analyse3_section2":null,"ordre_analyse3_section3":null,"ordre_analyse4_section1":null,"tranche_revenu_imposable_par_habitant":"3"},{"qpv":"Non","exer":"2022","ptot":21597,"categ":"Commune","insee":"13002","lbudg":"ALLAUCH","rural":"Non","siren":"211300025","ptot_n":21616,"agregat":"Epargne brute","montant":3790397.87,"com_code":"13002","com_name":"Allauch","dep_code":"13","dep_name":"Bouches-du-Rhône","montagne":"Non","reg_code":"93","reg_name":"Provence-Alpes-Côte d'Azur","epci_code":"200054807","epci_name":"Métropole d'Aix-Marseille-Provence","outre_mer":"Non","annee_join":"2022","montant_ba":0,"montant_bp":3790397.87,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":175.50575867018568,"tranche_population":"8","montant_en_millions":3.79039787,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"ordre_analyse1_section3":null,"ordre_analyse2_section1":null,"ordre_analyse2_section2":null,"ordre_analyse2_section3":"3","ordre_analyse3_section1":null,"ordre_analyse3_section2":null,"ordre_analyse3_section3":null,"ordre_analyse4_section1":null,"tranche_revenu_imposable_par_habitant":"3"},{"qpv":"Non","exer":"2022","ptot":2680,"categ":"Commune","insee":"13003","lbudg":"ALLEINS","rural":"Non","siren":"211300033","ptot_n":2903,"agregat":"Epargne brute","montant":259813.35,"com_code":"13003","com_name":"Alleins","dep_code":"13","dep_name":"Bouches-du-Rhône","montagne":"Non","reg_code":"93","reg_name":"Provence-Alpes-Côte d'Azur","epci_code":"200054807","epci_name":"Métropole d'Aix-Marseille-Provence","outre_mer":"Non","annee_join":"2022","montant_ba":0,"montant_bp":259813.35,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":96.94527985074627,"tranche_population":"4","montant_en_millions":0.25981335,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"ordre_analyse1_section3":null,"ordre_analyse2_section1":null,"ordre_analyse2_section2":null,"ordre_analyse2_section3":"3","ordre_analyse3_section1":null,"ordre_analyse3_section2":null,"ordre_analyse3_section3":null,"ordre_analyse4_section1":null,"tranche_revenu_imposable_par_habitant":"2"}],"record_count":"35746","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?limit=20","curl":"curl -s 'https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?select=exer%2Coutre_mer%2Creg_code&where=outre_mer+is+not+null&limit=20","curl":"curl -s 'https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/records?select=exer%2Coutre_mer%2Creg_code&where=outre_mer+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (exer, outre_mer, reg_code) and filter with ODSQL where clauses."},{"url":"https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/exports/csv","curl":"curl -sL 'https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020/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-01T16:46:37.685Z","run_id":"1ab11f03-824c-4991-a1fa-1eaaa6e07072","created_at":"2026-07-24T19:25:10.549Z","updated_at":"2026-09-01T16:46:37.685Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.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":["tranche_population","montant_bp","montant_ba","montant_flux","montant","montant_en_millions"],"entity_identifiers":["siren"]},"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":"f3c1ebcf-58e6-4532-af8e-d8cdd2a9b5c4","entry_id":"6a68c587-53dc-4b6f-8328-550554b7c1b7","limit_type":"requests_per_day","value":"100000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-09-01T16:46:39.417Z"}],"source_access":{"status":"accessed_despite_disallow","host":"data.ampmetropole.fr","requested_path_prefix":"/api/explore/v2.1/","robots_url":"https://data.ampmetropole.fr/robots.txt","user_agent_group":"*","robots_rule":"Disallow: /api/","robots_read_at":"2026-08-25T11:29:21.471Z","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":"92cdaa9ea5d3036059b1c632133a1fdda4a71e9a928ebe1b0013dfac654bbb8b","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":62,"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[] (41 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-07T23:44:04.377Z","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."}}