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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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