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
0811 A fire on a train Reason      
0843 A problem with the station lighting Reason      
1250 Stevenage Destination     SVG
2170 Drumchapel Destination     DMC
0029 will be in Conjoining      
2110 Rannoch Destination     RAN
0163 Will be in approximately 2 minutes Time      
0068 The train now approaching platform 1 Platform information      
0352 36 Time      
0792 ...a fault with the on-train signalling system. Reason      
1905 Kilmarnock Destination     KMK
1164 two Number      
0833 A passenger being taken ill on this train earlier in its journey Reason      
1137 Trespassers on the railway earlier today Reason      
2045 Helensburgh Central Destination     HLC
1972 7, 8 Number combo      
0135 7 minutes Time      
2193 Thurso Destination     THS
1220 Paddington Destination     PAD
1945 Manchester Victoria Destination     MCV
0241 Barry Links Destination     BYL
1618 Cowdenbeath Destination     COW
0767 ...a coach becoming uncoupled on this train earlier in its journey. Reason      
2035 Garve Destination     GVE
0143 Will arrive in approximately 15 minutes Time      
2135 West Kilbride Destination     WKB
1552 ...is the delayed... Conjoining      
1997 Barassie Destination     BSS
2103 Port Glasgow Destination     PTG
0037 Strathclyde metro service from Strathclyde metro      
2429 Windermere Destination     WDM
1407 twenty Number      
2059 King's Park Destination     KGP
1944 Brodick Destination Ferry destination from Adrossan    
0585 A signalling apparatus failure Reason      
1529 I am sorry to announce that the Apology      
1658 A signalling apparatus failure Reason      
2212 Should change at Passenger information      
0847 A river flooding the railway earlier today Reason      
0648 ...First Capital Connect. Train operating company end    
1793 Chesterfield Destination     CHD
2156 Clarkston Destination     CKS
1230 Portlethen Destination     PLN
2065 Lanark Destination     LNK
0954 An earlier landslip Reason      
2230 Carmyle Destination     CML
2014 Dalmuir Destination     DMR
1675 Ayr Destination     AYR
0569 Please wait on the concourse and listen for further announcements Passenger information      
1702 Bentham Destination     BEN
0684 Cark Destination     CAK
1915 Leuchars Destination     LEU
1364 Staff shortages Reason      
0096 ScotRail service from Train operating company      
1941 Manchester Piccadilly Destination     MAN
1252 Stoke-on-Trent Destination     SOT
1981 Newton-on-Ayr Destination     NOA
1845 calling at Conjoining      
0948 A wartime bomb near the railway yesterday Reason      
1517 This train is not for public use Passenger information      
2384 Corkerhill Destination     CKH
1579 Lenzie Destination     LNZ
0332 18 Time      
1232 Prestwick Town Destination     PTW
1671 Mechanical problems Reason      
2404 High Street Destination     HST
1376 The next service to Passenger information upwards inflection    
0809 A fire next to the track Reason      
1751 Stand well away from the edge of platform Safety      
0869 A safety inspection on a train Reason      
1389 The next bus service Passenger information      
0627 Bingley Destination     BIY
0168 Will be in approximately 15 minutes Time      
1683 Bare Lane Destination     BAR
2101 Pollokshields East Destination     PLE
0780 ...a fault occurring when detaching a part of this train. Reason      
0871 A safety inspection on this train Reason      
2022 Easterhouse Destination     EST
0992 Damage to the overhead electric wires earlier today Reason      
2089 Mount Vernon Destination     MTV
1602 Bathgate Destination     BHG
2221 Arrochar & Tarbet Destination     ART
0091 platform 6 for the delayed Platform information      
1082 The fire alarm sounding at a station Reason      
0635 Blackpool Pleasure Beach Destination     BPB
0823 A lorry colliding with a bridge Reason      
1356 fifty-two Number      
0922 a supermarket trolley on the track Reason trust scotland to need this 🤣    
1053 Passengers causing a disturbance on a train Reason      
0570 Listen for further announcements Passenger information      
1506 Standard class accommodation is towards the front Passenger information      
0182 This train is formed of 6 coaches Train formation      
0110 Is delayed by approximately 5 minutes Time      
1918 Liverpool Lime Street Destination     LIV
1865 Bearsden Destination     BRN
1755 Bristol Temple Meads Destination     BRI
0185 This train is formed of 9 coaches Train formation      
0909 a speed restriction in a tunnel Reason      
1131 This train's automatic braking system being activated, earlier today Reason      
1648 Accrington Destination     ACR