announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
421 rows where Category = "Reason" sorted by Transcription
This data as json, CSV (advanced)
Timestamp 3 ✖
- - 352
- 00:54:20 1
- https://matteason.github 1
Category 1
- Reason · 354 ✖
File | Transcription ▼ | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 |
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 );