Baselight

Average Number Of Actual Weekly Hours Of Work In The Second Job, By Sex, Age, Professional Status, Economic Activity And Full-time/part-time In The First Job (1998-2008, NACE Rev. 1.1)

Eurostat code: lfsa_ewh2na ยท (1992 - 2008)

@eurostat.lfsa_ewh2na

Average Number Of Actual Weekly Hours Of Work In The Second Job, By Sex, Age, Professional Status, Economic Activity And Full-time/part-time In The First Job (1998-2008, NACE Rev. 1.1) - Unpivoted
@eurostat.lfsa_ewh2na.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.41 MB
  • 1493122 rows
  • 10 columns
freq

Freq

nace_r1

Nace R1

wstatus

Wstatus

worktime

Worktime

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 15 to 34 yearsMalesHourItaly199218.4
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 15 to 34 yearsTotalHourItaly199217.1
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 15 to 64 yearsFemalesHourItaly19929.4
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 15 to 64 yearsMalesHourItaly199216.3
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 15 to 64 yearsTotalHourItaly199215.3
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 20 to 64 yearsFemalesHourItaly19929.4
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 20 to 64 yearsMalesHourItaly199216.4
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 20 to 64 yearsTotalHourItaly199215.4
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 25 to 54 yearsMalesHourItaly199216.2
AnnualAgriculture, hunting and forestryContributing family workersFull-timeFrom 25 to 54 yearsTotalHourItaly199215.3

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

Share link

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