12 things we learned by reading every single National Rail timetable

Some departure boards, yesterday. Image: flickr.com/photos/joshtechfission/ CC-BY-SA

A couple of weeks ago, someone on Twitter asked CityMetric’s editor about the longest possible UK train journey where the stations are all in progressive alphabetical order. Various people made suggestions, but I was intrigued as to what that definitive answer was. Helpfully, National Rail provides a 3,717 page document containing every single timetable in the country, so I got reading!

(Well, actually I let my computer read the raw data in a file provided by ATOC, the Association of Train Operating Companies. Apparently this ‘requires a good level of computer skills’, so I guess I can put that on my CV now.)

Here’s what I learned:

1) The record for stops in progressive alphabetical order within a single journey is: 10

The winner is the weekday 7.42am Arriva Trains Wales service from Bridgend to Aberdare, which stops at the following stations in sequence:

  • Barry, Barry Docks, Cadoxton, Cardiff Central, Cardiff Queen Street, Cathays, Llandaf, Radyr, Taffs Well, Trefforest

The second longest sequence possible – 8 – overlaps with this. It’s the 22:46pm from Cardiff Central to Treherbert, although at present it’s only scheduled to run from 9-12 April, so you’d better book now to avoid the rush. 

  • Cardiff Central, Cardiff Queen Street, Cathays, Llandaf, Radyr, Taffs Well, Trefforest, Trehafod

Not quite sure what you’ll actually be able to do when you get to Trehafod at half eleven. Maybe the Welsh Mining Experience at Rhondda Heritage Park could arrange a special late night event to celebrate.

Just one of the things that you probably won't be able to see in Trehafod. Image: Wikimedia/FruitMonkey.

There are 15 possible runs of 7 stations. They include:

  • Berwick Upon Tweed, Dunbar, Edinburgh, Haymarket, Inverkeithing, Kirkcaldy, Leuchars
  • Bidston, Birkenhead North, Birkenhead Park, Conway Park, Hamilton Square, James Street, Moorfields
  • Bedford, Flitwick, Harlington, Leagrave, Luton, St Albans City, St Pancras International

There is a chance for a bit of CONTROVERSY with the last one, as you could argue that the final station is actually called London St Pancras. But St Pancras International the ATOC data calls it, so if you disagree you should ring them up and shout very loudly about it, I bet they love it when stuff like that happens.

Alphabetical train journeys not exciting enough for you?

2) The longest sequence of stations with alliterative names: 5

There are two ways to do this:

  • Ladywell, Lewisham, London Bridge, London Waterloo (East), London Charing Cross – a sequence which is the end/beginning of a couple of routes in South East London.
  • Mills Hill, Moston, Manchester Victoria, Manchester Oxford Road, Manchester Piccadilly – from the middle of the Leeds-Manchester Airport route.

There are 20 ways to get a sequence of 4, and 117 for a sequence of 3, but there are no train stations in the UK beginning with Z so shut up you at the back there.

3) The longest sequence of stations with names of increasing length: 7

Two of these:

  • York, Leeds, Batley, Dewsbury, Huddersfield, Manchester Victoria, Manchester Oxford Road
  • Lewes, Glynde, Berwick, Polegate, Eastbourne, Hampden Park, Pevensey & Westham

4) The greatest number of stations you can stop at without changing trains: 50

On a veeeeery slow service that calls at every stop between Crewe and Cardiff Central over the course of 6hr20. Faster, albeit less comprehensive, trains are available.

But if you’re looking for a really long journey, that’s got nothing on:


5) The longest journey you can take on a single National Rail service: 13 hours and 58 minutes.

A sleeper service that leaves Inverness at 7.17pm, and arrives at London Euston at 9.15am the next morning. Curiously, the ATOC data appears to claim that it stops at Wembley European Freight Operations Centre, though sadly the National Rail website makes no mention of this once in a lifetime opportunity.

6) The shortest journey you can take on a National Rail service without getting off en route: 2 minutes.

Starting at Wrexham Central, and taking you all the way to Wrexham General, this service is in place for a few days in the last week of March.

