Register record·API·FRSTALE · checked 4d ago
C
2017 Administrative Account of the City of BordeauxCompte Administratif 2017 de la ville de Bordeaux
Compte Administratif 2017 de la ville de Bordeaux2017 Administrative Account of the City of Bordeaux
This dataset provides the 2017 administrative account (compte administratif) of the city of Bordeaux, presenting budget figures broken down by nature of expenditure and revenue, organized at the chapter level. It is published through the Bordeaux Métropole open data portal and is accessible for free without authentication, offering a view of the city's annual financial execution in aggregated form.Compte administratif par nature au niveau des chapitres.
public-finance
Trust score
How is this computed?35
poor
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 nature code identifying the accounting line item.Budget nature code identifying the accounting line item. |
| 100% | fonctionCode Fonction | text | Budget function code classifying the type of expenditure or revenue.Budget function code classifying the type of expenditure or revenue. |
| 99.8% | contnatCode ContNat | text | Nature account code used for accounting classification.Nature account code used for accounting classification. |
| 100% | artspeArticle Spécialisé | text | Indicates whether the budget article is specialized or not.Indicates whether the budget article is specialized or not. |
| 100% | codrdRecette/Dépense | text | Indicates whether the line is a revenue or expenditure.Indicates whether the line is a revenue or expenditure. |
| 100% | mtbudgprecMontant Budget précédent | double | Amount from the previous year's budget.Amount from the previous year's budget. |
| 100% | mtrarprecMontant reste à réaliser N-1 | double | Amount carried over to be realized from the previous fiscal 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 of the voted budget for this line.Amount of the voted budget for this line. |
| 100% | credouvCrédits ouverts à l'article | double | Amount of appropriations opened for this budget article.Amount of appropriations opened for this budget article. |
| 100% | mtrealMontant signé | double | Amount of confirmed budget realizations for this line.Montant signé des réalisations budgétaires |
| 100% | mtrar3112Montant reste à réaliser de l'exercice | double | Amount remaining to be realized at the end of 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 | Supplementary amount details, such as committed and remaining budget figures.Supplementary amount details, such as committed and remaining budget figures. |
| 0% | caracsup_chapspeCaracsup chapspe | text | Additional characteristic indicating a specialized chapter.Additional characteristic indicating a specialized chapter. |
| 0% | caracsup_progautolibCaracsup progautolib | text | Label of the associated autonomous program, if applicable.Label of the associated autonomous program, if applicable. |
| 0% | caracsup_progautonumCaracsup progautonum | text | Number of the associated autonomous program, if applicable.Number of the associated autonomous program, if applicable. |
| 100% | norme | text | Accounting standard or reporting framework applied.Accounting standard or reporting framework applied. |
| 96.4% | libelle_nature_cpteLibellé Nature Compte | text | Label describing the nature account.Label describing the nature account. |
| 99% | libelle_nature_chapLibellé Nature Chapitre | text | Label describing the nature chapter.Label describing the nature chapter. |
| 86.3% | libelle_ref_foncLibellé référence | text | Label describing the functional reference.Label describing the functional reference. |
| 100% | annee | text | Fiscal year of the budget record.Fiscal year of the budget record. |
Schema captured from opendatasoft 3 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: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"3140447.20\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 3456657.32,
"nature": "2313",
"opbudg": "Opération réelle ou mixte",
"contnat": "23",
"credouv": 6923879.54,
"fonction": "020",
"mtrar3112": 2000987.78,
"mtrarprec": 3783432.34,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Services communs",
"libelle_nature_chap": "Virement à la section d'investissement",
"libelle_nature_cpte": "Constructions",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 2annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"1739346.61\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 2441290.23,
"nature": "2313",
"opbudg": "Opération réelle ou mixte",
"contnat": "23",
"credouv": 5603018.12,
"fonction": "213",
"mtrar3112": 1250547.7,
"mtrarprec": 3863671.51,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Classes regroupées",
"libelle_nature_chap": "Immobilisations en cours",
"libelle_nature_cpte": "Constructions",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 3annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"33128.08\",\"BudgetHorsRAR\" : \"192046.51\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 184309.77,
"nature": "6135",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 192046.51,
"fonction": "020",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Services communs",
"libelle_nature_chap": "Charges à caractère général",
"libelle_nature_cpte": "Locations mobilières",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 4annee: 2017 · codrd: Recette
{
"annee": "2017",
"codrd": "Recette",
"mtsup": "{\"MtOpeCumul\" : \"0.00\",\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"100000.00\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 56320.13,
"nature": "4542",
"opbudg": "Opération réelle ou mixte",
"contnat": "4542",
"credouv": 277425.17,
"fonction": "020",
"mtrar3112": 221105.04,
"mtrarprec": 177425.17,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Administration générale de la collectivité",
"libelle_nature_chap": null,
"libelle_nature_cpte": "Remembrement",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 5annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"400000.00\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 0,
"nature": "238",
"opbudg": "Opération d'ordre",
"contnat": "041",
"credouv": 400000,
"fonction": "01",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Sécurité",
"libelle_nature_chap": "Opérations patrimoniales",
"libelle_nature_cpte": "Avances versées sur commandes d'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_2017
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_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.
Rate limits
50 000 req/day
per ipmeasured
observed 3 days ago
Dataset
Volume & freshness
Records
2.4k
2394
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.