The Best of Open Data

Share

Examples of public records

Proactive disclosure by department or agency
https://www.canada.ca/en/treasury-board-secretariat/services/reporting-government-spending/proactive-disclosure-department-agency.html

Indigenous and Northern Affairs Canada (Audit and Evaluation)
http://www.aadnc-aandc.gc.ca/eng/1100100011247/1100100011248#Aud

2017–18 Departmental Plan: Health Canada
https://www.canada.ca/en/health-canada/corporate/transparency/corporate-management-reporting/report-plans-priorities/2017-2018-report-plans-priorities.html

Reviews, Audits and Evaluations
http://www.tbs-sct.gc.ca/rma/database/aeve_e.asp

Hansard
http://www2.parl.gc.ca/housechamberbusiness/ChamberPublicationIndexSearch.aspx?Language=E&Mode=1&Parl=39&Ses=1

Historical parliamentary debates
http://parl.canadiana.ca/

Transcripts of Canadian parliamentary debates since 1901 are now online
https://mobilesyrup.com/2016/08/31/the-transcripts-of-canadian-parliamentary-debates-since-1901-are-now-online/

Lipad (earch the Canadian Hansard from 1901 to today)
https://www.lipad.ca/

Part III – 2018–19 Departmental Plans
https://www.canada.ca/en/treasury-board-secretariat/services/planned-government-spending/reports-plans-priorities/2018-19-departmental-plans.html

Plans and Priorities / Performance Reports
http://www.tbs-sct.gc.ca/est-pre/estime.asp#OSD

Federal bugets
http://www.fin.gc.ca/access/budinfo-eng.asp

Public Accounts (Government-wide)
http://www.tbs-sct.gc.ca/pd-dp/gr-rg/index-eng.asp

Proactive Disclosure
http://www.tbs-sct.gc.ca/pd-dp/index_e.asp

Auditor General of Canada
http://www.oag-bvg.gc.ca/internet/English/admin_e_41.html

Public Opinion Research Reports
http://www.porr-rrop.gc.ca/index-e.html

Access to information

Search Summaries of Completed ATI Requests
https://open.canada.ca/en/search/ati

Manitoba
Completed requests: http://gov.mb.ca/government/proactivedisclosure/index.html

June 1-7, 2018_weekly_list.pdf

May 25-May 31, 2018_weekly_list.pdf

May18-24,2018_weekly_list.pdf

June 8-14, 2018_weekly_list.pdf

June 15-21, 2018, weekly_list.pdf

June 29-July 5, 2018, weekly_list.pdf

July 13-19, weekly_list.pdf

FIPPA – departmental access requests list May 4-May 10, 2018.pdf

To obtain a zipped file containing Manitoba previously released requests from 2011 to May 2018, please click  here

Newfoundland and Labrador
Completed requests:http://atipp-search.gov.nl.ca/

Ottawa
Completed requests: https://ottawa.ca/en/city-hall/accountability-and-transparency/accountability-framework/freedom-information-and-protection-privacy/disclosure-mfippa-requests

Regina
Completed requests: http://open.regina.ca/group/freedom-of-information

Vancouver
Completed requests: http://vancouver.ca/your-government/freedom-of-information.aspx

Winnipeg
Completed requests: http://winnipeg.ca/clerks/fippa/AccessToInfo.stm

Cities (open-data sites)

Edmonton
http://data.edmonton.ca/

Halifax
https://www.halifax.ca/home/open-data

Fredericton
http://www.fredericton.ca/en/open-data

Mississauga
http://www.mississauga.ca/portal/residents/mississaugadata

Oakville
http://oakville.ca/data/

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

Toronto
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/

Saint John
http://catalogue-saintjohn.opendata.arcgis.com/

St. John’s
http://www.stjohns.ca/event/open-data

Vancouver
http://data.vancouver.ca/

Winnipeg
https://data.winnipeg.ca/

Crime

Conditional Release – Grant Rate 2016-2017 (Parole Board of Canada)
https://open.canada.ca/data/en/dataset/b9ce6212-7bfd-49f1-97a6-6bca5771bbde

Conditional Release Special Conditions 2016-2017 (Parole Board of Canada)
https://open.canada.ca/data/en/dataset/113d6905-6566-42e5-8113-65fd730b21cf

To download an Excel file containing the Conditional Release Special conditions 2016-17, please right-click here and save.

Parole Board of Canada Open Government Portal for conditional releases
https://open.canada.ca/data/en/dataset?portal_type=dataset&_organization_limit=0&organization=pbc-clcc

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

Environment

STORY: Ottawa contaminated sites a source of frustration for Mechanicsville neighbourhood
https://capitalnews.ca/ottawa-contaminated-sites-source-frustration-mechanicsville-neighbourhood/

Federal Contaminated Sites
http://tbs-sct.gc.ca/fcsi-rscf/classification-eng.aspx

Access data from the National Pollutant Release Inventory
https://www.canada.ca/en/environment-climate-change/services/national-pollutant-release-inventory/tools-resources-data/access.html

