Baselight

Employees By Sex, Age And Economic Activity (1983-2008, NACE Rev. 1.1) (1–000)

Eurostat code: lfsa_eegana · (1992 - 2008)

@eurostat.lfsa_eegana

Employees By Sex, Age And Economic Activity (1983-2008, NACE Rev. 1.1) (1–000) - Unpivoted
@eurostat.lfsa_eegana.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.

  • 1.66 MB
  • 578424 rows
  • 8 columns
freq

Freq

unit

Unit

sex

Sex

age

Age

nace_r1

Nace R1

geo

Geo

time_period

Time Period

value

Value

AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture, hunting and forestryItaly19927.4
AnnualThousand personsFemalesFrom 15 to 19 yearsAgriculture; fishingItaly19927.4
AnnualThousand personsFemalesFrom 15 to 19 yearsIndustryItaly1992100.5
AnnualThousand personsFemalesFrom 15 to 19 yearsIndustry and services (except public administration and community services; activities of households and extra-territorial organizations)Italy1992156.7
AnnualThousand personsFemalesFrom 15 to 19 yearsManufacturingItaly199296.5
AnnualThousand personsFemalesFrom 15 to 19 yearsWholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goodsItaly199230.2
AnnualThousand personsFemalesFrom 15 to 19 yearsServices (except public administration and community services; activities of households and extra-territorial organizations)Italy199256.2
AnnualThousand personsFemalesFrom 15 to 19 yearsServicesItaly199294.6
AnnualThousand personsFemalesFrom 15 to 19 yearsHotels and restaurantsItaly199213.8
AnnualThousand personsFemalesFrom 15 to 19 yearsReal estate, renting and business activitiesItaly199210

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

Share link

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