Date Number Title
April 6, 2021, 10:24 AM PDT 1144 [OR] Patch 12/01/20 cur. hosp numbers
April 6, 2021, 10:24 AM PDT 1144 [OR] Patch 12/01/20 cur. hosp numbers
April 6, 2021, 9:56 AM PDT 1142 [OR] Correct 10/31/20 Cases (confirmed + probable)
April 6, 2021, 9:56 AM PDT 1142 [OR] Correct 10/31/20 Cases (confirmed + probable)
March 1, 2021, 3:03 PM PST 1116 [OR] Patch 02/28/21 error
March 1, 2021, 3:03 PM PST 1116 [OR] Patch 02/28/21 error
February 12, 2021, 2:01 PM PST 1098 [OR] Patch 02/11/21 data
February 12, 2021, 2:01 PM PST 1098 [OR] Patch 02/11/21 data
February 8, 2021, 3:18 PM PST 1092 [OR] Patch OR 02/08/21 update
February 8, 2021, 3:18 PM PST 1092 [OR] Patch OR 02/08/21 update
February 8, 2021, 9:10 AM PST 1091 [OR] Delete history of confirmed and probable cases
February 8, 2021, 9:10 AM PST 1091 [OR] Delete history of confirmed and probable cases
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
January 22, 2021, 2:45 PM PST 1077 [OR] Patch 01/21/21 data
January 22, 2021, 2:45 PM PST 1077 [OR] Patch 01/21/21 data
January 19, 2021, 3:56 PM PST 1071 [OR] Remove values carried over after Oregon stopped reporting Recovered on 10/09/2020
January 19, 2021, 3:56 PM PST 1071 [OR] Remove values carried over after Oregon stopped reporting Recovered on 10/09/2020
January 19, 2021, 1:29 PM PST 1070 [OR] Correct 01/18 error
January 19, 2021, 1:29 PM PST 1070 [OR] Correct 01/18 error
January 13, 2021, 10:07 AM PST 1063 [OR] Move time series to a 1-day lag from the state (i.e., morning/noon EST) for consistency in reporting
January 13, 2021, 10:07 AM PST 1063 [OR] Move time series to a 1-day lag from the state (i.e., morning/noon EST) for consistency in reporting
January 7, 2021, 9:45 AM PST 1052 [OR] Patch 01/06 late update
January 7, 2021, 9:45 AM PST 1052 [OR] Patch 01/06 late update
January 6, 2021, 7:58 AM PST 1048 [OR] Patch 01/04 current hospitalization metrics
January 6, 2021, 7:58 AM PST 1048 [OR] Patch 01/04 current hospitalization metrics
January 6, 2021, 7:52 AM PST 1047 [OR] Correct changed case number 01/04
January 6, 2021, 7:17 AM PST 1046 [OR] Patch late 01/05 update
January 2, 2021, 2:03 PM PST 1039 [OR] Patch late 01/01/21 update
January 1, 2021, 3:39 PM PST 1035 [OR] Patch 12/30 late update
December 30, 2020, 2:35 PM PST 1034 [OR] Late update for 12/29
December 23, 2020, 3:03 PM PST 1025 [OR] Patch late 12/22 update
December 16, 2020, 9:36 PM PST 1016 [OR] Patching late update for 12/16
December 16, 2020, 1:32 PM PST 1015 [OR] Patch 12/15 late update
December 10, 2020, 5:26 PM PST 1005 [OR] Patching missed updates 12/9-12/10
December 4, 2020, 3:40 PM PST 997 [OR] Switch total tests from Total PCR tests (people) to Total PCR tests (specimens)
November 27, 2020, 1:47 PM PST 982 [OR] Patch 11/26 Negative PCR tests (specimens)
November 24, 2020, 9:38 PM PST 972 [OR] Patch 11/23 Current hosp, ICU, and vent. metrics
November 5, 2020, 4:54 AM PST 927 [OR] Remove In ICU – Cumulative value for 4/9
October 9, 2020, 1:07 PM PDT 893 [OR] Backfill 10/8 Data
September 21, 2020, 2:52 PM PDT 854 [OR] Probables backfill 5/4 - 7/27 and fixing confirmed case values 6/7, 6/10, 6/21
August 18, 2020, 10:50 PM PDT 776 Server CORS (Access-Control-Allow-Origin) header issue
July 19, 2020, 10:12 AM PDT 648 [OR] Data update missed on 7/15
July 15, 2020, 6:20 PM PDT 638 [OR] Add missing data points via state data reports?
July 15, 2020, 10:25 AM PDT 631 [OR] 6/15 Incorrect Hospitalization Value
July 8, 2020, 1:47 PM PDT 587 [OR] Wrong values were entered in Negative Tests (PCR) column
July 7, 2020, 5:33 PM PDT 582 [OR] missing data for 7/3, 6/27, 6/13 and 6/14
June 29, 2020, 6:36 AM PDT 556 [OR] PCL Case Historicals in States Daily
June 26, 2020, 7:15 AM PDT 549 [OR] PCL Historicals and WS2
June 14, 2020, 7:15 PM PDT 494 OR: bad data for today?
March 26, 2020, 2:53 PM PDT 62 OR: Incorrect data

#1144: [OR] Patch 12/01/20 cur. hosp numbers

Issue number 1144

hmhoffman opened this issue on April 6, 2021, 10:24 AM PDT

Open in Github

State: OR

Dates affected: 12/01/20 (OR was later put on a one day lag)

Describe the issue: On November 30, 2020, Oregon did not update their data dashboard until after the time of our daily update, but did provide a press release with data. We sourced their Positive Cases (People, confirmed + probable), Currently hospitalized, Currently in ICU, Deaths (confirmed and probable) from this press release. We later learned that the hospitalization figures from the press releases are different from the numbers we usually captured, and are backfilling their Currently hospitalized, Currently in ICU, and Currently on ventilator from screenshots.

Screenshot links: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201201-054743.png

Comments

hmhoffman commented on April 6, 2021, 10:24 AM PDT
Open in Github

Rows edited: 1 OR 2020-12-01 hospitalizedCurrently: 662 (was 584) inIcuCurrently: 127 (was 117) onVentilatorCurrently: 58 (was 50)

#1144: [OR] Patch 12/01/20 cur. hosp numbers

