Image

Innovation

Statscan to make yet more data available at no cost

Statistics Canada is going to make more of its data available to the public without charge, a move that has been years in the making.

Continue Reading Statscan to make yet more data available at no cost

Citizen reporter posts gun registry data

The federal government’s plan to destroy the data in the doomed long-gun registry has prompted an Ottawa Citizen reporter to publicly post a copy of registry data he obtained for a 2007 series published in the newspaper. Glen McGregor hopes this will preserve at least some of the data for future research.

 

Continue Reading Citizen reporter posts gun registry data

Global News shares data with the world

Now, here’s a breath of fresh air. Global News is going to make data it obtains for its own projects available to the public. It has already posted the data it used for an a mapping project on dangerous intersections in Toronto.
Continue Reading Global News shares data with the world

A slow march to open data

The federal government’s first, hesitant step toward an open-data policy is to be praised, even if so far it is unclear if it represents a real move to openness or is more of a public relations gesture. 
Continue Reading A slow march to open data

Remembing Toronto’s war dead

Patrick Cain, a CAR guy who became best know for his online maps at the Toronto Star, has produced a fascinating map of Toronto depicting the addresses of family of more than 3,000 people who died in the Second World War. It’s not journalism of the usual kind, but it will be of interest to war buffs, historians and anyone wanting to better understand their or their city’s connection to those who perished serving Canada in that brutal conflict.
Continue Reading Remembing Toronto’s war dead

Star series highlights advances in CAR

A new Toronto Star series shows just how far computer-assisted reporting has come. Race Matters is a follow up the monumental 2002 Race and Crime project.  Reporter Jim Rankin fought seven years to obtain several police databases and found police were three times more likely to stop and question blacks than they were to do the same to whites. The new series uses web-based Flash maps to help the reader drill down into the details.

Continue Reading Star series highlights advances in CAR

Ottawa releases pictures of data to ATI requesters

A number of journalists filing requests for data to federal departments are finding the “data” has been converted to image files, quite literally pictures of data, prior to release. This has the potential to take access to electronic records back a decade if the trend spreads.
Continue Reading Ottawa releases pictures of data to ATI requesters

Click and the hyperlinks are gone

Once in a while software designers do something little that makes life
a lot easier.  The folks at Microsoft have done that by adding
a shortcut command to remove hyperlinks from cells in Excel
2010. I’ve been testing the beta version to see what
it offers for journalists.

If you have ever cut and pasted some data that has hyperlinks from the Web into Excel you have no doubt found…
Continue Reading Click and the hyperlinks are gone

New Excel feature takes data analysis to new levels

Reporters who use Microsoft Excel to crunch government data have something to cheer about with the release of the beta version of Office 2010. A new add-in to Excel brings Excel’s ease of use to the analysis of huge datasets.
Continue Reading New Excel feature takes data analysis to new levels

Office 2010 Beta imminent

Love it or hate it, Microsoft Office is the king of the mountain when it comes to desktop spreadsheet and database software, and you’ll soon be able to have a close up look.
Continue Reading Office 2010 Beta imminent