Telling Your Story With Data 2017

Share

https://carleton.ca/globalacademy/telling-your-story-with-data/

David McKie

181 Queen Street

1-613-288-6523 (office)

1-613-290-7380 (cell) 1-613-288-6490 (fax)

Email: david.mckie@cbc.ca

Twitter: @mckiedavid

Glen McGregor

Senior Parliament Hill correspondent for CTV News

Email: sushiboy21@gmail.com

Twitter: @glen_mcgregor

Open datasites | Data journalism stories | David’s datasets | David’s tutorials | Data visualation  | Glen’s datasets Cool links | Reference

Open datasites (TOP)

2016 Census Program release schedule
http://www12.statcan.gc.ca/census-recensement/2016/ref/release-dates-diffusion-eng.cfm

Alberta
http://data.alberta.ca/

Alberta Historical Wildfire Database
http://wildfire.alberta.ca/wildfire-maps/historical-wildfire-information/historical-wildfire-database.aspx

British Columbia Previously Released Freedom of Information 
Requests
http://www2.gov.bc.ca/gov/search?q=FOI%2Binmeta%3Ayear%3D2017&id=4BAD1D13C68243D1960FECBBF7B8B091&tab=1

Civil Aviation Daily Occurrence Reporting System (CADORS) – Transport Canada

http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng

Completed Access to Information Requests
http://open.canada.ca/en/search/ati

Dean Beeby’s_ATIA-Tipsheet-April-CAJ2017.pdf

Edmonton
http://data.edmonton.ca/

Edmonton Fire Response – History
https://data.edmonton.ca/Emergency-Services/Fire-Response-History/3s7f-z7ut

Elections Ontario political donations
https://www3.elections.on.ca/internetapp/efsearch.aspx?lang=en

Elections Alberta
http://efpublic.elections.ab.ca/efCXDataExtract.cfm?MID=CX_DATA

Elections Canada Political Donations
http://www.elections.ca/WPAPPS/WPF/EN/CCS?returntype=1

Energy use and greenhouse gas emissions for the Broader Public Sector
https://www.ontario.ca/data/energy-use-and-greenhouse-gas-emissions-broader-public-sector

Federal Contaminated Sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx

Federal Electoral Districts – Canada 2013
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/56124851-71fc-4f94-8df2-40f59cd1dd46.html

Federal government open data portal
http://open.canada.ca/en/open-data

GeoBase – Federal Electoral Districts – Canada 2013
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/56124851-71fc-4f94-8df2-40f59cd1dd46.html

Incident-based crime statistics, by detailed violations
http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=2520051

Labour Force Survey, May 2017
http://www.statcan.gc.ca/daily-quotidien/170609/dq170609a-eng.htm?HPA=1

Manitoba Previously Released Freedom of Information Requests
http://www.gov.mb.ca/government/proactive_disclosure.html

Municipal Boundaries – ON – Ontario
http://open.canada.ca/data/en/dataset/d2335f47-a49a-49cc-9257-26d6d4b5b039

National Institute for Computer-Assisted Reporting
http://www.nicar.org/
http://data.nicar.org/
http://www.ire.org/resource-center/listservs/subscribe-nicar-l/

National Transportation Safety Board inventory of databases
http://www-odi.nhtsa.dot.gov/downloads/

Newfoundland Previously Released Freedom of Information Requests
http://atipp-search.gov.nl.ca/

Offender Profile 2013-2014 Correctional Services of Canada http://open.canada.ca/data/en/dataset/106fbf2d-bfdb-4e82-9aef-7ad46bf6ffd2

Ontario Public sector salary disclosure 2015: all sectors and seconded employees
https://www.ontario.ca/page/public-sector-salary-disclosure-2015-all-sectors-and-seconded-employees

https://www.ontario.ca/page/public-sector-salary-disclosure-act-disclosures-2014

Openparliament.ca
https://openparliament.ca/

Ottawa
http://data.ottawa.ca/en/?page=1

