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
1227 Plymouth Destination     PLY
0826 A low speed derailment Reason      
2309 Milngavie Destination     MLN
0016 The next train at platform 5 is the Platform information "the" (/ðə/)    
2409 Maryhill Destination     MYH
1742 Bredbury Destination     BDY
1716 suspected damage to a railway bridge. Reason      
0810 A fire next to the track earlier today Reason      
1583 Lochgelly Destination     LCG
1083 The fire alarm sounding at a station earlier today Reason      
0219 Starcross Destination     SCS
0128 This service will be in approximately 5 minutes Time      
0220 is available Conjoining      
0021 The next train at platform 2 is the Platform information "the" (/ði/)    
1487 Wester Hailes Destination     WTA
0897 a speed restriction because of high track temperatures earlier today Reason      
1401 sixteen Number      
2092 Neilston Destination     NEI
0512 Please join the middle three coaches of this train Passenger information      
0214 Southeastern Train operating company Low-pitch ending    
1741 Branksome Destination     BSM
0816 A gas leak near the railway Reason      
1942 Bridge of Orchy Destination     BRO
2292 Langbank Destination     LGB
1052 Passengers causing a disturbance earlier on this train's journey Reason      
0320 07 Time oh-seven    
1706 Berwick Destination     BRK
2301 Locheilside Destination     LCS
1114 Thick fog Weather      
1078 The electricity being switched off for safety reasons earlier on this train's journey Reason      
1361 fifty-seven Number      
1753 Bristol Parkway Destination     BPW
0126 Should join the rear 11 coaches Passenger information      
2279 Jordanhill Destination     JOR
0444 Stirling Destination     STG
1003 Failure of the electricity supply earlier on this train's journey Reason      
1686 Barnsley Destination     BNY
0457 The Grand Central service from Train operating company      
2296 Achanalt Destination     AAT
1837 Saltash Destination     STS
1451 South Gyle Destination     SGL
2237 Dalreoch Destination     DLR
1045 Overcrowding because of a football match Reason      
2011 Dalreoch Destination     DLR
1363 fifty-nine Number      
0103 Will be in 30 minutes Time      
0811 A fire on a train Reason      
1379 Mitcham Eastfields Destination     MTC
1823 Alness Destination     ASS
2434 Dalgety Bay Destination     DAG
1354 fifty Number      
1328 twenty-five Number      
0771 ...a collision at a level crossing earlier today. Reason      
2428 Wishaw Destination     WSH
0930 A train hitting an obstruction on the line earlier today Reason      
0324 11 Time      
1289 fourteen Number      
2215 Anniesland Destination     ANL
1906 Kilmaurs Destination     KLM
1547 The train now at... Conjoining      
2059 King's Park Destination     KGP
2300 Lochailort Destination     LCL
0580 Adlington Destination     ADC
0807 A fire near the railway suspected to involve gas cylinders earlier today Reason      
1446 minutes. Time end of sentence    
2066 Langbank Destination     LGB
2084 Milliken Park Destination     MIN
0156 The public address system at this station Operational      
1574 Kingsknowe Destination     KGE
1493 please note that cycles may not be carried on this train Passenger information      
2093 Oban Destination     OBN
1578 Larbert Destination     LBT
0316 White City Destination London Underground    
2088 Mount Florida Destination     MFL
1027 Horses on the railway Reason      
0985 Checking reports of an obstruction on the line earlier today Reason      
2275 Invergordon Destination     IGD
0013 The next train at platform 2 is the Platform information "the" (/ðə/)    
0765 ...a coach becoming uncoupled on a train earlier today Reason      
2262 Gourock Destination     GRK
1174 carriage. Conjoining      
1922 London Marylebone Destination     MYB
0962 An obstruction on the track earlier on this train's journey Reason      
0813 A fire on property near the railway Reason      
1335 thirty-two Number      
0700 Cupar Destination end   CUP
0723 ...will not call at... Conjoining mid    
2297 Achnasheen Destination     ACN
1577 Engineering works Conjoining      
0884 A shortage of trains because of accident damage Reason      
1916 Liskeard Destination     LSK
0736 ...at... Conjoining      
1205 Newcastle Destination     NCL
2163 Crookston Destination     CKT
0191 Stand well away from the edge of platform 2 Safety      
1990 Ardrossan Town Destination     ADN
1948 Market Harborough Destination     MHR
1778 service from Conjoining      
1684 Barnetby Destination     BTB
2383 Connel Ferry Destination     CON