announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Category
This data as json, CSV (advanced)
Category 5
- Train operating company 76
- Time 61
- Weather 30
- Train formation 14
- Train operating company 1
File | Transcription | Category ▼ | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0324 | 11 | Time | ||||
0325 | 12 | Time | ||||
0326 | 13 | Time | ||||
0327 | 14 | Time | ||||
0328 | 15 | Time | ||||
0330 | 16 | Time | ||||
0331 | 17 | Time | ||||
0332 | 18 | Time | ||||
0333 | 19 | Time | ||||
0334 | 20 | Time | ||||
0335 | 21 | Time | ||||
0336 | 22 | Time | ||||
0337 | 23 | Time | ||||
0338 | 24 | Time | ||||
0339 | 25 | Time | ||||
0341 | 26 | Time | ||||
0342 | 27 | Time | ||||
0343 | 28 | Time | ||||
0344 | 29 | Time | ||||
0345 | 30 | Time | ||||
0346 | 31 | Time | ||||
0347 | 32 | Time | ||||
0348 | 33 | Time | ||||
0349 | 34 | Time | ||||
0350 | 35 | Time | ||||
0352 | 36 | Time | ||||
0353 | 37 | Time | ||||
0354 | 38 | Time | ||||
0355 | 39 | Time | ||||
0356 | 40 | Time | ||||
0357 | 41 | Time | ||||
0358 | 42 | Time | ||||
0359 | 43 | Time | ||||
0360 | 44 | Time | ||||
0361 | 45 | Time | ||||
0365 | 46 | Time | ||||
0367 | 47 | Time | ||||
0368 | 48 | Time | ||||
0369 | 49 | Time | ||||
0370 | 50 | Time | ||||
0371 | 51 | Time | ||||
0372 | 52 | Time | ||||
0373 | 53 | Time | ||||
0374 | 54 | Time | ||||
0375 | 55 | Time | ||||
0377 | 56 | Time | ||||
0378 | 57 | Time | ||||
0379 | 58 | Time | ||||
0380 | 59 | Time | ||||
0381 | hundred hours | Time | ||||
1303 | o'clock | Time | ||||
1304 | 01 | Time | oh-one | |||
1305 | 02 | Time | oh-two | |||
1306 | 03 | Time | oh-three | |||
1307 | 04 | Time | oh-four | |||
1308 | 05 | Time | oh-five | |||
1309 | 06 | Time | oh-six | |||
1310 | 07 | Time | oh-seven | |||
1311 | 08 | Time | oh-eight | |||
1312 | 09 | Time | oh-nine | |||
1446 | minutes. | Time | end of sentence | |||
0177 | This train is formed of 1 coach only | Train formation | ||||
0178 | This train is formed of 2 coaches | Train formation | ||||
0179 | This train is formed of 3 coaches | Train formation | ||||
0180 | This train is formed of 4 coaches | Train formation | ||||
0181 | This train is formed of 5 coaches | Train formation | ||||
0182 | This train is formed of 6 coaches | Train formation | ||||
0183 | This train is formed of 7 coaches | Train formation | ||||
0184 | This train is formed of 8 coaches | Train formation | ||||
0185 | This train is formed of 9 coaches | Train formation | ||||
0186 | This train is formed of 10 coaches | Train formation | ||||
0187 | This train is formed of 11 coaches | Train formation | ||||
0188 | This train is formed of 12 coaches | Train formation | ||||
1730 | This train is formed of | Train formation | ||||
1815 | This train is formed of one coach only | Train formation | ||||
0004 | South West Trains service to | Train operating company | Bit of a detour | 0:00:07 | ||
0005 | South West Trains service to | Train operating company | 0:00:10 | |||
0007 | Midland Main Line | Train operating company | Stopped existing in 2007! | 0:00:16 | ||
0008 | Midland Main Line service to | Train operating company | 0:00:19 | |||
0009 | Midland Main Line service from | Train operating company | 0:00:22 | |||
0032 | ScotRail | Train operating company | ||||
0034 | ScotRail service from | Train operating company | ||||
0095 | ScotRail services to | Train operating company | ||||
0096 | ScotRail service from | Train operating company | ||||
0198 | Southern | Train operating company | if you hear this the train is very lost :( | |||
0199 | Southern service to | Train operating company | ||||
0200 | Southern service from | Train operating company | ||||
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 | ||||
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 | ||||
0388 | First Capital Connect | Train operating company |
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 );