Baselight

New Passenger Cars By Unloaded Weight

Eurostat code: road_eqr_unlweig ยท (1970 - 2023)

@eurostat.road_eqr_unlweig

New Passenger Cars By Unloaded Weight - Unpivoted
@eurostat.road_eqr_unlweig.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.

  • 25.86 KB
  • 3020 rows
  • 6 columns
freq

Freq

weight

Weight

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualTotalNumberBelgium1970295701
AnnualTotalNumberGermany19702107123
AnnualTotalNumberDenmark1970108634
AnnualTotalNumberGreece197032354
AnnualTotalNumberSpain1970572346
AnnualTotalNumberFrance19701296240
AnnualTotalNumberIreland197052947
AnnualTotalNumberItaly19701363594
AnnualTotalNumberLuxembourg197011633
AnnualTotalNumberNetherlands1970432231

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

Share link

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