Road Freight Transport By Type Of Goods And Type Of Transport (t, Tkm) - Annual Data (1999-2007)

Eurostat code: road_go_ta7tg · (1999 - 2007)

@eurostat.road_go_ta7tg

Table List

2 tables(255.55 KB)

Road Freight Transport By Type Of Goods And Type Of Transport (t, Tkm) - Annual Data (1999-2007) - Raw

Road Freight Transport By Type Of Goods And Type Of Transport (t, Tkm) - Annual Data (1999-2007) - Unpivoted

Road Freight Transport By Type Of Goods And Type Of Transport (t, Tkm) - Annual Data (1999-2007) - Unpivoted

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

111.61 KB
27588 rows
7 columns

freq Freq	tra_type Tra Type	nstr_gg Nstr Gg	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Austria	1999	225
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Belgium	1999	404
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Germany	1999	1900
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Denmark	1999	410
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Spain	1999	3516
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Finland	1999	367
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	France	1999	4112
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Ireland	1999	187
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Italy	1999	4286
Annual	Hire or reward	Cereals	Million tonne-kilometre (TKM)	Luxembourg	1999	12


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

Share link

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