Oct 252017

The Rail Delivery Group‘s database “Knowledgebase” contains (among other things) all the station information used e.g. on the National Rail enquiries website, including all the station accessibility information. This data is available to everybody, but in a format only programmers can use. So with help, I’ve converted the station accessibility data (and some other key data) into a spreadsheet.

Here’s the Knowledgebase stations spreadsheet in Excel format (~2.5Mb), and here’s the Knowledgebase stations spreadsheet in .csv format (~5Mb). Here’s National Rail Enquiries Knowledgebase Data Feeds Specification (PDF, 900kb) which describes what each element (should) describe.

The spreadsheet is current as of 3rd February 2018. (My spreadsheet can update the data, but I’ve removed this function from the spreadsheets here because the update mechanism uses my username and password for the National Rail Data Portal.)

One may wish to consider:

  • the proportion of stations that have step-free access, overall and by station operator
  • the proportion of stations that have toilets compared to the proportion of stations that have disabled toilets (“NKS toilets”, after the Radar National Key Scheme) or no information about disabled toilets
  • stations that have step free access and are staffed but don’t have train ramps available
  • stations with temporarily broken lifts, and when the data on the station was last updated
  • staffed stations which don’t offer staff assistance to disabled people
  • stations with car parks but no Blue Badge spaces and/or no suitable drop off point for disabled people
  • stations with contradictory information, such as stating both “Step-free access coverage: No part of station” and “Both platforms are fully accessible from the street

And whatever else you like, really.

If you would like me to update the spreadsheet, drop me a line.

Sorry, the comment form is closed at this time.

%d bloggers like this: