Skip to content

Latest commit

 

History

History
31 lines (22 loc) · 1.29 KB

README.md

File metadata and controls

31 lines (22 loc) · 1.29 KB
Raw

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.

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

alt text

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