Register record·API·FRVERIFIED · checked 3d ago
C
Compte Administratif 2017 de la ville de Bordeaux
Compte administratif par nature au niveau des chapitres.
Trust score
How is this computed?42
fair
Weighted across five axes. Tap a ring for what it measures.
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 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. |
| 100% | annee | text | Fiscal year of the budget record.Fiscal year of the budget record. |
| 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. |
Schema captured from opendatasoft 7 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\" : \"465.00\",\"BudgetHorsRAR\" : \"4000.00\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 3890.22,
"nature": "6184",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 4000,
"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": "Versements à des organismes de formation",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 2annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"74.28\",\"BudgetHorsRAR\" : \"13441.16\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 13433.32,
"nature": "6188",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 13441.16,
"fonction": "041",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Actions relevant de la subvention globale",
"libelle_nature_chap": "Charges à caractère général",
"libelle_nature_cpte": "Autres frais divers",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 3annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"9030.00\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 6799.84,
"nature": "6188",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 9030,
"fonction": "323",
"mtrar3112": 2230,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Piscines",
"libelle_nature_chap": "Charges à caractère général",
"libelle_nature_cpte": "Autres frais divers",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 4annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"60.00\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 60,
"nature": "6188",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 60,
"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": "Autres frais divers",
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 5annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"mtsup": "{\"ProdChaRat\" : \"0.00\",\"BudgetHorsRAR\" : \"1145.19\"}",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 1145.19,
"nature": "6218",
"opbudg": "Opération réelle ou mixte",
"contnat": "012",
"credouv": 1145.19,
"fonction": "40",
"mtrar3112": 0,
"mtrarprec": 0,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": null,
"libelle_nature_chap": "Charges de personnel et frais assimilés",
"libelle_nature_cpte": "Autre personnel extérieur",
"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 7 days ago
Dataset
Volume & freshness
Records
2.4k
2394
Last upstream update
3 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.