announcements

Table actions

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

12 rows where Category = "Special train" and Category != "Destination"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transcription

Category 1

  • Special train · 12 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0466 The Cathedrals Express Special train      
0467 The Cathedrals Express Special train      
0468 The Cathedrals Express service to Special train      
0469 The Cathedrals Express service from Special train      
0470 The Cathedrals Express steam service to Special train      
0471 The Cathedrals Express steam service from Special train      
0472 The Cathedrals Express special steam service to Special train      
0473 The Cathedrals Express special steam service from Special train      
0474 The Blue Pullman Special train      
0475 The Blue Pullman Special train      
0476 The Blue Pullman service to Special train      
0477 The Blue Pullman service from Special train      

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