simonwillisonblog
Queries
Tables schema
auth_user
id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined
1 row
blog_beat
id, created, slug, metadata, search_document, import_ref, card_image, is_draft, beat_type, title, url, commentary, series_id, image_alt, image_url, note
3,613 rows
blog_blogmark
id, slug, link_url, link_title, via_url, via_title, commentary, created, metadata, import_ref, card_image, series_id, use_markdown, is_draft, title
8,488 rows
blog_entry
id, title, slug, body, created, metadata, tweet_html, import_ref, extra_head_html, card_image, custom_template, series_id, is_draft, live_timezone, replacement_blogmark_id, replacement_note_id, poll_live_updates
3,340 rows
blog_note
id, created, slug, metadata, import_ref, card_image, is_draft, body, series_id, title
160 rows
blog_quotation
id, slug, quotation, source, source_url, created, metadata, import_ref, card_image, series_id, is_draft, context
1,472 rows
guides_chapter
id, created, slug, metadata, search_document, import_ref, card_image, is_draft, updated, title, body, order, series_id, guide_id, section_id, is_unlisted
16 rows
til
path, topic, title, url, body, html, created, created_utc, updated, updated_utc, shot_hash, slug, summary
583 rows
... and 6 hidden tables
Download SQLite DB: simonwillisonblog.db 82.6 MB