Baselight
Sign In

Lorries And Road Tractors By Age And Type Of Vehicle

Eurostat code: road_eqs_lorroa ยท (2000 - 2023)

@eurostat.road_eqs_lorroa

Lorries And Road Tractors By Age And Type Of Vehicle - Unpivoted
@eurostat.road_eqs_lorroa.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.

  • 43.27 KB
  • 5867 rows
  • 7 columns
freq

Freq

unit

Unit

vehicle

Vehicle

age

Age

geo

Geo

time_period

Time Period

value

Value

AnnualNumberRoad tractorsTotalGermany2000171124
AnnualNumberRoad tractorsFrom 2 to 5 yearsGermany200054525
AnnualNumberRoad tractorsFrom 5 to 10 yearsGermany200043409
AnnualNumberRoad tractorsLess than 2 yearsGermany200055668
AnnualNumberRoad tractorsTotalGermany2007179935
AnnualNumberRoad tractorsFrom 2 to 5 yearsGermany200764049
AnnualNumberRoad tractorsFrom 5 to 10 yearsGermany200736449
AnnualNumberRoad tractorsLess than 2 yearsGermany200768571
AnnualNumberRoad tractorsTotalPoland2012257226
AnnualNumberRoad tractorsFrom 2 to 5 yearsPoland201242755

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

Share link

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