Goods Transported By Group Of Goods - Until 2007 Based On NST/R

Eurostat code: rail_go_grgood7 · (2003 - 2007)

@eurostat.rail_go_grgood7

Table List

2 tables(57.43 KB)

Goods Transported By Group Of Goods - Until 2007 Based On NST/R - Raw

Goods Transported By Group Of Goods - Until 2007 Based On NST/R - Unpivoted

Goods Transported By Group Of Goods - Until 2007 Based On NST/R - Unpivoted

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

25.61 KB
6344 rows
6 columns

freq Freq	unit Unit	nstr24 Nstr24	geo Geo	time_period Time Period	value Value
Annual	Million tonne-kilometre (TKM)	Cereals	Belgium	2003	46
Annual	Million tonne-kilometre (TKM)	Cereals	Czechia	2003	160
Annual	Million tonne-kilometre (TKM)	Cereals	Germany	2003	487
Annual	Million tonne-kilometre (TKM)	Cereals	Denmark	2003	1
Annual	Million tonne-kilometre (TKM)	Cereals	Estonia	2003	270
Annual	Million tonne-kilometre (TKM)	Cereals	Spain	2003	341
Annual	Million tonne-kilometre (TKM)	Cereals	Finland	2003	15
Annual	Million tonne-kilometre (TKM)	Cereals	France	2003	3694
Annual	Million tonne-kilometre (TKM)	Cereals	Hungary	2003	80
Annual	Million tonne-kilometre (TKM)	Cereals	Ireland	2003


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

Share link

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