Transport Of Dangerous Goods

Eurostat code: iww_go_adago · (2007 - 2023)

@eurostat.iww_go_adago

Table List

2 tables(48.61 KB)

Transport Of Dangerous Goods - Unpivoted

Transport Of Dangerous Goods - Unpivoted

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

18.78 KB
5994 rows
7 columns

freq Freq	unit Unit	dang_gds Dang Gds	tra_cov Tra Cov	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	1. Explosives	International transport	Hungary	2007
Annual	Million tonne-kilometre (TKM)	1. Explosives	Total transport	Hungary	2007
Annual	Million tonne-kilometre (TKM)	3. Flammable liquids	International transport	Hungary	2007	163
Annual	Million tonne-kilometre (TKM)	3. Flammable liquids	National transport	Hungary	2007	3
Annual	Million tonne-kilometre (TKM)	3. Flammable liquids	Total transport	Hungary	2007	201
Annual	Million tonne-kilometre (TKM)	3. Flammable liquids	Transit	Hungary	2007	34
Annual	Million tonne-kilometre (TKM)	4.1. Flammable solids	International transport	Hungary	2007	7
Annual	Million tonne-kilometre (TKM)	4.1. Flammable solids	Total transport	Hungary	2007	16
Annual	Million tonne-kilometre (TKM)	4.1. Flammable solids	Transit	Hungary	2007	9
Annual	Million tonne-kilometre (TKM)	5.2. Organic peroxides	Total transport	Hungary	2007	4


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

Share link

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