states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-07-10 sorted by hospitalizedIncrease
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, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4365 | 4365 | 20200711 | WA | 44341 | 773779 | 818120 | 326 | 4662 | 57 | B | 7/10/2020 02:59 | 2020-07-10T02:59:00Z | 07/09 22:59 | 1424 | 4662 | 2020-07-10T02:59:00Z | 44341 | 1424 | 818120 | 668466 | 53 | 526 | 9817 | 818120 | posNeg | 10343 | 818120 | 15 | -3 | db57d56483794efefc04447a1ac0a8b1f901d4f2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4269 | 4269 | 20200712 | GU | 312 | 16667 | 16979 | 3 | 202 | B | 7/10/2020 23:15 | 2020-07-10T23:15:00Z | 07/10 19:15 | 5 | 2020-07-10T23:15:00Z | 16858 | 304 | 16971 | 142 | 2 | 66 | 0 | 0 | 16979 | posNeg | 0 | 16979 | 0 | 0 | a2fe3e0c32a8db9110491ed3923d0b19f6c98c7c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4275 | 4275 | 20200712 | KS | 18611 | 199168 | 217779 | 1304 | 405 | 160 | 905 | A | 7/10/2020 10:00 | 2020-07-10T10:00:00Z | 07/10 06:00 | 284 | 1304 | 2020-07-10T10:00:00Z | 217779 | 20 | 0 | 0 | 217779 | posNeg | 0 | 217779 | 0 | 0 | 8bb91d91e6b146f9118cbfb9708954fcbf03a9e6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4300 | 4300 | 20200712 | RI | 17312 | 149343 | 292723 | 61 | 2051 | 4 | 5 | 1685 | A+ | 7/10/2020 12:00 | 2020-07-10T12:00:00Z | 07/10 08:00 | 976 | 2051 | 2020-07-10T12:00:00Z | 278357 | 24885 | 253472 | 17312 | 292723 | 166655 | 44 | 0 | 0 | 166655 | totalTestEncountersViral | 2934 | 166655 | 0 | 0 | 45e060efd3d08b26edb88de8af5bfd27b5f810e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4301 | 4301 | 20200712 | SC | 56648 | 435860 | 492508 | 1472 | 3398 | 20957 | A | 7/10/2020 23:59 | 2020-07-10T23:59:00Z | 07/10 19:59 | 961 | 3398 | 2020-07-10T23:59:00Z | 492345 | 69920 | 422425 | 56485 | 950 | 11 | 44173 | 2086 | 42087 | 45 | 1949 | 2469 | 492508 | posNeg | 4418 | 492508 | 10 | 0 | 95ab9b250ec479da7c92f79d1f660df23e4ba335 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4309 | 4309 | 20200712 | WA | 44675 | 778827 | 823502 | 326 | 4662 | 57 | B | 7/10/2020 02:59 | 2020-07-10T02:59:00Z | 07/09 22:59 | 1424 | 4662 | 2020-07-10T02:59:00Z | 44675 | 1424 | 823502 | 668466 | 53 | 334 | 5048 | 823502 | posNeg | 5382 | 823502 | 0 | 0 | d2e44ecf2902b0223b8872d422a1cb8bc08f3115 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4321 | 4321 | 20200711 | DC | 10801 | 113249 | 124050 | 92 | 29 | 17 | 1717 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 568 | 2020-07-10T00:00:00Z | 124050 | 93312 | 11 | 58 | 3108 | 124050 | posNeg | 3166 | 124050 | 0 | 0 | c7632c0a6b8f446494bda6d9d7953ca1f748d2a7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4322 | 4322 | 20200711 | DE | 12743 | 121372 | 134115 | 65 | 13 | 7002 | A+ | 7/10/2020 18:00 | 2020-07-10T18:00:00Z | 07/10 14:00 | 517 | 2020-07-10T18:00:00Z | 11699 | 460 | 57 | 134115 | 10 | 91 | 1316 | 134115 | posNeg | 1407 | 134115 | 0 | 0 | 71e9eba615752d54db23391148196a80e9e6ee93 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4325 | 4325 | 20200711 | GU | 312 | 16667 | 16979 | 3 | 202 | B | 7/10/2020 23:15 | 2020-07-10T23:15:00Z | 07/10 19:15 | 5 | 2020-07-10T23:15:00Z | 16858 | 304 | 16971 | 142 | 2 | 66 | 2 | 111 | 16979 | posNeg | 113 | 16979 | 0 | 0 | eec2050de7d18dd7f92ff4d2d96120294781d894 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4330 | 4330 | 20200711 | IN | 51079 | 507067 | 558146 | 714 | 7458 | 237 | 1577 | 72 | 38441 | A+ | 7/10/2020 23:59 | 2020-07-10T23:59:00Z | 07/10 19:59 | 2756 | 7458 | 2020-07-10T23:59:00Z | 2563 | 193 | 558146 | 18 | 779 | 6805 | 558146 | posNeg | 7584 | 558146 | 8 | 0 | 3e42490116b42f413d0a01840cd98c2162305aaa | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4331 | 4331 | 20200711 | KS | 18611 | 199168 | 217779 | 1304 | 405 | 160 | 905 | A | 7/10/2020 10:00 | 2020-07-10T10:00:00Z | 07/10 06:00 | 284 | 1304 | 2020-07-10T10:00:00Z | 217779 | 20 | 0 | 0 | 217779 | posNeg | 0 | 217779 | 0 | 0 | 60358464e8c97868876e837a6667a2364cacca03 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4345 | 4345 | 20200711 | NE | 20777 | 183077 | 203854 | 95 | 1419 | 15499 | B | 7/10/2020 20:00 | 2020-07-10T20:00:00Z | 07/10 16:00 | 286 | 1419 | 2020-07-10T20:00:00Z | 20777 | 204091 | 31 | 154 | 2686 | 203854 | posNeg | 2840 | 203854 | 2 | 0 | 9925eeb2d31172232f4c4be820bc66ccea58c5df | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4349 | 4349 | 20200711 | NV | 26838 | 314395 | 341233 | 918 | 241 | 122 | 764 | A+ | 7/10/2020 12:00 | 2020-07-10T12:00:00Z | 07/10 08:00 | 592 | 2020-07-10T12:00:00Z | 425027 | 26838 | 340338 | 32 | 930 | 4812 | 341233 | posNeg | 5742 | 341233 | 13 | 0 | 3bfdfa1d75b676be5f220a6ef2554947ce303d26 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4350 | 4350 | 20200711 | NY | 401029 | 4209748 | 4610777 | 799 | 89995 | 177 | 100 | 71477 | A | 7/10/2020 23:59 | 2020-07-10T23:59:00Z | 07/10 19:59 | 24974 | 89995 | 2020-07-10T23:59:00Z | 401029 | 4610777 | 36 | 730 | 68473 | 4610777 | posNeg | 69203 | 4610777 | 6 | 0 | ad13b028eb1c5d8650267075e3609a852ae2de99 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4356 | 4356 | 20200711 | RI | 17312 | 149343 | 289789 | 61 | 2051 | 4 | 5 | 1685 | A+ | 7/10/2020 12:00 | 2020-07-10T12:00:00Z | 07/10 08:00 | 976 | 2051 | 2020-07-10T12:00:00Z | 278357 | 24885 | 253472 | 17312 | 289789 | 166655 | 44 | 0 | 0 | 166655 | totalTestEncountersViral | 4507 | 166655 | 0 | 0 | d778052aa886da27ba56cb8dc2cfa6fb991e57d1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4357 | 4357 | 20200711 | SC | 54699 | 433391 | 488090 | 1396 | 3398 | 20956 | A | 7/10/2020 23:59 | 2020-07-10T23:59:00Z | 07/10 19:59 | 951 | 3398 | 2020-07-10T23:59:00Z | 487929 | 68604 | 419325 | 54538 | 940 | 11 | 44312 | 2055 | 42257 | 45 | 2280 | 10575 | 488090 | posNeg | 12855 | 488090 | 22 | 0 | a6b85fc4b6f6f65fba9aaf5c5476a602b03f58d3 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4363 | 4363 | 20200711 | VI | 167 | 3640 | 58 | 3807 | 92 | C | 7/10/2020 20:30 | 2020-07-10T20:30:00Z | 07/10 16:30 | 6 | 2020-07-10T20:30:00Z | 3865 | 6 | 78 | 14 | 167 | 3865 | posNeg | 181 | 3807 | 0 | 0 | 3e82e660904c4fffeee3946ae4abc8e0b3b74f33 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
4369 | 4369 | 20200710 | AK | 1323 | 140608 | 141931 | 30 | 0 | 588 | A | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 17 | 2020-07-10T00:00:00Z | 141931 | 1323 | 17 | 2 | 51 | 6136 | 141931 | posNeg | 6187 | 141931 | 0 | 0 | 34676751af121b48a66675a8accf9024fb26327c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4374 | 4374 | 20200710 | CA | 304297 | 4871440 | 5175737 | 7896 | 2005 | B | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 6851 | 2020-07-10T00:00:00Z | 5175737 | 304297 | 6 | 7798 | 89505 | 5175737 | posNeg | 97303 | 5175737 | 140 | 0 | 6e00557d29fab8b55dabd2b0e519c80ba548e17f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
4383 | 4383 | 20200710 | IA | 33984 | 328264 | 362248 | 169 | 54 | 26 | 25891 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 743 | 2020-07-10T00:00:00Z | 33984 | 362997 | 34982 | 2410 | 32537 | 19 | 744 | 6845 | 362248 | posNeg | 7589 | 362248 | 4 | 0 | cae0c5646548ce4829fe2a98f6feade638912831 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4385 | 4385 | 20200710 | IL | 152899 | 1759976 | 1912875 | 1436 | 306 | 155 | A | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 7345 | 2020-07-10T00:00:00Z | 1911743 | 151767 | 7144 | 201 | 17 | 1327 | 31670 | 1912875 | posNeg | 32997 | 1912875 | 16 | 0 | 6aacb6c3794103eea3f32e349dc3a5eaba75a006 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4389 | 4389 | 20200710 | LA | 74636 | 830612 | 905248 | 1117 | 122 | 46334 | B | 7/10/2020 13:00 | 2020-07-10T13:00:00Z | 07/10 09:00 | 3380 | 2020-07-10T13:00:00Z | 74636 | 3272 | 108 | 905248 | 22 | 2642 | 22466 | 905248 | posNeg | 25108 | 905248 | 25 | 0 | 2be5386f3778dee9f17be1a53e02d4cc5529ec0b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4393 | 4393 | 20200710 | MI | 75685 | 1171120 | 1246805 | 505 | 174 | 92 | 52841 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 6285 | 2020-07-10T00:00:00Z | 1265344 | 94224 | 1171120 | 68295 | 6039 | 246 | 179789 | 26 | 622 | 22630 | 1246805 | posNeg | 23252 | 1246805 | 14 | 0 | 505f77331a8284a343020c287d0d9511200b3cb2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4395 | 4395 | 20200710 | MO | 25999 | 428826 | 454825 | 886 | 79 | B | 7/10/2020 15:00 | 2020-07-10T15:00:00Z | 07/10 11:00 | 1051 | 2020-07-10T15:00:00Z | 576537 | 31075 | 544522 | 25999 | 454825 | 48179 | 1670 | 46509 | 29 | 0 | 0 | 454825 | posNeg | 0 | 454825 | 0 | 0 | 87cf7eefd813b1ef45548898607c988bcf76d4c8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4399 | 4399 | 20200710 | NC | 81331 | 1069281 | 1150612 | 1046 | 55318 | A | 7/10/2020 12:00 | 2020-07-10T12:00:00Z | 07/10 08:00 | 1479 | 2020-07-10T12:00:00Z | 1150612 | 81331 | 1479 | 37 | 1982 | 26819 | 1150612 | posNeg | 28801 | 1150612 | 18 | 0 | e560aa6e81de69008d472004dbf1d86d39b2cb38 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4405 | 4405 | 20200710 | NV | 25908 | 309583 | 335491 | 924 | 248 | 111 | 764 | A+ | 7/10/2020 12:00 | 2020-07-10T12:00:00Z | 07/10 08:00 | 579 | 2020-07-10T12:00:00Z | 416707 | 25908 | 334447 | 32 | 1004 | 4709 | 335491 | posNeg | 5713 | 335491 | 8 | 0 | 4f882af5e05afc72219c54403025f3420ddae898 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4410 | 4410 | 20200710 | PA | 93876 | 804764 | 898640 | 653 | 103 | 72284 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 6880 | 2020-07-10T00:00:00Z | 91206 | 895970 | 42 | 1009 | 17608 | 898640 | posNeg | 18617 | 898640 | 32 | 0 | 1eb1c64ba4860b673b83f9694fe3260ba665003c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4416 | 4416 | 20200710 | TX | 240111 | 2149678 | 2389789 | 10002 | 122996 | B | 7/10/2020 16:50 | 2020-07-10T16:50:00Z | 07/10 12:50 | 3013 | 2020-07-10T16:50:00Z | 2389789 | 240111 | 214114 | 7480 | 48 | 9765 | 66812 | 2389789 | posNeg | 76577 | 2389789 | 95 | 0 | 207ccff8781e84ebf50711e3e570a857b873387c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4420 | 4420 | 20200710 | VT | 1277 | 72821 | 74098 | 11 | 1066 | B | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 56 | 2020-07-10T00:00:00Z | 1277 | 56 | 74098 | 50 | 5 | 1344 | 74098 | posNeg | 1349 | 74098 | 0 | 0 | c11518582dcb385ff77a4ab117769d580acc4c4c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4423 | 4423 | 20200710 | WV | 3983 | 197220 | 201203 | 56 | 16 | 7 | 2756 | B | 7/10/2020 17:00 | 2020-07-10T17:00:00Z | 07/10 13:00 | 95 | 2020-07-10T17:00:00Z | 201092 | 3872 | 11695 | 54 | 157 | 3857 | 201203 | posNeg | 4014 | 201203 | 0 | 0 | f84d2f16d620cc5031f888811ce5baba45ac6997 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
4424 | 4424 | 20200710 | WY | 1790 | 38077 | 39867 | 12 | 121 | 1327 | B | 7/10/2020 13:50 | 2020-07-10T13:50:00Z | 07/10 09:50 | 21 | 121 | 2020-07-10T13:50:00Z | 54917 | 1592 | 53324 | 1445 | 39552 | 56 | 16 | 806 | 39867 | posNeg | 822 | 39867 | 0 | 0 | 4abeba664f49e076280c61be1f6b9184f229487b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4326 | 4326 | 20200711 | HI | 1158 | 91076 | 92234 | 125 | 847 | D | 7/10/2020 18:00 | 2020-07-10T18:00:00Z | 07/10 14:00 | 19 | 125 | 2020-07-10T18:00:00Z | 109096 | 92234 | 15 | 28 | 1611 | 92234 | posNeg | 1639 | 92234 | 0 | 2 | 00d5c962b5a864f24fdb9a941e7e88ace4e20a2f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
4336 | 4336 | 20200711 | ME | 3520 | 116370 | 119890 | 16 | 368 | 7 | 4 | 2972 | A+ | 7/10/2020 23:59 | 2020-07-10T23:59:00Z | 07/10 19:59 | 112 | 368 | 2020-07-10T23:59:00Z | 119501 | 4322 | 115011 | 3131 | 111 | 1 | 8035 | 369 | 7658 | 23 | 21 | 1463 | 119890 | posNeg | 1484 | 119890 | 1 | 2 | b6559af027340f97ebc858b23b5b8244b20aa250 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
4344 | 4344 | 20200711 | ND | 4240 | 116608 | 218947 | 31 | 263 | 3533 | D | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 78 | 263 | 2020-07-10T00:00:00Z | 224033 | 4240 | 74 | 4 | 218947 | 118316 | 5716 | 203 | 5513 | 38 | 88 | 1166 | 120848 | totalTestEncountersViral | 4058 | 120848 | 0 | 3 | 348317f6aae790994b682147f776f021dc2accc9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4398 | 4398 | 20200710 | MT | 1593 | 110585 | 112178 | 21 | 123 | 855 | C | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 28 | 123 | 2020-07-10T00:00:00Z | 112178 | 1593 | 30 | 127 | 3286 | 112178 | posNeg | 3413 | 112178 | 3 | 3 | 09663ed5d5ad98d0c547a67a1b809159073ec7a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4400 | 4400 | 20200710 | ND | 4152 | 115442 | 214889 | 33 | 260 | 3496 | D | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 78 | 260 | 2020-07-10T00:00:00Z | 219708 | 4152 | 74 | 4 | 214889 | 117060 | 5586 | 201 | 5385 | 38 | 84 | 1663 | 119594 | totalTestEncountersViral | 5338 | 119594 | 0 | 3 | b12a1508e60cbbe71c191e064c5ee53b003b86a9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4346 | 4346 | 20200711 | NH | 5991 | 126311 | 177819 | 20 | 585 | 190 | 4897 | B | 7/10/2020 09:00 | 2020-07-10T09:00:00Z | 07/10 05:00 | 390 | 585 | 2020-07-10T09:00:00Z | 177819 | 5991 | 132302 | 24425 | 21186 | 33 | 18 | 1233 | 132302 | posNeg | 2727 | 132302 | 3 | 4 | 819d07d3c4cf320b9fdec2e332a7be1f7e68150a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4412 | 4412 | 20200710 | RI | 17312 | 149343 | 285282 | 61 | 2051 | 4 | 5 | 1685 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 976 | 2051 | 2020-07-10T00:00:00Z | 278357 | 24885 | 253472 | 17312 | 285282 | 166655 | 44 | 69 | 1449 | 166655 | totalTestEncountersViral | 3747 | 166655 | 2 | 8 | fee53718f10f1395128af0ff1cbd158b377add41 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4375 | 4375 | 20200710 | CO | 35525 | 341615 | 460925 | 318 | 5831 | 4691 | A | 7/10/2020 01:59 | 2020-07-10T01:59:00Z | 07/09 21:59 | 1581 | 5831 | 2020-07-10T01:59:00Z | 32546 | 460925 | 374161 | 115504 | 7668 | 107836 | 8 | 409 | 6029 | 377140 | totalTestEncountersViral | 9332 | 377140 | 37 | 11 | 968038024ff979636effccdf0d1ab9d88b524011 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4388 | 4388 | 20200710 | KY | 18670 | 414020 | 431910 | 409 | 2763 | 70 | 1012 | 5258 | B | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 620 | 2763 | 2020-07-10T00:00:00Z | 431910 | 17890 | 616 | 4 | 38638 | 21 | 425 | 8252 | 432690 | posNeg | 8651 | 432690 | 8 | 16 | 4a027244edb9f8b49128e29ddbad282f19477882 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4328 | 4328 | 20200711 | ID | 9928 | 112421 | 121640 | 122 | 449 | 33 | 138 | 3066 | A | 7/10/2020 19:00 | 2020-07-10T19:00:00Z | 07/10 15:00 | 101 | 449 | 2020-07-10T19:00:00Z | 121640 | 9219 | 81 | 20 | 16 | 500 | 3771 | 122349 | posNeg | 4250 | 122349 | 1 | 17 | 0699732beaeed77eb04dcb199f21ee0afdc225e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4409 | 4409 | 20200710 | OR | 11454 | 275316 | 286770 | 208 | 1180 | 56 | 30 | 3009 | A+ | 7/10/2020 03:01 | 2020-07-10T03:01:00Z | 07/09 23:01 | 232 | 1180 | 2020-07-10T03:01:00Z | 275316 | 10881 | 286197 | 41 | 266 | 4429 | 286770 | posNeg | 4695 | 286770 | 2 | 18 | ad1124d7b2e3df5f66f32d72ff72e802b2371c73 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
4390 | 4390 | 20200710 | MA | 111110 | 827506 | 1243451 | 632 | 11582 | 98 | 47 | 94347 | A+ | 7/10/2020 10:00 | 2020-07-10T10:00:00Z | 07/10 06:00 | 8296 | 11582 | 2020-07-10T10:00:00Z | 1243451 | 140318 | 105290 | 8081 | 215 | 932796 | 79073 | 25 | 213 | 12642 | 938616 | totalTestsViral | 18260 | 938616 | 28 | 23 | 2bf87857ac85435edeab1bb17a7793cd80bafe25 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4348 | 4348 | 20200711 | NM | 14549 | 389032 | 403581 | 151 | 2161 | 6181 | B | 7/10/2020 18:17 | 2020-07-10T18:17:00Z | 07/10 14:17 | 539 | 2161 | 2020-07-10T18:17:00Z | 403581 | 14549 | 35 | 298 | 7402 | 403581 | posNeg | 7700 | 403581 | 6 | 24 | 457a443b8879a5e4387599f5a3a26c0b27e64aa5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4387 | 4387 | 20200710 | KS | 18611 | 199168 | 217779 | 1304 | 405 | 160 | 905 | A | 7/10/2020 10:00 | 2020-07-10T10:00:00Z | 07/10 06:00 | 284 | 1304 | 2020-07-10T10:00:00Z | 217779 | 20 | 993 | 8304 | 217779 | posNeg | 9297 | 217779 | 2 | 35 | 8aa6a7f128c5a2c17e568bb145061b0e835cadab | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
4315 | 4315 | 20200711 | AR | 26803 | 342846 | 369649 | 402 | 1780 | 84 | 265 | 20642 | A | 7/10/2020 19:46 | 2020-07-10T19:46:00Z | 07/10 15:46 | 313 | 1780 | 2020-07-10T19:46:00Z | 369649 | 26803 | 5 | 0 | 4237 | 369649 | posNeg | 4988 | 369649 | 0 | 37 | 8b21be22ee34bf74872b7ea4ac72c23acb892c7f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4338 | 4338 | 20200711 | MN | 41571 | 700524 | 742095 | 241 | 4366 | 121 | 1325 | 36012 | A | 7/10/2020 17:00 | 2020-07-10T17:00:00Z | 07/10 13:00 | 1537 | 4366 | 2020-07-10T17:00:00Z | 41571 | 1499 | 38 | 742095 | 27 | 804 | 15466 | 742095 | posNeg | 16270 | 742095 | 4 | 37 | 6fd2ece78cbf7b5505c113077b6dd8bdd42b947d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4371 | 4371 | 20200710 | AR | 26803 | 338609 | 364661 | 402 | 1743 | 84 | 260 | 20642 | A | 7/10/2020 14:46 | 2020-07-10T14:46:00Z | 07/10 10:46 | 313 | 1743 | 2020-07-10T14:46:00Z | 364661 | 26803 | 5 | 751 | 0 | 365412 | posNeg | 0 | 365412 | 4 | 38 | 18d8b0f56adcdd957e15921022d10b21ab3ab62a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
4341 | 4341 | 20200711 | MS | 35419 | 298924 | 334343 | 963 | 3495 | 202 | 107 | 22167 | A | 7/10/2020 19:00 | 2020-07-10T19:00:00Z | 07/10 15:00 | 1230 | 3495 | 2020-07-10T19:00:00Z | 334029 | 35105 | 1208 | 22 | 13123 | 95 | 28 | 797 | 3234 | 334343 | posNeg | 4031 | 334343 | 15 | 40 | 63f1ef523728bb7672a2c458fe4acf33265968c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4422 | 4422 | 20200710 | WI | 38099 | 635411 | 151 | 673510 | 278 | 3766 | 77 | 792 | 27329 | A+ | 7/10/2020 16:00 | 2020-07-10T16:00:00Z | 07/10 12:00 | 821 | 3766 | 2020-07-10T16:00:00Z | 34753 | 814 | 7 | 670164 | 55 | 889 | 11857 | 673661 | posNeg | 12746 | 673510 | 5 | 40 | 76d4e7ba75eb5eaf96ebc07b89433c0cb853468e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4417 | 4417 | 20200710 | UT | 28223 | 367751 | 395974 | 229 | 1748 | 79 | 477 | 205 | 16261 | A+ | 7/10/2020 10:27 | 2020-07-10T10:27:00Z | 07/10 06:27 | 207 | 1748 | 2020-07-10T10:27:00Z | 28223 | 395974 | 428 | 150 | 500 | 158 | 49 | 867 | 6374 | 395974 | posNeg | 7241 | 395974 | 2 | 48 | beb6305fc13981f010e7e8fee861fb5cfa14051f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
4370 | 4370 | 20200710 | AL | 50508 | 441708 | 491600 | 1201 | 3089 | 888 | 493 | 25783 | B | 7/10/2020 11:00 | 2020-07-10T11:00:00Z | 07/10 07:00 | 1104 | 3089 | 2020-07-10T11:00:00Z | 491600 | 49892 | 1077 | 27 | 1 | 1334 | 20378 | 492216 | posNeg | 23846 | 492216 | 36 | 50 | 1cc6a77fd63150a8aa9fc31ac10e94e4f46e4786 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4408 | 4408 | 20200710 | OK | 19092 | 391982 | 411074 | 487 | 1949 | 217 | 14648 | A+ | 7/10/2020 08:00 | 2020-07-10T08:00:00Z | 07/10 04:00 | 416 | 1949 | 2020-07-10T08:00:00Z | 414197 | 21345 | 391982 | 19092 | 45013 | 1465 | 40 | 596 | 8724 | 411074 | posNeg | 9320 | 411074 | 6 | 56 | 83196059d57d3ece4bac76a09538ae5f8949ff35 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4415 | 4415 | 20200710 | TN | 59546 | 935029 | 994575 | 1184 | 3146 | 34740 | A | 7/10/2020 15:00 | 2020-07-10T15:00:00Z | 07/10 11:00 | 723 | 3146 | 2020-07-10T15:00:00Z | 994114 | 69283 | 924831 | 59085 | 697 | 26 | 47 | 1955 | 19906 | 994575 | posNeg | 21861 | 994575 | 13 | 58 | 22d2b3dd74c7fd8bdab86e28c338067927856f41 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4403 | 4403 | 20200710 | NJ | 174628 | 1448530 | 1623158 | 904 | 20567 | 162 | 94 | 31014 | A+ | 7/10/2020 13:00 | 2020-07-10T13:00:00Z | 07/10 09:00 | 15308 | 20567 | 2020-07-10T13:00:00Z | 1623158 | 174628 | 13532 | 1776 | 34 | 388 | 23353 | 1623158 | posNeg | 23741 | 1623158 | 31 | 62 | bcb36ff9e83434dbd3bc8d323ed09bf64d98ebee | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4391 | 4391 | 20200710 | MD | 71910 | 549153 | 621063 | 385 | 11300 | 122 | 5157 | A | 7/10/2020 10:00 | 2020-07-10T10:00:00Z | 07/10 06:00 | 3303 | 11300 | 2020-07-10T10:00:00Z | 769011 | 84290 | 71910 | 3172 | 131 | 621063 | 24 | 463 | 8019 | 621063 | posNeg | 8482 | 621063 | 15 | 79 | 7dacecf40c93dcc465d5d587707ecefa3f4302ec | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4362 | 4362 | 20200711 | VA | 69782 | 716553 | 365 | 797916 | 1020 | 10291 | 230 | 97 | 9271 | A+ | 7/10/2020 17:00 | 2020-07-10T17:00:00Z | 07/10 13:00 | 1962 | 10291 | 2020-07-10T17:00:00Z | 83832 | 66963 | 1857 | 105 | 797916 | 51 | 851 | 16759 | 786700 | posNeg | 16539 | 786335 | 4 | 96 | 936d4a638eac147e00ffb21c08f65e713cd54826 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
4407 | 4407 | 20200710 | OH | 62856 | 896697 | 959553 | 928 | 8701 | 289 | 2161 | 151 | 43435 | B | 7/10/2020 14:00 | 2020-07-10T14:00:00Z | 07/10 10:00 | 3032 | 8701 | 2020-07-10T14:00:00Z | 955697 | 59000 | 2776 | 256 | 39 | 1525 | 41626 | 959553 | posNeg | 43151 | 959553 | 26 | 131 | 24a69b80f3ae829104a61b11d3becf5b81fda6a7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4373 | 4373 | 20200710 | AZ | 116892 | 552319 | 668528 | 3432 | 5659 | 876 | 615 | 13853 | A+ | 7/10/2020 00:00 | 2020-07-10T00:00:00Z | 07/09 20:00 | 2082 | 5659 | 2020-07-10T00:00:00Z | 116209 | 1961 | 121 | 668528 | 191767 | 4 | 4221 | 11929 | 669211 | posNeg | 16110 | 669211 | 44 | 133 | c8867976b33e57384e5dbfa81cd74a28943b03b6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
4380 | 4380 | 20200710 | GA | 111211 | 935137 | 1046348 | 2443 | 12937 | 2565 | A | 7/10/2020 14:50 | 2020-07-10T14:50:00Z | 07/10 10:50 | 2965 | 12937 | 2020-07-10T14:50:00Z | 1046348 | 101057 | 945291 | 111211 | 177244 | 9169 | 13 | 4484 | 22442 | 1046348 | posNeg | 26926 | 1046348 | 35 | 331 | 163e081c55e6e94c02a061fce63f5fc49493b413 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
4314 | 4314 | 20200711 | AL | 51947 | 450073 | 501367 | 1093 | 6745 | 904 | 496 | 25783 | B | 7/10/2020 11:00 | 2020-07-10T11:00:00Z | 07/10 07:00 | 1114 | 6745 | 2020-07-10T11:00:00Z | 501367 | 51294 | 1086 | 28 | 1 | 1439 | 8365 | 502020 | posNeg | 9767 | 502020 | 10 | 3656 | c1a6a7493f4f4341ac48c81aad7ac2d97ae8a24d | 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 );