Virginia: June 7, 2020

Clearing duplicate recoveries field after switch to hosp. discharges.

Copy recovered to hospital discharges

On January 27, 2021 we began removing negatives that were created from mixed units (specimens minus cases or test encounters minus cases) for states that are using explicit totals in our main total test results field (called totalTestResults in the API). Virginia never reported negatives directly and always reported in encounters, so the total time series was removed.

Backfill antigen and antibody testing (encounters) and positive testing (encounters) from state dataset, before we start collecting it daily.

On April 26, 2020, we began reporting Virginia's Ever hospitalized as calculated from {"Combined number of confirmed positive COVID-19..." + "...discharged"} from the official Virginia Hospital and Healthcare association public dashboard. On December 2, 2020, we revised out time series of Virginia's Ever hospitalized to align with what the state reports on the state dashboard.

Remove Antibody Pos+Total

Backfilled probables using positive - confirmed until 4/21.

Backfilling antibody totals and positives, from EasyDC logs and State file from 2020-08-16 all the way back (beginning of April)

PCR Test encounters going back all the way to 27-Feb, and matching positive PCR results

Starting in early May, Virginia has been reporting their tests in units of test encounters. CTP has been capturing this data in the Total Tests (PCR) column. CTP now added a column to capture tests reported in test encounters units so we are moving the data to the correct column.

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 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 59 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