ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64,147 rows where state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 28035 110
- 28029 108
- 28083 108
- 28109 108
- 28049 106
- 28045 105
- 28095 105
- 28047 104
- 28059 104
- 28011 103
- 28027 103
- 28033 103
- 28089 103
- 28111 103
- 28051 102
- 28067 102
- 28123 102
- 28147 102
- 28157 102
- 28159 102
- 28163 102
- 28001 101
- 28037 101
- 28053 101
- 28071 101
- 28077 101
- 28081 101
- 28093 101
- 28113 101
- 28121 101
- …
county >30
- Forrest 110
- Copiah 108
- Leflore 108
- Pearl River 108
- Hinds 106
- Hancock 105
- Monroe 105
- Harrison 104
- Jackson 104
- Bolivar 103
- Coahoma 103
- DeSoto 103
- Madison 103
- Perry 103
- Holmes 102
- Jones 102
- Scott 102
- Walthall 102
- Wilkinson 102
- Winston 102
- Yazoo 102
- Adams 101
- Franklin 101
- Humphreys 101
- Lafayette 101
- Lawrence 101
- Lee 101
- Marshall 101
- Pike 101
- Rankin 101
- …
state 1
- Mississippi · 7,997 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282173 | 282173 | 2020-06-28 | Adams | Mississippi | 28001 | 252 | 18 |
282174 | 282174 | 2020-06-28 | Alcorn | Mississippi | 28003 | 53 | 1 |
282175 | 282175 | 2020-06-28 | Amite | Mississippi | 28005 | 80 | 2 |
282176 | 282176 | 2020-06-28 | Attala | Mississippi | 28007 | 346 | 23 |
282177 | 282177 | 2020-06-28 | Benton | Mississippi | 28009 | 25 | 0 |
282178 | 282178 | 2020-06-28 | Bolivar | Mississippi | 28011 | 247 | 13 |
282179 | 282179 | 2020-06-28 | Calhoun | Mississippi | 28013 | 110 | 4 |
282180 | 282180 | 2020-06-28 | Carroll | Mississippi | 28015 | 147 | 11 |
282181 | 282181 | 2020-06-28 | Chickasaw | Mississippi | 28017 | 235 | 18 |
282182 | 282182 | 2020-06-28 | Choctaw | Mississippi | 28019 | 71 | 4 |
282183 | 282183 | 2020-06-28 | Claiborne | Mississippi | 28021 | 212 | 10 |
282184 | 282184 | 2020-06-28 | Clarke | Mississippi | 28023 | 196 | 22 |
282185 | 282185 | 2020-06-28 | Clay | Mississippi | 28025 | 235 | 7 |
282186 | 282186 | 2020-06-28 | Coahoma | Mississippi | 28027 | 178 | 6 |
282187 | 282187 | 2020-06-28 | Copiah | Mississippi | 28029 | 538 | 13 |
282188 | 282188 | 2020-06-28 | Covington | Mississippi | 28031 | 268 | 5 |
282189 | 282189 | 2020-06-28 | DeSoto | Mississippi | 28033 | 1224 | 15 |
282190 | 282190 | 2020-06-28 | Forrest | Mississippi | 28035 | 777 | 42 |
282191 | 282191 | 2020-06-28 | Franklin | Mississippi | 28037 | 34 | 2 |
282192 | 282192 | 2020-06-28 | George | Mississippi | 28039 | 66 | 3 |
282193 | 282193 | 2020-06-28 | Greene | Mississippi | 28041 | 83 | 7 |
282194 | 282194 | 2020-06-28 | Grenada | Mississippi | 28043 | 296 | 5 |
282195 | 282195 | 2020-06-28 | Hancock | Mississippi | 28045 | 116 | 13 |
282196 | 282196 | 2020-06-28 | Harrison | Mississippi | 28047 | 642 | 7 |
282197 | 282197 | 2020-06-28 | Hinds | Mississippi | 28049 | 1957 | 36 |
282198 | 282198 | 2020-06-28 | Holmes | Mississippi | 28051 | 507 | 39 |
282199 | 282199 | 2020-06-28 | Humphreys | Mississippi | 28053 | 111 | 9 |
282200 | 282200 | 2020-06-28 | Issaquena | Mississippi | 28055 | 6 | 1 |
282201 | 282201 | 2020-06-28 | Itawamba | Mississippi | 28057 | 115 | 8 |
282202 | 282202 | 2020-06-28 | Jackson | Mississippi | 28059 | 475 | 16 |
282203 | 282203 | 2020-06-28 | Jasper | Mississippi | 28061 | 234 | 6 |
282204 | 282204 | 2020-06-28 | Jefferson | Mississippi | 28063 | 80 | 3 |
282205 | 282205 | 2020-06-28 | Jefferson Davis | Mississippi | 28065 | 101 | 4 |
282206 | 282206 | 2020-06-28 | Jones | Mississippi | 28067 | 1027 | 48 |
282207 | 282207 | 2020-06-28 | Kemper | Mississippi | 28069 | 171 | 13 |
282208 | 282208 | 2020-06-28 | Lafayette | Mississippi | 28071 | 323 | 4 |
282209 | 282209 | 2020-06-28 | Lamar | Mississippi | 28073 | 384 | 7 |
282210 | 282210 | 2020-06-28 | Lauderdale | Mississippi | 28075 | 869 | 78 |
282211 | 282211 | 2020-06-28 | Lawrence | Mississippi | 28077 | 147 | 1 |
282212 | 282212 | 2020-06-28 | Leake | Mississippi | 28079 | 534 | 17 |
282213 | 282213 | 2020-06-28 | Lee | Mississippi | 28081 | 452 | 15 |
282214 | 282214 | 2020-06-28 | Leflore | Mississippi | 28083 | 454 | 48 |
282215 | 282215 | 2020-06-28 | Lincoln | Mississippi | 28085 | 422 | 33 |
282216 | 282216 | 2020-06-28 | Lowndes | Mississippi | 28087 | 431 | 11 |
282217 | 282217 | 2020-06-28 | Madison | Mississippi | 28089 | 1145 | 32 |
282218 | 282218 | 2020-06-28 | Marion | Mississippi | 28091 | 228 | 11 |
282219 | 282219 | 2020-06-28 | Marshall | Mississippi | 28093 | 185 | 3 |
282220 | 282220 | 2020-06-28 | Monroe | Mississippi | 28095 | 340 | 29 |
282221 | 282221 | 2020-06-28 | Montgomery | Mississippi | 28097 | 111 | 2 |
282222 | 282222 | 2020-06-28 | Neshoba | Mississippi | 28099 | 933 | 64 |
282223 | 282223 | 2020-06-28 | Newton | Mississippi | 28101 | 330 | 8 |
282224 | 282224 | 2020-06-28 | Noxubee | Mississippi | 28103 | 234 | 7 |
282225 | 282225 | 2020-06-28 | Oktibbeha | Mississippi | 28105 | 466 | 23 |
282226 | 282226 | 2020-06-28 | Panola | Mississippi | 28107 | 240 | 6 |
282227 | 282227 | 2020-06-28 | Pearl River | Mississippi | 28109 | 236 | 32 |
282228 | 282228 | 2020-06-28 | Perry | Mississippi | 28111 | 56 | 4 |
282229 | 282229 | 2020-06-28 | Pike | Mississippi | 28113 | 334 | 11 |
282230 | 282230 | 2020-06-28 | Pontotoc | Mississippi | 28115 | 202 | 3 |
282231 | 282231 | 2020-06-28 | Prentiss | Mississippi | 28117 | 91 | 3 |
282232 | 282232 | 2020-06-28 | Quitman | Mississippi | 28119 | 63 | 0 |
282233 | 282233 | 2020-06-28 | Rankin | Mississippi | 28121 | 773 | 12 |
282234 | 282234 | 2020-06-28 | Scott | Mississippi | 28123 | 726 | 14 |
282235 | 282235 | 2020-06-28 | Sharkey | Mississippi | 28125 | 23 | 0 |
282236 | 282236 | 2020-06-28 | Simpson | Mississippi | 28127 | 198 | 3 |
282237 | 282237 | 2020-06-28 | Smith | Mississippi | 28129 | 204 | 11 |
282238 | 282238 | 2020-06-28 | Stone | Mississippi | 28131 | 49 | 1 |
282239 | 282239 | 2020-06-28 | Sunflower | Mississippi | 28133 | 238 | 6 |
282240 | 282240 | 2020-06-28 | Tallahatchie | Mississippi | 28135 | 93 | 2 |
282241 | 282241 | 2020-06-28 | Tate | Mississippi | 28137 | 234 | 6 |
282242 | 282242 | 2020-06-28 | Tippah | Mississippi | 28139 | 116 | 11 |
282243 | 282243 | 2020-06-28 | Tishomingo | Mississippi | 28141 | 60 | 1 |
282244 | 282244 | 2020-06-28 | Tunica | Mississippi | 28143 | 82 | 3 |
282245 | 282245 | 2020-06-28 | Union | Mississippi | 28145 | 161 | 8 |
282246 | 282246 | 2020-06-28 | Walthall | Mississippi | 28147 | 166 | 3 |
282247 | 282247 | 2020-06-28 | Warren | Mississippi | 28149 | 398 | 17 |
282248 | 282248 | 2020-06-28 | Washington | Mississippi | 28151 | 419 | 9 |
282249 | 282249 | 2020-06-28 | Wayne | Mississippi | 28153 | 499 | 10 |
282250 | 282250 | 2020-06-28 | Webster | Mississippi | 28155 | 123 | 10 |
282251 | 282251 | 2020-06-28 | Wilkinson | Mississippi | 28157 | 89 | 9 |
282252 | 282252 | 2020-06-28 | Winston | Mississippi | 28159 | 230 | 4 |
282253 | 282253 | 2020-06-28 | Yalobusha | Mississippi | 28161 | 148 | 7 |
282254 | 282254 | 2020-06-28 | Yazoo | Mississippi | 28163 | 445 | 6 |
279025 | 279025 | 2020-06-27 | Adams | Mississippi | 28001 | 248 | 18 |
279026 | 279026 | 2020-06-27 | Alcorn | Mississippi | 28003 | 53 | 1 |
279027 | 279027 | 2020-06-27 | Amite | Mississippi | 28005 | 80 | 2 |
279028 | 279028 | 2020-06-27 | Attala | Mississippi | 28007 | 345 | 23 |
279029 | 279029 | 2020-06-27 | Benton | Mississippi | 28009 | 25 | 0 |
279030 | 279030 | 2020-06-27 | Bolivar | Mississippi | 28011 | 242 | 13 |
279031 | 279031 | 2020-06-27 | Calhoun | Mississippi | 28013 | 110 | 4 |
279032 | 279032 | 2020-06-27 | Carroll | Mississippi | 28015 | 147 | 11 |
279033 | 279033 | 2020-06-27 | Chickasaw | Mississippi | 28017 | 232 | 18 |
279034 | 279034 | 2020-06-27 | Choctaw | Mississippi | 28019 | 70 | 4 |
279035 | 279035 | 2020-06-27 | Claiborne | Mississippi | 28021 | 211 | 10 |
279036 | 279036 | 2020-06-27 | Clarke | Mississippi | 28023 | 194 | 22 |
279037 | 279037 | 2020-06-27 | Clay | Mississippi | 28025 | 234 | 7 |
279038 | 279038 | 2020-06-27 | Coahoma | Mississippi | 28027 | 177 | 6 |
279039 | 279039 | 2020-06-27 | Copiah | Mississippi | 28029 | 536 | 13 |
279040 | 279040 | 2020-06-27 | Covington | Mississippi | 28031 | 264 | 5 |
279041 | 279041 | 2020-06-27 | DeSoto | Mississippi | 28033 | 1201 | 15 |
279042 | 279042 | 2020-06-27 | Forrest | Mississippi | 28035 | 775 | 42 |
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);