Data Bureau

Team of Globe and Mail reporters, editors, designers, developers, researchers and graphic artists dedicated to producing great journalism from data that serves our unique, Canadian audience.

[databureau]

The Harper government delivered their 2013 federal budget on Thursday, focusing on jobs, infrastructure and manufacturing. Here's a graphical summary of what's changed.

[databureau]

[databureau]

[databureau]

http://www.nytimes.com/interactive/2012/08/05/sports/olympics/the-100-meter-dash-one-race-every-medalist-ever.html

[databureau]

Sort and click all the Canadian Summer Games medalists

[treedance]

An Infographic Is

That about explains it, no?

See our interviews with Bitly’s Hilary Mason for more on working with data.

Image: An Infographic Is, by Karyn Lurie.

H/T: Chart Porn.

[sunfoundation]

The Most Popular Month for Birthdays

Amitabh Chandra, a professor of public policy at the Harvard University, earlier published a data table detailing how many babies were born in the United States on each date between 1973 and 1999. September 16th happens to be the most common birthday while December 25th is the least popular birthday

Matt Stiles, data journalist at NPR, converted this NYT table into a static heatmap for easy visualization (the darker the color, the higher the probability of births happening on that date) and Andy Kriebel made an interactive heatmap of the same data using Tableau – this version lets you hover over any cell and you can see the underlying data.

[databureau]

How Vancouver high school catchment areas compare

About half of all Vancouver School Board students attend a school outside their catchment area, and a majority of those chose schools on the city's west side.

The result is empty desks in the east and crowded schools in west. It's a problem playing out across the country, and some fear that by jumping boundaries, parents are undermining schools in some parts of their communities.

Explore the data behind Vancouver's high schools

[databureau]

[explore-blog]

All The News That’s Fit To Post – how the graphics department of The New York Times designs the world’s most respected newspaper, a teaser for Gestalten’s Visual Storytelling. 

[databureau]

Interactive: Where National Defence cuts hit hardest According to numbers provided by the Union of National Defence Employees, 1,093 civilian staff are receiving notices of “affected” status at Canadian Forces Bases across the country.

See the visualization

[databureau]

Infographic: Your 2012 federal budget explained

Use this infographic to explore the revenue, expenses, proposals and projections from the budget.

[databureau]

So you wanna be finance minister? Our game lets you try balancing Ottawa's books

Few issues stick to governments more than their ability to balance a budget. Today, Jim Flaherty releases a budget that aims to reassure Canadian taxpayers that his government is committed to returning to the black within a few years. But what does it take to eliminate the deficit? We've created a game that gives readers a taste of the decision making involved.

Read more on the methodology.

[databureau]

Which Ontario employees made the most money last year? Our tool helps you find out

The Ontario government released their annual Sunshine List on March 24, detailing public sector employees earning more than $100,000 per year. We created a table so readers can explore the list in more detail, letting you search, sort and filter by name, salary and more.

This list is published each year on the government’s website in a way that’s hard to search, impossible to sort and difficult to navigate. The Globe wanted to pull the data from this year’s list and publish it in a more usable way, as a tool for our reporters and our readers.

Here’s a little background on how we made the tool.

[databureau]

Census 2011: Data visualization in a media lockup

Early Wednesday morning, Statistics Canada released data for the first of five census 2011 topics: population and dwelling counts.

For the Globe and Mail, it was the first time ever that we've sent a member of our digital team to the census media lockup in Ottawa. The goal was to take a numbers-heavy story, break it down in a clear, visual way and publish it as quickly as possible so that the explainers could accompany the breaking news. Despite some internet connectivity issues at the lockup, it was pretty successful.

Advanced work was done to build the interactives ahead of time based on previous StatsCan numbers. Once in the lockup, our interactives developer was able to work with editors and reporters to add in the new numbers and make adjustments based on the new trends.

Together, the Globe and Mail staff on site created two interactive graphics: an interactive summary of the Census release itself, and a timeline chart showing the population of Canada by province over the past 55 years. The Canadian Press was also working on an interactive in the lockup and their map that allows users to zoom into their community is also on our site.

[databureau]

FlowingData's list of the 15 best data visualization projects of 2011.

[databureau]

Where do charities get their money? How many Canadians donate?

We analyzed Canada Revenue Agency and Statistics Canada data to show giving trends in Canada.

Recently updated with 2010 Stats Can data. CRA update to come a little later in the new year.