Date Number Title
March 29, 2021, 7:54 AM PDT 1136 [KY] Patch 01/25/21 Cur. hosp
March 29, 2021, 7:54 AM PDT 1136 [KY] Patch 01/25/21 Cur. hosp
January 27, 2021, 3:13 PM PST 1082 Removing values from the API field Negative from AK, CA, DC, GA, KY, NY, OH, OR, TX, VA and WA
January 27, 2021, 3:13 PM PST 1082 Removing values from the API field Negative from AK, CA, DC, GA, KY, NY, OH, OR, TX, VA and WA
November 29, 2020, 5:20 PM PST 985 [KY] Patching 11/29 late update
November 13, 2020, 11:59 AM PST 948 [KY] Backfill new Curr. Vent. metric for 11/12
September 24, 2020, 11:37 AM PDT 864 [KY] Probables Backfill Using Positive - Positive Cases(PCR) from 5/22 - 7/28
August 4, 2020, 9:52 PM PDT 734 [KY] Unresolved #REF! errors for KY Total Tests (PCR)
August 4, 2020, 6:59 AM PDT 730 [KY] Inputting PCR Tests (Specimens) in PCR Tests (People)
July 21, 2020, 10:34 AM PDT 653 [KY] Update on 7/19
July 9, 2020, 11:19 AM PDT 594 [KY] Total tests were used instead of PCR on 7/8
June 24, 2020, 5:47 PM PDT 518 Recent Data Anomalies in KY and other states

#1136: [KY] Patch 01/25/21 Cur. hosp

Issue number 1136

hmhoffman opened this issue on March 29, 2021, 7:54 AM PDT

Open in Github

State: KY

Dates affected: 01/25/21

Describe the issue: On January 25, 2021, we incorrectly captured Kentucky's Currently hospitalized as 1537 instead of 1539. This error was corrected on March 29, 2021.

Comments

muamichali commented on March 29, 2021, 8:22 AM PDT
Open in Github

#1136: [KY] Patch 01/25/21 Cur. hosp

Issue number 1136

hmhoffman opened this issue on March 29, 2021, 7:54 AM PDT

Open in Github

State: KY

Dates affected: 01/25/21

Describe the issue: On January 25, 2021, we incorrectly captured Kentucky's Currently hospitalized as 1537 instead of 1539. This error was corrected on March 29, 2021.

Comments

muamichali commented on March 29, 2021, 8:22 AM PDT
Open in Github

#1082: Removing values from the API field Negative from AK, CA, DC, GA, KY, NY, OH, OR, TX, VA and WA

Issue number 1082

jaclyde opened this issue on January 27, 2021, 3:13 PM PST

Labels Data quality

Open in Github

States: Alaska, California, Washington DC, Georgia, Kentucky, New York, Ohio, Oregon, Texas, Virginia, Washington

Issue: We are 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). See the Data FAQ for additional explanation.

Comments

jaclyde commented on January 27, 2021, 3:14 PM PST
Open in Github

Alaska: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:35 PM PST
Open in Github

California: Never reported negatives directly, but did report in Total tests (people) until April 21, 2020. Removing time series from present to April 22, 2020.

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:45 PM PST
Open in Github

Washington DC: Never reported negatives directly, and has always reported encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:48 PM PST
Open in Github

Georgia: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:49 PM PST
Open in Github

Kentucky: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:02 PM PST
Open in Github

New York: Never reported negatives directly and always reported in encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:09 PM PST
Open in Github

Ohio: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:14 PM PST
Open in Github

Oregon: Never reported negatives directly, but did report in Total tests (people) until December 1, 2020. Removing time series from present to December 2, 2020.

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:24 PM PST
Open in Github

Texas: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 5:44 PM PST
Open in Github

Virginia: Never reported negatives directly and always reported in encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 6:43 PM PST
Open in Github

Washington: Negatives were backfilled with values calculated from total tests (encounters)-confirmed cases in August 2020. Removing total time series.

Values Removed: Changes.txt

#1082: Removing values from the API field Negative from AK, CA, DC, GA, KY, NY, OH, OR, TX, VA and WA

Issue number 1082

jaclyde opened this issue on January 27, 2021, 3:13 PM PST

Labels Data quality

Open in Github

States: Alaska, California, Washington DC, Georgia, Kentucky, New York, Ohio, Oregon, Texas, Virginia, Washington

