Year
2026
My role
Solo project
Tools
SQL, DuckDB and Python
Data
Office of Rail and Road estimates of station usage (Table 1415) and TfL annual station counts

The question

Rail travel collapsed in 2020. How much of it has come back, and where? And how much did the Elizabeth line, which opened through central London in May 2022, change the city’s stations?

What I did

  • Built a pipeline in DuckDB, written mostly in SQL, that turns the Office of Rail and Road’s estimates for every station in Great Britain, from April 1997 to March 2025, into one row per station and year, alongside TfL’s own counts for the Underground.
  • Wrote 9 tests in SQL that must pass before anything here is published, including checks that the time series matches ORR’s separate table for 2024-25 station by station and reproduces ORR’s ranking of the busiest stations.
  • Compared each station’s latest year with 2019-20, the last full year before the pandemic, counting only stations open in both years.
Entries and exits at all of Great Britain’s stations each year, April 1997 to March 2025. ORR has no figures for 2003-04.
0 0.5 bn 1.0 bn 1.5 bn 2.0 bn 2.5 bn 3.0 bn 3.5 bn 1997-982002-032007-082012-132017-182024-25 Pandemic Break in series Great Britain: 3.06 billion

Travel is above its pre-pandemic level, but only because of new stations. Great Britain’s stations saw 3.06 billion entries and exits in 2024-25, against 3.01 billion in 2019-20. The 2,561 stations open in both years were at 96.7% of their 2019-20 level. The 25 stations with no figure for 2019-20 added 155.2 million, and 5 of them, on the Elizabeth line, account for 150.4 million of that.

Entries and exits in 2024-25 as a share of 2019-20, by region, for the stations open in both years.
  1. North East53 stations 119.2%
  2. South West167 stations 105.9%
  3. East Midlands108 stations 101.4%
  4. London333 stations 101.3%
  5. Wales222 stations 98.0%
  6. Great Britain2,561 stations 96.7%
  7. Yorkshire and The Humber187 stations 95.4%
  8. East of England214 stations 94.5%
  9. South East430 stations 92.3%
  10. North West335 stations 88.5%
  11. Scotland356 stations 88.2%
  12. West Midlands156 stations 83.8%

Back to the 2019-20 level

Recovery is uneven. Station by station, the North East is at 119.2% of its 2019-20 level and the West Midlands at 83.8%. London is at 101.3%, its Elizabeth line stations included.

Entries and exits at the Elizabeth line’s 41 stations, from Reading and Heathrow to Shenfield and Abbey Wood, and at London’s other stations, with 2019-20 as 100. The line’s new central stations count from the year they opened.
0 100 200 300 2010-112013-142016-172019-202024-25 Central section opens Elizabeth line stations: 212.9Other London stations: 87.0

The Elizabeth line’s stations now see 2.1 times their 2019-20 use. With 2019-20 as 100, the line’s 41 stations stood at 212.9 in 2024-25, and London’s other stations at 87.0. Among stations with at least a million entries and exits in 2019-20, all 10 of the fastest-growing are on the Elizabeth line, led by Heathrow Terminal 5 (+221.9%).

The busiest stations in 2024-25, with the change since 2019-20. “New” means the station had no figure for 2019-20.
StationRegionEntries and exits, 2024-25Change since 2019-20
1. London Liverpool Street (Elizabeth line)London98.0 million+48.5%
2. London WaterlooLondon70.4 million−19.0%
3. London Paddington (Elizabeth line)London69.9 million+55.8%
4. Tottenham Court Road (Elizabeth line)London68.1 millionnew
5. London BridgeLondon54.7 million−13.3%
6. London VictoriaLondon53.8 million−26.9%
7. Stratford (Elizabeth line)London51.5 million+22.8%
8. Farringdon (Elizabeth line)London50.2 million+204.1%
9. Bond Street (Elizabeth line)London42.8 millionnew
10. London EustonLondon40.2 million−10.1%
11. London St Pancras InternationalLondon38.8 million+7.8%
12. Whitechapel (Elizabeth line)London37.1 million+179.0%
13. Birmingham New StreetWest Midlands36.6 million−21.3%
14. London Kings CrossLondon27.7 million−14.8%
15. Manchester PiccadillyNorth West27.4 million−14.9%