7) The shortest complete journey as the crow flies: 0 miles

Because the origin station is the same as the terminating station, i.e. the journey is on a loop.

8) The longest unbroken journey as the crow flies: 505 miles

Taking you all the way from Aberdeen to Penzance – although opportunities to make it have become rarer. The only direct service in the current timetable departs at 8.20am on Saturday 24 March. It stops at 46 stations and takes 13 hours 20 minutes. Thankfully, a trolley service is available.

9) The shortest station names on the network have just 3 letters

Ash, Ayr, Ely, Lee, Lye, Ore, Par, Rye, Wem, and Wye.

There’s also I.B.M., serving an industrial site formerly owned by the tech firm, but the ATOC data includes those full stops so it's not quite as short. Compute that, Deep Blue, you chess twat.

10) The longest station name has 33 letters excluding spaces

Okay, I cheated on this and Googled it – the ATOC data only has space for 26 characters. But for completeness’ sake: it’s Rhoose Cardiff International Airport, with 33 letters.

No, I’m not counting that other, more infamous Welsh one, because it’s listed in the database as Llanfairpwll, which is what it is actually called.

 

This sign is a lie. Image: Cyberinsekt.

11) The highest platform number on the National Rail network is 22

Well, the highest platform number at which anything is currently scheduled to stop at, at least.

12) if yoU gAze lOng into an abYss the abySs alSo gazEs into yOu

Image: author's own.

“For I have seen God face to face, and my life is preserved”, said Thomas.

Ed Jefferson works for the internet and tweets as @edjeff.

Want more of this stuff? Follow CityMetric on Twitter or Facebook.

 
 
 
 

Urgently needed: Timely, more detailed standardized data on US evictions

Graffiti asking for rent forgiveness is seen on a wall on La Brea Ave amid the Covid-19 pandemic in Los Angeles, California. (Valerie Macon/AFP via Getty Images)

Last week the Eviction Lab, a team of eviction and housing policy researchers at Princeton University, released a new dashboard that provides timely, city-level US eviction data for use in monitoring eviction spikes and other trends as Covid restrictions ease. 

In 2018, Eviction Lab released the first national database of evictions in the US. The nationwide data are granular, going down to the level of a few city blocks in some places, but lagged by several years, so their use is more geared toward understanding the scope of the problem across the US, rather than making timely decisions to help city residents now. 

Eviction Lab’s new Eviction Tracking System, however, provides weekly updates on evictions by city and compares them to baseline data from past years. The researchers hope that the timeliness of this new data will allow for quicker action in the event that the US begins to see a wave of evictions once Covid eviction moratoriums are phased out.

But, due to a lack of standardization in eviction filings across the US, the Eviction Tracking System is currently available for only 11 cities, leaving many more places facing a high risk of eviction spikes out of the loop.

Each city included in the Eviction Tracking System shows rolling weekly and monthly eviction filing counts. A percent change is calculated by comparing current eviction filings to baseline eviction filings for a quick look at whether a city might be experiencing an uptick.

Timely US eviction data for a handful of cities is now available from the Eviction Lab. (Courtesy Eviction Lab)

The tracking system also provides a more detailed report on each city’s Covid eviction moratorium efforts and more granular geographic and demographic information on the city’s evictions.

Click to the above image to see a city-level eviction map, in this case for Pittsburgh. (Courtesy Eviction Lab)

As part of their Covid Resource, the Eviction Lab together with Columbia Law School professor Emily Benfer also compiled a scorecard for each US state that ranks Covid-related tenant protection measures. A total of 15 of the 50 US states plus Washington DC received a score of zero because those states provided little if any protections.

CityMetric talked with Peter Hepburn, an assistant professor at Rutgers who just finished a two-year postdoc at the Eviction Lab, and Jeff Reichman, principal at the data science research firm January Advisors, about the struggles involved in collecting and analysing eviction data across the US.

Perhaps the most notable hurdle both researchers addressed is that there’s no standardized reporting of evictions across jurisdictions. Most evictions are reported to county-level governments, however what “reporting” means differs among and even within each county. 

