states_info

Table actions

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

1 row where covid19SiteTertiary = "https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_HospitalizationsE/Hospitalizations?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=no&:language=en&publish=yes&:loadOrderID=0"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

covid19SiteTertiary ✖

  • https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_HospitalizationsE/Hospitalizations?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=no&:language=en&publish=yes&:loadOrderID=0 · 1 ✖
Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField name fips pui pum
31 31 NC On July 22, 2020, North Carolina started reporting the number of patients **currently in the ICU**.On August 12, 2020, North Carolina [announced](https://www.ncdhhs.gov/news/press-releases/ncdhhs-corrects-covid-19-testing-totals-after-identifying-labcorp-reporting) a major correction in its **Total PCR tests (specimens)**, resulting in a decrease of more than 220,000 reported tests. On September 25, 2020, North Carolina started reporting probable cases which caused the **Total Cases** to increase by 4,563.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.ncdhhs.gov/covid-19-case-count-nc https://files.nc.gov/covid/documents/dashboard/Weekly-COVID19-Patients-Presumed-to-be-Recovered.pdf https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_HospitalizationsE/Hospitalizations?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=no&:language=en&publish=yes&:loadOrderID=0     https://www.ncdhhs.gov/divisions/public-health/coronavirus-disease-2019-covid-19-response-north-carolina Specimens posNeg posNeg North Carolina 37   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
);