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,199
- Reason 419
- Passenger information 139
- Number 102
- Time 61
- Conjoining 56
- Train operating company 52
- Weather 30
- Special train 12
- Platform information 8
- Apology 6
- Fare information 6
- Heritage Railway 6
- Platform ID 6
- Number combo 4
- Safety 3
- Non-vocal 2
- Request stop 2
- Train formation 2
- Operational 1
- Station 1
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0324 | 11 | Time | ||||
0325 | 12 | Time | ||||
0326 | 13 | Time | ||||
0327 | 14 | Time | ||||
0328 | 15 | Time | ||||
0329 | delayed | Conjoining | ||||
0330 | 16 | Time | ||||
0331 | 17 | Time | ||||
0332 | 18 | Time | ||||
0333 | 19 | Time | ||||
0334 | 20 | Time | ||||
0335 | 21 | Time | ||||
0336 | 22 | Time | ||||
0337 | 23 | Time | ||||
0338 | 24 | Time | ||||
0339 | 25 | Time | ||||
0340 | has been cancelled | Conjoining | ||||
0341 | 26 | Time | ||||
0342 | 27 | Time | ||||
0343 | 28 | Time | ||||
0344 | 29 | Time | ||||
0345 | 30 | Time | ||||
0346 | 31 | Time | ||||
0347 | 32 | Time | ||||
0348 | 33 | Time | ||||
0349 | 34 | Time | ||||
0350 | 35 | Time | ||||
0351 | is available on this train | Passenger information | ||||
0352 | 36 | Time | ||||
0353 | 37 | Time | ||||
0354 | 38 | Time | ||||
0355 | 39 | Time | ||||
0356 | 40 | Time | ||||
0357 | 41 | Time | ||||
0358 | 42 | Time | ||||
0359 | 43 | Time | ||||
0360 | 44 | Time | ||||
0361 | 45 | Time | ||||
0362 | Gartcosh | Destination | Low-pitch ending | GRH | ||
0363 | Bodmin | Destination | Low-pitch ending | |||
0364 | Corby | Destination | Low-pitch ending | COR | ||
0365 | 46 | Time | ||||
0366 | St. Pancras International | Destination | Low-pitch ending | STP | ||
0367 | 47 | Time | ||||
0368 | 48 | Time | ||||
0369 | 49 | Time | ||||
0370 | 50 | Time | ||||
0371 | 51 | Time | ||||
0372 | 52 | Time | ||||
0373 | 53 | Time | ||||
0374 | 54 | Time | ||||
0375 | 55 | Time | ||||
0376 | a staff shortage | Reason | ||||
0377 | 56 | Time | ||||
0378 | 57 | Time | ||||
0379 | 58 | Time | ||||
0380 | 59 | Time | ||||
0381 | hundred hours | Time | ||||
0382 | A points failure | Reason | ||||
0383 | Platform A | Platform ID | ||||
0384 | Platform B | Platform ID | ||||
0385 | Platform C | Platform ID | ||||
0386 | Platform D | Platform ID | ||||
0387 | Signalling difficulties | Reason | ||||
0388 | First Capital Connect | Train operating company | ||||
0389 | The late arrival of an incoming train | Reason | ||||
0390 | Barry Links | Destination | Low-pitch ending | BYL | ||
0391 | Beauly | Destination | Low-pitch ending | BEL | ||
0392 | Brunstane | Destination | Low-pitch ending | BSU | ||
0393 | Central | Destination | Low-pitch ending | |||
0394 | Dunfermline Queen Margaret | Destination | Low-pitch ending | DFL | ||
0395 | Dunfermline Town | Destination | Low-pitch ending | DFE | ||
0396 | Dunoon | Destination | Ferry | |||
0397 | Exhibition Centre | Destination | EXG | |||
0398 | Georgemas | Destination | GGJ | |||
0399 | Gilshochill | Destination | GSC | |||
0400 | Greenfaulds | Destination | GRL | |||
0401 | Hamilton West | Destination | HNW | |||
0402 | Hawkhead | Destination | HKH | |||
0403 | High Street | Destination | HST | |||
0404 | Loch Awe | Destination | LHA | |||
0405 | Newcraighall | Destination | NEW | |||
0406 | Newton | Destination | NTN | |||
0407 | Queen Street | Destination | GLQ | |||
0408 | Rannoch | Destination | end of sentence | RAN | ||
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 | |||
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 |
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 );