states_daily_4pm_et

Table actions

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

64 rows where "dateChecked" is on date 2020-06-12

✎ 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, hospitalizedIncrease, dateModified (date)

dateChecked (date) ✖

  • 2020-06-12 · 64 ✖
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
5787 5787 20200615 KS 11419 125543   136962   988   327   143 676 A 6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 245 988 2020-06-12T13:30:00Z               136741                     20 372 7438 136962 posNeg 7810 136962 2 15 c3e71f1fefe07875c3cb324779fcbd61c5015c66 0 0 0 0 0  
5843 5843 20200614 KS 11047 118105   129152   973   324   143 667 A 6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 2020-06-12T13:30:00Z               128939                     20 0 0 129152 posNeg 0 129152 0 0 fcef10131c89146fc00f0d40c53c75d4fd087ab8 0 0 0 0 0  
5865 5865 20200614 OR 5636 168246   173882 133 875 47   15   2396 A+ 6/12/2020 03:01 2020-06-12T03:01:00Z 06/11 23:01 176 875 2020-06-12T03:01:00Z       5207       166019                     41 101 3302 173882 posNeg 3403 173882 2 0 153106b091ae7da1ae589e95856b08ade09af858 0 0 0 0 0  
5887 5887 20200613 CO 28822 207639   278526 274 5234         4184 A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1348 5234 2020-06-12T00:00:00Z       26215     278526 236461 85027 5892 79135               8 175 1916 236461 totalTestEncountersViral 5596 236461 9 177 a2ee4b750e70957b3281e73dc76dbe6b8f4ffdde 0 0 0 0 0  
5888 5888 20200613 CT 44994 305173   350167 233 9912         7611 B 6/12/2020 20:30 2020-06-12T20:30:00Z 06/12 16:30 4186 9912 2020-06-12T20:30:00Z 347190     42017 3342 844                         9 305 4730 350167 posNeg 5035 350167 27 0 6af6cf90df49c7c408cac4b1002c066ec6c184df 0 0 0 0 0  
5889 5889 20200613 DC 9709 53327   63036 197   78   52   1143 A+ 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 511   2020-06-12T00:00:00Z             63036 50032                     11 55 1028 63036 posNeg 1083 63036 5 0 3831d0956b3e67c561d63768967ed01011df10cd 0 0 0 0 0  
5890 5890 20200613 DE 10229 69870   80099 93           6116 A 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 495   2020-06-12T18:00:00Z       9278 437 58   80099                     10 56 2349 80099 posNeg 2405 80099 1 0 f2f8cec0bf6bc4faf1ca27be00a87e3b6ea05fc7 0 0 0 0 0  
5894 5894 20200613 HI 706 58632   59338   87         627 D 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 17 87 2020-06-12T18:00:00Z 68738             59338                     15 14 745 59338 posNeg 759 59338 0 1 15607b397ab6c012c4352ac2a5f03c9b7f1d3463 0 0 0 0 0  
5896 5896 20200613 ID 3353 59305   62328 24 265 5 98     2776 A 6/12/2020 19:00 2020-06-12T19:00:00Z 06/12 15:00 87 265 2020-06-12T19:00:00Z 62328     3023 67 20                         16 51 1175 62658 posNeg 1214 62658 1 0 0c4b6dd841994dde96d4849c23d8923bacbcd6e7 0 0 0 0 0  
5898 5898 20200613 IN 39543 301094   340637 871 6349 316 1354 118   28241 A+ 6/12/2020 23:59 2020-06-12T23:59:00Z 06/12 19:59 2413 6349 2020-06-12T23:59:00Z         2231 182   340637                     18 397 5060 340637 posNeg 5457 340637 17 0 a43a1962c74a426f0331039c27b897af64efd15e 0 0 0 0 0  
5899 5899 20200613 KS 11047 118105   129152   973   324   143 667 A 6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 2020-06-12T13:30:00Z               128939                     20 0 0 129152 posNeg 0 129152 0 0 4c9879d93c59223a803c0b0bb988d824185340db 0 0 0 0 0  
5906 5906 20200613 MN 30465 387245   417710 390 3581 191 1104     25620 A 6/12/2020 17:00 2020-06-12T17:00:00Z 06/12 13:00 1314 3581 2020-06-12T17:00:00Z       30465 1283 31 417710                       27 2 9656 417710 posNeg 9658 417710 9 24 e262735da28d3abba7740d9ff2d3a7a53ec5af98 0 0 0 0 0  
5908 5908 20200613 MP 30 7906   7936             19 D 6/12/2020 18:18 2020-06-12T18:18:00Z 06/12 14:18 2   2020-06-12T18:18:00Z 7936     30                             69 0 174 7936 posNeg 174 7936 0 0 6549cdd073de2d1b3fade1bb85e042f00457a624 0 0 0 0 0  
5909 5909 20200613 MS 19348 194537   213885 684 2644 160   103   13356 A 6/12/2020 19:00 2020-06-12T19:00:00Z 06/12 15:00 889 2644 2020-06-12T19:00:00Z 213753     19216 873 16     9442 95                 28 257 -865 213885 posNeg -608 213885 8 1 33b1ad73de50ac2d698b714210e1ef62783f9c11 0 0 0 0 0  
5913 5913 20200613 NE 16513 117864   134377 157 1067         9610 D 6/12/2020 19:00 2020-06-12T19:00:00Z 06/12 15:00 216 1067 2020-06-12T19:00:00Z       16513       134536                     31 198 3406 134377 posNeg 3604 134377 4 38 3df81353410443cf5735c2cef8a85252ae83ff29 0 0 0 0 0  
5914 5914 20200613 NH 5251 88705   112141 76 503   149     3843 B 6/12/2020 09:00 2020-06-12T09:00:00Z 06/12 05:00 315 503 2020-06-12T09:00:00Z 112141     5251       93956 17720     15236             33 42 1997 93956 posNeg 2639 93956 7 -1 33318d0d6238eb4b0018cacb589f7789c01dc357 0 0 0 0 0  
5916 5916 20200613 NM 9526 245758   255284 179 1625         3983 C 6/12/2020 17:30 2020-06-12T17:30:00Z 06/12 13:30 426 1625 2020-06-12T17:30:00Z 255284     9526                             35 0 0 255284 posNeg 0 255284 0 0 13b0ffc6d8630111366c2ccd5229743c135e4c74 0 0 0 0 0  
5918 5918 20200613 NY 382630 2489610   2872240 1734 89995 517   360   68584 A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 24527 89995 2020-06-12T00:00:00Z       382630     2872240                       36 916 69924 2872240 posNeg 70840 2872240 32 0 da7a04666d7c6d0bf9c62bb2fae5c1204c22f550 0 0 0 0 0  
5920 5920 20200613 OK 8073 238366   246439 154 1111 67       6495 A+ 6/12/2020 08:00 2020-06-12T08:00:00Z 06/12 04:00 359 1111 2020-06-12T08:00:00Z 248091 9456 238366 8073         27415 974                 40 225 0 246439 posNeg 225 246439 0 8 78a8370fc28f65ca83dfd0ac3c78f7375fc245c7 0 0 0 0 0  
5921 5921 20200613 OR 5535 164944   170479 133 875 47   15   2396 A+ 6/12/2020 03:01 2020-06-12T03:01:00Z 06/11 23:01 174 875 2020-06-12T03:01:00Z       5207       166019                     41 158 4132 170479 posNeg 4290 170479 1 0 a4560ec7df3010355fbcc649305f7912fd8f64d2 0 0 0 0 0  
5930 5930 20200613 VA 53869 406124 283 484215 959 8090 295   142   7131 A+ 6/12/2020 17:00 2020-06-12T17:00:00Z 06/12 13:00 1541 8090 2020-06-12T17:00:00Z   63856   51499 1435 106 484215                       51 658 8805 460276 posNeg 10561 459993 7 62 e3c49b4be54b38db01cd2e52e1c49b5ef8c462f0 0 0 0 0 0  
5931 5931 20200613 VI 72 2284 7 2356             64 C 6/12/2020 19:53 2020-06-12T19:53:00Z 06/12 15:53 6   2020-06-12T19:53:00Z 2363       6                           78 0 63 2363 posNeg 63 2356 0 0 81ad2f84ddfd4485a225af8fabc34810e1f2b5de 0 0 0 0 0  
5933 5933 20200613 WA 27348 465461   492809 225 3817     43     B 6/12/2020 02:59 2020-06-12T02:59:00Z 06/11 22:59 1204 3817 2020-06-12T02:59:00Z       27348 1204   492809 428859                     53 193 6230 492809 posNeg 6423 492809 10 45 8f2c5588de0a0d840ceef50f19e3f2b1ca880e37 0 0 0 0 0  
5937 5937 20200612 AK 625 70255   70880 15       3   403 A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 12   2020-06-12T00:00:00Z 70880     625 12                           2 14 1855 70880 posNeg 1869 70880 1 0 dbaa13ed6e9f5edca1e62f091a463c216ade97a9 0 0 0 0 0  
5938 5938 20200612 AL 23710 262675   286008 624 2202   658   384 13508 B 6/12/2020 11:00 2020-06-12T11:00:00Z 06/12 07:00 769 2202 2020-06-12T11:00:00Z 286008     23333 764 5                         1 865 6694 286385 posNeg 7553 286385 14 37 6a5a79a6af199ad831660a0cfd2963490a1c1763 0 0 0 0 0  
5939 5939 20200612 AR 11547 169575   182645 203 961     49 157 7607 A 6/12/2020 15:10 2020-06-12T15:10:00Z 06/12 11:10 176 961 2020-06-12T15:10:00Z 182645     11547                             5 731 3726 181122 posNeg 6428 181122 5 36 c09d744843c10beb7aec4b079d86db72a60b3d43 0 0 0 0 0  
5941 5941 20200612 AZ 32918 289861   320816 1336 4079 429   278   5980 A+ 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1144 4079 2020-06-12T00:00:00Z       30955 1060 67   320816 122070                   4 1654 11543 322779 posNeg 11543 322779 17 38 a27b5097c1273b2334831209d5b4b32a03c35889 0 0 0 0 0  
5942 5942 20200612 CA 141983 2520275   2662258 4480   1310         B 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 4943   2020-06-12T00:00:00Z 2662258     141983                             6 2702 61909 2662258 posNeg 64611 2662258 62 0 3f918dd092abfb315b81ae2180d10a987ce7d75c 0 0 0 0 0  
5943 5943 20200612 CO 28647 205723   272930 279 5057         4169 A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1339 5057 2020-06-12T00:00:00Z       26040     272930 231763 83345 5799 77546               8 148 3877 234370 totalTestEncountersViral 5401 234370 11 22 5d67484cb8b4331d35a92694c7b72dfc4bc1c062 0 0 0 0 0  
5947 5947 20200612 FL 70971 1264928 1242 1335899   11986           A 6/12/2020 10:00 2020-06-12T10:00:00Z 06/12 06:00 2967 11986 2020-06-12T10:00:00Z 1571222 96007 1472224 70971 2967     1336895       179109 7717 171364         12 1902 27249 1337141 posNeg 29151 1335899 29 136 2a715dada79dac4f9958603eb41676fd74b13b8c 0 0 0 0 0  
5948 5948 20200612 GA 55783 536175   586426 836 9181   2021       A 6/12/2020 14:50 2020-06-12T14:50:00Z 06/12 10:50 2418 9181 2020-06-12T14:50:00Z 586426 50251 536175 55783         110825 6504                 13 810 6907 591958 posNeg 7493 591958 43 108 081a6607d636cd6ccb3357203524dab02e04bdd6 0 0 0 0 0  
5949 5949 20200612 GU 184 8343   8527             168 B 6/12/2020 05:00 2020-06-12T05:00:00Z 06/12 01:00 5   2020-06-12T05:00:00Z 8426 174 8249 174       8517 110 2                 66 1 146 8527 posNeg 147 8527 0 0 29141bfeab6e233082f4866dfba68228235e34b0 0 0 0 0 0  
5951 5951 20200612 IA 23337 191207   214544 225   81   47   14227 A+ 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 643   2020-06-12T00:00:00Z       23337       214943       25697 2095 23575         19 399 5606 214544 posNeg 6005 214544 4 0 d1af79a4fb50d17f070b750a3b2576e714910ece 0 0 0 0 0  
5953 5953 20200612 IL 132059 1015903   1147962 2209   648   375     A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 6441   2020-06-12T00:00:00Z 1147101     131198 6260 181                         17 732 24179 1147962 posNeg 24911 1147962 78 0 502214851a500c0f571455f67c62fa8a56d4e7c0 0 0 0 0 0  
5955 5955 20200612 KS 11047 118105   129152   973   324   143 667 A 6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 2020-06-12T13:30:00Z               128939                     20 235 5175 129152 posNeg 5410 129152 3 19 7da603739de3565658cf672c50ff9df97cad2622 0 0 0 0 0  
5957 5957 20200612 LA 44995 434539   479534 549       74   33904 B 6/12/2020 13:00 2020-06-12T13:00:00Z 06/12 09:00 2996   2020-06-12T13:00:00Z       44995 2883 113   479534                     22 523 9338 479534 posNeg 9861 479534 9 0 f9f9f03ed3b9157dfcfce8004f2fc3c215e58c2b 0 0 0 0 0  
5958 5958 20200612 MA 105059 588300   891121 1143 10726 276   170   88725 A+ 6/12/2020 10:00 2020-06-12T10:00:00Z 06/12 06:00 7538 10726 2020-06-12T10:00:00Z 891121 132202   100811 7382 156   689111       55784             25 392 9879 693359 totalTestsViral 13004 693359 46 72 286c8ada6109ff7db59a142d2c95bf9167ed69fa 0 0 0 0 0  
5959 5959 20200612 MD 60613 339482   400095 836 9923 331       4474 B 6/12/2020 10:00 2020-06-12T10:00:00Z 06/12 06:00 2900 9923 2020-06-12T10:00:00Z 467564 69655   60613 2773 127   400095                     24 416 7309 400095 posNeg 7725 400095 25 134 42835e64d82d6da89d601fbc0e7c516581f4f973 0 0 0 0 0  
5960 5960 20200612 ME 2721 64166   66887 32 308 11   5   2105 B 6/12/2020 12:15 2020-06-12T12:15:00Z 06/12 08:15 100 308 2020-06-12T12:15:00Z 67585 3311 64166 2420 100       5464 274 5182               23 54 1376 66887 posNeg 1430 66887 0 0 f604b1d8d3bdb18f8de858ce7b58009e8544512c 0 0 0 0 0  
5961 5961 20200612 MI 65672 720615   786287 636   253   139   42041 A+ 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 5990   2020-06-12T00:00:00Z 802036 81421 720615 59621 5745 245     122843                   26 223 15544 786287 posNeg 15767 786287 5 0 81ed9807088938b5e06e65b3bb79215237b6206a 0 0 0 0 0  
5963 5963 20200612 MO 15585 249550   265135 593       69     B 6/12/2020 15:00 2020-06-12T15:00:00Z 06/12 11:00 872   2020-06-12T15:00:00Z 270232 17275 252506 15585       265135       32452 1232 31220         29 195 5900 265135 posNeg 6095 265135 12 0 b3e8e0a721cf0ea9e9aa2d35449e7931e62d4f77 0 0 0 0 0  
5964 5964 20200612 MP 30 7732   7762             19 D 6/12/2020 01:20 2020-06-12T01:20:00Z 06/11 21:20 2   2020-06-12T01:20:00Z 7762     30                             69 0 181 7762 posNeg 181 7762 0 0 c9587fc860a99e7ef0565054f0ac029158dcf206 0 0 0 0 0  
5966 5966 20200612 MT 573 56449   57022 7 77         489 C 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 18 77 2020-06-12T00:00:00Z 57022     573                             30 10 1235 57022 posNeg 1245 57022 0 3 0eea763bc975da724424861a7def251d1a3d6a9b 0 0 0 0 0  
5967 5967 20200612 NC 41249 554448   595697 760           23653 A 6/12/2020 12:12 2020-06-12T12:12:00Z 06/12 08:12 1092   2020-06-12T12:12:00Z 595697     41249 1092                           37 1768 21252 595697 posNeg 23020 595697 28 0 6dd1ba2ce5209548eab15d8f04e59b8dbc709b47 0 0 0 0 0  
5968 5968 20200612 ND 3014 81148   123650 35 197         2573 F 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 67 197 2020-06-12T00:00:00Z 126443     3014 64 3 123650 81930 3816 124 3692               38 36 1340 84162 totalTestEncountersViral 3332 84162 0 4 1939c956b956a6928676d5e136062c6dc10acce2 0 0 0 0 0  
5969 5969 20200612 NE 16315 114458   130773 164 1029         9229 D 6/12/2020 21:07 2020-06-12T21:07:00Z 06/12 17:07 212 1029 2020-06-12T21:07:00Z       16315       130933                     31 290 2821 130773 posNeg 3111 130773 17 29 dfcf531354f519f217334e32626ec395db87f24a 0 0 0 0 0  
5971 5971 20200612 NJ 166164 889232   1055396 1480 18607 415   300   28509 A+ 6/12/2020 13:00 2020-06-12T13:00:00Z 06/12 09:00 14241 18607 2020-06-12T13:00:00Z 1055396     166164 12489 1752                         34 348 24255 1055396 posNeg 24603 1055396 49 115 052c0c6dbe187cab943349f67ce1a561f50277c7 0 0 0 0 0  
5972 5972 20200612 NM 9526 245758   255284 179 1625         3983 C 6/12/2020 17:30 2020-06-12T17:30:00Z 06/12 13:30 426 1625 2020-06-12T17:30:00Z 255284     9526                             35 276 9451 255284 posNeg 9727 255284 16 42 8da267ae431729625a1cc2a8cbb299abb6f49912 0 0 0 0 0  
5973 5973 20200612 NV 10676 188769   199445 328   77   36   604 A+ 6/12/2020 11:30 2020-06-12T11:30:00Z 06/12 07:30 475   2020-06-12T11:30:00Z 229273     10676       199356                     32 277 5914 199445 posNeg 6191 199445 0 0 f3d1a5b5cf0b9d45d5c40c50f230f13edd4e1559 0 0 0 0 0  
5974 5974 20200612 NY 381714 2419686   2801400 1898 89995 552   387   68399 A 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 24495 89995 2020-06-12T00:00:00Z       381714     2801400                       36 822 71573 2801400 posNeg 72395 2801400 53 0 eb41611a881d6ea5556bdd88ba2ef8347658d216 0 0 0 0 0  
5975 5975 20200612 OH 40424 483294   523718 547 6814 217 1745 144     B 6/12/2020 14:00 2020-06-12T14:00:00Z 06/12 10:00 2508 6814 2020-06-12T14:00:00Z 520813     37519 2280 228                         39 420 10715 523718 posNeg 11135 523718 18 61 30cad72cb61e7ed0046a8f5e62d2766e234e3805 0 0 0 0 0  
5976 5976 20200612 OK 7848 238366   246214 154 1103 65       6391 A+ 6/12/2020 08:00 2020-06-12T08:00:00Z 06/12 04:00 359 1103 2020-06-12T08:00:00Z 248091 9156 238366 7848         27415 974                 40 222 4547 246214 posNeg 4769 246214 2 11 8290b12d43f4dbe20d2f61a1b81a095e35d141b4 0 0 0 0 0  
5978 5978 20200612 PA 77999 488385   566384 899       202   56939 A+ 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 6162   2020-06-12T00:00:00Z       75800       564185                     42 66 11946 566384 posNeg 12012 566384 49 0 aa3d83fde5abab94a5aa21aeaa622502356a9024 0 0 0 0 0  
5979 5979 20200612 PR 5536 113280   118816 92   7   4     C 6/12/2020 06:30 2020-06-12T06:30:00Z 06/12 02:30 146   2020-06-12T06:30:00Z 114723 2326 112331 1443 56 90       4093                 72 184 24595 118816 posNeg 24779 118816 2 0 c6b80c753cc9c8d5595fbcb2dfad2e254591e6f5 0 0 0 0 0  
5980 5980 20200612 RI 16023 115483   200175 141 1853 28   17   1435 A+ 6/12/2020 03:00 2020-06-12T03:00:00Z 06/11 23:00 833 1853 2020-06-12T03:00:00Z 202294 22336 179958 16023     200175 131506                     44 81 2093 131506 totalTestEncountersViral 3687 131506 10 11 137bf134029a0872cba874c2c925ec4d021db28b 0 0 0 0 0  
5981 5981 20200612 SC 17170 218889   236059 512 1988         8682 A+ 6/12/2020 16:00 2020-06-12T16:00:00Z 06/12 12:00 593 1988 2020-06-12T16:00:00Z 242543 23654 218889 17170 593       28298 1385 26913               45 729 5273 236059 posNeg 6002 236059 5 90 f23280aa1d1704430e17f13ee5ab1936d58d6617 0 0 0 0 0  
5983 5983 20200612 TN 29126 561047   590173 608 2049         19425 B 6/12/2020 15:00 2020-06-12T15:00:00Z 06/12 11:00 468 2049 2020-06-12T15:00:00Z 594960 33913 561047 28942 447 21                         47 588 54291 590173 posNeg 54879 590173 27 38 aa8989d3b9f316f44e3e5f97a6ecbdd2beb55535 0 0 0 0 0  
5984 5984 20200612 TX 83680 1143277   1226957 2166           55258 B 6/12/2020 16:40 2020-06-12T16:40:00Z 06/12 12:40 1939   2020-06-12T16:40:00Z 1226957     83680         143174 5925                 48 2097 18540 1226957 posNeg 20637 1226957 19 0 1a881e71e264ee690bae39e560b0ee401170f452 0 0 0 0 0  
5985 5985 20200612 UT 13577 245209   258786 197 988   294   130 7935 B 6/12/2020 10:20 2020-06-12T10:20:00Z 06/12 06:20 139 988 2020-06-12T10:20:00Z       13577       258786             5 5 5 5 49 325 3793 258786 posNeg 4118 258786 8 20 ea16f63ce27da53e7f4594c5ac4ce9838f22e3dd 0 0 0 0 0  
5987 5987 20200612 VI 72 2221 6 2293             64 C 6/12/2020 15:30 2020-06-12T15:30:00Z 06/12 11:30 6   2020-06-12T15:30:00Z 2299       6                           78 0 41 2299 posNeg 41 2293 0 0 02caa7538a01a6480a32df2a06b6acf49143334e 0 0 0 0 0  
5989 5989 20200612 WA 27155 459231   486386 226 3772     8     B 6/12/2020 02:59 2020-06-12T02:59:00Z 06/11 22:59 1194 3772 2020-06-12T02:59:00Z       27155 1194   486386 422770                     53 388 9249 486386 posNeg 9637 486386 4 -1 fcc11d3b62382d36640a8bfe67b5111eb8a8797a 0 0 0 0 0  
5990 5990 20200612 WI 24795 377362 172 402157 287 3003 104 670     15783 A+ 6/12/2020 16:00 2020-06-12T16:00:00Z 06/12 12:00 689 3003 2020-06-12T16:00:00Z       22246 689     399608                     55 354 11308 402329 posNeg 11662 402157 7 27 328785725657b2f213b9f73c9c3ade2e62a52929 0 0 0 0 0  
5991 5991 20200612 WV 2233 121806   124039 29   9   2   1553 B 6/12/2020 10:00 2020-06-12T10:00:00Z 06/12 06:00 86   2020-06-12T10:00:00Z 123963     2157         7354                   54 21 2898 124039 posNeg 2919 124039 1 0 7aa80a0f274b8399dc5a30228023d1a79a7538fa 0 0 0 0 0  
5992 5992 20200612 WY 1027 30873   31900 5 92         814 C 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 18 92 2020-06-12T18:00:00Z 31684 941 30446 811                             56 18 264 31900 posNeg 282 31900 0 0 56e5f0b0a1d7e86803ae8c09229a3fdf39e48788 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
);