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
1306 03 Time oh-three    
0861 A road vehicle colliding with level crossing barriers Reason      
0478 The Bluebell Railway Heritage Railway stepney is sad and lost    
0074 The train now approaching platform 7 Platform information      
1826 Durham Destination     DHM
1499 we are sorry to announce Passenger information      
2036 Glengarnock Destination     GLG
1143 Urgent repairs to the railway earlier today Reason      
1202 Morpeth Destination     MPT
2398 Dunrobin Castle Destination     DNO
1247 St Columb Road Destination     SCR
0873 A security alert at a station Reason      
1899 Saltash Destination     STS
2109 Queen's Park Destination     QPK
0938 A train's automatic braking system being activated Reason      
0245 Dunfermline Queen Margaret Destination     DFL
0867 A safety inspection of the track Reason      
0603 Bamber Bridge Destination     BMB
0035 platform 5 for the Platform information "the" (/ðə/)    
1378 two Number      
1456 Bellshill Destination     BLH
1204 Newark Northgate Destination     NNG
0534 Please join the rear twelve coaches of this train Passenger information      
2148 Cardross Destination     CDR
1080 The emergency services dealing with an incident Reason      
1997 Barassie Destination     BSS
0476 The Blue Pullman service to Special train      
1039 Lightning damaging this train Weather Unsure if this would even be callable in this event    
0129 This service will be in approximately 10 minutes Time      
2033 Par Destination     PAR
1709 should cross via the footbridge to Passenger information      
2170 Drumchapel Destination     DMC
0351 is available on this train Passenger information      
0059 will now depart from platform 6 Platform information      
1536 A points failure Reason      
1208 Newquay Destination     NQY
0395 Dunfermline Town Destination Low-pitch ending   DFE
0485 GNER Train operating company      
2360 Whitecraigs Destination     WCR
1766 to reach your destination Passenger information      
0983 Checking reports of an obstruction on the line Reason      
0566 First class accommodation is available Passenger information      
1804 Crossmyloof Destination     CMY
0113 Is delayed by approximately 20 minutes Time      
1764 Bugle Destination     BGL
0909 a speed restriction in a tunnel Reason      
1568 Riding Mill Destination     RDM
0850 A road accident at a level crossing yesterday Reason      
1728 Blackpool Destination      
0570 Listen for further announcements Passenger information      
2301 Locheilside Destination     LCS
2029 Forsinard Destination     FRS
1680 Bamber Bridge Destination     BMB
1153 Vandalism on a train Reason      
1477 Drem Destination     DRM
2302 Lochluichart Destination     LCC
1748 please Conjoining      
0901 a speed restriction because of severe weather Reason      
1812 Please note that this train will not call at Passenger information      
0069 The train now approaching platform 2 Platform information Nice    
0164 Will be in approximately 3 minutes Time      
1386 Southeastern Trains Train operating company      
2143 Branchton Destination     BCN
0583 Cheadle Hulme Destination     CHU
0506 Please join the front twelve coaches of this train Passenger information      
1717 Birmingham International Destination     BHI
1774 Bury St. Edmunds Destination     BSE
2100 Pollokshaws East Destination     PWE
2097 Paisley St James Destination     PYJ
0621 Berry Brow Destination     BBW
0122 Strathclyde metro service to Strathclyde metro      
1409 Blaydon Destination     BLO
1816 Dumfries Destination     DMF
0780 ...a fault occurring when detaching a part of this train. Reason      
0477 The Blue Pullman service from Special train      
0955 Kilmaurs Destination     KLM
0784 ...a fault with a swing bridge over a river. Reason      
0137 Will arrive in approximately 1 minute Time      
0404 Loch Awe Destination     LHA
0168 Will be in approximately 15 minutes Time      
0778 ...a fault occurring when attaching a part of this train. Reason      
1162 This train is formed of Passenger information      
1700 We are sorry to announce that the Apology      
1565 Invergowrie Destination     ING
1576 Kirknewton Destination     KKN
0977 Attempted theft of signalling cables yesterday Reason      
0872 A safety inspection on this train earlier in its journey Reason      
0921 a speed restriction over defective track earlier today Reason      
0943 A tree blocking the railway earlier today Reason      
2331 Prestwick International Airport Destination     PRA
2252 Forsinard Destination     FRS
0393 Central Destination Low-pitch ending    
2071 Achanalt Destination     AAT
1135 Trespassers on the railway Reason      
1339 We are sorry to announce that Apology      
1443 Pitlochry Destination     PIT
1156 Vandalism on this train Reason      
2000 Brora Destination     BRA
0325 12 Time      
1491 four Number