Road Equipment: Number Of Road Vehicles By Categories

Eurostat code: med_rd2 · (2005 - 2018)

@eurostat.med_rd2

Table List

2 tables(25.69 KB)

Road Equipment: Number Of Road Vehicles By Categories - Raw

Road Equipment: Number Of Road Vehicles By Categories - Unpivoted

Road Equipment: Number Of Road Vehicles By Categories - Unpivoted

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

9.02 KB
767 rows
6 columns

freq Freq	unit Unit	vehicle Vehicle	geo Geo	time_period Time Period	value Value
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	104.8
Annual	Thousand	Passenger cars	Tunisia	2005	671.3
Annual	Thousand	Passenger cars - diesel	Algeria	2005	254
Annual	Thousand	Passenger cars - diesel	Israel	2005	67
Annual	Thousand	Passenger cars - diesel	Jordan	2005	68
Annual	Thousand	Passenger cars - diesel	Tunisia	2005	169.4


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.