states_info

Table actions

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

25 rows where covidTrackingProjectPreferredTotalTestUnits = "Specimens"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: covid19SiteSecondary, covid19SiteTertiary, covidTrackingProjectPreferredTotalTestField, totalTestResultsField

covidTrackingProjectPreferredTotalTestUnits ✖

  • Specimens · 25 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
1 1 AK Alaska combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Alaska reports a "Total count" of people who have been hospitalized, but we do not record that count in our **Ever hospitalized** metric, since it does not include people who are currently in the hospital.As of July 16, 2020, we are reporting non-resident cases as part of **Cases or Positive PCR tests (people)** for Alaska.As of September 18, 2020, Alaska's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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://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     http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/default.aspx Specimens totalTestsViral Total Tests (PCR) Alaska 2   false
3 3 AR 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.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 September 16, 2020, Arkansas’ **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 that Arkansas reversed. It also added 140 probable deaths, not all of which dated to September 16.As of September 18, 2020, Arkansas' total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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. https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9 https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9     https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus Specimens totalTestsViral Total Tests (PCR) Arkansas 5   false
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) American Samoa 60   false
6 6 CA Prior to April 1, 2020, we used county data sources for more reliably timely reporting of California's COVID-19 data. At the start of April, we began reporting primarily from the state data dashboard(s). This led to a modest drop in **cases** and **deaths**, as the state's data lags behind the county sources.On April 4 and April 22, 2020, California reported large batches of backlogged **negative test** 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 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.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.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.As of September 18, 2020, California's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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://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     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx Specimens totalTestsViral Total Tests (PCR) California 6   false
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
12 12 GA As of May 27, 2020, Georgia reports antibody tests separately from PCR tests. This change reduced the number for total tests by approximately 74,000.As of August 28, 2020, we started reporting patients Now hospitalized from the [Georgia Geospatial Information Office](https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6). The new count includes both patients with a confirmed COVID-19 diagnosis and patients under investigation, as is our standard practice where possible.As of September 18, 2020, Georgia's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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://dph.georgia.gov/covid-19-daily-status-report https://augustagis.maps.arcgis.com/apps/opsdashboard/index.html#/4eec20925b6b4f338368df0ffcba472d https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6     https://dph.georgia.gov/novelcoronavirus Specimens totalTestsViral Total Tests (PCR) Georgia 13   false
16 16 ID As of April 9, 2020, Idaho reports **probable and confirmed cases** separately. On June 5, 2020, Idaho reported a large batch of previously unreported tests. The state's **Total tests** number rose by approximately 2,500 more tests on June 5 than the seven-day average for new tests at that time.On July 3, 2020, Idaho revised down their **Recovered** data by about 1,500, noting that "an error in auto-calculation was discovered."On July 8, 2020, Idaho revised its historical numers for **Hospitalized now**. We updated our hospitalization figures for Idaho from March 23 to July 13, 2020 to match on July 17, 2020.From July 13 through July 21, 2020, Idaho was unable to report **Hospitalized now** data due to HHS regulation changes. Idaho retroactively made figures available for these days on July 21, 2020, and we revised our figures to match.On July 22, 2020, Idaho reported 126 total **deaths** but also reported 103 lab-confirmed deaths and 33 probable deaths, for a calculated total of 136 deaths. We treated the 33 probable deaths data point as an error and reported 126 total deaths for this date, including 103 confirmed and 23 probable deaths. See Idaho state page screenshots for July 22. On August 4, 2020, after another period of missing data for **Hospitalized now**, Idaho reported current hospitalizations of 106, down from the previous report of 223 on July 31. It reported a similar drop in ICU patients from 51 on July 31 to 22 on August 4.As of September 18, 2020, Idaho's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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.idaho.gov/ https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard_V2/Story1?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y&%3Adisplay_static_image=y&%3AbootstrapWhenNotified=true       https://coronavirus.idaho.gov/ Specimens totalTestsViral Total Tests (PCR) Idaho 16   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
20 20 KY On May 23, 2020, Kentucky revised down the state's figure for **Total tests**.As of May 27, 2020, Kentucky reports antibody tests separately from PCR tests. As of September 18, 2020, Kentucky's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334 https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf     https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx Specimens totalTestsViral Total Tests (PCR) Kentucky 21   false
22 22 MA On June 1, 2020, Massachusetts began to report **probable cases** and **probable deaths*, causing **Total cases** and **Total deaths** to appear to increase sharply in our data. On June 30, 2020, Massachusetts decreased the number of **cumulative hospitalizations** and **confirmed and probable deaths** "due to ongoing data cleaning which identifies and removes duplicate reports."On July 31, 2020, Massachusetts noted that "Delays in the reporting of test results to DPH from multiple laboratories, including large national commercial laboratories, are reflected in today’s case counts. However, these positive test results have been assigned retrospectively to the appropriate date of test." We will backfill case data for Massachusetts in the near future.On August 12, 2020, Massachusetts began reporting **probable cases** weekly instead of daily. This can lead to apparent spikes in the data when the weekly numbers are incorporated, as happened on August 19. Beginning August 20, 2020, we will use the daily total case count from the race and ethnicity section of the dashboard, which includes both confirmed and probable cases, and will backfill the previous week's case counts.On August 31, 2020 we updated Massachusetts' **Total PCR Tests (specimens)** before August 12, 2020 based on the state's "Tests by Date" dataset, extending the column back to January 22, 2020.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. 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`.Negative test results reported in our API and CSVs are c… https://www.mass.gov/info-details/covid-19-cases-quarantine-and-monitoring         https://www.mass.gov/resource/information-on-the-outbreak-of-coronavirus-disease-2019-covid-19 Specimens totalTestsViral Total Tests (PCR) Massachusetts 25   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
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
34 34 NH As of May 25, 2020, New Hampshire reports PCR tests separately from antibody tests.On September 2, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.On September 9, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**.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`. https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm https://www.nh.gov/covid19/dashboard/summary.htm https://www.nh.gov/covid19/dashboard/overview.htm#dash     https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm Specimens totalTestsViral Total Tests (PCR) New Hampshire 33   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
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
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
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

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
);