David McKie
1-613-290-7380 (cell)
Email: davidmckiec@gmail.com
David McKie and Fred Vallance-Jones are co-authors of
“The Data Journalist: Getting the Story”
You can also obtain a copy of The Data Journalist e-book.
You’ll need a Kobo device or reader
David, Fred, Rob Cribb and Dean Jobb are co-authors of
Digging Deeper Third Edition
David McKie and Jim Bronskill are co-authors of
Your Right To Know: How to Use the Law to
Get Government Secrets
David McKie and Jim Bronskill are co-authors of: Your Right To Privacy: Minimize Your Digital Footprint
About me
David McKie is now the National Observer’s deputy managing editor.
David teaches at the schools of journalism at Carleton University, the University of King’s College, and Ryerson University, and has co-authored three journalism textbooks and two user guides on freedom-of-information laws and privacy, respectively.
In addition to teaching, he is a data-journalism trainer who has conducted workshops for the Canadian Association of Journalists, the U.S.-based National Institute for Computer-Assisted Reporting, the Humber Institute of Technology and Advanced Learning, and the Canadian Association of Community Television Users and Stations. David also continues to offer data-journalism training at the CBC.
He has a Bachelor of Journalism degree and a Master of Journalism degree from Carleton.
You can find more information on his online cv.
What is data journalism?
Generally speaking, data journalism describes three disciplines. First, the use of data analysis and mapping software to spot newsworthy trends; second, the ability to make people see your trend with the help of cloud-based visualization programs such as ArcGIS Online and Tableau Public; third, using coding skills to create interactive web pages and news applications.
It is also important to note that data is an example of one type of public record that journalists should be mining. Other public records include audits, minutes of meetings at federal, provincial and territorial legislatures and committees meetings of municipalities.
Data-driven COVID-10 Stories
Ontario families living in more racialized neighbourhoods less likely to send children back into classroom, Globe analysis finds
https://www.theglobeandmail.com/canada/article-ontario-families-living-in-more-racialized-neighbourhoods-less-likely/
2,000 COVID-19 cases missing from Toronto’s map of hot spots
https://www.cbc.ca/news/canada/covid-19-data-toronto-public-health-hot-spots-1.5598844?fbclid=IwAR0YCo65N1AltvM8kztaV9pQqY4zhh674m1TXZI6Q0nNVd_qN9JRJX_HKLk
Lockdown Delays Cost at Least 36,000 Lives, Data Show
https://www.nytimes.com/2020/05/20/us/coronavirus-distancing-deaths.html?campaign_id=60&emc=edit_na_20200520&instance_id=0&nl=breaking-news&ref=cta®i_id=29021587&segment_id=28630&user_id=6de68069fe244be82427d0bfd0d2af8e
Poverty and COVID-19: More data would help explain the connection
https://www.nationalobserver.com/2020/05/12/analysis/poverty-and-covid-19-more-data-would-help-explain-connection
Low-income neighbourhoods at higher risk of coronavirus
https://toronto.citynews.ca/2020/04/20/low-income-neighbourhoods-at-higher-risk-of-covid-19/
Toronto to begin tracking racial and socio-economic data in COVID-19 patients
https://toronto.ctvnews.ca/toronto-to-begin-tracking-racial-and-socio-economic-data-in-covid-19-patients-1.4926220
Award-winning data driven stories
Andreas Wesley, Anu Singh, Caitlin Taylor, Dan Taekema, David Common, Ellen Mauro, Jorge Barrera, Joseph Loiero, Sian Lloyd, Valerie Ouellet, David McKie
Peer-on-Peer Violence in Canadian Schools
CBC News
Inayat Singh, Naël Shiab, Romain Schué, Valérie Ouellet, Zach Dubinsky, Vincent Maisonneuve
Who’s behind Canada’s Most Active Airbnb Accounts?
CBC News / Radio-Canada – Investigative unit
Institute for Investigative Journalism and media partners
Tainted Water
IIJ / Toronto Star / Global News / Le Devoir / Regina Leader-Post / National Observer
Philippe Langlois, Sarah-Maude Lefebvre, Andrea Valéria
Combien gagnent vos élus?
Le Journal de Montréal – Bureau d’enquête
Bethanee Diamond, Ava Coulter, Ian Gibb, Piper MacDougall, Isabel Ruitenbeek, Julia-Simone Rutgers, Jane Sangster, Stacey Seward
Foreclosed
The Signal / University of King’s College, Halifax / The Coast / Pictou Advocate / Port Hawkesbury Reporter
Investintech — CAJ Data Journalism Scholarship
https://www.investintech.com/data-journalism-scholarship/winners/
https://noradnargel.wixsite.com/monsite
First place: Hidden Injustice; How U.S. courts cover up deadly secrets
https://www.reuters.com/investigates/section/usa-courts-secrecy/
Reuters
Second place: Ahead of the Fire
https://www.azcentral.com/in-depth/news/local/arizona-wildfires/2019/07/22/wildfire-risks-more-than-500-spots-have-greater-hazard-than-paradise/1434502001/
The Arizona Republic and the USA TODAY Network
Third place: Forced Out: Measuring the scale of the conflict in South Sudan
https://interactive.aljazeera.com/aje/2019/south-sudan-forced-out/index.html
Al Jazeera, supported by Pulitzer Center on Crisis Reporting, African Defence Review and Code for Africa
Honourable mention: Heat and Health in American Cities
https://www.npr.org/2019/09/03/754044732/as-rising-heat-bakes-u-s-cities-the-poor-often-feel-it-most
NPR
Code Red: Baltimore’s Climate Divide
https://cnsmaryland.org/interactives/summer-2019/code-red/index.html
The Howard Center For Investigative Journalism and Capital News Service at the University Of Maryland with additional work done by WMAR TV and Wide Angle Youth Media
Data Stories
Walmart: Thousands of police calls. You paid the bill.
http://www.tampabay.com/
‘We’re guinea pigs’: Canada’s oversight process for implanted medical devices stuns suffering patients
https://www.cbc.ca/news/health/implanted-files-medical-devices-icij-1.4909196
Open data portals
http://www.davidmckie.com/open-data-portals/
Federal websites
Federal government research
https://www.canada.ca/en.html
Open government – federal
https://open.canada.ca/en
Information about programs and information holdings
https://www.canada.ca/en/treasury-board-secretariat/services/access-information-privacy/access-information/information-about-programs-information-holdings/sources-federal-government-employee-information.html
Internal audit and evaluation – federal
https://www.canada.ca/en/treasury-board-secretariat/topics/audit-evaluation.html
https://www.canada.ca/en/treasury-board-secretariat/corporate/audit-evaluation-reports.html
Public opinion research reports — Library and Archives Canada
http://www.bac-lac.gc.ca/eng/porr/Pages/porr.aspx
Parliament of Canada
https://www.ourcommons.ca/en
Library of Parliament
https://lop.parl.ca/sites/PublicWebsite/default/en_CA
https://lop.parl.ca/sites/ParlInfo/default/en_CA/
A list of open-data portals
http://www.davidmckie.com/open-data-portals/
WE Charity to close operations in Canada
https://globalnews.ca/news/7324897/we-charity-close-operations-canada/
Canada Revenue Agency – List of Charities
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en
Personal bankruptcies fell to record low in April, but could be poised to soar
https://www.cbc.ca/news/business/consumer-insolvencies-1.5597996
Have you been bankrupt? You could become Minister of National Revenue
http://www.davidmckie.com/have-you-been-bankrupt-you-could-become-minister-of-national-revenue/
Charity Gospel for Asia files for creditor protection after $170M lawsuit
https://www.cbc.ca/news/canada/nova-scotia/gospel-for-asia-creditor-protection-subject-of-class-action-1.5656224
Office of the Superintendent of Bankruptcy Canada
http://www.ic.gc.ca/eic/site/bsf-osb.nsf/eng/home
Statistics Canada
Statistics Canada’s data tables
To obtain the Statistics Canada tutorial on using data tables, please click here.
StatCan August data reveals unemployment rate higher among visible minorities
https://globalnews.ca/news/7317436/statcan-august-data-reveals-unemployment-rate-higher-among-visible-minorities/
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Canada added 246,000 jobs in August, but employment still 1 million short of pre-COVID level
https://www.cbc.ca/news/business/canada-jobs-july-1.5712085
Labour Force Survey, August 2020
https://www150.statcan.gc.ca/n1/daily-quotidien/200904/dq200904a-eng.htm?HPA=1
Datasets
Political contributions all parties_Jan 1, 2019-Sept 17, 2020.zip
LabourForceSurvey_1410028701.xlsx
Tutorials
Sept 18, 2020, Magazine Association of BC Finding Stories in Numbers
https://www.youtube.com/watch?v=J2aFI9Iut1E&feature=youtu.be