states_current
Data source: Big Local News · About: big-local-datasette
28 rows where hospitalizedIncrease = 0
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, recovered, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, positiveIncrease, negativeIncrease, totalTestResultsSource, totalTestResultsIncrease, deathIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 20200926 | AK | 8315 | 434554 | 442869 | 43 | 14 | 3267 | A | 9/26/2020 03:59 | 2020-09-26T03:59:00Z | 09/25 23:59 | 52 | 2020-09-26T03:59:00Z | 442869 | 7411 | 435171 | 8315 | 52 | 2 | 113 | 1424 | 442869 | posNeg | 1537 | 442869 | 1 | 0 | bf7518dcc571d23d1d8206a95e1a1c12173bcb0a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
2 | 2 | 20200926 | AL | 151591 | 970048 | 1104932 | 709 | 16852 | 1791 | 1007 | 64583 | A | 9/26/2020 11:00 | 2020-09-26T11:00:00Z | 09/26 07:00 | 2501 | 16852 | 2020-09-26T11:00:00Z | 1104932 | 134884 | 2364 | 137 | 57800 | 1 | 933 | 6684 | 1121639 | posNeg | 7337 | 1121639 | 10 | 0 | 88370a431af70a13b1499a5cd6afe94a14fc9fb3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
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 | ||||||||||||
4 | 4 | 20200926 | AS | 0 | 1571 | 1571 | D | 9/1/2020 00:00 | 2020-09-01T00:00:00Z | 08/31 20:00 | 0 | 2020-09-01T00:00:00Z | 1571 | 0 | 60 | 0 | 0 | 1571 | posNeg | 0 | 1571 | 0 | 0 | b9eccb7369bdc4ee75708c7a892c5437ab915d83 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
6 | 6 | 20200926 | CA | 798237 | 13384493 | 14182730 | 3203 | 862 | B | 9/26/2020 02:59 | 2020-09-26T02:59:00Z | 09/25 22:59 | 15532 | 2020-09-26T02:59:00Z | 14182730 | 798237 | 6 | 4197 | 126286 | 14182730 | posNeg | 130483 | 14182730 | 134 | 0 | bc22d39302ce5646a61aef19adbfa503f5de5e76 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8 | 8 | 20200926 | CT | 56587 | 1462564 | 1519151 | 76 | 11560 | 9310 | B | 9/24/2020 20:30 | 2020-09-24T20:30:00Z | 09/24 16:30 | 4501 | 11560 | 2020-09-24T20:30:00Z | 1516780 | 54216 | 3604 | 897 | 9 | 0 | 0 | 1519151 | posNeg | 0 | 1519151 | 0 | 0 | 597a6f3bd03d5e8297830e769c3da2cb90e767e7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
9 | 9 | 20200926 | DC | 15215 | 362764 | 377979 | 101 | 25 | 17 | 12029 | A+ | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 624 | 2020-09-25T00:00:00Z | 377979 | 211599 | 11 | 52 | 4341 | 377979 | posNeg | 4393 | 377979 | 1 | 0 | 5dd3065a746eea8ae0e9a70d3218cd0129db3054 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
10 | 10 | 20200926 | DE | 20156 | 260243 | 280399 | 57 | 10 | 10541 | A+ | 9/25/2020 18:00 | 2020-09-25T18:00:00Z | 09/25 14:00 | 633 | 2020-09-25T18:00:00Z | 19103 | 556 | 77 | 280399 | 10 | 71 | 954 | 280399 | posNeg | 1025 | 280399 | 2 | 0 | e3e0fc4116a2a29665fe6bffd51a89a13780977a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
13 | 13 | 20200926 | GU | 2354 | 46365 | 48719 | 30 | 9 | 1668 | A | 9/26/2020 09:45 | 2020-09-26T09:45:00Z | 09/26 05:45 | 43 | 2020-09-26T09:45:00Z | 48254 | 2354 | 48719 | 179 | 3 | 66 | 68 | 395 | 48719 | posNeg | 463 | 48719 | 2 | 0 | 7185eba890dd8a1d9ad81f1a7efd70101c32b967 | 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 | |||||||||||||||||||||
19 | 19 | 20200926 | KS | 56592 | 446178 | 502770 | 343 | 2816 | 121 | 768 | 34 | 250 | 2039 | A+ | 9/25/2020 10:00 | 2020-09-25T10:00:00Z | 09/25 06:00 | 632 | 2816 | 2020-09-25T10:00:00Z | 502770 | 20 | 0 | 0 | 502770 | posNeg | 0 | 502770 | 0 | 0 | 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
21 | 21 | 20200926 | LA | 165152 | 2090913 | 2256065 | 570 | 86 | 149640 | A | 9/25/2020 13:00 | 2020-09-25T13:00:00Z | 09/25 09:00 | 5444 | 2020-09-25T13:00:00Z | 163928 | 5262 | 182 | 2254841 | 22 | 0 | 0 | 2256065 | posNeg | 0 | 2256065 | 0 | 0 | bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f | 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 | |||||||||||||||||||
28 | 28 | 20200926 | MP | 69 | 14776 | 14845 | 4 | 29 | D | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 2 | 4 | 2020-09-25T00:00:00Z | 19835 | 69 | 2 | 14845 | 69 | 0 | 0 | 14845 | posNeg | 0 | 14845 | 0 | 0 | 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
29 | 29 | 20200926 | MS | 96677 | 634036 | 730713 | 601 | 5607 | 147 | 68 | 85327 | A+ | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 2911 | 5607 | 2020-09-25T00:00:00Z | 723389 | 89353 | 2686 | 225 | 38425 | 95 | 55557 | 28 | 645 | 3682 | 730713 | posNeg | 4327 | 730713 | 17 | 0 | 25c406301ef686539186978256312931e29136fe | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
31 | 31 | 20200926 | NC | 206090 | 2741713 | 2947803 | 914 | 272 | 176422 | A+ | 9/26/2020 12:00 | 2020-09-26T12:00:00Z | 09/26 08:00 | 3440 | 2020-09-26T12:00:00Z | 2943144 | 201431 | 3440 | 37 | 1759 | 38427 | 2947803 | posNeg | 40186 | 2947803 | 31 | 0 | 20a1b19461a3df0fea54c6dfb6ffc967453a835b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
37 | 37 | 20200926 | NV | 78355 | 607323 | 685678 | 442 | 125 | 64 | 2075 | A+ | 9/26/2020 02:59 | 2020-09-26T02:59:00Z | 09/25 22:59 | 1582 | 2020-09-26T02:59:00Z | 1026486 | 78355 | 684796 | 32 | 602 | 3740 | 685678 | posNeg | 4342 | 685678 | 9 | 0 | 6562d5250f6a1ba7ad8affc64c3a68a2b09dd5cd | 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 | |||||||||||||||||||
42 | 42 | 20200926 | PA | 155232 | 1830292 | 1985524 | 444 | 60 | 127290 | A+ | 9/26/2020 12:00 | 2020-09-26T12:00:00Z | 09/26 08:00 | 8103 | 2020-09-26T12:00:00Z | 2898629 | 150393 | 1980685 | 42 | 1029 | 13895 | 1985524 | posNeg | 14924 | 1985524 | 22 | 0 | 95db3b8c62ccc9249c12e799648a8351f5b7337f | 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 | ||||||||||||||||||
44 | 44 | 20200926 | RI | 24181 | 305853 | 727469 | 94 | 2725 | 8 | 4 | 2278 | A+ | 9/25/2020 12:00 | 2020-09-25T12:00:00Z | 09/25 08:00 | 1107 | 2725 | 2020-09-25T12:00:00Z | 34299 | 693170 | 24181 | 727469 | 330034 | 44 | 0 | 0 | 330034 | totalTestEncountersViral | 0 | 330034 | 0 | 0 | e5a147d241db0ad3830218c1038dc29b79d42bcc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
48 | 48 | 20200926 | TX | 733438 | 5261375 | 5994813 | 3209 | 1056 | 649580 | A | 9/26/2020 16:20 | 2020-09-26T16:20:00Z | 09/26 12:20 | 15485 | 2020-09-26T16:20:00Z | 5994813 | 733438 | 399337 | 35847 | 80294 | 9297 | 48 | 4886 | 76478 | 5994813 | posNeg | 81364 | 5994813 | 121 | 0 | 118422653c167fc9d3ed0bd4ad4d2a32d4f6a49a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
51 | 51 | 20200926 | VI | 1296 | 18676 | 8 | 19972 | 1209 | D | 9/25/2020 09:30 | 2020-09-25T09:30:00Z | 09/25 05:30 | 19 | 2020-09-25T09:30:00Z | 19980 | 19 | 78 | 0 | 0 | 19980 | posNeg | 0 | 19972 | 0 | 0 | 61739fb2efab7827062ca9cc633984208f34bc24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
52 | 52 | 20200926 | VT | 1739 | 158537 | 160276 | 1 | 1580 | B | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 58 | 2020-09-25T23:59:00Z | 1739 | 58 | 160276 | 50 | 8 | 989 | 160276 | posNeg | 997 | 160276 | 0 | 0 | 21dc4138bae65a1c22e9f7756f9fd545cb820bea | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
55 | 55 | 20200926 | WV | 15158 | 527133 | 542291 | 174 | 56 | 31 | 11121 | C | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 332 | 2020-09-25T23:59:00Z | 541883 | 14750 | 329 | 3 | 17205 | 54 | 205 | 6692 | 542291 | posNeg | 6897 | 542291 | 2 | 0 | a4823873f7e477ab8b531c7edd4b61423f7dbfdb | 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 );