Baselight
Sign In

National Annual Road Freight Transport By Region Of Loading, Group Of Goods And Other Typologies

Eurostat code: urt_road_gonl ยท (2008 - 2023)

@eurostat.urt_road_gonl

National Annual Road Freight Transport By Region Of Loading, Group Of Goods And Other Typologies - Unpivoted
@eurostat.urt_road_gonl.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.

  • 167.74 KB
  • 35667 rows
  • 7 columns
freq

Freq

unit

Unit

terrtypo

Terrtypo

nst07

Nst07

geo

Geo

time_period

Time Period

value

Value

AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsAustria200813555
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsCzechia200840715
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsDenmark20085283
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsEstonia2008928
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsHungary200822346
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsIreland20082749
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsLithuania20084765
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsLuxembourg2008241
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsLatvia20086779
AnnualThousand tonnesBorder regionsProducts of agriculture, hunting, and forestry; fish and other fishing productsNorway20089177

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

Share link

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