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
0773 ...a collision between trains. Reason      
0519 Please join the middle ten coaches of this train Passenger information      
0916 a speed restriction over an embankment Reason      
2199 Whifflet Destination     WFF
0763 ...a coach becoming uncoupled on a train. Reason      
0335 21 Time      
2081 Mallaig Destination     MLG
1923 London Moorgate Destination     MOG
1233 Priesthill and Darnley Destination     PTL
0508 Please join the middle coach only Passenger information      
0693 Chinley Destination     CLY
2078 Lochwinnoch Destination     LHW
2128 Stepps Destination     SPS
1705 Berry Brow Destination     BBW
0695 Church Fenton Destination     CHF
0456 The Grand Central service to Train operating company      
0194 Stand well away from the edge of platform 5 Safety      
0911 a speed restriction in a tunnel earlier today Reason      
2089 Mount Vernon Destination     MTV
0390 Barry Links Destination Low-pitch ending   BYL
0120 Is delayed by approximately 55 minutes Time      
2182 Hyndland Destination     HYN
0308 04 Time oh-four    
1810 Derby Destination     DBY
1020 Heavy snow Weather      
1919 Lockerbie Destination     LOC
1184 London Marylebone Destination     MYB
0977 Attempted theft of signalling cables yesterday Reason      
0909 a speed restriction in a tunnel Reason      
0311 Shepherd's Bush Destination     SPH
1316 thirteen Number      
1447 Laurencekirk Destination     LAU
1230 Portlethen Destination     PLN
1042 Overcrowding as this train has fewer coaches than normal Reason      
2436 Dumbarton East Destination     DBE
1549 ...is the delayed... Conjoining      
0572 A train failure Reason      
1454 Balmossie Destination     BSI
0561 Cycles are not permitted on this train Passenger information      
0789 ...a fault with the electric third rail. Reason Why do they need this...    
0304 Liverpool South Parkway Destination     LPY
0980 Attempted theft of third rail electrification equipment yesterday Reason      
1816 Dumfries Destination     DMF
0157 Is at present being tested by our engineers Operational      
1461 Broughty Ferry Destination     BYF
2248 Fairlie Destination     FRL
1922 London Marylebone Destination     MYB
2056 Kildonan Destination     KIL
0805 A fire near the railway involving gas cylinders yesterday Reason      
2425 Winchester Destination     WIN
2431 Wick Destination     WCK
0229 This is a platform alteration Platform information      
0011 The next train at platform Platform information   0:00:32  
2111 Renton Destination     RTN
0510 Vandalism Reason      
0986 Congestion Reason      
0659 Bridgwater Destination     BWT
1177 Please use all available doors when getting on the train. Passenger information      
1056 The police dealing with an incident Reason      
1128 This train not stopping in the correct position at a station, earlier today Reason      
0804 A fire near the railway involving gas cylinders earlier today Reason      
2067 Langside Destination     LGS
2254 Garelochhead Destination     GCH
0415 Ardrossan South Beach Destination     ASB
0793 ...a fault with the on-train signalling system earlier on this train's journey. Reason      
2010 Paddington Destination     PAD
1649 Adlington Destination     ADC
2257 Garscadden Destination     GRS
0915 a speed restriction over a bridge earlier today Reason      
1393 The Conjoining      
2284 Kinbrace Destination     KBC
0920 a speed restriction over defective track earlier on this train's journey Reason      
0705 Conon Bridge Destination     CBD
0012 The next train at platform 1 is the Platform information "the" (/ðə/)    
1491 four Number      
1429 is delayed by approximately... Conjoining      
0860 A road vehicle colliding with a bridge earlier today Reason      
0358 42 Time      
2127 Quintrell Downs Destination     QUI
2358 West Kilbride Destination     WKB
1437 Monifieth Destination     MON
2370 Cardonald Destination     CDO
0482 The Spa Valley Railway Heritage Railway Sussex has been taken over by Scotland    
1344 forty Number      
0621 Berry Brow Destination     BBW
0010 [white noise] Non-vocal non-vocal 0:00:26  
0287 Eskbank Destination     EKB
1613 Cardenden Destination     CDD
0690 Chester Destination     CTR
1358 fifty-four Number      
2187 Rogart Destination     ROG
1343 thirty-nine Number      
2079 Loch Awe Destination     LHA
2277 Invershin Destination     INH
1974 Midland Mainline Turbostar Train operating company      
1548 Mitcham Eastfields Destination     MTC
0473 The Cathedrals Express special steam service from Special train      
0952 The ambulance service dealing with an incident near the railway earlier today Reason      
1678 Baildon Destination     BLD
0981 Cattle on the railway Reason