{"id":"38c782de-1156-4636-97f5-66cc744562d5","type":"API","name":"Compte Administratif 2022 du CCAS de la ville de Bordeaux","slug":"compte-administratif-2022-du-ccas-de-la-ville-de-bordeaux","description":"Compte administratif par nature au niveau des chapitres.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_compte_administratif_2022/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_compte_administratif_2022/","repo_url":null,"status":"ACTIVE","verification_state":"STALE","tags":["public-finance"],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_compte_administratif_2022/","extraction_confidence":"0.00","created_at":"2026-07-25T19:21:44.948Z","updated_at":"2026-10-23T01:53:41.107Z","last_verified_at":"2026-10-19T22:10:07.572Z","deprecated_at":null,"ranking_score":58,"last_ranked_at":"2026-10-13T09:34:32.544Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-16T01:39:55.098Z","popularity_score":"0.0000","maintenance_score":"0.7000","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-26T09:19:57.997Z","geographic_scope":"NATIONAL","name_en":"2022 Administrative Account of the Bordeaux CCAS (Municipal Social Action Centre)","description_en":"This dataset provides the 2022 administrative account (financial statement) of the Centre Communal d'Action Sociale (CCAS) of the city of Bordeaux, France's municipal social welfare body. Figures are presented by nature of expenditure and revenue, broken down at chapter level. The data is published via the Bordeaux Métropole open data portal, offering a view of the CCAS's budget execution for the year, useful for analysing local public social spending and financial transparency.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":32.25,"merged_into_entry_id":null,"identity_key":"API|https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_compte_administratif_2022|compte administratif 2022 du ccas de la ville de bordeaux","upstream_ref":"opendata.bordeaux-metropole.fr:dataset:bor_ccas_compte_administratif_2022","content_changed_at":"2026-10-15T12:18:26.466Z","institution":null,"title_qualifier":null,"access":{"level":"direct","primary":{"kind":"download","label":"Export CSV","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/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_ccas_compte_administratif_2022/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_ccas_compte_administratif_2022/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_ccas_compte_administratif_2022/records?select=bgt_nom%2Cbgt_siret%2Cbgt_annee&where=bgt_nom+is+not+null&limit=20","source":"query_example","runnable":true,"direct":true},{"kind":"query","label":"Run verified request","method":"GET","url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_compte_administratif_2022/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"38c782de-1156-4636-97f5-66cc744562d5","granularity":"entry","granularity_label":"One unit = one catalog entry. A PROXY for the SCOPE.md §4 ladder, which governs source families, not entries: a family with 400 entries moves this reading 400 times as much as a family with one. Never compare or combine with the source_family reading.","level":"discovered","level_index":1,"level_label":"Discovered","meaning":"Source and metadata recorded","counts_as_coverage":false,"blocked_by":"verified","rungs":[{"level":"discovered","level_index":1,"label":"Discovered","meaning":"Source and metadata recorded","evidence":"membership of the named population the ladder is taken over","counts_as_coverage":false,"met":true,"reached":true,"criterion":"TRUE"},{"level":"verified","level_index":2,"label":"Verified","meaning":"Access tested successfully","evidence":"entries.verification_state = 'VERIFIED'","counts_as_coverage":false,"met":false,"reached":false,"criterion":"entries.verification_state = 'VERIFIED'"},{"level":"profiled","level_index":3,"label":"Profiled","meaning":"Schema, dimensions and licence understood","evidence":"a data profile with at least one field (entry_data_profiles.field_count > 0)","counts_as_coverage":false,"met":true,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_data_profiles p WHERE p.entry_id = entries.id AND COALESCE(p.field_count, 0) > 0)"},{"level":"executable","level_index":4,"label":"Executable","meaning":"Queries run through Commodity","evidence":"entries.capability_tier = 'live' — today's proxy for \"queryable through us\"","counts_as_coverage":true,"met":true,"reached":false,"criterion":"entries.capability_tier = 'live'"},{"level":"joinable","level_index":5,"label":"Joinable","meaning":"Canonical identifiers and concepts mapped","evidence":"a field link to a canonical identifier whose sampled VALUES match its format","counts_as_coverage":true,"met":true,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_field_links efl WHERE efl.entry_id = entries.id AND efl.identifier_id IS NOT NULL AND efl.value_status = 'match')"},{"level":"reproducible","level_index":6,"label":"Reproducible","meaning":"Snapshots and transformation evidence retained","evidence":"at least one retained evidence manifest (migration 078)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM evidence_manifests em WHERE em.entry_id = entries.id)"},{"level":"guaranteed","level_index":7,"label":"Guaranteed","meaning":"Monitored against an operational reliability target","evidence":"an active reliability target with a named monitor (migration 096)","counts_as_coverage":true,"met":false,"reached":false,"criterion":"EXISTS (SELECT 1 FROM entry_reliability_targets rt WHERE rt.entry_id = entries.id AND rt.is_active = true)"}],"officialness":{"basis":"catalog_inherited","label":"Inherited from the upstream catalog: this item came from a trusted official government catalog, and that provenance — not per-item proof — is the warrant. Its own proof score is below 80 or it matched no registered institution (apps/worker/src/connectors/catalog/qualify-store.ts).","proof_confidence":0,"proven_threshold":80,"institution_id":null,"definition":"CASE WHEN COALESCE(entries.is_public_sector, false) IS NOT TRUE THEN 'not_official' WHEN COALESCE(entries.official_confidence, 0) >= 80 AND entries.institution_id IS NOT NULL THEN 'per_item_proven' ELSE 'catalog_inherited' END"},"source_family":{"key":"opendata.bordeaux-metropole.fr","label":"One unit = one source family, approximated by the serving host of the entry's primary source URL (e.g. bdl.stat.gov.pl). A COMPUTED stand-in for the curated families of SCOPE.md §5, which no table holds yet. A family sits at the highest level any of its entries has reached, because a family is integrated to the depth of its deepest working integration. Never compare or combine with the entry reading."},"generated_at":"2026-10-23T23:54:25.099Z"},"api_details":{"id":"e2a70ff2-0452-4e60-999d-be14109ff613","entry_id":"38c782de-1156-4636-97f5-66cc744562d5","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022","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_ccas_compte_administratif_2022","created_at":"2026-07-25T19:21:45.104Z","updated_at":"2026-07-25T19:21:45.104Z"},"dataset_details":{"id":"dc75975f-e5ab-465b-aff7-d166bdbe0075","entry_id":"38c782de-1156-4636-97f5-66cc744562d5","upstream_issued":null,"upstream_modified":"2025-06-17T08:51:48.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-26T04:23:47.700Z","updated_at":"2026-10-22T12:29:04.346Z","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"},"reuse":{"license_id":"lo-2.0","license_name":"Licence Ouverte 2.0 (France / Etalab)","license_url":"https://www.etalab.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf","commercial_use":{"status":"yes","value":true},"redistribution":{"status":"yes","value":true},"attribution_required":{"status":"yes","value":true},"share_alike":{"status":"no","value":false},"personal_data_warning":{"status":"yes","value":true},"cache_and_mirror":{"status":"yes","value":true},"undetermined":[],"basis":"licence_text","confidence":0.95,"confidence_tier":"high","source_text":"Texte de la licence - le reutilisateur est libre \"de la communiquer, la reproduire, la copier ; de l'adapter, la modifier, l'extraire et la transformer, notamment pour creer des Informations derivees ; de la diffuser, la redistribuer, la publier et la transmettre, de l'exploiter a titre commercial\". Seule obligation : \"mentionner la paternite de l'Information : sa source (a minima le nom du Concedant) et la date de la derniere mise a jour\". Le texte rappelle que le reutilisateur doit respecter \"le cadre legal relatif a la protection des donnees a caractere personnel\". Aucune clause de partage a l'identique n'est imposee.","source_url":"https://github.com/etalab/licence-ouverte/blob/master/LO.md","reviewed_at":null},"license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","latest_check":{"id":"55f79e63-3e99-40fd-b829-cf1740a3325d","entry_id":"38c782de-1156-4636-97f5-66cc744562d5","status":"VERIFIED","last_checked_at":"2026-10-19T22:10:07.269Z","p50_latency_ms":1760,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-27T22:31:13.428Z","updated_at":"2026-10-19T22:10:07.269Z","consecutive_successes":18,"probe_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-10-19T22:10:07.269Z"},"data_profile":{"id":"135628b7-ce26-4377-acd1-c7ff9e117c71","entry_id":"38c782de-1156-4636-97f5-66cc744562d5","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bor_ccas_compte_administratif_2022","fields":[{"name":"bgt_nom","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Nom de la collectivité \nDescription : cette zone permet de préciser le nom de la collectivité ou de l'établissement public concerné par le budget","description_en":"Name of the local authority or public body concerned by the budget."},{"name":"bgt_siret","type":"int","label":null,"fill_pct":100,"filterable":true,"description":"Code SIRET\nDescription : cette zone permet de déterminer le code SIRET de la collectivité ou de l'établissement public concerné (http://xml.insee.fr/schema/siret.html#SIRET_stype)","description_en":"SIRET code identifying the local authority or public body."},{"name":"bgt_annee","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Année de l'exercice \nDescription : cette zone permet de déterminer l'année de l'exercice budgétaire concerné. ","description_en":"Year of the budget exercise."},{"name":"bgt_natdec","type":"text","label":null,"fill_pct":51.3,"filterable":true,"description":"Etape budgétaire\nCe champ permet de déterminer l'étape budgétaire concernée. \nLes valeurs possibles sont : \n\"compte administratif\", \n\"budget prévisionnel\", \n\"budget supplémentaire\", \n\"décision modificative\"","description_en":"Budget stage, e.g. administrative account, forecast, supplementary or amending budget."},{"name":"bgt_section","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Budget section, such as operating or investment."},{"name":"bgt_codrd","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Code recette / dépense. \nDescription : cette zone permet de déterminer le sens (recette - dépense) du crédit concerné.","description_en":"Indicates whether the entry is a revenue or an expenditure."},{"name":"bgt_opbudg","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Type d'opération budgétaire\nDescription : cette zone permet d'isoler les opérations d'ordre budgétaire. Par défaut valeur 0. ","description_en":"Type of budgetary operation, default value indicates a real operation."},{"name":"bgt_contnat","type":"text","label":null,"fill_pct":98.7,"filterable":true,"description":"Numéro du compte budgétaire\nDescription : correspond au numéro de compte. A partir du Plan de Compte, dans le tableau \"Liste des comptes et utilisations\", utiliser le ContNat comme code et voir le chapitre correspondant dans la colonne RR ou DR pour une recette ou une dépense respectivement.","description_en":"Budgetary account number from the chart of accounts."},{"name":"bgt_contnat_label","type":"text","label":null,"fill_pct":99.2,"filterable":true,"description":"Libellé du compte budgétaire\nDescription : Ce champ correspond à la colonne LIBELLE de l'article ou compte budgétaire dans le tableau \"Liste des comptes et utilisations\" du plan de compte","description_en":"Label of the budgetary account."},{"name":"bgt_nature","type":"text","label":null,"fill_pct":99.2,"filterable":true,"description":"Nature de la dépense ou de la recette \nDescription : cette zone permet de déterminer la nature de la dépense ou de la recette, c'est-à-dire au \"quoi\". Le numéro est un numéro d'article. Exemples de nature : carburant, dépenses de personnel…(voir plan de compte)","description_en":"Nature code describing what the expenditure or revenue is for."},{"name":"bgt_nature_label","type":"text","label":null,"fill_pct":97.6,"filterable":true,"description":"Libellé de la nature de la dépense ou de la recette\nDescription : cette zone permet de déterminer le libellé de la nature de la dépense ou de la recette. Ce libellé est issu du référentiel ODM relatif à chaque plan de compte (http://odm-budgetaire.org/composants/normes/)","description_en":"Label describing the nature of the expenditure or revenue."},{"name":"bgt_fonction","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Fonction de la dépense ou de la recette\nDescription : cette zone permet de déterminer la fonction de la dépense ou de la recette, c'est-à-dire au \"pourquoi\". correspond à la fonction de la recette/dépense, c'est-à-dire au \"pourquoi\". Le numéro est un numéro de fonction. Exemples de fonction : éducation, sécurité (voir plan de compte).","description_en":"Function code indicating the purpose of the expenditure or revenue."},{"name":"bgt_fonction_label","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Libellé de la fonction de la dépense ou de la recette\nDescription : cette zone permet de déterminer le libellé de la fonction de la dépense ou de la recette. Ce libellé est issu du référentiel ODM relatif à chaque plan de compte (http://odm-budgetaire.org/composants/normes/)","description_en":"Label describing the function of the expenditure or revenue."},{"name":"bgt_credouv","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Crédits ouverts à l'article\nDescription : montant des crédits de paiement disponibles pour effectuer des dépenses sur cet article.","description_en":"Amount of payment credits opened for this account."},{"name":"bgt_artspe","type":"text","label":null,"fill_pct":51.3,"filterable":true,"description":"Article spécialisé\nDescription : permet d'isoler des articles au moment du vote du budget. ","description_en":"Indicates whether the budget line is a specialized article."},{"name":"bgt_mtreal","type":"double","label":null,"fill_pct":100,"filterable":true,"description":"Montant signé des réalisations budgétaires\nDescription : montant réalisé (en dépense ou en recette). Ce champ n'a de sens que dans un compte administratif","description_en":"Actual realized amount of expenditure or revenue."},{"name":"bgt_mtrar3112","type":"double","label":null,"fill_pct":51.3,"filterable":true,"description":"Montant reste à réaliser de l’exercice\nDescription : ce champ est utilisé pour le compte administratif. Il peut également être utilisé au BP/BS/DM pour présenter les informations du compte administratif de l'année précédente","description_en":"Amount remaining to be realized for the fiscal year."},{"name":"bgt_mtbudgprec","type":"int","label":null,"fill_pct":80.5,"filterable":true,"description":"Montant du budget précédent\nDescription : montant prévu lors de l'exercice précédent. Ce champ permet de voir l'évolution des montants entre le budget prévisionnel (BP), les décisions modificatives et le compte administratif qui consacre la réalité des montants effectivement engagés (payés ou reçus).","description_en":"Budgeted amount from the previous fiscal exercise."},{"name":"bgt_mtrarprec","type":"double","label":null,"fill_pct":51.3,"filterable":true,"description":"Montant restant à réaliser N-1.\nDescription : ce champ est uniquement rempli au BP/BS/DM en cas de reprise des résultats de l’exercice précédent. Ce champ est rempli au CA pour présenter les restes à réaliser de l’exercice précédent.","description_en":"Amount remaining to be realized from the previous year."},{"name":"bgt_mtpropnouv","type":"int","label":null,"fill_pct":51.3,"filterable":true,"description":"Montant \"Propositions nouvelles\" \nDescription : montant des recettes ou dépenses nouvelles c'est-à-dire non prévues dans l'étape budgétaire précédente.","description_en":"Amount of new proposed revenues or expenditures not previously budgeted."},{"name":"bgt_mtprev","type":"int","label":null,"fill_pct":100,"filterable":true,"description":"Montant budget voté \nDescription : en présence d'un champ MtPrev, celui-ci doit obligatoirement être valorisée soit du montant prévu soit d'un montant égal à zéro","description_en":"Amount of the voted budget for this line."},{"name":"gid","type":"int","label":null,"fill_pct":51.3,"filterable":true,"description":null,"description_en":"Internal record identifier."},{"name":"gda_source","type":"text","label":null,"fill_pct":51.3,"filterable":true,"description":null,"description_en":"Source system from which the data originates."},{"name":"entjur_code","type":"int","label":null,"fill_pct":51.3,"filterable":true,"description":null,"description_en":"Code identifying the legal entity."},{"name":"cdate","type":"text","label":null,"fill_pct":51.3,"filterable":true,"description":null,"description_en":"Date the record was created."},{"name":"mdate","type":"text","label":null,"fill_pct":51.3,"filterable":true,"description":null,"description_en":"Date the record was last modified."}],"field_count":26,"sample_records":[{"gid":71288,"cdate":"2022-01-01T01:00:00+01:00","mdate":"2025-06-17T08:00:04+02:00","bgt_nom":"Budget principal CCAS","bgt_annee":"2022","bgt_codrd":"Recettes","bgt_siret":26330062600482,"bgt_artspe":"non spécialisé","bgt_mtprev":0,"bgt_mtreal":2407761.5,"bgt_natdec":"Compte Administratif","bgt_nature":"2138","bgt_opbudg":"Ordre","gda_source":"SIFBORCCAS","bgt_contnat":"040","bgt_credouv":0,"bgt_section":"Investissement","entjur_code":2,"bgt_fonction":"01","bgt_mtrar3112":0,"bgt_mtrarprec":0,"bgt_mtbudgprec":0,"bgt_mtpropnouv":0,"bgt_nature_label":"Autres constructions","bgt_contnat_label":"Opérations d'ordre de transfert entre sections","bgt_fonction_label":"Opérations non ventilables"},{"gid":71483,"cdate":"2022-01-01T01:00:00+01:00","mdate":"2025-06-17T08:00:04+02:00","bgt_nom":"Budget principal CCAS","bgt_annee":"2022","bgt_codrd":"Dépenses","bgt_siret":26330062600482,"bgt_artspe":"non spécialisé","bgt_mtprev":0,"bgt_mtreal":5327438.29,"bgt_natdec":"Compte Administratif","bgt_nature":"6761","bgt_opbudg":"Ordre","gda_source":"SIFBORCCAS","bgt_contnat":"042","bgt_credouv":0,"bgt_section":"Fonctionnement","entjur_code":2,"bgt_fonction":"01","bgt_mtrar3112":0,"bgt_mtrarprec":0,"bgt_mtbudgprec":0,"bgt_mtpropnouv":0,"bgt_nature_label":"Différences sur réalisations (positives) transférées en investissement","bgt_contnat_label":"Opérations d'ordre de transfert entre sections","bgt_fonction_label":"Opérations non ventilables"},{"gid":70819,"cdate":"2022-01-01T01:00:00+01:00","mdate":"2025-06-17T08:00:04+02:00","bgt_nom":"Budget principal CCAS","bgt_annee":"2022","bgt_codrd":"Dépenses","bgt_siret":26330062600482,"bgt_artspe":"non spécialisé","bgt_mtprev":0,"bgt_mtreal":17995.89,"bgt_natdec":"Compte Administratif","bgt_nature":"6247","bgt_opbudg":"Réel","gda_source":"SIFBORCCAS","bgt_contnat":"011","bgt_credouv":20700,"bgt_section":"Fonctionnement","entjur_code":2,"bgt_fonction":"02","bgt_mtrar3112":0,"bgt_mtrarprec":0,"bgt_mtbudgprec":0,"bgt_mtpropnouv":0,"bgt_nature_label":"Transports collectifs","bgt_contnat_label":"Charges à caractère général","bgt_fonction_label":"Administration générale du C.C.A.S."},{"gid":70921,"cdate":"2022-01-01T01:00:00+01:00","mdate":"2025-06-17T08:00:04+02:00","bgt_nom":"Budget principal CCAS","bgt_annee":"2022","bgt_codrd":"Recettes","bgt_siret":26330062600482,"bgt_artspe":"non spécialisé","bgt_mtprev":0,"bgt_mtreal":28642.05,"bgt_natdec":"Compte Administratif","bgt_nature":"6419","bgt_opbudg":"Réel","gda_source":"SIFBORCCAS","bgt_contnat":"013","bgt_credouv":25350,"bgt_section":"Fonctionnement","entjur_code":2,"bgt_fonction":"02","bgt_mtrar3112":0,"bgt_mtrarprec":0,"bgt_mtbudgprec":0,"bgt_mtpropnouv":0,"bgt_nature_label":"Remboursements sur rémunérations du personnel","bgt_contnat_label":"Atténuations de charges","bgt_fonction_label":"Administration générale du C.C.A.S."},{"gid":null,"cdate":null,"mdate":null,"bgt_nom":"Ctre accueil accomp. CAAF","bgt_annee":"2022","bgt_codrd":"Dépense","bgt_siret":26330062600300,"bgt_artspe":null,"bgt_mtprev":0,"bgt_mtreal":0,"bgt_natdec":null,"bgt_nature":"65","bgt_opbudg":"Réel","gda_source":null,"bgt_contnat":"6571","bgt_credouv":0,"bgt_section":"Fonctionnement","entjur_code":null,"bgt_fonction":"Pas de fonction en M22","bgt_mtrar3112":null,"bgt_mtrarprec":null,"bgt_mtbudgprec":null,"bgt_mtpropnouv":null,"bgt_nature_label":"GROUPE III DEPENSES - Dépenses afférentes à la structure","bgt_contnat_label":"Subventions - Subventions aux associations participant à la vie sociale des usagers","bgt_fonction_label":"Pas de fonction en M22"}],"record_count":"374","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/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_ccas_compte_administratif_2022/records?select=bgt_nom%2Cbgt_siret%2Cbgt_annee&where=bgt_nom+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/records?select=bgt_nom%2Cbgt_siret%2Cbgt_annee&where=bgt_nom+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (bgt_nom, bgt_siret, bgt_annee) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_compte_administratif_2022/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-10-22T12:29:03.236Z","run_id":"a65ff172-9304-461e-8ad9-beeee6afbd85","created_at":"2026-07-26T04:23:47.046Z","updated_at":"2026-10-22T12:29:03.236Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2014/05/Licence_Ouverte.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"none","basis":"no_person_column_cited","grain":"none","allowed":true,"columns":{"direct_identifiers":[],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":[],"entity_identifiers":["bgt_siret"]},"publication":null,"publication_evidence":null,"notice":"personal data: no cited column names a natural person (the cited columns are all this reads)"}},"datasets":[],"limits":[{"id":"6862563d-cc00-49b7-a251-156277eecbf9","entry_id":"38c782de-1156-4636-97f5-66cc744562d5","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-10-22T12:29:04.667Z"}],"source_access":{"status":"accessed_despite_disallow","host":"opendata.bordeaux-metropole.fr","requested_path_prefix":"/api/explore/v2.1/catalog/datasets/","robots_url":"https://opendata.bordeaux-metropole.fr/robots.txt","user_agent_group":"*","robots_rule":"Disallow: /api/","robots_read_at":"2026-08-25T11:29:13.017Z","decision_ref":"owner decision 2026-08-22, recorded in docs/PROGRESS.md NEEDS-HUMAN: public-sector open-data portals whose purpose is machine access; the directive is an Opendatasoft vendor default reflecting no publisher intent. Concern raised and overruled; see the row.","note":"This answer is derived from a host whose robots.txt DISALLOWS the path Commodity requests, and Commodity requests it anyway under the decision named in `decision_ref`. The rule is quoted verbatim so you can read it yourself. Commodity does not send a user-agent it is not, so any `Allow` granted to a named crawler in that file is not claimed here."},"field_provenance_source_access":{"status":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THIS PLATFORM’S READING OF ITS OWN CONDUCT: that it requests a path this host forbids. No publisher asserts it and none was asked to","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"host":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"the host Commodity addressed, lowercased and stripped of scheme and port by this platform so that one host has one row and one reading","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"requested_path_prefix":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"THE PATH THE VERDICT IS ABOUT, derived from the base URLs this platform stores for the host — not `/`, and not an assumed `/api/`. A verdict about a path we do not call would describe someone else’s traffic","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_url":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"where the file was fetched from — composed by this platform from the host, at the one location the protocol fixes, so it can be re-fetched and the reading disputed","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"user_agent_group":{"basis":"stored_sample","derived":false,"upstream_field":"the `User-agent` line the deciding rule sits under","transform":"the group heading that made the rule OURS, verbatim from the stored file. Where it is `*` the directive addresses everyone; a group naming another crawler was not applied, because Commodity does not send a user-agent it is not","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_rule":{"basis":"stored_sample","derived":false,"upstream_field":"the directive line of the matching group","transform":"THE PUBLISHER’S OWN LINE, QUOTED AND UNCUT, as read from robots.txt at the moment below and stored — not fetched for this request, and not part of this response’s payload. It is here so the verdict beside it can be checked rather than taken from us","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"robots_read_at":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"OUR CLOCK when the file was read, never a `Date` header the origin sent. It bounds how stale this reading may be: a publisher can have changed the file since","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"decision_ref":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"WHO DECIDED TO CALL IT ANYWAY, AND WHEN. Recorded by this platform and required by the database before the exception may exist at all, so it can never be anonymous","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}},"note":{"basis":"platform_computed","derived":true,"upstream_field":null,"transform":"this platform’s sentence explaining what the reader is holding. Written here, by us, and not a quotation of anybody","cells":{"rows":1,"delivered":1,"empty":0,"stringified":0,"truncated":0}}},"manifest":{"answer_sha256":"53dc2726bb2b16ba3e1609abe1c30ce5274929236af6a203a65e0374732fac5a","answer_sha256_rule":"sha256 (hex, UTF-8) of JSON.stringify(this body) after deleting the keys listed in manifest.stamped_keys from manifest, and deleting manifest itself if it is then empty. The hash was computed before the stamp existed, so no field of the stamp is inside it.","stamped_keys":["answer_sha256","answer_sha256_rule","stamped_keys","row_count","row_count_basis","live","live_basis","created_at","created_at_basis","durable_citation"],"row_count":47,"row_count_basis":"Objects that are elements of a JSON array anywhere in this body, excluding manifest. Not a claim about which collection is the answer. Largest single collection: data_profile.fields[] (26 rows).","live":true,"live_basis":"This body was produced by executing the request.","created_at":"2026-10-23T23:54:25.137Z","created_at_basis":"When this response body was assembled, deliberately OUTSIDE the hashed bytes so the same answer hashes identically on every request. Not the upstream read time — that is provenance[].retrieved_at. A zone-cached replay carries the assembly time, not your receipt time.","durable_citation":"This manifest is produced at response time and is NOT stored. A durable, replayable citation is persisted only on an explicit cite: GET /api/v1/entries/{id-or-slug}/evidence, or the MCP cite_query tool. Both are entry-scoped, because evidence_manifests is entry-shaped; a domain answer spanning several sources has no single entry and cannot be persisted through that path."}}