Nevada: March 6, 2020

On 10/15/2020, Nevada switched their reporting from Total Tests (PCR) to Total Test Encounters (PCR) and the full time series of the new unit is available on their dashboard, and can be accessed via the PowerBI source code.

Reconciled our historical positive cases (PCR) and total tests (PCR) with state data. No major changes, just corrects some transposed digits on a few days and also extends back history of positive cases (PCR) from 4/29 to 3/5 and total tests (PCR) from 4/29 to 3/22. Also updated our Positives column since it is the same as positive cases (PCR).

backfill

Updating 1952 rows for AK, AL, AZ, CT, DE, FL, ID, IL, IN, KY, LA, MA, MD, ME, MI, MN, MP, MS, NC, ND, NJ, NV, NY, OH, PR, SC, TN, VA, VI, VT, WA, WI

Updating 108 rows for NV

Updating 3 rows for NV

Updating 104 rows for FL, IA, IN, KS, KY, MD, MI, NH, NV, NY, OR, RI, TX

Updating 4944 rows for AK, AL, AR, AS, AZ, CA, CO, CT, DC, DE, FL, GA, GU, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MP, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY

Updating 589 rows for AK, AL, AR, AS, AZ, CA, CO, CT, DC, DE, FL, GA, GU, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MP, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY

Updating 278 rows for AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI, WV, WY