home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette

30 rows where Category = "Weather"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Notes

Category 1

  • Weather · 30 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0654 ...adverse weather conditions... Weather Audio not supported mid    
1014 Forecasted heavy snow Weather Audio not supported      
1015 Forecasted high winds Weather Audio not supported      
1016 Forecasted severe weather Weather Audio not supported      
1017 Forecasted slippery rails Weather Audio not supported      
1018 Heavy rain flooding the railway Weather Audio not supported      
1019 Heavy rain flooding the railway earlier today Weather Audio not supported      
1020 Heavy snow Weather Audio not supported      
1021 Heavy snow earlier in this train's journey Weather Audio not supported      
1022 Heavy snow earlier today Weather Audio not supported      
1023 Heavy snow over recent days Weather Audio not supported      
1024 High winds Weather Audio not supported      
1025 High winds earlier in this train's journey Weather Audio not supported      
1026 High winds earlier today Weather Audio not supported      
1029 Ice preventing this train getting electricity from the third rail Weather Audio not supported      
1030 Ice preventing trains getting electricity from the third rail Weather Audio not supported hmmmmmmm    
1034 Lightning damaging a station Weather Audio not supported      
1035 Lightning damaging a train Weather Audio not supported      
1036 Lightning damaging equipment Weather Audio not supported      
1037 Lightning damaging the electricity supply Weather Audio not supported      
1038 Lightning damaging the signalling system Weather Audio not supported      
1039 Lightning damaging this train Weather Audio not supported Unsure if this would even be callable in this event    
1062 Severe weather Weather Audio not supported      
1063 Severe weather earlier Weather Audio not supported      
1064 Severe weather earlier in this train's journey Weather Audio not supported      
1065 Severe weather earlier today Weather Audio not supported      
1066 Severe weather preventing train crew getting to work Weather Audio not supported      
1114 Thick fog Weather Audio not supported      
1115 Thick fog, earlier in this train's journey Weather Audio not supported      
1116 Thick fog, earlier today Weather Audio not supported      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "announcements" (
   [File] TEXT PRIMARY KEY,
   [Transcription] TEXT,
   [Category] TEXT,
   [mp3] TEXT,
   [Notes] TEXT,
   [Timestamp] TEXT,
   [NRE_ID] TEXT
);
Powered by Datasette · Queries took 23.333ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette