Baselight

New Zero-emission Vehicles By Type Of Vehicle And Type Of Motor Energy

Eurostat code: road_eqr_zev ยท (2013 - 2023)

@eurostat.road_eqr_zev

New Zero-emission Vehicles By Type Of Vehicle And Type Of Motor Energy - Unpivoted
@eurostat.road_eqr_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.91 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 busesNumberAustria201315
AnnualElectricityBuses, motor coaches, and trolley busesNumberBelgium2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberBulgaria201320
AnnualElectricityBuses, motor coaches, and trolley busesNumberCyprus2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberCzechia20131
AnnualElectricityBuses, motor coaches, and trolley busesNumberGermany20135
AnnualElectricityBuses, motor coaches, and trolley busesNumberDenmark2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberEstonia2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberGreece2013
AnnualElectricityBuses, motor coaches, and trolley busesNumberSpain201310

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.