Etablissements du domaine sanitaire et social en France

Name: Etablissements du domaine sanitaire et social en France
Creator: opendatasoft

APIQuery nowOpen workbench🇫🇷France

Liste des établissements du domaine sanitaire et social. 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 établissements du domaine sanitaire et s...

⬇ Export CSV List records Select & filter API base URL Read the docs

Trust score

How is this computed?

poor

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	—
80.1%	rslongueRaison sociale longue	text	—
9.4%	complrsComplément de raison sociale	text	—
11.6%	compldistribComplément de distribution	text	—
83.9%	numvoieNuméro de voie	int	—
94.9%	typvoieType de voie	text	—
97.9%	voieLibellé de voie	text	—
3.8%	compvoieComplément de voie	text	—
11%	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)
86.7%	telephoneTéléphone	text	—
48.2%	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	—
88.2%	siretNuméro de SIRET	text	—
44.8%	codeape	text	—
100%	codemft	text	—
100%	libmftLibelle MFT	text	—
11.4%	codesph	int	—
11.4%	libsphLibelle SPH	text	—
100%	dateouvDate d’ouverture	date	—
99.4%	dateautorDate d’autorisation	date	—
100%	datemaj_structureDate de mise à jour sur la structure	date	—
3.4%	numuaiNuméro éducation nationale	text	—
100%	coordxet	double	—
100%	coordyet	double	—
100%	sourcecoordet	text	—
100%	datemaj_geoDate de mise à jour des coordonnées	date	—
99.9%	com_nameNom Officiel Commune	text	—
99.9%	reg_codeCode Officiel Région	text	—
99.9%	reg_nameNom Officiel Région	text	—
99.8%	epci_codeCode Officiel EPCI	text	—
—	epci_nameNom Officiel EPCI	text	—
—	addressAdresse	text	—
—	coord	geo_point_2d	—

Schema captured from opendatasoft 1 hour 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: SERVICE MJPM UDAF 47 · voie: ROGER JOHAN

{
  "rs": "SERVICE MJPM UDAF 47",
  "voie": "ROGER JOHAN",
  "coord": {
    "lat": 44.20333627923599,
    "lon": 0.6255493198963049
  },
  "siret": "78215311800032",
  "libmft": "Préfet de région établissements et services sociaux",
  "libsph": null,
  "numuai": null,
  "address": "7 R ROGER JOHAN",
  "codeape": "8899B",
  "codemft": "30",
  "codesph": null,
  "commune": "001",
  "complrs": null,
  "dateouv": "2011-03-02",
  "numvoie": 7,
  "typvoie": "R",
  "com_code": "47001",
  "com_name": "Agen",
  "compvoie": null,
  "coordxet": 510262.3,
  "coordyet": 6347778,
  "dep_code": "47",
  "dep_name": "LOT ET GARONNE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": null,
  "categetab": 340,
  "dateautor": "2011-03-02",
  "epci_code": "200096956",
  "epci_name": "Communauté d'agglomération Agglomération d'Agen",
  "lieuditbp": "BP 20219",
  "telecopie": null,
  "telephone": "0553693746",
  "nofinessej": "470011099",
  "nofinesset": "470016585",
  "datemaj_geo": "2024-09-03",
  "categagretab": "4608",
  "compldistrib": null,
  "libcategetab": "Service mandataire judiciaire à la protection des majeurs",
  "sourcecoordet": "1,ATLASANTE,100,BDADRESSE_v2.2_03-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Protection des majeurs",
  "datemaj_structure": "2018-04-24",
  "ligneacheminement": "47006 AGEN CEDEX"
}

Record 2rs: CDS DENTAIRE D'AGEN · voie: DE LA REPUBLIQUE

{
  "rs": "CDS DENTAIRE D'AGEN",
  "voie": "DE LA REPUBLIQUE",
  "coord": {
    "lat": 44.20437165462252,
    "lon": 0.614164341760493
  },
  "siret": "91406157700021",
  "libmft": "Tarifs conventionnels assurance maladie",
  "libsph": null,
  "numuai": null,
  "address": "28 BD DE LA REPUBLIQUE",
  "codeape": "8623Z",
  "codemft": "36",
  "codesph": null,
  "commune": "001",
  "complrs": null,
  "dateouv": "2022-12-15",
  "numvoie": 28,
  "typvoie": "BD",
  "com_code": "47001",
  "com_name": "Agen",
  "compvoie": null,
  "coordxet": 509356.3,
  "coordyet": 6347920.4,
  "dep_code": "47",
  "dep_name": "LOT ET GARONNE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "CDS DENTAIRE D'AGEN",
  "categetab": 124,
  "dateautor": "2022-09-02",
  "epci_code": "200096956",
  "epci_name": "Communauté d'agglomération Agglomération d'Agen",
  "lieuditbp": null,
  "telecopie": null,
  "telephone": "0978365661",
  "nofinessej": "750071243",
  "nofinesset": "470018557",
  "datemaj_geo": "2024-09-03",
  "categagretab": "2206",
  "compldistrib": null,
  "libcategetab": "Centre de Santé",
  "sourcecoordet": "1,ATLASANTE,85,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Centres de Santé",
  "datemaj_structure": "2022-12-15",
  "ligneacheminement": "47000 AGEN"
}

Record 3rs: GCS PSV IMMOBILIER - ET SIEGE · voie: —

