documents

4,804 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: doc_type, year, date_iso (date), first_seen (date), last_seen (date), body_fetched_at (date)

Next page

CREATE TABLE documents (
        url TEXT PRIMARY KEY,
        doc_type TEXT, number TEXT, num INTEGER, year INTEGER,
        date TEXT, date_iso TEXT, title TEXT,
        raw_html_path TEXT, first_seen TEXT, last_seen TEXT
    , body_text TEXT, body_path TEXT, body_fetched_at TEXT, body_status TEXT);
CREATE INDEX ix_docs_dateiso ON documents(date_iso);
CREATE INDEX ix_docs_type ON documents(doc_type);
CREATE INDEX ix_docs_year ON documents(year);
CREATE INDEX ix_docs_bodyfetched ON documents(body_fetched_at);