Police-reported hate crimes, 2015
http://www.statcan.gc.ca/daily-quotidien/170613/dq170613b-eng.htm?HPA=1

Pipeline Ruptures
https://www.neb-one.gc.ca/sftnvrnmnt/sft/pplnrptr/index-eng.html

Proactive Disclosure – Contracts over $10,000
http://open.canada.ca/data/en/dataset/d8f85d91-7dec-4fd1-8055-483b77225d8b

Public Services and Procurement Canada – National asbestos inventory
http://www.tpsgc-pwgsc.gc.ca/biens-property/documents/invamiante-asbestosinv-eng.pdf

Refugee Claim Data and IRB Member Recognition Rates – 2015
http://ccrweb.ca/en/2015-refugee-claim-data

Temporary Foreign Worker System 2008-2015
http://open.canada.ca/data/en/dataset/c65d2014-ef25-4781-b9b2-e13a7293b72d

Toronto City Wards
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD#C

Toronto Previously Released Freedom of Information Requests
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=261b423c963b4310VgnVCM1000003dd60f89RCRD&vgnextchannel=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD

Trade Data Online (TDO) (Innovation, Science and Economic Development Canada)
https://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home

Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD

Vancouver
http://data.vancouver.ca/

Data Journalism Stories (TOP)

The 100 WORST landlords in Toronto
http://www.landlordwatch.com/

City’s 311 hotline faces a new challenge: suicide calls
http://www.thestar.com/news/insight/2015/07/05/citys-311-hotline-faces-a-new-challenge-suicide-calls.html

Crossing out catastrophes: Some of Manitoba’s 2,000-plus rail crossings are among the most dangerous in Canada; mandatory safety upgrades are on the way
http://www.winnipegfreepress.com/local/crossing-out-catastrophes-392191851.html

DATA JOURNALISM AWARDS 2016 WINNING PROJECTS
https://www.datajournalismawards.org/past-winners/

How to avoid Toronto’s parking ticket hot spots
https://www.thestar.com/news/gta/2016/05/15/how-to-avoid-torontos-parking-ticket-hot-splots.html

Fatal Force
https://www.washingtonpost.com/graphics/national/police-shootings-2016/?utm_campaign=Vox%20Sentences%207/6/16&utm_medium=email&utm_source=Sailthru

Missed garbage pickup complaints rise in east, fall in west
http://www.thestar.com/news/gta/2015/07/09/missed-garbage-pickup-complaints-rise-in-east-fall-in-west.html

Montreal embraces new ‘open by default’ data policy
http://montrealgazette.com/news/local-news/montreal-embraces-new-open-data-policy

New map explores the mysteries of Edmonton’s tax assessments
http://edmontonjournal.com/news/local-news/new-map-explores-the-mysteries-of-edmontons-tax-assessments

Website coming to Vancouver will help renters find good landlords
http://globalnews.ca/news/2010721/new-vancouver-website-will-help-renters-find-good-landlords/

Walmart: Thousands of police calls. You paid the bill.
http://www.tampabay.com/projects/2016/public-safety/walmart-police

David’s Datasets(TOP)

Datasets for Excel

How to avoid 10 common mistakes in data reporting
https://www.americanpressinstitute.org/publications/data-reporting-common-mistakes/#disqus_thread

500 Excel Formula Examples
https://exceljet.net/formulas

More than a dozen PMO staffers earn at least $150,000 a year: CTV News
http://www.ctvnews.ca/politics/more-than-a-dozen-pmo-staffers-earn-at-least-150-000-a-year-ctv-news-1.3458878

Sunshine List reveals Ontario’s public sector salaries
http://www.cbc.ca/news/canada/toronto/sunshine-list-2017-ontario-salaries-2016-1.4037987

Data: Ontario Public Sector Salaries_2014-2016.zip

Pipeline safety incident rate doubled in past decade: Database gives detailed picture of 1,047 reported problems
http://www.cbc.ca/news/pipeline-safety-incident-rate-doubled-in-past-decade-1.2251771