Issue number 1144

hmhoffman opened this issue on April 6, 2021, 10:24 AM PDT

Open in Github

State: OR

Dates affected: 12/01/20 (OR was later put on a one day lag)

Describe the issue: On November 30, 2020, Oregon did not update their data dashboard until after the time of our daily update, but did provide a press release with data. We sourced their Positive Cases (People, confirmed + probable), Currently hospitalized, Currently in ICU, Deaths (confirmed and probable) from this press release. We later learned that the hospitalization figures from the press releases are different from the numbers we usually captured, and are backfilling their Currently hospitalized, Currently in ICU, and Currently on ventilator from screenshots.

Screenshot links: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201201-054743.png

Comments

hmhoffman commented on April 6, 2021, 10:24 AM PDT
Open in Github

Rows edited: 1 OR 2020-12-01 hospitalizedCurrently: 662 (was 584) inIcuCurrently: 127 (was 117) onVentilatorCurrently: 58 (was 50)

#1142: [OR] Correct 10/31/20 Cases (confirmed + probable)

Issue number 1142

hmhoffman opened this issue on April 6, 2021, 9:56 AM PDT

Open in Github

State: OR

Dates affected: 10/31/20 (OR was later put on a one-day lag)

Describe the issue: On October 30, 2020, we recorded Oregon's Cases (confirmed + probable) as 44389, per the state page. On October 31, the state changed this number to 44388. We are updating our timeseries as well to ensure that our data matches the states as closely as possible.

Screenshot links: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20201031-004125.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20201030-184109.png

Comments

hmhoffman commented on April 6, 2021, 9:57 AM PDT
Open in Github

Rows edited: 1 OR 2020-10-31 positive: 44388 (was 44389)

#1142: [OR] Correct 10/31/20 Cases (confirmed + probable)

Issue number 1142

hmhoffman opened this issue on April 6, 2021, 9:56 AM PDT

Open in Github

State: OR

Dates affected: 10/31/20 (OR was later put on a one-day lag)

Describe the issue: On October 30, 2020, we recorded Oregon's Cases (confirmed + probable) as 44389, per the state page. On October 31, the state changed this number to 44388. We are updating our timeseries as well to ensure that our data matches the states as closely as possible.

Screenshot links: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20201031-004125.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20201030-184109.png

Comments

hmhoffman commented on April 6, 2021, 9:57 AM PDT
Open in Github

Rows edited: 1 OR 2020-10-31 positive: 44388 (was 44389)

#1116: [OR] Patch 02/28/21 error

Issue number 1116

hmhoffman opened this issue on March 1, 2021, 3:03 PM PST

Open in Github

State: OR

Dates affected: 02/28/21

Describe the issue: On February 28, 2021, we accidentally caught the data meant for Oregon's March 1, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on March 1, 2021, 3:08 PM PST
Open in Github

Rows edited: 1 OR 2021-02-28 positive: 155315 (was 155597) lastUpdateTime: 2021-02-27 08:01:00+00:00 (was 2021-02-26 08:01:00+00:00)

#1116: [OR] Patch 02/28/21 error

Issue number 1116

hmhoffman opened this issue on March 1, 2021, 3:03 PM PST

Open in Github

State: OR

Dates affected: 02/28/21

Describe the issue: On February 28, 2021, we accidentally caught the data meant for Oregon's March 1, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on March 1, 2021, 3:08 PM PST
Open in Github

Rows edited: 1 OR 2021-02-28 positive: 155315 (was 155597) lastUpdateTime: 2021-02-27 08:01:00+00:00 (was 2021-02-26 08:01:00+00:00)

#1098: [OR] Patch 02/11/21 data

Issue number 1098

hmhoffman opened this issue on February 12, 2021, 2:01 PM PST

Open in Github

State: OR

Dates affected: 02/11/21

Describe the issue: On February 11, 2021, we accidentally caught the data meant for Oregon's February 12, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on February 12, 2021, 2:02 PM PST
Open in Github

Rows edited: 1 OR 2021-02-11 positive: 148475 (was 149082) death: 2044 (was 2056) totalTestsViral: 3344227 (was 3364377) positiveTestsViral: 195355 (was 196002) negativeTestsViral: 3148872 (was 3168375)

#1098: [OR] Patch 02/11/21 data

Issue number 1098

hmhoffman opened this issue on February 12, 2021, 2:01 PM PST

Open in Github

State: OR

Dates affected: 02/11/21

Describe the issue: On February 11, 2021, we accidentally caught the data meant for Oregon's February 12, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on February 12, 2021, 2:02 PM PST
Open in Github

Rows edited: 1 OR 2021-02-11 positive: 148475 (was 149082) death: 2044 (was 2056) totalTestsViral: 3344227 (was 3364377) positiveTestsViral: 195355 (was 196002) negativeTestsViral: 3148872 (was 3168375)

#1092: [OR] Patch OR 02/08/21 update

Issue number 1092

hmhoffman opened this issue on February 8, 2021, 3:18 PM PST

Open in Github

State: OR

Dates affected: 02/07/21

Describe the issue: On February 7, 2021, we accidentally caught the data meant for Oregon's February 8, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on February 8, 2021, 3:26 PM PST
Open in Github

Rows edited: 1 OR 2021-02-07 positive: 146741 (was 147122) death: 2019 (was 2023)

#1092: [OR] Patch OR 02/08/21 update

Issue number 1092

hmhoffman opened this issue on February 8, 2021, 3:18 PM PST

Open in Github

State: OR

Dates affected: 02/07/21

Describe the issue: On February 7, 2021, we accidentally caught the data meant for Oregon's February 8, 2021 update. Oregon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update.

Comments

hmhoffman commented on February 8, 2021, 3:26 PM PST
Open in Github

Rows edited: 1 OR 2021-02-07 positive: 146741 (was 147122) death: 2019 (was 2023)

#1091: [OR] Delete history of confirmed and probable cases

Issue number 1091

karaschechtman opened this issue on February 8, 2021, 9:10 AM PST

Labels Data quality

Open in Github

State or US: OR

Describe the problem We used to get confirmed cases in OR by using their positive people tested number and probably by subtracting that number from lumped. However, this number included people tested by antigen, it was never really confirmed. We should clear the history of this field.

