Baselight
Sign In

EU Blue Cards Holders And Family Members By Member State Of Previous Residence

Eurostat code: migr_resbc3 ยท (2010 - 2023)

@eurostat.migr_resbc3

EU Blue Cards Holders And Family Members By Member State Of Previous Residence - Unpivoted
@eurostat.migr_resbc3.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.

  • 9.38 KB
  • 10442 rows
  • 7 columns
freq

Freq

unit

Unit

pers_cat

Pers Cat

c_resid

C Resid

geo

Geo

time_period

Time Period

value

Value

AnnualPersonFamily member of EU Blue Cards holderAustriaAustria2012
AnnualPersonFamily member of EU Blue Cards holderAustriaCyprus2012
AnnualPersonFamily member of EU Blue Cards holderAustriaEstonia2012
AnnualPersonFamily member of EU Blue Cards holderAustriaGreece2012
AnnualPersonFamily member of EU Blue Cards holderAustriaLuxembourg2012
AnnualPersonFamily member of EU Blue Cards holderAustriaMalta2012
AnnualPersonFamily member of EU Blue Cards holderAustriaNetherlands2012
AnnualPersonFamily member of EU Blue Cards holderAustriaRomania2012
AnnualPersonFamily member of EU Blue Cards holderAustriaSlovenia2012
AnnualPersonFamily member of EU Blue Cards holderBelgiumAustria2012

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "pers_cat" VARCHAR,
  "c_resid" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" VARCHAR
);

Share link

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