Passenger Cars, By Type Of Motor Energy And Size Of Engine

Eurostat code: road_eqs_carmot · (1970 - 2023)

@eurostat.road_eqs_carmot

Table List

2 tables(135.47 KB)

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

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

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

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

50.68 KB
6765 rows
7 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	engine Engine	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Total	Belgium	1970	2060000
Annual	Number	Total	Total	Bulgaria	1970	164430
Annual	Number	Total	Total	Czechia	1970	728000
Annual	Number	Total	Total	Germany	1970	13941000
Annual	Number	Total	Total	Denmark	1970	1077000
Annual	Number	Total	Total	Greece	1970	227000
Annual	Number	Total	Total	Spain	1970	5017000
Annual	Number	Total	Total	France	1970	12470000
Annual	Number	Total	Total	Croatia	1970	184000
Annual	Number	Total	Total	Ireland	1970	389000


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.