Custom SQL query

issue_comm_cont

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

636 rows

issue_comm_exp

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

425 rows

school_board_cont

field1, Jurisdiction_x, Office, District, candidate, contribution_amount, contribution_date, contributor, city, state, zip, employer, occupation, contributor_type, contribution_type, explanation

8,555 rows

school_board_exp

field1, jurisdiction, Office, District, candidate, expenditure_amount, expenditure_date, recipient, city, state, zip, expenditure_type, explanation

2,885 rows

school_board_loans

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

652 rows

super_pacs_cont

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

1,370 rows

super_pacs_exp

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

980 rows

Download SQLite DB: camp_fin_2021.db 2.6 MB