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
0459 London Overground Train operating company      
1813 And this train will not call at Passenger information      
1511 Standard class accommodation is towards the rear Passenger information      
2371 Cardross Destination     CDR
1225 Perth Destination     PTH
0090 platform 5 for the delayed Platform information      
2216 Ardlui Destination     AUI
1789 Watford Junction Destination     WFJ
1053 Passengers causing a disturbance on a train Reason      
1031 Industrial action Reason      
0953 The ambulance service dealing with an incident near the railway yesterday Reason      
0195 Stand well away from the edge of platform 6 Safety      
1921 London King's Cross Destination     KGX
0724 Girvan Destination     GIR
0320 07 Time oh-seven    
1773 Burton-on-Trent Destination     BUT
2224 Balloch Destination     BCH
0466 The Cathedrals Express Special train      
0424 Chatelherault Destination     CTE
1864 Banavie Destination     BNV
0361 45 Time      
0303 Edinburgh International Destination Proposed    
2192 Thorntonhall Destination     THT
0237 07 Time oh-seven    
1708 Bescar Lane Destination     BES
2092 Neilston Destination     NEI
0082 The train now approaching platform 8 is the Platform information "the" (/ði/)    
0133 5 minutes Time      
1036 Lightning damaging equipment Weather      
1284 ten Number      
1798 Church and Oswaldtwistle Destination     CTW
1779 Cardiff Bute Road Destination Renamed in 1994   CDB
0675 Burton-on-Trent Destination     BUT
1470 Cowdenbeath Destination     COW
2118 Scotstounhill Destination     SCH
1089 The fire alarm sounding in the signalling centre earlier on this train's journey Reason      
1409 Blaydon Destination     BLO
1633 Golf Street Destination     GOF
0766 ...a coach becoming uncoupled on this train. Reason      
2269 Hawkhead Destination     HKH
2189 Strathcarron Destination     STC
0537 Middle Passenger information      
1918 Liverpool Lime Street Destination     LIV
1191 Manchester Piccadilly Destination     MAN
1303 o'clock Time      
2126 Springburn Destination     SPR
0707 Stow... Destination     SOI
0708 Virgin Trains East Coast service to... Train operating company      
0327 14 Time      
1127 This train not stopping in the correct position at a station, earlier in its journey Reason      
0944 Kilmarnock Destination Kilmarnock is a valid reason for a rail service issue   KMK
0069 The train now approaching platform 2 Platform information Nice    
1947 Hamilton West Destination     HNW
1423 Wigan North Western Destination     WGN
2236 Crosshill Destination     COI
0412 Glasgow Queen Street Low Level Destination     GLQ
1733 Bodmin Parkway Destination     BOD
2100 Pollokshaws East Destination     PWE
1082 The fire alarm sounding at a station Reason      
0546 and can be found in the middle of the train Passenger information      
0949 A wartime bomb which has now been made safe Reason thank god    
0063 This train is formed of 11 coaches Passenger information      
2334 Rannoch Destination     RAN
2261 Glenfinnan Destination     GLF
1881 Newark Destination      
1151 Vandalism of railway equipment earlier today Reason      
1994 Baillieston Destination     BIO
1081 The emergency services dealing with an incident earlier today Reason      
2015 Drumfrochar Destination     DFR
0048 Thank you Conjoining      
0531 Please join the rear nine coaches of this train Passenger information      
1927 Anderston Destination     AND
0864 A road vehicle damaging track at a level crossing Reason      
1778 service from Conjoining      
1161 Kintore Destination     KTR
1816 Dumfries Destination     DMF
1141 Urgent repairs to a tunnel earlier today Reason      
0735 Stow Destination     SOI
0591 Armathwaite Destination     AWT
1179 Liskeard Destination     LSK
1412 Dunston Destination     DOT
2375 Kilwinning Destination     KWN
1101 The train manager being taken ill Reason      
1184 London Marylebone Destination     MYB
2283 Kilwinning Destination     KWN
0383 Platform A Platform ID      
0346 31 Time      
1929 Argyle Street Destination     AGS
0128 This service will be in approximately 5 minutes Time      
2152 Kilwinning Destination     KWN
0365 46 Time      
1964 Platform 3 for the Platform information      
1706 Berwick Destination     BRK
1285 eleven Number      
2368 Breich Destination     BRC
1842 is a request stop, and passengers for this station Request stop      
1375 has been cancelled Passenger information      
1525 ...waiting for trains at this station. Passenger information      
1743 adverse weather conditions Reason      
2354 Thornliebank Destination     THB