Baselight
Sign In

Road Freight Transport By Type Of Cargo And Distance Class (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data

Eurostat code: road_go_ta_tcrg ยท (1999 - 2023)

@eurostat.road_go_ta_tcrg

Road Freight Transport By Type Of Cargo And Distance Class (t, Tkm, Vehicle-km, Basic Transport Operations) - Annual Data - Unpivoted
@eurostat.road_go_ta_tcrg.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.

  • 429.14 KB
  • 134692 rows
  • 7 columns
freq

Freq

unit

Unit

cargo

Cargo

distance

Distance

geo

Geo

time_period

Time Period

value

Value

AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmAustria199980
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmBelgium19991170
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmGermany19993777
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmFinland1999128
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmFrance1999744
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmItaly19992573
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmLuxembourg199926
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmPortugal199920
AnnualMillion tonne-kilometre (TKM)Other containersFrom 150 to 299 kmUnited Kingdom1999132
AnnualMillion tonne-kilometre (TKM)Other containersFrom 300 to 499 kmAustria199945

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

Share link

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