Employment In Principal Railway Enterprises, By Type Of Railway Activity (until 2012)

Eurostat code: rail_ec_emplo_a · (1970 - 2012)

@eurostat.rail_ec_emplo_a

Table List

2 tables(81.21 KB)

Employment In Principal Railway Enterprises, By Type Of Railway Activity (until 2012) - Raw

Employment In Principal Railway Enterprises, By Type Of Railway Activity (until 2012) - Unpivoted

Employment In Principal Railway Enterprises, By Type Of Railway Activity (until 2012) - Unpivoted

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

27.54 KB
3538 rows
6 columns

freq Freq	unit Unit	rail_act Rail Act	geo Geo	time_period Time Period	value Value
Annual	Number	General administration	Sweden	1970	1478
Annual	Number	Operations - total	Sweden	1970	38740
Annual	Number	Operations - operating and traffic	Sweden	1970	17084
Annual	Number	Operations - traction and rolling stock	Sweden	1970	13577
Annual	Number	Operations - ways and works	Sweden	1970	8079
Annual	Number	Other	Sweden	1970	4755
Annual	Number	Total	Belgium	1970	84222
Annual	Number	Total	Germany	1970	443448
Annual	Number	Total	Denmark	1970	21610
Annual	Number	Total	Greece	1970	7900


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

Share link

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