announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
5 rows where Notes = "mid"
This data as json, CSV (advanced)
Category 4
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
CREATE TABLE "announcements" ( [File] TEXT PRIMARY KEY, [Transcription] TEXT, [Category] TEXT, [mp3] TEXT, [Notes] TEXT, [Timestamp] TEXT, [NRE_ID] TEXT );