announcements_fts
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Transcription
This data as json, CSV (advanced)
Link | rowid | Transcription ▼ | announcements_fts | rank |
---|---|---|---|---|
2231 | 2231 | 07 | 72 | |
2255 | 2255 | 07 | 72 | |
2316 | 2316 | 07 | 72 | |
2232 | 2232 | 08 | 72 | |
2256 | 2256 | 08 | 72 | |
2317 | 2317 | 08 | 72 | |
2233 | 2233 | 09 | 72 | |
2257 | 2257 | 09 | 72 | |
2318 | 2318 | 09 | 72 | |
1464 | 1464 | 1, 2, 3 | 72 | |
2234 | 2234 | 10 | 72 | |
2258 | 2258 | 10 | 72 | |
2190 | 2190 | 10 minutes | 72 | |
2235 | 2235 | 11 | 72 | |
2259 | 2259 | 11 | 72 | |
2236 | 2236 | 12 | 72 | |
2260 | 2260 | 12 | 72 | |
2192 | 2192 | 12 minutes | 72 | |
2237 | 2237 | 13 | 72 | |
2261 | 2261 | 13 | 72 | |
2238 | 2238 | 14 | 72 | |
2262 | 2262 | 14 | 72 | |
2239 | 2239 | 15 | 72 | |
2263 | 2263 | 15 | 72 | |
2240 | 2240 | 16 | 72 | |
2264 | 2264 | 16 | 72 | |
2241 | 2241 | 17 | 72 | |
2265 | 2265 | 17 | 72 | |
2242 | 2242 | 18 | 72 | |
2266 | 2266 | 18 | 72 | |
2243 | 2243 | 19 | 72 | |
2267 | 2267 | 19 | 72 | |
2244 | 2244 | 20 | 72 | |
2268 | 2268 | 20 | 72 | |
2245 | 2245 | 21 | 72 | |
2269 | 2269 | 21 | 72 | |
2246 | 2246 | 22 | 72 | |
2270 | 2270 | 22 | 72 | |
2247 | 2247 | 23 | 72 | |
2271 | 2271 | 23 | 72 | |
2272 | 2272 | 24 | 72 | |
2273 | 2273 | 25 | 72 | |
2274 | 2274 | 26 | 72 | |
2275 | 2275 | 27 | 72 | |
2276 | 2276 | 28 | 72 | |
2277 | 2277 | 29 | 72 | |
2278 | 2278 | 30 | 72 | |
2279 | 2279 | 31 | 72 | |
2280 | 2280 | 32 | 72 | |
2281 | 2281 | 33 | 72 | |
2282 | 2282 | 34 | 72 | |
2283 | 2283 | 35 | 72 | |
2284 | 2284 | 36 | 72 | |
2285 | 2285 | 37 | 72 | |
2286 | 2286 | 38 | 72 | |
2287 | 2287 | 39 | 72 | |
1465 | 1465 | 4, 5, 6 | 72 | |
2288 | 2288 | 40 | 72 | |
2289 | 2289 | 41 | 72 | |
2290 | 2290 | 42 | 72 | |
2291 | 2291 | 43 | 72 | |
2292 | 2292 | 44 | 72 | |
2293 | 2293 | 45 | 72 | |
2294 | 2294 | 46 | 72 | |
2295 | 2295 | 47 | 72 | |
2296 | 2296 | 48 | 72 | |
2297 | 2297 | 49 | 72 | |
2189 | 2189 | 5 minutes | 72 | |
2298 | 2298 | 50 | 72 | |
2299 | 2299 | 51 | 72 | |
2300 | 2300 | 52 | 72 | |
2301 | 2301 | 53 | 72 | |
2302 | 2302 | 54 | 72 | |
2303 | 2303 | 55 | 72 | |
2304 | 2304 | 56 | 72 | |
2305 | 2305 | 57 | 72 | |
2306 | 2306 | 58 | 72 | |
2307 | 2307 | 59 | 72 | |
2191 | 2191 | 7 minutes | 72 | |
1466 | 1466 | 7, 8 | 72 | |
1467 | 1467 | 9, 10 | 72 | |
1789 | 1789 | A fire at a station | 72 | |
1790 | 1790 | A fire at a station earlier | 72 | |
1791 | 1791 | A fire near the railway involving gas cylinders | 72 | |
1792 | 1792 | A fire near the railway involving gas cylinders earlier today | 72 | |
1793 | 1793 | A fire near the railway involving gas cylinders yesterday | 72 | |
1794 | 1794 | A fire near the railway suspected to involve gas cylinders | 72 | |
1795 | 1795 | A fire near the railway suspected to involve gas cylinders earlier today | 72 | |
1796 | 1796 | A fire near the railway suspected to involve gas cylinders yesterday | 72 | |
1797 | 1797 | A fire next to the track | 72 | |
1798 | 1798 | A fire next to the track earlier today | 72 | |
1799 | 1799 | A fire on a train | 72 | |
1800 | 1800 | A fire on a train earlier today | 72 | |
1801 | 1801 | A fire on property near the railway | 72 | |
1802 | 1802 | A fire on property near the railway earlier today | 72 | |
1803 | 1803 | A fire on property near the railway yesterday | 72 | |
1602 | 1602 | A further announcement will be made when this... | 72 | |
1804 | 1804 | A gas leak near the railway | 72 | |
1805 | 1805 | A gas leak near the railway earlier today | 72 | |
1806 | 1806 | A gas leak near the railway yesterday | 72 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 ( [Transcription], tokenize='porter', content=[announcements] );