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

Eurostat code: lfsa_egana · (1992 - 2008)

@eurostat.lfsa_egana

Table List

2 tables(3.51 MB)

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

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

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

@eurostat.lfsa_egana.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
560099 rows
8 columns

freq Freq	unit Unit	sex Sex	age Age	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	Females	From 15 to 24 years	Agriculture, hunting and forestry	Italy	1992	48.9
Annual	Thousand persons	Females	From 15 to 24 years	Agriculture; fishing	Italy	1992	49.1
Annual	Thousand persons	Females	From 15 to 24 years	Mining and quarrying	Italy	1992	3.6
Annual	Thousand persons	Females	From 15 to 24 years	Industry	Italy	1992	388.3
Annual	Thousand persons	Females	From 15 to 24 years	Industry and services (except public administration and community services; activities of households and extra-territorial organizations)	Italy	1992	773.5
Annual	Thousand persons	Females	From 15 to 24 years	Manufacturing	Italy	1992	365.3
Annual	Thousand persons	Females	From 15 to 24 years	Construction	Italy	1992	18.2
Annual	Thousand persons	Females	From 15 to 24 years	Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods	Italy	1992	186.6
Annual	Thousand persons	Females	From 15 to 24 years	Services (except public administration and community services; activities of households and extra-territorial organizations)	Italy	1992	385.2
Annual	Thousand persons	Females	From 15 to 24 years	Services	Italy	1992	620.9


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.