London stations (all types) entries and exits update by station
Request ID: FOI-1210-2324 Date published: 14 August 2023
You asked
Hi TFL,
I would like to ask for the latest update similar to request FOI-3381-2223, I am looking into the latest total entries & exits in London stations up to Jun or Jul 2023
I can see that you publish weekly this information via PowerBI but as an analyst, I will require a csv format to be able to analyze the information in footfall trends
Hope this query is okay with you
Many thanks,
Amendment received 22/07/2023: Thank you for the update! I wanted to mention in a previous request FOI-3381-2223 that the list of stations wasn't the full list. It was missing all the stations below. I would like to ask if it's possible, would you be able to provide for all stations and any forms of transport managed by your entity? Any KPI that reflects people using the station (total taps, entry/exist, etc)
Missing stations in previously published extracts:
Mode NLC ASC Station
DLR 891 BEPd Beckton Park
DLR 859 PMLd Pudding Mill Lane
DLR 750 ABRd Abbey Road
DLR 890 ROAd Royal Albert
DLR 858 POPd Poplar
DLR 898 ELRd Elverson Road
DLR 749 SHSd Stratford High Street
DLR 889 STLd Star Lane
DLR 894 GARd Gallions Reach
DLR 882 BLAd Blackwall
DLR 850 ALSd All Saints
DLR 893 CYPd Cyprus
DLR 857 MUDd Mudchute
DLR 523 KGVd King George V
DLR 866 WIQd West India Quay
DLR 895 BECd Beckton
DLR 888 PRRd Prince Regent
DLR 867 DERd Devons Road
DLR 559 WSId West Silvertown
DLR 856 ISGd Island Gardens
DLR 533 LCAd London City Airport
DLR 851 BOCd Bow Church
DLR 897 DEBd Deptford Bridge
DLR 538 PDKd Pontoon Dock
DLR 887 CUHd Custom House
DLR 854 CROd Crossharbour
DLR 886 ROVd Royal Victoria
DLR 883 EAId East India
DLR 864 TOGd Tower Gateway
DLR 861 SOQd South Quay
DLR 504 STId Stratford International DLR
DLR 928 GREd Greenwich
DLR 853 LAPd Langdon Park
DLR 865 WESd Westferry
DLR 855 HEQd Heron Quays
DLR 879 CUSd Cutty Sark
DLR 860 SHAd Shadwell DLR
DLR 940 LEWd Lewisham DLR
DLR 862 LIMd Limehouse DLR
DLR 842 CAWd Canary Wharf DLR
DLR 573 WOAd Woolwich Arsenal
EZL 7091 HAFr Heathrow Terminal 4 EL
EZL 3170 IVRr Iver
EZL 9846 HWVr Heathrow Terminal 5 EL
EZL 3151 TAPr Taplow
EZL 3000 AMLr Acton Main Line
EZL 3171 LNYr Langley
EZL 3191 HANr Hanwell
EZL 7090 HXXr Heathrow Terminals 2 & 3 EL
EZL 3155 TWYr Twyford
EZL 3176 BNMr Burnham
EZL 3188 WEAr West Ealing
EZL 6970 MYLr Maryland
EZL 3174 WDTr West Drayton
EZL 6872 BREr Brentwood
EZL 6888 SNFr Shenfield
EZL 6877 GDPr Gidea Park
EZL 3149 RDGr Reading
EZL 3186 HAYr Hayes & Harlington
EZL 6879 HROr Harold Wood
EZL 6883 MNPr Manor Park
EZL 3147 MAIr Maidenhead
EZL 6893 SVKr Seven Kings
EZL 6878 GMYr Goodmayes
EZL 3172 SLOr Slough
EZL 3187 STLr Southall
EZL 6874 CTHr Chadwell Heath
EZL 6876 FOGr Forest Gate
EZL 6881 IFDr Ilford
EZL 6886 RMFr Romford
EZL 3087 PADr Paddington NR
EZL 6965 LSTr Liverpool Street NR
LO 5420 BAKr Battersea Park
LO 7473 EMPr Emerson Park
LO 6814 CHNr Cheshunt
LO 1434 HDLr Headstone Lane
LO 1395 BSHr Bushey
LO 1451 SOHr South Hampstead
LO 1398 HTEr Hatch End
LO 5372 WWRr Wandsworth Road
LO 6949 TEOr Theobalds Grove
LO 1415 KBNr Kilburn High Road
LO 5378 PNWr Penge West
LO 7467 WGRr Woodgrange Park
LO 6952 TURr Turkey Street
LO 6947 SBUr Southbury
LO 6968 SMHr Stamford Hill
LO 7403 LERr Leytonstone High Road
LO 7406 CRHr Crouch Hill
LO 6913 BHKr Bush Hill Park
LO 1442 CPKr Carpenders Park
LO 5397 ANYr Anerley
LO 1452 SATr South Acton
LO 1039 ROEr Rotherhithe
LO 6967 RECr Rectory Road
LO 7407 WMWr Walthamstow Queens Road
LO 5376 NWDr Norwood Junction
LO 6962 CBHr Cambridge Heath
LO 7408 WNPr Wanstead Park
LO 6973 SJSr St James Street
LO 7404 STOr South Tottenham
LO 1455 WFHr Watford High Street
LO 7401 HRYr Harringay Green Lanes
LO 1438 BSPr Brondesbury Park
LO 7402 LEMr Leyton Midland Road
LO 6961 BETr Bethnal Green LO
LO 1402 WFJr Watford Junction
LO 6926 CPTr Clapton
LO 5424 QRPr Queens Road Peckham
LO 6956 WHLr White Hart Lane
LO 1404 ACCr Acton Central
LO 1524 UHLr Upper Holloway
LO 6934 SKWr Stoke Newington
LO 6966 LOFr London Fields
LO 5301 CLPr Clapham High Street
LO 6954 WSTr Wood Street
LO 6914 CHIr Chingford
LO 1085 WPEr Wapping
LO 1439 CIRr Caledonian Road & Barnsbury
LO 6958 BCVr Bruce Grove
LO 6959 ENFr Enfield Town
LO 1445 FNYr Finchley Road & Frognal
LO 5437 SYDr Sydenham
LO 5150 NWXr New Cross
LO 1449 KTWr Kentish Town West
LO 5418 HPAr Honor Oak Park
LO 5356 CYPr Crystal Palace
LO 6972 SLVr Silver Street
LO 5362 FOHr Forest Hill
LO 6919 HIPr Highams Park
LO 1409 GPOr Gospel Oak
LO 1441 CNNr Canonbury
LO 1022 HGGr Haggerston
LO 1437 BSYr Brondesbury
LO 1023 HOXr Hoxton
LO 6978 HKWr Hackney Wick
LO 9586 IMWr Imperial Wharf
LO 1448 KNRr Kensal Rise
LO 1444 EUSr Euston NR
LO 6867 HACr Hackney Downs
LO 5423 PMRr Peckham Rye
LO 1413 HDHr Hampstead Heath
LO 5404 BCYr Brockley
LO 5411 WCYr West Croydon NR
LO 6941 EDRr Edmonton Green
LO 1082 SDEr Shadwell LO
LO 5345 NXGr New Cross Gate
LO 1440 CMDr Camden Road
LO 1083 SQEr Surrey Quays
LO 6979 HMNr Homerton
LO 1421 WHDr West Hampstead LO
LO 1443 DLJr Dalston Junction
LO 6977 HKCr Hackney Central
LO 1429 DLKr Dalston Kingsland
LO 5421 DMKr Denmark Hill
LO 9587 SPBr Shepherds Bush NR
LO 1024 SDCr Shoreditch High Street
LO 5595 CLJr Clapham Junction
LU 618 OLYu Kensington (Olympia)
LU 686 RMDu Richmond
LU 736 UPMu Upminster
LU 766 WJNu Willesden Junction
LU 767 WIMu Wimbledon
TRM 9444 AVRt Avenue Road
TRM 9464 COOt Coombe Lane
TRM 9454 BKBt Birkbeck Trams
TRM 9449 BDLt Beddington Lane
TRM 9475 HRDt Harrington Road
TRM 9446 BCRt Beckenham Road
TRM 9468 DDRt Dundonald Road
TRM 9474 GVHt Gravel Hill
TRM 9486 RVCt Reeves Corner
TRM 9476 KHDt King Henrys Drive
TRM 9479 MPKt Merton Park
TRM 9499 WLRt Wellesley Road
TRM 9450 BGWt Belgrave Walk
TRM 9478 LPKt Lloyd Park
TRM 8779 WDSt Woodside
TRM 9472 FLWt Fieldway
TRM 9482 MRDt Morden Road
TRM 9485 PHLt Phipps Bridge
TRM 9459 BHLt Blackhorse Lane
TRM 9471 ELMt Elmers End Trams
TRM 9441 ADVt Addington Village
TRM 9477 LEBt Lebanon Road
TRM 9488 TWRt Centrale
TRM 9443 ARNt Arena
TRM 9497 WDMt Waddon Marsh
TRM 9498 WPKt Wandle Park
TRM 9481 MTJt Mitcham Junction Trams
TRM 9480 MTMt Mitcham
TRM 9440 ADSt Addiscombe
TRM 9484 NADt New Addington
TRM 9445 BCJt Beckenham Junction Trams
TRM 9491 TPLt Therapia Lane
TRM 9442 AMPt Ampere Way
TRM 9487 SANt Sandilands
TRM 9460 CSTt Church Street
TRM 9473 GSTt George Street
TRM 8776 WCRt West Croydon Trams
TRM 8777 WMBt Wimbledon Trams
TRM 9470 ECRt East Croydon Trams
We answered
TfL Ref: FOI-1210-2324
Thank you for your request received by Transport for London (TfL) on 15th July 2023 asking for London Underground entry and exit data. Your request has been considered in accordance with the requirements of the Freedom of Information Act and our information access policy.
Specifically you asked:
“I would like to ask for the latest update similar to request FOI-3381-2223, I am looking into the latest total entries & exits in London stations up to Jun or Jul 2023. I can see that you publish weekly this information via PowerBI but as an analyst, I will require a csv format to be able to analyze the information in footfall trends.”
I can confirm that we hold the information you require, which is provided in the attached folders (note that you may need to expand the width of some columns to read the data in full). Data is provided from 1st January 2019 to 23rd July 2023. The data shows instances of passengers touching in and out at the named station, as well as the use of paper tickets at stations where TfL collects such information. As some stations may be ungated (such as DLR and Tram stations - with Tram stops being touch-in only) this means that the data is likely to be an under-representation of the true demand at those stations (for example, passengers using a paper ticket would have no need to touch in or out at an ungated station). Note that the source of this data is different to that used for the PowerBI tool that you cite. The PowerBI equivalent was Oyster and Contactless use only, from taps at the readers at the gates in ticket halls. TfL is no longer updating the PowerBI report, which was specifically introduced for insight on London Underground use during the pandemic. Note that all counts under 5 (be they entry or exit) are excluded from the data under section 40(2) of the Freedom of Information Act, the exemption that protects against the unfair release of personal data.
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,
David Wells FOI Case Officer FOI Case Management Team General Counsel Transport for London