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

1 row where covid19SiteTertiary = "https://coronavirus.iowa.gov/pages/case-counts" sorted by pum

View and edit SQL

covid19SiteTertiary

  • https://coronavirus.iowa.gov/pages/case-counts · 1
Link rowid state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum ▼
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

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