scotrail

Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette

Custom SQL query returning 100 rows (hide)

This data as json, CSV

FileTranscriptionCategorymp3NotesTimestampNRE_ID
0427 Eskbank Destination     EKB
2411 Patterton Destination     PTT
1715 will be diverted to Conjoining      
1532 a staff shortage Reason      
1305 02 Time oh-two    
0897 a speed restriction because of high track temperatures earlier today Reason      
2033 Par Destination     PAR
1651 Howwood Destination Not to be confused with How Wood (HWW) - with the exception of Watford Junction (WFJ), no other stations on this branch are included therefore this must be the Howwood in Scotland   HOZ
1204 Newark Northgate Destination     NNG
1860 Anderston Destination     AND
1627 Dunkeld & Birnam Destination     DKD
0448 White City Destination London Underground    
2303 Lochwinnoch Destination     LHW
1662 Appley Bridge Destination     APB
2204 Carfin Destination     CDF
1602 Bathgate Destination     BHG
0422 Merryton Destination     MEY
1135 Trespassers on the railway Reason      
2090 Muir of Ord Destination     MOO
0503 Please join the front nine coaches of this train Passenger information      
0280 Kelvindale Destination     KVD
1587 North Berwick Destination     NBW
1547 The train now at... Conjoining      
2297 Achnasheen Destination     ACN
1564 The next train at platform Passenger information      
2399 East Kilbride Destination     EKL
1342 thirty-eight Number      
2318 Oban Destination     OBN
1790 Cheltenham Spa Destination     CNM
0835 A person being hit by a train earlier Reason    
1476 Dalwhinnie Destination     DLW
0218 Stafford Destination     STA
2199 Whifflet Destination     WFF
1682 Banbury Destination     BAN
0035 platform 5 for the Platform information "the" (/ðə/)    
0832 A passenger being taken ill on this train Reason      
1441 North Queensferry Destination     NQU
2232 Coatbridge Sunnyside Destination     CBS
0761 ...a chemical spillage near the railway earlier today Reason      
2393 Truro Destination     TRU
1178 Leuchars Destination     LEU
2286 Kirkhill Destination     KKH
1975 Midland Mainline Turbostar service to Train operating company      
2273 Hillfoot Destination     HLF
1708 Bescar Lane Destination     BES
1354 fifty Number      
1314 eleven Number      
0182 This train is formed of 6 coaches Train formation      
1195 Markinch Destination     MNC
0991 Damage to the overhead electric wires earlier on this train's journey Reason      
0459 London Overground Train operating company      
1447 Laurencekirk Destination     LAU
1973 New Cumnock Destination     NCK
1181 Lockerbie Destination     LOC
0486 GNER Train operating company      
0177 This train is formed of 1 coach only Train formation      
0336 22 Time      
0144 Will arrive in approximately 20 minutes Time      
1271 Platform Platform ID      
1456 Bellshill Destination     BLH
1596 Shotts Destination     SHS
2427 Williamwood Destination     WLM
1516 Stand well away from the train at platform Passenger information      
0456 The Grand Central service to Train operating company      
1689 Barrhead Destination     BRR
0473 The Cathedrals Express special steam service from Special train      
2207 Dumbarton East Destination     DBE
0796 ...a fault with the radio system between the driver and the signaller earlier on this train's journey. Reason when has this ever been used    
0990 Damage to the overhead electric wires Reason      
0379 58 Time      
1679 The train now approaching platform Passenger information      
1876 Bridge of Orchy Destination     BRO
0915 a speed restriction over a bridge earlier today Reason      
2016 Drumgelloch Destination     DRU
0009 Midland Main Line service from Train operating company   0:00:22  
1062 Severe weather Weather      
1479 Dunkeld & Birnam Destination     DKD
1654 Althorpe Destination     ALN
0188 This train is formed of 12 coaches Train formation      
1085 The fire alarm sounding in a signal box earlier on this train's journey Reason      
1687 Please note Conjoining      
0525 Please join the rear three coaches of this train Passenger information      
1142 Urgent repairs to the railway Reason      
0222 Gartcosh Destination     GRH
1614 Carfin Destination     CDF
1055 Passengers causing a disturbance on this train Reason      
2431 Wick Destination     WCK
0684 Cark Destination     CAK
1731 will be at Conjoining      
2364 Barnhill Destination     BNL
1898 Inverness Destination     INV
2392 Dalry Destination     DLY
0249 Exhibition Centre Destination     EXG
1057 The police dealing with an incident near the railway Reason      
1667 Arram Destination     ARR
2069 Largs Destination     LAR
2244 Duirinish Destination     DRN
2287 Kirkwood Destination     KWD
0189 hundred hours Time      
0375 55 Time