#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 2021, there's information on fundraising, spending and loans for school board candidates, as well as fundraising and spending for issue committees at the state and local level. It's anticipated that outside spending for school board contests will be added.
Quickstart: Click on camp_fin_2021 and choose a table. Then 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 fish(at)coloradomediaproject.com.
Most recent update: Oct. 7 for school board and issue committies. Dec. 28 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.
camp_fin_2021
15,503 rows in 7 tables
school_board_cont, school_board_exp, super_pacs_cont, super_pacs_exp, school_board_loans, ...
campaign_finance_2020
360,697 rows in 17 tables
trad_pacs_cont, house_cand_cont, issue_comm_cont, house_cand_exp, senate_cand_cont, ...
outside_spending_2020
2,468 rows in 1 table