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

1 row where covid19SiteTertiary = "https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no"

View and edit SQL

covid19SiteTertiary

  • https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no · 1
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
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

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