announcements

Table actions

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

21 rows where Notes = ""the" (/ði/)"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0020 The next train at platform 1 is the Platform information "the" (/ði/)    
0021 The next train at platform 2 is the Platform information "the" (/ði/)    
0022 The next train at platform 3 is the Platform information "the" (/ði/)    
0023 The next train at platform 4 is the Platform information "the" (/ði/)    
0024 The next train at platform 5 is the Platform information "the" (/ði/)    
0025 The next train at platform 6 is the Platform information "the" (/ði/)    
0026 The next train at platform 7 is the Platform information "the" (/ði/)    
0027 The next train at platform 8 is the Platform information "the" (/ði/)    
0038 platform 1 for the Platform information "the" (/ði/)    
0039 platform 2 for the Platform information "the" (/ði/)    
0040 platform 3 for the Platform information "the" (/ði/)    
0041 platform 4 for the Platform information "the" (/ði/)    
0042 platform 5 for the Platform information "the" (/ði/)    
0043 platform 6 for the Platform information "the" (/ði/)    
0076 The train now approaching platform 2 is the Platform information "the" (/ði/)    
0077 The train now approaching platform 3 is the Platform information "the" (/ði/)    
0078 The train now approaching platform 4 is the Platform information "the" (/ði/)    
0079 The train now approaching platform 5 is the Platform information "the" (/ði/)    
0080 The train now approaching platform 6 is the Platform information "the" (/ði/)    
0081 The train now approaching platform 7 is the Platform information "the" (/ði/)    
0082 The train now approaching platform 8 is the Platform information "the" (/ði/)    

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