Stock Of Vehicles By Category

Eurostat code: enps_road_eqs_car · (2005 - 2022)

@eurostat.enps_road_eqs_car

Table List

2 tables(30.59 KB)

Stock Of Vehicles By Category - Unpivoted

Stock Of Vehicles By Category - Unpivoted

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

10.12 KB
1030 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Thousand	Motor coaches, buses and trolley buses	Algeria	2005	51.8
Annual	Thousand	Motor coaches, buses and trolley buses	Jordan	2005	15.6
Annual	Thousand	Motor coaches, buses and trolley buses	Palestine*	2005	1.2
Annual	Thousand	Passenger cars	Algeria	2005	1906
Annual	Thousand	Passenger cars	Israel	2005	1652
Annual	Thousand	Passenger cars	Jordan	2005	496
Annual	Thousand	Passenger cars	Morocco	2005	1477.3
Annual	Thousand	Passenger cars	Palestine*	2005	103.9
Annual	Thousand	Passenger cars	Tunisia	2005	671.3
Annual	Thousand	Passenger cars - diesel	Algeria	2005	254


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

Share link

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