JMS
CIS 9440- Course section 53483
Maliha Maliha: [email protected]
Junhao Zhang: [email protected]
Stephany Tong: [email protected]
Ideas:
1- COVID affecting employment based on industry
The project aims to focus on COVID-19 data set including cases and deaths based on the different counties in New York State along with the census labor data which includes employment for different industries and the wages for different time periods.
Our goal is to analyze both data sets and gain insights into how this pandemic has affected different industries across New York state. The questions we would like to answer are:
- Which industry was the most affected based on the number of layoffs and which industry was the least affected?
- Is there a significant relationship between employment and COVID-19 cases/ deaths based on different industries across different time periods?
- Which county was the most affected in New York state?
- For the industries that laid off employees, were there substantial wage cuts?
- Did the industries that laid off employees start hiring again when New York state began lifting the restrictions?
Tentative Data Sets:
https://catalog.data.gov/dataset/quarterly-census-of-employment-and-wages-quarterly-data-beginning-2000/resource/5d662b63-78ee-49f6-8b8a-6d2f8bf32d57 (Employment by industries and on a county level for New York)
https://github.com/nytimes/covid-19-data/blob/master/us-counties.csv (US county wise COVID data)
2- COVID and NYPD complaints
The project aims to focus on the NYPD complaints during the COVID-19 pandemic to identify the impacts of staying at home order.
Our goal is to analyze both data sets and get the insight into the below questions:
- Which type of complaints happen most frequently?
- Which county has the most complaints?
- Does the number of complaints have a positive relationship with the number of COVID cases?
- What type of complaints increase mostly, and what is the relationship with the number of COVID cases?
Source data:
NYPD Complaint Data Current (Year To Date)
https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Current-Year-To-Date-/5uac-w243/data
Coronavirus-data by-boro.csv
https://github.com/nychealth/coronavirus-data/blob/master/boro/boroughs-case-hosp-death.csv
3- COVID cases & import/export goods/ services in the US
The project focuses on COVID-19 cases and deaths by state within the US. Based on that data, what goods and services did the US import/ export most during the peak times?
We would also like to answer the following questions:
- When and where were COVID cases the most concentrated?
- What goods or services were mostly imported / exported during the peak time?
- How was import and export impacted by COVID?
- What goods were being imported pre-COVID?
- Based on this information, can businesses in the US start producing these products to promote domestic goods? This should result in increasing employment within the US.
Potential Data Sources:
US COVID Cases & deaths by state
https://catalog.data.gov/dataset/united-states-covid-19-cases-and-deaths-by-state-over-time-845b7
International trade in goods and services
https://catalog.data.gov/dataset/us-international-trade-in-goods-and-services
Import export price indices
https://catalog.data.gov/dataset/import-export-price-indices
COVID-19 Related Goods: US Imports & Tariffs
https://catalog.data.gov/dataset/covid-19-related-goods-u-s-imports-and-tariffs-updated
4- Yelp Rating & Restaurant Inspection in the Nevada Area
The project focuses on the 2017 Yelp Review & Restaurant Inspection in the Nevada Area. Based on that data, it is to identify if 2017 restaurant inspections in the Nevada area have any effect on their Yelp ratings.
We would also like to answer the following questions:
- What is the relationship between inspection and rating?
- What is the change in average rating before and after the inspection?
Potential Data Sources:
Yelp Data:
https://www.kaggle.com/yelp-dataset/yelp-dataset?select=yelp_academic_dataset_review.json
Restaurant Inspection: