Lorries And Road Tractors By Age (until 2012)

Eurostat code: road_eqs_lorroa_h · (1970 - 2012)

@eurostat.road_eqs_lorroa_h

Table List

2 tables(103.26 KB)

Lorries And Road Tractors By Age (until 2012) - Raw

Lorries And Road Tractors By Age (until 2012) - Unpivoted

Lorries And Road Tractors By Age (until 2012) - Unpivoted

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

39.09 KB
4960 rows
7 columns

freq Freq	unit Unit	vehicle Vehicle	age Age	geo Geo	time_period Time Period	value Value
Annual	Number	Lorries	Total	Belgium	1970	186639
Annual	Number	Lorries	Total	Czechia	1970	89000
Annual	Number	Lorries	Total	Germany	1970	1028116
Annual	Number	Lorries	Total	Denmark	1970	245347
Annual	Number	Lorries	Total	Greece	1970	105032
Annual	Number	Lorries	Total	Spain	1970	1100000
Annual	Number	Lorries	Total	France	1970	1504100
Annual	Number	Lorries	Total	Italy	1970	1260560
Annual	Number	Lorries	Total	Lithuania	1970	47386
Annual	Number	Lorries	Total	Luxembourg	1970	8528


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

Share link

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