Data journalism

I’ve been messing around with data journalism for years, and think I’ve only started to explore the possibilities. Here are some highlights of the past few years.

160611_poppy_file

For much of 2010, I was a contributing editor at openfile.ca, where my Poppy File project, which mapped Toronto’s Second World War deaths at the household level, won a Canadian Online Publishing Award and was shortlisted for an Online News Association award and a National Magazine Award.

OpenFile is no longer with us, but the map can be seen here. Since then, I’ve created First World War versions for Toronto, Winnipeg and Vancouver, and national maps for D-Day and Korea.

In Facts are Sacred, Simon Rogers described the Poppy File maps as “the pinnacle of what data journalism is supposed to be about.”

140304_driveclean

Nearly all recent car models pass their Drive Clean tests, Ontario government data shows. The story called the point of the mandatory testing program into question. The government defended it, but later dropped the $30 fee. The story won an RTDNA award.

Exclusive: Newer cars almost never fail Drive Clean. Why keep testing them?

Almost no one fails Drive Clean. But it’s needed anyway, Wynne argues


160410_AM

The leak of the Ashley Madison user data in August, 2015 created technical challenges because of the size of the databases, and also ethical challenges in how it could be used. We used the leaked data for several exclusive stories. The data included geotags created by users’ mobile devices which showed, often contrary to their claims, that over 1,200 were men seeking men in conservative countries where same-sex activities are harshly punished.

Where 1,296 gay Ashley Madison users face prison, flogging, execution

The economic benefits of casinos to communities can be debated, but data from Ontario’s lottery authority clearly shows another side of the story – all over the province, people with such a serious gambling problem that they volunteer to be charged with trespassing if they set foot in a casino are concentrated around casinos. It clearly implies that for some residents, the arrival of a casino led to their developing a gambling problem that they might otherwise have avoided.

The downtown Windsor postal code that houses the mammoth Caesar’s casino is also home to 248 self-excluded gamblers, which is just over 1 per cent of the population. In Windsor, self-excluded gamblers cluster around the casino site, with fewer of them found the further you get from downtown.

Across Ontario, desperate problem gamblers surround casinos

This story won a regional RTDNA award.

160611_intersections
In 2011, I mashed up the City of Toronto accident database with pedestrian counts to come up with a list of the city’s most dangerous intersections for pedestrians. The story led to several intersections being redesigned (though not the ones we wrote about).

The accident database was a rich source of story ideas:

Careful, last-minute shoppers: This is the worst week of the year for Toronto car crashes
Why do Toronto pedestrian accidents peak at the end of November?
Global News investigation sparks city plan for safer pedestrian intersections
Interactive map: Is sleepy Scarborough intersection the city’s most dangerous?
Fall daylight savings time correlates to a spike in pedestrian injuries
City committee to discuss dangerous pedestrian intersections
Toronto city councillor urges action on dangerous intersections