states_current
Data source: Big Local News · About: big-local-datasette
1 row where onVentilatorCurrently = 119
This data as json, copyable, CSV (advanced)
Suggested facets: dateModified (date), dateChecked (date)
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_current] ( [date] INTEGER, [state] TEXT, [positive] INTEGER, [probableCases] INTEGER, [negative] INTEGER, [pending] INTEGER, [totalTestResultsSource] TEXT, [totalTestResults] INTEGER, [hospitalizedCurrently] INTEGER, [hospitalizedCumulative] INTEGER, [inIcuCurrently] INTEGER, [inIcuCumulative] INTEGER, [onVentilatorCurrently] INTEGER, [onVentilatorCumulative] INTEGER, [recovered] INTEGER, [lastUpdateEt] TEXT, [dateModified] TEXT, [checkTimeEt] TEXT, [death] INTEGER, [hospitalized] INTEGER, [hospitalizedDischarged] INTEGER, [dateChecked] TEXT, [totalTestsViral] INTEGER, [positiveTestsViral] INTEGER, [negativeTestsViral] INTEGER, [positiveCasesViral] INTEGER, [deathConfirmed] INTEGER, [deathProbable] INTEGER, [totalTestEncountersViral] INTEGER, [totalTestsPeopleViral] INTEGER, [totalTestsAntibody] INTEGER, [positiveTestsAntibody] INTEGER, [negativeTestsAntibody] INTEGER, [totalTestsPeopleAntibody] INTEGER, [positiveTestsPeopleAntibody] INTEGER, [negativeTestsPeopleAntibody] INTEGER, [totalTestsPeopleAntigen] INTEGER, [positiveTestsPeopleAntigen] INTEGER, [totalTestsAntigen] INTEGER, [positiveTestsAntigen] INTEGER, [fips] INTEGER, [positiveIncrease] INTEGER, [negativeIncrease] INTEGER, [total] INTEGER, [totalTestResultsIncrease] INTEGER, [posNeg] INTEGER, [dataQualityGrade] TEXT, [deathIncrease] FLOAT, [hospitalizedIncrease] FLOAT, [hash] TEXT, [commercialScore] INTEGER, [negativeRegularScore] INTEGER, [negativeScore] INTEGER, [positiveScore] INTEGER, [score] INTEGER, [grade] TEXT );