
Reporting Tools
Tracking Legislator Activity Template
Use this template to track the actions and activity of elected officials at the state or federal level. The sheets allow you to track legislation they have been involved in, committee assignments, their connections to lobbyists, and interactions with major donors.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Reporting Recipe: Finding overlap in congressional candidates' campaign finance records
This reporting recipe explains how we automated the process of downloading campaign committees’ fundraising and spending records to find overlap among multiple candidates’ donors and recipients.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Reporting Recipe: PPP Loans
The U.S. Small Business Administration backed and distributed PPP loans to help businesses keep their workforce employed during the COVID-19 crisis from April 2020 to May 2021. The following is a step-by-step guide you can use to identify PPP loans to political candidates, their businesses and their spouses.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Reporting Recipe: How to Track Undisclosed Political Billboard Spending
Political campaigns often use billboards to spread their message, but the spending isn't always fully disclosed in campaign finance reports. This guide will help reporters investigate reported campaign spending and billboard advertising in their communities, potentially uncovering discrepancies.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Timeline and Source List
The Sunlight Research Center Timeline and Source List is a spreadsheet template for collecting data that can be used to create a Candidate Accountability Timeline in SRC’s format, as well as a Source List for organizing information pertaining to individuals associated with candidates.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Personal Financial Disclosure Analysis - Template - House of Representatives
This template can be used to organize data presented in Schedule A of the U.S. House of Representatives Personal Financial Disclosure form. Use it to approximate candidates’ personal wealth and holdings by income type and time range and to see changes in wealth over time.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Personal Financial Disclosure Analysis - Template - Senate
This template can be used to organize data presented in all seven sections of the U.S. Senate Personal Financial Disclosure form. Use this template to approximate candidates’ payments, income, donations, gifts, liabilities and personal wealth and holdings by income type and time range and to analyze changes in wealth over time.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |
Advanced Internet Search Guide
Use the Advanced Internet Search Guide to find exactly what you're looking for on the web. It explains all of the search operators you can use in Google and other search engines, provides search tips and strategies, and lists the search engines that can find what Google can't.
Type: | Reporting Tools |
Created by: | Sunlight Research Center |