http://carleton.ca/fpa-professionalinstitute/data-journalism/
David McKie
181 Queen Street
1-613-288-6523 (office)
1-613-290-7380 (cell) 1-613-288-6490 (fax)
Email: david.mckie@cbc.ca
Twitter: @mckiedavid
Glen McGregor
Senior Parliament Hill correspondent for CTV News
Email: sushiboy21@gmail.com
Twitter: @glen_mcgregor
Open data sites
Alberta
http://data.alberta.ca/
Alberta Historical Wildfire Database
http://wildfire.alberta.ca/wildfire-maps/historical-wildfire-information/historical-wildfire-database.aspx
Civil Aviation Daily Occurrence Reporting System (CADORS) – Transport Canada
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng
Edmonton
http://data.edmonton.ca/
Edmonton Fire Response – History
https://data.edmonton.ca/Emergency-Services/Fire-Response-History/3s7f-z7ut
Elections Ontario political donations
https://www3.elections.on.ca/internetapp/efsearch.aspx?lang=en
Elections Alberta
http://efpublic.elections.ab.ca/efCXDataExtract.cfm?MID=CX_DATA
Elections Canada Political Donations
http://www.elections.ca/WPAPPS/WPF/EN/CCS?returntype=1
Federal Contaminated Sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Federal Electoral Districts – Canada 2013
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/56124851-71fc-4f94-8df2-40f59cd1dd46.html
Federal government open data portal
http://open.canada.ca/en/open-data
NHS Profile, Canada, 2011
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/page.cfm?Lang=E&Geo1=PR&Code1=01&Data=Count&SearchText=01&SearchType=Begins&SearchPR=01&A1=All&B1=All&Custom=&TABID=3
Municipal Boundaries – ON – Ontario
http://open.canada.ca/data/en/dataset/d2335f47-a49a-49cc-9257-26d6d4b5b039
Offender Profile 2013-2014 Correctional Services of Canada http://open.canada.ca/data/en/dataset/106fbf2d-bfdb-4e82-9aef-7ad46bf6ffd2
Ontario Public sector salary disclosure 2015: all sectors and seconded employees
https://www.ontario.ca/page/public-sector-salary-disclosure-2015-all-sectors-and-seconded-employees
https://www.ontario.ca/page/public-sector-salary-disclosure-act-disclosures-2014
Proactive Disclosure – Contracts over $10,000
http://open.canada.ca/data/en/dataset/d8f85d91-7dec-4fd1-8055-483b77225d8b
Refugee Claim Data and IRB Member Recognition Rates – 2015
http://ccrweb.ca/en/2015-refugee-claim-data
Temporary Foreign Worker System 2008-2015
http://open.canada.ca/data/en/dataset/c65d2014-ef25-4781-b9b2-e13a7293b72d
Toronto City Wards
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD#C
Trade Data Online (TDO) (Innovation, Science and Economic Development Canada)
https://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Vancouver
http://data.vancouver.ca/
Completed Access to Information Requests
http://open.canada.ca/en/search/ati
Stories about open data sites
City of Lethbridge launches innovative Open Data Catalogue online
http://globalnews.ca/news/2364381/city-of-lethbridge-launches-innovative-open-data-catalogue-online/
Calgary-based app maps out sports fields and courts
http://metronews.ca/news/calgary/1372887/calgary-based-app-maps-out-sports-fields-and-courts/
Edmonton’s open data initiatives rank #1 among 34 Canadian cities
http://globalnews.ca/news/2456703/edmontons-open-data-initiatives-rank-1-among-34-canadian-cities/
How the quest for a bike collision map opened up city data in Edmonton
http://metronews.ca/news/edmonton/1374445/how-the-quest-for-a-bike-collision-map-opened-up-city-data-in-edmonton/
New Vancouver website will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/
Montreal embraces new ‘open by default’ data policy
http://montrealgazette.com/news/local-news/montreal-embraces-new-open-data-policy
New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments
Data journalism stories
Beech Street fire hydrant has netted city $65,000 since 2008
http://ottawacitizen.com/news/local-news/beech-street-fire-hydrant-has-netted-city-65000-since-2008
How to avoid Toronto’s parking ticket hot spots
https://www.thestar.com/news/gta/2016/05/15/how-to-avoid-torontos-parking-ticket-hot-splots.html
Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html
New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments
NSA Files: Decoded
http://www.theguardian.com/world/interactive/2013/nov/01/snowden-nsa-files-surveillance-revelations-decoded#section/1
Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320
Ontario Sunshine List of highest-paid public sector employees reveals thousands earn more than premier
http://www.cbc.ca/news/canada/toronto/ontario-sunshine-list-1.3505138
‘Open data’: Why it’s making waves across Canada
http://www.cbc.ca/news/technology/open-data-movement-canada-1.3557562
The 100 WORST landlords in Toronto
http://www.landlordwatch.com/
The 15 worst restaurant offenders according to DineSafe
http://www.blogto.com/eat_drink/2015/08/the_15_worst_restaurant_offenders_according_to_dinesafe/
This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html
Toronto data reveals hundreds of discarded syringes
https://www.thestar.com/news/gta/2013/08/15/toronto_data_reveals_hundreds_of_discarded_syringes.html
Walmart: Thousands of police calls. You paid the bill.
Data Journalism Tools
Tableau
Trade Data Online (TDO)
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home?OpenDocument#tag
Installing the Tableau Add-In for Reshaping Data in Excel
http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel
To download the Canada small arms trade data export tutorial, please click here.
To download Industry Canada’s small arms sales data, click here.
To download the city of Toronto’s Dinesafe data, please click here.
MySQL
Ontario political donations surge, plunge around key policy decisions, Radio-Canada finds
http://www.cbc.ca/news/canada/toronto/ontario-political-donations-1.3588320
To download the Windows version of MySQL downloading tutorial, please click here.
To download the Mac version of the MySQL downloading tutorial, please click here.
MySQL Crash Course by Ben Forta
http://www.forta.com/books/0672327120/
Mapping
Toronto data reveals hundreds of discarded syringes
https://www.thestar.com/news/gta/2013/08/15/toronto_data_reveals_hundreds_of_discarded_syringes.html
ArcGIS
https://www.arcgis.com/features/
To download the ArcGIS online tutorial, please click here.
Qgis
http://www.qgis.org/en/site/
To obtain the instructions for downloading Qgis, please click here
To download the first Qgis tutorial, please click here.
Check out this national inventory of federal buildings containing asbestos
http://www.cbc.ca/news/canada/ottawa/multimedia/check-out-this-national-inventory-of-federal-buildings-containing-asbestos-1.3555956
Google Fusion Tables
https://support.google.com/fusiontables/answer/2571232?hl=en
Tutorials
To download the voter turnout tutorial in Qgis, please click here.
To download the contaminated sites tutorial in Qgis, please click here.
To download the ArcGIS Online tutorial, please click here.
To download the Canada small arms trade data export in Tableau tutorial, please click here.
David’s datasets
Ontario 2014-15 sunshine list — please click here to download.
To download the city of Toronto’s Dinesafe data, please click here.
To download Infrastructure Canada’s Projects dataset, please click here.
To download Transport Canada’s recall dataset, please click here.
To download the Correctional Service of 2013-2014 offender profile dataset, please click here.
To download the Treasury Board’s contracts data, please click here.
To download the 2015 Immigration and Refugee Board statistics worksheet, please click here.
To download Industry Canada’s Canadian Trade Balances spreadsheet, please click here.
To download Industry Canada’s Canadian Trade Balances spreadsheet, please click here.
To download the city of Ottawa’s 311 data, please click here.
To download federal campaign donation data
To download the library of Excel routines, please click here.
To download the voter turnout csv file, please click here.
To download the voter turnout csvt file, please click here.
To download my Elections Canada access to information request for political donations, please click here.
To download Elections Canada sample datasets from the the agency’s website and a similar dataset obtained through access to information, please click here.
Glen’s datasets
Or you can download the zip file here.
Resources
Computer-Assisted Reporting: A Comprehensive Primer
http://www.staples.ca/en/Computer-Assisted-Reporting-A-Comprehensive-Primer/product_SS3546476_2-CA_1_20001
MySQL Crash Course
http://www.forta.com/books/0672327120/
Visualize This
http://book.flowingdata.com/
Your Right To Know
https://www.amazon.ca/Your-Right-Know-Government-Secrets/dp/177040211X