#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: Nov. 2 for school board, issue committees and super PACs, and Nov. 2 midday for outside spending on school board contests. 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

23,329 rows in 8 tables

school_board_cont, school_board_exp, super_pacs_cont, issue_comm_cont, super_pacs_exp, ...

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

state_iec