New Special Purpose Road Vehicles

Eurostat code: road_eqr_spurp · (2008 - 2023)

@eurostat.road_eqr_spurp

Table List

2 tables(22.46 KB)

New Special Purpose Road Vehicles - Unpivoted

New Special Purpose Road Vehicles - Unpivoted

@eurostat.road_eqr_spurp.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.88 KB
444 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	2008	2094
Annual	Number	Belgium	2008	3522
Annual	Number	Bulgaria	2008	2797
Annual	Number	Switzerland	2008
Annual	Number	Cyprus	2008	632
Annual	Number	Czechia	2008	173
Annual	Number	Germany	2008	15039
Annual	Number	Estonia	2008	500
Annual	Number	Finland	2008	2529
Annual	Number	Croatia	2008	1176


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

Share link

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