states_current
Data source: Big Local News · About: big-local-datasette
5 rows where deathIncrease = 1 sorted by totalTestResultsSource
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)
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
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 );