iweld/chicago_crime_and_weather

An SQL analysis exploring the relationship between reported crimes in Chicago and the average daily temperature from 2018 through 2023.

Chicago Crime and Weather

Author: Jaime M. Shaker
Email: [email protected]
Website: https://www.shaker.dev
LinkedIn: https://www.linkedin.com/in/jaime-shaker/

❗ If you find this repository helpful, please consider giving it a ⭐. Thanks! ❗

Introduction

An SQL analysis of reported crimes in the city of Chicago and the average daily temperature between 2018 and 2023.

• Data Analysis Question & Answers

Datasets used

Eight key datasets for this case study

• chicago_areas.csv: Chicago neighborhoods and areas.
• chicago_temps_18-23.csv: City Weather 2018-2022.
• chicago_crime_2018.csv: Reported crimes in 2018.
• chicago_crime_2019.csv: Reported crimes in 2019.
• chicago_crime_2020.csv: Reported crimes in 2020.
• chicago_crime_2021.csv: Reported crimes in 2021.
• chicago_crime_2022.csv: Reported crimes in 2022.
• chicago_crime_2023.csv: Reported crimes in 2023.

Entity Relationship Diagram

❗ If you find this repository helpful, please consider giving it a ⭐. Thanks! ❗