home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

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

2,440 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Category 23

  • Destination 1,271
  • Reason 421
  • Time 161
  • Passenger information 153
  • Number 102
  • Train operating company 76
  • Platform information 67
  • Conjoining 66
  • Weather 30
  • Safety 15
  • Train formation 14
  • Special train 12
  • Operational 10
  • Apology 8
  • Fare information 7
  • Platform ID 7
  • Heritage Railway 6
  • Number combo 4
  • Non-vocal 3
  • Strathclyde metro 3
  • Request stop 2
  • Station 1
  • Train operating company 1

Timestamp 15 ✖

  • - 2,426
  • 1
  • 00:54:20 1
  • 0:00:00 1
  • 0:00:02 1
  • 0:00:05 1
  • 0:00:07 1
  • 0:00:10 1
  • 0:00:14 1
  • 0:00:16 1
  • 0:00:19 1
  • 0:00:22 1
  • 0:00:26 1
  • 0:00:32 1
  • https://matteason.github 1
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0001 Platform Platform ID Audio not supported   0:00:00  
0002 A trolley service Passenger information Audio not supported   0:00:02  
0003 Warrington Bank Quay Destination Audio not supported   0:00:05 WBQ
0004 South West Trains service to Train operating company Audio not supported Bit of a detour 0:00:07  
0005 South West Trains service to Train operating company Audio not supported   0:00:10  
0006 Bath Spa Destination Audio not supported   0:00:14 BTH
0007 Midland Main Line Train operating company Audio not supported Stopped existing in 2007! 0:00:16  
0008 Midland Main Line service to Train operating company Audio not supported   0:00:19  
0009 Midland Main Line service from Train operating company Audio not supported   0:00:22  
0010 [white noise] Non-vocal Audio not supported non-vocal 0:00:26  
0011 The next train at platform Platform information Audio not supported   0:00:32  
0012 The next train at platform 1 is the Platform information Audio not supported "the" (/ðə/)    
0013 The next train at platform 2 is the Platform information Audio not supported "the" (/ðə/)    
0014 The next train at platform 3 is the Platform information Audio not supported "the" (/ðə/)    
0015 The next train at platform 4 is the Platform information Audio not supported "the" (/ðə/)    
0016 The next train at platform 5 is the Platform information Audio not supported "the" (/ðə/)    
0017 The next train at platform 6 is the Platform information Audio not supported "the" (/ðə/)    
0018 The next train at platform 7 is the Platform information Audio not supported "the" (/ðə/)    
0019 The next train at platform 8 is the Platform information Audio not supported "the" (/ðə/)    
0020 The next train at platform 1 is the Platform information Audio not supported "the" (/ði/)    
0021 The next train at platform 2 is the Platform information Audio not supported "the" (/ði/)    
0022 The next train at platform 3 is the Platform information Audio not supported "the" (/ði/)    
0023 The next train at platform 4 is the Platform information Audio not supported "the" (/ði/)    
0024 The next train at platform 5 is the Platform information Audio not supported "the" (/ði/)    
0025 The next train at platform 6 is the Platform information Audio not supported "the" (/ði/)    
0026 The next train at platform 7 is the Platform information Audio not supported "the" (/ði/)    
0027 The next train at platform 8 is the Platform information Audio not supported "the" (/ði/)    
0028 This train will call additionally at Passenger information Audio not supported      
0029 will be in Conjoining Audio not supported      
0030 will be at Conjoining Audio not supported      
0031 I am sorry to announce that the Apology Audio not supported      
0032 ScotRail Train operating company Audio not supported      
0033 ScotRail service to Train operating company Audio not supported      
0034 ScotRail service from Train operating company Audio not supported      
0035 platform 5 for the Platform information Audio not supported "the" (/ðə/)    
0036 platform 6 for the Platform information Audio not supported "the" (/ðə/)    
0037 Strathclyde metro service from Strathclyde metro Audio not supported      
0038 platform 1 for the Platform information Audio not supported "the" (/ði/)    
0039 platform 2 for the Platform information Audio not supported "the" (/ði/)    
0040 platform 3 for the Platform information Audio not supported "the" (/ði/)    
0041 platform 4 for the Platform information Audio not supported "the" (/ði/)    
0042 platform 5 for the Platform information Audio not supported "the" (/ði/)    
0043 platform 6 for the Platform information Audio not supported "the" (/ði/)    
0044 platform 7 for the Platform information Audio not supported "the" (/ðə/)    
0045 platform 8 for the Platform information Audio not supported "the" (/ðə/)    
0046 The public address at this station is currently under test Operational Audio not supported      
0047 Please ignore the following announcements Operational Audio not supported      
0048 Thank you Conjoining Audio not supported      
0049 The display information system at this station Operational Audio not supported      
0050 is currently under test Operational Audio not supported      
0051 Please ignore any information currently displayed Operational Audio not supported      
0052 The delayed Conjoining Audio not supported      
0053 Midland Main Line Passenger information Audio not supported Low-pitch ending    
0054 will now depart from platform 1 Platform information Audio not supported      
0055 will now depart from platform 2 Platform information Audio not supported      
0056 will now depart from platform 3 Platform information Audio not supported      
0057 will now depart from platform 4 Platform information Audio not supported      
0058 will now depart from platform 5 Platform information Audio not supported      
0059 will now depart from platform 6 Platform information Audio not supported      
0060 will now depart from platform 7 Platform information Audio not supported      
0061 will now depart from platform 8 Platform information Audio not supported      
0062 will now depart from Passenger information Audio not supported      
0063 This train is formed of 11 coaches Passenger information Audio not supported      
0064 This train is formed of 12 coaches Passenger information Audio not supported      
0065 This train is formed of 1 coach only Passenger information Audio not supported      
0066 This train is formed of 1 coach Passenger information Audio not supported      
0067 delayed Conjoining Audio not supported      
0068 The train now approaching platform 1 Platform information Audio not supported      
0069 The train now approaching platform 2 Platform information Audio not supported Nice    
0070 The train now approaching platform 3 Platform information Audio not supported      
0071 The train now approaching platform 4 Platform information Audio not supported      
0072 The train now approaching platform 5 Platform information Audio not supported      
0073 The train now approaching platform 6 Platform information Audio not supported      
0074 The train now approaching platform 7 Platform information Audio not supported      
0075 The train now approaching platform 8 Platform information Audio not supported      
0076 The train now approaching platform 2 is the Platform information Audio not supported "the" (/ði/)    
0077 The train now approaching platform 3 is the Platform information Audio not supported "the" (/ði/)    
0078 The train now approaching platform 4 is the Platform information Audio not supported "the" (/ði/)    
0079 The train now approaching platform 5 is the Platform information Audio not supported "the" (/ði/)    
0080 The train now approaching platform 6 is the Platform information Audio not supported "the" (/ði/)    
0081 The train now approaching platform 7 is the Platform information Audio not supported "the" (/ði/)    
0082 The train now approaching platform 8 is the Platform information Audio not supported "the" (/ði/)    
0083 Hexham Destination Audio not supported     HEX
0084 of drinks and light refreshments Passenger information Audio not supported      
0085 We are sorry to announce that the Apology Audio not supported Most frequently used file    
0086 platform 1 for the delayed Platform information Audio not supported      
0087 platform 2 for the delayed Platform information Audio not supported      
0088 platform 3 for the delayed Platform information Audio not supported      
0089 platform 4 for the delayed Platform information Audio not supported      
0090 platform 5 for the delayed Platform information Audio not supported      
0091 platform 6 for the delayed Platform information Audio not supported      
0092 platform 7 for the delayed Platform information Audio not supported      
0093 platform 8 for the delayed Platform information Audio not supported      
0094 The next service is to Passenger information Audio not supported      
0095 ScotRail services to Train operating company Audio not supported      
0096 ScotRail service from Train operating company Audio not supported      
0097 Will be in Time Audio not supported      
0098 Will be in 5 minutes Time Audio not supported      
0099 Will be in 10 minutes Time Audio not supported      
0100 Will be in 15 minutes Time Audio not supported      

Next page

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
);
Powered by Datasette · Queries took 49.087ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette