campaign_finance
Tables
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.db 59.0 MB