Health Workforce Migration - Historical Data (2000-2021)

Eurostat code: hlth_rs_wkmg · (2000 - 2021)

@eurostat.hlth_rs_wkmg

Table List

2 tables(77.25 KB)

Health Workforce Migration - Historical Data (2000-2021) - Raw

Health Workforce Migration - Historical Data (2000-2021) - Unpivoted

Health Workforce Migration - Historical Data (2000-2021) - Unpivoted

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

30.96 KB
4503 rows
7 columns

freq Freq	unit Unit	isco08 Isco08	indic_ed Indic Ed	geo Geo	time_period Time Period	value Value
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Belgium	2000	107
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Czechia	2000	18
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Germany	2000	226
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Denmark	2000	124
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Spain	2000	763
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Hungary	2000	95
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Italy	2000	74
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Norway	2000	1348
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Sweden	2000	306
Annual	Number	Medical doctors	Foreign-trained (annual inflow)	Slovenia	2000	28


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

Share link

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