|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Why Am I Doing This? |
|
|
|
|
|
|
|
|
|
|
|
I have been in
Information Technology since 2003, and data analysis is but one of my
disciplines. |
|
|
|
|
|
I am currently pursuing a
PhD in Information Technology with dual emphasis on data analytics and
information security (which is my profession). |
|
|
|
|
|
I plan on using this data
for (in some part) my dissertation with the focus being: 1) pattern-based
analytics; 2) differential analytics; 3) trending models used for specialized circumstances (e.g. a global pandemic
and predictive modeling). |
|
|
|
|
|
I find even the primary
data sources to focus too much on rolling totals and big datasets but
ignoring the smaller, more intricate and revealing data beneath it all - hence the need for differential analytics. |
|
|
|
|
|
I also find there is a
great deal of panic and ignorance in simply looking at rolling totals; the
media has been sensationalizing this very thing, playing on viewers' fears along the way. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Methodology |
|
|
|
|
|
|
|
|
|
|
|
I take daily snapshots
from 1 primary source: RoyLabs (which pulls directly from CDC, WHO and John
Hopkins). |
|
|
|
|
|
In order to truly capture
trending, in particular, one must capture daily (and weekly) data snapshots. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Definitions |
|
|
|
|
|
|
|
|
|
|
|
Pattern-based Analytics -
an overarching method of capturing and analyzing patterns to detect
root-cause (analysis), look for trends, and look for any predictors (if any exist) |
|
|
|
|
|
Differential Analytics -
calculating differences (in the postivve or the negative) between datasets
and calculating the results to show pattern-based behaviours (if any exist) |
|
|
|
|
|
Trending Models - visual
analytical models that help show trends (flat, peak, valley or plateau, up,
down) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sources |
|
|
|
|
|
|
|
|
|
|
|
|
WHO |
dates |
https://covid19.who.int/explorer |
|
|
|
|
|
|
|
|
|
RoyLabs |
daily stats |
https://youtu.be/NMre6IAAAiU |
https://docs.google.com/spreadsheets/d/e/2PACX-1vQuDj0R6K85sdtI8I-Tc7RCx8CnIxKUQue0TCUdrFOKDw9G3JRtGhl64laDd3apApEvIJTdPFJ9fEUL/pubhtml?gid=0&single=true |
|
|
|
|
|
KFF |
state stats |
https://www.kff.org/health-costs/issue-brief/state-data-and-policy-actions-to-address-coronavirus/ |
|
|
|
|
|
Tableau |
state stats |
https://public.tableau.com/views/KFF-CoronavirusTracker-JHUUpdateRF/Map-Dashboard?:display_count=y&:origin=viz_share_link&:showVizHome=no |
|
|
|
|
|
|
|
|
|
Worldometer |
country stats/pop |
https://www.worldometers.info/coronavirus/country/us/ |
|
|
|
|
|
CIA World Factbook |
2017 population |
|
|
|
|
|
|
|
|
|
|
NY Times |
state covid timeline |
https://www.nytimes.com/interactive/2020/03/21/us/coronavirus-us-cases-spread.html |
|
|
|
|
|
|
|
|
|
Jefferson County KY |
county stats |
https://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334 |
|
|
|
|
|
|
|
|
Info |
|
|
|
|
|
|
|
|
|
|
|
|
This is a study that
began 3/25/2020 through current. Why
3/25? This is when I started to notice things were getting much worse,
case-wise---especially in the U.S. As a result, I began my study on that day. |
|
|
|
|
|
Unfortunately, there are
certain daily snapshots that cannot be traced BACK prior to 3/25. |
|
|
|
|
|
|
|
|
|
|
|
|