Baselight

Employees By Sex, Age And Economic Activity (from 2008 Onwards, NACE Rev. 2) - 1–000

Eurostat code: lfsa_eegan2 · (2008 - 2024)

@eurostat.lfsa_eegan2

Employees By Sex, Age And Economic Activity (from 2008 Onwards, NACE Rev. 2) - 1–000 - Unpivoted
@eurostat.lfsa_eegan2.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.

  • 1.99 MB
  • 772116 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingGermany20085.8
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingEuro area – 20 countries (from 2023)200823.3
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingSpain20083.1
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingEuropean Union - 27 countries (from 2020)200826.5
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingNetherlands20088.3
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingNorway20081.4
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, forestry and fishingUnited Kingdom20084.4
AnnualThousand personsFemalesFrom 15 to 19 yearsManufacturingAustria20087.1
AnnualThousand personsFemalesFrom 15 to 19 yearsManufacturingSwitzerland20085
AnnualThousand personsFemalesFrom 15 to 19 yearsManufacturingCzechia20084.3

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.