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://www.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
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.
Population estimates, July 1, by census metropolitan area and census agglomeration, 2016 boundaries
Focus on Geography Series, 2016 Census
Following Money
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
Elections Canada: Financial Returns Registered Parties
Elections Alberta – Financial Disclosures
Office of the Superintendent of Bankruptcy Canada
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
Tutorials
To obtain the pivot table tutorial, please click here.
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.