Transport By Type Of Good (from 2007 Onwards With NST2007)

Eurostat code: iww_go_atygo · (2007 - 2023)

@eurostat.iww_go_atygo

Table List

2 tables(1008.06 KB)

Transport By Type Of Good (from 2007 Onwards With NST2007) - Raw

Transport By Type Of Good (from 2007 Onwards With NST2007) - Unpivoted

Transport By Type Of Good (from 2007 Onwards With NST2007) - Unpivoted

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

518.55 KB
198040 rows
8 columns

freq Freq	tra_cov Tra Cov	nst07 Nst07	typpack Typpack	unit Unit	geo Geo	time_period Time Period	value Value
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	Belgium	2007	272
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	Germany	2007	3143
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	France	2007	890
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	Hungary	2007	366
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	Netherlands	2007	747
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Million tonne-kilometre (TKM)	Poland	2007	4
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Thousand tonnes	Belgium	2007	3874
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Thousand tonnes	Germany	2007	7344
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Thousand tonnes	France	2007	7195
Annual	International transport	Products of agriculture, hunting, and forestry; fish and other fishing products	Goods not in containers and empty containers	Thousand tonnes	Hungary	2007	2238


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

Share link

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