Passenger Cars, By Type Of Motor Energy

Eurostat code: road_eqs_carpda · (1992 - 2023)

@eurostat.road_eqs_carpda

Table List

2 tables(82.96 KB)

Passenger Cars, By Type Of Motor Energy - Raw

Passenger Cars, By Type Of Motor Energy - Unpivoted

Passenger Cars, By Type Of Motor Energy - Unpivoted

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

37.75 KB
5754 rows
6 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Germany	1992	36042408
Annual	Number	Alternative energy	Germany	2000	9000
Annual	Number	Diesel	Germany	2000	6357000
Annual	Number	Electricity	Germany	2000	3000
Annual	Number	Petroleum products	Germany	2000	37406000
Annual	Number	Total	Germany	2000	43772260
Annual	Number	Total	European Union - 27 countries (from 2020)	2000	182033003
Annual	Number	Diesel	Germany	2007	10046000
Annual	Number	Petroleum products	Germany	2007	30905000
Annual	Number	Total	Germany	2007	41184000


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

Share link

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