Passenger Cars By Unloaded Weight

Eurostat code: road_eqs_unlweig · (1996 - 2023)

@eurostat.road_eqs_unlweig

Table List

2 tables(52.06 KB)

Passenger Cars By Unloaded Weight - Unpivoted

Passenger Cars By Unloaded Weight - Unpivoted

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

17.72 KB
1892 rows
6 columns

freq Freq	weight Weight	unit Unit	geo Geo	time_period Time Period	value Value
Annual	From 1 000 to 1 249 kg	Number	Denmark	1996	421000
Annual	From 1 250 to 1 499 kg	Number	Denmark	1996	161000
Annual	1 500 kg or over	Number	Denmark	1996	21000
Annual	Less than 1 000 kg	Number	Denmark	1996	1135000
Annual	From 1 000 to 1 249 kg	Number	Denmark	1997	465000
Annual	From 1 250 to 1 499 kg	Number	Denmark	1997	191000
Annual	1 500 kg or over	Number	Denmark	1997	24000
Annual	Less than 1 000 kg	Number	Denmark	1997	1104000
Annual	From 1 000 to 1 249 kg	Number	Switzerland	1998	758000
Annual	From 1 000 to 1 249 kg	Number	Denmark	1998	514000


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.