Baselight

Stock Of Zero-emission Vehicles At 31st December By Type Of Vehicle And Type Of Motor Energy

Eurostat code: road_eqs_zev ยท (2013 - 2023)

@eurostat.road_eqs_zev

Stock Of Zero-emission Vehicles At 31st December By Type Of Vehicle And Type Of Motor Energy - Unpivoted
@eurostat.road_eqs_zev.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.

  • 20.97 KB
  • 9240 rows
  • 7 columns
freq

Freq

mot_nrg

Mot Nrg

vehicle

Vehicle

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualElectricityBuses, motor coaches, and trolley busesNumberAustria2013139
AnnualElectricityBuses, motor coaches, and trolley busesNumberBelgium20133
AnnualElectricityBuses, motor coaches, and trolley busesNumberBulgaria2013468
AnnualElectricityBuses, motor coaches, and trolley busesNumberCyprus2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberCzechia2013706
AnnualElectricityBuses, motor coaches, and trolley busesNumberGermany201399
AnnualElectricityBuses, motor coaches, and trolley busesNumberDenmark2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberEstonia201391
AnnualElectricityBuses, motor coaches, and trolley busesNumberGreece2013366
AnnualElectricityBuses, motor coaches, and trolley busesNumberSpain201361

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

Share link

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