searchable_view (view)

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

2 rows sorted by text2 descending

✎ View and edit SQL

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

pk text1 text2 ▲
1 barry cat terry dog
2 terry dog sara weasel

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW searchable_view AS SELECT * FROM searchable;