Request ID: FOI-1115-2324 Date published: 14 August 2023
You asked
Is there a way to get access to the underlying data used in the Power BI dashboard for TFL network demand - demand by station type? I would like to get the numbers of entry and exit broken down by each station on a daily basis. The dashboard could show the data in a table but that doesn't allow a data download. A relevant data API call or CSV data files would be ideal.
I’m interested in station tap in and tap out counts exactly as from TfL Network Demand - Microsoft Power BI:
- 01/01/2020 – now or the latest data you have (I see the Power BI dashboard has data up to 08/05/2023)
- Daily entry & exit data for each station across all modes
A CVS data file would work for this, but ideally I would like to see the updated data on a regular basis
We answered
TfL Ref: FOI-1115-2324
Thank you for your clarified request which we received on 11 July 2023.
Your request has been considered in accordance with the requirements of the Freedom of Information (FOI) Act and our information access policy. I can confirm TfL does hold the information you require.
Please note TfL is no longer updating the PowerBI report, which was specifically introduced for insight on London Underground use during the pandemic. However, the entry and exit data you asked for has been published on the TfL website herein response to a recent FOI request.
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.
If this is not the information you are looking for, or if you are unable to access it for some 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
Eva Hextall
FOI Case Management Team General Counsel Transport for London
