searchable
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
1 row where search column "text1" matches "barry" sorted by text1
This data as json, testall, testnone, testresponse, CSV (advanced)
pk | text1 ▼ | text2 | name with . and spaces |
---|---|---|---|
1 | barry cat | terry dog | panther |
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 );