announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows
This data as json, CSV (advanced)
Category 21
- Destination 1,267
- Reason 419
- Passenger information 139
- Number 102
- Time 96
- Train operating company 64
- Conjoining 59
- Weather 30
- Special train 12
- Platform information 9
- Safety 7
- Apology 6
- Fare information 6
- Heritage Railway 6
- Platform ID 6
- Number combo 4
- Non-vocal 2
- Request stop 2
- Train formation 2
- Operational 1
- Station 1
Timestamp 4 ✖
- - 2,237
- 1
- 00:54:20 1
- https://matteason.github 1
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0201 | Southeastern Trains | Train operating company | ||||
0202 | Southeastern Trains | Train operating company | Low-pitch ending | |||
0203 | Southeastern Trains service to | Train operating company | ||||
0204 | Southeastern Trains service from | Train operating company | ||||
0205 | Southeastern | Train operating company | ||||
0206 | Southeastern service to | Train operating company | ||||
0207 | Southeastern service from | Train operating company | ||||
0208 | Attention please! Please leave the station immediately. | Safety | Male voice (quieter) | |||
0209 | Attention please! Please leave the station immediately. | Safety | Male voice | |||
0210 | Attention please! Please leave the station immediately. | Safety | Male voice | |||
0211 | Attention please! Please leave the station immediately. | Safety | Male voice (louder) | |||
0212 | Southampton Central | Destination | SOU | |||
0213 | Southern | Train operating company | Low-pitch ending | |||
0214 | Southeastern | Train operating company | Low-pitch ending | |||
0215 | First Great Western | Train operating company | ||||
0216 | First Great Western service to | Train operating company | ||||
0217 | First Great Western service from | Train operating company | ||||
0218 | Stafford | Destination | STA | |||
0219 | Starcross | Destination | SCS | |||
0220 | is available | Conjoining | ||||
0221 | Trowbridge | Destination | TRO | |||
0222 | Gartcosh | Destination | GRH | |||
0223 | Bodmin | Destination | ||||
0224 | Corby | Destination | COR | |||
0225 | St Pancras International | Destination | STP | |||
0226 | Wilmslow | Destination | WML | |||
0227 | Should change here | Conjoining | ||||
0228 | Southampton Airport Parkway | Destination | SOA | |||
0229 | This is a platform alteration | Platform information | ||||
0230 | Midnight | Time | ||||
0231 | 01 | Time | oh-one | |||
0232 | 02 | Time | oh-two | |||
0233 | 03 | Time | oh-three | |||
0234 | 04 | Time | oh-four | |||
0235 | 05 | Time | oh-five | |||
0236 | 06 | Time | oh-six | |||
0237 | 07 | Time | oh-seven | |||
0238 | 08 | Time | oh-eight | |||
0239 | 09 | Time | oh-nine | |||
0240 | 10 | Time | ||||
0241 | Barry Links | Destination | BYL | |||
0242 | Beauly | Destination | BEL | |||
0243 | Brunstane | Destination | BSU | |||
0244 | Central | Destination | ||||
0245 | Dunfermline Queen Margaret | Destination | DFL | |||
0246 | Dunfermline Town | Destination | DFE | |||
0247 | Dunoon | Destination | Ferry | |||
0248 | 11 | Time | ||||
0249 | Exhibition Centre | Destination | EXG | |||
0250 | Georgemas | Destination | GGJ | |||
0251 | Gilshochill | Destination | GSC | |||
0252 | Greenfaulds | Destination | GRL | |||
0253 | Hamilton West | Destination | HNW | |||
0254 | Hawkhead | Destination | HKH | |||
0255 | High Street | Destination | HST | |||
0256 | Loch Awe | Destination | LHA | |||
0257 | Newcraighall | Destination | NEW | |||
0258 | Newton | Destination | NTN | |||
0259 | 12 | Time | ||||
0260 | Queen Street | Destination | Glasgow | GLQ | ||
0261 | Rannoch | Destination | mid-sentence | RAN | ||
0262 | Kingsknowe | Destination | KGE | |||
0263 | Stromeferry | Destination | STF | |||
0264 | Glasgow Central Low Level | Destination | GLC | |||
0265 | Glasgow Queen Street Low Level | Destination | GLQ | |||
0266 | Newton (Lanarkshire) | Destination | NTN | |||
0267 | Ardrossan Harbour | Destination | ADS | |||
0268 | Ardrossan South Beach | Destination | ASB | |||
0269 | Ardrossan Town | Destination | ADN | |||
0270 | 13 | Time | ||||
0271 | Brampton (Cumbria) | Destination | BMP | |||
0272 | Cumbrae Slip | Destination | Ferry | |||
0273 | Kirkconnel | Destination | KRK | |||
0274 | 14 | Time | ||||
0275 | 15 | Time | ||||
0276 | 16 | Time | ||||
0277 | 17 | Time | ||||
0278 | 18 | Time | ||||
0279 | East Midlands Airport | Destination | Non-rail | |||
0280 | Kelvindale | Destination | KVD | |||
0281 | Merryton | Destination | MEY | |||
0282 | Larkhall | Destination | LRH | |||
0283 | Chatelherault | Destination | CTE | |||
0284 | Alloa | Destination | ALO | |||
0285 | 19 | Time | ||||
0286 | Shawfair | Destination | SFI | |||
0287 | Eskbank | Destination | EKB | |||
0288 | Newtongrange | Destination | NEG | |||
0289 | Gorebridge | Destination | GBG | |||
0290 | Galashiels | Destination | GAL | |||
0291 | 20 | Time | ||||
0292 | Tweedbank | Destination | TWB | |||
0293 | Edinburgh Airport | Destination | Non-rail | |||
0294 | Edinburgh International Airport | Destination | Non-rail | |||
0295 | 21 | Time | ||||
0296 | Abbey Road | Destination | DLR | |||
0297 | 22 | Time | ||||
0298 | 23 | Time | ||||
0299 | clock | Time | ||||
0300 | 01 | Time | oh-one |
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 );