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
0326 13 Time      
0655 Bridgend Destination     BGN
1900 Sandwell and Dudley Destination     SAD
1279 six Number      
0890 a speed restriction because of fog earlier on this train's journey Reason      
0838 A problem currently under investigation Reason      
0877 A shortage of on-train staff Reason      
0192 Stand well away from the edge of platform 3 Safety      
1349 forty-five Number      
2086 Morar Destination     MRR
2156 Clarkston Destination     CKS
1261 Troon Destination is this a station or the scottish version of train   TRN
0948 A wartime bomb near the railway yesterday Reason      
0645 Bradford Interchange Destination     BDI
1119 This train hitting an obstruction on the line Reason      
1786 Milton Keynes Central Destination     MKC
0542 Megatrain accomodation can be found at the rear of the train Passenger information      
1045 Overcrowding because of a football match Reason      
2101 Pollokshields East Destination     PLE
0051 Please ignore any information currently displayed Operational      
1233 Priesthill and Darnley Destination     PTL
0688 Cheltenham Spa Destination     CNM
0568 You must ensure that you have a valid first class ticket Passenger information      
1466 Carfin Destination     CDF
1275 two Number      
1601 Balmossie Destination     BSI
0602 Baildon Destination     BLD
0976 Attempted theft of signalling cables earlier today Reason      
2386 Croftfoot Destination     CFF
1030 Ice preventing trains getting electricity from the third rail Weather hmmmmmmm    
2211 Sheffield Destination     SHF
0800 ...a fault with the signalling system earlier today. Reason      
1196 Mauldeth Road Destination     MAU
0080 The train now approaching platform 6 is the Platform information "the" (/ði/)    
1295 Stafford Destination     STA
1902 St Budeaux Ferry Road Destination     SBF
1170 Leicester Destination     LEI
1901 Kennishead Destination     KNS
0625 Beverley Destination     BEV
2051 Inverkip Destination     INP
1359 fifty-five Number      
1710 and cross to Passenger information      
1042 Overcrowding as this train has fewer coaches than normal Reason      
1319 sixteen Number      
2111 Renton Destination     RTN
0099 Will be in 10 minutes Time      
1603 Bellshill Destination     BLH
0415 Ardrossan South Beach Destination     ASB
1232 Prestwick Town Destination     PTW
1384 A security alert Reason downward inflection    
0048 Thank you Conjoining      
0698 Crewe Destination end   CRE
1185 London Moorgate Destination     MOG
1076 The communication alarm being activated on this train Reason      
1798 Church and Oswaldtwistle Destination     CTW
0131 This service will arrive in approximately 12 minutes Time      
1150 Vandalism of railway equipment Reason      
0483 The Spa Valley Railway Heritage Railway      
1909 Ladybank Destination     LDY
0266 Newton (Lanarkshire) Destination     NTN
1209 Newton Abbot Destination     NTA
1088 The fire alarm sounding in the signalling centre Reason      
0013 The next train at platform 2 is the Platform information "the" (/ðə/)    
1540 Insch Destination     INS
0959 An object being caught on the overhead electric wires earlier on this train's journey Reason      
0107 Will be in 50 minutes Time      
0579 Accrington Destination     ACR
0423 Larkhall Destination     LRH
1179 Liskeard Destination     LSK
1760 Brockenhurst Destination     BCU
1241 Sanquhar Destination     SQH
1627 Dunkeld & Birnam Destination     DKD
1995 Oxenholme Lake District Destination     OXN
0985 Checking reports of an obstruction on the line earlier today Reason      
0977 Attempted theft of signalling cables yesterday Reason      
2055 Kilcreggan Destination For ferry from Gourock    
0668 ...signalling difficulties... Reason mid    
2048 Hillfoot Destination     HLF
1592 Prestonpans Destination     PST
0373 53 Time      
0881 A shortage of train drivers Reason      
2400 Fort William Destination     FTW
1532 a staff shortage Reason      
2251 Fearn Destination     FRN
1665 Armathwaite Destination     AWT
1426 Kingsknowe Destination     KGE
0520 Please join the middle eleven coaches of this train Passenger information      
1464 Camelon Destination     CMO
0054 will now depart from platform 1 Platform information      
1515 South West Trains Train operating company      
2208 Kilpatrick Destination     KPT
0885 A shortage of trains because of extra safety inspections Reason      
1284 ten Number      
2182 Hyndland Destination     HYN
1737 Bradford Forster Square Destination     BDQ
0952 The ambulance service dealing with an incident near the railway earlier today Reason      
2080 Plymouth Destination     PLY
1877 Bridgeton Destination     BDG
0392 Brunstane Destination Low-pitch ending   BSU
0634 Blackpool North Destination     BPN