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

✎ 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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  
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  

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