https://coronavirus-northwestern.herokuapp.com/
The rapid spread of the virus that causes COVID-19 has sparked alarm worldwide. The World Health Organization (WHO) has declared this rapidly spreading coronavirus outbreak a pandemic, and any countries are grappling with a rise in confirmed cases. Because this is a new virus, there are still things we do not know, such as how severe the illness can be, how well it is transmitted between people, and other features of the virus.
Therefore, we are collecting datasets and visualizing them to see if we can predict and find patterns of the virus.
- Any pattern vs GDP/capita, or public healthcare funding spends or index, temperature
- Stage and pattern of the pandemic (research the terminology and concept of stages)
- Population distribution and healthcare resources by Geo Mapping
- Future projection
-
[Country-Level Data] Johns Hopkins full dataset (https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_daily_reports). Available as csv file.
-
[State and County-Level Data] New York Times US dataset (https://github.com/nytimes/covid-19-data). Available as csv file.
- Check for duplicates and missing data
- Remove and rename columns
- Drop NAs and zeros
- Change data types to correct types
All data are loaded to PostgresSQL. Data are organized into 5 tables.
- countries
- global_population
- covid19
- health_exp_gdp
- global_gdp
Database stucture also illustrated with diagram below.
Javascript calls flask api to query data from PostgreSQL
- Bootstrap for layout
- Leaflet for map
- D3 for one line chart
- Highcharts for line charts
- Plotly for scatter plots
- Awesome Fonts for icons