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
1799 Coventry Destination     COV
0067 delayed Conjoining      
1543 Elgin Destination     ELG
1571 Wigan North Western Destination     WGN
1988 Ardrossan Harbour Destination     ADS
1120 This train hitting an obstruction on the line, earlier in its journey Reason      
0630 Birmingham International Destination     BHI
2124 Preston Destination     PRE
1841 St Germans Destination     SGM
1723 Blackpool Pleasure Beach Destination     BPB
2437 Kilpatrick Destination     KPT
1387 seven Number      
0532 Please join the rear ten coaches of this train Passenger information      
1893 Huntingdon Destination     HUN
0112 Is delayed by approximately 15 minutes Time      
0133 5 minutes Time      
1547 The train now at... Conjoining      
0012 The next train at platform 1 is the Platform information "the" (/ðə/)    
2141 Bishopton Destination     BPT
2206 Dalwhinnie Destination     DLW
0899 a speed restriction because of high winds earlier on this train's journey Reason      
0776 ...a derailment within the depot. Reason      
0936 A train not stopping in the correct position at a station earlier in its journey Reason      
0801 A fire at a station Reason      
1636 West Calder Destination     WCL
1218 Oxenholme Lake District Destination     OXN
2156 Clarkston Destination     CKS
0591 Armathwaite Destination     AWT
1621 Uphall Destination     UHA
0323 10 Time      
1283 Hexham Destination     HEX
0522 Please join the rear coach of this train Passenger information      
1834 South West Trains Train operating company Low-pitched ending    
1305 02 Time oh-two    
0047 Please ignore the following announcements Operational      
1180 Liverpool Lime Street Destination     LIV
1558 Corbridge Destination     CRB
2030 Fort Matilda Destination     FTM
2431 Wick Destination     WCK
1409 Blaydon Destination     BLO
1324 twenty-one Number      
0641 ...cancellation of the incoming service... Reason mid (suffixed with 'at <station>'/'between <x> and <y>'/similar)    
0552 If you are travelling to these stations, please wait on the concourse Passenger information      
1079 The electricity being switched off for safety reasons earlier today Reason      
0631 Birmingham New Street Destination     BHM
0939 A train's automatic braking system being activated earlier in its journey Reason      
0665 Broad Green Destination     BGE
0619 Bentham Destination     BEN
1504 please note that this train is in reverse formation today Passenger information      
1389 The next bus service Passenger information      
2171 Duke Street Destination     DST
1291 sixteen Number      
1488 we apologise for the inconvenience caused Apology      
2078 Lochwinnoch Destination     LHW
1915 Leuchars Destination     LEU
0404 Loch Awe Destination     LHA
1618 Cowdenbeath Destination     COW
0565 and can be found in the front and rear of the train Passenger information      
0935 A train not stopping in the correct position at a station Reason      
0553 If you are travelling to these stations, please wait on the platform Passenger information      
0438 Edinburgh International Destination Proposed    
0251 Gilshochill Destination     GSC
2195 Sanquhar Destination     SQH
0686 Carnoustie Destination neutral inflex   CAN
1234 Preston Destination     PRE
1196 Mauldeth Road Destination     MAU
0904 a speed restriction because of snow and ice Reason      
1070 Signalling staff being taken ill earlier on this train's journey Reason      
2191 Taynuilt Destination     TAY
0825 A lorry colliding with a bridge earlier today Reason      
1327 twenty-four Number      
1112 Theft of third rail electrical equipment, earlier today Reason      
1877 Bridgeton Destination     BDG
2284 Kinbrace Destination     KBC
1457 Bishopbriggs Destination     BBG
1184 London Marylebone Destination     MYB
0318 via Conjoining vee-ah    
0705 Conon Bridge Destination     CBD
2058 Kinbrace Destination     KBC
1395 ten Number      
1699 Ben Rhydding Destination     BEY
2112 Rothesay Destination For ferry from Wemyss Bay    
0049 The display information system at this station Operational      
0386 Platform D Platform ID      
1301 Wilmslow Destination     WML
2189 Strathcarron Destination     STC
1795 Chinley Destination     CLY
1383 A security alert Reason upward inflection    
1451 South Gyle Destination     SGL
2289 Kyle of Lochalsh Destination     KYL
1563 Haydon Bridge Destination     HDB
2372 Carluke Destination Same as 2371 (above)   CLU
0160 Thank you Conjoining      
2043 Hairmyres Destination     HMY
2007 Corrour Destination     CRR
1833 Edinburgh Destination      
1745 Bridgwater Destination     BWT
0222 Gartcosh Destination     GRH
0076 The train now approaching platform 2 is the Platform information "the" (/ði/)    
0107 Will be in 50 minutes Time