Road Equipment: Number Of Road Vehicles By Age

Eurostat code: med_rd3 · (2005 - 2018)

@eurostat.med_rd3

Table List

2 tables(20.84 KB)

Road Equipment: Number Of Road Vehicles By Age - Raw

Road Equipment: Number Of Road Vehicles By Age - Unpivoted

Road Equipment: Number Of Road Vehicles By Age - Unpivoted

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

6.68 KB
248 rows
7 columns

freq Freq	unit Unit	age Age	vehicle Vehicle	geo Geo	time_period Time Period	value Value
Annual	Thousand	Total	Passenger cars	Algeria	2005	1906
Annual	Thousand	Total	Passenger cars	Israel	2005	1652
Annual	Thousand	Total	Passenger cars	Jordan	2005	496
Annual	Thousand	Total	Passenger cars	Morocco	2005	1477.3
Annual	Thousand	Total	Passenger cars	Palestine*	2005	104.8
Annual	Thousand	Total	Passenger cars	Tunisia	2005	671.3
Annual	Thousand	Total	Lorries	Algeria	2005	966
Annual	Thousand	Total	Lorries	Egypt	2005	668.2
Annual	Thousand	Total	Lorries	Israel	2005	347
Annual	Thousand	Total	Lorries	Jordan	2005	106.9


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

Share link

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