Atos: French National Health and Social Facilities

Certified repository of French health and social facilities recognized by the administration


The FINESS (Fichier National des Etablissements Sanitaires et Sociaux) dataset contains a view with the complete list of health and social facilities in France. This dataset will allow you to correct, update or enrich your data based on a single repository, recognized by the French administration.

Views Included:
– Etablissements: Complete list of health and social facilities in France

Fields Included:
– num_finess_et: facility identifier
– num_finess_ej: legal entity identifier
– raison_sociale: facility name
– raison_sociale_longue: facility full name
– complement_raison_sociale: additional information on facility name
– complement_distribution: additional information on distribution
– num_voie: street number
– type_voie: street type
– libelle_voie: street name
– complement_voie: additional information on street name
– lieu_dit_bp: locality / postal box
– code_commune: municipality code
– departement: department code
– libelle_departement: departement name
– ligne_acheminement: name of the routing ligne
– telephone: phone number
– telecopie: fax number
– categorie_etablissement: code category of the facility
– libelle_categorie_etablissement: category name of the facility
– categorie_aggregat_etablissement: regroupment code category of the facility
– libelle_aggregat_etablissement: regroupment category name of the facility
– siret: SIRET number
– code_ape: APE code
– code_mft: MFT code
– libelle_mft: MFT name
– code_sph: SPH code
– date_ouverture: opening date
– date_autorisation: approval date
– date_mise_a_jour: update date
– num_education_nationale: Numéro éducation nationale

Additional Information:
Original data downloaded from

About the Provider:

Atos is the global leader in secure and decarbonized digital with a range of market-leading digital solutions along with consultancy services, digital security and decarbonization offerings; an end-to-end partnership approach.

Atos operates under the brands Atos and Atos|Syntel and is an SE (Societas Europaea), listed on the CAC40 Paris stock index.

As part of the free redistribution license granted by etalab.gouv, ATOS collects, prepare and share “”Open Data License”” datasets to Snowflake customers. This free and open license provides the necessary legal certainty for producers and users of public data.

Atos has developed the mechanisms for loading and regularly updating these open data in Snowflake and we wish to make more and more data available over the time. If you need an open data set which is not already available do not hesitate to contact us and we will see to add it in the marketplace!

Get access to the Atos: French National Health and Social Facilities Listing in Snowflake

Sign up for a Snowflake free Trial

Already a Snowflake customer?
Access this listing directly from your Snowflake account.