states_info

Table actions

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

1 row where covid19SiteTertiary = "https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/gviz/tq?tqx=out:csv&sheet=1592746937"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

covid19SiteTertiary ✖

  • https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/gviz/tq?tqx=out:csv&sheet=1592746937 · 1 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
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

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