ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2022-03-01 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2263411 | 2263411 | 2022-03-01 | Adams | Mississippi | 28001 | 7104 | 141 |
2263412 | 2263412 | 2022-03-01 | Alcorn | Mississippi | 28003 | 9863 | 148 |
2263413 | 2263413 | 2022-03-01 | Amite | Mississippi | 28005 | 3206 | 67 |
2263414 | 2263414 | 2022-03-01 | Attala | Mississippi | 28007 | 5227 | 111 |
2263415 | 2263415 | 2022-03-01 | Benton | Mississippi | 28009 | 2259 | 49 |
2263416 | 2263416 | 2022-03-01 | Bolivar | Mississippi | 28011 | 9210 | 176 |
2263417 | 2263417 | 2022-03-01 | Calhoun | Mississippi | 28013 | 4632 | 69 |
2263418 | 2263418 | 2022-03-01 | Carroll | Mississippi | 28015 | 2548 | 50 |
2263419 | 2263419 | 2022-03-01 | Chickasaw | Mississippi | 28017 | 5567 | 95 |
2263420 | 2263420 | 2022-03-01 | Choctaw | Mississippi | 28019 | 2197 | 33 |
2263421 | 2263421 | 2022-03-01 | Claiborne | Mississippi | 28021 | 2135 | 46 |
2263422 | 2263422 | 2022-03-01 | Clarke | Mississippi | 28023 | 4202 | 104 |
2263423 | 2263423 | 2022-03-01 | Clay | Mississippi | 28025 | 4932 | 96 |
2263424 | 2263424 | 2022-03-01 | Coahoma | Mississippi | 28027 | 6427 | 120 |
2263425 | 2263425 | 2022-03-01 | Copiah | Mississippi | 28029 | 7091 | 112 |
2263426 | 2263426 | 2022-03-01 | Covington | Mississippi | 28031 | 7049 | 108 |
2263427 | 2263427 | 2022-03-01 | DeSoto | Mississippi | 28033 | 49837 | 539 |
2263428 | 2263428 | 2022-03-01 | Forrest | Mississippi | 28035 | 21884 | 305 |
2263429 | 2263429 | 2022-03-01 | Franklin | Mississippi | 28037 | 1920 | 37 |
2263430 | 2263430 | 2022-03-01 | George | Mississippi | 28039 | 7111 | 86 |
2263431 | 2263431 | 2022-03-01 | Greene | Mississippi | 28041 | 3175 | 56 |
2263432 | 2263432 | 2022-03-01 | Grenada | Mississippi | 28043 | 5488 | 126 |
2263433 | 2263433 | 2022-03-01 | Hancock | Mississippi | 28045 | 12131 | 148 |
2263434 | 2263434 | 2022-03-01 | Harrison | Mississippi | 28047 | 53183 | 646 |
2263435 | 2263435 | 2022-03-01 | Hinds | Mississippi | 28049 | 51897 | 764 |
2263436 | 2263436 | 2022-03-01 | Holmes | Mississippi | 28051 | 4429 | 104 |
2263437 | 2263437 | 2022-03-01 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2263438 | 2263438 | 2022-03-01 | Issaquena | Mississippi | 28055 | 261 | 9 |
2263439 | 2263439 | 2022-03-01 | Itawamba | Mississippi | 28057 | 7350 | 142 |
2263440 | 2263440 | 2022-03-01 | Jackson | Mississippi | 28059 | 36723 | 441 |
2263441 | 2263441 | 2022-03-01 | Jasper | Mississippi | 28061 | 4792 | 73 |
2263442 | 2263442 | 2022-03-01 | Jefferson | Mississippi | 28063 | 1470 | 37 |
2263443 | 2263443 | 2022-03-01 | Jefferson Davis | Mississippi | 28065 | 2839 | 50 |
2263444 | 2263444 | 2022-03-01 | Jones | Mississippi | 28067 | 21094 | 287 |
2263445 | 2263445 | 2022-03-01 | Kemper | Mississippi | 28069 | 2161 | 47 |
2263446 | 2263446 | 2022-03-01 | Lafayette | Mississippi | 28071 | 15098 | 176 |
2263447 | 2263447 | 2022-03-01 | Lamar | Mississippi | 28073 | 17301 | 160 |
2263448 | 2263448 | 2022-03-01 | Lauderdale | Mississippi | 28075 | 18696 | 358 |
2263449 | 2263449 | 2022-03-01 | Lawrence | Mississippi | 28077 | 3561 | 54 |
2263450 | 2263450 | 2022-03-01 | Leake | Mississippi | 28079 | 6356 | 114 |
2263451 | 2263451 | 2022-03-01 | Lee | Mississippi | 28081 | 26498 | 292 |
2263452 | 2263452 | 2022-03-01 | Leflore | Mississippi | 28083 | 7285 | 166 |
2263453 | 2263453 | 2022-03-01 | Lincoln | Mississippi | 28085 | 8245 | 155 |
2263454 | 2263454 | 2022-03-01 | Lowndes | Mississippi | 28087 | 17448 | 232 |
2263455 | 2263455 | 2022-03-01 | Madison | Mississippi | 28089 | 23869 | 319 |
2263456 | 2263456 | 2022-03-01 | Marion | Mississippi | 28091 | 6932 | 134 |
2263457 | 2263457 | 2022-03-01 | Marshall | Mississippi | 28093 | 9868 | 172 |
2263458 | 2263458 | 2022-03-01 | Monroe | Mississippi | 28095 | 10927 | 214 |
2263459 | 2263459 | 2022-03-01 | Montgomery | Mississippi | 28097 | 2941 | 74 |
2263460 | 2263460 | 2022-03-01 | Neshoba | Mississippi | 28099 | 10500 | 234 |
2263461 | 2263461 | 2022-03-01 | Newton | Mississippi | 28101 | 5960 | 96 |
2263462 | 2263462 | 2022-03-01 | Noxubee | Mississippi | 28103 | 2713 | 48 |
2263463 | 2263463 | 2022-03-01 | Oktibbeha | Mississippi | 28105 | 11046 | 158 |
2263464 | 2263464 | 2022-03-01 | Panola | Mississippi | 28107 | 10359 | 165 |
2263465 | 2263465 | 2022-03-01 | Pearl River | Mississippi | 28109 | 14964 | 266 |
2263466 | 2263466 | 2022-03-01 | Perry | Mississippi | 28111 | 3031 | 63 |
2263467 | 2263467 | 2022-03-01 | Pike | Mississippi | 28113 | 9432 | 182 |
2263468 | 2263468 | 2022-03-01 | Pontotoc | Mississippi | 28115 | 10240 | 137 |
2263469 | 2263469 | 2022-03-01 | Prentiss | Mississippi | 28117 | 8139 | 103 |
2263470 | 2263470 | 2022-03-01 | Quitman | Mississippi | 28119 | 1559 | 31 |
2263471 | 2263471 | 2022-03-01 | Rankin | Mississippi | 28121 | 36319 | 474 |
2263472 | 2263472 | 2022-03-01 | Scott | Mississippi | 28123 | 6477 | 117 |
2263473 | 2263473 | 2022-03-01 | Sharkey | Mississippi | 28125 | 950 | 25 |
2263474 | 2263474 | 2022-03-01 | Simpson | Mississippi | 28127 | 6932 | 141 |
2263475 | 2263475 | 2022-03-01 | Smith | Mississippi | 28129 | 4078 | 66 |
2263476 | 2263476 | 2022-03-01 | Stone | Mississippi | 28131 | 5380 | 70 |
2263477 | 2263477 | 2022-03-01 | Sunflower | Mississippi | 28133 | 5731 | 120 |
2263478 | 2263478 | 2022-03-01 | Tallahatchie | Mississippi | 28135 | 3175 | 60 |
2263479 | 2263479 | 2022-03-01 | Tate | Mississippi | 28137 | 7251 | 139 |
2263480 | 2263480 | 2022-03-01 | Tippah | Mississippi | 28139 | 7182 | 106 |
2263481 | 2263481 | 2022-03-01 | Tishomingo | Mississippi | 28141 | 6092 | 122 |
2263482 | 2263482 | 2022-03-01 | Tunica | Mississippi | 28143 | 2506 | 45 |
2263483 | 2263483 | 2022-03-01 | Union | Mississippi | 28145 | 9438 | 116 |
2263484 | 2263484 | 2022-03-01 | Walthall | Mississippi | 28147 | 3570 | 78 |
2263485 | 2263485 | 2022-03-01 | Warren | Mississippi | 28149 | 10175 | 199 |
2263486 | 2263486 | 2022-03-01 | Washington | Mississippi | 28151 | 10217 | 194 |
2263487 | 2263487 | 2022-03-01 | Wayne | Mississippi | 28153 | 5935 | 84 |
2263488 | 2263488 | 2022-03-01 | Webster | Mississippi | 28155 | 3371 | 68 |
2263489 | 2263489 | 2022-03-01 | Wilkinson | Mississippi | 28157 | 1790 | 45 |
2263490 | 2263490 | 2022-03-01 | Winston | Mississippi | 28159 | 5185 | 103 |
2263491 | 2263491 | 2022-03-01 | Yalobusha | Mississippi | 28161 | 4050 | 56 |
2263492 | 2263492 | 2022-03-01 | Yazoo | Mississippi | 28163 | 7995 | 103 |
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);