Number of Services Per Station Stats

Discussion in 'UK Railway Discussion' started by FrankieGTH, 7 Jul 2019.

  1. FrankieGTH

    FrankieGTH Member

    Messages:
    12
    Joined:
    25 Jun 2019
    Hello there,

    I have collated how many services each station gets per week (passenger calls), taking into consideration reduced services on Sundays. I can't promise every figure is exact (realtimetrains spits out different numbers on a day by basis for some stations as the VAR and STP services fluctuate) but the figures are a very good guide.

    From this, I have worked out on average how many entrances and exits (E&E) for each service at each station. You can question the methodology, but again I think it's a good rough guide. I have not included interchange figures, just entrances and exits.

    Example...

    Harrow-On-The-Hill
    • 487 services per week
    • 69.57 services on average per day (487 ÷ 7)
    • 2,518,034 entries and exits last year according to official figures
    • That makes 6,917 entries and exits per day (2,518,034 ÷ 364 days)
    • 6,917 E&E per day ÷ 69.57 services per day = 99.43 passengers per service
    Random things that pop out at me...

    Bath Spa, 142 services per day, 6,395,694 E&E last year
    vs
    Ford, 186 services per day, 114,594 E&E last year

    Harrow-On-The-Hill, 69 services per day, 2,518,034 E&E last year
    vs
    Bishopstone, 74 services per day, 33,686 E&E last year

    I attach the spreadsheet with the figures, I hope some of you might find it interesting and you can compare how many services your station gets in comparison to others.

    Edit: I believe some of the very small stations are reporting 1 less service than in reality. i.e. Clifton should be 12, not 11. I can see how that's happened but it would be too much effort to fix it on a Sunday evening!
     

    Attached Files:

    Last edited: 7 Jul 2019
  2. Registered users do not see these banners - join or log in today!

    Rail Forums

     
  3. johnr57

    johnr57 Member

    Messages:
    144
    Joined:
    29 Mar 2013
    wow - what a fascinatingly interesting piece of work, well done and thank you

    re sorting by least pax makes more interesting reading
     
  4. bhb

    bhb Member

    Messages:
    24
    Joined:
    13 Nov 2018
    Thanks! I do like things like this!
    But, Harrow on the Hill cannot be a good example, it's on the metropolitan line, so must get a lot more than 487 trains per week? I know they won't all be national rail services, but, how would the exit/entry data show that?
     
  5. yorkie

    yorkie Administrator Staff Member Administrator

    Messages:
    43,712
    Joined:
    6 Jun 2005
    Location:
    Yorkshire
    The number of NR trains is known (the figure given does not include LU services; if they did the figures would be exponentially higher!).
    There are estimates that differentiate between NR vs LU usage. How accurate those estimates are (given fares are inter-available on this route), I don't know.

    But the average passenger count is stated to be approx 50 alighting and 50 boarding per train. This is plausible but it's really a guestimate. At peak times there will be many more than that, but off peak much fewer.
     
    Last edited: 7 Jul 2019
  6. FrankieGTH

    FrankieGTH Member

    Messages:
    12
    Joined:
    25 Jun 2019
  7. imagination

    imagination Member

    Messages:
    466
    Joined:
    3 Aug 2010
    One arguable issue with the list would be that a train that terminates somewhere is counted as one train, and then when it starts back in the other direction it counts as another. The first train will only have exits, and the latter only entrances. Meanwhile a station where a train calls only counts as one service, but will generate both entries and exits.

    To demonstrate - Henley-on-Thames lists 31.57 passengers per service. This means the average train that picks up passengers here will pick up (roughly) 31.57 people. Down the line at Wargrave, the figure listed is 3.82. Here, each train that picks up passengers and generates entries also drops off passengers to generate exits (or can do at any rate), so the average train that picks up passengers here will pick up just 1.91 people.

    This would go some way to explaining why places like Chelmsford and Bath Spa, with very few terminating services, are so high up the list. The average train that pulls into Seven Sisters will only drop off half as many passengers as the average train that pulls into Marylebone.
     
  8. FrankieGTH

    FrankieGTH Member

    Messages:
    12
    Joined:
    25 Jun 2019
    Interesting, I hadn't thought of that, good point.

    Another thing I played around with was the disproportionate amount of services against how many E&E each station gets...

    So Ford is ranked 1,659 in how many people it serves, but ranked 359 in how many services it gets.

    [​IMG]

    at the other end of the scale...

    [​IMG]

    The people of Barnstaple should write to their local MP! :D
     
  9. yorkie

    yorkie Administrator Staff Member Administrator

    Messages:
    43,712
    Joined:
    6 Jun 2005
    Location:
    Yorkshire
    I believe this is an interchange station so you'd expect it to get a better service, proportionally, than the number of people who exit/enter there.

    If only it wasn't at the end of a branch line (or a branch line with several similarly well used stations!)
     
  10. thenorthern

    thenorthern Established Member

    Messages:
    3,464
    Joined:
    27 May 2013
    At around 25 passengers per train someone should electrify the line to Corby and introduce 12 coach trains to the town as it's in dire need even more so that Nottingham, Leicester and Derby. :lol:
     
  11. FelixtheCat

    FelixtheCat Established Member

    Messages:
    2,821
    Joined:
    23 Jul 2015
    Location:
    Edinburgh, London, or somewhere else
    Yes to an extent. Most people change at Barnham (1 stop down the line). It's busier and gets a full service.
     
  12. mikey9

    mikey9 Member

    Messages:
    67
    Joined:
    19 Aug 2013
    Very interesting - looking at Highland services the data suggests 38 per day for Mallaig...?
     
  13. bigfoote

    bigfoote Member

    Messages:
    66
    Joined:
    5 Jan 2013
    Ford has a lot of scheduled stops, I believe, to prevent congestion with the Bognor shuttle. Preferable to have a scheduled stop rather than to hold it at signals closer to Barnham.
     
  14. FrankieGTH

    FrankieGTH Member

    Messages:
    12
    Joined:
    25 Jun 2019
    Hmmm, that 38 includes a great deal of SHIP services, which obviously shouldn't count. I removed BUS services but hadn't thought of ships! There appears to be more ships on Fridays and weekends I assume because of tourism? I know there are SailRail tickets, but didn't know you could use a rail ticket to also catch a ship at Mallig.
     
  15. kieron

    kieron Established Member

    Messages:
    2,225
    Joined:
    22 Mar 2012
    Location:
    Connah's Quay
    Looking at the figures for Harrow & Wealdstone, the "number of services" column does seem to include LT services along with the others. Does TfL collect passenger numbers in a similar way?
     
  16. Mojo

    Mojo Administrator Staff Member Administrator

    Messages:
    17,025
    Joined:
    7 Aug 2005
    Location:
    0035
    Harrow and Wealdstone and Richmond (as well as intermediate stations) will include Underground trains in the data as the line is owned by Network Rail, similarly the Wimbledon branch south of the bridge at Putney even though the line is owned by LU it operates under NR rules.

    London Underground does publish data on passenger numbers, you can find a spreadsheet on the TfL website: http://content.tfl.gov.uk/multi-year-station-entry-and-exit-figures.xlsx
     
  17. kieron

    kieron Established Member

    Messages:
    2,225
    Joined:
    22 Mar 2012
    Location:
    Connah's Quay
    Thanks. The notes on that table say that some counts include NR passengers, but don't say which ones are affected. I don't know much at all about how the NR entry/exit figures treat London.

    If the two organisations' figures for this station overlap, though, then I can't just use these figures to estimate how many people used an average NR service, or anything like that.
     
  18. NorthOxonian

    NorthOxonian Member

    Messages:
    62
    Joined:
    5 Jul 2018
    I am very impressed by Bordesley (obviously the figure is heavily distorted by the fact it gets one train a week). Is that mainly from Birmingham City fans or residents of Bordesley itself?

    I'd be interested to see (and might to make myself) a version of the disproportionate table using the ratio of the rankings (so #20 E&E and #50 services would get 0.4 for example). There seem to be quite a few stations which punch well above their weight (Exeter Central for instance), but many of these would still be in the top 500 for service levels, so they'd never be able to have a difference of 1,200 like Barnstaple.
     
  19. FelixtheCat

    FelixtheCat Established Member

    Messages:
    2,821
    Joined:
    23 Jul 2015
    Location:
    Edinburgh, London, or somewhere else
    Mainly football crowds. It gets additional services on matchdays, so the figure is to be treated with caution.
     
  20. deltic

    deltic Established Member

    Messages:
    1,999
    Joined:
    8 Feb 2010
    Just stumbled upon this - a fascinating data set do you mind if I produce a blog on this with a link to your spreadsheet?
     
  21. FrankieGTH

    FrankieGTH Member

    Messages:
    12
    Joined:
    25 Jun 2019
    Sure, no problem.
     
  22. Deafdoggie

    Deafdoggie Established Member

    Messages:
    1,339
    Joined:
    29 Sep 2016

    Indeed, having done the weekly train, I can assure you it really isn’t used much, or indeed, at all, apart from match days, when there are very more trains laid on. A difficult station to quantify really.
     
  23. Birkonian

    Birkonian Member

    Messages:
    40
    Joined:
    19 Sep 2017
    I'm sure that this is a fantastic piece of work - I don't have Excel on this laptop to view it - however, figures for my local station, Spital, will be skewed by Merseyrail missing it out regularly to make up time.
     

Share This Page