Data Journalism: The Art of Storytelling
David McKie
david.mckie@cbc.ca
1-613-290-7380 (cell)
Articles
In the dark: The cost of Canada’s data deficit
https://www.theglobeandmail.com/canada/article-in-the-dark-the-cost-of-canadas-data-deficit/
Divorce and marriage data crucial for understanding Canada’s public health, researchers argue
https://www.theglobeandmail.com/canada/article-divorce-and-marriage-data-crucial-for-understanding-canadas-public/
Health-care data in the cloud? Early adopter took a giant leap, and it paid off
https://www.theglobeandmail.com/business/article-health-care-data-in-the-cloud-early-adopter-took-a-giant-leap-and-it/
What makes an award-winning data journalism project?
https://datajournalismawards.org/2019/03/22/what-makes-an-award-winning-data-journalism-project/
CBC News’s joint investigation into the sometimes murky world of medical devices
https://www.cbc.ca/news/health/implant-files-investigation-medical-devices-1.4924384
Award-winning projects
CAJ 2017 Data Journalism finalists
Unfounded (The Globe and Mail)
https://www.theglobeandmail.com/news/investigations/unfounded-sexual-assault-canada-main/article33891309/
Easy Money: How Fraudsters can make millions off Canadian investors, get barely punished and do it again (The Globe and Mail)
https://www.theglobeandmail.com/news/investigations/easy-money-canadian-securities-fraud/article37350705/
Ottawa nursing homes have seen at least 163 cases of abuse since 2012 (Ottawa-Citizen)
http://ottawacitizen.com/news/local-news/more-than-2000-cases-of-non-compliance-and-163-cases-of-abuse-at-ottawa-long-term-care-homes
Big corporate donors give big to the B.C. Liberals (Vancouver Sun)
http://vancouversun.com/business/local-business/big-corporate-donors-give-big-to-the-b-c-liberals
In search of Canada’s elusive shadow population (Discourse Media)
https://www.thediscourse.ca/data/canadas-shadow-population
2018 Philip Meyer Award winners
https://www.ire.org/awards/philip-meyer-awards/2018-philip-meyer-award-winners
Examples of Open Data
Federal
Open Government Portal (federal)
https://open.canada.ca/data/en/dataset?portal_type=dataset&_organization_limit=0
Statistics Canada
Statistics Canada Releases Schedule
https://www150.statcan.gc.ca/n1/dai-quo/cal3-eng.htm
https://www150.statcan.gc.ca/n1/dai-quo/cal1-eng.htm
Canada’s Unemployment Rate Edges Higher, Despite A Rush Of New Jobs In January
https://www.huffingtonpost.ca/2019/02/08/unemployment-rate-canada-january_a_23664967/
Labour Force Survey, January 2019
https://www150.statcan.gc.ca/n1/daily-quotidien/190208/dq190208a-eng.htm?HPA=1
Hate crimes reached all-time high in 2017, Statistics Canada says
https://www.cbc.ca/news/canada/toronto/statistics-canada-2017-hate-crime-numbers-1.4925399
Police-reported hate crime, 2017
https://www150.statcan.gc.ca/n1/daily-quotidien/181129/dq181129a-eng.htm
Provinces and territories
Alberta
http://data.alberta.ca/
B.C.
http://www.openinfo.gov.bc.ca/ibc/search/search.page#cateloguehttp://www.openinfo.gov.bc.ca/ibc/index.page?http://www.data.gov.bc.ca/
Nova Scotia
https://data.novascotia.ca/
Newfoundland and Labrador
http://open.gov.nl.ca/
Ontario
http://www.ontario.ca/government/open-data-ontario
Prince Edward Island
https://www.princeedwardisland.ca/en/search/site/?f%5B0%5D=type%3Aservice&f%5B1%5D=field_service_topics%3A2237
Québec Ouvert (les données ouvertes pour le Québec)
http://quebecouvert.org/
Saskatchewan Open Data
http://www.opendatask.ca/
Cities
Edmonton
http://data.edmonton.ca/
Halifax
https://www.halifax.ca/home/open-data
Fredericton
http://www.fredericton.ca/en/open-data
Mississauga
http://www.mississauga.ca/portal/residents/mississaugadata
Montreal
http://donnees.ville.montreal.qc.ca/
Oakville
http://oakville.ca/data/
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/
Saint John
http://catalogue-saintjohn.opendata.arcgis.com/
St. John’s
http://www.stjohns.ca/event/open-data
Vancouver
http://data.vancouver.ca/
Winnipeg
https://data.winnipeg.ca/
Federal Open Data Portal
https://open.canada.ca/data/en/dataset?portal_type=dataset
Following money
Quebec Lobbyists Registry
https://www.commissairelobby.qc.ca/en/lobbyists-registry/
Public Accounts (Government-wide)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Charities Listings (Revenue Canada)
http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html
Parliament’s security service looks for cyber guru
https://www.thechronicleherald.ca/news/canada/parliaments-security-service-looks-for-cyber-guru-281840/
Cyber Security Speacialist (PPS-RFP-2019-033)
https://buyandsell.gc.ca/procurement-data/tender-notice/PW-19-00862670
Feds to search social media using AI to find patterns of suicide-related behaviour
http://www.cbc.ca/news/canada/nova-scotia/feds-to-search-social-media-using-ai-to-find-patterns-of-suicide-related-behaviour-1.4467167
AI startup enlisted for project to predict suicide risk in Canada
https://www.theglobeandmail.com/technology/government-enlists-ai-startup-for-project-to-predict-suicide-risk-in-canada/article37475839/
Artificial Intelligence (AI) pilot project for surveillance of suicide-related behaviours using social media. (1000196416)
https://buyandsell.gc.ca/procurement-data/tender-notice/PW-17-00809483
Buyandsell.gc.ca
https://buyandsell.gc.ca/
International merchandise trade for all countries and by Principal Trading Partners, monthly (x 1,000,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210001101
Trade Data Online
http://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home
Merchandise imports and exports, customs and balance of payments basis for all countries, by seasonal adjustment and North American Product Classification System (NAPCS)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210012101
Canadian International Merchandise Trade Database
http://www5.statcan.gc.ca/cimt-cicm/home-accueil?lang=eng
Disclosure of Grants and Contributions
https://open.canada.ca/data/en/dataset/432527ab-7aac-45b5-81d6-7597107a7013
Crime
Hate crimes reached all-time high in 2017, Statistics Canada says
https://www.cbc.ca/news/canada/toronto/statistics-canada-2017-hate-crime-numbers-1.4925399
Police-reported hate crime, 2017
https://www150.statcan.gc.ca/n1/daily-quotidien/181129/dq181129a-eng.htm
Conditional Release – Grant Rate 2016-2017 (Parole Board of Canada)
https://open.canada.ca/data/en/dataset/b9ce6212-7bfd-49f1-97a6-6bca5771bbde
Conditional Release Special Conditions 2016-2017 (Parole Board of Canada)
https://open.canada.ca/data/en/dataset/113d6905-6566-42e5-8113-65fd730b21cf
Parole Board of Canada Open Government Portal for conditional releases
https://open.canada.ca/data/en/dataset?portal_type=dataset&_organization_limit=0&organization=pbc-clcc
Incident-based crime statistics, by detailed violations
http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=2520051&p2=17
Resources
The Data Journalist: Getting the Story
Aneurin Bosley’s Tableau Tutorials
Getting data into Tableau:
https://www.youtube.com/watch?v=rrt8hyOaZRI
Working with data:
https://www.youtube.com/watch?v=a7nuVSsXWeM
Building dashboards:
https://www.youtube.com/watch?v=Es50LH0Pbiw
Tableau’s Free Training Videos
https://www.tableau.com/learn/training