Goods Transported By Group Of Goods - From 2008 Onwards Based On NST 2007

Eurostat code: rail_go_grpgood · (2008 - 2024)

@eurostat.rail_go_grpgood

Table List

2 tables(151.17 KB)

Goods Transported By Group Of Goods - From 2008 Onwards Based On NST 2007 - Raw

Goods Transported By Group Of Goods - From 2008 Onwards Based On NST 2007 - Unpivoted

Goods Transported By Group Of Goods - From 2008 Onwards Based On NST 2007 - Unpivoted

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

61.1 KB
19203 rows
6 columns

freq Freq	unit Unit	nst07 Nst07	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Belgium	2008	159
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Bulgaria	2008	145
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Switzerland	2008	420
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Czechia	2008	632
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Germany	2008	3799
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Denmark	2008	47
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Estonia	2008	122
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Greece	2008	25
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Spain	2008	219
Annual	Million tonne-kilometre (TKM)	Products of agriculture, hunting, and forestry; fish and other fishing products	Finland	2008	2908


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

Share link

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