home

campaign_finance_2022

Custom SQL query

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

Powered by Datasette · Queries took 15.356ms