#FollowtheMoneyCO
FollowtheMoneyCO aims to make Colorado campaign finance data more accessible to journalists and the public using downloadable data from the Colorado Secretary of State’s TRACER system.
In 2022, we'll have data on fundraising, spending and loans for state House, Senate and statewide candidates, as well as fundraising and spending for issue committees, super PACs and traditional PACs at the state. Eventually, we'll track outside spending in state contests.
Quickstart: Click on campaign_finance_2022 and choose a table. Query the data using the dropdown menu to select, say = ASPEN from the city column. The results may be downloaded as a CSV (best for using a spreadsheet) or json file.
See the about page for more details on the data and what it includes.
Need more info on queries? Click here to read more about using SQL.
Want to know what state-level candidates and committees are spending their cash on? Head over to Follow the Message, where many of them are being collected. Email yours to fishnette(at)gmail.com.
Most recent updates:
- Sept. 20 for 2022 candidates and committees. This is likely the last time losing primary candidates will be included.
- Jan. 30, 2021, for 2021 school board and outside spending on school board contests.
- Dec. 28, 2020, for 2020 campaign finance and for state-level outside spending, where support/oppose means the spender is supporting the first candidate named in the candidate column and opposing the other.
Questions or corrections, email fishnette (at) gmail.com.
campaign_finance_2022
426,457 rows in 13 tables
trad_pacs_cont, state_cont, house_cont, trad_pacs_exp, senate_cont, ...
camp_fin_2021
26,079 rows in 8 tables
school_board_cont, school_board_exp, super_pacs_cont, issue_comm_cont, super_pacs_exp, ...
campaign_finance
360,697 rows in 17 tables
trad_pacs_cont, house_cand_cont, issue_comm_cont, house_cand_exp, senate_cand_cont, ...
outside_spending
2,468 rows in 1 table