home / index

summary

2 rows where language = "eng", publisher = "Ten Speed Press" and tags contains "Mycology" sorted by title

✎ View and edit SQL

This data as json, CSV (advanced)

uuid cover title ▼ authors year series language links publisher tags identifiers formats
9dc26df3-f298-4f1a-903e-0245b10994b2 Mycelium Running: How Mushrooms Can Help Save the World
[
    "Paul Stamets"
]
2005   eng pdf (25.4 MB) Ten Speed Press
[
    "PDF",
    "BookFi",
    "Mycology",
    "Mushrooms",
    "Fungi",
    "Ecology",
    "Psilocybin",
    "nonfiction"
]
{
    "amazon": "1580085792",
    "isbn": "9781580085793"
}
[
    "pdf"
]
57c87e00-0e5d-4ce6-b9c0-1ed40376bc28 Growing Gourmet and Medicinal Mushrooms
[
    "Paul Stamets"
]
2000   eng azw3 (76.2 MB), epub (69.0 MB) Ten Speed Press
[
    "Bookzz.org",
    "Gardening",
    "herbal",
    "Herbal Medications",
    "Medicinal plants",
    "Mushrooms",
    "Mycology",
    "Psilocybin",
    "Techniques"
]
{
    "isbn": "9781607741381"
}
[
    "azw3",
    "epub"
]

Advanced export

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

CSV options:

CREATE TABLE [summary] (
   [uuid] TEXT PRIMARY KEY,
   [cover] TEXT,
   [title] TEXT,
   [authors] TEXT,
   [year] TEXT,
   [series] TEXT,
   [language] TEXT,
   [links] TEXT,
   [publisher] TEXT,
   [tags] TEXT,
   [identifiers] TEXT,
   [formats] TEXT
);
Powered by Datasette · Queries took 2646.308ms