Health and Social Care Establishments - Bordeaux MétropoleEtablissements du domaine sanitaire et social - Bordeaux Métropole

Name: Health and Social Care Establishments - Bordeaux Métropole
Creator: opendatasoft

Etablissements du domaine sanitaire et social - Bordeaux MétropoleHealth and Social Care Establishments - Bordeaux Métropole

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

Website Docs

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...

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (43 fields)

Filterable via the API (42)

nofinessetnofinessejrsrslonguecomplrscompldistribnumvoietypvoievoiecompvoielieuditbpcommunecom_codedep_codedep_nameligneacheminementtelephonetelecopiecategetablibcategetabcategagretablibcategagretabsiretcodeapecodemftlibmftcodesphlibsphdateouvdateautordatemaj_structurenumuaicoordxetcoordyetsourcecoordetdatemaj_geocom_namereg_codereg_nameepci_codeepci_nameaddress

Click a field to see example values.

Fill	Field	Type	Description
100%	nofinessetNuméro FINESS ET	text	—
100%	nofinessejNuméro FINESS EJ	text	—
100%	rsRaison sociale	text	—
89.2%	rslongueRaison sociale longue	text	—
7.8%	complrsComplément de raison sociale	text	—
8.2%	compldistribComplément de distribution	text	—
91.4%	numvoieNuméro de voie	int	—
98.6%	typvoieType de voie	text	—
99.4%	voieLibellé de voie	text	—
2.7%	compvoieComplément de voie	text	—
6.5%	lieuditbp	text	—
100%	communeCommune	text	—
100%	com_codeCode Commune	text	—
100%	dep_codeDépartement	text	—
100%	dep_nameLibellé département	text	—
100%	ligneacheminementLigne d’acheminement	text	(CodePostal+Lib commune)
93.8%	telephoneTéléphone	text	—
50.7%	telecopieTélécopie	text	—
100%	categetabCatégorie d’établissement	int	—
100%	libcategetabLibelle catégorie d’établissement	text	—
100%	categagretabCatégorie d’agrégat d’établissement	text	—
100%	libcategagretabLibellé catégorie d’agrégat d’établissement	text	—
92.8%	siretNuméro de SIRET	text	—
47.3%	codeape	text	—
100%	codemft	text	—
100%	libmftLibelle MFT	text	—
12.3%	codesph	int	—
12.3%	libsphLibelle SPH	text	—
100%	dateouvDate d’ouverture	date	—
99.6%	dateautorDate d’autorisation	date	—
100%	datemaj_structureDate de mise à jour sur la structure	date	—
2.2%	numuaiNuméro éducation nationale	text	—
100%	coordxet	double	—
100%	coordyet	double	—
100%	sourcecoordet	text	—
100%	datemaj_geoDate de mise à jour des coordonnées	date	—
100%	com_nameNom Officiel Commune	text	—
100%	reg_codeCode Officiel Région	text	—
100%	reg_nameNom Officiel Région	text	—
100%	epci_codeCode Officiel EPCI	text	—
—	epci_nameNom Officiel EPCI	text	—
—	addressAdresse	text	—
—	coord	geo_point_2d	—

Schema captured from opendatasoft 6 days 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.

Where=

Sort by

Sample data (5 records)

Record 1rs: PHARMACIE DUBOIS-HIDEUX · voie: Louis Barthou

