North Carolina: May 17, 2020

On March 3, 2021, we cleared the history of Negative (people or cases) in North Carolina. This number mixed units, but we kept it because we relied on it for totalTestResults. Now, with totalTestResults drawn from totalTestsViral, we no longer need the negatives field to be filled.

Backfilling Total Tests (PCR) from March-17th to May-17th, 2020. Updating the time series with the separated PCR tests starting on September 22th, 2020 -- this is when the state started reporting separate PCR and antigen testing.

Clearing duplicate recoveries field after switch to hosp. discharges.

Copy recovered to hospital discharges

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 19 rows for NC, NH, VA

Updating 2469 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 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

Daily update for 20200517