Pipeline investigation reports (Transportation Safety Board of Canada)
http://www.tsb.gc.ca/eng/rapports-reports/pipeline/

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

To download a zipped pipeline incident data file, please right-click here and save.

Federal, Provincial and Territorial ( open-data sites)

Open Government (Federal)
https://open.canada.ca/en

Open Government Portal (Federal)
https://open.canada.ca/data/en/dataset?portal_type=dataset

Alberta
http://data.alberta.ca/

B.C.
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/

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

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

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

Prince Edward  Island
https://www.princeedwardisland.ca/en/search/site/?f%5B0%5D=type%3Aservice&f%5B1%5D=field_service_topics%3A2237

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

Saskatchewan Open Data
http://www.opendatask.ca/

Following Money

BLOG:  Key statistics on Canada’s charity and non-profit sector
https://www.globalphilanthropy.ca/blog/key_statistics_on_canadas_charity_and_non_profit_sector

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

STORY: Statistics Canada turning to sewage to determine pot consumption
https://www.ctvnews.ca/sci-tech/statistics-canada-turning-to-sewage-to-determine-pot-consumption-1.3802765

Waste water analysis (J012173) (Buyandsell)
https://buyandsell.gc.ca/procurement-data/tender-notice/PW-18-00816110

STORY: Feds to search social media using AI to find patterns of suicide-related behaviour
http://www.cbc.ca/news/canada/nova-scotia/feds-to-search-social-media-using-ai-to-find-patterns-of-suicide-related-behaviour-1.4467167

Artificial Intelligence (AI) pilot project for surveillance of suicide-related behaviours using social media. (1000196416) (Buyandsell)
https://buyandsell.gc.ca/procurement-data/tender-notice/PW-17-00809483

Trudeau government preparing for long-awaited Indigenous Languages Act
http://aptnnews.ca/2018/05/10/trudeau-government-preparing-for-long-awaited-indigenous-languages-act/

Indigenous Languages Legislation (10180568) (Buyandsell)
https://buyandsell.gc.ca/procurement-data/tender-notice/PW-18-00826291

Buyandsell.gc.ca
https://buyandsell.gc.ca/

Merx
https://www.merx.com/

STORY: NAFTA’s saga so far: A guide to trade, the talks and Trump
https://www.theglobeandmail.com/politics/article-nafta-explainer-trump-canada-mexico-trudeau/

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

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

Merchandise imports and exports, customs and balance of payments basis for all countries, by seasonal adjustment and North American Product Classification System (NAPCS)
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1210012101

Canadian International Merchandise Trade Database
http://www5.statcan.gc.ca/cimt-cicm/home-accueil?lang=eng

NEWS RELEASE:Government of Canada Invests in Indigenous Economic Development across Western Canada
https://www.newswire.ca/news-releases/government-of-canada-invests-in-indigenous-economic-development-across-western-canada-676688403.html

WD – Grants and Contributions over $25,000
https://open.canada.ca/data/en/dataset/10b22c3b-7ff8-4b12-88ce-7e0765779077 (The page has been removed)

To download a saved version of the database, please click here.

Disclosure of Grants and Contributions
https://open.canada.ca/data/en/dataset/432527ab-7aac-45b5-81d6-7597107a7013

STORY: https://www.guelphmercury.com/news-story/2763229-seven-firms-have-received-money-from-acoa-for-20-consecutive-years/

ACOA Project Information
https://open.canada.ca/data/en/dataset/ad1f4897-3298-4d15-8e5e-094958be7388

Public Accounts (federal)
https://open.canada.ca/data/en/dataset/51c3b869-9182-4ee3-a7c2-36da0dc2889c

City of Toronto Open Data Catalogue – business
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/business/

City of Toronto Open Data Catalogue – finance
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/finance/

STORY: Facebook promises to join registry of lobbyists
http://www.cbc.ca/news/politics/lobbying-facebook-investigation-government-1.4630183

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

Budget and Finances (City of Halifax)
https://www.halifax.ca/city-hall/budget-finances/budget

Public Sector Compensation (Nova Scotia)
https://www.novascotia.ca/finance/en/home/publications/PSCD/default.aspx

Public Sector Compensation (Ontario)
https://www.ontario.ca/page/public-sector-salary-disclosure

Public Sector Compensation (Alberta)
https://www.alberta.ca/salary-disclosure.aspx

Health

Complete listing of all recalls and allergy alerts (Canadian Food Inspection Agency)
http://www.inspection.gc.ca/about-the-cfia/newsroom/food-recall-warnings/complete-listing/eng/1351519587174/1351519588221

STORY: Adverse drug reaction deaths kill thousands of Canadians:
https://globalnews.ca/video/3163939/adverse-drug-reaction-deaths-kills-thousands-of-canadians

Health Canada’s adverse drug reaction database
https://www.canada.ca/en/health-canada/services/drugs-health-products/medeffect-canada/adverse-reaction-database/medeffect-canada-caveat-privacy-statement-interpretation-data-search-canada-vigilance-adverse-reaction-online-database.html

