New Jersey: July 18, 2020

Clearing duplicate recoveries field after switch to hosp. discharges.

Copy recovered to hospital discharges

The state added antigen probable cases. Backfill the probables and adjust positives with both confirmed and the new probables.

Updated entire probables and total deaths columns for NJ based on its routine weekly release of probable deaths. There's no change to the last two days, just minor updates to historical data.

Weekly backfill of NJ probable deaths, updating total deaths as well. This is actually for two weeks since we skipped last week after they took an unusually long time to provide the "weekly" data update.

Our weekly backfill of NJ's probable deaths time series, including updating the total deaths to account for the modified probables data. This removes an apparent drop in NJ total deaths on 8/26.

Weekly backfill of NJ probable deaths using state-provided probable deaths by date of death time series. Total deaths recalculated from probable + confirmed (confirmed deaths are dashboard date). This updates historical data only; no change to today or yesterday since this backfill matches the recent NJ dashboards.

Updated New Jersey probables based on the revised probable death time series released on 8/14 (though dated 8/11). Our probables column now matches this time series and our total deaths has been updated to be the sum of our existing confirmed + the new probables. I've also extended our confirmed column back into March based on the assumption pre-5/3 total deaths were all confirmed.

Since 5/11. NJ has been reporting tests in "tests" units, but CTP has been capturing them in the "people" column. This moves all the values from 5/11-8/16 from "Total Tests PCR (People)" column to "Total Tests (PCR)" 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 143 rows for MA, NJ

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