states_info

Table actions

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

1 row where covid19SiteTertiary = "https://www.dhs.wisconsin.gov/covid-19/hosp-data.htm"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

covid19SiteTertiary ✖

  • https://www.dhs.wisconsin.gov/covid-19/hosp-data.htm · 1 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
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

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