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 |
---|---|---|---|---|
101 | 101 | Hawkhead | 16 | |
102 | 102 | High Street | 16 | |
103 | 103 | Loch Awe | 16 | |
104 | 104 | Newcraighall | 16 | |
105 | 105 | Newton | 16 | |
106 | 106 | Queen Street | 16 | |
107 | 107 | Rannoch | 16 | |
108 | 108 | Kingsknowe | 16 | |
109 | 109 | Stromeferry | 16 | |
110 | 110 | Glasgow Central Low Level | 16 | |
111 | 111 | Glasgow Queen Street Low Level | 16 | |
112 | 112 | Newton (Lanarkshire) | 16 | |
113 | 113 | Ardrossan Harbour | 16 | |
114 | 114 | Ardrossan South Beach | 16 | |
115 | 115 | Ardrossan Town | 16 | |
116 | 116 | Brampton (Cumbria) | 16 | |
117 | 117 | Cumbrae Slip | 16 | |
118 | 118 | Kirkconnel | 16 | |
119 | 119 | East Midlands Airport | 16 | |
120 | 120 | Kelvindale | 16 | |
121 | 121 | Merryton | 16 | |
122 | 122 | Larkhall | 16 | |
123 | 123 | Chatelherault | 16 | |
124 | 124 | Alloa | 16 | |
125 | 125 | Shawfair | 16 | |
126 | 126 | Eskbank | 16 | |
127 | 127 | Newtongrange | 16 | |
128 | 128 | Gorebridge | 16 | |
129 | 129 | Galashiels | 16 | |
130 | 130 | Tweedbank | 16 | |
131 | 131 | Edinburgh Airport | 16 | |
132 | 132 | Edinburgh International Airport | 16 | |
133 | 133 | Abbey Road | 16 | |
134 | 134 | Edinburgh International | 16 | |
135 | 135 | Liverpool South Parkway | 16 | |
136 | 136 | Liverpool South | 16 | |
137 | 137 | Falmouth | 16 | |
138 | 138 | Folkestone Racecourse | 16 | |
139 | 139 | Racecourse | 16 | |
140 | 140 | Ratcliffe-on-Soar | 16 | |
141 | 141 | Shepherd's Bush | 16 | |
142 | 142 | Star Lane | 16 | |
143 | 143 | Stratford High Street | 16 | |
144 | 144 | Stratford International | 16 | |
145 | 145 | Westenhanger Racecourse | 16 | |
146 | 146 | White City | 16 | |
147 | 147 | Gartcosh | 16 | |
148 | 148 | Bodmin | 16 | |
149 | 149 | Corby | 16 | |
150 | 150 | St. Pancras International | 16 | |
151 | 151 | Barry Links | 16 | |
152 | 152 | Beauly | 16 | |
153 | 153 | Brunstane | 16 | |
154 | 154 | Central | 16 | |
155 | 155 | Dunfermline Queen Margaret | 16 | |
156 | 156 | Dunfermline Town | 16 | |
157 | 157 | Dunoon | 16 | |
158 | 158 | Exhibition Centre | 16 | |
159 | 159 | Georgemas | 16 | |
160 | 160 | Gilshochill | 16 | |
161 | 161 | Greenfaulds | 16 | |
162 | 162 | Hamilton West | 16 | |
163 | 163 | Hawkhead | 16 | |
164 | 164 | High Street | 16 | |
165 | 165 | Loch Awe | 16 | |
166 | 166 | Newcraighall | 16 | |
167 | 167 | Newton | 16 | |
168 | 168 | Queen Street | 16 | |
169 | 169 | Rannoch | 16 | |
170 | 170 | Kingsknowe | 16 | |
171 | 171 | Stromeferry | 16 | |
172 | 172 | Glasgow Central Low Level | 16 | |
173 | 173 | Glasgow Queen Street Low Level | 16 | |
174 | 174 | Newton (Lanarkshire) | 16 | |
175 | 175 | Ardrossan Harbour | 16 | |
176 | 176 | Ardrossan South Beach | 16 | |
177 | 177 | Ardrossan Town | 16 | |
178 | 178 | Brampton (Cumbria) | 16 | |
179 | 179 | Cumbrae Slip | 16 | |
180 | 180 | Kirkconnel | 16 | |
181 | 181 | East Midlands Airport | 16 | |
182 | 182 | Kelvindale | 16 | |
183 | 183 | Merryton | 16 | |
184 | 184 | Larkhall | 16 | |
185 | 185 | Chatelherault | 16 | |
186 | 186 | Alloa | 16 | |
187 | 187 | Shawfair | 16 | |
188 | 188 | Eskbank | 16 | |
189 | 189 | Newtongrange | 16 | |
190 | 190 | Gorebridge | 16 | |
191 | 191 | Galashiels | 16 | |
192 | 192 | Tweedbank | 16 | |
193 | 193 | Edinburgh Airport | 16 | |
194 | 194 | Edinburgh International Airport | 16 | |
195 | 195 | Abbey Road | 16 | |
196 | 196 | Liverpool South Parkway | 16 | |
197 | 197 | Liverpool South | 16 | |
198 | 198 | Edinburgh International | 16 | |
199 | 199 | Falmouth | 16 | |
200 | 200 | Folkestone Racecourse | 16 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 ( [Transcription], tokenize='porter', content=[announcements] );