Health Personnel

Eurostat code: hlth_rs_prs2$dv_2824

@eurostat.hlth_rs_prs2_dv_2824

Table List

2 tables(41.24 KB)

Health Personnel - Unpivoted

@eurostat.hlth_rs_prs2_dv_2824.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

18.08 KB
1920 rows
7 columns

freq Freq	unit Unit	wstatus Wstatus	med_spec Med Spec	geo Geo	time_period Time Period	value Value
Annual	Per hundred thousand inhabitants	Practising	Dentists	Austria	2013	59.61
Annual	Per hundred thousand inhabitants	Practising	Dentists	Belgium	2013	71.37
Annual	Per hundred thousand inhabitants	Practising	Dentists	Bulgaria	2013	97.23
Annual	Per hundred thousand inhabitants	Practising	Dentists	Switzerland	2013	52.02
Annual	Per hundred thousand inhabitants	Practising	Dentists	Cyprus	2013	96.18
Annual	Per hundred thousand inhabitants	Practising	Dentists	Czechia	2013	70.63
Annual	Per hundred thousand inhabitants	Practising	Dentists	Germany	2013	84.93
Annual	Per hundred thousand inhabitants	Practising	Dentists	Denmark	2013	78.27
Annual	Per hundred thousand inhabitants	Practising	Dentists	Estonia	2013	90.29
Annual	Per hundred thousand inhabitants	Practising	Dentists	Finland	2013	72.75


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "wstatus" VARCHAR,
  "med_spec" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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