{"id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","type":"API","name":"Marchés Publics du CCAS de Bordeaux - de 2018 à 2024","slug":"marches-publics-du-ccas-de-bordeaux-de-2018-a-2024","description":"Liste des marchés publics du CCAS de la ville de Bordeaux depuis 2018.","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_marchespublics/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_marchespublics/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":[],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_marchespublics/","extraction_confidence":"0.00","created_at":"2026-07-25T20:01:43.828Z","updated_at":"2026-09-08T18:26:53.942Z","last_verified_at":"2026-09-08T15:05:39.942Z","deprecated_at":null,"ranking_score":51,"last_ranked_at":"2026-08-28T22:39:51.020Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-09-08T05:42:32.002Z","search_vector":"'2018':8A,18A,33B,58B,132A,142A,157B,182B '2024':10A,20A,134A,144A 'a':133A,161B 'access':74B,198B 'action':50B,97B,174B,221B 'activ':91B 'activity':215B 'administr':124B 'administration':248B 'analysi':114B 'analysis':238B 'and':195B,234B,237B 'api':35B,159B 'as':186B 'authent':76B 'authentication':200B 'award':43B,106B 'awarded':167B 'awards':230B 'be':225B 'bordeaux':6A,16A,31B,56B,66B,120B,130A,140A,155B,180B,190B,244B 'by':168B,217B 'can':224B 'ccas':4A,17A,26B,46B,128A,141A,150B,170B 'center':98B,222B 'centr':47B 'centre':171B 'citi':54B 'city':178B 'communal':48B,172B 'contract':13A,42B,80B,105B,229B 'contracts':137A,166B,204B 'cover':79B 'covers':203B 'd':49B,173B 'data':69B,193B 'dataset':78B,202B 'de':5A,7A,27B,30B,129A,131A,151B,154B 'depui':32B 'depuis':156B 'des':22B,146B 'du':3A,25B,127A,149B 'focus':87B 'focusing':211B 'franc':86B 'france':210B 'free':73B,197B 'is':184B 'it':183B,223B 'la':28B,152B 'list':21B,38B,162B 'liste':145B 'manag':92B 'managed':216B 'marches':125A,147B 'marché':1A,23B 'metropole':191B 'monitor':107B,231B 'municip':95B 'municipal':219B 'métropol':67B 'nation':83B 'national':207B 'of':138A,163B,176B,179B,188B,209B,239B 'offer':72B 'offers':196B 'on':212B 'open':68B,192B 'part':63B,187B 'portal':70B,194B 'practic':117B 'practices':241B 'procur':12A,41B,90B,116B 'procurement':136A,165B,214B,240B 'provid':36B 'provides':160B 'public':2A,11A,24B,40B,89B,108B,135A,164B,213B,232B 'publics':126A,148B 'publish':61B 'published':185B 'relat':118B 'related':242B 's':245B 'scope':84B,208B 'servic':123B 'services':247B 'sinc':57B 'since':181B 'social':51B,96B,122B,220B,246B 'sociale':175B 'spend':109B 'spending':233B 'support':111B,235B 'the':139A,169B,177B,189B,201B,206B,218B 'this':158B 'to':143A,227B,243B 'track':104B,228B 'transpar':112B 'transparency':236B 'use':102B 'used':226B 'vill':29B 'ville':153B 'within':81B,205B 'without':75B,199B 'à':9A","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-27T09:05:00.000Z","geographic_scope":"NATIONAL","name_en":"Public Procurement Contracts of the Bordeaux CCAS - 2018 to 2024","description_en":"This API provides a list of public procurement contracts awarded by the CCAS (Centre Communal d'Action Sociale) of the city of Bordeaux since 2018. It is published as part of the Bordeaux Métropole open data portal and offers free access without authentication. The dataset covers contracts within the national scope of France, focusing on public procurement activity managed by the municipal social action center. It can be used to track contract awards, monitor public spending, and support transparency and analysis of procurement practices related to Bordeaux's social services administration.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":38.75,"merged_into_entry_id":null,"identity_key":"API|https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_marchespublics|marchés publics du ccas de bordeaux - de 2018 à 2024","upstream_ref":"opendata.bordeaux-metropole.fr:dataset:bor_ccas_marchespublics","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_marchespublics/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_marchespublics/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_marchespublics/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_marchespublics/records?select=id%2Cnature%2Ctypecontrat&where=id+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_marchespublics","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/bor_ccas_marchespublics/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","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":"executable","level_index":4,"level_label":"Executable","meaning":"Queries run through Commodity","counts_as_coverage":true,"blocked_by":null,"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":true,"reached":true,"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":true,"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":true,"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":false,"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-09-09T05:31:20.694Z"},"api_details":{"id":"9837db7b-f1b4-41b0-ab82-ca635f54eb01","entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics","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_marchespublics","created_at":"2026-07-25T20:01:44.068Z","updated_at":"2026-07-25T20:01:44.068Z"},"dataset_details":{"id":"602d6009-da19-4039-a592-f256d5ebd18e","entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","upstream_issued":null,"upstream_modified":"2024-06-25T13:06:21.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-25T23:09:09.814Z","updated_at":"2026-09-02T19:48:36.608Z","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":"e146542b-3ec8-4514-9bc4-5c48bad47c22","entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","status":"VERIFIED","last_checked_at":"2026-09-08T15:05:39.671Z","p50_latency_ms":1332,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-25T21:25:23.529Z","updated_at":"2026-09-08T15:05:39.671Z","consecutive_successes":9,"probe_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-09-08T15:05:39.671Z"},"data_profile":{"id":"3d87d3bb-90e2-4fb5-a3f8-585833c2dfff","entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"bor_ccas_marchespublics","fields":[{"name":"id","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Numéro d'identification unique du contrat","description_en":"Unique identification number of the contract."},{"name":"nature","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Nature du contrat : marché / accord-cadre / marché subséquent (à un accord-cadre) / marché de partenariat","description_en":"Type of contract: market, framework agreement, subsequent contract, or partnership."},{"name":"typecontrat","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"","description_en":"Category of contract, e.g. public procurement contract."},{"name":"objet","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Objet du marché décrit de manière synthétique","description_en":"Brief description of the subject matter of the contract."},{"name":"codecpv","type":"int","label":null,"fill_pct":100,"filterable":true,"description":"Nomenclature permettant d'identifier l'objet du marché de manière uniforme à l'échelle européenne","description_en":"European Common Procurement Vocabulary code identifying the contract's subject."},{"name":"procedure","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Procédure de passation adoptée : procédure adaptée / appel d’offres ouvert / appel d’offres restreint / procédure avec négociation / dialogue compétitif / marché public passé sans publicité ni mise en concurrence préalable","description_en":"Award procedure used, such as open or restricted tendering."},{"name":"dureemois","type":"int","label":null,"fill_pct":100,"filterable":true,"description":"Durée maximale du marché en mois","description_en":"Maximum duration of the contract, in months."},{"name":"datenotification","type":"date","label":null,"fill_pct":100,"filterable":true,"description":"Date de notification du marché","description_en":"Date the contract was notified to the awarded party."},{"name":"datepublicationdonnees","type":"date","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Date the contract data was published."},{"name":"montant","type":"double","label":null,"fill_pct":77.4,"filterable":true,"description":"Montant maximal du marché, hors taxes, sur toute la durée, toutes phases et toutes tranches confondues, toutes reconductions possibles incluses","description_en":"Maximum total contract value excluding tax, over its full duration."},{"name":"formeprix","type":"text","label":null,"fill_pct":100,"filterable":true,"description":"Forme du prix : ferme / ferme et actualisable / révisable","description_en":"Pricing structure: fixed, fixed and adjustable, or revisable."},{"name":"acheteur_nom","type":"text","label":"acheteur","fill_pct":100,"filterable":true,"description":null,"description_en":"Name of the public buyer awarding the contract."},{"name":"lieuexecution_nom","type":"text","label":"lieuExecution","fill_pct":100,"filterable":true,"description":null,"description_en":"Place where the contract is executed."},{"name":"titulaires_titulaire_denominationsociale","type":"text","label":"titulaire_denominationsociale","fill_pct":100,"filterable":true,"description":"Nom du ou des titulaire.s du marché","description_en":"Name(s) of the company or companies awarded the contract."},{"name":"titulaires_titulaire_id","type":"text","label":"titulaire_id","fill_pct":100,"filterable":true,"description":"Identification du ou des titulaire.s du marché : numéro SIRET ou numéro de TVA intracommunautaire","description_en":"Identifier(s) of the contract holder(s), such as SIRET or VAT number."},{"name":"objetmodifications","type":"text","label":null,"fill_pct":6.5,"filterable":true,"description":"Modification.s apportée.s au marché en cours d'exécution","description_en":"Description of modifications made during contract execution."},{"name":"datesignaturemodifications","type":"text","label":null,"fill_pct":6.5,"filterable":true,"description":null,"description_en":"Date(s) when contract modifications were signed."},{"name":"montantmodifications","type":"double","label":null,"fill_pct":0,"filterable":true,"description":null,"description_en":"Monetary value of the modifications made to the contract."},{"name":"datepublicationdonneesmodifications","type":"text","label":null,"fill_pct":0,"filterable":true,"description":null,"description_en":"Date the modification data was published."}],"field_count":19,"sample_records":[{"id":"20212021S0000100","objet":"La prestation porte sur la production et livraison de repas sur sept (7) jours, y compris les jours fériés (365 jours/an), avec la location de deux (2) fours, d'armoires froides positive et négative et d'une banque de service pour le Centre Simone Noaille","nature":"Accord-cadre","codecpv":55521200,"montant":1200000,"dureemois":48,"formeprix":"Révisable","procedure":"Procédure adaptée","typecontrat":"MARCHE_PUBLIC","acheteur_nom":"Centre communal d'action sociale de Bordeaux","datenotification":"2021-01-06","lieuexecution_nom":"(33) Gironde","objetmodifications":null,"montantmodifications":null,"datepublicationdonnees":"2021-01-06","titulaires_titulaire_id":"33415947200458","datesignaturemodifications":null,"datepublicationdonneesmodifications":null,"titulaires_titulaire_denominationsociale":"ANSAMBLE"},{"id":"20182018S0000500","objet":"Prestations d'activités physiques adaptées pour les résidences-autonomie gérés par le CCAS de la ville de Bordeaux - Lot 4 : Résidences autonomie Bonnefin, Notre Temps, Alsace Lorraine et Reinette","nature":"Accord-cadre","codecpv":92600000,"montant":null,"dureemois":36,"formeprix":"Révisable","procedure":"Procédure adaptée","typecontrat":"MARCHE_PUBLIC","acheteur_nom":"CCAS de Bordeaux","datenotification":"2018-11-05","lieuexecution_nom":"(33) Gironde","objetmodifications":null,"montantmodifications":null,"datepublicationdonnees":"2018-11-05","titulaires_titulaire_id":"53488856500023","datesignaturemodifications":null,"datepublicationdonneesmodifications":null,"titulaires_titulaire_denominationsociale":"GROUPEMENT D'EMPLOYEURS ACTIVITE PHYSIQUE ADAPTEE-SANTE-NUTRITION"},{"id":"20202020S0000200","objet":"Installation et maintenance de dispositifs de téléassistance pour les personnes résidant dans les Résidences Autonomie gérés par le C.C.A.S. de la Ville de Bordeaux incluant un abonnement une centrale 24h/24, 7j/7","nature":"Accord-cadre","codecpv":64200000,"montant":200000,"dureemois":48,"formeprix":"Ferme","procedure":"Appel d'offres ouvert","typecontrat":"MARCHE_PUBLIC","acheteur_nom":"CCAS de Bordeaux","datenotification":"2020-12-02","lieuexecution_nom":"(33) Gironde","objetmodifications":null,"montantmodifications":null,"datepublicationdonnees":"2020-12-02","titulaires_titulaire_id":"79375991100019","datesignaturemodifications":null,"datepublicationdonneesmodifications":null,"titulaires_titulaire_denominationsociale":"SECURITAS TELEASSISTANCE"},{"id":"20182018S0000400","objet":"Prestations d'activités physiques adaptées pour les résidences-autonomie gérés par le CCAS de la ville de Bordeaux - Lot 3 : Résidences autonomie Dubourdieu, Magendie, Buchou et Billaudel","nature":"Accord-cadre","codecpv":92600000,"montant":null,"dureemois":36,"formeprix":"Révisable","procedure":"Procédure adaptée","typecontrat":"MARCHE_PUBLIC","acheteur_nom":"CCAS de Bordeaux","datenotification":"2018-11-05","lieuexecution_nom":"(33) Gironde","objetmodifications":null,"montantmodifications":null,"datepublicationdonnees":"2018-11-05","titulaires_titulaire_id":"53488856500023","datesignaturemodifications":null,"datepublicationdonneesmodifications":null,"titulaires_titulaire_denominationsociale":"GROUPEMENT D'EMPLOYEURS ACTIVITE PHYSIQUE ADAPTEE-SANTE-NUTRITION"},{"id":"20182018S0000200","objet":"Prestations d'activités physiques adaptées pour les résidences-autonomie gérés par le CCAS de la ville de Bordeaux - Résidences autonomie La Lumineuse, Achard, Chantecrit et Maryse Bastié","nature":"Accord-cadre","codecpv":92600000,"montant":null,"dureemois":36,"formeprix":"Révisable","procedure":"Procédure adaptée","typecontrat":"MARCHE_PUBLIC","acheteur_nom":"CCAS de Bordeaux","datenotification":"2018-11-05","lieuexecution_nom":"(33) Gironde","objetmodifications":null,"montantmodifications":null,"datepublicationdonnees":"2018-11-05","titulaires_titulaire_id":"53488856500023","datesignaturemodifications":null,"datepublicationdonneesmodifications":null,"titulaires_titulaire_denominationsociale":"GROUPEMENT D'EMPLOYEURS ACTIVITE PHYSIQUE ADAPTEE-SANTE-NUTRITION"}],"record_count":"31","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics/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_marchespublics/records?select=id%2Cnature%2Ctypecontrat&where=id+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics/records?select=id%2Cnature%2Ctypecontrat&where=id+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (id, nature, typecontrat) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/bor_ccas_marchespublics/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-09-02T19:48:35.266Z","run_id":"c3924f62-8398-43ef-ba4d-e077ed70eb93","created_at":"2026-07-25T23:09:09.319Z","updated_at":"2026-09-02T19:48:35.266Z","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":["montant","montantmodifications"],"entity_identifiers":[]},"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":"7b6f5557-eae3-455e-a916-88e047e007a6","entry_id":"eec419c7-26ec-4d6e-960b-aa9387fbf4f7","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-09-02T19:48:36.782Z"}],"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":"d6957772d4f3d5231ba37a5d92620e54f349d993fe3ca924bb210098af22db61","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":40,"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[] (19 rows).","live":false,"live_basis":"This body was replayed from the worker edge cache (x-edge-cache: hit); the bytes, and therefore answer_sha256, are those of the execution that filled the cache.","created_at":"2026-09-09T05:33:27.265Z","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."}}