home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

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

2 rows where Notes = "Male voice"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Safety 2
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0209 Attention please! Please leave the station immediately. Safety Audio not supported Male voice    
0210 Attention please! Please leave the station immediately. Safety Audio not supported Male voice    

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
);
Powered by Datasette · Queries took 28.6ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette