states_daily_4pm_et

Table actions

Data source: Big Local News · About: big-local-datasette

66 rows where "dateChecked" is on date 2020-08-17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-08-17 · 66 ✖
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
1764 1764 20200826 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 0bf683fc6f56b4f97f9ae354bf75743a9a8319fa 0 0 0 0 0  
1820 1820 20200825 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 ed246f0f20ccdce0111fb372bcfeae07550195a8 0 0 0 0 0  
1876 1876 20200824 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 8ddda8a06e3cf9b36b6724bdb97f35971d13f7be 0 0 0 0 0  
1932 1932 20200823 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 b5fefa2da2987cc3665ab46349aa00b74f5c7519 0 0 0 0 0  
1988 1988 20200822 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 821f9beeecb7d6c39079ca0da688becebb3bf69e 0 0 0 0 0  
2044 2044 20200821 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12921 posNeg 0 12921 0 0 3edfec6d35750f0d2ee8d31d829606dab1dd0e1b 0 0 0 0 0  
2100 2100 20200820 MP 54 12867   12921   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 1 12921 posNeg 1 12921 0 0 8e06fa27b11574d06b3200cffd77705b51cc91d0 0 0 0 0 0  
2156 2156 20200819 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54 2     12920                     69 0 0 12920 posNeg 0 12920 0 0 6a24ee889d9d9d0b7758a111995fa1eff8b893f1 0 0 0 0 0  
2191 2191 20200818 CO 53370 586280   881252 245 6739         5712 A 8/17/2020 01:59 2020-08-17T01:59:00Z 08/16 21:59 1778 6739 2020-08-17T01:59:00Z       49801     881252 636081 150080 10349 139731               8 194 4883 639650 totalTestEncountersViral 8201 639650 10 4 adc9957cbc7a74b6ee1547af7291bd029471a05f 0 0 0 0 0  
2192 2192 20200818 CT 51255 941476   992731 47 11015         8809 B 8/17/2020 20:30 2020-08-17T20:30:00Z 08/17 16:30 4456 11015 2020-08-17T20:30:00Z 990712     49236 3571 885                         9 -12 10775 992731 posNeg 10763 992731 0 0 b423852a101e885ec1dfa6e920a26543fbfcd638 0 0 0 0 0  
2193 2193 20200818 DC 13325 236153   249478 79   27   14   10595 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 599   2020-08-17T00:00:00Z             249478 159943                     11 52 3771 249478 posNeg 3823 249478 2 0 60b86928d0b7085b7d64da291873f9ce839896fa 0 0 0 0 0  
2194 2194 20200818 DE 16593 197252   213845 32   7       8749 A+ 8/17/2020 18:00 2020-08-17T18:00:00Z 08/17 14:00 593   2020-08-17T18:00:00Z       15589 524 69   213845                     10 57 1150 213845 posNeg 1207 213845 0 0 9eb152cb93bc2b272c06ee6396e9bca28c485393 0 0 0 0 0  
2195 2195 20200818 FL 579932 3699108 3814 4279040 5484 35112           B 8/17/2020 23:59 2020-08-17T23:59:00Z 08/17 19:59 9893 35112 2020-08-17T23:59:00Z 5757074 741276 4984524 579932 9893     4285720 408950 27323 381574 401862 26788 375046   5884     12 3838 22326 4282854 posNeg 26164 4279040 219 505 218bb5df07e4670d4ceea9fa777de712bf9e29b9 0 0 0 0 0  
2197 2197 20200818 GU 577 28649   29226 14   4       353 A 8/17/2020 23:40 2020-08-17T23:40:00Z 08/17 19:40 5   2020-08-17T23:40:00Z 29216     569       29218 155 2                 66 19 434 29226 posNeg 453 29226 0 0 425343df51cd1c6d339405e0f90c91755326ee9c 0 0 0 0 0  
2198 2198 20200818 HI 5215 158984   164199 175 288 35   25   1868 C 8/17/2020 22:55 2020-08-17T22:55:00Z 08/17 18:55 40 288 2020-08-17T22:55:00Z 209529             164199                     15 173 2078 164199 posNeg 2251 164199 0 5 30ee747c863156cbdb87e5a23f039bdd48dc3568 0 0 0 0 0  
2200 2200 20200818 ID 27942 198927   225018 167 1129 37 316     11093 A 8/17/2020 19:00 2020-08-17T19:00:00Z 08/17 15:00 273 1129 2020-08-17T19:00:00Z 225018     26091 245 28                         16 282 2100 226869 posNeg 2350 226869 4 19 74f63b17c1aa286abcc427415dd296f5d3e49f3b 0 0 0 0 0  
2202 2202 20200818 IN 81847 846767   928614 849 10037 251 2052 94   61518 A+ 8/17/2020 23:59 2020-08-17T23:59:00Z 08/17 19:59 3165 10037 2020-08-17T23:59:00Z 1192986       2954 211   928614                     18 841 13140 928614 posNeg 13981 928614 30 64 691c13b8c629881e036a30c08990fe35c4a68b6c 0 0 0 0 0  
2203 2203 20200818 KS 35167 319095   354262 229 2034 62 560 24 200 1409 A+ 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 405 2034 2020-08-17T10:00:00Z               354262                     20 0 0 354262 posNeg 0 354262 0 0 c271d074611aa55e2bbfbb43fbabf4ea4867a319 0 0 0 0 0  
2208 2208 20200818 ME 4213 210113   214326 10 401 5   1   3649 A+ 8/17/2020 23:59 2020-08-17T23:59:00Z 08/17 19:59 127 401 2020-08-17T23:59:00Z 213894 5283 208383 3781 126 1     9268 456 8799               23 16 1756 214326 posNeg 1772 214326 0 2 1da898a5ba515243b9f625fa16a35c9b78c8c77c 0 0 0 0 0  
2210 2210 20200818 MN 66061 937245   1273397 304 5932 154 1722     59568 A 8/17/2020 17:00 2020-08-17T17:00:00Z 08/17 13:00 1767 5932 2020-08-17T17:00:00Z       66061 1721 46 1273397 1003306                     27 345 2938 1003306 posNeg 6836 1003306 9 46 947b6cc75db77650849e6fad3d1f7e3e9b38f158 0 0 0 0 0  
2212 2212 20200818 MP 54 12866   12920   4         29 D 8/17/2020 19:35 2020-08-17T19:35:00Z 08/17 15:35 2 4 2020-08-17T19:35:00Z 16453     54       12920                     69 1 -1 12920 posNeg 0 12920 0 0 a63741bea14a2c854485327bedad895bef6d14bb 0 0 0 0 0  
2213 2213 20200818 MS 73207 452177   525384 1090 5025 284   163   56577 A+ 8/17/2020 19:00 2020-08-17T19:00:00Z 08/17 15:00 2128 5025 2020-08-17T19:00:00Z 522738     71254 2046 82     18516 95                 28 795 0 525384 posNeg 795 525384 33 36 37ddf3d26cec733a111898825873585298f28816 0 0 0 0 0  
2217 2217 20200818 NE 30563 294924   325487 158 1883         22647 A 8/17/2020 20:20 2020-08-17T20:20:00Z 08/17 16:20 362 1883 2020-08-17T20:20:00Z       30563       325782                     31 191 2305 325487 posNeg 2496 325487 1 0 d76e527b75e502dbff10185edd4506067f2e1bd7 0 0 0 0 0  
2220 2220 20200818 NM 23500 653650   677150 119 2984         10602 B 8/17/2020 17:50 2020-08-17T17:50:00Z 08/17 13:50 718 2984 2020-08-17T17:50:00Z 677150     23500                             35 92 6485 677150 posNeg 6577 677150 4 19 6c075270ac8012ffb209452f09a71e410067e126 0 0 0 0 0  
2222 2222 20200818 NY 426571 6765407   7191978 537 89995 126   60   74258 A 8/17/2020 23:59 2020-08-17T23:59:00Z 08/17 19:59 25264 89995 2020-08-17T23:59:00Z       426571     7191978                       36 655 66236 7191978 posNeg 66891 7191978 8 0 68ae0c502bc8dee13dcda9651eb2a1366b558b57 0 0 0 0 0  
2229 2229 20200818 SC 107672 770809   878481 1116 7146 294   173   45205 A+ 8/17/2020 23:59 2020-08-17T23:59:00Z 08/17 19:59 2343 7146 2020-08-17T23:59:00Z 877383 141827 735556 106574 2230 113     61311 4738 56573               45 719 4215 878481 posNeg 4934 878481 55 294 bfee6f60cceae99c3732855d05b67c563704b779 0 0 0 0 0  
2230 2230 20200818 SD 10443 119570   130013 68 927         9126 A 8/17/2020 14:00 2020-08-17T14:00:00Z 08/17 10:00 154 927 2020-08-17T14:00:00Z 166304             130013                     46 83 637 130013 posNeg 720 130013 1 6 7bbfc7ec7bf332c0dfbbdedf69f7861474a2a2e3 0 0 0 0 0  
2234 2234 20200818 VA 108282 1282023 381 1385832 1253 15163 300   163   13910 A+ 8/17/2020 17:00 2020-08-17T17:00:00Z 08/17 13:00 2396 15163 2020-08-17T17:00:00Z   125049   103809 2278 118 1385832                       51 861 16002 1390686 posNeg 16795 1390305 11 163 400d192989208ae4792fda6b2cd3a2b61b7a793e 0 0 0 0 0  
2237 2237 20200818 WA 69967 1259249   1329216 394 6296     39     B 8/17/2020 02:59 2020-08-17T02:59:00Z 08/16 22:59 1785 6296 2020-08-17T02:59:00Z       69967 1785   1329216                       53 598 14503 1329216 posNeg 15101 1329216 4 41 14c3d2255cad0efe945a2f53ac088d8341e59758 0 0 0 0 0  
2241 2241 20200817 AK 5110 300538   305648 33       4   1432 A 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 28   2020-08-17T00:00:00Z 305648 4838 300493 5110 28                           2 50 4083 305648 posNeg 4133 305648 0 0 1f061811cb893bd447aa24b54caa076b568a38a0 0 0 0 0 0  
2242 2242 20200817 AL 109004 743919   848514 1301 12958   1319   720 41523 B 8/17/2020 11:00 2020-08-17T11:00:00Z 08/17 07:00 1925 12958 2020-08-17T11:00:00Z 848514     104595 1855 70                         1 571 5928 852923 posNeg 6444 852923 27 351 9a38a9f09dbf0e9603e20f95a8ac01a4e78083fe 0 0 0 0 0  
2243 2243 20200817 AR 53077 569385   622050 486 3621     120 472 46133 A 8/17/2020 15:43 2020-08-17T15:43:00Z 08/17 11:43 603 3621 2020-08-17T15:43:00Z 622050   569385 53077                         7090 1085 5 412 0 622462 posNeg 0 622462 4 51 2e3e00c631848358279934b3d13ef8c89d24bc5e 0 0 0 0 0  
2245 2245 20200817 AZ 194005 904383   1096897 1182 20756 430   266   27800 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 4506 20756 2020-08-17T00:00:00Z       192514 4252 254   1096897 252860                   4 468 5946 1098388 posNeg 6398 1098388 0 1 4960dda7e889c381abb92e19704e91986aae35f5 0 0 0 0 0  
2246 2246 20200817 CA 628031 9305749   9933780 6332   1811         B 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 11242   2020-08-17T00:00:00Z 9933780     628031                             6 6469 129176 9933780 posNeg 135645 9933780 18 0 d2a8eb52fa329853459959ccc6d782253c5d23bb 0 0 0 0 0  
2252 2252 20200817 GA 238861 1788556   2027417 2626 22133   4061       A 8/17/2020 14:50 2020-08-17T14:50:00Z 08/17 10:50 4727 22133 2020-08-17T14:50:00Z 2027417 221905 1805512 238861         257747 18393                 13 1831 20313 2027417 posNeg 22144 2027417 25 46 7c3b4ce8e8ae6c6d4fd5e8ae9456d7c39d42cad7 0 0 0 0 0  
2253 2253 20200817 GU 558 28215   28773 13   4       352 A 8/17/2020 01:30 2020-08-17T01:30:00Z 08/16 21:30 5   2020-08-17T01:30:00Z 28763     550       28765 155 2                 66 42 958 28773 posNeg 1000 28773 0 0 3ab1fbd33a83f022c94e2f7d6de7085a1f73f79d 0 0 0 0 0  
2255 2255 20200817 IA 52722 501262   553984 283   85   33   40788 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 981   2020-08-17T00:00:00Z       52722       561762       44376 2919 41418         19 294 2497 553984 posNeg 2791 553984 6 0 0279503112bedc15a21c306ca69f8c9d2cb55fee 0 0 0 0 0  
2257 2257 20200817 IL 209186 3197243   3406429 1544   340   126     A 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 7967   2020-08-17T00:00:00Z 3405097     207854 7756 211                         17 1773 36473 3406429 posNeg 38246 3406429 12 0 7bf9392f8f51a9bafa222c3cd51db906c6d4689f 0 0 0 0 0  
2259 2259 20200817 KS 35167 319095   354262 229 2034 62 560 24 200 1409 A+ 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 405 2034 2020-08-17T10:00:00Z               354262                     20 1282 9937 354262 posNeg 11219 354262 3 14 595976c4df4f7cf86af970c07fd819fb4a58da09 0 0 0 0 0  
2260 2260 20200817 KY 39691 677125   713949 563 4215 136 1310     9158 B 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 818 4215 2020-08-17T00:00:00Z 713949     36824 813 5     45353               720   21 376 4079 716816 posNeg 4786 716816 5 22 0d3a6104d55a7ea928100482f25e2678605d4fa2 0 0 0 0 0  
2261 2261 20200817 LA 138485 1535804   1674289 1226       184   103512 A 8/17/2020 13:00 2020-08-17T13:00:00Z 08/17 09:00 4526   2020-08-17T13:00:00Z       138485 4403 123   1674289                     22 567 15635 1674289 posNeg 16202 1674289 19 0 b083652781cfad497bba558d1bfa71c85d45ba00 0 0 0 0 0  
2262 2262 20200817 MA 123413 1341501   1929891 367 12178 59   22   100486 A+ 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 8833 12178 2020-08-17T10:00:00Z 1929891 151327   114611 8611 222   1456112       105540     69018       25 213 14733 1464914 totalTestsViral 21416 1464914 4 5 f68ba2f3746e00ef1925ec9f7bec747dfae6aeff 0 0 0 0 0  
2263 2263 20200817 MD 100715 1056897   1157612 435 13658 106       6008 A 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 3641 13658 2020-08-17T10:00:00Z 1645642 118601   100715 3504 137   1157612                     24 503 14699 1157612 posNeg 15202 1157612 2 44 fc8f7db099de7885d5e11a6d5d4d0b162f2c4e57 0 0 0 0 0  
2265 2265 20200817 MI 102749 2237458   2340207 653   169   89   67778 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 6592   2020-08-17T00:00:00Z 2368782 131324 2237458 93185 6325 267     238946                   26 490 18667 2340207 posNeg 19157 2340207 0 0 693c061e2dca1e96ba79a7f06c8185b2de2447a4 0 0 0 0 0  
2267 2267 20200817 MO 68623 789994   858617 853       119     A 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 1396   2020-08-17T00:00:00Z 1138890 79618 1057293 68623       858617       64968 2549 62419         29 1148 11851 858617 posNeg 12999 858617 29 0 45e0b73eae8d871911a6533b183a5a3f11994fdc 0 0 0 0 0  
2268 2268 20200817 MP 53 12867   12920   4         29 D 8/17/2020 04:04 2020-08-17T04:04:00Z 08/17 00:04 2 4 2020-08-17T04:04:00Z 16453     53       12920                     69 3 615 12920 posNeg 618 12920 0 0 bc6c175e5cb73add0628a192468ee34e6fd453bc 0 0 0 0 0  
2270 2270 20200817 MT 5792 198933   204725 94 330         4162 C 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 82 330 2020-08-17T00:00:00Z 204725     5792                             30 42 2759 204725 posNeg 2801 204725 0 4 1343b7d48fe878f4e6b9e796aab6ddbb40cf5cd1 0 0 0 0 0  
2271 2271 20200817 NC 145516 1789956   1935472 980   290       127749 A+ 8/17/2020 12:20 2020-08-17T12:20:00Z 08/17 08:20 2348   2020-08-17T12:20:00Z 1935472     145516 2348                           37 564 10262 1935472 posNeg 10826 1935472 1 0 75fddc10963dc5924bfa25cf61bbf779637ae07c 0 0 0 0 0  
2272 2272 20200817 ND 8641 171772   387834 55 461         7343 C 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 105 461 2020-08-17T00:00:00Z 400035     8641 101 4 387834 178013 8027 293 7734               38 59 559 180413 totalTestEncountersViral 2603 180413 0 2 9b795f2e2b4e8c8ded28b287fbbcb0e3b892e104 0 0 0 0 0  
2274 2274 20200817 NH 7004 178967   283133 15 709   218     6302 B 8/17/2020 09:00 2020-08-17T09:00:00Z 08/17 05:00 423 709 2020-08-17T09:00:00Z 283133     7004       185971 29241     28699             33 16 1026 185971 posNeg 2123 185971 0 1 58104d18e731a272b7b40d603ce10e467ec281e8 0 0 0 0 0  
2275 2275 20200817 NJ 187767 2323303   2511070 472 22218 91   38   33381 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 15866 22218 2020-08-17T00:00:00Z 2511070     187767 14077 1789                         34 312 20572 2511070 posNeg 20884 2511070 4 12 870e2711305d30e2c9fcfdb647b83b4034528aac 0 0 0 0 0  
2277 2277 20200817 NV 61967 489456   551423 869   256   150   1498 A+ 8/17/2020 02:59 2020-08-17T02:59:00Z 08/16 22:59 1077   2020-08-17T02:59:00Z 759112     61967       551770                     32 662 3298 551423 posNeg 3960 551423 5 0 192889d444e48d7a410beb18c96fb1f37074ecec 0 0 0 0 0  
2279 2279 20200817 OH 109062 1739954   1849016 933 12319 316 2786 175   87764 A+ 8/17/2020 14:00 2020-08-17T14:00:00Z 08/17 10:00 3832 12319 2020-08-17T14:00:00Z 1843274     103320 3554 278                         39 775 18596 1849016 posNeg 19371 1849016 6 83 6766dd68c49961e43a1833be580df539df85d36c 0 0 0 0 0  
2280 2280 20200817 OK 48711 706619   755330 506 4021 236       40531 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 665 4021 2020-08-17T00:00:00Z 762899 54870 706619 48711         65475 2649                 40 369 0 755330 posNeg 369 755330 4 8 d83f3e08727d44517562d448f9f32c71320833f2 0 0 0 0 0  
2281 2281 20200817 OR 23451 467766   491217 206 1913 47   19   4419 A+ 8/17/2020 03:01 2020-08-17T03:01:00Z 08/16 23:01 388 1913 2020-08-17T03:01:00Z     467766 22234       490000                     41 189 2231 491217 posNeg 2420 491217 0 50 ac95f7f05a9ed3c77ace512080c809ced3f60d4b 0 0 0 0 0  
2282 2282 20200817 PA 124844 1342475   1467319 560       95   98626 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 7468   2020-08-17T00:00:00Z       121354       1463829                     42 384 10072 1467319 posNeg 10456 1467319 0 0 010fd18e127552e89ec0f0234fad775607d7de8e 0 0 0 0 0  
2283 2283 20200817 PR 26760 305972   332732 400   55   44     B 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 335   2020-08-17T00:00:00Z 310546 7002 303412 11723 206 129       15037                 72 754 0 332732 posNeg 754 332732 0 0 b0b990eccf513f386632102872fa035ed3491123 0 0 0 0 0  
2284 2284 20200817 RI 20572 213250   431005 80 2380 11   3   1982 A+ 8/17/2020 12:00 2020-08-17T12:00:00Z 08/17 08:00 1023 2380 2020-08-17T12:00:00Z   29317 401688 20572     431005 233822                     44 58 686 233822 totalTestEncountersViral 2028 233822 1 0 1425eae20f8c3bf389882f0a2925687a9465b244 0 0 0 0 0  
2287 2287 20200817 TN 134744 1736364   1871108 1139 5881 374   173   94812 A+ 8/17/2020 15:00 2020-08-17T15:00:00Z 08/17 11:00 1387 5881 2020-08-17T15:00:00Z 1868761 159582 1709179 132397 1345 42                         47 1036 12732 1871108 posNeg 13768 1871108 21 34 7dc198f2b9f3a6c57f09c921d37fc780d1ded753 0 0 0 0 0  
2288 2288 20200817 TX 542950 3933217   4476167 6200   2240       405817 A 8/17/2020 16:55 2020-08-17T16:55:00Z 08/17 12:55 10034   2020-08-17T16:55:00Z 4476167     542950         322433 23797             17887 2694 48 7368 29758 4476167 posNeg 37126 4476167 51 0 11bc01cfa95559e83eaa288c86435ef5a0ed3536 0 0 0 0 0  
2289 2289 20200817 UT 46894 554901   601795 156 2782 64 708   286 38132 A+ 8/17/2020 10:24 2020-08-17T10:24:00Z 08/17 06:24 364 2782 2020-08-17T10:24:00Z 734332     46894       601795             2300 696 2777 747 49 242 3026 601795 posNeg 3268 601795 1 11 5795ea890fb2d61de3aa7dc9ee8953ebbed97614 0 0 0 0 0  
2291 2291 20200817 VI 760 11658 11 12418             525 C 8/17/2020 07:14 2020-08-17T07:14:00Z 08/17 03:14 9   2020-08-17T07:14:00Z 12429       9                           78 19 228 12429 posNeg 247 12418 0 0 baa2458078570b88f6180b1c65da1bdaacecced1 0 0 0 0 0  
2292 2292 20200817 VT 1527 111696   113223 18           1343 B 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 58   2020-08-17T00:00:00Z       1527 58     113223                     50 12 1876 113223 posNeg 1888 113223 0 0 e11b5aa58e4b52314e27f4e5386365e63e7e8ba2 0 0 0 0 0  
2294 2294 20200817 WI 70715 1066040 172 1136755 365 5327 124 961     56602 A+ 8/17/2020 00:00 2020-08-17T00:00:00Z 08/16 20:00 1046 5327 2020-08-17T00:00:00Z       66196 1039 7   1132236                     55 469 5507 1136927 posNeg 5976 1136755 0 23 ae2f181f9e9f5a049821b656d62f346428b2757f 0 0 0 0 0  
2295 2295 20200817 WV 8632 352207   360839 134   50   19   6531 B 8/17/2020 10:00 2020-08-17T10:00:00Z 08/17 06:00 160   2020-08-17T10:00:00Z 360669     8462 159 1     15208                   54 68 5432 360839 posNeg 5500 360839 0 0 d7c7b1830ad0101991e87fb3320d377d61a3f643 0 0 0 0 0  
2296 2296 20200817 WY 3331 57567   60898 13 195         2699 B 8/17/2020 16:57 2020-08-17T16:57:00Z 08/17 12:57 33 195 2020-08-17T16:57:00Z 87365 2708 84656 2829       60396                     56 45 758 60898 posNeg 803 60898 3 4 91495e13add9a2d613cff6046f0b2a13cb624999 0 0 0 0 0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);