announcements

Table actions

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

67 rows where Category = "Platform information" and Category != "Destination"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Notes, Timestamp

Category 1

  • Platform information · 67 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0011 The next train at platform Platform information   0:00:32  
0012 The next train at platform 1 is the Platform information "the" (/ðə/)    
0013 The next train at platform 2 is the Platform information "the" (/ðə/)    
0014 The next train at platform 3 is the Platform information "the" (/ðə/)    
0015 The next train at platform 4 is the Platform information "the" (/ðə/)    
0016 The next train at platform 5 is the Platform information "the" (/ðə/)    
0017 The next train at platform 6 is the Platform information "the" (/ðə/)    
0018 The next train at platform 7 is the Platform information "the" (/ðə/)    
0019 The next train at platform 8 is the Platform information "the" (/ðə/)    
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/)    
0035 platform 5 for the Platform information "the" (/ðə/)    
0036 platform 6 for the Platform information "the" (/ðə/)    
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/)    
0044 platform 7 for the Platform information "the" (/ðə/)    
0045 platform 8 for the Platform information "the" (/ðə/)    
0054 will now depart from platform 1 Platform information      
0055 will now depart from platform 2 Platform information      
0056 will now depart from platform 3 Platform information      
0057 will now depart from platform 4 Platform information      
0058 will now depart from platform 5 Platform information      
0059 will now depart from platform 6 Platform information      
0060 will now depart from platform 7 Platform information      
0061 will now depart from platform 8 Platform information      
0068 The train now approaching platform 1 Platform information      
0069 The train now approaching platform 2 Platform information Nice    
0070 The train now approaching platform 3 Platform information      
0071 The train now approaching platform 4 Platform information      
0072 The train now approaching platform 5 Platform information      
0073 The train now approaching platform 6 Platform information      
0074 The train now approaching platform 7 Platform information      
0075 The train now approaching platform 8 Platform information      
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/)    
0086 platform 1 for the delayed Platform information      
0087 platform 2 for the delayed Platform information      
0088 platform 3 for the delayed Platform information      
0089 platform 4 for the delayed Platform information      
0090 platform 5 for the delayed Platform information      
0091 platform 6 for the delayed Platform information      
0092 platform 7 for the delayed Platform information      
0093 platform 8 for the delayed Platform information      
0229 This is a platform alteration Platform information      
1962 Platform 1 for the Platform information      
1963 Platform 2 for the Platform information      
1964 Platform 3 for the Platform information      
1965 Platform 4 for the Platform information      
1966 Platform 5 for the Platform information      
1967 Platform 6 for the Platform information      
1968 Platform 7 for the Platform information      
1969 Platform 8 for the Platform information      

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