Daily entry and exit London Underground passenger data.
Request ID: FOI-2290-2223 Date published: 16 June 2023
You asked
Follow-up to TfL Ref: 1784-2223: Hi Jasmine,
Firstly, thank you for taking the time to respond and directing me in the right place for the data, it is greatly appreciated.
Having reviewed the data in the link, the key information missing for what I require is the data by day. As mentioned, the PowerBi link attached is broken down by day. Please let me know if you are able to send me this data or not.
https://app.powerbi.com/view?r=eyJrIjoiMjZjMmQwYTktZjYxNS00MTIwLTg0ZjAtNWIwNGE0ODMzZGJhIiwidCI6IjFmYmQ2NWJmLTVkZWYtNGVlYS1hNjkyLWEwODljMjU1MzQ2YiIsImMiOjh9
Thank you for your help, its greatly appreciated.
We answered
TfL Ref: 2290-2223
Thank you for your request received by us on 8 December 2023 asking for information about London Underground daily passenger usage data, following your previous request for information, TfL reference: 1784-2223.
Your request has been considered in accordance with the requirements of the Freedom of Information Act and our information access policy. You asked for:
the supporting data for the PowerBI published labelled: TfL Network Demand, Demand by Station Station Type. This PowerBI displays the number of Taps by Station for Entry and Exit by day, dating back to 01/01/2020 up to 16/10/2022.
Would you be able to provide this data in Excel format, including all Tube Stations and all days?
I work for a small hospitality company, this data would be greatly appreciated.
Please see the attached daily passenger exit data usage from 1 January 2020 to 31 December 2022. Unfortunately, due to some technical issues with our software with retrieving entry demand usage for Outside Station Interchanges, it has not been possible to provide a complete dataset for passenger entry data.
Whilst Entry+Exit data should roughly be a ratio of 50:50, it is possible to extract the data you are seeking from the above dashboard, by referring to the second graph in these reports, represented in blue for the London Underground network, select the station of interest and then choose either the Entry or Exit options in the tabs above, and right click on the graph itself, selecting ‘show as table’ to produce passenger data in table format accordingly.
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
Jasmine Howard FOI Case Officer FOI Case Management Team General Counsel Transport for London