announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
421 rows where Category = "Reason"
This data as json, CSV (advanced)
Transcription >30 ✖
- A points failure 2
- A security alert 2
- A gas leak near the railway earlier today 1
- A gas leak near the railway yesterday 1
- A landslip 1
- A late departure while the train was cleaned specially 1
- A late running freight train 1
- A late running train being in front of this one 1
- A lorry colliding with a bridge 1
- A lorry colliding with a bridge earlier on this trains journey 1
- A lorry colliding with a bridge earlier today 1
- A low speed derailment 1
- A member of on-train staff being taken ill 1
- A passenger being taken ill at a station 1
- A passenger being taken ill at a station earlier today 1
- A passenger being taken ill on a train 1
- A passenger being taken ill on a train earlier today 1
- A passenger being taken ill on this train 1
- A passenger being taken ill on this train earlier in its journey 1
- A person being hit by a train 1
- A person being hit by a train earlier 1
- A power cut at this station 1
- A problem currently under investigation 1
- A problem with a river bridge 1
- A problem with a river bridge earlier today 1
- A problem with lineside equipment 1
- A problem with the station lighting 1
- A rail buckling in the heat 1
- A railway embankment being damaged 1
- A river flooding the railway 1
- …
Category 1
- Reason · 321 ✖
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0817 | A gas leak near the railway earlier today | Reason | ||||
0818 | A gas leak near the railway yesterday | Reason | ||||
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 | ||||
0836 | 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 | ||||
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 | ||||
0888 | a speed restriction | Reason | ||||
0889 | a speed restriction because of fog | Reason | ||||
0890 | a speed restriction because of fog earlier on this train's journey | Reason | ||||
0891 | a speed restriction because of fog earlier today | Reason | ||||
0892 | a speed restriction because of heavy rain | Reason | ||||
0893 | a speed restriction because of heavy rain earlier on this train's journey | Reason | ||||
0894 | a speed restriction because of heavy rain earlier today | Reason | ||||
0895 | a speed restriction because of high track temperatures | Reason | ||||
0896 | a speed restriction because of high track temperatures earlier on this train's journey | Reason | ||||
0897 | a speed restriction because of high track temperatures earlier today | Reason | ||||
0898 | a speed restriction because of high winds | Reason | ||||
0899 | a speed restriction because of high winds earlier on this train's journey | Reason | ||||
0900 | a speed restriction because of high winds earlier today | Reason | ||||
0901 | a speed restriction because of severe weather | Reason | ||||
0902 | a speed restriction because of severe weather earlier on this train's journey | Reason | ||||
0903 | a speed restriction because of severe weather earlier today | Reason | ||||
0904 | a speed restriction because of snow and ice | Reason | ||||
0905 | a speed restriction because of snow and ice earlier on this train's journey | Reason | ||||
0906 | a speed restriction because of snow and ice earlier today | Reason | ||||
0907 | a speed restriction earlier on this train's journey | Reason | ||||
0908 | a speed restriction earlier today | Reason | ||||
0909 | a speed restriction in a tunnel | Reason | ||||
0910 | a speed restriction in a tunnel earlier on this train's journey | Reason | ||||
0911 | a speed restriction in a tunnel earlier today | Reason | ||||
0913 | a speed restriction over a bridge | Reason | ||||
0914 | a speed restriction over a bridge earlier on this train's journey | Reason | ||||
0915 | a speed restriction over a bridge earlier today | Reason | ||||
0916 | a speed restriction over an embankment | Reason | ||||
0917 | a speed restriction over an embankment earlier on this train's journey | Reason | ||||
0918 | a speed restriction over an embankment earlier today | Reason | ||||
0919 | a speed restriction over defective track | 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 );