Accidents Involving The Transport Of Dangerous Goods - Annual Data (2004-2015)

Eurostat code: rail_ac_dnggood · (2004 - 2016)

@eurostat.rail_ac_dnggood

Table List

2 tables(20.07 KB)

Accidents Involving The Transport Of Dangerous Goods - Annual Data (2004-2015) - Raw

Accidents Involving The Transport Of Dangerous Goods - Annual Data (2004-2015) - Unpivoted

Accidents Involving The Transport Of Dangerous Goods - Annual Data (2004-2015) - Unpivoted

@eurostat.rail_ac_dnggood.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.45 KB
1179 rows
6 columns

freq Freq	unit Unit	accident Accident	geo Geo	time_period Time Period	value Value
Annual	Number	Accidents involving transport of dangerous goods	Austria	2004	23
Annual	Number	Accidents involving transport of dangerous goods	Belgium	2004
Annual	Number	Accidents involving transport of dangerous goods	Czechia	2004
Annual	Number	Accidents involving transport of dangerous goods	Germany	2004	14
Annual	Number	Accidents involving transport of dangerous goods	Denmark	2004
Annual	Number	Accidents involving transport of dangerous goods	Estonia	2004
Annual	Number	Accidents involving transport of dangerous goods	Greece	2004
Annual	Number	Accidents involving transport of dangerous goods	Spain	2004	2
Annual	Number	Accidents involving transport of dangerous goods	Finland	2004
Annual	Number	Accidents involving transport of dangerous goods	France	2004	4


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

Share link

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