states_info
Data source: Big Local News · About: big-local-datasette
1 row where covid19SiteTertiary = "https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html"
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | name | fips | pui | pum | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47 | 47 | TN | On April 5, 2020, Tennessee reported a decline in **Recoveries**. As of July 3, 2020, **Now hospitalized** data includes both positive and pending cases. We have updated hospitalizations for March 31–July 3 to include both positive and pending cases as well.As of June 10, 2020, **Cases** include both confirmed and probable cases of COVID-19 reported to or tested by the Tennessee Department of Health. Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (specimens)** in the absence of better data. | https://www.tn.gov/health/cedep/ncov.html | https://apps.health.tn.gov/AEM_embed/TDH-2019-Novel-Coronavirus-Epi-and-Surveillance.pdf#toolbar=0 | https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html | @TNDeptofHealth | https://www.tn.gov/health/cedep/ncov.html | Specimens | posNeg | posNeg | Tennessee | 47 | false |
Advanced export
JSON shape: default, array, newline-delimited
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 );