Select an email to view
Schema
emails
id INTEGER PRIMARY KEY doc_type TEXT -- 'email' | 'document' from_name TEXT from_email TEXT to_name TEXT to_email TEXT date_sent TEXT -- ISO 8601 subject TEXT body TEXT quoted_text TEXT disclaimer TEXT efta_ids TEXT -- JSON array metadata TEXT -- JSON object source_file TEXT
emails_fts
FTS5 virtual table Columns: subject, body Join: emails_fts.rowid = emails.id
Examples
-- Top 20 senders SELECT from_name, COUNT(*) as n FROM emails WHERE from_name IS NOT NULL GROUP BY from_name ORDER BY n DESC LIMIT 20
-- Emails in date range SELECT id, from_name, subject, date_sent FROM emails WHERE date_sent BETWEEN '2001-06-01' AND '2001-12-31' ORDER BY date_sent LIMIT 100
-- Full-text search SELECT id, subject, snippet(emails_fts, 1, '[', ']', '...', 30) as snip FROM emails_fts WHERE emails_fts MATCH 'california power' LIMIT 50
Tips
- Ctrl+Enter to run
- Max 10,000 rows returned
- Click long cells to expand
- FTS5 supports:
"phrase",term*,OR,NOT - DB is read-only