underground: London Underground Services Performance Data
In nacnudus/underground: London Underground Performance Data

Description Usage Format Details Source

A dataset of the London Underground services performance data timeseries from 2003/04 to 23 June 2018.

1	underground

A data frame with 108,482 rows and 9 variables:

metric The title of the data series
year Year beginning 1 April
quarter The quarter, e.g. "QTR 1" of year beginning 1 April, for quarterly series
fourweek The four-week period within the year beginning 1 April, for four-weekly series. I don't know whether the 13th and final period is a day longer.
line The London Underground Line, for series broken down by line
category The cause of loss of customer hours, for some Lost Customer Hours series
asset Either Escalators - MTBF (days) or Lifts - MTBF (days), for the series "Escalator and Lift Mean Time Between Failures (Days)"
company The company concerned, for some Lost Customer Hours series (see 'Details')
value The observed value of the metric

This dataset may be updated approximately monthly. To use the latest data, reinstall the package from the GitHub repository https://github.com/nacnudus/underground.

There are many series, each given annually as well as one of quarterly and four-weekly. Most series are broken down by line, others are broken down by other things as follows.

Various Lost Customer Hours series are broken down by line, category (which is really 'cause'), and company (see 'Details')
Escalator and Lift Mean Time Between Failures (Days) is broken down by asset (lift or escalator)

What the company column means:

BCV = Bakerloo, Central, Victoria (and Waterlool & City) SSL = Sub-Surface Lines (District, Hammersmith and City, Metropolitan, Circle and East London) JNP = Jubilee, Northern, Picadilly

From https://en.wikipedia.org/wiki/Talk

"The maintenance and upgrading of the London Underground Network is carried out by different companies. Tube Lines in responsible for the Jubilee, Northern and Piccadilly Lines (JNP), Metronet BCV is responsible for the Bakerloo, Central and Victoria Lines (BCV) as well as the Waterloo and City Line, whilst Metronet SSL (sub surface lines) is responsible for the District, Hammersmith and City, Metropolitan, Circle and East London lines." DavidB601 20:57, 7 November 2006 (UTC)

The source spreadsheet contains a small dataset called "Unmanned - Open, Stations" that is small and already tidy, so it isn't included in this package. It looks like this.

Month | Hours- Stations Open/Unmanned | Daily hours | Calendar Month Hours | ——-|——————————-|————-|———————–|————————- Jan-18 | 245.90 | 5240.00 | 162440.00 | 0.15 Feb-18 | 142.23 | 5240.00 | 146720.00 | 0.10 Mar-18 | 201.82 | 5240.00 | 162440.00 | 0.12 Apr-18 | 90.4 | 5240.00 | 157200.00 | 0.06 May-18 | 177.2 | 5240.00 | 162440.00 | 0.11 Jun-18 | 229.43 | 5240.00 | 157200.00 | 0.15 Jul-18 | 254.53 | 5240.00 | 162440.00 | 0.16

https://tfl.gov.uk/corporate/publications-and-reports/underground-services-performance

nacnudus/underground documentation built on May 18, 2019, 9:14 p.m.