Register record·API·FRVERIFIED · checked 11h ago
C
2018 Administrative Account of the City of BordeauxCompte Administratif 2018 de la ville de Bordeaux
Compte Administratif 2018 de la ville de Bordeaux2018 Administrative Account of the City of Bordeaux
This dataset provides the 2018 administrative account (budget execution report) for the city of Bordeaux, broken down by nature of expenditure or revenue at the chapter level. It is published via the Bordeaux Métropole open data portal and offers insight into the municipality's actual financial operations for that fiscal year, useful for budget analysis and public finance transparency.Compte administratif par nature au niveau des chapitres.
public-finance
Trust score
How is this computed?45
fair
Weighted across five axes. Tap a ring for what it measures.
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.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. |
| 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. |
| 100% | annee | text | Fiscal year of the budget record.Fiscal year of the budget record. |
Schema captured from opendatasoft 2 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.
=
Sample data (5 records)
Record 1annee: 2018 · codrd: Dépense
{
"annee": "2018",
"codrd": "Dépense",
"mtsup": "[0.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"1370852.50\", \"@Code\": \"BudgetHorsRAR]",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 1323784.57,
"nature": "2313",
"opbudg": "Opération réelle ou mixte",
"contnat": "23",
"credouv": 2247808.5,
"fonction": "322",
"mtrar3112": 757420.53,
"mtrarprec": 876956,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Stades",
"libelle_nature_chap": "Immobilisations en cours",
"libelle_nature_cpte": "Constructions",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 2annee: 2018 · codrd: Dépense
{
"annee": "2018",
"codrd": "Dépense",
"mtsup": "[106.56\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"1250.00\", \"@Code\": \"BudgetHorsRAR]",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 1144.4,
"nature": "6064",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 1250,
"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": "Fournitures administratives",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 3annee: 2018 · codrd: Dépense
{
"annee": "2018",
"codrd": "Dépense",
"mtsup": "[0.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"299.28\", \"@Code\": \"BudgetHorsRAR]",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 299.28,
"nature": "2158",
"opbudg": "Opération réelle ou mixte",
"contnat": "21",
"credouv": 299.28,
"fonction": "413",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Sécurité alimentaire",
"libelle_nature_chap": "Virement de la section de fonctionnement",
"libelle_nature_cpte": "Autres installations, matériel et outillage techniques",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 4annee: 2018 · codrd: Recette
{
"annee": "2018",
"codrd": "Recette",
"mtsup": "[0.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"8000.00\", \"@Code\": \"BudgetHorsRAR]",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 22170,
"nature": "7478",
"opbudg": "Opération réelle ou mixte",
"contnat": "74",
"credouv": 8000,
"fonction": "61",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Interventions économiques transversales",
"libelle_nature_chap": "Dotations et participations",
"libelle_nature_cpte": "Autres organismes",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 5annee: 2018 · codrd: Dépense
{
"annee": "2018",
"codrd": "Dépense",
"mtsup": "[0.00\", \"@Code\": \"ProdChaRat\"}, {\"@V\": \"0.00\", \"@Code\": \"BudgetHorsRAR]",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 0,
"nature": "2318",
"opbudg": "Opération réelle ou mixte",
"contnat": "23",
"credouv": 8411.27,
"fonction": "821",
"mtrar3112": 0,
"mtrarprec": 8411.27,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Transport sur route",
"libelle_nature_chap": "Immobilisations en cours",
"libelle_nature_cpte": "Autres immobilisations corporelles",
"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
- ✓ 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.
Rate limits
50 000 req/day
per ipmeasured
observed 2 days ago
Dataset
Volume & freshness
Records
2.3k
2344
Last upstream update
4 years ago
2023-05-23
License
No license declared upstream.
○ Documentation○ Data dictionary○ Versioning
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.