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 23
- Destination 1,270
- Reason 354
- Passenger information 149
- Time 143
- Number 102
- Train operating company 72
- Platform information 67
- Conjoining 61
- Weather 29
- Safety 15
- Train formation 14
- Special train 12
- Operational 10
- Apology 8
- Fare information 7
- Platform ID 7
- Heritage Railway 6
- Number combo 4
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
- Train operating company 1
File | Transcription ▼ | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0237 | 07 | Time | oh-seven | |||
0320 | 07 | Time | oh-seven | |||
1310 | 07 | Time | oh-seven | |||
0238 | 08 | Time | oh-eight | |||
0321 | 08 | Time | oh-eight | |||
1311 | 08 | Time | oh-eight | |||
0239 | 09 | Time | oh-nine | |||
0322 | 09 | Time | oh-nine | |||
1312 | 09 | Time | oh-nine | |||
1957 | 1, 2, 3 | Number combo | ||||
0240 | 10 | Time | ||||
0323 | 10 | Time | ||||
0134 | 10 minutes | Time | ||||
0248 | 11 | Time | ||||
0324 | 11 | Time | ||||
0259 | 12 | Time | ||||
0325 | 12 | Time | ||||
0136 | 12 minutes | Time | ||||
0270 | 13 | Time | ||||
0326 | 13 | Time | ||||
0274 | 14 | Time | ||||
0327 | 14 | Time | ||||
0275 | 15 | Time | ||||
0328 | 15 | Time | ||||
0276 | 16 | Time | ||||
0330 | 16 | Time | ||||
0277 | 17 | Time | ||||
0331 | 17 | Time | ||||
0278 | 18 | Time | ||||
0332 | 18 | Time | ||||
0285 | 19 | Time | ||||
0333 | 19 | Time | ||||
0291 | 20 | Time | ||||
0334 | 20 | Time | ||||
0295 | 21 | Time | ||||
0335 | 21 | Time | ||||
0297 | 22 | Time | ||||
0336 | 22 | Time | ||||
0298 | 23 | 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 | ||||
1960 | 4, 5, 6 | Number combo | ||||
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 | ||||
0133 | 5 minutes | 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 | ||||
0135 | 7 minutes | Time | ||||
1972 | 7, 8 | Number combo | ||||
1980 | 9, 10 | Number combo | ||||
0801 | A fire at a station | Reason | ||||
0802 | A fire at a station earlier | Reason | ||||
0803 | A fire near the railway involving gas cylinders | Reason | ||||
0804 | A fire near the railway involving gas cylinders earlier today | Reason | ||||
0805 | A fire near the railway involving gas cylinders yesterday | Reason | ||||
0806 | A fire near the railway suspected to involve gas cylinders | Reason | ||||
0807 | A fire near the railway suspected to involve gas cylinders earlier today | Reason | ||||
0808 | A fire near the railway suspected to involve gas cylinders yesterday | Reason | so specific; lazy should do one for each day of the week. | |||
0809 | A fire next to the track | Reason | ||||
0810 | A fire next to the track earlier today | Reason | ||||
0811 | A fire on a train | Reason | ||||
0812 | A fire on a train earlier today | Reason | ||||
0813 | A fire on property near the railway | Reason | ||||
0814 | A fire on property near the railway earlier today | Reason | ||||
0815 | A fire on property near the railway yesterday | Reason | ||||
1520 | A further announcement will be made when this... | Passenger information | ||||
0816 | A gas leak near the railway | Reason | ||||
0817 | A gas leak near the railway earlier today | Reason | ||||
0818 | A gas leak near the railway yesterday | Reason |
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 );