2 rows sorted by text2

View and edit SQL

pk text1 text2 ▼ name with . and spaces
2 terry dog sara weasel puma
1 barry cat terry dog panther

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE searchable (
  pk integer primary key,
  text1 text,
  text2 text,
  [name with . and spaces] text
Powered by Datasette · Query took 7.977ms