Persons Employed In Goods Road Transport Enterprises By Sex

Eurostat code: road_ec_empl_s · (1980 - 2012)

@eurostat.road_ec_empl_s

Table List

2 tables(36.39 KB)

Persons Employed In Goods Road Transport Enterprises By Sex - Raw

Persons Employed In Goods Road Transport Enterprises By Sex - Unpivoted

Persons Employed In Goods Road Transport Enterprises By Sex - Unpivoted

@eurostat.road_ec_empl_s.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.56 KB
677 rows
6 columns

freq Freq	unit Unit	sex Sex	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	Total	Austria	1988	30619
Annual	Number	Total	Spain	1988	52961
Annual	Number	Total	France	1988	264865
Annual	Number	Total	Spain	1989	50184
Annual	Number	Total	France	1989	272646


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

Share link

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