Ohio: July 4, 2020

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). Ohio never reported negatives directly and always reported in specimens, so the total time series was removed.

On December 29, 2020, Ohio provided a timeseries of Total Tests (PCR), Positive Tests (PCR), Total Antigen Tests, and Positive Antigen Tests. The totals for PCR from the download did not initially match the dashboard because of a lag, but starting on January 6, 2021, the download matched the dashboard. We are backfilling all 4 metrics from this download, which will result in the addition of three new metrics (positive tests PCR, positive tests antigen, total tests antigen) and a full timeseries for Total Tests (PCR), enabling a totalTestResults switch.

Ohio has been reporting probable cases on its dashboard since 4/10. CTP did not create a column to capture explicit probable cases until 7/28, . This fills out probable cases from 4/10 through 7/27 using the difference between confirmed and total

CTP's current values for Total PCR Tests (People) only goes back until 5/13. Used the secondary screenshots to backfill to 4/20 (inclusive). OH reports the value as "Total Tested." Since OH reports in unclear units, we are defaulting to reporting "Total Tested" in Total Tests (PCR) until outreach gets back with more information.

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