announcements

Table actions

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

2 rows where Category = "Destination" and Transcription = "Worcester"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Destination · 2 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
1817 Worcester Destination Three stations for Worcester (WOF Foregate St, WOP Parkway, WOS Shrub Hill)    
1883 Worcester Destination Three stations for Worcester (WOF Foregate St, WOP Parkway, WOS Shrub Hill)    

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