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 = "For ferry from Gourock" and Transcription = "Kilcreggan"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Destination 2
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
2055 Kilcreggan Destination Audio not supported For ferry from Gourock    
2280 Kilcreggan Destination Audio not supported For ferry from Gourock    

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 22.103ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette