announcements

Table actions

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

3 rows where Category = "Non-vocal"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Timestamp

Category 1

  • Non-vocal · 3 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0010 [white noise] Non-vocal non-vocal 0:00:26  
1643 [long beep] Non-vocal      
1646 [4 rising chimes] Non-vocal played before announcements over tannoy    

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