Baselight

Persons Reporting An Accident At Work By Sex, Age And Occupation

Eurostat code: hsw_ac7 ยท (2007 - 2020)

@eurostat.hsw_ac7

Persons Reporting An Accident At Work By Sex, Age And Occupation - Unpivoted
@eurostat.hsw_ac7.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.

  • 15.15 KB
  • 5164 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

isco08

Isco08

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsAustria20073.9
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsBelgium20071.8
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsCzechia20070.5
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsDenmark20074.2
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsEuro area - 19 countries (2015-2022)20071.9
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsSpain20071.8
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsEuropean Union - 27 countries (from 2020)20071.7
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsEuropean Union - 28 countries (2013-2020)20071.7
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsFinland20073.7
AnnualFemalesFrom 15 to 34 yearsManagers, professionals, technicians and associate professionalsPercentage of persons employed and previously employed within 12 monthsFrance20073.4

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

Share link

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