scotrail

Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette

Custom SQL query returning 100 rows (show)

This data as json, CSV

FileTranscriptionCategorymp3NotesTimestampNRE_ID
2070 Peterborough Destination     PBO
0390 Barry Links Destination Low-pitch ending   BYL
1880 This train is ready to leave Passenger information      
0825 A lorry colliding with a bridge earlier today Reason      
0631 Birmingham New Street Destination     BHM
1097 The train guard being taken ill Reason      
0616 Bempton Destination     BEM
0275 15 Time      
1752 Fast train approaching Safety      
0366 St. Pancras International Destination Low-pitch ending   STP
0666 Brockenhurst Destination     BCU
1586 Newtonmore Destination     NWR
1985 Anniesland Destination     ANL
1915 Leuchars Destination     LEU
1289 fourteen Number      
0870 A safety inspection on a train earlier today Reason      
2304 Loch Awe Destination     LHA
0213 Southern Train operating company Low-pitch ending    
0889 a speed restriction because of fog Reason      
0132 This service will be in approximately Time      
0383 Platform A Platform ID      
2289 Kyle of Lochalsh Destination     KYL
0114 Is delayed by approximately 25 minutes Time      
1427 Kirknewton Destination     KKN
1407 twenty Number      
1625 Drem Destination     DRM
0691 Chesterfield Destination     CHD
2196 Upper Tyndrum Destination     UTY
1525 ...waiting for trains at this station. Passenger information      
0918 a speed restriction over an embankment earlier today Reason      
0785 ...a fault with a swing bridge over a river earlier today. Reason      
0101 Will be in 20 minutes Time      
0848 A road accident at a level crossing Reason      
1323 twenty Number      
0064 This train is formed of 12 coaches Passenger information      
1563 Haydon Bridge Destination     HDB
1874 Bowling Destination     BWG
2307 Maxwell Park Destination     MAX
0122 Strathclyde metro service to Strathclyde metro      
0466 The Cathedrals Express Special train      
0876 A security alert on this train Reason      
1868 Haymarket Destination     HYM
2323 Plockton Destination     PLK
1897 Inverkeithing Destination     INK
1925 London St Pancras Destination     STP
1633 Golf Street Destination     GOF
1882 Newton Destination     NTN
1335 thirty-two Number      
0663 Bristol Parkway Destination     BPW
1900 Sandwell and Dudley Destination     SAD
0861 A road vehicle colliding with level crossing barriers Reason      
1277 four Number      
1898 Inverness Destination     INV
0172 Will be in approximately 35 minutes Time      
1631 Gleneagles Destination     GLE
0662 Brighouse Destination     BGH
1595 Rosyth Destination     ROS
0649 First Capital Connect service to... Train operating company start    
1251 Stranraer Destination     STR
0693 Chinley Destination     CLY
1671 Mechanical problems Reason      
1429 is delayed by approximately... Conjoining      
0803 A fire near the railway involving gas cylinders Reason      
0527 Please join the rear five coaches of this train Passenger information      
0197 Stand well away from the edge of platform 8 Safety      
0792 ...a fault with the on-train signalling system. Reason      
0941 A tree blocking the railway Reason      
1962 Platform 1 for the Platform information      
0140 Will arrive in approximately 4 minutes Time      
1160 Leeds Destination     LDS
2259 Glengarnock Destination     GLG
0660 Bridlington Destination     BDT
1293 Southampton Central Destination     SOU
1364 Staff shortages Reason      
2290 Lairg Destination     LRG
2393 Truro Destination     TRU
0391 Beauly Destination Low-pitch ending   BEL
0540 Megatrain accomodation can be found at the front of the train Passenger information      
0200 Southern service from Train operating company      
0492 coach Conjoining      
1058 The police dealing with an incident near the railway earlier today Reason      
1215 Nottingham Destination     NOT
0244 Central Destination      
0954 An earlier landslip Reason      
1388 eight Number      
2313 Mount Florida Destination     MFL
1031 Industrial action Reason      
0134 10 minutes Time      
1111 Theft of third rail electrical equipment Reason      
1422 Wetheral Destination     WRL
2253 Fort Matilda Destination     FTM
2381 Clydebank Destination     CYK
2190 Tain Destination     TAI
1156 Vandalism on this train Reason      
0482 The Spa Valley Railway Heritage Railway Sussex has been taken over by Scotland    
0719 Exeter St Davids Destination     EXD
2242 Drumgelloch Destination     DRU
0079 The train now approaching platform 5 is the Platform information "the" (/ði/)    
2281 Stewarton Destination     STT
1019 Heavy rain flooding the railway earlier today Weather