Teaching Case: SQL as a Tool for Civic Crime Analysis

Authors

Shwadhin Sharma, California State University, Monterey BayFollow

Abstract

This case study engages students in the practice of civic data analysis by applying SQL to the Los Angeles Police Department’s open crime datasets, covering the period from 2010 to the present. Participants step into the role of city analysts responsible for examining crime distribution, temporal rhythms, enforcement outcomes, and neighborhood variations. Through structured exercises, learners gain hands-on experience with SQL operations, including table creation, data cleaning, aggregation, and spatial joins. The project emphasizes how database queries can reveal actionable insights for policy discussions on public safety, community partnerships, and policing strategies. In doing so, students strengthen both their technical fluency in SQL and their ability to interpret real-world public data in a critical, applied context.

DOI

https://doi.org/10.62273/QOXY7659

Recommended Citation

Sharma, Shwadhin (2026) "Teaching Case: SQL as a Tool for Civic Crime Analysis," Journal of Information Systems Education: Vol. 37 : Iss. 1 , 61-71.
DOI: https://doi.org/10.62273/QOXY7659
Available at: https://aisel.aisnet.org/jise/vol37/iss1/4