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 22

  • Destination 1,268
  • Reason 421
  • Time 157
  • Passenger information 143
  • Number 102
  • Train operating company 67
  • Conjoining 61
  • Weather 30
  • Safety 15
  • Train formation 14
  • Special train 12
  • Platform information 9
  • Fare information 7
  • Apology 6
  • Heritage Railway 6
  • Platform ID 6
  • Operational 5
  • Number combo 4
  • Non-vocal 2
  • Request stop 2
  • Strathclyde metro 2
  • Station 1
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0101 Will be in 20 minutes Time Audio not supported      
0102 Will be in 25 minutes Time Audio not supported      
0103 Will be in 30 minutes Time Audio not supported      
0104 Will be in 35 minutes Time Audio not supported      
0105 Will be in 40 minutes Time Audio not supported      
0106 Will be in 45 minutes Time Audio not supported      
0107 Will be in 50 minutes Time Audio not supported      
0108 Will be in 55 minutes Time Audio not supported      
0109 Will be in 1 hour Time Audio not supported      
0110 Is delayed by approximately 5 minutes Time Audio not supported      
0111 Is delayed by approximately 10 minutes Time Audio not supported      
0112 Is delayed by approximately 15 minutes Time Audio not supported      
0113 Is delayed by approximately 20 minutes Time Audio not supported      
0114 Is delayed by approximately 25 minutes Time Audio not supported      
0115 Is delayed by approximately 30 minutes Time Audio not supported      
0116 Is delayed by approximately 35 minutes Time Audio not supported      
0117 Is delayed by approximately 40 minutes Time Audio not supported      
0118 Is delayed by approximately 45 minutes Time Audio not supported      
0119 Is delayed by approximately 50 minutes Time Audio not supported      
0120 Is delayed by approximately 55 minutes Time Audio not supported      
0121 Is delayed by approximately 1 hour Time Audio not supported      
0122 Strathclyde metro service to Strathclyde metro Audio not supported      
0123 Strathclyde metro service from Strathclyde metro Audio not supported      
0124 Should join the rear 9 coaches Passenger information Audio not supported      
0125 Should join the rear 10 coaches Passenger information Audio not supported      
0126 Should join the rear 11 coaches Passenger information Audio not supported      
0127 Should join the rear 12 coaches Passenger information Audio not supported      
0128 This service will be in approximately 5 minutes Time Audio not supported      
0129 This service will be in approximately 10 minutes Time Audio not supported      
0130 This service will arrive in approximately 7 minutes Time Audio not supported      
0131 This service will arrive in approximately 12 minutes Time Audio not supported      
0132 This service will be in approximately Time Audio not supported      
0133 5 minutes Time Audio not supported      
0134 10 minutes Time Audio not supported      
0135 7 minutes Time Audio not supported      
0136 12 minutes Time Audio not supported      
0137 Will arrive in approximately 1 minute Time Audio not supported      
0138 Will arrive in approximately 2 minutes Time Audio not supported      
0139 Will arrive in approximately 3 minutes Time Audio not supported      
0140 Will arrive in approximately 4 minutes Time Audio not supported      
0141 Will arrive in approximately 5 minutes Time Audio not supported      
0142 Will arrive in approximately 10 minutes Time Audio not supported      
0143 Will arrive in approximately 15 minutes Time Audio not supported      
0144 Will arrive in approximately 20 minutes Time Audio not supported      
0145 Will arrive in approximately 25 minutes Time Audio not supported      
0146 Will arrive in approximately 30 minutes Time Audio not supported      
0147 Will arrive in approximately 35 minutes Time Audio not supported      
0148 Will arrive in approximately 40 minutes Time Audio not supported      
0149 Will arrive in approximately 45 minutes Time Audio not supported      
0150 Will arrive in approximately 50 minutes Time Audio not supported      
0151 Will arrive in approximately 55 minutes Time Audio not supported      
0152 Poor rail conditions Reason Audio not supported      
0153 Poor rail conditions Reason Audio not supported      
0154 Penrith Destination Audio not supported     PNR
0155 Attention please Conjoining Audio not supported      
0156 The public address system at this station Operational Audio not supported      
0157 Is at present being tested by our engineers Operational Audio not supported      
0158 Please disregard any public address announcements Operational Audio not supported      
0159 While this testing is carried out Operational Audio not supported      
0160 Thank you Conjoining Audio not supported      
0161 Attention please, here is a special announcement, penalty fares are in operation in this area, all passengers must be in possession of a valid ticket or authority to travel before travelling on services from this station. If you are asked to produce a ticket, and are unable to do so, you will be liable to pay a penalty fare, or the full standard single fare, whichever is the greater Fare information Audio not supported really long    
0162 Will be in approximately 1 minute Time Audio not supported      
0163 Will be in approximately 2 minutes Time Audio not supported      
0164 Will be in approximately 3 minutes Time Audio not supported      
0165 Will be in approximately 4 minutes Time Audio not supported      
0166 Will be in approximately 5 minutes Time Audio not supported      
0167 Will be in approximately 10 minutes Time Audio not supported      
0168 Will be in approximately 15 minutes Time Audio not supported      
0169 Will be in approximately 20 minutes Time Audio not supported      
0170 Will be in approximately 25 minutes Time Audio not supported      
0171 Will be in approximately 30 minutes Time Audio not supported      
0172 Will be in approximately 35 minutes Time Audio not supported      
0173 Will be in approximately 40 minutes Time Audio not supported      
0174 Will be in approximately 45 minutes Time Audio not supported      
0175 Will be in approximately 50 minutes Time Audio not supported      
0176 Will be in approximately 55 minutes Time Audio not supported      
0177 This train is formed of 1 coach only Train formation Audio not supported      
0178 This train is formed of 2 coaches Train formation Audio not supported      
0179 This train is formed of 3 coaches Train formation Audio not supported      
0180 This train is formed of 4 coaches Train formation Audio not supported      
0181 This train is formed of 5 coaches Train formation Audio not supported      
0182 This train is formed of 6 coaches Train formation Audio not supported      
0183 This train is formed of 7 coaches Train formation Audio not supported      
0184 This train is formed of 8 coaches Train formation Audio not supported      
0185 This train is formed of 9 coaches Train formation Audio not supported      
0186 This train is formed of 10 coaches Train formation Audio not supported      
0187 This train is formed of 11 coaches Train formation Audio not supported      
0188 This train is formed of 12 coaches Train formation Audio not supported      
0189 hundred hours Time Audio not supported      
0190 Stand well away from the edge of platform 1 Safety Audio not supported      
0191 Stand well away from the edge of platform 2 Safety Audio not supported      
0192 Stand well away from the edge of platform 3 Safety Audio not supported      
0193 Stand well away from the edge of platform 4 Safety Audio not supported      
0194 Stand well away from the edge of platform 5 Safety Audio not supported      
0195 Stand well away from the edge of platform 6 Safety Audio not supported      
0196 Stand well away from the edge of platform 7 Safety Audio not supported      
0197 Stand well away from the edge of platform 8 Safety Audio not supported      
0198 Southern Train operating company Audio not supported if you hear this the train is very lost :(    
0199 Southern service to Train operating company Audio not supported      
0200 Southern service from Train operating company 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 9.985ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette