Exploring the Impacts of Government Responses on Pandemic Control and Local Tourism at Honolulu County

About the Project

The Class Project have four main parts

• Part 1 - Common Analysis sets the stage for the subsequent assignments. In A4 you conduct a base analysis. All of the students in the class will conduct the same analysis, but with a slightly different data subset. Python Notebook
• Part 2 - Extension Plan will require you to ask a human centered data science question that extends the work in A4: Common Analysis.
• Part 3 - Presentation will require you to give a modified (shorter) PechaKucha presentation of your completed project.
• Part 4 - Project Repository, creation of a fully documented repository and also requires the submission of a written project report. Python Notebook, Annotated R Code

Documentations

• Project Report pdf
• Part 1 Reflection Statement
• Part 1 Visualization Explanation
• Part 2 Extension Plan
• Part 4 Data Source and Intermediate Data Files Document

Data Sources

Six data sources are used in this project:

• Kaggle repository of John Hopkins University COVID-19 data Link
• The CDC dataset of masking mandates by county Link
• The New York Times mask compliance survey data Link
• Social Distancing Index from University of Maryland Link
• Oxford COVID-19 government response track Link
• Daily Passenger Counts Hawaii.gov Link

License

• Kaggle repository of John Hopkins University COVID-19 data license by Attribution 4.0 International by CC BY 4.0
• The CDC dataset of masking mandates by county data license by CC BY-NC-SA 3.0
• The New York Times mask compliance survey data License
• Social Distancing Index from University of Maryland CC0 1.0
• Oxford COVID-19 government response track CC BY 4.0
• Daily Passenger Counts Hawaii.gov DCAT-US Schema v1.1

Intermediate data files

• Honolulu_dataset.csv
• Honolulu_dataset_delay2.csv
• Honolulu_dataset_delay4.csv
• Honolulu_dataset_delay7.csv
• Honolulu_dataset_delay14.csv
• Honolulu_dataset_tourist.csv

Data Schema

Name	Type	Description	Example
date	string	ISO 8601 date (YYYY-MM-DD) of the datapoint	2020-07-30
daily_confirmed_cases	integer [0-inf]	Daily confired covid cases	25
daily_passenger_arrivals	integer [0-inf]	Daily confired covid cases	15000
school_closing	integer [0-3]	Schools are closed	2
workplace_closing	integer [0-3]	Workplaces are closed	2
contact_tracing	integer [0-2]	Country-wide contact tracing policy	1
facial_coverings	integer [0-4]	Policies on the use of facial coverings outside the home	2
stringency_index	double [0-100]	Overall stringency index	71.43
SDI	integer [0-100]	Overall stringency index	54

Graphical Outputs

Rate of Infections

Derivative Function of Rate of Infections

Histogram Of Daily Confirmed Cases

Correlation Heat Map