Carleton University School of Journalism and Communication: 2014 Data Journalism Boot Camp
OPEN DATA GOVERNMENT WEBSITES
Open Data Pilot Project (federal government)
http://www.data.gc.ca/default.asp?lang=En
Government-Wide Reporting — Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp
Edmonton
http://data.edmonton.ca/
Halifax’s Open Data Catalogue
https://www.halifaxopendata.ca/
Ottawa
http://data.ottawa.ca/en/?page=1
Toronto
http://www1.toronto.ca/wps/portal/contentonly?vgnextoid=1a66e03bb8d1e310VgnVCM10000071d60f89RCRD
Vancouver
http://data.vancouver.ca/
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/
Ontario
http://www.ontario.ca/government/open-data-ontario
Québec Ouvert (les données ouvertes pour le Québec)
http://quebecouvert.org/
Canadian Open Data Institute
http://opendatainstitute.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
GLEN’S DATA
To access Glen’s zipped data set, please click here
STORIES USING DATA
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
EXCLUSIVE: Search and rescue for false alarms costs millions (CBC News)
http://www.cbc.ca/news/politics/search-and-rescue-for-false-alarms-costs-millions-1.2594306
More discarded needles being found in Ottawa’s suburbs (CBC News)
http://www.cbc.ca/news/canada/ottawa/more-discarded-needles-being-found-in-ottawa-s-suburbs-1.2572573
Toronto data reveals hundreds of discarded syringes (The Toronto Star)
http://www.thestar.com/news/gta/2013/08/15/toronto_data_reveals_hundreds_of_discarded_syringes.html
Just 31 donors switch to Wildrose from Tories (Edmonton Journal)
http://www2.canada.com/edmontonjournal/news/story.html?id=a4ddf170-bd63-4ff0-b7d9-9ae55199e92c&p=2
Number of reported bird strikes at Windsor airport soars (The Windsor Star)
http://blogs.windsorstar.com/2013/05/13/number-of-reported-bird-strikes-at-windsor-airport-soars/
‘Huge, huge overtime’ lifts Ontario nurses into $100,000 salary club (The Ottawa Citizen)
http://www2.canada.com/ottawacitizen/news/story.html?id=5088efab-5799-495a-b04a-c94beccfb5a0&p=2
Elections Canada
http://www.elections.ca/WPAPPS/WPF
Download federal campaign donation data
Elections BC
http://contributions.electionsbc.gov.bc.ca/pcs/Options.aspx
Download a sample BC election contribution database here
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
Quebec political contributions
http://www.electionsquebec.qc.ca/francais/provincial/financement-et-depenses-electorales/recherche-sur-les-donateurs.php#
Ontario campaign contribution data
Zambito implicates Laval mayor, parties at corruption inquiry (CBC News)
http://www.cbc.ca/news/canada/montreal/zambito-implicates-laval-mayor-parties-at-corruption-inquiry-1.1140223
Quebec campaign contribution data
Political Contributions Disclosure Statement Annual Reports
https://electionsnovascotia.ca/content/political-contributions-disclosure-statement-annual-reports
Cometdocs
http://www.cometdocs.com/
To access instructions on extracting pages from Preview Extraction in the Mac, please click here
Download Nova Scotia 2011 political donation here
Download Nova Scotia 2012 political donation extract here
Judge Advocate General Annual Report 2009-2010
Download selected table from judge advocate general report here
Overhaul aims to make foreign worker program the ‘last resort’ (The Toronto Star)
http://www.thestar.com/news/canada/2014/06/20/federal_government_overhauling_temporary_foreign_worker_program.html
Alberta leads way in fast-track requests for temporary foreign workers (CBC News)
http://www.cbc.ca/news/politics/alberta-leads-way-in-fast-track-requests-for-temporary-foreign-workers-1.2682379
Temporary foreign worker sessional paper
Temporary foreign worker Excel table
Atlantic Canada Opportunities Agency
http://www.acoa-apeca.gc.ca/eng/Accountability/ProjectInformation/Pages/Home.aspx
Download ACOA data for mapping here
Federal Contaminated Sites Inventory (Find Sites by Classification)
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.asp
Download the crime data tutorial for calculating ratios.
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
Gun seizures up but fears of porous border remain (CBC News)
http://www.cbc.ca/news/politics/story/2013/05/01/pol-cbsa-weapons-seized-border-guns.html
Download CBSA seizure data here
Conservatives defend new waterways rules against accusations of favouritism (The Ottawa Citizen)
Treasury Board contaminated sites
http://www.tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx
Download the high priority for action Excel file here
Download contaminated sites file here
Download Ottawa building inspection data 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