Consolidated municipal accounts since 2016Comptes consolidés des communes depuis 2016

Name: Consolidated municipal accounts since 2016
Creator: opendatasoft

Comptes consolidés des communes depuis 2016Consolidated municipal accounts since 2016

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

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.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...

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (41 fields)

Filterable via the API (41)

exeroutre_merreg_codereg_namedep_codedep_nameepci_codeepci_nametranche_populationruralmontagnetouristiquetranche_revenu_imposable_par_habitantqpvcom_codecom_namecategsireninseelbudgagregatmontant_bpmontant_bamontant_fluxmontantmontant_en_millionsptoteuros_par_habitantpresence_budgetordre_analyse1_section1ordre_analyse1_section2ordre_analyse1_section3ordre_analyse2_section1ordre_analyse2_section2ordre_analyse2_section3ordre_analyse3_section1ordre_analyse3_section2ordre_analyse3_section3ordre_analyse4_section1annee_joinptot_n

Click a field to see example values.

Fill	Field	Type	Description
100%	exerExercice	date	Budget year of the record.Exercice budgétaire
100%	outre_merOutre mer	text	Whether the municipality is located overseas (yes/no).Appartenance de la collectivité à l'outre-mer : oui/non
100%	reg_codeCode Insee 2025 Région	text	2025 INSEE code of the region.Numéro Insee 2025 de la région ou assimilé
100%	reg_nameNom 2025 Région	text	2025 name of the region.Nom 2025 de la région ou assimilé
100%	dep_codeCode Insee 2025 Département	text	2025 INSEE code of the department.Numéro Insee 2025 du département ou assimilé
100%	dep_nameNom 2025 Département	text	2025 name of the department.Nom 2025 du département ou assimilé
100%	epci_codeCode Siren 2025 EPCI	text	2025 SIREN code of the inter-municipal grouping (EPCI/EPT).Numéro Siren 2025 du groupement à fiscalité propre ou de l’établissement public territorial (EPT)
100%	epci_nameNom 2025 EPCI	text	2025 name of the inter-municipal grouping (EPCI/EPT).Nom 2025 du groupement à fiscalité propre ou de l’établissement public territorial (EPT)
100%	tranche_populationStrate population 2025	text	Coded population bracket as of 1 January 2025.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)
100%	ruralCommune rurale	text	Whether the municipality is classified as rural (yes/no).Commune classée comme rural : oui/non
100%	montagneCommune de montagne	text	Whether the municipality is classified as mountain area (yes/no).Commune classée comme montagne : oui/non
100%	touristiqueCommune touristique	text	Whether the municipality is classified as touristic (yes/no).Commune classée comme touristique : oui/non
100%	tranche_revenu_imposable_par_habitantTranche revenu par habitant	text	Coded bracket of taxable income per inhabitant.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€)
100%	qpvPrésence QPV	text	Whether the municipality contains priority urban areas (QPV, yes/no).Présence de quartiers prioritaires de la ville : oui/non
100%	com_codeCode Insee 2025 Commune	text	2025 INSEE code of the municipality.Numéro Insee 2025 de la commune
100%	com_nameNom 2025 Commune	text	2025 name of the municipality.Nom 2025 de la commune
100%	categCatégorie	text	Category of local authority: municipality or Paris.Catégorie de collectivité : Commune pour commune, PARIS pour la ville de Paris
100%	sirenCode Siren Collectivité	text	SIREN number of the municipality.Numéro Siren de la commune
100%	inseeCode Insee Collectivité	text	INSEE code of the municipality.Code Insee de la commune
100%	lbudgLibellé Budget	text	Name of the local authority for the given fiscal year.Nom de la collectivité sur l'exercice
100%	agregatAgrégat	text	Name of the financial aggregate.Nom de l'agrégat financier
100%	montant_bpMontant bp	double	Value of the aggregate for the main budget.Valeur de l'agrégat pour le budget principal
100%	montant_baMontant ba	double	Value of the aggregate for any annex budgets.Valeur de l'agrégat pour les éventuels budgets annexes
100%	montant_fluxMontant flux BP-BA	double	Value of cross-flows between main and annex budgets for the aggregate.Valeur des éventuels flux croisés entre le budget principal et les budgets annexes pour l'agrégat
100%	montant	double	Total value of the aggregate in euros (main plus annex minus cross-flows).Valeur de l'agrégat en € (Montant BP + Montant BA - Montant croisés BP-BA)
100%	montant_en_millionsMontant en millions	double	Value of the aggregate in millions of euros.Valeur de l'agrégat en millions d'€
100%	ptotPopulation totale	int	Total INSEE population as of 1 January of the fiscal year.Population Insee totale au 1er janvier de l'exercice
100%	euros_par_habitantMontant en € par habitant	double	Value of the aggregate in euros per inhabitant.Valeur de l'agrégat en € par habitant
100%	presence_budgetCompte 2025 Disponible	text	Whether the main budget data is available for 2025 (1=yes, 0=no).Disponibilité du budget principal sur 2025 : 1=oui ; 0=non
10.3%	ordre_analyse1_section1Ordre analyse1 section1	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
10.3%	ordre_analyse1_section2Ordre analyse1 section2	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
6.2%	ordre_analyse1_section3Ordre analyse1 section3	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
12.3%	ordre_analyse2_section1Ordre analyse2 section1	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
12.3%	ordre_analyse2_section2Ordre analyse2 section2	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
6.2%	ordre_analyse2_section3Ordre analyse2 section3	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
8.2%	ordre_analyse3_section1Ordre analyse3 section1	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
8.2%	ordre_analyse3_section2Ordre analyse3 section2	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
8.2%	ordre_analyse3_section3Ordre analyse3 section3	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
4.1%	ordre_analyse4_section1Ordre analyse4 section1	text	Internal OFGL variable used for data visualization.Variable interne OFGL pour data visualisation
100%	annee_joinAnnee join	text	Year value used to join with related datasets.Year value used to join with related datasets.
100%	ptot_nPopulation totale du dernier exercice	int	Total INSEE population as of 1 January of the latest fiscal year.Population Insee totale au 1er janvier du dernier exercice

Schema captured from opendatasoft 6 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1qpv: Non · exer: 2022

{
  "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"
}

Record 2qpv: Oui · exer: 2022

{
  "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"
}

Record 3qpv: Oui · exer: 2022

{
  "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"
}

Record 4qpv: Non · exer: 2022

{
  "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"
}

Record 5qpv: Non · exer: 2022

{
  "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"
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://data.ampmetropole.fr/api/explore/v2.1/catalog/datasets/fed-comptes-consolides-des-communes-2012-2020

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

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'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

100 000 req/day

per ipmeasured

observed 6 days ago

Dataset

Volume & freshness

Records

36k

35746

Last upstream update

1 month ago

2026-08-08

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.