paginated_view (view)
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
201 rows sorted by content_extra descending
This data as json, testall, testnone, testresponse, CSV (advanced)
content | content_extra ▲ |
---|---|
53 | - 53 - |
52 | - 52 - |
51 | - 51 - |
50 | - 50 - |
5 | - 5 - |
49 | - 49 - |
48 | - 48 - |
47 | - 47 - |
46 | - 46 - |
45 | - 45 - |
44 | - 44 - |
43 | - 43 - |
42 | - 42 - |
41 | - 41 - |
40 | - 40 - |
4 | - 4 - |
39 | - 39 - |
38 | - 38 - |
37 | - 37 - |
36 | - 36 - |
35 | - 35 - |
34 | - 34 - |
33 | - 33 - |
32 | - 32 - |
31 | - 31 - |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key;