Custom SQL query

issue_comm_cont

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

1,395 rows

issue_comm_exp

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

654 rows

outside_spend_school_board

Committee, Payee, Spent, ExpenditureDate, Delivereddate, type, candidate, position, District

140 rows

school_board_cont

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

12,603 rows

school_board_exp

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

5,127 rows

school_board_loans

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

95 rows

super_pacs_cont

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

1,930 rows

super_pacs_exp

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

1,385 rows

Download SQLite DB: camp_fin_2021.db 3.9 MB