searchable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
2 rows where search matches "dog" sorted by pk
This data as json, testall, testnone, testresponse, CSV (advanced)
text2 2 ✖
- sara weasel 1
- terry dog 1
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE searchable ( pk integer primary key, text1 text, text2 text, [name with . and spaces] text );