Budgets

Name: Budgets
Creator: Saint Denis de Pile
License: https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf

DatasetJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset publishes budgetary and financial deliberations adopted by the local authority of Saint Denis de Pile, France, in open-data format, complementing the legal obligation to transmit such documents for legality review and public disclosure under the General Code of Territorial Communities. It aims to improve transparency of public financial decisions taken by local governing bodies. The data is structured according to the Common Pillar of Local Data (Socle Commun des Données Locales), a shared schema used across French local authorities to standardize open data on deliberations, budgets, and related administrative acts.In addition to the legal obligations to transmit to the legality and publicity of the budgetary and financial documents of the local authorities defined in the General Code of Territorial Communities, the provision in Open Data of data relating to deliberations of type budgetary and financial documents adopted by a local authority must make it possible to improve the transparency of public decisions taken by the various authorised bodies at any territorial level. The data is structured according to the Common Pillar of Local Data ([see detail on this page](https://scdl.opendatafrance.net/docs-next/schemas/deliberations.html)).

public-financegovernmentlegislation

⬇ Download CSV Download OPEN DATA GIRONDE NUMÉRIQUE Open source page Open source record

Trust score

How is this computed?

good

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

Data schema (17 fields)

Click a field to see example values.

Field	Type	Description
COLL_NOMColl nom	text	Name of the local authority (collectivité).Name of the local authority (collectivité).
COLL_SIRETColl siret	int	SIRET identification number of the local authority.SIRET identification number of the local authority.
DELIB_IDDelib id	text	Unique identifier of the deliberation.Unique identifier of the deliberation.
DELIB_DATEDelib date	text	Date the deliberation was adopted.Date the deliberation was adopted.
DELIB_MATIERE_CODEDelib matiere code	text	Code classifying the subject matter of the deliberation.Code classifying the subject matter of the deliberation.
DELIB_MATIERE_NOMDelib matiere nom	text	Name of the subject matter category of the deliberation.Name of the subject matter category of the deliberation.
DELIB_OBJETDelib objet	text	Subject or title of the deliberation.Subject or title of the deliberation.
BUDGET_ANNEEBudget annee	text	Fiscal year of the budget.Fiscal year of the budget.
BUDGET_NOMBudget nom	text	Name of the budget concerned.Name of the budget concerned.
PREF_IDPref id	text	Identifier assigned by the prefecture to the deliberation.Identifier assigned by the prefecture to the deliberation.
PREF_DATEPref date	text	Date the deliberation was transmitted to the prefecture.Date the deliberation was transmitted to the prefecture.
VOTE_EFFECTIFVote effectif	text	Total number of council members entitled to vote.Total number of council members entitled to vote.
VOTE_REELVote reel	text	Number of members who actually took part in the vote.Number of members who actually took part in the vote.
VOTE_POURVote pour	text	Number of votes in favor.Number of votes in favor.
VOTE_CONTREVote contre	text	Number of votes against.Number of votes against.
VOTE_ABSTENTIONVote abstention	text	Number of abstentions.Number of abstentions.
DELIB_URLDelib url	text	Web link to the published deliberation document.Web link to the published deliberation document.

Schema inferred from the distribution file's first records 22 days ago. Column types are sampled estimates, not source-declared.

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 1PREF_ID: · COLL_NOM: COMMUNE DE SAINT DENIS DE PILE

{
  "PREF_ID": "",
  "COLL_NOM": "COMMUNE DE SAINT DENIS DE PILE",
  "DELIB_ID": "15_04_24",
  "DELIB_URL": "http://data.mairie-saintdenisdepile.fr/OpenData/4_Finances_locales/2024/15_affectation_des_resultats_2023_budget_mairie_20_20240606103325197949.pdf",
  "PREF_DATE": "",
  "VOTE_POUR": "",
  "VOTE_REEL": "",
  "BUDGET_NOM": "",
  "COLL_SIRET": "21330393600016",
  "DELIB_DATE": "31/03/2024",
  "DELIB_OBJET": "15. Affectation résultat mairie",
  "VOTE_CONTRE": "",
  "BUDGET_ANNEE": "",
  "VOTE_EFFECTIF": "",
  "VOTE_ABSTENTION": "",
  "DELIB_MATIERE_NOM": "délibérations afférentes aux documents budgétaires (BP, DM, CA, affectation de résultats, approbation du compte de gestion)",
  "DELIB_MATIERE_CODE": "7.1.2"
}

Record 2PREF_ID: · COLL_NOM: COMMUNE DE SAINT DENIS DE PILE

{
  "PREF_ID": "",
  "COLL_NOM": "COMMUNE DE SAINT DENIS DE PILE",
  "DELIB_ID": "11_04_24",
  "DELIB_URL": "http://data.mairie-saintdenisdepile.fr/OpenData/4_Finances_locales/2024/11_affectation_des_resultats_2023_budget_transport_20240606103327225843.pdf",
  "PREF_DATE": "",
  "VOTE_POUR": "",
  "VOTE_REEL": "",
  "BUDGET_NOM": "",
  "COLL_SIRET": "21330393600016",
  "DELIB_DATE": "31/03/2024",
  "DELIB_OBJET": "11. Affectation résultat TS",
  "VOTE_CONTRE": "",
  "BUDGET_ANNEE": "",
  "VOTE_EFFECTIF": "",
  "VOTE_ABSTENTION": "",
  "DELIB_MATIERE_NOM": "délibérations afférentes aux documents budgétaires (BP, DM, CA, affectation de résultats, approbation du compte de gestion)",
  "DELIB_MATIERE_CODE": "7.1.2"
}

Record 3PREF_ID: · COLL_NOM: COMMUNE DE SAINT DENIS DE PILE

{
  "PREF_ID": "",
  "COLL_NOM": "COMMUNE DE SAINT DENIS DE PILE",
  "DELIB_ID": "8_04_2022",
  "DELIB_URL": "http://data.mairie-saintdenisdepile.fr/OpenData/4_Finances_locales/2022/8_compte_adm_2021_transport_2022_tampon_20220518132618545660.pdf",
  "PREF_DATE": "",
  "VOTE_POUR": "",
  "VOTE_REEL": "",
  "BUDGET_NOM": "",
  "COLL_SIRET": "21330393600107",
  "DELIB_DATE": "01/04/2022",
  "DELIB_OBJET": "8-Compte administratif 2021 budget annexe transport scolaire (39350)",
  "VOTE_CONTRE": "",
  "BUDGET_ANNEE": "",
  "VOTE_EFFECTIF": "",
  "VOTE_ABSTENTION": "",
  "DELIB_MATIERE_NOM": "délibérations afférentes aux documents budgétaires (BP, DM, CA, affectation de résultats, approbation du compte de gestion)",
  "DELIB_MATIERE_CODE": "7.1.2"
}

Record 4PREF_ID: · COLL_NOM: COMMUNE DE SAINT DENIS DE PILE

{
  "PREF_ID": "",
  "COLL_NOM": "COMMUNE DE SAINT DENIS DE PILE",
  "DELIB_ID": "9_04_2022",
  "DELIB_URL": "http://data.mairie-saintdenisdepile.fr/OpenData/4_Finances_locales/2022/9_compte_adm_2021_mairie_tampon_20220518132636757337.pdf",
  "PREF_DATE": "",
  "VOTE_POUR": "",
  "VOTE_REEL": "",
  "BUDGET_NOM": "",
  "COLL_SIRET": "21330393600107",
  "DELIB_DATE": "01/04/2022",
  "DELIB_OBJET": "9- Compte administratif 2021 budget principal de la Commune (39300)",
  "VOTE_CONTRE": "",
  "BUDGET_ANNEE": "",
  "VOTE_EFFECTIF": "",
  "VOTE_ABSTENTION": "",
  "DELIB_MATIERE_NOM": "délibérations afférentes aux documents budgétaires (BP, DM, CA, affectation de résultats, approbation du compte de gestion)",
  "DELIB_MATIERE_CODE": "7.1.2"
}

Record 5PREF_ID: · COLL_NOM: COMMUNE DE SAINT DENIS DE PILE

{
  "PREF_ID": "",
  "COLL_NOM": "COMMUNE DE SAINT DENIS DE PILE",
  "DELIB_ID": "7_04_2022",
  "DELIB_URL": "http://data.mairie-saintdenisdepile.fr/OpenData/4_Finances_locales/2022/7_compte_de_gestion_commune_2021_2022_tampon_20220518132559183993.pdf",
  "PREF_DATE": "",
  "VOTE_POUR": "",
  "VOTE_REEL": "",
  "BUDGET_NOM": "",
  "COLL_SIRET": "21330393600107",
  "DELIB_DATE": "01/04/2022",
  "DELIB_OBJET": "7-Compte de gestion 2021 Budget Principal de la Commune (39300)",
  "VOTE_CONTRE": "",
  "BUDGET_ANNEE": "",
  "VOTE_EFFECTIF": "",
  "VOTE_ABSTENTION": "",
  "DELIB_MATIERE_NOM": "délibérations afférentes aux documents budgétaires (BP, DM, CA, affectation de résultats, approbation du compte de gestion)",
  "DELIB_MATIERE_CODE": "7.1.2"
}

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

Verification Status

Using the API

Query examples

curl -sL 'https://api-opendata.girondenumerique.fr/datasets/213303936/budgets.csv' -o data.csv

Full csv file download — the schema shown was inferred from the file's first records.

Dataset

Volume & freshness

Data size

11 KB

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required
Category: national

✓ Documentation○ Data dictionary○ Versioning

Distributions (2)

CSV

https://api-opendata.girondenumerique.fr/datasets/213303936/budgets.csv Source page

CSV●

Open Data Gironde Digital REST API

https://api-opendata.girondenumerique.fr/datasets/213303936/budgets.json Source page

open data gironde numérique

Machine-readable & source

JSON GitHub

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