announcements_fts

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

2,440 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Transcription announcements_fts rank
1 1 I am sorry to announce that the 2  
2 2 We are sorry to announce that the 2  
3 3 We are sorry to announce that 2  
4 4 we apologise for the inconvenience caused 2  
5 5 Apologies to customers... 2  
6 6 I am sorry to announce that the 2  
7 7 We are sorry to announce that the 2  
8 8 we apologise for the inconvenience caused by 2  
9 9 will be in 2  
10 10 will be at 2  
11 11 Thank you 2  
12 12 The delayed 2  
13 13 delayed 2  
14 14 Attention please 2  
15 15 Thank you 2  
16 16 is available 2  
17 17 Should change here 2  
18 18 via 2  
19 19 delayed 2  
20 20 has been cancelled 2  
21 21 and will now depart at 2  
22 22 will not arrive until 2  
23 23 and will not arrive until 2  
24 24 please join the front 2  
25 25 coach 2  
26 26 of this train 2  
27 27 This train... 2  
28 28 ...will not call at... 2  
29 29 ...at... 2  
30 30 carriage. 2  
31 31 carriages. 2  
32 32 is the 2  
33 33 is the 2  
34 34 ...is delayed. 2  
35 35 between 2  
36 36 Customers for 2  
37 37 is delayed... 2  
38 38 Engineering work 2  
39 39 Engineering work 2  
40 40 The 2  
41 41 The 2  
42 42 is delayed by approximately... 2  
43 43 may be subject to delay 2  
44 44 due to 2  
45 45 is being delayed 2  
46 46 This is 2  
47 47 has been cancelled 2  
48 48 Please note that this train 2  
49 49 The train now at... 2  
50 50 ...is the delayed... 2  
51 51 ...is the delayed... 2  
52 52 Engineering works 2  
53 53 Service to 2  
54 54 Please note 2  
55 55 Is the 2  
56 56 Is the delayed 2  
57 57 Please note 2  
58 58 Thank you 2  
59 59 is the 2  
60 60 will be diverted to 2  
61 61 will be at 2  
62 62 please 2  
63 63 is delayed 2  
64 64 Please take 2  
65 65 service from 2  
66 66 this cancellation 2  
67 67 will now depart at 2  
68 68 For the...... 2  
69 69 calling at 2  
70 70 For the 2  
71 71 For the 2  
72 72 Passengers For 2  
73 73 Coaches 2  
74 74 only 2  
75 75 Warrington Bank Quay 2  
76 76 Bath Spa 2  
77 77 Hexham 2  
78 78 Penrith 2  
79 79 Southampton Central 2  
80 80 Stafford 2  
81 81 Starcross 2  
82 82 Trowbridge 2  
83 83 Gartcosh 2  
84 84 Bodmin 2  
85 85 Corby 2  
86 86 St Pancras International 2  
87 87 Wilmslow 2  
88 88 Southampton Airport Parkway 2  
89 89 Barry Links 2  
90 90 Beauly 2  
91 91 Brunstane 2  
92 92 Central 2  
93 93 Dunfermline Queen Margaret 2  
94 94 Dunfermline Town 2  
95 95 Dunoon 2  
96 96 Exhibition Centre 2  
97 97 Georgemas 2  
98 98 Gilshochill 2  
99 99 Greenfaulds 2  
100 100 Hamilton West 2  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 (
    [Transcription],
    tokenize='porter',
    content=[announcements]
);