announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows
This data as json, CSV (advanced)
Category 21
- Destination 1,171
- Reason 415
- Passenger information 138
- Number 102
- Conjoining 54
- Train operating company 51
- Weather 30
- Special train 12
- Time 11
- Platform information 8
- Apology 6
- Fare information 6
- Heritage Railway 6
- Number combo 4
- Safety 3
- Non-vocal 2
- Platform ID 2
- Request stop 2
- Train formation 2
- Operational 1
- Station 1
Timestamp 4 ✖
- - 2,024
- 1
- 00:54:20 1
- https://matteason.github 1
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0414 | Ardrossan Harbour | Destination | ADS | |||
0415 | Ardrossan South Beach | Destination | ASB | |||
0416 | Ardrossan Town | Destination | ADN | |||
0417 | Brampton (Cumbria) | Destination | BMP | |||
0418 | Cumbrae Slip | Destination | Ferry | |||
0419 | Kirkconnel | Destination | KRK | |||
0420 | East Midlands Airport | Destination | Non-rail | |||
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 | |||
0433 | Edinburgh Airport | Destination | Non-rail | |||
0434 | Edinburgh International Airport | Destination | https://github.com/matteason/scotrail-announcements-june-2022/raw/main/announcements/ | Non-rail | ||
0435 | Abbey Road | Destination | DLR | |||
0436 | Liverpool South Parkway | Destination | LPY | |||
0437 | Liverpool South | Destination | ||||
0438 | Edinburgh International | Destination | Proposed | |||
0439 | Falmouth | Destination | FMT | |||
0440 | Folkestone Racecourse | Destination | Non-rail | |||
0441 | Racecourse | Destination | Possibly for combining with racecourse town names? | |||
0442 | Ratcliffe-on-Soar | Destination | Non-rail | |||
0443 | Shepherds Bush | Destination | SPH | |||
0444 | Stirling | Destination | STG | |||
0445 | Stratford High Street | Destination | DLR | |||
0446 | Stratford International | Destination | SFA | |||
0447 | Westenhanger Racecourse | Destination | Station closed in 1960s! | WHA | ||
0448 | White City | Destination | London Underground | |||
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 | ||||
0478 | The Bluebell Railway | Heritage Railway | stepney is sad and lost | |||
0479 | The Bluebell Railway | Heritage Railway | the profesionals at firewatch | |||
0480 | The Watercress Line | Heritage Railway | ||||
0481 | The Watercress Line | Heritage Railway | ||||
0482 | The Spa Valley Railway | Heritage Railway | Sussex has been taken over by Scotland | |||
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 |
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 );