Links

What you will learn on day one

Downloading tables from Statistics Canada
Downloading data from an open-data portal
Light data cleaning
Distinguishing between record level and aggregate data
Sorting filtering
Using an If statement to substitute political party names with ID numbers in a new column
Creating a pivot table
Summing totals
Formatting numbers
How to go beyond the headlines to make pitches

What you will learn day two

Using functions to dig more deeply into data
Building databases
Visualizing using Tableau
How to find data online
Building data into your workflow

Statistics Canada

Statistics Canada Releases Schedule
https://www150.statcan.gc.ca/n1/dai-quo/cal3-eng.htm

Story: Canada’s economy adds 106,500 jobs, most in a month since 1976
https://www.cbc.ca/news/business/economy-adds-record-jobs-april-1.5130682

Story: 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

Labour force characteristics by province, monthly, seasonally adjusted
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1410028703

Trade Data Online
http://www.ic.gc.ca/eic/site/tdo-dcd.nsf/eng/Home

International merchandise trade for all countries and by Principal Trading Partners, monthly
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210001101

Manufacturing sales by industry and province, monthly (dollars unless otherwise noted) (x 1,000)https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1610004801

Retail trade sales by industry (x 1,000)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=2010000802

Open-Data Sites

Open Government Portal (federal)
https://open.canada.ca/data/en/dataset

BlackBerrys, a boat and a $40 clock: Here’s what people are stealing from the government
https://nationalpost.com/news/politics/ottawa-recorded-6-8-million-in-stolen-property-4-3-billion-in-debt-write-offs-last-year

Public Accounts
https://open.canada.ca/data/en/dataset?portal_type=dataset&q=public+accounts

Office of the Commissioner of Lobbying of Canada
https://lobbycanada.gc.ca/eic/site/012.nsf/eng/h_00000.html

Story: Parties filling coffers in record numbers for fall federal election
https://www.cbc.ca/news/politics/canada-political-fundraising-federal-election-1.5116430

Elections Canada — Political Financing
https://www.elections.ca/content.aspx?section=fin&&document=index&lang=e

National Parole Board Pardon Statistics
PardonsGrantedAndDenied – FY2011-2012 to MY2018-2019.xlsx

Federal Contaminated Sites Inventory
https://www.tbs-sct.gc.ca/fcsi-rscf/home-accueil-eng.aspx

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

Canadian Federal Candidates (University of Montreal)
(This dataverse contains district level data for all Canadian federal candidates from 1867-2017. This dataset includes unique id for each individual who ran for federal elections, riding names, province, date of birth for all elected MPs by year, gender, occupation, party names)
https://dataverse.harvard.edu/dataverse/cdnelxns

ParlInfo
https://lop.parl.ca/sites/ParlInfo/default/en_CA/

Women Candidates in General Elections
https://lop.parl.ca/sites/ParlInfo/default/en_CA/ElectionsRidings/womenCandidates

Story: Neighbours rally around family targeted by racist graffiti
https://ottawacitizen.com/news/local-news/neighbours-rally-around-black-family-targeted-by-racist-graffiti

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

2019 Monthly Service Requests — City of Ottawa
http://data.ottawa.ca/dataset/2019monthlyservicerequests

Tableau Public
https://public.tableau.com/en-us/s/