Register record·API·FRSTALE · checked 3d ago

B

City of Bordeaux 2019 Original BudgetBudget primitif 2019 de la ville de Bordeaux

Budget primitif 2019 de la ville de BordeauxCity of Bordeaux 2019 Original Budget

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

This API provides access to the 2019 original budget (budget primitif) of the City of Bordeaux, published via the Bordeaux Métropole open data portal. It lists appropriations voted at the chapter level, broken down by budgetary nature. The dataset is freely accessible without authentication and can be used to analyze the municipality's planned revenues and expenditures for the fiscal year.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 (21 fields)

Filterable via the API (21)

naturefonctioncontnatartspecodrdmtbudgprecmtrarprecmtpropnouvmtprevcredouvmtrealmtrar3112opbudgcaracsup_chapspecaracsup_progautolibcaracsup_progautonumnormeanneelibelle_nature_cptelibelle_nature_chaplibelle_ref_fonc

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 classification code.Budget function classification code.
99.9%	contnatCode ContNat	text	Chapter-level nature code (M57 chapter grouping).Chapter-level nature code (M57 chapter grouping).
100%	artspeArticle Spécialisé	text	Indicates whether the account article is specialized or not.Indicates whether the account article is specialized or not.
100%	codrdRecette/Dépense	text	Indicates whether the line is revenue or expenditure.Indicates whether the line is revenue or expenditure.
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	Prior-year carried-forward amount not yet realized.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 voted in the budget for this line.Amount voted in the budget for this line.
100%	credouvCrédits ouverts à l'article	double	Total credits opened for this article.Total credits opened for this article.
100%	mtrealMontant signé	double	Confirmed (signed) amount of budget execution.Montant signé des réalisations budgétaires
100%	mtrar3112Montant reste à réaliser de l'exercice	double	Amount carried forward as unrealized at year-end.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 budgetary operation, e.g. real or mixed.Type of budgetary operation, e.g. real or mixed.
0%	caracsup_chapspeCaracsup chapspe	text	Additional characteristic indicating a specialized chapter.Additional characteristic indicating a specialized chapter.
0%	caracsup_progautolibCaracsup progautolib	text	Label of an associated autonomous program, if any.Label of an associated autonomous program, if any.
0%	caracsup_progautonumCaracsup progautonum	text	Code number of an associated autonomous program, if any.Code number of an associated autonomous program, if any.
100%	norme	text	Accounting standard/framework applied, e.g. M57.Accounting standard/framework applied, e.g. M57.
100%	annee	text	Budget year.Budget year.
95.8%	libelle_nature_cpteLibellé Nature Compte	text	Description of the account nature.Description of the account nature.
99.3%	libelle_nature_chapLibellé Nature Chapitre	text	Description of the nature chapter.Description of the nature chapter.
88.9%	libelle_ref_foncLibellé référence	text	Description of the function reference category.Description of the function reference category.

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: 2019 · codrd: Dépense

{
  "annee": "2019",
  "codrd": "Dépense",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 5000,
  "mtreal": 0,
  "nature": "6255",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 9000,
  "fonction": "020",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 9000,
  "mtpropnouv": 5000,
  "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": "Frais de déménagement",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 2annee: 2019 · codrd: Dépense

{
  "annee": "2019",
  "codrd": "Dépense",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 5100,
  "mtreal": 0,
  "nature": "6065",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 5100,
  "fonction": "64",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 5100,
  "mtpropnouv": 5100,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Rayonnement et attractivité du territoire",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Livres, disques, cassettes... (bibliothèques et médiathèques)",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 3annee: 2019 · codrd: Dépense

{
  "annee": "2019",
  "codrd": "Dépense",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 0,
  "nature": "6228",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 5700,
  "fonction": "22",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 5700,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Enseignement du second degré",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Divers",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 4annee: 2019 · codrd: Dépense

{
  "annee": "2019",
  "codrd": "Dépense",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 0,
  "nature": "6218",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "012",
  "credouv": 37201,
  "fonction": "422",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 37201,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Petite enfance",
  "libelle_nature_chap": "Charges de personnel et frais assimilés",
  "libelle_nature_cpte": "Autre personnel extérieur",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 5annee: 2019 · codrd: Dépense

{
  "annee": "2019",
  "codrd": "Dépense",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 775,
  "mtreal": 0,
  "nature": "60632",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 600,
  "fonction": "12",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 600,
  "mtpropnouv": 775,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Incendie et secours",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Fournitures de petit équipement",
  "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_2019

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_2019/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.2k

2228

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.

City of Bordeaux 2019 Original BudgetBudget primitif 2019 de la ville de Bordeaux

Trust score

Data schema (21 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