All posts by David McKie

About David McKie

DESCRIPTION This course will teach students how to locate, obtain, and read public records with an investigative mindset. Students will learn to probe public records to uncover connections and patterns of information that might be invisible from reviewing one record in isolation. Students will learn how public records fit into a complete research strategy with the aim of telling, investigative, original and breaking stories, or simply adding context to ongoing stories.

Halifax Crime Mapped

Share

Points  on the map were downloaded from Halifax’s open data site on August 9, 2017. The different coloured points represent crimes that have occurred in Halifax Regional Municipality within a seven-day period. To see the individual crimes, click the dots for a pop-up box. Click the double-arrows at the top left to see the legend.

 

2016 Census Halifax

Share

Each census tract represents the percent change of lone-parent families in Halifax. The darker colours represent the areas with the highest percents. To see the census tract’s number, click inside the polygon to obtain a pop-up box.

Analysis: David McKie/ Source: Statistics Canada

GOVERNMENT OPEN-DATA WEBSITES

Share

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/

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

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

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

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

Toronto Unoccupied Dwellings 2016

Share

The darker purple colours represent the 2016 census tracts (called dissemination areas) that contain the highest number of unoccupied dwellings. To learn more details about the tracts with largest counts, zoom into the desired areas by clicking on the “+” sign, then clicking within the boundaries to produce a pop-up box with the details. The names represent the federal ridings, which should help you better situate the high-concentration areas.

Source: Statistics Canada 2016 Census/David McKie

Ottawa 2017 Census Tracts_Fusion Table

Share

The 2016 Ottawa census tracts chart the percent change between the 2011 census and the 2016 census. Click on the individual tracts to see the percent change. The darkest colours indicate those areas that experience the fastest growth rates. Use the plus and minus signs to the bottom right to zoom in and out. You can also maneuver key census tracts away from the legend. The red areas represent tracts with no values.

Source Statistics Canada

Percent population increases in federal ridings

Share

This map shows the percent of population increases in federal ridings from the 2011 cencus and the 2016 census

Source: Statistics Canada