Illinois: June 27, 2020

On March 4, 2021, we cleared the history of Negative (people or cases) in Illinois. This number mixed units and we no longer need it to calculate totalTestResults.

CTP didn't have a column for probables until 7/28 and we started a confirmed cases column on 4/29. IL didn't start separating out confirmed and probables until 6/8.

Calculated probables as positive - positive(PCR) from 6/9 to 7/28.

backfill

Updating 5800 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 5827 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 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 74 rows for IL, MA

Updating 37 rows for IL

Daily update for 20200627