announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
1,271 rows where Category = "Destination" sorted by NRE_ID
This data as json, CSV (advanced)
Category 1
- Destination · 1,171 ✖
File | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID ▼ |
---|---|---|---|---|---|---|
0425 | Alloa | Destination | ALO | |||
1822 | Alexandria | Destination | ALX | |||
1860 | Anderston | Destination | AND | |||
1927 | Anderston | Destination | AND | |||
1985 | Anniesland | Destination | ANL | |||
2215 | Anniesland | Destination | ANL | |||
0584 | Annan | Destination | ANN | |||
1657 | Annan | Destination | ANN | |||
0588 | Appley Bridge | Destination | APB | |||
1662 | Appley Bridge | Destination | APB | |||
0587 | Appleby | Destination | APP | |||
1660 | Appleby | Destination | APP | |||
0589 | Arbroath | Destination | ARB | |||
1663 | Arbroath | Destination | ARB | |||
1861 | Ardgay | Destination | ARD | |||
1928 | Ardgay | Destination | ARD | |||
1991 | Arisaig | Destination | ARG | |||
2220 | Arisaig | Destination | ARG | |||
0593 | Arram | Destination | ARR | |||
1667 | Arram | Destination | ARR | |||
1992 | Arrochar & Tarbet | Destination | ART | |||
2221 | Arrochar & Tarbet | Destination | ART | |||
0268 | Ardrossan South Beach | Destination | ASB | |||
0415 | Ardrossan South Beach | Destination | ASB | |||
1989 | Ardrossan South Beach | Destination | ASB | |||
2218 | Ardrossan South Beach | Destination | ASB | |||
1863 | Ashfield | Destination | ASF | |||
1930 | Ashfield | Destination | ASF | |||
1823 | Alness | Destination | ASS | |||
1887 | Alness | Destination | ASS | |||
0598 | Attenborough | Destination | ATB | |||
1672 | Attenborough | Destination | ATB | |||
0596 | Atherton | Destination | ATN | |||
1670 | Atherton | Destination | ATN | |||
1993 | Attadale | Destination | ATT | |||
2222 | Attadale | Destination | ATT | |||
1987 | Ardlui | Destination | AUI | |||
2216 | Ardlui | Destination | AUI | |||
0600 | Auchinleck | Destination | AUK | |||
1674 | Auchinleck | Destination | AUK | |||
1489 | Aberdour | Destination | AUR | |||
1641 | Aberdour | Destination | AUR | |||
1453 | Aviemore | Destination | AVM | |||
1600 | Aviemore | Destination | AVM | |||
0591 | Armathwaite | Destination | AWT | |||
1665 | Armathwaite | Destination | AWT | |||
1886 | Alexandria | Destination | AXL | |||
2139 | Alexandra Parade | Destination | AXP | |||
2363 | Alexandra Parade | Destination | AXP | |||
0601 | Ayr | Destination | AYR | |||
1675 | Ayr | Destination | AYR | |||
1869 | Blairhill | Destination | BAI | |||
1935 | Blairhill | Destination | BAI | |||
0604 | Bamford | Destination | BAM | |||
1681 | Bamford | Destination | BAM | |||
0605 | Banbury | Destination | BAN | |||
1682 | Banbury | Destination | BAN | |||
0606 | Bare Lane | Destination | BAR | |||
1683 | Bare Lane | Destination | BAR | |||
1457 | Bishopbriggs | Destination | BBG | |||
1604 | Bishopbriggs | Destination | BBG | |||
0633 | Blackburn | Destination | BBN | |||
1721 | Blackburn | Destination | BBN | |||
0621 | Berry Brow | Destination | BBW | |||
1705 | Berry Brow | Destination | BBW | |||
0674 | Burscough Bridge | Destination | BCB | |||
1772 | Burscough Bridge | Destination | BCB | |||
1996 | Balloch | Destination | BCH | |||
2224 | Balloch | Destination | BCH | |||
1410 | Branchton | Destination | BCN | |||
2143 | Branchton | Destination | BCN | |||
2367 | Branchton | Destination | BCN | |||
0666 | Brockenhurst | Destination | BCU | |||
1760 | Brockenhurst | Destination | BCU | |||
1877 | Bridgeton | Destination | BDG | |||
1943 | Bridgeton | Destination | BDG | |||
0645 | Bradford Interchange | Destination | BDI | |||
1739 | Bradford Interchange | Destination | BDI | |||
0613 | Bedford | Destination | BDM | |||
1695 | Bedford | Destination | BDM | |||
0644 | Bradford Forster Square | Destination | BDQ | |||
1737 | Bradford Forster Square | Destination | BDQ | |||
0660 | Bridlington | Destination | BDT | |||
1746 | Bridlington | Destination | BDT | |||
0652 | Bredbury | Destination | BDY | |||
1742 | Bredbury | Destination | BDY | |||
1459 | Bridge of Allan | Destination | BEA | |||
1606 | Bridge of Allan | Destination | BEA | |||
0614 | Beeston | Destination | BEE | |||
1696 | Beeston | Destination | BEE | |||
0242 | Beauly | Destination | BEL | |||
0391 | Beauly | Destination | Low-pitch ending | BEL | ||
0616 | Bempton | Destination | BEM | |||
1698 | Bempton | Destination | BEM | |||
0619 | Bentham | Destination | BEN | |||
1702 | Bentham | Destination | BEN | |||
0624 | Bescar Lane | Destination | BES | |||
1708 | Bescar Lane | Destination | BES | |||
0625 | Beverley | Destination | BEV | |||
1711 | Beverley | Destination | BEV |
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 );