announcements

Table actions

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

10 rows where Category = "Destination" and Notes = "Low-pitch ending"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: NRE_ID

Category 1

  • Destination · 10 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0362 Gartcosh Destination Low-pitch ending   GRH
0363 Bodmin Destination Low-pitch ending    
0364 Corby Destination Low-pitch ending   COR
0366 St. Pancras International Destination Low-pitch ending   STP
0390 Barry Links Destination Low-pitch ending   BYL
0391 Beauly Destination Low-pitch ending   BEL
0392 Brunstane Destination Low-pitch ending   BSU
0393 Central Destination Low-pitch ending    
0394 Dunfermline Queen Margaret Destination Low-pitch ending   DFL
0395 Dunfermline Town Destination Low-pitch ending   DFE

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