announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by NRE_ID descending
This data as json, CSV (advanced)
Category 23
- Destination 1,271
- Reason 421
- Time 161
- Passenger information 153
- Number 102
- Train operating company 76
- Platform information 67
- Conjoining 66
- Weather 30
- Safety 15
- Train formation 14
- Special train 12
- Operational 10
- Apology 8
- Fare information 7
- Platform ID 7
- Heritage Railway 6
- Number combo 4
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
- Train operating company 1
File | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID ▲ |
---|---|---|---|---|---|---|
1270 | York | Destination | YRK | |||
2440 | York | Destination | YRK | |||
2138 | Yoker | Destination | YOK | |||
2361 | Yoker | Destination | Les Porter | YOK | ||
1424 | Wylam | Destination | WYM | |||
1572 | Wylam | Destination | WYM | |||
1269 | Wolverhampton | Destination | WVH | |||
2432 | Wolverhampton | Destination | WVH | |||
1487 | Wester Hailes | Destination | WTA | |||
1637 | Wester Hailes | Destination | WTA | |||
1264 | Weston-super-Mare | Destination | WSM | |||
2412 | Weston-super-Mare | Destination | WSM | |||
2201 | Wishaw | Destination | WSH | |||
2428 | Wishaw | Destination | WSH | |||
1422 | Wetheral | Destination | WRL | |||
1570 | Wetherall | Destination | WRL | |||
2136 | Whinhill | Destination | WNL | |||
2359 | Whinhill | Destination | WNL | |||
2134 | Wemyss Bay | Destination | WMS | |||
2357 | Wemyss Bay | Destination | WMS | |||
0226 | Wilmslow | Destination | WML | |||
1301 | Wilmslow | Destination | WML | |||
2200 | Williamwood | Destination | WLM | |||
2427 | Williamwood | Destination | WLM | |||
1263 | Wakefield Westgate | Destination | WKF | |||
2407 | Wakefield Westgate | Destination | WKF | |||
2135 | West Kilbride | Destination | WKB | |||
2358 | West Kilbride | Destination | WKB | |||
1267 | Winchester | Destination | WIN | |||
2425 | Winchester | Destination | WIN | |||
1265 | Widnes | Destination | WID | |||
2421 | Widnes | Destination | WID | |||
0315 | Westenhanger Racecourse | Destination | Station closed in 1960s! | WHA | ||
0447 | Westenhanger Racecourse | Destination | Station closed in 1960s! | WHA | ||
1266 | Wigan Wallgate | Destination | WGW | |||
2423 | Wigan Wallgate | Destination | WGW | |||
1423 | Wigan North Western | Destination | WGN | |||
1571 | Wigan North Western | Destination | WGN | |||
1661 | Watford Junction | Destination | WFJ | |||
1789 | Watford Junction | Destination | WFJ | |||
2199 | Whifflet | Destination | WFF | |||
2426 | Whifflet | Destination | WFF | |||
2197 | Westerton | Destination | WES | |||
2424 | Westerton | Destination | WES | |||
1268 | Windermere | Destination | WDM | |||
2429 | Windermere | Destination | WDM | |||
2202 | Woodhall | Destination | WDL | |||
2430 | Woodhall | Destination | WDL | |||
2137 | Whitecraigs | Destination | WCR | |||
2360 | Whitecraigs | Destination | WCR | |||
1486 | West Calder | Destination | WCL | |||
1636 | West Calder | Destination | WCL | |||
2203 | Wick | Destination | WCK | |||
2431 | Wick | Destination | WCK | |||
0003 | Warrington Bank Quay | Destination | 0:00:05 | WBQ | ||
1272 | Warrington Bank Quay | Destination | WBQ | |||
1485 | Wallyford | Destination | WAF | |||
1635 | Wallyford | Destination | WAF | |||
1873 | Upper Tyndrum | Destination | UTY | |||
1939 | Upper Tyndrum | Destination | UTY | |||
2196 | Upper Tyndrum | Destination | UTY | |||
2422 | Upper Tyndrum | Destination | UTY | |||
1473 | Uphall | Destination | UHA | |||
1621 | Uphall | Destination | UHA | |||
1472 | Uddingston | Destination | UDD | |||
1620 | Uddingston | Destination | UDD | |||
2132 | Tyndrum Lower | Destination | TYL | |||
2356 | Tyndrum Lower | Destination | TYL | |||
0292 | Tweedbank | Destination | TWB | |||
0432 | Tweedbank | Destination | TWB | |||
1259 | Tiverton Parkway | Destination | TVP | |||
2365 | Tiverton Parkway | Destination | TVP | |||
2194 | Tulloch | Destination | TUL | |||
2420 | Tulloch | Destination | TUL | |||
1707 | Thetford | Destination | TTF | |||
1262 | Truro | Destination | TRU | |||
2393 | Truro | Destination | TRU | |||
0221 | Trowbridge | Destination | TRO | |||
1300 | Trowbridge | Destination | TRO | |||
1261 | Troon | Destination | is this a station or the scottish version of train | TRN | ||
2388 | Troon | Destination | TRN | |||
1260 | Totnes | Destination | TOT | |||
2379 | Totnes | Destination | TOT | |||
2192 | Thorntonhall | Destination | THT | |||
2418 | Thorntonhall | Destination | THT | |||
2193 | Thurso | Destination | THS | |||
2419 | Thurso | Destination | THS | |||
2131 | Thornliebank | Destination | THB | |||
2354 | Thornliebank | Destination | THB | |||
1258 | Teignmouth | Destination | TGM | |||
2355 | Teignmouth | Destination | TGM | |||
2191 | Taynuilt | Destination | TAY | |||
2417 | Taynuilt | Destination | TAY | |||
1257 | Taunton | Destination | TAU | |||
2352 | Taunton | Destination | TAU | |||
1256 | Tamworth | Destination | TAM | |||
2349 | Tamworth | Destination | TAM | |||
2190 | Tain | Destination | TAI | |||
2416 | Tain | Destination | TAI | |||
1250 | Stevenage | Destination | SVG |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "announcements" ( [File] TEXT PRIMARY KEY, [Transcription] TEXT, [Category] TEXT, [mp3] TEXT, [Notes] TEXT, [Timestamp] TEXT, [NRE_ID] TEXT );