announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
1,271 rows where Category = "Destination" sorted by Notes
This data as json, CSV (advanced)
File | Transcription | Category | mp3 | Notes ▼ | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0266 | Newton (Lanarkshire) | Destination | NTN | |||
0267 | Ardrossan Harbour | Destination | ADS | |||
0268 | Ardrossan South Beach | Destination | ASB | |||
0269 | Ardrossan Town | Destination | ADN | |||
0271 | Brampton (Cumbria) | Destination | BMP | |||
0273 | Kirkconnel | Destination | KRK | |||
0280 | Kelvindale | Destination | KVD | |||
0281 | Merryton | Destination | MEY | |||
0282 | Larkhall | Destination | LRH | |||
0283 | Chatelherault | Destination | CTE | |||
0284 | Alloa | Destination | ALO | |||
0286 | Shawfair | Destination | SFI | |||
0287 | Eskbank | Destination | EKB | |||
0288 | Newtongrange | Destination | NEG | |||
0289 | Gorebridge | Destination | GBG | |||
0290 | Galashiels | Destination | GAL | |||
0292 | Tweedbank | Destination | TWB | |||
0304 | Liverpool South Parkway | Destination | LPY | |||
0305 | Liverpool South | Destination | ||||
0306 | Falmouth | Destination | FMT | |||
0311 | Shepherd's Bush | Destination | SPH | |||
0314 | Stratford International | Destination | SFA | |||
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 | |||
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 | |||
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 | |||
0578 | Aberdeen | Destination | ABD | |||
0579 | Accrington | Destination | ACR | |||
0580 | Adlington | Destination | ADC | |||
0581 | Alnmouth | Destination | ALM | |||
0582 | Althorpe | Destination | ALN | |||
0583 | Cheadle Hulme | Destination | CHU | |||
0584 | Annan | Destination | ANN | |||
0586 | Ansdell & Fairhaven | Destination | AFV | |||
0587 | Appleby | Destination | APP | |||
0588 | Appley Bridge | Destination | APB | |||
0589 | Arbroath | Destination | ARB | |||
0590 | Ardwick | Destination | ADK | |||
0591 | Armathwaite | Destination | AWT | |||
0592 | Goostrey | Destination | GTR | |||
0593 | Arram | Destination | ARR | |||
0594 | Ashburys | Destination | ABY | |||
0595 | Ashton-under-Lyne | Destination | AHN | |||
0596 | Atherton | Destination | ATN | |||
0598 | Attenborough | Destination | ATB | |||
0599 | Kirton Lindsey | Destination | KTL | |||
0600 | Auchinleck | Destination | AUK | |||
0601 | Ayr | Destination | AYR | |||
0602 | Baildon | Destination | BLD | |||
0603 | Bamber Bridge | Destination | BMB | |||
0604 | Bamford | Destination | BAM | |||
0605 | Banbury | Destination | BAN | |||
0606 | Bare Lane | Destination | BAR | |||
0607 | Barnetby | Destination | BTB | |||
0609 | Barnsley | Destination | BNY | |||
0610 | Barrhead | Destination | BRR | |||
0611 | Barrhill | Destination | BRL | |||
0612 | Basingstoke | Destination | BSK | |||
0613 | Bedford | Destination | BDM | |||
0614 | Beeston | Destination | BEE | |||
0615 | Belle Vue | Destination | BLV | |||
0616 | Bempton | Destination | BEM | |||
0617 | Ben Rhydding | Destination | BEY | |||
0619 | Bentham | Destination | BEN | |||
0620 | Bentley | Destination | BYK | |||
0621 | Berry Brow | Destination | BBW | |||
0622 | Berwick | Destination | BRK |
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 );