fec_employer_to_candidate

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

1,125,030 rows sorted by total_amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE fec_employer_to_candidate (
    employer TEXT,
    cand_id TEXT,
    bioguide_id TEXT,
    cand_name TEXT,
    party TEXT,
    office TEXT,
    state TEXT,
    cycle INTEGER,
    donation_count INTEGER,
    total_amount INTEGER
);
CREATE INDEX idx_emp_cand_employer ON fec_employer_to_candidate(employer);
CREATE INDEX idx_emp_cand_cand ON fec_employer_to_candidate(cand_id);
CREATE INDEX idx_emp_cand_bioguide ON fec_employer_to_candidate(bioguide_id);