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
2085 Milngavie Destination     MLN
0410 Stromeferry Destination     STF
2063 Kyle of Lochalsh Destination     KYL
0926 A train derailment earlier today Reason      
2340 Saltcoats Destination     SLT
0937 A train not stopping in the correct position at a station earlier today Reason      
1139 Urgent repairs to a bridge earlier today Reason      
1867 Hale Destination     HAL
2016 Drumgelloch Destination     DRU
0913 a speed restriction over a bridge Reason      
0919 a speed restriction over defective track Reason      
2366 Bishopton Destination     BPT
0796 ...a fault with the radio system between the driver and the signaller earlier on this train's journey. Reason when has this ever been used    
1372 Forres Destination     FOR
1183 London King's Cross Destination     KGX
1909 Ladybank Destination     LDY
2386 Croftfoot Destination     CFF
0034 ScotRail service from Train operating company      
0243 Brunstane Destination     BSU
0017 The next train at platform 6 is the Platform information "the" (/ðə/)    
0853 A road accident near the railway earlier today Reason      
0061 will now depart from platform 8 Platform information      
1224 Penzance Destination     PNZ
2355 Teignmouth Destination     TGM
0639 Blackrod Destination     BLK
2140 Barnhill Destination     BNL
0240 10 Time      
1338 thirty-five Number      
1600 Aviemore Destination     AVM
2281 Stewarton Destination     STT
0565 and can be found in the front and rear of the train Passenger information      
1955 Metrocentre Destination     MCE
0888 a speed restriction Reason      
2207 Dumbarton East Destination     DBE
2070 Peterborough Destination     PBO
1545 Nairn Destination     NRN
0978 Attempted theft of third rail electrification equipment Reason      
1055 Passengers causing a disturbance on this train Reason      
1182 London Euston Destination     EUS
2062 Penzance Destination     PNZ
1085 The fire alarm sounding in a signal box earlier on this train's journey Reason      
0475 The Blue Pullman Special train      
0019 The next train at platform 8 is the Platform information "the" (/ðə/)    
0985 Checking reports of an obstruction on the line earlier today Reason      
1250 Stevenage Destination     SVG
1739 Bradford Interchange Destination     BDI
1434 Livingston South Destination     LVG
0840 Inverkeithing Destination     INK
1087 Ladybank Destination     LDY
1563 Haydon Bridge Destination     HDB
0895 a speed restriction because of high track temperatures Reason      
2260 Giffnock Destination     GFN
2363 Alexandra Parade Destination     AXP
2203 Wick Destination     WCK
0907 a speed restriction earlier on this train's journey Reason      
0264 Glasgow Central Low Level Destination     GLC
1969 Platform 8 for the Platform information      
2026 Falls of Cruachan Destination Croo-kin surely? (Not with a 'k' unless you are anglicising it, surely)   FOC
0276 16 Time      
2243 Drumry Destination     DMY
1131 This train's automatic braking system being activated, earlier today Reason      
2277 Invershin Destination     INH
0491 please join the front Conjoining      
1743 adverse weather conditions Reason      
1689 Barrhead Destination     BRR
1720 Birmingham Destination      
1674 Auchinleck Destination     AUK
0804 A fire near the railway involving gas cylinders earlier today Reason      
1588 North Queensferry Destination     NQU
0904 a speed restriction because of snow and ice Reason      
2233 Corpach Destination     CPA
1412 Dunston Destination     DOT
0712 Doncaster Destination     DON
1271 Platform Platform ID      
1300 Trowbridge Destination     TRO
0808 A fire near the railway suspected to involve gas cylinders yesterday Reason so specific; lazy should do one for each day of the week.    
1407 twenty Number      
1569 Stocksfield Destination     SKS
1913 Leeds Destination     LDS
2188 Stratford Destination     SRA
0790 ...a fault with the electric third rail earlier on this train's journey. Reason      
0951 The ambulance service dealing with an incident near the railway Reason      
2368 Breich Destination     BRC
0344 29 Time      
0672 Manchester Oxford Road Destination     MCO
2309 Milngavie Destination     MLN
0079 The train now approaching platform 5 is the Platform information "the" (/ði/)    
0822 A late running train being in front of this one Reason      
1805 Cupar Destination     CUP
0577 Overhead electric line problems Reason      
0521 Please join the middle twelve coaches of this train Passenger information How long does a train have to be in total to have twelve middle coaches? - 14 coaches!    
0793 ...a fault with the on-train signalling system earlier on this train's journey. Reason      
1035 Lightning damaging a train Weather      
2413 Rogart Destination     ROG
0750 ...a broken windscreen on the train. Reason      
1562 Haltwhistle Destination     HWH
0813 A fire on property near the railway Reason      
1809 Dawlish Warren Destination     DWW
0915 a speed restriction over a bridge earlier today Reason      
2181 Hillington West Destination     HLW