Custom SQL query

da_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

13,897 rows

da_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

2,459 rows

da_loans

district, candidate, affiliation, loan_amount, loan_date, payment_amount, payment_date, loan_balance, filed_date

12 rows

ed_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

4,284 rows

ed_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

1,199 rows

ed_loans

district, candidate, affiliation, loan_amount, loan_date, payment_amount, payment_date, loan_balance, filed_date

50 rows

house_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

37,992 rows

house_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

15,326 rows

issue_comm_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

33,809 rows

issue_comm_exp

committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

8,729 rows

leg_loans

district, candidate, affiliation, loan_amount, loan_date, payment_amount, payment_date, loan_balance, filed_date

278 rows

senate_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

15,090 rows

senate_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

6,613 rows

super_pacs_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

13,713 rows

super_pacs_exp

committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

11,340 rows

trad_pacs_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

180,831 rows

trad_pacs_exp

committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

15,075 rows

Download SQLite DB: campaign_finance_2020.db 59.0 MB