Issue: We are 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). See the Data FAQ for additional explanation.

Comments

jaclyde commented on January 27, 2021, 3:14 PM PST
Open in Github

Alaska: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:35 PM PST
Open in Github

California: Never reported negatives directly, but did report in Total tests (people) until April 21, 2020. Removing time series from present to April 22, 2020.

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:45 PM PST
Open in Github

Washington DC: Never reported negatives directly, and has always reported encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:48 PM PST
Open in Github

Georgia: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 3:49 PM PST
Open in Github

Kentucky: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:02 PM PST
Open in Github

New York: Never reported negatives directly and always reported in encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:09 PM PST
Open in Github

Ohio: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:14 PM PST
Open in Github

Oregon: Never reported negatives directly, but did report in Total tests (people) until December 1, 2020. Removing time series from present to December 2, 2020.

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 4:24 PM PST
Open in Github

Texas: Never reported negatives directly and always reported in specimens, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 5:44 PM PST
Open in Github

Virginia: Never reported negatives directly and always reported in encounters, removing total time series

Values Removed: Changes.txt

jaclyde commented on January 27, 2021, 6:43 PM PST
Open in Github

Washington: Negatives were backfilled with values calculated from total tests (encounters)-confirmed cases in August 2020. Removing total time series.

Values Removed: Changes.txt

#985: [KY] Patching 11/29 late update

Issue number 985

jaclyde opened this issue on November 29, 2020, 5:20 PM PST

Labels Data quality

Open in Github

State: Kentucky

Issue: Kentucky updated after our publish time. As usual on Sundays the update was only to Cases (confirmed and probable) and Deaths (confirmed and probable)

Source: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/KY/KY-secondary-20201129-232820.pdf

Comments

jaclyde commented on November 29, 2020, 5:21 PM PST
Open in Github

BEFORE: Screen Shot 2020-11-29 at 5 15 49 PM

AFTER: Screen Shot 2020-11-29 at 5 21 21 PM

#948: [KY] Backfill new Curr. Vent. metric for 11/12

Issue number 948

the-daniel-lin opened this issue on November 13, 2020, 11:59 AM PST

Labels Backfill Data quality

Open in Github

State or US: Kentucky

Describe the problem On 11/12/20, Kentucky began to include a Currently on Ventilator number in their daily PDF report. We need to backfill the number for 11/12.

Link to data source https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/KY/KY-tertiary-20201112-172508.pdf

Comments

hmhoffman commented on November 13, 2020, 12:04 PM PST
Open in Github

BEFORE: Screen Shot 2020-11-13 at 3 02 32 PM

AFTER: Screen Shot 2020-11-13 at 3 03 53 PM

#864: [KY] Probables Backfill Using Positive - Positive Cases(PCR) from 5/22 - 7/28

Issue number 864

esquared opened this issue on September 24, 2020, 11:37 AM PDT

Labels Data quality

Open in Github

State or US: Kentucky

Describe the problem State reports Probables back to 5/21/20. Using calculation of Positive - Positive Cases (PCR), all Probables match screenshots with the exception of 5/21/20. On 5/21/20, the Lab Confirmed and Total Positive numbers are transposed, but the difference equals the Probables number. Patched the numbers for 5/21/20 to address the transposition.

Link to data source https://govstatus.egov.com/kycovid19 https://covidtracking.com/screenshots/KY/KY-secondary-20200521-123329.png.

Comments

esquared commented on September 24, 2020, 12:03 PM PDT
Open in Github

Before and after values attached spreadsheet. Probable Timeseries Backfill.xlsx

#734: [KY] Unresolved #REF! errors for KY Total Tests (PCR)

Issue number 734

zachlipton opened this issue on August 4, 2020, 9:52 PM PDT

Labels Data quality

Open in Github

State or US: KY

Describe the problem A number of Total Tests (PCR) fields for KY in States Daily display #REF! instead of the expected value. Looks like it happened for all dates 20200512 and earlier.

A search of States Daily for REF! has 61 results. The formula in these cells is just =#REF!+#REF!

Comments

zachlipton commented on August 4, 2020, 9:54 PM PDT
Open in Github

I'm guessing this occurred in the process of addressing #730

space-buzzer commented on August 6, 2020, 12:17 PM PDT
Open in Github

The bad refs in KY was a formula that got moved too many cells to the left.

