states_daily_4pm_et

Table actions

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

69 rows where "dateModified" is on date 2020-07-01 sorted by totalTestsPeopleViral

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

dateModified (date) ✖

  • 2020-07-01 · 69 ✖
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
4092 4092 20200715 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 2a9ec16e2a7ed924205fb641de62ec01632edf08 0 0 0 0 0  
4148 4148 20200714 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 955c53831bad4949b4d03fe9bb1d9cfba78862d0 0 0 0 0 0  
4204 4204 20200713 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 e0d4b909d0c23cd27d434e52fbf6d47150231a46 0 0 0 0 0  
4260 4260 20200712 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 38096a8ec3443e118bb1a8226ba464c94dcb7129 0 0 0 0 0  
4316 4316 20200711 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 7c631e0814901bb1cab7149f914513e6374e7f91 0 0 0 0 0  
4372 4372 20200710 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 45b631b10fec7f226d287c435323b45ea2fa549d 0 0 0 0 0  
4428 4428 20200709 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 0 816 posNeg 0 816 0 0 a00d54cf2894f39530332f980cac1071babb9d6d 0 0 0 0 0  
4484 4484 20200708 AS 0 816   816               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 816     0                             60 0 120 816 posNeg 120 816 0 0 6718a8e10d9a238444b20ecef43a5141ff2a60f3 0 0 0 0 0  
4540 4540 20200707 AS 0 696   696               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 696     0                             60 0 0 696 posNeg 0 696 0 0 a90db7511e08ff06196e0412d02ff2a5ffa97f24 0 0 0 0 0  
4596 4596 20200706 AS 0 696   696               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 696     0                             60 0 0 696 posNeg 0 696 0 0 0fa0a0e50b4470eb6ec7ace32da91b0cf7635534 0 0 0 0 0  
4652 4652 20200705 AS 0 696   696               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 696     0                             60 0 0 696 posNeg 0 696 0 0 2f7ddff71e577262100f9d2744ce6387d69cc05b 0 0 0 0 0  
4708 4708 20200704 AS 0 696   696               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 696     0                             60 0 0 696 posNeg 0 696 0 0 e205fbc4d7546d1a2387dad0e5c0a1fed3cb2d53 0 0 0 0 0  
4764 4764 20200703 AS 0 696   696               C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 0   2020-07-01T00:00:00Z 696     0                             60 0 0 696 posNeg 0 696 0 0 3d09c4fd3db304955f7b8e58c569718d9edd89b4 0 0 0 0 0  
4789 4789 20200703 MS 28770 270269   299039 863 3208 167   94   19388 A 7/1/2020 19:00 2020-07-01T19:00:00Z 07/01 15:00 1092 3208 2020-07-01T19:00:00Z 298842     28573 1074 18     12055 95                 28 0 0 299039 posNeg 0 299039 0 0 23fee074ef4648ad3e4f15dc4692ad79d9bdb966 0 0 0 0 0  
4824 4824 20200702 CT 46646 453468   500114 101 10411         8210 B 7/1/2020 20:30 2020-07-01T20:30:00Z 07/01 16:30 4326 10411 2020-07-01T20:30:00Z 497693     44225 3459 867                         9 74 10231 500114 posNeg 10305 500114 2 143 9e517be64b1a6d5e734c2923d2da25aff0d178ee 0 0 0 0 0  
4832 4832 20200702 ID 6370 88751   94537 69 340 17 118     4393 A 7/1/2020 19:00 2020-07-01T19:00:00Z 07/01 15:00 92 340 2020-07-01T19:00:00Z 94537     5786 72 20                         16 253 3828 95121 posNeg 4061 95121 0 10 ab939194dcb44e82ee42100555722acf2d43ea5f 0 0 0 0 0  
4840 4840 20200702 ME 3328 97489   100817 30 354 9   3   2698 A+ 7/1/2020 23:59 2020-07-01T23:59:00Z 07/01 19:59 105 354 2020-07-01T23:59:00Z 100440 4026 96272 2951 104 1     7548 345 7194               23 34 3542 100817 posNeg 3576 100817 0 3 d57966575860a79d2835c2cc42add00f680d386b 0 0 0 0 0  
4842 4842 20200702 MN 37210 593217   630427 274 4112 123 1266     32163 A 7/1/2020 17:00 2020-07-01T17:00:00Z 07/01 13:00 1495 4112 2020-07-01T17:00:00Z       37210 1458 37 630427                       27 494 12826 630427 posNeg 13320 630427 13 31 677354100bd3d82d6642685da6a93a5f4447c728 0 0 0 0 0  
4845 4845 20200702 MS 28770 270269   299039 863 3208 167   94   19388 A 7/1/2020 19:00 2020-07-01T19:00:00Z 07/01 15:00 1092 3208 2020-07-01T19:00:00Z 298842     28573 1074 18     12055 95                 28 870 4417 299039 posNeg 5287 299039 10 31 c42041630c002101b202e4a43d89fc056f2c7d20 0 0 0 0 0  
4852 4852 20200702 NM 12276 337784   350060 127 1928         5514 B 7/1/2020 17:50 2020-07-01T17:50:00Z 07/01 13:50 500 1928 2020-07-01T17:50:00Z 350060     12276                             35 129 5750 350060 posNeg 5879 350060 3 26 2b714161ab3370e1773deebc834d7f3153a789ad 0 0 0 0 0  
4854 4854 20200702 NY 394954 3646639   4041593 878 89995 209   129   70698 A 7/1/2020 23:59 2020-07-01T23:59:00Z 07/01 19:59 24877 89995 2020-07-01T23:59:00Z       394954     4041593                       36 875 69070 4041593 posNeg 69945 4041593 11 0 20a6de17f32d9f2b8d5aa5c7085e74406b9f906e 0 0 0 0 0  
4855 4855 20200702 OH 54166 739140   793306 724 8038 244 2035 116   38987 B 7/1/2020 14:00 2020-07-01T14:00:00Z 07/01 10:00 2903 8038 2020-07-01T14:00:00Z 788403     50523 2653 250                         39 1301 0 793306 posNeg 1301 793306 27 127 54a1952a11d6fe669d0a3ab9f94472f8422097bc 0 0 0 0 0  
4866 4866 20200702 VA 63735 610521 343 684558 888 9384 206   95   8496 A+ 7/1/2020 17:00 2020-07-01T17:00:00Z 07/01 13:00 1816 9384 2020-07-01T17:00:00Z   75964   61039 1712 104 684558                       51 532 15091 674599 posNeg 12640 674256 30 361 d4c0abde17c3818be269439ab72067a3d8bdf593 0 0 0 0 0  
4867 4867 20200702 VI 92 2924 39 3016             75 C 7/1/2020 21:36 2020-07-01T21:36:00Z 07/01 17:36 6   2020-07-01T21:36:00Z 3055       6                           78 2 48 3055 posNeg 50 3016 0 0 49b4ff53c49e3de423f1912e306e13fb9470b09e 0 0 0 0 0  
4873 4873 20200701 AK 978 113422   114400 20       2   528 A 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 14   2020-07-01T00:00:00Z 114400     978 14                           2 38 2177 114400 posNeg 2215 114400 0 0 40a5821df23974ca630ae2c0af99ec2a08550581 0 0 0 0 0  
4874 4874 20200701 AL 38962 374991   413433 809 2803   814   464 18866 B 7/1/2020 11:00 2020-07-01T11:00:00Z 07/01 07:00 972 2803 2020-07-01T11:00:00Z 413433     38442 947 25                         1 917 6384 413953 posNeg 7290 413953 22 34 47b9c09c547491e6e2c3ae633ed33f2212de9c96 0 0 0 0 0  
4875 4875 20200701 AR 21197 293661   314858 275 1448     72 224 15163 A 7/1/2020 14:36 2020-07-01T14:36:00Z 07/01 10:36 277 1448 2020-07-01T14:36:00Z 314858     21197                             5 420 3235 314858 posNeg 3655 314858 7 35 f0c77ed0aeb8b7f497ad1c1be7f93c9d43678896 0 0 0 0 0  
4878 4878 20200701 CA 236139 4018037   4254176 6612   1859         B 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 6090   2020-07-01T00:00:00Z 4254176     236139                             6 7407 79630 4254176 posNeg 87037 4254176 110 0 4b7053fe0b4212852a09d83aab5e43fb5068b06e 0 0 0 0 0  
4884 4884 20200701 GA 84237 770801   855038 1570 11275   2357       A 7/1/2020 14:57 2020-07-01T14:57:00Z 07/01 10:57 2827 11275 2020-07-01T14:57:00Z 855038 76664 778374 84237         157971 8556                 13 2946 18214 855038 posNeg 21160 855038 22 224 2ce1f131515e3a1e2e82b316b0c5f3b38a3024d1 0 0 0 0 0  
4889 4889 20200701 IL 145066 1492042   1637108 1511   384   189     A 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 7152   2020-07-01T00:00:00Z 1636055     144013 6951 201                         17 828 32262 1637108 posNeg 33090 1637108 28 0 8aef3f33d2069754908701360bfd4501ca34a543 0 0 0 0 0  
4892 4892 20200701 KY 15842 361248   376534 427 2635 73 1007     4052 B 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 572 2635 2020-07-01T00:00:00Z 376534     15286 568 4     34683                   21 218 5938 377090 posNeg 6134 377090 7 14 84502e3f3bcedb8baafc3ce5c516b3e0ea5352cd 0 0 0 0 0  
4897 4897 20200701 MI 71089 990770   1061859 471   179   103   51099 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 6198   2020-07-01T00:00:00Z 1078989 88219 990770 64132 5951 247     162911                   26 361 16441 1061859 posNeg 16802 1061859 5 0 ab7023407916559807d9628f6a51e9abcf87ded2 0 0 0 0 0  
4902 4902 20200701 MT 1016 92314   93330 14 105         658 C 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 22 105 2020-07-01T00:00:00Z 93330     1016                             30 49 2420 93330 posNeg 2469 93330 0 4 709daa54b986734ce3a4640ee627d6da84819bd6 0 0 0 0 0  
4903 4903 20200701 NC 66513 875725   942238 901           45538 A 7/1/2020 12:30 2020-07-01T12:30:00Z 07/01 08:30 1373   2020-07-01T12:30:00Z 942238     66513 1373                           37 1843 30362 942238 posNeg 32205 942238 30 0 dd6c9c7e3e5ba654e8998dd7472e741a824a6586 0 0 0 0 0  
4907 4907 20200701 NJ 171928 1271009   1442937 1080 20054 217   178   30300 A+ 7/1/2020 13:00 2020-07-01T13:00:00Z 07/01 09:00 14996 20054 2020-07-01T13:00:00Z 1442937     171928 13224 1772                         34 261 20302 1442937 posNeg 20563 1442937 43 207 37ad4254c9e6c529f60e2987f3d4cebe3db59df8 0 0 0 0 0  
4911 4911 20200701 OH 52865 739140   792005 724 7911 244 2008 116     B 7/1/2020 14:00 2020-07-01T14:00:00Z 07/01 10:00 2876 7911 2020-07-01T14:00:00Z 788403     49263 2626 250                         39 1076 3000 792005 posNeg 4076 792005 13 72 8f4fc0c91ed91608179a4b6d817d6ba85c018a4b 0 0 0 0 0  
4912 4912 20200701 OK 14112 332201   346313 374 1553 159       10605 A+ 7/1/2020 08:00 2020-07-01T08:00:00Z 07/01 04:00 389 1553 2020-07-01T08:00:00Z 348350 15387 332201 14112         34490 1171                 40 355 4361 346313 posNeg 4716 346313 2 33 653378733cb9cdafc593015a2c9543a3b12cf008 0 0 0 0 0  
4915 4915 20200701 PR 7537 192686   200223 121   7   3     C 7/1/2020 06:30 2020-07-01T06:30:00Z 07/01 02:30 153   2020-07-01T06:30:00Z 194324 2627 191601 1729 59 94       5808                 72 72 0 200223 posNeg 72 200223 0 0 d01a4e43ba2e7c95596d3f92d4b78bdc5eab31d5 0 0 0 0 0  
4919 4919 20200701 TN 45315 772571   817886 955 2715         28283 B 7/1/2020 15:00 2020-07-01T15:00:00Z 07/01 11:00 609 2715 2020-07-01T15:00:00Z 817522 52617 764905 44951 583 26                         47 1806 22953 817886 posNeg 24759 817886 5 50 5ad2291867da490a6acdb42b0113a7d5bbd36e8d 0 0 0 0 0  
4920 4920 20200701 TX 168062 1753886   1921948 6904           87556 B 7/1/2020 16:50 2020-07-01T16:50:00Z 07/01 12:50 2481   2020-07-01T16:50:00Z 1921948     168062         197088 7234                 48 8076 44590 1921948 posNeg 52666 1921948 57 0 6c295e556c69766908fa370d30a6c516d96f8a1a 0 0 0 0 0  
4923 4923 20200701 VI 90 2876 6 2966             73 C 7/1/2020 03:34 2020-07-01T03:34:00Z 06/30 23:34 6   2020-07-01T03:34:00Z 2972       6                           78 6 57 2972 posNeg 63 2966 0 0 2fab7e0eb0b21ee2fe4946159a797230beb1e51f 0 0 0 0 0  
4927 4927 20200701 WV 2932 170420   173352 23   5   3   2284 B 7/1/2020 10:00 2020-07-01T10:00:00Z 07/01 06:00 93   2020-07-01T10:00:00Z 173251     2831         9918                   54 27 1561 173352 posNeg 1588 173352 0 0 2be5affb57137c5533abfe755e1f7e87568bbb0b 0 0 0 0 0  
4904 4904 20200701 ND 3613 103611   180927 20 234         3210 D 7/1/2020 13:00 2020-07-01T13:00:00Z 07/01 09:00 78 234 2020-07-01T13:00:00Z 184779     3613 69 9 180927 104898 4976 186 4790               38 39 1065 107224 totalTestEncountersViral 2459 107224 0 3 0be211227c2e5c04571ca41bd618430789e59c3e 0 0 0 0 0  
4826 4826 20200702 DE 11731 103187   114918 67   16       6678 A+ 7/1/2020 18:00 2020-07-01T18:00:00Z 07/01 14:00 510   2020-07-01T18:00:00Z       10687 453 57   114918                     10 221 3313 114918 posNeg 3534 114918 1 0 ceae2adf56b9444daf7e0e68f221ca6f0f7c8c50 0 0 0 0 0  
4850 4850 20200702 NH 5802 114505   156642 32 565   162     4491 B 7/1/2020 09:00 2020-07-01T09:00:00Z 07/01 05:00 373 565 2020-07-01T09:00:00Z 156642     5802       120307 22605     19483             33 20 1118 120307 posNeg 3714 120307 2 0 f4901cbef4abec05c1c09c04d4a2b22e2b4b1696 0 0 0 0 0  
4829 4829 20200702 GU 280 13653   13933 1           179 B 7/1/2020 22:10 2020-07-01T22:10:00Z 07/01 18:10 5   2020-07-01T22:10:00Z 13925     272       13925 128 2                 66 13 136 13933 posNeg 149 13933 0 0 8e629cc25f4266c91f72b54c91af1c3df310e49e 0 0 0 0 0  
4916 4916 20200701 RI 16976 139063   257151 69 2007 11   11   1638 A+ 7/1/2020 03:00 2020-07-01T03:00:00Z 06/30 23:00 956 2007 2020-07-01T03:00:00Z 255735 24284 231451 16976     257151 156039                     44 65 1891 156039 totalTestEncountersViral 1997 156039 6 6 3d5a3f8959edc48e8ecfe2d280a1175e42f7354a 0 0 0 0 0  
4849 4849 20200702 NE 19310 163352   182662 117 1343         13807 B 7/1/2020 19:54 2020-07-01T19:54:00Z 07/01 15:54 276 1343 2020-07-01T19:54:00Z       19310       182880                     31 133 1921 182662 posNeg 2054 182662 2 13 ed5dd67522cfaffb747c92d8cb040c13f5fe61c1 0 0 0 0 0  
4827 4827 20200702 FL 169106 1863077 1683 2032183   15454           A 7/1/2020 23:59 2020-07-01T23:59:00Z 07/01 19:59 3718 15454 2020-07-01T23:59:00Z 2449162 216375 2228207 169106 3718     2033794       236304 9575 226699         12 10109 41720 2033866 posNeg 51829 2032183 68 329 a64cfdc9e49903f9860e2eeffdd84f21a171a615 0 0 0 0 0  
4913 4913 20200701 OR 8931 234429   243360 192 1055 62   24   2722 A+ 7/1/2020 03:01 2020-07-01T03:01:00Z 06/30 23:01 208 1055 2020-07-01T03:01:00Z     234429 8525       242954                     41 275 5451 243360 posNeg 5726 243360 1 17 00d117f324624ec5d1e88f841277a0fea28b278d 0 0 0 0 0  
4909 4909 20200701 NV 19101 264995   284096 630   142   74   714 A+ 7/1/2020 11:30 2020-07-01T11:30:00Z 07/01 07:30 511   2020-07-01T11:30:00Z 331318     19101       282805                     32 645 5883 284096 posNeg 6528 284096 4 0 862b4b6b6040aa26e7890b7e4d0483f711b05bd4 0 0 0 0 0  
4887 4887 20200701 IA 29451 280339   309790 149   37   21   23607 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 717   2020-07-01T00:00:00Z       29451       310218       32844 2315 30496         19 444 5158 309790 posNeg 5602 309790 2 0 c77080128af8aea4c4d2ed68c0f2281de4a2491d 0 0 0 0 0  
4823 4823 20200702 CO 33029 300226   401617 262 5513         4524 A 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 1520 5513 2020-07-01T00:00:00Z       30133     401617 330359 105861 6940 98921               8 314 5438 333255 totalTestEncountersViral 7001 333255 0 24 9c4d2fcbe35464204308354cc7674f4f3b49e8d2 0 0 0 0 0  
4928 4928 20200701 WY 1514 32185   33699 9 117         1119 B 7/1/2020 17:40 2020-07-01T17:40:00Z 07/01 13:40 20 117 2020-07-01T17:40:00Z 45310 1313 43996 1203       33369                     56 27 0 33699 posNeg 27 33699 0 0 41159dbbfadd4420a97a42ad40acbd514be80feb 0 0 0 0 0  
4921 4921 20200701 UT 22716 320642   343358 261 1476 84 423   187 12707 A+ 7/1/2020 10:10 2020-07-01T10:10:00Z 07/01 06:10 173 1476 2020-07-01T10:10:00Z       22716       343358             177 39 204 42 49 499 2106 343358 posNeg 2605 343358 1 32 62af3f65173afcea257cc3f25bf200883f30b301 0 0 0 0 0  
4899 4899 20200701 MO 21927 367813   389740 592       75     B 7/1/2020 15:00 2020-07-01T15:00:00Z 07/01 11:00 1017   2020-07-01T15:00:00Z 424214 23527 399926 21927       389740       43529 1568 41961         29 376 16357 389740 posNeg 16733 389740 2 0 4506b96453b176c46f6a19ac11c121a8847a9e10 0 0 0 0 0  
4834 4834 20200702 IN 46387 450448   496835 644 7139 221 1493 89   35405 A+ 7/1/2020 23:59 2020-07-01T23:59:00Z 07/01 19:59 2662 7139 2020-07-01T23:59:00Z         2469 193   496835                     18 435 6684 496835 posNeg 7119 496835 12 44 cf3cf634b551eccb27ac83c32b65d1084973e833 0 0 0 0 0  
4895 4895 20200701 MD 67918 474686   542604 461 10902 154       5001 A 7/1/2020 10:00 2020-07-01T10:00:00Z 07/01 06:00 3205 10902 2020-07-01T10:00:00Z 656590 79129   67918 3077 128   542604                     24 359 6390 542604 posNeg 6749 542604 15 58 081ca1055d18a04c4f2224532897709efea090e5 0 0 0 0 0  
4877 4877 20200701 AZ 84092 465504   549149 2876 4837 675   466   9715 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 1720 4837 2020-07-01T00:00:00Z       83645 1607 113   549149 172836                   4 4877 12363 549596 posNeg 17227 549596 88 101 79d92ece340b2d9e14a123a36f994798dede8330 0 0 0 0 0  
4869 4869 20200702 WA 38189 672554   710743 311 4402     57     B 7/1/2020 02:59 2020-07-01T02:59:00Z 06/30 22:59 1339 4402 2020-07-01T02:59:00Z       38189 1339   710743 571964                     53 869 13942 710743 posNeg 14811 710743 7 41 1dd12151a796d88c9e3bd5e53404e6af3d3fc214 0 0 0 0 0  
4926 4926 20200701 WI 32225 551607 147 583832 237 3482 77 757     23089 A+ 7/1/2020 16:00 2020-07-01T16:00:00Z 07/01 12:00 793 3482 2020-07-01T16:00:00Z       29199 786 7   580806                     55 563 12068 583979 posNeg 12631 583832 9 36 fd3a8576cf9c15a508dd3a9fe41317e8618a6acd 0 0 0 0 0  
4924 4924 20200701 VT 1210 65082   66292 17           961 B 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 56   2020-07-01T00:00:00Z       1210 56     66292                     50 2 526 66292 posNeg 528 66292 0 0 72d12b0545f4e09a291aabf45dc2e14ca4f6590e 0 0 0 0 0  
4893 4893 20200701 LA 60178 691910   752088 799       84   43026 B 7/1/2020 13:00 2020-07-01T13:00:00Z 07/01 09:00 3238   2020-07-01T13:00:00Z       60178 3130 108   752088                     22 2083 21494 752088 posNeg 23577 752088 17 0 bdfd6ac45db8cd0cbd7dfb90ccb15b823710354d 0 0 0 0 0  
4914 4914 20200701 PA 87242 689562   776804 632       111   68048 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 6649   2020-07-01T00:00:00Z       84751       774313                     42 636 11981 776804 posNeg 12617 776804 0 0 5197b95f7d4fce410d8c08f52edd9c2759c892ea 0 0 0 0 0  
4825 4825 20200702 DC 10390 90673   101063 120   33   28   1465 A+ 7/1/2020 00:00 2020-07-01T00:00:00Z 06/30 20:00 554   2020-07-01T00:00:00Z             101063 78600                     11 25 1003 101063 posNeg 1028 101063 1 0 042b9781cb26ecccd79d30429a78c4a56cc50b07 0 0 0 0 0  
4830 4830 20200702 HI 926 79364   80290   116         741 D 7/1/2020 18:00 2020-07-01T18:00:00Z 07/01 14:00 18 116 2020-07-01T18:00:00Z 94160             80290                     15 9 1223 80290 posNeg 1232 80290 0 3 e514d06cb67b91a5b4ababc4a1e254e37475e13a 0 0 0 0 0  
4918 4918 20200701 SD 6826 74117   80943 65 674         5933 B 7/1/2020 11:46 2020-07-01T11:46:00Z 07/01 07:46 93 674 2020-07-01T11:46:00Z               80943                     46 62 793 80943 posNeg 855 80943 2 8 e2b7a780f4baed973ba58580278ee3bc8009c1a9 0 0 0 0 0  
4862 4862 20200702 SD 6893 75048   81941 64 683         5982 B 7/1/2020 18:00 2020-07-01T18:00:00Z 07/01 14:00 97 683 2020-07-01T18:00:00Z               81941                     46 67 931 81941 posNeg 998 81941 4 9 2dd58a314ed661ccb7f6e5eb9ff58449572e53b6 0 0 0 0 0  
4894 4894 20200701 MA 109143 749292   1118078 760 11352 123   65   93157 A+ 7/1/2020 10:00 2020-07-01T10:00:00Z 07/01 06:00 8081 11352 2020-07-01T10:00:00Z 1118078 137915   103858 7902 179   853150       72752             25 261 10033 858435 totalTestsViral 14528 858435 27 15 74e0d68f7ce4e8e17b66160c49b73b5abbcc6533 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
);