All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year

Eurostat code: migr_resvas$dv_1282

@eurostat.migr_resvas_dv_1282

Table List

2 tables(44.43 KB)

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Raw

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Unpivoted

All Valid Permits By Age, Sex And Citizenship On 31 December Of Each Year - Raw

@eurostat.migr_resvas_dv_1282.raw

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

25.13 KB
464 rows
16 columns

freq Freq	sex Sex	age Age	citizen Citizen	unit Unit	geo Geo	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023
Annual	Females	From 0 to 14 years	Total	Person	Austria		38799	39792	39718
Annual	Females	From 0 to 14 years	Total	Person	Belgium		46259	46906	46737
Annual	Females	From 0 to 14 years	Total	Person	Bulgaria		2338	2254	2638
Annual	Females	From 0 to 14 years	Total	Person	Switzerland		64245	64137	64439
Annual	Females	From 0 to 14 years	Total	Person	Cyprus		5299	7202	8126
Annual	Females	From 0 to 14 years	Total	Person	Czechia		24414	23268	25297
Annual	Females	From 0 to 14 years	Total	Person	Germany		272384	331751	361709
Annual	Females	From 0 to 14 years	Total	Person	Denmark		9379
Annual	Females	From 0 to 14 years	Total	Person	Estonia		4445	4630	4631
Annual	Females	From 0 to 14 years	Total	Person	Greece	51003	50148	38756	36177


CREATE TABLE raw (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "citizen" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "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.