states_daily_4pm_et

Table actions

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

68 rows where "dateChecked" is on date 2020-04-17

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-04-17 · 68 ✖
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
8967 8967 20200419 CO 9433 35173   49465 874 1797           A 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 411 1797 2020-04-17T00:00:00Z             49465 44606                     8 386 913 44606 totalTestEncountersViral 1581 44606 20 42 d9dbd61bedab5ea5e57c4531b3b7c3fa7dbad14a 0 0 0 0 0  
9019 9019 20200418 AR 1739 22402   24141 86 291     22 57 703 A 4/17/2020 19:00 2020-04-17T19:00:00Z 04/17 15:00 38 291 2020-04-17T19:00:00Z 24141     1739                             5 44 603 24141 posNeg 647 24141 1 291 a1f4a26ea3cdfb9e0a83bf6ef90c3cf6465a11bf 0 0 0 0 0  
9022 9022 20200418 CA 28963 230703 7200 259666 4936   1490         B 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 1072   2020-04-17T00:00:00Z 259666                                   6 1435 6617 266866 posNeg 8052 259666 87 0 9adea0514a6711a3354ff7f6c08c719a6c2270a9 0 0 0 0 0  
9023 9023 20200418 CO 9047 34260   47884 843 1755           A 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 391 1755 2020-04-17T00:00:00Z             47884 43307                     8 372 1105 43307 totalTestEncountersViral 1706 43307 17 62 25970c8681808a4185dc55e32a9cf928143b6255 0 0 0 0 0  
9024 9024 20200418 CT 16809 38653   55462 1946             A 4/17/2020 16:00 2020-04-17T16:00:00Z 04/17 12:00 1036   2020-04-17T16:00:00Z 58213       602                           9 0 0 55462 posNeg 0 55462 0 0 4919d8d538796e4ab16dd11c546c8ea20d4c033b 0 0 0 0 0  
9025 9025 20200418 DC 2666 10602   13268 313   105   79   608 A 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 91   2020-04-17T00:00:00Z             13268                       11 190 435 13268 posNeg 625 13268 5 0 227be6a32c3f27f9cdd2278bd45cb8a5cbda19d6 0 0 0 0 0  
9026 9026 20200418 DE 2323 11694   14017 224           423 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 86   2020-04-17T17:00:00Z         77 9                         10 0 0 14017 posNeg 0 14017 10 0 d8c25549d1eff08836b49ac13dff26315fcf34ed 0 0 0 0 0  
9030 9030 20200418 HI 553 21790   22343   48         390 A 4/17/2020 18:30 2020-04-17T18:30:00Z 04/17 14:30 9 48 2020-04-17T18:30:00Z                                     15 12 474 22343 posNeg 486 22343 0 3 ee997afc0be5927a1f000a8fe9fe18de4787be6f 0 0 0 0 0  
9031 9031 20200418 IA 2513 20434   22947 193   84   51   1095 A 4/17/2020 12:00 2020-04-17T12:00:00Z 04/17 08:00 74   2020-04-17T12:00:00Z       2513                             19 181 974 22947 posNeg 1155 22947 10 0 0f0af7614c4be83939cab60ee694afc9561f1f88 0 0 0 0 0  
9032 9032 20200418 ID 1655 15292   16947 53 151   53     453 A 4/17/2020 19:00 2020-04-17T19:00:00Z 04/17 15:00 43 151 2020-04-17T19:00:00Z 16947                                   16 46 249 16947 posNeg 295 16947 2 3 c1dea328d36d565d3555b6622fad3f27947b81c7 0 0 0 0 0  
9034 9034 20200418 IN 10641 46232   56873     663   360     B 4/17/2020 23:59 2020-04-17T23:59:00Z 04/17 19:59 545   2020-04-17T23:59:00Z                                     18 487 1601 56873 posNeg 2088 56873 26 0 ee65a539dac3c907e95f4f6dc2cc025d9543b3b9 0 0 0 0 0  
9036 9036 20200418 KY 2522 28074   30596 360 1008 227 514     979 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 137 1008 2020-04-17T17:00:00Z 30596                                   21 93 756 30596 posNeg 849 30596 8 37 d36eb749aaadaa4f9aac8e02f8b03d024056e3ad 0 0 0 0 0  
9038 9038 20200418 MA 37527 124604   201692 3728 3728 987         B 4/17/2020 16:00 2020-04-17T16:00:00Z 04/17 12:00 1983 3728 2020-04-17T16:00:00Z 201692 47174                                 25 2402 7409 162131 totalTestsViral 7478 162131 161 -28 4f6964a7cc768741da9d249b84f2f4634f7e5a14 0 0 0 0 0  
9042 9042 20200418 MN 2788 45182   47970 239 561 111 215     997 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 121 561 2020-04-17T17:00:00Z       2788     47970                       27 120 1362 47970 posNeg 1482 47970 10 43 058dbece31d60295bf927ae2ea4ba87ce80702f2 0 0 0 0 0  
9044 9044 20200418 MP 14 42 4 56             9   4/17/2020 19:15 2020-04-17T19:15:00Z 04/17 15:15 2   2020-04-17T19:15:00Z                                     69 1 0 60 posNeg 1 56 0 0 ee5f65a9e3d7ba634aef791525702a1dd51ab866 0 0 0 0 0  
9045 9045 20200418 MS 3974 34791   38765   782 154   99     A 4/17/2020 19:00 2020-04-17T19:00:00Z 04/17 15:00 152 782 2020-04-17T19:00:00Z                                     28 181 0 38765 posNeg 181 38765 12 46 47e3909077758e2b5ec5eac58aecaba2d2652e31 0 0 0 0 0  
9049 9049 20200418 NE 1138 12539   13677               A 4/17/2020 19:42 2020-04-17T19:42:00Z 04/17 15:42 24   2020-04-17T19:42:00Z               13753                     31 72 501 13677 posNeg 573 13677 0 0 4ca4b9aa50a4bf5b658bef5c1156e66e1307bee6 0 0 0 0 0  
9050 9050 20200418 NH 1287 11565 174 14100 86 190         468 B 4/17/2020 09:00 2020-04-17T09:00:00Z 04/17 05:00 37 190 2020-04-17T09:00:00Z 14100                                   33 0 144 13026 posNeg 565 12852 0 0 a26f3195113fbec5693f9e01c62a7443c582b12b 0 0 0 0 0  
9052 9052 20200418 NM 1711 33902   35613 96 242         382 A 4/17/2020 21:53 2020-04-17T21:53:00Z 04/17 17:53 51 242 2020-04-17T21:53:00Z                                     35 114 1011 35613 posNeg 1125 35613 7 12 d1f93f6713a62535b13a04ee152e8c8ddc67648a 0 0 0 0 0  
9062 9062 20200418 SD 1542 10118 1 11660   68         552 A 4/17/2020 18:00 2020-04-17T18:00:00Z 04/17 14:00 7 68 2020-04-17T18:00:00Z               11660                     46 131 467 11661 posNeg 598 11660 0 5 d8b01460ad9534be7a37ff11332e4ff14a8b8ee1 0 0 0 0 0  
9066 9066 20200418 VA 8053 43878 486 67960 1307 1296 398   230   1228 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 258 1296 2020-04-17T17:00:00Z   11808         67960                       51 562 2372 52417 posNeg 3305 51931 27 75 f466b84530d8719a1b41249a71d5313145afff4a 0 0 0 0 0  
9071 9071 20200418 WV 785 18655   19440 83   40   27   255 B 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 16   2020-04-17T17:00:00Z       785                             54 31 728 19440 posNeg 759 19440 3 0 6e30511c29aba9e6fb8531b0858ef6dd87c9ffd2 0 0 0 0 0  
9072 9072 20200418 WY 305 6217   6522 19 50         206 A 4/17/2020 16:02 2020-04-17T16:02:00Z 04/17 12:02 2 50 2020-04-17T16:02:00Z       305                             56 9 86 6522 posNeg 95 6522 0 7 97f421de86c717ec0ef036db2046a7ef20c1906b 0 0 0 0 0  
9074 9074 20200417 AL 4530 33318   37848 364 594   247   148   B 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 144 594 2020-04-17T00:00:00Z 37848     4530                             1 185 1272 37848 posNeg 1457 37848 11 41 62111d65289893c2d1efa8a452184d9eb0a5bbcf 0 0 0 0 0  
9075 9075 20200417 AR 1695 21799   23494 83       21   593 A 4/17/2020 19:00 2020-04-17T19:00:00Z 04/17 15:00 37   2020-04-17T19:00:00Z 23494     1695                             5 75 744 23494 posNeg 819 23494 0 0 7dfb1465128b9c3ff566da89b77f1932315e250d 0 0 0 0 0  
9077 9077 20200417 AZ 4507 44723   49230 566 1289 285   178   539 B 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 169 1289 2020-04-17T00:00:00Z               49230                     4 273 1559 49230 posNeg 1832 49230 19 31 a29a548add28bb8f142bedae176b913eedb8c186 0 0 0 0 0  
9078 9078 20200417 CA 27528 224086 7200 251614 4892   1484         B 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 985   2020-04-17T00:00:00Z 251614                                   6 1346 3868 258814 posNeg 5214 251614 95 0 27b01a17036df6df1b452da1fa411a96339a47f1 0 0 0 0 0  
9080 9080 20200417 CT 16809 38653   55462 1946             A 4/17/2020 16:00 2020-04-17T16:00:00Z 04/17 12:00 1036   2020-04-17T16:00:00Z 55462       554                           9 925 1415 55462 posNeg 2340 55462 65 0 87c9041b207603ca43721aaedff2d855755006d9 0 0 0 0 0  
9082 9082 20200417 DE 2323 11694   14017 224           423 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 76   2020-04-17T17:00:00Z         67 9                         10 248 419 14017 posNeg 667 14017 6 0 29152a359a07af14fda50fa73d54a4c3d3d5777d 0 0 0 0 0  
9083 9083 20200417 FL 24119 210718 1285 234837   3665           A 4/17/2020 16:21 2020-04-17T16:21:00Z 04/17 12:21 699 3665 2020-04-17T16:21:00Z                                     12 1222 14367 236122 posNeg 15589 234837 53 205 f84ae67e3b3d66e4a673b262582742ba07d923db 0 0 0 0 0  
9084 9084 20200417 GA 17194 54490   71684   3324           A 4/17/2020 18:28 2020-04-17T18:28:00Z 04/17 14:28 650 3324 2020-04-17T18:28:00Z 71684                                   13 1525 2220 71684 posNeg 3745 71684 63 216 80e1f7d17a8b28d35fabbb8f922e9eedc3f048de 0 0 0 0 0  
9085 9085 20200417 GU 133 940   1073 6   2       97   4/17/2020 07:00 2020-04-17T07:00:00Z 04/17 03:00 5   2020-04-17T07:00:00Z                                     66 0 70 1073 posNeg 70 1073 0 0 03032c101771aad6f0b013315eaee93b5748f980 0 0 0 0 0  
9086 9086 20200417 HI 541 21316   21857   45         374 A 4/17/2020 18:30 2020-04-17T18:30:00Z 04/17 14:30 9 45 2020-04-17T18:30:00Z                                     15 11 1146 21857 posNeg 1157 21857 0 0 65cef10cb37c85dd60682765ba6445ff36ab8ade 0 0 0 0 0  
9088 9088 20200417 ID 1609 15043   16652 58 148   51     390 A 4/17/2020 19:00 2020-04-17T19:00:00Z 04/17 15:00 41 148 2020-04-17T19:00:00Z 16652                                   16 22 388 16652 posNeg 410 16652 0 5 e150c33601c201623d27e15a1530825d32a63839 0 0 0 0 0  
9089 9089 20200417 IL 27575 102588   130163 4454   1196   777     A 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 1134   2020-04-17T00:00:00Z                                     17 1842 5732 130163 posNeg 7574 130163 62 0 95e2eebf31994de2562e9f9439498c87e6681f1d 0 0 0 0 0  
9091 9091 20200417 KS 1705 15196   16901   375           B 4/17/2020 12:00 2020-04-17T12:00:00Z 04/17 08:00 84 375 2020-04-17T12:00:00Z                                     20 117 662 16901 posNeg 779 16901 4 16 efc6b3c32635dc04a361e7b81b0297d1b214b7d0 0 0 0 0 0  
9092 9092 20200417 KY 2429 27318   29747 477 971 333 506     956 A 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 129 971 2020-04-17T17:00:00Z 29747                                   21 138 1285 29747 posNeg 1423 29747 7 164 1f56c4c8920a54a80858166fc04e376e4694bd99 0 0 0 0 0  
9093 9093 20200417 LA 23118 108869   131987 1868       363     A 4/17/2020 13:00 2020-04-17T13:00:00Z 04/17 09:00 1213   2020-04-17T13:00:00Z       23118                             22 586 4815 131987 posNeg 5401 131987 57 0 5dda2bbb445cc02b13ab24772b7445933287ea39 0 0 0 0 0  
9095 9095 20200417 MD 11572 50437   62009   2612         736 A 4/17/2020 10:00 2020-04-17T10:00:00Z 04/17 06:00 541 2612 2020-04-17T10:00:00Z 69474 14075   11572 512 29                         24 788 2378 62009 posNeg 3166 62009 42 161 accbcb126becefe718e58ff91b00e153de29abe7 0 0 0 0 0  
9096 9096 20200417 ME 827 14076   14903 55 133 28   8   352 A 4/17/2020 11:45 2020-04-17T11:45:00Z 04/17 07:45 29 133 2020-04-17T11:45:00Z       827                             23 31 0 14903 posNeg 31 14903 2 3 025d44aa854582dba393e259bf2a781b431c4233 0 0 0 0 0  
9097 9097 20200417 MI 36320 83268   119588 3674   1428   1167   629 B 4/17/2020 11:00 2020-04-17T11:00:00Z 04/17 07:00 2984   2020-04-17T11:00:00Z 122507 39239 83268 35118 2955 148                         26 865 4994 119588 posNeg 5859 119588 143 0 6f8fbfad29139599b3a5e8d6ce280857022f685f 0 0 0 0 0  
9099 9099 20200417 MO 5283 46434   51717 1043             A 4/17/2020 15:00 2020-04-17T15:00:00Z 04/17 11:00 165   2020-04-17T15:00:00Z 52444 6022 46360 5283               3 0 3         29 172 897 51717 posNeg 1069 51717 13 0 7c6acb06f20b9e91e5b4e90d42fc628e5a386621 0 0 0 0 0  
9100 9100 20200417 MP 13 42 4 55                 4/17/2020 19:15 2020-04-17T19:15:00Z 04/17 15:15 2   2020-04-17T19:15:00Z                                     69 0 15 59 posNeg 15 55 0 0 7bf3e8bc825078c2daf9c659c653c437a130301f 0 0 0 0 0  
9102 9102 20200417 MT 422 9822   10244 21 54         233 A 4/17/2020 10:44 2020-04-17T10:44:00Z 04/17 06:44 8 54 2020-04-17T10:44:00Z 10244                                   30 7 301 10244 posNeg 308 10244 1 2 5f4717b04dc98b6e27cb86776459de0c8118214a 0 0 0 0 0  
9103 9103 20200417 NC 5859 67122   72981 429             A 4/17/2020 11:00 2020-04-17T11:00:00Z 04/17 07:00 152   2020-04-17T11:00:00Z                                     37 394 1670 72981 posNeg 2064 72981 21 0 043500592313694e2dbf7cbcfef5ec595fd26a31 0 0 0 0 0  
9104 9104 20200417 ND 438 11903   12629 16 47         172 B 4/17/2020 13:00 2020-04-17T13:00:00Z 04/17 09:00 9 47 2020-04-17T13:00:00Z 12790     438     12629 11825                     38 46 592 12341 totalTestEncountersViral 819 12341 0 2 0188536414df766832086cf004e75829d6597ee9 0 0 0 0 0  
9105 9105 20200417 NE 1066 12038   13104               A 4/17/2020 19:42 2020-04-17T19:42:00Z 04/17 15:42 24   2020-04-17T19:42:00Z               13173                     31 114 696 13104 posNeg 810 13104 3 0 c019406cf91410ddac20f897290cc4b77fe76f30 0 0 0 0 0  
9106 9106 20200417 NH 1287 11421 174 13535 74 190         455 B 4/17/2020 09:00 2020-04-17T09:00:00Z 04/17 05:00 37 190 2020-04-17T09:00:00Z 13535                                   33 148 394 12882 posNeg 410 12708 5 12 863a70162d158eb0990ec11c96854883867f6e9e 0 0 0 0 0  
9107 9107 20200417 NJ 78467 78982   157449 8011   1961   1594     A 4/17/2020 13:00 2020-04-17T13:00:00Z 04/17 09:00 4856   2020-04-17T13:00:00Z       78467 3840 1016   157449                     34 3150 2469 157449 posNeg 5619 157449 365 0 b2fc450b46058defbba1284ecfd0cf88f5e41aa4 0 0 0 0 0  
9108 9108 20200417 NM 1597 32891   34488 90 230         353 A 4/17/2020 20:53 2020-04-17T20:53:00Z 04/17 16:53 44 230 2020-04-17T20:53:00Z                                     35 113 981 34488 posNeg 1094 34488 8 15 4d2a96ab240984924d413b67b38043c3508751df 0 0 0 0 0  
9109 9109 20200417 NV 3524 26238   29762               A 4/17/2020 10:00 2020-04-17T10:00:00Z 04/17 06:00 162   2020-04-17T10:00:00Z 35955     3524                             32 203 1108 29762 posNeg 1311 29762 4 0 26a0c43226a81d875b356195a9bb89feecf0f55d 0 0 0 0 0  
9110 9110 20200417 NY 229642 343581   573223 17316 61120 5039       33392 A 4/17/2020 14:00 2020-04-17T14:00:00Z 04/17 10:00 12822 61120 2020-04-17T14:00:00Z                                     36 7358 15286 573223 posNeg 22644 573223 630 2068 5f626642854ac25a9e6726f14695d93a7fa1a8db 0 0 0 0 0  
9111 9111 20200417 OH 9107 68819   77926   2424   740       B 4/17/2020 14:00 2020-04-17T14:00:00Z 04/17 10:00 418 2424 2020-04-17T14:00:00Z       8858 401 17                         39 693 2393 77926 posNeg 3086 77926 29 93 d4baf45ff1807f5a2192c17a516c9b4403ddcf48 0 0 0 0 0  
9112 9112 20200417 OK 2465 31155   33620 325 528 155       1331 B 4/17/2020 11:35 2020-04-17T11:35:00Z 04/17 07:35 136 528 2020-04-17T11:35:00Z       2465                             40 108 2613 33620 posNeg 2721 33620 5 0 12d750873ebf15d46ba0f178b32a3787e8316c3a 0 0 0 0 0  
9113 9113 20200417 OR 1785 34536   36321 301 427 69   41     A 4/17/2020 11:00 2020-04-17T11:00:00Z 04/17 07:00 70 427 2020-04-17T11:00:00Z                                     41 49 1334 36321 posNeg 1383 36321 6 13 934d05facfd0ecba708312b44c17c72d55a8a02d 0 0 0 0 0  
9114 9114 20200417 PA 29441 117932   147373 2603       661     A 4/17/2020 12:00 2020-04-17T12:00:00Z 04/17 08:00 756   2020-04-17T12:00:00Z               147373                     42 1706 4197 147373 posNeg 5903 147373 49 0 030043a4e94a0f8ae1084e2968c4990e6fb2ef50 0 0 0 0 0  
9115 9115 20200417 PR 1068 7864 1478 8932               A 4/17/2020 06:00 2020-04-17T06:00:00Z 04/17 02:00 58   2020-04-17T06:00:00Z                                     72 25 549 10410 posNeg 574 8932 2 0 30fbb06fd9a500fc80f386007ca9288cef501153 0 0 0 0 0  
9116 9116 20200417 RI 4585 26157   31779 252 331 62   43   196 B 4/17/2020 03:00 2020-04-17T03:00:00Z 04/16 23:00 118 331 2020-04-17T03:00:00Z 33997 4816 29181 4585     31779 30742                     44 290 1500 30742 totalTestEncountersViral 2941 30742 13 0 5ab15ff9b0019527d30ab6c796ae97f57c7c4c4a 0 0 0 0 0  
9117 9117 20200417 SC 3931 32353   36284   675           B 4/17/2020 16:48 2020-04-17T16:48:00Z 04/17 12:48 109 675 2020-04-17T16:48:00Z       3931                             45 275 1276 36284 posNeg 1551 36284 2 0 ab919b630a76f85e11175132e076c3311af66ffa 0 0 0 0 0  
9119 9119 20200417 TN 6589 80684   87273 465 711         3017 A 4/17/2020 15:00 2020-04-17T15:00:00Z 04/17 11:00 142 711 2020-04-17T15:00:00Z                                     47 327 1897 87273 posNeg 2224 87273 1 20 6235fe4d797c925013715d9ac8d41708b51a2359 0 0 0 0 0  
9120 9120 20200417 TX 17371 152165   169536 1522           4190 A 4/17/2020 12:45 2020-04-17T12:45:00Z 04/17 08:45 428   2020-04-17T12:45:00Z       17371                             48 916 10073 169536 posNeg 10989 169536 35 0 5433cb7be9ece6383e6f4675fed7d888e7426535 0 0 0 0 0  
9121 9121 20200417 UT 2805 52966   55771   244         443 A 4/17/2020 15:00 2020-04-17T15:00:00Z 04/17 11:00 23 244 2020-04-17T15:00:00Z       2805                             49 122 5971 55771 posNeg 6093 55771 2 6 b3bf60f93c398af29a627022bea9c938c303fd44 0 0 0 0 0  
9123 9123 20200417 VI 51 373 34 424             46   4/17/2020 08:30 2020-04-17T08:30:00Z 04/17 04:30 2   2020-04-17T08:30:00Z                                     78 0 16 458 posNeg 16 424 1 0 f5eb61fee8afe8f87c32f0f2f54138fd451397c7 0 0 0 0 0  
9124 9124 20200417 VT 802 10813   11615 32           15 A 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 35   2020-04-17T00:00:00Z       802                             50 10 554 11615 posNeg 564 11615 0 0 3055dd40be3d23154e9e577937c4103b20d69e67 0 0 0 0 0  
9125 9125 20200417 WA 12318 148206   160524 622   195         C 4/17/2020 00:00 2020-04-17T00:00:00Z 04/16 20:00 585   2020-04-17T00:00:00Z       12318     160524 153193                     53 351 4772 160524 posNeg 5123 160524 14 0 c64fe60e6082d8aefc4c487d23cf35d434ac1b96 0 0 0 0 0  
9126 9126 20200417 WI 4839 42365 198 47204 361 1153 141 306 348     A 4/17/2020 14:24 2020-04-17T14:24:00Z 04/17 10:24 205 1153 2020-04-17T14:24:00Z       4045                             55 203 1391 47402 posNeg 1594 47204 8 32 3a5fbcba38f43acb05d84b829a1bebe394c0f2a5 0 0 0 0 0  
9127 9127 20200417 WV 754 17927   18681 85   34   24   223 B 4/17/2020 17:00 2020-04-17T17:00:00Z 04/17 13:00 13   2020-04-17T17:00:00Z       754                             54 15 360 18681 posNeg 375 18681 0 0 93d6b44bb8e26ed1586a3e3f7c17af6e06df50fe 0 0 0 0 0  
9128 9128 20200417 WY 296 6131   6427 19 43         148 A 4/17/2020 16:02 2020-04-17T16:02:00Z 04/17 12:02 2 43 2020-04-17T16:02:00Z       296                             56 0 0 6427 posNeg 0 6427 0 0 d4f2711320c163692c051e536990fdfe13b52abe 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
);