Health Personnel

Eurostat code: hlth_rs_prs2$dv_2824

@eurostat.hlth_rs_prs2_dv_2824

Table List

2 tables(41.24 KB)

Health Personnel - Raw

Health Personnel - Unpivoted

Health Personnel - Raw

@eurostat.hlth_rs_prs2_dv_2824.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

23.15 KB
214 rows
15 columns

freq Freq	unit Unit	wstatus Wstatus	med_spec Med Spec	geo Geo	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022
Annual	Per hundred thousand inhabitants	Practising	Dentists	Austria	59.61	60.03	59.39	58.91	59.55	59.37	60.59	61.15	61.66	61.55
Annual	Per hundred thousand inhabitants	Practising	Dentists	Belgium	71.37	72.33	73.54	74.82	74.86	75.38	75.7	76.88	77.04	75.51
Annual	Per hundred thousand inhabitants	Practising	Dentists	Bulgaria	97.23	99.56	100.26	104	106.06	103.66	106.64	106.33	109.92	115.35
Annual	Per hundred thousand inhabitants	Practising	Dentists	Switzerland	52.02	51.05	50.71	50.36	51.6	50.94	40.59
Annual	Per hundred thousand inhabitants	Practising	Dentists	Cyprus	96.18	98.42	103.34	103.57	109.25	112.18	114.52	105.94	110.96	119.43
Annual	Per hundred thousand inhabitants	Practising	Dentists	Czechia	70.63	75.11		75.29	74.77	73.79	73.32	74.7	75.8	73.89
Annual	Per hundred thousand inhabitants	Practising	Dentists	Germany	84.93	85.62	85.76	85.56	85.58	85.74	85.44	85.42	85.67	85.08
Annual	Per hundred thousand inhabitants	Practising	Dentists	Denmark	78.27	77.01	76.08	74.21	71.86	71.87	72.08	71.44	71.8
Annual	Per hundred thousand inhabitants	Practising	Dentists	Estonia	90.29	92.98	94.19	95.53	96.02	96.6	98.2	100.49	101.13	101.94
Annual	Per hundred thousand inhabitants	Practising	Dentists	Spain										60.37


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "wstatus" VARCHAR,
  "med_spec" VARCHAR,
  "geo" VARCHAR,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

Anyone who has the link will be able to view this.