London Underground Services Performance Data

Source: R/underground.R

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

underground

Format

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

Source

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

Details

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