Persons Reporting An Accident At Work By Sex, Age And Professional Status

Eurostat code: hsw_ac8$dv_386

@eurostat.hsw_ac8_dv_386

Table List

2 tables(14.31 KB)

Persons Reporting An Accident At Work By Sex, Age And Professional Status - Raw

Persons Reporting An Accident At Work By Sex, Age And Professional Status - Unpivoted

Persons Reporting An Accident At Work By Sex, Age And Professional Status - Unpivoted

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

6.8 KB
95 rows
8 columns

freq Freq	sex Sex	age Age	wstatus Wstatus	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Austria	2007	5.1
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Belgium	2007	3.2
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Bulgaria	2007	0.6
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Cyprus	2007	3
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Czechia	2007	2.6
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Germany	2007	2.9
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Denmark	2007	5
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Estonia	2007	2.4
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Greece	2007	1.8
Annual	Total	From 15 to 64 years	Employed persons	Percentage of persons employed and previously employed within 12 months	Spain	2007	3.9


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

Share link

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