{"id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","type":"API","name":"Etablissements du domaine sanitaire et social - Bordeaux Métropole","slug":"etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","description":"Liste des établissements du domaine sanitaire et social sur le territoire de Bordeaux Métropole. Enrichissement Normalisation des systèmes de projection des coordonnés Ajout de l'epci/commune/région à partir du code INSEE de la commune Vous pouvez retrouver une version historisée de la liste des...","free_access_class":"FREE_NO_AUTH","auth_type":"NONE","homepage_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/","docs_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/","repo_url":null,"status":"ACTIVE","verification_state":"VERIFIED","tags":["health"],"logo_url":"https://opendata.bordeaux-metropole.fr/assets/favicon?tstamp=174885191012131","primary_source_url":"https://opendata.bordeaux-metropole.fr/explore/dataset/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/","extraction_confidence":"0.00","created_at":"2026-07-25T15:47:57.519Z","updated_at":"2026-10-23T01:53:44.267Z","last_verified_at":"2026-10-23T01:29:43.912Z","deprecated_at":null,"ranking_score":54,"last_ranked_at":"2026-10-18T01:08:34.381Z","last_seen_at":null,"last_validated_at":null,"last_uptime_at":"2026-10-15T05:30:33.875Z","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-26T14:02:00.000Z","geographic_scope":"NATIONAL","name_en":"Health and Social Care Establishments - Bordeaux Métropole","description_en":"This API provides a list of health and social care establishments located within the territory of Bordeaux Métropole, France. It is published as part of the Bordeaux Métropole open data portal. The dataset includes normalized geographic coordinate projections and adds administrative context such as EPCI, commune, and region, derived from the INSEE commune code of each establishment. A historized version of the establishment list is also referenced, allowing tracking of changes over time. The data is freely accessible without authentication and is useful for mapping and analyzing local health and social service provision.","native_lang":"fr","access_level":"direct","formats":["CSV"],"capability_tier":"live","trust_score":42.25,"merged_into_entry_id":null,"identity_key":"API|https://opendata.bordeaux-metropole.fr/explore/dataset/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole|etablissements du domaine sanitaire et social - bordeaux métropole","upstream_ref":"opendata.bordeaux-metropole.fr:dataset:etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","content_changed_at":"2026-10-15T20:38:48.606Z","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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/records?select=nofinesset%2Cnofinessej%2Crs&where=nofinesset+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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","source":"probe","runnable":true},{"kind":"landing","label":"Read the docs","method":"GET","url":"https://opendata.bordeaux-metropole.fr/explore/dataset/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/","source":"docs","runnable":false}],"formats":["CSV"]},"maturity":{"entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","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":"joinable","level_index":5,"level_label":"Joinable","meaning":"Canonical identifiers and concepts mapped","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":true,"reached":true,"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-24T07:15:50.208Z"},"api_details":{"id":"2f2c74e7-8eab-4356-8acf-33baf59ef45a","entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","base_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","created_at":"2026-07-25T15:47:57.678Z","updated_at":"2026-07-25T15:47:57.678Z"},"dataset_details":{"id":"852df0ba-6acc-4067-b3d6-9deea26aaa55","entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","upstream_issued":null,"upstream_modified":"2026-10-10T04:30:03.000Z","themes":[],"update_frequency":"monthly","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-26T06:30:05.594Z","updated_at":"2026-10-22T21:00:57.039Z","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/2018/11/open-licence.pdf","latest_check":{"id":"eb1a5055-a7b9-422f-943c-82316acc45ac","entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","status":"VERIFIED","last_checked_at":"2026-10-23T01:29:43.676Z","p50_latency_ms":1680,"p95_latency_ms":null,"last_error":null,"consecutive_failures":0,"created_at":"2026-07-26T03:24:06.373Z","updated_at":"2026-10-23T01:29:43.676Z","consecutive_successes":20,"probe_url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","probe_method":"GET","probe_http_status":200,"probe_content_type":"application/json; charset=utf-8","probe_succeeded_at":"2026-10-23T01:29:43.676Z"},"data_profile":{"id":"a477d782-c540-4e2f-8f54-fac17a5566c1","entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","profile_source":"opendatasoft","profile_kind":"dataset","dataset_id":"etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole","fields":[{"name":"nofinesset","type":"text","label":"Numéro FINESS ET","fill_pct":100,"filterable":true,"description":null,"description_en":"FINESS identifier of the facility's geographical establishment."},{"name":"nofinessej","type":"text","label":"Numéro FINESS EJ","fill_pct":100,"filterable":true,"description":null,"description_en":"FINESS identifier of the facility's legal entity."},{"name":"rs","type":"text","label":"Raison sociale","fill_pct":100,"filterable":true,"description":null,"description_en":"Short official name of the establishment."},{"name":"rslongue","type":"text","label":"Raison sociale longue","fill_pct":88.6,"filterable":true,"description":null,"description_en":"Full official name of the establishment."},{"name":"complrs","type":"text","label":"Complément de raison sociale","fill_pct":7.2,"filterable":true,"description":null,"description_en":"Additional information for the establishment's name."},{"name":"compldistrib","type":"text","label":"Complément de distribution","fill_pct":8.5,"filterable":true,"description":null,"description_en":"Additional address distribution detail, such as a building name."},{"name":"numvoie","type":"int","label":"Numéro de voie","fill_pct":91.6,"filterable":true,"description":null,"description_en":"House or building number in the street address."},{"name":"typvoie","type":"text","label":"Type de voie","fill_pct":98.4,"filterable":true,"description":null,"description_en":"Abbreviation for the type of street (e.g. street, avenue)."},{"name":"voie","type":"text","label":"Libellé de voie","fill_pct":99.3,"filterable":true,"description":null,"description_en":"Name of the street."},{"name":"compvoie","type":"text","label":"Complément de voie","fill_pct":2.5,"filterable":true,"description":null,"description_en":"Additional complement to the street address."},{"name":"lieuditbp","type":"text","label":null,"fill_pct":6.5,"filterable":true,"description":null,"description_en":"Locality or PO box information for the address."},{"name":"commune","type":"text","label":"Code commune (sans le département)","fill_pct":100,"filterable":true,"description":null,"description_en":"Municipality code without the department prefix."},{"name":"com_code","type":"text","label":"Code Commune","fill_pct":100,"filterable":true,"description":null,"description_en":"Full official INSEE code of the municipality."},{"name":"dep_code","type":"text","label":"Département","fill_pct":100,"filterable":true,"description":null,"description_en":"Code of the department."},{"name":"dep_name","type":"text","label":"Libellé département","fill_pct":100,"filterable":true,"description":null,"description_en":"Name of the department."},{"name":"ligneacheminement","type":"text","label":"Ligne d’acheminement","fill_pct":100,"filterable":true,"description":"(CodePostal+Lib commune)","description_en":"Postal code and municipality name used for mail routing."},{"name":"telephone","type":"text","label":"Téléphone","fill_pct":91.8,"filterable":true,"description":null,"description_en":"Telephone number of the establishment."},{"name":"telecopie","type":"text","label":"Télécopie","fill_pct":47.1,"filterable":true,"description":null,"description_en":"Fax number of the establishment."},{"name":"categetab","type":"int","label":"Catégorie d’établissement","fill_pct":100,"filterable":true,"description":null,"description_en":"Numeric code identifying the establishment category."},{"name":"libcategetab","type":"text","label":"Libellé catégorie d’établissement","fill_pct":100,"filterable":true,"description":null,"description_en":"Label describing the establishment category."},{"name":"categagretab","type":"text","label":"Catégorie d’agrégat d’établissement","fill_pct":100,"filterable":true,"description":null,"description_en":"Code of the establishment's aggregate category."},{"name":"libcategagretab","type":"text","label":"Libellé catégorie d’agrégat d’établissement","fill_pct":100,"filterable":true,"description":null,"description_en":"Label describing the establishment's aggregate category."},{"name":"siret","type":"text","label":"Numéro de SIRET","fill_pct":92.9,"filterable":true,"description":null,"description_en":"SIRET identifier of the establishment."},{"name":"codeape","type":"text","label":null,"fill_pct":44.8,"filterable":true,"description":null,"description_en":"APE/NAF code indicating the establishment's main economic activity."},{"name":"codemft","type":"text","label":null,"fill_pct":100,"filterable":true,"description":null,"description_en":"Code for the establishment's pricing/rate regime (MFT)."},{"name":"libmft","type":"text","label":"Libellé MFT","fill_pct":100,"filterable":true,"description":null,"description_en":"Label describing the establishment's pricing regime."},{"name":"codesph","type":"int","label":null,"fill_pct":12.6,"filterable":true,"description":null,"description_en":"Code for the establishment's public hospital service status."},{"name":"libsph","type":"text","label":"Libellé SPH","fill_pct":12.6,"filterable":true,"description":null,"description_en":"Label describing the public hospital service status."},{"name":"dateouv","type":"date","label":"Date d’ouverture","fill_pct":100,"filterable":true,"description":null,"description_en":"Date the establishment opened."},{"name":"dateautor","type":"date","label":"Date d’autorisation","fill_pct":99.6,"filterable":true,"description":null,"description_en":"Date the establishment was authorized."},{"name":"datemaj_structure","type":"date","label":"Date de mise à jour sur la structure","filterable":true,"description":null,"description_en":"Date the establishment's structural data was last updated."},{"name":"numuai","type":"text","label":"Numéro éducation nationale","filterable":true,"description":null,"description_en":"National education ministry identifier for the establishment."},{"name":"coordxet","type":"double","label":"Coordonnée X (projection source)","filterable":true,"description":null,"description_en":"X coordinate of the establishment in its source projection."},{"name":"coordyet","type":"double","label":"Coordonnée Y (projection source)","filterable":true,"description":null,"description_en":"Y coordinate of the establishment in its source projection."},{"name":"sourcecoordet","type":"text","label":"Source et projection des coordonnées","filterable":true,"description":null,"description_en":"Source and coordinate projection system used for the location."},{"name":"datemaj_geo","type":"date","label":"Date de mise à jour des coordonnées","filterable":true,"description":null,"description_en":"Date the establishment's geographic coordinates were last updated."},{"name":"address","type":"text","label":"Adresse","filterable":true,"description":null,"description_en":"Full postal address of the establishment."},{"name":"coord","type":"geo_point_2d","label":"Coordonnées géographiques","filterable":false,"description":null,"description_en":"Geographic coordinates (latitude and longitude) of the establishment."},{"name":"reg_code","type":"text","label":"Code Officiel Région","filterable":true,"description":null,"description_en":"Official code of the region."},{"name":"reg_name","type":"text","label":"Nom Officiel Région","filterable":true,"description":null,"description_en":"Official name of the region."},{"name":"epci_code","type":"text","label":"Code Officiel EPCI","fill_pct":100,"filterable":true,"description":null,"description_en":"Official code of the EPCI (intermunicipal body)."},{"name":"epci_name","type":"text","label":"Nom Officiel EPCI","fill_pct":100,"filterable":true,"description":null,"description_en":"Official name of the EPCI (intermunicipal body)."},{"name":"com_name","type":"text","label":"Nom Officiel Commune","fill_pct":100,"filterable":true,"description":null,"description_en":"Official name of the municipality."}],"field_count":43,"sample_records":[{"rs":"CMPP RIVE DROITE CENON","voie":"PASTEUR","coord":{"lat":44.8514481,"lon":-0.5210794},"siret":"78196349100100","libmft":"DGS ARS & hébergement PCD - sous CPOM","libsph":null,"numuai":"0332459U","address":"14 R PASTEUR","codeape":"8891B","codemft":"57","codesph":null,"commune":"119","complrs":null,"dateouv":"1971-09-15","numvoie":14,"typvoie":"R","com_code":"33119","com_name":"Cenon","compvoie":null,"coordxet":421897.6,"coordyet":6423121.3,"dep_code":"33","dep_name":"GIRONDE","reg_code":"75","reg_name":"Nouvelle-Aquitaine","rslongue":"CMPP RIVE DROITE CENON","categetab":189,"dateautor":"2017-01-03","epci_code":"243300316","epci_name":"Bordeaux Métropole","lieuditbp":null,"telecopie":"0556863674","telephone":"0556862645","nofinessej":"330791625","nofinesset":"330780610","datemaj_geo":"2026-05-04","categagretab":"4106","compldistrib":null,"libcategetab":"Centre Médico-Psycho-Pédagogique (C.M.P.P.)","sourcecoordet":"1,ATLASANTE,97,BAN,EPSG:2154 RGF93 / Lambert-93 (Métropole)","libcategagretab":"Services à Domicile ou Ambulatoires pour Handicapés","datemaj_structure":"2024-01-29","ligneacheminement":"33150 CENON"},{"rs":"EEAP ARC EN CIEL","voie":"JEANNE CHANAY","coord":{"lat":44.7963754,"lon":-0.6226645},"siret":"77568873209765","libmft":"ARS dotation forfait ou prix de journée globalisé hors CPOM","libsph":null,"numuai":null,"address":"10 ALL JEANNE CHANAY","codeape":"8899B","codemft":"58","codesph":null,"commune":"318","complrs":null,"dateouv":"1904-04-04","numvoie":10,"typvoie":"ALL","com_code":"33318","com_name":"Pessac","compvoie":null,"coordxet":413599.2,"coordyet":6417373.7,"dep_code":"33","dep_name":"GIRONDE","reg_code":"75","reg_name":"Nouvelle-Aquitaine","rslongue":"ETABLISSEMENT ENFANTS POLYHANDICAPES ARC-EN-CIEL","categetab":188,"dateautor":"2017-01-03","epci_code":"243300316","epci_name":"Bordeaux Métropole","lieuditbp":null,"telecopie":"0556454179","telephone":"0556452692","nofinessej":"750719239","nofinesset":"330804444","datemaj_geo":"2026-05-04","categagretab":"4101","compldistrib":null,"libcategetab":"Etablissement pour Enfants ou Adolescents Polyhandicapés","sourcecoordet":"1,ATLASANTE,96,BAN,EPSG:2154 RGF93 / Lambert-93 (Métropole)","libcategagretab":"Etab.Educ.Spéciale pour Déficients Mentaux et Handicapés","datemaj_structure":"2024-11-21","ligneacheminement":"33600 PESSAC"},{"rs":"PHARMACIE  DE  LANGE","voie":"DU GENERAL DE GAULLE","coord":{"lat":44.7787296,"lon":-0.6098249},"siret":"84816394500019","libmft":"Etablissement Tarif Libre","libsph":null,"numuai":null,"address":"81 CRS DU GENERAL DE GAULLE","codeape":null,"codemft":"01","codesph":null,"commune":"192","complrs":null,"dateouv":"2023-10-01","numvoie":81,"typvoie":"CRS","com_code":"33192","com_name":"Gradignan","compvoie":null,"coordxet":414524,"coordyet":6415369.3,"dep_code":"33","dep_name":"GIRONDE","reg_code":"75","reg_name":"Nouvelle-Aquitaine","rslongue":"PHARMACIE  DE  LANGE","categetab":620,"dateautor":"2005-01-31","epci_code":"243300316","epci_name":"Bordeaux Métropole","lieuditbp":null,"telecopie":"0556891313","telephone":"0556891313","nofinessej":"330046616","nofinesset":"330046624","datemaj_geo":"2026-05-04","categagretab":"3201","compldistrib":null,"libcategetab":"Pharmacie d'Officine","sourcecoordet":"1,ATLASANTE,98,BAN,EPSG:2154 RGF93 / Lambert-93 (Métropole)","libcategagretab":"Commerce de Biens à Usage Médicaux","datemaj_structure":"2026-03-17","ligneacheminement":"33170 GRADIGNAN"},{"rs":"PHARMACIE DUBARRY","voie":"RICHELIEU","coord":{"lat":44.8397899,"lon":-0.568925},"siret":"43939556700019","libmft":"Etablissement Tarif Libre","libsph":null,"numuai":null,"address":"3 QU RICHELIEU","codeape":null,"codemft":"01","codesph":null,"commune":"063","complrs":null,"dateouv":"2005-05-17","numvoie":3,"typvoie":"QU","com_code":"33063","com_name":"Bordeaux","compvoie":null,"coordxet":418062.7,"coordyet":6421997.4,"dep_code":"33","dep_name":"GIRONDE","reg_code":"75","reg_name":"Nouvelle-Aquitaine","rslongue":"PHARMACIE DUBARRY","categetab":620,"dateautor":"1942-11-11","epci_code":"243300316","epci_name":"Bordeaux Métropole","lieuditbp":null,"telecopie":"0556900897","telephone":"0556909404","nofinessej":"330042185","nofinesset":"330042193","datemaj_geo":"2026-05-04","categagretab":"3201","compldistrib":null,"libcategetab":"Pharmacie d'Officine","sourcecoordet":"1,ATLASANTE,98,BAN,EPSG:2154 RGF93 / Lambert-93 (Métropole)","libcategagretab":"Commerce de Biens à Usage Médicaux","datemaj_structure":"2021-06-14","ligneacheminement":"33000 BORDEAUX"},{"rs":"EHPAD MAISON DE FONTAUDIN","voie":"JEANNE CHANAY","coord":{"lat":44.7980961,"lon":-0.6232932},"siret":"80826970800208","libmft":"ARS/PCD, Tarif partiel, habilité aide sociale sans PUI","libsph":null,"numuai":null,"address":"2 ALL JEANNE CHANAY","codeape":"8710A","codemft":"45","codesph":null,"commune":"318","complrs":null,"dateouv":"1993-02-01","numvoie":2,"typvoie":"ALL","com_code":"33318","com_name":"Pessac","compvoie":null,"coordxet":413558.3,"coordyet":6417566.9,"dep_code":"33","dep_name":"GIRONDE","reg_code":"75","reg_name":"Nouvelle-Aquitaine","rslongue":"EHPAD MAISON DE FONTAUDIN","categetab":500,"dateautor":"2017-01-03","epci_code":"243300316","epci_name":"Bordeaux Métropole","lieuditbp":null,"telecopie":"0556464030","telephone":"0556464570","nofinessej":"750057291","nofinesset":"330803669","datemaj_geo":"2026-05-04","categagretab":"4401","compldistrib":null,"libcategetab":"Etablissement d'hébergement pour personnes âgées dépendantes","sourcecoordet":"1,ATLASANTE,96,BAN,EPSG:2154 RGF93 / Lambert-93 (Métropole)","libcategagretab":"Etablissements d'Hébergement pour Personnes Âgées","datemaj_structure":"2024-05-28","ligneacheminement":"33600 PESSAC"}],"record_count":"1217","data_size_bytes":null,"dataset_count":null,"query_examples":[{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/records?limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/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/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/records?select=nofinesset%2Cnofinessej%2Crs&where=nofinesset+is+not+null&limit=20","curl":"curl -s 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/records?select=nofinesset%2Cnofinessej%2Crs&where=nofinesset+is+not+null&limit=20' -H 'Accept: application/json'","label":"Select & filter","method":"GET","description":"Project specific fields (nofinesset, nofinessej, rs) and filter with ODSQL where clauses."},{"url":"https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/exports/csv","curl":"curl -sL 'https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole/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-22T21:00:55.867Z","run_id":"71a7b8f7-2a4b-4957-baba-db2c865961d0","created_at":"2026-07-26T06:30:03.626Z","updated_at":"2026-10-22T21:00:55.867Z","license_raw":"https://www.etalab.gouv.fr/wp-content/uploads/2018/11/open-licence.pdf","license_id":"lo-2.0","consecutive_failure_count":0,"last_error_at":null,"last_error_message":null,"previewable":true,"personal_data":{"status":"identified_person","basis":"direct_identifier_cited","grain":"one_row_per_person","allowed":false,"columns":{"direct_identifiers":["telephone"],"family_names":[],"given_names":[],"attributes":[],"unresolved_names":[],"measures":[],"entity_identifiers":["siret"]},"publication":null,"publication_evidence":null,"notice":"personal data: a record about ONE IDENTIFIABLE PERSON; rows WITHHELD; columns — identifiers: telephone; names: none; names of an unstated subject: none; attributes: none; measures: none; entity keys: siret"}},"datasets":[],"limits":[{"id":"1d91672a-677e-42a6-b67f-0627e1fde788","entry_id":"6b3cdfb9-8a8f-42db-a3c7-a2a7ed4e2501","limit_type":"requests_per_day","value":"10000000","unit":"requests","period":"day","scope":"per-ip","source_id":null,"claim_type":"measured","confidence":"0.90","observed_at":"2026-10-22T21:00:57.361Z"}],"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":"79abbc349e5870bc768b0be88159f4ff556a363e8efe1714e6ead74bb21e21fe","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":64,"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[] (43 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-10-24T07:16:53.622Z","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."}}