Fred Vallance-Jones
University of King’s College
1-902-422-1271
fvjones@gmail.com
@Fvjones

David McKie
CBC News
Carleton University
Algonquin College
613-288-6523 (office)
613-290-7380 (cell)
david.mckie@cbc.ca
@mckiedavid

 

 

OPEN DATA GOVERNMENT WEBSITES

Atlantic Canada Opportunities Agency
http://www.acoa-apeca.gc.ca/eng/Accountability/ProjectInformation/Pages/Home.aspx

Elections Canada
http://www.elections.ca/WPAPPS/WPF

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/

Federal Public Accounts
http://open.canada.ca/data/en/dataset?_organization_limit=0&organization=pwgsc-tpsgc

Government-Wide Reporting — Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp

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

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

 DATA SETS

To obtain the library of Excel  routines, please click here

Download federal campaign donation data 

Federal contaminated sites 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.

Ottawa censors majority of Access to Information requests
http://www.thestar.com/news/canada/2015/07/08/ottawa-censors-majority-of-access-to-information-requests.html

Search Summaries of Completed ATI Requests
http://data.gc.ca/eng/search/ati?

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

Digging Deeper 3rd edition
http://www.oupcanada.com/catalog/9780199008490.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

Your Right To Know: How to Use the Law to Get Government Secrets
http://www.amazon.ca/Your-Right-To-Know-Government/dp/177040211X

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

http://extra.twincities.com/CAR/MJ/DataStateofMind.pdf

http://extra.twincities.com/CAR/MJ/ManagingJuggling.pdf