New Passenger Cars By Type Of Motor Energy And Engine Size

Eurostat code: road_eqr_carmot · (1970 - 2023)

@eurostat.road_eqr_carmot

Table List

2 tables(120.58 KB)

New Passenger Cars By Type Of Motor Energy And Engine Size - Raw

New Passenger Cars By Type Of Motor Energy And Engine Size - Unpivoted

New Passenger Cars By Type Of Motor Energy And Engine Size - Unpivoted

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

46.5 KB
6059 rows
7 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	engine Engine	geo Geo	time_period Time Period	value Value
Annual	Number	Petroleum products	From 1 400 to 1 999 cm³	Ireland	1970	9843
Annual	Number	Petroleum products	2 000 cm³ or over	Ireland	1970	2355
Annual	Number	Petroleum products	Less than 1 400 cm³	Ireland	1970	40749
Annual	Number	Total	Total	Belgium	1970	295701
Annual	Number	Total	Total	Germany	1970	2107123
Annual	Number	Total	Total	Denmark	1970	108634
Annual	Number	Total	Total	Greece	1970	32354
Annual	Number	Total	Total	Spain	1970	572346
Annual	Number	Total	Total	France	1970	1296240
Annual	Number	Total	Total	Ireland	1970	52947


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

Share link

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