Register record·API·FRVERIFIED · checked 32h ago
C
2017 Administrative Account of Bordeaux MétropoleCompte Administratif 2017 de Bordeaux Métropole
Compte Administratif 2017 de Bordeaux Métropole2017 Administrative Account of Bordeaux Métropole
This API provides access to the 2017 administrative account (compte administratif) of Bordeaux Métropole, presenting budgetary data by nature at the chapter level. It is published on the Bordeaux Métropole open data portal and offers a breakdown of the local authority's actual revenue and expenditure for the fiscal year, useful for budgetary analysis and financial transparency regarding the metropolitan area's public accounts.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 (25 fields)
Filterable via the API (25)
naturefonctioncontnatartspecodrdmtbudgprecmtrarprecmtpropnouvmtprevcredouvmtrealmtrar3112opbudgtypopbudgfilenamemtsup_prodcharatmtsup_budgethorsrarcaracsup_chapspecaracsup_progautolibcaracsup_progautonumnormelibelle_nature_cptelibelle_nature_chaplibelle_ref_foncannee
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| 100% | natureCode Nature | text | Nature account code.Nature account code. |
| 73.4% | fonctionCode Fonction | text | Functional classification code.Functional classification code. |
| 100% | contnatCode ContNat | text | Nature chapter code.Nature chapter code. |
| 100% | artspeArticle Spécialisé | text | Indicates whether the article is specialized or not.Indicates whether the 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 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 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.Amount of new budget proposals. |
| 100% | mtprevMontant budget voté | double | Amount voted in the budget.Amount voted in the budget. |
| 100% | credouvCrédits ouverts à l'article | double | Credits opened for the article.Credits opened for the 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 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 (real, mixed, or order).Type of budgetary operation (real, mixed, or order). |
| 17.1% | typopbudgType d'opération budgétaire | text | Code for the type of budgetary operation.Code for the type of budgetary operation. |
| 100% | filename | text | Source data file name.Source data file name. |
| 100% | mtsup_prodcharatMtsup prodcharat | double | Additional amount related to accrued income/expenses.Additional amount related to accrued income/expenses. |
| 100% | mtsup_budgethorsrarMtsup budgethorsrar | double | Additional budget amount excluding amounts to be realized.Additional budget amount excluding amounts to be realized. |
| 0% | caracsup_chapspeCaracsup chapspe | text | Indicates whether the chapter is a specialized chapter.Indicates whether the chapter is a specialized chapter. |
| 1.7% | caracsup_progautolibCaracsup progautolib | text | Label of the autonomous program, if applicable.Label of the autonomous program, if applicable. |
| 11.9% | caracsup_progautonumCaracsup progautonum | text | Number of the autonomous program, if applicable.Number of the autonomous program, if applicable. |
| 100% | norme | text | Accounting standard applied to the budget.Accounting standard applied to the budget. |
| 99.2% | libelle_nature_cpteLibellé Nature Compte | text | Label of the nature account.Label of the nature account. |
| 100% | libelle_nature_chapLibellé Nature Chapitre | text | Label of the nature chapter.Label of the nature chapter. |
| 73.4% | libelle_ref_foncLibellé référence | text | Label of the functional reference.Label of 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",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 4838956.8,
"nature": "231351",
"opbudg": "Opération réelle ou mixte",
"contnat": "23",
"credouv": 5432500.54,
"filename": "CA2017_BM_budget-principal",
"fonction": "020",
"mtrar3112": 564736.88,
"mtrarprec": 401687.73,
"typopbudg": null,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Administration générale de la collectivité",
"mtsup_prodcharat": 0,
"libelle_nature_chap": "Immobilisations en cours",
"libelle_nature_cpte": "Bâtiments publics",
"mtsup_budgethorsrar": 5030812.81,
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 2annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 6688.8,
"nature": "6042",
"opbudg": "Opération réelle ou mixte",
"contnat": "011",
"credouv": 8000,
"filename": "CA2017_BM_budget-principal",
"fonction": "213",
"mtrar3112": 0,
"mtrarprec": 0,
"typopbudg": null,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Classes regroupées",
"mtsup_prodcharat": 4520,
"libelle_nature_chap": "Charges à caractère général",
"libelle_nature_cpte": "Achats de prestations de services (autres que terrains à aménager)",
"mtsup_budgethorsrar": 8000,
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 3annee: 2017 · codrd: Recette
{
"annee": "2017",
"codrd": "Recette",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 0,
"nature": "4582",
"opbudg": "Opération réelle ou mixte",
"contnat": "4582",
"credouv": 160024.89,
"filename": "CA2017_BM_budget-principal",
"fonction": "01",
"mtrar3112": 160024.89,
"mtrarprec": 160024.89,
"typopbudg": null,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Opérations non ventilables",
"mtsup_prodcharat": 0,
"libelle_nature_chap": "Opérations sous mandat",
"libelle_nature_cpte": "Recettes (à subdiviser par mandat)",
"mtsup_budgethorsrar": 0,
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 4annee: 2017 · codrd: Recette
{
"annee": "2017",
"codrd": "Recette",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 7188.66,
"nature": "2115",
"opbudg": "Opération réelle ou mixte",
"contnat": "21",
"credouv": 0,
"filename": "CA2017_BM_budget-principal",
"fonction": "734",
"mtrar3112": 0,
"mtrarprec": 0,
"typopbudg": null,
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": "Eaux pluviales",
"mtsup_prodcharat": 0,
"libelle_nature_chap": "Immobilisations corporelles",
"libelle_nature_cpte": "Terrains bâtis",
"mtsup_budgethorsrar": 0,
"caracsup_progautolib": null,
"caracsup_progautonum": null
}Record 5annee: 2017 · codrd: Dépense
{
"annee": "2017",
"codrd": "Dépense",
"norme": "M57-M57",
"artspe": "Article non spécialisé",
"mtprev": 0,
"mtreal": 3260696,
"nature": "21532",
"opbudg": "Opération d'ordre",
"contnat": "041",
"credouv": 6000000,
"filename": "CA2017_BM_assainissement",
"fonction": null,
"mtrar3112": 0,
"mtrarprec": 0,
"typopbudg": "1",
"mtbudgprec": 0,
"mtpropnouv": 0,
"caracsup_chapspe": null,
"libelle_ref_fonc": null,
"mtsup_prodcharat": 0,
"libelle_nature_chap": "Opérations patrimoniales",
"libelle_nature_cpte": null,
"mtsup_budgethorsrar": 6000000,
"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/compte-administratif-bordeaux-metropole-2017
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/compte-administratif-bordeaux-metropole-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
3.5k
3473
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.