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 220
- 28029 218
- 28083 218
- 28109 218
- 28049 216
- 28045 215
- 28095 215
- 28047 214
- 28059 214
- 28011 213
- 28027 213
- 28033 213
- 28089 213
- 28111 213
- 28051 212
- 28067 212
- 28123 212
- 28147 212
- 28157 212
- 28159 212
- 28163 212
- 28001 211
- 28037 211
- 28053 211
- 28071 211
- 28077 211
- 28081 211
- 28093 211
- 28113 211
- 28121 211
- …
county >30
- Forrest 220
- Copiah 218
- Leflore 218
- Pearl River 218
- Hinds 216
- Hancock 215
- Monroe 215
- Harrison 214
- Jackson 214
- Bolivar 213
- Coahoma 213
- DeSoto 213
- Madison 213
- Perry 213
- Holmes 212
- Jones 212
- Scott 212
- Walthall 212
- Wilkinson 212
- Winston 212
- Yazoo 212
- Adams 211
- Franklin 211
- Humphreys 211
- Lafayette 211
- Lawrence 211
- Lee 211
- Marshall 211
- Pike 211
- Rankin 211
- …
state 1
- Mississippi · 17,021 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636299 | 636299 | 2020-10-16 | Adams | Mississippi | 28001 | 1032 | 40 |
636300 | 636300 | 2020-10-16 | Alcorn | Mississippi | 28003 | 938 | 12 |
636301 | 636301 | 2020-10-16 | Amite | Mississippi | 28005 | 412 | 13 |
636302 | 636302 | 2020-10-16 | Attala | Mississippi | 28007 | 755 | 25 |
636303 | 636303 | 2020-10-16 | Benton | Mississippi | 28009 | 296 | 4 |
636304 | 636304 | 2020-10-16 | Bolivar | Mississippi | 28011 | 1973 | 75 |
636305 | 636305 | 2020-10-16 | Calhoun | Mississippi | 28013 | 605 | 12 |
636306 | 636306 | 2020-10-16 | Carroll | Mississippi | 28015 | 453 | 12 |
636307 | 636307 | 2020-10-16 | Chickasaw | Mississippi | 28017 | 811 | 24 |
636308 | 636308 | 2020-10-16 | Choctaw | Mississippi | 28019 | 202 | 6 |
636309 | 636309 | 2020-10-16 | Claiborne | Mississippi | 28021 | 528 | 16 |
636310 | 636310 | 2020-10-16 | Clarke | Mississippi | 28023 | 704 | 48 |
636311 | 636311 | 2020-10-16 | Clay | Mississippi | 28025 | 663 | 21 |
636312 | 636312 | 2020-10-16 | Coahoma | Mississippi | 28027 | 1223 | 36 |
636313 | 636313 | 2020-10-16 | Copiah | Mississippi | 28029 | 1328 | 36 |
636314 | 636314 | 2020-10-16 | Covington | Mississippi | 28031 | 902 | 25 |
636315 | 636315 | 2020-10-16 | DeSoto | Mississippi | 28033 | 6495 | 77 |
636316 | 636316 | 2020-10-16 | Forrest | Mississippi | 28035 | 2906 | 77 |
636317 | 636317 | 2020-10-16 | Franklin | Mississippi | 28037 | 223 | 3 |
636318 | 636318 | 2020-10-16 | George | Mississippi | 28039 | 927 | 16 |
636319 | 636319 | 2020-10-16 | Greene | Mississippi | 28041 | 444 | 17 |
636320 | 636320 | 2020-10-16 | Grenada | Mississippi | 28043 | 1193 | 37 |
636321 | 636321 | 2020-10-16 | Hancock | Mississippi | 28045 | 739 | 27 |
636322 | 636322 | 2020-10-16 | Harrison | Mississippi | 28047 | 4713 | 81 |
636323 | 636323 | 2020-10-16 | Hinds | Mississippi | 28049 | 7707 | 170 |
636324 | 636324 | 2020-10-16 | Holmes | Mississippi | 28051 | 1129 | 60 |
636325 | 636325 | 2020-10-16 | Humphreys | Mississippi | 28053 | 394 | 16 |
636326 | 636326 | 2020-10-16 | Issaquena | Mississippi | 28055 | 106 | 3 |
636327 | 636327 | 2020-10-16 | Itawamba | Mississippi | 28057 | 1070 | 24 |
636328 | 636328 | 2020-10-16 | Jackson | Mississippi | 28059 | 4258 | 77 |
636329 | 636329 | 2020-10-16 | Jasper | Mississippi | 28061 | 657 | 16 |
636330 | 636330 | 2020-10-16 | Jefferson | Mississippi | 28063 | 259 | 10 |
636331 | 636331 | 2020-10-16 | Jefferson Davis | Mississippi | 28065 | 390 | 11 |
636332 | 636332 | 2020-10-16 | Jones | Mississippi | 28067 | 2799 | 81 |
636333 | 636333 | 2020-10-16 | Kemper | Mississippi | 28069 | 315 | 15 |
636334 | 636334 | 2020-10-16 | Lafayette | Mississippi | 28071 | 2405 | 42 |
636335 | 636335 | 2020-10-16 | Lamar | Mississippi | 28073 | 2100 | 38 |
636336 | 636336 | 2020-10-16 | Lauderdale | Mississippi | 28075 | 2311 | 130 |
636337 | 636337 | 2020-10-16 | Lawrence | Mississippi | 28077 | 489 | 14 |
636338 | 636338 | 2020-10-16 | Leake | Mississippi | 28079 | 1110 | 39 |
636339 | 636339 | 2020-10-16 | Lee | Mississippi | 28081 | 3354 | 79 |
636340 | 636340 | 2020-10-16 | Leflore | Mississippi | 28083 | 1582 | 86 |
636341 | 636341 | 2020-10-16 | Lincoln | Mississippi | 28085 | 1321 | 54 |
636342 | 636342 | 2020-10-16 | Lowndes | Mississippi | 28087 | 1729 | 62 |
636343 | 636343 | 2020-10-16 | Madison | Mississippi | 28089 | 3683 | 92 |
636344 | 636344 | 2020-10-16 | Marion | Mississippi | 28091 | 926 | 42 |
636345 | 636345 | 2020-10-16 | Marshall | Mississippi | 28093 | 1273 | 25 |
636346 | 636346 | 2020-10-16 | Monroe | Mississippi | 28095 | 1422 | 72 |
636347 | 636347 | 2020-10-16 | Montgomery | Mississippi | 28097 | 523 | 23 |
636348 | 636348 | 2020-10-16 | Neshoba | Mississippi | 28099 | 1790 | 110 |
636349 | 636349 | 2020-10-16 | Newton | Mississippi | 28101 | 840 | 27 |
636350 | 636350 | 2020-10-16 | Noxubee | Mississippi | 28103 | 593 | 16 |
636351 | 636351 | 2020-10-16 | Oktibbeha | Mississippi | 28105 | 1932 | 54 |
636352 | 636352 | 2020-10-16 | Panola | Mississippi | 28107 | 1642 | 36 |
636353 | 636353 | 2020-10-16 | Pearl River | Mississippi | 28109 | 1063 | 55 |
636354 | 636354 | 2020-10-16 | Perry | Mississippi | 28111 | 469 | 22 |
636355 | 636355 | 2020-10-16 | Pike | Mississippi | 28113 | 1351 | 55 |
636356 | 636356 | 2020-10-16 | Pontotoc | Mississippi | 28115 | 1426 | 19 |
636357 | 636357 | 2020-10-16 | Prentiss | Mississippi | 28117 | 1007 | 19 |
636358 | 636358 | 2020-10-16 | Quitman | Mississippi | 28119 | 410 | 6 |
636359 | 636359 | 2020-10-16 | Rankin | Mississippi | 28121 | 3773 | 86 |
636360 | 636360 | 2020-10-16 | Scott | Mississippi | 28123 | 1216 | 29 |
636361 | 636361 | 2020-10-16 | Sharkey | Mississippi | 28125 | 277 | 14 |
636362 | 636362 | 2020-10-16 | Simpson | Mississippi | 28127 | 1174 | 48 |
636363 | 636363 | 2020-10-16 | Smith | Mississippi | 28129 | 576 | 16 |
636364 | 636364 | 2020-10-16 | Stone | Mississippi | 28131 | 443 | 14 |
636365 | 636365 | 2020-10-16 | Sunflower | Mississippi | 28133 | 1557 | 49 |
636366 | 636366 | 2020-10-16 | Tallahatchie | Mississippi | 28135 | 817 | 25 |
636367 | 636367 | 2020-10-16 | Tate | Mississippi | 28137 | 1119 | 39 |
636368 | 636368 | 2020-10-16 | Tippah | Mississippi | 28139 | 844 | 20 |
636369 | 636369 | 2020-10-16 | Tishomingo | Mississippi | 28141 | 779 | 40 |
636370 | 636370 | 2020-10-16 | Tunica | Mississippi | 28143 | 518 | 17 |
636371 | 636371 | 2020-10-16 | Union | Mississippi | 28145 | 1119 | 25 |
636372 | 636372 | 2020-10-16 | Walthall | Mississippi | 28147 | 628 | 27 |
636373 | 636373 | 2020-10-16 | Warren | Mississippi | 28149 | 1511 | 54 |
636374 | 636374 | 2020-10-16 | Washington | Mississippi | 28151 | 2493 | 95 |
636375 | 636375 | 2020-10-16 | Wayne | Mississippi | 28153 | 972 | 21 |
636376 | 636376 | 2020-10-16 | Webster | Mississippi | 28155 | 361 | 13 |
636377 | 636377 | 2020-10-16 | Wilkinson | Mississippi | 28157 | 329 | 20 |
636378 | 636378 | 2020-10-16 | Winston | Mississippi | 28159 | 810 | 21 |
636379 | 636379 | 2020-10-16 | Yalobusha | Mississippi | 28161 | 479 | 14 |
636380 | 636380 | 2020-10-16 | Yazoo | Mississippi | 28163 | 1160 | 33 |
633053 | 633053 | 2020-10-15 | Adams | Mississippi | 28001 | 1019 | 41 |
633054 | 633054 | 2020-10-15 | Alcorn | Mississippi | 28003 | 920 | 12 |
633055 | 633055 | 2020-10-15 | Amite | Mississippi | 28005 | 410 | 13 |
633056 | 633056 | 2020-10-15 | Attala | Mississippi | 28007 | 749 | 25 |
633057 | 633057 | 2020-10-15 | Benton | Mississippi | 28009 | 292 | 4 |
633058 | 633058 | 2020-10-15 | Bolivar | Mississippi | 28011 | 1967 | 75 |
633059 | 633059 | 2020-10-15 | Calhoun | Mississippi | 28013 | 594 | 12 |
633060 | 633060 | 2020-10-15 | Carroll | Mississippi | 28015 | 449 | 12 |
633061 | 633061 | 2020-10-15 | Chickasaw | Mississippi | 28017 | 801 | 24 |
633062 | 633062 | 2020-10-15 | Choctaw | Mississippi | 28019 | 202 | 6 |
633063 | 633063 | 2020-10-15 | Claiborne | Mississippi | 28021 | 527 | 16 |
633064 | 633064 | 2020-10-15 | Clarke | Mississippi | 28023 | 701 | 48 |
633065 | 633065 | 2020-10-15 | Clay | Mississippi | 28025 | 660 | 21 |
633066 | 633066 | 2020-10-15 | Coahoma | Mississippi | 28027 | 1219 | 35 |
633067 | 633067 | 2020-10-15 | Copiah | Mississippi | 28029 | 1319 | 35 |
633068 | 633068 | 2020-10-15 | Covington | Mississippi | 28031 | 897 | 25 |
633069 | 633069 | 2020-10-15 | DeSoto | Mississippi | 28033 | 6401 | 77 |
633070 | 633070 | 2020-10-15 | Forrest | Mississippi | 28035 | 2887 | 77 |
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);