states_daily_4pm_et

Table actions

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

620 rows where totalTestResultsSource = "totalTestEncountersViral"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, pending, dataQualityGrade, deathProbable, fips, dateModified (date), dateChecked (date)

totalTestResultsSource ✖

  • totalTestEncountersViral · 620 ✖
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
7 7 20200926 CO 67926 804806   1277613 248 7479         6404 A 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 1940 7479 2020-09-25T01:59:00Z       63137     1277613 867943 166415 11592 154823               8 709 9218 872732 totalTestEncountersViral 16752 872732 5 25 e66aa724278acdbfea40842a634bf1ac4a32fa77 0 0 0 0 0  
32 32 20200926 ND 20380 215849   594628 104 809 22 201     16481 B 9/26/2020 01:59 2020-09-26T01:59:00Z 09/25 21:59 156 809 2020-09-26T01:59:00Z 616642     20380 153 3 594628 236229 9344 421 8923               38 495 1100 236229 totalTestEncountersViral 7064 236229 0 20 774fda32838bbbdd408f7f2df9a95d38e10e2829 0 0 0 0 0  
44 44 20200926 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 0 0 330034 totalTestEncountersViral 0 330034 0 0 e5a147d241db0ad3830218c1038dc29b79d42bcc 0 0 0 0 0  
63 63 20200925 CO 67217 795588   1260861 258 7454         6384 A 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 1935 7454 2020-09-24T01:59:00Z       62520     1260861 858108 165873 11561 154312               8 548 8665 862805 totalTestEncountersViral 15116 862805 9 10 45e4c07f8e584b5c055940eaa9c96cd814f2e4e5 0 0 0 0 0  
88 88 20200925 ND 19885 214749   587564 89 789 25 200     16104 B 9/25/2020 01:59 2020-09-25T01:59:00Z 09/24 21:59 156 789 2020-09-25T01:59:00Z 609021     19885 153 3 587564 234634 9312 417 8895               38 434 1087 234634 totalTestEncountersViral 5460 234634 0 12 ddc992d655f3c417d4d3a1f72d70d66ad80f4ec5 0 0 0 0 0  
100 100 20200925 RI 24181 305853   727469 94 2725 8   4   2278 A+ 9/25/2020 12:00 2020-09-25T12:00:00Z 09/25 08:00 1107 2725 2020-09-25T12:00:00Z   34299 693170 24181     727469 330034                     44 -130 2581 330034 totalTestEncountersViral 10422 330034 1 0 93a877812623e1750b2c506f59e53ecfc693fb8e 0 0 0 0 0  
119 119 20200924 CO 66669 786923   1245745 259 7444         6351 A 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 1926 7444 2020-09-23T01:59:00Z       61983     1245745 848906 165290 11524 153766               8 616 7865 853592 totalTestEncountersViral 13457 853592 0 28 b3f97a8d2eb9b057bcdbf2c7e5d2735bfae768b0 0 0 0 0 0  
144 144 20200924 ND 19451 213662   582104 89 777 26 194     15757 B 9/24/2020 01:59 2020-09-24T01:59:00Z 09/23 21:59 156 777 2020-09-24T01:59:00Z 603207     19451 153 3 582104 233113 9259 412 8847               38 470 791 233113 totalTestEncountersViral 6625 233113 0 14 6fbb7a9c0e426dd94de8a322f661e93048ddb9e0 0 0 0 0 0  
156 156 20200924 RI 24311 303272   717047 94 2725 8   4   2278 A+ 9/24/2020 12:00 2020-09-24T12:00:00Z 09/24 08:00 1106 2725 2020-09-24T12:00:00Z   34111 682936 24311     717047 327583                     44 134 2329 327583 totalTestEncountersViral 10469 327583 4 12 8163bebdcf0bf1d5914944de06cb338a5392078e 0 0 0 0 0  
175 175 20200923 CO 66053 779058   1232288 230 7416         6332 A 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 1926 7416 2020-09-22T01:59:00Z       61394     1232288 840452 167110 11645 155465               8 654 5573 845111 totalTestEncountersViral 13151 845111 12 43 c71007212dbe9c1847499f752ccfb5aeae0193fd 0 0 0 0 0  
200 200 20200923 ND 18981 212871   575479 89 763 25 192     15476 B 9/23/2020 01:59 2020-09-23T01:59:00Z 09/22 21:59 156 763 2020-09-23T01:59:00Z 596181     18981 153 3 575479 231852 9259 412 8847               38 473 1309 231852 totalTestEncountersViral 6939 231852 0 11 0408d7c5efa7b614f87f1c92524aca20f1dc2f81 0 0 0 0 0  
212 212 20200923 RI 24177 300943   706578 86 2713 9   5   2275 A+ 9/23/2020 12:00 2020-09-23T12:00:00Z 09/23 08:00 1102 2713 2020-09-23T12:00:00Z   33952 672626 24177     706578 325120                     44 133 2596 325120 totalTestEncountersViral 9770 325120 3 9 619de2d19bf56b44041c7b6d6fbed07b54816f4c 0 0 0 0 0  
231 231 20200922 CO 65399 773485   1219137 239 7373         6306 A 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 1914 7373 2020-09-21T01:59:00Z       60792     1219137 834277 166809 11624 155187               8 542 5633 838884 totalTestEncountersViral 10712 838884 1 10 acbe7e6b873d2efee74c91deb30171e27b8cb2ff 0 0 0 0 0  
256 256 20200922 ND 18508 211562   568540 92 752 26 192     15220 B 9/22/2020 01:59 2020-09-22T01:59:00Z 09/21 21:59 156 752 2020-09-22T01:59:00Z 588751     18508 153 3 568540 230070 9240 407 8833               38 264 295 230070 totalTestEncountersViral 2697 230070 5 22 3a3b0330f7731f0d57f1b38bebdc780c85a7c225 0 0 0 0 0  
268 268 20200922 RI 24044 298347   696808 82 2704 10   7   2272 A+ 9/22/2020 12:00 2020-09-22T12:00:00Z 09/22 08:00 1099 2704 2020-09-22T12:00:00Z   33791 663017 24044     696808 322391                     44 112 1713 322391 totalTestEncountersViral 6527 322391 2 11 76d8f25c0656b7455fece1ef2e92a773d79df2bf 0 0 0 0 0  
287 287 20200921 CO 64857 767852   1208425 239 7363         6291 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7363 2020-09-20T01:59:00Z       60256     1208425 828108 166546 11600 154948               8 501 6506 832709 totalTestEncountersViral 13046 832709 0 6 dfa726f7daf8d6b4a08ccf6210e93e7c20ea0fd4 0 0 0 0 0  
312 312 20200921 ND 18244 211267   565843 87 730 23 186     14841 B 9/21/2020 01:59 2020-09-21T01:59:00Z 09/20 21:59 151 730 2020-09-21T01:59:00Z 585970     18244 148 3 565843 229511 9203 403 8800               38 286 970 229511 totalTestEncountersViral 3244 229511 9 7 40d3f73e2c05a8dbaf7e6ad2dbc6854ffec40aea 0 0 0 0 0  
324 324 20200921 RI 23932 296634   690281 78 2693 10   4   2268 A+ 9/21/2020 12:00 2020-09-21T12:00:00Z 09/21 08:00 1097 2693 2020-09-21T12:00:00Z   33671 656610 23932     690281 320566                     44 52 711 320566 totalTestEncountersViral 2136 320566 3 0 def3a930acdb8fc111f370444a89b38d5622c0f4 0 0 0 0 0  
343 343 20200920 CO 64356 761346   1195379 237 7357         6274 A 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 1913 7357 2020-09-20T01:59:00Z       59782     1195379 821128 166196 11568 154630               8 606 7227 825702 totalTestEncountersViral 13550 825702 0 10 53538ff2d6fb07c9a2a5be3d98b592c35770bf7b 0 0 0 0 0  
368 368 20200920 ND 17958 210297   562599 81 723 22 185     14558 B 9/20/2020 01:59 2020-09-20T01:59:00Z 09/19 21:59 142 723 2020-09-20T01:59:00Z 582629     17958 139 3 562599 228255 9164 400 8764               38 351 1402 228255 totalTestEncountersViral 5737 228255 0 7 fd547903281d387d9445dbc1233b2224e93e3635 0 0 0 0 0  
380 380 20200920 RI 23880 295923   688145 78 2693 10   4   2268 A+ 9/20/2020 12:00 2020-09-20T12:00:00Z 09/20 08:00 1094 2693 2020-09-20T12:00:00Z   33607 654538 23880     688145 319803                     44 82 1705 319803 totalTestEncountersViral 8291 319803 3 6 8e8f514b90a2bd4fa3516895e981d9934b1b24f4 0 0 0 0 0  
399 399 20200919 CO 63750 754119   1181829 230 7347         6254 A 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 1913 7347 2020-09-19T01:59:00Z       59236     1181829 813355 165511 11507 154006               8 605 8023 817869 totalTestEncountersViral 14919 817869 2 20 0af822cd69de7384f1b02c950ec6ffc747fc3ef2 0 0 0 0 0  
424 424 20200919 ND 17607 208895   556862 78 716 22 184     14319 B 9/19/2020 01:59 2020-09-19T01:59:00Z 09/18 21:59 142 716 2020-09-19T01:59:00Z 576672     17607 139 3 556862 226502 9164 400 8764               38 377 932 226502 totalTestEncountersViral 6538 226502 0 11 e862b6b6bedaa268a3f38b22cf09b9276279a79d 0 0 0 0 0  
436 436 20200919 RI 23798 294218   679854 75 2687 11   4   2265 A+ 9/19/2020 12:00 2020-09-19T12:00:00Z 09/19 08:00 1091 2687 2020-09-19T12:00:00Z   33449 646405 23798     679854 318016                     44 178 2283 318016 totalTestEncountersViral 4746 318016 3 12 4101d54926dac1ed412a31032bdaba1d7e0b7a07 0 0 0 0 0  
455 455 20200918 CO 63145 746096   1166910 213 7327         6241 A 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 1911 7327 2020-09-18T01:59:00Z       58671     1166910 804767 164905 11458 153449               8 459 6860 809241 totalTestEncountersViral 13057 809241 6 39 fd250a6a61df3496a50c9cf3a212276715207ee8 0 0 0 0 0  
480 480 20200918 ND 17230 207963   550324 77 705 24 183     14060 B 9/18/2020 01:59 2020-09-18T01:59:00Z 09/17 21:59 142 705 2020-09-18T01:59:00Z 569913     17230 139 3 550324 225193 9164 400 8764               38 507 1516 225193 totalTestEncountersViral 9699 225193 0 14 056173ae37279c33d1df14cf27638b88e7958a5c 0 0 0 0 0  
492 492 20200918 RI 23620 291935   675108 85 2675 7   6   2244 A+ 9/18/2020 12:00 2020-09-18T12:00:00Z 09/18 08:00 1088 2675 2020-09-18T12:00:00Z   33476 641632 23620     675108 315555                     44 132 2148 315555 totalTestEncountersViral 9182 315555 3 7 2e04f70b4bd1bf95101aa91d68088fcd610c2fbf 0 0 0 0 0  
511 511 20200917 CO 62686 739236   1153853 248 7288         6220 A 9/17/2020 01:59 2020-09-17T01:59:00Z 09/16 21:59 1905 7288 2020-09-17T01:59:00Z       58257     1153853 797493 164320 11393 152929               8 587 5602 801922 totalTestEncountersViral 9912 801922 0 26 6b8e92972209044359cb116a1ac8170e282d2b18 0 0 0 0 0  
536 536 20200917 ND 16723 206447   540625 69 691 24 181     13828 B 9/17/2020 01:59 2020-09-17T01:59:00Z 09/16 21:59 142 691 2020-09-17T01:59:00Z 559923     16723 139 3 540625 223170 9028 377 8651               38 390 723 223170 totalTestEncountersViral 6402 223170 1 17 5a99f68c0c04ea06c4e33e49cf1e797638805c42 0 0 0 0 0  
548 548 20200917 RI 23488 289787   665926 88 2668 9   5   2236 A+ 9/17/2020 12:00 2020-09-17T12:00:00Z 09/17 08:00 1085 2668 2020-09-17T12:00:00Z   33335 632591 23488     665926 313275                     44 130 1801 313275 totalTestEncountersViral 11823 313275 4 6 6edcd8e621d87844da053c780c17bee240f69d5a 0 0 0 0 0  
567 567 20200916 CO 62099 733634   1143941 273 7262         6197 A 9/16/2020 01:59 2020-09-16T01:59:00Z 09/15 21:59 1905 7262 2020-09-16T01:59:00Z       57805     1143941 791439 164320 11370 152511               8 400 4576 795733 totalTestEncountersViral 9275 795733 11 22 73ea872034ce9e500415c070d5ece178ff8df974 0 0 0 0 0  
592 592 20200916 ND 16333 205724   534223 62 674 20 176     13628 B 9/16/2020 01:59 2020-09-16T01:59:00Z 09/15 21:59 141 674 2020-09-16T01:59:00Z 553163     16333 138 3 534223 222057 9028 377 8651               38 269 1143 222057 totalTestEncountersViral 5021 222057 6 17 e49f5c691d83f47d1c03cf2570e2d3225e301172 0 0 0 0 0  
604 604 20200916 RI 23358 287986   654103 84 2662 9   5   2235 A+ 9/16/2020 12:00 2020-09-16T12:00:00Z 09/16 08:00 1081 2662 2020-09-16T12:00:00Z   33159 620944 23358     654103 311344                     44 108 1195 311344 totalTestEncountersViral 11536 311344 3 12 9f1aba50e392b1d4df7b5803f585a1ce1d6d74a0 0 0 0 0 0  
623 623 20200915 CO 61699 729058   1134666 239 7240         6184 A+ 9/14/2020 01:59 2020-09-14T01:59:00Z 09/13 21:59 1894 7240 2020-09-14T01:59:00Z       57453     1134666 786511 163615 11348 152267               8 375 5852 790757 totalTestEncountersViral 10485 790757 5 13 7da76a090abc85ced2dfeb97a3b10534fc2407f9 0 0 0 0 0  
648 648 20200915 ND 16064 204581   529202 62 657 18 171     13328 A 9/15/2020 01:59 2020-09-15T01:59:00Z 09/14 21:59 135 657 2020-09-15T01:59:00Z 547945     16064 132 3 529202 220645 9028 377 8651               38 233 182 220645 totalTestEncountersViral 1667 220645 1 11 66a8365d1f79a36bdedd499c7727565fa352d3ea 0 0 0 0 0  
660 660 20200915 RI 23250 286791   642567 81 2650 9   5   2228 A+ 9/15/2020 12:00 2020-09-15T12:00:00Z 09/15 08:00 1078 2650 2020-09-15T12:00:00Z   32820 609747 23250     642567 310041                     44 120 1724 310041 totalTestEncountersViral 6849 310041 3 6 b31588951f9fa7715fc866acbeffd6220ad178a3 0 0 0 0 0  
679 679 20200914 CO 61324 723206   1124181 228 7227         6162 A+ 9/13/2020 01:59 2020-09-13T01:59:00Z 09/12 21:59 1889 7227 2020-09-13T01:59:00Z       57099     1124181 780305 163290 11326 151964               8 417 6625 784530 totalTestEncountersViral 12609 784530 0 4 5499f96fe8290a616f0bee7910a002eb68554cad 0 0 0 0 0  
704 704 20200914 ND 15831 204399   527535 65 646 19 171     12903 A 9/14/2020 01:59 2020-09-14T01:59:00Z 09/13 21:59 134 646 2020-09-14T01:59:00Z 546127     15831 131 3 527535 220230 9028 377 8651               38 254 1370 220230 totalTestEncountersViral 3965 220230 1 3 3f515a5c7d0ae3347c4e6765c38962de0fbcea5e 0 0 0 0 0  
716 716 20200914 RI 23130 285067   635718 80 2644 7   4   2223 A+ 9/14/2020 12:00 2020-09-14T12:00:00Z 09/14 08:00 1075 2644 2020-09-14T12:00:00Z   32706 603012 23130     635718 308197                     44 32 682 308197 totalTestEncountersViral 2208 308197 0 0 45832018f86b51472bf29fc8c479bd54d0313a90 0 0 0 0 0  
735 735 20200913 CO 60907 716581   1111572 226 7223         6156 A+ 9/12/2020 01:59 2020-09-12T01:59:00Z 09/11 21:59 1889 7223 2020-09-12T01:59:00Z       56704     1111572 773285 162866 11300 151566               8 415 6846 777488 totalTestEncountersViral 13587 777488 0 15 b059e74ebeecefcacbb29497a60fcb11079934d2 0 0 0 0 0  
760 760 20200913 ND 15577 203029   523570 62 643 18 170     12655 A 9/13/2020 01:59 2020-09-13T01:59:00Z 09/12 21:59 133 643 2020-09-13T01:59:00Z 541850     15577 130 3 523570 218606 9026 376 8650               38 426 1599 218606 totalTestEncountersViral 8150 218606 0 9 898aab4e2a87025ae4dc62ee59f5e9f41b18f4d9 0 0 0 0 0  
772 772 20200913 RI 23098 284385   633510 80 2644 7   4   2223 A+ 9/12/2020 12:00 2020-09-12T12:00:00Z 09/12 08:00 1075 2644 2020-09-12T12:00:00Z   32660 600850 23098     633510 307483                     44 99 1248 307483 totalTestEncountersViral 5419 307483 3 5 b2e6f5ca449fc94a507f711db332bed27274c520 0 0 0 0 0  
791 791 20200912 CO 60492 709735   1097985 232 7208         6139 A+ 9/11/2020 01:59 2020-09-11T01:59:00Z 09/10 21:59 1889 7208 2020-09-11T01:59:00Z       56378     1097985 766113 162325 11252 151073               8 307 5238 770227 totalTestEncountersViral 10786 770227 0 22 0d3f7ad5f13df8e0bc26f4346262fcb370d5ff97 0 0 0 0 0  
816 816 20200912 ND 15151 201430   515420 56 634 18 169     12450 A 9/12/2020 01:59 2020-09-12T01:59:00Z 09/11 21:59 133 634 2020-09-12T01:59:00Z 533340     15151 130 3 515420 216581 9020 373 8647               38 467 1038 216581 totalTestEncountersViral 9022 216581 0 4 2e33699e76ebc44a3a5a683c36d8b31831694c14 0 0 0 0 0  
828 828 20200912 RI 22999 283137   628091 80 2639 8   4   2220 A+ 9/11/2020 12:00 2020-09-11T12:00:00Z 09/11 08:00 1072 2639 2020-09-11T12:00:00Z   32558 595533 22999     628091 306136                     44 94 3019 306136 totalTestEncountersViral 12408 306136 1 19 f6a4985fde4dc3ee5a091b4f1554b0a2c2d32fe3 0 0 0 0 0  
847 847 20200911 CO 60185 704497   1087199 240 7186         6117 A+ 9/10/2020 01:59 2020-09-10T01:59:00Z 09/09 21:59 1889 7186 2020-09-10T01:59:00Z       56113     1087199 760610 161906 11227 150679               8 265 4065 764682 totalTestEncountersViral 7923 764682 7 13 396067acae54a54c6893cec7bfe842d1ed3ea07c 0 0 0 0 0  
872 872 20200911 ND 14684 200392   506398 64 630 22 169     12177 A 9/11/2020 01:59 2020-09-11T01:59:00Z 09/10 21:59 133 630 2020-09-11T01:59:00Z 523783     14684 130 3 506398 215076 8978 367 8611               38 241 543 215076 totalTestEncountersViral 5474 215076 2 6 0344ebabd4a8a047d2490c0482be43e5070ea275 0 0 0 0 0  
884 884 20200911 RI 22905 280118   615683 80 2620 8   3   2201 A+ 9/11/2020 12:00 2020-09-11T12:00:00Z 09/11 08:00 1071 2620 2020-09-11T12:00:00Z   32589 583094 22905     615683 303023                     44 123 1587 303023 totalTestEncountersViral 8777 303023 4 9 aedf60c2b75751dc16bb3653b109986e87862d0f 0 0 0 0 0  
903 903 20200910 CO 59920 700432   1079276 226 7173         6102 A+ 9/9/2020 01:59 2020-09-09T01:59:00Z 09/08 21:59 1882 7173 2020-09-09T01:59:00Z       55866     1079276 756298 161518 11199 150319               8 246 2865 760352 totalTestEncountersViral 5297 760352 14 12 5cce55e0b07d6df64767f09d2db224ec60381a08 0 0 0 0 0  
928 928 20200910 ND 14443 199849   500924 62 624 21 165     11930 A 9/10/2020 01:59 2020-09-10T01:59:00Z 09/09 21:59 131 624 2020-09-10T01:59:00Z 518090     14443 128 3 500924 214292 8978 367 8611               38 333 1000 214292 totalTestEncountersViral 6155 214292 2 13 f51c85d7469f2df20ded0d86c0d488b52a873563 0 0 0 0 0  
940 940 20200910 RI 22782 278531   606906 76 2611 5   3   2197 A+ 9/10/2020 12:00 2020-09-10T12:00:00Z 09/10 08:00 1067 2611 2020-09-10T12:00:00Z   32425 574481 22782     606906 301313                     44 106 2193 301313 totalTestEncountersViral 8589 301313 5 7 68cfb13af17365befe7ef59ff7a3c22c6121bbb6 0 0 0 0 0  
959 959 20200909 CO 59674 697567   1073979 218 7161         6093 A+ 9/8/2020 01:59 2020-09-08T01:59:00Z 09/07 21:59 1868 7161 2020-09-08T01:59:00Z       55642     1073979 753209 161277 11175 150102               8 187 2735 757241 totalTestEncountersViral 4373 757241 2 19 9ecaa14d2ece53476a945df46c576c71cf2407d5 0 0 0 0 0  
984 984 20200909 ND 14110 198849   494769 53 611 18 163     11733 A 9/9/2020 01:59 2020-09-09T01:59:00Z 09/08 21:59 129 611 2020-09-09T01:59:00Z 511730     14110 125 4 494769 212959 8918 359 8559               38 238 592 212959 totalTestEncountersViral 3027 212959 0 7 87e22cccd47c1e0fe197fa2fc7f62e79fb017e66 0 0 0 0 0  
996 996 20200909 RI 22676 276338   598317 82 2604 4   3   2185 A+ 9/9/2020 12:00 2020-09-09T12:00:00Z 09/09 08:00 1062 2604 2020-09-09T12:00:00Z   32303 566014 22676     598317 299014                     44 84 7491 299014 totalTestEncountersViral 15705 299014 3 15 d03650d29bb995121e6330844ef8983f83e34645 0 0 0 0 0  
1015 1015 20200908 CO 59487 694832   1069606 237 7142         6074 A+ 9/7/2020 01:59 2020-09-07T01:59:00Z 09/06 21:59 1866 7142 2020-09-07T01:59:00Z       55458     1069606 750290 161106 11166 149940               8 213 5645 754319 totalTestEncountersViral 10049 754319 0 4 bbac2ed4ed6333586a7766ee91cdb89afdf94238 0 0 0 0 0  
1040 1040 20200908 ND 13872 198257   491742 63 604 19 162     11452 A 9/8/2020 01:59 2020-09-08T01:59:00Z 09/07 21:59 129 604 2020-09-08T01:59:00Z 508555     13872 125 4 491742 212129 8918 359 8559               38 75 160 212129 totalTestEncountersViral 1374 212129 4 2 33c36dfa756c431f747ada2988a307b5547c92c1 0 0 0 0 0  
1052 1052 20200908 RI 22592 268847   582612 73 2589 5   3   2179 A+ 9/8/2020 12:00 2020-09-08T12:00:00Z 09/08 08:00 1059 2589 2020-09-08T12:00:00Z   31815 550797 22592     582612 291439                     44 20 390 291439 totalTestEncountersViral 1438 291439 0 0 30338d29fcbaf33107fea441c454061895bb32b9 0 0 0 0 0  
1071 1071 20200907 CO 59274 689187   1059557 227 7138         6057 A+ 9/6/2020 01:59 2020-09-06T01:59:00Z 09/05 21:59 1866 7138 2020-09-06T01:59:00Z       55256     1059557 744443 160811 11137 149674               8 285 5604 748461 totalTestEncountersViral 8473 748461 0 4 0e71fc2fafad295f71847f29f90e9583e50084ee 0 0 0 0 0  
1096 1096 20200907 ND 13797 198097   490368 68 602 19 162     11080 A 9/7/2020 01:59 2020-09-07T01:59:00Z 09/06 21:59 125 602 2020-09-07T01:59:00Z 507124     13797 121 4 490368 211675 8913 359 8554               38 171 729 211894 totalTestEncountersViral 2082 211894 0 4 ce9ca502ccf21f87a27369cfe79ad6a0299e95a6 0 0 0 0 0  
1108 1108 20200907 RI 22572 268457   581174 73 2589 5   3   2179 A+ 9/7/2020 12:00 2020-09-07T12:00:00Z 09/07 08:00 1059 2589 2020-09-07T12:00:00Z   31786 549388 22572     581174 291029                     44 53 1768 291029 totalTestEncountersViral 4011 291029 1 2 9dea148f544fc3e649b6afa4189bd482fdb2bbbd 0 0 0 0 0  
1127 1127 20200906 CO 58989 683583   1051084 220 7134         6049 A+ 9/5/2020 01:59 2020-09-05T01:59:00Z 09/04 21:59 1866 7134 2020-09-05T01:59:00Z       54980     1051084 738563 160346 11117 149229               8 334 6270 742572 totalTestEncountersViral 10332 742572 0 9 b38bd0ef1a7ede384c16884e14fe545f0310b1e7 0 0 0 0 0  
1152 1152 20200906 ND 13626 197368   488286 64 598 18 161     10821 A 9/6/2020 01:59 2020-09-06T01:59:00Z 09/05 21:59 125 598 2020-09-06T01:59:00Z 504785     13626 121 4 488286 210757 8913 359 8554               38 299 1203 210994 totalTestEncountersViral 4462 210994 0 2 42866274213d3fb37b945ef5adc4b3cf667dd193 0 0 0 0 0  
1164 1164 20200906 RI 22519 266689   577163 79 2587 7   3   2172 A+ 9/7/2020 12:00 2020-09-07T12:00:00Z 09/07 08:00 1058 2587 2020-09-07T12:00:00Z   31715 545448 22519     577163 289208                     44 35 1486 289208 totalTestEncountersViral 6234 289208 0 6 a1b98aaa03b61f7cc2a1f02ebde03d0c66046a15 0 0 0 0 0  
1183 1183 20200905 CO 58655 677313   1040752 219 7125         6029 A+ 9/4/2020 01:59 2020-09-04T01:59:00Z 09/03 21:59 1866 7125 2020-09-04T01:59:00Z       54709     1040752 732022 159721 11076 148645               8 368 6585 735968 totalTestEncountersViral 10961 735968 5 21 588dc8b6fbc05c63e70b3484180873802cdc978a 0 0 0 0 0  
1208 1208 20200905 ND 13327 196165   483824 67 596 18 159     10640 A 9/5/2020 01:59 2020-09-05T01:59:00Z 09/04 21:59 125 596 2020-09-05T01:59:00Z 500132     13327 121 4 483824 209213 8904 359 8545               38 356 1382 209492 totalTestEncountersViral 7031 209492 0 6 e882c4a12159aa878495a41e858e005851a65ac9 0 0 0 0 0  
1220 1220 20200905 RI 22484 265203   570929 82 2581 9   4   2163 A+ 9/7/2020 12:00 2020-09-07T12:00:00Z 09/07 08:00 1058 2581 2020-09-07T12:00:00Z   31667 539262 22484     570929 287687                     44 241 3440 287687 totalTestEncountersViral 13407 287687 3 22 d2597a53b57974c5cb678575a3703c502fe4c887 0 0 0 0 0  
1239 1239 20200904 CO 58287 670728   1029791 211 7104         6011 A+ 9/3/2020 01:59 2020-09-03T01:59:00Z 09/02 21:59 1861 7104 2020-09-03T01:59:00Z       54367     1029791 725095 159091 11028 148063               8 268 5689 729015 totalTestEncountersViral 8294 729015 8 14 3c7a6f79b987998c0c56812e25dcfe8325d4b31e 0 0 0 0 0  
1264 1264 20200904 ND 12971 194783   476793 67 590 17 158     10310 A 9/4/2020 01:59 2020-09-04T01:59:00Z 09/03 21:59 125 590 2020-09-04T01:59:00Z 492798     12971 121 4 476793 207257 8872 355 8517               38 342 1513 207754 totalTestEncountersViral 6370 207754 1 7 19d62edae59dde50c9fc2e415e7469d386c06ec6 0 0 0 0 0  
1276 1276 20200904 RI 22243 261763   557522 76 2559 8   4   2147 A+ 9/4/2020 12:00 2020-09-04T12:00:00Z 09/04 08:00 1055 2559 2020-09-04T12:00:00Z   31547 525975 22243     557522 284006                     44 100 2273 284006 totalTestEncountersViral 9929 284006 0 19 9ec0ae438afd93c750b483d6d0b9aad53d7f504a 0 0 0 0 0  
1295 1295 20200903 CO 58019 665039   1021497 247 7090         5992 A+ 9/2/2020 01:59 2020-09-02T01:59:00Z 09/01 21:59 1853 7090 2020-09-02T01:59:00Z       54109     1021497 719148 158603 10998 147605               8 244 4416 723058 totalTestEncountersViral 6855 723058 0 37 52b8a19548e67f17b28f75f7f49e5c232047f7d4 0 0 0 0 0  
1320 1320 20200903 ND 12629 193270   470423 51 583 16 156     10051 A 9/3/2020 01:59 2020-09-03T01:59:00Z 09/02 21:59 124 583 2020-09-03T01:59:00Z 486081     12629 120 4 470423 205204 8678 348 8330               38 359 1440 205899 totalTestEncountersViral 6312 205899 2 8 26c102c9e6d135b80dfc6bab744ca4add509d731 0 0 0 0 0  
1332 1332 20200903 RI 22143 259490   547593 68 2540 7   4   2137 A+ 9/3/2020 12:00 2020-09-03T12:00:00Z 09/03 08:00 1055 2540 2020-09-03T12:00:00Z   31447 516146 22143     547593 281633                     44 65 2927 281633 totalTestEncountersViral 11454 281633 4 -2 dce08fcb375cf7df05f7638c3505ad5da516b6eb 0 0 0 0 0  
1351 1351 20200902 CO 57775 660623   1014642 236 7053         5979 A+ 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 1853 7053 2020-09-01T01:59:00Z       53878     1014642 714501 158224 10966 147258               8 351 3279 718398 totalTestEncountersViral 4672 718398 4 25 6390dedf19353347575ce408692f0fd3283149ef 0 0 0 0 0  
1376 1376 20200902 ND 12270 191830   464111 66 575 16 153     9834 A 9/2/2020 01:59 2020-09-02T01:59:00Z 09/01 21:59 122 575 2020-09-02T01:59:00Z 479537     12270 118 4 464111 203229 8655 342 8313               38 266 1412 204100 totalTestEncountersViral 5525 204100 0 11 9c29e4138e4a913fba50dab6ade095479a0f1836 0 0 0 0 0  
1388 1388 20200902 RI 22078 256563   536139 78 2542 8   4   2130 A+ 9/2/2020 12:00 2020-09-02T12:00:00Z 09/02 08:00 1051 2542 2020-09-02T12:00:00Z   31362 504777 22078     536139 278641                     44 76 2083 278641 totalTestEncountersViral 5651 278641 1 14 86690c037a2bbec735a17f674a9a93d7324edbe3 0 0 0 0 0  
1407 1407 20200901 CO 57424 657344   1009970 241 7028         5953 A+ 8/31/2020 01:59 2020-08-31T01:59:00Z 08/30 21:59 1849 7028 2020-08-31T01:59:00Z       53579     1009970 710923 157837 10932 146905               8 201 4671 714768 totalTestEncountersViral 7168 714768 6 18 68e2039ab7814f2f00c4b35ab27e33c1192ae35f 0 0 0 0 0  
1432 1432 20200901 ND 12004 190418   458586 62 564 15 152     9610 A 9/1/2020 01:59 2020-09-01T01:59:00Z 08/31 21:59 122 564 2020-09-01T01:59:00Z 473749     12004 118 4 458586 201357 8616 338 8278               38 194 473 202422 totalTestEncountersViral 2396 202422 4 10 8166581d2e21ed24982d9b4fa86bb4909488a82a 0 0 0 0 0  
1444 1444 20200901 RI 22002 254480   530488 81 2528 8   5   2113 A+ 9/1/2020 12:00 2020-09-01T12:00:00Z 09/01 08:00 1050 2528 2020-09-01T12:00:00Z   31281 499207 22002     530488 276482                     44 53 2532 276482 totalTestEncountersViral 6074 276482 2 9 214dfdf5c85fb708ca4a7f359d1b0687ebc32e61 0 0 0 0 0  
1463 1463 20200831 CO 57223 652673   1002802 240 7010         5946 A+ 8/30/2020 01:59 2020-08-30T01:59:00Z 08/29 21:59 1843 7010 2020-08-30T01:59:00Z       53394     1002802 706067 157500 10910 146590               8 182 4505 709896 totalTestEncountersViral 7851 709896 0 17 d5f4e4187ca54e33ac84d4f385407097c8226222 0 0 0 0 0  
1488 1488 20200831 ND 11810 189945   456190 68 554 17 149     9295 A 8/31/2020 01:59 2020-08-31T01:59:00Z 08/30 21:59 118 554 2020-08-31T01:59:00Z 471253     11810 114 4 456190 200456 8580 335 8245               38 114 1682 201755 totalTestEncountersViral 1781 201755 0 0 3e9dd47051a9fd30caa3f7c1d7da1f15f8d04d57 0 0 0 0 0  
1500 1500 20200831 RI 21949 251948   524414 77 2519 9   5   2108 A+ 8/31/2020 12:00 2020-08-31T12:00:00Z 08/31 08:00 1048 2519 2020-08-31T12:00:00Z   31198 493216 21949     524414 273897                     44 46 1835 273897 totalTestEncountersViral 3936 273897 1 0 d3c0ee9c6b03bd2064b6edff96f2d33869eb5422 0 0 0 0 0  
1519 1519 20200830 CO 57041 648168   994951 239 6993         5933 A+ 8/29/2020 01:59 2020-08-29T01:59:00Z 08/28 21:59 1843 6993 2020-08-29T01:59:00Z       53209     994951 701377 157120 10882 146238               8 268 5557 705209 totalTestEncountersViral 9329 705209 0 48 e5ac0280a617a0532af59c8d147ff863f73b6545 0 0 0 0 0  
1544 1544 20200830 ND 11696 188263   454409 68 554 17 147     9079 A 8/30/2020 01:59 2020-08-30T01:59:00Z 08/29 21:59 118 554 2020-08-30T01:59:00Z 469333     11696 114 4 454409 199722 8565 334 8231               38 221 0 199959 totalTestEncountersViral 3551 199959 0 3 2637a2b9c4374ef21d69689fc4dd41ca3674e99f 0 0 0 0 0  
1556 1556 20200830 RI 21903 250113   520478 77 2519 9   5   2108 A+ 8/30/2020 12:00 2020-08-30T12:00:00Z 08/30 08:00 1047 2519 2020-08-30T12:00:00Z   31135 489343 21903     520478 272016                     44 46 1759 272016 totalTestEncountersViral 5336 272016 0 5 baa95b8590e5a59f07eaf417ee4693c2d5ab9160 0 0 0 0 0  
1575 1575 20200829 CO 56773 642611   985622 225 6945         5921 A+ 8/28/2020 01:59 2020-08-28T01:59:00Z 08/27 21:59 1843 6945 2020-08-28T01:59:00Z       52958     985622 695569 156499 10834 145665               8 430 7643 699384 totalTestEncountersViral 12632 699384 8 17 77d202ba63f72195e772d3aa76037d4e12deaf0f 0 0 0 0 0  
1600 1600 20200829 ND 11475 188263   450858 65 551 17 147     9018 A 8/29/2020 01:59 2020-08-29T01:59:00Z 08/28 21:59 118 551 2020-08-29T01:59:00Z 465673     11475 114 4 450858 198321 8565 334 8231               38 373 1377 199738 totalTestEncountersViral 7678 199738 0 1 29fa22057a24243766fae96ff31ccf67313da7d7 0 0 0 0 0  
1612 1612 20200829 RI 21857 248354   515142 80 2514 8   6   2101 A+ 8/29/2020 12:00 2020-08-29T12:00:00Z 08/29 08:00 1047 2514 2020-08-29T12:00:00Z   31071 484071 21857     515142 270211                     44 174 3246 270211 totalTestEncountersViral 10238 270211 1 18 544ce1459b7dc92b330d2f946372043736edc495 0 0 0 0 0  
1631 1631 20200828 CO 56343 634968   972990 213 6928         5907 A 8/27/2020 01:59 2020-08-27T01:59:00Z 08/26 21:59 1835 6928 2020-08-27T01:59:00Z       52562     972990 687530 155517 10757 144760               8 350 4858 691311 totalTestEncountersViral 10236 691311 0 26 d42fbbb94da073687ca2fa8883121b1c73020c12 0 0 0 0 0  
1656 1656 20200828 ND 11102 186886   443180 70 550 17 144     8808 A 8/28/2020 01:59 2020-08-28T01:59:00Z 08/27 21:59 118 550 2020-08-28T01:59:00Z 457772     11102 114 4 443180 196389 8329 318 8011               38 312 1127 197988 totalTestEncountersViral 7514 197988 0 16 e546cb9dd2f28b0c6921dda59438e73214d7b5d5 0 0 0 0 0  
1668 1668 20200828 RI 21683 245108   504904 81 2496 8   4   2084 A+ 8/28/2020 12:00 2020-08-28T12:00:00Z 08/28 08:00 1046 2496 2020-08-28T12:00:00Z   30953 473951 21683     504904 266791                     44 94 3284 266791 totalTestEncountersViral 9329 266791 2 11 1fc4636a7555607a6f4903f01eb84eeb5fca41a1 0 0 0 0 0  
1687 1687 20200827 CO 55993 630110   962754 253 6902         5881 A 8/26/2020 01:59 2020-08-26T01:59:00Z 08/25 21:59 1835 6902 2020-08-26T01:59:00Z       52228     962754 682339 154903 10697 144206               8 193 3849 686103 totalTestEncountersViral 7113 686103 9 8 807f778fba9150d75a45305ea475a914c77d6444 0 0 0 0 0  
1712 1712 20200827 ND 10790 185759   435666 61 534 17 142     8666 A 8/27/2020 01:59 2020-08-27T01:59:00Z 08/26 21:59 118 534 2020-08-27T01:59:00Z 449894     10790 114 4 435666 194659 8329 318 8011               38 333 1108 196549 totalTestEncountersViral 6614 196549 1 9 fa3c00ecafc56f95f3d389dba984621feffa2115 0 0 0 0 0  
1724 1724 20200827 RI 21589 241824   495575 82 2485 10   3   2073 A+ 8/27/2020 12:00 2020-08-27T12:00:00Z 08/27 08:00 1044 2485 2020-08-27T12:00:00Z   30872 464703 21589     495575 263413                     44 135 3648 263413 totalTestEncountersViral 10549 263413 3 7 a3d5b290c2376ac1a3548233db268921b2aa3a1e 0 0 0 0 0  
1743 1743 20200826 CO 55800 626261   955641 243 6894         5867 A 8/25/2020 01:59 2020-08-25T01:59:00Z 08/24 21:59 1826 6894 2020-08-25T01:59:00Z       52074     955641 678335 154497 10671 143826               8 459 31404 682061 totalTestEncountersViral 7996 682061 2 49 baca648956c04f8b1c7003ba3d756f41afe24fd0 0 0 0 0 0  
1768 1768 20200826 ND 10457 184651   429052 53 525 17 142     8545 A 8/26/2020 01:59 2020-08-26T01:59:00Z 08/25 21:59 117 525 2020-08-26T01:59:00Z 442929     10457 113 4 429052 193100 8329 318 8011               38 234 1281 195108 totalTestEncountersViral 4260 195108 2 6 2b727e3ee2bda3e14928c90ecd8daa73d5fa0096 0 0 0 0 0  
1780 1780 20200826 RI 21454 238176   485026 80 2478 11   4   2069 A+ 8/26/2020 12:00 2020-08-26T12:00:00Z 08/26 08:00 1041 2478 2020-08-26T12:00:00Z   30697 454329 21454     485026 259630                     44 82 1759 259630 totalTestEncountersViral 5643 259630 2 4 65593bbd4b8f678ea3eaf4f7803ef8143840de40 0 0 0 0 0  
1799 1799 20200825 CO 55341 594857   947645 243 6845         5841 A 8/24/2020 01:59 2020-08-24T01:59:00Z 08/23 21:59 1824 6845 2020-08-24T01:59:00Z       51676     947645 673913 154075 10639 143436               8 198 0 650198 totalTestEncountersViral 9049 650198 9 4 c25d9a93e3b1b03b5e83b75d55ad152570db376c 0 0 0 0 0  
1824 1824 20200825 ND 10223 183370   424792 50 519 16 140     8410 B 8/25/2020 01:59 2020-08-25T01:59:00Z 08/24 21:59 115 519 2020-08-25T01:59:00Z 438486     10223 111 4 424792 191458 8290 314 7976               38 234 1352 193593 totalTestEncountersViral 3087 193593 3 14 faae89d775be3c1bcaac296cd2ecec3a3c6e6d79 0 0 0 0 0  
1836 1836 20200825 RI 21372 236417   479383 87 2474 11   2   2059 A+ 8/25/2020 12:00 2020-08-25T12:00:00Z 08/25 08:00 1039 2474 2020-08-25T12:00:00Z   30440 448943 21372     479383 257789                     44 70 3045 257789 totalTestEncountersViral 5713 257789 4 14 8d6c2f68bae079a01eb50eff81d2f548f8957229 0 0 0 0 0  
1855 1855 20200824 CO 55143 594857   938596 225 6841         5823 A 8/23/2020 01:59 2020-08-23T01:59:00Z 08/22 21:59 1815 6841 2020-08-23T01:59:00Z       51505     938596 668994 153659 10612 143047               8 260 0 650000 totalTestEncountersViral 8444 650000 0 10 2aa9117da60673fe8bd8fe2c706779f426a741fc 0 0 0 0 0  

Next page

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
);