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
county >30
- Forrest 85
- Copiah 83
- Leflore 83
- Pearl River 83
- Hinds 81
- Hancock 80
- Monroe 80
- Harrison 79
- Jackson 79
- Bolivar 78
- Coahoma 78
- DeSoto 78
- Madison 78
- Perry 78
- Holmes 77
- Jones 77
- Scott 77
- Walthall 77
- Wilkinson 77
- Winston 77
- Yazoo 77
- Adams 76
- Franklin 76
- Humphreys 76
- Lafayette 76
- Lawrence 76
- Lee 76
- Marshall 76
- Pike 76
- Rankin 76
- …
state 1
- Mississippi · 5,964 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
204365 | 204365 | 2020-06-03 | Adams | Mississippi | 28001 | 202 | 16 |
204366 | 204366 | 2020-06-03 | Alcorn | Mississippi | 28003 | 19 | 1 |
204367 | 204367 | 2020-06-03 | Amite | Mississippi | 28005 | 65 | 1 |
204368 | 204368 | 2020-06-03 | Attala | Mississippi | 28007 | 307 | 18 |
204369 | 204369 | 2020-06-03 | Benton | Mississippi | 28009 | 14 | 0 |
204370 | 204370 | 2020-06-03 | Bolivar | Mississippi | 28011 | 166 | 11 |
204371 | 204371 | 2020-06-03 | Calhoun | Mississippi | 28013 | 67 | 4 |
204372 | 204372 | 2020-06-03 | Carroll | Mississippi | 28015 | 116 | 11 |
204373 | 204373 | 2020-06-03 | Chickasaw | Mississippi | 28017 | 140 | 14 |
204374 | 204374 | 2020-06-03 | Choctaw | Mississippi | 28019 | 48 | 2 |
204375 | 204375 | 2020-06-03 | Claiborne | Mississippi | 28021 | 114 | 5 |
204376 | 204376 | 2020-06-03 | Clarke | Mississippi | 28023 | 155 | 19 |
204377 | 204377 | 2020-06-03 | Clay | Mississippi | 28025 | 118 | 4 |
204378 | 204378 | 2020-06-03 | Coahoma | Mississippi | 28027 | 128 | 4 |
204379 | 204379 | 2020-06-03 | Copiah | Mississippi | 28029 | 325 | 4 |
204380 | 204380 | 2020-06-03 | Covington | Mississippi | 28031 | 177 | 2 |
204381 | 204381 | 2020-06-03 | DeSoto | Mississippi | 28033 | 559 | 8 |
204382 | 204382 | 2020-06-03 | Forrest | Mississippi | 28035 | 592 | 39 |
204383 | 204383 | 2020-06-03 | Franklin | Mississippi | 28037 | 29 | 2 |
204384 | 204384 | 2020-06-03 | George | Mississippi | 28039 | 28 | 1 |
204385 | 204385 | 2020-06-03 | Greene | Mississippi | 28041 | 33 | 1 |
204386 | 204386 | 2020-06-03 | Grenada | Mississippi | 28043 | 100 | 3 |
204387 | 204387 | 2020-06-03 | Hancock | Mississippi | 28045 | 90 | 12 |
204388 | 204388 | 2020-06-03 | Harrison | Mississippi | 28047 | 265 | 7 |
204389 | 204389 | 2020-06-03 | Hinds | Mississippi | 28049 | 1066 | 26 |
204390 | 204390 | 2020-06-03 | Holmes | Mississippi | 28051 | 441 | 30 |
204391 | 204391 | 2020-06-03 | Humphreys | Mississippi | 28053 | 60 | 7 |
204392 | 204392 | 2020-06-03 | Itawamba | Mississippi | 28057 | 90 | 7 |
204393 | 204393 | 2020-06-03 | Jackson | Mississippi | 28059 | 309 | 14 |
204394 | 204394 | 2020-06-03 | Jasper | Mississippi | 28061 | 166 | 4 |
204395 | 204395 | 2020-06-03 | Jefferson | Mississippi | 28063 | 42 | 1 |
204396 | 204396 | 2020-06-03 | Jefferson Davis | Mississippi | 28065 | 81 | 3 |
204397 | 204397 | 2020-06-03 | Jones | Mississippi | 28067 | 686 | 32 |
204398 | 204398 | 2020-06-03 | Kemper | Mississippi | 28069 | 149 | 11 |
204399 | 204399 | 2020-06-03 | Lafayette | Mississippi | 28071 | 150 | 4 |
204400 | 204400 | 2020-06-03 | Lamar | Mississippi | 28073 | 248 | 5 |
204401 | 204401 | 2020-06-03 | Lauderdale | Mississippi | 28075 | 760 | 68 |
204402 | 204402 | 2020-06-03 | Lawrence | Mississippi | 28077 | 108 | 1 |
204403 | 204403 | 2020-06-03 | Leake | Mississippi | 28079 | 454 | 12 |
204404 | 204404 | 2020-06-03 | Lee | Mississippi | 28081 | 185 | 7 |
204405 | 204405 | 2020-06-03 | Leflore | Mississippi | 28083 | 273 | 36 |
204406 | 204406 | 2020-06-03 | Lincoln | Mississippi | 28085 | 278 | 29 |
204407 | 204407 | 2020-06-03 | Lowndes | Mississippi | 28087 | 241 | 9 |
204408 | 204408 | 2020-06-03 | Madison | Mississippi | 28089 | 757 | 27 |
204409 | 204409 | 2020-06-03 | Marion | Mississippi | 28091 | 116 | 9 |
204410 | 204410 | 2020-06-03 | Marshall | Mississippi | 28093 | 85 | 3 |
204411 | 204411 | 2020-06-03 | Monroe | Mississippi | 28095 | 267 | 25 |
204412 | 204412 | 2020-06-03 | Montgomery | Mississippi | 28097 | 86 | 1 |
204413 | 204413 | 2020-06-03 | Neshoba | Mississippi | 28099 | 722 | 44 |
204414 | 204414 | 2020-06-03 | Newton | Mississippi | 28101 | 283 | 4 |
204415 | 204415 | 2020-06-03 | Noxubee | Mississippi | 28103 | 193 | 6 |
204416 | 204416 | 2020-06-03 | Oktibbeha | Mississippi | 28105 | 267 | 14 |
204417 | 204417 | 2020-06-03 | Panola | Mississippi | 28107 | 85 | 3 |
204418 | 204418 | 2020-06-03 | Pearl River | Mississippi | 28109 | 212 | 31 |
204419 | 204419 | 2020-06-03 | Perry | Mississippi | 28111 | 51 | 3 |
204420 | 204420 | 2020-06-03 | Pike | Mississippi | 28113 | 205 | 11 |
204421 | 204421 | 2020-06-03 | Pontotoc | Mississippi | 28115 | 45 | 3 |
204422 | 204422 | 2020-06-03 | Prentiss | Mississippi | 28117 | 53 | 3 |
204423 | 204423 | 2020-06-03 | Quitman | Mississippi | 28119 | 31 | 0 |
204424 | 204424 | 2020-06-03 | Rankin | Mississippi | 28121 | 453 | 8 |
204425 | 204425 | 2020-06-03 | Scott | Mississippi | 28123 | 662 | 12 |
204426 | 204426 | 2020-06-03 | Sharkey | Mississippi | 28125 | 7 | 0 |
204427 | 204427 | 2020-06-03 | Simpson | Mississippi | 28127 | 104 | 0 |
204428 | 204428 | 2020-06-03 | Smith | Mississippi | 28129 | 153 | 11 |
204429 | 204429 | 2020-06-03 | Stone | Mississippi | 28131 | 32 | 0 |
204430 | 204430 | 2020-06-03 | Sunflower | Mississippi | 28133 | 93 | 3 |
204431 | 204431 | 2020-06-03 | Tallahatchie | Mississippi | 28135 | 30 | 1 |
204432 | 204432 | 2020-06-03 | Tate | Mississippi | 28137 | 88 | 1 |
204433 | 204433 | 2020-06-03 | Tippah | Mississippi | 28139 | 76 | 11 |
204434 | 204434 | 2020-06-03 | Tishomingo | Mississippi | 28141 | 35 | 0 |
204435 | 204435 | 2020-06-03 | Tunica | Mississippi | 28143 | 56 | 3 |
204436 | 204436 | 2020-06-03 | Union | Mississippi | 28145 | 86 | 7 |
204437 | 204437 | 2020-06-03 | Walthall | Mississippi | 28147 | 63 | 0 |
204438 | 204438 | 2020-06-03 | Warren | Mississippi | 28149 | 191 | 10 |
204439 | 204439 | 2020-06-03 | Washington | Mississippi | 28151 | 194 | 7 |
204440 | 204440 | 2020-06-03 | Wayne | Mississippi | 28153 | 235 | 3 |
204441 | 204441 | 2020-06-03 | Webster | Mississippi | 28155 | 67 | 3 |
204442 | 204442 | 2020-06-03 | Wilkinson | Mississippi | 28157 | 85 | 9 |
204443 | 204443 | 2020-06-03 | Winston | Mississippi | 28159 | 122 | 1 |
204444 | 204444 | 2020-06-03 | Yalobusha | Mississippi | 28161 | 97 | 6 |
204445 | 204445 | 2020-06-03 | Yazoo | Mississippi | 28163 | 291 | 4 |
201288 | 201288 | 2020-06-02 | Adams | Mississippi | 28001 | 200 | 15 |
201289 | 201289 | 2020-06-02 | Alcorn | Mississippi | 28003 | 18 | 1 |
201290 | 201290 | 2020-06-02 | Amite | Mississippi | 28005 | 64 | 1 |
201291 | 201291 | 2020-06-02 | Attala | Mississippi | 28007 | 303 | 18 |
201292 | 201292 | 2020-06-02 | Benton | Mississippi | 28009 | 14 | 0 |
201293 | 201293 | 2020-06-02 | Bolivar | Mississippi | 28011 | 165 | 11 |
201294 | 201294 | 2020-06-02 | Calhoun | Mississippi | 28013 | 67 | 4 |
201295 | 201295 | 2020-06-02 | Carroll | Mississippi | 28015 | 116 | 11 |
201296 | 201296 | 2020-06-02 | Chickasaw | Mississippi | 28017 | 137 | 14 |
201297 | 201297 | 2020-06-02 | Choctaw | Mississippi | 28019 | 47 | 2 |
201298 | 201298 | 2020-06-02 | Claiborne | Mississippi | 28021 | 112 | 2 |
201299 | 201299 | 2020-06-02 | Clarke | Mississippi | 28023 | 154 | 19 |
201300 | 201300 | 2020-06-02 | Clay | Mississippi | 28025 | 115 | 4 |
201301 | 201301 | 2020-06-02 | Coahoma | Mississippi | 28027 | 127 | 4 |
201302 | 201302 | 2020-06-02 | Copiah | Mississippi | 28029 | 315 | 4 |
201303 | 201303 | 2020-06-02 | Covington | Mississippi | 28031 | 173 | 2 |
201304 | 201304 | 2020-06-02 | DeSoto | Mississippi | 28033 | 553 | 8 |
201305 | 201305 | 2020-06-02 | Forrest | Mississippi | 28035 | 594 | 39 |
201306 | 201306 | 2020-06-02 | Franklin | Mississippi | 28037 | 29 | 2 |
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);