campaign_finance_2022
Tables
cand_loans
District, name, Party, loan_amount, loan_date, payment_amount, payment_date, loan_balance, filed_date
319 rows
house_cont
District, candidate_name, Party, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
38,394 rows
house_exp
District, candidate_name, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
15,896 rows
issue_comm_cont
committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
4,871 rows
issue_comm_exp
committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
2,396 rows
senate_cont
District, candidate_name, Party, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
17,933 rows
senate_exp
District, candidate_name, Party, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
5,365 rows
state_cont
District, candidate_name, Party, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
146,615 rows
state_exp
District, candidate_name, Party, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
10,212 rows
super_pacs_cont
committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
7,617 rows
super_pacs_exp
committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
5,901 rows
trad_pacs_cont
committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation
250,888 rows
trad_pacs_exp
committee, committee_type, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation
15,086 rows
Download SQLite DB: campaign_finance_2022.db 81.0 MB