states_info

Table actions

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

37 rows where totalTestResultsField = "posNeg"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: covid19SiteSecondary, covid19SiteTertiary, covid19SiteQuaternary, covidTrackingProjectPreferredTotalTestUnits, covidTrackingProjectPreferredTotalTestField

totalTestResultsField ✖

  • posNeg · 37 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
8 8 CT On May 27, 2020, Connecticut deduplicated some of its data, resulting in a decrease in **Cases** and **Total PCR tests (specimens)**.On May 29, 2020, Connecticut hospitalization data changed due to reporting laboratory-confirmed cases only. These changes resulted in a decrease in the numbers for **Ever hospitalized** and **Recovered** (which can be found in our API and CSVs). On June 18, 2020, Connecticut corrected some errors in its data, resulting in a decrease in **Total PCR tests (specimens)**.On June 24, 2020, Connecticut corrected some errors in its data, resulting in a decrease in **Negative PCR tests (specimens)** (which can be found in our API and CSVs).Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://data.ct.gov/coronavirus         https://portal.ct.gov/Coronavirus Specimens posNeg posNeg Connecticut 9   false
10 10 DE On April 11, 2020, Delaware revised down negative test results from 10,415 to 9,624.On July 25, 2020, Delaware revised down total cases, confirmed positives, and total tests.On August 27, 2020, Delaware revised down total cases and confirmed positives. This is a semi-regular occurrence which will impact Delware's number occasionally. On September 6, 2020, the Division of Public Health reported a technical issue which caused between 175-200 positive cases to be excluded from Delaware's cumulative confirmed case count. These cases will be added in the coming days. As a result new cases reported may not have been diagnosed in the past 24 hour period.On September 9, 2020, Delaware reported that data from September 8, 2020 and September 9, 2020 would not be available until September 10, 2020 due to a maintenance issue with their electronic reporting system. We will backfill data for September 8, 2020 and September 9, 2020 to the best of our abilities when data is released https://myhealthycommunity.dhss.delaware.gov/locations/state#testing         https://dhss.delaware.gov/dhss/dph/epi/2019novelcoronavirus.html People posNeg posNeg Delaware 10   false
11 11 FL Florida combines PCR and antigen tests in the total tests figure reported on the state's dashboard (first noted July 2, 2020). We include data about Florida non-residents in all metrics where possible. For some metrics, we use machine queries against the Florida Department of Health's raw data, which may not be displayed on its [dashboard](https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/).On March 21, 2020, Florida began including tests of people not investigated as PUIs in its **Negative PCR tests** metric. Since May 15, 2020, Florida reports total tests in unique people and in unique people tested per lab. For that latter number, if an individual is tested twice by one lab, they only get counted once, but if an individual gets tested twice at different labs, they get counted twice. We store the former value in **Total PCR Tests (People)**, and the latter value, which does not match any of our totals units, in **Total Tests (PCR)**, our specimens field, where we also store testing data with unclear units. This value does **not** represent the number of specimens.As of July 10, 2020, Florida reports **Now hospitalized** data for those patients with a "primary diagnosis of COVID-19."On August 12, 2020, the Florida Department of Health reported via Twitter that it had received a large backlog of testing data from Niznik Lab Corp in Miami: "The lab reported over 4000 cases occurring over the last 7 weeks, but which had not been reported to FDOH until today. Therefore, this backlog severely skews today's daily report for Miami-Dade and is not reflective of current trends."On September 1, 2020, the Florida Department of Health [announced](http://www.floridahealth.gov/newsroom/2020/09/090120-1112-covid19.pr.html) that Quest Diagnostics had reported nearly 75,000 backlogged tests dating as far back as April.[Per reporting](https://www.miamiherald.com/news/coronavirus/article241882491.html), the number of **pending tests** (available in our API and CSVs) may include only results from public labs… https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/ https://floridahealthcovid19.gov/ https://bi.ahca.myflorida.com/t/ABICC/views/Public/COVIDHospitalizationsCounty?%3AshowAppBanner=false&%3Adisplay_count=n&%3AshowVizHome=n&%3Aorigin=viz_share_link&%3AisGuestRedirectFromVizportal=y&%3Aembed=y     http://www.floridahealth.gov/diseases-and-conditions/COVID-19/ People posNeg posNeg Florida 12   false
13 13 GU Guam's counts include 11 people tested at the San Diego naval base.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 Guams's total case count. http://dphss.guam.gov/covid-19/         https://ghs.guam.gov/coronavirus-covid-19 Unclear Units posNeg posNeg Guam 66   false
14 14 HI As of August 5, 2020, we are collecting **Now hospitalized**, **Now in ICU**, and **Now on ventilator** data from the Lt. Governor of Hawaii's Instagram account, as we have determined that these are official statistics not available elsewhere. We have backfilled our time series for all available data from this source.On September 3, 2020, Hawaii included cases which had been previously diagnosed in their daily update due to an electronic laboratory reporting error." As a result, new cases reported may not have been diagnosed in the previous 24 hours.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people, confirmed + probable)** from **Total PCR tests (people)** in the absence of better data. https://health.hawaii.gov/coronavirusdisease2019/ https://health.hawaii.gov/coronavirusdisease2019/what-you-should-know/current-situation-in-hawaii/       https://health.hawaii.gov/docd/advisories/novel-coronavirus-2019/ People posNeg posNeg Hawaii 15   false
15 15 IA As of May 19, 2020, Iowa reports PCR and antibody tests separately.On September 26, 2020, Iowa [announced] (https://coronavirus.iowa.gov/#CurrentStatus) that due to a data update, roughly 27,000 antigen test from long-term care facilities will be added to their COVID-19 data. This update will occur from September 26, 2020 to September 27, 2020 and will result in an increased number of antigen testing metrics. https://coronavirus.iowa.gov/ https://coronavirus.iowa.gov/pages/access https://coronavirus.iowa.gov/pages/case-counts     https://idph.iowa.gov/Emerging-Health-Issues/Novel-Coronavirus People posNeg posNeg Iowa 19   false
17 17 IL 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." Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. 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 Illinois 17   false
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 **Positive PCR tests (people, confirmed + probable)** from **Total PCR tests (people)** in the absence of better data. https://www.in.gov/isdh/28470.htm https://www.regenstrief.org/covid-dashboard/       https://www.in.gov/isdh/28470.htm People posNeg posNeg Indiana 18   false
19 19 KS Kansas combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Kansas reports much 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.As of May 7, 2020, **confirmed and probable cases** are included in the case totals.From July 1–July 3, 2020, we reported incorrect numbers for Kansas **Cases or Positive PCR tests (people)**. We have corrected the error.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. https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas http://www.kdheks.gov/coronavirus/ https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no     http://www.kdheks.gov/coronavirus/ People posNeg posNeg Kansas 20   false
21 21 LA Between April 20 and April 24, 2020, Louisiana did not report testing data from commercial labs due to a state review of data.On June 19, 2020, Louisiana's data changed due to deduplication and the state's removal of out-of-state cases.On August 30 Louisiana's reported data included 532 older cases that had not previously been reported; these cases had specimen collection dates ranging back to July 1.On August 26, 2020, Louisiana started reporting Probable cases, this caused a notable increase in **Total cases**.Louisiana reports probable deaths on a weekly basis.Negative test results reported in our API and CSVs are calculated by subtracting *Positive PCR tests (people)** from **Total PCR tests (people)** in the absence of better data. http://ldh.la.gov/Coronavirus/ https://services5.arcgis.com/O5K6bb5dZVZcTo5M/arcgis/rest/services/Combined_COVID_Reporting/FeatureServer/0/query?groupByFieldsForStatistics=Measure&outStatistics=%5B%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%7D%5D&where=1%3D1       http://ldh.la.gov/Coronavirus/ People posNeg posNeg Louisiana 22   false
23 23 MD Between March 12 and March 28, 2020, Maryland did not report data for **negative tests**.On July 31, 2020, we began capturing Maryland's data for **Positive PCR tests (specimens)**. 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. https://coronavirus.maryland.gov/         https://phpa.health.maryland.gov/Pages/Novel-coronavirus.aspx Specimens totalTestsViral posNeg Maryland 24   false
24 24 ME Maine combines PCR and antigen tests in the total tests figure reported on the state's dashboard.As of May 20, 2020, Maine reports PCR tests and antibody tests separately.On June 23, 2020, Maine began reporting the dates of **cases**, **deaths**, **recoveries**, and **hospitalizations** on the day they occurred instead of the day the event was reported. Maine also began providing separate figures for **Deaths (probable)** and **Deaths (confirmed)**.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml         https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus.shtml Specimens posNeg posNeg Maine 23   false
25 25 MI On June 11, 2020, we updated our historical data from a spreadsheet provided by Michigan's Department of Health and Human Services in order to reflect the lab-reported dates of **probable and confirmed cases** and **probable and confirmed deaths** by date of death.As of July 7, 2020, Michigan updates its death figures three times a week after conducting reviews of death certificates. As a result, "new" deaths may not always reflect deaths in the past 24 hours.Michigan updates its **Recovered** metric weekly and does not update any data on Sundays. Michigan combines PCR and antigen tests in the total tests figure reported on the state's dashboard. Since March 10, 2020, Michigan has reported each day's Positive and Negative tests (people) by county but has never totaled these metrics for the state. We add new Positive and Negative tests (people) values daily to a running sum and report the total. https://www.michigan.gov/coronavirus/0,9753,7-406-98163_98173---,00.html https://www.michigan.gov/coronavirus/0,9753,7-406-98159-523641--,00.html       https://www.michigan.gov/coronavirus Specimens totalTestsViral posNeg Michigan 26   false
27 27 MO As of May 22, 2020, Missouri reports PCR tests separately from antibody tests. On September 5, 2020, the Missouri DHSS [added an additional 72 deaths](http://twitter.com/HealthyLivingMo/status/1302314149620391937?s=20) to their total count, "most of which occurred June-August".Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://health.mo.gov/living/healthcondiseases/communicable/novel-coronavirus/results.php https://missouri-coronavirus-gis-hub-mophep.hub.arcgis.com/ https://mophep.maps.arcgis.com/apps/opsdashboard/index.html#/d05d2bf6e13745c5afffc8fc87d5b1c5     https://health.mo.gov/living/healthcondiseases/communicable/novel-coronavirus/ People posNeg posNeg Missouri 29   false
28 28 MP 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.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://www.chcc.gov.mp/coronavirusinformation.php 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://www.chcc.gov.mp/coronavirusinformation.php People posNeg posNeg Northern Mariana Islands 69   false
29 29 MS As of May 23, 2020, Mississippi is separating out PCR and antibody tests. We now report both separately.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 September 11, 2020, we discovered a new source for Mississippi current hospitalizations and current ICU admissions on the Mississippi State Department of Health website.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.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://msdh.ms.gov/msdhsite/_static/14,0,420.html         https://msdh.ms.gov/msdhsite/_static/14,0,420.html Specimens posNeg posNeg Mississippi 28   false
30 30 MT Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt/demographics       https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt Specimens totalTestsViral posNeg Montana 30   false
31 31 NC On July 22, 2020, North Carolina started reporting the number of patients **currently in the ICU**.On August 12, 2020, North Carolina [announced](https://www.ncdhhs.gov/news/press-releases/ncdhhs-corrects-covid-19-testing-totals-after-identifying-labcorp-reporting) a major correction in its **Total PCR tests (specimens)**, resulting in a decrease of more than 220,000 reported tests. On September 25, 2020, North Carolina started reporting probable cases which caused the **Total Cases** to increase by 4,563.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. 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://www.ncdhhs.gov/divisions/public-health/coronavirus-disease-2019-covid-19-response-north-carolina Specimens posNeg posNeg North Carolina 37   false
33 33 NE Nebraska combines PCR and antigen tests in the total tests figure reported on the state's dashboard. https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd         http://dhhs.ne.gov/Pages/Coronavirus.aspx People totalTestsPeopleViral posNeg Nebraska 31   false
35 35 NJ On May 16, 2020, a backfill effort by New Jersey caused the state's data for **Recovered** to rise by approximately 7,000 people. On July 16, 2020, New Jersey's **Recovered** figure decreased.On July 19, 2020, New Jersey's **Total cases** decreased, perhaps due to reclassification of probable cases.On August 4, 2020, New Jersey's *Now hospitalized** number decreased by 268 people.On August 7, 2020, we back-filled New Jersey's **Probable deaths** with data provided by the state. This removed apparent spikes in deaths due to the state's irregulat reporting.On September 1, New Jersey did not update their total PCR test figure by the time of our update, however total cases increased from 191160 to 192290.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)**. https://covid19.nj.gov/#live-updates https://maps.arcgis.com/apps/MapSeries/index.html?appid=c2efd1898e48452e83d7218329e953d7&entry=2       https://www.nj.gov/health/cd/topics/ncov.shtml Specimens posNeg posNeg New Jersey 34   false
36 36 NM Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://cvprovider.nmhealth.org/public-dashboard.html         https://cv.nmhealth.org/ Specimens posNeg posNeg New Mexico 35   false
37 37 NV   https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9 http://dpbh.nv.gov/coronavirus/       http://dpbh.nv.gov/coronavirus/ People posNeg posNeg Nevada 32   false
38 38 NY Due to an exclusion of **probable COVID-19 deaths** in the state's data, New York City and New York State report substantially diverging death counts. As of June 1, 2020, New York City reported 5740 more deaths than New York State. We use the data from the state, so our dataset excludes these probable COVID-19 deaths. New York State has not reported new **Ever hospitalized** data since June 2, 2020.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases https://covid19tracker.health.ny.gov/views/NYS-COVID19-Tracker/NYSDOHCOVID-19Tracker-Fatalities?%3Aembed=yes&%3Atoolbar=no&%3Atabs=n https://www.governor.ny.gov/news/governor-cuomo-updates-new-yorkers-states-progress-during-covid-19-pandemic     https://www.health.ny.gov/diseases/communicable/coronavirus/ Encounters posNeg posNeg New York 36   false
39 39 OH Ohio continually updates its **Currently hospitalized / Now hospitalized** data which can cause slight differences between their historic data and ours. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://coronavirus.ohio.gov/wps/portal/gov/covid-19/ 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     https://odh.ohio.gov/wps/portal/gov/odh/know-our-programs/Novel-Coronavirus/welcome/ Unclear units posNeg posNeg Ohio 39   false
40 40 OK Prior to April 10, 2020, Oklahoma reported "Positive (Out-of-State)" results. We excluded these figures from our data, as we assumed these individuals were isolated outside the state.Oklahoma noted that reported **Total cases** numbers for July 19 and July 20 were inaccurately low due to technical issues. https://coronavirus.health.ok.gov/         https://coronavirus.health.ok.gov Specimens posNeg posNeg Oklahoma 40   false
41 41 OR As of June 6th, 2020, Oregon only releases updated data for **Cases (confirmed plus probable)**, **Deaths (confirmed and probable)**, and **Negative PCR tests (people)** metrics on the weekend. 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://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx People posNeg posNeg Oregon 41   false
42 42 PA On April 23, 2020, Pennsylvania revised down its total **Deaths (confirmed and probable)** from 1,622 to 1,421 to exclude some probable deaths that needed further confirmation to be linked to COVID-19.On September 3, 2020, Pennsylvania [clarified](https://www.health.pa.gov/topics/disease/coronavirus/Pages/Coronavirus.aspx) that the test numbers they have been reporting previously are in units of unique people and began publishing new test data in units of specimens. On September 4, 2020, we therefore moved the appropriate historical data to the **Total PCR tests (people)** field and began capturing **Total PCR tests (specimens)**. https://www.health.pa.gov/topics/disease/coronavirus/Pages/Cases.aspx https://pema.maps.arcgis.com/apps/opsdashboard/index.html?rand_1596123643354=1596123643354#/034bec0bab3b450888a32012f81b8fe4 https://www.health.pa.gov/topics/disease/coronavirus/Pages/Coronavirus.aspx     https://www.health.pa.gov/topics/disease/Pages/Coronavirus.aspx People totalTestsPeopleViral posNeg Pennsylvania 42   false
43 43 PR On April 22, 2020, Puerto Rico's data changed due to deduplication. This resulted in a decrease in **Total cases**.On May 6, 2020, Puerto Rico stopped reporting **Negative PCR tests**.On July 7, 2020, we updated **Negative PCR tests** based on press releases from May and June.Reported **Deaths** include both confirmed and probable COVID-19 deaths.Puerto Rico reports both confirmed cases, which are identified by positive PCR tests, and probable cases, which the territory reports are identified by positive antibody tests. It is not clear whether Puerto Rico requires additional epidemiological, clinical, or vital records evidence to classify a person with a positive antibody test as a probable case. The combined case number in our dataset includes Puerto Rico's confirmed and probable cases as the territory reports them. https://estadisticas.pr/en/covid-19 https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/3bfb64c9a91944bc8c41edd8ff27e6df       http://www.salud.gov.pr/Pages/coronavirus.aspx Specimens posNeg posNeg Puerto Rico 72   false
45 45 SC As of June 11, 2020, South Carolina reports PCR tests separately from antibody tests. Total test numbers were reduced by around 22,000 as a result of this change. On July 18, 2020, South Carolina announced it was transitioning to new reporting systems and that "there may be incomplete data with significant gaps." Though reporting resumed July 28, 2020, this resulted in data being carried over at times. We will backfill with the updated numbers when they are available.On August 14, 2020, South Carolina reported an unusually large number of tests without explanation. On August 23, 2020, South Carolina [corrected](https://scdhec.gov/news-releases/south-carolina-announces-latest-covid-19-update-august-23-2020) a double-counting of testing numbers from the months May–August. This resulted in a significant drop of all aspects of testing-related counts, with **Total PCR tests (specimens)** dropping by approximately 22,000 and total antibody tests dropping by 1,500.On September 10, 2020, South Carolina [announced](https://scdhec.gov/news-releases/south-carolina-announces-latest-covid-19-update-september-10-2020) that it added a large number of saliva tests from the University of South Carolina to its data, causing an unusually large number of cases in the data for September 11. The most recent date that South Carolina published **Recovered** data was August 25, 2020. We will carry over the data point from that date until new data is available.On September 15, 2020, South Carolina started reporting antigen testing data, reporting 7,763 positive tests and 23,477 total tests. Its “viral (i.e. molecular/PCR) tests” positives and totals dropped by about the same amount, likely due to the removal of this data.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. 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/health/infectious-diseases/viruses/coronavirus-disease-2019-covid-19 Specimens posNeg posNeg South Carolina 45   false
47 47 TN On April 5, 2020, Tennessee reported a decline in **Recoveries**. As of July 3, 2020, **Now hospitalized** data includes both positive and pending cases. We have updated hospitalizations for March 31–July 3 to include both positive and pending cases as well.As of June 10, 2020, **Cases** include both confirmed and probable cases of COVID-19 reported to or tested by the Tennessee Department of Health. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. 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://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html     https://www.tn.gov/health/cedep/ncov.html Specimens posNeg posNeg Tennessee 47   false
48 48 TX As of May 23, 2020, Texas reports PCR tests separately from antibody tests.On June 16, 2020, Texas notes that "The reported cases for June 16 include 2,622 new cases and 1,476 cases that were previously diagnosed among Texas Department of Criminal Justice inmates but that had not been reported by local health departments (887 from Anderson County and 589 from Brazoria County)." On July 22, 2020, we began reporting **Currently in ICU** for Texas. We are currently reviewing historical data to maintain an accurate time-series. On July 25, 2020, Texas reported that 2092 probable cases had been removed from the statewide case totals by the Corpus Christi-Nueces County Public Health District. That removal meant that the number of total cases for Texas appeared smaller than it was. The actual number of new cases in Texas that day was 8,112, not 6,020. On July 27, 2020, Texas added 675 additional deaths through death certificate reviews. However only 44 deaths were truly "new" deaths on July 27. This will create a one-day artificial apparent daily increase in deaths.Starting July 23, 2020, Texas has reported that its current hospitalization and ICU numbers are 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 July 23–July 28 if the complete data becomes available.On July 30, 2020, Texas noted that "Cumulative fatalities have been corrected for July 27–29. As DSHS shifted to using death certificate data to count fatalities this week, an automation error caused approximately 225 fatalities to be included that did not have COVID-19 listed as a direct cause of death."On August 2, 2020, Texas noted that "New data will not be posted on this dashboard on Sunday, August 2 due to a scheduled upgrade to the system that processes electronic lab reports. Data for Sunday will be posted with Monday’s data update."As of August 16, 2020, several commercial laboratories submitted previously backlogged test results to the Texas Dep… https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/ed483ecd702b4298ab01e8b9cafc8b83 https://www.dshs.texas.gov/coronavirus/TexasCOVID-19HospitalizationsOverTimebyTSA.xlsx https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/0d8bdf9be927459d9cb11b9eaef6101f     https://dshs.texas.gov/coronavirus/ Specimens posNeg posNeg Texas 48   false
49 49 UT Utah combines PCR and antigen tests in the top-line total tests figure reported on the state's dashboard. We get our cumulative PCR and antigen testing numbers from summing the daily testing figures on a graph with a timeseries that Utah continuously revises. We do our best to capture any backfilling manually, but the graph does not have an option to download the data automatically, which would allow us to better capture these revisions.As of June 11, 2020, Utah reports a combined case count for total intubated patients and patients on a ventilator. We report this figure as **Ever on ventilator**.As of July 16, 2020, Utah is reporting both specimens and people tested. We report positives and negatives based on the number of people tested. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://coronavirus-dashboard.utah.gov/ https://coronavirus-dashboard.utah.gov/#hospitalizations       https://health.utah.gov/coronavirus People posNeg posNeg Utah 49   false
51 51 VI Total PCR tests in the Virgin Islands is the sum of **Positive PCR tests**, **Negative PCR tests**, and **Pending tests**. https://doh.vi.gov/covid19usvi https://www.covid19usvi.com       https://doh.vi.gov/ Unclear units posNeg posNeg US Virgin Islands 78   false
52 52 VT Between May 15 and May 16, 2020, Vermont's **total tests** decreased by about 1,000 tests with no explanation.On August 19, 2020, Vermont's **total tests** decreased by about 200 tests with no explanation. On September 23, 2020, Vermont's **total tests** decreased by about 80 tests with no explanation. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170 https://www.healthvermont.gov/response/coronavirus-covid-19/current-activity-vermont#dashboard       https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus People posNeg posNeg Vermont 50   false
54 54 WI On March 30, 2020, Wisconsin revised its cumulative **Negative PCR tests (people)** data downward without explanation.In early June of 2020, Wisconsin started reporting probable cases of COVID-19 separately from confirmed cases of COVID-19. On June 25, 2020, The COVID Tracking Project added more than two weeks' worth of probable cases to our **Cases (confirmed plus probable)** for WI, initially causing a large single day increase in cases. We subsequently updated our historical Cases data using data provided to us by the state, which eliminated this one-day increase.In early June of 2020, Wisconsin started reporting probable deaths from COVID-19 separately from confirmed deaths from COVID-19. We did not discover this data until June 29, 2020, and so our time series only has data for this metric beginning on that date. https://www.dhs.wisconsin.gov/outbreaks/index.htm https://www.dhs.wisconsin.gov/covid-19/data.htm https://www.dhs.wisconsin.gov/covid-19/hosp-data.htm     https://www.dhs.wisconsin.gov/disease/covid-19.htm People posNeg posNeg Wisconsin 55   false
55 55 WV 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.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 July 4, 2020, West Virginia began making continual changes to its previous data for antibody testing, so its historical time series might not match COVID Tracking Project data.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 **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://app.powerbigov.us/view?r=eyJrIjoiYmIyYTE0YWYtZDMyOS00YjAzLTgxZTItZDIyMmNlYTZmMWVkIiwidCI6IjhhMjZjZjAyLTQzNGEtNDMxZS04Y2FkLTdlYWVmOTdlZjQ4NCJ9&pageName=ReportSection3aff85597cada99d298f&pageName=ReportSection9f5bc3be6e9ebda92968 https://app.powerbigov.us/view?r=eyJrIjoiYmIyYTE0YWYtZDMyOS00YjAzLTgxZTItZDIyMmNlYTZmMWVkIiwidCI6IjhhMjZjZjAyLTQzNGEtNDMxZS04Y2FkLTdlYWVmOTdlZjQ4NCJ9&pageName=ReportSection4bb4fbc7d2bc2ad57511     https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx Specimens posNeg posNeg West Virginia 54   false
56 56 WY During the week of April 6, 2020, Wyoming began reporting confirmed and probable cases separately.During the week of April 7, 2020, Wyoming began to report both confirmed and probable cases in its Recovered metrics.On April 22, 2020, Wyoming revised its **Total PCR tests (specimens)** downward, resulting in a corresponding decrease in the calculated value of **Negative PCR tests (specimens)**. On April 28, 2020, we began to report **probable cases** together with **confirmed cases**.On June 19, 2020, Wyoming began reporting the **Total PCR tests (people)** as well as **Total PCR tests (specimens)**.On August 26, 2020, Wyoming did not report *Total PCR tests (people).** We have carried over the previous day's value.Wyoming reports both **Positive tests PCR (specimens)** and **Negative tests PCR (specimens)** as percentages of **Total tests PCR**. We convert these percentages to integers. Wyoming reports the number of people currently hospitalized with COVID-19 in each hospital: we sum these values for the state total. Wyoming reports the number of people ever hospitalized with COVID-19 as a percentage: we convert this percentage to an integer. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. 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://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/ People posNeg posNeg Wyoming 56   false

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,
   [name] TEXT,
   [fips] INTEGER,
   [pui] TEXT,
   [pum] TEXT
);