home / fixtures / searchable

Menu

searchable

2 rows

View and edit SQL

Export data

searchable

All rows in this table

TSV All 2 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 2 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 2 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 2 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 2 rows
    One JSON object per line
    View Download
  • JSON object All 2 rows
    Rows keyed by their primary key
    View Download
  • testall All 2 rows
    View Download
  • testnone All 2 rows
    View Download
  • testresponse All 2 rows
    View Download

pk ▼ text1 text2 name with . and spaces
1 barry cat terry dog panther
2 terry dog sara weasel puma
Table schema
CREATE TABLE searchable (
  pk integer primary key,
  text1 text,
  text2 text,
  [name with . and spaces] text
);
Powered by Datasette · Queries took 58.158ms