London Liverpool Street is Britain’s busiest station, with 98.0 million entries and exits in 2024-25, +48.5% on 2019-20. London Waterloo, the busiest of these in 2019-20, is down 19.0%. The biggest falls among large stations are at London Cannon Street (−59.4%), Erdington (−53.2%) and Woolwich Arsenal (−48.3%).

The biggest risers and fallers since 2019-20, among stations with at least a million entries and exits that year.
StationRegion2019-202024-25Change
Heathrow Terminal 5 (Elizabeth line)London1.5 million4.7 million+221.9%
Abbey Wood (Elizabeth line)London3.8 million11.9 million+210.4%
Maryland (Elizabeth line)London1.3 million4.1 million+204.7%
Farringdon (Elizabeth line)London16.5 million50.2 million+204.1%
Whitechapel (Elizabeth line)London13.3 million37.1 million+179.0%
Ealing Broadway (Elizabeth line)London6.9 million15.5 million+123.7%
Southall (Elizabeth line)London3.5 million7.7 million+120.7%
West Ealing (Elizabeth line)London1.2 million2.5 million+115.6%
Heathrow Terminals 2 and 3 (Elizabeth line)London4.0 million7.9 million+99.0%
Hayes and Harlington (Elizabeth line)London4.4 million8.5 million+91.8%
London Cannon StreetLondon18.5 million7.5 million−59.4%
ErdingtonWest Midlands1.0 million0.5 million−53.2%
Woolwich ArsenalLondon4.4 million2.3 million−48.3%
Cardiff BayWales1.5 million0.8 million−48.3%
Five WaysWest Midlands2.5 million1.3 million−47.8%
PlumsteadLondon1.8 million0.9 million−47.6%
Queenstown Road (Battersea)London1.5 million0.8 million−46.3%
Conway ParkNorth West1.1 million0.6 million−45.0%
Kirkby (Merseyside)North West2.9 million1.6 million−44.8%
BexleyheathLondon2.7 million1.5 million−44.7%
Entries and exits at London Underground stations by calendar year, from TfL’s annual counts, with 2019 as 100. There are no published figures here for 2024.
0 25 50 75 100 201720182019202020212022202320242025 Underground: 80.7

The Underground is still 19% below 2019. TfL’s counts put its 269 stations at 80.7% of their 2019 level in 2025. Waterloo LU was its busiest station, with 74.5 million entries and exits.

The busiest Underground stations in 2025, with the change since 2019, from TfL’s counts.
Station20252019Change
1. Waterloo LU74.5 million82.9 million−10.2%
2. King's Cross St. Pancras73.6 million88.3 million−16.7%
3. Tottenham Court Road60.8 million42.0 million+44.8%
4. Victoria LU60.2 million85.5 million−29.6%
5. Liverpool Street LU60.1 million67.2 million−10.6%
6. Paddington TfL58.0 million48.6 million+19.2%
7. London Bridge LU56.2 million74.3 million−24.4%
8. Stratford53.2 million64.9 million−18.0%
9. Oxford Circus52.3 million78.1 million−33.0%
10. Bond Street42.3 million37.5 million+12.8%

Caveats

  • ORR’s figures are estimates based mainly on ticket sales, so they undercount some stations, and its methods change from time to time: it marks a break in the series in 2022-23. It has no figures for 2003-04.
  • ORR’s years run from April to March; TfL’s counts are calendar years.
  • An entry and an exit are counted separately, so a single journey adds one to each end’s station. Interchanges aren’t included.
  • The Elizabeth line’s group includes its stations outside London and its new central stations once they opened, so part of its rise is new stations rather than more people at the same ones.

Data: Office of Rail and Road, Estimates of station usage (Table 1415), accredited official statistics; contains public sector information licensed under the Open Government Licence v3.0. TfL annual station counts: Powered by TfL Open Data.