#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.
Note that super PACs includes both 527 and IEC committees, and some 527s often collect money then donate that to an IEC with the same name. It's best when noting large contribution to use a SQL query that captures all the contributor's information. Some large contributions end up fully or partially refunded.
Most recent updates:
- Dec. 14 for 2022 candidates and committees.
- 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
521,493 rows in 13 tables
trad_pacs_cont, state_cont, house_cont, senate_cont, house_exp, ...
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