states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
69 rows where "dateModified" is on date 2020-07-01 sorted by deathConfirmed
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)
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||||
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 | ||||||||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||||
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 | ||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | ||||||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||
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 | |||||||||||||||||||||
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 | |||||||||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||
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 | ||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||
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 | |||||||||||||||||||||
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 | ||||||||||||||||||
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 | |||||||||||||||||
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 | |||||||||||||||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );