Deaths Related To Transport Accidents Occurring In The Country

Eurostat code: hlth_cd_tro · (2011 - 2023)

@eurostat.hlth_cd_tro

Table List

2 tables(101.74 KB)

Deaths Related To Transport Accidents Occurring In The Country - Unpivoted

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

40.21 KB
17047 rows
7 columns

freq Freq	unit Unit	sex Sex	icd10 Icd10	geo Geo	time_period Time Period	value Value
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Switzerland	2011	17
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Czechia	2011	34
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Germany	2011	254
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Denmark	2011	2
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Estonia	2011	3
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Spain	2011	76
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Finland	2011	1
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Croatia	2011	18
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Hungary	2011	9
Annual	Number	Females	Other land transport accidents, other and unspecified transport accidents (V80-V89, V98-V99)	Ireland	2011	7


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

Share link

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