Train Database 2020

[BenW390Fan]

Hi, Sorry for replying so late i have been trying to catch up on other things. Thanks for welcoming me to the forum and well done on doing the database it is useful.

Re 37057: I did see the photos online before saying that it has been repainted. It is a shame that the BR Green Livery went but at least the locomotive is still running on the network.

Also I have found a few more to update:

Update on Class 37s:

• 37003 is Under Overhaul/Preserved instead of In Service.
• 37422 is In Service instead of Stored (Been used on RHTT).
• 37521 is in BR Green instead of Colas Rail.

Update on Class 43s:

• 43046 & 43055 is in Midland Pullman Livery instead of Ex-East Midlands Trains.
• 43048 is now owned by 125 Group and in Ex-East Midlands Trains.
• 43052, 43054, 43066 & 43076 are operated by Data Acquisition & Testing Services Ltd (DATS) and are in Ex-East Midlands Trains with DATS Branding.

Update on Class 67s:

• 67008 is now in Transport for Wales livery instead of Ex-EWS.

And on a similar note, 43089 isn't in storage - it was in use yesterday.

Thank you so much to both of you, I'm really sorry for not updating it recently - I've been so stressed I haven't had the chance. Really happy to hear it's of use 37's are one of the locos I can't seem to find any gen on! Thanks for letting me know. I've updated 43089 aswell now, apologies

 

[CR165022]

Another little update, 165022 now in new Chiltern livery

 

[BenW390Fan]

Another little update, 165022 now in new Chiltern livery

Updated, thanks

 

[CR165022]

Updated, thanks

