Health Personnel (excluding Nursing And Caring Professionals) - Historical Data (1980-2021)

Eurostat code: hlth_rs_prs1 · (1960 - 2021)

@eurostat.hlth_rs_prs1

Table List

2 tables(347.28 KB)

Health Personnel (excluding Nursing And Caring Professionals) - Historical Data (1980-2021) - Raw

Health Personnel (excluding Nursing And Caring Professionals) - Historical Data (1980-2021) - Unpivoted

Health Personnel (excluding Nursing And Caring Professionals) - Historical Data (1980-2021) - Unpivoted

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

155.09 KB
22941 rows
7 columns

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


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

Share link

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