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 1,270
- Reason 336
- Passenger information 148
- Number 102
- Train operating company 72
- Platform information 67
- Time 66
- 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
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
- Train operating company 1
File | Transcription ▼ | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0819 | A landslip | Reason | ||||
0820 | A late departure while the train was cleaned specially | Reason | 👀 | |||
0821 | A late running freight train | Reason | ||||
0822 | A late running train being in front of this one | Reason | ||||
0823 | A lorry colliding with a bridge | Reason | ||||
0824 | A lorry colliding with a bridge earlier on this trains journey | Reason | ||||
0825 | A lorry colliding with a bridge earlier today | Reason | ||||
0826 | A low speed derailment | Reason | ||||
0827 | A member of on-train staff being taken ill | Reason | ||||
0828 | A passenger being taken ill at a station | Reason | ||||
0829 | A passenger being taken ill at a station earlier today | Reason | ||||
0830 | A passenger being taken ill on a train | Reason | ||||
0831 | A passenger being taken ill on a train earlier today | Reason | ||||
0832 | A passenger being taken ill on this train | Reason | ||||
0833 | A passenger being taken ill on this train earlier in its journey | Reason | ||||
0834 | A person being hit by a train | Reason | ||||
0835 | A person being hit by a train earlier | Reason | ||||
0382 | A points failure | Reason | ||||
0836 | A points failure | Reason | ||||
1536 | A points failure | Reason | ||||
0837 | A power cut at this station | Reason | ||||
0838 | A problem currently under investigation | Reason | ||||
0839 | A problem with a river bridge | Reason | Belter | 562 | ||
0841 | A problem with a river bridge earlier today | Reason | ||||
0842 | A problem with lineside equipment | Reason | ||||
0843 | A problem with the station lighting | Reason | ||||
0844 | A rail buckling in the heat | Reason | ||||
0845 | A railway embankment being damaged | Reason | ||||
0846 | A river flooding the railway | Reason | ||||
0847 | A river flooding the railway earlier today | Reason | ||||
0848 | A road accident at a level crossing | Reason | ||||
0849 | A road accident at a level crossing earlier today | Reason | ||||
0850 | A road accident at a level crossing yesterday | Reason | ||||
0852 | A road accident near the railway | Reason | ||||
0853 | A road accident near the railway earlier today | Reason | ||||
0854 | A road accident near the railway yesterday | Reason | ||||
0855 | A road vehicle blocking the railway | Reason | ||||
0856 | A road vehicle blocking the railway earlier on this train's journey | Reason | ||||
0857 | A road vehicle blocking the railway earlier today | Reason | ||||
0858 | A road vehicle colliding with a bridge | Reason | ||||
0859 | A road vehicle colliding with a bridge earlier on this train's journey | Reason | ||||
0860 | A road vehicle colliding with a bridge earlier today | Reason | ||||
0861 | A road vehicle colliding with level crossing barriers | Reason | ||||
0862 | A road vehicle colliding with level crossing barriers earlier today | Reason | ||||
0863 | A road vehicle colliding with level crossing barriers yesterday | Reason | ||||
0864 | A road vehicle damaging track at a level crossing | Reason | ||||
0865 | A road vehicle damaging track at a level crossing earlier today | Reason | ||||
0866 | A road vehicle damaging track at a level crossing yesterday | Reason | ||||
0867 | A safety inspection of the track | Reason | ||||
0868 | A safety inspection of the track earlier today | Reason | ||||
0869 | A safety inspection on a train | Reason | ||||
0870 | A safety inspection on a train earlier today | Reason | ||||
0871 | A safety inspection on this train | Reason | ||||
0872 | A safety inspection on this train earlier in its journey | Reason | ||||
1383 | A security alert | Reason | upward inflection | |||
1384 | A security alert | Reason | downward inflection | |||
0873 | A security alert at a station | Reason | ||||
0874 | A security alert earlier today | Reason | ||||
0875 | A security alert on another train | Reason | ||||
0876 | A security alert on this train | Reason | ||||
0877 | A shortage of on-train staff | Reason | ||||
0878 | A shortage of station staff | Reason | ||||
0879 | A shortage of train conductors | Reason | ||||
0880 | A shortage of train crew | Reason | ||||
0881 | A shortage of train drivers | Reason | ||||
0882 | A shortage of train guards | Reason | ||||
0883 | A shortage of train managers | Reason | ||||
0884 | A shortage of trains because of accident damage | Reason | ||||
0885 | A shortage of trains because of extra safety inspections | Reason | ||||
0886 | A shortage of trains because of vandalism | Reason | ||||
0887 | A shortage of trains following damage by snow and ice | Reason | ||||
0585 | A signalling apparatus failure | Reason | ||||
1658 | A signalling apparatus failure | Reason | ||||
0450 | A technical problem | Reason | ||||
0451 | A technical problem | Reason | ||||
0926 | A train derailment earlier today | Reason | ||||
0927 | A train derailment yesterday | Reason | ||||
0572 | A train failure | Reason | ||||
1638 | A train failure | Reason | ||||
0928 | A train hitting an obstruction on the line | Reason | ||||
0929 | A train hitting an obstruction on the line earlier on this train's journey | Reason | ||||
0930 | A train hitting an obstruction on the line earlier today | Reason | ||||
0931 | A train not stopping at a station it was supposed to | Reason | ||||
0932 | A train not stopping at a station it was supposed to earlier in its journey | Reason | ||||
0934 | A train not stopping at a station it was supposed to earlier today | Reason | ||||
0935 | A train not stopping in the correct position at a station | Reason | ||||
0936 | A train not stopping in the correct position at a station earlier in its journey | Reason | ||||
0937 | A train not stopping in the correct position at a station earlier today | Reason | ||||
0938 | A train's automatic braking system being activated | Reason | ||||
0939 | A train's automatic braking system being activated earlier in its journey | Reason | ||||
0940 | A train's automatic braking system being activated earlier today | Reason | ||||
0941 | A tree blocking the railway | Reason | ||||
0942 | A tree blocking the railway earlier on this train's journey | Reason | ||||
0943 | A tree blocking the railway earlier today | Reason | ||||
0002 | A trolley service | Passenger information | 0:00:02 | |||
0945 | A tunnel being closed for safety reasons | Reason | ||||
0946 | A wartime bomb near the railway | Reason | wat | 00:54:20 | ||
0947 | A wartime bomb near the railway earlier today | Reason | ||||
0948 | A wartime bomb near the railway yesterday | Reason | ||||
0949 | A wartime bomb which has now been made safe | Reason | thank god |
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 );