Another update (many more to come soon I'm guessing)
165028 is back in service still in old livery

 

[BenW390Fan]

Another update (many more to come soon I'm guessing)
165028 is back in service still in old livery

Updated

 

[43055]

43208 and 43239 have now moved to Laira in Cross Country livery. I would assume both will see service soon.
156406 now has EMR regional branding.
170418 is now with EMR and currently being painted into EMR livery.

 

[Townsend Hook]

One update which perhaps might be made is that Scotrail 43030 and 43140 are no longer ’in service’, following their involvement in the Carmont derailment and subsequent move into secure storage for the investigation.

 

[BenW390Fan]

Apologies, I saw your messages but never got round to doing it!

 

[CR165022]

a few updates:
165038 now in the new Chiltern livery
all remaining northern pacers can be marked as out of service/storage now
158798 is 3 car not 2 car like it is marked as currently (not hybrid like the /9s, it has a proper center car)

 

[St. Paddy]

a few updates:
165038 now in the new Chiltern livery
all remaining northern pacers can be marked as out of service/storage now
158798 is 3 car not 2 car like it is marked as currently (not hybrid like the /9s, it has a proper center car)
43208 & 43239 are now in cross country livery
and 170418 is now in northern ownership

I think you mean East Midlands for 170418

 

[CR165022]

I think you mean East Midlands for 170418

yes i did, sorry!
however i saw it was mentioned already so removed it from the post

 

[St. Paddy]

yes i did, sorry!
however i saw it was mentioned already so removed it from the post

No worries

 

[Liam-Wabtec]

Train Database 2020
Publicly released now!

https://docs.google.com/spreadsheets/d/e/2PACX-1vQtQ0gPBuw1ktpNjXOOULKzMnpSnrZgdD6sFNF68xchsczbrZ0fCz0iGkUMooZCgLf8AwvGDb2cLrkA/pubhtml

After 5 months in development, I've finally released the train database which features locomotives, DMU's and EMU's. This database includes number lists, the relevant TOC / FOC, liveries, notes and nameplates. This is still heavily unfinished and is always being updated. Some stock aren't as up to date as others but these are being worked on. I'll probably focus on modern stock as that's the stock that I can get more information on regarding status, liveries, etc. I hope enjoy using it and I hope it's somewhat useful!

When the database gets updated, I'll post the update log in this thread. I'm open for constructive feedback, good or bad

This is a community contributed project. I.e. if someone posts to this thread that X train has been scrapped and provides proof, I'll mark it down as out of service on the database as I'm obviously not going to be able to know what the status of every single train in the country is! The same can apply with the train operator, livery, nameplates, etc.

Stock Update Submission

If info of a particular loco / unit is incorrect on the database, you can submit an update request via the following Google Form:

Train Database Stock Update Submission

Submit updates to the relevant loco or unit if the info on the database is incorrect.

forms.gle

Hi Ben,

Is there anyway you could export this to an excel doc and email it to me?

Many thanks

Liam

 

[BenW390Fan]

Hi Ben,

Is there anyway you could export this to an excel doc and email it to me?

Many thanks

Liam

Hi, can I ask what it'd be used for please? Just that I don't want to give edit permissions

 

[43055]

EMR update (a lot on HST's):

43047, 049, 073, 277, 290, 296, 299, 308, 314, 318, 423, 465, 467, 468, 480, 484 are all not stored.
156406 is now has branding
156902 is now in the EMR outgoing livery.
170418 is now with EMR and in the full regional livery like the other EMR 170's.
180113 is now in the outgoing EMR livery (like 110/111) and I think all 4 180's are now been in service.

 

[REVUpminster]

Being new to this site I thought I'd report 158798 was working 2F24 Paignton - Exmouth tonight and it was three coaches. When i got home I checked Dawlish cams to watch it go through.

 

[PHILIPE]

Being new to this site I thought I'd report 158798 was working 2F24 Paignton - Exmouth tonight and it was three coaches. When i got home I checked Dawlish cams to watch it go through.

Being new to this site I thought I'd report 158798 was working 2F24 Paignton - Exmouth tonight and it was three coaches. When i got home I checked Dawlish cams to watch it go through.

Yes. 158 was a genuine 3 Car set from birth.

 

[REVUpminster]

I am interested in stock at Exeter depot as the 143s have gone. Three went last Wednesday. There are two 166s there 210 and 211. 211 I photographed at Paignton in service on the 13 December but i am wondering if there are anymore there plus 158s, one of which seems to come down from Bristol then goes back later in the week.

 

[507021]

Hopefully these updates are useful:

There are no more Pacers in use with Northern.
150115, 117/118 and 122 are in Northern livery.
158791 hasn't been repainted yet.
158851 is in Northern livery.
195021 is out of service for repairs.
195131-133 have been delivered and are in service.

 

[ALEMASTER]

You may (or may not) want to add the tram trains with Stagecoach Supertram: 399201 to 399207, they are shown in TOPS as EMUs.

South Yorkshire | Supertram | Tram Train

All you need to know about the South Yorkshire tram train project.

www.stagecoachbus.com

They operate on Network Rail infrastructure Tinsley-Rotherham Central-Rotherham Parkgate with the rest of the route from Sheffield on the tramway.

 

[PHILIPE]

There are now no 142s with TFW or 143s with GWR, all withdrawn.

 

[CR165022]

There are now no 142s with TFW or 143s with GWR, all withdrawn.

Are 143617 & 618 not in service anymore? Because they were in service after the day when they all "left service"

 

[PHILIPE]

Are 143617 & 618 not in service anymore? Because they were in service after the day when they all "left se

Are 143617 & 618 not in service anymore? Because they were in service after the day when they all "left service"

No. They are not allowed to be having no authority to work after December 31st. In any case they have been moved out of Exeter to await scrapping, the last day out was December 28th.

 

[REVUpminster]

143603/618/617 and 150207, 8 coaches went St Phillip Marsh on the 30 DMR 2020. What happened to the other five units?

 

[43172]

143603/618/617 and 150207, 8 coaches went St Phillip Marsh on the 30 DMR 2020. What happened to the other five units?

619 and 612 went to St Philips Marsh on the 6th December, 611/620/621 went to Landore on the 17th December

 

[REVUpminster]

619 and 612 went to St Philips Marsh on the 6th December, 611/620/621 went to Landore on the 17th December

Thank you. There must be some reciprocal 166s back to Exeter. They needed four (they have 2) to replace the 8 143s which have in turn been replaced by short castle sets unless Exmouth gets a shock and one turns up there.

166203 working Paignton-Exmouth 09JNR2020 still in it's First Great Western livery and with 1st class decals. Guard in the back cab but I think the driver opened the doors.

.

 

[Peter C]

I've just had a look at the site and was wondering if all was alright? @BenW390Fan hasn't been on the thread for a while and it would be a real shame if the database wasn't updated further; it's a really good resource.

-Peter

 

[hst43102]

I've just had a look at the site and was wondering if all was alright? @BenW390Fan hasn't been on the thread for a while and it would be a real shame if the database wasn't updated further; it's a really good resource.

-Peter

Hello Peter, I agree that it's a complete shame to leave it un-updated! I think Ben is probably busy with exams and things, so I've created a copy of the database and I will carry on updating it until Ben is available. You can find the new database here : https://docs.google.com/spreadsheets/d/1eXMGk1AIA39NbiB77Pg7j59dxfddx5aPC3P7QNf6Tc8/edit?usp=sharing

It's not been updated for a few months, so please let me know what needs updating!

 

[43 302]

Hello Peter, I agree that it's a complete shame to leave it un-updated! I think Ben is probably busy with exams and things, so I've created a copy of the database and I will carry on updating it until Ben is available. You can find the new database here : https://docs.google.com/spreadsheets/d/1eXMGk1AIA39NbiB77Pg7j59dxfddx5aPC3P7QNf6Tc8/edit?usp=sharing

It's not been updated for a few months, so please let me know what needs updating!

More graphics would be nice! Class 43 could do with a bit of an update!

 

[hst43102]

More graphics would be nice! Class 43 could do with a bit of an update!

Absolutely. I've just added the Class 40 as I had the graphics sitting about, I'll work on getting the 43's updated this afternoon