Link to data source Provide links to original data sources that we can refer to, like a state COVID website.

Comments

karaschechtman commented on February 8, 2021, 10:07 AM PST
Open in Github

#1091: [OR] Delete history of confirmed and probable cases

Issue number 1091

karaschechtman opened this issue on February 8, 2021, 9:10 AM PST

Labels Data quality

Open in Github

State or US: OR

Describe the problem We used to get confirmed cases in OR by using their positive people tested number and probably by subtracting that number from lumped. However, this number included people tested by antigen, it was never really confirmed. We should clear the history of this field.

Link to data source Provide links to original data sources that we can refer to, like a state COVID website.

Comments

karaschechtman commented on February 8, 2021, 10:07 AM PST
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

#1077: [OR] Patch 01/21/21 data

Issue number 1077

hmhoffman opened this issue on January 22, 2021, 2:45 PM PST

Open in Github

State: OR

Dates affected: 01/21/21

Describe the issue: On January 21, 2021, we accidentally caught the next days data for Oregon's data. Orgeon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update. On January 21, 2021, they published data abnormally early and we mistakenly caught the data meant for January 22, 2021 in our data for January 21, 2021.

Comments

hmhoffman commented on January 22, 2021, 2:46 PM PST
Open in Github

Rows edited: 1 OR 2021-01-21 positive: 135142 (was 135973) negative: 2868071 (was 2887359) hospitalizedCurrently: 387 (was 365) inIcuCurrently: 96 (was 91) death: 1832 (was 1843) totalTestsViral: 3003213 (was 3023332) positiveTestsViral: 179384 (was 180336) negativeTestsViral: 2823829 (was 2842996)

#1077: [OR] Patch 01/21/21 data

Issue number 1077

hmhoffman opened this issue on January 22, 2021, 2:45 PM PST

Open in Github

State: OR

Dates affected: 01/21/21

Describe the issue: On January 21, 2021, we accidentally caught the next days data for Oregon's data. Orgeon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update. On January 21, 2021, they published data abnormally early and we mistakenly caught the data meant for January 22, 2021 in our data for January 21, 2021.

Comments

hmhoffman commented on January 22, 2021, 2:46 PM PST
Open in Github

Rows edited: 1 OR 2021-01-21 positive: 135142 (was 135973) negative: 2868071 (was 2887359) hospitalizedCurrently: 387 (was 365) inIcuCurrently: 96 (was 91) death: 1832 (was 1843) totalTestsViral: 3003213 (was 3023332) positiveTestsViral: 179384 (was 180336) negativeTestsViral: 2823829 (was 2842996)

#1071: [OR] Remove values carried over after Oregon stopped reporting Recovered on 10/09/2020

Issue number 1071

jaclyde opened this issue on January 19, 2021, 3:56 PM PST

Labels Data quality

Open in Github

State: Oregon

Issue: On October 9, 2020, Oregon announced they were removing the Recovered metric from their reporting and working on a revised definition of recovered. We carried over the last available value, as that was our policy at the time, however the value is out of date and potentially confusing. We will be keeping the time series as provided by the state, but removing the carried over values from October 9, 2020, forward.

Comments

jaclyde commented on January 19, 2021, 3:56 PM PST
Open in Github
  • [x] make GH issue
  • [x] double check the metrics aren't being reported somewhere by the state
  • [x] remove carried over values
  • [x] null out source notes
  • [x] null out WS2 values add chart annotation no chart annotation added because we don't have a chart with this metric
  • [x] add public note
jaclyde commented on January 19, 2021, 4:18 PM PST
Open in Github

Values removed: Changes.txt

#1071: [OR] Remove values carried over after Oregon stopped reporting Recovered on 10/09/2020

Issue number 1071

jaclyde opened this issue on January 19, 2021, 3:56 PM PST

Labels Data quality

Open in Github

State: Oregon

Issue: On October 9, 2020, Oregon announced they were removing the Recovered metric from their reporting and working on a revised definition of recovered. We carried over the last available value, as that was our policy at the time, however the value is out of date and potentially confusing. We will be keeping the time series as provided by the state, but removing the carried over values from October 9, 2020, forward.

Comments

jaclyde commented on January 19, 2021, 3:56 PM PST
Open in Github
  • [x] make GH issue
  • [x] double check the metrics aren't being reported somewhere by the state
  • [x] remove carried over values
  • [x] null out source notes
  • [x] null out WS2 values add chart annotation no chart annotation added because we don't have a chart with this metric
  • [x] add public note
jaclyde commented on January 19, 2021, 4:18 PM PST
Open in Github

Values removed: Changes.txt

#1070: [OR] Correct 01/18 error

Issue number 1070

hmhoffman opened this issue on January 19, 2021, 1:29 PM PST

Open in Github

State: OR

Dates affected: 01/18

Describe the issue: On January 18, 2021, we accidentally caught the next days data for Oregon's Cases (confirmed + probable) and Deaths (confirmed + probable). Orgeon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update. On January 18, 2021, they published data abnormally early and we mistakenly caught the data meant for January 19, 2021 in our data for January 18, 2021.

Comments

hmhoffman commented on January 19, 2021, 1:30 PM PST
Open in Github

Rows edited: 1 OR 2021-01-18 positive: 133205 (was 133851) death: 1800 (was 1803)

#1070: [OR] Correct 01/18 error

Issue number 1070

hmhoffman opened this issue on January 19, 2021, 1:29 PM PST

Open in Github

State: OR

Dates affected: 01/18

Describe the issue: On January 18, 2021, we accidentally caught the next days data for Oregon's Cases (confirmed + probable) and Deaths (confirmed + probable). Orgeon's data is on a one-day lag in our timeseries due to consistently updating after 7:30 pm est, when we publish our daily update. On January 18, 2021, they published data abnormally early and we mistakenly caught the data meant for January 19, 2021 in our data for January 18, 2021.

Comments

hmhoffman commented on January 19, 2021, 1:30 PM PST
Open in Github

Rows edited: 1 OR 2021-01-18 positive: 133205 (was 133851) death: 1800 (was 1803)

#1063: [OR] Move time series to a 1-day lag from the state (i.e., morning/noon EST) for consistency in reporting

Issue number 1063

space-buzzer opened this issue on January 13, 2021, 10:07 AM PST

