announcements_fts
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows
This data as json, CSV (advanced)
Link | rowid ▼ | Transcription | announcements_fts | rank |
---|---|---|---|---|
201 | 201 | Racecourse | 14 | |
202 | 202 | Ratcliffe-on-Soar | 14 | |
203 | 203 | Shepherds Bush | 14 | |
204 | 204 | Stirling | 14 | |
205 | 205 | Stratford High Street | 14 | |
206 | 206 | Stratford International | 14 | |
207 | 207 | Westenhanger Racecourse | 14 | |
208 | 208 | White City | 14 | |
209 | 209 | Aberdeen | 14 | |
210 | 210 | Accrington | 14 | |
211 | 211 | Adlington | 14 | |
212 | 212 | Alnmouth | 14 | |
213 | 213 | Althorpe | 14 | |
214 | 214 | Cheadle Hulme | 14 | |
215 | 215 | Annan | 14 | |
216 | 216 | Ansdell & Fairhaven | 14 | |
217 | 217 | Appleby | 14 | |
218 | 218 | Appley Bridge | 14 | |
219 | 219 | Arbroath | 14 | |
220 | 220 | Ardwick | 14 | |
221 | 221 | Armathwaite | 14 | |
222 | 222 | Goostrey | 14 | |
223 | 223 | Arram | 14 | |
224 | 224 | Ashburys | 14 | |
225 | 225 | Ashton-under-Lyne | 14 | |
226 | 226 | Atherton | 14 | |
227 | 227 | Attenborough | 14 | |
228 | 228 | Kirton Lindsey | 14 | |
229 | 229 | Auchinleck | 14 | |
230 | 230 | Ayr | 14 | |
231 | 231 | Baildon | 14 | |
232 | 232 | Bamber Bridge | 14 | |
233 | 233 | Bamford | 14 | |
234 | 234 | Banbury | 14 | |
235 | 235 | Bare Lane | 14 | |
236 | 236 | Barnetby | 14 | |
237 | 237 | Barnsley | 14 | |
238 | 238 | Barrhead | 14 | |
239 | 239 | Barrhill | 14 | |
240 | 240 | Basingstoke | 14 | |
241 | 241 | Bedford | 14 | |
242 | 242 | Beeston | 14 | |
243 | 243 | Belle Vue | 14 | |
244 | 244 | Bempton | 14 | |
245 | 245 | Ben Rhydding | 14 | |
246 | 246 | Bentham | 14 | |
247 | 247 | Bentley | 14 | |
248 | 248 | Berry Brow | 14 | |
249 | 249 | Berwick | 14 | |
250 | 250 | Berwick-upon-Tweed | 14 | |
251 | 251 | Bescar Lane | 14 | |
252 | 252 | Beverley | 14 | |
253 | 253 | Billingham | 14 | |
254 | 254 | Bingley | 14 | |
255 | 255 | Birchwood | 14 | |
256 | 256 | Birmingham International | 14 | |
257 | 257 | Birmingham New Street | 14 | |
258 | 258 | Birmingham | 14 | |
259 | 259 | Blackburn | 14 | |
260 | 260 | Blackpool North | 14 | |
261 | 261 | Blackpool Pleasure Beach | 14 | |
262 | 262 | Blackpool South | 14 | |
263 | 263 | Edinburgh Park | 14 | |
264 | 264 | Blackpool | 14 | |
265 | 265 | Blackrod | 14 | |
266 | 266 | Bodmin Parkway | 14 | |
267 | 267 | Bolton | 14 | |
268 | 268 | Bournemouth | 14 | |
269 | 269 | Bradford Forster Square | 14 | |
270 | 270 | Bradford Interchange | 14 | |
271 | 271 | Bramley | 14 | |
272 | 272 | Branksome | 14 | |
273 | 273 | Bredbury | 14 | |
274 | 274 | Bridgend | 14 | |
275 | 275 | Bridgwater | 14 | |
276 | 276 | Bridlington | 14 | |
277 | 277 | Brighton | 14 | |
278 | 278 | Brighouse | 14 | |
279 | 279 | Bristol Parkway | 14 | |
280 | 280 | Bristol Temple Meads | 14 | |
281 | 281 | Broad Green | 14 | |
282 | 282 | Brockenhurst | 14 | |
283 | 283 | Bugle | 14 | |
284 | 284 | Burnage | 14 | |
285 | 285 | Burneside | 14 | |
286 | 286 | Manchester Oxford Road | 14 | |
287 | 287 | Burnley Transpennine | 14 | |
288 | 288 | Burscough Bridge | 14 | |
289 | 289 | Burton-on-Trent | 14 | |
290 | 290 | Bury St Edmunds | 14 | |
291 | 291 | Camborne | 14 | |
292 | 292 | Cambridge | 14 | |
293 | 293 | Cardiff | 14 | |
294 | 294 | Cardiff Bute Road | 14 | |
295 | 295 | Cardiff Central | 14 | |
296 | 296 | Cardiff Queen Street | 14 | |
297 | 297 | Cark | 14 | |
298 | 298 | Carlisle | 14 | |
299 | 299 | Carnoustie | 14 | |
300 | 300 | Carstairs | 14 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 ( [Transcription], tokenize='porter', content=[announcements] );