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
0008 Midland Main Line service to Train operating company   0:00:19  
0803 A fire near the railway involving gas cylinders Reason      
1437 Monifieth Destination     MON
1801 this cancellation Conjoining      
0478 The Bluebell Railway Heritage Railway stepney is sad and lost    
2397 Dumbarton Central Destination     DBC
1972 7, 8 Number combo      
0036 platform 6 for the Platform information "the" (/ðə/)    
0110 Is delayed by approximately 5 minutes Time      
1238 Retford Destination     RET
2052 Invershin Destination     INH
0118 Is delayed by approximately 45 minutes Time      
2197 Westerton Destination     WES
1772 Burscough Bridge Destination     BCB
0425 Alloa Destination     ALO
1969 Platform 8 for the Platform information      
0069 The train now approaching platform 2 Platform information Nice    
1175 carriages. Conjoining      
1596 Shotts Destination     SHS
1306 03 Time oh-three    
1142 Urgent repairs to the railway Reason      
1721 Blackburn Destination     BBN
2423 Wigan Wallgate Destination     WGW
2390 Cumbernauld Destination     CUB
1686 Barnsley Destination     BNY
0601 Ayr Destination     AYR
1608 Broughty Ferry Destination     BYF
1579 Lenzie Destination     LNZ
2240 Dalmuir Destination     DMR
0382 A points failure Reason      
2180 Hillington East Destination     HLE
1112 Theft of third rail electrical equipment, earlier today Reason      
1611 Cambuslang Destination     CBL
1931 Banavie Destination     BNV
2061 Kirkwood Destination     KWD
1609 Penalty fares are in operation in this area Fare information      
0276 16 Time      
1858 Chippenham Destination     CPM
1163 one Number      
1749 Brighouse Destination     BGH
1888 Altnabreac Destination     ABC
1114 Thick fog Weather      
1887 Alness Destination     ASS
1482 Gleneagles Destination     GLE
1662 Appley Bridge Destination     APB
0120 Is delayed by approximately 55 minutes Time      
0937 A train not stopping in the correct position at a station earlier today Reason      
0405 Newcraighall Destination   NEW
1316 thirteen Number      
1201 Montrose Destination     MTS
2105 Portlethen Destination     PLN
1648 Accrington Destination     ACR
2095 Paisley Canal Destination     PCN
1165 three Number      
1308 05 Time oh-five    
2291 Lanark Destination     LNK
0077 The train now approaching platform 3 is the Platform information "the" (/ði/)    
1941 Manchester Piccadilly Destination     MAN
1514 This train will be calling at stations with short platforms Passenger information      
0777 ...a fault occurring when attaching a part of a train. Reason      
1014 Forecasted heavy snow Weather      
0460 London Overground service to Train operating company      
2177 Golspie Destination     GOL
0928 A train hitting an obstruction on the line Reason      
0477 The Blue Pullman service from Special train      
0638 Blackpool Destination      
1657 Annan Destination     ANN
1064 Severe weather earlier in this train's journey Weather      
1685 Trespass on the line Reason      
1191 Manchester Piccadilly Destination     MAN
0817 A gas leak near the railway earlier today Reason      
0793 ...a fault with the on-train signalling system earlier on this train's journey. Reason      
0616 Bempton Destination     BEM
1039 Lightning damaging this train Weather Unsure if this would even be callable in this event    
0964 An operational incident Reason      
1359 fifty-five Number      
0450 A technical problem Reason      
1338 thirty-five Number      
2104 Possilpark & Parkhouse Destination     PPK
0147 Will arrive in approximately 35 minutes Time      
1315 twelve Number      
1688 Thank you Conjoining      
1690 Barrhill Destination     BRL
1627 Dunkeld & Birnam Destination     DKD
0679 Cardiff Destination start    
0322 09 Time oh-nine    
1402 seventeen Number      
0286 Shawfair Destination     SFI
1460 Breich Destination     BRC
1184 London Marylebone Destination     MYB
1666 Goostrey Destination     GTR
1923 London Moorgate Destination     MOG
2066 Langbank Destination     LGB
1251 Stranraer Destination     STR
1601 Balmossie Destination     BSI
0215 First Great Western Train operating company      
1004 Failure of the electricity supply earlier today Reason   https://matteason.github  
1728 Blackpool Destination      
0891 a speed restriction because of fog earlier today Reason      
1624 Dalwhinnie Destination     DLW