ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2020-10-26 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668751 | 668751 | 2020-10-26 | Adams | Mississippi | 28001 | 1089 | 44 |
668752 | 668752 | 2020-10-26 | Alcorn | Mississippi | 28003 | 1011 | 12 |
668753 | 668753 | 2020-10-26 | Amite | Mississippi | 28005 | 425 | 13 |
668754 | 668754 | 2020-10-26 | Attala | Mississippi | 28007 | 797 | 26 |
668755 | 668755 | 2020-10-26 | Benton | Mississippi | 28009 | 345 | 6 |
668756 | 668756 | 2020-10-26 | Bolivar | Mississippi | 28011 | 2019 | 77 |
668757 | 668757 | 2020-10-26 | Calhoun | Mississippi | 28013 | 626 | 12 |
668758 | 668758 | 2020-10-26 | Carroll | Mississippi | 28015 | 493 | 12 |
668759 | 668759 | 2020-10-26 | Chickasaw | Mississippi | 28017 | 857 | 26 |
668760 | 668760 | 2020-10-26 | Choctaw | Mississippi | 28019 | 208 | 6 |
668761 | 668761 | 2020-10-26 | Claiborne | Mississippi | 28021 | 538 | 16 |
668762 | 668762 | 2020-10-26 | Clarke | Mississippi | 28023 | 761 | 51 |
668763 | 668763 | 2020-10-26 | Clay | Mississippi | 28025 | 700 | 21 |
668764 | 668764 | 2020-10-26 | Coahoma | Mississippi | 28027 | 1254 | 37 |
668765 | 668765 | 2020-10-26 | Copiah | Mississippi | 28029 | 1381 | 36 |
668766 | 668766 | 2020-10-26 | Covington | Mississippi | 28031 | 979 | 27 |
668767 | 668767 | 2020-10-26 | DeSoto | Mississippi | 28033 | 7134 | 79 |
668768 | 668768 | 2020-10-26 | Forrest | Mississippi | 28035 | 3069 | 78 |
668769 | 668769 | 2020-10-26 | Franklin | Mississippi | 28037 | 246 | 3 |
668770 | 668770 | 2020-10-26 | George | Mississippi | 28039 | 999 | 19 |
668771 | 668771 | 2020-10-26 | Greene | Mississippi | 28041 | 478 | 18 |
668772 | 668772 | 2020-10-26 | Grenada | Mississippi | 28043 | 1226 | 39 |
668773 | 668773 | 2020-10-26 | Hancock | Mississippi | 28045 | 850 | 28 |
668774 | 668774 | 2020-10-26 | Harrison | Mississippi | 28047 | 5272 | 84 |
668775 | 668775 | 2020-10-26 | Hinds | Mississippi | 28049 | 7987 | 178 |
668776 | 668776 | 2020-10-26 | Holmes | Mississippi | 28051 | 1149 | 60 |
668777 | 668777 | 2020-10-26 | Humphreys | Mississippi | 28053 | 449 | 16 |
668778 | 668778 | 2020-10-26 | Issaquena | Mississippi | 28055 | 107 | 4 |
668779 | 668779 | 2020-10-26 | Itawamba | Mississippi | 28057 | 1148 | 25 |
668780 | 668780 | 2020-10-26 | Jackson | Mississippi | 28059 | 4622 | 85 |
668781 | 668781 | 2020-10-26 | Jasper | Mississippi | 28061 | 691 | 17 |
668782 | 668782 | 2020-10-26 | Jefferson | Mississippi | 28063 | 277 | 10 |
668783 | 668783 | 2020-10-26 | Jefferson Davis | Mississippi | 28065 | 412 | 11 |
668784 | 668784 | 2020-10-26 | Jones | Mississippi | 28067 | 2957 | 84 |
668785 | 668785 | 2020-10-26 | Kemper | Mississippi | 28069 | 327 | 15 |
668786 | 668786 | 2020-10-26 | Lafayette | Mississippi | 28071 | 2513 | 43 |
668787 | 668787 | 2020-10-26 | Lamar | Mississippi | 28073 | 2271 | 38 |
668788 | 668788 | 2020-10-26 | Lauderdale | Mississippi | 28075 | 2485 | 135 |
668789 | 668789 | 2020-10-26 | Lawrence | Mississippi | 28077 | 525 | 14 |
668790 | 668790 | 2020-10-26 | Leake | Mississippi | 28079 | 1152 | 42 |
668791 | 668791 | 2020-10-26 | Lee | Mississippi | 28081 | 3600 | 80 |
668792 | 668792 | 2020-10-26 | Leflore | Mississippi | 28083 | 1687 | 87 |
668793 | 668793 | 2020-10-26 | Lincoln | Mississippi | 28085 | 1411 | 57 |
668794 | 668794 | 2020-10-26 | Lowndes | Mississippi | 28087 | 1802 | 62 |
668795 | 668795 | 2020-10-26 | Madison | Mississippi | 28089 | 3837 | 94 |
668796 | 668796 | 2020-10-26 | Marion | Mississippi | 28091 | 954 | 43 |
668797 | 668797 | 2020-10-26 | Marshall | Mississippi | 28093 | 1453 | 29 |
668798 | 668798 | 2020-10-26 | Monroe | Mississippi | 28095 | 1521 | 73 |
668799 | 668799 | 2020-10-26 | Montgomery | Mississippi | 28097 | 552 | 23 |
668800 | 668800 | 2020-10-26 | Neshoba | Mississippi | 28099 | 1854 | 111 |
668801 | 668801 | 2020-10-26 | Newton | Mississippi | 28101 | 869 | 27 |
668802 | 668802 | 2020-10-26 | Noxubee | Mississippi | 28103 | 599 | 17 |
668803 | 668803 | 2020-10-26 | Oktibbeha | Mississippi | 28105 | 2028 | 54 |
668804 | 668804 | 2020-10-26 | Panola | Mississippi | 28107 | 1702 | 40 |
668805 | 668805 | 2020-10-26 | Pearl River | Mississippi | 28109 | 1145 | 60 |
668806 | 668806 | 2020-10-26 | Perry | Mississippi | 28111 | 498 | 23 |
668807 | 668807 | 2020-10-26 | Pike | Mississippi | 28113 | 1392 | 56 |
668808 | 668808 | 2020-10-26 | Pontotoc | Mississippi | 28115 | 1479 | 20 |
668809 | 668809 | 2020-10-26 | Prentiss | Mississippi | 28117 | 1069 | 20 |
668810 | 668810 | 2020-10-26 | Quitman | Mississippi | 28119 | 420 | 6 |
668811 | 668811 | 2020-10-26 | Rankin | Mississippi | 28121 | 3982 | 86 |
668812 | 668812 | 2020-10-26 | Scott | Mississippi | 28123 | 1257 | 29 |
668813 | 668813 | 2020-10-26 | Sharkey | Mississippi | 28125 | 285 | 14 |
668814 | 668814 | 2020-10-26 | Simpson | Mississippi | 28127 | 1217 | 49 |
668815 | 668815 | 2020-10-26 | Smith | Mississippi | 28129 | 596 | 16 |
668816 | 668816 | 2020-10-26 | Stone | Mississippi | 28131 | 477 | 14 |
668817 | 668817 | 2020-10-26 | Sunflower | Mississippi | 28133 | 1634 | 49 |
668818 | 668818 | 2020-10-26 | Tallahatchie | Mississippi | 28135 | 845 | 26 |
668819 | 668819 | 2020-10-26 | Tate | Mississippi | 28137 | 1177 | 39 |
668820 | 668820 | 2020-10-26 | Tippah | Mississippi | 28139 | 913 | 23 |
668821 | 668821 | 2020-10-26 | Tishomingo | Mississippi | 28141 | 816 | 41 |
668822 | 668822 | 2020-10-26 | Tunica | Mississippi | 28143 | 535 | 17 |
668823 | 668823 | 2020-10-26 | Union | Mississippi | 28145 | 1192 | 25 |
668824 | 668824 | 2020-10-26 | Walthall | Mississippi | 28147 | 640 | 27 |
668825 | 668825 | 2020-10-26 | Warren | Mississippi | 28149 | 1551 | 56 |
668826 | 668826 | 2020-10-26 | Washington | Mississippi | 28151 | 2592 | 99 |
668827 | 668827 | 2020-10-26 | Wayne | Mississippi | 28153 | 1020 | 22 |
668828 | 668828 | 2020-10-26 | Webster | Mississippi | 28155 | 376 | 13 |
668829 | 668829 | 2020-10-26 | Wilkinson | Mississippi | 28157 | 338 | 20 |
668830 | 668830 | 2020-10-26 | Winston | Mississippi | 28159 | 844 | 21 |
668831 | 668831 | 2020-10-26 | Yalobusha | Mississippi | 28161 | 549 | 14 |
668832 | 668832 | 2020-10-26 | Yazoo | Mississippi | 28163 | 1226 | 34 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);