Persons Employed In Goods Road Transport Enterprises By Employment Size Classes

Eurostat code: road_ec_empl · (1980 - 2012)

@eurostat.road_ec_empl

Table List

2 tables(51.95 KB)

Persons Employed In Goods Road Transport Enterprises By Employment Size Classes - Raw

Persons Employed In Goods Road Transport Enterprises By Employment Size Classes - Unpivoted

Persons Employed In Goods Road Transport Enterprises By Employment Size Classes - Unpivoted

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

17.24 KB
1872 rows
6 columns

freq Freq	unit Unit	sizeclas Sizeclas	geo Geo	time_period Time Period	value Value
Annual	Number	Total	Spain	1980	70582
Annual	Number	Total	Spain	1984	71117
Annual	Number	Total	Spain	1985	66288
Annual	Number	Total	Spain	1986	66276
Annual	Number	Total	Spain	1987	60504
Annual	Number	From 1 to 5 employees	Austria	1988	5333
Annual	Number	From 1 to 5 employees	France	1988	61511
Annual	Number	From 10 to 19 employees	Austria	1988	6287
Annual	Number	From 10 to 19 employees	France	1988	33578
Annual	Number	From 20 to 49 employees	Austria	1988	6104


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

Share link

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