Derek Willis is a news applications developer at ProPublica, focusing on politics and elections. He previously worked as a developer and reporter at The New York Times, a database editor at The Washington Post, and at the Center for Public Integrity and Congressional Quarterly. He began his journalism career at The Palm Beach Post. He is a co-founder of OpenElections, a project to collect and publish election results from all 50 states.
Our Congress API now lets programmers access lobbying data. It also lets them find congressional press releases that mention bills.
Our FEC Itemizer Database now tracks spending at hotels, restaurants and other facilities owned by the Trump Organization.
ProPublica’s database of campaign filings now includes spending by political committees at Trump Organization properties.
We asked readers to help us reconceive and redesign an interactive database that tracks Congress. Here’s how the process worked.
It’s not too early to think about reporting on the midterm elections. Get a head start using our free, near-real-time database.
Newly revealed records show sloppy practices that could put millions of people’s information at risk.
What you need to know about some new features in our Congress API, as well as details on our plans to turn off the Sunlight Congress API on Aug. 31.
Get data on House and Senate press releases and more bill information.
We analyzed more than 575 press releases from representatives and senators about the Affordable Care Act and its repeal. Democrats, we found, speak more often and are more united.
Here’s a status update for developers who use the Sunlight Congress API.
We’re relaunching a service that lets you make notifications when some key real-world things happen in Washington.
Politwoops tracks deleted tweets by public officials, including people currently in office and candidates for office.
‘America Comes First’ can’t seem to decide if it’s a PAC or a super PAC, but in either case its federal filings remain problematic.
The America Comes First PAC did not disclose its donors before Election Day. And its top funder is banned from the securities industry.
A status update on the projects we took over from the Sunlight Foundation