Employed Persons By Economic Activity And NUTS 2 Region (NACE Rev. 2) (2008-2026)
Eurostat code: lfst_r_lfe2en2$dv_3150
@eurostat.lfst_r_lfe2en2_dv_3150
Eurostat code: lfst_r_lfe2en2$dv_3150
@eurostat.lfst_r_lfe2en2_dv_3150
This Eurostat dataset contains data on employed persons by economic activity and nuts 2 region (nace rev. 2) (2008-2026), as collected and published by the Statistical Office of the European Union.
raw: Original table as downloaded from Eurostat.tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2025-09-11T23:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"nace_r2" VARCHAR,
"age" VARCHAR,
"sex" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_2015" DOUBLE -- 2015,
"n_2016" DOUBLE -- 2016,
"n_2017" DOUBLE -- 2017,
"n_2018" DOUBLE -- 2018,
"n_2019" DOUBLE -- 2019,
"n_2020" DOUBLE -- 2020,
"n_2021" DOUBLE -- 2021,
"n_2022" DOUBLE -- 2022,
"n_2023" DOUBLE -- 2023,
"n_2024" DOUBLE -- 2024
);CREATE TABLE tidy (
"freq" VARCHAR,
"nace_r2" 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.