states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
63 rows where "dateModified" is on date 2020-05-22 sorted by deathConfirmed
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7009 | 7009 | 20200524 | DC | 7966 | 44025 | 40803 | 324 | 110 | 73 | 1075 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 427 | 2020-05-22T00:00:00Z | 40803 | 33576 | 11 | 0 | 0 | 51991 | posNeg | 1875 | 51991 | 0 | 0 | ee54fa0fac7e0731e58611ea368ab615830b462b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7019 | 7019 | 20200524 | KS | 8958 | 67476 | 76434 | 787 | 269 | 120 | 485 | A+ | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 185 | 787 | 2020-05-22T10:00:00Z | 76280 | 20 | 0 | 0 | 76434 | posNeg | 0 | 76434 | 0 | 0 | f941cb902ed9db6a88ff0a878299ae203db32e3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7063 | 7063 | 20200523 | CO | 23487 | 121465 | 162468 | 571 | 4082 | 3612 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 1088 | 4082 | 2020-05-22T00:00:00Z | 21202 | 162468 | 142667 | 44103 | 3448 | 40655 | 8 | 296 | 2431 | 144952 | totalTestEncountersViral | 3550 | 144952 | 26 | 45 | 36b54cb4a0444d31c342519cc4edf316bf5ae04a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7064 | 7064 | 20200523 | CT | 40022 | 168345 | 208367 | 724 | 12538 | 7127 | B | 5/22/2020 20:30 | 2020-05-22T20:30:00Z | 05/22 16:30 | 3675 | 12538 | 2020-05-22T20:30:00Z | 214136 | 208367 | 9 | 382 | 5657 | 208367 | posNeg | 6039 | 208367 | 38 | 0 | 2cc9fb0ffbc5e88bc4e3c6b8dff30d60f44965f6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7065 | 7065 | 20200523 | DC | 7966 | 44025 | 38928 | 324 | 110 | 73 | 1075 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 427 | 2020-05-22T00:00:00Z | 38928 | 32735 | 11 | 73 | 8925 | 51991 | posNeg | -4065 | 51991 | 9 | 0 | 8985fb064dc58328bc6671e18fdc82a6ef87c387 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7070 | 7070 | 20200523 | HI | 642 | 48179 | 48821 | 84 | 585 | C | 5/22/2020 18:00 | 2020-05-22T18:00:00Z | 05/22 14:00 | 17 | 84 | 2020-05-22T18:00:00Z | 48821 | 15 | -5 | 841 | 48821 | posNeg | 836 | 48821 | 0 | 1 | 08bf679383709f862912db1d208e170341c7dca3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7075 | 7075 | 20200523 | KS | 8958 | 67476 | 76434 | 787 | 269 | 120 | 485 | A+ | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 185 | 787 | 2020-05-22T10:00:00Z | 76280 | 20 | 0 | 0 | 76434 | posNeg | 0 | 76434 | 0 | 0 | 17cce5d954a4f7b9646f5b80a94e8da0d1a6c80b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7084 | 7084 | 20200523 | MP | 22 | 4296 | 4318 | 13 | D | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 2 | 2020-05-22T00:00:00Z | 4318 | 22 | 69 | 0 | 0 | 4318 | posNeg | 0 | 4318 | 0 | 0 | 067206a8163c59163af260353992b0261315540f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7085 | 7085 | 20200523 | MS | 13005 | 121215 | 134220 | 590 | 1996 | 154 | 93 | 7681 | A | 5/22/2020 19:00 | 2020-05-22T19:00:00Z | 05/22 15:00 | 616 | 1996 | 2020-05-22T19:00:00Z | 134220 | 8813 | 80 | 28 | 381 | -4134 | 134220 | posNeg | -3753 | 134220 | 20 | 30 | 49491cbfb4a5a44fb0c5a5c850b5676b044cf79a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7089 | 7089 | 20200523 | NE | 11662 | 68320 | 79982 | D | 5/22/2020 19:45 | 2020-05-22T19:45:00Z | 05/22 15:45 | 147 | 2020-05-22T19:45:00Z | 11662 | 80475 | 31 | 237 | 1326 | 79982 | posNeg | 1563 | 79982 | 4 | 0 | 21735036451b7772ee36b01ff7c3017780d5d553 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7092 | 7092 | 20200523 | NM | 6625 | 151758 | 158383 | 206 | 1139 | 2149 | C | 5/22/2020 17:58 | 2020-05-22T17:58:00Z | 05/22 13:58 | 302 | 1139 | 2020-05-22T17:58:00Z | 158383 | 6625 | 35 | 153 | 5463 | 158383 | posNeg | 5616 | 158383 | 8 | 0 | b8f23616beb787cca73969cd91999b8cfaca3dac | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7094 | 7094 | 20200523 | NY | 359926 | 1292135 | 1652061 | 4642 | 88083 | 1502 | 1254 | 63292 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 23282 | 88083 | 2020-05-22T00:00:00Z | 359926 | 1652061 | 36 | 1772 | 49496 | 1652061 | posNeg | 51268 | 1652061 | 87 | 240 | ba333020bd7851eff068c6b2bc1cc46db0e19b64 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7102 | 7102 | 20200523 | SD | 4468 | 29060 | 33528 | 90 | 358 | 3336 | C | 5/22/2020 18:00 | 2020-05-22T18:00:00Z | 05/22 14:00 | 50 | 358 | 2020-05-22T18:00:00Z | 33528 | 46 | 112 | 1072 | 33528 | posNeg | 1184 | 33528 | 0 | 7 | b9faf951a8705d00e6b6f13052952471c6abeb27 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7104 | 7104 | 20200523 | TX | 54509 | 708197 | 762706 | 1688 | 32277 | B | 5/22/2020 17:00 | 2020-05-22T17:00:00Z | 05/22 13:00 | 1506 | 2020-05-22T17:00:00Z | 762706 | 54509 | 60252 | 2463 | 48 | 1060 | 20284 | 762706 | posNeg | 21344 | 762706 | 26 | 0 | 99f33878612ab98288d56ee3a73dc13774ab893a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7115 | 7115 | 20200522 | AR | 5612 | 97435 | 103047 | 86 | 584 | 14 | 110 | 4029 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 113 | 584 | 2020-05-22T00:00:00Z | 103047 | 5612 | 5 | 154 | 3617 | 103047 | posNeg | 3771 | 103047 | 3 | 49 | 673ddc95d69193d3d77eb3244e8765e2dc42cc03 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7117 | 7117 | 20200522 | AZ | 15608 | 160395 | 176003 | 796 | 2943 | 311 | 203 | 3949 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 775 | 2943 | 2020-05-22T00:00:00Z | 176003 | 69483 | 4 | 293 | 4083 | 176003 | posNeg | 4376 | 176003 | 12 | 58 | 10fd128b5645600b7b8e5edc0744e1068a2510bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7119 | 7119 | 20200522 | CO | 23191 | 119034 | 158918 | 620 | 4037 | 3580 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 1062 | 4037 | 2020-05-22T00:00:00Z | 20903 | 158918 | 139937 | 41457 | 3315 | 38142 | 8 | 394 | 6220 | 142225 | totalTestEncountersViral | 5121 | 142225 | 61 | 47 | b0b95e8a0346f9453dda5a048c5c1bdc16543581 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7124 | 7124 | 20200522 | GA | 41218 | 386031 | 427249 | 889 | 7313 | 1658 | A | 5/22/2020 13:00 | 2020-05-22T13:00:00Z | 05/22 09:00 | 1785 | 7313 | 2020-05-22T13:00:00Z | 427249 | 41218 | 13 | 813 | 18705 | 427249 | posNeg | 19518 | 427249 | 31 | 78 | 6d2f50cd95a0678953f0faebde75029e281af851 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7125 | 7125 | 20200522 | GU | 165 | 5114 | 5279 | 125 | C | 5/22/2020 05:35 | 2020-05-22T05:35:00Z | 05/22 01:35 | 5 | 2020-05-22T05:35:00Z | 5331 | 5037 | 160 | 5279 | 66 | 0 | 215 | 5279 | posNeg | 215 | 5279 | 0 | 0 | f26f74608ea996e606d7f8a6db67da026b485c1b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7127 | 7127 | 20200522 | IA | 16504 | 103746 | 120250 | 362 | 123 | 79 | 9079 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 425 | 2020-05-22T00:00:00Z | 16504 | 120514 | 13818 | 1725 | 12090 | 19 | 334 | 3351 | 120250 | posNeg | 3685 | 120250 | 19 | 0 | ac9c52764eb40a12a28de886f49c97add151983c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7131 | 7131 | 20200522 | KS | 8958 | 67476 | 76434 | 787 | 269 | 120 | 485 | A+ | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 185 | 787 | 2020-05-22T10:00:00Z | 76280 | 20 | 419 | 4812 | 76434 | posNeg | 5231 | 76434 | 7 | 27 | 565cec5545e6c6e6edd0dc41c9a13820966f19e2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7139 | 7139 | 20200522 | MO | 11558 | 161388 | 172946 | 711 | 93 | B | 5/22/2020 15:00 | 2020-05-22T15:00:00Z | 05/22 11:00 | 671 | 2020-05-22T15:00:00Z | 167199 | 14046 | 152883 | 11558 | 172946 | 16192 | 647 | 15520 | 29 | 218 | 10636 | 172946 | posNeg | 10854 | 172946 | 10 | 0 | bd7409cf53d57beab625ad37cde617d790ee2315 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7140 | 7140 | 20200522 | MP | 22 | 4296 | 4318 | 13 | D | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 2 | 2020-05-22T00:00:00Z | 4318 | 22 | 69 | 0 | 229 | 4318 | posNeg | 229 | 4318 | 0 | 0 | 15f3f42c050f1679f00b226d893ad2c579c20976 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7142 | 7142 | 20200522 | MT | 479 | 31378 | 31857 | 3 | 65 | 441 | C | 5/22/2020 12:05 | 2020-05-22T12:05:00Z | 05/22 08:05 | 16 | 65 | 2020-05-22T12:05:00Z | 31857 | 479 | 30 | 0 | 1333 | 31857 | posNeg | 1333 | 31857 | 0 | 0 | b3920710920141064e882bd7ce6d9c9320dd5190 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7149 | 7149 | 20200522 | NV | 7401 | 92540 | 99941 | 404 | 90 | 51 | 339 | A+ | 5/22/2020 09:30 | 2020-05-22T09:30:00Z | 05/22 05:30 | 400 | 2020-05-22T09:30:00Z | 117606 | 7401 | 99941 | 32 | 146 | 5413 | 99941 | posNeg | 5559 | 99941 | 3 | 0 | ce83242ba12109ad6f457e68af171d975344b0f0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7150 | 7150 | 20200522 | NY | 358154 | 1242639 | 1600793 | 4844 | 87843 | 1581 | 1254 | 63292 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 23195 | 87843 | 2020-05-22T00:00:00Z | 358154 | 1600793 | 36 | 1696 | 44042 | 1600793 | posNeg | 45738 | 1600793 | 112 | 205 | b77ebe13f6fade632f14183a564158d80a000db5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7152 | 7152 | 20200522 | OK | 5849 | 147318 | 153167 | 190 | 926 | 94 | 4533 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 307 | 926 | 2020-05-22T00:00:00Z | 152998 | 6589 | 146409 | 5849 | 13642 | 459 | 40 | 169 | 3403 | 153167 | posNeg | 3572 | 153167 | 3 | 9 | 00db2bf5e3b208725599822c5bb5497710dda39d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7153 | 7153 | 20200522 | OR | 3864 | 103975 | 107839 | 146 | 737 | 47 | 16 | 1376 | A+ | 5/22/2020 11:00 | 2020-05-22T11:00:00Z | 05/22 07:00 | 147 | 737 | 2020-05-22T11:00:00Z | 3770 | 107745 | 41 | 47 | 2568 | 107839 | posNeg | 2615 | 107839 | 2 | 5 | 82d57aebbe5c29728c78cd59de49f0e110254c89 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7154 | 7154 | 20200522 | PA | 66258 | 312743 | 379001 | 1580 | 368 | 37767 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 4984 | 2020-05-22T00:00:00Z | 64551 | 379001 | 481 | 42 | 866 | 9229 | 379001 | posNeg | 10095 | 379001 | 115 | 0 | 04fd96b2575bd38b3576107366621bb053b0d2da | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7156 | 7156 | 20200522 | RI | 13949 | 87850 | 136692 | 242 | 1537 | 56 | 40 | 1084 | A+ | 5/22/2020 03:00 | 2020-05-22T03:00:00Z | 05/21 23:00 | 579 | 1537 | 2020-05-22T03:00:00Z | 138609 | 17749 | 120860 | 13949 | 136692 | 101799 | 44 | 201 | 1451 | 101799 | totalTestEncountersViral | 4131 | 101799 | 23 | 31 | 714c7c136eadd874bf5b1c7cf53c7c40d35267f3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7161 | 7161 | 20200522 | UT | 8057 | 178777 | 186834 | 163 | 660 | 210 | 88 | 4748 | B | 5/22/2020 15:00 | 2020-05-22T15:00:00Z | 05/22 11:00 | 93 | 660 | 2020-05-22T15:00:00Z | 8057 | 186834 | 49 | 183 | 3777 | 186834 | posNeg | 3960 | 186834 | 1 | 13 | efacc3e49302b47cfd91f62e07026ab19bac4234 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7167 | 7167 | 20200522 | WV | 1616 | 83213 | 84829 | 47 | 13 | 9 | 983 | B | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 71 | 2020-05-22T10:00:00Z | 84829 | 1593 | 54 | 23 | 1665 | 84829 | posNeg | 1688 | 84829 | 1 | 0 | bfd765a1d0b82d6155cfe4d0b76147367d08ced6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7113 | 7113 | 20200522 | AK | 404 | 41042 | 41446 | 15 | 356 | C | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 10 | 2020-05-22T00:00:00Z | 41446 | 404 | 10 | 2 | 2 | 1899 | 41446 | posNeg | 1901 | 41446 | 0 | 0 | 2386d42b882a13c7c4a1d893d3af92caaea4a635 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7109 | 7109 | 20200523 | WA | 20986 | 320020 | 341006 | 332 | 3230 | 96 | B | 5/22/2020 02:59 | 2020-05-22T02:59:00Z | 05/21 22:59 | 1050 | 3230 | 2020-05-22T02:59:00Z | 20986 | 1050 | 341006 | 304123 | 53 | 149 | 3201 | 341006 | posNeg | 3350 | 341006 | 6 | 74 | fc7f3efc74e70d607514b2db600169a7c426442b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7147 | 7147 | 20200522 | NJ | 152719 | 402595 | 555314 | 3049 | 846 | 674 | 24491 | A+ | 5/22/2020 13:00 | 2020-05-22T13:00:00Z | 05/22 09:00 | 12675 | 2020-05-22T13:00:00Z | 555314 | 152719 | 10985 | 1690 | 34 | 1247 | 9793 | 555314 | posNeg | 11040 | 555314 | 148 | 0 | 3556aa96b1dca62b987b2ce82741d9e4f0e5450a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7106 | 7106 | 20200523 | VA | 35749 | 196721 | 409 | 276297 | 1384 | 6431 | 330 | 213 | 5047 | A+ | 5/22/2020 17:00 | 2020-05-22T17:00:00Z | 05/22 13:00 | 1159 | 6431 | 2020-05-22T17:00:00Z | 45359 | 33962 | 1123 | 36 | 276297 | 51 | 799 | 6496 | 232879 | posNeg | 10630 | 232470 | 23 | 9 | bd76677ba9b979c04e7b52ca0f5146076662704e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7151 | 7151 | 20200522 | OH | 30794 | 277006 | 307800 | 879 | 5379 | 362 | 1416 | 232 | B | 5/22/2020 14:00 | 2020-05-22T14:00:00Z | 05/22 10:00 | 1872 | 5379 | 2020-05-22T14:00:00Z | 305764 | 28758 | 1691 | 181 | 39 | 627 | 8095 | 307800 | posNeg | 8722 | 307800 | 36 | 84 | a1c03586051d46718c56c3ab10442c47120e15a2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7074 | 7074 | 20200523 | IN | 30901 | 184032 | 214933 | 1138 | 5285 | 403 | 1166 | 173 | A+ | 5/22/2020 23:59 | 2020-05-22T23:59:00Z | 05/22 19:59 | 1943 | 5285 | 2020-05-22T23:59:00Z | 1812 | 152 | 214933 | 18 | 492 | 5880 | 214933 | posNeg | 6372 | 214933 | 2 | 0 | ffe9925bd2e12d4ee2743bcfc91802bd3610f8cb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7135 | 7135 | 20200522 | MD | 44424 | 183478 | 227902 | 1329 | 7634 | 506 | 3243 | B | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 2274 | 7634 | 2020-05-22T10:00:00Z | 251847 | 50019 | 44424 | 2169 | 105 | 227902 | 24 | 893 | 6776 | 227902 | posNeg | 7669 | 227902 | 53 | 149 | b5c434324c34741a683d0c09b61aa0b4190041c5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7123 | 7123 | 20200522 | FL | 49451 | 786045 | 1487 | 835496 | 9372 | A | 5/22/2020 09:39 | 2020-05-22T09:39:00Z | 05/22 05:39 | 2268 | 9372 | 2020-05-22T09:39:00Z | 940758 | 66424 | 871876 | 49451 | 2268 | 837172 | 12 | 776 | 20791 | 836983 | posNeg | 21567 | 835496 | 46 | 172 | b80d3da000829ca57f3312d00a396966aac85de0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7133 | 7133 | 20200522 | LA | 36925 | 274883 | 311808 | 867 | 104 | 26249 | B | 5/22/2020 13:00 | 2020-05-22T13:00:00Z | 05/22 09:00 | 2668 | 2020-05-22T13:00:00Z | 36925 | 2545 | 123 | 311808 | 22 | 421 | 6006 | 311808 | posNeg | 6427 | 311808 | 39 | 0 | d313861f63d0af35c6386d613f6015a9923c767c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7159 | 7159 | 20200522 | TN | 19394 | 348776 | 368170 | 570 | 1560 | 12566 | B | 5/22/2020 15:00 | 2020-05-22T15:00:00Z | 05/22 11:00 | 315 | 1560 | 2020-05-22T15:00:00Z | 19394 | 315 | 368170 | 47 | 433 | 7154 | 368170 | posNeg | 7587 | 368170 | 2 | 21 | 383ba635c8b6cbb1273e57ec5944471a6b92b60d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7066 | 7066 | 20200523 | DE | 8690 | 41844 | 50534 | 210 | 4454 | B | 5/22/2020 18:00 | 2020-05-22T18:00:00Z | 05/22 14:00 | 425 | 2020-05-22T18:00:00Z | 371 | 54 | 50534 | 10 | 161 | 1387 | 50534 | posNeg | 1548 | 50534 | 5 | 0 | c43adc27750d72b3e40dc55d20f1fbdd5f48b2a6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7144 | 7144 | 20200522 | ND | 2235 | 60513 | 74611 | 39 | 147 | 1405 | C | 5/22/2020 13:00 | 2020-05-22T13:00:00Z | 05/22 09:00 | 39 | 147 | 2020-05-22T13:00:00Z | 76017 | 2235 | 39 | 74611 | 60764 | 38 | 70 | 1463 | 62748 | totalTestEncountersViral | 2491 | 62748 | 1 | 3 | c06f22c3510c7d01cc779f39608e8affaae1237b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7076 | 7076 | 20200523 | KY | 8426 | 163033 | 171338 | 477 | 2076 | 90 | 889 | 3069 | A | 5/22/2020 17:00 | 2020-05-22T17:00:00Z | 05/22 13:00 | 391 | 2076 | 2020-05-22T17:00:00Z | 171338 | 8305 | 390 | 1 | 21 | 140 | 5079 | 171459 | posNeg | 5098 | 171459 | 5 | 35 | a5fe0aaac0d47961d32f90e9cbf6bd87eb20e349 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7157 | 7157 | 20200522 | SC | 9638 | 140385 | 150023 | 429 | 1534 | 5743 | A+ | 5/22/2020 16:00 | 2020-05-22T16:00:00Z | 05/22 12:00 | 419 | 1534 | 2020-05-22T16:00:00Z | 154746 | 14361 | 140385 | 9638 | 419 | 45 | 463 | 11322 | 150023 | posNeg | 11785 | 150023 | 12 | 90 | 182874edf9a4ff4517f86c336b04cc891c0a196e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7129 | 7129 | 20200522 | IL | 105444 | 591689 | 697133 | 3928 | 1060 | 589 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 4715 | 2020-05-22T00:00:00Z | 105444 | 4715 | 697133 | 17 | 2758 | 22355 | 697133 | posNeg | 25113 | 697133 | 108 | 0 | 263224211fa870b08f27909ef13a31a4ef93b914 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7073 | 7073 | 20200523 | IL | 107796 | 614451 | 722247 | 3753 | 1027 | 607 | A | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 4790 | 2020-05-22T00:00:00Z | 107796 | 4790 | 722247 | 17 | 2352 | 22762 | 722247 | posNeg | 25114 | 722247 | 75 | 0 | 55b642e48d789570bc3e4a3397812c57e4422937 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7166 | 7166 | 20200522 | WI | 16340 | 172703 | 187 | 189043 | 416 | 2259 | 134 | 535 | 8362 | A+ | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 496 | 2259 | 2020-05-22T00:00:00Z | 14396 | 496 | 187099 | 55 | 548 | 9465 | 189230 | posNeg | 10013 | 189043 | 9 | 41 | b8b6e9eb39b03ec23e0f91d6f9c0718c54dbfd9e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7114 | 7114 | 20200522 | AL | 13563 | 164205 | 177768 | 598 | 1561 | 531 | 315 | 7951 | B | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 537 | 1561 | 2020-05-22T00:00:00Z | 177768 | 13563 | 537 | 1 | 444 | 6585 | 177768 | posNeg | 7029 | 177768 | 8 | 33 | 0f832eb95e0a8cef7d787ec7382fcdf7c4adcc8a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7137 | 7137 | 20200522 | MI | 61075 | 441282 | 502357 | 955 | 470 | 348 | 28234 | A+ | 5/22/2020 11:00 | 2020-05-22T11:00:00Z | 05/22 07:00 | 5586 | 2020-05-22T11:00:00Z | 512752 | 71470 | 441282 | 56445 | 5375 | 237 | 26 | 465 | 19494 | 502357 | posNeg | 19959 | 502357 | 31 | 0 | a547738afbdb6340fc225d9e8d1022bc2e2789c5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7164 | 7164 | 20200522 | VT | 952 | 24781 | 25733 | 16 | 834 | B | 5/22/2020 00:00 | 2020-05-22T00:00:00Z | 05/21 20:00 | 54 | 2020-05-22T00:00:00Z | 952 | 54 | 25733 | 50 | 2 | 30 | 25733 | posNeg | 32 | 25733 | 0 | 0 | 7bc717a2b1f2d31e1afa8b680103d8a57e532380 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7081 | 7081 | 20200523 | MI | 61293 | 455556 | 516849 | 953 | 449 | 319 | 33168 | A+ | 5/22/2020 11:00 | 2020-05-22T11:00:00Z | 05/22 07:00 | 5612 | 2020-05-22T11:00:00Z | 527621 | 72065 | 455556 | 56612 | 5402 | 237 | 61973 | 26 | 218 | 14274 | 516849 | posNeg | 14492 | 516849 | 26 | 0 | f59dd01a3442760056b87220e5fbef33b671fb40 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7072 | 7072 | 20200523 | ID | 2595 | 38014 | 40370 | 19 | 225 | 94 | 1735 | A | 5/22/2020 19:00 | 2020-05-22T19:00:00Z | 05/22 15:00 | 79 | 225 | 2020-05-22T19:00:00Z | 40370 | 2356 | 59 | 20 | 16 | 61 | 953 | 40609 | posNeg | 1008 | 40609 | 2 | 2 | 607608f29120e93748a6d2ffbcbc8e1f5fb92cfa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
6995 | 6995 | 20200525 | VI | 69 | 1343 | 45 | 1412 | 61 | C | 5/22/2020 07:29 | 2020-05-22T07:29:00Z | 05/22 03:29 | 6 | 2020-05-22T07:29:00Z | 1457 | 6 | 78 | 0 | 0 | 1457 | posNeg | 0 | 1412 | 0 | 0 | 2f57190cb25c46b394495b294e120a2e8954b334 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7051 | 7051 | 20200524 | VI | 69 | 1343 | 45 | 1412 | 61 | C | 5/22/2020 07:29 | 2020-05-22T07:29:00Z | 05/22 03:29 | 6 | 2020-05-22T07:29:00Z | 1457 | 6 | 78 | 0 | 0 | 1457 | posNeg | 0 | 1412 | 0 | 0 | 47ec158c14c612a7e43ad9cb7c331d4c7cea0f81 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7107 | 7107 | 20200523 | VI | 69 | 1343 | 45 | 1412 | 61 | C | 5/22/2020 07:29 | 2020-05-22T07:29:00Z | 05/22 03:29 | 6 | 2020-05-22T07:29:00Z | 1457 | 6 | 78 | 0 | 0 | 1457 | posNeg | 0 | 1412 | 0 | 0 | 3d4a0de54c6f960c147e3ec8c9fa22ffb2212cba | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7163 | 7163 | 20200522 | VI | 69 | 1343 | 45 | 1412 | 61 | C | 5/22/2020 07:29 | 2020-05-22T07:29:00Z | 05/22 03:29 | 6 | 2020-05-22T07:29:00Z | 1457 | 6 | 78 | 0 | 29 | 1457 | posNeg | 29 | 1412 | 0 | 0 | 0df76d065665793373491bf5ce08d4dda4c83b6f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7155 | 7155 | 20200522 | PR | 3030 | 40488 | 43518 | 96 | 12 | 6 | B | 5/22/2020 05:51 | 2020-05-22T05:51:00Z | 05/22 01:51 | 126 | 2020-05-22T05:51:00Z | 41701 | 1572 | 40095 | 1221 | 60 | 66 | 1809 | 72 | 117 | 0 | 43518 | posNeg | 117 | 43518 | 0 | 0 | 3a37c15a29a8178632ea7741c71f7676525e6ec7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7134 | 7134 | 20200522 | MA | 90889 | 420755 | 664312 | 2323 | 9162 | 628 | A | 5/22/2020 10:00 | 2020-05-22T10:00:00Z | 05/22 06:00 | 6228 | 9162 | 2020-05-22T10:00:00Z | 664312 | 117464 | 90889 | 6228 | 511644 | 25 | 805 | 9353 | 511644 | totalTestsViral | 14811 | 511644 | 80 | 122 | a5f85f5dc23df0e62708f5f372bc074c12bc92e5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7143 | 7143 | 20200522 | NC | 21618 | 281606 | 303224 | 568 | 11637 | A | 5/22/2020 10:51 | 2020-05-22T10:51:00Z | 05/22 06:51 | 728 | 2020-05-22T10:51:00Z | 303224 | 21618 | 728 | 37 | 758 | 11821 | 303224 | posNeg | 12579 | 303224 | 12 | 0 | 056543c1285887e76d916fb659e70b1a4b3f86ba | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7136 | 7136 | 20200522 | ME | 1948 | 35450 | 37398 | 45 | 240 | 21 | 12 | 1192 | B | 5/22/2020 12:30 | 2020-05-22T12:30:00Z | 05/22 08:30 | 75 | 240 | 2020-05-22T12:30:00Z | 37725 | 2201 | 35450 | 1749 | 75 | 28357 | 2884 | 177 | 2704 | 23 | 71 | 0 | 37398 | posNeg | 71 | 37398 | 2 | 5 | 0129110807dd7d869dbea9bed19ddadbd0a4a299 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
7082 | 7082 | 20200523 | MN | 22765 | 194941 | 217706 | 568 | 2534 | 215 | 832 | 13485 | A | 5/22/2020 17:00 | 2020-05-22T17:00:00Z | 05/22 13:00 | 861 | 2534 | 2020-05-22T17:00:00Z | 22765 | 852 | 9 | 217706 | 27 | 391 | 8505 | 217706 | posNeg | 8896 | 217706 | 10 | 102 | b406a5ec715eb714a9d07404a819ff148c6a4d21 | 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 );