David McKie
1-613-290-7380 (cell)
Email: davidmckiec@gmail.com
David and Fred are co-authors of
“The Data Journalist: Getting the Story“
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
Open Data Portals
A list of open-data portals
http://www.davidmckie.com/open-data-portals/
Statistics Canada
To obtain the Statistics Canada tutorial on using data tables, please click here.
Statistics Canada’s data tables
Population estimates, quarterly
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901
Population estimates on July 1st, by age and sex
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501
Census Profile, 2016 Census
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E
2021 Census dissemination planning
https://www12.statcan.gc.ca/census-recensement/2021/ref/prodserv/release-diffusion-eng.cfm
Changes made by businesses to adapt to the COVID-19 pandemic, by business characteristics
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3310025001
COVID-19 death comorbidities in Canada
https://www150.statcan.gc.ca/n1/pub/45-28-0001/2020001/article/00087-eng.htm
COVID-19 mortality rates in Canada’s ethno-cultural neighbourhoods
https://www150.statcan.gc.ca/n1/pub/45-28-0001/2020001/article/00079-eng.htm
Population and demography statistics
https://www.statcan.gc.ca/eng/subjects-start/population_and_demography
Infographic: Police-reported hate crime in Canada, 2019
https://www150.statcan.gc.ca/n1/pub/11-627-m/11-627-m2021021-eng.htm
Police-reported hate crime in Canada, 2019
https://www150.statcan.gc.ca/n1/pub/85-002-x/2021001/article/00002-eng.htm
Police-reported hate crime, by type of motivation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510006601
Police-reported hate crime, by most serious violation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510006701
Police-reported hate crime, number of incidents and rate per 100,000 population, Census Metropolitan Areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510019101
COVID-19 Datasets
Download today’s data on the geographic distribution of COVID-19 cases worldwide
https://www.ecdc.europa.eu/en/publications-data/download-todays-data-geographic-distribution-covid-19-cases-worldwide
Tableau COVID-19 hub
https://www.tableau.com/covid-19-coronavirus-data-resources
Coronavirus disease (COVID-19): Outbreak update
https://www.canada.ca/en/public-health/services/diseases/2019-novel-coronavirus-infection.html?topic=tilelink#a1
SANTÉ MONTRÉAL
https://santemontreal.qc.ca/en/public/coronavirus-covid-19/situation-of-the-coronavirus-covid-19-in-montreal/#c41383
COVID-19: Status of Cases in Toronto
https://www.toronto.ca/home/covid-19/covid-19-latest-city-of-toronto-news/covid-19-status-of-cases-in-toronto/
Elections and political donations
UCP leads Alberta political parties following third quarter fundraising
Elections Alberta – Financial Disclosures
Conservatives top Liberals in Q3 fundraising
Elections Canada: Financial Returns Registered Parties
October 21, 2019 Federal Election Results
The National Post’s Follow the Money Project
Environment
Facility greenhouse gas reporting: overview of 2019 reported emissions
https://www.canada.ca/en/environment-climate-change/services/climate-change/greenhouse-gas-emissions/facility-reporting/overview-2019.html
Greenhouse Gas Reporting Program data search
https://climate-change.canada.ca/facility-emissions/
Greenhouse Gas Reporting Program (GHGRP) – Facility Greenhouse Gas (GHG) Data
https://open.canada.ca/data/en/dataset/a8ba14b7-7f23-462a-bdbb-83b0ef629823
Health
Canadian Institute for Health Information
https://www.cihi.ca/en
National Air Pollution Surveillance Program
https://www.canada.ca/en/environment-climate-change/services/air-pollution/monitoring-networks-data/national-air-pollution-program.html
Global
World Bank Open Data
https://data.worldbank.org/
UNDATA
https://data.un.org/
OECD OPEN DATA
https://www.oecd.org/gov/digital-government/open-government-data.htm
World Health Organization Open Datasets
https://www.who.int/data/collections
International Energy Agency Open Data Portal
https://www.iea.org/data-and-statistics
Datasets
Global Hospitalization data.xlsx
Canadian GHG emissions data.xlsx
Tutorials
To obtain the pivot table tutorial, please click here.
Data Journalism Academy
https://sites.google.com/view/mj-basic-data-academy/home?authuser=0
https://sites.google.com/view/mj-basic-data-academy/excel-magic?authuser=0
Google Sheets guide in Excel worksheets
SpiceUpYourSheetLife_ExcelGoogleSheetTips_BenCollins.pdf
Create a pivot table in Google Sheets with the help of this tutorial.
To obtain the tutorial on calculating per cents, please click here.
To obtain the specialized functions tutorial, please click here.
Math Tools for Journalists
https://www.amazon.ca/Math-Tools-Journalists-Professor-Professional/dp/0972993746
Data Visualization: A Primer
https://open.canada.ca/en/data-visualization
Resources
All the Best Microsoft Excel Keyboard Shortcuts
https://www.howtogeek.com/361582/all-the-best-microsoft-excel-keyboard-shortcuts/
Excel Shortcuts for Mac to Make Your Life Easy
https://www.99signals.com/excel-shortcuts-for-mac/