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
1880 This train is ready to leave Passenger information      
0632 Birmingham Destination      
0237 07 Time oh-seven    
0680 This train... Conjoining      
0287 Eskbank Destination     EKB
1182 London Euston Destination     EUS
0446 Stratford International Destination     SFA
0327 14 Time      
0921 a speed restriction over defective track earlier today Reason      
1690 Barrhill Destination     BRL
1541 Huntly Destination     HNT
1420 Riding Mill Destination     RDM
1897 Inverkeithing Destination     INK
0312 Star Lane Destination DLR    
1853 Gretna Green Destination     GEA
0687 Carstairs Destination     CRS
1848 Glasgow Queen Street Destination     GLQ
1781 Cardiff Queen Street Destination     CDQ
0232 02 Time oh-two    
0266 Newton (Lanarkshire) Destination     NTN
0064 This train is formed of 12 coaches Passenger information      
2330 Stonehaven Destination     STN
0671 Burneside Destination     BUD
0079 The train now approaching platform 5 is the Platform information "the" (/ði/)    
0789 ...a fault with the electric third rail. Reason Why do they need this...    
1825 Dunlop Destination     DNL
0283 Chatelherault Destination     CTE
0478 The Bluebell Railway Heritage Railway stepney is sad and lost    
2180 Hillington East Destination     HLE
0575 East Midlands service to Train operating company      
1705 Berry Brow Destination     BBW
0317 05 Time oh-five    
2388 Troon Destination     TRN
2243 Drumry Destination     DMY
1289 fourteen Number      
1047 Overcrowding because of a rugby match Reason      
1282 nine Number      
0794 ...a fault with the on-train signalling system earlier today. Reason      
2019 Padgate Destination     PDG
0438 Edinburgh International Destination Proposed    
2438 Kirknewton Destination     KKN
0282 Larkhall Destination     LRH
0953 The ambulance service dealing with an incident near the railway yesterday Reason      
0061 will now depart from platform 8 Platform information      
0234 04 Time oh-four    
0604 Bamford Destination     BAM
1375 has been cancelled Passenger information      
0776 ...a derailment within the depot. Reason      
1062 Severe weather Weather      
0952 The ambulance service dealing with an incident near the railway earlier today Reason      
1730 This train is formed of Train formation      
0180 This train is formed of 4 coaches Train formation      
1267 Winchester Destination     WIN
1148 Vandalism at a station yesterday Reason      
1798 Church and Oswaldtwistle Destination     CTW
0401 Hamilton West Destination     HNW
0009 Midland Main Line service from Train operating company   0:00:22  
0788 ...a fault with barriers at a level crossing yesterday. Reason      
0810 A fire next to the track earlier today Reason      
1293 Southampton Central Destination     SOU
2152 Kilwinning Destination     KWN
2436 Dumbarton East Destination     DBE
1894 Hunts Cross Destination     HNX
0825 A lorry colliding with a bridge earlier today Reason      
1899 Saltash Destination     STS
2143 Branchton Destination     BCN
2314 Mount Vernon Destination     MTV
2155 Charing Cross Destination     CHX
0586 Ansdell & Fairhaven Destination     AFV
0683 Cardiff Queen Street Destination     CDQ
1895 Melksham Destination     MKM
0112 Is delayed by approximately 15 minutes Time      
0040 platform 3 for the Platform information "the" (/ði/)    
2102 Pollokshields West Destination     PLW
1409 Blaydon Destination     BLO
2089 Mount Vernon Destination     MTV
1884 Airbles Destination     AIR
1721 Blackburn Destination     BBN
1464 Camelon Destination     CMO
2054 Jordanhill Destination     JOR
1919 Lockerbie Destination     LOC
0797 ...a fault with the radio system between the driver and the signaller earlier today. Reason      
2327 Port Glasgow Destination     PTG
0290 Galashiels Destination     GAL
2423 Wigan Wallgate Destination     WGW
2228 Brora Destination     BRA
2122 Shieldmuir Destination     SDM
2140 Barnhill Destination     BNL
2301 Locheilside Destination     LCS
2210 Musselburgh Destination     MUB
1823 Alness Destination     ASS
2067 Langside Destination     LGS
0388 First Capital Connect Train operating company      
0131 This service will arrive in approximately 12 minutes Time      
0265 Glasgow Queen Street Low Level Destination     GLQ
1352 forty-eight Number      
2047 Helmsdale Destination     HMS
1224 Penzance Destination     PNZ
2239 Dalmarnock Destination     DAK
0351 is available on this train Passenger information