states_info
Data source: Big Local News · About: big-local-datasette
1 row where covid19SiteTertiary = "https://www.nh.gov/covid19/dashboard/overview.htm#dash"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | name | fips | pui | pum | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34 | 34 | NH | As of May 25, 2020, New Hampshire reports PCR tests separately from antibody tests.On September 2, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.On September 9, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.Negative test results reported in our API and CSVs are calculated by subtracting **Positive PCR tests (people)** from **Total PCR tests (people)**.As of September 18, 2020, New Hampshire's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`. | https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm | https://www.nh.gov/covid19/dashboard/summary.htm | https://www.nh.gov/covid19/dashboard/overview.htm#dash | @NHPubHealth | https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm | Specimens | totalTestsViral | Total Tests (PCR) | New Hampshire | 33 | 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 );