Employment By Sex, Age, Professional Status And Occupation (1–000)

Eurostat code: lfsa_egais$dv_574

@eurostat.lfsa_egais_dv_574

Table List

2 tables(76.07 KB)

Employment By Sex, Age, Professional Status And Occupation (1–000) - Raw

Employment By Sex, Age, Professional Status And Occupation (1–000) - Unpivoted

Employment By Sex, Age, Professional Status And Occupation (1–000) - Unpivoted

@eurostat.lfsa_egais_dv_574.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.

31.54 KB
4302 rows
9 columns

freq Freq	unit Unit	sex Sex	age Age	wstatus Wstatus	isco08 Isco08	geo Geo	time_period Time Period	value Value
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Austria	2005	74.6
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Belgium	2005	154.8
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Bulgaria	2005	66.3
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Switzerland	2005	70.2
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Cyprus	2005	1.4
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Czechia	2005	87.2
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Germany	2005	556.5
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Denmark	2005	48.5
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Euro area – 20 countries (from 2023)	2005	3457.5
Annual	Thousand persons	Females	15 years or over	Employed persons	Managers	Estonia	2005	28.8


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

Share link

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