announcements

Table actions

Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette

1,271 rows where Category = "Destination"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Destination · 1,171 ✖
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
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    
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
0623 Berwick-upon-Tweed Destination     BWK
0624 Bescar Lane Destination     BES
0625 Beverley Destination     BEV
0626 Billingham Destination     BIL
0627 Bingley Destination     BIY
0628 Birchwood Destination     BWD
0630 Birmingham International Destination     BHI
0631 Birmingham New Street Destination     BHM
0632 Birmingham Destination      
0633 Blackburn Destination   BBN
0634 Blackpool North Destination     BPN
0635 Blackpool Pleasure Beach Destination     BPB
0636 Blackpool South Destination     BPS
0637 Edinburgh Park Destination     EDP
0638 Blackpool Destination      
0639 Blackrod Destination     BLK
0640 Bodmin Parkway Destination     BOD
0642 Bolton Destination     BON
0643 Bournemouth Destination     BMH
0644 Bradford Forster Square Destination     BDQ
0645 Bradford Interchange Destination     BDI
0646 Bramley Destination     BLE
0651 Branksome Destination     BSM
0652 Bredbury Destination     BDY
0655 Bridgend Destination     BGN

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "announcements" (
   [File] TEXT PRIMARY KEY,
   [Transcription] TEXT,
   [Category] TEXT,
   [mp3] TEXT,
   [Notes] TEXT,
   [Timestamp] TEXT,
   [NRE_ID] TEXT
);