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
1159 Waiting for a part of the train to be attached Reason valid reason I think    
1564 The next train at platform Passenger information      
0660 Bridlington Destination     BDT
1781 Cardiff Queen Street Destination     CDQ
1449 Shotts Destination     SHS
0372 52 Time      
1016 Forecasted severe weather Weather      
2199 Whifflet Destination     WFF
2166 Dalreoch Destination     DLR
1339 We are sorry to announce that Apology      
1980 9, 10 Number combo      
1589 Charing Cross Destination     CHC
0322 09 Time oh-nine    
1381 four Number      
1448 Rosyth Destination     ROS
0840 Inverkeithing Destination     INK
2284 Kinbrace Destination     KBC
0928 A train hitting an obstruction on the line Reason      
1224 Penzance Destination     PNZ
0045 platform 8 for the Platform information "the" (/ðə/)    
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    
1838 Sandwell and Dudley Destination     SAD
1429 is delayed by approximately... Conjoining      
1522 Due to a security alert at this station... Passenger information      
0587 Appleby Destination     APP
1476 Dalwhinnie Destination     DLW
0584 Annan Destination     ANN
1999 Bellgrove Destination     BLG
2146 Retford Destination     RET
2431 Wick Destination     WCK
2153 Cathcart Destination     CCT
0327 14 Time      
2126 Springburn Destination     SPR
1442 Charing Cross Destination     CHC
0768 ...a coach becoming uncoupled on this train earlier today. Reason      
1680 Bamber Bridge Destination     BMB
2030 Fort Matilda Destination     FTM
1993 Attadale Destination     ATT
1185 London Moorgate Destination     MOG
0775 ...a derailed train. Reason      
0122 Strathclyde metro service to Strathclyde metro      
1464 Camelon Destination     CMO
0723 ...will not call at... Conjoining mid    
0963 An obstruction on the track earlier today Reason      
1075 The communication alarm being activated on a train Reason      
0556 If you are travelling to these stations, please wait on the concourse Passenger information      
1909 Ladybank Destination     LDY
1700 We are sorry to announce that the Apology      
0672 Manchester Oxford Road Destination     MCO
0644 Bradford Forster Square Destination     BDQ
1862 Argyle Street Destination     AGS
1813 And this train will not call at Passenger information      
0286 Shawfair Destination     SFI
1197 Maypole Destination     MAY
0982 Cattle on the railway earlier today Reason      
0978 Attempted theft of third rail electrification equipment Reason      
1911 For the Conjoining      
0630 Birmingham International Destination     BHI
2132 Tyndrum Lower Destination     TYL
1725 The train now approaching Passenger information      
0413 Newton (Lanarkshire) Destination     NTN
0319 06 Time oh-six    
1082 The fire alarm sounding at a station Reason      
1957 1, 2, 3 Number combo      
2274 IBM Destination     (IBM)
1230 Portlethen Destination     PLN
2073 Achnashellach Destination     ACH
2428 Wishaw Destination     WSH
1319 sixteen Number      
1049 Overcrowding because of an earlier cancellation Reason If it's cancelled for this reason, the overcrowding will increase exponentially    
0929 A train hitting an obstruction on the line earlier on this train's journey Reason      
2074 Loch Eil Outward Bound Destination     LHE
0633 Blackburn Destination   BBN
2229 Busby Destination     BUS
0179 This train is formed of 3 coaches Train formation      
0359 43 Time      
1177 Please use all available doors when getting on the train. Passenger information      
1229 Poole Destination     POO
0501 Please join the front seven coaches of this train Passenger information      
0125 Should join the rear 10 coaches Passenger information      
0573 East Midlands Train operating company      
1988 Ardrossan Harbour Destination     ADS
1866 Beasdale Destination     BSL
2163 Crookston Destination     CKT
0748 ...a broken down train, earlier today. Reason      
0759 ...a bus colliding with a bridge, earlier today. Reason      
0105 Will be in 40 minutes Time      
0701 Darlington Destination end   DAR
0615 Belle Vue Destination     BLV
1122 This train hitting an obstruction on the line, earlier today Reason      
0290 Galashiels Destination     GAL
0049 The display information system at this station Operational      
0356 40 Time      
0686 Carnoustie Destination neutral inflex   CAN
2300 Lochailort Destination     LCL
1011 Flooding Reason      
1912 Leamington Spa Destination     LMS
1352 forty-eight Number      
0738 ...a bicycle on the track... Reason      
1108 Theft of signalling cables Reason