Health and Social Care Establishments - Bordeaux MétropoleEtablissements du domaine sanitaire et social - Bordeaux Métropole
Etablissements du domaine sanitaire et social - Bordeaux MétropoleHealth and Social Care Establishments - Bordeaux Métropole
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.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...
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (43 fields)
Click a field to see example values.
| Fill | Field | Type | Description |
|---|---|---|---|
| 100% | nofinessetNuméro FINESS ET | text | FINESS identifier of the facility's geographical establishment.FINESS identifier of the facility's geographical establishment. |
| 100% | nofinessejNuméro FINESS EJ | text | FINESS identifier of the facility's legal entity.FINESS identifier of the facility's legal entity. |
| 100% | rsRaison sociale | text | Short official name of the establishment.Short official name of the establishment. |
| 88.6% | rslongueRaison sociale longue | text | Full official name of the establishment.Full official name of the establishment. |
| 7.2% | complrsComplément de raison sociale | text | Additional information for the establishment's name.Additional information for the establishment's name. |
| 8.5% | compldistribComplément de distribution | text | Additional address distribution detail, such as a building name.Additional address distribution detail, such as a building name. |
| 91.6% | numvoieNuméro de voie | int | House or building number in the street address.House or building number in the street address. |
| 98.4% | typvoieType de voie | text | Abbreviation for the type of street (e.g. street, avenue).Abbreviation for the type of street (e.g. street, avenue). |
| 99.3% | voieLibellé de voie | text | Name of the street.Name of the street. |
| 2.5% | compvoieComplément de voie | text | Additional complement to the street address.Additional complement to the street address. |
| 6.5% | lieuditbp | text | Locality or PO box information for the address.Locality or PO box information for the address. |
| 100% | communeCode commune (sans le département) | text | Municipality code without the department prefix.Municipality code without the department prefix. |
| 100% | com_codeCode Commune | text | Full official INSEE code of the municipality.Full official INSEE code of the municipality. |
| 100% | dep_codeDépartement | text | Code of the department.Code of the department. |
| 100% | dep_nameLibellé département | text | Name of the department.Name of the department. |
| 100% | ligneacheminementLigne d’acheminement | text | Postal code and municipality name used for mail routing.(CodePostal+Lib commune) |
| 91.8% | telephoneTéléphone | text | Telephone number of the establishment.Telephone number of the establishment. |
| 47.1% | telecopieTélécopie | text | Fax number of the establishment.Fax number of the establishment. |
| 100% | categetabCatégorie d’établissement | int | Numeric code identifying the establishment category.Numeric code identifying the establishment category. |
| 100% | libcategetabLibellé catégorie d’établissement | text | Label describing the establishment category.Label describing the establishment category. |
| 100% | categagretabCatégorie d’agrégat d’établissement | text | Code of the establishment's aggregate category.Code of the establishment's aggregate category. |
| 100% | libcategagretabLibellé catégorie d’agrégat d’établissement | text | Label describing the establishment's aggregate category.Label describing the establishment's aggregate category. |
| 92.9% | siretNuméro de SIRET | text | SIRET identifier of the establishment.SIRET identifier of the establishment. |
| 44.8% | codeape | text | APE/NAF code indicating the establishment's main economic activity.APE/NAF code indicating the establishment's main economic activity. |
| 100% | codemft | text | Code for the establishment's pricing/rate regime (MFT).Code for the establishment's pricing/rate regime (MFT). |
| 100% | libmftLibellé MFT | text | Label describing the establishment's pricing regime.Label describing the establishment's pricing regime. |
| 12.6% | codesph | int | Code for the establishment's public hospital service status.Code for the establishment's public hospital service status. |
| 12.6% | libsphLibellé SPH | text | Label describing the public hospital service status.Label describing the public hospital service status. |
| 100% | dateouvDate d’ouverture | date | Date the establishment opened.Date the establishment opened. |
| 99.6% | dateautorDate d’autorisation | date | Date the establishment was authorized.Date the establishment was authorized. |
| — | datemaj_structureDate de mise à jour sur la structure | date | Date the establishment's structural data was last updated.Date the establishment's structural data was last updated. |
| — | numuaiNuméro éducation nationale | text | National education ministry identifier for the establishment.National education ministry identifier for the establishment. |
| — | coordxetCoordonnée X (projection source) | double | X coordinate of the establishment in its source projection.X coordinate of the establishment in its source projection. |
| — | coordyetCoordonnée Y (projection source) | double | Y coordinate of the establishment in its source projection.Y coordinate of the establishment in its source projection. |
| — | sourcecoordetSource et projection des coordonnées | text | Source and coordinate projection system used for the location.Source and coordinate projection system used for the location. |
| — | datemaj_geoDate de mise à jour des coordonnées | date | Date the establishment's geographic coordinates were last updated.Date the establishment's geographic coordinates were last updated. |
| — | addressAdresse | text | Full postal address of the establishment.Full postal address of the establishment. |
| — | coordCoordonnées géographiques | geo_point_2d | Geographic coordinates (latitude and longitude) of the establishment.Geographic coordinates (latitude and longitude) of the establishment. |
| — | reg_codeCode Officiel Région | text | Official code of the region.Official code of the region. |
| — | reg_nameNom Officiel Région | text | Official name of the region.Official name of the region. |
| 100% | epci_codeCode Officiel EPCI | text | Official code of the EPCI (intermunicipal body).Official code of the EPCI (intermunicipal body). |
| 100% | epci_nameNom Officiel EPCI | text | Official name of the EPCI (intermunicipal body).Official name of the EPCI (intermunicipal body). |
| 100% | com_nameNom Officiel Commune | text | Official name of the municipality.Official name of the municipality. |
Schema captured from opendatasoft 1 day ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1rs: CMPP RIVE DROITE CENON · voie: PASTEUR
{
"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"
}Record 2rs: EEAP ARC EN CIEL · voie: JEANNE CHANAY
{
"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"
}Record 3rs: PHARMACIE DE LANGE · voie: DU GENERAL DE GAULLE
{
"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"
}Record 4rs: PHARMACIE DUBARRY · voie: RICHELIEU
{
"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"
}Record 5rs: EHPAD MAISON DE FONTAUDIN · voie: JEANNE CHANAY
{
"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"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Configuration
- Base URL
- https://opendata.bordeaux-metropole.fr/api/explore/v2.1/catalog/datasets/etablissements-du-domaine-sanitaire-et-social-bordeaux-metropole
License
- ✓ Redistributable
- ✓ Attribution required
Query examples
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'First 20 records of the dataset as JSON.
Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.
Rate limits
Dataset
Volume & freshness
License
No license declared upstream.
Source: opendatasoft
Machine-readable & source
Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.