Admitted Family Members Of EU Blue Cards Holders By Type Of Decision And Citizenship

Eurostat code: migr_resbc2 · (2012 - 2023)

@eurostat.migr_resbc2

Table List

2 tables(108.26 KB)

Admitted Family Members Of EU Blue Cards Holders By Type Of Decision And Citizenship - Raw

Admitted Family Members Of EU Blue Cards Holders By Type Of Decision And Citizenship - Unpivoted

Admitted Family Members Of EU Blue Cards Holders By Type Of Decision And Citizenship - Unpivoted

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

41.41 KB
63682 rows
7 columns

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


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

Share link

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