London Underground Passenger Counts

Open Data
1

Hi everyone,

I am looking for an API to collect data related to London underground passenger counts.
I found in TFL open data something related (shown in image), but I am not sure if there is an actual API to collect a live feed, or is it just the excel files that they create annually?
Does anyone have any useful input related to that?

Thanks,

Michail

London_Underground_Passenger_Counts
London_Underground_Passenger_Counts1536×960 37.4 KB

2

I’ve got a table of them but I had to scrape them…

3

Thanks for you reply. So, to your knowledge there is not any related API?
Could I ask you, from which source did you scrape them?

Thanks

4

It says here…

// TfL Tube data from https://data.london.gov.uk/dataset/london-underground-performance-reports?resource=b6ab04fc-9062-4291-b514-7fa218073b4c
// https://data.gov.uk/dataset/ff93ffc1-6656-47d8-9155-85ea0b8f2251/national-public-transport-access-nodes-naptan

// DLR DATA Extracted from  https://www.whatdotheyknow.com/request/up_to_date_dlr_entry_exit_statis_2

The CSV for the ORR data is … https://dataportal.orr.gov.uk/media/1909/table-1410-passenger-entries-and-exits-and-interchanges-by-station.csv

If you have a NAPTAN (940GZZLULVT) you can get the 96-slots a day x 7 days a week data using https://api.tfl.gov.uk/crowding/940GZZLULVT?app_key=xxxxx → this is relative rather than absolute.