{"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-07-24T19:34:44.017Z","last_verified_at":"2026-07-24T19:29:24.080Z","deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'-2023':18B,37B,71B,90B '2012':17B,36B,70B,89B '2016':6A,59A 'a':95B 'agregats':75B,94B 'agrégat':22B,41B 'annex':30B 'annexes':83B 'budget':26B,29B 'budgets':79B,82B 'calcul':39B,92B 'commune':4A,16B,32B 'communes':57A,69B,85B 'compt':1A,13B,24B 'comptes':54A,66B,77B 'consolides':55A,67B,78B 'consolidé':2A,14B,25B 'de':10B,51B,63B,104B 'depui':5A 'depuis':58A 'des':3A,15B,23B,31B,40B,48B,56A,68B,76B,84B,93B,101B 'donnees':64B 'donné':11B 'du':8B,61B 'et':28B,50B,81B,103B 'ete':96B 'financ':49B 'finances':102B 'ge':53B,106B 'jeu':9B,62B 'l':46B,99B 'la':34B,52B,87B,105B 'le':38B,91B 'les':12B,20B,65B,73B 'observatoir':47B 'observatoire':100B 'par':45B,98B 'periode':88B 'pour':33B,86B 'presentation':60B 'presentent':72B 'principaux':21B,27B,74B,80B 'présentat':7B 'présentent':19B 'périod':35B 'realise':97B 'réalisé':44B 'été':43B","popularity_score":"0.0000","maintenance_score":"0.0000","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":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":50.75,"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"]},"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-07-23T06:25:47.619Z","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-07-24T19:25:11.200Z","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"},"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-07-24T19:29:23.428Z","p50_latency_ms":3177,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-24T19:29:23.428Z","updated_at":"2026-07-24T19:29:23.428Z","consecutive_successes":1,"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-07-24T19:29:23.428Z"},"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"},{"name":"outre_mer","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Appartenance de la collectivité à l'outre-mer : oui/non"},{"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é"},{"name":"reg_name","type":"text","label":"Nom 2025 Région","fill_pct":100,"filterable":true,"description":"Nom 2025 de la région ou assimilé"},{"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é"},{"name":"dep_name","type":"text","label":"Nom 2025 Département","fill_pct":100,"filterable":true,"description":"Nom 2025 du département ou assimilé"},{"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)"},{"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)"},{"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)"},{"name":"rural","type":"text","label":"Commune rurale","fill_pct":100,"filterable":true,"description":"Commune classée comme rural : oui/non"},{"name":"montagne","type":"text","label":"Commune de montagne","fill_pct":100,"filterable":true,"description":"Commune classée comme montagne : oui/non"},{"name":"touristique","type":"text","label":"Commune touristique","fill_pct":100,"filterable":true,"description":"Commune classée comme touristique : oui/non"},{"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€)"},{"name":"qpv","type":"text","label":"Présence QPV","fill_pct":100,"filterable":true,"description":"Présence de quartiers prioritaires de la ville : oui/non"},{"name":"com_code","type":"text","label":"Code Insee 2025 Commune","fill_pct":100,"filterable":true,"description":"Numéro Insee 2025 de la commune"},{"name":"com_name","type":"text","label":"Nom 2025 Commune","fill_pct":100,"filterable":true,"description":"Nom 2025 de la commune"},{"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"},{"name":"siren","type":"text","label":"Code Siren Collectivité","fill_pct":100,"filterable":true,"description":"Numéro Siren de la commune"},{"name":"insee","type":"text","label":"Code Insee Collectivité","fill_pct":100,"filterable":true,"description":"Code Insee de la commune"},{"name":"lbudg","type":"text","label":"Libellé Budget","fill_pct":100,"filterable":true,"description":"Nom de la collectivité sur l'exercice"},{"name":"agregat","type":"text","label":"Agrégat","fill_pct":100,"filterable":true,"description":"Nom de l'agrégat financier"},{"name":"montant_bp","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat pour le budget principal"},{"name":"montant_ba","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat pour les éventuels budgets annexes"},{"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"},{"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)"},{"name":"montant_en_millions","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Valeur de l'agrégat en millions d'€"},{"name":"ptot","type":"int","label":"Population totale","fill_pct":100,"filterable":true,"description":"Population Insee totale au 1er janvier de l'exercice"},{"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"},{"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"},{"name":"ordre_analyse1_section1","type":"text","label":null,"fill_pct":10.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse1_section2","type":"text","label":null,"fill_pct":10.3,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse1_section3","type":"text","label":null,"fill_pct":6.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse2_section1","type":"text","label":null,"fill_pct":12.4,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse2_section2","type":"text","label":null,"fill_pct":12.4,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse2_section3","type":"text","label":null,"fill_pct":6.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse3_section1","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse3_section2","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse3_section3","type":"text","label":null,"fill_pct":8.2,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"ordre_analyse4_section1","type":"text","label":null,"fill_pct":4.1,"filterable":true,"description":"Variable interne OFGL pour data visualisation"},{"name":"annee_join","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"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"}],"field_count":41,"sample_records":[{"qpv":"Non","exer":"2018","ptot":5465,"categ":"Commune","insee":"83120","lbudg":"SAINT-ZACHARIE","rural":"Non","siren":"218301208","ptot_n":5949,"agregat":"Ventes de biens et services","montant":461173.16,"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":"2018","montant_ba":18786.25,"montant_bp":442386.91,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":84.3866715462031,"tranche_population":"6","montant_en_millions":0.46117315999999997,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"ordre_analyse1_section3":null,"ordre_analyse2_section1":"5","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":"5"},{"qpv":"Oui","exer":"2018","ptot":20050,"categ":"Commune","insee":"84089","lbudg":"PERTUIS","rural":"Non","siren":"218400893","ptot_n":20032,"agregat":"Ventes de biens et services","montant":2228782.23,"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":"2018","montant_ba":0,"montant_bp":2228782.23,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":111.16120847880299,"tranche_population":"8","montant_en_millions":2.22878223,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"ordre_analyse1_section3":null,"ordre_analyse2_section1":"5","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":"5"},{"qpv":"Oui","exer":"2018","ptot":146192,"categ":"Commune","insee":"13001","lbudg":"AIX-EN-PROVENCE","rural":"Non","siren":"211300017","ptot_n":151033,"agregat":"Fonds de roulement","montant":11956854.77,"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":"2018","montant_ba":0,"montant_bp":11956854.77,"touristique":"Oui","montant_flux":0,"presence_budget":"1","euros_par_habitant":81.78870779522819,"tranche_population":"10","montant_en_millions":11.95685477,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"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":"5"},{"qpv":"Non","exer":"2018","ptot":21582,"categ":"Commune","insee":"13002","lbudg":"ALLAUCH","rural":"Non","siren":"211300025","ptot_n":21616,"agregat":"Fonds de roulement","montant":4406974.05,"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":"2018","montant_ba":0,"montant_bp":4406974.05,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":204.19674033917153,"tranche_population":"8","montant_en_millions":4.40697405,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"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":"5"},{"qpv":"Non","exer":"2018","ptot":2541,"categ":"Commune","insee":"13003","lbudg":"ALLEINS","rural":"Non","siren":"211300033","ptot_n":2903,"agregat":"Fonds de roulement","montant":444855.51,"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":"2018","montant_ba":0,"montant_bp":444855.51,"touristique":"Non","montant_flux":0,"presence_budget":"1","euros_par_habitant":175.07103896103897,"tranche_population":"4","montant_en_millions":0.44485551,"ordre_analyse1_section1":null,"ordre_analyse1_section2":null,"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":"5"}],"record_count":"31178","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-07-24T19:25:10.549Z","run_id":"5d97f6b3-3cc2-4eeb-923d-5b8b9d285ac5","created_at":"2026-07-24T19:25:10.549Z","updated_at":"2026-07-24T19:25:10.549Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","license_id":"lo-2.0","previewable":true},"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-07-24T19:25:11.359Z"}]}