states_info
Data source: Big Local News · About: big-local-datasette
1 row where covid19SiteTertiary = "https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf" sorted by rowid descending
This data as json, copyable, CSV (advanced)
Link | rowid ▲ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | name | fips | pui | pum | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | KY | On May 23, 2020, Kentucky revised down the state's figure for **Total tests**.As of May 27, 2020, Kentucky reports antibody tests separately from PCR tests. As of September 18, 2020, Kentucky's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334 | https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx | https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf | @CHFSKy | https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx | Specimens | totalTestsViral | Total Tests (PCR) | Kentucky | 21 | 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 );