Health Personnel

Eurostat code: hlth_rs_prs2 · (1960 - 2022)

@eurostat.hlth_rs_prs2

Table List

2 tables(514.42 KB)

Health Personnel - Unpivoted

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

234.74 KB
36999 rows
7 columns

freq Freq	unit Unit	wstatus Wstatus	med_spec Med Spec	geo Geo	time_period Time Period	value Value
Annual	Inhabitants per ...	Licensed to practice	Physicians	Greece	1960	799.28
Annual	Inhabitants per ...	Licensed to practice	Physicians	Spain	1960	853.44
Annual	Inhabitants per ...	Licensed to practice	Physicians	Netherlands	1960	896.76
Annual	Inhabitants per ...	Licensed to practice	Physicians	Portugal	1960	1321.85
Annual	Inhabitants per ...	Professionally active	Physicians	Switzerland	1960	715.91
Annual	Inhabitants per ...	Professionally active	Physicians	Iceland	1960	856.46
Annual	Inhabitants per ...	Professionally active	Physicians	Türkiye	1960	3340.34
Annual	Inhabitants per ...	Practising	Physicians	Austria	1960	627.62
Annual	Inhabitants per ...	Practising	Physicians	Belgium	1960	780.35
Annual	Inhabitants per ...	Practising	Physicians	Estonia	1960	481.15


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.