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
List of access to information and privacy coordinators by institution
https://www.tbs-sct.gc.ca/ap/atip-aiprp/coord-eng.asp
A list of open-data portals
http://davidmckie.com/open-data-portals/
Federal government research
https://www.canada.ca/en.html
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
Statistics Canada
StatCan release schedules
Statistics Canada’s data tables
Canada added 35,000 jobs in December, capping strong 2019 for employment
To obtain the Statistics Canada tutorial on using data tables, please click here.
CMA and CA tutorial
Population estimates, July 1, by census metropolitan area and census agglomeration, 2016 boundaries
Census Profile, 2016 Census
Census Profile, 2011 Census
Focus on Geography Series, 2016 Census
2016 Census – Boundary files
Following Money
Search Government Contracts
Search Grants and Contributions
Top public sector earners revealed in annual Alberta sunshine list
Public sector body compensation disclosure table
Alberta Public Disclosure of Salary and Severance
Ontario Public Disclosure of Salary and Severance
Federal public accounts
Elections Canada: Financial Returns Registered Parties
Elections Alberta – Financial Disclosures
Office of the Superintendent of Bankruptcy Canada
Alberta Lobbyist Registry
Lobbyists (Edmonton)
B.C. Lobbyists Registry
Federal Lobbyists Registry
Datasets for Download
Correctional Investigator Excel workbook on Indigenous incarceration
To download the data used in the Calgary speeding ticket series, please click here.
Gun registry for prohibited and restricted firearms
National Parole Board Pardon Statistics
Chrome Scraper
Tutorials
To obtain the pivot table tutorial, please click here.
Google Sheets guide
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.