Immigration By Age Group, Sex And Country Of Birth

Eurostat code: migr_imm3ctb · (2008 - 2023)

@eurostat.migr_imm3ctb

Table List

2 tables(17.53 MB)

Immigration By Age Group, Sex And Country Of Birth - Raw

Immigration By Age Group, Sex And Country Of Birth - Unpivoted

Immigration By Age Group, Sex And Country Of Birth - Raw

@eurostat.migr_imm3ctb.raw

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

8.96 MB
962205 rows
23 columns

freq Freq	age Age	agedef Agedef	c_birth C Birth	unit Unit	sex Sex	geo Geo	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	n_2023 2023
Annual	Total	Age in completed years	Andorra	Number	Females	Austria						1			1
Annual	Total	Age in completed years	Andorra	Number	Females	Belgium	3		3	3	2		1		2					5
Annual	Total	Age in completed years	Andorra	Number	Females	Bulgaria
Annual	Total	Age in completed years	Andorra	Number	Females	Switzerland		4	6	5	7	6	6		8	3	6
Annual	Total	Age in completed years	Andorra	Number	Females	Czechia
Annual	Total	Age in completed years	Andorra	Number	Females	Germany											5	4	1	1
Annual	Total	Age in completed years	Andorra	Number	Females	Denmark					1		1	2
Annual	Total	Age in completed years	Andorra	Number	Females	Estonia						1		1		1
Annual	Total	Age in completed years	Andorra	Number	Females	Finland									1		1
Annual	Total	Age in completed years	Andorra	Number	Females	Croatia


CREATE TABLE raw (
  "freq" VARCHAR,
  "age" VARCHAR,
  "agedef" VARCHAR,
  "c_birth" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "geo" VARCHAR,
  "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,
  "n_2023" DOUBLE
);

Share link

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