states_current
Data source: Big Local News · About: big-local-datasette
4 rows where deathIncrease = "1.0"
This data as json, copyable, CSV (advanced)
Suggested facets: totalTestResultsSource, hospitalizedIncrease, dateModified (date), dateChecked (date)
| Link | rowid ▼ | date | state | positive | probableCases | negative | pending | totalTestResultsSource | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | hospitalizedDischarged | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsIncrease | posNeg | dataQualityGrade | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 7 | 20210301 | CO | 429839 | 23620 | 2175502 | totalTestEncountersViral | 6229855 | 427 | 23550 | 3/1/2021 01:59 | 2021-03-01T01:59:00Z | 02/28 20:59 | 5952 | 23550 | 22700 | 2021-03-01T01:59:00Z | 406219 | 5218 | 734 | 6229855 | 2581721 | 420020 | 59574 | 358510 | 8 | 1536 | 2874 | 2605341 | 13654 | 2605341 | 1.0 | 74.0 | ba393a3166d21c1ef1b2fe881539880a24299c57 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 15 | 15 | 20210301 | IA | 280279 | 1035119 | posNeg | 1315398 | 197 | 48 | 15 | 315443 | 2/28/2021 00:00 | 2021-02-28T00:00:00Z | 02/27 19:00 | 5472 | 2021-02-28T00:00:00Z | 2711184 | 304008 | 2392446 | 280279 | 1317777 | 112011 | 18571 | 93389 | 242163 | 56368 | 1346025 | 59842 | 19 | 240 | 1329 | 1315398 | 1569 | 1315398 | 1.0 | 0.0 | 9202bb28684fedf3813600cf4aef9248f4ccd283 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
| 43 | 43 | 20210301 | PR | 100584 | 7876 | 305972 | posNeg | 406556 | 155 | 23 | 23 | 90891 | 3/1/2021 00:00 | 2021-03-01T00:00:00Z | 02/28 19:00 | 2037 | 2021-03-01T00:00:00Z | 415664 | 20103 | 395291 | 92708 | 1733 | 304 | 82090 | 72 | 287 | 0 | 406556 | 287 | 406556 | 1.0 | 0.0 | 2c21bd21482944575ccaa8e36ed63443c577c51d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 52 | 52 | 20210301 | VT | 15284 | 437 | 316758 | totalTestsViral | 1076259 | 29 | 8 | 12626 | 2/28/2021 23:59 | 2021-02-28T23:59:00Z | 02/28 18:59 | 205 | 2021-02-28T23:59:00Z | 1076259 | 14847 | 331605 | 50 | 86 | 880 | 332042 | 7960 | 332042 | 1.0 | 0.0 | 8f5315258d53de27d8b0c8c3db10d6c0b6cde646 | 0 | 0 | 0 | 0 | 0 |
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 );