Baselight
Sign In

New Passenger Cars By Type Of Motor Energy

Eurostat code: road_eqr_carpda ยท (2013 - 2023)

@eurostat.road_eqr_carpda

New Passenger Cars By Type Of Motor Energy - Unpivoted
@eurostat.road_eqr_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.

  • 28.27 KB
  • 4976 rows
  • 6 columns
freq

Freq

unit

Unit

mot_nrg

Mot Nrg

geo

Geo

time_period

Time Period

value

Value

AnnualNumberAlternative energyAustria20131285
AnnualNumberAlternative energyBosnia and Herzegovina201339
AnnualNumberAlternative energyBelgium2013843
AnnualNumberAlternative energySwitzerland20132272
AnnualNumberAlternative energyCyprus20138
AnnualNumberAlternative energyGermany201346534
AnnualNumberAlternative energyDenmark2013549
AnnualNumberAlternative energyEstonia2013137
AnnualNumberAlternative energySpain20132088
AnnualNumberAlternative energyFinland2013559

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