states_daily_4pm_et

Table actions

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

11,578 rows sorted by totalTestsViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
377 377 20200920 OR 30801 605268   636069 145 2356 32   11   5391 A+ 9/20/2020 03:01 2020-09-20T03:01:00Z 09/19 23:01 526 2356 2020-09-20T03:01:00Z     605268 28871       627951                     41 202 1957 636069 posNeg 2159 636069 1 0 c774b71015b6201f014952bbc96abf7071c20587 0 0 0 0 0  
380 380 20200920 RI 23880 295923   688145 78 2693 10   4   2268 A+ 9/20/2020 12:00 2020-09-20T12:00:00Z 09/20 08:00 1094 2693 2020-09-20T12:00:00Z   33607 654538 23880     688145 319803                     44 82 1705 319803 totalTestEncountersViral 8291 319803 3 6 8e8f514b90a2bd4fa3516895e981d9934b1b24f4 0 0 0 0 0  
386 386 20200920 VA 140511 1748306 308 1882028 939 17819 263   126   16880 A+ 9/19/2020 17:00 2020-09-19T17:00:00Z 09/19 13:00 3015 17819 2020-09-19T17:00:00Z   159604   133722 2811 204 1882028                       51 856 14606 1889125 posNeg 15362 1888817 25 11 cf83044aa61954239c786d07fa35a38697831179 0 0 0 0 0  
388 388 20200920 VT 1715 154180   155895 2           1548 B 9/19/2020 23:59 2020-09-19T23:59:00Z 09/19 19:59 58   2020-09-19T23:59:00Z       1715 58     155895                     50 5 1090 155895 posNeg 1095 155895 0 0 bd99708f326996fbfa7ce99054babfcbd044f68d 0 0 0 0 0  
389 389 20200920 WA 82199 1640841   1723040 262 7248     26     B 9/19/2020 02:59 2020-09-19T02:59:00Z 09/18 22:59 2037 7248 2020-09-19T02:59:00Z       82199 2037   1723040                       53 597 17773 1723040 posNeg 18370 1723040 0 33 6ad1b5012368d8905d746d13224a1a9fa8d71887 0 0 0 0 0  
390 390 20200920 WI 107292 1332102 133 1439394 407 6653 111 1115     85824 A+ 9/20/2020 00:00 2020-09-20T00:00:00Z 09/19 20:00 1250 6653 2020-09-20T00:00:00Z       101227 1242 8   1433329                     55 1735 6655 1439527 posNeg 8390 1439394 1 34 28e5831bb0509bcd77c6561535b8aa0b5a88ddb5 0 0 0 0 0  
397 397 20200919 AZ 213551 1159608   1368906 528 21882 120   70   33668 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 5467 21882 2020-09-19T00:00:00Z       209298 5176 291   1368906 281887                   4 609 10231 1373159 posNeg 10752 1373159 16 17 90959c0030280e61c3dd920fe4f37679b826cb4a 0 0 0 0 0  
399 399 20200919 CO 63750 754119   1181829 230 7347         6254 A 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 1913 7347 2020-09-19T01:59:00Z       59236     1181829 813355 165511 11507 154006               8 605 8023 817869 totalTestEncountersViral 14919 817869 2 20 0af822cd69de7384f1b02c950ec6ffc747fc3ef2 0 0 0 0 0  
401 401 20200919 DC 14902 335975   350877 85   23   14   11823 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 619   2020-09-18T00:00:00Z             350877 202618                     11 50 3709 350877 posNeg 3759 350877 0 0 4f3655146b46326135d58634878269b61c4beb96 0 0 0 0 0  
402 402 20200919 DE 19449 250262   269711 53   15       10257 A+ 9/18/2020 18:00 2020-09-18T18:00:00Z 09/18 14:00 621   2020-09-18T18:00:00Z       18429 548 73   269711                     10 83 990 269711 posNeg 1073 269711 1 0 cfbced4f64ed183e15486991059c259dbc566bc1 0 0 0 0 0  
407 407 20200919 IA 77058 636717   713775 282   81   40   57269 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1264   2020-09-19T00:00:00Z       77058       715311       55107 3312 51755 18314 2326     19 847 4897 713775 posNeg 5744 713775 4 0 4d37bad5cf9f6423fa19d2acb8a1a7b17128d27c 0 0 0 0 0  
411 411 20200919 KS 52285 422464   474749 286 2671 79 734 23 230 1950 A+ 9/18/2020 10:00 2020-09-18T10:00:00Z 09/18 06:00 596 2671 2020-09-18T10:00:00Z               474749                     20 0 0 474749 posNeg 0 474749 0 0 fbece70742f3b6402b0b82185e763bf4c9ad12e3 0 0 0 0 0  
413 413 20200919 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 0 0 2146986 posNeg 0 2146986 0 0 391142daaa1979e017147041a56a46a716e7789a 0 0 0 0 0  
418 418 20200919 MN 88721 1202674   1815774 241 7124 134 1998     80407 A 9/18/2020 17:00 2020-09-18T17:00:00Z 09/18 13:00 2015 7124 2020-09-18T17:00:00Z       88721 1963 52 1815774 1291395                     27 914 11644 1291395 posNeg 24094 1291395 13 33 1db0b414c0ce4669343adec103dd182202b3a92d 0 0 0 0 0  
425 425 20200919 NE 40387 379608   419995 185 2194         30509 A 9/18/2020 20:15 2020-09-18T20:15:00Z 09/18 16:15 442 2194 2020-09-18T20:15:00Z       40387       420291                     31 466 2954 419995 posNeg 3420 419995 0 13 2d4c032f39cb806a0f4c8bcbec431096100f0dd5 0 0 0 0 0  
430 430 20200919 NY 449038 9373053   9822091 467 89995 144   60   76101 A 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 25425 89995 2020-09-18T23:59:00Z       449038     9822091                       36 986 109458 9822091 posNeg 110444 9822091 2 0 6428fa42a0444dfe549a7a14c8e0e10ffbb91404 0 0 0 0 0  
433 433 20200919 OR 30599 603311   633910 145 2356 32   11   5391 A+ 9/19/2020 03:01 2020-09-19T03:01:00Z 09/18 23:01 525 2356 2020-09-19T03:01:00Z     603311 28871       627951                     41 257 4231 633910 posNeg 4488 633910 4 0 f25783b8105f847358957b41063cfa5ab70b6708 0 0 0 0 0  
436 436 20200919 RI 23798 294218   679854 75 2687 11   4   2265 A+ 9/19/2020 12:00 2020-09-19T12:00:00Z 09/19 08:00 1091 2687 2020-09-19T12:00:00Z   33449 646405 23798     679854 318016                     44 178 2283 318016 totalTestEncountersViral 4746 318016 3 12 4101d54926dac1ed412a31032bdaba1d7e0b7a07 0 0 0 0 0  
442 442 20200919 VA 139655 1733700 299 1866666 960 17808 219   108   16848 A+ 9/18/2020 17:00 2020-09-18T17:00:00Z 09/18 13:00 2990 17808 2020-09-18T17:00:00Z   158898   132966 2787 203 1866666                       51 953 34167 1873654 posNeg 35043 1873355 41 71 675f51fa15bf451d894fa189a47c40f1da0abe4b 0 0 0 0 0  
444 444 20200919 VT 1710 153090   154800 3           1541 B 9/18/2020 23:59 2020-09-18T23:59:00Z 09/18 19:59 58   2020-09-18T23:59:00Z       1710 58     154800                     50 4 697 154800 posNeg 701 154800 0 0 d0b35c04784e2e162d57021fb7d47ab5ab1e275f 0 0 0 0 0  
445 445 20200919 WA 81602 1623068   1704670 248 7215     34     B 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 2037 7215 2020-09-18T02:59:00Z       81602 2037   1704670                       53 0 0 1704670 posNeg 0 1704670 0 0 09a5a1ca1ac431f57b4278c1cce4978ed0610be0 0 0 0 0 0  
446 446 20200919 WI 105557 1325447 121 1431004 362 6619 105 1112     84632 A+ 9/19/2020 00:00 2020-09-19T00:00:00Z 09/18 20:00 1249 6619 2020-09-19T00:00:00Z       99562 1241 8   1425009                     55 2403 10189 1431125 posNeg 12592 1431004 3 50 cc7783dfe4f5e969c819604fa58e541f0e834aec 0 0 0 0 0  
453 453 20200918 AZ 212942 1149377   1358154 516 21865 130   72   33526 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 5451 21865 2020-09-18T00:00:00Z       208777 5160 291   1358154 281052                   4 1282 8155 1362319 posNeg 8038 1362319 42 44 95607af232d157f176a9ff13d95500db8deb7370 0 0 0 0 0  
455 455 20200918 CO 63145 746096   1166910 213 7327         6241 A 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 1911 7327 2020-09-18T01:59:00Z       58671     1166910 804767 164905 11458 153449               8 459 6860 809241 totalTestEncountersViral 13057 809241 6 39 fd250a6a61df3496a50c9cf3a212276715207ee8 0 0 0 0 0  
457 457 20200918 DC 14852 332266   347118 91   24   13   11802 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 619   2020-09-17T00:00:00Z             347118 201379                     11 62 5738 347118 posNeg 5800 347118 0 0 5b5d54794bb52ea6dea82f9789c0a4b1736483ee 0 0 0 0 0  
458 458 20200918 DE 19366 249272   268638 58   17       10201 A+ 9/17/2020 18:00 2020-09-17T18:00:00Z 09/17 14:00 620   2020-09-17T18:00:00Z       18363 547 73   268638                     10 48 1422 268638 posNeg 1470 268638 1 0 fde395d540d7fc1f765916fa16723c6f59b0f10b 0 0 0 0 0  
463 463 20200918 IA 76211 631820   708031 281   91   39   56546 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1260   2020-09-18T00:00:00Z       76211       709565       54988 3289 51659 18101 2314     19 1183 5410 708031 posNeg 6593 708031 9 0 38bb2b2a915a5b2ad06f646eca9d9c76f9d8ccd0 0 0 0 0 0  
467 467 20200918 KS 52285 422464   474749 286 2671 79 734 23 230 1950 A+ 9/18/2020 10:00 2020-09-18T10:00:00Z 09/18 06:00 596 2671 2020-09-18T10:00:00Z               474749                     20 1415 9108 474749 posNeg 10523 474749 10 55 1b535325fb0951bfd1a8ae1eee1d749700f5c7b4 0 0 0 0 0  
469 469 20200918 LA 161322 1985664   2146986 647       104   145570 A 9/18/2020 13:00 2020-09-18T13:00:00Z 09/18 09:00 5340   2020-09-18T13:00:00Z       160283 5172 168   2145947                     22 979 21817 2146986 posNeg 22796 2146986 29 0 a240b9935efd335f467f94404a8006b6c051c52f 0 0 0 0 0  
474 474 20200918 MN 87807 1191030   1791680 250 7091 136 1990     80221 A 9/17/2020 17:00 2020-09-17T17:00:00Z 09/17 13:00 2002 7091 2020-09-17T17:00:00Z       87807 1950 52 1791680 1278837                     27 1085 14206 1278837 posNeg 27945 1278837 8 41 35f8e28594418956ee8585a44d57ac3368e380b5 0 0 0 0 0  
481 481 20200918 NE 39921 376654   416575 188 2181         30254 A 9/17/2020 20:15 2020-09-17T20:15:00Z 09/17 16:15 442 2181 2020-09-17T20:15:00Z       39921       416868                     31 502 3222 416575 posNeg 3724 416575 3 9 27013ee19c40c247efff0fea3b5530c089fe26a3 0 0 0 0 0  
486 486 20200918 NY 448052 9263595   9711647 478 89995 141   62   76036 A 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 25423 89995 2020-09-17T23:59:00Z       448052     9711647                       36 790 88937 9711647 posNeg 89727 9711647 10 0 484099c5cadb392fbd9a1cdd91d0dfbb3d880cf9 0 0 0 0 0  
489 489 20200918 OR 30342 599080   629422 145 2356 32   11   5376 A+ 9/18/2020 03:01 2020-09-18T03:01:00Z 09/17 23:01 521 2356 2020-09-18T03:01:00Z     599080 28871       627951                     41 492 3506 629422 posNeg 3998 629422 0 15 89132cc4df3967f105a8ea26c1067ea66a120410 0 0 0 0 0  
492 492 20200918 RI 23620 291935   675108 85 2675 7   6   2244 A+ 9/18/2020 12:00 2020-09-18T12:00:00Z 09/18 08:00 1088 2675 2020-09-18T12:00:00Z   33476 641632 23620     675108 315555                     44 132 2148 315555 totalTestEncountersViral 9182 315555 3 7 2e04f70b4bd1bf95101aa91d68088fcd610c2fbf 0 0 0 0 0  
498 498 20200918 VA 138702 1699533 297 1831623 945 17737 212   102   16762 A+ 9/17/2020 17:00 2020-09-17T17:00:00Z 09/17 13:00 2949 17737 2020-09-17T17:00:00Z   157605   132090 2755 194 1831623                       51 1242 8481 1838532 posNeg 9611 1838235 29 71 12f9481bc692f822148b81d495ad680ead68327c 0 0 0 0 0  
500 500 20200918 VT 1706 152393   154099 6           1536 B 9/17/2020 23:59 2020-09-17T23:59:00Z 09/17 19:59 58   2020-09-17T23:59:00Z       1706 58     154099                     50 1 903 154099 posNeg 904 154099 0 0 6b8ab95cb171fed140875c476935ce1aaed34539 0 0 0 0 0  
501 501 20200918 WA 81602 1623068   1704670 248 7215     34     B 9/18/2020 02:59 2020-09-18T02:59:00Z 09/17 22:59 2037 7215 2020-09-18T02:59:00Z       81602 2037   1704670                       53 404 13219 1704670 posNeg 13623 1704670 6 19 f6d5abdbe1cab27405187ffc7aff1a8d7e027961 0 0 0 0 0  
502 502 20200918 WI 103154 1315258 121 1418412 342 6569 98 1110     83184 A+ 9/18/2020 00:00 2020-09-18T00:00:00Z 09/17 20:00 1246 6569 2020-09-18T00:00:00Z       97279 1238 8   1412537                     55 2580 10534 1418533 posNeg 13114 1418412 7 47 b14b1cabaa94dde93fcb121be296cc55adfcac8f 0 0 0 0 0  
509 509 20200917 AZ 211660 1141222   1350116 594 21821 119   65   33381 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 5409 21821 2020-09-17T00:00:00Z       208894 5135 274   1350116 280184                   4 1753 22668 1352882 posNeg 23844 1352882 38 -4 3a5c768154706b52e7d4daa51006bf64b4bca18a 0 0 0 0 0  
511 511 20200917 CO 62686 739236   1153853 248 7288         6220 A 9/17/2020 01:59 2020-09-17T01:59:00Z 09/16 21:59 1905 7288 2020-09-17T01:59:00Z       58257     1153853 797493 164320 11393 152929               8 587 5602 801922 totalTestEncountersViral 9912 801922 0 26 6b8e92972209044359cb116a1ac8170e282d2b18 0 0 0 0 0  
513 513 20200917 DC 14790 326528   341318 100   22   18   11763 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 619   2020-09-16T00:00:00Z             341318 199579                     11 47 3030 341318 posNeg 3077 341318 2 0 48ffd6e6edaf60cd4a0a90fdbb9d2acc05d8f164 0 0 0 0 0  
514 514 20200917 DE 19318 247850   267168 66   18       10193 A+ 9/16/2020 18:00 2020-09-16T18:00:00Z 09/16 14:00 619   2020-09-16T18:00:00Z       18319 547 72   267168                     10 84 1179 267168 posNeg 1263 267168 0 0 ae64986f521647ff42e83472add3161e17297c2e 0 0 0 0 0  
519 519 20200917 IA 75028 626410   701438 271   85   36   55834 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1251   2020-09-17T00:00:00Z       75028       702988       54504 3269 51195 17663 2250     19 948 5379 701438 posNeg 6327 701438 14 0 8fb35d2a2cb9fc221bdc9dcc65782ecb945f6553 0 0 0 0 0  
523 523 20200917 KS 50870 413356   464226 278 2616 83 713 21 225 1920 A+ 9/16/2020 10:00 2020-09-16T10:00:00Z 09/16 06:00 586 2616 2020-09-16T10:00:00Z               464226                     20 0 0 464226 posNeg 0 464226 0 0 9774767ad4c7b3cc6016f5b12265f2a8c7df86a6 0 0 0 0 0  
525 525 20200917 LA 160343 1963847   2124190 663       106   145570 A 9/17/2020 13:00 2020-09-17T13:00:00Z 09/17 09:00 5311   2020-09-17T13:00:00Z       159304 5143 168   2123151                     22 478 8528 2124190 posNeg 9006 2124190 17 0 996d232f6b3f66d4927f6b0b437ad9167d5c4d64 0 0 0 0 0  
530 530 20200917 MN 86722 1176824   1763735 242 7050 132 1980     79878 A 9/16/2020 17:00 2020-09-16T17:00:00Z 09/16 13:00 1994 7050 2020-09-16T17:00:00Z       86722 1942 52 1763735 1263546                     27 909 10245 1263546 posNeg 20124 1263546 9 31 c8d74991ee79fb3b9616a177302d8b70acb0ff75 0 0 0 0 0  
537 537 20200917 NE 39419 373432   412851 176 2172         29966 A 9/16/2020 20:15 2020-09-16T20:15:00Z 09/16 16:15 439 2172 2020-09-16T20:15:00Z       39419       413473                     31 449 3441 412851 posNeg 3890 412851 3 5 7fa3dfda26578dc0dc1ad11eb7ee6c4728de0b83 0 0 0 0 0  
542 542 20200917 NY 447262 9174658   9621920 486 89995 135   68   75962 A 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 25413 89995 2020-09-16T23:59:00Z       447262     9621920                       36 896 90608 9621920 posNeg 91504 9621920 3 0 5e44bc2c7424a256603012991c84a330c2f41244 0 0 0 0 0  
545 545 20200917 OR 29850 595574   625424 144 2341 32   11   5376 A+ 9/17/2020 15:01 2020-09-17T15:01:00Z 09/17 11:01 521 2341 2020-09-17T15:01:00Z     595574 28590       624164                     41 0 4151 625424 posNeg 4151 625424 0 22 b02bf38aff4a26d83319f1278dc5c29b8b17fded 0 0 0 0 0  
548 548 20200917 RI 23488 289787   665926 88 2668 9   5   2236 A+ 9/17/2020 12:00 2020-09-17T12:00:00Z 09/17 08:00 1085 2668 2020-09-17T12:00:00Z   33335 632591 23488     665926 313275                     44 130 1801 313275 totalTestEncountersViral 11823 313275 4 6 6edcd8e621d87844da053c780c17bee240f69d5a 0 0 0 0 0  
554 554 20200917 VA 137460 1691052 326 1822012 995 17666 225   109   16671 A+ 9/16/2020 17:00 2020-09-16T17:00:00Z 09/16 13:00 2920 17666 2020-09-16T17:00:00Z   156565   130960 2734 186 1822012                       51 1101 21164 1828838 posNeg 22161 1828512 36 103 33916f3bfcf2b2776200d373449be7034c462068 0 0 0 0 0  
556 556 20200917 VT 1705 151490   153195 2           1533 B 9/16/2020 23:59 2020-09-16T23:59:00Z 09/16 19:59 58   2020-09-16T23:59:00Z       1705 58     153195                     50 3 1128 153195 posNeg 1131 153195 0 0 958ccc14d1318e2550adb521c973a8bcfd17eac1 0 0 0 0 0  
557 557 20200917 WA 81198 1609849   1691047 248 7196     36     B 9/17/2020 02:59 2020-09-17T02:59:00Z 09/16 22:59 2031 7196 2020-09-17T02:59:00Z       81198 2031   1691047                       53 386 13959 1691047 posNeg 14345 1691047 11 34 1e2f79583b37963862253e9dffe4e8e70009c5f4 0 0 0 0 0  
558 558 20200917 WI 100574 1304724 148 1405298 347 6522 103 1105     81902 A+ 9/17/2020 00:00 2020-09-17T00:00:00Z 09/16 20:00 1239 6522 2020-09-17T00:00:00Z       94746 1231 8   1399470                     55 2134 9411 1405446 posNeg 11545 1405298 2 68 313381dcc0d92f59dfafd7365de0c11959b048f1 0 0 0 0 0  
565 565 20200916 AZ 209907 1118554   1326272 538 21825 135   81   33250 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 5371 21825 2020-09-16T00:00:00Z       207718 5098 273   1326272 279172                   4 698 15459 1328461 posNeg 15957 1328461 27 25 66ece926d6d0bc1aecad99053a46a4f6aea47604 0 0 0 0 0  
567 567 20200916 CO 62099 733634   1143941 273 7262         6197 A 9/16/2020 01:59 2020-09-16T01:59:00Z 09/15 21:59 1905 7262 2020-09-16T01:59:00Z       57805     1143941 791439 164320 11370 152511               8 400 4576 795733 totalTestEncountersViral 9275 795733 11 22 73ea872034ce9e500415c070d5ece178ff8df974 0 0 0 0 0  
569 569 20200916 DC 14743 323498   338241 91   24   13   11691 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 617   2020-09-15T00:00:00Z             338241 198409                     11 56 1905 338241 posNeg 1961 338241 1 0 58073eeed1c488c2f7c48c238a3317b275047c9e 0 0 0 0 0  
570 570 20200916 DE 19234 246671   265905 58   11       10189 A+ 9/15/2020 18:00 2020-09-15T18:00:00Z 09/15 14:00 619   2020-09-15T18:00:00Z       18235 547 72   265905                     10 97 1649 265905 posNeg 1746 265905 1 0 f606baf4e4a8589b2089ad56f807f52b86cc0e26 0 0 0 0 0  
575 575 20200916 IA 74080 621031   695111 291   79   32   55067 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 1237   2020-09-16T00:00:00Z       74080       696656       53963 3240 50683 17285 2201     19 803 4696 695111 posNeg 5499 695111 3 0 ada3ba706bf73d3e426a7f0c48416420b447cd6a 0 0 0 0 0  
579 579 20200916 KS 50870 413356   464226 278 2616 83 713 21 225 1920 A+ 9/16/2020 10:00 2020-09-16T10:00:00Z 09/16 06:00 586 2616 2020-09-16T10:00:00Z               464226                     20 971 4874 464226 posNeg 5845 464226 52 44 51ad37f734d7195edebb25bca14e749bf6192912 0 0 0 0 0  
581 581 20200916 LA 159865 1955319   2115184 678       107   145570 A 9/16/2020 13:00 2020-09-16T13:00:00Z 09/16 09:00 5294   2020-09-16T13:00:00Z       158826 5126 168   2114145                     22 612 22614 2115184 posNeg 23226 2115184 16 0 42d0a9cff3bf5abcece0770dc0eef14820fb97aa 0 0 0 0 0  
586 586 20200916 MN 85813 1166579   1743611 244 7019 136 1977     79583 A 9/15/2020 17:00 2020-09-15T17:00:00Z 09/15 13:00 1985 7019 2020-09-15T17:00:00Z       85813 1933 52 1743611 1252392                     27 462 4063 1252392 posNeg 10319 1252392 6 40 e0474044182a47b6edfe0f06d1dc8147cccef412 0 0 0 0 0  
593 593 20200916 NE 38970 369991   408961 167 2167         29799 A 9/15/2020 20:05 2020-09-15T20:05:00Z 09/15 16:05 436 2167 2020-09-15T20:05:00Z       38970       409565                     31 328 1958 408961 posNeg 2286 408961 1 13 ce01765e4f9231ad52e9f0c82b0bc6289d712f4c 0 0 0 0 0  
598 598 20200916 NY 446366 9084050   9530416 483 89995 138   67   75903 A 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 25410 89995 2020-09-15T23:59:00Z       446366     9530416                       36 652 74435 9530416 posNeg 75087 9530416 5 0 247d677a0fea26706b310e8053dd5198afd55927 0 0 0 0 0  
601 601 20200916 OR 29850 591423   621273 172 2319 39   15   5365 A+ 9/16/2020 03:01 2020-09-16T03:01:00Z 09/15 23:01 521 2319 2020-09-16T03:01:00Z     591423 28399       619822                     41 188 3021 621273 posNeg 3209 621273 2 27 052a5486417274bc162d9553217f682ab3ffe02d 0 0 0 0 0  
604 604 20200916 RI 23358 287986   654103 84 2662 9   5   2235 A+ 9/16/2020 12:00 2020-09-16T12:00:00Z 09/16 08:00 1081 2662 2020-09-16T12:00:00Z   33159 620944 23358     654103 311344                     44 108 1195 311344 totalTestEncountersViral 11536 311344 3 12 9f1aba50e392b1d4df7b5803f585a1ce1d6d74a0 0 0 0 0 0  
610 610 20200916 VA 136359 1669888 349 1799851 1027 17563 212   103   16536 A+ 9/15/2020 17:00 2020-09-15T17:00:00Z 09/15 13:00 2884 17563 2020-09-15T17:00:00Z   155402   129963 2711 173 1799851                       51 845 13594 1806596 posNeg 14298 1806247 45 99 eba1829ee60548ed9ec45f57078781a3ae3358c8 0 0 0 0 0  
612 612 20200916 VT 1702 150362   152064 6           1530 B 9/15/2020 23:59 2020-09-15T23:59:00Z 09/15 19:59 58   2020-09-15T23:59:00Z       1702 58     152064                     50 0 472 152064 posNeg 472 152064 0 0 34dada47f9c2d9f8389703f9ed9c28d276e01a6f 0 0 0 0 0  
613 613 20200916 WA 80812 1595890   1676702 248 7162     29     B 9/16/2020 02:59 2020-09-16T02:59:00Z 09/15 22:59 2020 7162 2020-09-16T02:59:00Z       80812 2020   1676702                       53 347 10640 1676702 posNeg 10987 1676702 5 35 628771b31d76cf1bc39f2f0575d2482270ed7870 0 0 0 0 0  
614 614 20200916 WI 98440 1295313 175 1393753 370 6454 103 1098     80627 A+ 9/16/2020 00:00 2020-09-16T00:00:00Z 09/15 20:00 1237 6454 2020-09-16T00:00:00Z       92712 1228 9   1388025                     55 1502 10788 1393928 posNeg 12290 1393753 8 48 87f9b3de15d766d118ae4c5a2d7f5e75e351d0ff 0 0 0 0 0  
621 621 20200915 AZ 209209 1103095   1310315 550 21800 138   76   33095 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 5344 21800 2020-09-15T00:00:00Z       207220 5071 273   1310315 278475                   4 484 11156 1312304 posNeg 9651 1312304 22 26 6141885a4b35fa88e3cfa75552d3c37d6b89b2f5 0 0 0 0 0  
623 623 20200915 CO 61699 729058   1134666 239 7240         6184 A+ 9/14/2020 01:59 2020-09-14T01:59:00Z 09/13 21:59 1894 7240 2020-09-14T01:59:00Z       57453     1134666 786511 163615 11348 152267               8 375 5852 790757 totalTestEncountersViral 10485 790757 5 13 7da76a090abc85ced2dfeb97a3b10534fc2407f9 0 0 0 0 0  
625 625 20200915 DC 14687 321593   336280 89   23   11   11630 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 616   2020-09-14T00:00:00Z             336280 197726                     11 65 4067 336280 posNeg 4132 336280 0 0 d272bf60dd6eb64ff7bc2ff72e66bcc7edcd720c 0 0 0 0 0  
626 626 20200915 DE 19137 245022   264159 61   20       10165 A+ 9/14/2020 18:00 2020-09-14T18:00:00Z 09/14 14:00 618   2020-09-14T18:00:00Z       18138 546 72   264159                     10 200 1455 264159 posNeg 1655 264159 1 0 0d896be5fcff253e0d65a44466aaaea7ab3b4cb8 0 0 0 0 0  
631 631 20200915 IA 73277 616335   689612 284   74   29   54352 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 1234   2020-09-15T00:00:00Z       73277       691147       53494 3224 50230 16832 2112     19 401 2575 689612 posNeg 2976 689612 10 0 415fea5ac3a1d4a08d2a8b13f51331c4c0e882dc 0 0 0 0 0  
635 635 20200915 KS 49899 408482   458381 192 2572 50 703 15 221 1887 A+ 9/14/2020 10:00 2020-09-14T10:00:00Z 09/14 06:00 534 2572 2020-09-14T10:00:00Z               458381                     20 0 0 458381 posNeg 0 458381 0 0 f2f2ff46eba821dc5c314d7e7dbf7ae2764b34b7 0 0 0 0 0  
637 637 20200915 LA 159253 1932705   2091958 667       99   140440 A 9/15/2020 13:00 2020-09-15T13:00:00Z 09/15 09:00 5278   2020-09-15T13:00:00Z       158318 5108 170   2091023                     22 371 12288 2091958 posNeg 12659 2091958 26 0 ad55cf718436fff04af5ce03963ecb67e17f9465 0 0 0 0 0  
642 642 20200915 MN 85351 1162516   1733292 238 6979 131 1971     78953 A+ 9/14/2020 17:00 2020-09-14T17:00:00Z 09/14 13:00 1979 6979 2020-09-14T17:00:00Z       85351 1927 52 1733292 1247867                     27 402 4110 1247867 posNeg 8513 1247867 5 25 f3a5eb6e0919b9dd906801c99572fdc4388c0f2d 0 0 0 0 0  
649 649 20200915 NE 38642 368033   406675 176 2154         29597 A+ 9/14/2020 22:10 2020-09-14T22:10:00Z 09/14 18:10 435 2154 2020-09-14T22:10:00Z       38642       407270                     31 307 2403 406675 posNeg 2710 406675 1 15 f21cb39a359db7cca82947f61a07fb1fee89bf2a 0 0 0 0 0  
654 654 20200915 NY 445714 9009615   9455329 481 89995 144   60   75847 A 9/14/2020 23:59 2020-09-14T23:59:00Z 09/14 19:59 25405 89995 2020-09-14T23:59:00Z       445714     9455329                       36 766 72912 9455329 posNeg 73678 9455329 11 0 dff1d805592ccd3c7f86828c445b52061d34bd97 0 0 0 0 0  
657 657 20200915 OR 29662 588402   618064 155 2292 34   11   5353 A+ 9/15/2020 03:01 2020-09-15T03:01:00Z 09/14 23:01 519 2292 2020-09-15T03:01:00Z     588402 28223       616625                     41 178 3082 618064 posNeg 3260 618064 8 13 f09d562f676b3e17c8cf60b7b4280456f8918730 0 0 0 0 0  
660 660 20200915 RI 23250 286791   642567 81 2650 9   5   2228 A+ 9/15/2020 12:00 2020-09-15T12:00:00Z 09/15 08:00 1078 2650 2020-09-15T12:00:00Z   32820 609747 23250     642567 310041                     44 120 1724 310041 totalTestEncountersViral 6849 310041 3 6 b31588951f9fa7715fc866acbeffd6220ad178a3 0 0 0 0 0  
666 666 20200915 VA 135514 1656294 329 1785553 1015 17464 228   104   16449 A+ 9/14/2020 17:00 2020-09-14T17:00:00Z 09/14 13:00 2839 17464 2020-09-14T17:00:00Z   154395   129259 2691 148 1785553                       51 943 11536 1792137 posNeg 12395 1791808 96 97 908e7031d8f9aa994afa9f72bd153d4c35e3f7d2 0 0 0 0 0  
668 668 20200915 VT 1702 149890   151592 7           1524 B 9/14/2020 23:59 2020-09-14T23:59:00Z 09/14 19:59 58   2020-09-14T23:59:00Z       1702 58     151592                     50 6 108 151592 posNeg 114 151592 0 0 b5129eef41e16a13c476631bc59b12adb5f1216a 0 0 0 0 0  
669 669 20200915 WA 80465 1585250   1665715 262 7127     28     B 9/15/2020 02:59 2020-09-15T02:59:00Z 09/14 22:59 2015 7127 2020-09-15T02:59:00Z       80465 2015   1665715                       53 327 11421 1665715 posNeg 11748 1665715 9 29 557eecb4d372da6bf07279c457e442152cfac864 0 0 0 0 0  
670 670 20200915 WI 96938 1284525 154 1381463 343 6406 95 1090     79557 A+ 9/15/2020 00:00 2020-09-15T00:00:00Z 09/14 20:00 1229 6406 2020-09-15T00:00:00Z       91304 1220 9   1375829                     55 1441 10918 1381617 posNeg 12359 1381463 11 56 8ea000794e23f27f9752d2397a6da1fe70d9b728 0 0 0 0 0  
677 677 20200914 AZ 208725 1091939   1300664 489 21774 168   81   32975 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 5322 21774 2020-09-14T00:00:00Z       206775 5049 273   1300664 278029                   4 213 4314 1300664 posNeg 4527 1300664 0 1 35fb73fdb9859876cc70fb071b3ee7feba28a1d1 0 0 0 0 0  
679 679 20200914 CO 61324 723206   1124181 228 7227         6162 A+ 9/13/2020 01:59 2020-09-13T01:59:00Z 09/12 21:59 1889 7227 2020-09-13T01:59:00Z       57099     1124181 780305 163290 11326 151964               8 417 6625 784530 totalTestEncountersViral 12609 784530 0 4 5499f96fe8290a616f0bee7910a002eb68554cad 0 0 0 0 0  
681 681 20200914 DC 14622 317526   332148 91   22   8   11592 A+ 9/13/2020 00:00 2020-09-13T00:00:00Z 09/12 20:00 616   2020-09-13T00:00:00Z             332148 195691                     11 30 1477 332148 posNeg 1507 332148 0 0 aae150882a2a67f6fdd9fadfa21be257bf05c02c 0 0 0 0 0  
682 682 20200914 DE 18937 243567   262504 64   18       10091 A+ 9/13/2020 18:00 2020-09-13T18:00:00Z 09/13 14:00 617   2020-09-13T18:00:00Z       17945 545 72   262504                     10 88 1120 262504 posNeg 1208 262504 2 0 11cc751c04e5f5de5698745750b5de15858047d6 0 0 0 0 0  
687 687 20200914 IA 72876 613760   686636 272   75   29   53417 A+ 9/14/2020 00:00 2020-09-14T00:00:00Z 09/13 20:00 1224   2020-09-14T00:00:00Z       72876       688157       53228 3205 49983 16383 2024     19 386 2805 686636 posNeg 3191 686636 6 0 6f5ae77924c1e8810a0a3c663eabb5e892d5ad2a 0 0 0 0 0  
691 691 20200914 KS 49899 408482   458381 192 2572 50 703 15 221 1887 A+ 9/14/2020 10:00 2020-09-14T10:00:00Z 09/14 06:00 534 2572 2020-09-14T10:00:00Z               458381                     20 1513 7938 458381 posNeg 9451 458381 23 35 1b034af2bcf4df3f3218cbc3e1392e7a62cf3611 0 0 0 0 0  
693 693 20200914 LA 158882 1920417   2079299 664       105   140440 A 9/14/2020 13:00 2020-09-14T13:00:00Z 09/14 09:00 5252   2020-09-14T13:00:00Z       157947 5082 170   2078364                     22 492 12077 2079299 posNeg 12569 2079299 17 0 9b093d115307f7223788306f3879cf0a4acd196f 0 0 0 0 0  
698 698 20200914 MN 84949 1158406   1724779 233 6954 135 1965     78238 A+ 9/13/2020 17:00 2020-09-13T17:00:00Z 09/13 13:00 1974 6954 2020-09-13T17:00:00Z       84949 1922 52 1724779 1243355                     27 638 9412 1243355 posNeg 17265 1243355 3 23 95d32e4cdf73880bae2d9c4e53b73ca1d7c8e4b0 0 0 0 0 0  
705 705 20200914 NE 38335 365630   403965 169 2139         29405 A+ 9/14/2020 14:00 2020-09-14T14:00:00Z 09/14 10:00 434 2139 2020-09-14T14:00:00Z       38335       404546                     31 227 3054 403965 posNeg 3281 403965 0 2 8b95f4f62652d8cb3d25aea2a234faaa7a2a7ab4 0 0 0 0 0  
710 710 20200914 NY 444948 8936703   9381651 464 89995 143   59   75814 A 9/13/2020 23:59 2020-09-13T23:59:00Z 09/13 19:59 25394 89995 2020-09-13T23:59:00Z       444948     9381651                       36 583 62775 9381651 posNeg 63358 9381651 4 0 6a2fb762bc87056f5df959d1f8988e03ed4f2e95 0 0 0 0 0  
713 713 20200914 OR 29484 585320   614804 135 2279 32   13   5310 A+ 9/14/2020 03:01 2020-09-14T03:01:00Z 09/13 23:01 511 2279 2020-09-14T03:01:00Z     585320 28051       613371                     41 147 2037 614804 posNeg 2184 614804 2 44 8abd5e46e6040b8518eb3d77d8a6c644aeeb0326 0 0 0 0 0  
716 716 20200914 RI 23130 285067   635718 80 2644 7   4   2223 A+ 9/14/2020 12:00 2020-09-14T12:00:00Z 09/14 08:00 1075 2644 2020-09-14T12:00:00Z   32706 603012 23130     635718 308197                     44 32 682 308197 totalTestEncountersViral 2208 308197 0 0 45832018f86b51472bf29fc8c479bd54d0313a90 0 0 0 0 0  
722 722 20200914 VA 134571 1644758 308 1773158 1006 17367 220   110   16361 A+ 9/13/2020 17:00 2020-09-13T17:00:00Z 09/13 13:00 2743 17367 2020-09-13T17:00:00Z   153493   128400 2607 136 1773158                       51 757 12334 1779637 posNeg 13062 1779329 19 45 5a9e856a017a0e32e8650ae2779fa5e602e56562 0 0 0 0 0  
724 724 20200914 VT 1696 149782   151478 3           1509 B 9/13/2020 23:59 2020-09-13T23:59:00Z 09/13 19:59 58   2020-09-13T23:59:00Z       1696 58     151478                     50 12 793 151478 posNeg 805 151478 0 0 74ca6aaa84710ab29f63faa4ebc7757c697f7846 0 0 0 0 0  

Next page

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