paginated_view (view)
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
201 rows sorted by content_extra
This data as json, testall, testnone, testresponse, CSV (advanced)
content | content_extra ▼ |
---|---|
167 | - 167 - |
168 | - 168 - |
169 | - 169 - |
17 | - 17 - |
170 | - 170 - |
171 | - 171 - |
172 | - 172 - |
173 | - 173 - |
174 | - 174 - |
175 | - 175 - |
176 | - 176 - |
177 | - 177 - |
178 | - 178 - |
179 | - 179 - |
18 | - 18 - |
180 | - 180 - |
181 | - 181 - |
182 | - 182 - |
183 | - 183 - |
184 | - 184 - |
185 | - 185 - |
186 | - 186 - |
187 | - 187 - |
188 | - 188 - |
189 | - 189 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;