Hospital Employment

Eurostat code: hlth_rs_prshp2 · (1980 - 2022)

@eurostat.hlth_rs_prshp2

Table List

2 tables(295.54 KB)

Hospital Employment - Unpivoted

@eurostat.hlth_rs_prshp2.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.

135.94 KB
19321 rows
6 columns

freq Freq	med_spec Med Spec	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Health care assistants	Full-time equivalent (FTE)	Liechtenstein	1980	8.7
Annual	Health care assistants	Full time equivalent per hundred thousand inhabitants	Liechtenstein	1980	34.1
Annual	Health care assistants	Inhabitants per ... (full time equivalent)	Liechtenstein	1980	2932.41
Annual	Health care assistants	Inhabitants per ... (head count)	Denmark	1980	406.49
Annual	Health care assistants	Inhabitants per ... (head count)	Liechtenstein	1980	1962.46
Annual	Health care assistants	Head count	Denmark	1980	12603
Annual	Health care assistants	Head count	Liechtenstein	1980	13
Annual	Health care assistants	Head count per hundred thousand inhabitants	Denmark	1980	246.01
Annual	Health care assistants	Head count per hundred thousand inhabitants	Liechtenstein	1980	50.96
Annual	Other health service providers	Full-time equivalent (FTE)	Liechtenstein	1980	2.3


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

Share link

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