#FollowtheMoneyCO
Is anyone using this site? Would you like it to continue? Check the about page and let me know!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. email fishnette@gmail.com if you see something amiss, please
Quickstart: Click on campaign_finance_2024 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:
- Oct. 3, 2024, for 2024 state campaign finance, with outside spending for general to come
- Dec. 13, 2023 for 2023 school board candidates, issue committees, super PACs and schools outside spending. This is the last update for 2023.
- Dec. 14, 2022, for 2022 candidates and committees.
- Dec. 3, 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_2024
176,731 rows in 12 tables
trad_pacs_cont, house_cont, house_exp, trad_pacs_exp, senate_cont, ...
campaign_finance_2023
26,518 rows in 8 tables
school_board_cont, school_board_exp, issue_comm_cont, super_pacs_exp, super_pacs_cont, ...
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