announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Notes
This data as json, CSV (advanced)
Category 21
- Destination 1,212
- Reason 415
- Passenger information 139
- Number 102
- Train operating company 57
- Conjoining 55
- Platform information 42
- Weather 30
- Time 29
- Special train 12
- Apology 7
- Fare information 7
- Safety 7
- Heritage Railway 6
- Number combo 4
- Non-vocal 3
- Platform ID 2
- Request stop 2
- Train formation 2
- Operational 1
- Station 1
File | Transcription | Category | mp3 | Notes ▼ | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0400 | Greenfaulds | Destination | GRL | |||
0401 | Hamilton West | Destination | HNW | |||
0402 | Hawkhead | Destination | HKH | |||
0403 | High Street | Destination | HST | |||
0404 | Loch Awe | Destination | LHA | |||
0406 | Newton | Destination | NTN | |||
0407 | Queen Street | Destination | GLQ | |||
0409 | Kingsknowe | Destination | KGE | |||
0410 | Stromeferry | Destination | STF | |||
0411 | Glasgow Central Low Level | Destination | GLC | |||
0412 | Glasgow Queen Street Low Level | Destination | GLQ | |||
0413 | Newton (Lanarkshire) | Destination | NTN | |||
0414 | Ardrossan Harbour | Destination | ADS | |||
0415 | Ardrossan South Beach | Destination | ASB | |||
0416 | Ardrossan Town | Destination | ADN | |||
0417 | Brampton (Cumbria) | Destination | BMP | |||
0419 | Kirkconnel | Destination | KRK | |||
0421 | Kelvindale | Destination | KVD | |||
0422 | Merryton | Destination | MEY | |||
0423 | Larkhall | Destination | LRH | |||
0424 | Chatelherault | Destination | CTE | |||
0425 | Alloa | Destination | ALO | |||
0426 | Shawfair | Destination | SFI | |||
0427 | Eskbank | Destination | EKB | |||
0428 | Newtongrange | Destination | NEG | |||
0429 | Gorebridge | Destination | GBG | |||
0430 | Galashiels | Destination | GAL | |||
0431 | Bad weather conditions | Reason | ||||
0432 | Tweedbank | Destination | TWB | |||
0436 | Liverpool South Parkway | Destination | LPY | |||
0437 | Liverpool South | Destination | ||||
0439 | Falmouth | Destination | FMT | |||
0443 | Shepherds Bush | Destination | SPH | |||
0444 | Stirling | Destination | STG | |||
0446 | Stratford International | Destination | SFA | |||
0449 | Engineering works | Reason | ||||
0450 | A technical problem | Reason | ||||
0451 | A technical problem | Reason | ||||
0452 | Staff shortages | Reason | ||||
0453 | Staff shortages | Reason | ||||
0454 | The Grand Central | Train operating company | ||||
0455 | The Grand Central | Train operating company | ||||
0456 | The Grand Central service to | Train operating company | ||||
0457 | The Grand Central service from | Train operating company | ||||
0458 | London Overground | Train operating company | ||||
0459 | London Overground | Train operating company | ||||
0460 | London Overground service to | Train operating company | ||||
0461 | London Overground service from | Train operating company | ||||
0462 | Transport for London Overground | Train operating company | ||||
0463 | Transport for London Overground | Train operating company | ||||
0464 | Transport for London Overground service to | Train operating company | ||||
0465 | Transport for London Overground service from | Train operating company | ||||
0466 | The Cathedrals Express | Special train | ||||
0467 | The Cathedrals Express | Special train | ||||
0468 | The Cathedrals Express service to | Special train | ||||
0469 | The Cathedrals Express service from | Special train | ||||
0470 | The Cathedrals Express steam service to | Special train | ||||
0471 | The Cathedrals Express steam service from | Special train | ||||
0472 | The Cathedrals Express special steam service to | Special train | ||||
0473 | The Cathedrals Express special steam service from | Special train | ||||
0474 | The Blue Pullman | Special train | ||||
0475 | The Blue Pullman | Special train | ||||
0476 | The Blue Pullman service to | Special train | ||||
0477 | The Blue Pullman service from | Special train | ||||
0480 | The Watercress Line | Heritage Railway | ||||
0481 | The Watercress Line | Heritage Railway | ||||
0483 | The Spa Valley Railway | Heritage Railway | ||||
0484 | Midland Mainline Turbostar | Train operating company | ||||
0485 | GNER | Train operating company | ||||
0486 | GNER | Train operating company | ||||
0487 | Platform 0 | Platform ID | ||||
0488 | and will now depart at | Conjoining | ||||
0489 | will not arrive until | Conjoining | ||||
0490 | and will not arrive until | Conjoining | ||||
0491 | please join the front | Conjoining | ||||
0492 | coach | Conjoining | ||||
0493 | of this train | Conjoining | ||||
0494 | Please join the front coach only | Passenger information | ||||
0495 | Please join the front coach only of this train | Passenger information | ||||
0496 | Please join the front two coaches of this train | Passenger information | ||||
0497 | Please join the front three coaches of this train | Passenger information | ||||
0498 | Please join the front four coaches of this train | Passenger information | ||||
0499 | Please join the front five coaches of this train | Passenger information | ||||
0500 | Please join the front six coaches of this train | Passenger information | ||||
0501 | Please join the front seven coaches of this train | Passenger information | ||||
0502 | Please join the front eight coaches of this train | Passenger information | ||||
0503 | Please join the front nine coaches of this train | Passenger information | ||||
0504 | Please join the front ten coaches of this train | Passenger information | ||||
0505 | Please join the front eleven coaches of this train | Passenger information | ||||
0506 | Please join the front twelve coaches of this train | Passenger information | ||||
0507 | Please join the middle | Passenger information | ||||
0508 | Please join the middle coach only | Passenger information | ||||
0509 | Please join the middle coach only of this train | Passenger information | ||||
0510 | Vandalism | Reason | ||||
0511 | Please join the middle two coaches of this train | Passenger information | ||||
0512 | Please join the middle three coaches of this train | Passenger information | ||||
0513 | Please join the middle four coaches of this train | Passenger information | ||||
0514 | Please join the middle five coaches of this train | Passenger information | ||||
0515 | Please join the middle six coaches of this train | Passenger information | ||||
0516 | Please join the middle seven coaches of this train | Passenger information |
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 );