Recalls and Safety Alerts (Health Canada)
http://www.healthycanadians.gc.ca/recall-alert-rappel-avis/index-eng.php?cat=3&_ga=2.62879726.391885525.1524421688-1331689611.1513217975

STORY: LTC home operators promise quick action to bring facilities into ‘good standing’
http://ottawacitizen.com/news/local-news/city-says-three-ltc-homes-flagged-by-province-are-now-in-compliance

Find long-term care homes in Ontario
http://www.health.gov.on.ca/en/public/programs/ltc/home-finder.aspx

Historical

Transcripts of Canadian parliamentary debates since 1901 are now online
https://mobilesyrup.com/2016/08/31/the-transcripts-of-canadian-parliamentary-debates-since-1901-are-now-online/

Historical parliamentary debates
https://www.lipad.ca/
http://parl.canadiana.ca/

Saskatcehewan Agricultural Crown Land Map Viewer
https://gisappl.saskatchewan.ca/Html5Ext/index.html?viewer=ACLMVE

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

International

World Bank Open Data
https://data.worldbank.org/

Statistics Canada

CANSIM – Table directory – All Section
http://www5.statcan.gc.ca/cansim/a29?lang=eng&groupid=All&p2=17

2016 Census Program release schedule
https://www12.statcan.gc.ca/census-recensement/2016/ref/release-dates-diffusion-eng.cfm

Reference materials, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/ref/index-eng.cfm

Census Profile, 2016 Census
Canada [Country] and Canada [Country]
https://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/page.cfm?Lang=E&Geo1=PR&Code1=01&Geo2=&Code2=&Data=Count&SearchText=Canada&SearchType=Begins&SearchPR=01&B1=All&TABID=1

2016 Census of Population advisory: Aboriginal peoples, Immigration and ethnocultural diversity, and Housing
https://www150.statcan.gc.ca/n1/daily-quotidien/171018/dq171018e-eng.htm?CMP=mstatcan

Census Profile, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/index.cfm?Lang=E

Download, Census Profile, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/download-telecharger/comp/page_dl-tc.cfm?Lang=E

2016 Census – Boundary files
http://www12.statcan.gc.ca/census-recensement/2011/geo/bound-limit/bound-limit-2016-eng.cfm

Aboriginal Peoples Highlight Tables, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/hlt-fst/abo-aut/Table.cfm?Lang=Eng&S=99&O=A&RPP=25

Census Profile, 2016 Census (Wemindji, Terres réservées aux Cris [Census subdivision], Quebec and Quebec [Province]
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/page.cfm?Lang=E&Geo1=CSD&Code1=2499812&Geo2=PR&Code2=24&Data=Count&SearchText=Wemindji&SearchType=Begins&SearchPR=01&B1=All&GeoLevel=PR&GeoCode=2499812&TABID=1

Census Profile, 2016 Census Wemindji, Terres réservées aux Cris [Census subdivision], Quebec and Quebec [Province]
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/details/page.cfm?Lang=E&Geo1=CSD&Code1=3560051&Geo2=PR&Code2=35&Data=Count&SearchText=Attawapiskat%2091A&SearchType=Begins&SearchPR=01&B1=All&GeoLevel=PR&GeoCode=3560051&TABID=1

Estimates of population by census metropolitan area, sex and age group for July 1, based on the Standard Geographical Classification
http://www5.statcan.gc.ca/cansim/a26?lang=eng&retrLang=eng&id=0510056&pattern=051-0056..051-0064&tabMode=dataTable&srchLan=-1&p1=-1&p2=31

2011 Census Profile
http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/prof/index.cfm?Lang=E

2011 Census Profile – Comprehensive download files for a selected geographic level: CSV or TAB
http://www12.statcan.gc.ca/census-recensement/2011/dp-pd/prof/details/download-telecharger/comprehensive/comp-csv-tab-dwnld-tlchrgr.cfm?Lang=E

2011 NHS Profile – Download NHS data for a complete geographic level: CSV or TAB
http://www12.statcan.gc.ca/nhs-enm/2011/dp-pd/prof/details/download-telecharger/comprehensive/comp-csv-tab-nhs-enm.cfm?Lang=E

Statistics Canada – Cannabis Consumer Prices
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1810021101

Transportation

STORY: Engine ‘surge’ said to be behind Air Canada jet’s emergency landing in Toronto
https://www.theglobeandmail.com/news/toronto/engine-surge-said-to-be-behind-air-canada-jets-emergency-landing-in-toronto/article35844158/

Civil Aviation Daily Occurrence Reporting System
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng

STORY: Airline safety plummets
https://okanaganedge.net/2018/02/20/airline-safety-plummets/

TSB releases preliminary 2017 transportation occurrence statistics
http://www.tsb.gc.ca/eng/medias-media/communiques/autres-other/2018/20180220.asp

Civil Aviation Daily Occurrence Reporting System (CADORS): Main Menu
http://wwwapps.tc.gc.ca/saf-sec-sur/2/cadors-screaq/m.aspx?lang=eng

Municipal

Resources

The Data Journalist