{"id":"21591cda-a8a8-4226-9b06-3f5f53023549","type":"API","name":"Compte Administratif 2017 de la ville de Bordeaux","slug":"compte-administratif-2017-de-la-ville-de-bordeaux","description":"Compte administratif par nature au niveau des chapitres.","free_access_class":"UNKNOWN","auth_type":"UNKNOWN","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_compteadmin_2017/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_compteadmin_2017/","repo_url":null,"status":"ACTIVE","verification_state":"UNVERIFIED","tags":[],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_compteadmin_2017/","extraction_confidence":"0.00","created_at":"2026-07-25T16:35:23.097Z","updated_at":"2026-07-25T16:35:54.964Z","last_verified_at":null,"deprecated_at":null,"ranking_score":0,"last_ranked_at":null,"last_seen_at":null,"last_validated_at":null,"last_uptime_at":null,"search_vector":"'2017':3A,19A 'administratif':2A,10B,18A,26B 'au':13B,29B 'bordeaux':8A,24A 'chapitr':16B 'chapitres':32B 'compt':1A,9B 'compte':17A,25B 'de':4A,7A,20A,23A 'des':15B,31B 'la':5A,21A 'natur':12B 'nature':28B 'niveau':14B,30B 'par':11B,27B 'vill':6A 'ville':22A","popularity_score":"0.0000","maintenance_score":"0.0000","institution_id":null,"institution_type":null,"country_code":"FR","official_confidence":0,"proof_summary":"Confidence: 0%","source_seed_url":null,"is_public_sector":true,"published_at":"2026-07-26T19:49:02.498Z","geographic_scope":"NATIONAL","name_en":null,"description_en":null,"native_lang":null,"access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":0,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},"actions":[{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/exports/csv","format":"CSV","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"List records","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Select & filter","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?select=nature%2Cfonction%2Ccontnat&where=nature+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"API base URL","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017","source":"base_url","runnable":false},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_compteadmin_2017/","source":"docs","runnable":false}],"formats":["CSV"]},"api_details":{"id":"863cd636-a004-4657-9652-ce2f41bf554b","entry_id":"21591cda-a8a8-4226-9b06-3f5f53023549","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017","openapi_url":null,"graphql_url":null,"api_version":null,"spec_format":null,"endpoints_count":null,"endpoints":[],"rate_limit_info":null,"free_tier_limits":null,"ping_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017","created_at":"2026-07-25T16:35:23.258Z","updated_at":"2026-07-25T16:35:23.258Z"},"dataset_details":{"id":"0457da12-4f92-4bc7-a81f-e39f4d04c84d","entry_id":"21591cda-a8a8-4226-9b06-3f5f53023549","upstream_issued":null,"upstream_modified":"2023-05-23T12:48:33.000Z","themes":[],"update_frequency":null,"temporal_start":null,"temporal_end":null,"spatial_coverage":null,"landing_page":null,"license_id":null,"license_raw":null,"has_documentation":false,"has_data_dictionary":false,"has_versioning":false,"source_portal":"opendatasoft","source_portal_url":"https://opendata.bordeaux-metropole.fr","created_at":"2026-07-25T16:35:54.467Z","updated_at":"2026-07-25T16:35:54.467Z","publisher":null,"publisher_url":null,"distributions":[],"license":null},"license":{"id":"lo-2.0","spdx_id":"etalab-2.0","name":"Licence Ouverte 2.0 (France / Etalab)","url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","is_open":true,"is_redistributable":true,"requires_attribution":true,"category":"national","notes":null,"created_at":"2026-06-12T16:29:19.729Z"},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":null,"data_profile":{"id":"6c04a85a-be06-432a-883f-024cb0b82fcb","entry_id":"21591cda-a8a8-4226-9b06-3f5f53023549","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bor_compteadmin_2017","fields":[{"name":"nature","type":"text","label":"Code Nature","fill_pct":100,"filterable":true,"description":null},{"name":"fonction","type":"text","label":"Code Fonction","fill_pct":100,"filterable":true,"description":null},{"name":"contnat","type":"text","label":"Code ContNat","fill_pct":99.8,"filterable":true,"description":null},{"name":"artspe","type":"text","label":"Article Spécialisé","fill_pct":100,"filterable":true,"description":null},{"name":"codrd","type":"text","label":"Recette/Dépense","fill_pct":100,"filterable":true,"description":null},{"name":"mtbudgprec","type":"double","label":"Montant Budget précédent","fill_pct":100,"filterable":true,"description":null},{"name":"mtrarprec","type":"double","label":"Montant reste à réaliser N-1","fill_pct":100,"filterable":true,"description":"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."},{"name":"mtpropnouv","type":"double","label":"Montant \"Propositions Nouvelles\"","fill_pct":100,"filterable":true,"description":null},{"name":"mtprev","type":"double","label":"Montant budget voté","fill_pct":100,"filterable":true,"description":null},{"name":"credouv","type":"double","label":"Crédits ouverts à l'article","fill_pct":100,"filterable":true,"description":null},{"name":"mtreal","type":"double","label":"Montant signé","fill_pct":100,"filterable":true,"description":"Montant signé des réalisations budgétaires"},{"name":"mtrar3112","type":"double","label":"Montant reste à réaliser de l'exercice","fill_pct":100,"filterable":true,"description":"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 »)."},{"name":"opbudg","type":"text","label":"Opération budgétaire","fill_pct":100,"filterable":true,"description":null},{"name":"mtsup","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"caracsup_chapspe","type":"text","label":null,"fill_pct":0,"filterable":true,"description":null},{"name":"caracsup_progautolib","type":"text","label":null,"fill_pct":0,"filterable":true,"description":null},{"name":"caracsup_progautonum","type":"text","label":null,"fill_pct":0,"filterable":true,"description":null},{"name":"norme","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"annee","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null},{"name":"libelle_nature_cpte","type":"text","label":"Libellé Nature Compte","fill_pct":96.4,"filterable":true,"description":null},{"name":"libelle_nature_chap","type":"text","label":"Libellé Nature Chapitre","fill_pct":99,"filterable":true,"description":null},{"name":"libelle_ref_fonc","type":"text","label":"Libellé référence","fill_pct":86.3,"filterable":true,"description":null}],"field_count":22,"sample_records":[{"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},{"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},{"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},{"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},{"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}],"record_count":"2394","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?limit=20' -H 'Accept: application/json'","label":"List records","method":"GET","description":"First 20 records of the dataset as JSON."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?select=nature%2Cfonction%2Ccontnat&where=nature+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/records?select=nature%2Cfonction%2Ccontnat&where=nature+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (nature, fonction, contnat) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_compteadmin_2017/exports/csv' -o dataset.csv","label":"Export CSV","method":"GET","description":"Full dataset export as CSV (also available: json, parquet, xlsx)."}],"status":"ok","error_message":null,"profiled_at":"2026-07-25T16:35:53.990Z","run_id":"97ae1898-f880-46a9-b9c3-3aa0161d8235","created_at":"2026-07-25T16:35:53.990Z","updated_at":"2026-07-25T16:35:53.990Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","previewable":true},"datasets":[],"limits":[{"id":"222b4b61-eead-43ee-b0ba-01038815c525","entry_id":"21591cda-a8a8-4226-9b06-3f5f53023549","limit_type":"requests_per_day","value":"50000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-07-25T16:35:54.639Z"}]}