Baselight

People Reporting Having Had An Accident By Sex, Age And Educational Attainment Level (%)

Eurostat code: hlth_ehis_st2 ยท (2008 - 2008)

@eurostat.hlth_ehis_st2

People Reporting Having Had An Accident By Sex, Age And Educational Attainment Level (%) - Unpivoted
@eurostat.hlth_ehis_st2.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.

  • 10.4 KB
  • 2507 rows
  • 8 columns
freq

Freq

sex

Sex

age

Age

accident

Accident

isced97

Isced97

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Belgium20086
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Bulgaria20083.2
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Cyprus20083.5
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Czechia200811.4
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Greece20083.5
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Spain20088.7
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Hungary20088.5
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Latvia20087.7
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Malta200812.3
AnnualFemalesTotalAccident at home / school / leisurePre-primary, primary and lower secondary education (levels 0-2)Poland20083.1

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

Share link

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