announcements

Table actions

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

5 rows where Notes = "mid"

✎ View and edit SQL

This data as json, CSV (advanced)

File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0647 ...First Capital Connect.... Train operating company mid    
0653 ...Grand Central... Train operating company mid    
0654 ...adverse weather conditions... Weather mid    
0668 ...signalling difficulties... Reason mid    
0723 ...will not call at... Conjoining mid    

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
);