Exposing the Cost of Police Misconduct in Chicago

In researching Settling for Misconduct, a story on settlements and judgments of police misconduct, the Chicago Reporter had to account for details from hundreds of county and federal court filings, identify thousands of officers named in civil complaints, tally hundreds of millions of dollars in monetary awards and input all these data in a proper database. They also had to build a slick web app to present the data to the public. Here is how they did it.

Creative Ideas for Funding Independent Journalism

From South Africa to Brazil; from Yangon to Kabul, I heard media editors sing varying versions of the same lyrics: I feel the earth move under my feet. The media business model has now cracked all over the world. Subscriptions to newspapers and magazines drop by the thousands; traditional advertising revenue vanishes into thin air; and digital advertising revenue is poor and only seems to work for web giants. Media have certainly learnt how to increase the value of Facebook or Twitter in their quest to fish readers for their stories, but have plenty of trouble in finding how to increase the value of their own outlets.

How China’s Top Investigative Newsroom Digs for Data

China’s leading investigative news company, Caixin.com, is pushing the boundaries of data journalism in that country. In this exclusive look, Caixin Data Editor Huang Chen writes on how its journalists are using data in one of the toughest countries in the world to report on. Caixin’s challenges will sound strikingly familiar to Western data journalists: messy formats, unreliable data, and problems with access. Despite this, the team at Caixin is pushing forward in ways that should bring a cheer from its colleagues around the world.

The Data Sleuths of San José: How Costa Rican Reporters Used Data To Bring Down a System of Sleaze

In the fall of 2003 the story made its way to journalists at La Nación, the leading national newspaper in the Central American republic of Costa Rica. The reporters at the paper’s investigative unit pricked up their ears as soon as the disgruntled real estate agent spoke the name of her exasperating client: Eliseo Vargas, the man in charge of the country’s vaunted national health-care agency. “We didn’t really know what she had,” recalls reporter Ernesto Rivera.