New Passenger Cars, Motor Coaches, Buses And Trolley Buses By Alternative Motor Energy (until 2012)

Eurostat code: road_eqr_carbua · (1995 - 2012)

@eurostat.road_eqr_carbua

Table List

2 tables(34.05 KB)

New Passenger Cars, Motor Coaches, Buses And Trolley Buses By Alternative Motor Energy (until 2012) - Raw

New Passenger Cars, Motor Coaches, Buses And Trolley Buses By Alternative Motor Energy (until 2012) - Unpivoted

New Passenger Cars, Motor Coaches, Buses And Trolley Buses By Alternative Motor Energy (until 2012) - Unpivoted

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

11.84 KB
2179 rows
7 columns

freq Freq	unit Unit	vehicle Vehicle	mot_nrg Mot Nrg	geo Geo	time_period Time Period	value Value
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Bulgaria	1995	9
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Cyprus	1995
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Germany	1995	12
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Finland	1995
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	France	1995	1
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Hungary	1995	8
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Latvia	1995
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Poland	1995	13
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	Slovenia	1995
Annual	Number	Buses, motor coaches, and trolley buses	Electricity	United Kingdom	1995	2


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

Share link

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