All posts by David McKie

About David McKie

DESCRIPTION This course will teach students how to locate, obtain, and read public records with an investigative mindset. Students will learn to probe public records to uncover connections and patterns of information that might be invisible from reviewing one record in isolation. Students will learn how public records fit into a complete research strategy with the aim of telling, investigative, original and breaking stories, or simply adding context to ongoing stories. View all posts by David McKie →

Canadian Small Arms Sales

May 13, 20162016 Toronto Watchdog WorkshopDavid McKie

Dinesafe

May 9, 2016Assignment 2David McKie

Eating establishments that the city of Toronto ticketed for violating the city’s food-safety bylaws.

BlackBerry

December 31, 2015VisualizationsDavid McKie

BlackBerry Stock Prices

BlackBerry Stock Prices by mckied on TradingView.com

Source: TradingView

A portion of BlackBerry’s financial statement annotated in DocumentCloud
(click inside the annotation to see the entire document and other annotations)

Source: BlackBerry

A BlackBerry Competitor: Samsung

Samsung by mckied on TradingView.com

Source: TradingView

Noise By-Law complaints

December 4, 2015Assignment 2David McKie

This a map that shows the noise bylaw complaints broken down by ward from Jan. 1, 2013 to Sept. 2015.

Source: The city of Ottawa’s open data site

Search and Rescue

December 3, 2015Assignment 2David McKie

This is a map of search-and-rescue operations in which the person who was lost had a unregistered beacon.

View larger map

Source: National Defence

Tim Hortons in City of Ottawa Wards

November 27, 2015Final_Data_AssignmentDavid McKie

This visualization represents the number violations Tim Hortons restaurants have received from Ottawa inspectors from 2009 to the first five months of 2015.

View larger map

Source: Ottawa Public Health food premises inspection reports
http://data.ottawa.ca/dataset/public-health-inspection-data