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
2356 Tyndrum Lower Destination     TYL
0743 ...a bridge being damaged. Reason      
1743 adverse weather conditions Reason      
0296 Abbey Road Destination DLR    
1426 Kingsknowe Destination     KGE
0128 This service will be in approximately 5 minutes Time      
2395 Drumchapel Destination     DMC
1273 one Number      
0933 Kidderminster Destination     KID
0569 Please wait on the concourse and listen for further announcements Passenger information      
2240 Dalmuir Destination     DMR
0617 Ben Rhydding Destination     BEY
0694 Chorley Destination     CRL
1682 Banbury Destination     BAN
1356 fifty-two Number      
1774 Bury St. Edmunds Destination     BSE
0857 A road vehicle blocking the railway earlier today Reason      
1463 Cambuslang Destination     CBL
0189 hundred hours Time      
1813 And this train will not call at Passenger information      
2005 Coatbridge Sunnyside Destination     CBS
0638 Blackpool Destination      
0811 A fire on a train Reason      
1302 Southampton Airport Parkway Destination     SOA
2152 Kilwinning Destination     KWN
0457 The Grand Central service from Train operating company      
1649 Adlington Destination     ADC
0630 Birmingham International Destination     BHI
0175 Will be in approximately 50 minutes Time      
2415 Strathcarron Destination     STC
0249 Exhibition Centre Destination     EXG
2227 Bellgrove Destination     BLG
0772 ...a collision at a level crossing yesterday. Reason      
0423 Larkhall Destination     LRH
1254 Stonehaven Destination     STN
0265 Glasgow Queen Street Low Level Destination     GLQ
1062 Severe weather Weather      
1115 Thick fog, earlier in this train's journey Weather      
0236 06 Time oh-six    
0890 a speed restriction because of fog earlier on this train's journey Reason      
1784 Howwood Destination Not to be confused with How Wood (HWW)   HOZ
2157 Clydebank Destination     CYK
0783 ...a fault on this train which is now fixed. Reason      
1105 Theft of railway equipment Reason      
2029 Forsinard Destination     FRS
0427 Eskbank Destination     EKB
1662 Appley Bridge Destination     APB
2018 Duirinish Destination     DRN
0599 Kirton Lindsey Destination     KTL
0205 Southeastern Train operating company      
2013 Dalmarnock Destination     DAK
0872 A safety inspection on this train earlier in its journey Reason      
0654 ...adverse weather conditions... Weather mid    
1940 Bowling Destination     BWG
0513 Please join the middle four coaches of this train Passenger information      
0593 Arram Destination     ARR
2140 Barnhill Destination     BNL
0388 First Capital Connect Train operating company      
0150 Will arrive in approximately 50 minutes Time      
0843 A problem with the station lighting Reason      
0656 ...Grand Central Train operating company end    
2310 Morar Destination     MRR
0285 19 Time      
1348 forty-four Number      
0361 45 Time      
1408 Bardon Mill Destination     BLL
1926 Lostwithiel Destination     LOS
1923 London Moorgate Destination     MOG
1453 Aviemore Destination     AVM
1303 o'clock Time      
2061 Kirkwood Destination     KWD
1801 this cancellation Conjoining      
1335 thirty-two Number      
0122 Strathclyde metro service to Strathclyde metro      
1121 This train hitting an obstruction on the line, earlier on this train's journey Reason      
1520 A further announcement will be made when this... Passenger information      
1292 seventeen Number      
0391 Beauly Destination Low-pitch ending   BEL
2134 Wemyss Bay Destination     WMS
1559 Dunston Destination     DOT
0067 delayed Conjoining      
0882 A shortage of train guards Reason      
0861 A road vehicle colliding with level crossing barriers Reason      
1786 Milton Keynes Central Destination     MKC
0605 Banbury Destination     BAN
0480 The Watercress Line Heritage Railway      
2114 Prestwick Town Destination     PTW
2283 Kilwinning Destination     KWN
0499 Please join the front five coaches of this train Passenger information      
1262 Truro Destination     TRU
1373 Nairn Destination     NRN
2326 Pollokshields West Destination     PLW
1368 Insch Destination     INS
1656 Cheadle Hulme Destination     CHU
1824 Altnabreac Destination     ABC
2066 Langbank Destination     LGB
0619 Bentham Destination     BEN
1507 standard class accommodation is towards the front of this train Passenger information      
2034 Garscadden Destination     GRS
1451 South Gyle Destination     SGL