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
1898 Inverness Destination     INV
0858 A road vehicle colliding with a bridge Reason      
0782 ...a fault on this train. Reason      
0674 Burscough Bridge Destination     BCB
0652 Bredbury Destination     BDY
0030 will be at Conjoining      
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    
1880 This train is ready to leave Passenger information      
0545 First class accommodation is available Passenger information      
2428 Wishaw Destination     WSH
0444 Stirling Destination     STG
0204 Southeastern Trains service from Train operating company      
2035 Garve Destination     GVE
2146 Retford Destination     RET
1083 The fire alarm sounding at a station earlier today Reason      
0727 Grantham Destination     GRA
1399 fourteen Number      
1960 4, 5, 6 Number combo      
1514 This train will be calling at stations with short platforms Passenger information      
0900 a speed restriction because of high winds earlier today Reason      
1191 Manchester Piccadilly Destination     MAN
2114 Prestwick Town Destination     PTW
0754 ...a burst water main near the railway, earlier today. Reason      
2147 Cardonald Destination     CDO
0567 and can be found in the middle and rear of the train Passenger information      
2040 Greenfaulds Destination     GRL
0740 ...a bicycle on the track earlier today. Reason      
0399 Gilshochill Destination     GSC
0996 Kirkcaldy Destination     KDY
0249 Exhibition Centre Destination     EXG
1013 Flooding earlier today Reason      
0330 16 Time      
1326 twenty-three Number      
0296 Abbey Road Destination DLR    
0172 Will be in approximately 35 minutes Time      
2361 Yoker Destination Les Porter   YOK
1143 Urgent repairs to the railway earlier today Reason      
0338 24 Time      
1480 Edinburgh Waverley Destination     EDB
1815 This train is formed of one coach only Train formation      
0838 A problem currently under investigation Reason      
1660 Appleby Destination     APP
1446 minutes. Time end of sentence    
0516 Please join the middle seven coaches of this train Passenger information      
0855 A road vehicle blocking the railway Reason      
2223 Baillieston Destination     BIO
1830 Melksham Destination     MKM
0058 will now depart from platform 5 Platform information      
0024 The next train at platform 5 is the Platform information "the" (/ði/)    
1533 has been cancelled Conjoining      
2071 Achanalt Destination     AAT
0328 15 Time      
1862 Argyle Street Destination     AGS
1151 Vandalism of railway equipment earlier today Reason      
1559 Dunston Destination     DOT
2120 Shawlands Destination     SHL
0108 Will be in 55 minutes Time      
0793 ...a fault with the on-train signalling system earlier on this train's journey. Reason      
1547 The train now at... Conjoining      
1723 Blackpool Pleasure Beach Destination     BPB
1534 Please note that this train Conjoining      
2251 Fearn Destination     FRN
0243 Brunstane Destination     BSU
2168 Roche Destination     ROC
0961 An obstruction on the track Reason      
2311 Stockport Destination     SPT
1931 Banavie Destination     BNV
0969 Attempted theft of overhead line electrification equipment Reason      
2039 Gourock Destination     GRK
0349 34 Time      
0489 will not arrive until Conjoining      
0880 A shortage of train crew Reason      
1263 Wakefield Westgate Destination     WKF
1483 Glenrothes with Thornton Destination     GLT
0766 ...a coach becoming uncoupled on this train. Reason      
0471 The Cathedrals Express steam service from Special train      
0520 Please join the middle eleven coaches of this train Passenger information      
0530 Please join the rear eight coaches of this train Passenger information      
1691 This service has been reported to be full and standing Passenger information      
1301 Wilmslow Destination     WML
1811 Doncaster Destination     DON
1646 [4 rising chimes] Non-vocal played before announcements over tannoy    
1814 For the...... Conjoining      
1525 ...waiting for trains at this station. Passenger information      
1274 Bath Spa Destination     BTH
0561 Cycles are not permitted on this train Passenger information      
1884 Airbles Destination     AIR
1910 Lancaster Destination     LAN
1700 We are sorry to announce that the Apology      
0460 London Overground service to Train operating company      
1001 Expected industrial action yesterday Reason What the Time Travel??    
0721 Falkirk Grahamston Destination     FKG
1479 Dunkeld & Birnam Destination     DKD
0803 A fire near the railway involving gas cylinders Reason      
1390 nine Number      
2078 Lochwinnoch Destination     LHW
1252 Stoke-on-Trent Destination     SOT
0818 A gas leak near the railway yesterday Reason      
1126 This train not stopping in the correct position at a station Reason      
2019 Padgate Destination     PDG