Baselight

Employment By Sex, Age And Professional Status (1–000)

Eurostat code: lfsa_egaps · (1983 - 2024)

@eurostat.lfsa_egaps

Employment By Sex, Age And Professional Status (1–000) - Unpivoted
@eurostat.lfsa_egaps.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.

  • 2.74 MB
  • 851882 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

wstatus

Wstatus

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 19 yearsContributing family workersGermany198316.4
AnnualThousand personsFemalesFrom 15 to 19 yearsContributing family workersGreece198323.2
AnnualThousand personsFemalesFrom 15 to 19 yearsContributing family workersItaly198334.4
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsBelgium198342.2
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsGermany1983860.8
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsDenmark198365.2
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsGreece198359.7
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsFrance1983289.1
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsIreland198340.2
AnnualThousand personsFemalesFrom 15 to 19 yearsEmployed personsItaly1983370.2

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

Share link

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