states_info

Table actions

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

56 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
2 2 AL Alabama combines PCR and antigen tests in the total tests figure reported on the state's dashboard.On July 11, 2020, Alabama began using direct reports from hospitals for cumulative hospitalizations (which we report in our **Ever hospitalized** metric), rather than state case surveillance. Its number of cumulative hospitalizations increased by over 3,000 as a result. On July 15, 2020, we changed our data reporting to reflect that Alabama reports test totals in specimens rather than unique people tested, as we had initially believed. All test results were moved into the correct API field and metric.On September 1, 2020, Alabama began displaying the number of people tested by antibody, over 50,000 individuals, separately from its main total tested field, which it clarified represents antigen and PCR testing. Its main total tested number dropped by over 25,000 the same day. We have reached out to the Alabama Department of Public Health to confirm this drop was due to the removal of the individuals tested by antibody.As of September 18, 2020, Alabama'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://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7 https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7 https://services7.arcgis.com/4RQmZZ0yaZkGR1zy/arcgis/rest/services/HospitalizedPatientTemporal_READ_ONLY/FeatureServer/1/query?where=1%3D1&orderbyfields=DateTxt+desc&outFields=%2A&resultRecordCount=1     http://www.alabamapublichealth.gov/infectiousdiseases/2019-coronavirus.html Unclear units totalTestsViral Total Tests (PCR) Alabama 1   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
5 5 AZ Arizona combines PCR and antigen tests in the total tests figure reported on the state’s dashboardOn June 23, 2020, we updated our historical data for **Cumulative hospitalized** to match Arizona's dashboard data for "hospitalized by date admitted." Data for this metric is not typically reported until several days after admittance. Our daily updates will continue to compile Arizona’s overall number as of cumulative hospitalizations, regardless of date admitted.From July 18–August 5, 2020, Arizona’s dashboard stopped displaying confirmed and probable breakdowns for **cases** and **deaths**. We will backfill this data if Arizona provides historical numbers.On July 28 and July 29, 2020, we noticed that Arizona's numbers for their **Now hospitalized** decreased slightly, while those for **Ever hospitalized** increased significantly. The state offered no explanation.On August 30 and August 31, the Arizona Department of Health removed duplicate case records from their data. As a result, total deaths decreased by 1 on August 31, and cumulative hospitalizations decreased on August 30 and August 31.On September 16, 2020, Arizona added antigen testing into its main totals figure. This appears to have raised its Total Tests (PCR) number more than usual.On September 18, 2020, Arizona reported a policy change in the way they count people with positive antigen testing results to comply with CSTE case definitions. This appears to have resulted in a large increase in probable cases and also likely the reason where a decrease in confirmed cases was observedAs of September 25, 2020, Arizona’s total test timeseries is stored in our Total PCR Tests (People) field instead of Total PCR Tests (specimens), reflecting a response to our outreach to Arizona’s health department that it counts unique individuals tested. Arizona includes antigen tests in its totals figure, so if an individual received both an antigen and PCR test, they are counted only once. Additionally, as of September 25, 2020, Arizona's total test results are drawn from … 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://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php People totalTestsPeopleViral Total PCR Tests (People) Arizona 4   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
7 7 CO On May 15, Colorado started reporting deaths for which COVID-19 is listed on the death certificate, in addition to the figure it already provided, deaths among laboratory-confirmed and probable cases (whether or not COVID was a cause of death). On July 1, 2020, we revised our historical data to reflect the death-certificate metric instead of the deaths-among-cases metric. Because of this change in methodology, there is a drop from 1,091 deaths on May 15 to 878 on May 16 in our data. Colorado also reports subsets of confirmed and probable COVID-19 deaths, but these metrics correspond to the deaths-among-cases metric we no longer report, so we do not compile this data.On June 14, 2020, Colorado revised previous "daily discharged" numbers. This caused an overall decline in their **Recovered** data.On July 27, 2020, Colorado posted a notice that, "Due to a server issue yesterday and today with our electronic laboratory reporting system, the number of tests completed and cases reported today, July 27, 2020, may be artificially low." We report Colorado data a day after posting due to timing, so this note applies to the data published on July 28.As of August 13, 2020, Colorado's **total test results** reflect total test encounters. The number of unique people tested is available in our API as `totalTestsPeopleViral`.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://covid19.colorado.gov/data https://public.tableau.com/views/Colorado_COVID19_Data/CO_Hospital?%3Aembed=y&%3AshowVizHome=no       https://www.colorado.gov/pacific/cdphe/2019-novel-coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) Colorado 8   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
9 9 DC On May 25, 2020, the District of Columbia decreased the district's **total tests** number by 11,000 to reflect only DC residents.As of September 18, 2020, District of Columbia's total test results are drawn from our total`TestEncountersViral` field instead of calculated via positive+negative.According to our outreach, the District of Columbia’s “total overall tested” figure on its dashboard represents test encounters, the number of unique individuals tested per day, with one exception: if an individual receives a positive and a negative test on the same day, they are counted twice rather than once. As of August 29, 2020, we store the “total overall tested” timeseries in our **Total PCR Tests (encounters)** field, despite this difference in definition.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people, confirmed + probable)** from **Total PCR tests (specimens)** in the absence of better data. https://coronavirus.dc.gov/page/coronavirus-surveillance-data         https://coronavirus.dc.gov/ Encounters totalTestEncountersViral Total Test Encounters (PCR) District of Columbia 11   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
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
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
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
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
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
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
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
26 26 MN On September 17, 2020, we switched Minnesota's specimens timeseries to **Total Test Encounters (PCR)** based on correspondence with the state, which revealed that their "total approximate number of completed tests" reflects individuals tested per day.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, Minnesota total test results are drawn from our `totalTestEncountersViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`. https://www.health.state.mn.us/diseases/coronavirus/situation.html         https://www.health.state.mn.us/diseases/coronavirus/index.html Encounters totalTestEncountersViral Total Test Encounters (PCR) Minnesota 27   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
32 32 ND On May 3, 2020, North Dakota began reporting two additional **death** metrics: deaths of people with lab-confirmed cases of COVID-19 whose death records are still pending and deaths of people with lab-confirmed cases of COVID-19 whose death certificates do not list COVID-19 as a cause of death. As of July 1, 2020, we have edited our historical figures to exclude these numbers from our death counts, resulting in an apparent drop from 24 deaths on May 2 to 16 on May 3. On August 19, 2020, North Dakota launched a new dashboard with a number of new data points, including race and ethnicity data and ICU data. On September 9, 2020, North Dakota began reporting “Susceptible Encounters” on its dashboard, which are defined as test encounters excluding those who have tested positive after the first time. We have begun recording the value in our **Total PCR tests (test encounters)** field.As of September 11, 2020, North Dakota’s total test results reflect total test encounters. The number of unique people tested is available in our API as `totalTestsPeopleViral`. https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases         https://www.health.nd.gov/diseases-conditions/coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) North Dakota 38   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
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
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
44 44 RI Rhode Island combines PCR and antigen tests in the total tests figure reported on the state's dashboard.As of August 17, 2020, our **Total tests** metrics include Rhode Island's **Total tests (in test encounters)**.On September 25, 2020, Rhode Island removed 240 duplicate cases from its case count, resulting in a drop from 24,311 cases to 24,181. https://health.ri.gov/data/covid-19/ https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/edit#gid=264100583 https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/gviz/tq?tqx=out:csv&sheet=1592746937     https://health.ri.gov/diseases/respiratory/?parm=163 Encounters totalTestEncountersViral Total Test Encounters (PCR) Rhode Island 44   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
46 46 SD On July 27, 2020, **Negative PCR tests** decreased by 148 for unclear reasons.On August 27, the South Dakota Department of Health included cases from August 25 and 26 in their update due to a reporting aberration, resulting in a 343 case increase. They have provided historical case counts, and we are working to backfill our data.As of September 18, 2020, South Dakota's total test results are drawn from our `totalTestsPeopleViral` field instead of calculated via positive+negative. https://doh.sd.gov/news/Coronavirus.aspx         https://doh.sd.gov/news/Coronavirus.aspx People totalTestsPeopleViral Total PCR Tests (People) South Dakota 46   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
50 50 VA As of May 15, 2020, Virginia is reporting PCR tests and antibody tests separately. On Aug 7, 2020, due to the release of a backlog, Virginia reoprted an abnormally large **case** increase of around 2000.On August 27, the VA dashboard did not update by our publish time. We are carrying over the values from August 26On August 31, 2020 we began publishing **Positive PCR tests (specimens)** for Virginia. This data has been collected daily since July 21, 2020. Previous data going back to February 27, 2020 was taken from state historical data as of July 21. Historical data for **Total PCR Tests (encounters)** before July 21, 2020 was updated based on the same dataset, extending the column back to February 27, 2020 as well.**Ever hospitalized** is calculated from the "currently hospitalized" and "discharged" data points on the Virginia Hospital COVID-19 dashboard. Negative test results reported in our API and CSVs are calculated by subtracting "Positive PCR tests (people)" from "Total PCR tests (test encounters)" in the absence of better data.As of September 18, 2020, Virginia's total test results are drawn from our `totalTestEncountersViral` field instead of calculated via positive+negative. https://www.vdh.virginia.gov/coronavirus/covid-19-in-virginia/ https://www.vhha.com/communications/virginia-hospital-covid-19-data-dashboard/ https://public.tableau.com/views/VirginiaCOVID-19Dashboard/VirginiaCOVID-19Dashboard?:embed=yes&:display_count=yes&:showVizHome=no&:toolbar=no     http://www.vdh.virginia.gov/surveillance-and-investigation/novel-coronavirus/ Encounters totalTestEncountersViral Total Test Encounters (PCR) Virginia 51   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
53 53 WA Between March 31 and April 15, 2020, Washington state did not report **Negative PCR tests (people)**. On April 18, 2020, Washington state removed 190 **confirmed cases** that were discovered to be out-of-state residents tested in Washington laboratories. On June 18, 2020, Washington revised its **Total PCR tests (people)** downward. On the same date, Washington decreased its count of COVID-19 **deaths by 7**, because it determined that even though those 7 people had tested positive for COVID-19, COVID-19 was not a contributing cause in their deaths.On June 22, 2020, we updated previous values for **cases** and **total tests** in our time-series using data from Washington state's dashboard. This update caused an artificial decrease in cases and tests between June 21 and June 22.On July 14, 2020, Washington state revised its count of COVID-19 **deaths** downward by 39, because it determined that even though those 39 people had tested positive for COVID-19, COVID-19 was not a contributing cause in their deaths.On August 2, 2020, Washington state Department of Health reported that "DOH is continuing to experience issues with its reporting system today. We are able to report cases, deaths and hospitalizations but have not reported new negative test results since 8/1."On August 26, 2020, Washington switched its total tests units to testing encounters, excluding future encounters from individuals who test positive. It also provided a full timeseries of the figure. This testing encounters figure is slightly different from how we define testing encounters in two ways: first, our definition of testing encounters includes encounters after a positive test, and second, it should be calculated not by summing resulted tests but by counting all daily tests in a separate reporting stream. Despite these differences, the historical and current values of Washington’s figure are still stored in our **Total PCR tests (test encounters)** field.Washington State reports **confirmed cases**, **laboratory tests**, and **deaths** as of the … https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard https://www.doh.wa.gov/Emergencies/Coronavirus       https://www.doh.wa.gov/Emergencies/Coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) Washington 53   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
);