states_info
Data source: Big Local News · About: big-local-datasette
21 rows where totalTestResultsField = "Total Tests (PCR)"
This data as json, copyable, CSV (advanced)
Suggested facets: pui
| Link | rowid ▼ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | pui | pum | name | fips | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | AK | Alaska combines PCR and antigen tests in the total tests figure reported on the state's dashboard.As of February 6, 2021, [Alaska no longer updates](https://twitter.com/alaska_dhss/status/1355349178335944708?s=21) their COVID-19 dashboards on weekends. As a result, we will be unable to update their data on Saturdays and Sundays. On February 12, 2021, Alaska [announced](https://twitter.com/Alaska_DHSS/status/1360413364065767424?s=20) via the official Alaska Department of Health and Social Services twitter that there would be no update to their data on February 15, 2021 due to the Presidents Day holiday.On January 20, 2021, Alaska [reported](https://www.adn.com/alaska-news/2021/01/20/tracking-covid-19-in-alaska-record-23-deaths-and-167-infections-reported-wednesday/) a comparatively large increase of 23 deaths due to a review of death certificates.On January 4, 2020, Alaska noted that "counted deaths in Alaska include COVID-19 cases confirmed through a lab result as well as probable deaths based on confirmed COVID-19 clinical and epidemiological criteria as defined by the CDC with no confirmatory lab testing." Due to this change we are unable to update the **Confirmed deaths** metric after January 4, 2020.On January 1, 2021, Alaska noted that there would be no update to their data on January 1, 2021.On December 25, 2020, Alaska announced on their dashboard that there would be no update to their data on December 25, 2020. On November 17, 2020, Alaska [announced](https://alaska-coronavirus-vaccine-outreach-alaska-dhss.hub.arcgis.com/datasets/cases-frequently-asked-questions) that “As of 11/17/2020, the cases dashboard will not be showing data on recovered and active cases due to the increasing State case load”. Due to this we cannot continue reporting **Recovered**, however the time series for this metric is available in the historical data, and our data downloads. On November 16, 2020 we updated the **Cases (confirmed plus probable)** field to include only residents. We also deleted the time series for **Confirmed c… | http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/monitoring.aspx | https://experience.arcgis.com/experience/ed1c874ca60b4c15ab09095a070065ca | https://alaska-dhss.maps.arcgis.com/apps/opsdashboard/index.html#/8782a14ef52342e99f866a3b8a3e624a | https://services1.arcgis.com/WzFsmainVTuD5KML/arcgis/rest/services/Tests_Dataset/FeatureServer/0/query?where=Test_Result+%3D+%27Negative%27&outStatistics=%5B%7B%27statisticType%27%3A+%27count%27%2C+%27onStatisticField%27%3A+%27FID%27%2C+%27outStatisticFieldName%27%3A+%27tests_negative%27%7D%5D | https://services1.arcgis.com/WzFsmainVTuD5KML/arcgis/rest/services/Tests_Dataset/FeatureServer/0/query?where=Test_Result+%3D+%27Positive%27&outStatistics=%5B%7B%27statisticType%27%3A+%27count%27%2C+%27onStatisticField%27%3A+%27FID%27%2C+%27outStatisticFieldName%27%3A+%27tests_positive%27%7D%5D | @Alaska_DHSS | http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/default.aspx | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Alaska | 2 |
| 3 | 3 | AR | Arkansas reports a category of “non-COVID deaths,” representing individuals who died with COVID positive but of causes unrelated to COVID. We do not count these individuals in our deaths metric, consistent with our policy of tracking only individuals with COVID as a cause of death where possible.On February 28, 2021, Arkansas’s total Deaths decreased by over 200. Arkansas [stated](https://twitter.com/ADHPIO/status/1366163333225799682) that this decrease was because of data clean-up and deduplication.During the week of September 20, 2020, Arkansas made some continual adjustments to its antigen people tested numbers, resulting in some fluctuation in its negatives and totals.As of September 18, 2020, Arkansas's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The totals do not include repeat positives—counting individuals only for their first positive—but do count repeat negative tests.On September 16, 2020, Arkansas’s **Negative Tests (PCR)** dropped by 26,801 tests, causing its **Total Tests (PCR)** to drop by 26,195 tests due to the reversal of a data dump of negative test results. It also added 140 **Probable deaths**, not all of which dated to September 16.On September 3, 2020, Arkansas began reporting **Probable cases** according to the most recent CSTE definitions, in addition to confirmed cases. This added 423 new cases to AR’s **Total cases** number.On Aug 15, 2020, Arkansas data changed due to deduplication and the state's removal of out-of-state cases from its dataset. These changes resulted in reductions in **Total cases**, **Ever hospitalized**, and **Ever in ICU** data. Between July 30, 2020 and September 17, 2020, Arkansas provided Total, Positive, and Negative Antigen tests (specimens) sporadically and then stopped reporting them. This data can be found in our API. | https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus | https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9 | https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd | https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd | https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd | @adhpio | https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Arkansas | 5 |
| 4 | 4 | AS | American Samoa does not have a regularly updated data source. We monitor their social media, emergency declarations, and local media for updates.As of September 18, 2020, American Samoa's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. | https://www.americansamoa.gov/covid-19-advisories | https://www.facebook.com/amsamgov/ | http://www.samoagovt.ws/2020/03/ministry-of-health-coronavirus-covid-19-update-14-march-2020/ | Specimens | totalTestsViral | Total Tests (PCR) | No Data | false | American Samoa | 60 | ||||
| 5 | 5 | AZ | Arizona combines PCR and antigen tests in the total tests figure reported on the state’s dashboardArizona regularly reviews and removes duplicate records which may occasionally result in minor decreases of cumulative figures. The **Recovered** data point we report for Arizona 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 (people)** in the absence of better data.On March 1, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1366405875754291212?s=20) via the official Arizona Department of Health Twitter that due to death certificate matching, Confirmed deaths increased by 1, and Probable deaths decreased by 2. As a result, Deaths (confirmed + probable) decreased by 1.On February 22, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1363869914356994054?s=20) via the Department of Health's official Twitter that no new deaths were reported. Additionally, there was a decrease of 3 deaths (confirmed and probable) due to death certificate matching.On January 18, 2021 Arizona [announced](https://twitter.com/AZDHS/status/1351183189100867586) via the official Arizona Department of Health twitter that their reported Deaths (confirmed and probable) decreased by one due to de-duplication of the data.On January 9, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1347930259170021376?s=20) that the number of COVID-19 patients in ICU was incomplete on their COVID-19 dashboard, and we sourced Currently in ICU from the official Arizona Department of Health twitter.On December 28, 2020, Arizona [noted](https://twitter.com/AZDHS/status/1343575976026886144) that due to the holiday weekend, multiple days of case reviews were completed, resulting in the data for December 28, 2020 being higher than usual. As a result, they … | https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php | https://tableau.azdhs.gov/views/Hospitalization/HospitalizedCOVID-19Cases?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Ftableau.azdhs.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:showAppBanner=false&:display_spinner=no&iframeSizedToWindow=true&:loadOrderID=3 | https://tableau.azdhs.gov/views/ExternalEMResourceCOVIDSpecificDashboard/InpatientCOVID-19?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Ftableau.azdhs.gov%2F&:embed_code_version=3&:tabs=yes&:toolbar=no&:showAppBanner=false&:display_spinner=no&iframeSizedToWindow=true&:loadOrderID=4 | https://tableau.azdhs.gov/views/ExternalEMResourceCOVIDSpecificDashboard/VentilatorsinUseCOVID-19?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Ftableau.azdhs.gov%2F&%3Aembed_code_version=3&%3Atabs=yes&%3Atoolbar=no&%3AshowAppBanner=false&%3Adisplay_spinner=no&iframeSizedToWindow=true&%3AloadOrderID=1 | https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php | @azdhs | https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Arizona | 4 |
| 6 | 6 | CA | On February 25, 2021, California announced that their deaths included a backlog of 806 deaths initially not reported as COVID-19 deaths from Los Angeles County. As a result, many of the deaths reported on February 25, 2021 occurred between December 3, 2020 and February 3, 2021. We urge caution when interpreting numbers from this period, and encourage the use of 7 and 14-day averages as more reliable metrics than individual figures.On December 16, 2020, California [announced](https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-338.aspx) that their cases for December 16, 2020 include 15,337 cases from previous days due to a change in case processing. It appears this new process will regularly include a higher volume of cases that were not identified within the previous 24 hours.As of September 18, 2020, California's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.From July 23 through July 28, 2020, California reported that its **Now hospitalized** and **Now in ICU** were incomplete due to its transition to the HHS reporting system. We carried over hospitalization figures until July 28. We will backfill the complete numbers for this period if the complete data becomes available.From June 29 to July 5, 2020, California made revisions to daily **case** numbers. On July 17, we updated the values based on the most recent data from the state dashboard.On July 8, 2020, California data included a backlog from Los Angeles County, which had not reported for several days. Approximately 1,000 of the 11,000 new cases were attributed to this backlog data.As of April 22, 2020, California has reported specimens tested instead of people tested. Because some people may be tested more than once, this number is probably higher than the number of people tested.On April 4 and April 22, 2020, California reported large batches of backlogged **negative test** data. Prior to April 1, 2020, we used county data sources for more reliably timely reporting of California's COVID-19 data. At th… | https://update.covid19.ca.gov | https://public.tableau.com/views/COVID-19CasesDashboard_15931020425010/Cases?:embed=y&:showVizHome=no | https://public.tableau.com/views/COVID-19HospitalsDashboard/Hospitals?:embed=y&:showVizHome=no | @CAPublicHealth | https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | California | 6 | ||
| 8 | 8 | CT | 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.The **Recovered** data point we report for Connecticut 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. Connecticut stopped reporting hospital discharges on October 22, 2020, but the time series for the metric is available in the historical data, and our data downloads. As of February 23, 2021, Connecticut's `totalTestResults` field is taken directly from `totalTestsViral` instead of calculated from positive + negative. We also cleared the history of Negative (people or cases) since it was calculated using mixed units.On February 3, 2021, we updated the **Total Antigen Tests** and backfilled **Positive Antigen Tests** and **Negative Antigen Tests** from Connecticut's testing dataset provided by the state. Going forward, we'll be updating all these 3 metrics on weekdays. On February 23, we backfilled **Total PCR Tests (specimens)** from the same source so that it would only include PCR tests. This resulted in a drop at the topline of 345,693 tests, distributed over the timeseries.On December 25, 2020, Connecticut announced on their [COVID-19 page](https://portal.ct.gov/Coronavirus/COVID-19-Data-Tracker) that there would be no update to their data on December 25, 2020 through December 27, 2020 or on January 1, 2021 due to the holidays.On November 26, 2020, Connecticut announced via a [press release](https://portal.ct.gov/Office-of-the-Governor/News/Press-Releases/2020/11-2020/Governor-Lamont-Coronavirus-Update-November-25) that there would be no update to their data on November 26, 2020 due to the Thanksgiving holiday. Additionally, the data for November 26, 2020 and November 27, 2020 will both be included in the November 27, 2020 update.On November 5, 2020, Connecticut announced that … | https://data.ct.gov/coronavirus | https://data.ct.gov/stories/s/q5as-kyim | https://data.ct.gov/api/id/rf3k-f8fg.json?%24query=select+%2A+order+by+date+desc+limit+1 | @ctdph | https://portal.ct.gov/Coronavirus | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Connecticut | 9 | ||
| 12 | 12 | GA | On February 3, 2021, we moved Georgia’s history of Positive Antigen Tests (people) to Probable Cases, since the state calls the metric “antigen positive cases.” We also backfilled Positive (people, confirmed + probable) to include these values. This change resulted in the addition of 162,028 cases in Georgia distributed over the timeseries from November 3, 2020 onward. Georgia does not provide a full history of this number, so on November 3, 2020 we record 29,937 probable cases for Georgia, many of which do not date to that day.On January 6, 2021, Georgia stated on its dashboard that its data would be delayed several hours “due to a high volume of data to process.” Georgia’s data did not update before for our publication time. We were able to update their Currently hospitalized from their separate [hospitalization source](https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6).On November 13, 2020, we backfilled the **Total PCR tests (specimens)** time series to include only PCR testing, reported by the state in their data download file. This updates the previously reported series that until May 27, 2020 included both PCR and antibody tests.On November 3, 2020, Georgia started reporting probable deaths and antigen positive cases in their COVID-19 Daily Status report. On November 4, we added the probable deaths in our **Deaths (probable)** field for November 3 and 4, causing the daily rise in deaths on the 3rd to appear as 480. This large increase includes the data dump of 450 probable deaths, many of which are not from the most recent 24 hour period. We also began recording the 29,937 antigen positive cases in our `positiveTestsPeopleAntigen` API field. We have reached out to Georgia's health department for clarity on the definition of this number. On October 21, 2020, Georgia did not update their "COVID-19 Daily Status Report" by the time of our daily update due to technical issues. In order to provide the most up to date data possible, we updated only **Current Hospitalizations**,… | https://dph.georgia.gov/covid-19-daily-status-report | https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6 | https://augustagis.maps.arcgis.com/apps/opsdashboard/index.html#/4eec20925b6b4f338368df0ffcba472d | @GaDPH | https://dph.georgia.gov/novelcoronavirus | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Georgia | 13 | ||
| 18 | 18 | IN | Indiana combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Negative test results reported in our API and CSVs are calculated by subtracting **Total cases** from **Total PCR tests (people)** in the absence of better data.On February 26, 2021, Indiana announced that due to a historic load of negative tests, 663 older Total PCR tests (people) and 2150 Total PCR tests (specimens) would be included in their data for the day.On February 4, 2021, Indiana announced that their deaths included “1,507 historical deaths identified through an audit of 2020 and 2021 COVID death records and test results”. As a result, the majority of new Deaths (confirmed + probable) and Deaths (confirmed) reported on February 4, 2021 were not reported in the previous 24 hours. We urge caution when looking at this figure.On January 5, 2021, Indiana’s Currently in ICU decreased by 9 without explanation.On November 29, 2020, Indiana announced that a historical backlog of roughly 2200 Total PCR tests (people) and about 4000 Total PCR tests (specimens) would be included in their data for November 29, 2020. The `Negative` field in the API will also be affected. As a result, new tests reported on November 29, 2020 were not all reported in the previous 24 hour period.As of October 16, 2020, Indiana’s total test results are drawn from our totalTestsViral field instead of calculated via positive+negative. | https://www.in.gov/isdh/28470.htm | https://www.regenstrief.org/covid-dashboard/ | https://hub.mph.in.gov/dataset/covid-19-beds-and-vents/resource/882a7426-886f-48cc-bbe0-a8d14e3012e4/view/05961851-c7ab-4ac7-92bf-fdf9881ecdab | https://hub.mph.in.gov/api/3/action/datastore_search_sql?sql=SELECT+sum%28%22COVID_POSITIVE_TESTS_ADMIN%22%29+as+pos_tests+from+%22afaa225d-ac4e-4e80-9190-f6800c366b58%22 | @statehealthin | https://www.in.gov/isdh/28470.htm | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Indiana | 18 | |
| 20 | 20 | KY | On December 24, 2020, December 25, 2020, December 31, 2020 and January 1, 2021, Kentucky did not update their data by the time of our daily update, presumably due to the holidays.On November 26, 2020, Kentucky did not update their data by the time of our daily update, presumably due to the Thanksgiving holiday.On November 12, 2020, Kentucky began reporting **Currently on ventilator** in their [COVID-19 Daily Summaries](https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/KY/KY-tertiary-20201112-172508.pdf).On November 7, 2020, Kentucky [reported](https://chfs.ky.gov/cvdaily/COVID19DailyReport1107.pdf) that "due to a keystroke error, the PCR and total tested figures were incorrectly reported on 11/6/2020." This caused our **Total PCR tests (specimens)** to go up by ~168k on November 6, and to go down by ~130k on November 7. If we find an official source with a corrected value we will backfill it.As of September 18, 2020, Kentucky's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.As of May 27, 2020, Kentucky reports antibody tests separately from PCR tests. On May 23, 2020, Kentucky revised down the state's figure for **Total tests**. | https://govstatus.egov.com/kycovid19 | https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf | @CHFSKy | https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Kentucky | 21 | |||
| 22 | 22 | MA | Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On December 25, 2020, Massachusetts announced on their [COVID-19 page](https://www.mass.gov/info-details/covid-19-response-reporting) that there would be no update to their data on December 25, 2020, or on January 1, 2021. Additionally, they noted that data reported on December 26, 2020 and January 2, 2021 would each include two days of data.On November 26, 2020, Massachusetts announced on their COVID-19 page that there would be no update to their data on November 26, 2020 due to the the Thanksgiving holiday. Additionally, they announced that the data for November 27, 2020 would include both the data for November 26, 2020 and November 27, 2020.On November 25, 2020, Massachusetts reported that their data “was delayed today due to a technological issue that resulted in an interruption of the data download. As a result, today’s numbers reflect case counts from up to a 30 hour period" instead of the usual previous 24-hour period.As of November 2, 2020, Massachusetts’ **Currently Hospitalized**, **Currently in ICU**, and **Currently on Ventilator** figures include only confirmed cases. Previously these numbers included confirmed and probable hospitalizations.As of September 11, 2020, Massachusetts’ total test results reflect total specimens. The number of unique people tested is available in our API as `totalTestsPeopleViral`.On September 2, 2020, MA [reported](https://www.mass.gov/doc/covid-19-dashboard-september-2-2020/download) that it had shifted to using the more restrictive August 6 definition of probable cases released by the CSTE. This change caused a significant decrease in several data points where probable cases or probable deaths were included, particularly the overall case count, which dropped by more than 7,000. Historical data was also affected. On August 31, 2020 we updated Massachusetts' **Total PCR Tests (specimens)** before August 12, 2020 based on the state's "Tests… | https://www.mass.gov/doc/covid-19-dashboard-march-1-2021/download | https://www.mass.gov/doc/weekly-covid-19-public-health-report-march-1-2021/download | @massdph | https://www.mass.gov/resource/information-on-the-outbreak-of-coronavirus-disease-2019-covid-19 | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Massachusetts | 25 | |||
| 23 | 23 | MD | As of October 16, 2020, Maryland’s total test results are drawn from our totalTestsViral field instead of calculated via positive+negative. This will result in TotalTestResults only going back to 3/24 instead of 3/5.On August 31, 2020, we updated Maryland's **Total PCR tests (specimens)** and **Positive PCR tests (specimens)** prior to 8/16 to match state-provided "Testing Volume" data.On July 31, 2020, we began capturing Maryland's data for **Positive PCR tests (specimens)**. Between March 12 and March 28, 2020, Maryland did not report data for **negative tests**. | https://coronavirus.maryland.gov/ | https://services.arcgis.com/njFNhDsUCentVYJW/arcgis/rest/services/MDCOVID19_TestingVolume/FeatureServer/0/query?where=1%3D1&outFields=*&outStatistics=[%7B%22statisticType%22%3A+%22sum%22%2C+%22onStatisticField%22%3A+%22number_of_positives%22%2C+%22outStatisticFieldName%22%3A+%22total_number_of_positives%22%7D] | https://services.arcgis.com/njFNhDsUCentVYJW/arcgis/rest/services/MDCOVID19_SerologyTests/FeatureServer/0/query?where=1%3D1&outFields=%2A | @MDHealthDept | https://phpa.health.maryland.gov/Pages/Novel-coronavirus.aspx | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Maryland | 24 | ||
| 27 | 27 | MO | Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On November 21, 2020, Missouri’s **Total PCR Tests (People)** increased by less than **Confirmed cases**. As a result, **Negative (People or Cases)** saw a decline from the previous day since it is calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On November 10, 2020, Missouri’s Total PCR tests (specimens), Negative PCR tests (specimens), Total PCR tests (people), Total antibody tests (specimens), Total antibody tests (people), Negative antibody tests (specimens), Total antigen tests (specimens), and Negative antigen tests (specimens) dropped without explanation.On November 8, 2020, Missouri's **Total PCR Tests (specimens)** decreased from 2,672,288 to 2,654,691 with no explanation.On October 14, 2020, Missouri testing numbers by people decreased. This resulted in a decrease in all total testing numbers (people) and negative cases. Testing numbers by specimen are unaffected.On October 11, 2020, [Missouri announced that a database error had resulted in an “incorrect inflation” of cases in its October 10, 2020 report](https://www.kshb.com/news/coronavirus/missouri-covid-19-database-error-causes-incorrect-inflation-of-cases). When The COVID Tracking Project is able to obtain correct official data for October 10 from Missouri, we will update our dataset to reflect the correction.On October 8, 2020, Missouri added current hospitalizations to their COVID-19 dashboard, and we began to capture this metric. Historical data is also available and we are working on backfilling our data for days where this metric was unavailable.As of October 7, 2020, Missouri's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`. On September 28, 2020, Missouri removed the Positive and Negative antibody tests (people) metrics from their das… | https://showmestrong.mo.gov/data/statewide-public-health/ | https://showmestrong.mo.gov/public-healthcare-testing/ | https://showmestrong.mo.gov/public-healthcare/ | @HealthyLivingMo | https://health.mo.gov/living/healthcondiseases/communicable/novel-coronavirus/ | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Missouri | 29 | ||
| 33 | 33 | NE | Nebraska combines PCR and antigen tests in the total tests figure reported on the state's dashboard, and thus antigen tests are included in our "Total Tests (PCR)" metric. Nebraska's cumulative data values often decrease without explanation, likely due to deduplication or other data corrections.Nebraska’s **Recovered** numbers occasionally decrease without explanation.On January 20, 2021, Nebraska reported that its dashboard would be down until “later in the week” due to system maintenance. The Nebraska Department of Health reported **Deaths** and **Now hospitalized** values manually.On January 13, 2021, Nebraska’s Recovered decreased by 1864 without explanation.On January 9, 2021, Nebraska’s Deaths (confirmed + probable) decreased by 78 without explanation.On January 3, 2021, Nebraska’s **Recovered** value decreased by nearly 4,000 without explanation.On December 26, 2020, Nebraska’s **Ever hospitalized** decreased by 3, their Recovered decreased by 4265, and their Deaths (confirmed + probable) decreased by 10 without explanation.On November 13, 2020, Nebraska's cumulative hospitalized count dropped by 21 without explanation.On November 6, 2020, Nebraska removed 114 recoveries without explanation.On October 30, 2020, we backfilled the full time series for Nebraska's Total Tests into our "Total Tests (PCR)" metric from a Nebraska GIS query. At the same time, we filled our Positive Tests (PCR) and Negative Tests (PCR) from the same query.On September 20, 2020, Nebraska started publishing **Total Tests (in specimens)** in addition to **People Tested (in people)**, and we started collecting the Total Tests daily into our Total Tests (PCR) metric.On November 22, 2020, Nebraska's **Recovered** metric dropped from 56,605 to 16,068 without explanation. | https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd | https://gis.ne.gov/enterprise/rest/services/Covid19MapV5/MapServer/11/query?where=1%3D1&outFields=%2A&orderByFields=LAB_REPORT_DATE+desc&resultRecordCount=1&f=json | https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd | https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd | https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd | @NEDHHS | http://dhhs.ne.gov/Pages/Coronavirus.aspx | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Nebraska | 31 |
| 34 | 34 | NH | Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On March 1, 2021, New Hampshire's **Total PCR Tests (people)** decreased by 563 without explanation. This in turn affected **Negative PCR tests (people)**, which is calculated as **Total PCR Tests (people)** minus **Confirmed cases**.On February 8, 2021, New Hampshire's **Total antigen tests (specimens)** decreased by 102 without explanation.On January 10, 2021, New Hampshire’s **Total antigen tests (specimens)** increased by 41167 without explanation.On January 1, 2021, New Hampshire did not update their COVID-19 data by the time of our daily update.On December 26, 2020, we began capturing New Hampshire's "Antigen Positive" cases as **Probable cases** instead of **Positive antigen tests (people)** and revised its historical numbers so that **Confirmed cases** reflected only PCR positives. We also modified *Negative (people or cases)* to subtract these confirmed cases. Because negatives are calculated from lumped figures including antigen before November 20, negatives are artificially high on that day.On December 25, 2020, New Hampshire did not update their data, presumably due to the Christmas holiday.On November 13, 2020, New Hampshire announced: "The Dashboard Service is currently undergoing system maintenance and will be restored by November 16, 4:00 PM EST." This means **Total tests (in specimens)**, **Ever hospitalized**, **Ever in ICU**, and **Total Antibody Tests** will not be updated during this time.As of September 18, 2020, New Hampshire's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`.On September 9, 2020, New Hampshire did not update their dashboards or summary report by the time of our update. On September 2, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.As of May 25, 2020,… | https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm | https://www.nh.gov/covid19/documents/case-summary.pdf | https://www.nh.gov/covid19/dashboard/overview.htm#dash | https://nh.gov/t/DHHS/views/COVID19TrendsDashboard/TrendsDashboard?:isGuestRedirectFromVizportal=y&:embed=y | @NHPubHealth | https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | New Hampshire | 33 | |
| 39 | 39 | OH | Since February 10, 2021, Ohio has been reconciling their death data. As a result, death figures may fluctuate more than normal, and may include deaths which were not reported in the previous 24 hours. We urge caution when interpreting data from this period and encourage the use of 7 and 14-day averages as more reliable metrics. Our data quality team will continue to investigate how best to handle changes to their data.Ohio continually updates its **Currently hospitalized / Now hospitalized** data which can cause slight differences between their historic data and ours. On February 10, 2021, Ohio [announced](https://odh.ohio.gov/wps/portal/gov/odh/media-center/odh-news-releases/odh-news-release-02-10-20) that up to 4,000 COVID-19 deaths were underreported in the state’s reporting system and on their COVID-29 dashboard. These deaths will be added to their counts over the week on February 11, 2021. As a result, new deaths will be substantially higher than normal throughout this period. We urge caution when interpreting data from this period. Our data quality team will continue to investigate how best to handle the addition of these death. Approximately 650 of the deaths reported on February 11, 2021, 2500 of the deaths reported on February 12, 2021, and 1125 of the deaths reported on February 13, 2021 are a result of this reconciliation. On February 15, 2021, Ohio noted that they were continuing to reconcile deaths through a deep review of data which may result in fluctuations in death data.On January 6, 2021, we switched Ohio's `totalTestResults` to draw from `totalTestsViral` instead of by calculating from positive+negative. On December 29, 2020, Ohio provided a timeseries of Total Tests (PCR), Positive Tests (PCR), Total Antigen Tests, and Positive Antigen Tests. On January 6, 2021, we backfilled all 4 metrics from this download, which resulted in the addition of three new metrics (positive tests PCR, positive tests antigen, total tests antigen) and a full history for Total Tests (PCR).On December 25, 2020, Ohio a… | https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/overview/ | https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/key-metrics/cases | https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/key-metrics/hospitalizations | @OHdeptofhealth | https://odh.ohio.gov/wps/portal/gov/odh/know-our-programs/Novel-Coronavirus/welcome/ | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Ohio | 39 | ||
| 41 | 41 | OR | As of January 13, 2021, Oregon’s data is on a 1 day lag in our timeseries due to consistently updating after 7:30 pm Eastern Time, when we publish our daily update.On February 8, 2021, we cleared the history of our confirmed and probable cases fields in Oregon. Before Oregon switched to reporting tests in units of specimens, we had used its figures for people testing positive to represent confirmed cases and subtracted that number from total cases to get probable cases. However, it turned out that Oregon's people tested figure included people testing positive with antigen, so the positive people tested figure did not accurately reflect confirmed cases.On January 29, 2021, Oregon [announced](https://twitter.com/ohaoregon/status/1355286471687745537?s=21) that their COVID-19 case database would be down “for server and file migration maintenance” on January 30, 2021, and as a result there would be no update to their data on January 31, 2021. Because Oregon’s data is on a one day lag in our timeseries due to late updates, we were unable to update their data on February 1, 2021.As of December 9, 2020, Oregon’s total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. This change will cause Oregon’s `totalTestResults` to begin on March 29, 2020 instead of March 4, 2020. Because Oregon’s totalTestsViral represent only electronic laboratory reporting, whereas its cases and negatives represented tests from all sources, this change causes a decrease of 10,296 tests in `totalTestResults` on March 29. The old numbers remain available by summing the positive and negative fields of our API.In addition, Oregon has not reported their total tests in people units since December 2, 2020 and they indicated that they will not continue to report total tests in people, so we have removed any values in **Total PCR tests (people)** we previously carried over.On December 3, 2020, Oregon removed its total people tested metric, after adding total specimens on December 1. Because they did not p… | https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx | https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/CaseandTesting | https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19TestingandOutcomesbyCounty/OregonsCOVID-19TestingandOutcomesbyCounty?:display_count=y&:toolbar=n&:origin=viz_share_link&:showShareOptions=false | https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/HospitalCapacity | @OHAOregon | https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx | Specimens | totalTestsViral | Total Tests (PCR) | All data | false | Oregon | 41 | |
| 47 | 47 | TN | 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.Tennessee continually updates its **Currently hospitalized / Now hospitalized** data which can cause differences between their historic data and ours. As of March 1, 2021, Tennessee's `totalTestResults` field is taken directly from `totalTestsViral` instead of calculated from positive + negative. We backfilled the data for March 24, 2020 through March 1, 2021 using the time-series posted in Tennessee's [Downloadable Datasets](https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html). We also cleared the history of Negative (people or cases) since it was calculated using mixed units.On January 1, 2021, the Tennessee Department of Health [announced](https://twitter.com/TNDeptofHealth/status/1345117770543996940?s=20) that its update for January 2, 2021 would include data from both January 1 and January 2, presumably because of the holiday. We were able to update **Now hospitalized** from Tennessee’s separate [hospitalization source](https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html).On December 25, 2020, Tennessee did not provide a data update, likely due to the holiday. We were able to update **Now hospitalized** from Tennessee’s separate [hospitalization source](https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html). Additionally, they [noted](https://twitter.com/TNDeptofHealth/status/1342952651022086147) that the data reported on December 26, 2020, included two days of data, and that the number of deaths reported were “limited” due to the holiday.On December 19, 2020, Tennessee announced that due to the volume of tests being processed they will likely release a combined report with data from both December 19, 2020 and December 20, 2020 on December 20, 2020. As a result, we were unable to update their data on December 20, 2020.On December 12, 20… | https://www.tn.gov/health/cedep/ncov.html | https://apps.health.tn.gov/AEM_embed/TDH-2019-Novel-Coronavirus-Epi-and-Surveillance.pdf#toolbar=0 | https://data.tn.gov/t/Public/views/HospitalizedPatients/HospitalizedPatients?:embed=y | @TNDeptofHealth | https://www.tn.gov/health/cedep/ncov.html | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Tennessee | 47 | ||
| 48 | 48 | TX | The Texas Department of State Health Services regularly includes older cases identified by labs in their cumulative confirmed case counts. As a result, new cases reported may not necessarily have occurred in the past 24 hour period. When these increases are significant, we will specifically mention them in our daily update on Twitter.On February 21, 2021, Texas’s Positive PCR tests (specimens) decreased by over 10,000 without explanation. Throughout the week, Texas has experienced multiple weather-related issues which have impacted their data reporting. We urge caution when interpreting data from this period.On February 20, 2021, Texas’s Total PCR tests (specimens) decreased by roughly 85,000 without explanation. Throughout the week, Texas has experienced multiple weather-related issues which have impacted their data reporting. We urge caution when interpreting data from this period.During the week of February 17, 2021, Texas experienced several weather-related issues and power outages which affected their data reporting. They [noted](https://twitter.com/TexasDSHS/status/1362111931578945538?s=20) via the official Texas Department of State Health Services Twitter that new cases will be “artificially low” until the reporting resumes normally. On February 15, 2021 through February 18, 2021, they could not update their testing data due to outages. As a result, we were unable to update their testing data on these dates. We urge caution when interpreting data from this period.On December 29, 2020, Texas noted that “New cases reported today (12/29) may include several days of cases for some counties as some local health departments did not report over the holiday weekend.As of December 15, 2020, Texas’s total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. On December 14 2020, we backfilled the full time series of **Total PCR tests (specimens)**, **Positive PCR tests (specimens)** from data available on [Texas ArcGis Layer](https://services5.arcgis.com/ACaLB9ifngzawsp… | https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/ed483ecd702b4298ab01e8b9cafc8b83 | https://services5.arcgis.com/ACaLB9ifngzawspq/ArcGIS/rest/services/TX_DSHS_COVID19_Test[…]&outFields=%2A&orderByFields=Date+desc&resultRecordCount=1 | https://www.dshs.texas.gov/coronavirus/TexasCOVID-19HospitalizationsOverTimebyTSA.xlsx | https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/0d8bdf9be927459d9cb11b9eaef6101f | @TexasDSHS | https://dshs.texas.gov/coronavirus/ | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Texas | 48 | |
| 49 | 49 | UT | On February 12, 2021, we cleared the history of Utah's **Confirmed cases** field, which we previously filled using data from its positive people tested via PCR number. Utah does not present this figure as confirmed cases and instead calls its main case number, which includes both PCR and antigen tests, "lab-confirmed cases." We did not duplicate Utah's main case number into Confirmed cases to replace this positive PCR individuals number because the definition the state uses for "confirmed" is not in accordance with CSTE definitions.On December 25, 2020, Utah did not update their data by the time of our daily update, presumably due to the Christmas holiday.On November 25, 2020, Utah [announced](https://twitter.com/UtahCoronavirus/status/1331703634942451715) via their official Utah COVID-19 response twitter that there would be no update to their data on November 26, 2020. Additionally, the data that would normally have been published on November 26, 2020 will be included in the November 27, 2020 update.As of November 9, 2020, our **Confirmed cases** metric for Utah is sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests. This caused a slight decrease in the number of **Confirmed Cases**.As of November 6, 2020, our **Total PCR tests (people)** and **Negative PCR tests (people)** metrics for Utah are sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests.As of October 28, 2020, our **Total PCR tests (specimens)** and **Positive PCR tests (specimens)** metrics for Utah are sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests. **Total PCR tests (specimens)** is calculated by adding positive and negative PCR tests from this [download](https://coronavirus-dashboard.utah.gov/Utah_COVID19_data.zip).As of October 29, 2020, Utah's `totalTestResults` field … | https://coronavirus-dashboard.utah.gov/ | https://coronavirus-dashboard.utah.gov/#hospitalizations-mortality | @utahdepofhealth | https://health.utah.gov/coronavirus | Specimens | totalTestsViral | Total Tests (PCR) | Only positives | false | Utah | 49 | |||
| 52 | 52 | VT | Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**. On February 13, 2021 Vermont's reported **Total Tests (PCR)** declined from 961,542 to 958,666 without explanation.On February 02, 2021, Vermont reported a decrease in Total PCR Tests (specimens) of around 23K without explanation.On January 4, 2020, Vermont posted that "the numbers of COVID-19 deaths now includes deaths among probable cases since September 6, 2020." Due to this change we are unable to update the **Confirmed deaths** metric after January 4, 2020.On December 23, 2020, Vermont announced on their [COVID-19 page](https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus)that there would be no update to their data on December 24, 2020 or December 25, 2020. On January 1, 2020, they noted that there would be no update to their data on January 1, 2020. On December 23, 2020, Vermont reported more new **Confirmed cases** than new **Total PCR Tests (people)**, which caused a decrease in the value of **Negative PCR tests (people)** in our API.On December 4, 2020, Vermont provided a timeseries for both confirmed and probable cases. We backfilled **Total cases**, **Confirmed cases** and **Probable cases** and updated **Total Tests (in People)** and **Negative** to match the new confirmed series.On December 2, 2020, Vermont added approximately 120 cases to its case count, representing **Probable cases** since the beginning of September in the state (previously, the state had only reported PCR-confirmed cases). It provided a timeseries, and we backfilled our **Total cases** field to avoid the impression of an additional 120 case rise on December 2.On November 26, 2020, Vermont announced on their [COVID-19 page](https://www.healthvermont.gov/covid-19) that there would be no update to their data on November 26, 2020.On November 3, 2020, Vermont’s **Total PCR tests (people)** decreased without explanation. As a result, Vermont’s negative test results, which ar… | https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170 | https://www.healthvermont.gov/response/coronavirus-covid-19/current-activity-vermont#dashboard | @healthvermont | https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus | Specimens | totalTestsViral | Total Tests (PCR) | Positives + Negatives | false | Vermont | 50 | |||
| 56 | 56 | WY | As of February 13, 2021, Wyoming does not update their COVID-19 data on Saturdays.Wyoming’s metrics do not update every day, and don’t always update together. As a result, please exercise extra caution when using numbers that are calculated from daily changes, especially if these calculations use multiple metrics. If anomalies are observed, numbers from previous days will be carried over until corrections are made.Wyoming reports the number of people *Ever hospitalized* with COVID-19 as a percentage of “Lab Confirmed Cases by Reported Hospitalization” on their [Statistics page](https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/). In the absence of a better data source we convert this percentage to an integer, and as a result of the calculation, this value may fluctuate.Negatives reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On February 9, 2021, Wyoming’s Total PCR tests (specimens) fell from 704,836 to 595,970. We carried the previous day’s number as we believed this may have been an error. On February 10, 2021, we learned that the decrease was "Due to recent changes in reporting by commercial laboratories, some test results were being counted twice. Testing numbers have been corrected to reflect these changes therefore a decrease in the testing numbers will be observed for Non-WPHL labs. That decrease is attributed to the removal of duplicate tests being reported". As a result of this new information, we are backfilling our Total PCR tests (specimens) to reflect this new information and ensure that our data aligns as closely as possible with Wyoming's.On February 7, 2021, Wyoming’s **Confirmed cases** decreased by 36 and **Recovered** decreased by 2 with no explanation.On February 02, 2021, Wyoming’s Total PCR tests (specimens) decreased by roughly 4,600 and their Total PCR tests (people) decreased by approximately 1,500 without explanation. As a result, Negative PCR tes… | https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/ | https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/ | https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-testing-data/ | https://sites.google.com/wyo.gov/exec-covid19/hospital-resources | https://public.tableau.com/views/StateandCountyDashboard/Dashboard1?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=yes&:language=en&publish=yes&:loadOrderID=0 | @health_wyoming | https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/ | Specimens | totalTestsViral | Total Tests (PCR) | No data | false | Wyoming | 56 |
Advanced export
JSON shape: default, array, newline-delimited
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 );