states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
61 rows where "dateModified" is on date 2020-09-11 sorted by positiveTestsAntigen
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, dateChecked, positiveTestsViral, negativeTestsViral, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, dateChecked (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
747 | 747 | 20200913 | KS | 48386 | 400544 | 448930 | 140 | 2537 | 40 | 690 | 10 | 219 | 1859 | A+ | 9/11/2020 10:00 | 2020-09-11T10:00:00Z | 09/11 06:00 | 511 | 2537 | 2020-09-11T10:00:00Z | 448930 | 20 | 0 | 0 | 448930 | posNeg | 0 | 448930 | 0 | 0 | 5562750d6f8e4885550c4cbf5520fabab6edfefb | 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 | ||||||||||||||||||
793 | 793 | 20200912 | DC | 14552 | 312885 | 327437 | 98 | 24 | 12 | 11561 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 616 | 2020-09-11T00:00:00Z | 327437 | 194043 | 11 | 59 | 5942 | 327437 | posNeg | 6001 | 327437 | 0 | 0 | 90d76f789c7f39088d2fbfc6efe030a4e0a1e04d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
794 | 794 | 20200912 | DE | 18726 | 240859 | 259585 | 66 | 15 | 10063 | A+ | 9/11/2020 18:00 | 2020-09-11T18:00:00Z | 09/11 14:00 | 613 | 2020-09-11T18:00:00Z | 17734 | 541 | 72 | 259585 | 10 | 260 | 2627 | 259585 | posNeg | 2887 | 259585 | 0 | 0 | 6f34f6a51ad60ef179aaeb8d678da35a120494e9 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
795 | 795 | 20200912 | FL | 661571 | 4240109 | 3676 | 4901680 | 2683 | 41687 | A+ | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 12756 | 41687 | 2020-09-11T23:59:00Z | 6818027 | 851937 | 5926779 | 661571 | 12756 | 4908723 | 446669 | 34738 | 411877 | 437913 | 34017 | 403867 | 12579 | 12 | 3190 | 21734 | 4905356 | posNeg | 24924 | 4901680 | 98 | 193 | 188d0335691f616fdf912e127c0f9d4568a73973 | 0 | 0 | 0 | 0 | 0 | |||||||||||
798 | 798 | 20200912 | HI | 10459 | 239580 | 250039 | 220 | 622 | 51 | 41 | 3334 | C | 9/11/2020 18:00 | 2020-09-11T18:00:00Z | 09/11 14:00 | 96 | 622 | 2020-09-11T18:00:00Z | 334756 | 250039 | 15 | 167 | 3389 | 250039 | posNeg | 3556 | 250039 | 2 | 12 | 11703774c0e6eaa40ebaf08f66ff18d10ba22a5e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
800 | 800 | 20200912 | ID | 34950 | 240660 | 272888 | 165 | 1569 | 46 | 412 | 18052 | A+ | 9/11/2020 19:00 | 2020-09-11T19:00:00Z | 09/11 15:00 | 412 | 1569 | 2020-09-11T19:00:00Z | 272888 | 32228 | 375 | 37 | 16 | 333 | 1461 | 275610 | posNeg | 1746 | 275610 | 5 | 18 | d1819b1690fd76c18267755f390b6107decc4f3a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
802 | 802 | 20200912 | IN | 104561 | 1102419 | 1206980 | 807 | 11710 | 234 | 2327 | 70 | 81089 | A+ | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 3437 | 11710 | 2020-09-11T23:59:00Z | 1666889 | 3213 | 224 | 1206980 | 18 | 1056 | 22820 | 1206980 | posNeg | 23876 | 1206980 | 17 | 59 | dee45ad9fc39d28edcbbfea55a2668f905678d66 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
803 | 803 | 20200912 | KS | 48386 | 400544 | 448930 | 140 | 2537 | 40 | 690 | 10 | 219 | 1859 | A+ | 9/11/2020 10:00 | 2020-09-11T10:00:00Z | 09/11 06:00 | 511 | 2537 | 2020-09-11T10:00:00Z | 448930 | 20 | 0 | 0 | 448930 | posNeg | 0 | 448930 | 0 | 0 | 35d7ce6cf7bf9d30d0feb2960da36d3140ea08ae | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
805 | 805 | 20200912 | LA | 157109 | 1880644 | 2037753 | 723 | 117 | 140440 | A | 9/11/2020 13:00 | 2020-09-11T13:00:00Z | 09/11 09:00 | 5202 | 2020-09-11T13:00:00Z | 156174 | 5032 | 170 | 2036818 | 22 | 0 | 0 | 2037753 | posNeg | 0 | 2037753 | 0 | 0 | 3add26a8e3d061aad50f1595e2ed87b3bb0def9a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
808 | 808 | 20200912 | ME | 4834 | 320169 | 325003 | 10 | 431 | 6 | 4 | 4211 | A+ | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 135 | 431 | 2020-09-11T23:59:00Z | 324518 | 6048 | 318215 | 4349 | 134 | 1 | 9957 | 503 | 9440 | 23 | 42 | 4953 | 325003 | posNeg | 4995 | 325003 | 1 | -1 | 4daa684fbe00a12fbd7f0bb798ebf3da42ae2222 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
810 | 810 | 20200912 | MN | 83588 | 1138934 | 1684520 | 247 | 6899 | 140 | 1949 | 76650 | A+ | 9/11/2020 17:00 | 2020-09-11T17:00:00Z | 09/11 13:00 | 1958 | 6899 | 2020-09-11T17:00:00Z | 83588 | 1906 | 52 | 1684520 | 1222522 | 27 | 872 | 9090 | 1222522 | posNeg | 19192 | 1222522 | 9 | 36 | 3a24ccc1b088bd8994b92892e63a45b9104da69c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
813 | 813 | 20200912 | MS | 89620 | 532919 | 622539 | 542 | 5410 | 179 | 74098 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 2685 | 5410 | 2020-09-11T00:00:00Z | 617161 | 84242 | 2502 | 183 | 28693 | 95 | 38257 | 28 | 445 | 3715 | 622539 | posNeg | 4160 | 622539 | 15 | 0 | 1ab4ca1a6a3942a68d2467e04481f77e42c1a30f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
817 | 817 | 20200912 | NE | 37841 | 359513 | 397354 | 166 | 2131 | 28816 | A+ | 9/11/2020 20:30 | 2020-09-11T20:30:00Z | 09/11 16:30 | 434 | 2131 | 2020-09-11T20:30:00Z | 37841 | 397904 | 31 | 468 | 3074 | 397354 | posNeg | 3542 | 397354 | 4 | 12 | da1a439c90fbd20727e8beda684df95598679e08 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
818 | 818 | 20200912 | NH | 7652 | 221372 | 369691 | 6 | 721 | 228 | 6920 | B | 9/11/2020 09:00 | 2020-09-11T09:00:00Z | 09/11 05:00 | 435 | 721 | 2020-09-11T09:00:00Z | 369691 | 7652 | 229024 | 31079 | 30329 | 33 | 32 | 1701 | 229024 | posNeg | 4046 | 229024 | 1 | 1 | 4bc7077257fb9ee0df1ccd1520ec42e80275a94d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
820 | 820 | 20200912 | NM | 26563 | 785487 | 812050 | 73 | 3247 | 14276 | B | 9/11/2020 17:50 | 2020-09-11T17:50:00Z | 09/11 13:50 | 818 | 3247 | 2020-09-11T17:50:00Z | 812050 | 26563 | 35 | 134 | 4917 | 812050 | posNeg | 5051 | 812050 | 2 | 9 | be4a660ffa6e223a40df7be40f253894beec384b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
822 | 822 | 20200912 | NY | 443640 | 8801985 | 9245625 | 467 | 89995 | 127 | 51 | 75707 | A | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 25384 | 89995 | 2020-09-11T23:59:00Z | 443640 | 9245625 | 36 | 849 | 102076 | 9245625 | posNeg | 102925 | 9245625 | 2 | 0 | 0cf0f61afa5b762948ea7155234f87dd4687c02d | 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 | |||||||||||||||||
829 | 829 | 20200912 | SC | 129978 | 924894 | 1054872 | 806 | 8402 | 220 | 131 | 51431 | A+ | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 3040 | 8402 | 2020-09-11T23:59:00Z | 1052540 | 168092 | 884448 | 127646 | 2891 | 149 | 65834 | 5799 | 60035 | 45 | 932 | 9464 | 1054872 | posNeg | 10396 | 1054872 | 12 | 49 | 56d70a33cc067170e29258b1b5bfccc410169a3d | 0 | 0 | 0 | 0 | 0 | |||||||||||||
830 | 830 | 20200912 | SD | 16437 | 146172 | 162609 | 109 | 1152 | 13739 | A+ | 9/11/2020 14:00 | 2020-09-11T14:00:00Z | 09/11 10:00 | 183 | 1152 | 2020-09-11T14:00:00Z | 219227 | 162609 | 46 | 320 | 1326 | 162609 | posNeg | 1646 | 162609 | 6 | 14 | 8200d254cf41ddf718ee22d91a3c4361fbeca00b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
834 | 834 | 20200912 | VA | 132940 | 1617170 | 272 | 1744020 | 995 | 17271 | 228 | 113 | 16276 | A+ | 9/11/2020 17:00 | 2020-09-11T17:00:00Z | 09/11 13:00 | 2722 | 17271 | 2020-09-11T17:00:00Z | 151825 | 126850 | 2589 | 133 | 1744020 | 51 | 1300 | 14763 | 1750382 | posNeg | 15910 | 1750110 | 11 | 8 | c6bf7225f0e0be9b18a53606d9906f42b79133c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
836 | 836 | 20200912 | VT | 1677 | 147984 | 149661 | 4 | 1496 | B | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 58 | 2020-09-11T23:59:00Z | 1677 | 58 | 149661 | 50 | 9 | 1077 | 149661 | posNeg | 1086 | 149661 | 0 | 0 | 119a4a94705da4511a864a34bcd0fb6f9f620011 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
837 | 837 | 20200912 | WA | 79476 | 1551686 | 1631162 | 269 | 7048 | 19 | B | 9/11/2020 02:59 | 2020-09-11T02:59:00Z | 09/10 22:59 | 1991 | 7048 | 2020-09-11T02:59:00Z | 79476 | 1991 | 1631162 | 53 | 465 | 15949 | 1631162 | posNeg | 16414 | 1631162 | 0 | 30 | 04905c7bc2499c4a8103c5c98e96035d7713c9c5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
839 | 839 | 20200912 | WV | 12521 | 466355 | 478876 | 145 | 59 | 26 | 9225 | C | 9/11/2020 23:59 | 2020-09-11T23:59:00Z | 09/11 19:59 | 265 | 2020-09-11T23:59:00Z | 478580 | 12225 | 263 | 2 | 16292 | 54 | 347 | 6738 | 478876 | posNeg | 7085 | 478876 | 2 | 0 | 747d75121a393bb8299b0b523bad771b58160e59 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
841 | 841 | 20200911 | AK | 7024 | 387562 | 394586 | 44 | 7 | 2359 | A | 9/11/2020 03:59 | 2020-09-11T03:59:00Z | 09/10 23:59 | 43 | 2020-09-11T03:59:00Z | 394586 | 6340 | 387966 | 7024 | 43 | 2 | 109 | 1400 | 394586 | posNeg | 1509 | 394586 | 1 | 0 | 7362921fa69c20bc82d18bd257382ca0197025c1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
842 | 842 | 20200911 | AL | 136703 | 874219 | 998316 | 811 | 15527 | 1593 | 877 | 54223 | B | 9/11/2020 11:00 | 2020-09-11T11:00:00Z | 09/11 07:00 | 2333 | 15527 | 2020-09-11T11:00:00Z | 998316 | 124097 | 2204 | 129 | 55157 | 1 | 1138 | 4046 | 1010922 | posNeg | 4876 | 1010922 | 32 | 188 | 4f5d424289ac00a717c8a75de272cd53028db436 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
845 | 845 | 20200911 | AZ | 207523 | 1071901 | 1277543 | 577 | 21747 | 171 | 100 | 32472 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 5288 | 21747 | 2020-09-11T00:00:00Z | 205642 | 5014 | 274 | 1277543 | 275536 | 4 | 521 | 6169 | 1279424 | posNeg | 6670 | 1279424 | 15 | 136 | ec55d92b4868082a5b2968208cdd51fb1722fe32 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
846 | 846 | 20200911 | CA | 746191 | 11705469 | 12451660 | 4023 | 1172 | B | 9/11/2020 02:59 | 2020-09-11T02:59:00Z | 09/10 22:59 | 14089 | 2020-09-11T02:59:00Z | 12451660 | 746191 | 6 | 3326 | 58343 | 12451660 | posNeg | 61669 | 12451660 | 111 | 0 | 711a528c1e9e5ccd9a5bab8e18df6a3e1894e1fd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
852 | 852 | 20200911 | GA | 290781 | 2267538 | 2558319 | 2152 | 26163 | 4794 | A+ | 9/11/2020 14:50 | 2020-09-11T14:50:00Z | 09/11 10:50 | 6246 | 26163 | 2020-09-11T14:50:00Z | 2558319 | 265022 | 2293297 | 290781 | 287173 | 22769 | 13 | 1658 | 14067 | 2558319 | posNeg | 15725 | 2558319 | 42 | 101 | 34a23d011eb71609eac4844af598429ec0bc7096 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
853 | 853 | 20200911 | GU | 1863 | 41150 | 43013 | 52 | 13 | 1118 | A+ | 9/11/2020 03:15 | 2020-09-11T03:15:00Z | 09/10 23:15 | 23 | 2020-09-11T03:15:00Z | 43011 | 1863 | 43013 | 158 | 2 | 66 | 17 | 378 | 43013 | posNeg | 395 | 43013 | 2 | 0 | 28d8908cf66217d2f94fa983ecc93de9ea678af2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
855 | 855 | 20200911 | IA | 71133 | 602464 | 673597 | 281 | 83 | 36 | 52370 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 1211 | 2020-09-11T00:00:00Z | 71133 | 675126 | 52493 | 3177 | 49276 | 15171 | 1895 | 19 | 728 | 5000 | 673597 | posNeg | 5728 | 673597 | 4 | 0 | 6e5d14c0dafd035ceb3784622fc7ca8b4fb18f3f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
857 | 857 | 20200911 | IL | 259883 | 4374594 | 4634477 | 1619 | 359 | 155 | A | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 8505 | 2020-09-11T00:00:00Z | 4632382 | 257788 | 8273 | 232 | 17 | 2312 | 54516 | 4634477 | posNeg | 56828 | 4634477 | 44 | 0 | 96264885e3c4b77ab4a24d9d57cdc263cb016b9a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
859 | 859 | 20200911 | KS | 48386 | 400544 | 448930 | 140 | 2537 | 40 | 690 | 10 | 219 | 1859 | A+ | 9/11/2020 10:00 | 2020-09-11T10:00:00Z | 09/11 06:00 | 511 | 2537 | 2020-09-11T10:00:00Z | 448930 | 20 | 976 | 6540 | 448930 | posNeg | 7516 | 448930 | 16 | 67 | e463072e88b3bfdb16c9d73d71b7dcd753929943 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
860 | 860 | 20200911 | KY | 55704 | 844986 | 894965 | 549 | 4862 | 124 | 1443 | 10822 | B | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 1044 | 4862 | 2020-09-11T00:00:00Z | 894965 | 49979 | 1035 | 9 | 48463 | 17002 | 21 | 932 | 15267 | 900690 | posNeg | 16048 | 900690 | 9 | 27 | ef8249a670ea721ca92637b74d82d373dfbb296c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
861 | 861 | 20200911 | LA | 157109 | 1880644 | 2037753 | 723 | 117 | 140440 | A | 9/11/2020 13:00 | 2020-09-11T13:00:00Z | 09/11 09:00 | 5202 | 2020-09-11T13:00:00Z | 156174 | 5032 | 170 | 2036818 | 22 | 755 | 26479 | 2037753 | posNeg | 27234 | 2037753 | 41 | 0 | 190da0080fb36a8221b24e38be29019ab1aa8bdc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
862 | 862 | 20200911 | MA | 123986 | 1803416 | 2905353 | 330 | 12411 | 60 | 22 | 107501 | A+ | 9/11/2020 08:00 | 2020-09-11T08:00:00Z | 09/11 04:00 | 9180 | 12411 | 2020-09-11T08:00:00Z | 2905353 | 160811 | 122202 | 8971 | 209 | 1925618 | 115893 | 100148 | 25 | 440 | 18963 | 1927402 | totalTestsViral | 52803 | 1927402 | 14 | 10 | 07b61a4c16cec3f5c68d503f803965e569ef09b5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
863 | 863 | 20200911 | MD | 114724 | 1318152 | 1432876 | 369 | 14756 | 89 | 7186 | A+ | 9/11/2020 10:00 | 2020-09-11T10:00:00Z | 09/11 06:00 | 3828 | 14756 | 2020-09-11T10:00:00Z | 2150638 | 136897 | 114724 | 3685 | 143 | 1432876 | 24 | 646 | 8503 | 1432876 | posNeg | 9149 | 1432876 | 4 | 50 | 434b45a7d1d56097ffc2c4ef205fb01b68a32394 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
865 | 865 | 20200911 | MI | 122251 | 2950535 | 3072786 | 627 | 172 | 77 | 80678 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 6900 | 2020-09-11T00:00:00Z | 3106168 | 155633 | 2950535 | 110832 | 6578 | 322 | 267328 | 26 | 1405 | 34933 | 3072786 | posNeg | 36338 | 3072786 | 6 | 0 | c85cd0b7af30f1f41ae020b12b670768e0686817 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
867 | 867 | 20200911 | MO | 99160 | 997412 | 1096572 | 934 | 113 | A | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 1701 | 2020-09-11T00:00:00Z | 1437730 | 107727 | 1327482 | 99160 | 1096572 | 70812 | 3157 | 67655 | 29 | 1569 | 11079 | 1096572 | posNeg | 12648 | 1096572 | 10 | 0 | 4e22fbe33ddea3bd2f24c4cd0f1e6c04db56d733 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
870 | 870 | 20200911 | MT | 8785 | 265873 | 274658 | 142 | 518 | 6795 | B | 9/11/2020 01:59 | 2020-09-11T01:59:00Z | 09/10 21:59 | 131 | 518 | 2020-09-11T01:59:00Z | 274658 | 8785 | 30 | 122 | 1183 | 274658 | posNeg | 1305 | 274658 | 8 | 6 | c2751196e8a9a0499110a9bb696138535ffd75a4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
871 | 871 | 20200911 | NC | 182286 | 2376368 | 2558654 | 938 | 292 | 156652 | A+ | 9/11/2020 12:50 | 2020-09-11T12:50:00Z | 09/11 08:50 | 3023 | 2020-09-11T12:50:00Z | 2558654 | 182286 | 3023 | 37 | 1532 | 35283 | 2558654 | posNeg | 36815 | 2558654 | 33 | 0 | 55a80ab13fd22bbe495453d1204b9bbf630e1cac | 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 | |||||||||||||
874 | 874 | 20200911 | NH | 7620 | 219671 | 365645 | 7 | 720 | 228 | 6870 | B | 9/11/2020 09:00 | 2020-09-11T09:00:00Z | 09/11 05:00 | 434 | 720 | 2020-09-11T09:00:00Z | 365645 | 7620 | 227291 | 31004 | 30325 | 33 | 47 | 1585 | 227291 | posNeg | 3677 | 227291 | 0 | 1 | 5f603efaaca716e725a56f9715bcc3904c71cc04 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
875 | 875 | 20200911 | NJ | 195888 | 2944898 | 3140786 | 483 | 22918 | 81 | 36 | 34345 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 16024 | 22918 | 2020-09-11T00:00:00Z | 3140786 | 195888 | 14234 | 1790 | 34 | 474 | 26658 | 3140786 | posNeg | 27132 | 3140786 | 9 | 30 | a51e330aaf245911d7e147654e07aefc2734c8e4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
877 | 877 | 20200911 | NV | 72806 | 560476 | 633282 | 476 | 165 | 102 | 1930 | A+ | 9/11/2020 02:59 | 2020-09-11T02:59:00Z | 09/10 22:59 | 1439 | 2020-09-11T02:59:00Z | 922480 | 72806 | 632668 | 32 | 260 | 5703 | 633282 | posNeg | 5963 | 633282 | 10 | 0 | ebe95e00e6f3ae225ee25b8dd58753c2972c64c8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
879 | 879 | 20200911 | OH | 135326 | 2383887 | 2519213 | 650 | 14236 | 222 | 3081 | 131 | 113053 | A+ | 9/11/2020 14:00 | 2020-09-11T14:00:00Z | 09/11 10:00 | 4403 | 14236 | 2020-09-11T14:00:00Z | 2512184 | 128297 | 4110 | 293 | 39 | 1240 | 27622 | 2519213 | posNeg | 28862 | 2519213 | 49 | 72 | 41e9a0a1d5723a4053bc00b4c02c38c6ffde3379 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
880 | 880 | 20200911 | OK | 67642 | 907109 | 6696 | 974751 | 509 | 5369 | 208 | 57383 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 888 | 5369 | 2020-09-11T00:00:00Z | 987322 | 78255 | 907109 | 67642 | 73173 | 3453 | 40 | 942 | 12099 | 981447 | posNeg | 13041 | 974751 | 12 | 51 | 5c82a90b9cae9fd9718b3d1144292c1725c655e8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
881 | 881 | 20200911 | OR | 28865 | 576874 | 605739 | 161 | 2235 | 43 | 19 | 5310 | A+ | 9/11/2020 03:01 | 2020-09-11T03:01:00Z | 09/10 23:01 | 499 | 2235 | 2020-09-11T03:01:00Z | 576874 | 27460 | 604334 | 41 | 211 | 8540 | 605739 | posNeg | 8751 | 605739 | 2 | 13 | 960d73e1e15c62a34e563958e2d8b907c86007a7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
882 | 882 | 20200911 | PA | 142885 | 1652028 | 1794913 | 491 | 64 | 117165 | A+ | 9/11/2020 12:00 | 2020-09-11T12:00:00Z | 09/11 08:00 | 7837 | 2020-09-11T12:00:00Z | 2474523 | 138759 | 1790787 | 42 | 1008 | 12679 | 1794913 | posNeg | 13687 | 1794913 | 17 | 0 | d97bf7929b588c557f9aadb78a561691b4a61f7f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
883 | 883 | 20200911 | PR | 36581 | 305972 | 342553 | 401 | 68 | 52 | C | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 523 | 2020-09-11T00:00:00Z | 310546 | 7002 | 303412 | 17357 | 359 | 164 | 19224 | 72 | 302 | 0 | 342553 | posNeg | 302 | 342553 | 11 | 0 | 7ac233925abe87e974af7b03d23e1028daae47ac | 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 | |||||||||||||||||
887 | 887 | 20200911 | TN | 169859 | 2250520 | 2420379 | 965 | 7624 | 305 | 141 | 152674 | A+ | 9/11/2020 15:00 | 2020-09-11T15:00:00Z | 09/11 11:00 | 2025 | 7624 | 2020-09-11T15:00:00Z | 2415529 | 200561 | 2214968 | 165009 | 1957 | 68 | 47 | 1622 | 25717 | 2420379 | posNeg | 27339 | 2420379 | 37 | 75 | d229c70ebf99a74005fa5a2a474e7dc413a2b7e1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
891 | 891 | 20200911 | VI | 1201 | 16849 | 16 | 18050 | 1124 | C | 9/11/2020 06:29 | 2020-09-11T06:29:00Z | 09/11 02:29 | 18 | 2020-09-11T06:29:00Z | 18066 | 18 | 78 | 4 | 181 | 18066 | posNeg | 185 | 18050 | 0 | 0 | 051ea5e6a1fa414809a0ca43bf8d566e13315a5d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
893 | 893 | 20200911 | WA | 79011 | 1535737 | 1614748 | 269 | 7018 | 19 | B | 9/11/2020 02:59 | 2020-09-11T02:59:00Z | 09/10 22:59 | 1991 | 7018 | 2020-09-11T02:59:00Z | 79011 | 1991 | 1614748 | 53 | 544 | 16217 | 1614748 | posNeg | 16761 | 1614748 | 6 | 25 | ce88d99a428baca0fb30bceae336d84e2af1d1c6 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
894 | 894 | 20200911 | WI | 91625 | 1254034 | 144 | 1345659 | 326 | 6263 | 97 | 1074 | 75878 | A+ | 9/11/2020 00:00 | 2020-09-11T00:00:00Z | 09/10 20:00 | 1205 | 6263 | 2020-09-11T00:00:00Z | 86250 | 1197 | 8 | 1340284 | 55 | 1443 | 8586 | 1345803 | posNeg | 10029 | 1345659 | 4 | 41 | 00ce3fef4945c53a88a4fe76c7f0897cf4a38ccb | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
896 | 896 | 20200911 | WY | 4264 | 82091 | 86355 | 12 | 227 | 3724 | B | 9/11/2020 17:31 | 2020-09-11T17:31:00Z | 09/11 13:31 | 42 | 227 | 2020-09-11T17:31:00Z | 126331 | 3663 | 122667 | 3605 | 85696 | 56 | 65 | 991 | 86355 | posNeg | 1056 | 86355 | 0 | 3 | 6d4c991baa79c7f8edc4cd5fde61fdcf8567eb18 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
889 | 889 | 20200911 | UT | 56675 | 651132 | 707807 | 170 | 3288 | 48 | 817 | 338 | 48021 | A+ | 9/11/2020 11:02 | 2020-09-11T11:02:00Z | 09/11 07:02 | 431 | 3288 | 2020-09-11T11:02:00Z | 887314 | 56675 | 707807 | 7681 | 1192 | 10170 | 1267 | 49 | 656 | 3385 | 707807 | posNeg | 4041 | 707807 | 1 | 15 | 054a8c9828f40edd610795bbe83dfb02e9d63870 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
787 | 787 | 20200912 | AR | 69710 | 750290 | 820354 | 392 | 4678 | 170 | 76 | 597 | 61245 | A+ | 9/11/2020 14:35 | 2020-09-11T14:35:00Z | 09/11 10:35 | 969 | 4678 | 2020-09-11T14:35:00Z | 820354 | 750290 | 68542 | 964 | 5 | 17549 | 2709 | 5 | 727 | 20915 | 820000 | posNeg | 24175 | 820000 | 16 | 0 | e1d5d689c3de02083ff13fdea155bd6c6b7a3912 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
843 | 843 | 20200911 | AR | 68983 | 729375 | 796179 | 392 | 4678 | 76 | 597 | 61245 | A | 9/11/2020 14:35 | 2020-09-11T14:35:00Z | 09/11 10:35 | 953 | 4678 | 2020-09-11T14:35:00Z | 796179 | 729375 | 67911 | 17549 | 2709 | 5 | 1180 | 0 | 798358 | posNeg | 0 | 798358 | 13 | 72 | 2348f9a7b8b46f7301b5aa6a35b72ae97760da85 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
888 | 888 | 20200911 | TX | 653356 | 4800685 | 5454041 | 3465 | 1198 | 568067 | A+ | 9/11/2020 16:25 | 2020-09-11T16:25:00Z | 09/11 12:25 | 13997 | 2020-09-11T16:25:00Z | 5454041 | 653356 | 380352 | 33010 | 43841 | 6163 | 48 | 3547 | 45237 | 5454041 | posNeg | 48784 | 5454041 | 144 | 0 | 974f3e0dcda3886d8aac8415e75d839aac67c634 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
832 | 832 | 20200912 | TX | 657589 | 4862052 | 5519641 | 3371 | 1174 | 573670 | A+ | 9/11/2020 16:25 | 2020-09-11T16:25:00Z | 09/11 12:25 | 14143 | 2020-09-11T16:25:00Z | 5519641 | 657589 | 383596 | 33571 | 44740 | 6299 | 48 | 4233 | 61367 | 5519641 | posNeg | 65600 | 5519641 | 146 | 0 | c7d89c318abcf68ccd415afb9ad8e524cfa4604e | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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 );