Passenger Cars By Age

Eurostat code: road_eqs_carage · (1992 - 2023)

@eurostat.road_eqs_carage

Table List

2 tables(51.39 KB)

Passenger Cars By Age - Unpivoted

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

21.82 KB
2331 rows
6 columns

freq Freq	unit Unit	age Age	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Germany	1992	36042408
Annual	Number	Total	Germany	2000	43772260
Annual	Number	Total	European Union - 27 countries (from 2020)	2000	182033003
Annual	Number	From 2 to 5 years	Germany	2000	10387000
Annual	Number	From 5 to 10 years	Germany	2000	15219000
Annual	Number	Less than 2 years	Germany	2000	7166000
Annual	Number	Total	Germany	2007	41184000
Annual	Number	From 2 to 5 years	Germany	2007	8531000
Annual	Number	From 5 to 10 years	Germany	2007	13362000
Annual	Number	Less than 2 years	Germany	2007	5937000


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

Share link

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