announcements

Table actions

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

8 rows where Category = "Destination" and Notes = "end"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Destination · 8 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0697 Coventry Destination end   COV
0698 Crewe Destination end   CRE
0699 Crossmyloof Destination end   CMY
0700 Cupar Destination end   CUP
0701 Darlington Destination end   DAR
0702 Dawlish Destination end   DWL
0703 Dawlish Warren Destination end   DWW
0704 Derby Destination end   DBY

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