states_current
Data source: Big Local News · About: big-local-datasette
4 rows where deathIncrease = 6 sorted by hash
This data as json, copyable, CSV (advanced)
Suggested facets: inIcuCurrently, inIcuCumulative, onVentilatorCurrently, dataQualityGrade, deathConfirmed, deathProbable, totalTestsPeopleViral, dateModified (date), dateChecked (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39 | 39 | 20200926 | OH | 150009 | 2883978 | 3033987 | 625 | 15185 | 205 | 3247 | 95 | 129498 | A+ | 9/26/2020 14:00 | 2020-09-26T14:00:00Z | 09/26 10:00 | 4740 | 15185 | 2020-09-26T14:00:00Z | 3025649 | 141671 | 4439 | 301 | 39 | 1115 | 37279 | 3033987 | posNeg | 38394 | 3033987 | 6 | 58 | bc6ac50a6f9a24d96bc3280b69d405cfab1f7ca9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
36 | 36 | 20200926 | NM | 28487 | 865002 | 893489 | 75 | 3420 | 16020 | C | 9/25/2020 17:50 | 2020-09-25T17:50:00Z | 09/25 13:50 | 865 | 3420 | 2020-09-25T17:50:00Z | 893489 | 28487 | 35 | 263 | 7853 | 893489 | posNeg | 8116 | 893489 | 6 | 18 | ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
35 | 35 | 20200926 | NJ | 202850 | 3309718 | 3512568 | 426 | 23324 | 88 | 38 | 34650 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 16103 | 23324 | 2020-09-26T00:00:00Z | 3512568 | 202850 | 14312 | 1791 | 34 | 750 | 33107 | 3512568 | posNeg | 33857 | 3512568 | 6 | 39 | cd73d3de8c388876eca2bfe00d66d734af82857f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
33 | 33 | 20200926 | NE | 43162 | 397483 | 440645 | 225 | 2276 | 32238 | A | 9/25/2020 20:30 | 2020-09-25T20:30:00Z | 09/25 16:30 | 468 | 2276 | 2020-09-25T20:30:00Z | 595287 | 43162 | 440947 | 31 | 431 | 2910 | 440645 | posNeg | 3341 | 440645 | 6 | 17 | dff40db61c6d6203f6a42331a30731482bfd47e3 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );