Chicago Crime and Weather

Author: Sachin MM
Email: sachinds360@gmail.com
Website: https://www.sachinpfl.xyz
LinkedIn: https://www.linkedin.com/in/sachin-m-6a6a9a171/

❗ 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 2022.

• Data Analysis Question & Answers

Datasets used

Seven key datasets for this case study

• chicago_areas.csv: Chicago neighborhoods and areas.
• chicago_temps_18-22.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.

Entity Relationship Diagram

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