Open Data Links
Articles
International buyers eye N.S. vacation properties — especially in Cape Breton
https://www.cbc.ca/news/canada/nova-scotia/foreign-property-statistics-canada-cape-breton-properties-1.5213540
Calgary has 1,200 playground zones. Most speeding tickets are issued in just these 10 spots
https://www.cbc.ca/news/canada/calgary/calgary-playground-zones-top-10-ticket-locations-1.5130180
Northeast Calgarians wonder why their playground zones get so much less speed enforcement
https://www.cbc.ca/news/canada/calgary/calgary-playground-zones-tale-two-zones-1.5162003
How Calgary’s ‘built for speed’ playground zones punish people for doing what comes naturally
https://www.cbc.ca/news/canada/calgary/calgary-playground-zones-road-design-solutions-1.5163587
To download the data used in the Calgary speeding ticket series, please click here.
Sex offences against minors: Investigation reveals more than 200 Canadian coaches convicted in last 20 years
https://www.cbc.ca/sports/amateur-sports-coaches-sexual-offences-minors-1.5006609
MAPPING THE BATTLE OF NORMANDY
https://www.project44.ca/
Alcohol sends more Canadians to hospital than heart attacks: report
http://ottawacitizen.com/news/local-news/alcohol-sends-more-canadians-to-hospital-than-heart-attacks-report
Common Challenges, Shared Priorities: Measuring Access to Home and
Community Care and to Mental Health and Addictions Services in Canada
https://www.cihi.ca/en/shared-health-priorities-0
https://yourhealthsystem.cihi.ca/hsp/?lang=en
Heavy drinking, by age group
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1310009611
Can digital government produce usable and useful data for non-expert users? Canada’s National Energy Board faced the challenge with data visualization
http://policyoptions.irpp.org/magazines/february-2019/data-visualization-government-can-empower-dialogue/
Data Driven Journalism: Where Journalism Meets Data
http://datadrivenjournalism.net/
The National Institute for Computer-Assisted Reporting
https://www.ire.org/nicar
To download or open the Power Point presentation for this two-day session, please click here.
Follow The Money
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
2016-17 federal public accounts
https://www.documentcloud.org/documents/4114038-2017-vol3-Eng.html#document/p143/a474223
The Public Accounts of Ontario 2017-18
https://www.ontario.ca/page/public-accounts-ontario-2017-18
Government Open Data Portals
Federal
Open Data Portal
https://open.canada.ca/en/open-data
Provincial
College enrolment: Enrolment and statistical data for colleges of applied arts and technology in the province
https://www.ontario.ca/data/college-enrolment
University enrolment:Enrolment and statistical data for universities in the province that receive regular operating funding from the Ministry of Advanced Education and Skills Development
https://www.ontario.ca/data/university-enrolment
Census of agriculture: Statistical data from census of agriculture for 1996, 2001, 2006, 2011 and 2016
https://www.ontario.ca/data/census-agriculture
Consumer Inquiries: Number of consumer inquiries by method
https://www.ontario.ca/data/consumer-inquiries\
Employment standards claims report
https://www.ontario.ca/data/employment-standards-claims-report
Municipal
Toronto Open Data Catalogue
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/
To download the active Toronto lobbyist registry data, please click here.
311 Service Requests – Customer Initiated
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/#2fc027de-d27a-2a00-1388-6849497cb84c
Dinesafe Data
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/#e3c15b0f-5f83-0f12-fabb-c84018395c38
Vancouver Open Data Catalogue
https://vancouver.ca/your-government/open-data-catalogue.aspx
Montreal’s Open Data Catalogue
http://donnees.ville.montreal.qc.ca/portail/english-version-of-the-portail-des-donnees-ouvertes-de-la-ville-de-montreal/
Health
Canada Vigilance adverse reaction online database
https://www.canada.ca/en/health-canada/services/drugs-health-products/medeffect-canada/adverse-reaction-database.html
Alcohol sends more Canadians to hospital than heart attacks: report
http://ottawacitizen.com/news/local-news/alcohol-sends-more-canadians-to-hospital-than-heart-attacks-report
More Canadians hospitalized for alcohol and drugs than heart attacks, strokes: study
https://www.ctvnews.ca/health/more-canadians-hospitalized-for-alcohol-and-drugs-than-heart-attacks-strokes-study-1.4443557
Common Challenges, Shared Priorities: Measuring Access to Home and
Community Care and to Mental Health and Addictions Services in Canada
https://www.cihi.ca/en/shared-health-priorities-0
https://yourhealthsystem.cihi.ca/hsp/?lang=en
Common Challenges, Shared Priorities uploaded to DocumentCloud
https://www.documentcloud.org/documents/6128720-Common-Challenges-Shared-Priorities-CIHI-May-2019.html
To obtain the tutorial that explains how to download the CIHI data, please click here.
Canadian Institute for Health Information List of Data Holdings
https://www.cihi.ca/en/access-data-and-reports/make-a-data-request/data-holdings
Public Services
Public Tenders: https://buyandsell.gc.ca/
https://buyandsell.gc.ca/procurement-data/tenders/download-tenders-data
Public Accounts: https://open.canada.ca/data/en/dataset?portal_type=dataset&q=Public+accounts&organization=pwgsc-tpsgc
Treasury Board Secretariat’s Access to Information summaries: https://open.canada.ca/en/search/ati
For more great examples, check out another page I created called The Best of Open Data
National Parole Board Pardon Statistics
PardonsGrantedAndDenied – FY2011-2012 to MY2018-2019.xlsx
Statistics Canada
Statistics Canada’s data tables
Statistics Canada Releases Schedule
https://www150.statcan.gc.ca/n1/dai-quo/cal3-eng.htm
https://www150.statcan.gc.ca/n1/dai-quo/cal1-eng.htm
Canada’s jobless rate drops to 5.4%, lowest level in 43 years
https://www.cbc.ca/news/business/may-jobs-statscan-1.5166200
Labour Force Survey, May 2019
https://www150.statcan.gc.ca/n1/daily-quotidien/190607/dq190607a-eng.htm?HPA=1
Justice committee votes to scrub Conservative MP’s ‘hurtful’ remarks to Muslim witness from official record
https://www.cbc.ca/news/politics/justice-committee-online-hate-steyn-1.5161259
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
Tracking influence
SNC-Lavalin’s failure to secure deferred prosecution comes after years of legal fights, lobbying blitz
https://nationalpost.com/news/politics/snc-failure-to-secure-deferred-prosecution-comes-after-years-of-legal-fights-lobbying-blitz
Office of the Commissioner of Lobbying of Canada
https://lobbycanada.gc.ca/eic/site/012.nsf/eng/h_00000.html
Lobbyists ( British Columbia)
http://www.lobbyistsregistrar.bc.ca/
Lobbyists (Alberta)
http://www.lobbyistsact.ab.ca/LRS/Search.nsf/$$Search
Lobbyists (Saskatchewan)
https://www.sasklobbyistregistry.ca/
Lobbyists (Manitoba)
https://registry.lobbyistregistrar.mb.ca/lra/reporting/public/registrySearch.do?method=init
Lobbyists (Ontario)
http://www.oico.on.ca/home/lobbyists-registration
Lobbyists (Quebec)
https://www.lobby.gouv.qc.ca/servicespublic/consultation/ConsultationCitoyen.aspx
Lobbying (New Brunswick)
https://www.pxw1.snb.ca/snb9000/product.aspx?productid=A001PSNBCATLOBBY&l=e
Lobbyists (Nova Scotia)
http://www.gov.ns.ca/snsmr/lobbyist/
Lobbyists (Newfoundland and Labrador)
http://www.gs.gov.nl.ca/registries/lobbyists.html
Lobbyists ( Prince Edward Island)
https://www.princeedwardisland.ca/en/feature/lobbyist-registry#/
Office of the Lobbyist Registrar of Toronto
https://www.toronto.ca/city-government/accountability-operations-customer-service/accountability-officers/lobbyist-registrar/
Toronto Lobbyists Registry – Toronto Open Data Catalogue
https://www.toronto.ca/city-government/data-research-maps/open-data/open-data-catalogue/#94202791-cb02-4a98-4b1f-0f301b6f89d3
To download the active Toronto lobbyist registry data, please click here.
Follow the Money – political donations
http://special.nationalpost.com/follow-the-money/feature
WHO BACKS CANADA’S POLITICIANS? FOLLOW THE MONEY HERE
http://special.nationalpost.com/follow-the-money/database
Corporations fuelled Ontario Proud’s pro-PC election spending
https://www.cbc.ca/news/canada/toronto/ontario-proud-election-advertising-spending-1.4941210
Elections Ontario
https://www.elections.on.ca/en.html
Maxime Bernier’s broad regional donor base edges out remaining rivals
https://www.cbc.ca/news/politics/grenier-conservative-leadership-index-1.4095861
Follow this tutorial which explains how to download, save and open the donations table.
Create a pivot table with the help of this tutorial.
Story: Parties filling coffers in record numbers for fall federal election
https://www.cbc.ca/news/politics/canada-political-fundraising-federal-election-1.5116430
Tutorial for downloading federal political contribution data.pdf
Transportation
City of Ottawa Transportation Collision Data
http://data.ottawa.ca/dataset?q=transportation+collision+data
To obtain a zipped folder containing the City of Ottawa’s collision data,
please click here.
To obtain a zipped folder containing more detailed collision data the City of Ottawa
sent to the library, please click here.
National Collision Database
https://open.canada.ca/data/en/dataset/1eb9eba7-71d1-4b30-9fb1-30cbdab7e63a
Vehicle Recalls- Last 60 Days
https://open.canada.ca/data/en/dataset/1991fef6-9dfe-40e2-a0c6-19c60ddf4a02