Population By Sex, Age, Migration Status, Citizenship And Educational Attainment Level
Eurostat code: lfsa_pganedm$dv_1806
@eurostat.lfsa_pganedm_dv_1806
Eurostat code: lfsa_pganedm$dv_1806
@eurostat.lfsa_pganedm_dv_1806
CREATE TABLE raw (
"freq" VARCHAR,
"isced11" VARCHAR,
"citizen" VARCHAR,
"mgstatus" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_2021" DOUBLE,
"n_2022" DOUBLE,
"n_2023" DOUBLE,
"n_2024" DOUBLE
);
CREATE TABLE tidy (
"freq" VARCHAR,
"isced11" VARCHAR,
"citizen" VARCHAR,
"mgstatus" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.