In Texas, evictions go through the Justice of the Peace Courts. In Virginia they’re processed by General District Courts. Judges in Milwaukee are sealing more eviction case documents that come through their courtroom. In Austin, Pittsburgh and Richmond, eviction addresses aren’t available online but ZIP codes are. In Denver you have to pay about $7 to access a single eviction filing. In Alabama*, it’s $10 per eviction filing. 

Once the filings are acquired, the next barrier is normalizing them. While some jurisdictions share reporting systems, many have different fields and formats. Some are digital, but many are images of text or handwritten documents that require optical character recognition programs and natural language processors in order to translate them into data. That, or the filings would have to be processed by hand. 

“There's not enough interns in the world to do that work,” says Hepburn.


Aggregating data from all of these sources and normalizing them requires knowledge of the nuances in each jurisdiction. “It would be nice if, for every region, we were looking for the exact same things,” says Reichman. “Instead, depending on the vendor that they use, and depending on how the data is made available, it's a puzzle for each one.”

In December of 2019, US Senators Michael Bennet of Colorado and Rob Portman of Ohio introduced a bill that would set up state and local grants aimed at reducing low-income evictions. Included in the bill is a measure to enhance data collection. Hepburn is hopeful that the bill could one day mean an easier job for those trying to analyse eviction data.

That said, Hepburn and Reichman caution against the public release of granular eviction data. 

“In a lot of cases, what this gets used for is for tenant screening services,” says Hepburn. “There are companies that go and collect these data and make them available to landlords to try to check and see if their potential tenants have been previously evicted, or even just filed against for eviction, without any sort of judgement.”

According to research by Eviction Lab principal Matthew Desmond and Tracey Shollenberger, who is now vice president of science at Harvard’s Center for Policing Equity, residents who have been evicted or even just filed against for eviction often have a much harder time finding equal-quality housing in the future. That coupled with evidence that evictions affect minority populations at disproportionate rates can lead to widening racial and economic gaps in neighborhoods.

While opening up raw data on evictions to the public would not be the best option, making timely, granular data available to researchers and government officials can improve the system’s ability to respond to potential eviction crises.

Data on current and historical evictions can help city officials spot trends in who is getting evicted and who is doing the evicting. It can help inform new housing policy and reform old housing policies that may put more vulnerable citizens at undue risk.

Hepburn says that the Eviction Lab is currently working, in part with the ACLU, on research that shows the extent to which Black renters are disproportionately affected by the eviction crisis.

More broadly, says Hepburn, better data can help provide some oversight for a system which is largely unregulated.

“It's the Wild West, right? There's no right to representation. Defendants have no right to counsel. They're on their own here,” says Hepburn. “I mean, this is people losing their homes, and they're being processed in bulk very quickly by the system that has very little oversight, and that we know very little about.”

A 2018 report by the Philadelphia Mayor’s Taskforce on Eviction Prevention and Response found that of Philadelphia’s 22,500 eviction cases in 2016, tenants had legal representation in only 9% of them.

Included in Hepburn’s eviction data wishlist is an additional ask, something that is rarely included in any of the filings that the Eviction Lab and January Advisors have been poring over for years. He wants to know the relationship between money owed and monthly rent.

“At the individual level, if you were found to owe $1,500, was that on an apartment that's $1,500 a month? Or was it an apartment that's $500 a month? Because that makes a big difference in the story you're telling about the nature of the crisis, right? If you're letting somebody get three months behind that's different than evicting them immediately once they fall behind,” Hepburn says.

Now that the Eviction Tracking System has been out for a week, Hepburn says one of the next steps is to start reaching out to state and local governments to see if they can garner interest in the project. While he’s not ready to name any names just yet, he says that they’re already involved in talks with some interested parties.

*Correction: This story initially misidentified a jurisdiction that charges $10 to access an eviction filing. It is the state of Alabama, not the city of Atlanta. Also, at the time of publication, Peter Hepburn was an assistant professor at Rutgers, not an associate professor.

Alexandra Kanik is a data reporter at CityMetric.