Labels Data quality

Open in Github

Target Date: Entire time series Overview: OR reports their daily numbers very later, which means that if we want to be on their schedule we need to backfill it daily (either in the evening or the following day). This is inconvenient and error-prone

We're moving their time series 1 day back in our dating and reporting. The actual date the state updates the data does not change, and remains in lastUpdatedAt field.

No metrics and no values are changing due to this update

Comments

space-buzzer commented on January 13, 2021, 10:09 AM PST
Open in Github

Done in batch #764

#1063: [OR] Move time series to a 1-day lag from the state (i.e., morning/noon EST) for consistency in reporting

Issue number 1063

space-buzzer opened this issue on January 13, 2021, 10:07 AM PST

Labels Data quality

Open in Github

Target Date: Entire time series Overview: OR reports their daily numbers very later, which means that if we want to be on their schedule we need to backfill it daily (either in the evening or the following day). This is inconvenient and error-prone

We're moving their time series 1 day back in our dating and reporting. The actual date the state updates the data does not change, and remains in lastUpdatedAt field.

No metrics and no values are changing due to this update

Comments

space-buzzer commented on January 13, 2021, 10:09 AM PST
Open in Github

Done in batch #764

#1052: [OR] Patch 01/06 late update

Issue number 1052

hmhoffman opened this issue on January 7, 2021, 9:45 AM PST

Labels not stale

Open in Github

State: OR

Dates affected: 01/06

Describe the issue: On January 6, 2021, Oregon updated their COVID-19 data after the time of our daily update.

Comments

stale[bot] commented on January 22, 2021, 2:08 PM PST
Open in Github

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

stale[bot] commented on February 1, 2021, 6:34 PM PST
Open in Github

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."

jaclyde commented on April 5, 2021, 8:38 PM PDT
Open in Github

Patched on 01/07/21: Changes (7).txt

#1052: [OR] Patch 01/06 late update

Issue number 1052

hmhoffman opened this issue on January 7, 2021, 9:45 AM PST

Labels not stale

Open in Github

State: OR

Dates affected: 01/06

Describe the issue: On January 6, 2021, Oregon updated their COVID-19 data after the time of our daily update.

Comments

stale[bot] commented on January 22, 2021, 2:08 PM PST
Open in Github

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

stale[bot] commented on February 1, 2021, 6:34 PM PST
Open in Github

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."

jaclyde commented on April 5, 2021, 8:38 PM PDT
Open in Github

Patched on 01/07/21: Changes (7).txt

#1048: [OR] Patch 01/04 current hospitalization metrics

Issue number 1048

hmhoffman opened this issue on January 6, 2021, 7:58 AM PST

Open in Github

State: OR

Dates affected: 01/04

Describe the issue: On January 4, 2021, Oregon did not update their data dashboard until after the time of our daily update.

Comments

hmhoffman commented on January 6, 2021, 8:00 AM PST
Open in Github

Rows edited: 1 OR 2021-01-04 hospitalizedCurrently: 520 (was 524) inIcuCurrently: 107 (was 119) onVentilatorCurrently: 55 (was 60)

#1048: [OR] Patch 01/04 current hospitalization metrics

Issue number 1048

hmhoffman opened this issue on January 6, 2021, 7:58 AM PST

Open in Github

State: OR

Dates affected: 01/04

Describe the issue: On January 4, 2021, Oregon did not update their data dashboard until after the time of our daily update.

Comments

hmhoffman commented on January 6, 2021, 8:00 AM PST
Open in Github

Rows edited: 1 OR 2021-01-04 hospitalizedCurrently: 520 (was 524) inIcuCurrently: 107 (was 119) onVentilatorCurrently: 55 (was 60)

#1047: [OR] Correct changed case number 01/04

Issue number 1047

hmhoffman opened this issue on January 6, 2021, 7:52 AM PST

Open in Github

State: OR

Dates affected: 01/04

Describe the issue: On January 4, 2021, Oregon revised the Total cases number on their website from 118456 to 118453. In order to ensure that our data is as consistent with Oregon's as possible, we are patching this metric in our timeseries.

Comments

hmhoffman commented on January 6, 2021, 7:54 AM PST
Open in Github

Rows edited: 1 OR 2021-01-04 positive: 118453 (was 118456)

#1046: [OR] Patch late 01/05 update

Issue number 1046

hmhoffman opened this issue on January 6, 2021, 7:17 AM PST

Open in Github

State: OR

Dates affected: 01/05/21

Describe the issue: On January 5, 2021, Oregon did not update their COVID-19 data page. On January 6, 2021, we were able to patch Cases (confirmed and probable), and Deaths (confirmed + probable) from a press release, and Currently hospitalized, Currently in ICU, and Currently on ventilator from one of their data dashboards.

Links: Press release, Data dashboard

Comments

hmhoffman commented on January 6, 2021, 7:44 AM PST
Open in Github

Rows edited: 1 OR 2021-01-05 positive: 119488 (was 118456) hospitalizedCurrently: 540 (was 520) inIcuCurrently: 110 (was 107) death: 1550 (was 1506) lastUpdateTime: 2021-01-05 08:01:00+00:00 (was 2021-01-04 08:01:00+00:00) dateChecked: 2021-01-06 15:38:00+00:00 (was 2021-01-05 23:34:00+00:00)

#1039: [OR] Patch late 01/01/21 update

Issue number 1039

hmhoffman opened this issue on January 2, 2021, 2:03 PM PST

Open in Github

State: OR

Dates affected: 01/01

Describe the issue: On January 1, 2021, Oregon did not update their COVID-19 page or data dashboards. We were able to update Cases (confirmed + probable) and Deaths (confirmed + probable) in our time series from a press release on January 2, 2021.

Links: https://www.oregon.gov/oha/ERD/Pages/Oregon-reports-1446-new-confirmed-and-presumptive-COVID-19-cases-13-new-deaths.aspx

Comments

hmhoffman commented on January 2, 2021, 2:49 PM PST
Open in Github

Rows edited: 1 OR 2021-01-01 positive: 115339 (was 113909) death: 1490 (was 1477) lastUpdateTime: 2021-01-01 08:01:00+00:00 (was 2020-12-31 08:01:00+00:00)

#1035: [OR] Patch 12/30 late update

Issue number 1035

hmhoffman opened this issue on January 1, 2021, 3:39 PM PST

Open in Github

State: OR

Dates affected: 12/30

Describe the issue: On 12/20 OR did not update until after the time of our daily update.

Comments

hmhoffman commented on January 1, 2021, 3:45 PM PST
Open in Github

Rows edited: 1 OR 2020-12-30 hospitalizedCurrently: 568 (was 570) inIcuCurrently: 117 (was 127) onVentilatorCurrently: 61 (was 60) dateChecked: 2020-01-01 23:42:00+00:00 (was 2020-12-30 23:55:00+00:00) checker: HMH (was CB-M) doubleChecker: ALF (was P*K)

#1034: [OR] Late update for 12/29

Issue number 1034

whobody opened this issue on December 30, 2020, 2:35 PM PST

Labels Data quality

Open in Github

Target Date: The date by which we hope to complete this issue. 12/30 Overview: Briefly describe what work the issue entails. We did not catch the 12/29 update for OR Contribution to milestone: Explain how the issue contributes to the overall milestone. We want good data. Other benefits: Explain any side benefits we could get from completing this issue. Michal is kinda scary and this will keep me from getting into trouble. Potential challenges: Explain any potential blockers. Nada Editorial: The specific editorial content we expect to come out of this issue.

Comments

whobody commented on December 30, 2020, 2:42 PM PST
Open in Github

Patched by bhp on 12/30.

#1025: [OR] Patch late 12/22 update

Issue number 1025

hmhoffman opened this issue on December 23, 2020, 3:03 PM PST

Open in Github

State: OR

Dates affected: 12/23

Describe the issue: On 12/22 Oregon did not update their data by the time of our daily update.

Comments

hmhoffman commented on December 23, 2020, 3:25 PM PST
Open in Github

Rows edited: 1 OR 2020-12-22 positive: 105073 (was 103755) negative: 2386364 (was 2315496) hospitalizedCurrently: 579 (was 595) hospitalizedCumulative: 6014 (was 5940) inIcuCurrently: 125 (was 131) onVentilatorCurrently: 67 (was 59) death: 1382 (was 1347) totalTestsViral: 2491437 (was 2472444) positiveTestsViral: 145343 (was 144207) negativeTestsViral: 2346094 (was 2328237)

#1016: [OR] Patching late update for 12/16

Issue number 1016

jaclyde opened this issue on December 16, 2020, 9:36 PM PST

Labels Data quality Missing Data Publish Time

Open in Github

State: OR

Dates affected: 12/16/2020

Describe the issue: On December 16, 2020, Oregon updated their COVID-19 response page after the publish time of our daily update.

Sources: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20201216-235912.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201216-235945.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-tertiary-20201216-235933.png

Comments

jaclyde commented on December 16, 2020, 9:41 PM PST
Open in Github

BEFORE: Screen Shot 2020-12-16 at 9 35 25 PM

AFTER: Screen Shot 2020-12-16 at 9 39 48 PM

#1015: [OR] Patch 12/15 late update

Issue number 1015

hmhoffman opened this issue on December 16, 2020, 1:32 PM PST

Open in Github

State: OR

Dates affected: 12/15/2020

Describe the issue: On December 15, 2020, Oregon updated their COVID-19 response page after the publish time of our daily update.

Comments

hmhoffman commented on December 16, 2020, 1:40 PM PST
Open in Github

Rows edited: 1 OR 2020-12-15 positive: 96092 (was 95010) negative: 2247636 (was 2209921) hospitalizedCurrently: 599 (was 601) hospitalizedCumulative: 5579 (was 5503) inIcuCurrently: 119 (was 134) onVentilatorCurrently: 67 (was 68) death: 1214 (was 1161) totalTestsViral: 2343728 (was 2304931) positiveTestsViral: 135329 (was 133562) negativeTestsViral: 2208399 (was 2171369) OR 2020-12-15 lastUpdateTime: 2020-12-15 08:01:00+00:00 (was 2020-12-14 08:01:00+00:00)

#1005: [OR] Patching missed updates 12/9-12/10

Issue number 1005

jaclyde opened this issue on December 10, 2020, 5:26 PM PST

Labels Data quality

Open in Github

State: Oregon

Issue: The dashboard we were using for testing, case and hospital metrics did not update before publish time, and the updates were published without all data. On 12/9 we missed the current hospitalization metrics. On 12/10 we missed all testing, case, and hospitalization metrics.

Sources: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201209-235723.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-secondary-20201210-235351.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-tertiary-20201210-235359.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201210-235407.png

Comments

jaclyde commented on December 10, 2020, 5:49 PM PST
Open in Github

BEFORE: Screen Shot 2020-12-10 at 5 38 52 PM

AFTER: Screen Shot 2020-12-10 at 5 46 26 PM

#997: [OR] Switch total tests from Total PCR tests (people) to Total PCR tests (specimens)

Issue number 997

jaclyde opened this issue on December 4, 2020, 3:40 PM PST

Labels Data quality

Open in Github

State: Oregon:

