Population By Sex, Age, Migration Status, Country Of Birth And Country Of Birth Of Parents
Eurostat code: lfso_14pcobp ยท (2014 - 2014)
@eurostat.lfso_14pcobp
Population By Sex, Age, Migration Status, Country Of Birth And Country Of Birth Of Parents - Unpivoted
@eurostat.lfso_14pcobp.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.
- 171.4 KB
- 65772 rows
- 10 columns
freqFreq | unitUnit | c_bthparC Bthpar | c_birthC Birth | mgstatusMgstatus | ageAge | sexSex | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|---|---|
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Austria | 2014 | 26.7 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Belgium | 2014 | 28.9 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Switzerland | 2014 | 33.1 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Cyprus | 2014 | 3.4 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Czechia | 2014 | 5.7 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Germany | 2014 | 63.4 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Greece | 2014 | 5.8 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Spain | 2014 | 82.6 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Finland | 2014 | 4 |
| Annual | Thousand persons | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020) | Foreign-born (first generation) | From 15 to 24 years | Females | Hungary | 2014 | 4.4 |
CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"c_bthpar" VARCHAR,
"c_birth" VARCHAR,
"mgstatus" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);