Inland Waterway Transport By Type Of Goods And Country/region Of Loading And Unloading (1982-2007)

Eurostat code: iww_go_atygof07 · (1982 - 2007)

@eurostat.iww_go_atygof07

Table List

2 tables(1.43 MB)

Inland Waterway Transport By Type Of Goods And Country/region Of Loading And Unloading (1982-2007) - Raw

Inland Waterway Transport By Type Of Goods And Country/region Of Loading And Unloading (1982-2007) - Unpivoted

Inland Waterway Transport By Type Of Goods And Country/region Of Loading And Unloading (1982-2007) - Unpivoted

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

690.74 KB
522471 rows
8 columns

freq Freq	nstr24 Nstr24	c_unload C Unload	c_load C Load	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Cereals	Austria	Germany	Million tonne-kilometre (TKM)	Germany	1982
Annual	Cereals	Austria	Germany	Thousand tonnes	Germany	1982
Annual	Cereals	Belgium	Belgium	Million tonne-kilometre (TKM)	France	1982
Annual	Cereals	Belgium	Belgium	Million tonne-kilometre (TKM)	Netherlands	1982	6
Annual	Cereals	Belgium	Belgium	Thousand tonnes	Belgium	1982	1183
Annual	Cereals	Belgium	Belgium	Thousand tonnes	France	1982
Annual	Cereals	Belgium	Belgium	Thousand tonnes	Netherlands	1982	99
Annual	Cereals	Belgium	Région de Bruxelles-Capitale/Brussels Hoofdstedelijk Gewest	Thousand tonnes	Belgium	1982	6
Annual	Cereals	Belgium	Vlaams Gewest	Thousand tonnes	Belgium	1982	836
Annual	Cereals	Belgium	Prov. Antwerpen	Thousand tonnes	Belgium	1982	204


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nstr24" VARCHAR,
  "c_unload" VARCHAR,
  "c_load" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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