MySQL Tutorial Using city of Ottawa 311 Data

Share

This page contains a tutorial for uploading the city of Ottawa’s 311 complaints data from Jan. 1, 2017, to August 2017 into MySQL.
Below  the video tutorial,  you’ll also find the MySQL queries that can be downloaded, and then uploaded to a MySQL query tab, allowing you to follow along.

As well, you’ll also find the PowerPoint presentation that accompanies the tutorial, complete with the page references in The Data Journalist. and the MySQL dump file that we uploaded for our Sept. 27 session.

http://www.davidmckie.com/OttawaServiceCalls_2013-2017_Dump_20170926.zip

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.

Leave a Reply

Your email address will not be published. Required fields are marked *