FOI request detail

LU station to station journey times

Request ID: FOI-0433-2425
Date published: 23 May 2024

You asked
Dear Transport for London, I would like to request a spreadsheet with the average journey time between each pair of stations on the underground and DLR. Preferably at various times and various days This would enable me to look up journey time to every station on the tube from every other very easily.

We answered

TfL Ref: 0433-2425

Thank you for your request received by Transport for London (TfL) on 6 May 2024 asking for information about journey times between stations on the London Underground and DLR.

Your request has been considered in accordance with the requirements of the Freedom of Information Act and our information access policy.  I can confirm that we hold the information you require. You specifically asked:
I would like to request a spreadsheet with the average journey time between each pair of stations on the underground and DLR. Preferably at various times and various days. This would enable me to look up journey time to every station on the tube from every other very easily.

The London Underground information you asked for is available on the TfL website using the following link: https://tfl.gov.uk/corporate/publications-and-reports/working-timetables.  Distance between stations and running times are included in the working timetables for each London Underground line.

We have also previously answered a request asking for similar information which is published on our website at the following link: https://tfl.gov.uk/corporate/transparency/freedom-of-information/foi-request-detail?referenceId=FOI-0050-1920.  The link to the published answer referred to in that request along with the inter station database data is here: https://www.whatdotheyknow.com/request/distance_and_inter_station_runni#incoming-201950.

Alternatively, a 2019 version of this data can be found online at crowding.data.tfl.gov.uk in the files named:
 
  • NBT19MTT4a_jt__network_tb_wf.csv
  • NBT19FRI4a_jt__network_tb_wf.csv
  • NBT19SAT4a_jt__network_tb_wf.csv
  • NBT19SUN4a_jt__network_tb_wf.csv

Note that there a different files for different day types (Mon-Thu, Fri, Sat, Sun).

There is a definitions file on the same site: NBT19_Definitions_Published.xlsx

The station codes can be found in the tab names “Stations”.

The column headers refer to the time bands throughout the day. These numbers refer to time bands that can also be looked up in the “Timebands” tab of the definitions file.

We are currently working on the latest version of this data and it will be uploaded to the same site in the near future.

In accordance with section 21 of the FOI Act, we are not obliged to supply you with a copy of the requested information as it is already accessible to you elsewhere.

In respect of the DLR, please see attached document which provides the information you have requested.

If this is not the information you are looking for, or if you are unable to access it for any reason, please do not hesitate to contact me.

Please see the attached information sheet for details of your right to appeal as well as information on copyright and what to do if you would like to re-use any of the information we have disclosed.

Yours sincerely


Sara Thomas
FOI Case Management Team
General Counsel
Transport for London

Attachments

FOI 0433 2425 CRM0138831.pdf

PDF
Back to top

Want to make a request?

We'll email you the response within 20 working days.


We'll publish the response online without disclosing any personal information.

Make a request

Something wrong with this request?


If you believe this request is not suitable, you can report it for attention, at foi@tfl.gov.uk