Finding Delays in a Week By Route

[Charles Winter]

Hello All,

I'm trying to investigate a software idea, that would require me to find all the delays (preferably with a query parameter of delay threshold) for a particular user defined route in the last week. 

So for example, someone might want to know all the delayed trains from Derby->Sheffield in the last week.

I assumed that the right place for me to go would be the HSP https://wiki.openraildata.com/index.php/HSP. It's 99% what I want, but sadly the query for tolerance is

 

tolerance (optional) is a set of up to three values to set the tolerances, e.g. ['2', '5', '10'] will return statistics for the number of trains which arrived at the to_loc within 2 minutes, within 5 minutes and within 10 minutes of their scheduled time

Whereas I'm interested in whether a train was 15m, 30m or an hour late. I see that I can individually query the serviceDetails endpoint with every individual RID to find that information but this doesn't feel like the right thing to do.

I'm after some advice please, as I'm a bit bewildered by the available datasets! Would someone please be able to point me in the right direction?

Much appreciated.

[Jeskynar]

Is this website any good?

https://www.recenttraintimes.co.uk/Home/Search?Op=Srch&Fr=Derby+%28DBY%29&To=Sheffield+%28SHF%29&TimTyp=A&TimDay=6a&Days=Wk&TimPer=7d&dtFr=&dtTo=&ShwTim=AvAr&MxArCl=5&ShwAdv=ShwAdv&TOC=All&ArrSta=60&SvcCtA=SvcCtA&SvcCtR=SvcCtR&SvcCtC=SvcCtC&SvcPcR=SvcPcR&SvcPcC=SvcPcC&SvcArS=SvcArS&SvcPfS=SvcPfS&SvcLWE=SvcLWE&MetAvg=Mea&MetSpr=RT&DaySum=DaySum&ArrGph=ArrGph&MxScDu=&MxSvAg=10&MnScCt=2

--
You received this message because you are subscribed to the Google Groups "A gathering place for the Open Rail Data community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openraildata-t...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/openraildata-talk/bec4a0bd-fbcb-4ade-ad6f-bfaaa67c0b0en%40googlegroups.com.

[Ryan Woolies]

I'm not sure how far along you are with your idea but I think HSP is the right data.
You can alter the tolerance values, so for example send the tolerance parameter as ['15','30','60'] for the number of trains 15, 30 and 60 minutes late.