searchable_view (view)

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

2 rows

✎ View and edit SQL

This data as json, testall, testnone, testresponse, CSV (advanced)

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW searchable_view AS
    SELECT * from searchable;