New Mexico

State or US: New Mexico

Describe the problem We were previously calcaulating Negative (People or Cases) in New Mexico because our system relied on adding positive+negative to get total tests. Since this is no longer the case, we are removing the calculated negatives timeseries.

The last time NM reported negatives explicitly was for April 4th, 2020: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/NM/NM-20200405-001135.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/NM/NM-20200406-121242.png

State or US: New Mexico

Describe the problem We were previously calcaulating Negative (People or Cases) in New Mexico because our system relied on adding positive+negative to get total tests. Since this is no longer the case, we are removing the calculated negatives timeseries.

The last time NM reported negatives explicitly was for April 4th, 2020: https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/NM/NM-20200405-001135.png https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/NM/NM-20200406-121242.png

State or US: New Mexico

Describe the problem CTP started capturing total tests data in NM on 5/12. The state provides a data download file that adds tests from 4/10 - 5/11 so we are going to backfill them.

Link to data source https://e7p503ngy5.execute-api.us-west-2.amazonaws.com/prod/GetCvDataByDay Changes (2).txt

State or US: New Mexico

Describe the problem CTP started capturing total tests data in NM on 5/12. The state provides a data download file that adds tests from 4/10 - 5/11 so we are going to backfill them.

Link to data source https://e7p503ngy5.execute-api.us-west-2.amazonaws.com/prod/GetCvDataByDay Changes (2).txt

State: NM

Dates affected: 02/27/21

Describe the issue: On February 27, 2021, New Mexico updated their COVID-19 data after the time of our daily update.

State: NM

Dates affected: 02/27/21

Describe the issue: On February 27, 2021, New Mexico updated their COVID-19 data after the time of our daily update.

State: New Mexico

Issue: New Mexico updated Total tests (specimens) after our publish time on 1/28/2021.

Source:

State: New Mexico

Issue: New Mexico updated Total tests (specimens) after our publish time on 1/28/2021.

Source:

State or US: NM

Describe the problem We appear to store NM cases in the "confirmed" field because they call them "Positive test results" on their website. However, there is no indication anywhere (or from our outreach) to clarify that these positives are PCR only, and reports such as KHN's have implied they include antigen tests in the figure. Clearing the confirmed field history.

State: NM

Dates affected: 12/09

Describe the issue: On December 9, 2020, New Mexico updated their Total PCR tests (specimens) after the time of our daily update. As a result we were unable to update their Total PCR tests (specimens) and Negative PCR tests (people), which is calculated as Total PCR tests (specimens) minus Positive PCR tests (people), on December 9, 2020.

** State or US**: New Mexico ** Problem** NM updates their dashboard late during the day, so up until now, we were capturing values reported on the previous day. Starting today (Nov-18, 2020) we will be capturing the values NM publishing on the day of their publish, such that our dating of the data matches the states dating. For this, we will shift the entire time series by 1 day.

NM publishes historic time series, available at: https://cvprovider.nmhealth.org/public-dashboard.html (clicking "Show Historical Statewide Data). We'll use this to also patch a few days and fill missing values at the beginning of the series.

State or US: New Mexico

Describe the problem Per outreach, New Mexico reports tests in specimens, not unique people.

Link to data source "At the beginning of testing in New Mexico, we reported on number of persons tested. This was the Governor’s office request for testing all New Mexicans. This wasn’t a problem because tests were so sparse most people were tested once, unless positive. We only count positives the first time because of circulating bits of RNA which is no longer infectious after 10 days of infection. On 5/13 we changed to reporting all tests done daily including positive repeats to better measure resources used. The info page is not reflective of the testing to date. They are the total # of tests not persons tested. " David Morgan, PIO DOH 9/21

Action Plan

• [ ] Move 5/13-9/22 time series from Total Tests PCR (People) to Total Tests (PCR)

State or US: New Mexico

Describe the problem Due to a late shift, the data meant for entry on 8/20 was captured. The missing data can be patched using the linked screenshot.

Link to data source https://cvprovider.nmhealth.org/public-dashboard.html https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/NM/NM-20200819-122149.png

State or US: New Mexico

Describe the problem The data meant to be entered on 7/31 was instead entered on 7/30 due to a late shift. As a result, there are no new numbers for 7/31. Backfill using screenshots is required to separate the two days' data.

Link to data source https://cvprovider.nmhealth.org/public-dashboard.html http://covid-tracking-project-data.s3-website.us-east-1.amazonaws.com/state_screenshots/NM/

State: NM

Issue: We are concerned with whether they are only reporting RT-PCR testing results. The state page says: ""Positive COVID-19 cases in NM"" with the source listed as ""Test results are from the state Scientific Laboratory Division of the New Mexico Department of Health, TriCore Reference Laboratories, LabCorp, Mayo Clinic Laboratories, Quest Diagnostics, and BioReference Laboratories."" They do not spell out what kind of test they use, and further outreach is necessary.

Sources: https://cv.nmhealth.org/

Death values are historically recorded in both the "Deaths" and "Deaths (Confirmed)" columns for NM. However, NM's death values represent lumped probable and confirmed figures, so they should only be recorded in the main "Deaths" field.

There's an entry for 4/11/20, however, it appears as if no testing took place.

> covid %>% filter(state == "NM", date >= "2020-04-10", date <= "2020-04-11")
        date state positive negative pending hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently
1 2020-04-11    NM     1091    26007      NA                    75                     NA             NA              NA                    18
2 2020-04-10    NM     1091    26007      NA                    73                     NA             NA              NA                    18
  onVentilatorCumulative recovered dataQualityGrade lastUpdateEt          dateChecked death hospitalized totalTestResults fips deathIncrease
1                     NA       235                A   2020-04-10 2020-04-11T20:00:00Z    19           NA            27098   35             0
2                     NA       217                A   2020-04-10 2020-04-10T20:00:00Z    19           NA            27098   35             3
  hospitalizedIncrease negativeIncrease positiveIncrease totalTestResultsIncrease population
1                    0                0                0                        0    2096829
2                    0             3065              226                     3291    2096829

NM new positive cases, cases in hospital, deaths are reported daily together. They are:

3/27 191 17 1 3/28 208 19 2 3/29 237 22 2 3/30 281 24 4 3/31 315 24 5

These daily reports consistently appear after 4pm ET so have the following day's date on the COVID Tracking Project spreadsheet. The negative count is not included in the daily report; it can be taken daily from the NM state coronavirus dashboard at 4pm ET. Spreadsheet data entry errors at this time: 3/29 positives should be 208 not 237, 3/31 hospitalized should be 24 not 22.

Also, a note for the dashboard: Reported hospitalized patients are current, not cumulative, and do not include persons who have died or recovered. Daily reports are links on https://cv.nmhealth.org/newsroom/

Finally, I see labels on some issues but I don't see a way to label this issue.