Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

16 rows where covidTrackingProjectPreferredTotalTestField = "posNeg"

View and edit SQL

Suggested facets: covidTrackingProjectPreferredTotalTestUnits, pui

Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField pui pum name fips
13 GU As of November 21, 2020, Guam’s Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.Guam's counts include 11 people tested at the San Diego naval base.As of December 7, 2020, Guam’s Total PCR tests (specimens), Total antigen tests (specimens), Total antibody tests (specimens) will include all specimens reported. Previously they did not include follow up testing for known cases.On November 21, 2020, we cleared Guam’s **Total PCR tests (People)** timeseries. Prior to November 21, we had believed that Guam’s negative counts represented people. However after outreach to Guam’s health department, we learned that the negatives represented specimens (while its positives represent cases). This change means Guam’s totalTestResults represent specimens excluding repeat positive results.On November 18, 2020, Guam [announced](https://ghs.guam.gov/jic-release-no-454-results-112-test-positive-covid-19-two-gdoe-employees-test-positive-covid-19) that “Beginning next week, the Department of Public Health and Social Services (DPHSS) will shift from daily situation reports to weekly reports in order to provide for more comprehensive data analysis. To reflect this, the Joint Information Center (JIC) will report profiles of confirmed cases on a weekly basis only.” As a result, Positive antigen tests (specimens) and Positive antibody tests (specimens) will only be updated once weekly going forward.On September 3, 2020, Guam reported that it had shifted to using the more restrictive August 5 definition of probable cases released by the CSTE. From March 12, 2020 to September 2, 2020 Guam reported eight probable cases under the previous probable case definition. Due to the change, Guam has no cases that classify as probable cases as of September 3, 2020, and 8 cases have been removed from Guam's total case count. http://dphss.guam.gov/covid-19/ https://drive.google.com/file/d/1FVW6sNbdgyV5-CYkOorYvOGivkmOED8t/view https://drive.google.com/file/d/1n-vrUGzEzs7rjcxXBFEbIMmeUQykuyO9/view     https://ghs.guam.gov/coronavirus-covid-19 Specimens posNeg posNeg All Data false Guam 66
15 IA On December 13, 2020, Iowa’s Total antigen tests (people) decreased by 77 and their Negative antigen tests (people) decreased by 206 without explanation.On October 16, 2020, Iowa removed 12,831 tests from the state’s PCR test total. On the same day, 19,308 tests were added to the state’s antigen test total. We were unable to locate an official explanation, but these changes were likely the result of data cleaning and reorganization work.On September 26, 2020, Iowa announced that due to a data update, roughly 27,000 antigen tests from long-term care facilities will be added to their COVID-19 antigen test data. This update will occur from September 26, 2020 to September 27, 2020, and will result in an increased number of antigen test tests reported in our data for Iowa. (Antigen data is available in our CSVs and API.)As of May 19, 2020, Iowa reports PCR and antibody tests separately. https://coronavirus.iowa.gov/ https://coronavirus.iowa.gov/pages/case-counts https://coronavirus.iowa.gov/pages/rmcc-data https://coronavirus.iowa.gov/pages/serology-testing   https://idph.iowa.gov/Emerging-Health-Issues/Novel-Coronavirus People posNeg posNeg All data false Iowa 19
17 IL Negative test results reported in our API and CSVs are calculated by subtracting **Total cases** from **Total PCR tests (specimens)** in the absence of better data. On January 22, 2021, Illinois began including all probable deaths reported since the beginning of the pandemic in the total case count. This means all 1,903 Probable deaths were included in the cases reported on January 22, 2021.On November 6, 2020, Illinois [announced](http://www.dph.illinois.gov/news/public-health-officials-announce-10376-new-confirmed-cases-coronavirus-disease) that they "will report confirmed cases and probable cases combined.” Due to this we cannot continue reporting **Confirmed** and **Probable cases** separately, however the time series for these metrics are available in the historical data, and our data downloads. As of October 15, 2020, Illinois combines PCR and antigen tests in the total tests figure reported on the state's dashboard.On September 4, 2020, Illinois reported over 140,000 new **Total PCR tests (in specimens)** and over 5,000 new **Cases.** According to the [Chicago Tribune](https://www.chicagotribune.com/coronavirus/ct-covid-19-pandemic-chicago-illinois-news-20200904-qun7unon5fhjbfhnsml4edwqia-story.html), "The Illinois Department of Public Health said Friday there was significant slowdown in the agency's test reporting earlier this week that it is just catching up with." http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus http://www.dph.illinois.gov/covid19/hospitalization-utilization       http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus Specimens posNeg posNeg All data false Illinois 17
19 KS Kansas combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Kansas reports most of its data on Mondays, Wednesdays, and Fridays only, so there are often large changes in the values, which can represent 2-3 days of data.The **Recovered** data point we report for Kansas reflects the number of COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized. Kansas notes that this metric only includes cases with available discharge information reported to the Kansas Department of Health and Environment.On December 25, 2020, Kansas announced on their [COVID-19 page](https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas) that there would be no update to their data on December 25, 2020 due to the holiday.On December 3, 2020, Kansas’ **Currently hospitalized** decreased by 342 without explanation. Kansas does not usually update their data on Thursdays.On November 13, 2020, Kansas announced that there was a "technical issue with displaying the number of negative tests and people tested" but that no other metrics were effected. The values for **Total tests (people)**, and the `Negative` field in the API, were carried over and will be updated if they become available.On November 12, 2020, Kansas’s **Total tests (people)** and `Negative` decreased without explanation.On October 21, 2020, the **Currently in Icu** value for KS dropped from 81 to 1 on the state's dashboard. We recorded it, but expect it to be revised at another point. On July 15, 2020, Kansas began reporting additional data from hospitals, and at that time, data for the **Now hospitalized** metric was only available through July 10.From July 1–July 3, 2020, we reported incorrect numbers for Kansas **Cases or Confirmed cases**. We have corrected the error.As of May 7, 2020, **confirmed and probable cases** are included in the case totals. https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas https://public.tableau.com/views/COVID-19TableauVersion2/HospitalCapacity?%3Aembed=y&%3AshowVizHome=no https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no https://public.tableau.com/views/COVID-19TableauVersion2/HospitalSummary?%3Aembed=y&%3AshowVizHome=no   http://www.kdheks.gov/coronavirus/ People posNeg posNeg All data false Kansas 20
21 LA Louisiana reports probable deaths on a weekly basis.Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total tests (PCR)** in the absence of better data.On February 16, 2021, Louisiana announced that there would be no update to their data due to Mardi Gras.On February 10, 2021, Louisiana [announced](https://twitter.com/LADeptHealth/status/1359562769205522436?s=20) that due to a processing error, the day's case and test counts are incomplete.On February 7, 2021, Louisiana [noted](https://twitter.com/LADeptHealth/status/1358475247410905091?s=20) on its Department of Health's twitter that "due to a technical issue, today’s reported case and test counts only include one day of data. Because of the daily removal of newly identified duplicates and out of state cases, the new case increase may not match the difference between today’s and yesterday's total case count." Subsequently, on February 8, 2021, Louisiana [noted](https://twitter.com/LADeptHealth/status/1358838000961134593?s=20) that case and test counts reported on February 8, 2021 included two days of data.On January 24, 2021, Louisiana [announced](https://twitter.com/ladepthealth/status/1353399882674016256?s=21) via the official Louisiana Department of Health twitter that the data reported on January 24, 2021 would only include lab reports from January 23, 2021. The remainder of the data that would normally have been reported on January 24, 2021 will be included in the data for January 25, 2021. On January 17, 2021, Louisiana announced that their deaths reflected deaths reported to the Louisiana Department of Health since January 14, 2021.On January 15, 2021, Louisiana announced on their [COVID-19 Dashboard](https://ldh.la.gov/coronavirus/) that deaths will not be updated due to a system error. As a result, we were unable to update Deaths (confirmed and probable), Deaths (confirmed), and Deaths (probable).On January 14, 2021, Louisiana announced that their data included a backlog of 916 cases dating back … http://ldh.la.gov/Coronavirus/         http://ldh.la.gov/Coronavirus/ Specimens posNeg posNeg Only positives false Louisiana 22
24 ME Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.On December 25, 2020, Maine announced on their [COVID-19 page](https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml) that some of their data would not be updated between December 25, 2020 and December 27, 2020 due to the holiday. As a result, we were unable to update Maine’s testing and current hospitalization data on December 25, 2020, and unable to update any data on December 26, 2020.On December 9, 2020, Maine’s **Total Antigen Tests (specimens)** decreased by 248 on their COVID-19 page, which we believe was an error. The sum of **Positive Antigen Tests,** **Negative Antigen Tests,** and indeterminate antigen tests is 38,632 and Maine reported 36,632. In order to ensure that our data is as accurate as possible, we did not update Maine’s Total Antigen Tests (specimens) on December 9, 2020. (Antigen data is available in our CSVs and API.)On November 30, 2020, Maine’s Total antigen tests (specimens) and Negative antigen tests (specimens) increased by roughly 11,000, and their Positive antigen tests (specimens) increased by about 400 without explanation. On November 26, 2020, Maine announced on their COVID-19 page that there would only be partial updates to their data from November 26, 2020 to November 29, 2020 due to the Thanksgiving holiday. As a result, we were unable to update testing data, and current hospitalization data on November 26, 2020, and unable to update all data points except for Currently hospitalized, Currently in ICU, and Currently on ventilator on November 27, 2020.On November 11, 2020, Maine did not update testing and hospitalization data: only **Cases,** **Deaths,** and **Recovered** were updated.On November 2, 2020, Maine started reporting antigen and molecular tests separately on the state's dashboard.On June 23, 2020, Maine began reporting the dates of **cases**, **deaths**, **recoveries**,… https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://analytics.maine.gov/t/CDCExternal/views/covid-19-maine-cdc-dashboard-nav-buttons/1_Casetrendsbycounty?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fanalytics.maine.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:showAppBanner=false&:display_spinner=no&:loadOrderID=1 https://analytics.maine.gov/t/CDCExternal/views/covid-19-maine-cdc-dashboard-nav-buttons/1_Casetrendsbycounty?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fanalytics.maine.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:showAppBanner=false&:display_spinner=no&:loadOrderID=1 https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus.shtml Specimens posNeg posNeg Only positives false Maine 23
28 MP The Northern Mariana Islands have not posted a new **Recovered** number since July 15, 2020. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.The Northern Mariana Islands **Total PCR tests (specimens)** values decrease occasionally without explanation. We suspect this is due to some sort of data quality assurance or de-deduplication.The Northern Mariana Islands provides irregular data updates, so changes in values often represent multiple days of data.On July 23, 2020, we switched our **Total tests** units to the people-tested metric reported by the Northern Mariana Islands, which led to a drop in total tests. We will backfill total tests data for the territory as soon as we are able to do so. https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5 https://services8.arcgis.com/zkkZCub5I6ydvXQj/ArcGIS/rest/services/Coronavirus_PublicDashboardView/FeatureServer/3/query?where=1%3D1&outStatistics=%5B%7B%27statisticType%27%3A+%27max%27%2C+%27onStatisticField%27%3A+%27reportdt%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27confirmedcases%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27totalspeccnmi%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27deaths%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27recovered%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27hospitalized%27%7D%5D https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5 https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5   https://www.chcc.gov.mp/coronavirusinformation.php People posNeg posNeg No Data false Northern Mariana Islands 69
29 MS Mississippi started updating testing totals on a weekly schedule on September, 27, 2020, so each update includes many days worth of testing. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.From May 21, 2020 through May 26, 2020, we briefly captured Mississippi's Positive antibody tests (specimens) through state press conferences. As of May 26, 2020, Mississippi no longer reports this metric. On February 11, 2021, we cleared Mississippi's Positive antibody tests (specimens) timeseries to ensure that our data is as accurate and consistent as possible.On October 25, 2020, Mississippi announced that COVID-19 data for October 24, 2020 and October 25, 2020 would be published on Monday. As a result, Mississippi did not update on October 24, 2020 and October 25, 2020.On September 15, 2020, Mississippi resumed reporting current hospitalizations, ICU, and ventilations on the source we have historically used for this metric. We are working to backfill these data points in our historical data.On September 11, 2020, we discovered a new source for Mississippi current hospitalizations and current ICU admissions on the Mississippi State Department of Health website.Between June 17 and June 22, 2020, Mississippi experienced technical difficulties with their reporting system. We filled in five days of **case** and **death** data on June 22, 2020.On May 26, 2020, news reports indicated that 95 antibody tests had returned positive in Mississippi, but we have not found more recent data since then for this metric.As of May 23, 2020, Mississippi is separating out PCR and antibody tests. We now report both separately. https://msdh.ms.gov/msdhsite/_static/14,0,420.html https://msdh.ms.gov/msdhsite/_static/14,21994,420,873.html       https://msdh.ms.gov/msdhsite/_static/14,0,420.html Specimens posNeg posNeg Only positives false Mississippi 28
31 NC The metric reported in our API as `totalTestsAntigen` only includes tests reported after September, 22, 2020. If previous values become available from North Carolina we will backfill the complete time series. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data. On February 28, 2021, North Carolina [noted](https://covidtracking.com/screenshots/NC/NC-20210228-115701.png) that its data dashboards would not update on that day in order to make changes to improve system performance.On February 3, 2021, the North Carolina Department of Health and Human Services [reported](https://twitter.com/ncdhhs/status/1357052211252068354) that the day's case counts were much larger than usual because of the inclusion of a backlog of nearly 8,000 cases identified at FastMed clinics during December 2020 and January 2021. On January 18, 2021, North Carolina announced on their [COVID-19 dashboard](https://covid19.ncdhhs.gov/dashboard) that there will be no daily update due to the holiday, and that their data will next be updated on Tuesday, January 19, 2021.On January 13, 2021, North Carolina reported that technical issues occurring on January 12, 2021 prevented processing of case and testing data into their COVID reporting system. As a result, case and testing data reported on January 13, 2021 are lower than they would have been had all the data been processed, and case and testing data on January 14, 2021 will be increased, since it will include the previous day's data.On December 30, 2020, North Carolina announced on its [dashboard](https://covid19.ncdhhs.gov/dashboard) that due to holiday-related disruptions and technical issues, data reported on December 30, 2020 was artificially higher than usual and includes 36 hours of data, while data reported on December 31, 2020 was artificially lower than usual and includes only 12 hours of data.On December 24, 2020, North Carolina announced on their COVID-19 dashboard that the… https://www.ncdhhs.gov/covid-19-case-count-nc https://files.nc.gov/covid/documents/dashboard/Weekly-COVID19-Patients-Presumed-to-be-Recovered.pdf https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_HospitalizationsE/Hospitalizations?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=no&:language=en&publish=yes&:loadOrderID=0 https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_Cases_County/NCDHHS_Dashboard_Cases2?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=yes&:language=en&publish=yes&:loadOrderID=0   https://www.ncdhhs.gov/divisions/public-health/coronavirus-disease-2019-covid-19-response-north-carolina Specimens posNeg posNeg Only positives false North Carolina 37
35 NJ The **Recovered** data point we report for New Jersey reflects the number of COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized.Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)**.New Jersey does not update their **Total PCR tests (specimens)** everyday. If **Total PCR tests (specimens)** is not updated, we are unable to update their **Negative PCR tests (specimens)**, which is calculated as **Total PCR tests (specimens)** minus **Confirmed cases**.On February 8, 2021, New Jersey [reported](https://twitter.com/GovMurphy/status/1358841345859870721) that today's data is artificially low due to electronic lab reporting issues. Data reported on February 9, 2021 is expected to correct the backlog.On January 15, 2021, New Jersey’s Probable cases decreased from 59,881 to 31,717 on their [data dashboard](https://covid19.nj.gov/#live-updates) without explanation. We believe this decrease may have been a mistake and sourced this data point from the [underlying data layer](https://services7.arcgis.com/Z0rixLlManVefxqY/arcgis/rest/services/DailyCaseCounts/Feat[…]27%2C+%27onStatisticField%27%3A+%27TOTAL_AG_CASES%27%7D%5D) (today's value is 60,791) in order to avoid the decrease.On January 8, 2021 New Jersey’s Probable cases increased from 53,967 to 72,123 without explanation. This affected their Cases (confirmed + probable), which is calculated as Confirmed cases plus Probable cases in the absence of an explicit total case number. On January 9, 2021, their Probable cases decreased from 72,123 to 56,147. Because of this, we believe that the figure reported on January 8, 2021 was a mistake, and have corrected the number in our timeseries. On October 23, New Jersey's reported **Ever hospitalized** value increased dramatically from 24,517 to 37,222 with no explanation we could find: this was probably a one… https://covid19.nj.gov/#live-updates https://www.arcgis.com/apps/MapSeries/index.html?appid=c2efd1898e48452e83d7218329e953d7 https://njhealth.maps.arcgis.com/apps/opsdashboard/index.html#/81a17865cb1a44db92eb8eb421703635 https://services7.arcgis.com/Z0rixLlManVefxqY/arcgis/rest/services/PPE_Capacity/FeatureServer/0/query?where=survey_period%3E%3Dtimestamp+%272020-04-27+07%3A00%3A00%27+AND+structure_measure_identifier+LIKE+%27%25ischarge%25Excluding+Deaths%25%27&outStatistics=%5B%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%2C+%27outStatisticFieldName%27%3A+%27recoveries%27%7D%5D   https://www.nj.gov/health/cd/topics/ncov.shtml Specimens posNeg posNeg All data false New Jersey 34
36 NM Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**. On January 15, 2021, New Mexico’s **Total PCR tests (specimens)** decreased by approximately 13,000 without explanation.On November 18, 2020, we shifted the entire time series of New Mexico metrics by one day to match the date that the state reports on its dashboard. https://cvprovider.nmhealth.org/public-dashboard.html         https://cv.nmhealth.org/ Specimens posNeg posNeg All data false New Mexico 35
40 OK On February 27, 2021, Oklahoma's Total PCR Tests dropped by 3,314 without explanation.On February 11, 2021, Oklahoma announced via a [press release](https://oklahoma.gov/covid19/newsroom/2021/february/situation-update--covid-19-02-11-2021.html) that due to delayed reporting by facilities, and time taken to investigate previously deferred cases, the “majority” of new deaths reported on February 11, 2021 occurred in November, 2020.On February 3, 2020, the Oklahoma Department of Health [cautioned](https://twitter.com/healthyoklahoma/status/1357016405586178050?s=21) that the 52 deaths reported on this date occurred between January 4, 2021 and February 1, 2021, with 32 of them having occurred since January 27, 2021.On January 10, 2021, Oklahoma [noted](https://oklahoma.gov/covid19/newsroom/2021/january/state-department-of-health-comments-on-spike-in-covid-19-case-nu.html) that the rise in COVID-19 cases was in part due to a “decrease in testing and a less consistent reporting schedule over the holidays”. We urge caution when interpreting their data from this time period, and encourage the use of 7 and 14-day averages as more reliable figures than individual numbers. On December 27, 2020, we cleared Oklahoma's **Confirmed cases** field from October 19 onward. On September 8, 2020, Oklahoma [announced](https://oklahoma.gov/covid19/newsroom/2020/september/situation-update-covid-19-09082020.html) in a press release that it would transition to counting both confirmed and probable cases, instead of just confirmed cases. This change appears to have taken effect on October 19, 2020, when OK [stopped calling](https://oklahoma.gov/covid19/newsroom/2020/october/situation-update-covid-19-10192020.html) its cases "confirmed positive cases" in press releases, as it had before, switching the wording to "cases." On December 22, 2020, Oklahoma noted via a [press release](https://oklahoma.gov/covid19/newsroom/2020/december/osdh-releases-covid-19-reporting-cadence-for-upcoming-holidays.html) that there would be no update to their data … https://oklahoma.gov/covid19.html https://coronavirus.health.ok.gov/sites/g/files/gmc786/f/eo_-_covid-19_report_-_2-28-21.pdf https://coronavirus.health.ok.gov/sites/g/files/gmc786/f/2020.2.28_weekly_epi_report.pdf     https://coronavirus.health.ok.gov Specimens posNeg posNeg All data false Oklahoma 40
43 PR Reported **Deaths** include both confirmed and probable COVID-19 deaths.Puerto Rico does not report test data on its data dashboard. Data for **Total PCR Tests (in specimens)** and **Positive PCR Tests (in specimens)** is taken from infrequent press reports. The most recent test data for Puerto Rico is taken from a [Departamento de Salud press release](https://github.com/COVID19Tracking/issues/files/5307568/Actualizacion.de.los.resultados.de.las.pruebas.moleculares.y.serologicas.para.Covid-19.registradas.en.Bioportal.del.Depto.de.Salud.pdf) from August 28, 2020. Puerto Rico’s **Recovered** numbers occasionally decrease without explanation. We suspect this is due to some sort of data quality assurance or de-deduplication.On November 7, 2020, Puerto Rico switched from using antibody tests to antigen tests to identify probable cases in accordance with August 2020 CSTE guidelines. This caused probable cases to drop by 33,888. We cleared the history of our **Probable Cases** field to match the new definition. We also modified our **Cases (confirmed + probable)** field to remove probables identified via antibody from April 24, 2020 onward, when we have access to a breakdown.On November 2, 2020, Puerto Rico removed 551 recoveries without explanation.On July 7, 2020, we updated **Negative PCR tests** based on press releases from May and June.On May 6, 2020, Puerto Rico stopped reporting **Negative PCR tests**.On April 22, 2020, Puerto Rico's data changed due to deduplication. This resulted in a decrease in **Total cases**. https://services5.arcgis.com/klquQoHA0q9zjblu/ArcGIS/rest/services/Datos_Totales_View7/FeatureServer/0/query?where=1%3D1&outFields=T_Muertes_COVID_RD%2CT_Fatalidades%2CT_Muertes_Combinadas%2CT_Pacientes_Int_Covid%2CT_Vent_Covid%2CT_Serologicos_Pos%2CT_Casos_Unicos%2CT_Molecular_Pos%2CT_Fatalidades%2CT_Hospitalizados%2CT_Recuperados https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/3bfb64c9a91944bc8c41edd8ff27e6df http://www.salud.gov.pr/Pages/coronavirus.aspx https://services5.arcgis.com/klquQoHA0q9zjblu/ArcGIS/rest/services/Datos_Totales_View7/FeatureServer/0/query?where=1%3D1&outFields=T_Muertes_COVID_RD%2CT_Muertes_Combinadas%2CT_Pacientes_Int_Covid%2CT_Vent_Covid%2CT_Serologicos_Pos%2CT_Casos_Unicos%2CT_Molecular_Pos%2CT_Fatalidades%2CT_Hospitalizados   http://www.salud.gov.pr/Pages/coronavirus.aspx Specimens posNeg posNeg No Data false Puerto Rico 72
45 SC Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.On February 23, 2021 through March 1, 2021, South Carolina’s Recovered metric was absent from their data dashboard, potentially due to [technical issues](https://twitter.com/scdhec/status/1364619613313634304). As a result, we were unable to update their Recovered.On February 23, 2021, South Carolina’s testing and recovery data was not available from their [dashboard](https://scdhec.gov/covid19/south-carolina-county-level-data-covid-19) due to [“technical issues”](https://twitter.com/scdhec/status/1364619613313634304) As a result, we were unable to update their testing data on February 23, 2021.On February 5, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1357822265258369027) via the official South Carolina Department of Health and Environmental Control twitter that roughly 29,000 positive and negative test results from December 22, 2020 through January 16, 2021 would be included in their data. This backlog will account for approximately 23,000 Negative PCR tests (specimens) and 3500 cases reported on February 5, 2021.On February 1, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1356322670170746888) via the official South Carolina Department of Health and Environmental control twitter that due to a vital statistics system update, they were reporting over 240 Deaths (confirmed + probable) from the last several weeks. As a result, not all new deaths reported on February 1, 2021 were identified in the previous 24 hour period.On January 28, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1354893317398556673) via the official South Carolina Department of Health and Environmental control twitter that due to a vital statistics system update, they were reporting over 230 Deaths (confirmed + probable) from the last several weeks. As a result, not all new deaths reported on January 28, 2021 were ident… https://scdhec.gov/health/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/monitoring-testing-covid-19 https://www.scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/sc-demographic-data-covid-19 https://www.scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/hospital-bed-capacity-covid-19 https://scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/south-carolina-county-level-data-covid-19 https://public.tableau.com/views/MainDashboard_15964746061440/Testing?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Fpublic.tableau.com%2F&%3Aembed_code_version=3&%3Atabs=no&%3Atoolbar=no&%3Aanimate_transition=no&%3Adisplay_static_image=no&%3Adisplay_spinner=no&%3Adisplay_overlay=no&%3Adisplay_count=yes&%3Alanguage=en&publish=yes&%3AloadOrderID=2 https://scdhec.gov/health/infectious-diseases/viruses/coronavirus-disease-2019-covid-19 Specimens posNeg posNeg All data false South Carolina 45
51 VI Total PCR tests in the Virgin Islands is the sum of **Positive PCR tests**, **Negative PCR tests**, and **Pending tests**.The Virgin Islands provides irregular data updates, so changes in values often represent multiple days of data. https://doh.vi.gov/covid19usvi         https://doh.vi.gov/ People posNeg posNeg Positives Only false US Virgin Islands 78
55 WV West Virginia reports new antibody tests daily. We sum these numbers in a running total to report a value for the total number of antibody tests West Virginia has conducted. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.On July 4, 2020, West Virginia began making continual changes to its previous data for antibody testing, so its historical time series might not match the time series we collected.On May 23, 2020, West Virginia began reporting PCR and antibody tests separately. Total test values before this date might include both PCR and antibody tests.On April 16, 2020, West Virginia began reporting current hospitalization, ICU, and ventilator metrics from 49 of 55 counties. Before April 16, 2020, those counts were less complete, as they were based on completed investigations rather than on hospital data. https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx   https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx Specimens posNeg posNeg All data false West Virginia 54

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [states_info] (
   [state] TEXT,
   [notes] TEXT,
   [covid19Site] TEXT,
   [covid19SiteSecondary] TEXT,
   [covid19SiteTertiary] TEXT,
   [covid19SiteQuaternary] TEXT,
   [covid19SiteQuinary] TEXT,
   [twitter] TEXT,
   [covid19SiteOld] TEXT,
   [covidTrackingProjectPreferredTotalTestUnits] TEXT,
   [covidTrackingProjectPreferredTotalTestField] TEXT,
   [totalTestResultsField] TEXT,
   [pui] TEXT,
   [pum] TEXT,
   [name] TEXT,
   [fips] INTEGER
);