coloradocampaignfinance

Custom SQL query

da_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip...

12,972 rows

da_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip...

2,085 rows

da_loans

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

5 rows

ed_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip...

3,347 rows

ed_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip...

663 rows

ed_loans

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

10 rows

house_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip...

32,521 rows

house_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip...

12,304 rows

issue_comm_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer...

30,387 rows

issue_comm_exp

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

7,707 rows

leg_loans

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

155 rows

senate_cand_cont

district, candidate, affiliation, contribution_amount, contribution_date, contributor, city, state, zip...

12,853 rows

senate_cand_exp

district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, state, zip...

5,326 rows

super_pacs_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer...

12,745 rows

super_pacs_exp

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

9,809 rows

trad_pacs_cont

committee, committee_type, contribution_amount, contribution_date, contributor, city, state, zip, employer...

161,707 rows

trad_pacs_exp

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

13,856 rows

Download SQLite DB: coloradocampaignfinance.db 51.7 MB

Powered by Datasette · Query took 33.686ms