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
1749 Brighouse Destination     BGH
2132 Tyndrum Lower Destination     TYL
0675 Burton-on-Trent Destination     BUT
1621 Uphall Destination     UHA
0396 Dunoon Destination Ferry    
1434 Livingston South Destination     LVG
1655 Rugby Destination     RUG
1775 Camborne Destination     CBN
0142 Will arrive in approximately 10 minutes Time      
0140 Will arrive in approximately 4 minutes Time      
2040 Greenfaulds Destination     GRL
1232 Prestwick Town Destination     PTW
2023 Paignton Destination     PGN
1533 has been cancelled Conjoining      
2371 Cardross Destination     CDR
0703 Dawlish Warren Destination end   DWW
1194 Market Harborough Destination     MHR
2423 Wigan Wallgate Destination     WGW
2413 Rogart Destination     ROG
1574 Kingsknowe Destination     KGE
1843 should ask the conductor on the train to arrange for the train to stop Request stop      
1330 twenty-seven Number      
1327 twenty-four Number      
2259 Glengarnock Destination     GLG
1798 Church and Oswaldtwistle Destination     CTW
0975 Attempted theft of signalling cables Reason      
0027 The next train at platform 8 is the Platform information "the" (/ði/)    
0192 Stand well away from the edge of platform 3 Safety      
0170 Will be in approximately 25 minutes Time      
2224 Balloch Destination     BCH
0105 Will be in 40 minutes Time      
1545 Nairn Destination     NRN
1718 Birmingham New Street Destination     BHM
0369 49 Time      
2438 Kirknewton Destination     KKN
2059 King's Park Destination     KGP
0913 a speed restriction over a bridge Reason      
0977 Attempted theft of signalling cables yesterday Reason      
1942 Bridge of Orchy Destination     BRO
1360 fifty-six Number      
0404 Loch Awe Destination     LHA
1477 Drem Destination     DRM
1189 Manchester Airport Destination     MIA
1842 is a request stop, and passengers for this station Request stop      
1324 twenty-one Number      
0099 Will be in 10 minutes Time      
1149 Leamington Spa Destination     LMS
2154 Chapel-en-le-Frith Destination     CEF
1836 Falkirk High Destination     FKK
0776 ...a derailment within the depot. Reason      
1296 Starcross Destination     SCS
2083 Maxwell Park Destination     MAX
1305 02 Time oh-two    
2051 Inverkip Destination     INP
0617 Ben Rhydding Destination     BEY
1274 Bath Spa Destination     BTH
2176 Georgemas Destination     GGJ
0636 Blackpool South Destination     BPS
0361 45 Time      
0188 This train is formed of 12 coaches Train formation      
2319 Paisley Canal Destination     PCN
1285 eleven Number      
0033 ScotRail service to Train operating company      
0789 ...a fault with the electric third rail. Reason Why do they need this...    
1347 forty-three Number      
0208 Attention please! Please leave the station immediately. Safety Male voice (quieter)    
0423 Larkhall Destination     LRH
0846 A river flooding the railway Reason      
0197 Stand well away from the edge of platform 8 Safety      
0637 Edinburgh Park Destination     EDP
1143 Urgent repairs to the railway earlier today Reason      
0315 Westenhanger Racecourse Destination Station closed in 1960s!   WHA
1673 Kirton Lindsey Destination     KTL
1923 London Moorgate Destination     MOG
1275 two Number      
1549 ...is the delayed... Conjoining      
1208 Newquay Destination     NQY
2333 Queens Park Destination     QPK
0302 03 Time oh-three    
1633 Golf Street Destination     GOF
1298 Customers for Conjoining      
2245 Dumbreck Destination     DUM
0656 ...Grand Central Train operating company end    
1773 Burton-on-Trent Destination     BUT
0869 A safety inspection on a train Reason      
1833 Edinburgh Destination      
1828 Dockyard Destination     DOC
1816 Dumfries Destination     DMF
1372 Forres Destination     FOR
1403 eighteen Number      
0871 A safety inspection on this train Reason      
0991 Damage to the overhead electric wires earlier on this train's journey Reason      
0098 Will be in 5 minutes Time      
0274 14 Time      
1932 Bearsden Destination     BRN
0833 A passenger being taken ill on this train earlier in its journey Reason      
0924 a supermarket trolley on the track earlier today Reason      
1918 Liverpool Lime Street Destination     LIV
2231 Coatbridge Central Destination     CBC
2396 Duke Street Destination     DST