states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
70 rows where "dateModified" is on date 2020-04-19 sorted by negativeScore
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8348 | 8348 | 20200430 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | c1a6f2573d586d2f3df990eeb447fa0d07b5af9a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8404 | 8404 | 20200429 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | f9a5ef42aad60ea58048469affccfb21a0262fab | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8460 | 8460 | 20200428 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 2b6a7a6ded23ac7189ccf983ce335e5b5dd3fa34 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8516 | 8516 | 20200427 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 5c3294ac17a9c944bbbd0e606dccfe5d6974ab79 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8572 | 8572 | 20200426 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | ab3f599f5e6ae04418fa318ab0b07e7a0e35f1f9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8628 | 8628 | 20200425 | AS | 0 | 3 | 17 | 3 | F | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 0 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 0567a4c733d322eb79264f00446f0bd37d4619a8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8684 | 8684 | 20200424 | AS | 0 | 3 | 17 | 3 | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 2020-04-19T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 20 | posNeg | 0 | 3 | 0 | 0 | 658893a7d3d87219411073fcaccfe66d7d51cb62 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8910 | 8910 | 20200420 | CA | 30978 | 259522 | 290500 | 4674 | 1480 | B | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 1208 | 2020-04-19T00:00:00Z | 290500 | 6 | 645 | 8955 | 290500 | posNeg | 9600 | 290500 | 42 | 0 | 2c5e388cfe93451ae84d71d05ed96bd3e7771255 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8913 | 8913 | 20200420 | DC | 2927 | 11186 | 14113 | 402 | 120 | 69 | 630 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 105 | 2020-04-19T00:00:00Z | 14113 | 11 | 134 | 280 | 14113 | posNeg | 414 | 14113 | 9 | 0 | 0a3c51edd8707186790404a258b6a08f6fe84824 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8918 | 8918 | 20200420 | HI | 580 | 23595 | 24175 | 52 | 414 | A | 4/19/2020 18:00 | 2020-04-19T18:00:00Z | 04/19 14:00 | 10 | 52 | 2020-04-19T18:00:00Z | 15 | 6 | 699 | 24175 | posNeg | 705 | 24175 | 1 | 1 | 07e3c31c25c6aaf87ece82fa287f9f1d39804111 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8919 | 8919 | 20200420 | IA | 3159 | 22661 | 25820 | 214 | 91 | 58 | 1235 | A | 4/19/2020 12:00 | 2020-04-19T12:00:00Z | 04/19 08:00 | 79 | 2020-04-19T12:00:00Z | 3159 | 19 | 257 | 1013 | 25820 | posNeg | 1270 | 25820 | 4 | 0 | cfae49febf3e2bd4fe6c5b8cacd8fcf89d35225a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8920 | 8920 | 20200420 | ID | 1672 | 15773 | 17445 | 53 | 151 | 53 | 585 | A | 4/19/2020 19:00 | 2020-04-19T19:00:00Z | 04/19 15:00 | 45 | 151 | 2020-04-19T19:00:00Z | 17445 | 16 | 4 | 0 | 17445 | posNeg | 4 | 17445 | 1 | 0 | aaa32cfb146bdf1edbf3e296567571ed6d3a76b0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8922 | 8922 | 20200420 | IN | 11686 | 52953 | 64639 | 669 | 353 | B | 4/19/2020 23:59 | 2020-04-19T23:59:00Z | 04/19 19:59 | 569 | 2020-04-19T23:59:00Z | 18 | 476 | 3021 | 64639 | posNeg | 3497 | 64639 | 7 | 0 | 2b43a5cd0a66279fcf0b3b1e1702e1e757cb8437 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8924 | 8924 | 20200420 | KY | 2960 | 29612 | 32572 | 274 | 1059 | 155 | 534 | 1174 | A | 4/19/2020 17:00 | 2020-04-19T17:00:00Z | 04/19 13:00 | 148 | 1059 | 2020-04-19T17:00:00Z | 32572 | 21 | 253 | 94 | 32572 | posNeg | 347 | 32572 | 4 | 0 | 3add042e588c1c4d9e1b5216eb8f82440e7ed08a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8926 | 8926 | 20200420 | MA | 41416 | 136046 | 220251 | 3872 | 3872 | 987 | B | 4/19/2020 16:00 | 2020-04-19T16:00:00Z | 04/19 12:00 | 2303 | 3872 | 2020-04-19T16:00:00Z | 220251 | 51550 | 25 | 1596 | 6751 | 177462 | totalTestsViral | 12963 | 177462 | 157 | 83 | 136775c5d3e677e431c2e6b185bb90c396998c4b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8933 | 8933 | 20200420 | MS | 4512 | 46922 | 51434 | 548 | 819 | 146 | 89 | A | 4/19/2020 19:00 | 2020-04-19T19:00:00Z | 04/19 15:00 | 169 | 819 | 2020-04-19T19:00:00Z | 28 | 238 | 12131 | 51434 | posNeg | 12369 | 51434 | 10 | 11 | ad237861fa95f0ae697cb1d28245753042fb5ced | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8937 | 8937 | 20200420 | NE | 1474 | 14206 | 15680 | A | 4/19/2020 19:45 | 2020-04-19T19:45:00Z | 04/19 15:45 | 28 | 2020-04-19T19:45:00Z | 15756 | 31 | 187 | 918 | 15680 | posNeg | 1105 | 15680 | 0 | 0 | 774fd0bbb3315869c6549bfa7cebb7af8a6ced58 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8938 | 8938 | 20200420 | NH | 1392 | 12726 | 298 | 15354 | 79 | 198 | 521 | B | 4/19/2020 09:00 | 2020-04-19T09:00:00Z | 04/19 05:00 | 41 | 198 | 2020-04-19T09:00:00Z | 15354 | 33 | 50 | 644 | 14416 | posNeg | 653 | 14118 | 3 | 6 | 0ae9ffc1b936c8bbc2f3681b868f2bce83aa08ee | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8940 | 8940 | 20200420 | NM | 1845 | 35197 | 37042 | 103 | 274 | 487 | A | 4/19/2020 18:46 | 2020-04-19T18:46:00Z | 04/19 14:46 | 55 | 274 | 2020-04-19T18:46:00Z | 35 | 47 | 363 | 37042 | posNeg | 410 | 37042 | 2 | 16 | c7bbc845b929d4baa6ea486c3cff83e623ffa1c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8949 | 8949 | 20200420 | SC | 4377 | 36103 | 40480 | 776 | 2063 | B | 4/19/2020 15:30 | 2020-04-19T15:30:00Z | 04/19 11:30 | 120 | 776 | 2020-04-19T15:30:00Z | 4377 | 45 | 0 | 0 | 40480 | posNeg | 0 | 40480 | 0 | 0 | ab30e06ef7673b6875e55f08020429fd9a985608 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8950 | 8950 | 20200420 | SD | 1685 | 10641 | 0 | 12326 | 87 | 709 | A | 4/19/2020 18:00 | 2020-04-19T18:00:00Z | 04/19 14:00 | 7 | 87 | 2020-04-19T18:00:00Z | 12326 | 46 | 50 | 214 | 12326 | posNeg | 264 | 12326 | 0 | 13 | 494885f226f3b50372a3f796c21d7b831b0f3736 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8955 | 8955 | 20200420 | VI | 53 | 554 | 18 | 607 | 48 | 4/19/2020 20:30 | 2020-04-19T20:30:00Z | 04/19 16:30 | 3 | 2020-04-19T20:30:00Z | 78 | 0 | 6 | 625 | posNeg | 6 | 607 | 0 | 0 | 355bb9fc91c1e70863c4bece1f4d3068bfa8d276 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8960 | 8960 | 20200420 | WY | 313 | 7073 | 7386 | 19 | 51 | 233 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 2 | 51 | 2020-04-19T00:00:00Z | 313 | 56 | 4 | 101 | 7386 | posNeg | 105 | 7386 | 0 | 1 | ec7a55bbc2552b4bc293dd87f71475985262927c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8962 | 8962 | 20200419 | AL | 4837 | 40875 | 45712 | 360 | 641 | 260 | 157 | B | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 154 | 641 | 2020-04-19T00:00:00Z | 45712 | 4837 | 1 | 182 | 2992 | 45712 | posNeg | 3174 | 45712 | 8 | 21 | 8f22f1dca82d968f25138a352ae33a9053720007 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8963 | 8963 | 20200419 | AR | 1781 | 22428 | 24209 | 88 | 291 | 25 | 57 | 721 | A | 4/19/2020 18:47 | 2020-04-19T18:47:00Z | 04/19 14:47 | 40 | 291 | 2020-04-19T18:47:00Z | 24209 | 1781 | 5 | 42 | 26 | 24209 | posNeg | 68 | 24209 | 2 | 0 | cf34383bbb20d454d380d29d402c82baca0323e2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8965 | 8965 | 20200419 | AZ | 4929 | 48061 | 52990 | 631 | 1387 | 283 | 187 | 994 | B | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 184 | 1387 | 2020-04-19T00:00:00Z | 52990 | 4 | 210 | 1735 | 52990 | posNeg | 1945 | 52990 | 7 | 46 | 73ebf1373faf4c93b33ec49bace7adb8b54ac779 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8968 | 8968 | 20200419 | CT | 17550 | 40663 | 58213 | 1938 | A | 4/19/2020 17:00 | 2020-04-19T17:00:00Z | 04/19 13:00 | 1086 | 2020-04-19T17:00:00Z | 59759 | 671 | 9 | 741 | 2010 | 58213 | posNeg | 2751 | 58213 | 50 | 0 | a95bcf6504c6f97d409a1d8323aae7c75c7d3e3d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8971 | 8971 | 20200419 | FL | 25996 | 230083 | 1179 | 256079 | 3930 | A | 4/19/2020 16:12 | 2020-04-19T16:12:00Z | 04/19 12:12 | 781 | 3930 | 2020-04-19T16:12:00Z | 12 | 727 | 8825 | 257258 | posNeg | 9552 | 256079 | 27 | 88 | abd36f3b199b775b4e69b8eec704b021c07527eb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8972 | 8972 | 20200419 | GA | 18301 | 61632 | 79933 | 3464 | A | 4/19/2020 21:34 | 2020-04-19T21:34:00Z | 04/19 17:34 | 687 | 3464 | 2020-04-19T21:34:00Z | 79933 | 13 | 632 | 5093 | 79933 | posNeg | 5725 | 79933 | 14 | 44 | 068aab9c2685732c84aff2c09f3e36898407b12b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8973 | 8973 | 20200419 | GU | 133 | 943 | 1076 | 6 | 2 | 112 | 4/19/2020 05:00 | 2020-04-19T05:00:00Z | 04/19 01:00 | 5 | 2020-04-19T05:00:00Z | 133 | 66 | 0 | 0 | 1076 | posNeg | 0 | 1076 | 0 | 0 | 58b79f8eda272899805deee0340d95e46d972268 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8974 | 8974 | 20200419 | HI | 574 | 22896 | 23470 | 51 | 410 | A | 4/19/2020 18:00 | 2020-04-19T18:00:00Z | 04/19 14:00 | 9 | 51 | 2020-04-19T18:00:00Z | 15 | 21 | 1106 | 23470 | posNeg | 1127 | 23470 | 0 | 3 | 98983f2e956366b81c6dab69e8d6136714a2109a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8976 | 8976 | 20200419 | ID | 1668 | 15773 | 17441 | 43 | 151 | 53 | 520 | A | 4/19/2020 19:00 | 2020-04-19T19:00:00Z | 04/19 15:00 | 44 | 151 | 2020-04-19T19:00:00Z | 17441 | 16 | 13 | 481 | 17441 | posNeg | 494 | 17441 | 1 | 0 | 2af053829727ccfedd6c61c8a900efdb5cb1e843 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8977 | 8977 | 20200419 | IL | 30357 | 112961 | 143318 | 4314 | 1196 | 749 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 1290 | 2020-04-19T00:00:00Z | 17 | 1197 | 4717 | 143318 | posNeg | 5914 | 143318 | 31 | 0 | f5e276e018ef28cae9f1f44a4a0ff38f9c06fc82 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8979 | 8979 | 20200419 | KS | 1849 | 16281 | 18130 | 390 | B | 4/19/2020 12:00 | 2020-04-19T12:00:00Z | 04/19 08:00 | 92 | 390 | 2020-04-19T12:00:00Z | 20 | 59 | 395 | 18130 | posNeg | 454 | 18130 | 6 | 7 | f6a533c13c6aa4a7e988180e402ad8dc04044a54 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8980 | 8980 | 20200419 | KY | 2707 | 29518 | 32225 | 274 | 1059 | 155 | 534 | 1174 | A | 4/19/2020 17:00 | 2020-04-19T17:00:00Z | 04/19 13:00 | 144 | 1059 | 2020-04-19T17:00:00Z | 32225 | 21 | 185 | 1444 | 32225 | posNeg | 1629 | 32225 | 7 | 51 | 24a9dc5a7987e0e9f8ac72fe3b72830bfd2e67b9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8981 | 8981 | 20200419 | LA | 23928 | 111420 | 135348 | 1748 | 349 | A | 4/19/2020 13:00 | 2020-04-19T13:00:00Z | 04/19 09:00 | 1296 | 2020-04-19T13:00:00Z | 23928 | 22 | 348 | -2999 | 135348 | posNeg | -2651 | 135348 | 29 | 0 | 646f35fc8741b0f22b014a34a5a6b9155fe59690 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
8982 | 8982 | 20200419 | MA | 39820 | 129295 | 207288 | 3789 | 3789 | 987 | B | 4/19/2020 16:00 | 2020-04-19T16:00:00Z | 04/19 12:00 | 2146 | 3789 | 2020-04-19T16:00:00Z | 207288 | 48441 | 25 | 2293 | 4691 | 169115 | totalTestsViral | 5596 | 169115 | 163 | 61 | 7b5d697282eff6449d622e3bcdb41d164a6a8270 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8983 | 8983 | 20200419 | MD | 12830 | 55061 | 67891 | 2886 | 914 | A | 4/19/2020 10:00 | 2020-04-19T10:00:00Z | 04/19 06:00 | 626 | 2886 | 2020-04-19T10:00:00Z | 75989 | 15669 | 12830 | 592 | 34 | 24 | 522 | 1999 | 67891 | posNeg | 2521 | 67891 | 44 | 129 | a4da0950bb6e6ddd1923c952b760c9308b10c7d2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8984 | 8984 | 20200419 | ME | 867 | 14076 | 14943 | 46 | 136 | 18 | 9 | 393 | A | 4/19/2020 11:15 | 2020-04-19T11:15:00Z | 04/19 07:15 | 34 | 136 | 2020-04-19T11:15:00Z | 867 | 23 | 20 | 0 | 14943 | posNeg | 20 | 14943 | 2 | 0 | 3fe023000a2d6a63ba46e2835cb5231bbcfb8827 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8985 | 8985 | 20200419 | MI | 37557 | 89758 | 127315 | 3403 | 1344 | 1115 | 3237 | B | 4/19/2020 11:00 | 2020-04-19T11:00:00Z | 04/19 07:00 | 3236 | 2020-04-19T11:00:00Z | 130677 | 40919 | 89758 | 36293 | 3178 | 160 | 26 | 528 | 2644 | 127315 | posNeg | 3172 | 127315 | 129 | 0 | 728a80747f8c71d0a8a0cb57094922ae203d67cf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
8986 | 8986 | 20200419 | MN | 2914 | 46288 | 49202 | 228 | 574 | 116 | 226 | 1026 | A | 4/19/2020 12:00 | 2020-04-19T12:00:00Z | 04/19 08:00 | 134 | 574 | 2020-04-19T12:00:00Z | 2914 | 49202 | 27 | 126 | 1106 | 49202 | posNeg | 1232 | 49202 | 13 | 13 | 3f63abec83761b545e5c87f168bcad48978aa30b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8987 | 8987 | 20200419 | MO | 5667 | 48242 | 53909 | 875 | A | 4/19/2020 15:00 | 2020-04-19T15:00:00Z | 04/19 11:00 | 176 | 2020-04-19T15:00:00Z | 56834 | 6457 | 50308 | 5667 | 11 | 2 | 9 | 29 | 150 | 0 | 53909 | posNeg | 150 | 53909 | 1 | 0 | acf03091066cbdae2a6fa618eef817e21683cb2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8988 | 8988 | 20200419 | MP | 14 | 42 | 4 | 56 | 9 | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 2 | 2020-04-19T00:00:00Z | 69 | 0 | 0 | 60 | posNeg | 0 | 56 | 0 | 0 | 59dcf2c4e86e01978c41e4beb9beb5689fcf7958 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8990 | 8990 | 20200419 | MT | 433 | 10465 | 10898 | 18 | 55 | 243 | A | 4/19/2020 11:40 | 2020-04-19T11:40:00Z | 04/19 07:40 | 10 | 55 | 2020-04-19T11:40:00Z | 10898 | 30 | 7 | 322 | 10898 | posNeg | 329 | 10898 | 0 | 0 | c41f28d6a4ce2a37e40744f2f07a7d4a88e72bc3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8991 | 8991 | 20200419 | NC | 6493 | 72279 | 78772 | 465 | A | 4/19/2020 11:00 | 2020-04-19T11:00:00Z | 04/19 07:00 | 172 | 2020-04-19T11:00:00Z | 37 | 353 | 2208 | 78772 | posNeg | 2561 | 78772 | 8 | 0 | 1d68b2a7f2ad2b78db5955b972ed8ade9ac5199d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8992 | 8992 | 20200419 | ND | 584 | 13045 | 14257 | 15 | 51 | 189 | B | 4/19/2020 13:00 | 2020-04-19T13:00:00Z | 04/19 09:00 | 10 | 51 | 2020-04-19T13:00:00Z | 14458 | 584 | 14257 | 13277 | 38 | 56 | 610 | 13629 | totalTestEncountersViral | 932 | 13629 | 1 | 4 | 7dcab45ab2036f14b13a31d8df5e0d4381d5b8a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
8993 | 8993 | 20200419 | NE | 1287 | 13288 | 14575 | A | 4/19/2020 19:45 | 2020-04-19T19:45:00Z | 04/19 15:45 | 28 | 2020-04-19T19:45:00Z | 14652 | 31 | 149 | 749 | 14575 | posNeg | 898 | 14575 | 4 | 0 | d67ba0ef6bfcb677ccd2818b00464ea396114d13 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
8994 | 8994 | 20200419 | NH | 1342 | 12082 | 316 | 14701 | 85 | 192 | 513 | B | 4/19/2020 09:00 | 2020-04-19T09:00:00Z | 04/19 05:00 | 38 | 192 | 2020-04-19T09:00:00Z | 14701 | 33 | 55 | 517 | 13740 | posNeg | 601 | 13424 | 1 | 2 | f6f420893052123c7452ab412ef7d6fb84b055db | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
8995 | 8995 | 20200419 | NJ | 85301 | 85387 | 170688 | 7494 | 1940 | 1628 | A | 4/19/2020 13:00 | 2020-04-19T13:00:00Z | 04/19 09:00 | 5313 | 2020-04-19T13:00:00Z | 85301 | 4202 | 1111 | 170688 | 34 | 3881 | 4271 | 170688 | posNeg | 8152 | 170688 | 171 | 0 | fb6935f130ab034cb443a963ebc8012c4ad8ad07 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
8996 | 8996 | 20200419 | NM | 1798 | 34834 | 36632 | 92 | 258 | 465 | A | 4/19/2020 19:46 | 2020-04-19T19:46:00Z | 04/19 15:46 | 53 | 258 | 2020-04-19T19:46:00Z | 35 | 87 | 932 | 36632 | posNeg | 1019 | 36632 | 2 | 16 | 305991033c8a948c10367141e6002ddfde074de9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
8997 | 8997 | 20200419 | NV | 3728 | 27870 | 31598 | A | 4/19/2020 11:00 | 2020-04-19T11:00:00Z | 04/19 07:00 | 172 | 2020-04-19T11:00:00Z | 38668 | 3728 | 32 | 102 | 745 | 31598 | posNeg | 847 | 31598 | 4 | 0 | 0df3d60641e71638fe3d3e27078630965d6219d8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8998 | 8998 | 20200419 | NY | 242786 | 374769 | 617555 | 16213 | 64550 | 4878 | 37596 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 13869 | 64550 | 2020-04-19T00:00:00Z | 36 | 6054 | 14969 | 617555 | posNeg | 21023 | 617555 | 507 | 1447 | cbbe74a92cf809bb2ce41fe8f96275a33462a840 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
8999 | 8999 | 20200419 | OH | 11602 | 75697 | 87299 | 2565 | 765 | B | 4/19/2020 14:00 | 2020-04-19T14:00:00Z | 04/19 10:00 | 471 | 2565 | 2020-04-19T14:00:00Z | 11292 | 453 | 18 | 39 | 1380 | 6878 | 87299 | posNeg | 8258 | 87299 | 20 | 46 | e8893c23eca3a270151372346a16c8aad4b83b66 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9000 | 9000 | 20200419 | OK | 2599 | 32966 | 35565 | 307 | 541 | 136 | 1575 | B | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 140 | 541 | 2020-04-19T00:00:00Z | 2599 | 40 | 29 | 0 | 35565 | posNeg | 29 | 35565 | 1 | 0 | c9086ad8b3ecc97a788b1a9776d17aadf26b2647 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
9001 | 9001 | 20200419 | OR | 1910 | 37128 | 39038 | 290 | 456 | 74 | 37 | A | 4/19/2020 11:00 | 2020-04-19T11:00:00Z | 04/19 07:00 | 74 | 456 | 2020-04-19T11:00:00Z | 41 | 66 | 1389 | 39038 | posNeg | 1455 | 39038 | 2 | 7 | 07fd6a364b8f86c377fcb6108c44958197ce292e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9002 | 9002 | 20200419 | PA | 32284 | 126570 | 158854 | 2634 | 657 | A | 4/19/2020 13:00 | 2020-04-19T13:00:00Z | 04/19 09:00 | 1112 | 2020-04-19T13:00:00Z | 158854 | 42 | 1215 | 3674 | 158854 | posNeg | 4889 | 158854 | 276 | 0 | bdd0d17a52cacb6e7fdccc2fd1cd209dccc7ca12 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9003 | 9003 | 20200419 | PR | 1213 | 8280 | 1839 | 9493 | 160 | A | 4/19/2020 07:00 | 2020-04-19T07:00:00Z | 04/19 03:00 | 62 | 2020-04-19T07:00:00Z | 72 | 95 | 225 | 11332 | posNeg | 320 | 9493 | 2 | 0 | 03705cc04203bb49b111309b808c4d8500b97a8c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9004 | 9004 | 20200419 | RI | 5207 | 29289 | 35950 | 298 | 605 | 66 | 37 | 244 | B | 4/19/2020 03:00 | 2020-04-19T03:00:00Z | 04/18 23:00 | 164 | 605 | 2020-04-19T03:00:00Z | 38488 | 5520 | 32968 | 5207 | 35950 | 34496 | 44 | 339 | 1762 | 34496 | totalTestEncountersViral | 2046 | 34496 | 14 | 27 | b1e6c57c6c3242f0d9816210d19343844b1b7a6a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
9005 | 9005 | 20200419 | SC | 4377 | 36103 | 40480 | 776 | 2633 | B | 4/19/2020 15:30 | 2020-04-19T15:30:00Z | 04/19 11:30 | 120 | 776 | 2020-04-19T15:30:00Z | 4377 | 45 | 131 | 1516 | 40480 | posNeg | 1647 | 40480 | 1 | 0 | 0cc0bb0b0d08c11c4ee143b6a3e6165d0d05d8a7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9006 | 9006 | 20200419 | SD | 1635 | 10427 | 0 | 12062 | 74 | 646 | A | 4/19/2020 12:30 | 2020-04-19T12:30:00Z | 04/19 08:30 | 7 | 74 | 2020-04-19T12:30:00Z | 12062 | 46 | 93 | 309 | 12062 | posNeg | 402 | 12062 | 0 | 6 | 7bd7cc151539a0a7bc78fc4b81821c2fd9e27517 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9007 | 9007 | 20200419 | TN | 7070 | 90028 | 97098 | 393 | 724 | 3344 | A | 4/19/2020 15:00 | 2020-04-19T15:00:00Z | 04/19 11:00 | 148 | 724 | 2020-04-19T15:00:00Z | 47 | 308 | 6204 | 97098 | posNeg | 6512 | 97098 | 3 | 5 | 54148829668bc2a369127c73d8cbe6c617179d8d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9008 | 9008 | 20200419 | TX | 18923 | 163787 | 182710 | 1471 | 5334 | A | 4/19/2020 13:00 | 2020-04-19T13:00:00Z | 04/19 09:00 | 477 | 2020-04-19T13:00:00Z | 18923 | 48 | 663 | 5808 | 182710 | posNeg | 6471 | 182710 | 24 | 0 | 72bde9e1080880aea67ac17123ff6be218cde65b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9009 | 9009 | 20200419 | UT | 3069 | 60486 | 63555 | 259 | 679 | A | 4/19/2020 15:00 | 2020-04-19T15:00:00Z | 04/19 11:00 | 27 | 259 | 2020-04-19T15:00:00Z | 3069 | 49 | 138 | 3473 | 63555 | posNeg | 3611 | 63555 | 2 | 8 | 95470cd7f76f013d12049d5a9ecdaa2987419d95 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9010 | 9010 | 20200419 | VA | 8537 | 46196 | 499 | 70666 | 1319 | 1422 | 388 | 231 | 1267 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 277 | 1422 | 2020-04-19T00:00:00Z | 12352 | 70666 | 51 | 484 | 2318 | 55232 | posNeg | 2706 | 54733 | 19 | 126 | 55033dfeeb6a2c825b5b09b56992a42ad93361bc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
9011 | 9011 | 20200419 | VI | 53 | 548 | 22 | 601 | 48 | 4/19/2020 20:30 | 2020-04-19T20:30:00Z | 04/19 16:30 | 3 | 2020-04-19T20:30:00Z | 78 | 0 | 158 | 623 | posNeg | 158 | 601 | 0 | 0 | e2d8cd024889ef228a904cb95210d5249763f878 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9012 | 9012 | 20200419 | VT | 817 | 11450 | 12267 | 53 | 15 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 38 | 2020-04-19T00:00:00Z | 817 | 50 | 4 | 238 | 12267 | posNeg | 242 | 12267 | 0 | 0 | 9fcd20ae1f9e4e4313dea666b205e0d9e556cfcd | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
9013 | 9013 | 20200419 | WA | 12589 | 152470 | 165059 | 586 | 193 | C | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 615 | 2020-04-19T00:00:00Z | 12589 | 165059 | 157116 | 53 | 96 | 1871 | 165059 | posNeg | 1967 | 165059 | 17 | 0 | 9abc7cebbec9f3d89755f6f16a76e5daffa60a6a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9014 | 9014 | 20200419 | WI | 5176 | 45323 | 248 | 50499 | 357 | 1190 | 137 | 307 | A | 4/19/2020 12:57 | 2020-04-19T12:57:00Z | 04/19 08:57 | 220 | 1190 | 2020-04-19T12:57:00Z | 4346 | 55 | 163 | 1361 | 50747 | posNeg | 1524 | 50499 | 9 | 14 | 5c1afcc1775dd09568f7fe9c35d193129a27dc6f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
9015 | 9015 | 20200419 | WV | 863 | 19168 | 20031 | 72 | 37 | 25 | 265 | B | 4/19/2020 17:00 | 2020-04-19T17:00:00Z | 04/19 13:00 | 18 | 2020-04-19T17:00:00Z | 863 | 54 | 78 | 513 | 20031 | posNeg | 591 | 20031 | 2 | 0 | e376597fd4935898ccd046efc5720a27632f3553 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
9016 | 9016 | 20200419 | WY | 309 | 6972 | 7281 | 19 | 50 | 227 | A | 4/19/2020 00:00 | 2020-04-19T00:00:00Z | 04/18 20:00 | 2 | 50 | 2020-04-19T00:00:00Z | 309 | 56 | 4 | 755 | 7281 | posNeg | 759 | 7281 | 0 | 0 | cf048399c533e2b08e39cd14a3245d7f08be38fc | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_daily_4pm_et] ( [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 );