states_current
Data source: Big Local News · About: big-local-datasette
3 rows where hospitalizedIncrease = 34 sorted by positiveTestsViral
This data as json, copyable, CSV (advanced)
Suggested facets: inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||
49 | 49 | 20200926 | UT | 69547 | 735532 | 805079 | 191 | 3702 | 77 | 890 | 358 | 53806 | A+ | 9/26/2020 11:02 | 2020-09-26T11:02:00Z | 09/26 07:02 | 448 | 3702 | 2020-09-26T11:02:00Z | 1037414 | 69547 | 805079 | 13698 | 1793 | 23618 | 1900 | 49 | 1017 | 8845 | 805079 | posNeg | 9862 | 805079 | 0 | 34 | 3670fa0d15d16f24a5287b6b4adede4295b71342 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
45 | 45 | 20200926 | SC | 145273 | 1097524 | 1242797 | 727 | 9028 | 186 | 99 | 69629 | A+ | 9/25/2020 11:59 | 2020-09-25T11:59:00Z | 09/25 07:59 | 3323 | 9028 | 2020-09-25T11:59:00Z | 1238862 | 181055 | 1057807 | 141338 | 3141 | 182 | 70491 | 6831 | 63660 | 39995 | 9972 | 45 | 1371 | 14959 | 1242797 | posNeg | 16330 | 1242797 | 26 | 34 | f961ffe6bba29cf00c45195b6b3d192e8cd6b734 | 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 );