Register record·API·FRSTALE · checked 4d ago

C

Compte Administratif 2018 de la ville de Bordeaux

Name: Compte Administratif 2018 de la ville de Bordeaux
Creator: opendatasoft

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

Website Docs

Compte administratif par nature au niveau des chapitres.

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

Data schema (22 fields)

Filterable via the API (22)

naturefonctioncontnatartspecodrdmtbudgprecmtrarprecmtpropnouvmtprevcredouvmtrealmtrar3112opbudgmtsupcaracsup_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 code.Budget function code.
99.9%	contnatCode ContNat	text	Nature-account counterpart code.Nature-account counterpart code.
100%	artspeArticle Spécialisé	text	Indicates whether the budget article is specialized.Indicates whether the budget article is specialized.
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.Amount from the previous budget.
100%	mtrarprecMontant reste à réaliser N-1	double	Amount to be carried over from the prior year's remaining commitments.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.Amount of new budget proposals.
100%	mtprevMontant budget voté	double	Amount of the voted budget.Amount of the voted budget.
100%	credouvCrédits ouverts à l'article	double	Credits opened for this article.Credits opened for this article.
100%	mtrealMontant signé	double	Signed amount of budget execution.Montant signé des réalisations budgétaires
100%	mtrar3112Montant reste à réaliser de l'exercice	double	Amount remaining to be realized for the fiscal 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 structured supplementary amount data.Additional structured supplementary amount data.
0%	caracsup_chapspeCaracsup chapspe	text	Special chapter supplementary characteristic.Special chapter supplementary characteristic.
0%	caracsup_progautolibCaracsup progautolib	text	Label of the autonomous program supplementary characteristic.Label of the autonomous program supplementary characteristic.
0%	caracsup_progautonumCaracsup progautonum	text	Numeric code of the autonomous program supplementary characteristic.Numeric code of the autonomous program supplementary characteristic.
100%	norme	text	Accounting standard applied to the budget.Accounting standard applied to the budget.
100%	annee	text	Fiscal year of the budget record.Fiscal year of the budget record.
96%	libelle_nature_cpteLibellé Nature Compte	text	Label describing the nature account.Label describing the nature account.
99.5%	libelle_nature_chapLibellé Nature Chapitre	text	Label describing the nature chapter.Label describing the nature chapter.
87.7%	libelle_ref_foncLibellé référence	text	Label describing the function reference.Label describing the function reference.

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 1annee: 2018 · codrd: Dépense

{
  "annee": "2018",
  "codrd": "Dépense",
  "mtsup": "[3796.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"5619.42\", \"@Code\": \"BudgetHorsRAR]",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 4896.44,
  "nature": "6068",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 5619.42,
  "fonction": "415",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": null,
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Autres matières et fournitures",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 2annee: 2018 · codrd: Dépense

{
  "annee": "2018",
  "codrd": "Dépense",
  "mtsup": "[8541.68\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"21957.03\", \"@Code\": \"BudgetHorsRAR]",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 20175.79,
  "nature": "6068",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 21957.03,
  "fonction": "64",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Rayonnement et attractivité du territoire",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Autres matières et fournitures",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 3annee: 2018 · codrd: Dépense

{
  "annee": "2018",
  "codrd": "Dépense",
  "mtsup": "[46350.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"107810.00\", \"@Code\": \"BudgetHorsRAR]",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 106429.01,
  "nature": "611",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 107810,
  "fonction": "22",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Enseignement du second degré",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Contrats de prestations de services",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 4annee: 2018 · codrd: Dépense

{
  "annee": "2018",
  "codrd": "Dépense",
  "mtsup": "[0.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"1622.14\", \"@Code\": \"BudgetHorsRAR]",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 1622.14,
  "nature": "611",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 1622.14,
  "fonction": "412",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": "Prévention et éducation pour la santé",
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Contrats de prestations de services",
  "caracsup_progautolib": null,
  "caracsup_progautonum": null
}

Record 5annee: 2018 · codrd: Dépense

{
  "annee": "2018",
  "codrd": "Dépense",
  "mtsup": "[11516.15\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"49252.55\", \"@Code\": \"BudgetHorsRAR]",
  "norme": "M57-M57",
  "artspe": "Article non spécialisé",
  "mtprev": 0,
  "mtreal": 49252.55,
  "nature": "611",
  "opbudg": "Opération réelle ou mixte",
  "contnat": "011",
  "credouv": 49252.55,
  "fonction": "521",
  "mtrar3112": 0,
  "mtrarprec": 0,
  "mtbudgprec": 0,
  "mtpropnouv": 0,
  "caracsup_chapspe": null,
  "libelle_ref_fonc": null,
  "libelle_nature_chap": "Charges à caractère général",
  "libelle_nature_cpte": "Contrats de prestations de services",
  "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_compteadmin_2018

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_compteadmin_2018/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 6 days ago

Dataset

Volume & freshness

Records

2.3k

2344

Last upstream update

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

Compte Administratif 2018 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