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
1225 Perth Destination     PTH
0807 A fire near the railway suspected to involve gas cylinders earlier today Reason      
0573 East Midlands Train operating company      
1137 Trespassers on the railway earlier today Reason      
0387 Signalling difficulties Reason      
1949 Markinch Destination     MNC
1309 06 Time oh-six    
0696 Church and Oswaldtwistle Destination     CTW
1208 Newquay Destination     NQY
0809 A fire next to the track Reason      
1480 Edinburgh Waverley Destination     EDB
2096 Paisley Gilmour Street Destination     PYG
0177 This train is formed of 1 coach only Train formation      
1591 Polmont Destination     PMT
1472 Uddingston Destination     UDD
0777 ...a fault occurring when attaching a part of a train. Reason      
0217 First Great Western service from Train operating company      
0248 11 Time      
2017 Drumry Destination     DMY
0618 ...an incident on the line... Reason mid (suffixed with 'at <station>'/'between <x> and <y>'/similar)    
0846 A river flooding the railway Reason      
1093 The train conductor being taken ill Reason      
0765 ...a coach becoming uncoupled on a train earlier today Reason      
0515 Please join the middle six coaches of this train Passenger information      
1862 Argyle Street Destination     AGS
1413 Hartwood Destination     HTW
2216 Ardlui Destination     AUI
0740 ...a bicycle on the track earlier today. Reason      
2186 Patterton Destination     PTT
0341 26 Time      
1633 Golf Street Destination     GOF
0562 First class accommodation is available Passenger information      
0445 Stratford High Street Destination DLR    
0194 Stand well away from the edge of platform 5 Safety      
1566 Prudhoe Destination     PRU
2426 Whifflet Destination     WFF
0364 Corby Destination Low-pitch ending   COR
0252 Greenfaulds Destination     GRL
1043 Overcrowding because an earlier train had fewer coaches than normal Reason      
2313 Mount Florida Destination     MFL
0798 ...a fault with the signalling system. Reason      
0332 18 Time      
1712 Billingham Destination     BIL
2289 Kyle of Lochalsh Destination     KYL
1537 Penrith North Lakes Destination     PNR
1599 Stirling Destination     STG
2236 Crosshill Destination     COI
1881 Newark Destination      
1636 West Calder Destination     WCL
1767 Here is a special announcement Passenger information      
1928 Ardgay Destination     ARD
1666 Goostrey Destination     GTR
0730 Haymarket Destination     HYM
1787 Carstairs Destination     CRS
0270 13 Time      
0887 A shortage of trains following damage by snow and ice Reason      
1002 Failure of the electricity supply Reason      
0168 Will be in approximately 15 minutes Time      
1062 Severe weather Weather      
0661 Brighton Destination     BTN
1542 Keith Destination     KEH
0577 Overhead electric line problems Reason      
1467 Carnoustie Destination mid inflex same as 1785? - sounds like a repeated audio file   CAN
1460 Breich Destination     BRC
1778 service from Conjoining      
0557 If you are travelling to these stations, please wait on the platform Passenger information      
2029 Forsinard Destination     FRS
1320 seventeen Number      
0349 34 Time      
0358 42 Time      
2105 Portlethen Destination     PLN
1860 Anderston Destination     AND
1575 Kirknewton Destination     KKN
1203 Motherwell Destination     MTH
0019 The next train at platform 8 is the Platform information "the" (/ðə/)    
2357 Wemyss Bay Destination     WMS
1490 Addiewell Destination     ADW
0284 Alloa Destination     ALO
0480 The Watercress Line Heritage Railway      
0964 An operational incident Reason      
1376 The next service to Passenger information upwards inflection    
1901 Kennishead Destination     KNS
2338 Roy Bridge Destination     RYV
0600 Auchinleck Destination     AUK
1350 forty-six Number      
2262 Gourock Destination     GRK
0491 please join the front Conjoining      
0853 A road accident near the railway earlier today Reason      
1802 will now depart at Conjoining      
0589 Arbroath Destination     ARB
1686 Barnsley Destination     BNY
1023 Heavy snow over recent days Weather      
0835 A person being hit by a train earlier Reason    
1077 The electricity being switched off for safety reasons Reason      
1114 Thick fog Weather      
0605 Banbury Destination     BAN
0700 Cupar Destination end   CUP
0426 Shawfair Destination     SFI
1567 Johnstone Destination     JHN
1757 Virgin Trains Train operating company