Health Personnel By NUTS 2 Region - Historical Data (1993-2021)

Eurostat code: hlth_rs_prsrg · (1993 - 2021)

@eurostat.hlth_rs_prsrg

Table List

2 tables(883.87 KB)

Health Personnel By NUTS 2 Region - Historical Data (1993-2021) - Raw

Health Personnel By NUTS 2 Region - Historical Data (1993-2021) - Unpivoted

Health Personnel By NUTS 2 Region - Historical Data (1993-2021) - Unpivoted

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

409.01 KB
77008 rows
6 columns

freq Freq	unit Unit	isco08 Isco08	geo Geo	time_period Time Period	value Value
Annual	Inhabitants per ...	Medical doctors	Austria	1993	303.47
Annual	Inhabitants per ...	Medical doctors	Burgenland	1993	449.46
Annual	Inhabitants per ...	Medical doctors	Niederösterreich	1993	407.41
Annual	Inhabitants per ...	Medical doctors	Wien	1993	175.46
Annual	Inhabitants per ...	Medical doctors	Kärnten	1993	346.08
Annual	Inhabitants per ...	Medical doctors	Steiermark	1993	323.28
Annual	Inhabitants per ...	Medical doctors	Oberösterreich	1993	419.5
Annual	Inhabitants per ...	Medical doctors	Salzburg	1993	324.42
Annual	Inhabitants per ...	Medical doctors	Tirol	1993	309.24
Annual	Inhabitants per ...	Medical doctors	Vorarlberg	1993	417.03


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

Share link

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