Baselight

Number Of Employees Working On Call By Sex, Age, Occupation And Economic Activity

Eurostat code: lfso_04oncwisna ยท (2004 - 2004)

@eurostat.lfso_04oncwisna

Number Of Employees Working On Call By Sex, Age, Occupation And Economic Activity - Unpivoted
@eurostat.lfso_04oncwisna.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.

  • 95.35 KB
  • 25846 rows
  • 9 columns
freq

Freq

sex

Sex

age

Age

nace_r1

Nace R1

ynlfs

Ynlfs

isco88

Isco88

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingNo answerSkilled manual workersGermany200412.5
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingNo answerTotalGermany200415.8
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobSkilled manual workersSwitzerland20043.1
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobSkilled manual workersNetherlands20045
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobSkilled manual workersNorway20041.8
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobElementary occupationsSpain200412.8
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobElementary occupationsNetherlands20042.8
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobTotalSwitzerland20043.7
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobTotalCzechia20041.7
AnnualFemalesFrom 15 to 24 yearsAgriculture; fishingPerson is not on an on-call jobTotalDenmark20044.3

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "nace_r1" VARCHAR,
  "ynlfs" VARCHAR,
  "isco88" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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