EU Blue Cards By Type Of Decision, Occupation And Citizenship

Eurostat code: migr_resbc1 · (2012 - 2023)

@eurostat.migr_resbc1

Table List

2 tables(1.07 MB)

EU Blue Cards By Type Of Decision, Occupation And Citizenship - Raw

EU Blue Cards By Type Of Decision, Occupation And Citizenship - Unpivoted

EU Blue Cards By Type Of Decision, Occupation And Citizenship - Unpivoted

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

318.83 KB
1211878 rows
8 columns

freq Freq	unit Unit	decision Decision	isco08 Isco08	citizen Citizen	geo Geo	time_period Time Period	value Value
Annual	Person	Decision to grant	Managers	Andorra	Cyprus	2012
Annual	Person	Decision to grant	Managers	United Arab Emirates	Cyprus	2012
Annual	Person	Decision to grant	Managers	Afghanistan	Cyprus	2012
Annual	Person	Decision to grant	Managers	Antigua and Barbuda	Cyprus	2012
Annual	Person	Decision to grant	Managers	Albania	Cyprus	2012
Annual	Person	Decision to grant	Managers	Armenia	Bulgaria	2012	1
Annual	Person	Decision to grant	Managers	Armenia	Cyprus	2012
Annual	Person	Decision to grant	Managers	Angola	Cyprus	2012
Annual	Person	Decision to grant	Managers	Argentina	Cyprus	2012
Annual	Person	Decision to grant	Managers	Argentina	Czechia	2012	1


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

Share link

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