David and Fred are co-authors of
“The Data Journalist: Getting the Story“

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

How to use Statistics Canada’s Canadian International Merchandise (CIMT) web app
https://www.statcan.gc.ca/en/sc/video/CIMT-web-application

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

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

Labour Force Survey in brief: Interactive app
https://www150.statcan.gc.ca/n1/pub/14-20-0001/142000012018001-eng.htm

Gross domestic product (GDP) at basic prices, by industry, monthly, growth rates (x 1,000,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3610043402

Definition of the “chained dollars” reference in the GDP numbers
https://dictionary.university/Chained%20dollars

Real Gross Domestic Product definition
https://www.investopedia.com/terms/r/realgdp.asp

Census

Guide to the Census of Population, 2021
https://www12.statcan.gc.ca/census-recensement/2021/ref/98-304/index-eng.cfm

Dictionary, Census of Population, 2021
https://www12.statcan.gc.ca/census-recensement/2021/ref/dict/az/index-eng.cfm

Census release schedule
https://census.gc.ca/census-recensement/2021/ref/prodserv/release-diffusion-eng.cfm

Census Profile, 2021 Census of Population
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/prof/index.cfm?Lang=E

Census Program Data Viewer
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/dv-vd/cpdv-vdpr/index-eng.cfm

2021 Census – Boundary Files
https://www12.statcan.gc.ca/census-recensement/2021/geo/sip-pis/boundary-limites/index2021-eng.cfm?year=21

Census Profile, 2016 Census
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/page.cfm?Lang=E&Geo1=PR&Code1=01&Geo2=&Code2=&SearchText=Canada&SearchType=Begins&SearchPR=01&B1=All&TABID=1&type=0

2016 Census – Boundary files
https://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2016-eng.cfm

Statistics Canada Instagram releases
https://www.instagram.com/statcan_eng/

Statscan medium income release on Instagram
https://www.instagram.com/p/CgxeqApLtVB/

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

Federal institutions

High inflation is hitting people on fixed disability benefits hard
https://www.cbc.ca/news/business/inflation-disability-benefits-odsp-canada-benefits-cpp-1.6427751

Question Period Note: Cbc news story: high inflation is hitting people on fixed disability benefits hard
https://search.open.canada.ca/qpnotes/record/esdc-edsc,EWDDI-JUN2022-012

Annual reports on public opinion research
https://www.tpsgc-pwgsc.gc.ca/rop-por/rapportsannuels-annualreports-eng.html

Search for a report
https://library-archives.canada.ca/eng/services/government-canada/public-opinion-research/pages/search-por-reports.aspx#a1

Search for reports older than six months (NOTE: In the search bar use “Public opinion research” in quotes, the AND operator and then the keyword such as “immigration”)
https://recherche-collection-search.bac-lac.gc.ca/eng/Home/Search?q=public+opinion&num=25&start=0&DateBucket=2020-2029

Government of Canada Public Opinion Research Reports
https://epe.lac-bac.gc.ca/100/200/301/pwgsc-tpsgc/por-ef/index.html

Polling Fundamentals
https://ropercenter.cornell.edu/polling-and-public-opinion/polling-fundamentals

Angus Reid Institute
https://angusreid.org/

Leger
https://leger360.com/

Nanos Research
https://nanos.co/

Abacus Data
https://abacusdata.ca/

The Bank of Canada
https://www.bankofcanada.ca/

Statistics Canada
https://www.statcan.gc.ca/en/start

Office of the Superintendent of Bankruptcy
https://ised-isde.canada.ca/site/office-superintendent-bankruptcy/en

Office of the Superintendent of Bankruptcy – open data portal
https://search.open.canada.ca/en/od/?od-search-portal=Open+Data&search_text=office+of+the+superintendent+of+bankruptcy

Canadian Institute for Health Information
https://www.cihi.ca/en

Canada Revenue Agency – List of Charities
https://apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch?request_locale=en

COVID-19 vaccination in Canada
https://health-infobase.canada.ca/covid-19/vaccine-administration/

Canadian Housing and Mortage Corporation
https://www.cmhc-schl.gc.ca/en/

Boundary Files

COVID-19 in Ottawa Neighbourhoods
https://www.neighbourhoodstudy.ca/covid-19-in-ottawa-neighbourhoods/

Toronto neighourhoods
https://open.toronto.ca/dataset/neighbourhoods/

Toronto City Wards
https://open.toronto.ca/dataset/city-wards/

Ministry of Health Public Health Unit Boundary
https://geohub.lio.gov.on.ca/datasets/ministry-of-health-public-health-unit-boundary/data?geometry=-168.377%2C38.920%2C-1.122%2C58.787

COVID-19 in Ontario
https://covid-19.ontario.ca/
https://data.ontario.ca/dataset?keywords_en=COVID-19

Visualizations

Tableau desktop
https://www.tableau.com/products/desktop

Tableau Public
Discover | Tableau Public

ArcGIS Online
https://www.arcgis.com/home/index.html

QGIS
https://qgis.org/en/site/

Interactive data visualizations of COVID-19 – Government of Canada
https://health-infobase.canada.ca/covid-19/visual-data-gallery/

INTERACTIVE GRAPHICS: Emily Victoria Viegas’s death puts spotlight on increasing spread of COVID-19 in younger people in third wave

https://www.thestar.com/news/gta/2021/04/26/emily-victoria-viegass-death-puts-spotlight-on-increasing-spread-of-covid-19-in-younger-people-in-third-wave.html

WHO pandemic timeline
https://www.who.int/emergencies/diseases/novel-coronavirus-2019/interactive-timeline#event-72

Cumulative COVID-19 vaccination does administered per 100 people — Our World in Data
https://bit.ly/3gfGKvr

Coronavirus World Map: Tracking the Global Outbreak
https://www.nytimes.com/interactive/2020/world/coronavirus-maps.html?action=click&module=Top%20Stories&pgtype=Homepage

Stories

Despite pandemic, Canada’s population grows at fastest rate in G7: census
https://www.cbc.ca/news/politics/census-2021-release-population-cities-1.6344179

Canadian census data shows rise in households with multiple generations of families
https://globalnews.ca/news/8986133/canada-census-data-families-2021/

Linguistic diversity on the rise in Canada: census
https://montreal.citynews.ca/2022/08/17/linguistic-diversity-canada-census/

Population share of immigrants, permanent residents hits 23% record: census
https://www.cbc.ca/news/politics/statistics-canada-immigration-census-1.6629861

Census shows high rate of undergraduate and college education among Canadians, but complex trends lie behind it
https://www.theglobeandmail.com/canada/article-census-2021-university-college-graduate/

Census data shows 300,000 Quebec kids eligible for English school, 76% attend
https://www.cbc.ca/news/canada/montreal/english-school-statscan-1.6669265

Ontario just released its 2021 Sunshine List of $100K+ earners. See it for yourself
https://www.cbc.ca/news/canada/toronto/ontario-2021-sunshine-list-1.6397437

Power Gap – The Globe and Mail
https://www.theglobeandmail.com/topics/powergap/

Canada’s unemployment rate declined slightly to 5.1 per cent, wages grow again
https://www.ctvnews.ca/business/canada-s-unemployment-rate-declined-slightly-to-5-1-per-cent-wages-grow-again-1.6177979

L6P – The Globe and Mail
https://www.theglobeandmail.com/topics/l6p/

Hate crimes underreported, Halifax police chief tells board of commissioners
https://www.cbc.ca/news/canada/nova-scotia/polic-commission-hate-crimes-reporting-1.6074252

Canada’s data gaps hampered COVID-19 pandemic response, hurting vaccination tracking: report
https://www.theglobeandmail.com/canada/article-canadas-data-gaps-hampered-pandemic-response-hurting-vaccination/

Case study

‘Scared to death to go to school’: York Memorial students stage mass walkout amid concerns over violence, teacher shortage
https://www.thestar.com/news/gta/2022/12/02/scared-to-death-to-go-to-school-york-memorial-students-stage-mass-walkout-amid-concerns-over-violence-teacher-shortage.html

‘Scared to death to go to school’: York Memorial students stage mass walkout amid concerns over violence, teacher shortage (uploaded as a PDF)
http://www.davidmckie.com/Scared to death to go to school.pdf

York Memorial Collegiate Institute
https://schoolweb.tdsb.on.ca/yorkmemorial

York Memorial Collegiate Institute (Google Maps)
https://bit.ly/3gZUcbs

York Memorial Collegiate Institute – Instagram
https://www.instagram.com/explore/tags/yorkmemorialcollegiateinstitute/

York South-Weston
https://www.toronto.ca/city-government/data-research-maps/neighbourhoods-communities/ward-profiles/ward-5-york-south-weston/

York South-Weston – census profile 2016-2018
https://www.toronto.ca/wp-content/uploads/2018/09/96e6-City_Planning_2016_Census_Profile_2018_25Wards_Ward05.pdf

For Youth Initiative
https://www.foryouth.ca/

Parents of Black Children
https://parentsofblackchildren.org/our-story/

Elementary and secondary schools — Ontario data portal
https://data.ontario.ca/en/dataset?q=elementary+and+public+schools&sort=score+desc%2C+metadata_modified+desc

Elementary and secondary schools — Ontario data portal – uploaded to Google Sheets
https://docs.google.com/spreadsheets/d/1HhKF_ectrNY7aOnvv7FSL0JimDxxERdJBkXa5Nz7i5c/edit#gid=2108839762

Elementary and secondary schools — Ontario data portal – saved in an Excel workbook
http://www.davidmckie.com/School information and student demographics_en_november2022.xlsx

Census Program Data Viewer
https://www12.statcan.gc.ca/census-recensement/2021/dp-pd/dv-vd/cpdv-vdpr/index-eng.cfm

Immigration and income – Toronto – Census 2021 – ArcGIS Online
https://cdn-mediaprogram.maps.arcgis.com/home/webmap/viewer.html?webmap=5f8c6344b60f4a6c86e05c4bee0e9a37