Kings Journalism banner

Module 7–Thursday morning and afternoon, June 30

Go back to main resources page

We will turn our attention to mapping, making sure that we have opened an Esri account.

Here are Emilie’s two first tutorials.

Here’s the PowerPoint that accompanies the second tutorial.

Once you have finished watching the tutorial, try creating the same map. It helps to have two screens, one with the tutorial, the other with your data.

If you have time, check out the second tutorial which covers story maps, which are powerful visual storytelling options.

Here’s the PDF version of the story map tutorial.

Emilie’s noon-hour live session.

Here are some links Emilie has provided.

Here are direct links to the articles and StoryMaps that will be highlighted:

Here’s our final live session.

Other helpful links

Below are helpful links, some of which we used for our exercises on previous days.

Statistics Canada

Statistics Canada Tables
https://www150.statcan.gc.ca/n1/en/type/data

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

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

Incident-based crime statistics, by detailed violations, Canada, provinces, territories and Census Metropolitan Areas
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=3510017701

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

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

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

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

Worldometer
https://www.worldometers.info/world-population/canada-population/

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

Population estimates on July 1st, by age and sex
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000501

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 vaccination in  Canada
https://health-infobase.canada.ca/covid-19/vaccine-administration/

List of charities and other qualified donees
https://www.canada.ca/en/revenue-agency/services/charities-giving/list-charities/list-charities-other-qualified-donees.html

Stories

CAJ Data Journalism finalists – 2021

Valérie Ouellet, Naël Shiab, Sylvène Gilchrist
White men make up a third of Canada’s population but a majority of MPs — here’s why
CBC News Investigative Unit / Radio-Canada

Analysis of candidacies during Canadian federal elections
https://ici.radio-canada.ca/info/codesource/code-ouvert/2021/elections/candidatures/analysis.nb.html

Dataset on the Demographics of Canadian Federal Election Candidates (2008-2019)
https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/MI5XQ6

Sample candidates  dataset

John Rieti, Angelina King, Katie Swyers, James Wattie
State of Our Schools
CBC News – Toronto

Sample schools dataset

Robyn Doolittle, Chen Wang, Tavia Grant
The Power Gap
The Globe and Mail

Sample salaries dataset

Tai Huynh
COVID-19 infection and vaccinations
The Local, Toronto

Kenyon Wallace, Ed Tubb, Brendan Kennedy
Making sense of COVID-19 data
Toronto Star

Toronto Star long-term-care analysis.xlsx

Toronto Star long-term-care analysis – Google Sheets

2021 Philip Meyer Award winners

The Wall Street Journal – How Tik Tok Figures You Out (first place)
Inside TikTok’s Algorithm: A WSJ Video Investigation – WSJ

The Wall Street Journal’s application form with story links and explanations of methodology
QUESTIONNAIRE_TikTok_WSJ.pdf
http://www.davidmckie.com/PRIMARY_TikTok_WSJ.pdf

The Palm Beach Post – ProPublica – Black Snow: Big Sugar’s Burning Problem (second place)
http://www.davidmckie.com/PBP_PP_BlackSnow_MeyerQuestionnaire.pdf
PBP_PP_BlackSnow_MeyerPrimaryMaterials.pdf

Asbury Park Press and ProPublica – “Gilded Badges: How New Jersey Cops Profit From Police Unions and Avoid Accountability” (third place)
APP_PP_GildedBadges_MeyerQuestionnaire.pdf
APP_PP_GildedBadges_MeyerPrimaryMaterials.pdf

Sigma Award winners 2022

The Sigma Awards Projects Database
https://sigmaawards.org/projects/

Go back to main resources page

We are proud to work with our partners and sponsors

Posted: June 29, 2022, 2:37 pm ADT
Modified: June 30, 2022, 9:27 pm ADT