canonical_filings

Data license: Public Domain (IRS data)

5,652,935 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE canonical_filings (
    -- Materialized canonical-selection set (Phase-1 escalation, measured 2026-07-06:
    -- corpus-scale canned queries over the canonical_returns VIEW regressed 0.5s->18s
    -- and 4.5s->43s, past the ruled 10s Datasette threshold). REBUILT from the view by
    -- update.sh each monthly (fail-loud count assertion); the canonical_selection
    -- harness invariant REDs if this table ever differs from the view. The VIEW stays
    -- the semantic source of truth; point (ein-scoped) queries use the view directly.
    object_id TEXT PRIMARY KEY
) WITHOUT ROWID;