Baselight

Health Workforce Migration

Eurostat code: hlth_rs_wkmg2 ยท (2000 - 2022)

@eurostat.hlth_rs_wkmg2

Health Workforce Migration - Raw
@eurostat.hlth_rs_wkmg2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

  • 47.99 KB
  • 321 rows
  • 28 columns
freq

Freq

unit

Unit

med_spec

Med Spec

indic_ed

Indic Ed

geo

Geo

n_2000

2000

n_2001

2001

n_2002

2002

n_2003

2003

n_2004

2004

n_2005

2005

n_2006

2006

n_2007

2007

n_2008

2008

n_2009

2009

n_2010

2010

n_2011

2011

n_2012

2012

n_2013

2013

n_2014

2014

n_2015

2015

n_2016

2016

n_2017

2017

n_2018

2018

n_2019

2019

n_2020

2020

n_2021

2021

n_2022

2022

AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Austria900992983839655624661615616724
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Belgium98907380101121148218265300361425886890783726590464622509567532425
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Bulgaria1221121113655
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Switzerland33442021159018712434279026302237268826622654247224922294223121232034236722053043
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Czechia101157106229180
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Germany6631875263133423699469851427014771083408310
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Denmark9492104100106107144241513425162102627499811211199113898124149
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Estonia12142643333
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Spain107207151393563569871138412439341088850509327290235219355311491514597731
AnnualNumberNurses (EU recognised qualification)Foreign-trained (annual inflow)Finland19152010344666708411612314013095843431332645544337

CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "med_spec" VARCHAR,
  "indic_ed" VARCHAR,
  "geo" VARCHAR,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Share link

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