Category Archives: Interactive


Price Check: A community-created guide to health costs

No database yet exists where consumers can easily look up costs. KQED teamed up with and KPCC to win a Knight Prototype Grant to ask users to help us make health care costs transparent. 

I led the product team at KQED, working closely with our partners to launch an embeddable form for users to submit how much their common medical procedures cost. That data then becomes searchable for others to use. View the project.

Displaying staffing rates for California nursing homes

Users can explore in detail the 645 nursing homes that gained the most under a 2004 law designed to help hire more caregivers and boost wages. The database shows each home’s revenue under the new law, net income, staffing rates and staffing wages. Also,¬† users can sort through facilities with a google map displaying homes that were under the state minimums and by county.

I built and designed this django database with data analyst Agustin Armendariz. The data all comes from information that we had collected while reporting and that we needed to crunch for the print story. Because of the sheer number of homes, we decided to automate it using Django, the Google Charts API and the Google Map API.

This story, and the multimedia accompaniments, was one of California Watch’s Pulitzer entries. The database, video and print stories were picked up and run in several newspapers across California, including the San Francisco Chronicle and Orange County Register and on KQED online.

Launching California Watch

California Watch websiteCalifornia Watch, a branch of the Center for Investigative Reporting, launched online in January 2010. I helped lead the development and design effort, working with contract designers and developers, editors and reporters to decide everything from new features, content organization, work flow and design. We brainstormed as an editorial team to decide on features, while I had daily Scrum meetings with the developers to work on implementation. I also led a team of four testers as the site went into production. Currently, I also work with a developer to implement new tools on the site.

It happens at midnight

My masters project explores the resurgence of midnight movies. The project won the 2009 ONA Small Team Student Award, the 2009 Wired Excellence in New Media Award and was a finalist for the 2010 SXSW Interactive Student award. It features more than 26 minutes of fully produced video and 3,000 words. I produced and shot the entire project myself over nine months.

View the project.

Dollars and change: Backing Obama in the Bay Area

I explored exactly how much money residents of the Bay Area were donating to Barack Obama and why through an interactive graph, data charts and videos. I was the team leader on this project and used the FEC database and Access to narrow down how much, in what amounts, when and where people donated from. I designed and coded all of the charts, reported, shot and produced video and assisted with the rest of the programming.

View the project.

SF Bay Guardian | Making a marriage

Jen and Iris flew over 2,000 miles from Atlanta, Georgia, determined to become legally recognized as a married couple – even if just for a moment.

They are one of the many couples flocking to San Francisco’s City Hall in the days leading up to the vote of Proposition 8, when Californians decide whether to ban same-sex marriage. I shot video, produced and helped with the flash production as part of a team of four.

View the project