#CAJ17 ANNUAL CONFERENCE

David McKie
http://www.davidmckie.com/about-me/resume/
CBC News
181 Queen Street
Ottawa, Ontario
K1P 1K9
613-288-6523 (office)
613-290-7380 (cell)
David.mckie@cbc.ca

Fred Vallance-Jones
https://ukings.ca/people/fred-vallance-jones/
Associate Professor
University Of King’s College
6350 Coburg Road,
Halifax, NS, Canada
B3H 2A1
902.422.1271 ext.147
902.880.5470 (cell)
Fvjones@dal.ca

David and Fred are co-authors of
“The Data Journalist: Getting the Story“

Stories using data |Government open-data websites | Data sets for download |Access to information links |Resources

Data workshop details

10:15-11:15 a.m. — Finding stories in data (part one). You’ve heard about data journalism, but you’re not sure what it is or where to start. CBC’s David McKie and Fred Vallance-Jones of the University of King’s College walk you through the basics of finding a story in open data and using a spreadsheet for simple analysis. To gain the most from this session, you should install either Microsoft Excel or OpenOffice on your computer.
Twitter: #CAJdata

11:20-12:20 p.m. — Finding stories in data (part 2)

STORIES USING DATA

50 ideas in 60  minutes #NICAR15//ATL
/50ideas.html#/

Ontario Sunshine List of highest-paid public sector employees reveals thousands earn more than premier
http://www.cbc.ca/news/canada/toronto/ontario-sunshine-list-1.3505138

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

GOVERNMENT OPEN-DATA WEBSITES(TOP)

Alberta
http://data.alberta.ca/

Alberta  Government Salary disclosures
https://www.alberta.ca/salary-disclosure-table.cfm

ACOA Project Information (Atlantic Canada Opportunities Agency)
http://pub.acoa-apeca.gc.ca/atip/e/content/default.asp

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/

Charities Listings (Revenue Canada)
http://www.cra-arc.gc.ca/chrts-gvng/lstngs/menu-eng.html

Edmonton
http://data.edmonton.ca/

Elections BC (Political Contributions System)
http://contributions.electionsbc.gov.bc.ca/pcs/SA1ASearch.aspx

Halifax’s Open Data Catalogue
http://www.halifax.ca/opendata/

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

Merchandise imports, exports and trade balance, customs and balance of payments basis for all countries, by seasonal adjustment and principal trading partners
http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2280069&&pattern=&stByVal=1&p1=1&p2=31&tabMode=dataTable&csid=

National Pollutant Release Inventory (NPRI) datasets
http://www.ec.gc.ca/inrp-npri/Default.asp?lang=En&n=0EC58C98-1

Newfoundland and Labrador
http://open.gov.nl.ca/

Nova Scotia
https://data.novascotia.ca/

Ontario
http://www.ontario.ca/government/open-data-ontario
http://www.ontario.ca/government/open-government

Ontario’s Public Sector Salary Disclosure
http://www.ontario.ca/government/public-sector-salary-disclosure

Open Government Portal (Federal)
http://open.canada.ca/data/en/datase

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

Québec Ouvert (les données ouvertes pour le Québec)
http://quebecouvert.org/

Record Suspension Program 2015-2016 Report to Parliament
https://www.canada.ca/en/parole-board/corporate/transparency/reporting-to-canadians/record-suspension-report-to-parliament-2015-2016.html

Statistics Canada Trade Data
http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=2280069&&pattern=&stByVal=1&p1=1&p2=31&tabMode=dataTable&csid=

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

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

Vancouver
http://data.vancouver.ca/

Vehicle Recalls Database
http://open.canada.ca/data/en/dataset/1ec92326-47ef-4110-b7ca-959fab03f96d

DATA SETS FOR DOWNLOAD (TOP)

OPGsalaries2016.xlsx

UnivCollegeSalaries6.xlsx

Ontario Public Sector Salaries_2014-2016.zip

2016 Monthly Service Requests.zip

Revenue Canada’s charities database

To download the National Energy Board’s pipeline incident database, please click here.

To download the narratives from the National Energy Board’s pipeline incident database, please click here.

To download the Excel file the Prime Minister’s Office sent to reporters, please right-click here and use the “save-as”.

To download federal political donation data, please right-click here and use the “save-as”.

ACCESS TO INFORMATION LINKS (TOP)

Access to Information Act
http://laws-lois.justice.gc.ca/eng/acts/A-1/

Interim Directive on the Administration of the Access to Information Act
https://www.tbs-sct.gc.ca/pol/doc-eng.aspx?id=18310

