Baselight

Employed Persons By Job Autonomy, Economic Activity And Occupation

Eurostat code: lfso_22wrkm03 ยท (2022 - 2022)

@eurostat.lfso_22wrkm03

Employed Persons By Job Autonomy, Economic Activity And Occupation - Unpivoted
@eurostat.lfso_22wrkm03.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.63 MB
  • 1029821 rows
  • 10 columns
freq

Freq

isco08

Isco08

nace_r2

Nace R2

job_autn

Job Autn

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNo responseAgriculture, forestry and fishingAt most some on order and contentFrom 15 to 64 yearsTotalThousand personsPoland202211.9
AnnualNo responseAgriculture, forestry and fishingAt most some on order and contentFrom 15 to 74 yearsTotalThousand personsPoland202211.9
AnnualNo responseAgriculture, forestry and fishingAt most some on order and contentFrom 20 to 64 yearsTotalThousand personsPoland202211.9
AnnualNo responseAgriculture, forestry and fishingTotalFrom 15 to 64 yearsTotalThousand personsPoland202211.9
AnnualNo responseAgriculture, forestry and fishingTotalFrom 15 to 74 yearsTotalThousand personsPoland202211.9
AnnualNo responseAgriculture, forestry and fishingTotalFrom 20 to 64 yearsTotalThousand personsPoland202211.9
AnnualNo responseIndustry (except construction)At most some on order and contentFrom 15 to 24 yearsTotalThousand personsSwitzerland20224.4
AnnualNo responseIndustry (except construction)At most some on order and contentFrom 15 to 29 yearsTotalThousand personsSwitzerland20224.4
AnnualNo responseIndustry (except construction)At most some on order and contentFrom 15 to 64 yearsFemalesThousand personsSwitzerland20223.7
AnnualNo responseIndustry (except construction)At most some on order and contentFrom 15 to 64 yearsMalesThousand personsSwitzerland20226.6

CREATE TABLE tidy (
  "freq" VARCHAR,
  "isco08" VARCHAR,
  "nace_r2" VARCHAR,
  "job_autn" 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.