Michigan: March 17, 2020

On March 4, 2021, we deleted the history of Negative (people or cases), because they represented negative tests, not individuals. Now that totalTestResults is not calculated from positive+negative, we do not need to duplicate negative specimens in the people field.

Backfill Probable Cases from 3/1-6/11 using the numbers from the file MI gave us on 6/11 (we didn't have the column yet then so we couldn't stash that anywhere)

Positive Cases PCR - timeseries corrections on june 9th , 59278 was duplicated on 6/9 by mistake on march 17th, a number was missed

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 104 rows for FL, IA, IN, KS, KY, MD, MI, NH, NV, NY, OR, RI, TX

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

Updating 3004 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 24 rows for MI

Updating 24 rows for MI

Daily update for 20200317