sections

3 rows where breadcrumbs = "["Pages and API endpoints", "Schemas"]", breadcrumbs contains "Pages and API endpoints" and references = "[]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: breadcrumbs (array)

id ▼ page ref title content breadcrumbs references
pages:databaseschemaview pages databaseschemaview Database schema Use /database-name/-/schema to see the complete schema for a specific database. The .md and .json extensions work here too. The JSON returns an object with "database" and "schema" keys. ["Pages and API endpoints", "Schemas"] []
pages:instanceschemaview pages instanceschemaview Instance schema Access /-/schema to see the complete schema for all attached databases in the Datasette instance. Use /-/schema.md to get the same information as Markdown. Use /-/schema.json to get the same information as JSON, which looks like this: { "schemas": [ { "database": "content", "schema": "create table posts ..." } } ["Pages and API endpoints", "Schemas"] []
pages:tableschemaview pages tableschemaview Table schema Use /database-name/table-name/-/schema to see the schema for a specific table. The .md and .json extensions work here too. The JSON returns an object with "database" , "table" , and "schema" keys. ["Pages and API endpoints", "Schemas"] []

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
);