c0mm0.com — the continuously verified register of European data
c0mm0.com
Insights
Identifiers
Methodology
About
/
EN
Submit
Workbench
Établissements de santé (FINESS)
Query now
STALE
Columns
(6/8 max)
source
string
date_maj
Date maj
date
finess
string
finess8
string
etat
string
date_extract_finess
Date extract finess
date
rs
string
type
string
ej_finess
Ej finess
string
ej_rs
Ej rs
string
et_finess
Et finess
string
et_rs
Et rs
string
siren
SIREN (company)
string
siret
SIRET (establishment)
string
date_autorisation
Date autorisation
date
date_ouverture
Date ouverture
date
date_maj_finess
Date maj finess
date
adresse_num_voie
Adresse num voie
string
adresse_comp_voie
Adresse comp voie
string
adresse_type_voie
Adresse type voie
string
adresse_nom_voie
Adresse nom voie
string
adresse_lieuditbp
Adresse lieuditbp
string
adresse_code_postal
Adresse code postal
string
adresse_lib_routage
Adresse lib routage
string
telephone
string
telecopie
string
com_code
Com code
string
statut_jur_code
Statut jur code
string
statut_jur_lib
Statut jur lib
string
statut_jur_etat
Statut jur etat
boolean
statut_jur_niv3_code
Statut jur niv3 code
integer
statut_jur_niv3_lib
Statut jur niv3 lib
string
statut_jur_niv2_code
Statut jur niv2 code
integer
statut_jur_niv2_lib
Statut jur niv2 lib
string
statut_jur_niv1_code
Statut jur niv1 code
integer
statut_jur_niv1_lib
Statut jur niv1 lib
string
categ_code
Categ code
integer
categ_lib
Categ lib
string
categ_lib_court
Categ lib court
string
categ_etat
Categ etat
string
categ_niv3_code
Categ niv3 code
integer
categ_niv3_lib
Categ niv3 lib
string
categ_niv2_code
Categ niv2 code
integer
categ_niv2_lib
Categ niv2 lib
string
categ_niv1_code
Categ niv1 code
integer
categ_niv1_lib
Categ niv1 lib
string
categ_domaine
Categ domaine
string
esms
boolean
esms_capaTot_inst
Esms capa tot inst
string
esms_capaInternat_inst
Esms capa internat inst
string
esms_esh
Esms esh
boolean
esms_ash
Esms ash
boolean
esms_pa
Esms pa
boolean
san
boolean
san_med
San med
boolean
san_chir
San chir
boolean
san_obs
San obs
boolean
san_psy
San psy
boolean
san_had
San had
boolean
san_sld
San sld
boolean
san_urg
San urg
boolean
san_sc
San sc
boolean
san_dialyse
San dialyse
boolean
san_cancer
San cancer
boolean
san_smr
San smr
boolean
nb_scanners
Nb scanners
string
nb_irm
Nb irm
string
gestion_ars
Gestion ars
string
gestion_dreets
Gestion dreets
string
gestion_drihl
Gestion drihl
string
version_nomenclature
Version nomenclature
string
tutelle
string
mft_code
Mft code
string
mft_lib
Mft lib
string
sph_code
Sph code
integer
sph_lib
Sph lib
string
geoloc_source
Geoloc source
string
geoloc_precision
Geoloc precision
string
geoloc_legal_x
Geoloc legal x
number
geoloc_legal_y
Geoloc legal y
number
geoloc_legal_projection
Geoloc legal projection
string
geoloc_3857_x
Geoloc 3857 x
number
geoloc_3857_y
Geoloc 3857 y
number
geoloc_4326_long
Geoloc 4326 long
number
geoloc_4326_lat
Geoloc 4326 lat
number
Sort by
— none —
source
date_maj
finess
finess8
etat
date_extract_finess
rs
type
ej_finess
ej_rs
et_finess
et_rs
siren
siret
date_autorisation
date_ouverture
date_maj_finess
adresse_num_voie
adresse_comp_voie
adresse_type_voie
adresse_nom_voie
adresse_lieuditbp
adresse_code_postal
adresse_lib_routage
telephone
telecopie
com_code
statut_jur_code
statut_jur_lib
statut_jur_etat
statut_jur_niv3_code
statut_jur_niv3_lib
statut_jur_niv2_code
statut_jur_niv2_lib
statut_jur_niv1_code
statut_jur_niv1_lib
categ_code
categ_lib
categ_lib_court
categ_etat
categ_niv3_code
categ_niv3_lib
categ_niv2_code
categ_niv2_lib
categ_niv1_code
categ_niv1_lib
categ_domaine
esms
esms_capaTot_inst
esms_capaInternat_inst
esms_esh
esms_ash
esms_pa
san
san_med
san_chir
san_obs
san_psy
san_had
san_sld
san_urg
san_sc
san_dialyse
san_cancer
san_smr
nb_scanners
nb_irm
gestion_ars
gestion_dreets
gestion_drihl
version_nomenclature
tutelle
mft_code
mft_lib
sph_code
sph_lib
geoloc_source
geoloc_precision
geoloc_legal_x
geoloc_legal_y
geoloc_legal_projection
geoloc_3857_x
geoloc_3857_y
geoloc_4326_long
geoloc_4326_lat
↑ asc
Where
(filters AND together)
— any —
source ▾
date_maj ▾
finess ▾
finess8 ▾
etat ▾
date_extract_finess ▾
rs ▾
type ▾
ej_finess ▾
ej_rs ▾
et_finess ▾
et_rs ▾
siren ▾
siret ▾
date_autorisation ▾
date_ouverture ▾
date_maj_finess ▾
adresse_num_voie ▾
adresse_comp_voie ▾
adresse_type_voie ▾
adresse_nom_voie ▾
adresse_lieuditbp ▾
adresse_code_postal ▾
adresse_lib_routage ▾
telephone ▾
telecopie ▾
com_code ▾
statut_jur_code ▾
statut_jur_lib ▾
statut_jur_etat ▾
statut_jur_niv3_code ▾
statut_jur_niv3_lib ▾
statut_jur_niv2_code ▾
statut_jur_niv2_lib ▾
statut_jur_niv1_code ▾
statut_jur_niv1_lib ▾
categ_code ▾
categ_lib ▾
categ_lib_court ▾
categ_etat ▾
categ_niv3_code ▾
categ_niv3_lib ▾
categ_niv2_code ▾
categ_niv2_lib ▾
categ_niv1_code ▾
categ_niv1_lib ▾
categ_domaine ▾
esms ▾
esms_capaTot_inst ▾
esms_capaInternat_inst ▾
esms_esh ▾
esms_ash ▾
esms_pa ▾
san ▾
san_med ▾
san_chir ▾
san_obs ▾
san_psy ▾
san_had ▾
san_sld ▾
san_urg ▾
san_sc ▾
san_dialyse ▾
san_cancer ▾
san_smr ▾
nb_scanners ▾
nb_irm ▾
gestion_ars ▾
gestion_dreets ▾
gestion_drihl ▾
version_nomenclature ▾
tutelle ▾
mft_code ▾
mft_lib ▾
sph_code ▾
sph_lib ▾
geoloc_source ▾
geoloc_precision ▾
geoloc_legal_x ▾
geoloc_legal_y ▾
geoloc_legal_projection ▾
geoloc_3857_x ▾
geoloc_3857_y ▾
geoloc_4326_long ▾
geoloc_4326_lat ▾
=
≥
≤
contains
+ Add filter
Summarize
— none —
source
date_maj
finess
finess8
etat
date_extract_finess
rs
type
ej_finess
ej_rs
et_finess
et_rs
siren
siret
date_autorisation
date_ouverture
date_maj_finess
adresse_num_voie
adresse_comp_voie
adresse_type_voie
adresse_nom_voie
adresse_lieuditbp
adresse_code_postal
adresse_lib_routage
telephone
telecopie
com_code
statut_jur_code
statut_jur_lib
statut_jur_etat
statut_jur_niv3_code
statut_jur_niv3_lib
statut_jur_niv2_code
statut_jur_niv2_lib
statut_jur_niv1_code
statut_jur_niv1_lib
categ_code
categ_lib
categ_lib_court
categ_etat
categ_niv3_code
categ_niv3_lib
categ_niv2_code
categ_niv2_lib
categ_niv1_code
categ_niv1_lib
categ_domaine
esms
esms_capaTot_inst
esms_capaInternat_inst
esms_esh
esms_ash
esms_pa
san
san_med
san_chir
san_obs
san_psy
san_had
san_sld
san_urg
san_sc
san_dialyse
san_cancer
san_smr
nb_scanners
nb_irm
gestion_ars
gestion_dreets
gestion_drihl
version_nomenclature
tutelle
mft_code
mft_lib
sph_code
sph_lib
geoloc_source
geoloc_precision
geoloc_legal_x
geoloc_legal_y
geoloc_legal_projection
geoloc_3857_x
geoloc_3857_y
geoloc_4326_long
geoloc_4326_lat
Rows
20
50
100
200
Run query
CSV
JSON
NDJSON
Parquet
Cite
Subscribe
source
date_maj
finess
finess8
etat
date_extract_finess
Run a query to see rows.
Entry record
