CIS 9440: Data Warehousing Group Project

Team members:

  1. Kotekoro Traore – kotekoro.traore@baruchmail.cuny.edu
  2. Neha Rajeevneharajeev.chaudhari@baruchmail.cuny.edu
  3. Sera Ahmedsera.ahmed@baruchmail.cuny.edu
  4. Trang Letrang.le@baruchmail.cuny.edu

Project Proposals:

  1. Unemployment and Crime rate in the US

The project focuses on finding the relation between unemployment and the crime rate for different states in the US. The goal is to find if a change in employment rate brings any change in the crime rate and if we could leverage this data to bring a positive change in the community and bring down the crime rate.

  1. Which states have the highest unemployment rate?
  2. Which states have the highest crime rate?
  3. Which month of the year has the highest unemployment rate?
  4. Which month of the year has the highest crime rate?
  5. Is there a relationship between the crime rate and unemployment rate of different states?
  6. What are the most common crimes in the states where crime is the highest?
  7. What are the most common crimes throughout the US?
  8. Can we predict the number of crime rate based on the unemployment rate?

Datasets: 

  1. https://www.kaggle.com/aniruddhasshirahatti/us-unemployment-dataset-2010-2020
  2. https://www.bls.gov/lau/#data
  3. https://crime-data-explorer.fr.cloud.gov/downloads-and-docs

 

2. NYC Crime and NY COVID-19 

This project is to find if NY during the COVID-19 period can control the crime rate by easing the lockdown rules and that if the NY COVID-19 has any relation with the crime rates of NY?

  1. Has the crime rate increased since COVID-19?
  2. Do the highly affected counties in NY by COVID-19 have a high crime rate?
  3. Which part of NY has been most affected by crime during COVID-19?
  4. Has the crime rate changed since the city started easing lockdown rules?
  5. What are the most common complaints during the COVID-19 period?
  6. Could the city lower the crime rate by easing the lockdown rules?

Datasets: 

  1. https://www.kaggle.com/sudalairajkumar/covid19-in-usa
  2. https://data.world/data-society/nyc-crime-data