searchable_view (view)

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

2 rows sorted by pk

✎ 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;