chicago_crime_and_weather
An SQL analysis exploring the relationship between reported crimes in Chicago and the average daily temperature from 2018 through 2023.
Last updated Apr 20, 2026
68
Stars
33
Forks
0
Issues
0
Stars/day
Attention Score
39
Language breakdown
No language data available.
▸ Files
click to expand
README
Chicago Crime and Weather
Author: Jaime M. Shaker
Email: jaime.m.shaker@gmail.com
Website: https://www.shaker.dev
LinkedIn: https://www.linkedin.com/in/jaime-shaker/
:exclamation: If you find this repository helpful, please consider giving it a :star:. Thanks! :exclamation:
Introduction
An SQL analysis of reported crimes in the city of Chicago and the average daily temperature between 2018 and 2023.Datasets used
Eight key datasets for this case study- chicago_areas.csv: Chicago neighborhoods and areas.
- chicagotemps18-23.csv: City Weather 2018-2022.
- chicagocrime2018.csv: Reported crimes in 2018.
- chicagocrime2019.csv: Reported crimes in 2019.
- chicagocrime2020.csv: Reported crimes in 2020.
- chicagocrime2021.csv: Reported crimes in 2021.
- chicagocrime2022.csv: Reported crimes in 2022.
- chicagocrime2023.csv: Reported crimes in 2023.
Entity Relationship Diagram
:exclamation: If you find this repository helpful, please consider giving it a :star:. Thanks! :exclamation:
