Baselight
Sign In

Accidents At Work By ISCO And Employment Status (NACE Rev. 2 Activity A, C-N)

Eurostat code: hsw_mi05 ยท (2008 - 2022)

@eurostat.hsw_mi05

Accidents At Work By ISCO And Employment Status (NACE Rev. 2 Activity A, C-N) - Unpivoted
@eurostat.hsw_mi05.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.

  • 364.03 KB
  • 187229 rows
  • 9 columns
freq

Freq

unit

Unit

isco88

Isco88

wstatus

Wstatus

severity

Severity

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyAustria200871
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyCyprus200814
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyDenmark20084
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyEuropean Union - 15 countries (1995-2004)20082466.86
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyFrance20082326
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyIreland20086
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyLuxembourg200859
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economyRomania200827
AnnualNumberArmed forcesPersons employed or previously employed4 days or overAgriculture; industry and construction (except mining); services of the business economySlovenia200810
AnnualNumberArmed forcesOthers4 days or overAgriculture; industry and construction (except mining); services of the business economyFrance2008128

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "isco88" VARCHAR,
  "wstatus" VARCHAR,
  "severity" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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