announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
4 rows where Notes = "mid (suffixed with 'at <station>'/'between <x> and <y>'/similar)"
This data as json, CSV (advanced)
Category 1
- Reason 4
File ▼ | Transcription | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0608 | ...trespass on the line... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
0618 | ...an incident on the line... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
0629 | ...suspected damage to a railway bridge... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
0641 | ...cancellation of the incoming service... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) |
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 );