announcements

Table actions

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

4 rows where Category = "Train operating company" and Notes = "start"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Train operating company · 4 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0649 First Capital Connect service to... Train operating company start    
0650 First Capital Connect service from... Train operating company start    
0657 Grand Central service to... Train operating company start    
0658 Grand Central service from... Train operating company start    

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