states_daily_4pm_et

Table actions

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

67 rows where "dateChecked" is on date 2020-05-03

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-05-03 · 67 ✖
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
7788 7788 20200510 AS 0 83   83               D 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 543b2b629c50dde48ffb7a4af41967de7e6c4628 0 0 0 0 0  
7844 7844 20200509 AS 0 83   83               D 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 181e10ded2dd368a627e73ac90a09ee84623409b 0 0 0 0 0  
7900 7900 20200508 AS 0 83   83               F 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 ae69a856b0ae36a0af9fdbe71cae63f7640c410d 0 0 0 0 0  
7956 7956 20200507 AS 0 83   83               F 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 9885bea25e2daf9f4b2b79d283832360f41b2852 0 0 0 0 0  
8012 8012 20200506 AS 0 83   83               F 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 0ac7a83b06d8c35477261f819b8f161cbd3cf0d4 0 0 0 0 0  
8068 8068 20200505 AS 0 83   83               F 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 0 83 posNeg 0 83 0 0 835bc2833de00a4e9bd06cc3039c3b2f541017e2 0 0 0 0 0  
8071 8071 20200505 CO 16907 68097   93656 834 2838         2743 B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 851 2838 2020-05-03T00:00:00Z       15169     93656 83266                     8 272 1642 85004 totalTestEncountersViral 2232 85004 9 39 8d6f6f7d2e3dd7709377b61c9c5d8c66d8b33720 0 0 0 0 0  
8080 8080 20200505 ID 2106 28202   30146 27 201   83     1358 C 5/3/2020 19:00 2020-05-03T19:00:00Z 05/03 15:00 64 201 2020-05-03T19:00:00Z 30146     1944                             16 45 456 30308 posNeg 495 30308 0 1 2334640921b27ef3ea6e4f466f22d8f3e817db1b 0 0 0 0 0  
8097 8097 20200505 NE 6083 28526   34609               D 5/3/2020 20:45 2020-05-03T20:45:00Z 05/03 16:45 78   2020-05-03T20:45:00Z       6083       34675                     31 173 682 34609 posNeg 855 34609 0 0 ebc07120f8f7da59c49187eed47c2e9bfc55a130 0 0 0 0 0  
8123 8123 20200504 AR 3458 50984   54442 91 438     16 88 2016 B 5/3/2020 15:40 2020-05-03T15:40:00Z 05/03 11:40 81 438 2020-05-03T15:40:00Z 54442     3458                             5 27 1525 54442 posNeg 1552 54442 5 11 41c382e4072510c5702cb4bde2df3566e3c04807 0 0 0 0 0  
8124 8124 20200504 AS 0 83   83               F 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 0   2020-05-03T00:00:00Z 83     0                             60 0 26 83 posNeg 26 83 0 0 cdf6493ed40a0dd1eeacd85c2d3ab5775f5ac920 0 0 0 0 0  
8127 8127 20200504 CO 16635 66455   91424 883 2799         2650 B 5/3/2020 18:00 2020-05-03T18:00:00Z 05/03 14:00 842 2799 2020-05-03T18:00:00Z       14897     91424 81352                     8 410 2774 83090 totalTestEncountersViral 3582 83090 10 6 814d4db30f1c487c3f9a1ee854d7d73ed0cdfc7a 0 0 0 0 0  
8128 8128 20200504 CT 29287 73206   102493 1488 7758         4346 B 5/3/2020 16:00 2020-05-03T16:00:00Z 05/03 12:00 2495 7758 2020-05-03T16:00:00Z 108643       2168                           9 0 0 102493 posNeg 0 102493 59 0 ad90d6ba56516a4729217c4b004a4767d17b9835 0 0 0 0 0  
8129 8129 20200504 DC 5170 18625   23795 447   130   91   666 A+ 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 258   2020-05-03T00:00:00Z             23795                       11 154 539 23795 posNeg 693 23795 7 0 d9c293d8a1fa557116407f97b2e0e31c9348900a 0 0 0 0 0  
8130 8130 20200504 DE 5288 18822   24110 281           1716 B 5/3/2020 18:00 2020-05-03T18:00:00Z 05/03 14:00 255   2020-05-03T18:00:00Z         226 29                         10 80 293 24110 posNeg 373 24110 9 0 ae531d5d37fd913b706fbaf439691271d7c4cbb1 0 0 0 0 0  
8134 8134 20200504 HI 620 33246   33866   73         544 B 5/3/2020 18:00 2020-05-03T18:00:00Z 05/03 14:00 17 73 2020-05-03T18:00:00Z                                     15 0 916 33866 posNeg 916 33866 1 1 dbb2c6cc2cf3ffebb33f8bceb807a7fb8f06002f 0 0 0 0 0  
8135 8135 20200504 IA 9703 47458   57161 389   143   93   3486 B 5/3/2020 12:00 2020-05-03T12:00:00Z 05/03 08:00 188   2020-05-03T12:00:00Z       9703                             19 534 3441 57161 posNeg 3975 57161 4 0 81c70c5a53fa81c8eec79e51b981e058a8754e88 0 0 0 0 0  
8138 8138 20200504 IN 20507 92790   113297 1449   483   249     A+ 5/3/2020 23:59 2020-05-03T23:59:00Z 05/03 19:59 1264   2020-05-03T23:59:00Z         1151                           18 574 3864 113297 posNeg 4438 113297 18 0 bf9351363ff23201d4b9c44ef75de7d258d8515f 0 0 0 0 0  
8139 8139 20200504 KS 5245 33358   38603   553   209   95 291 A 5/3/2020 10:00 2020-05-03T10:00:00Z 05/03 06:00 136 553 2020-05-03T10:00:00Z                                     20 215 1610 38603 posNeg 1825 38603 2 6 3d89e573c197d60f04031466acab60d07233ed8f 0 0 0 0 0  
8140 8140 20200504 KY 5130 53279   58408 329 1519 170 654     1892 A 5/3/2020 17:00 2020-05-03T17:00:00Z 05/03 13:00 253 1519 2020-05-03T17:00:00Z 58408     5129 252                           21 251 509 58409 posNeg 760 58409 5 108 f4243b316e5f93d80af0678d97f196470c3ad01f 0 0 0 0 0  
8144 8144 20200504 ME 1205 19546   20751 37 186 18   11   720 B 5/3/2020 11:59 2020-05-03T11:59:00Z 05/03 07:59 57 186 2020-05-03T11:59:00Z       1136 57                           23 20 0 20751 posNeg 20 20751 0 3 5ce05d9ecc4a025fdca67bec4995822b87526aa6 0 0 0 0 0  
8145 8145 20200504 MI 49809 202671   252480 1948   839   670   15659 A+ 5/3/2020 11:00 2020-05-03T11:00:00Z 05/03 07:00 4722   2020-05-03T11:00:00Z 258536 55865 202671 47451 4573 206                         26 780 7310 252480 posNeg 8090 252480 81 0 7c450f7cc7ec8cc2dbb7959c14e6594fd84792e3 0 0 0 0 0  
8149 8149 20200504 MS 7877 71800   79677 646 1316 145   78   4421 B 5/3/2020 19:00 2020-05-03T19:00:00Z 05/03 15:00 310 1316 2020-05-03T19:00:00Z                                     28 327 1757 79677 posNeg 2084 79677 7 18 cf5b8b1f8041fb1f4c350320013ccdd24de54f31 0 0 0 0 0  
8153 8153 20200504 NE 5910 27844   33754               D 5/3/2020 20:45 2020-05-03T20:45:00Z 05/03 16:45 78   2020-05-03T20:45:00Z       5910       33819                     31 584 1908 33754 posNeg 2492 33754 2 0 7f04093a6bfca1d2064e3a594c13a2831f78b71a 0 0 0 0 0  
8154 8154 20200504 NH 2588 24282 244 27910 103 286         1017 C 5/3/2020 09:00 2020-05-03T09:00:00Z 05/03 05:00 86 286 2020-05-03T09:00:00Z 27910     2588         1351                   33 159 -1682 27114 posNeg 426 26870 2 9 86ccb0ef937a131a9ce8fe8648a05f9adbdf687d 0 0 0 0 0  
8156 8156 20200504 NM 3850 74127   77977 164 587         832 C 5/3/2020 17:58 2020-05-03T17:58:00Z 05/03 13:58 151 587 2020-05-03T17:58:00Z       3850                             35 118 2915 77977 posNeg 3033 77977 12 0 d89e2c31cada1bfba07dadf95cba29935bdba2a8 0 0 0 0 0  
8160 8160 20200504 OK 4044 59804   63848 236 753 92       2682 A 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 238 753 2020-05-03T00:00:00Z 70368 4150 66084 4044                             40 72 0 63848 posNeg 72 63848 0 10 94a25be0f282c747be9141a238418857fc16e384 0 0 0 0 0  
8165 8165 20200504 SC 6626 57562   64188   1110         3622 B 5/3/2020 15:30 2020-05-03T15:30:00Z 05/03 11:30 275 1110 2020-05-03T15:30:00Z       6626 275                           45 0 0 64188 posNeg 0 64188 0 0 de777a5efb92849d2a3eaf59af449b1853b9d5bd 0 0 0 0 0  
8166 8166 20200504 SD 2668 16045   18713 69 211         1830 C 5/3/2020 18:00 2020-05-03T18:00:00Z 05/03 14:00 21 211 2020-05-03T18:00:00Z               18713                     46 37 259 18713 posNeg 296 18713 0 14 60a13fe04c55d4fe1d13239ebe7c461550e98654 0 0 0 0 0  
8169 8169 20200504 UT 5317 119344   124661   441         2342 C 5/3/2020 15:00 2020-05-03T15:00:00Z 05/03 11:00 50 441 2020-05-03T15:00:00Z       5317                             49 142 2417 124661 posNeg 2559 124661 0 5 bdef3b5b19e68247cc8bceee13b80b5a37cedf98 0 0 0 0 0  
8170 8170 20200504 VA 19492 92801 478 135641 1463 4010 348   192   2547 A+ 5/3/2020 17:00 2020-05-03T17:00:00Z 05/03 13:00 684 4010 2020-05-03T17:00:00Z   24539   18640 662 22 135641                       51 821 3470 112771 posNeg 4821 112293 24 100 f602be0d25543a11b930021025e0edeec2c9a936 0 0 0 0 0  
8171 8171 20200504 VI 66 965 15 1031             51 C 5/3/2020 20:30 2020-05-03T20:30:00Z 05/03 16:30 4   2020-05-03T20:30:00Z         4                           78 0 14 1046 posNeg 14 1031 0 0 75224559fd7d59618fae954070179e524f1fb23d 0 0 0 0 0  
8177 8177 20200503 AK 368 21210   21578 12           262 C 5/3/2020 14:15 2020-05-03T14:15:00Z 05/03 10:15 9   2020-05-03T14:15:00Z 21578     368 9                           2 3 176 21578 posNeg 179 21578 0 0 e8608bf6a68990f37e526edd75f88e73d9e057cf 0 0 0 0 0  
8178 8178 20200503 AL 7725 84775   92500 427 1035   403   242   B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 290 1035 2020-05-03T00:00:00Z 92500     7725 290                           1 291 0 92500 posNeg 291 92500 2 12 c12a951677090426a3f7121665ac75d7abebd01a 0 0 0 0 0  
8179 8179 20200503 AR 3431 49459   52890 100 427     20 88 1999 B 5/3/2020 13:30 2020-05-03T13:30:00Z 05/03 09:30 76 427 2020-05-03T13:30:00Z 52890     3431                             5 59 1249 52890 posNeg 1308 52890 3 13 38169c4478088effd5632f0afe442423954a7ed5 0 0 0 0 0  
8181 8181 20200503 AZ 8640 72479   81119 732 2089 282   192   1597 A+ 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 362 2089 2020-05-03T00:00:00Z               81119                     4 276 2846 81119 posNeg 3122 81119 14 56 798468bf25bcf74e7981936a299cfb4e66543af0 0 0 0 0 0  
8182 8182 20200503 CA 53616 662135   715751 4734   1468         B 5/3/2020 14:00 2020-05-03T14:00:00Z 05/03 10:00 2215   2020-05-03T14:00:00Z 715751     53616                             6 1419 27529 715751 posNeg 30703 715751 44 0 668fb4bb75ff78beb807f16f823ab8838f54c97b 0 0 0 0 0  
8188 8188 20200503 GA 28602 146494   174800 1410 5393   1249       A 5/3/2020 10:25 2020-05-03T10:25:00Z 05/03 06:25 1177 5393 2020-05-03T10:25:00Z 174800     28602                             13 296 0 175096 posNeg 0 175096 3 6 0bfd0beb05040533c2ed190692c1f156ec33debe 0 0 0 0 0  
8189 8189 20200503 GU 150 3152   3302             126 F 5/3/2020 06:20 2020-05-03T06:20:00Z 05/03 02:20 5   2020-05-03T06:20:00Z       146                             66 2 112 3302 posNeg 114 3302 0 0 e28e1db0b1fa1dd0099a1ceabb40118d79a38a27 0 0 0 0 0  
8195 8195 20200503 KS 5030 31748   36778   547   209   95 286 A 5/3/2020 10:00 2020-05-03T10:00:00Z 05/03 06:00 134 547 2020-05-03T10:00:00Z                                     20 284 1552 36778 posNeg 1836 36778 3 6 f7ba9f52521c5bd92b71ae853ff3e645094bc78e 0 0 0 0 0  
8197 8197 20200503 LA 29340 146820   176160 1530       213   17303 B 5/3/2020 13:00 2020-05-03T13:00:00Z 05/03 09:00 1969   2020-05-03T13:00:00Z       29340 1845                           22 200 3102 176160 posNeg 3302 176160 19 0 05b1edfcad540fd05302c87b2cc744774b775f71 0 0 0 0 0  
8198 8198 20200503 MA 68087 246559   386680 3617 6507 904         A 5/3/2020 16:00 2020-05-03T16:00:00Z 05/03 12:00 4004 6507 2020-05-03T16:00:00Z 386680 82450   68087 4004                           25 1824 13828 314646 totalTestsViral 6462 314646 158 129 f1dc03b65a0c1d303a5e5a2f0a25d2b08d3216a2 0 0 0 0 0  
8199 8199 20200503 MD 25462 107332   132794 1635 5051 565       1666 A 5/3/2020 10:00 2020-05-03T10:00:00Z 05/03 06:00 1372 5051 2020-05-03T10:00:00Z 133367 29716   25462 1302 70                         24 989 6283 132794 posNeg 7272 132794 49 141 a2e1f45e9dc857956f33eb19a88b8daccce071f1 0 0 0 0 0  
8200 8200 20200503 ME 1185 19546   20731 33 183 18   12   706 B 5/3/2020 11:45 2020-05-03T11:45:00Z 05/03 07:45 57 183 2020-05-03T11:45:00Z       1185 57                           23 33 0 20731 posNeg 33 20731 1 2 e6ff02088bfe36007d0925273a0bd92b45657abf 0 0 0 0 0  
8201 8201 20200503 MI 49029 195361   244390 2100   850   713   15659 A+ 5/3/2020 11:00 2020-05-03T11:00:00Z 05/03 07:00 4641   2020-05-03T11:00:00Z 250589 55228 195361 46783 4516 205                         26 357 6648 244390 posNeg 7005 244390 62 0 2bf3843af08b971fde5f9385a65275e578aaa3cb 0 0 0 0 0  
8203 8203 20200503 MO 8386 74590   82976 896       141     A 5/3/2020 15:00 2020-05-03T15:00:00Z 05/03 11:00 352   2020-05-03T15:00:00Z 97614 10227 87215 8386               2443 105 2337         29 232 0 82976 posNeg 232 82976 1 0 f17d953a637eac21474528c482e39041c6e1fd35 0 0 0 0 0  
8204 8204 20200503 MP 14 1321   1335             12 D 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 2   2020-05-03T00:00:00Z       14                             69 0 387 1335 posNeg 387 1335 0 0 d818bd3dc0da8c6d07fbcc4984d1589b0d08539c 0 0 0 0 0  
8206 8206 20200503 MT 455 14552   15007 5 61         404 C 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 16 61 2020-05-03T00:00:00Z 15007     455                             30 0 372 15007 posNeg 372 15007 0 0 f73c9ef207f3bcd32e320a275e5355de90601140 0 0 0 0 0  
8207 8207 20200503 NC 11664 132171   143835 475             B 5/3/2020 11:00 2020-05-03T11:00:00Z 05/03 07:00 422   2020-05-03T11:00:00Z       11664 422                           37 155 4205 143835 posNeg 4360 143835 2 0 815955c42b54c9b3d718fd5b55c7c94705d471da 0 0 0 0 0  
8208 8208 20200503 ND 1191 32162   35095 31 90         517 C 5/3/2020 13:00 2020-05-03T13:00:00Z 05/03 09:00 16 90 2020-05-03T13:00:00Z 35636     1191 16   35095 32083                     38 38 1768 33353 totalTestEncountersViral 1889 33353 -8 0 9190c04dfc9bcbb42049e4a50451cd62e84612aa 0 0 0 0 0  
8211 8211 20200503 NJ 126744 148322 641 275066 5317   1623   1198   15642 A+ 5/3/2020 13:00 2020-05-03T13:00:00Z 05/03 09:00 9384   2020-05-03T13:00:00Z       126744 7871 1513   275066                     34 3027 9727 275707 posNeg 12754 275066 154 0 0c77c4a13af18448b9887f3707c17b0388facfc7 0 0 0 0 0  
8213 8213 20200503 NV 5423 39843   45266             182 D 5/3/2020 10:00 2020-05-03T10:00:00Z 05/03 06:00 287   2020-05-03T10:00:00Z 56107     5423                             32 112 767 45266 posNeg 879 45266 6 0 7b426a58bc25f672729eac50a7af60362c5dd1e7 0 0 0 0 0  
8214 8214 20200503 NY 316415 669496   985911 9786 79768 3430       58950 B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 19189 79768 2020-05-03T00:00:00Z       316415                             36 3438 23402 985911 posNeg 26840 985911 280 826 01f40b3df25c608a9aab347e5c141aac6518d573 0 0 0 0 0  
8215 8215 20200503 OH 19914 130252   150166 931 3769 393 1078 255     B 5/3/2020 14:00 2020-05-03T14:00:00Z 05/03 10:00 1038 3769 2020-05-03T14:00:00Z 145021     19094 957 81                         39 579 3768 150166 posNeg 4347 150166 17 57 675c6915111d17723bfc245da2433ff62225a338 0 0 0 0 0  
8216 8216 20200503 OK 3972 59804   63776 236 743 92       2635 A 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 238 743 2020-05-03T00:00:00Z 70368 4150 66084 3972                             40 121 0 63776 posNeg 121 63776 0 0 2cb74d001c83ecf541da217c28179d69c31dccaa 0 0 0 0 0  
8217 8217 20200503 OR 2680 59374   62054 205 598 46   21   860 A+ 5/3/2020 11:00 2020-05-03T11:00:00Z 05/03 07:00 109 598 2020-05-03T11:00:00Z                                     41 45 1873 62054 posNeg 1918 62054 0 3 ca7bd76b6981dc61747d2529e16ae9cbe56af4cd 0 0 0 0 0  
8218 8218 20200503 PA 49267 191374   240641 2645       562     B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 2444   2020-05-03T00:00:00Z               240641                     42 962 4303 240641 posNeg 5265 240641 26 0 6232ba332e8fc27602bcffb31fb967cc731a08c3 0 0 0 0 0  
8219 8219 20200503 PR 1808 9313   11121 171             D 5/3/2020 06:00 2020-05-03T06:00:00Z 05/03 02:00 97   2020-05-03T06:00:00Z       988 53         820                 72 51 0 11121 posNeg 51 11121 2 0 d50c85910af01a7c65aa3095921d0f565e67cf8c 0 0 0 0 0  
8220 8220 20200503 RI 9703 55233   75274 330 1013 83   59   565 A+ 5/3/2020 03:00 2020-05-03T03:00:00Z 05/02 23:00 320 1013 2020-05-03T03:00:00Z 77910 11036 66874 9703     75274 64936                     44 181 1610 64936 totalTestEncountersViral 2183 64936 24 36 2802926f258152aa86ed0c28b5b57e91b42802d6 0 0 0 0 0  
8221 8221 20200503 SC 6626 57562   64188   1110         3622 B 5/3/2020 15:30 2020-05-03T15:30:00Z 05/03 11:30 275 1110 2020-05-03T15:30:00Z       6626                             45 137 2435 64188 posNeg 2572 64188 8 0 0df4ab5359e7ce38b17a57bc43c3151d9e3c7489 0 0 0 0 0  
8223 8223 20200503 TN 13177 191430   204607 510 1135         5814 B 5/3/2020 15:00 2020-05-03T15:00:00Z 05/03 11:00 210 1135 2020-05-03T15:00:00Z       13177                             47 516 7815 204607 posNeg 8331 204607 1 10 76a3dd46683630c76fbc86e4bb0e20ae874c8e70 0 0 0 0 0  
8225 8225 20200503 UT 5175 116927   122102   436         2238 C 5/3/2020 15:00 2020-05-03T15:00:00Z 05/03 11:00 50 436 2020-05-03T15:00:00Z       5175                             49 194 4104 122102 posNeg 4298 122102 1 18 159f58007f27671126273a2e4ca34d534c4dac55 0 0 0 0 0  
8227 8227 20200503 VI 66 951 29 1017             51 C 5/3/2020 08:04 2020-05-03T08:04:00Z 05/03 04:04 4   2020-05-03T08:04:00Z                                     78 0 29 1046 posNeg 29 1017 0 0 5ad65f22d26d8a3598c710f073c3078317c6418f 0 0 0 0 0  
8228 8228 20200503 VT 901 15570   16471 19             C 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 52   2020-05-03T00:00:00Z       897                             50 5 338 16471 posNeg 343 16471 1 0 d6f558c55d88c0fdb692722fe0a326d7489d056c 0 0 0 0 0  
8229 8229 20200503 WA 16132 213668   229800 411   120         B 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 830   2020-05-03T00:00:00Z       16132     229800 213630                     53 84 1713 229800 posNeg 1797 229800 6 0 57c5479eb46c7c05ec138e6cd59dabf5fc37cebb 0 0 0 0 0  
8230 8230 20200503 WI 9227 77997 231 87224 348 1608 116 402     3723 A+ 5/3/2020 00:00 2020-05-03T00:00:00Z 05/02 20:00 339 1608 2020-05-03T00:00:00Z       7964                             55 307 2427 87455 posNeg 2734 87224 5 17 3fe1ab67595bd179fec9fc362d351f8d6303bd5c 0 0 0 0 0  
8231 8231 20200503 WV 1191 50447   51638 73   28   15   611 C 5/3/2020 10:00 2020-05-03T10:00:00Z 05/03 06:00 50   2020-05-03T10:00:00Z 51638     1191                             54 22 2470 51638 posNeg 2492 51638 2 0 148ab598b4810db53b1a8aebd0577daec0aada32 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
);