No database yet exists where consumers can easily look up costs. KQED teamed up with ClearHealthCosts.com 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.
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.
California 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.
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.
I created an interactive flash game for The Chronicle/SFGate.com on California water usage and wrote a full page article for the paper on distribution issues. Over three months I conducted all of the reporting and did all of the shooting and production myself.
View the game.
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.
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
Before the Olympics I went to Beijing for the Washington Post. With six other reporters I helped report and produce a series of stories about everyday life of Beijingers in San Francisco and back in Beijing. I designed and developed the Web project.
View the project.
Using archival images and current videos this interactive timeline explains how the Your Black Muslim Bakery developed and their legal entanglements, including the murder of journalist Chauncey Bailey. I reported and produced this timeline with Rhyen Coombs.
Working with a team of reporters and producers I helped redesign the Chauncey Bailey Project Web site. I was a part of the design, implementation and outreach for the site.
View it here.