Goods Road Transport Enterprises By Number Of Vehicles

Eurostat code: road_ec_entveh · (1988 - 2012)

@eurostat.road_ec_entveh

Table List

2 tables(37.07 KB)

Goods Road Transport Enterprises By Number Of Vehicles - Raw

Goods Road Transport Enterprises By Number Of Vehicles - Unpivoted

Goods Road Transport Enterprises By Number Of Vehicles - Unpivoted

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

11.21 KB
1070 rows
6 columns

freq Freq	unit Unit	n_vehicl N Vehicl	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Austria	1988	3953
Annual	Number	Total	Sweden	1989	7126
Annual	Number	Total	Sweden	1990	7789
Annual	Number	Total	Switzerland	1991	4622
Annual	Number	Total	Finland	1991	12571
Annual	Number	Total	Italy	1991	86438
Annual	Number	Total	Sweden	1991	7945
Annual	Number	1 vehicle	France	1992	15468
Annual	Number	1 vehicle	Portugal	1992	1262
Annual	Number	1 vehicle	Sweden	1992	2398


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

Share link

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