states_current
Data source: Big Local News · About: big-local-datasette
3 rows where deathIncrease = 4 sorted by grade
This data as json, copyable, CSV (advanced)
Suggested facets: dataQualityGrade, negativeTestsViral, totalTestEncountersViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15 | 15 | 20200926 | IA | 82944 | 667954 | 750898 | 334 | 84 | 29 | 65490 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1311 | 2020-09-26T00:00:00Z | 82944 | 752449 | 57997 | 3389 | 54568 | 20350 | 2645 | 19 | 899 | 5018 | 750898 | posNeg | 5917 | 750898 | 4 | 0 | 47decf503735f781b057e655041ca39b2b4fb714 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
38 | 38 | 20200926 | NY | 454760 | 9968656 | 10423416 | 527 | 89995 | 164 | 75 | 76528 | A | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 25450 | 89995 | 2020-09-25T23:59:00Z | 454760 | 10423416 | 36 | 1005 | 98948 | 10423416 | posNeg | 99953 | 10423416 | 4 | 0 | bb7957fb78d761d4366fb1503123856475c70689 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
41 | 41 | 20200926 | OR | 32581 | 636090 | 668671 | 199 | 2496 | 40 | 14 | 5490 | A+ | 9/26/2020 03:01 | 2020-09-26T03:01:00Z | 09/25 23:01 | 546 | 2496 | 2020-09-26T03:01:00Z | 636090 | 30742 | 661334 | 41 | 267 | 5498 | 668671 | posNeg | 5765 | 668671 | 4 | 0 | 76f49d2ef6b4e575aed9232f25aefd8711244bf3 | 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 );