sections

1 row where breadcrumbs contains "0.29 (2019-07-07)", breadcrumbs contains "Changelog" and title = "Facet by date"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: breadcrumbs (array)

id ▼ page ref title content breadcrumbs references
changelog:facet-by-date changelog facet-by-date Facet by date If a column contains datetime values, Datasette can now facet that column by date. ( #481 ) ["Changelog", "0.29 (2019-07-07)"] [{"href": "https://github.com/simonw/datasette/issues/481", "label": "#481"}]

Advanced export

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

CSV options: 

CREATE TABLE [sections] (
   [id] TEXT PRIMARY KEY,
   [page] TEXT,
   [ref] TEXT,
   [title] TEXT,
   [content] TEXT,
   [breadcrumbs] TEXT,
   [references] TEXT
);