Passenger Cars By Alternative Motor Energy (until 2012)

Eurostat code: road_eqs_caralt · (1990 - 2012)

@eurostat.road_eqs_caralt

Table List

2 tables(32.51 KB)

Passenger Cars By Alternative Motor Energy (until 2012) - Raw

Passenger Cars By Alternative Motor Energy (until 2012) - Unpivoted

Passenger Cars By Alternative Motor Energy (until 2012) - Unpivoted

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

9.45 KB
1445 rows
6 columns

freq Freq	unit Unit	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Thousand	Electricity	Switzerland	1990	1
Annual	Thousand	Electricity	Cyprus	1990
Annual	Thousand	Electricity	Finland	1990
Annual	Thousand	Electricity	Hungary	1990
Annual	Thousand	Electricity	Iceland	1990
Annual	Thousand	Electricity	Latvia	1990
Annual	Thousand	Electricity	North Macedonia	1990
Annual	Thousand	Natural gas	Cyprus	1990
Annual	Thousand	Natural gas	Finland	1990
Annual	Thousand	Liquefied petroleum gases (LPG)	Cyprus	1990


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.