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 143
- 28029 141
- 28083 141
- 28109 141
- 28049 139
- 28045 138
- 28095 138
- 28047 137
- 28059 137
- 28011 136
- 28027 136
- 28033 136
- 28089 136
- 28111 136
- 28051 135
- 28067 135
- 28123 135
- 28147 135
- 28157 135
- 28159 135
- 28163 135
- 28001 134
- 28037 134
- 28053 134
- 28071 134
- 28077 134
- 28081 134
- 28093 134
- 28113 134
- 28121 134
- …
county >30
- Forrest 143
- Copiah 141
- Leflore 141
- Pearl River 141
- Hinds 139
- Hancock 138
- Monroe 138
- Harrison 137
- Jackson 137
- Bolivar 136
- Coahoma 136
- DeSoto 136
- Madison 136
- Perry 136
- Holmes 135
- Jones 135
- Scott 135
- Walthall 135
- Wilkinson 135
- Winston 135
- Yazoo 135
- Adams 134
- Franklin 134
- Humphreys 134
- Lafayette 134
- Lawrence 134
- Lee 134
- Marshall 134
- Pike 134
- Rankin 134
- …
state 1
- Mississippi · 10,707 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387347 | 387347 | 2020-07-31 | Adams | Mississippi | 28001 | 565 | 23 |
387348 | 387348 | 2020-07-31 | Alcorn | Mississippi | 28003 | 335 | 3 |
387349 | 387349 | 2020-07-31 | Amite | Mississippi | 28005 | 193 | 4 |
387350 | 387350 | 2020-07-31 | Attala | Mississippi | 28007 | 486 | 23 |
387351 | 387351 | 2020-07-31 | Benton | Mississippi | 28009 | 118 | 0 |
387352 | 387352 | 2020-07-31 | Bolivar | Mississippi | 28011 | 917 | 32 |
387353 | 387353 | 2020-07-31 | Calhoun | Mississippi | 28013 | 366 | 8 |
387354 | 387354 | 2020-07-31 | Carroll | Mississippi | 28015 | 240 | 11 |
387355 | 387355 | 2020-07-31 | Chickasaw | Mississippi | 28017 | 420 | 19 |
387356 | 387356 | 2020-07-31 | Choctaw | Mississippi | 28019 | 124 | 4 |
387357 | 387357 | 2020-07-31 | Claiborne | Mississippi | 28021 | 398 | 12 |
387358 | 387358 | 2020-07-31 | Clarke | Mississippi | 28023 | 297 | 25 |
387359 | 387359 | 2020-07-31 | Clay | Mississippi | 28025 | 363 | 14 |
387360 | 387360 | 2020-07-31 | Coahoma | Mississippi | 28027 | 632 | 10 |
387361 | 387361 | 2020-07-31 | Copiah | Mississippi | 28029 | 897 | 23 |
387362 | 387362 | 2020-07-31 | Covington | Mississippi | 28031 | 575 | 11 |
387363 | 387363 | 2020-07-31 | DeSoto | Mississippi | 28033 | 3113 | 26 |
387364 | 387364 | 2020-07-31 | Forrest | Mississippi | 28035 | 1564 | 50 |
387365 | 387365 | 2020-07-31 | Franklin | Mississippi | 28037 | 111 | 3 |
387366 | 387366 | 2020-07-31 | George | Mississippi | 28039 | 525 | 5 |
387367 | 387367 | 2020-07-31 | Greene | Mississippi | 28041 | 223 | 11 |
387368 | 387368 | 2020-07-31 | Grenada | Mississippi | 28043 | 796 | 20 |
387369 | 387369 | 2020-07-31 | Hancock | Mississippi | 28045 | 323 | 14 |
387370 | 387370 | 2020-07-31 | Harrison | Mississippi | 28047 | 2048 | 31 |
387371 | 387371 | 2020-07-31 | Hinds | Mississippi | 28049 | 5091 | 102 |
387372 | 387372 | 2020-07-31 | Holmes | Mississippi | 28051 | 825 | 46 |
387373 | 387373 | 2020-07-31 | Humphreys | Mississippi | 28053 | 262 | 11 |
387374 | 387374 | 2020-07-31 | Issaquena | Mississippi | 28055 | 20 | 1 |
387375 | 387375 | 2020-07-31 | Itawamba | Mississippi | 28057 | 297 | 10 |
387376 | 387376 | 2020-07-31 | Jackson | Mississippi | 28059 | 1837 | 34 |
387377 | 387377 | 2020-07-31 | Jasper | Mississippi | 28061 | 368 | 8 |
387378 | 387378 | 2020-07-31 | Jefferson | Mississippi | 28063 | 188 | 6 |
387379 | 387379 | 2020-07-31 | Jefferson Davis | Mississippi | 28065 | 191 | 5 |
387380 | 387380 | 2020-07-31 | Jones | Mississippi | 28067 | 1705 | 57 |
387381 | 387381 | 2020-07-31 | Kemper | Mississippi | 28069 | 223 | 15 |
387382 | 387382 | 2020-07-31 | Lafayette | Mississippi | 28071 | 837 | 7 |
387383 | 387383 | 2020-07-31 | Lamar | Mississippi | 28073 | 1080 | 12 |
387384 | 387384 | 2020-07-31 | Lauderdale | Mississippi | 28075 | 1316 | 88 |
387385 | 387385 | 2020-07-31 | Lawrence | Mississippi | 28077 | 300 | 5 |
387386 | 387386 | 2020-07-31 | Leake | Mississippi | 28079 | 755 | 25 |
387387 | 387387 | 2020-07-31 | Lee | Mississippi | 28081 | 1162 | 29 |
387388 | 387388 | 2020-07-31 | Leflore | Mississippi | 28083 | 814 | 59 |
387389 | 387389 | 2020-07-31 | Lincoln | Mississippi | 28085 | 730 | 38 |
387390 | 387390 | 2020-07-31 | Lowndes | Mississippi | 28087 | 941 | 30 |
387391 | 387391 | 2020-07-31 | Madison | Mississippi | 28089 | 2250 | 50 |
387392 | 387392 | 2020-07-31 | Marion | Mississippi | 28091 | 581 | 17 |
387393 | 387393 | 2020-07-31 | Marshall | Mississippi | 28093 | 536 | 8 |
387394 | 387394 | 2020-07-31 | Monroe | Mississippi | 28095 | 675 | 50 |
387395 | 387395 | 2020-07-31 | Montgomery | Mississippi | 28097 | 276 | 3 |
387396 | 387396 | 2020-07-31 | Neshoba | Mississippi | 28099 | 1186 | 87 |
387397 | 387397 | 2020-07-31 | Newton | Mississippi | 28101 | 514 | 11 |
387398 | 387398 | 2020-07-31 | Noxubee | Mississippi | 28103 | 411 | 10 |
387399 | 387399 | 2020-07-31 | Oktibbeha | Mississippi | 28105 | 1039 | 34 |
387400 | 387400 | 2020-07-31 | Panola | Mississippi | 28107 | 877 | 11 |
387401 | 387401 | 2020-07-31 | Pearl River | Mississippi | 28109 | 471 | 36 |
387402 | 387402 | 2020-07-31 | Perry | Mississippi | 28111 | 209 | 7 |
387403 | 387403 | 2020-07-31 | Pike | Mississippi | 28113 | 808 | 30 |
387404 | 387404 | 2020-07-31 | Pontotoc | Mississippi | 28115 | 699 | 7 |
387405 | 387405 | 2020-07-31 | Prentiss | Mississippi | 28117 | 318 | 6 |
387406 | 387406 | 2020-07-31 | Quitman | Mississippi | 28119 | 211 | 1 |
387407 | 387407 | 2020-07-31 | Rankin | Mississippi | 28121 | 2091 | 28 |
387408 | 387408 | 2020-07-31 | Scott | Mississippi | 28123 | 947 | 17 |
387409 | 387409 | 2020-07-31 | Sharkey | Mississippi | 28125 | 139 | 1 |
387410 | 387410 | 2020-07-31 | Simpson | Mississippi | 28127 | 696 | 24 |
387411 | 387411 | 2020-07-31 | Smith | Mississippi | 28129 | 367 | 12 |
387412 | 387412 | 2020-07-31 | Stone | Mississippi | 28131 | 144 | 3 |
387413 | 387413 | 2020-07-31 | Sunflower | Mississippi | 28133 | 893 | 21 |
387414 | 387414 | 2020-07-31 | Tallahatchie | Mississippi | 28135 | 399 | 10 |
387415 | 387415 | 2020-07-31 | Tate | Mississippi | 28137 | 621 | 21 |
387416 | 387416 | 2020-07-31 | Tippah | Mississippi | 28139 | 285 | 12 |
387417 | 387417 | 2020-07-31 | Tishomingo | Mississippi | 28141 | 299 | 3 |
387418 | 387418 | 2020-07-31 | Tunica | Mississippi | 28143 | 228 | 5 |
387419 | 387419 | 2020-07-31 | Union | Mississippi | 28145 | 503 | 13 |
387420 | 387420 | 2020-07-31 | Walthall | Mississippi | 28147 | 425 | 18 |
387421 | 387421 | 2020-07-31 | Warren | Mississippi | 28149 | 946 | 25 |
387422 | 387422 | 2020-07-31 | Washington | Mississippi | 28151 | 1419 | 32 |
387423 | 387423 | 2020-07-31 | Wayne | Mississippi | 28153 | 729 | 21 |
387424 | 387424 | 2020-07-31 | Webster | Mississippi | 28155 | 181 | 12 |
387425 | 387425 | 2020-07-31 | Wilkinson | Mississippi | 28157 | 178 | 12 |
387426 | 387426 | 2020-07-31 | Winston | Mississippi | 28159 | 560 | 14 |
387427 | 387427 | 2020-07-31 | Yalobusha | Mississippi | 28161 | 308 | 10 |
387428 | 387428 | 2020-07-31 | Yazoo | Mississippi | 28163 | 757 | 11 |
384129 | 384129 | 2020-07-30 | Adams | Mississippi | 28001 | 552 | 23 |
384130 | 384130 | 2020-07-30 | Alcorn | Mississippi | 28003 | 331 | 3 |
384131 | 384131 | 2020-07-30 | Amite | Mississippi | 28005 | 192 | 4 |
384132 | 384132 | 2020-07-30 | Attala | Mississippi | 28007 | 480 | 23 |
384133 | 384133 | 2020-07-30 | Benton | Mississippi | 28009 | 115 | 0 |
384134 | 384134 | 2020-07-30 | Bolivar | Mississippi | 28011 | 889 | 29 |
384135 | 384135 | 2020-07-30 | Calhoun | Mississippi | 28013 | 364 | 8 |
384136 | 384136 | 2020-07-30 | Carroll | Mississippi | 28015 | 237 | 11 |
384137 | 384137 | 2020-07-30 | Chickasaw | Mississippi | 28017 | 413 | 19 |
384138 | 384138 | 2020-07-30 | Choctaw | Mississippi | 28019 | 120 | 4 |
384139 | 384139 | 2020-07-30 | Claiborne | Mississippi | 28021 | 390 | 12 |
384140 | 384140 | 2020-07-30 | Clarke | Mississippi | 28023 | 288 | 25 |
384141 | 384141 | 2020-07-30 | Clay | Mississippi | 28025 | 360 | 13 |
384142 | 384142 | 2020-07-30 | Coahoma | Mississippi | 28027 | 626 | 7 |
384143 | 384143 | 2020-07-30 | Copiah | Mississippi | 28029 | 885 | 23 |
384144 | 384144 | 2020-07-30 | Covington | Mississippi | 28031 | 569 | 10 |
384145 | 384145 | 2020-07-30 | DeSoto | Mississippi | 28033 | 3062 | 26 |
384146 | 384146 | 2020-07-30 | Forrest | Mississippi | 28035 | 1540 | 50 |
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);