select

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

1 row sorted by json

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid group having and json ▼
1 1 group having and {"href": "http://example.com/", "label":"Example"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [select] (
  [group] text,
  [having] text,
  [and] text,
  [json] text
);
Powered by Datasette · Query took 11.691ms · Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette