states_daily_4pm_et

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

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, probableCases, totalTestResultsSource, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, hospitalizedDischarged, negativeTestsViral, deathConfirmed, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, deathIncrease, hospitalizedIncrease, dateModified (date), dateChecked (date)

Link rowid ▼ date state positive probableCases negative pending totalTestResultsSource totalTestResults hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered lastUpdateEt dateModified checkTimeEt death hospitalized hospitalizedDischarged dateChecked totalTestsViral positiveTestsViral negativeTestsViral positiveCasesViral deathConfirmed deathProbable totalTestEncountersViral totalTestsPeopleViral totalTestsAntibody positiveTestsAntibody negativeTestsAntibody totalTestsPeopleAntibody positiveTestsPeopleAntibody negativeTestsPeopleAntibody totalTestsPeopleAntigen positiveTestsPeopleAntigen totalTestsAntigen positiveTestsAntigen fips positiveIncrease negativeIncrease total totalTestResultsIncrease posNeg dataQualityGrade deathIncrease hospitalizedIncrease hash commercialScore negativeRegularScore negativeScore positiveScore score grade
14523 14523 20200615 KS 11419   125543   posNeg 136962   988   327   143   6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 245 988 676 2020-06-12T13:30:00Z               136741                     20 372 7438 136962 7810 136962   2.0 15.0 fd806e0c2d354182359060cd1e402430658d3b61 0 0 0 0 0  
14545 14545 20200615 OR 5636   168246   totalTestsViral 256784 133 875 47   15   2396 6/12/2020 03:01 2020-06-12T03:01:00Z 06/11 23:01 176 875   2020-06-12T03:01:00Z 256784 14030 242754         166019                     41 101 3302 173882 6243 173882   2.0 0.0 936f45bc809db8d6067af0a676e9020d449b8345 0 0 0 0 0  
14579 14579 20200614 KS 11047   118105   posNeg 129152   973   324   143   6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 667 2020-06-12T13:30:00Z               128939                     20 0 0 129152 0 129152   0.0 0.0 3cc300702d94b8fc51505eb8ea270b0dfcd5a62d 0 0 0 0 0  
14601 14601 20200614 OR 5535   164944   totalTestsViral 250541 133 875 47   15   2396 6/12/2020 03:01 2020-06-12T03:01:00Z 06/11 23:01 174 875   2020-06-12T03:01:00Z 250541 13842 236699         166019                     41 158 4132 170479 6302 170479   1.0 0.0 1aec89a01190029c99e69ec997a1ef72f85ef41a 0 0 0 0 0  
14624 14624 20200613 CT 44994 1916     totalTestsViral 362824 233 9912         7611 6/12/2020 20:30 2020-06-12T20:30:00Z 06/12 16:30 4186 9912 7611 2020-06-12T20:30:00Z 362824 55208 306308 43078 3342 844                         9 305 0 44994 6507 44994   27.0 0.0 931e270e6a52dda7ff6cd01f12466d7dbeb0fb54 0 0 0 0 0  
14625 14625 20200613 DC 9709       totalTestEncountersViral 63036 197   78   52   1143 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 511     2020-06-12T00:00:00Z             63036 50032                     11 55 0 9709 1083 9709   5.0 0.0 fe09cad71bacafc03679980ca4813615cb02320b 0 0 0 0 0  
14626 14626 20200613 DE 10229 951 69870   totalTestEncountersViral 93481 93           6116 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 495     2020-06-12T18:00:00Z   12677   9278 437 58 93481 80099                     10 56 2349 80099 2416 80099   1.0 0.0 d860a7eee1a2ec8b9d928bbbd152b5c28c5bbd3c 0 0 0 0 0  
14630 14630 20200613 HI 706   58632   totalTestEncountersViral 67076   87         627 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 17 87   2020-06-12T18:00:00Z 68738 659     17   67076 59338                     15 14 745 59338 949 59338   0.0 1.0 c0802a109da77258c3f64c77eb78715d7525f926 0 0 0 0 0  
14632 14632 20200613 ID 3353 330 59305   totalTestsPeopleViral 62328 24 265 5 98     2776 6/12/2020 19:00 2020-06-12T19:00:00Z 06/12 15:00 87 265   2020-06-12T19:00:00Z       3023 67 20   62328                     16 51 1175 62658 1214 62658   1.0 0.0 08c6f351d21620bb91d02e392bd4b60191cce4cc 0 0 0 0 0  
14634 14634 20200613 IN 39543   301094   totalTestsViral 444384 871 6349 316 1354 118     6/12/2020 23:59 2020-06-12T23:59:00Z 06/12 19:59 2413 6349 28241 2020-06-12T23:59:00Z 444384 41037     2231 182   340637                     18 397 5060 340637 13135 340637   17.0 0.0 0958f11820fe0fb71d16cad68118e2ea8ab3b0e9 0 0 0 0 0  
14635 14635 20200613 KS 11047   118105   posNeg 129152   973   324   143   6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 667 2020-06-12T13:30:00Z               128939                     20 0 0 129152 0 129152   0.0 0.0 ca7eacf199cbe021aba3216b284a767292242ec2 0 0 0 0 0  
14642 14642 20200613 MN 30465   387245   totalTestEncountersViral 417710 390 3581 191 1104     25620 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 9658 417710   9.0 24.0 8c71faa33af4a78446a90be7007201fd67c005ff 0 0 0 0 0  
14644 14644 20200613 MP 30   7906   posNeg 7936             19 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 174 7936   0.0 0.0 dcf7a60404483865e28445e5be2372adcf9fce38 0 0 0 0 0  
14645 14645 20200613 MS 19348 132 194537   posNeg 213885 684 2644 160   103   13356 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                   28 257 -865 213885 -608 213885   8.0 1.0 890ba0ee6cdfa8c4bf8713dc0a37fd468a064c7f 0 0 0 0 0  
14649 14649 20200613 NE 16513   117864   totalTestsViral 161666 157 1067         9610 6/12/2020 19:00 2020-06-12T19:00:00Z 06/12 15:00 216 1067   2020-06-12T19:00:00Z 161666 19772 141410         134536                     31 198 3406 134377 3842 134377   4.0 38.0 64c1fee17d5789de04836abe5bd4581ad329c7ad 0 0 0 0 0  
14650 14650 20200613 NH 5251   88705   totalTestsViral 112141 76 503   149     3843 6/12/2020 09:00 2020-06-12T09:00:00Z 06/12 05:00 315 503   2020-06-12T09:00:00Z 112141             93956 17720     15236             33 42 1997 93956 2639 93956   7.0 -1.0 25e69554ddc80ff0ed4ea0ae6aafd462efc99650 0 0 0 0 0  
14654 14654 20200613 NY 382630       totalTestEncountersViral 2872240 1734 89995 517   360     6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 24527 89995 68584 2020-06-12T00:00:00Z             2872240                       36 916 0 382630 70840 382630   32.0 0.0 a621bd90137369b5805451cdeb36330aea8047ce 0 0 0 0 0  
14656 14656 20200613 OK 8073   238366   posNeg 246439 154 1111 67       6495 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 225 246439   0.0 8.0 392bf2e8a7fa827bcb456551881f63bf31829a5c 0 0 0 0 0  
14666 14666 20200613 VA 53869 2370   283 totalTestEncountersViral 484215 959 5511 295   142     6/12/2020 17:00 2020-06-12T17:00:00Z 06/12 13:00 1541 5511 7131 2020-06-12T17:00:00Z   63856   51499 1435 106 484215   58767 3588             169 75 51 658 0 54152 10561 53869   7.0 66.0 16a3765b083f7bdc0a9e1d7165fdb157e706d1bb 0 0 0 0 0  
14667 14667 20200613 VI 72   2284 7 posNeg 2356             64 6/12/2020 19:53 2020-06-12T19:53:00Z 06/12 15:53 6     2020-06-12T19:53:00Z         6     2363                     78 0 63 2363 63 2356   0.0 0.0 b7a105d4850d553341e4708ef7383e04f2a9c9b8 0 0 0 0 0  
14669 14669 20200613 WA 26852       totalTestEncountersViral 492809 372 3817     43     6/12/2020 02:59 2020-06-12T02:59:00Z 06/11 22:59 1204 3817   2020-06-12T02:59:00Z       26852 1204   492809 428859                     53 400 0 26852 6423 26852   10.0 45.0 4cf0dde043cb3b64193489fbe5d8a83397fca7d5 0 0 0 0 0  
14673 14673 20200612 AK 630       totalTestsViral 70880 15 55     3   403 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 12 55   2020-06-12T00:00:00Z 70880       12                           2 14 0 630 1869 630   1.0 1.0 b1351efee333e94921c6ba59df33d7986ee9f392 0 0 0 0 0  
14674 14674 20200612 AL 23710 377 262675   totalTestsPeopleViral 286008 624 2202   658   384 13508 6/12/2020 11:00 2020-06-12T11:00:00Z 06/12 07:00 769 2202   2020-06-12T11:00:00Z       23333 764 5   286008                     1 865 6694 286385 7553 286385   14.0 37.0 1fd5cc53511d41fbae03df8589064bee33890324 0 0 0 0 0  
14675 14675 20200612 AR 11547   169575   totalTestsViral 182645 203 961     49 157 7607 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 6428 181122   5.0 36.0 7ddc512d2a4bd72f4bc07885e5d1d560ccc93f9b 0 0 0 0 0  
14677 14677 20200612 AZ 32918 309 289861   totalTestsViral 444139 1336 4079 429   278     6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1144 4079 5980 2020-06-12T00:00:00Z 444139     30955 1060 67   320816 122070                   4 1654 11543 322779 15088 322779   17.0 38.0 3c75e7d9b993f776bd53bd257fbc4d342aab4ea4 0 0 0 0 0  
14678 14678 20200612 CA 141983       totalTestsViral 2662258 4480   1310         6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 4943     2020-06-12T00:00:00Z 2662258     141983                             6 2702 0 141983 64611 141983   62.0 0.0 64afe304f63ee49a66f0b98ec8c3fe998a8a3115 0 0 0 0 0  
14679 14679 20200612 CO 28822 2607 207639   totalTestEncountersViral 278526 274 5234           6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1595 5234 4184 2020-06-12T00:00:00Z       26215 1268 327 278526 236461 85027 5892 79135               8 175 1916 236461 5596 236461   12.0 177.0 3829e972198fe9c3074ec54b799c0d2815276857 0 0 0 0 0  
14683 14683 20200612 FL 68673   1264928 1242 totalTestEncountersViral 1392549   11986           6/12/2020 10:00 2020-06-12T10:00:00Z 06/12 06:00 2967 11986   2020-06-12T10:00:00Z 1571222 96007 1472224   2967   1392549 1336895       179109 7717 171364         12 1634 27249 1334843 30492 1333601   29.0 136.0 2567e80499d03e9d122fff35d0ad448be18ceae5 0 0 0 0 0  
14684 14684 20200612 GA 55783       totalTestsViral 585957 836 9181   2021       6/12/2020 14:50 2020-06-12T14:50:00Z 06/12 10:50 2418 9181   2020-06-12T14:50:00Z 585957 50189   55783         110825 6504                 13 810 0 55783 7493 55783   43.0 108.0 ab7caf7d28697fe4c431b67fd7c758ccbec958ad 0 0 0 0 0  
14685 14685 20200612 GU 184 10 8343   posNeg 8527             168 6/12/2020 05:00 2020-06-12T05:00:00Z 06/12 01:00 5     2020-06-12T05:00:00Z 8426 174 8249 174         110 2                 66 1 146 8527 147 8527   0.0 0.0 6fe6b4e4bb6537b9020c0d5ba270d03c7cae75e6 0 0 0 0 0  
14687 14687 20200612 IA 23337   191207   posNeg 214544 225   81   47   14227 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 6005 214544   4.0 0.0 921756f78b55887382fbf4e7b4464a32d2859112 0 0 0 0 0  
14689 14689 20200612 IL 132059 861 1015903   posNeg 1147962 2209   648   375     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 24911 1147962   78.0 0.0 c7a68fb45850ec7306b05244e3b1ea5fb1d8c308 0 0 0 0 0  
14691 14691 20200612 KS 11047   118105   posNeg 129152   973   324   143   6/12/2020 13:30 2020-06-12T13:30:00Z 06/12 09:30 243 973 667 2020-06-12T13:30:00Z               128939                     20 235 5175 129152 5410 129152   3.0 19.0 a9f9779d6a59dff20466808d8b8c61f2a3466465 0 0 0 0 0  
14693 14693 20200612 LA 44995   434539   posNeg 479534 549       74   33904 6/12/2020 13:00 2020-06-12T13:00:00Z 06/12 09:00 2996     2020-06-12T13:00:00Z 479534     44995 2883 113                         22 523 9338 479534 9861 479534   9.0 0.0 83296c31f43ec816fe0b6291ddcb3ae3bef0065f 0 0 0 0 0  
14694 14694 20200612 MA 105059   588300   totalTestsViral 891121 1143 10726 276   170   88725 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 13004 693359   46.0 72.0 c6e82e4187db972b83b2a76b4dbbca7b306b4b15 0 0 0 0 0  
14695 14695 20200612 MD 60613   339482   totalTestsViral 467564 836 9923 331       4474 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 9748 400095   25.0 134.0 c3b73c8ba3884eedceefc71f13d192e6f8ac71d6 0 0 0 0 0  
14696 14696 20200612 ME 2721 301 64166   posNeg 66887 32 308 11   5   2105 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 1430 66887   0.0 0.0 1d313f0950b14f558bafdb1e501a2791197c38f6 0 0 0 0 0  
14697 14697 20200612 MI 65672 6051 720615   posNeg 786287 636   253   139   42041 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 15767 786287   5.0 0.0 0d36e6cee8eb50adfc9bb5d41cfe0a69bb226669 0 0 0 0 0  
14699 14699 20200612 MO 15585   249550   totalTestsViral 270232 593       69     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 0 265135   12.0 0.0 b9567b22abb56347377518f2070aa5a798b66369 0 0 0 0 0  
14700 14700 20200612 MP 30   7732   posNeg 7762             19 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 181 7762   0.0 0.0 ebe8603a1fa962477f1c9949d23e5e49240915d5 0 0 0 0 0  
14702 14702 20200612 MT 573   56449   posNeg 57022 7 77         489 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 18 77   2020-06-12T00:00:00Z 57022                                   30 10 1235 57022 1245 57022   0.0 3.0 5e3785fb17672f88b7b6ed434545b7306f443483 0 0 0 0 0  
14703 14703 20200612 NC 41249   554448   posNeg 595697 760             6/12/2020 12:12 2020-06-12T12:12:00Z 06/12 08:12 1092   23653 2020-06-12T12:12:00Z 595697     41249 1092                           37 1768 21252 595697 23020 595697   28.0 0.0 3e807304b5c99b1b7bde67ffe012aee1a4c3dfbf 0 0 0 0 0  
14704 14704 20200612 ND 3012 0 81148   totalTestEncountersViral 123650 35 197         2573 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 77 197   2020-06-12T00:00:00Z 126443     3012     123650 81930 3816 124 3692               38 36 1340 84160 3332 84160   0.0 4.0 c36de2064b7fdf4fe6751d6e851afd00a0c08169 0 0 0 0 0  
14705 14705 20200612 NE 16315   114458   totalTestsViral 157824 164 1029         9229 6/12/2020 21:07 2020-06-12T21:07:00Z 06/12 17:07 212 1029   2020-06-12T21:07:00Z 157824 19491 137852         130933                     31 290 2821 130773 4137 130773   17.0 29.0 986446923bed7b0d55382bf486e3029516f8bc8d 0 0 0 0 0  
14707 14707 20200612 NJ 166711 547 889232   posNeg 1055943 1480 18607 415   300     6/12/2020 13:00 2020-06-12T13:00:00Z 06/12 09:00 14232 18607 28509 2020-06-12T13:00:00Z 1055396     166164 12489 1743                         34 373 24255 1055943 24628 1055943   49.0 115.0 0534c4d38d988dcc2ef86c647fab8a485dd57697 0 0 0 0 0  
14708 14708 20200612 NM 9526   245758   posNeg 255284 179 1625         3983 6/12/2020 17:30 2020-06-12T17:30:00Z 06/12 13:30 426 1625   2020-06-12T17:30:00Z 255284                                   35 159 4245 255284 4404 255284   6.0 0.0 0be396383968f1e56f64a52ea300ea2b0df9d9ad 0 0 0 0 0  
14709 14709 20200612 NV 10676   188769   totalTestEncountersViral 244346 328   77   36     6/12/2020 11:30 2020-06-12T11:30:00Z 06/12 07:30 475     2020-06-12T11:30:00Z 229273     10676     244346 199356                     32 277 5914 199445 4759 199445   0.0 0.0 4b4b767640a606c42b9530f83ebc4a8a3a0d7034 0 0 0 0 0  
14710 14710 20200612 NY 381714       totalTestEncountersViral 2801400 1898 89995 552   387     6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 24495 89995 68399 2020-06-12T00:00:00Z             2801400                       36 822 0 381714 72395 381714   53.0 0.0 dcd296c9ecc6929f5949106f9527134ab6e66e8a 0 0 0 0 0  
14711 14711 20200612 OH 40424 2905     totalTestsViral 557808 547 6814 217 1745 144     6/12/2020 14:00 2020-06-12T14:00:00Z 06/12 10:00 2508 6814   2020-06-12T14:00:00Z 557808 44225   37519 2280 228                         39 420 0 40424 13033 40424   18.0 61.0 575efb8cd7b4e78388e2173cb83fa6a9ae925310 0 0 0 0 0  
14712 14712 20200612 OK 7848   238366   posNeg 246214 154 1103 65       6391 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 4769 246214   2.0 11.0 baec6b03d55aac101ab51dabab45bc6583e6b2e8 0 0 0 0 0  
14714 14714 20200612 PA 77999 2199 488385   totalTestEncountersViral 663676 899       202   56939 6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 6162     2020-06-12T00:00:00Z       75800     663676 564185                     42 66 11946 566384 15287 566384   49.0 0.0 da74781556a38e7613d9a76a5313ec4c7f0530e2 0 0 0 0 0  
14715 14715 20200612 PR 1443   113280   posNeg 114723 92   7   4     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 40 24595 114723 24635 114723   2.0 0.0 cc645f4a3fabccd62a2c291e7bcf548728988451 0 0 0 0 0  
14716 14716 20200612 RI 16023   115483   totalTestEncountersViral 200175 141 1853 28   17     6/12/2020 03:00 2020-06-12T03:00:00Z 06/11 23:00 833 1853 1435 2020-06-12T03:00:00Z 202294 22336 179958       200175 131506                     44 81 2093 131506 3687 131506   10.0 11.0 d190ea679287d39f6bc879dc1263d32378ba3851 0 0 0 0 0  
14717 14717 20200612 SC 17170   218889   posNeg 236059 512 1988         8682 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 6002 236059   5.0 90.0 c7ac3ea3f01383b5375cc2c6efec2cd8c9099dcf 0 0 0 0 0  
14719 14719 20200612 TN 29126 184     totalTestsViral 594960 608 2049         19425 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 0 29126 59864 29126   27.0 38.0 3a02f06f4ba98ddcdb9972fd434fff4e81a690f7 0 0 0 0 0  
14720 14720 20200612 TX 83680       totalTestsViral 1530984 2166           55258 6/12/2020 16:40 2020-06-12T16:40:00Z 06/12 12:40 1939     2020-06-12T16:40:00Z 1530984 117638   83680         143174 5925             963 117 48 2097 0 83680 42643 83680   19.0 0.0 58be70aae1fd8508a8e131d4192cdb812d5f4b15 0 0 0 0 0  
14721 14721 20200612 UT 13577   250040   totalTestsViral 303200 197 988   294   130 7935 6/12/2020 10:20 2020-06-12T10:20:00Z 06/12 06:20 139 988   2020-06-12T10:20:00Z 303200 15816 287384         264173             5 5 5 5 49 325 3453 263617 5184 263617   8.0 20.0 9832d3a3921272c1bdb86636c38d11fcfe0e3fd7 0 0 0 0 0  
14723 14723 20200612 VI 72   2221 6 posNeg 2293             64 6/12/2020 15:30 2020-06-12T15:30:00Z 06/12 11:30 6     2020-06-12T15:30:00Z         6     2299                     78 0 41 2299 41 2293   0.0 0.0 80550feb3ae072f657be98df1f3417267d50d72a 0 0 0 0 0  
14725 14725 20200612 WA 26452       totalTestEncountersViral 486386 386 3772     8     6/12/2020 02:59 2020-06-12T02:59:00Z 06/11 22:59 1194 3772   2020-06-12T02:59:00Z       26452 1194   486386 422770                     53 371 0 26452 9637 26452   4.0 -1.0 94eb463abafa76a5dd80f2e373b0cfab3ae438f6 0 0 0 0 0  
14726 14726 20200612 WI 24795 2549 377362 172 totalTestEncountersViral 481690 287 3003 104 670     15783 6/12/2020 16:00 2020-06-12T16:00:00Z 06/12 12:00 689 3003   2020-06-12T16:00:00Z       22246 689   481690 399608                     55 354 11308 402329 12959 402157   7.0 27.0 8ba28897f98ebc42ee4f8ca1f0e0512f42468b61 0 0 0 0 0  
14727 14727 20200612 WV 2233 76 121806   posNeg 124039 29   9   2   1553 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 2919 124039   1.0 0.0 9e755bbaad9c48b65b7fec8f86c73dc549eae83f 0 0 0 0 0  
14728 14728 20200612 WY 1027 216 30873   totalTestsViral 34650 5 92         814 6/12/2020 18:00 2020-06-12T18:00:00Z 06/12 14:00 18 92   2020-06-12T18:00:00Z 34650 1026 33624 811                             56 18 264 31900 696 31900   0.0 0.0 dcf623e7f4bd11000dbf7d3a806fd609dc095faf 0 0 0 0 0  
14735 14735 20200611 CO 28647 2607 205723   totalTestEncountersViral 272930 279 5057           6/12/2020 00:00 2020-06-12T00:00:00Z 06/11 20:00 1583 5057 4169 2020-06-12T00:00:00Z       26040 1258 325 272930 231763 83345 5799 77546               8 148 3877 234370 5401 234370   10.0 22.0 7dd57b78e37ae88fa08b2c9684e837934178a745 0 0 0 0 0  
14764 14764 20200611 NM 9367   241513   posNeg 250880 183 1625         3380 6/12/2020 17:30 2020-06-12T17:30:00Z 06/12 13:30 420 1625   2020-06-12T17:30:00Z 250880                                   35 117 5206 250880 5323 250880   10.0 42.0 2efc9e04c79561df7f0b52706fa8c4c323838018 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,
   [probableCases] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [totalTestResultsSource] TEXT,
   [totalTestResults] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [recovered] INTEGER,
   [lastUpdateEt] TEXT,
   [dateModified] TEXT,
   [checkTimeEt] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [hospitalizedDischarged] INTEGER,
   [dateChecked] TEXT,
   [totalTestsViral] INTEGER,
   [positiveTestsViral] INTEGER,
   [negativeTestsViral] INTEGER,
   [positiveCasesViral] INTEGER,
   [deathConfirmed] INTEGER,
   [deathProbable] INTEGER,
   [totalTestEncountersViral] INTEGER,
   [totalTestsPeopleViral] INTEGER,
   [totalTestsAntibody] INTEGER,
   [positiveTestsAntibody] INTEGER,
   [negativeTestsAntibody] INTEGER,
   [totalTestsPeopleAntibody] INTEGER,
   [positiveTestsPeopleAntibody] INTEGER,
   [negativeTestsPeopleAntibody] INTEGER,
   [totalTestsPeopleAntigen] INTEGER,
   [positiveTestsPeopleAntigen] INTEGER,
   [totalTestsAntigen] INTEGER,
   [positiveTestsAntigen] INTEGER,
   [fips] INTEGER,
   [positiveIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [total] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [posNeg] INTEGER,
   [dataQualityGrade] TEXT,
   [deathIncrease] FLOAT,
   [hospitalizedIncrease] FLOAT,
   [hash] TEXT,
   [commercialScore] INTEGER,
   [negativeRegularScore] INTEGER,
   [negativeScore] INTEGER,
   [positiveScore] INTEGER,
   [score] INTEGER,
   [grade] TEXT
);