states_current
Data source: Big Local News · About: big-local-datasette
4 rows where deathIncrease = 2
This data as json, copyable, CSV (advanced)
Suggested facets: hospitalizedCumulative, onVentilatorCurrently, dataQualityGrade, hospitalized, deathConfirmed, deathProbable, totalTestsAntibody, positiveTestsAntibody, hospitalizedIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | 20200926 | DE | 20156 | 260243 | 280399 | 57 | 10 | 10541 | A+ | 9/25/2020 18:00 | 2020-09-25T18:00:00Z | 09/25 14:00 | 633 | 2020-09-25T18:00:00Z | 19103 | 556 | 77 | 280399 | 10 | 71 | 954 | 280399 | posNeg | 1025 | 280399 | 2 | 0 | e3e0fc4116a2a29665fe6bffd51a89a13780977a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
13 | 13 | 20200926 | GU | 2354 | 46365 | 48719 | 30 | 9 | 1668 | A | 9/26/2020 09:45 | 2020-09-26T09:45:00Z | 09/26 05:45 | 43 | 2020-09-26T09:45:00Z | 48254 | 2354 | 48719 | 179 | 3 | 66 | 68 | 395 | 48719 | posNeg | 463 | 48719 | 2 | 0 | 7185eba890dd8a1d9ad81f1a7efd70101c32b967 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
46 | 46 | 20200926 | SD | 21133 | 165001 | 186134 | 213 | 1434 | 17173 | A | 9/25/2020 14:00 | 2020-09-25T14:00:00Z | 09/25 10:00 | 218 | 1434 | 2020-09-25T14:00:00Z | 260219 | 186134 | 46 | 579 | 1608 | 186134 | posNeg | 2187 | 186134 | 2 | 34 | ca6a7392a4ed3947a93b80040d2c4fffc4abcbe2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
55 | 55 | 20200926 | WV | 15158 | 527133 | 542291 | 174 | 56 | 31 | 11121 | C | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 332 | 2020-09-25T23:59:00Z | 541883 | 14750 | 329 | 3 | 17205 | 54 | 205 | 6692 | 542291 | posNeg | 6897 | 542291 | 2 | 0 | a4823873f7e477ab8b531c7edd4b61423f7dbfdb | 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 );