fec_contributions

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

4,395,926 rows sorted by transaction_dt descending

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: entity_tp

Next page

CREATE TABLE fec_contributions (
    cmte_id TEXT,
    cmte_name TEXT,
    cand_id TEXT,
    cand_name TEXT,
    transaction_dt TEXT,
    transaction_amt REAL,
    entity_tp TEXT,
    state TEXT,
    employer TEXT,
    occupation TEXT,
    cycle INTEGER NOT NULL
);
CREATE INDEX idx_fec_contrib_cand ON fec_contributions(cand_id);
CREATE INDEX idx_fec_contrib_cmte ON fec_contributions(cmte_id);
CREATE INDEX idx_fec_contrib_cycle ON fec_contributions(cycle);
CREATE INDEX idx_fec_contrib_amt ON fec_contributions(transaction_amt);