states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-05-14
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, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7455 | 7455 | 20200516 | CO | 21232 | 100608 | 135313 | 671 | 3842 | 3312 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 878 | 3842 | 2020-05-14T00:00:00Z | 19151 | 135313 | 119759 | 30029 | 2538 | 27491 | 8 | 394 | 3416 | 121840 | totalTestEncountersViral | 4262 | 121840 | -213 | 53 | 2dfee3c90be923002acd96c91f5820b92cd56830 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7499 | 7499 | 20200516 | VI | 69 | 1194 | 37 | 1263 | 61 | C | 5/14/2020 19:04 | 2020-05-14T19:04:00Z | 05/14 15:04 | 6 | 2020-05-14T19:04:00Z | 1300 | 6 | 78 | 0 | 0 | 1300 | posNeg | 0 | 1263 | 0 | 0 | 2267023c0d4f87e56cb47ea04dc74752b4110195 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7505 | 7505 | 20200515 | AK | 388 | 32030 | 32418 | 8 | 343 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 10 | 2020-05-14T00:00:00Z | 32418 | 388 | 10 | 2 | 1 | 655 | 32418 | posNeg | 656 | 32418 | 0 | 0 | 8c2e9834e962d20d82c878e11b1becc0c5944246 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7510 | 7510 | 20200515 | CA | 74936 | 1058970 | 1133906 | 4519 | 1324 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 3108 | 2020-05-14T00:00:00Z | 1133906 | 74936 | 6 | 1772 | 27483 | 1133906 | posNeg | 29255 | 1133906 | 76 | 0 | a6f1c4bf1b4b7abb30f65fe0e263827a4c2d2e56 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7512 | 7512 | 20200515 | CT | 36085 | 119823 | 155908 | 1033 | 10946 | 6264 | B | 5/14/2020 20:30 | 2020-05-14T20:30:00Z | 05/14 16:30 | 3285 | 10946 | 2020-05-14T20:30:00Z | 164755 | 155908 | 9 | 621 | 5725 | 155908 | posNeg | 6346 | 155908 | 66 | 0 | 8021056a602056fa293d6571e5a223c4a11aba95 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7513 | 7513 | 20200515 | DC | 6871 | 27468 | 34339 | 393 | 90 | 975 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 368 | 2020-05-14T00:00:00Z | 34339 | 11 | 135 | 1205 | 34339 | posNeg | 2681 | 34339 | 10 | 0 | 9ac28b7cf950a04dd5a9136d7af16c1247374a97 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7514 | 7514 | 20200515 | DE | 7373 | 30905 | 38278 | 269 | 3210 | B | 5/14/2020 18:00 | 2020-05-14T18:00:00Z | 05/14 14:00 | 373 | 2020-05-14T18:00:00Z | 327 | 46 | 38278 | 10 | 150 | 1271 | 38278 | posNeg | 1421 | 38278 | 11 | 0 | 7fc114ed9210a7e155b76775fdd0abdcb0560e62 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7515 | 7515 | 20200515 | FL | 43210 | 565627 | 1228 | 608837 | 7993 | A+ | 5/14/2020 12:33 | 2020-05-14T12:33:00Z | 05/14 08:33 | 1991 | 7993 | 2020-05-14T12:33:00Z | 43210 | 1991 | 609574 | 12 | 0 | 0 | 610065 | posNeg | 0 | 608837 | 43 | 0 | 745389b066da4cdf8d48b65534b11cb78c358713 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7518 | 7518 | 20200515 | HI | 637 | 38139 | 38776 | 81 | 564 | B | 5/14/2020 18:00 | 2020-05-14T18:00:00Z | 05/14 14:00 | 17 | 81 | 2020-05-14T18:00:00Z | 39767 | 15 | -1 | -104 | 38776 | posNeg | -105 | 38776 | 0 | 0 | f6d3fba5d67d3df82afcf4cee396637a41d194ac | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7519 | 7519 | 20200515 | IA | 14049 | 79517 | 93566 | 387 | 130 | 87 | 6561 | A+ | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 336 | 2020-05-14T00:00:00Z | 14049 | 93566 | 19 | 374 | 3898 | 93566 | posNeg | 4272 | 93566 | 18 | 0 | b25fbd9867ead14da10e510c995a5e51448ecd27 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7520 | 7520 | 20200515 | ID | 2351 | 32394 | 34546 | 26 | 212 | 89 | 1573 | B | 5/14/2020 19:00 | 2020-05-14T19:00:00Z | 05/14 15:00 | 72 | 212 | 2020-05-14T19:00:00Z | 34546 | 2152 | 16 | 27 | 964 | 34745 | posNeg | 990 | 34745 | 3 | 0 | 717edf60f44a5a1c46614331f65214664d65dc14 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7522 | 7522 | 20200515 | IN | 26655 | 138793 | 165448 | 1294 | 4389 | 492 | 990 | 213 | A+ | 5/14/2020 23:59 | 2020-05-14T23:59:00Z | 05/14 19:59 | 1691 | 4389 | 2020-05-14T23:59:00Z | 1550 | 138 | 165448 | 18 | 602 | 4607 | 165448 | posNeg | 5209 | 165448 | 45 | 0 | a5ab68638a0012043a57f6571af29ed73f3e6a7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7524 | 7524 | 20200515 | KY | 7225 | 114053 | 121246 | 385 | 1887 | 220 | 794 | 2712 | A+ | 5/14/2020 17:00 | 2020-05-14T17:00:00Z | 05/14 13:00 | 328 | 1887 | 2020-05-14T17:00:00Z | 121246 | 7193 | 328 | 21 | 145 | 3738 | 121278 | posNeg | 10637 | 121278 | 2 | 52 | 5cbadce9caca1271bbcbc4eca2d23ee23df7751e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7526 | 7526 | 20200515 | MA | 83421 | 352258 | 567173 | 2767 | 8314 | 749 | A+ | 5/14/2020 10:00 | 2020-05-14T10:00:00Z | 05/14 06:00 | 5592 | 8314 | 2020-05-14T10:00:00Z | 567173 | 106978 | 83421 | 5592 | 435679 | 25 | 1239 | 10079 | 435679 | totalTestsViral | 17768 | 435679 | 110 | 107 | 96ccca90f1f424ef2a0a9e9161fad163ab7aeb58 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7529 | 7529 | 20200515 | MI | 57687 | 341827 | 399514 | 1256 | 532 | 440 | 22686 | A+ | 5/14/2020 11:00 | 2020-05-14T11:00:00Z | 05/14 07:00 | 5325 | 2020-05-14T11:00:00Z | 407180 | 65353 | 341827 | 53956 | 5124 | 233 | 26 | 651 | 15170 | 399514 | posNeg | 15821 | 399514 | 47 | 0 | f0dacc4f03492a27b7d67b534f48141af9a210a2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7530 | 7530 | 20200515 | MN | 17363 | 139773 | 157136 | 498 | 1985 | 200 | 679 | 8820 | A+ | 5/14/2020 17:00 | 2020-05-14T17:00:00Z | 05/14 13:00 | 692 | 1985 | 2020-05-14T17:00:00Z | 17363 | 683 | 9 | 157136 | 27 | 798 | 8330 | 157136 | posNeg | 9128 | 157136 | 29 | 70 | 95b15f87b842a995213bda70de322f81d2bb148a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7533 | 7533 | 20200515 | MS | 10801 | 96022 | 106823 | 573 | 1712 | 172 | 81 | 6268 | A | 5/14/2020 19:00 | 2020-05-14T19:00:00Z | 05/14 15:00 | 493 | 1712 | 2020-05-14T19:00:00Z | 106823 | 28 | 318 | 1179 | 106823 | posNeg | 1497 | 106823 | 13 | 45 | 7d26bf2f80977a8f6cf21f2fde326a8052131e18 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7537 | 7537 | 20200515 | NE | 9416 | 47799 | 57215 | C | 5/14/2020 15:45 | 2020-05-14T15:45:00Z | 05/14 11:45 | 113 | 2020-05-14T15:45:00Z | 9416 | 57315 | 31 | 341 | 3533 | 57215 | posNeg | 3874 | 57215 | 6 | 0 | d78a552e018ede5d4ec40c970e9ab1665eb9ff7d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
7538 | 7538 | 20200515 | NH | 3464 | 39148 | 543 | 44206 | 115 | 335 | 109 | 1247 | B | 5/14/2020 09:00 | 2020-05-14T09:00:00Z | 05/14 05:00 | 159 | 335 | 2020-05-14T09:00:00Z | 44206 | 3158 | 42306 | 5870 | 33 | 165 | 3272 | 43155 | posNeg | 1919 | 42612 | 9 | 9 | cb3398c44388a8fa23e0dbda69737b3367ddafd8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7540 | 7540 | 20200515 | NM | 5503 | 114098 | 119601 | 209 | 886 | 1576 | C | 5/14/2020 17:55 | 2020-05-14T17:55:00Z | 05/14 13:55 | 242 | 886 | 2020-05-14T17:55:00Z | 119601 | 5503 | 35 | 139 | 4451 | 119601 | posNeg | 4590 | 119601 | 11 | 0 | e10094de7f68cfb9d85a4db91f49555c89e5afaf | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7542 | 7542 | 20200515 | NY | 345813 | 992235 | 1338048 | 6394 | 85782 | 2156 | 1774 | 60302 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 22304 | 85782 | 2020-05-14T00:00:00Z | 345813 | 1338048 | 36 | 2762 | 36529 | 1338048 | posNeg | 39291 | 1338048 | 134 | 328 | da8f270b2b38896ea3bc46a218e8ac3404580ff3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7550 | 7550 | 20200515 | SD | 3887 | 23527 | 27414 | 80 | 296 | 2574 | B | 5/14/2020 18:00 | 2020-05-14T18:00:00Z | 05/14 14:00 | 44 | 296 | 2020-05-14T18:00:00Z | 27414 | 46 | 95 | 846 | 27414 | posNeg | 941 | 27414 | 1 | 6 | d54925c19031d293080698d6ead3be77a2d761af | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7554 | 7554 | 20200515 | VA | 28672 | 149342 | 458 | 209111 | 1511 | 5316 | 362 | 195 | 3805 | A+ | 5/14/2020 17:00 | 2020-05-14T17:00:00Z | 05/14 13:00 | 977 | 5316 | 2020-05-14T17:00:00Z | 35912 | 27293 | 944 | 33 | 209111 | 51 | 859 | 10325 | 178472 | posNeg | 7952 | 178014 | 22 | 105 | fd532b04773a852a8d0d5c133f0d2ead3a36fcdd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7555 | 7555 | 20200515 | VI | 69 | 1194 | 37 | 1263 | 61 | C | 5/14/2020 19:04 | 2020-05-14T19:04:00Z | 05/14 15:04 | 6 | 2020-05-14T19:04:00Z | 1278 | 6 | 78 | 0 | 30 | 1300 | posNeg | 30 | 1263 | 0 | 0 | aa805ae0900904960e7710cff9c57a0d1e843c7a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7560 | 7560 | 20200515 | WY | 715 | 15307 | 16022 | 8 | 68 | 487 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 7 | 68 | 2020-05-14T00:00:00Z | 15848 | 607 | 14957 | 541 | 56 | 14 | 578 | 16022 | posNeg | 592 | 16022 | 0 | 1 | 844a4c0d59f9a173a80d6bfc7b0d90a0c76d9a61 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7561 | 7561 | 20200514 | AK | 387 | 31375 | 31762 | 12 | 339 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 10 | 2020-05-14T00:00:00Z | 31762 | 387 | 10 | 2 | 4 | 1109 | 31762 | posNeg | 1113 | 31762 | 0 | 0 | 707e0f5d6806c7524d672690914635a99bdbf4c0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7562 | 7562 | 20200514 | AL | 10968 | 131017 | 136372 | 509 | 1350 | 489 | 291 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 467 | 1350 | 2020-05-14T00:00:00Z | 136372 | 10968 | 467 | 1 | 351 | 5262 | 141985 | posNeg | 3154 | 141985 | 18 | 33 | ca604f83540a44bd732cd25898ce35126cd2aed7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7563 | 7563 | 20200514 | AR | 4236 | 71582 | 75818 | 64 | 509 | 13 | 100 | 3277 | A | 5/14/2020 08:20 | 2020-05-14T08:20:00Z | 05/14 04:20 | 97 | 509 | 2020-05-14T08:20:00Z | 75818 | 4236 | 5 | 72 | 2531 | 75818 | posNeg | 2603 | 75818 | 2 | 12 | 944b8aefb36cca2b1027f7b871d23a26337402c7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7565 | 7565 | 20200514 | AZ | 12674 | 121664 | 134338 | 781 | 2595 | 323 | 201 | 3074 | A+ | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 624 | 2595 | 2020-05-14T00:00:00Z | 134338 | 41117 | 4 | 498 | 6090 | 134338 | posNeg | 6588 | 134338 | 30 | 52 | e132f36fa8935aa77d6dff442c0b655fac56e44a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7566 | 7566 | 20200514 | CA | 73164 | 1031487 | 1104651 | 4655 | 1324 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 3032 | 2020-05-14T00:00:00Z | 1104651 | 73164 | 6 | 2023 | 37036 | 1104651 | posNeg | 39059 | 1104651 | 98 | 0 | 4810ef2ccc7465e52ea90e229711128e5abb1658 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
7571 | 7571 | 20200514 | FL | 43210 | 565627 | 1228 | 608837 | 7993 | A+ | 5/14/2020 12:33 | 2020-05-14T12:33:00Z | 05/14 08:33 | 1948 | 7993 | 2020-05-14T12:33:00Z | 43210 | 1948 | 595478 | 12 | 808 | 13266 | 610065 | posNeg | 14074 | 608837 | 50 | 158 | 95f598d6c399f9e9f808392b223f3d3179d9a7ba | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7572 | 7572 | 20200514 | GA | 35858 | 250023 | 285881 | 1060 | 6345 | 1513 | A+ | 5/14/2020 13:30 | 2020-05-14T13:30:00Z | 05/14 09:30 | 1527 | 6345 | 2020-05-14T13:30:00Z | 285881 | 35858 | 13 | 526 | 11451 | 285881 | posNeg | 11977 | 285881 | 22 | 86 | 3f854634753b9ac20de858a9952dccd2dac6b31a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7573 | 7573 | 20200514 | GU | 153 | 4226 | 4379 | 124 | C | 5/14/2020 05:45 | 2020-05-14T05:45:00Z | 05/14 01:45 | 5 | 2020-05-14T05:45:00Z | 149 | 4258 | 66 | 1 | 116 | 4379 | posNeg | 117 | 4379 | 0 | 0 | 22fcab771f547a5ab4dfe3bfdb32fa4a890d645d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7577 | 7577 | 20200514 | IL | 87937 | 424100 | 512037 | 4473 | 1132 | 689 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 3928 | 2020-05-14T00:00:00Z | 87937 | 3928 | 489359 | 17 | 3239 | 19439 | 512037 | posNeg | 22678 | 512037 | 136 | 0 | a3cc5149590a41101f9e5edd244e096dfad5827a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7581 | 7581 | 20200514 | LA | 33489 | 214099 | 247588 | 1193 | 140 | 22608 | B | 5/14/2020 13:00 | 2020-05-14T13:00:00Z | 05/14 09:00 | 2417 | 2020-05-14T13:00:00Z | 33489 | 2351 | 66 | 237904 | 22 | 827 | 8857 | 247588 | posNeg | 9684 | 247588 | 36 | 0 | 6f3c7553e26b211098a4ee01d21dbbefd9b8bf0b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7583 | 7583 | 20200514 | MD | 35903 | 142551 | 178454 | 1538 | 6553 | 569 | 2569 | B | 5/14/2020 10:00 | 2020-05-14T10:00:00Z | 05/14 06:00 | 1935 | 6553 | 2020-05-14T10:00:00Z | 194595 | 41635 | 35903 | 1840 | 95 | 173574 | 24 | 1091 | 3789 | 178454 | posNeg | 4880 | 178454 | 54 | 149 | 3b78326ea52e0e63a6faf55e67120b13b71f09a9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7584 | 7584 | 20200514 | ME | 1565 | 22092 | 23657 | 37 | 207 | 18 | 7 | 958 | B | 5/14/2020 12:30 | 2020-05-14T12:30:00Z | 05/14 08:30 | 69 | 207 | 2020-05-14T12:30:00Z | 33035 | 1405 | 69 | 28357 | 587 | 23 | 50 | 0 | 23657 | posNeg | 50 | 23657 | 3 | 3 | f3c518b02a57b53240c7351a583bed10b9b23ff8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
7585 | 7585 | 20200514 | MI | 57036 | 326657 | 383693 | 1330 | 653 | 515 | 22686 | A+ | 5/14/2020 11:00 | 2020-05-14T11:00:00Z | 05/14 07:00 | 5278 | 2020-05-14T11:00:00Z | 391176 | 64519 | 326657 | 53451 | 5092 | 232 | 26 | 578 | 16415 | 383693 | posNeg | 16993 | 383693 | 46 | 0 | 8022a2b9b62ef0aa391ee02a77fc5e2f8d56ffb6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7587 | 7587 | 20200514 | MO | 10317 | 116793 | 127110 | 796 | 115 | B | 5/14/2020 15:00 | 2020-05-14T15:00:00Z | 05/14 11:00 | 562 | 2020-05-14T15:00:00Z | 134975 | 12346 | 122388 | 10317 | 124006 | 7644 | 328 | 7307 | 29 | 175 | 2793 | 127110 | posNeg | 2968 | 127110 | 20 | 0 | a2b865e74ad9ccb47de7072ef48c1ac8eb9f6b2e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7588 | 7588 | 20200514 | MP | 19 | 3306 | 3325 | 12 | D | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 2 | 2020-05-14T00:00:00Z | 3325 | 19 | 69 | 0 | 285 | 3325 | posNeg | 285 | 3325 | 0 | 0 | 9fbef1e480eb88a49e54b26b9d4a554f5de33232 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7590 | 7590 | 20200514 | MT | 462 | 24087 | 24549 | 3 | 63 | 431 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 16 | 63 | 2020-05-14T00:00:00Z | 24549 | 462 | 30 | 0 | 697 | 24549 | posNeg | 697 | 24549 | 0 | 0 | 210db5c4fb318c0576e8d92a4df5ed076f7a9a6a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7591 | 7591 | 20200514 | NC | 16507 | 202761 | 219268 | 507 | 9115 | A | 5/14/2020 11:00 | 2020-05-14T11:00:00Z | 05/14 07:00 | 615 | 2020-05-14T11:00:00Z | 210457 | 16507 | 615 | 37 | 691 | 8120 | 219268 | posNeg | 8811 | 219268 | 18 | 0 | 039ed77bbbecc5499878ce90040621209eb938f9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7592 | 7592 | 20200514 | ND | 1709 | 48599 | 56410 | 38 | 129 | 1007 | C | 5/14/2020 13:00 | 2020-05-14T13:00:00Z | 05/14 09:00 | 31 | 129 | 2020-05-14T13:00:00Z | 57421 | 1709 | 31 | 56410 | 48533 | 38 | 67 | 1301 | 50308 | totalTestEncountersViral | 2317 | 50308 | 2 | 2 | 220bf645bdfe60acdf085f5ddaeddcd5da0f676c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7595 | 7595 | 20200514 | NJ | 142704 | 308992 | 451696 | 3958 | 1157 | 898 | 15642 | A+ | 5/14/2020 13:00 | 2020-05-14T13:00:00Z | 05/14 09:00 | 11600 | 2020-05-14T13:00:00Z | 451696 | 142704 | 9946 | 1654 | 34 | 1144 | 9102 | 451696 | posNeg | 10246 | 451696 | 253 | 0 | 56a02504245b5a2d060f6e22fe9519d4c031ebeb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7597 | 7597 | 20200514 | NV | 6499 | 62985 | 69484 | 515 | 126 | 75 | 244 | B | 5/14/2020 12:00 | 2020-05-14T12:00:00Z | 05/14 08:00 | 358 | 2020-05-14T12:00:00Z | 82993 | 6499 | 66672 | 32 | 105 | 2707 | 69484 | posNeg | 2812 | 69484 | 3 | 0 | eeb678f81b31624ec8d1349067b17af5f0152383 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7598 | 7598 | 20200514 | NY | 343051 | 955706 | 1298757 | 6706 | 85454 | 2223 | 1846 | 59758 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 22170 | 85454 | 2020-05-14T00:00:00Z | 343051 | 1258907 | 36 | 2390 | 37460 | 1298757 | posNeg | 39850 | 1298757 | 157 | 446 | 1d9ab9279f31fb29233bce7e03bbbedaee1eb899 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7599 | 7599 | 20200514 | OH | 26357 | 206995 | 233352 | 953 | 4718 | 360 | 1268 | 253 | B | 5/14/2020 14:00 | 2020-05-14T14:00:00Z | 05/14 10:00 | 1534 | 4718 | 2020-05-14T14:00:00Z | 224378 | 24800 | 1388 | 146 | 39 | 636 | 6862 | 233352 | posNeg | 7498 | 233352 | 51 | 100 | 0b28911d61a5601e4233215e039ef7c02f694a54 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7600 | 7600 | 20200514 | OK | 4962 | 107221 | 112183 | 217 | 858 | 102 | 3660 | A+ | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 284 | 858 | 2020-05-14T00:00:00Z | 112647 | 5426 | 107221 | 4962 | 40 | 110 | 2946 | 112183 | posNeg | 3056 | 112183 | 6 | 10 | cf4a1b263792cea9f4b89119c2664b8f7bbc53b8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
7601 | 7601 | 20200514 | OR | 3479 | 80571 | 84050 | 163 | 685 | 38 | 17 | 1406 | A+ | 5/14/2020 11:00 | 2020-05-14T11:00:00Z | 05/14 07:00 | 137 | 685 | 2020-05-14T11:00:00Z | 3407 | 83909 | 41 | 63 | 0 | 84050 | posNeg | 63 | 84050 | 3 | 7 | aa4bcf2c33a5654e7d413f11bbea355bae8c1c78 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7602 | 7602 | 20200514 | PA | 59636 | 251559 | 311195 | 1983 | 446 | C | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 4218 | 2020-05-14T00:00:00Z | 311195 | 42 | 938 | 7388 | 311195 | posNeg | 8326 | 311195 | 275 | 0 | 5c510600b5206d2228463dc8ce94ac222dd8726f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
7603 | 7603 | 20200514 | PR | 2427 | 2427 | 159 | 18 | 5 | B | 5/14/2020 06:30 | 2020-05-14T06:30:00Z | 05/14 02:30 | 117 | 2020-05-14T06:30:00Z | 1073 | 58 | 1354 | 72 | 98 | 0 | 2427 | posNeg | 98 | 2427 | 2 | 0 | a1ec436b42655b00f20f2f367d45851c5886879d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7604 | 7604 | 20200514 | RI | 12431 | 74767 | 108466 | 271 | 1351 | 65 | 42 | 903 | A+ | 5/14/2020 03:00 | 2020-05-14T03:00:00Z | 05/13 23:00 | 468 | 1351 | 2020-05-14T03:00:00Z | 111593 | 15089 | 96504 | 12431 | 108466 | 87198 | 44 | 228 | 1927 | 87198 | totalTestEncountersViral | 3981 | 87198 | 6 | 23 | 53944a80f38a5aab5e01ed70f28bc35ae63fd5f8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
7605 | 7605 | 20200514 | SC | 8189 | 94346 | 102535 | 1338 | 4914 | A | 5/14/2020 15:34 | 2020-05-14T15:34:00Z | 05/14 11:34 | 371 | 1338 | 2020-05-14T15:34:00Z | 8189 | 371 | 93140 | 45 | 262 | 9133 | 102535 | posNeg | 9395 | 102535 | 16 | 0 | ab645142528f0a5499dce5c340e96879645094d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7607 | 7607 | 20200514 | TN | 16699 | 285618 | 302317 | 599 | 1435 | 8881 | A | 5/14/2020 15:00 | 2020-05-14T15:00:00Z | 05/14 11:00 | 287 | 1435 | 2020-05-14T15:00:00Z | 16699 | 287 | 292917 | 47 | 329 | 9071 | 302317 | posNeg | 9400 | 302317 | 14 | 47 | 000b6a3c99d89e42ff3e591e8750a8d641be9f8a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
7608 | 7608 | 20200514 | TX | 43851 | 543462 | 587313 | 1648 | 24487 | A | 5/14/2020 16:30 | 2020-05-14T16:30:00Z | 05/14 12:30 | 1216 | 2020-05-14T16:30:00Z | 587313 | 43851 | 35971 | 48 | 1448 | 29089 | 587313 | posNeg | 30537 | 587313 | 58 | 0 | bb3cf947985c9c338bee354cadb38ce54c2765a5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7609 | 7609 | 20200514 | UT | 6749 | 153370 | 160119 | 142 | 558 | 187 | 83 | 3566 | B | 5/14/2020 10:07 | 2020-05-14T10:07:00Z | 05/14 06:07 | 75 | 558 | 2020-05-14T10:07:00Z | 6749 | 156786 | 49 | 129 | 3204 | 160119 | posNeg | 3333 | 160119 | 0 | 5 | a34844970261a3f12aa1afe8f65004ddf35de46d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
7612 | 7612 | 20200514 | VT | 931 | 20497 | 21428 | 18 | 792 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 53 | 2020-05-14T00:00:00Z | 932 | 53 | 21676 | 50 | 1 | 789 | 21428 | posNeg | 790 | 21428 | 0 | 0 | 1b677a4186916a41756cea0856d628aad31bd55b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
7613 | 7613 | 20200514 | WA | 18898 | 270519 | 289417 | 365 | 111 | A | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 975 | 2020-05-14T00:00:00Z | 18898 | 975 | 289417 | 262293 | 53 | 271 | 6102 | 289417 | posNeg | 6373 | 289417 | 13 | 0 | dda9199eca6f7370b053590ab87698b3bd4cc274 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7614 | 7614 | 20200514 | WI | 12869 | 122598 | 169 | 135467 | 352 | 1939 | 120 | 478 | 5994 | A+ | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 434 | 1939 | 2020-05-14T00:00:00Z | 11275 | 434 | 128013 | 55 | 420 | 5487 | 135636 | posNeg | 5907 | 135467 | 13 | 31 | b0067ae2f72bb7ed552875f50fe46c91e7099ce3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
7615 | 7615 | 20200514 | WV | 1427 | 67286 | 68713 | 52 | 9 | 5 | 870 | B | 5/14/2020 10:00 | 2020-05-14T10:00:00Z | 05/14 06:00 | 60 | 2020-05-14T10:00:00Z | 66680 | 1427 | 54 | 29 | 2004 | 68713 | posNeg | 2033 | 68713 | 2 | 0 | fa63240093a45deea387fa0241a1f1a554dbcf77 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
7616 | 7616 | 20200514 | WY | 701 | 14729 | 15430 | 8 | 67 | 480 | B | 5/14/2020 00:00 | 2020-05-14T00:00:00Z | 05/13 20:00 | 7 | 67 | 2020-05-14T00:00:00Z | 15417 | 529 | 56 | 26 | 345 | 15430 | posNeg | 371 | 15430 | 0 | 0 | 7526bb515b4611741179e663137914692b21e880 | 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 );