states_info
Data source: Big Local News · About: big-local-datasette
8 rows where covidTrackingProjectPreferredTotalTestUnits = "Encounters"
This data as json, copyable, CSV (advanced)
Suggested facets: covid19SiteSecondary, covid19SiteTertiary, covidTrackingProjectPreferredTotalTestField, totalTestResultsField
| Link | rowid ▼ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | name | fips | pui | pum | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | @cdphe | https://www.colorado.gov/pacific/cdphe/2019-novel-coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Colorado | 8 | 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 | @_DCHealth | https://coronavirus.dc.gov/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | District of Columbia | 11 | 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 | @mnhealth | https://www.health.state.mn.us/diseases/coronavirus/index.html | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Minnesota | 27 | 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 | @NDDOH | https://www.health.nd.gov/diseases-conditions/coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | North Dakota | 38 | 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 | @healthnygov | https://www.health.ny.gov/diseases/communicable/coronavirus/ | Encounters | posNeg | posNeg | New York | 36 | 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 | @rihealth | https://health.ri.gov/diseases/respiratory/?parm=163 | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Rhode Island | 44 | 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 | @vdhgov | http://www.vdh.virginia.gov/surveillance-and-investigation/novel-coronavirus/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Virginia | 51 | 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 | @WADeptHealth | https://www.doh.wa.gov/Emergencies/Coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Washington | 53 | false |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_info] ( [state] TEXT, [notes] TEXT, [covid19Site] TEXT, [covid19SiteSecondary] TEXT, [covid19SiteTertiary] TEXT, [covid19SiteQuaternary] TEXT, [covid19SiteQuinary] TEXT, [twitter] TEXT, [covid19SiteOld] TEXT, [covidTrackingProjectPreferredTotalTestUnits] TEXT, [covidTrackingProjectPreferredTotalTestField] TEXT, [totalTestResultsField] TEXT, [name] TEXT, [fips] INTEGER, [pui] TEXT, [pum] TEXT );