fec_employer_totals

Pre-computed aggregates of the FEC employer field as filed — the verbatim employer string from public individual-contribution filings, totaled by employer. DataDawn publishes no donor names, addresses, or donor-level records. Employer keys are verbatim strings from FEC filings and may denote a sole proprietorship or eponymous business; counts reflect contributions, not employees. Keys where a single contributor's giving dominates the aggregate are not indexed for full-text search (they are not representative employer aggregates); they remain in the dataset. The same records are public at fec.gov, which additionally exposes donor name, address, and occupation and is searchable by employer.

CREATE TABLE fec_employer_totals (
    employer TEXT PRIMARY KEY,
    donation_count INTEGER,
    total_amount INTEGER,
    avg_amount INTEGER,
    unique_states INTEGER,
    min_cycle INTEGER,
    max_cycle INTEGER,
    fts_eligible INTEGER DEFAULT 1  -- A13 (2026-07-12): r11 arbiter FTS-membership flag from 09 v2
);
CREATE INDEX idx_emp_totals_amount ON fec_employer_totals(total_amount);