paginated_view (view)

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

201 rows

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

content content_extra
1 - 1 -
2 - 2 -
3 - 3 -
4 - 4 -
5 - 5 -
6 - 6 -
7 - 7 -
8 - 8 -
9 - 9 -
10 - 10 -
11 - 11 -
12 - 12 -
13 - 13 -
14 - 14 -
15 - 15 -
16 - 16 -
17 - 17 -
18 - 18 -
19 - 19 -
20 - 20 -
21 - 21 -
22 - 22 -
23 - 23 -
24 - 24 -
25 - 25 -

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW paginated_view AS
    SELECT
        content,
        '- ' || content || ' -' AS content_extra
    FROM no_primary_key;