searchable_view (view)

2 rows sorted by name with . and spaces descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

CSV options: 

CREATE VIEW searchable_view AS
    SELECT * from searchable;
Powered by Datasette · Query took 6.701ms