coloradocampaignfinance

Custom SQL query

da_cand_cont

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

11,445 rows

da_cand_exp

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

1,801 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,012 rows

ed_cand_exp

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

577 rows

ed_loans

field1, district, candidate, affiliation, loan_amount, loan_date, payment_amount, payment_date, loan_balance...

8 rows

house_cand_cont

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

25,507 rows

house_cand_exp

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

10,435 rows

issue_comm_cont

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

26,508 rows

issue_comm_exp

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

6,809 rows

leg_loans

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

146 rows

senate_cand_cont

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

10,482 rows

senate_cand_exp

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

4,724 rows

super_pacs_cont

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

11,653 rows

super_pacs_exp

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

8,436 rows

trad_pacs_cont

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

145,846 rows

trad_pacs_exp

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

11,483 rows

Download SQLite DB: coloradocampaignfinance.db 40.6 MB

Powered by Datasette · Query took 50.266ms