c0mm0.com — the continuously verified register of European data
c0mm0.com
Insights
Identifiers
Methodology
About
/
EN
Submit
Workbench
Établissements de santé (FINESS)
Query now
VERIFIED
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
Convert to EUR
(ECB rate on each row's own date)
— amount —
source (string)
date_maj (date)
finess (string)
finess8 (string)
etat (string)
date_extract_finess (date)
rs (string)
type (string)
ej_finess (string)
ej_rs (string)
et_finess (string)
et_rs (string)
siren (string)
siret (string)
date_autorisation (date)
date_ouverture (date)
date_maj_finess (date)
adresse_num_voie (string)
adresse_comp_voie (string)
adresse_type_voie (string)
adresse_nom_voie (string)
adresse_lieuditbp (string)
adresse_code_postal (string)
adresse_lib_routage (string)
telephone (string)
telecopie (string)
com_code (string)
statut_jur_code (string)
statut_jur_lib (string)
statut_jur_etat (boolean)
statut_jur_niv3_code (integer)
statut_jur_niv3_lib (string)
statut_jur_niv2_code (integer)
statut_jur_niv2_lib (string)
statut_jur_niv1_code (integer)
statut_jur_niv1_lib (string)
categ_code (integer)
categ_lib (string)
categ_lib_court (string)
categ_etat (string)
categ_niv3_code (integer)
categ_niv3_lib (string)
categ_niv2_code (integer)
categ_niv2_lib (string)
categ_niv1_code (integer)
categ_niv1_lib (string)
categ_domaine (string)
esms (boolean)
esms_capaTot_inst (string)
esms_capaInternat_inst (string)
esms_esh (boolean)
esms_ash (boolean)
esms_pa (boolean)
san (boolean)
san_med (boolean)
san_chir (boolean)
san_obs (boolean)
san_psy (boolean)
san_had (boolean)
san_sld (boolean)
san_urg (boolean)
san_sc (boolean)
san_dialyse (boolean)
san_cancer (boolean)
san_smr (boolean)
nb_scanners (string)
nb_irm (string)
gestion_ars (string)
gestion_dreets (string)
gestion_drihl (string)
version_nomenclature (string)
tutelle (string)
mft_code (string)
mft_lib (string)
sph_code (integer)
sph_lib (string)
geoloc_source (string)
geoloc_precision (string)
geoloc_legal_x (number)
geoloc_legal_y (number)
geoloc_legal_projection (string)
geoloc_3857_x (number)
geoloc_3857_y (number)
geoloc_4326_long (number)
geoloc_4326_lat (number)
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
