announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Transcription
This data as json, CSV (advanced)
Category 22
- Destination 563
- Reason 176
- Passenger information 122
- Number 102
- Platform information 67
- Time 61
- Train operating company 53
- Conjoining 52
- Train formation 14
- Weather 14
- Special train 12
- Safety 10
- Operational 9
- Platform ID 7
- Heritage Railway 6
- Apology 5
- Fare information 3
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
- Train operating company 1
File | Transcription ▼ | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0115 | Is delayed by approximately 30 minutes | Time | ||||
0116 | Is delayed by approximately 35 minutes | Time | ||||
0117 | Is delayed by approximately 40 minutes | Time | ||||
0118 | Is delayed by approximately 45 minutes | Time | ||||
0110 | Is delayed by approximately 5 minutes | Time | ||||
0119 | Is delayed by approximately 50 minutes | Time | ||||
0120 | Is delayed by approximately 55 minutes | Time | ||||
1676 | Is the | Conjoining | ||||
1677 | Is the delayed | Conjoining | ||||
1567 | Johnstone | Destination | JHN | |||
1419 | Johnstone | Destination | JHN | |||
2054 | Jordanhill | Destination | JOR | |||
2279 | Jordanhill | Destination | JOR | |||
1370 | Keith | Destination | KEH | |||
1542 | Keith | Destination | KEH | |||
0280 | Kelvindale | Destination | KVD | |||
0421 | Kelvindale | Destination | KVD | |||
0912 | Kennishead | Destination | KNS | |||
1901 | Kennishead | Destination | KNS | |||
0933 | Kidderminster | Destination | KID | |||
1904 | Kidderminster | Destination | KID | |||
2055 | Kilcreggan | Destination | For ferry from Gourock | |||
2280 | Kilcreggan | Destination | For ferry from Gourock | |||
2056 | Kildonan | Destination | KIL | |||
2282 | Kildonan | Destination | KIL | |||
0944 | Kilmarnock | Destination | Kilmarnock is a valid reason for a rail service issue | KMK | ||
1905 | Kilmarnock | Destination | KMK | |||
0955 | Kilmaurs | Destination | KLM | |||
1906 | Kilmaurs | Destination | KLM | |||
2208 | Kilpatrick | Destination | KPT | |||
2437 | Kilpatrick | Destination | KPT | |||
2057 | Kilwinning | Destination | KWN | |||
2152 | Kilwinning | Destination | KWN | |||
2283 | Kilwinning | Destination | KWN | |||
2375 | Kilwinning | Destination | KWN | |||
2058 | Kinbrace | Destination | KBC | |||
2284 | Kinbrace | Destination | KBC | |||
2059 | King's Park | Destination | KGP | |||
2285 | King's Park | Destination | KGP | |||
1425 | Kinghorn | Destination | KGH | |||
1573 | Kinghorn | Destination | KGH | |||
0262 | Kingsknowe | Destination | KGE | |||
0409 | Kingsknowe | Destination | KGE | |||
1426 | Kingsknowe | Destination | KGE | |||
1574 | Kingsknowe | Destination | KGE | |||
0722 | Kingussie | Destination | KIN | |||
1405 | Kingussie | Destination | KIN | |||
1161 | Kintore | Destination | KTR | |||
1216 | Kintore | Destination | KTR | |||
0996 | Kirkcaldy | Destination | KDY | |||
1907 | Kirkcaldy | Destination | KDY | |||
0273 | Kirkconnel | Destination | KRK | |||
0419 | Kirkconnel | Destination | KRK | |||
2060 | Kirkhill | Destination | KKH | |||
2286 | Kirkhill | Destination | KKH | |||
1427 | Kirknewton | Destination | KKN | |||
1428 | Kirknewton | Destination | KKN | |||
1575 | Kirknewton | Destination | KKN | |||
1576 | Kirknewton | Destination | KKN | |||
2209 | Kirknewton | Destination | KKN | |||
2438 | Kirknewton | Destination | KKN | |||
2061 | Kirkwood | Destination | KWD | |||
2287 | Kirkwood | Destination | KWD | |||
0599 | Kirton Lindsey | Destination | KTL | |||
1673 | Kirton Lindsey | Destination | KTL | |||
2063 | Kyle of Lochalsh | Destination | KYL | |||
2289 | Kyle of Lochalsh | Destination | KYL | |||
1087 | Ladybank | Destination | LDY | |||
1909 | Ladybank | Destination | LDY | |||
2064 | Lairg | Destination | LRG | |||
2290 | Lairg | Destination | LRG | |||
2065 | Lanark | Destination | LNK | |||
2291 | Lanark | Destination | LNK | |||
1098 | Lancaster | Destination | LAN | |||
1910 | Lancaster | Destination | LAN | |||
2066 | Langbank | Destination | LGB | |||
2292 | Langbank | Destination | LGB | |||
2067 | Langside | Destination | LGS | |||
2293 | Langside | Destination | LGS | |||
1430 | Larbert | Destination | LBT | |||
1578 | Larbert | Destination | LBT | |||
2069 | Largs | Destination | LAR | |||
2295 | Largs | Destination | LAR | |||
0282 | Larkhall | Destination | LRH | |||
0423 | Larkhall | Destination | LRH | |||
1447 | Laurencekirk | Destination | LAU | |||
1594 | Laurencekirk | Destination | LAU | |||
1149 | Leamington Spa | Destination | LMS | |||
1912 | Leamington Spa | Destination | LMS | |||
1160 | Leeds | Destination | LDS | |||
1913 | Leeds | Destination | LDS | |||
1170 | Leicester | Destination | LEI | |||
1914 | Leicester | Destination | LEI | |||
1431 | Lenzie | Destination | LNZ | |||
1579 | Lenzie | Destination | LNZ | |||
1178 | Leuchars | Destination | LEU | |||
1915 | Leuchars | Destination | LEU | |||
1034 | Lightning damaging a station | Weather | ||||
1035 | Lightning damaging a train | Weather | ||||
1036 | Lightning damaging equipment | Weather |
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 );