states_daily_4pm_et

Table actions

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

83 rows where "dateModified" is on date 2020-09-01 sorted by deathConfirmed

✎ 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, dateChecked (date)

dateModified (date) ✖

  • 2020-09-01 · 83 ✖
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
4 4 20200926 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b9eccb7369bdc4ee75708c7a892c5437ab915d83 0 0 0 0 0  
60 60 20200925 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 84c6296997b54d1474da9d9c51e33d48fda7fb5b 0 0 0 0 0  
116 116 20200924 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 f949dd0d4f1a5cc85607dc1e308d0088f67199bd 0 0 0 0 0  
172 172 20200923 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 2c46457ee4f802b1f3f14dabbca92ccfbf5670d7 0 0 0 0 0  
228 228 20200922 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 1fbce7d9c6b9b287e0974b92a27198573fb8ecdf 0 0 0 0 0  
284 284 20200921 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 fe2ac904fb66e75d6ba49697cef3e44e5eee9332 0 0 0 0 0  
340 340 20200920 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 3e8d4473820fe86e6e0d374bbcf084d1a4283566 0 0 0 0 0  
396 396 20200919 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 678ba0c96c17a95db48c29d3e95785ec49852061 0 0 0 0 0  
452 452 20200918 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 4953337207aa6ea9f70d3e91b93db3bd67bd2589 0 0 0 0 0  
508 508 20200917 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 54f9bc2755f89f45c7a1fa08c2b1a68d14fdc849 0 0 0 0 0  
564 564 20200916 AS 0 1571   1571               D 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 1e432dfcc52e27d75970f4b590b1e74ec5a025a5 0 0 0 0 0  
620 620 20200915 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 2b445be74daf156f41869a55052b390e3d37ee0e 0 0 0 0 0  
676 676 20200914 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 174cf78dc9ab5615d074020dde4ce99fcd28e6de 0 0 0 0 0  
732 732 20200913 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 3ae357e9638017e50197c3bf2bd193a2569941a7 0 0 0 0 0  
788 788 20200912 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 ca96fa86c9a0c4210a96c86ab92800701dce88ad 0 0 0 0 0  
844 844 20200911 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 af92759401b47f8c1b3777fde5b06c65b773a25a 0 0 0 0 0  
900 900 20200910 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 aafe07069b99c5cb6e3a433727b4d1233cba2abd 0 0 0 0 0  
956 956 20200909 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 0 1571 posNeg 0 1571 0 0 b568d4827408ce320e19f678e9d3d4da52b89bf1 0 0 0 0 0  
1012 1012 20200908 AS 0 1571   1571               C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 0   2020-09-01T00:00:00Z 1571     0                             60 0 57 1571 posNeg 57 1571 0 0 8b4aa9d198cf888bb19a9c536401d3ee1ff86512 0 0 0 0 0  
1351 1351 20200902 CO 57775 660623   1014642 236 7053         5979 A+ 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 1853 7053 2020-09-01T01:59:00Z       53878     1014642 714501 158224 10966 147258               8 351 3279 718398 totalTestEncountersViral 4672 718398 4 25 6390dedf19353347575ce408692f0fd3283149ef 0 0 0 0 0  
1353 1353 20200902 DC 14077 280720   294797 73   22   8   11211 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 608   2020-09-01T00:00:00Z             294797 181300                     11 28 1925 294797 posNeg 1953 294797 1 0 d1f0ef6f6401158f3fbe9c8ca784dccf764b97bc 0 0 0 0 0  
1358 1358 20200902 HI 8653 193533   202186 288 532 48   27   2634 C 9/1/2020 05:59 2020-09-01T05:59:00Z 09/01 01:59 74 532 2020-09-01T05:59:00Z 268461             202186                     15 181 3823 202186 posNeg 4004 202186 4 24 8724e399b3ce098fbc1c4e35b7af67f3e924986c 0 0 0 0 0  
1377 1377 20200902 NE 34574 331067   365641 162 2014         26363 A+ 9/1/2020 20:30 2020-09-01T20:30:00Z 09/01 16:30 399 2014 2020-09-01T20:30:00Z       34574       366056                     31 287 2279 365641 posNeg 2566 365641 2 8 a068acc2e0436c2a35fdb8b5d21e9ea747b4c118 0 0 0 0 0  
1378 1378 20200902 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 0 0 211281 posNeg 0 211281 0 0 3395348e8655ae62da6779299352168bc0f27eb1 0 0 0 0 0  
1380 1380 20200902 NM 25460 739939   765399 72 3151         13073 B 9/1/2020 17:50 2020-09-01T17:50:00Z 09/01 13:50 787 3151 2020-09-01T17:50:00Z 765399     25460                             35 108 4417 765399 posNeg 4525 765399 8 17 ab8d187f8acbf2e2ed838fa238fd53d93e77acd5 0 0 0 0 0  
1382 1382 20200902 NY 436218 7992259   8428477 445 89995 117   61   75203 A 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 25336 89995 2020-09-01T23:59:00Z       436218     8428477                       36 708 87739 8428477 posNeg 88447 8428477 5 0 5ea8d5920a5729dc75a1fe74eba5f9d63e9e6f50 0 0 0 0 0  
1390 1390 20200902 SD 14003 134922   148925 77 1043         10959 A+ 9/1/2020 14:00 2020-09-01T14:00:00Z 09/01 10:00 169 1043 2020-09-01T14:00:00Z 196300             148925                     46 254 1076 148925 posNeg 1330 148925 2 7 b52d98839e181c97da17a6b2eb17eb71c7b543a0 0 0 0 0 0  
1403 1403 20200901 AR 61497 669528   731025 423 4306     85 554 55647 A 9/1/2020 14:38 2020-09-01T14:38:00Z 09/01 10:38 814 4306 2020-09-01T14:38:00Z 731025   669528 61497                         12508 1894 5 273 3717 731025 posNeg 3990 731025 17 93 f3415132c1f902634219223bd58c97173d552a8f 0 0 0 0 0  
1406 1406 20200901 CA 707797 10762899   11470696 4869   1352         B 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 13018   2020-09-01T02:59:00Z 11470696     707797                             6 3712 93679 11470696 posNeg 97391 11470696 85 0 84d8e0d2015f6b693b70c314aac4b9dfcfc40aef 0 0 0 0 0  
1412 1412 20200901 GA 272697 2095801   2368498 2488 24847   4537       A+ 9/1/2020 14:50 2020-09-01T14:50:00Z 09/01 10:50 5733 24847 2020-09-01T14:50:00Z 2368498 249498 2119000 272697         278431 21400                 13 2226 22638 2368498 posNeg 24864 2368498 101 243 0f985f8df92d34b224978140a090e788d71b1d6c 0 0 0 0 0  
1413 1413 20200901 GU 1447 36875   38322 43   4       568 A+ 9/1/2020 05:25 2020-09-01T05:25:00Z 09/01 01:25 13   2020-09-01T05:25:00Z 38312     1439       38314 158 2                 66 52 386 38322 posNeg 438 38322 3 0 6c1d8856ee1834463c1e06d0e211680206a10819 0 0 0 0 0  
1415 1415 20200901 IA 63919 559628   623547 311   88   43   47437 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1123   2020-09-01T00:00:00Z       63919       625058       49415 3071 46304 12398 1558     19 591 2084 623547 posNeg 2675 623547 7 0 617dedf9dabc6d700ee2628bdee277f3b7800708 0 0 0 0 0  
1427 1427 20200901 MO 85755 905489   991244 906       110     A 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1538   2020-09-01T00:00:00Z 1305031 96068 1206684 85755       991244       69005 2908 66097         29 1058 7231 991244 posNeg 8289 991244 8 0 9e6cfcc0dbd5d46af287d8d89618a0598321c923 0 0 0 0 0  
1430 1430 20200901 MT 7509 244787   252296 140 447         5459 B 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 105 447 2020-09-01T01:59:00Z 252296     7509                             30 88 1970 252296 posNeg 2058 252296 1 11 9b450ea667382d582afd90debb22555d5b651a08 0 0 0 0 0  
1434 1434 20200901 NH 7297 203984   329116 8 715   221     6634 B 9/1/2020 09:00 2020-09-01T09:00:00Z 09/01 05:00 432 715 2020-09-01T09:00:00Z 329116     7297       211281 30385     29761             33 22 343 211281 posNeg 1021 211281 0 1 bed06694de17f15dd5d239e76edcb7bd962127e9 0 0 0 0 0  
1437 1437 20200901 NV 69633 530716   600349 643   193   119   1798 A+ 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 1313   2020-09-01T02:59:00Z 859175     69633       599812                     32 405 2023 600349 posNeg 2428 600349 8 0 4ac829e935d0ee8dd9327c1fc95899f2ac2a8d41 0 0 0 0 0  
1440 1440 20200901 OK 59399 827513 2776 886912 535 4903 207       49989 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 809 4903 2020-09-01T00:00:00Z 898288 69077 827513 59399         68964 3006                 40 666 20968 889688 posNeg 21634 886912 9 82 9f13e6b5899ebb0ee34a06a835d5df054da853e8 0 0 0 0 0  
1441 1441 20200901 OR 26946 534854   561800 132 2162 49   25   4938 A+ 9/1/2020 03:01 2020-09-01T03:01:00Z 08/31 23:01 465 2162 2020-09-01T03:01:00Z     534854 25639       560493                     41 233 4339 561800 posNeg 4572 561800 6 13 21741fda8f80ceedfcbdc3bd2af8aaef4308b031 0 0 0 0 0  
1442 1442 20200901 PA 134795 1539969   1674764 528       73   109183 A+ 9/1/2020 12:00 2020-09-01T12:00:00Z 09/01 08:00 7691   2020-09-01T12:00:00Z       130961       1670930                     42 770 15774 1674764 posNeg 16544 1674764 18 0 e5450e32195ed7e27d68330dc90c030c3263966c 0 0 0 0 0  
1444 1444 20200901 RI 22002 254480   530488 81 2528 8   5   2113 A+ 9/1/2020 12:00 2020-09-01T12:00:00Z 09/01 08:00 1050 2528 2020-09-01T12:00:00Z   31281 499207 22002     530488 276482                     44 53 2532 276482 totalTestEncountersViral 6074 276482 2 9 214dfdf5c85fb708ca4a7f359d1b0687ebc32e61 0 0 0 0 0  
1448 1448 20200901 TX 617333 4416221   5033554 4144   1525       514861 A+ 9/1/2020 16:30 2020-09-01T16:30:00Z 09/01 12:30 12681   2020-09-01T16:30:00Z 5033554     617333         359593 30159             25577 3529 48 4364 67637 5033554 posNeg 72001 5033554 145 0 9f5bc1a8d744d0b67826563d851e730271ce700e 0 0 0 0 0  
1449 1449 20200901 UT 52403 612118   664521 145 3110 44 780   322 44338 A+ 9/1/2020 11:08 2020-09-01T11:08:00Z 09/01 07:08 409 3110 2020-09-01T11:08:00Z 823155     52403       664521             4710 981 5706 1046 49 296 4370 664521 posNeg 4666 664521 2 17 ea13ea22474fbb9ff4257cf170c33d2d7bd68bd4 0 0 0 0 0  
1456 1456 20200901 WY 3866 72701   76567 13 219         3206 A 9/1/2020 17:36 2020-09-01T17:36:00Z 09/01 13:36 41 219 2020-09-01T17:36:00Z 108187 3137 105049 3282       75983                     56 24 270 76567 posNeg 294 76567 4 4 7f800359a42e19161fb7291822ba50846451e076 0 0 0 0 0  
1454 1454 20200901 WI 81604 1183717 167 1265321 295 5878 100 1026     67902 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 1139 5878 2020-09-01T00:00:00Z       76584 1130 9   1260301                     55 1036 10863 1265488 posNeg 11899 1265321 9 61 ac18dec967f45ae62eb2811aac97da85ccfe5f93 0 0 0 0 0  
1355 1355 20200902 FL 633442 4060360 3515 4693802 3511 39611           A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 11651 39611 2020-09-01T23:59:00Z 6461035 815752 5608276 633442 11651     4700822 446669 34738 411877 437913 34017 403867   9489     12 2402 15534 4697317 posNeg 17936 4693802 130 300 1d3a0eb59cf90c76cb7f2bd307324bee0e49f4f9 0 0 0 0 0  
1432 1432 20200901 ND 12004 190418   458586 62 564 15 152     9610 A 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 122 564 2020-09-01T01:59:00Z 473749     12004 118 4 458586 201357 8616 338 8278               38 194 473 202422 totalTestEncountersViral 2396 202422 4 10 8166581d2e21ed24982d9b4fa86bb4909488a82a 0 0 0 0 0  
1368 1368 20200902 ME 4567 268465   273032 11 423 6   1   3978 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 133 423 2020-09-01T23:59:00Z 272565 5717 266604 4100 132 1     9646 480 9153               23 19 4278 273032 posNeg 4297 273032 1 2 5ee2ed8982e8321d7ef56976957862f1f2963b41 0 0 0 0 0  
1435 1435 20200901 NJ 192290 2666758   2859048 463 22667 84   33   33949 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 15960 22667 2020-09-01T00:00:00Z 2857918     192290 14170 1790                         34 330 800 2859048 posNeg 1130 2859048 5 40 6c4d6881b8d20d680fa1dba9f0d4096b2ac5eb3f 0 0 0 0 0  
1395 1395 20200902 VI 1143 15343 19 16486             998 C 9/1/2020 19:17 2020-09-01T19:17:00Z 09/01 15:17 15   2020-09-01T19:17:00Z 16505       15                           78 4 95 16505 posNeg 99 16486 0 0 3b8ca2af404e5b1fec4fb5016cc008a266cb524b 0 0 0 0 0  
1447 1447 20200901 TN 156329 2061422   2217751 1037 6978 348   164   118885 A+ 9/1/2020 15:00 2020-09-01T15:00:00Z 09/01 11:00 1781 6978 2020-09-01T15:00:00Z 2213949 184950 2028999 152527 1729 52                         47 1396 15356 2217751 posNeg 16752 2217751 27 100 e9ee87313e3f309329f02c06b8155cdc7e9b08f9 0 0 0 0 0  
1370 1370 20200902 MN 77085 1073769   1525555 297 6566 135 1854     69521 A+ 9/1/2020 17:00 2020-09-01T17:00:00Z 09/01 13:00 1882 6566 2020-09-01T17:00:00Z       77085 1830 52 1525555 1150854                     27 730 17202 1150854 posNeg 26636 1150854 10 46 93e58ce82258beca7ca6b038a968036a85ca62d8 0 0 0 0 0  
1397 1397 20200902 WA 74939 1405100   1480039 328 6787     48     B 9/1/2020 02:59 2020-09-01T02:59:00Z 08/31 22:59 1931 6787 2020-09-01T02:59:00Z       74939 1931   1480039                       53 304 6490 1480039 posNeg 6794 1480039 16 24 cc7e7d883eee90615748714463203cdad2465dc6 0 0 0 0 0  
980 980 20200909 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 0 0 13543 posNeg 0 13543 0 0 03d6e521defdae0ad99269ea3876502901160d28 0 0 0 0 0  
1036 1036 20200908 MP 59 13484   13543   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     59 2     13540                     69 1 0 13543 posNeg 1 13543 0 0 53b32a99df9b81349f8c9e7f038fa5b72c7bc572 0 0 0 0 0  
1092 1092 20200907 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 775d656966bf522797679c0f5ef1cd8d8ae1faa5 0 0 0 0 0  
1148 1148 20200906 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 0 0 13542 posNeg 0 13542 0 0 27b844b60ca92a40925110b9427cbf144ff71f17 0 0 0 0 0  
1204 1204 20200905 MP 58 13484   13542   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     58 2     13540                     69 1 0 13542 posNeg 1 13542 0 0 6b3c8da17601c70b994000e32f6a15e806c32556 0 0 0 0 0  
1260 1260 20200904 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6a5775dfc03759ee10f326a446c010dc219d4e3b 0 0 0 0 0  
1316 1316 20200903 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 6d3fbada05132b8f400b437dbc810b415fc98952 0 0 0 0 0  
1372 1372 20200902 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 0 0 13541 posNeg 0 13541 0 0 a431b7eb0449131837e1789a13858652ace850cf 0 0 0 0 0  
1428 1428 20200901 MP 57 13484   13541   4         29 C 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2 4 2020-09-01T00:00:00Z 17626     57 2     13540                     69 1 0 13541 posNeg 1 13541 0 0 29df9ccd3c08f0f2abac3816e10084cc5a034b82 0 0 0 0 0  
1402 1402 20200901 AL 127616 831304   949438 990 14538   1487   817 48028 B 9/1/2020 11:00 2020-09-01T11:00:00Z 09/01 07:00 2200 14538 2020-09-01T11:00:00Z 949438     118134 2102 98           54076             1 1558 -27925 958920 posNeg -26943 958920 18 271 c06dbcde8a46d1053003865c92d2ffafd4d16645 0 0 0 0 0  
1399 1399 20200902 WV 10642 430943   441585 146   48   27   8266 C 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 230   2020-09-01T23:59:00Z 441396     10453 228 2     16019                   54 135 3009 441585 posNeg 3144 441585 8 0 26a782dbb4c7f4c54255145c75bef9be593891ad 0 0 0 0 0  
1429 1429 20200901 MS 83584 493933   577517 798 5326 196   117   67918 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2493 5326 2020-09-01T00:00:00Z 573583     79650 2337 156     26337 95             31360   28 634 3018 577517 posNeg 3652 577517 20 0 eb269dba58ffd9ac5a6927dc36aacfc41f176044 0 0 0 0 0  
1373 1373 20200902 MS 84365 497221   581586 856 5326 190   111   67918 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 2526 5326 2020-09-01T00:00:00Z 577414     80193 2364 162     26774 95             31722   28 781 3288 581586 posNeg 4069 581586 33 0 ff1e002516a9e9fc5f444324946ae8fb38dcb84f 0 0 0 0 0  
1394 1394 20200902 VA 122542 1488149 278 1605290 1114 16433 266   134   15319 A+ 9/1/2020 17:00 2020-09-01T17:00:00Z 09/01 13:00 2641 16433 2020-09-01T17:00:00Z   140932   117141 2508 133 1605290                       51 927 11075 1610969 posNeg 11922 1610691 29 195 536d928de5c9f1057852c1f20f42ac78749de253 0 0 0 0 0  
1389 1389 20200902 SC 120503 838529   959032 892 7948 228   145   51431 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 2794 7948 2020-09-01T23:59:00Z 957228 154856 802372 118699 2652 142     63448 5313 58135               45 657 3973 959032 posNeg 4630 959032 37 78 59582a3cfdb2746c194544988cb07a0badbf0f74 0 0 0 0 0  
1431 1431 20200901 NC 169424 2126274   2295698 946   270       145884 A+ 9/1/2020 12:20 2020-09-01T12:20:00Z 09/01 08:20 2741   2020-09-01T12:20:00Z 2295698     169424 2741                           37 2111 37415 2295698 posNeg 39526 2295698 39 0 35b60e27ced475a9a764bcf6a5d6986a452ee240 0 0 0 0 0  
1443 1443 20200901 PR 33421 305972   339393 392   71   51     B 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 435   2020-09-01T00:00:00Z 310546 7002 303412 15584 288 147       17837                 72 222 0 339393 posNeg 222 339393 1 0 21a9ecfe1a882b2a40902a762527f29f437dd4b8 0 0 0 0 0  
1362 1362 20200902 IN 95750 996846   1092596 887 11143 247 2237 69   73390 A+ 9/1/2020 23:59 2020-09-01T23:59:00Z 09/01 19:59 3325 11143 2020-09-01T23:59:00Z 1457009       3106 219   1092596                     18 859 7972 1092596 posNeg 8831 1092596 13 49 1fa59c56dfc390f291cab061f6cc5eac55b378d2 0 0 0 0 0  
1360 1360 20200902 ID 32368 226728   256697 162 1394 46 381     15212 A+ 9/1/2020 19:00 2020-09-01T19:00:00Z 09/01 15:00 368 1394 2020-09-01T19:00:00Z 256697     29969 333 35                         16 280 1127 259096 posNeg 1349 259096 7 0 ac6e090f2820949ec145b2e024ef8040625ea770 0 0 0 0 0  
1352 1352 20200902 CT 53108 1150871   1203979 65 11180         8967 B 9/1/2020 20:30 2020-09-01T20:30:00Z 09/01 16:30 4467 11180 2020-09-01T20:30:00Z 1201849     50978 3582 885                         9 102 11539 1203979 posNeg 11641 1203979 1 0 01ab76762b7d3161278f70030767edd0184b0e60 0 0 0 0 0  
1423 1423 20200901 MD 108863 1230054   1338917 385 14337 112       6976 A+ 9/1/2020 10:00 2020-09-01T10:00:00Z 09/01 06:00 3761 14337 2020-09-01T10:00:00Z 1952501 129682   108863 3617 144   1338917                     24 614 7450 1338917 posNeg 8064 1338917 6 34 09ba7eb99e59e61babb72d9c0cb90d697d675bbd 0 0 0 0 0  
1439 1439 20200901 OH 124610 2145059   2269669 777 13479 241 2975 127   104024 A+ 9/1/2020 14:00 2020-09-01T14:00:00Z 09/01 10:00 4165 13479 2020-09-01T14:00:00Z 2263107     118048 3879 286                         39 1453 24112 2269669 posNeg 25565 2269669 27 103 cd8aecf1fa4bf4b3584158398cc100080fbef846 0 0 0 0 0  
1401 1401 20200901 AK 6160 368095   374255 41       9   2246 A 9/1/2020 03:59 2020-09-01T03:59:00Z 08/31 23:59 39   2020-09-01T03:59:00Z 374255 5974 367949 6160 39                           2 35 25590 374255 posNeg 25625 374255 2 0 5bb6d9d2b71cda18e77331f3d68c177b957c13e5 0 0 0 0 0  
1405 1405 20200901 AZ 202342 1006648   1207256 729 21405 253   150   30841 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 5044 21405 2020-09-01T00:00:00Z       200608 4777 267   1207256 267953                   4 507 4054 1208990 posNeg 4558 1208990 15 0 d4b1417c32745a6bff5fd09f9933cd9aab7659b7 0 0 0 0 0  
1421 1421 20200901 LA 149583 1740943   1890526 910       128   127918 A 9/1/2020 13:00 2020-09-01T13:00:00Z 09/01 09:00 4984   2020-09-01T13:00:00Z       148882 4821 163   1889825                     22 689 16347 1890526 posNeg 17036 1890526 34 0 26bc2f76c96509b5349f49498891ac763478e0f8 0 0 0 0 0  
1354 1354 20200902 DE 17549 222981   240530 62   9       9467 A+ 9/1/2020 18:00 2020-09-01T18:00:00Z 09/01 14:00 606   2020-09-01T18:00:00Z       16557 534 72   240530                     10 14 2093 240530 posNeg 2107 240530 1 0 add38598290fa882e2083f84bed00763579b58a6 0 0 0 0 0  
1396 1396 20200902 VT 1637 137459   139096 2           1433 B 9/1/2020 23:39 2020-09-01T23:39:00Z 09/01 19:39 58   2020-09-01T23:39:00Z       1637 58     139096                     50 2 648 139096 posNeg 650 139096 0 0 4459e7c9ce9fe2a527e63a99e787803b1932de82 0 0 0 0 0  
1425 1425 20200901 MI 113820 2675587   2789407 629   156   83   76151 A+ 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 6767   2020-09-01T00:00:00Z 2821258 145671 2675587 103186 6495 272     258577                   26 795 24181 2789407 posNeg 24976 2789407 14 0 23bde657bac2c6873e6a2743fc5f3d525236e29c 0 0 0 0 0  
1417 1417 20200901 IL 238217 3850607   4088824 1513   362   146     A 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 8273   2020-09-01T00:00:00Z 4087122     236515 8064 209                         17 1492 21469 4088824 posNeg 22961 4088824 38 0 7a6a2d735958657eaa860408ad6873a7b97b1408 0 0 0 0 0  
1422 1422 20200901 MA 128888 1635284   2448341 320 12386 55   29   103920 A+ 9/1/2020 08:00 2020-09-01T08:00:00Z 09/01 04:00 9064 12386 2020-09-01T08:00:00Z 2448341 156836   119138 8831 232   1754422       112996     87251       25 355 21300 1764172 totalTestsViral 43915 1764172 4 22 23fbac77ffd06460ad5cc17dd381cb96f3a38817 0 0 0 0 0  
1420 1420 20200901 KY 49185 781236   826060 552 4616 138 1391     10417 B 9/1/2020 00:00 2020-09-01T00:00:00Z 08/31 20:00 948 4616 2020-09-01T00:00:00Z 826060     44824 939 9     46878               14609   21 789 8312 830421 posNeg 8924 830421 15 36 dd39a90c4a20e6331da6170bb9e8623bf2dda66e 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
);