documents

1 row where source_id = "site-19-big-desks-and-little-people"

✎ View and edit SQL

This data as json, CSV (advanced)

source_id 1

  • Daniel Hardman's blog · 1 ✖

show 1

license 1

kind 1

category 1

id ▼ source siteName category title url creationDate author mediaType records chars first_heading raw_file level_proposed kind source_id text_path license show text_url
site-19-big-desks-and-little-people/1 Blogposts Daniel Hardman's blog Blogs Big Desks and Little People https://daniel-hardman.medium.com/big-desks-and-little-people-e1b1b9e92d79   Daniel Hardman Web page 86 15963 A Neglected Risk site-19-Big-Desks-and-Little-People.jsonl practitioner web page Daniel Hardman's blog site-19-big-desks-and-little-people   none abstract  

Advanced export

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

CSV options: 

CREATE TABLE documents (id TEXT PRIMARY KEY, source TEXT, siteName TEXT, category TEXT, title TEXT, url TEXT,
        creationDate TEXT, author TEXT, mediaType TEXT, records INTEGER, chars INTEGER, first_heading TEXT,
        raw_file TEXT, level_proposed TEXT REFERENCES levels(id), kind TEXT, source_id TEXT REFERENCES document_sources(id),
        text_path TEXT, license TEXT, show TEXT, text_url TEXT);