First Permits By Reason, Length Of Validity And Citizenship
Eurostat code: migr_resfirst ยท (2008 - 2023)
@eurostat.migr_resfirst
First Permits By Reason, Length Of Validity And Citizenship - Raw
@eurostat.migr_resfirst.raw
This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.
- 1.99 MB
- 121024 rows
- 22 columns
freqFreq | reasonReason | citizenCitizen | durationDuration | unitUnit | geoGeo | n_20082008 | n_20092009 | n_20102010 | n_20112011 | n_20122012 | n_20132013 | n_20142014 | n_20152015 | n_20162016 | n_20172017 | n_20182018 | n_20192019 | n_20202020 | n_20212021 | n_20222022 | n_20232023 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Austria | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Belgium | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Bulgaria | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Switzerland | 2 | 2 | 1 | |||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Cyprus | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Czechia | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Germany | 1 | 1 | 2 | 2 | ||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Denmark | 1 | 1 | ||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Estonia | ||||||||||||||||
| Annual | Education reasons | Andorra | From 3 to 5 months | Person | Greece |
CREATE TABLE raw (
"freq" VARCHAR,
"reason" VARCHAR,
"citizen" VARCHAR,
"duration" VARCHAR,
"unit" 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
);