The following lesson was provided to Hearst Connecticut Media Group on June 30, 2022. Please note: Those viewing the recording should import the datasets below into Google Sheets rather than using the Google Drive links as instructed during the live presentation.
About Your Instructor
Maggie Mulvihill is a veteran investigative and data journalist, journalism educator, news entrepreneur and impassioned defender of our right to know. Her data journalism students have been honored with 10 regional or national journalism awards since 2011 as well as being named finalists for the prestigious Livingston Award for Young Journalists. An attorney, Mulvihill is co-founder of the New England Center for Investigative Reporting. In 2014, Maggie founded Boston University’s summer workshops, Data + Narrative: Data-Driven Storytelling. She serves on the Steering Committee of the Reporter’s Committee for Freedom of the Press, the board of the New England First Amendment Coalition, was a 2004–2005 fellow at the Nieman Foundation for Journalism at Harvard University and was a 2014-2016 member of the Federal Freedom of Information Act Advisory Committee. (Photo Credit: Molly Hamill)
Dataset Links (.csv)
• Employees
• CT Firearms Dealers Lat Long
• Budget Data
• 0122-ffl-list-connecticut
• Connecticut Missing Persons
• Copy of CT State Police Payroll
• CT State Police Payroll
• Data_Download_ECHO_6_29_2022_62bbd5d945489
• PPP_Loans_to_Connecticut_Businesses
• RAR_Q4_CalYr_2021
• Spill_Incidents
• Wildlife_Export_6282022
Other Materials
Additional Database Analysis Lessons
• Data Cleaning 101
• Data Cleaning 102
• Data Visualization 101
• Web Scraping 101
• Web Scraping 102