2015 Data Journalism Boot Camp
OPEN DATA GOVERNMENT WEBSITES
David McKie
CBC News
david.mckie@cbc.ca
613-290-7380 (cell)
613-288-6523 (office)
Glen McGregor
Ottawa Citizen
gmcgregor@ottawacitizen.com
613-235-6685 (office)
613-302-3530 (cell)
Class of 2015
OPEN DATA GOVERNMENT WEBSITES
BC
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/
Edmonton
http://data.edmonton.ca/
Halifax’s Open Data Catalogue
https://www.halifaxopendata.ca/
Government-Wide Reporting — Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Ontario
http://www.ontario.ca/government/open-data-ontario
Open Data Portal (federal government)
http://open.canada.ca/data/en/dataset
Ottawa
http://data.ottawa.ca/en/?page=1
Québec Ouvert (les données ouvertes pour le Québec)
http://quebecouvert.org/
Telling Your Story with Data
http://carleton.ca/fpa-professionalinstitute/courses/data-journalism/
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Vancouver
http://data.vancouver.ca/
World Development Indicators (The World Bank)
http://data.worldbank.org/data-catalog/world-development-indicators?cid=GPD_WDI
The United States: The Department of Transportation
http://www.dot.gov/mission/open/open-government
DAVID’S DATASETS
Atlantic Canada Opportunities Agency
http://www.acoa-apeca.gc.ca/eng/Accountability/ProjectInformation/Pages/Home.aspx
Elections Canada
http://www.elections.ca/WPAPPS/WPF
Download federal campaign donation data
Federal contaminated sites data – download here
Geobase – Federal Electoral Districts – Canada 2013
http://geogratis.gc.ca/api/en/nrcan-rncan/ess-sst/-/(urn:iso:series)geobase-federal-electoral-districts?sort-field=relevance
Industry Canada Trade Data
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home?OpenDocument
Federal Public Accounts
http://open.canada.ca/data/en/dataset?_organization_limit=0&organization=pwgsc-tpsgc
Ottawa 311 Service Request Volumes – download zip file here
Ottawa Ward file – download the kml file here
MySQL string functions for Ottawa 311 tables – download file here
Ottawa mapped noise complaints in March 2015 in Fusion Tables
https://www.google.com/fusiontables/data?docid=1xE47_6NsWdrPqTa9-aN4QUjjAPtkzHSRIEjHNMWB#map:id=3
Toronto Parking Ticket 2014 data – download here
Cometdocs http://www.cometdocs.com/
To obtain the extracted PDF of Lost Property in Public Accounts extracted and uploaded to Cometdocs, click here.
To download the contaminated sites tutorial for Qgis, please click here.
GLEN’S DATASETS
To download the powerpoint Finding Stories in Data, please click here
To download the PowerPoint Webscraping seminar, please click here
To obtain Glen’s data, please click here.
STORIES USING DATA
Tory, suburban ridings gain the most from enriched child benefits: analysis
http://ottawacitizen.com/news/politics/tory-suburban-ridings-gain-the-most-from-enriched-child-benefits-analysis
Government favours infrastructure projects to Conservative ridings
http://www.theglobeandmail.com/news/politics/government-favours-infrastructure-projects-to-conservative-ridings/article25492064/
Federal infrastructure fund spending favoured Conservative ridings
http://www.theglobeandmail.com/news/politics/federal-infrastructure-fund-spending-favoured-conservative-ridings/article25172781/
50 data-journalism ideas (NICAR)
http://mtduk.es/prez/50ideas.html#/
Opponents ask court to block work on Memorial to Victims of Communism site
http://ottawacitizen.com/news/local-news/opponents-ask-court-to-block-ncc-work-on-memorial-to-victims-of-communism-site
Contaminated sites cleanup to cost billions more, budget office says (CBC News)
http://www.cbc.ca/news/politics/contaminated-sites-cleanup-to-cost-billions-more-budget-office-says-1.2604939
Treasury Board contaminated Sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Conservatives defend new waterways rules against accusations of favouritism (The Ottawa Citizen)
Questionable arms exports up (The Canadian Press)
https://www.ceasefire.ca/?p=17259
Industry Canada Trade Data
http://strategis.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home?OpenDocument
Metro buses involved in hundreds of crashes a year (CBC News Nova Scotia)
http://www.cbc.ca/news/canada/nova-scotia/story/2012/01/29/ns-metro-transit-collisions.html
Ontario voter turnout lowest since 1867 (globalnews.ca)
http://www.globalnews.ca/interactive/6442496991/story.html
This fire hydrant costs Toronto drivers the most in parking tickets (The Canadian Press)
http://www.thestar.com/news/gta/2014/08/11/this_fire_hydrant_costs_toronto_drivers_the_most_in_parking_tickets.html
Toronto Parking Ticket Download site
Beech Street fire hydrant has netted city $65,000 since 2008
http://ottawacitizen.com/news/local-news/beech-street-fire-hydrant-has-netted-city-65000-since-2008
Ottawa Parking Ticket Data
Explore the Data
The New York Times spent 10 months investigating business incentives awarded by hundreds of cities, counties and states
Brewers poured $100,000 into Ontario Liberal leadership race (iPolitics)
http://newsle.com/article/0/69223713/
Elections Ontario
http://www.elections.on.ca/en-CA/Tools/FinancialStatementsandContributions/RealTimeDisclosure.htm
Temporary Foreign Worker Program complaints began in 2006 (CBC News)
http://www.cbc.ca/news/politics/temporary-foreign-worker-program-complaints-began-in-2006-1.2685056
Temporary Foreign Worker Program queries came mostly from Tory MPs (CBC News)
http://www.cbc.ca/news/politics/temporary-foreign-worker-program-queries-came-mostly-from-tory-mps-1.2687159
Temporary Foreign Worker File used for the story – download it here
RCMP fire Tasers multiple times despite health hazards: probe (CBC-Radio-Canada, The Canadan Press)
http://www.cbc.ca/canada/story/2008/06/11/taser-rcmp.html
RCMP softened Taser-use restrictions (CBC-Radio-Canada, The Canadian Press)
http://www.cbc.ca/canada/britishcolumbia/story/2009/03/25/taser.html
RCMP shocked 16 people five times or more last year (CBC and The Canadian Press)
http://www.cbc.ca/news/canada/rcmp-shocked-16-people-five-times-or-more-last-year-1.812794
Conducted Energy Weapon Usage Report – download it here
Drug seizure stories (CBC News)
http://www.cbc.ca/news/politics/story/2013/03/27/pol-busted-at-the-border-drug-seizures-cbsa.html
http://www.cbc.ca/news/politics/story/2013/03/27/pol-border-drug-seizures-china-gbh.html
http://www.cbc.ca/news/canada/british-columbia/story/2013/03/27/bc-cbsa-drugs-ketamine.html
http://www.cbc.ca/news/canada/windsor/story/2013/03/28/wdr-cocaine-seizures-ambassador-bridge.html
http://www.cbc.ca/news/canada/nova-scotia/story/2013/03/27/ns-border-halifax-smuggle.html
http://www.cbc.ca/news/canada/manitoba/story/2013/03/27/mb-khat-manitoba-border-smuggling.html
http://www.radio-canada.ca/grands-titres/
http://www.cbc.ca/news/politics/inside-politics-blog/2013/03/post-15.html
Canada Border Service Agency seizures – to download data click here
Theft of military uniforms sparks fresh security concerns (Ottawa Citizen) http://ottawacitizen.com/news/politics/theft-of-military-uniforms-sparks-fresh-security-concerns
To obtain the extracted PDF of Lost Property in Public Accounts extracted and uploaded to Cometdocs, click here.
To obtain the Excel workbook of Lost Property in Public Accounts, click here.
MAPPING
To access mapping links, please click here to take you to a syllabus that contains many links
DATA CLEANING
To obtain the data-cleaning tutorial using Textwangler ( for Mac users ), please click here
To obtain the data-cleaning tutorial using Notepad++ ( for PC users ), please click here
RESOURCES
Appendix C from Digging Deeper 3rd edition: Visualizing Data with Google Fusion Tables and Tableau Public
http://www.oupcanada.com/higher_education/companion/comm_studies/9780199008490/student_resources/appendix_c.html
101 Ready-to-Use Excel Formulas
http://books.google.ca/books?id=HnwJBAAAQBAJ&printsec=frontcover#v=onepage&q&f=false
Computer-Assisted Reporting: A Comprehensive Primer
http://www.amazon.ca/Computer-Assisted-Reporting-A-Comprehensive-Primer/dp/0195424573
Excel Tips
http://excel.tips.net/
MySQL:Crash Course by Ben Forta
http://www.amazon.ca/MySQL-Crash-Course-Ben-Forta/dp/0672327120
My Favorite (Excel) Things (Excellent tutorial from MaryJo (Sylwester) of the St. Paul Pioneer Press)
http://extra.twincities.com/CAR/MJ/ExcelClasshandout.pdf