states_current
Data source: Big Local News · About: big-local-datasette
31 rows where deathProbable = "" sorted by totalTestsPeopleViral
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, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, positiveIncrease, negativeIncrease, totalTestResultsSource, totalTestResultsIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||
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 | ||||||||||||||||||||||||
12 | 12 | 20200926 | GA | 313873 | 2558482 | 2872355 | 1831 | 28153 | 5176 | A | 9/26/2020 14:50 | 2020-09-26T14:50:00Z | 09/26 10:50 | 6914 | 28153 | 2020-09-26T14:50:00Z | 2872355 | 292318 | 2580037 | 313873 | 299555 | 24723 | 13 | 1359 | 23502 | 2872355 | posNeg | 24861 | 2872355 | 40 | 118 | 9ab79841fa3a6c3d058ce3f94b9671540d5a8880 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
30 | 30 | 20200926 | MT | 11907 | 317378 | 329285 | 147 | 684 | 8749 | C | 9/26/2020 01:59 | 2020-09-26T01:59:00Z | 09/25 21:59 | 171 | 684 | 2020-09-26T01:59:00Z | 329285 | 11907 | 30 | 343 | 2826 | 329285 | posNeg | 3169 | 329285 | 1 | 9 | 2b25a5d9191b4d38560392a23353c41e646042be | 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 | ||||||||||||||||||||||
36 | 36 | 20200926 | NM | 28487 | 865002 | 893489 | 75 | 3420 | 16020 | C | 9/25/2020 17:50 | 2020-09-25T17:50:00Z | 09/25 13:50 | 865 | 3420 | 2020-09-25T17:50:00Z | 893489 | 28487 | 35 | 263 | 7853 | 893489 | posNeg | 8116 | 893489 | 6 | 18 | ca61662b5c3adb6ac3a1bd588dfa0ca45978ca5b | 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 | ||||||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||||||||||
53 | 53 | 20200926 | WA | 85226 | 1715795 | 1801021 | 264 | 7412 | 28 | B | 9/25/2020 02:59 | 2020-09-25T02:59:00Z | 09/24 22:59 | 2100 | 7412 | 2020-09-25T02:59:00Z | 85226 | 2100 | 1801021 | 53 | 988 | 16754 | 1801021 | posNeg | 17742 | 1801021 | 20 | 55 | fd6ce507d03586f2b0ac32e299f88b85d7393013 | 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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||||||
34 | 34 | 20200926 | NH | 8121 | 257257 | 422591 | 18 | 734 | 232 | 7379 | B | 9/26/2020 09:00 | 2020-09-26T09:00:00Z | 09/26 05:00 | 439 | 734 | 2020-09-26T09:00:00Z | 422591 | 8121 | 265378 | 31666 | 30983 | 33 | 77 | 18150 | 265378 | posNeg | 4902 | 265378 | 1 | 2 | 55a064dd09da123029c8d41638a6b22a33f1173c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
14 | 14 | 20200926 | HI | 11891 | 278076 | 289967 | 150 | 787 | 55 | 30 | 5397 | B | 9/25/2020 18:00 | 2020-09-25T18:00:00Z | 09/25 14:00 | 127 | 787 | 2020-09-25T18:00:00Z | 402010 | 289967 | 15 | 112 | 2980 | 289967 | posNeg | 3092 | 289967 | 3 | 8 | 6244d9b33b4882c0c4fd80e6a666219eab29ae6e | 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 | |||||||||||||||||
33 | 33 | 20200926 | NE | 43162 | 397483 | 440645 | 225 | 2276 | 32238 | A | 9/25/2020 20:30 | 2020-09-25T20:30:00Z | 09/25 16:30 | 468 | 2276 | 2020-09-25T20:30:00Z | 595287 | 43162 | 440947 | 31 | 431 | 2910 | 440645 | posNeg | 3341 | 440645 | 6 | 17 | dff40db61c6d6203f6a42331a30731482bfd47e3 | 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 | ||||||||||||||||||||
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 | |||||||||||||||||||
11 | 11 | 20200926 | FL | 698682 | 4536325 | 4001 | 5235007 | 2099 | 43964 | A | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 14190 | 43964 | 2020-09-25T23:59:00Z | 7383930 | 899158 | 6443064 | 698682 | 14190 | 5242163 | 505164 | 45080 | 460024 | 493810 | 44075 | 449702 | 16485 | 12 | 2795 | 26218 | 5239008 | posNeg | 29013 | 5235007 | 107 | 171 | dc9d1e1af52716f018602f6f32d66d5e9c263c88 | 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 | |||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||
7 | 7 | 20200926 | CO | 67926 | 804806 | 1277613 | 248 | 7479 | 6404 | A | 9/25/2020 01:59 | 2020-09-25T01:59:00Z | 09/24 21:59 | 1940 | 7479 | 2020-09-25T01:59:00Z | 63137 | 1277613 | 867943 | 166415 | 11592 | 154823 | 8 | 709 | 9218 | 872732 | totalTestEncountersViral | 16752 | 872732 | 5 | 25 | e66aa724278acdbfea40842a634bf1ac4a32fa77 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
56 | 56 | 20200926 | WY | 5465 | 92406 | 97871 | 22 | 258 | 4479 | B | 9/26/2020 11:55 | 2020-09-26T11:55:00Z | 09/26 07:55 | 50 | 258 | 2020-09-26T11:55:00Z | 155082 | 4497 | 150584 | 4618 | 96991 | 56 | 45 | 0 | 97871 | posNeg | 45 | 97871 | 0 | 2 | 9c1be43cf5db286c8a903c0b3ed654e3d5b588c2 | 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 );