top of page

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

Finding State Personal Financial Disclosures

This document provides a state-by-state list of where to find or who to contact to obtain state-level personal financial disclosures for political candidates and elected officials.

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

Subscribe to stay up to date with Sunlight Research Center.

bottom of page