announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
1,271 rows where Category = "Destination"
This data as json, CSV (advanced)
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0659 | Bridgwater | Destination | BWT | |||
0660 | Bridlington | Destination | BDT | |||
0661 | Brighton | Destination | BTN | |||
0662 | Brighouse | Destination | BGH | |||
0663 | Bristol Parkway | Destination | BPW | |||
0664 | Bristol Temple Meads | Destination | BRI | |||
0665 | Broad Green | Destination | BGE | |||
0666 | Brockenhurst | Destination | BCU | |||
0667 | Bugle | Destination | BGL | |||
0670 | Burnage | Destination | BNA | |||
0671 | Burneside | Destination | BUD | |||
0672 | Manchester Oxford Road | Destination | MCO | |||
0673 | Burnley Transpennine | Destination | What does this mean? lmao | |||
0674 | Burscough Bridge | Destination | BCB | |||
0675 | Burton-on-Trent | Destination | BUT | |||
0676 | Bury St Edmunds | Destination | BSE | |||
0677 | Camborne | Destination | CBN | |||
0678 | Cambridge | Destination | CBG | |||
0679 | Cardiff | Destination | start | |||
0681 | Cardiff Bute Road | Destination | Renamed in 1994 | CDB | ||
0682 | Cardiff Central | Destination | CDF | |||
0683 | Cardiff Queen Street | Destination | CDQ | |||
0684 | Cark | Destination | CAK | |||
0685 | Carlisle | Destination | CAR | |||
0686 | Carnoustie | Destination | neutral inflex | CAN | ||
0687 | Carstairs | Destination | CRS | |||
0688 | Cheltenham Spa | Destination | CNM | |||
0689 | Cherry Tree | Destination | CYT | |||
0690 | Chester | Destination | CTR | |||
0691 | Chesterfield | Destination | CHD | |||
0692 | Chester-le-Street | Destination | CLS | |||
0693 | Chinley | Destination | CLY | |||
0694 | Chorley | Destination | CRL | |||
0695 | Church Fenton | Destination | CHF | |||
0696 | Church and Oswaldtwistle | Destination | CTW | |||
0697 | Coventry | Destination | end | COV | ||
0698 | Crewe | Destination | end | CRE | ||
0699 | Crossmyloof | Destination | end | CMY | ||
0700 | Cupar | Destination | end | CUP | ||
0701 | Darlington | Destination | end | DAR | ||
0702 | Dawlish | Destination | end | DWL | ||
0703 | Dawlish Warren | Destination | end | DWW | ||
0704 | Derby | Destination | end | DBY | ||
0705 | Conon Bridge | Destination | CBD | |||
0706 | ...Edinburgh Gateway... | Destination | EGY | |||
0707 | Stow... | Destination | SOI | |||
0712 | Doncaster | Destination | DON | |||
0713 | Dumfries | Destination | DMF | |||
0714 | Dunbar | Destination | DUN | |||
0715 | Dundee | Destination | DEE | |||
0716 | Dunlop | Destination | DNL | |||
0717 | Durham | Destination | DHM | |||
0718 | Edinburgh | Destination | ||||
0719 | Exeter St Davids | Destination | EXD | |||
0720 | Falkirk High | Destination | FKK | |||
0721 | Falkirk Grahamston | Destination | FKG | |||
0722 | Kingussie | Destination | KIN | |||
0724 | Girvan | Destination | GIR | |||
0725 | Glasgow Central | Destination | GLC | |||
0726 | Glasgow Queen Street | Destination | GLQ | |||
0727 | Grantham | Destination | GRA | |||
0728 | Gretna Green | Destination | GEA | |||
0729 | Hale | Destination | HAL | |||
0730 | Haymarket | Destination | HYM | |||
0731 | Heald Green | Destination | HDG | |||
0732 | Hebden Bridge | Destination | HBD | |||
0733 | Conon Bridge | Destination | CBD | |||
0734 | Edinburgh Gateway | Destination | EGY | |||
0735 | Stow | Destination | SOI | |||
0737 | Hull | Destination | HUL | |||
0758 | Huntingdon | Destination | HUN | |||
0769 | Hunts Cross | Destination | HNX | |||
0840 | Inverkeithing | Destination | INK | |||
0851 | Inverness | Destination | why is this in the middle. so weird. | INV | ||
0912 | Kennishead | Destination | KNS | |||
0933 | Kidderminster | Destination | KID | |||
0944 | Kilmarnock | Destination | Kilmarnock is a valid reason for a rail service issue | KMK | ||
0955 | Kilmaurs | Destination | KLM | |||
0996 | Kirkcaldy | Destination | KDY | |||
1087 | Ladybank | Destination | LDY | |||
1098 | Lancaster | Destination | LAN | |||
1149 | Leamington Spa | Destination | LMS | |||
1160 | Leeds | Destination | LDS | |||
1161 | Kintore | Destination | KTR | |||
1170 | Leicester | Destination | LEI | |||
1178 | Leuchars | Destination | LEU | |||
1179 | Liskeard | Destination | LSK | |||
1180 | Liverpool Lime Street | Destination | LIV | |||
1181 | Lockerbie | Destination | LOC | |||
1182 | London Euston | Destination | EUS | |||
1183 | London King's Cross | Destination | KGX | |||
1184 | London Marylebone | Destination | MYB | |||
1185 | London Moorgate | Destination | MOG | |||
1186 | London Paddington | Destination | PAD | |||
1187 | London St. Pancras | Destination | STP | |||
1188 | Lostwithiel | Destination | LOS | |||
1189 | Manchester Airport | Destination | MIA | |||
1190 | Manchester Oxford Road | Destination | MCO | |||
1191 | Manchester Piccadilly | Destination | MAN | |||
1192 | Manchester Victoria | Destination | MCV |
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 );