announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by NRE_ID
This data as json, CSV (advanced)
Category 21
- Destination 1,245
- Reason 414
- 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
File | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID ▼ |
---|---|---|---|---|---|---|
0440 | Folkestone Racecourse | Destination | Non-rail | |||
0441 | Racecourse | Destination | Possibly for combining with racecourse town names? | |||
0442 | Ratcliffe-on-Soar | Destination | Non-rail | |||
0445 | Stratford High Street | Destination | DLR | |||
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 | ||||
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 | ||||
0517 | Please join the middle eight coaches of this train | Passenger information | ||||
0518 | Please join the middle nine coaches of this train | Passenger information | ||||
0519 | Please join the middle ten coaches of this train | Passenger information | ||||
0520 | Please join the middle eleven coaches of this train | Passenger information | ||||
0521 | Please join the middle twelve coaches of this train | Passenger information | How long does a train have to be in total to have twelve middle coaches? - 14 coaches! | |||
0522 | Please join the rear coach of this train | Passenger information | ||||
0523 | Please join the rear coach only of this train | Passenger information | ||||
0524 | Please join the rear two coaches of this train | Passenger information | ||||
0525 | Please join the rear three coaches of this train | Passenger information | ||||
0526 | Please join the rear four coaches of this train | Passenger information | ||||
0527 | Please join the rear five coaches of this train | Passenger information | ||||
0528 | Please join the rear six coaches of this train | Passenger information | ||||
0529 | Please join the rear seven coaches of this train | Passenger information | ||||
0530 | Please join the rear eight coaches of this train | Passenger information | ||||
0531 | Please join the rear nine coaches of this train | Passenger information | ||||
0532 | Please join the rear ten coaches of this train | Passenger information | ||||
0533 | Please join the rear eleven coaches of this train | Passenger information | ||||
0534 | Please join the rear twelve coaches of this train | Passenger information | ||||
0535 | Megatrain accommodation can be found at the | Passenger information | ||||
0536 | Front | Passenger information | ||||
0537 | Middle | Passenger information | ||||
0538 | Rear | Passenger information | ||||
0539 | Of the train | Passenger information | ||||
0540 | Megatrain accomodation can be found at the front of the train | Passenger information | ||||
0541 | Megatrain accomodation can be found in the middle of the train | Passenger information | ||||
0542 | Megatrain accomodation can be found at the rear of the train | Passenger information | ||||
0543 | First class accommodation is available | 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 );