Baselight

Mean Annual Holidays By Sex, Age, Occupation

Eurostat code: earn_ses_agt42 ยท (2002 - 2002)

@eurostat.earn_ses_agt42

Mean Annual Holidays By Sex, Age, Occupation - Unpivoted
@eurostat.earn_ses_agt42.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.

  • 12.97 KB
  • 7086 rows
  • 8 columns
freq

Freq

age

Age

isco88

Isco88

unit

Unit

sex

Sex

geo

Geo

time_period

Time Period

value

Value

AnnualTotalArmed forcesDayFemalesCzechia200233
AnnualTotalArmed forcesDayFemalesEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)200224
AnnualTotalArmed forcesDayFemalesEuro area - 12 countries (2001-2006)200223
AnnualTotalArmed forcesDayFemalesEuropean Union - 15 countries (1995-2004)200223
AnnualTotalArmed forcesDayFemalesEuropean Union - 25 countries (2004-2006)200224
AnnualTotalArmed forcesDayFemalesLithuania200222
AnnualTotalArmed forcesDayFemalesNetherlands200224
AnnualTotalArmed forcesDayFemalesNew Member States - 10 countries (2004-2006)200225
AnnualTotalArmed forcesDayFemalesNorway200223
AnnualTotalArmed forcesDayFemalesSlovenia2002

CREATE TABLE tidy (
  "freq" VARCHAR,
  "age" VARCHAR,
  "isco88" 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.