Dataset: Detailed Deaths Related To Transport Accidents Occurring In The EU

About this Dataset

Detailed Deaths Related To Transport Accidents Occurring In The EU

This Eurostat dataset contains data on detailed deaths related to transport accidents occurring in the eu, as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-03-21T11:00:00+0100

Tables

Detailed Deaths Related To Transport Accidents Occurring In The EU - Raw

@eurostat.hlth_cd_troeu.raw

36.42 KB
1037 rows
18 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "icd10" VARCHAR,
  "geo" VARCHAR,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE
);

Detailed Deaths Related To Transport Accidents Occurring In The EU - Unpivoted

@eurostat.hlth_cd_troeu.tidy

22.72 KB
5750 rows
8 columns


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