Quarantine Pilot Covid 19

The following featured work is a community collaboration (aka Potluck) and a public service pilot during our quarantine time in San Diego due to COVID-19. All contributors have worked together under one roof at some point and been collaborators remotely for several years over the last decade or so. We all also have played pickleball together. Even though we are all working under separate corporate banners now, the quarantine brought us together and we created a small pilot around one of the most critical and pertinent topic of our lifetime. In the interactive dashboard below, we provide visualization for COVID-19 data from multiple sources. The dashboard also allows the end user to compare two locations using some data-driven annotations we have added to the raw data provided by John Hopkins and New York times (see data source links below).

Weekly average Daily cases per 100k
San Diego, California, and US Mainland

Two weeks ago	Last week	This week
July 27th	Aug 3rd	Aug 8th

July 28th	Aug 3rd	Aug 9th

July 28th	Aug 3rd	Aug 9th

Quarantine Pilot Covid 19 Dashboard

Supported Annotations

We provide the following annotations in the current deployed version.

Spread rate

Spread rate = (Log[Confirmed cases at time t] - Log[Confirmed cases at time t-delta]) / delta

Daily Growth rate

This metric provides an indicator for the inflection point. A value switch from greater than 1.0 to less than 1.0 and staying below 1.0 indicates that we are close to an inflection point.

Daily growth rate = [New confirmed cases at day D / New confirmed cases at day [D-d] ]^(1/d)

Fatality rate

Since there is a lag between the confirmed cases and the resolution of those confirmed cases by several weeks. We provide a crude measure for now

Confirmed fatality rate = Cumulative deaths at time t / Cumulative confirmed cases at time t

Daily Cases per 100k

We are using a measure provided by ESRI for epidemic control assessment. An epidemic is considered controlled when there is maximum 0.5 new case per 100,000 people for a period of 21 days.

Credits

Team

Stephanie Siu, UI Lead

Sam Patel, Deployment Lead

Rajdeep Singh, Jamie Lawson, Analytics Leads

Date Sources

John Hopkins Covid19 data source

New York times Covid19 data source

Demographic data

Development kit

The analytics portion of this work has been developed in Scala.
The UI is driven by the Angular framework.
The charts are provided using non-profit license given graciously by AnyChart.
We are using Netlify for CICD.

Quarantine Covid 19 Pilot Git hub page

Disclaimer

There are a few countries and counties missing due to data sanitizing issues that would require significant effort to include - so we have settled with 95% of the locations from the data sources. All work shared here is for educational and informational purpose and users should use their own judgment in using the metrics and trends from this dashboard for any COVID-19 related social engagement strategies.