states_current
Data source: Big Local News · About: big-local-datasette
11 rows where dateChecked = "2020-09-26T00:00:00Z"
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCumulative, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, dataQualityGrade, hospitalized, totalTestsViral, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, deathIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | 20200926 | AR | 80755 | 855635 | 933895 | 447 | 5202 | 213 | 91 | 657 | 72051 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1285 | 5202 | 2020-09-26T00:00:00Z | 933895 | 855635 | 78260 | 1137 | 148 | 10264 | 2706 | 21856 | 3300 | 5 | 809 | 6813 | 936390 | posNeg | 7601 | 936390 | 19 | 0 | 1177f6d15b81adb770caebd6b66b47189c93f198 | 0 | 0 | 0 | 0 | 0 | ||||||||||||
5 | 5 | 20200926 | AZ | 216826 | 1221851 | 1434227 | 509 | 22005 | 115 | 56 | 34730 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 5622 | 22005 | 2020-09-26T00:00:00Z | 212376 | 5355 | 267 | 1434227 | 290470 | 4 | 459 | 10194 | 1438677 | posNeg | 10624 | 1438677 | 35 | 33 | 130636fd317b3160d4644679abe3501863463881 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
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 | |||||||||||||||||
17 | 17 | 20200926 | IL | 288815 | 5142362 | 5431177 | 1597 | 355 | 141 | A | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 8832 | 2020-09-26T00:00:00Z | 5428688 | 286326 | 8588 | 244 | 17 | 2441 | 62776 | 5431177 | posNeg | 65217 | 5431177 | 25 | 0 | 2620e4472a6793bd94436e1e6a2f1efbe8f39315 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
20 | 20 | 20200926 | KY | 66036 | 1216560 | 1274688 | 538 | 5193 | 129 | 1511 | 11750 | B | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1154 | 5193 | 2020-09-26T00:00:00Z | 1274688 | 58128 | 1144 | 10 | 55724 | 24514 | 21 | 970 | 29298 | 1282596 | posNeg | 30060 | 1282596 | 5 | 46 | bbc51488b99291f0d9e247a91056b3ddc5af5618 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
25 | 25 | 20200926 | MI | 134373 | 3408684 | 3543057 | 558 | 139 | 52 | 95051 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 7044 | 2020-09-26T00:00:00Z | 3578584 | 169900 | 3408684 | 121427 | 6723 | 321 | 291180 | 26 | 996 | 39749 | 3543057 | posNeg | 40745 | 3543057 | 17 | 0 | 2e49e36255f6a6daef66f967af21b911b45c97ad | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
27 | 27 | 20200926 | MO | 122014 | 1167155 | 1289169 | 1101 | B | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 2063 | 2020-09-26T00:00:00Z | 1687509 | 128009 | 1556710 | 122014 | 1289169 | 74093 | 3508 | 70585 | 29 | 1716 | 14288 | 1289169 | posNeg | 16004 | 1289169 | 69 | 0 | de543358a328e51d3abdbaecc32041460021841e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
35 | 35 | 20200926 | NJ | 202850 | 3309718 | 3512568 | 426 | 23324 | 88 | 38 | 34650 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 16103 | 23324 | 2020-09-26T00:00:00Z | 3512568 | 202850 | 14312 | 1791 | 34 | 750 | 33107 | 3512568 | posNeg | 33857 | 3512568 | 6 | 39 | cd73d3de8c388876eca2bfe00d66d734af82857f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
40 | 40 | 20200926 | OK | 83510 | 1075475 | 6653 | 1158985 | 579 | 6252 | 223 | 69754 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1004 | 6252 | 2020-09-26T00:00:00Z | 1172554 | 94741 | 1075475 | 83510 | 78836 | 3997 | 40 | 990 | 17331 | 1165638 | posNeg | 18321 | 1158985 | 11 | 60 | 832a286352d7b6c33cd6f7c2aca41c1e843e62b5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
43 | 43 | 20200926 | PR | 45413 | 305972 | 351385 | 342 | 59 | 33 | C | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 642 | 2020-09-26T00:00:00Z | 310546 | 7002 | 303412 | 22164 | 471 | 171 | 23249 | 72 | 508 | 0 | 351385 | posNeg | 508 | 351385 | 7 | 0 | 347836cd67621b97708a39d1a47689f42650b1b1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
54 | 54 | 20200926 | WI | 120231 | 1393412 | 211 | 1513643 | 574 | 7041 | 161 | 1153 | 94094 | A+ | 9/26/2020 00:00 | 2020-09-26T00:00:00Z | 09/25 20:00 | 1291 | 7041 | 2020-09-26T00:00:00Z | 113645 | 1281 | 10 | 1507057 | 55 | 2902 | 9767 | 1513854 | posNeg | 12669 | 1513643 | 7 | 79 | fb3c2ebb10eddd0158608674af0e708a51da7173 | 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 );