announcements_fts
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | Transcription | announcements_fts | rank |
---|---|---|---|---|
2440 | 2440 | Thick fog, earlier today | 1 | |
2439 | 2439 | Thick fog, earlier in this train's journey | 1 | |
2438 | 2438 | Thick fog | 1 | |
2437 | 2437 | Severe weather preventing train crew getting to work | 1 | |
2436 | 2436 | Severe weather earlier today | 1 | |
2435 | 2435 | Severe weather earlier in this train's journey | 1 | |
2434 | 2434 | Severe weather earlier | 1 | |
2433 | 2433 | Severe weather | 1 | |
2432 | 2432 | Lightning damaging this train | 1 | |
2431 | 2431 | Lightning damaging the signalling system | 1 | |
2430 | 2430 | Lightning damaging the electricity supply | 1 | |
2429 | 2429 | Lightning damaging equipment | 1 | |
2428 | 2428 | Lightning damaging a train | 1 | |
2427 | 2427 | Lightning damaging a station | 1 | |
2426 | 2426 | Ice preventing trains getting electricity from the third rail | 1 | |
2425 | 2425 | Ice preventing this train getting electricity from the third rail | 1 | |
2424 | 2424 | High winds earlier today | 1 | |
2423 | 2423 | High winds earlier in this train's journey | 1 | |
2422 | 2422 | High winds | 1 | |
2421 | 2421 | Heavy snow over recent days | 1 | |
2420 | 2420 | Heavy snow earlier today | 1 | |
2419 | 2419 | Heavy snow earlier in this train's journey | 1 | |
2418 | 2418 | Heavy snow | 1 | |
2417 | 2417 | Heavy rain flooding the railway earlier today | 1 | |
2416 | 2416 | Heavy rain flooding the railway | 1 | |
2415 | 2415 | Forecasted slippery rails | 1 | |
2414 | 2414 | Forecasted severe weather | 1 | |
2413 | 2413 | Forecasted high winds | 1 | |
2412 | 2412 | Forecasted heavy snow | 1 | |
2411 | 2411 | ...adverse weather conditions... | 1 | |
2410 | 2410 | ScotRail service to | 1 | |
2409 | 2409 | Midland Mainline Turbostar service from | 1 | |
2408 | 2408 | Midland Mainline Turbostar service to | 1 | |
2407 | 2407 | Midland Mainline Turbostar | 1 | |
2406 | 2406 | GNER service from | 1 | |
2405 | 2405 | South West Trains service from | 1 | |
2404 | 2404 | South West Trains service from | 1 | |
2403 | 2403 | GNER service to | 1 | |
2402 | 2402 | South West Trains service to | 1 | |
2401 | 2401 | South West Trains service to | 1 | |
2400 | 2400 | South West Trains | 1 | |
2399 | 2399 | GNER | 1 | |
2398 | 2398 | Virgin Trains | 1 | |
2397 | 2397 | South West Trains | 1 | |
2396 | 2396 | GNER | 1 | |
2395 | 2395 | Southeastern Trains | 1 | |
2394 | 2394 | Scotrail | 1 | |
2393 | 2393 | First Great Western | 1 | |
2392 | 2392 | South West Trains | 1 | |
2391 | 2391 | Midland Mainline Turbostar | 1 | |
2390 | 2390 | Southeastern Trains | 1 | |
2389 | 2389 | London North Eastern Railway service from... | 1 | |
2388 | 2388 | London North Eastern Railway service to... | 1 | |
2387 | 2387 | Virgin Trains East Coast service from... | 1 | |
2386 | 2386 | Virgin Trains East Coast service to... | 1 | |
2385 | 2385 | Grand Central service from... | 1 | |
2384 | 2384 | Grand Central service to... | 1 | |
2383 | 2383 | ...Grand Central | 1 | |
2382 | 2382 | ...Grand Central... | 1 | |
2381 | 2381 | First Capital Connect service from... | 1 | |
2380 | 2380 | First Capital Connect service to... | 1 | |
2379 | 2379 | ...First Capital Connect. | 1 | |
2378 | 2378 | ...First Capital Connect.... | 1 | |
2377 | 2377 | East Midlands service from | 1 | |
2376 | 2376 | East Midlands service to | 1 | |
2375 | 2375 | East Midlands | 1 | |
2374 | 2374 | East Midlands | 1 | |
2373 | 2373 | GNER | 1 | |
2372 | 2372 | GNER | 1 | |
2371 | 2371 | Midland Mainline Turbostar | 1 | |
2370 | 2370 | Transport for London Overground service from | 1 | |
2369 | 2369 | Transport for London Overground service to | 1 | |
2368 | 2368 | Transport for London Overground | 1 | |
2367 | 2367 | Transport for London Overground | 1 | |
2366 | 2366 | London Overground service from | 1 | |
2365 | 2365 | London Overground service to | 1 | |
2364 | 2364 | London Overground | 1 | |
2363 | 2363 | London Overground | 1 | |
2362 | 2362 | The Grand Central service from | 1 | |
2361 | 2361 | The Grand Central service to | 1 | |
2360 | 2360 | The Grand Central | 1 | |
2359 | 2359 | The Grand Central | 1 | |
2358 | 2358 | First Capital Connect | 1 | |
2357 | 2357 | First Great Western service from | 1 | |
2356 | 2356 | First Great Western service to | 1 | |
2355 | 2355 | First Great Western | 1 | |
2354 | 2354 | Southeastern | 1 | |
2353 | 2353 | Southern | 1 | |
2352 | 2352 | Southeastern service from | 1 | |
2351 | 2351 | Southeastern service to | 1 | |
2350 | 2350 | Southeastern | 1 | |
2349 | 2349 | Southeastern Trains service from | 1 | |
2348 | 2348 | Southeastern Trains service to | 1 | |
2347 | 2347 | Southeastern Trains | 1 | |
2346 | 2346 | Southeastern Trains | 1 | |
2345 | 2345 | Southern service from | 1 | |
2344 | 2344 | Southern service to | 1 | |
2343 | 2343 | Southern | 1 | |
2342 | 2342 | ScotRail service from | 1 | |
2341 | 2341 | ScotRail services to | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 ( [Transcription], tokenize='porter', content=[announcements] );