Baselight

Duration Of Working Life

Eurostat code: lfsi_dwl_a ยท (2000 - 2024)

@eurostat.lfsi_dwl_a

Duration Of Working Life - Unpivoted
@eurostat.lfsi_dwl_a.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.

  • 9.37 KB
  • 2595 rows
  • 6 columns
freq

Freq

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualYearFemalesAustria200029.7
AnnualYearFemalesBelgium200026.4
AnnualYearFemalesBulgaria200026.9
AnnualYearFemalesSwitzerland200035.4
AnnualYearFemalesCyprus200027.9
AnnualYearFemalesCzechia200030.3
AnnualYearFemalesGermany200030.8
AnnualYearFemalesDenmark200036.3
AnnualYearFemalesEstonia200032.6
AnnualYearFemalesGreece200024.7

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

Share link

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