Train Traffic On The Rail Network - United Kingdom (2015)

Eurostat code: rail_tf_ns15_uk · (2015 - 2015)

@eurostat.rail_tf_ns15_uk

Table List

2 tables(182.58 KB)

Train Traffic On The Rail Network - United Kingdom (2015) - Raw

Train Traffic On The Rail Network - United Kingdom (2015) - Unpivoted

Train Traffic On The Rail Network - United Kingdom (2015) - Unpivoted

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

91.58 KB
6604 rows
6 columns

freq Freq	unit Unit	net_seg15 Net Seg15	train Train	time_period Time Period	value Value
Annual	Number	London Liverpool Street - Bow Jn E	Goods trains	2015	60
Annual	Number	London Liverpool Street - Bow Jn E	Passenger trains	2015	59844
Annual	Number	London Liverpool Street - Bethnal Green	Goods trains	2015	337
Annual	Number	London Liverpool Street - Bethnal Green	Passenger trains	2015	62403
Annual	Number	London Liverpool Street - Bethnal Green Sub S	Goods trains	2015	124
Annual	Number	London Liverpool Street - Bethnal Green Sub S	Passenger trains	2015	105173
Annual	Number	Bethnal Green - Bow Jn M	Goods trains	2015	83
Annual	Number	Bethnal Green - Bow Jn M	Passenger trains	2015	64387
Annual	Number	Bow Jn E - Stratford E	Goods trains	2015	112
Annual	Number	Bow Jn E - Stratford E	Passenger trains	2015	56725


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

Share link

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