CAJ 2023 — Whither data journalism

The data-journalism team after a long day

David McKie
davidmckiec@gmail.com

Tom Cardoso
TCardoso@globeandmail.com

Tara Carman
tara.carman@cbc.ca

Francesca Fionda
fionda.francesca@gmail.com

Chad Skelton
cskeltonnews@gmail.com

nathan griffiths
njgriffiths@gmail.com

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

Data journalism examples

Investigative Journalism Examples

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/

General investigations

The Smoke Comes Every Year. Sugar Companies Say the Air Is Safe.
https://projects.propublica.org/black-snow/

Stories from Black Snow: Big Sugar’s Burning Problem
http://www.davidmckie.com/PBP_PP_BlackSnow_MeyerPrimaryMaterials.pdf

Addressing Rape in Four Minutes or Less: Dating App Reps Left Unprepared to Respond to Assault Victims
https://bit.ly/3GrXD1X

Thousands of suspected injuries tied to breast implants revealed in manufacturer data dump, CBC analysis finds
https://bit.ly/3fpVVlM

“THEGRAVEYARDDOESN’T LIE”
https://www.buzzfeednews.com/article/peteraldhous/texas-winter-storm-power-outage-death-toll

https://drive.google.com/file/d/1nOcPZRrrS8j24-O0IHyPzbaCfjmBRreP/view?usp=sharing

Bias behind bars: A Globe investigation finds a prison system stacked against Black and Indigenous inmates
https://www.theglobeandmail.com/canada/article-investigation-racial-bias-in-canadian-prison-risk-assessments/

How we did it: How The Globe uncovered systemic bias in prisoners’ risk assessments
https://www.theglobeandmail.com/canada/article-investigation-racial-bias-in-canadian-prisons-methodology/

Toronto Star/National Observer: Generation Distress
https://ijb.utoronto.ca/projects/generation-distress/

Clean water broken promises
https://www.nationalobserver.com/tags/clean-water-broken-promises
https://storymaps.arcgis.com/stories/cbdc979bf27642bfba51689ca3c180e8

Decades after mercury poisoned the water, Grassy Narrows still searches for answers
https://www.nationalobserver.com/2021/06/16/decades-after-mercury-poisoned-water-grassy-narrows-searches-answers

Decades-old water pollution ravaged the health of 2 Ontario First Nations. Elders are still fighting for justice
https://www.nationalobserver.com/2021/09/02/water-pollution-ontario-first-nations-elders-environmental-justice

How an Ontario paper mill poisoned nearby First Nations
https://www.nationalobserver.com/2021/09/01/how-ontario-paper-mill-poisoned-nearby-first-nations

Where is data journalism heading?

Nathan Griffiths, Tom Cardoso, Francesca Fionda, Tara Carman, David McKie (moderator)

Session recording:
https://www.youtube.com/watch?v=5SRtugkXmyg

Deep dive: Unraveling the Canada Emergency Wage Subsidy

Session recording:
https://www.youtube.com/watch?v=odEpaMndbmc

Tom Cardoso, Nathan Griffiths

Links:

Tom’s Github page:
https://tomcardoso.github.io/cews-caj-2023/

CEWS Registry Results
https://apps.cra-arc.gc.ca/ebci/habs/cews/srch/pub/fllLstSrh

Bankrupt firms tapped federal wage subsidy despite long odds of survival
https://www.theglobeandmail.com/business/article-bankrupt-firms-tapped-federal-wage-subsidy-despite-long-odds-of/

Wage subsidies were meant to preserve jobs. In many cases, the $110.6-billion response padded bottom lines
https://www.theglobeandmail.com/business/article-canada-emergency-wage-subsidy-data-analysis/

CEWS: A massive subsidy, shrouded in secrecy
https://www.theglobeandmail.com/business/article-cews-a-massive-subsidy-shrouded-in-secrecy/

Data journalism 101: Reporting with data

Session recording:
https://www.youtube.com/watch?v=iJCumGXVQ6Y

Nathan Griffiths, Francesca Fionda, Tara Carman
Links:

Data 101.pptx

Data 101 – tipsheet.pdf

Statistics Canada: Getting beyond the news releases

Session recording:
https://www.youtube.com/watch?v=TlOxBuCYrPQ

David McKie, Chad Skelton
Links:

StatCan release schedules

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

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

Census Profile – 2021
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

Consumer Price Index visualization tool
https://www150.statcan.gc.ca/n1/pub/71-607-x/2018016/cpilg-ipcgl-eng.htm

Consumer Price Index frequently asked questions
https://www.documentcloud.org/documents/22672133-consumer-price-index-frequently-asked-questions

The eight major components in the Consumer Price Index
https://www.documentcloud.org/documents/22672133-consumer-price-index-frequently-asked-questions#document/p1/a2199262

Seasonally adjusted data – Frequently asked questions
https://www.statcan.gc.ca/en/dai/btd/sad-faq

Consumer price index portal
https://www.statcan.gc.ca/en/subjects-start/prices_and_price_indexes/consumer_price_indexes

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

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

Investment status of residential properties
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=4610007001

Employee wages by industry, annual
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410006401

Undergraduate tuition fees, Canadian students, by selected standard geographic areas and by field of study
https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3710012001