states_current

Table actions

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

5 rows where deathIncrease = 1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, dataQualityGrade, hospitalized, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, totalTestsPeopleAntibody, hospitalizedIncrease, 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
1 1 20200926 AK 8315 434554   442869 43       14   3267 A 9/26/2020 03:59 2020-09-26T03:59:00Z 09/25 23:59 52   2020-09-26T03:59:00Z 442869 7411 435171 8315 52                           2 113 1424 442869 posNeg 1537 442869 1 0 bf7518dcc571d23d1d8206a95e1a1c12173bcb0a 0 0 0 0 0  
9 9 20200926 DC 15215 362764   377979 101   25   17   12029 A+ 9/25/2020 00:00 2020-09-25T00:00:00Z 09/24 20:00 624   2020-09-25T00:00:00Z             377979 211599                     11 52 4341 377979 posNeg 4393 377979 1 0 5dd3065a746eea8ae0e9a70d3218cd0129db3054 0 0 0 0 0  
16 16 20200926 ID 39757 262420   298652 135 1795 44 451     21291 A 9/25/2020 18:55 2020-09-25T18:55:00Z 09/25 14:55 458 1795 2020-09-25T18:55:00Z 298652     36232 421 37                         16 523 1772 302177 posNeg 2240 302177 1 29 71c4c31498029adf59faba29c2c940f819b1402a 0 0 0 0 0  
30 30 20200926 MT 11907 317378   329285 147 684         8749 C 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 171 684 2020-09-26T01:59:00Z 329285     11907                             30 343 2826 329285 posNeg 3169 329285 1 9 2b25a5d9191b4d38560392a23353c41e646042be 0 0 0 0 0  
34 34 20200926 NH 8121 257257   422591 18 734   232     7379 B 9/26/2020 09:00 2020-09-26T09:00:00Z 09/26 05:00 439 734 2020-09-26T09:00:00Z 422591     8121       265378 31666     30983             33 77 18150 265378 posNeg 4902 265378 1 2 55a064dd09da123029c8d41638a6b22a33f1173c 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
);