Issue: Oregon has stopped reporting Total, positive, and negative PCR tests (people) and started reporting Total PCR tests (specimens) as well as positive and negative PCR tests (specimens). We hope to get a time series from the state soon to backfill Total PCR tests (specimens

Comments

karaschechtman commented on December 4, 2020, 5:39 PM PST
Open in Github
space-buzzer commented on December 9, 2020, 4:39 PM PST
Open in Github
space-buzzer commented on December 9, 2020, 5:03 PM PST
Open in Github

In addition to backfilling specimens time series, we're also cleaning up the Total PCR Tests (People) field since Oregon stopped reporting it.

Multi-edit tool-PRODUCTION - OR-reb-20201210_cleanup.csv.txt Multi-edit tool-PRODUCTION - OR-reb-20201210_cleanup.post.csv.txt

#982: [OR] Patch 11/26 Negative PCR tests (specimens)

Issue number 982

hmhoffman opened this issue on November 27, 2020, 1:47 PM PST

Open in Github

State: OR

Dates affected: 11/26

Describe the issue: On November 26, 2020, Oregon's Negative PCR tests (specimens) were input as 960,657 based on a number from a press release due to the dashboard not being updated because of the Thanksgiving holiday. On November 27, 2020, the dashboard showed 960,604 negative tests. The decision was made to revert November 26, 2020's Negative PCR tests (specimens) value to 960469, the value shown on our historical screenshots of the dashboard to ensure that our time series was consistent.

Comments

hmhoffman commented on November 27, 2020, 1:57 PM PST
Open in Github

BEFORE: Screen Shot 2020-11-27 at 4 57 03 PM

AFTER: Screen Shot 2020-11-27 at 4 57 28 PM

#972: [OR] Patch 11/23 Current hosp, ICU, and vent. metrics

Issue number 972

jaclyde opened this issue on November 24, 2020, 9:38 PM PST

Labels Data quality

Open in Github

State: Oregon

Issue: We missed Oregon's hospital metrics update on 11/23. Patching in the values for Currently hospitalized, in ICU, and on ventilators.

Source: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-quaternary-20201124-114151.png

Comments

jaclyde commented on November 24, 2020, 9:43 PM PST
Open in Github

BEFORE: Screen Shot 2020-11-24 at 9 29 59 PM

AFTER: Screen Shot 2020-11-24 at 9 39 24 PM

#927: [OR] Remove In ICU – Cumulative value for 4/9

Issue number 927

muamichali opened this issue on November 5, 2020, 4:54 AM PST

Labels Data quality

Open in Github

State or US: Oregon

Describe the problem On 4/9 we recorded a cumulative in ICU value of 69 in Oregon. This seems to be a mistake

Link to data source Provide links to original data sources that we can refer to, like a state COVID website. image

Comments

space-buzzer commented on November 5, 2020, 10:35 AM PST
Open in Github

Updated in batch 466

#893: [OR] Backfill 10/8 Data

Issue number 893

hmhoffman opened this issue on October 9, 2020, 1:07 PM PDT

Labels Backfill Data quality

Open in Github

State: OR

Dates Affected: 10/8

Describe the issue: On 10/8, OR did not update in time for our publish. We should patch data from screencaps.

Links: https://covid-tracking.slack.com/archives/CUQ4MMTPD/p1602196821017200

Comments

MattHilliard commented on October 11, 2020, 11:33 AM PDT
Open in Github

Updated most columns from screenshots. Not available in screenshots: Hospitalized - currently, In ICU - currently, and On Ventilator - currently. Maybe for the same reason they updated late, there's no "data report" for 10/8 either, so as far as I know there's no way to recover the current hospitalization metrics.

Note OR isn't providing Recovered so that doesn't change even with normal data entry. Probable cases is calculated by subtracting Positive Cases (PCR) from Positives.

Relevant screenshots:

  • https://covidtracking.com/screenshots/OR/OR-20201009-002909.png
  • https://covidtracking.com/screenshots/OR/OR-secondary-20201009-002920.png
  • https://covidtracking.com/screenshots/OR/OR-tertiary-20201009-002933.png

Before: image

After: image

#854: [OR] Probables backfill 5/4 - 7/27 and fixing confirmed case values 6/7, 6/10, 6/21

Issue number 854

the-daniel-lin opened this issue on September 21, 2020, 2:52 PM PDT

Labels Backfill Data quality Historical Data

Open in Github

State or US: Oregon Describe the problem Oregon began to release total ("Total Cases") and confirmed ("Positive Tests") case values on 5/4. On 7/28, CTP began using a total - confirmed calculation to record probable values. We need to backfill these probable values back through 5/4, when OR first released confirmed/total values.

Beginning 6/6, Oregon does not update the confirmed values on their dashboard on weekends, so for those days, we carry over confirmed/probable values. Prior to 6/6, however, Oregon did provide consistent updates on their dashboard through the weekend, so we will not carry over those weekend values. On 7/3 and 9/7, OR did not update their dashboard, so we are carrying over values for those weekdays.

There are errors in Positive Cases (PCR) on 6/7, 6/10, and 6/21. On 6/7 and 6/21, Data Entry recorded the total case value in the Positive Cases (PCR) confirmed column as well. As these are unupdated weekend values, we should change these to the respective carried over values, from 4808 and 6937 to 4442 and 6344. On 6/10, Data Entry did not record the confirmed case value and only recorded the total cases value. We should change this to reflect the screen-captured value, from 5060 to 4907.

Link to data source Using Total-Confirmed calculation and spot checking with screenshots.

6/10: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/OR/OR-20200610-184345.png

Comments

the-daniel-lin commented on September 22, 2020, 7:55 AM PDT
Open in Github

Probables BEFORE: image image image image

the-daniel-lin commented on September 22, 2020, 8:02 AM PDT
Open in Github

Probables AFTER: image image image image

Backfilled values:

848 831 831 831 813 807 784 762 717 717 717 702 675 654 643 573 573 573 556 540 519 493 417 417 417 417 406 391 364 297 297 297 274 259 256 247 228 228 228 226 211 201 195 170 170 170 161 153 147 147 128 128 128 124 119 115 110 108 102 102 92 91 88 88 85 109 94 92 100 90 83 81 78 71 72 78 64 64 57 49 36 32 29 22 14

the-daniel-lin commented on September 22, 2020, 8:04 AM PDT
Open in Github

6/7, 6/10, 6/21 Confirmed Cases BEFORE: image

the-daniel-lin commented on September 22, 2020, 8:06 AM PDT
Open in Github

6/7, 6/10, 6/21 Confirmed Cases AFTER: image

#776: Server CORS (Access-Control-Allow-Origin) header issue

Issue number 776

loglow opened this issue on August 18, 2020, 10:50 PM PDT

Labels Data quality

Open in Github

Describe the problem The server does not appear to be returning Access-Control-Allow-Origin headers along with API requests.

This results in web browser errors such as: XMLHttpRequest at 'https://covidtracking.com/api/v1/us/daily.json' from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource.

I believe that the API server should be returning an Access-Control-Allow-Origin: * header, and that this would resolve the problem.

I don't have prior experience with these kinds of issues, so please forgive my ignorance if any of this is incorrect. I only began receiving these errors today for the first time, and I've been using this API for months now. I've temporarily mitigated the problem by routing all API requests through https://cors-anywhere.herokuapp.com/ but this doesn't seem like a great permanent solution.

Thanks for all your time and efforts!

Comments

muamichali commented on August 19, 2020, 7:17 AM PDT
Open in Github

@kevee can you please transfer to the website repo? 🙏

loglow commented on August 19, 2020, 2:12 PM PDT
Open in Github

Well, this just became more urgent because https://cors-anywhere.herokuapp.com/ is now giving me 429 Too Many Requests errors. Please fix ASAP.

loglow commented on August 19, 2020, 2:14 PM PDT
Open in Github
cors
loglow commented on August 19, 2020, 2:19 PM PDT
Open in Github

Safari flavor of errors below. Above was Chrome.

cors2
loglow commented on August 19, 2020, 2:23 PM PDT
Open in Github

PS. Firefox 79.0 (latest version) is working because apparently it's not yet strictly enforcing CORS policy.

For the above screenshots:

  • Chrome is 84.0.4147.135
  • Safari is 13.1.2 (14609.3.5.1.5)
kevee commented on August 19, 2020, 6:18 PM PDT
Open in Github

Per our API changelog, please use https://covidtracking.com/api/v1/us/daily.json instead of https://covidtracking.com/api/v1/us/daily.json. The website is doing a 301 redirect to the new API domain, but for some reason Netlify is stripping CORS out from that feedback, so I'll check in with them:

curl -I https://covidtracking.com/api/v1/us/daily.json
HTTP/2 301 
content-type: text/plain
location: https://api.covidtracking.com/v1/us/daily.json
loglow commented on August 19, 2020, 7:26 PM PDT
Open in Github

Thanks!

#648: [OR] Data update missed on 7/15

Issue number 648

MattHilliard opened this issue on July 19, 2020, 10:12 AM PDT

Labels Data quality

Open in Github

State or US: OR

Describe the problem We didn't get updated numbers on 7/15 for OR, probably because they updated after 5pm.

Link to data source Data report: https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Emerging%20Respitory%20Infections/Oregon-COVID-19-Update-07-15-2020-FINAL.pdf

Press release (with confirmed + probable cases): https://www.oregon.gov/oha/ERD/Pages/Oregon-reports-282-new-confirmed-and-presumptive-COVID-19-cases-4-new-deaths.aspx

Comments

MattHilliard commented on July 19, 2020, 10:38 AM PDT
Open in Github

I was able to update everything except Recovered from the OR data report and press release.

Before: image

After: image

terwilliger42 commented on July 19, 2020, 10:42 AM PDT
Open in Github

Thanks @MattHilliard !

#638: [OR] Add missing data points via state data reports?

Issue number 638

MattHilliard opened this issue on July 15, 2020, 6:20 PM PDT

Labels Data quality not stale

Open in Github

State or US: OR

Describe the problem We have a fair number of days without new data in various columns for OR. It seems like the "data reports" (below the press releases on the linked page) may allow filling in some of this data but I haven't investigated yet.

Link to data source https://www.oregon.gov/oha/erd/pages/covid-19-news.aspx "Data Reports" section

Comments

MattHilliard commented on July 19, 2020, 11:34 AM PDT
Open in Github

I looked at days we had no negative tests and found of the 15 days we don't have an updated data point, 6 of them can be repaired using OR data reports:

No data report available: 7/4, 6/28, 6/26, 6/20 Data reports available: 5/14, 5/12, 4/28, 4/10, 4/4, 4/1 Data report available but no test data: 4/22 Dates preceding data report horizon of 3/26: 3/25, 3/21, 3/14, 3/12

Some of those days have other data missing as well, e.g. positive cases or hospitalization.

terwilliger42 commented on July 21, 2020, 12:34 AM PDT
Open in Github

Thanks a lot @MattHilliard !!

stale[bot] commented on August 5, 2020, 1:47 AM PDT
Open in Github

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

stale[bot] commented on August 15, 2020, 2:45 AM PDT
Open in Github

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."

#631: [OR] 6/15 Incorrect Hospitalization Value

Issue number 631

the-daniel-lin opened this issue on July 15, 2020, 10:25 AM PDT

Labels Data quality Historical Data

Open in Github

"In Oregon the hospital/ICU/Vent counts are missing for Monday 6/15. This is provided (M-F) on Oregon's "Daily Update" PDF. You can get there by using the "Primary Source" you guys already have:

https://govstatus.egov.com/OR-OHA-COVID-19

... then click "+ Additional Data and Projections" ... then click "COVID-19 Daily Update" ... which links to this PDF: https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Emerging%20Respitory%20Infections/Oregon-COVID-19-Daily-Upda…

THANKS SO MUCH for coordinating this effort! This has been a HUGE help!"

I was unable to find ICU/Vent values from screenshots/wayback, but we do have a screenshot from 6/15 that shows an updated Hospitalization value -- 899 (not 875). image

Current CTP Data: image

Front logo Front conversations

Comments

terwilliger42 commented on July 15, 2020, 10:41 AM PDT
Open in Github

I'm the original submitter of that support ticket. Here's the Oregon Health Authority's report from that day -- which has all of the values (vent, hospital, icu, etc).

20200615.pdf

terwilliger42 commented on July 15, 2020, 10:44 AM PDT
Open in Github

If you don't find that trustworthy, then you can also get that same PDF directly from Oregon Health Authority:

https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Emerging%20Respitory%20Infections/Oregon-COVID-19-Update-06-15-2020-FINAL.pdf

Thanks for correcting this -- and thanks for the great resource.

MattHilliard commented on July 15, 2020, 4:59 PM PDT
Open in Github

@terwilliger42 Thank you so much for reporting this and following up to link to this data. Oregon is a tough state for us to record correctly because of the weekday/weekend reporting differences. Looking at this, I am pretty sure we have other days we can fix with these state reports. I'm not sure if they've always been there and I just hadn't seen them, but I personally have done cleanup work based on their textual press releases; these seem much better. Anyway, I will open a follow-up issue to investigate that possibility. Meanwhile, I've fixed our hospitalization data for 6/15:

Before: image

After: image

This report can also be used to update our Positive Cases (PCR) and Total PCR Tests columns for 6/15 (previously they were unchanged that day).

Before: image

After: image

#587: [OR] Wrong values were entered in Negative Tests (PCR) column

Issue number 587

muamichali opened this issue on July 8, 2020, 1:47 PM PDT

Labels Data quality stale

Open in Github

State or US: Oregon

Describe the problem It should not be Dashboard > Negative Tests / WEEKEND use Other link and check most recent press release just WEEKEND use Other link and check most recent press release

Link to data source https://covid-tracking.slack.com/archives/CUQ4MMTPD/p1594239559460200

Comments

MattHilliard commented on July 10, 2020, 6:39 PM PDT
Open in Github

@muamichali Was this related to https://github.com/COVID19Tracking/issues/issues/582 or something else? I can't tell based on the description.

stale[bot] commented on July 25, 2020, 6:56 PM PDT
Open in Github

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

stale[bot] commented on August 4, 2020, 7:35 PM PDT
Open in Github

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."

#582: [OR] missing data for 7/3, 6/27, 6/13 and 6/14

Issue number 582

MattHilliard opened this issue on July 7, 2020, 5:33 PM PDT

Labels Data quality

Open in Github

State or US: OR

Describe the problem Oregon has a weird system where they have a dashboard on weekdays but also daily press releases that include weekends. Our positive case data wasn't updated on 7/3, 6/27, 6/14 and 6/13, but this information is available from the state's press releases. Testing and deaths should also be re-checked for those days.

Link to data source https://www.oregon.gov/oha/erd/pages/covid-19-news.aspx?wp8888=p:1#g_0569e9ee_0a15_446d_9eb3_197889f78853

Reported via email

Comments

MattHilliard commented on July 10, 2020, 6:38 PM PDT
Open in Github

I've patched the historical data. It should be on the site within an hour.

Spreadsheet with analysis, plus before/after copies of States Daily: https://docs.google.com/spreadsheets/d/10zo0XLxh9sEhpBNjUY_6rvlk7ziQcYAQvD3ZTbtXE7A/edit

#556: [OR] PCL Case Historicals in States Daily

Issue number 556

muamichali opened this issue on June 29, 2020, 6:36 AM PDT

Labels PCL/SVP Historicals

Open in Github

State or US: OR

Describe the problem Cases There are some missing values for Positive Cases PCR in States Daily.

Link to data source Found while working on #549

Comments

camille-le commented on July 3, 2020, 7:35 AM PDT
Open in Github

Hey @muamichali, on May 4th, Oregon started reporting confirmed and presumptive cases. We've removed "Positive Cases (PCR)" from 2020-04-30 and 2020-04-29.

So while it appears there were missing values between 2020-05-01 and 2020-05-02, that is not the case.

BEFORE BEFORE_OREGON

AFTER AFTER_OREGON

Thanks! Camille

#549: [OR] PCL Historicals and WS2

Issue number 549

pscsharon opened this issue on June 26, 2020, 7:15 AM PDT

Labels PCL/SVP Historicals

Open in Github

Death values are historically recorded in both the "Deaths" and "Deaths (Confirmed)" columns for OR. However, OR’s death values are unclear about what they represent, so they should only be recorded in the main "Deaths" field.

Comments

pscsharon commented on June 26, 2020, 7:17 AM PDT
Open in Github

Added tooltip saying "no data" as well as process note.

Screen Shot 2020-06-26 at 7 16 16 AM
muamichali commented on June 28, 2020, 5:40 PM PDT
Open in Github

Deaths

BEFORE image

AFTER image

Note: while working on this I found an issue with missing Positive Cases PCR in States Daily and logged in separately. #556

karaschechtman commented on June 30, 2020, 8:08 AM PDT
Open in Github

DC'd by JJA

#494: OR: bad data for today?

Issue number 494

adamdavis40208 opened this issue on June 14, 2020, 7:15 PM PDT

Open in Github

I'm using a few fields for a pet project:

deathIncrease
death
positiveIncrease
totalTestResultsIncrease

image

All of these numbers have generally been populated and accurate, except for today. Just thought I'd drop you a note!

Comments

muamichali commented on June 14, 2020, 7:48 PM PDT
Open in Github

Hi Adam

If you look at the screenshots on our website https://covidtracking.com/data/state/oregon#historical you will see that Oregon has not been updating the numbers on their dashboard since 6/12. Is this possibly the answer to your question?

adamdavis40208 commented on June 14, 2020, 10:57 PM PDT
Open in Github

Ah. I didn't realize the data source only updated monday-friday

https://govstatus.egov.com/OR-OHA-COVID-19

Data current as of 6/12/2020, 12:01 a.m. Updated Monday - Friday.*

Good to know, sorry for the false alarm!

#62: OR: Incorrect data

Issue number 62

tedder opened this issue on March 26, 2020, 2:53 PM PDT

Labels Data quality stale

Open in Github

Comparing my dataset for Oregon (pulled from the official source) against yours, it looks like 3/25 is missing, causing 3/26 to be wrong.

my cases on 3/24-3/26: 209, 266, 316 my increases: 20, 50, 57 your cases: 209, 209, 327 your increases: 18, 0, 118

This may be because of this issue: https://github.com/COVID19Tracking/covid-tracking-api/issues/22

Spotchecking the 'positive' counts, they are correct except for 3/25, 3/21, and everything before about 3/19. Most of the older ones are a date-off-by-one error.

I wouldn't mind being invited to the Slack, if possible. I'm trying to replace my OR and FL datasets with yours to generate some graphs on Wikipedia.

Comments

careeningspace commented on March 26, 2020, 10:55 PM PDT
Open in Github

Unfortunately, I am not seeing a screen-capture of historical data, so all I have is a copy of the data we have collected:

  • [ ] Data collection log: Screen Shot 2020-03-27 at 1 51 34 AM

  • [ ] Daily Report (cut off at 4pm) Screen Shot 2020-03-27 at 1 36 27 AM

asheragy commented on April 21, 2020, 8:41 PM PDT
Open in Github

The same is happening between 4/8 and 4/11 for positives and deaths. Other columns are most likely effected too but unable to verify the correct values. #135

stale[bot] commented on May 6, 2020, 9:17 PM PDT
Open in Github

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions!

stale[bot] commented on May 16, 2020, 9:47 PM PDT
Open in Github

This issue has been closed because it was stale for 15 days, and there was no further activity on it for 10 days. You can feel free to re-open it if the issue is important, and label it as "not stale."