ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where "date" is on date 2020-06-17 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
247736 | 247736 | 2020-06-17 | Adams | Mississippi | 28001 | 227 | 18 |
247737 | 247737 | 2020-06-17 | Alcorn | Mississippi | 28003 | 32 | 1 |
247738 | 247738 | 2020-06-17 | Amite | Mississippi | 28005 | 73 | 2 |
247739 | 247739 | 2020-06-17 | Attala | Mississippi | 28007 | 335 | 23 |
247740 | 247740 | 2020-06-17 | Benton | Mississippi | 28009 | 18 | 0 |
247741 | 247741 | 2020-06-17 | Bolivar | Mississippi | 28011 | 197 | 13 |
247742 | 247742 | 2020-06-17 | Calhoun | Mississippi | 28013 | 83 | 4 |
247743 | 247743 | 2020-06-17 | Carroll | Mississippi | 28015 | 122 | 11 |
247744 | 247744 | 2020-06-17 | Chickasaw | Mississippi | 28017 | 177 | 16 |
247745 | 247745 | 2020-06-17 | Choctaw | Mississippi | 28019 | 71 | 2 |
247746 | 247746 | 2020-06-17 | Claiborne | Mississippi | 28021 | 144 | 9 |
247747 | 247747 | 2020-06-17 | Clarke | Mississippi | 28023 | 168 | 21 |
247748 | 247748 | 2020-06-17 | Clay | Mississippi | 28025 | 185 | 6 |
247749 | 247749 | 2020-06-17 | Coahoma | Mississippi | 28027 | 156 | 6 |
247750 | 247750 | 2020-06-17 | Copiah | Mississippi | 28029 | 425 | 7 |
247751 | 247751 | 2020-06-17 | Covington | Mississippi | 28031 | 213 | 3 |
247752 | 247752 | 2020-06-17 | DeSoto | Mississippi | 28033 | 790 | 14 |
247753 | 247753 | 2020-06-17 | Forrest | Mississippi | 28035 | 697 | 41 |
247754 | 247754 | 2020-06-17 | Franklin | Mississippi | 28037 | 30 | 2 |
247755 | 247755 | 2020-06-17 | George | Mississippi | 28039 | 41 | 2 |
247756 | 247756 | 2020-06-17 | Greene | Mississippi | 28041 | 56 | 4 |
247757 | 247757 | 2020-06-17 | Grenada | Mississippi | 28043 | 170 | 4 |
247758 | 247758 | 2020-06-17 | Hancock | Mississippi | 28045 | 100 | 13 |
247759 | 247759 | 2020-06-17 | Harrison | Mississippi | 28047 | 393 | 7 |
247760 | 247760 | 2020-06-17 | Hinds | Mississippi | 28049 | 1390 | 29 |
247761 | 247761 | 2020-06-17 | Holmes | Mississippi | 28051 | 477 | 35 |
247762 | 247762 | 2020-06-17 | Humphreys | Mississippi | 28053 | 83 | 8 |
247763 | 247763 | 2020-06-17 | Itawamba | Mississippi | 28057 | 106 | 8 |
247764 | 247764 | 2020-06-17 | Jackson | Mississippi | 28059 | 385 | 16 |
247765 | 247765 | 2020-06-17 | Jasper | Mississippi | 28061 | 203 | 4 |
247766 | 247766 | 2020-06-17 | Jefferson | Mississippi | 28063 | 57 | 2 |
247767 | 247767 | 2020-06-17 | Jefferson Davis | Mississippi | 28065 | 86 | 3 |
247768 | 247768 | 2020-06-17 | Jones | Mississippi | 28067 | 910 | 44 |
247769 | 247769 | 2020-06-17 | Kemper | Mississippi | 28069 | 169 | 13 |
247770 | 247770 | 2020-06-17 | Lafayette | Mississippi | 28071 | 209 | 4 |
247771 | 247771 | 2020-06-17 | Lamar | Mississippi | 28073 | 300 | 6 |
247772 | 247772 | 2020-06-17 | Lauderdale | Mississippi | 28075 | 818 | 75 |
247773 | 247773 | 2020-06-17 | Lawrence | Mississippi | 28077 | 121 | 1 |
247774 | 247774 | 2020-06-17 | Leake | Mississippi | 28079 | 496 | 16 |
247775 | 247775 | 2020-06-17 | Lee | Mississippi | 28081 | 330 | 14 |
247776 | 247776 | 2020-06-17 | Leflore | Mississippi | 28083 | 385 | 47 |
247777 | 247777 | 2020-06-17 | Lincoln | Mississippi | 28085 | 330 | 32 |
247778 | 247778 | 2020-06-17 | Lowndes | Mississippi | 28087 | 352 | 10 |
247779 | 247779 | 2020-06-17 | Madison | Mississippi | 28089 | 922 | 31 |
247780 | 247780 | 2020-06-17 | Marion | Mississippi | 28091 | 163 | 9 |
247781 | 247781 | 2020-06-17 | Marshall | Mississippi | 28093 | 122 | 3 |
247782 | 247782 | 2020-06-17 | Monroe | Mississippi | 28095 | 301 | 26 |
247783 | 247783 | 2020-06-17 | Montgomery | Mississippi | 28097 | 98 | 1 |
247784 | 247784 | 2020-06-17 | Neshoba | Mississippi | 28099 | 921 | 56 |
247785 | 247785 | 2020-06-17 | Newton | Mississippi | 28101 | 325 | 8 |
247786 | 247786 | 2020-06-17 | Noxubee | Mississippi | 28103 | 218 | 6 |
247787 | 247787 | 2020-06-17 | Oktibbeha | Mississippi | 28105 | 386 | 18 |
247788 | 247788 | 2020-06-17 | Panola | Mississippi | 28107 | 146 | 4 |
247789 | 247789 | 2020-06-17 | Pearl River | Mississippi | 28109 | 224 | 32 |
247790 | 247790 | 2020-06-17 | Perry | Mississippi | 28111 | 55 | 3 |
247791 | 247791 | 2020-06-17 | Pike | Mississippi | 28113 | 248 | 11 |
247792 | 247792 | 2020-06-17 | Pontotoc | Mississippi | 28115 | 93 | 3 |
247793 | 247793 | 2020-06-17 | Prentiss | Mississippi | 28117 | 70 | 3 |
247794 | 247794 | 2020-06-17 | Quitman | Mississippi | 28119 | 52 | 0 |
247795 | 247795 | 2020-06-17 | Rankin | Mississippi | 28121 | 563 | 10 |
247796 | 247796 | 2020-06-17 | Scott | Mississippi | 28123 | 696 | 12 |
247797 | 247797 | 2020-06-17 | Sharkey | Mississippi | 28125 | 9 | 0 |
247798 | 247798 | 2020-06-17 | Simpson | Mississippi | 28127 | 126 | 1 |
247799 | 247799 | 2020-06-17 | Smith | Mississippi | 28129 | 182 | 11 |
247800 | 247800 | 2020-06-17 | Stone | Mississippi | 28131 | 35 | 1 |
247801 | 247801 | 2020-06-17 | Sunflower | Mississippi | 28133 | 128 | 4 |
247802 | 247802 | 2020-06-17 | Tallahatchie | Mississippi | 28135 | 49 | 1 |
247803 | 247803 | 2020-06-17 | Tate | Mississippi | 28137 | 155 | 1 |
247804 | 247804 | 2020-06-17 | Tippah | Mississippi | 28139 | 100 | 11 |
247805 | 247805 | 2020-06-17 | Tishomingo | Mississippi | 28141 | 47 | 1 |
247806 | 247806 | 2020-06-17 | Tunica | Mississippi | 28143 | 67 | 3 |
247807 | 247807 | 2020-06-17 | Union | Mississippi | 28145 | 109 | 8 |
247808 | 247808 | 2020-06-17 | Walthall | Mississippi | 28147 | 111 | 1 |
247809 | 247809 | 2020-06-17 | Warren | Mississippi | 28149 | 280 | 14 |
247810 | 247810 | 2020-06-17 | Washington | Mississippi | 28151 | 276 | 9 |
247811 | 247811 | 2020-06-17 | Wayne | Mississippi | 28153 | 409 | 8 |
247812 | 247812 | 2020-06-17 | Webster | Mississippi | 28155 | 109 | 8 |
247813 | 247813 | 2020-06-17 | Wilkinson | Mississippi | 28157 | 85 | 9 |
247814 | 247814 | 2020-06-17 | Winston | Mississippi | 28159 | 158 | 2 |
247815 | 247815 | 2020-06-17 | Yalobusha | Mississippi | 28161 | 139 | 7 |
247816 | 247816 | 2020-06-17 | Yazoo | Mississippi | 28163 | 354 | 6 |
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);