My Google Sheets with Southern Nevada Health District COVID-19 zip code count data Since the beginning of the pandemic and close of workplace in March, 2020, I have applied my descriptive statistics training to the data from the Southern Nevada Health District (SNHD). In the beginning, it was simply new cases per day matching what I had learned from the Johns Hopkins Teach out on Epidemiology and Covid-19 on Coursera.org. By May, I was discovering the counts per day were changing as new information was incorporated into the data according to the SNHD guidelines*. Then I found a journal on Statistical Communications in Infectious Diseases and tried to make the data more accessible. Finally, I stumbled across the MinutePhysics YouTube video using a Log x Log scale illustration of case counts vs New Cases over the last seven days and felt that was the way to go. Not being skilled in animation or the tools they used, I found a way to coax Google Sheets to show a static graph of the data with date tags which served the same purpose. These I used in my role as member of the city's Senior Citizens' Advisory Board and general mitigation advocate. Now the complexity is to a point I am hesitant going further without a more neutral and stable platform for the data from which I can more quickly calculate per capita counts and graphs from there.
https://www.coursera.org/learn/covid19-epidemiology/home/welcome https://covid.southernnevadahealthdistrict.org/ http://covid.southernnevadahealthdistrict.org/cases/ http://covid.southernnevadahealthdistrict.org/cases/reports/
- If symptom onset date was missing, the following dates were substituted in this order: 1) diagnosis date, 2) lab collection date, 3) report date (date case was reported to SNHD), 4) event creation date (date case was entered into SNHD's surveillance system). Southern Nevada Health District reported cases of CoViD-19 daily and cumulative growth rate computation https://drive.google.com/file/d/1u7vZSLpLaxQKYPIn1Q_MHwI8ngHfl5km/view?usp=sharing statistical communications in infectious diseases 20502 covid19, Clark County, NV https://docs.google.com/spreadsheets/d/1PwZrbcdl306FvJoBPklxRSAcO5MNXr6Xh7xLEoAc1gk/edit?usp=sharing Epidemiological Curve to Date https://docs.google.com/spreadsheets/d/1HmVtcdD7AIN9nW9TWxBqPTdva1aja9863uPKcPzO1Oc/edit?usp=sharing Statistical Communications in Infectious Diseases from 5/3/2020, COVID-19, Clark County, NV https://docs.google.com/spreadsheets/d/1wM7ks5G0rv6Mw07HDWHQZh7laMb1OaWXbhFFLitmcfM/edit?usp=sharing Southern Nevada Health District daily report of CoViD-19 cases https://docs.google.com/spreadsheets/d/1GhtlKF-N02GMehmbXy-jVScPPcTFC7WGwKc04Oj0K60/edit?usp=sharing COVID-19 confirmed cases over time log x log Plot June 2, 2020, to date Clark County, NV; (SNHD) https://docs.google.com/spreadsheets/d/1pLjauoqU5eY0dnXDQDyr-rI3DgVGZjLG_khafqysGCY/edit?usp=sharing Video result for minute physics 7:16 How To Tell If We're Beating COVID-19 YouTube · minutephysics Mar 27, 2020 https://www.youtube.com/watch?v=54XLXg4fYsc