Pre/post revert to numbers and placing them in the correct column, without formulas this time: States Daily.zip

#730: [KY] Inputting PCR Tests (Specimens) in PCR Tests (People)

Issue number 730

the-daniel-lin opened this issue on August 4, 2020, 6:59 AM PDT

Labels Historical Data PCL/SVP Historicals

Open in Github

State or US: Kentucky

Describe the problem On 8/3, we discovered that we're currently reporting total PCR tests (specimens) in the Total PCR Tests (People) column. This is reflected in our SVP sheet and in 6/16 and 6/30 outreaches.

We need to:

  • Change popup notes
  • Copy over the values from Total PCR Tests (People) into Total Tests (PCR)

Link to data source 6/16 Outreach: https://covid-tracking.slack.com/archives/C0124MP2E5C/p1592314451088800 6/30 Outreach: https://covid-tracking.slack.com/archives/C0124MP2E5C/p1593540304173000

Comments

brianskli commented on August 4, 2020, 7:07 AM PDT
Open in Github

KY's units were confirmed to be in specimens.

Pop-ups were changed Before: Screen Shot 2020-08-04 at 10 04 38 AM After: Screen Shot 2020-08-04 at 10 04 46 AM

Values in States Daily were copied over Before: Screen Shot 2020-08-04 at 10 03 51 AM After: Screen Shot 2020-08-04 at 10 04 09 AM

#653: [KY] Update on 7/19

Issue number 653

brianskli opened this issue on July 21, 2020, 10:34 AM PDT

Labels Historical Data Missing Data

Open in Github

Front user reports that CTP did not enter data from KY's update on Sunday, 7/19.

PDFs with dates in question:

7/19: https://chfs.ky.gov/cvdaily/COVID19DailyReport0719.pdf 7/20: https://chfs.ky.gov/cvdaily/COVID19DailyReport0720.pdf

Front logo Front conversations

Comments

brianskli commented on July 21, 2020, 10:49 AM PDT
Open in Github

It is possible that KY's PDF was not uploaded in time for capture. The 7/19 PDF listed above was used for filling data.

Before: Screen Shot 2020-07-21 at 1 44 35 PM After: Screen Shot 2020-07-21 at 1 49 40 PM

#594: [KY] Total tests were used instead of PCR on 7/8

Issue number 594

muamichali opened this issue on July 9, 2020, 11:19 AM PDT

Labels Data quality

Open in Github

State or US: Kentucky

Describe the problem Total tests were used instead of PCR on 7/8 in negatives calculation. Total test should be 415,204 not 451,921 not

Link to data source https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/KY/KY-secondary-20200709-121201.png

Comments

muamichali commented on July 9, 2020, 12:24 PM PDT
Open in Github

BEFORE Screenshot_2020-07-09 Coronavirus numbers by state (CovidTracking, DEV COPY)

AFTER image

#518: Recent Data Anomalies in KY and other states

Issue number 518

muamichali opened this issue on June 24, 2020, 5:47 PM PDT

Labels Data quality

Open in Github

However, I have noticed in recent data pulls (over the past week or so) that there are some highly unusual (implausible) values for certain states during early-mid March. For example, KY goes from having 8 positive cases as of March 12, thousands of positive cases March 13-15, then back to 21 positive cases as of March 16. There are a number of other states with similar strange jumps in the number of positive tests (as well as decreases in the number of negative tests) in early-mid March.

These problems were not present in earlier datasets that I had downloaded from your site (e.g. on May 6). Do you know what happened to explain these unusual values?

Front logo Front conversations

Comments

muamichali commented on June 24, 2020, 6:25 PM PDT
Open in Github

Kentucky

BEFORE image

positives column to fix

image image image

Negatives column to fix image image image

Total Tests (PCR) column to fix image

image

image

AFTER image

Kansas

BEFORE image

positive to fix image negative to fix image

AFTER image

Maryland

BEFORE image

positive to fix image negative to fix image

AFTER image

Rhode Island

BEFORE image

positives image

negatives image

_I also changed 3/7 positives to 3 based on rebma's download file from RI _ AFTER image

Florida

BEFORE image

positives image negatives image

AFTER image

Indiana

BEFORE image image image image image image image image image image

AFTER image

New Hampshire

BEFORE image

image image image

AFTER image

###Oregon BEFORE image

image

AFTER image

###Iowa BEFORE image

image image

AFTER image