David McKie
Email Address:
davidmckiec@gmail.com
Phone Number:
613-290-7380
Government Open Data Portals
Federal
The Open Data Charter
https://opendatacharter.net/who-we-are/
Open Data 101
https://open.canada.ca/en/open-data-principles
Open Government – Proactive disclosure and access to information
https://open.canada.ca/en
Open Data Portal
https://open.canada.ca/en/open-data
Federal mandate letters
https://pm.gc.ca/en/mandate-letters
Information about programs and holdings
https://www.canada.ca/en/treasury-board-secretariat/services/access-information-privacy/access-information/information-about-programs-information-holdings.html
Orders In Council – Search
https://orders-in-council.canada.ca/index.php?lang=en
Prime Minister’s Office
https://pm.gc.ca/en
Orders In Council – Search
https://orders-in-council.canada.ca/
Provinces and territories
B.C.
http://www.openinfo.gov.bc.ca/ibc/index.page?
http://www.data.gov.bc.ca/
Alberta
http://data.alberta.ca/
Saskatchewan Open Data
http://www.opendatask.ca/
Manitoba
https://www.gov.mb.ca/openmb/index.html
Ontario
http://www.ontario.ca/government/open-data-ontario
Québec Ouvert (les données ouvertes pour le Québec)
http://quebecouvert.org/
New Brunswick
https://gnb.socrata.com/
Salaries
https://docs.google.com/spreadsheets/d/1KxsVzSQaPGpwj8aaGyduzAJMfmFbeekmKWrjZFwuQ1U/edit#gid=1771304169
Nova Scotia
https://data.novascotia.ca/
Newfoundland and Labrador
http://open.gov.nl.ca/
Prince Edward Island
https://data.princeedwardisland.ca/
Yukon
https://open.yukon.ca/data/
Northwest Territories
https://www.opennwt.ca/
Nunavut
https://open.canada.ca/data/en/dataset?keywords=Nunavut&page=1
Cities
Halifax
https://www.halifax.ca/home/open-data
Fredericton
http://www.fredericton.ca/en/open-data
Saint John
http://catalogue-saintjohn.opendata.arcgis.com/
St. John’s
http://www.stjohns.ca/event/open-data
Fredericton
https://www.fredericton.ca/en/about-fredericton/open-data-portal-0
Statisitics Canada
Consumer Price Index visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm
CPI uploaded to Google sheets
https://docs.google.com/spreadsheets/d/15Agd7WNl1vkfpmia7uiV9m-ePOtZUnRaFcqKlEEpe5g/edit#gid=1615938872
Statistics Canada’s data tables
Consumer Price Index visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm
Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm
Employment income statistics by occupation minor group, work activity during the reference year, age and gender: Canada, provinces and territories and census metropolitan areas with parts
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=9810045201
Labour Force Survey – Custom Tabulations
https://www150.statcan.gc.ca/n1/en/catalogue/71C0003
Average hourly wages by selected characteristics, Halifax and Toronto 2017- custom tabulation 2022https://docs.google.com/spreadsheets/d/199q4t2pNqePYm7anx4iJey3ZLRkfK4p2/edit#gid=795974839
KING’S STORIES USING LABOUR FORCE STORY CUSTOM TABULATIONS
https://signalhfx.ca/the-affordability-crisis-can-young-people-afford-to-live-in-halifax/
Employment by industry, census metropolitan areas, annual (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410038401
Employee wages by industry, monthly, unadjusted for seasonality
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410006301
Employee wages by occupation, monthly, unadjusted for seasonality
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410042601
Employee wages by occupation, annual
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410041701
Employment by industry, three-month moving average, unadjusted for seasonality (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410037901
Average hourly wages of employees, by sex and detailed age group, Canada, Halifax and Toronto Census Metropolitan Areas (CMA), 2017-2022 annual average – custom tabulation
https://docs.google.com/spreadsheets/d/1sr9f-sh6XZzAHq6GWXQgsarnKRt0HQ3ZZSFbNlnXZNQ/edit#gid=1671408072
Canadian International Merchandise Trade Web Application – explainer
https://www.statcan.gc.ca/en/sc/video/CIMT-web-application
Canadian International Merchandise Trade Web Application
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2021004-eng.htm
How to use Statistics Canada’s Canadian International Merchandise (CIMT) web app
https://www.statcan.gc.ca/en/sc/video/CIMT-web-application
International merchandise trade for all countries and by Principal Trading Partners, monthly (x 1,000,000)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1210001101
Canadian international merchandise trade by industry for all countries
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210013601
Canadian international merchandise trade by industry for all countries
https://open.canada.ca/data/en/dataset/cf26a8f3-bf96-4fd3-8fa9-e0b4089b5866
The International Trade Explorer, 2022
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2019005-eng.htm
Merchandise imports and exports, customs-based, by Harmonized commodity description and coding system (HS) section, Canada, provinces and territories, United States, states (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210009901
International merchandise trade by province, commodity, and Principal Trading Partners (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210011901
Trade Data Online
https://ised-isde.canada.ca/site/trade-data-online/en
Income of individuals by age group, sex and income source, Canada, provinces and selected census metropolitan areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1110023901
How to use Statistics Canada’s data tables
https://www.statcan.gc.ca/en/sc/video/howto
Unemployment rate, participation rate, and employment rate by type of student during school months, monthly, unadjusted for seasonality
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1410002101
Crime
HRM open data portal – crime
https://catalogue-hrm.opendata.arcgis.com/datasets/f6921c5b12e64d17b5cd173cafb23677_0/explore
Incident-based crime statistics, by detailed violations, Canada, provinces, territories, Census Metropolitan Areas and Canadian Forces Military Police
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017701
Police-reported crime statistics in Canada, 2022
https://www150.statcan.gc.ca/n1/daily-quotidien/230727/dq230727b-eng.htm
Police-reported crime in Canada, 2022
https://www150.statcan.gc.ca/n1/pub/11-627-m/11-627-m2023041-eng.htm
Police-reported hate crime, by type of motivation, Canada (selected police services) https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3510006601
Police-reported hate crime, by most serious violation, Canada (selected police services)
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3510006701
Police-reported hate crime, number of incidents and rate per 100,000 population, Census Metropolitan Areas and Canadian Forces Military Police
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510019101
Social inclusion indicators for Canada’s ethnocultural groups: Discrimination and victimization
https://www150.statcan.gc.ca/n1/pub/71-607-x/71-607-x2023014-eng.htm
Population
Census Profile, 2021 Census of Population
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/prof/index.cfm?Lang=E
Census Profile, 2016 Census
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E
Census Program Data Viewer dashboard
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/dv-vd/cpdv-vdpr/index-eng.cfm
Population estimates, July 1, by census metropolitan area and census agglomeration, 2016 boundaries
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1710013501
Population and Dwelling Count Highlight Tables, 2016 Census
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/pd-pl/Table.cfm?Lang=Eng&T=1903&S=3&O=D&RPP=50
Population estimates, July 1, by census metropolitan area and census agglomeration, 2016 boundaries
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710013501
Calculating rates using Ontario COVID-19 case-count data and Statistics Canada’s population estimates, July 1, by census subdivision, 2016 boundaries
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1710014201
Population estimates, quarterly
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=1710000901
Population estimates on July 1st, by age and sex
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501
Housing
Housing Market Information Portal
https://www03.cmhc-schl.gc.ca/hmip-pimh/en#Profile/1/1/Canada
Rental Market Survey Data Tables
https://www.cmhc-schl.gc.ca/professionals/housing-markets-data-and-research/housing-data/data-tables/rental-market/rental-market-report-data-tables
Immigration
Permanent Residents – Monthly IRCC Updates – Canada – Permanent Residents by Province/Territory and Immigration Category
https://open.canada.ca/data/en/dataset/f7e5498e-0ad8-4417-85c9-9b8aff9b9eda/resource/5582034d-8f89-49d5-8597-483d628078a1
Lobbyists
Federal lobbyist registry
https://lobbycanada.gc.ca/app/secure/ocl/lrs/do/guest?lang=eng
B.C. – Office of the Registrar of Lobbyists
https://www.lobbyistsregistrar.bc.ca/
Alberta Lobbyist Registry
https://www.albertalobbyistregistry.ca/apex/f?p=171:9996:11841761880093::::CMS_SITE,CMS_PAGE:ABLBY,HOME
Saskatchewan – Office of the Registrar of Lobbyistshttps://www.sasklobbyistregistry.ca/lobbyists/
Manitoba Lobbyist Registry
http://www.lobbyistregistrar.mb.ca/index.php?lang=en
Ontario – Office of the Integrity Commissioner: Lobbyists Registration
http://www.oico.on.ca/home/lobbyists-registration/overview
Quebec – Registre des lobbyistes
https://www.lobby.gouv.qc.ca/servicespublic/consultation/ConsultationCitoyen.aspx?id=0
New Brunswick – Lobbyist Registry
https://www.pxw1.snb.ca/snb9000/product.aspx?productid=A001PSNBCATLOBBY&l=e
Nova Scotia – Registry of Lobbyists
https://novascotia.ca/sns/lobbyist/
PEI – Lobbyist Registry
https://www.princeedwardisland.ca/en/feature/lobbyist-registry#/home/Lobbyist/Lobbyist
Environment/Health
Canada’s official greenhouse gas inventory – main page
https://www.canada.ca/en/environment-climate-change/services/climate-change/greenhouse-gas-emissions/inventory.html
Canada’s Official Greenhouse Gas Inventory – open data site
https://open.canada.ca/data/en/dataset/779c7bcf-4982-47eb-af1b-a33618a05e5b
Breakdown of Canada’s GHG emissions by economic sector (2021)
https://www.documentcloud.org/documents/23831848-en81-4-2021-1-eng#document/p30/a2262003
Canada’s total GHG emissions broken down by economic sector (2021)
https://www.documentcloud.org/documents/23831848-en81-4-2021-1-eng#document/p29/a2381636
Spreadheet tables for the GHG emissions breakdown
https://data-donnees.ec.gc.ca/data/substances/monitor/canada-s-official-greenhouse-gas-inventory/B-Economic-Sector/?lang=en
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
National Air Pollution Surveillance Program
https://www.canada.ca/en/environment-climate-change/services/air-pollution/monitoring-networks-data/national-air-pollution-program.html
Canadian Institute for Health Information
https://www.cihi.ca/en
Opioid- and Stimulant-related Harms in Canada
https://health-infobase.canada.ca/substance-related-harms/opioids-stimulants/
Following money
Canada Emergency Wage Support recipients
https://docs.google.com/spreadsheets/d/10QpdfHUizwHD9znORg5rOmuN2QvCe6IDoE0j9puZBhA/edit#gid=958399769
Convoy protest donors
https://docs.google.com/spreadsheets/d/1203QAGrL-AYijwUd6E_rWDtBMHd19w_t4BWQMh4xAPU/edit#gid=2079973935
Innovation, Science and Economic’s Canada corporation database for Atlantic Canada
https://docs.google.com/spreadsheets/d/1-Rmc7d4GULlj46TmZGCcNcTd85bAXYDLpBZ6gSJNOxA/edit#gid=634508513
Facebook Ad Library
https://www.facebook.com/ads/library/?active_status=all&ad_type=political_and_issue_ads&country=CA&media_type=all
Federal grants and contributions
https://search.open.canada.ca/grants/?search_api_fulltext=&owner_org=acoa-apeca&page=1&sort=agreement_start_date+desc
ACOA data loaded to Google Sheets
https://docs.google.com/spreadsheets/d/1fpsJo9mBZ5de9V4Yp-KZxQ3P9NUgWg1xIQpAARPAGRA/edit#gid=273287803
Fall Economic Statement 2023
https://open.canada.ca/data/en/dataset/c2cb858e-660b-44a8-821a-0fd849f20271
Search for a federal corporation
https://ised-isde.canada.ca/cc/lgcy/fdrlCrpSrch.html
Canada’s business registry
https://beta.canadasbusinessregistries.ca/search
Corporate Affairs Registry Database – New Brunswick
https://www.pxw2.snb.ca/card_online/Search/search.aspx
Canada Revenue Agency – List of Charities
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en
Quarterly balance sheet, income statement and selected financial ratios, by non-financial industries, non seasonally adjusted (x 1,000,000
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3310022501
Gross domestic product, income-based, quarterly (x 1,000,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3610010301
CEWS Registry Results
https://apps.cra-arc.gc.ca/ebci/habs/cews/srch/pub/fllLstSrh
CEWs scraped data in csv format
CEWs uploaded to Google Sheets
https://docs.google.com/spreadsheets/d/10QpdfHUizwHD9znORg5rOmuN2QvCe6IDoE0j9puZBhA/edit#gid=958399769
COVID-19 wage and rent subsidies for businesses
https://www.canada.ca/en/revenue-agency/services/wage-rent-subsidies.html
Office of the Superintendent of Bankruptcy
https://ised-isde.canada.ca/site/office-superintendent-bankruptcy/en
Elections and political donations
Tories best Liberals with record $8.5-million in second-quarter fundraising
Elections Canada: Financial Returns Registered Parties
42nd General Election: Official Voting Results
Elections Alberta – Financial Disclosures
The National Post’s Follow the Money Project
LAND-TITLE AND PROPERTY ASSESSMENT OFFICES(TOP)
The TitleSearchers.ca ( is a website of title searches / registry agents across Canada
Alberta Land Titles
http://www.servicealberta.ca/LandTitles.cfm
British Columbia Land Titles
https://www.bconline.gov.bc.ca/
Manitoba Property Registry
http://www.gov.mb.ca/tpr/land_titles/lto_offices/offices.html
New Brunswick Land Titles and Assessments
http://www.snb.ca/e/4000/4106e.asp
NewFoundland and Labrador Deeds
http://www.gs.gov.nl.ca/registries/deeds.html
Northwest Territories Land Titles
http://www.justice.gov.nt.ca/LandTitles/index.shtml
Nova Scotia’s Property Online
http://www.gov.ns.ca/snsmr/property/default.asp?mn=282.46.1064
Nunavut
http://www.justice.gov.nu.ca/i18n/french/legreg/lt_index.shtm
Ontario Land Registration Information
http://www.ontario.ca/en/information_bundle/land_registration/STEL01_130081.html
Prince Edward Island Registry of Deeds
http://www.gov.pe.ca/finance/index.php3?number=1007538&lang=E
Quebec Land Titles
https://www.registrefoncier.gouv.qc.ca/Sirf/Script/14_06_01-02/pf_14_06_01_reglr.asp
Saskatchewan Land Registry
http://www.isc.ca/LandTitles/Pages/default.aspx
Yukon Land Titles
http://www.justice.gov.yk.ca/prog/cs/index.html
Tutorials
Tutorial: A quick video how-to session on using the agency’s data tables.
https://www.statcan.gc.ca/eng/sc/video/howto
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.