states_current

Table actions

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

2 rows where deathIncrease = 22

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: dateModified (date), dateChecked (date)

deathIncrease ✖

Link rowid ▼ date state positive negative pending totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dataQualityGrade lastUpdateEt dateModified checkTimeEt death hospitalized dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsSource totalTestResultsIncrease posNeg deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
42 42 20200926 PA 155232 1830292   1985524 444       60   127290 A+ 9/26/2020 12:00 2020-09-26T12:00:00Z 09/26 08:00 8103   2020-09-26T12:00:00Z 2898629     150393       1980685                     42 1029 13895 1985524 posNeg 14924 1985524 22 0 95db3b8c62ccc9249c12e799648a8351f5b7337f 0 0 0 0 0  
47 47 20200926 TN 190891 2598988   2789879 855 8528 267   119   174044 A+ 9/26/2020 15:00 2020-09-26T15:00:00Z 09/26 11:00 2374 8528 2020-09-26T15:00:00Z 2782844 224629 2558215 183856 2281 93                         47 1437 25597 2789879 posNeg 27034 2789879 22 51 053b3f4cd24a0ce9d35d93dfa59a783a7b6091cb 0 0 0 0 0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [states_current] (
   [date] INTEGER,
   [state] TEXT,
   [positive] INTEGER,
   [negative] INTEGER,
   [pending] TEXT,
   [totalTestResults] INTEGER,
   [hospitalizedCurrently] TEXT,
   [hospitalizedCumulative] TEXT,
   [inIcuCurrently] TEXT,
   [inIcuCumulative] TEXT,
   [onVentilatorCurrently] TEXT,
   [onVentilatorCumulative] TEXT,
   [recovered] TEXT,
   [dataQualityGrade] TEXT,
   [lastUpdateEt] TEXT,
   [dateModified] TEXT,
   [checkTimeEt] TEXT,
   [death] INTEGER,
   [hospitalized] TEXT,
   [dateChecked] TEXT,
   [totalTestsViral] TEXT,
   [positiveTestsViral] TEXT,
   [negativeTestsViral] TEXT,
   [positiveCasesViral] TEXT,
   [deathConfirmed] TEXT,
   [deathProbable] TEXT,
   [totalTestEncountersViral] TEXT,
   [totalTestsPeopleViral] TEXT,
   [totalTestsAntibody] TEXT,
   [positiveTestsAntibody] TEXT,
   [negativeTestsAntibody] TEXT,
   [totalTestsPeopleAntibody] TEXT,
   [positiveTestsPeopleAntibody] TEXT,
   [negativeTestsPeopleAntibody] TEXT,
   [totalTestsPeopleAntigen] TEXT,
   [positiveTestsPeopleAntigen] TEXT,
   [totalTestsAntigen] TEXT,
   [positiveTestsAntigen] TEXT,
   [fips] INTEGER,
   [positiveIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [total] INTEGER,
   [totalTestResultsSource] TEXT,
   [totalTestResultsIncrease] INTEGER,
   [posNeg] INTEGER,
   [deathIncrease] INTEGER,
   [hospitalizedIncrease] INTEGER,
   [hash] TEXT,
   [commercialScore] INTEGER,
   [negativeRegularScore] INTEGER,
   [negativeScore] INTEGER,
   [positiveScore] INTEGER,
   [score] INTEGER,
   [grade] TEXT
);