states_info

Table actions

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

19 rows where covidTrackingProjectPreferredTotalTestUnits = "People"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

covidTrackingProjectPreferredTotalTestUnits ✖

  • People · 19 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
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
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
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
18 18 IN Indiana combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people, confirmed + probable)** from **Total PCR tests (people)** in the absence of better data. https://www.in.gov/isdh/28470.htm https://www.regenstrief.org/covid-dashboard/       https://www.in.gov/isdh/28470.htm People posNeg posNeg Indiana 18   false
19 19 KS Kansas combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Kansas reports much of its data on Mondays, Wednesdays, and Fridays only, so there are often large changes in the values, which can represent 2-3 days of data.As of May 7, 2020, **confirmed and probable cases** are included in the case totals.From July 1–July 3, 2020, we reported incorrect numbers for Kansas **Cases or Positive PCR tests (people)**. We have corrected the error.On July 15, 2020, Kansas began reporting additional data from hospitals, and at that time, data for the **Now hospitalized** metric was only available through July 10. https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas http://www.kdheks.gov/coronavirus/ https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no     http://www.kdheks.gov/coronavirus/ People posNeg posNeg Kansas 20   false
21 21 LA Between April 20 and April 24, 2020, Louisiana did not report testing data from commercial labs due to a state review of data.On June 19, 2020, Louisiana's data changed due to deduplication and the state's removal of out-of-state cases.On August 30 Louisiana's reported data included 532 older cases that had not previously been reported; these cases had specimen collection dates ranging back to July 1.On August 26, 2020, Louisiana started reporting Probable cases, this caused a notable increase in **Total cases**.Louisiana reports probable deaths on a weekly basis.Negative test results reported in our API and CSVs are calculated by subtracting *Positive PCR tests (people)** from **Total PCR tests (people)** in the absence of better data. http://ldh.la.gov/Coronavirus/ https://services5.arcgis.com/O5K6bb5dZVZcTo5M/arcgis/rest/services/Combined_COVID_Reporting/FeatureServer/0/query?groupByFieldsForStatistics=Measure&outStatistics=%5B%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%7D%5D&where=1%3D1       http://ldh.la.gov/Coronavirus/ People posNeg posNeg Louisiana 22   false
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
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
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
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
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
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
52 52 VT Between May 15 and May 16, 2020, Vermont's **total tests** decreased by about 1,000 tests with no explanation.On August 19, 2020, Vermont's **total tests** decreased by about 200 tests with no explanation. On September 23, 2020, Vermont's **total tests** decreased by about 80 tests with no explanation. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**. https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170 https://www.healthvermont.gov/response/coronavirus-covid-19/current-activity-vermont#dashboard       https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus People posNeg posNeg Vermont 50   false
54 54 WI On March 30, 2020, Wisconsin revised its cumulative **Negative PCR tests (people)** data downward without explanation.In early June of 2020, Wisconsin started reporting probable cases of COVID-19 separately from confirmed cases of COVID-19. On June 25, 2020, The COVID Tracking Project added more than two weeks' worth of probable cases to our **Cases (confirmed plus probable)** for WI, initially causing a large single day increase in cases. We subsequently updated our historical Cases data using data provided to us by the state, which eliminated this one-day increase.In early June of 2020, Wisconsin started reporting probable deaths from COVID-19 separately from confirmed deaths from COVID-19. We did not discover this data until June 29, 2020, and so our time series only has data for this metric beginning on that date. https://www.dhs.wisconsin.gov/outbreaks/index.htm https://www.dhs.wisconsin.gov/covid-19/data.htm https://www.dhs.wisconsin.gov/covid-19/hosp-data.htm     https://www.dhs.wisconsin.gov/disease/covid-19.htm People posNeg posNeg Wisconsin 55   false
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
);