{
  "rs": "GCS PSV IMMOBILIER - ET SIEGE",
  "voie": null,
  "coord": {
    "lat": 44.41029278121114,
    "lon": 0.7060204635764313
  },
  "siret": "51124913800013",
  "libmft": "Indéterminé",
  "libsph": "indéterminé",
  "numuai": null,
  "address": "",
  "codeape": "6832B",
  "codemft": "99",
  "codesph": 9,
  "commune": "323",
  "complrs": "POLE DE SANTE DU VILLENEUVOIS",
  "dateouv": "2008-07-17",
  "numvoie": null,
  "typvoie": null,
  "com_code": "47323",
  "com_name": "Villeneuve-sur-Lot",
  "compvoie": null,
  "coordxet": 517358.6,
  "coordyet": 6370569.9,
  "dep_code": "47",
  "dep_name": "LOT ET GARONNE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "GCS POLE DE SANTE DU VILLENEUVOIS (PSV) IMMOBILIER-ET SIEGE",
  "categetab": 696,
  "dateautor": "2008-07-17",
  "epci_code": "200023307",
  "epci_name": "Communauté d'agglomération du Grand Villeneuvois",
  "lieuditbp": "CS80232",
  "telecopie": "0553722379",
  "telephone": "0553722323",
  "nofinessej": "470014341",
  "nofinesset": "470015132",
  "datemaj_geo": "2024-09-03",
  "categagretab": "1205",
  "compldistrib": null,
  "libcategetab": "Groupement de coopération sanitaire de moyens",
  "sourcecoordet": "4,ATLASANTE,.,ADMIN-EXPRESS-2023,LAMBERT_93_METROPOLE",
  "libcategagretab": "Autres Etablissements Relevant de la Loi Hospitalière",
  "datemaj_structure": "2014-12-01",
  "ligneacheminement": "47305 VILLENEUVE SUR LOT CEDEX"
}

Record 4rs: APTIM - SERVICE MJPM · voie: FRANCOIS VILLON

{
  "rs": "APTIM - SERVICE MJPM",
  "voie": "FRANCOIS VILLON",
  "coord": {
    "lat": 44.3976142571128,
    "lon": 0.7038375537881474
  },
  "siret": "39842350900031",
  "libmft": "Préfet de région établissements et services sociaux",
  "libsph": null,
  "numuai": null,
  "address": "7 IMP FRANCOIS VILLON",
  "codeape": "8899B",
  "codemft": "30",
  "codesph": null,
  "commune": "323",
  "complrs": null,
  "dateouv": "1992-01-22",
  "numvoie": 7,
  "typvoie": "IMP",
  "com_code": "47323",
  "com_name": "Villeneuve-sur-Lot",
  "compvoie": null,
  "coordxet": 517143.9,
  "coordyet": 6369167.1,
  "dep_code": "47",
  "dep_name": "LOT ET GARONNE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "SERVICE MANDATAIRE A LA PROTECTION DES MAJEURS",
  "categetab": 340,
  "dateautor": "2011-03-02",
  "epci_code": "200023307",
  "epci_name": "Communauté d'agglomération du Grand Villeneuvois",
  "lieuditbp": null,
  "telecopie": "0553367590",
  "telephone": "0553367715",
  "nofinessej": "470016288",
  "nofinesset": "470016296",
  "datemaj_geo": "2024-09-03",
  "categagretab": "4608",
  "compldistrib": null,
  "libcategetab": "Service mandataire judiciaire à la protection des majeurs",
  "sourcecoordet": "1,ATLASANTE,86,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Protection des majeurs",
  "datemaj_structure": "2018-03-28",
  "ligneacheminement": "47300 VILLENEUVE SUR LOT"
}

Record 5rs: SESSAD SOLINCITE · voie: DES REMPARTS

{
  "rs": "SESSAD SOLINCITE",
  "voie": "DES REMPARTS",
  "coord": {
    "lat": 44.54830371476739,
    "lon": 0.2379881508671278
  },
  "siret": "78216138400022",
  "libmft": "ARS / DG dotation globale",
  "libsph": null,
  "numuai": null,
  "address": "R DES REMPARTS",
  "codeape": "8899B",
  "codemft": "34",
  "codesph": null,
  "commune": "088",
  "complrs": null,
  "dateouv": "2007-10-01",
  "numvoie": null,
  "typvoie": "R",
  "com_code": "47088",
  "com_name": "Escassefort",
  "compvoie": null,
  "coordxet": 480645,
  "coordyet": 6387084.5,
  "dep_code": "47",
  "dep_name": "LOT ET GARONNE",
  "reg_code": "75",
  "reg_name": "Nouvelle-Aquitaine",
  "rslongue": "SESSAD SOLINCITE",
  "categetab": 182,
  "dateautor": "2022-07-02",
  "epci_code": "200030674",
  "epci_name": "Communauté d'agglomération Val de Garonne Agglomération",
  "lieuditbp": null,
  "telecopie": "0553203404",
  "telephone": "0553203840",
  "nofinessej": "470009143",
  "nofinesset": "470012709",
  "datemaj_geo": "2024-09-03",
  "categagretab": "4106",
  "compldistrib": null,
  "libcategetab": "Service d'Éducation Spéciale et de Soins à Domicile",
  "sourcecoordet": "2,ATLASANTE,81,BAN_05-09-2024,LAMBERT_93_METROPOLE",
  "libcategagretab": "Services à Domicile ou Ambulatoires pour Handicapés",
  "datemaj_structure": "2023-04-25",
  "ligneacheminement": "47350 ESCASSEFORT"
}

Live sample captured at profiling time — values may have changed upstream.

Using the API

Configuration

Base URL: https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/healthref-france-finess

License

Licence Ouverte 2.0 (France / Etalab)Open

✓ Redistributable
✓ Attribution required

Query examples

curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/healthref-france-finess/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 1 hour ago

Dataset

Volume & freshness

Records

100k

100462

Update cadence

Monthly

declared upstream

Last upstream update

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