home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

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

5 rows where Notes = " "

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: NRE_ID

Category 3

  • Destination 3
  • Passenger information 1
  • Reason 1
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0405 Newcraighall Destination Audio not supported   NEW
0551 If you are travelling to this station, please wait on the platform Passenger information Audio not supported    
0633 Blackburn Destination Audio not supported   BBN
0835 A person being hit by a train earlier Reason Audio not supported    
1647 Aberdeen Destination Audio not supported   ABD

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