{
  "rs": "PHARMACIE DUBOIS-HIDEUX",
  "voie": "Louis Barthou",
  "coord": {
    "lat": 44.852339004978916,
    "lon": -0.6148782737909756
  },
  "siret": "80847259100011",
  "libmft": "Etablissement Tarif Libre",
  "libsph": null,
  "numuai": null,
  "address": "151 AV Louis Barthou",
  "codeape": null,
  "codemft": "01",
  "codesph": null,
  "commune": "063",
  "complrs": null,
  "dateouv": "2015-01-05",
  "numvoie": 151,
  "typvoie": "AV",
  "com_code": "33063",
  "com_name": "Bordeaux",
  "compvoie": null,
  "coordxet": 414498.8,
  "coordyet": 6423554.9,
  "dep_code": "33",
  "dep_name": "GIRONDE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "PHARMACIE DUBOIS-HIDEUX",
  "categetab": 620,
  "dateautor": "1942-11-10",
  "epci_code": "243300316",
  "epci_name": "Bordeaux Métropole",
  "lieuditbp": null,
  "telecopie": null,
  "telephone": "0556082821",
  "nofinessej": "330042904",
  "nofinesset": "330042912",
  "datemaj_geo": "2024-09-03",
  "categagretab": "3201",
  "compldistrib": null,
  "libcategetab": "Pharmacie d'Officine",
  "sourcecoordet": "1,ATLASANTE,100,BDADRESSE_v2.2_03-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Commerce de Biens à Usage Médicaux",
  "datemaj_structure": "2024-09-03",
  "ligneacheminement": "33200 BORDEAUX"
}

Record 2rs: PHARMACIE DU PARC BORDELAIS · voie: D EYSINES

{
  "rs": "PHARMACIE DU PARC BORDELAIS",
  "voie": "D EYSINES",
  "coord": {
    "lat": 44.85890917298624,
    "lon": -0.6065477667314599
  },
  "siret": "35152440000022",
  "libmft": "Etablissement Tarif Libre",
  "libsph": null,
  "numuai": null,
  "address": "245 AV D EYSINES",
  "codeape": null,
  "codemft": "01",
  "codesph": null,
  "commune": "069",
  "complrs": null,
  "dateouv": "2023-01-15",
  "numvoie": 245,
  "typvoie": "AV",
  "com_code": "33069",
  "com_name": "Le Bouscat",
  "compvoie": null,
  "coordxet": 415189.6,
  "coordyet": 6424253.8,
  "dep_code": "33",
  "dep_name": "GIRONDE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "PHARMACIE DU PARC BORDELAIS",
  "categetab": 620,
  "dateautor": "2018-11-29",
  "epci_code": "243300316",
  "epci_name": "Bordeaux Métropole",
  "lieuditbp": null,
  "telecopie": "0556569287",
  "telephone": "0556085173",
  "nofinessej": "330044256",
  "nofinesset": "330044264",
  "datemaj_geo": "2024-09-03",
  "categagretab": "3201",
  "compldistrib": null,
  "libcategetab": "Pharmacie d'Officine",
  "sourcecoordet": "1,ATLASANTE,84,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Commerce de Biens à Usage Médicaux",
  "datemaj_structure": "2024-09-03",
  "ligneacheminement": "33110 LE BOUSCAT"
}

Record 3rs: PHARMACIE DU BOURGAILH · voie: DU BOURGAILH

{
  "rs": "PHARMACIE DU BOURGAILH",
  "voie": "DU BOURGAILH",
  "coord": {
    "lat": 44.812993286962154,
    "lon": -0.6647451230608632
  },
  "siret": "84505232300019",
  "libmft": "Etablissement Tarif Libre",
  "libsph": null,
  "numuai": null,
  "address": "128 AV DU BOURGAILH",
  "codeape": null,
  "codemft": "01",
  "codesph": null,
  "commune": "281",
  "complrs": null,
  "dateouv": "2019-02-01",
  "numvoie": 128,
  "typvoie": "AV",
  "com_code": "33281",
  "com_name": "Mérignac",
  "compvoie": null,
  "coordxet": 410360.4,
  "coordyet": 6419371,
  "dep_code": "33",
  "dep_name": "GIRONDE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "PHARMACIE DU BOURGAILH",
  "categetab": 620,
  "dateautor": "1976-03-10",
  "epci_code": "243300316",
  "epci_name": "Bordeaux Métropole",
  "lieuditbp": null,
  "telecopie": "0557269854",
  "telephone": "0556070618",
  "nofinessej": "330048802",
  "nofinesset": "330048810",
  "datemaj_geo": "2024-09-03",
  "categagretab": "3201",
  "compldistrib": null,
  "libcategetab": "Pharmacie d'Officine",
  "sourcecoordet": "1,ATLASANTE,84,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Commerce de Biens à Usage Médicaux",
  "datemaj_structure": "2022-02-10",
  "ligneacheminement": "33700 MERIGNAC"
}

Record 4rs: PHARMACIE ORUEZABAL · voie: AUBERNY

{
  "rs": "PHARMACIE ORUEZABAL",
  "voie": "AUBERNY",
  "coord": {
    "lat": 44.87726824747012,
    "lon": -0.526564499178975
  },
  "siret": "38778988600026",
  "libmft": "Etablissement Tarif Libre",
  "libsph": null,
  "numuai": null,
  "address": "2 PL AUBERNY",
  "codeape": null,
  "codemft": "01",
  "codesph": null,
  "commune": "249",
  "complrs": null,
  "dateouv": "2000-10-12",
  "numvoie": 2,
  "typvoie": "PL",
  "com_code": "33249",
  "com_name": "Lormont",
  "compvoie": null,
  "coordxet": 421592.7,
  "coordyet": 6426005.6,
  "dep_code": "33",
  "dep_name": "GIRONDE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "PHARMACIE ORUEZABAL",
  "categetab": 620,
  "dateautor": "1943-01-05",
  "epci_code": "243300316",
  "epci_name": "Bordeaux Métropole",
  "lieuditbp": null,
  "telecopie": "0556383893",
  "telephone": "0556065041",
  "nofinessej": "330048323",
  "nofinesset": "330048331",
  "datemaj_geo": "2024-09-03",
  "categagretab": "3201",
  "compldistrib": null,
  "libcategetab": "Pharmacie d'Officine",
  "sourcecoordet": "1,ATLASANTE,80,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Commerce de Biens à Usage Médicaux",
  "datemaj_structure": "2024-03-18",
  "ligneacheminement": "33310 LORMONT"
}

Record 5rs: LBM BIO LAB 33 - AMBARES ET LAGRAVE LI · voie: DE LA LIBERATION

{
  "rs": "LBM BIO LAB 33 - AMBARES ET LAGRAVE LI",
  "voie": "DE LA LIBERATION",
  "coord": {
    "lat": 44.919623181939706,
    "lon": -0.4802807292334214
  },
  "siret": "32815531200155",
  "libmft": "Etablissement Tarif Libre",
  "libsph": null,
  "numuai": null,
  "address": "4 AV DE LA LIBERATION",
  "codeape": null,
  "codemft": "01",
  "codesph": null,
  "commune": "003",
  "complrs": null,
  "dateouv": "1983-05-04",
  "numvoie": 4,
  "typvoie": "AV",
  "com_code": "33003",
  "com_name": "Ambarès-et-Lagrave",
  "compvoie": null,
  "coordxet": 425451.5,
  "coordyet": 6430543.2,
  "dep_code": "33",
  "dep_name": "GIRONDE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "LBM BIO LAB 33 - AMBARES ET LAGRAVE LIBERATION",
  "categetab": 611,
  "dateautor": "1983-05-04",
  "epci_code": "243300316",
  "epci_name": "Bordeaux Métropole",
  "lieuditbp": null,
  "telecopie": "0556778430",
  "telephone": "0556776177",
  "nofinessej": "330032269",
  "nofinesset": "330053158",
  "datemaj_geo": "2024-09-03",
  "categagretab": "3101",
  "compldistrib": null,
  "libcategetab": "Laboratoire de Biologie Médicale",
  "sourcecoordet": "1,ATLASANTE,87,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Laboratoires de Biologie Médicale",
  "datemaj_structure": "2023-06-26",
  "ligneacheminement": "33440 AMBARES ET LAGRAVE"
}

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

Licence Ouverte 2.0 (France / Etalab)Open

✓ 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.

Full API documentation ↗

Rate limits

10 000 000 req/day

per ipmeasured

observed 6 days ago

Dataset

Volume & freshness

Records

1.2k

1164

Update cadence

Monthly

declared upstream

Last upstream update

9 months ago

2025-12-10

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.