sections

2 rows where breadcrumbs = "["SpatiaLite", "Installation"]" and page = "spatialite"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: breadcrumbs (array)

id ▼ page ref title content breadcrumbs references
spatialite:installing-spatialite-on-linux spatialite installing-spatialite-on-linux Installing SpatiaLite on Linux SpatiaLite is packaged for most Linux distributions. apt install spatialite-bin libsqlite3-mod-spatialite Depending on your distribution, you should be able to run Datasette something like this: datasette --load-extension=/usr/lib/x86_64-linux-gnu/mod_spatialite.so If you are unsure of the location of the module, try running locate mod_spatialite and see what comes back. ["SpatiaLite", "Installation"] []
spatialite:installing-spatialite-on-os-x spatialite installing-spatialite-on-os-x Installing SpatiaLite on OS X The easiest way to install SpatiaLite on OS X is to use Homebrew . brew update brew install spatialite-tools This will install the spatialite command-line tool and the mod_spatialite dynamic library. You can now run Datasette like so: datasette --load-extension=spatialite ["SpatiaLite", "Installation"] [{"href": "https://brew.sh/", "label": "Homebrew"}]

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