Data: PipelineIncidentData_DateFixInstructions.xlsx

Ex-coach Graham James pardoned for sex abuse that rocked NHL
https://www.theglobeandmail.com/news/national/ex-coach-graham-james-pardoned-for-sex-abuse-that-rocked-nhl/article4318517/

Data: CBC statistics (Updated April 26 2017)v2.xlsx

Wynne defends climate plan, citing Ontario’s ‘high’ carbon footprint
https://www.theglobeandmail.com/news/national/wynne-defends-climate-plan-citing-ontarios-high-carbon-footprint/article32322144/

Data: Energy use and greenhouse gas emissions for the Ontario broader
public sector

Datasets for mapping

Pipeline Incident Data
http://open.canada.ca/data/en/dataset/7dffedc4-23fa-440c-a36d-adf5a6cc09f1

To download the filtered pipeline data for Qgis, please click  here.

Toronto Homes Not Regularly Occupied
https://betterdwelling.com/city/toronto/toronto-has-over-99000-unoccupied-homes-heres-where-they-are-interactive/

Toronto Unoccupied dwellings mapped out in ArcGIS and Google  Fusion Tables
http://www.davidmckie.com/category/digi-1examples/

Population and Dwelling Count Highlight Tables, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/pd-pl/comprehensive.cfm

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

Data: 2016DwellingCountDataAndBoundaryFiles.zip

Decontaminating LeBreton sites could cost as much as $50 million, says expert
http://ottawacitizen.com/news/local-news/decontaminating-lebreton-sites-could-cost-up-to-50-million-expert-says

Federal Contaminated Sites
http://tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx

Data: FCSI_2606218_TombstoneData.csv

2016 Geographic boundaries
http://www12.statcan.gc.ca/census-recensement/2016/geo/index-eng.cfm

David’s Tutorials(TOP)

Excel

To download the tutorial that explains how to find patterns in Statistics Canada crime data, click here.

To download the tutorial that explains how to filter Statistics Canada and then get the table into Tableau Public, click here.

To download the calculating percent of totals tutorial, click here.

To download the calculating rates tutorial, click here.

To download the Logical Functions And IF Statements tutorial, please click here.

To download a more extensive Excel tutorial using functions, please click here to download

Qgis

To download the tutorial “Introduction to QGIS and Basic Geoprocessing Skills” (Rebecca Bartlett and Joel Rivard) please click here.

To download the Qgis tutorial using the Statistics Canada federal electoral districts and contaminated sites,  please click here.

To download the tutorial for downloading Qgis for PC’s and Macs, please click here.

To download the contaminated sites tutorial in Qgis, please click here.

To download the first Qgis tutorial on census tracts, please click here.

To download a second Qgis tutorial on census tracts, please click here.

MySQL

To download the Windows version of MySQL downloading tutorial, please click here.

To download the Mac version of the MySQL downloading tutorial, please click here.

To download the MySQL tutorial, please click here.

To download the MySQL query cheat sheet, please click  here.

Data visualisation(TOP)

To download the tutorial for “A Guide to Google Fusion Tables Visualizations”, please click here.

To download the latest Tableau Public tutorial using the StatsCan human trafficking data, please click here.

To access Digging Deeper’s online Excel, Google Fusion Table and Tableau Public tutorials, please click here.

To download the tutorial that explains how to filter Statistics Canada and then get the table into Tableau Public, click here.

To download the Canada small arms trade data export tutorial, please click here.

Glen’s Datasets(TOP)

Mapping.zip

Cool links (TOP)

Code Academy
https://www.codecademy.com/

IFTTT
https://ifttt.com/applets/gdxDAKwC-save-tweets-featuring-specific-content-to-a-google-spreadsheet

MMP
https://www.mamp.info/en/

Hans Rosling
https://www.ted.com/speakers/hans_rosling

Open Refine
http://openrefine.org/

Reference (TOP)

MySQL Crash Course by Ben Forta
http://www.forta.com/books/0672327120/