Baselight
Sign In

Immigration By Broad Group Of Country Of Previous Residence

Eurostat code: migr_imm12prv ยท (2013 - 2023)

@eurostat.migr_imm12prv

Immigration By Broad Group Of Country Of Previous Residence - Unpivoted
@eurostat.migr_imm12prv.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.

  • 13.61 KB
  • 1441 rows
  • 6 columns
freq

Freq

partner

Partner

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEU27 countries (from 2020) except reporting countryNumberAustria201361893
AnnualEU27 countries (from 2020) except reporting countryNumberBelgium201373249
AnnualEU27 countries (from 2020) except reporting countryNumberBulgaria20133568
AnnualEU27 countries (from 2020) except reporting countryNumberSwitzerland2013100422
AnnualEU27 countries (from 2020) except reporting countryNumberCzechia201315695
AnnualEU27 countries (from 2020) except reporting countryNumberGermany2013393915
AnnualEU27 countries (from 2020) except reporting countryNumberDenmark201327226
AnnualEU27 countries (from 2020) except reporting countryNumberEstonia20131668
AnnualEU27 countries (from 2020) except reporting countryNumberGreece201331779
AnnualEU27 countries (from 2020) except reporting countryNumberSpain201385466

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