Federal Departments and Agencies
http://canada.ca/en/gov/dept/index.html

Access to Information and Privacy Coordinators
http://www.tbs-sct.gc.ca/atip-aiprp/apps/coords/index-eng.asp

Info Source: information listings
https://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/sfgei-srgfff-eng.asp#A

Access to Information: general info
https://www.tbs-sct.gc.ca/hgw-cgf/oversight-surveillance/atip-aiprp/ai/index-eng.asp

Access to Information request forms
http://www.tbs-sct.gc.ca/tbsf-fsct/350-57_e.asp

Access to Information fillable request form

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

David McKie’s Coordination of Access to Information Requests System (CAIRS) site
http://www.davidmckie.com/coordination-of-access-to-information-requests-system-cairs/

Specific Exemptions under the Access to Information Act (Treasury Board of Canada Secretariat)
http://www.tbs-sct.gc.ca/pol/doc-eng.aspx?section=text&id=13784

Office of the Information Commissioner
http://www.oic-ci.gc.ca/eng/

Office of the Privacy Commissioner
http://www.priv.gc.ca

PROVINCES AND TERRITORIES

Alberta
http://www.servicealberta.ca/foip/

British Columbia
Main: http://www.gov.bc.ca/citz/iao/foi/
Completed requests: http://www2.gov.bc.ca/gov/search?id=4BAD1D13C68243D1960FECBBF7B8B091

Manitoba
Main: http://www.gov.mb.ca/chc/fippa/
Completed Requests: http://www.gov.mb.ca/chc/fippa/disclosure.html

New Brunswick
http://www2.gnb.ca/content/gnb/en/services/services_renderer.200949.html

Newfoundland and Labrador
Main: http://www.atipp.gov.nl.ca/info/accessrequestform.html
Completed requests: http://atipp-search.gov.nl.ca/

Northwest Territories
https://www.justice.gov.nt.ca/en/access-to-information-held-by-public-bodies/

Nova Scotia
Main: http://www.foipop.ns.ca/
Info: http://novascotia.ca/is/programs-and-services/information-access-and-privacy.asp

The Right to Know Coalition of Nova Scotia
http://www.nsrighttoknow.ca/

Nunavut
http://www.gov.nu.ca/eia/information/how-place-atipp-request

Ontario
https://www.ontario.ca/page/how-make-freedom-information-request

Prince Edward Island
https://www.princeedwardisland.ca/en/information/justice-et-securite-publique/freedom-of-information-and-protection-of-privacy-foipp

Quebec
Main: http://www.cai.gouv.qc.ca/english/
Contacts: http://www.cai.gouv.qc.ca/documents/CAI_liste_resp_acces_eng.pdf

Saskatchewan
http://www.saskatchewan.ca/residents/justice-crime-and-the-law/your-rights-and-the-law/make-a-freedom-of-information-request

Yukon
http://www.atipp.gov.yk.ca/

CITIES

Calgary
http://www.calgary.ca/CA/city-clerks/Pages/Freedom-of-Information-and-Protection-of-Privacy/Freedom-of-Information-and-Protection-of-Privacy.aspx

Edmonton
http://www.edmonton.ca/city_government/city_organization/freedom-of-information-and-privacy.aspx

Fredericton
http://www.fredericton.ca/en/right-to-information-and-protection-of-privacy

Halifax Regional Municipality
http://www.halifax.ca/AccessPrivacy/index.php

Hamilton
http://www.hamilton.ca/CityDepartments/CorporateServices/Clerks/MFIPPA_adn_PHIPA.htm

Moncton
http://www.moncton.ca/Government/Right_to_Information_and_Protection_of_Privacy_Act__RTIPPA_.htm

Montreal
http://ville.montreal.qc.ca/portal/page?_pageid=5798,39687582&_dad=portal&_schema=PORTAL

Ottawa
http://ottawa.ca/en/city-hall/your-city-government/access-information-and-privacy

Regina
http://www.regina.ca/residents/council-committees/learn-city-clerk/access_to_information_and_protection_of_privacy/

Saskatoon
https://www.saskatoon.ca/city-hall/send-comments-concerns-city/freedom-information

Toronto
http://www.toronto.ca/cap/form_foi.htm

Waterloo
http://www.waterloo.ca/en/government/freedomofinformation.asp

Winnipeg
http://winnipeg.ca/clerks/fippa/

Vancouver
http://vancouver.ca/ctyclerk/foi/index.htm

RESOURCES (TOP)

Books: 
The Data Journalist
Your Right To Know

Workshops:
Telling Your Story With Data
https://carleton.ca/globalacademy/telling-your-story-with-data/