Baselight

Persons Reporting An Accident At Work By Sex And Country Of Birth

Eurostat code: hsw_ac12 ยท (2007 - 2020)

@eurostat.hsw_ac12

Persons Reporting An Accident At Work By Sex And Country Of Birth - Unpivoted
@eurostat.hsw_ac12.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.

  • 8.87 KB
  • 1292 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

c_birth

C Birth

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesFrom 15 to 64 yearsEU27 countries (from 2020) except reporting countryPercentage of persons employed and previously employed within 12 monthsSpain20072.3
AnnualFemalesFrom 15 to 64 yearsEU27 countries (from 2020) except reporting countryPercentage of persons employed and previously employed within 12 monthsEuropean Union - 28 countries (2013-2020)20072.1
AnnualFemalesFrom 15 to 64 yearsEU27 countries (from 2020) except reporting countryPercentage of persons employed and previously employed within 12 monthsItaly20071.9
AnnualFemalesFrom 15 to 64 yearsEU27 countries (from 2020) except reporting countryPercentage of persons employed and previously employed within 12 monthsLuxembourg20073.1
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsAustria20075.2
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsCyprus20071.9
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsCzechia20072.3
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsDenmark20073.7
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsEuro area - 19 countries (2015-2022)20072.5
AnnualFemalesFrom 15 to 64 yearsForeign countryPercentage of persons employed and previously employed within 12 monthsEstonia20073.3

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

Share link

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