Transport Of Dangerous Goods

Eurostat code: rail_go_dnggood · (2003 - 2024)

@eurostat.rail_go_dnggood

Table List

2 tables(101.65 KB)

Transport Of Dangerous Goods - Unpivoted

Transport Of Dangerous Goods - Unpivoted

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

37.65 KB
15575 rows
6 columns

freq Freq	dang_gds Dang Gds	unit Unit	geo Geo	time_period Time Period	value Value
Annual	8. Corrosives	Million tonne-kilometre (TKM)	Sweden	2003	136
Annual	8. Corrosives	Thousand tonnes	Sweden	2003	241
Annual	9. Miscellaneous dangerous substances	Million tonne-kilometre (TKM)	Sweden	2003	13
Annual	9. Miscellaneous dangerous substances	Thousand tonnes	Sweden	2003	10
Annual	1. Explosives	Million tonne-kilometre (TKM)	Sweden	2003
Annual	1. Explosives	Thousand tonnes	Sweden	2003	1
Annual	3. Flammable liquids	Million tonne-kilometre (TKM)	Sweden	2003	167
Annual	3. Flammable liquids	Thousand tonnes	Sweden	2003	482
Annual	4.1. Flammable solids	Million tonne-kilometre (TKM)	Sweden	2003	12
Annual	4.1. Flammable solids	Thousand tonnes	Sweden	2003	18


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

Share link

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