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
1032 Industrial action earlier today Reason      
0993 Earlier engineering works not being finished on time Reason      
2332 Prestwick Town Destination     PTW
1244 between Conjoining      
2002 Carmyle Destination     CML
0148 Will arrive in approximately 40 minutes Time      
1177 Please use all available doors when getting on the train. Passenger information      
0564 First class accommodation is available Passenger information      
1352 forty-eight Number      
1858 Chippenham Destination     CPM
0856 A road vehicle blocking the railway earlier on this train's journey Reason      
1833 Edinburgh Destination      
0144 Will arrive in approximately 20 minutes Time      
1016 Forecasted severe weather Weather      
1109 Theft of signalling cables, earlier today Reason      
0153 Poor rail conditions Reason      
0113 Is delayed by approximately 20 minutes Time      
1852 GNER service to Train operating company      
2029 Forsinard Destination     FRS
2356 Tyndrum Lower Destination     TYL
0942 A tree blocking the railway earlier on this train's journey Reason      
0081 The train now approaching platform 7 is the Platform information "the" (/ði/)    
0612 Basingstoke Destination     BSK
2317 Neilston Destination     NEI
2406 Hillington West Destination     HLW
1806 Chippenham Destination     CPM
0479 The Bluebell Railway Heritage Railway the profesionals at firewatch    
0622 Berwick Destination     BRK
0168 Will be in approximately 15 minutes Time      
1058 The police dealing with an incident near the railway earlier today Reason      
0420 East Midlands Airport Destination Non-rail    
1408 Bardon Mill Destination     BLL
2103 Port Glasgow Destination     PTG
0176 Will be in approximately 55 minutes Time      
1856 GNER service from Train operating company      
0981 Cattle on the railway Reason      
1160 Leeds Destination     LDS
1039 Lightning damaging this train Weather Unsure if this would even be callable in this event    
1262 Truro Destination     TRU
0106 Will be in 45 minutes Time      
1560 Hartwood Destination     HTW
0125 Should join the rear 10 coaches Passenger information      
2347 Spean Bridge Destination     SBR
1882 Newton Destination     NTN
0620 Bentley Destination     BYK
1383 A security alert Reason upward inflection    
0519 Please join the middle ten coaches of this train Passenger information      
0754 ...a burst water main near the railway, earlier today. Reason      
0845 A railway embankment being damaged Reason      
0621 Berry Brow Destination     BBW
2252 Forsinard Destination     FRS
1193 Manchester Destination      
1807 Darlington Destination     DAR
1726 Edinburgh Park Destination     EDP
1889 Devonport Destination     DPT
1460 Breich Destination     BRC
0164 Will be in approximately 3 minutes Time      
0830 A passenger being taken ill on a train Reason      
0316 White City Destination London Underground    
1809 Dawlish Warren Destination     DWW
1773 Burton-on-Trent Destination     BUT
0915 a speed restriction over a bridge earlier today Reason      
0037 Strathclyde metro service from Strathclyde metro      
1426 Kingsknowe Destination     KGE
2004 Coatbridge Central Destination     CBC
1323 twenty Number      
1620 Uddingston Destination     UDD
1248 St Erth Destination     SER
1493 please note that cycles may not be carried on this train Passenger information      
1132 Train crew being delayed Reason      
2258 Garve Destination     GVE
0134 10 minutes Time      
2042 Greenock West Destination     GKW
1347 forty-three Number      
1758 Attention please Passenger information      
2195 Sanquhar Destination     SQH
1699 Ben Rhydding Destination     BEY
1120 This train hitting an obstruction on the line, earlier in its journey Reason      
0957 An incident at the airport Reason      
0551 If you are travelling to this station, please wait on the platform Passenger information    
0995 The emergency services dealing with an incident near the railway earlier today Reason      
0066 This train is formed of 1 coach Passenger information      
0084 of drinks and light refreshments Passenger information      
1796 Chorley Destination     CRL
1827 Devonport Destination     DPT
2346 Singer Destination     SIN
0015 The next train at platform 4 is the Platform information "the" (/ðə/)    
1629 All passengers must be in possession of a valid ticket Fare information after 1609    
0512 Please join the middle three coaches of this train Passenger information      
0307 Folkestone Racecourse Destination Non-rail    
1194 Market Harborough Destination     MHR
1007 The fire brigade dealing with an incident near the railway earlier today Reason      
1260 Totnes Destination     TOT
0838 A problem currently under investigation Reason      
1167 five Number      
0637 Edinburgh Park Destination     EDP
1970 Newark Northgate Destination     NNG
1634 Or authority to travel Fare information after 1629    
2364 Barnhill Destination     BNL
1419 Johnstone Destination     JHN