FollowtheMoneyCO is a campaign finance data site operated by Sandra Fish. The site originated in 2020 as a joint project of the media collaborative COLab and the Colorado Sun, funded by the Colorado Media Project and the Colorado Sun.
The project 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.
Need more info on querying the data? Click here to read more about using SQL.
It's 2022, and we've got the data for candidates for state House, Senate and statewide offices, including University of Colorado Regent and Board of Education. We also have data spending and cash raised by super PACs, issue committees and traditional PACs and political parties.
The data comes from bulk downloads on TRACER, the state’s campaign finance data system.
Sandra Fish, the Colorado data journalist managing the project, uses Python, Pandas and Jupyter notebook to create the tables, which are pared down from the original and include full names for contributors and payment recipients. These names have not been standardized.
For legislative candidates, the TRACER data is merged with a list of candidate committee numbers. Other tables are created by selecting committee types.
Information about contribution limits for various types of committees may be found on this page, from the Secretary of State’s Office. The Campaign Finance Institute also offers an interactive database of campaign finance and disclosure laws in all 50 states, which is a great way to compare Colorado to other states.
If you have questions, requests or feedback please email fishnette(at)gmail.com
The 2022 tables include:
Table name | Description |
---|---|
house_exp | Spending by state House candidates |
house_cont | Fundraising by state House candidates |
issue_comm_cont | Fundraising by issue committees, including small-donor issue committees (typically these work on state or local ballot initiatives). Keep in mind that some of these committees were focused on 2021 satewide issues. |
issue_comm_exp | Spending by issue committees |
cand_loans | Loans by legislative candidates to their campaigns. This includes repayments, to the balance is the best number to use. Also check the loan date, as some may have been made in prior campaign cycles. |
senate_exp | Spending by state Senate candidates. This is limited only to candidates for 2022 and includes data from 2019 through the present. |
senate_cont | Fundraising by state Senate candidates. This is limited only to candidates for 2022 and includes data from 2019 through the present. |
state_cont | Fundraising by candidates for governor, attorney general, secretary of state, treasurer, state board of education and CU regents. This includes data from 2019 through the present. |
state_exp | Spending by candidates for governor, attorney general, secretary of state, treasurer, state board of education and CU regents. This includes data from 2019 through the present. |
super_pacs_cont | Fundraising by independent expenditure committees and 527 committees. Both of these committees may accept unlimited contributions from individuals or corporations. Key caveat: Some groups have both IECs and 527s with one committee taking donations and passing them to another. Examining the committee_type is essential to avoid double-counting. |
super_pacs_exp | Spending by independent expenditure committees and 527 committees. Both these committees may spend unlimited amounts of money to support or oppose candidates as long as they don’t coordinate with the candidates. |
trad_pacs_cont | Fundraising by traditional political action committees, political party committees and small donor committees. |
trad_pacs_exp | Spending by traditional political action committees, political party committees and small donor committees. |