Register record·API·FRSTALE · checked 4d ago

B

2017 Initial Budget of the City of BordeauxBudget primitif 2017 de la ville de Bordeaux

Budget primitif 2017 de la ville de Bordeaux2017 Initial Budget of the City of Bordeaux

APIDiscovered1/7blocked by verifiedQuery nowOpen workbench Subscribe🇫🇷France

This API provides access to the initial budget ('budget primitif') of the city of Bordeaux for the year 2017, published by Bordeaux Métropole as part of its open data portal. It details the credits voted in the initial budget, broken down by nature at the chapter level. The dataset is freely accessible without authentication and covers France at national scope. It is useful for analyzing municipal budget allocations and public finance transparency for Bordeaux.Crédits votés au budget primitif par nature au niveau des chapitres.

public-finance

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

Data schema (22 fields)

Filterable via the API (22)

naturefonctioncontnatartspecodrdmtbudgprecmtrarprecmtpropnouvmtprevcredouvmtrealmtrar3112opbudgmtsupcaracsup_chapspecaracsup_progautolibcaracsup_progautonumnormelibelle_nature_cptelibelle_nature_chaplibelle_ref_foncannee

Click a field to see example values.

Fill	Field	Type	Description
100%	natureCode Nature	text	Budget account nature code.Budget account nature code.
100%	fonctionCode Fonction	text	Budget function code.Budget function code.
99.8%	contnatCode ContNat	text	Nature/control account code (comptabilité M57).Nature/control account code (comptabilité M57).
100%	artspeArticle Spécialisé	text	Indicates whether the article is specialized or not.Indicates whether the article is specialized or not.
100%	codrdRecette/Dépense	text	Indicates whether the line is a revenue or an expense.Indicates whether the line is a revenue or an expense.
100%	mtbudgprecMontant Budget précédent	double	Amount from the previous budget for this line.Amount from the previous budget for this line.
100%	mtrarprecMontant reste à réaliser N-1	double	Amount carried over to be realized from the previous year.Cette balise est servie au BP/BS/DM uniquement en cas de reprise des résultats de l’exercice précédent. Cette balise est servie au CA pour présenter les restes à réaliser de l’exercice précédent.
100%	mtpropnouvMontant "Propositions Nouvelles"	double	Amount of new budget proposals for this line.Amount of new budget proposals for this line.
100%	mtprevMontant budget voté	double	Amount approved in the voted budget.Amount approved in the voted budget.
100%	credouvCrédits ouverts à l'article	double	Total appropriations opened for the article.Total appropriations opened for the article.
100%	mtrealMontant signé	double	Signed amount of actual budget execution.Montant signé des réalisations budgétaires
100%	mtrar3112Montant reste à réaliser de l'exercice	double	Amount still to be realized at year end for the current year.Cette balise est servie au CA. Cette balise peut également être utilisé au BP/BS/DM pour présenter les informations du CA N-1 (présence des vues « Exécution du budget de l’exercice précédent »).
100%	opbudgOpération budgétaire	text	Type of budget operation (real or mixed).Type of budget operation (real or mixed).
100%	mtsup	text	Additional budget amounts detail, including budget excluding carryovers and prior carryovers.Additional budget amounts detail, including budget excluding carryovers and prior carryovers.
0%	caracsup_chapspeCaracsup chapspe	text	Indicates whether the chapter is specialized.Indicates whether the chapter is specialized.
0%	caracsup_progautolibCaracsup progautolib	text	Label of the associated autonomous program, if any.Label of the associated autonomous program, if any.
0%	caracsup_progautonumCaracsup progautonum	text	Number of the associated autonomous program, if any.Number of the associated autonomous program, if any.
100%	norme	text	Accounting standard/framework applied (e.g. M57).Accounting standard/framework applied (e.g. M57).
96.3%	libelle_nature_cpteLibellé Nature Compte	text	Label describing the account nature.Label describing the account nature.
99.1%	libelle_nature_chapLibellé Nature Chapitre	text	Label describing the chapter nature.Label describing the chapter nature.
84.7%	libelle_ref_foncLibellé référence	text	Label describing the functional reference.Label describing the functional reference.
100%	annee	text	Budget year of the record.Budget year of the record.

Schema captured from opendatasoft 1 day 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 1annee: 2017 · codrd: Recette

{
  "annee": "2017",
  "codrd": "Recette",
  "mtsup": "{\"BudgetHorsRAR\" :  \"0.00\",\"RARPrec\" :  \"0.00\"}",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 3180,
  "mtreal": 372142,
  "nature": "7478",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "74",
  "credouv": 371942,
  "fonction": "311",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 3180,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Activités artistiques, actions et manifestations culturelles",
  "libelle_nature_chap": "Dotations et participations",
  "libelle_nature_cpte": "Autres organismes",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 2annee: 2017 · codrd: Dépense

{
  "annee": "2017",
  "codrd": "Dépense",
  "mtsup": "{\"BudgetHorsRAR\" :  \"0.00\",\"RARPrec\" :  \"0.00\"}",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 0,
  "nature": "2135",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "21",
  "credouv": 1845,
  "fonction": "833",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Fret fluvial",
  "libelle_nature_chap": "Virement de la section de fonctionnement",
  "libelle_nature_cpte": "Installations générales, agencements, aménagements des constructions",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 3annee: 2017 · codrd: Dépense

{
  "annee": "2017",
  "codrd": "Dépense",
  "mtsup": "{\"BudgetHorsRAR\" :  \"1022121.00\",\"RARPrec\" :  \"0.00\"}",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 479990,
  "mtreal": 142770.56,
  "nature": "6288",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 296950,
  "fonction": "020",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 1022121,
  "mtpropnouv": 479990,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Administration générale de la collectivité",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Autres",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 4annee: 2017 · codrd: Dépense

{
  "annee": "2017",
  "codrd": "Dépense",
  "mtsup": "{\"BudgetHorsRAR\" :  \"0.00\",\"RARPrec\" :  \"0.00\"}",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 64.51,
  "nature": "2138",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "21",
  "credouv": 139068.16,
  "fonction": "311",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Activités artistiques, actions et manifestations culturelles",
  "libelle_nature_chap": "Virement de la section de fonctionnement",
  "libelle_nature_cpte": "Autres constructions",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 5annee: 2017 · codrd: Dépense

{
  "annee": "2017",
  "codrd": "Dépense",
  "mtsup": "{\"BudgetHorsRAR\" :  \"1994.45\",\"RARPrec\" :  \"0.00\"}",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 1843.83,
  "nature": "6454",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "012",
  "credouv": 0,
  "fonction": "520",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 1994.45,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": null,
  "libelle_nature_chap": "Charges de personnel et frais assimilés",
  "libelle_nature_cpte": "Cotisations aux A.S.S.E.D.I.C.",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

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

Verification Status

Using the API

Configuration

Base URL: https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_budgetprimitif_2017

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_budgetprimitif_2017/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

50 000 req/day

per ipmeasured

observed 1 day ago

Dataset

Volume & freshness

Records

2.6k

2639

Last upstream update

4 years ago

2023-05-23

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.

2017 Initial Budget of the City of BordeauxBudget primitif 2017 de la ville de Bordeaux

Trust score

Data schema (22 fields)

Query the data

Sample data (5 records)

Verification Status

Using the API

Configuration

License

Query examples

Rate limits

Dataset

Volume & freshness

License

Machine-readable & source