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 392
- 28029 390
- 28083 390
- 28109 390
- 28049 388
- 28045 387
- 28095 387
- 28047 386
- 28059 386
- 28011 385
- 28027 385
- 28033 385
- 28089 385
- 28111 385
- 28051 384
- 28067 384
- 28123 384
- 28147 384
- 28157 384
- 28159 384
- 28163 384
- 28001 383
- 28037 383
- 28053 383
- 28071 383
- 28077 383
- 28081 383
- 28093 383
- 28113 383
- 28121 383
- …
county >30
- Forrest 392
- Copiah 390
- Leflore 390
- Pearl River 390
- Hinds 388
- Hancock 387
- Monroe 387
- Harrison 386
- Jackson 386
- Bolivar 385
- Coahoma 385
- DeSoto 385
- Madison 385
- Perry 385
- Holmes 384
- Jones 384
- Scott 384
- Walthall 384
- Wilkinson 384
- Winston 384
- Yazoo 384
- Adams 383
- Franklin 383
- Humphreys 383
- Lafayette 383
- Lawrence 383
- Lee 383
- Marshall 383
- Pike 383
- Rankin 383
- …
state 1
- Mississippi · 31,126 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194523 | 1194523 | 2021-04-06 | Adams | Mississippi | 28001 | 2438 | 82 |
1194524 | 1194524 | 2021-04-06 | Alcorn | Mississippi | 28003 | 2967 | 63 |
1194525 | 1194525 | 2021-04-06 | Amite | Mississippi | 28005 | 1189 | 39 |
1194526 | 1194526 | 2021-04-06 | Attala | Mississippi | 28007 | 2129 | 73 |
1194527 | 1194527 | 2021-04-06 | Benton | Mississippi | 28009 | 969 | 25 |
1194528 | 1194528 | 2021-04-06 | Bolivar | Mississippi | 28011 | 4765 | 128 |
1194529 | 1194529 | 2021-04-06 | Calhoun | Mississippi | 28013 | 1627 | 30 |
1194530 | 1194530 | 2021-04-06 | Carroll | Mississippi | 28015 | 1205 | 26 |
1194531 | 1194531 | 2021-04-06 | Chickasaw | Mississippi | 28017 | 2046 | 57 |
1194532 | 1194532 | 2021-04-06 | Choctaw | Mississippi | 28019 | 726 | 16 |
1194533 | 1194533 | 2021-04-06 | Claiborne | Mississippi | 28021 | 1012 | 30 |
1194534 | 1194534 | 2021-04-06 | Clarke | Mississippi | 28023 | 1760 | 75 |
1194535 | 1194535 | 2021-04-06 | Clay | Mississippi | 28025 | 1821 | 54 |
1194536 | 1194536 | 2021-04-06 | Coahoma | Mississippi | 28027 | 2890 | 77 |
1194537 | 1194537 | 2021-04-06 | Copiah | Mississippi | 28029 | 2917 | 63 |
1194538 | 1194538 | 2021-04-06 | Covington | Mississippi | 28031 | 2542 | 80 |
1194539 | 1194539 | 2021-04-06 | DeSoto | Mississippi | 28033 | 20648 | 248 |
1194540 | 1194540 | 2021-04-06 | Forrest | Mississippi | 28035 | 7506 | 146 |
1194541 | 1194541 | 2021-04-06 | Franklin | Mississippi | 28037 | 810 | 23 |
1194542 | 1194542 | 2021-04-06 | George | Mississippi | 28039 | 2368 | 46 |
1194543 | 1194543 | 2021-04-06 | Greene | Mississippi | 28041 | 1293 | 33 |
1194544 | 1194544 | 2021-04-06 | Grenada | Mississippi | 28043 | 2534 | 80 |
1194545 | 1194545 | 2021-04-06 | Hancock | Mississippi | 28045 | 3706 | 84 |
1194546 | 1194546 | 2021-04-06 | Harrison | Mississippi | 28047 | 17433 | 300 |
1194547 | 1194547 | 2021-04-06 | Hinds | Mississippi | 28049 | 19779 | 406 |
1194548 | 1194548 | 2021-04-06 | Holmes | Mississippi | 28051 | 1857 | 71 |
1194549 | 1194549 | 2021-04-06 | Humphreys | Mississippi | 28053 | 942 | 32 |
1194550 | 1194550 | 2021-04-06 | Issaquena | Mississippi | 28055 | 168 | 6 |
1194551 | 1194551 | 2021-04-06 | Itawamba | Mississippi | 28057 | 2962 | 76 |
1194552 | 1194552 | 2021-04-06 | Jackson | Mississippi | 28059 | 13056 | 243 |
1194553 | 1194553 | 2021-04-06 | Jasper | Mississippi | 28061 | 2196 | 48 |
1194554 | 1194554 | 2021-04-06 | Jefferson | Mississippi | 28063 | 646 | 28 |
1194555 | 1194555 | 2021-04-06 | Jefferson Davis | Mississippi | 28065 | 1046 | 32 |
1194556 | 1194556 | 2021-04-06 | Jones | Mississippi | 28067 | 8272 | 160 |
1194557 | 1194557 | 2021-04-06 | Kemper | Mississippi | 28069 | 949 | 25 |
1194558 | 1194558 | 2021-04-06 | Lafayette | Mississippi | 28071 | 5991 | 116 |
1194559 | 1194559 | 2021-04-06 | Lamar | Mississippi | 28073 | 6080 | 84 |
1194560 | 1194560 | 2021-04-06 | Lauderdale | Mississippi | 28075 | 7131 | 237 |
1194561 | 1194561 | 2021-04-06 | Lawrence | Mississippi | 28077 | 1258 | 23 |
1194562 | 1194562 | 2021-04-06 | Leake | Mississippi | 28079 | 2603 | 73 |
1194563 | 1194563 | 2021-04-06 | Lee | Mississippi | 28081 | 9831 | 169 |
1194564 | 1194564 | 2021-04-06 | Leflore | Mississippi | 28083 | 3466 | 124 |
1194565 | 1194565 | 2021-04-06 | Lincoln | Mississippi | 28085 | 3862 | 107 |
1194566 | 1194566 | 2021-04-06 | Lowndes | Mississippi | 28087 | 6238 | 144 |
1194567 | 1194567 | 2021-04-06 | Madison | Mississippi | 28089 | 9859 | 209 |
1194568 | 1194568 | 2021-04-06 | Marion | Mississippi | 28091 | 2649 | 79 |
1194569 | 1194569 | 2021-04-06 | Marshall | Mississippi | 28093 | 4250 | 100 |
1194570 | 1194570 | 2021-04-06 | Monroe | Mississippi | 28095 | 4053 | 131 |
1194571 | 1194571 | 2021-04-06 | Montgomery | Mississippi | 28097 | 1252 | 42 |
1194572 | 1194572 | 2021-04-06 | Neshoba | Mississippi | 28099 | 3971 | 175 |
1194573 | 1194573 | 2021-04-06 | Newton | Mississippi | 28101 | 2440 | 59 |
1194574 | 1194574 | 2021-04-06 | Noxubee | Mississippi | 28103 | 1255 | 32 |
1194575 | 1194575 | 2021-04-06 | Oktibbeha | Mississippi | 28105 | 4542 | 97 |
1194576 | 1194576 | 2021-04-06 | Panola | Mississippi | 28107 | 4427 | 103 |
1194577 | 1194577 | 2021-04-06 | Pearl River | Mississippi | 28109 | 4396 | 139 |
1194578 | 1194578 | 2021-04-06 | Perry | Mississippi | 28111 | 1248 | 38 |
1194579 | 1194579 | 2021-04-06 | Pike | Mississippi | 28113 | 3162 | 104 |
1194580 | 1194580 | 2021-04-06 | Pontotoc | Mississippi | 28115 | 4158 | 72 |
1194581 | 1194581 | 2021-04-06 | Prentiss | Mississippi | 28117 | 2749 | 59 |
1194582 | 1194582 | 2021-04-06 | Quitman | Mississippi | 28119 | 785 | 16 |
1194583 | 1194583 | 2021-04-06 | Rankin | Mississippi | 28121 | 13270 | 275 |
1194584 | 1194584 | 2021-04-06 | Scott | Mississippi | 28123 | 3090 | 72 |
1194585 | 1194585 | 2021-04-06 | Sharkey | Mississippi | 28125 | 495 | 17 |
1194586 | 1194586 | 2021-04-06 | Simpson | Mississippi | 28127 | 2867 | 84 |
1194587 | 1194587 | 2021-04-06 | Smith | Mississippi | 28129 | 1576 | 34 |
1194588 | 1194588 | 2021-04-06 | Stone | Mississippi | 28131 | 1777 | 31 |
1194589 | 1194589 | 2021-04-06 | Sunflower | Mississippi | 28133 | 3286 | 89 |
1194590 | 1194590 | 2021-04-06 | Tallahatchie | Mississippi | 28135 | 1751 | 40 |
1194591 | 1194591 | 2021-04-06 | Tate | Mississippi | 28137 | 3206 | 81 |
1194592 | 1194592 | 2021-04-06 | Tippah | Mississippi | 28139 | 2838 | 68 |
1194593 | 1194593 | 2021-04-06 | Tishomingo | Mississippi | 28141 | 2217 | 67 |
1194594 | 1194594 | 2021-04-06 | Tunica | Mississippi | 28143 | 1023 | 25 |
1194595 | 1194595 | 2021-04-06 | Union | Mississippi | 28145 | 4023 | 75 |
1194596 | 1194596 | 2021-04-06 | Walthall | Mississippi | 28147 | 1300 | 43 |
1194597 | 1194597 | 2021-04-06 | Warren | Mississippi | 28149 | 4272 | 118 |
1194598 | 1194598 | 2021-04-06 | Washington | Mississippi | 28151 | 5270 | 132 |
1194599 | 1194599 | 2021-04-06 | Wayne | Mississippi | 28153 | 2611 | 41 |
1194600 | 1194600 | 2021-04-06 | Webster | Mississippi | 28155 | 1134 | 32 |
1194601 | 1194601 | 2021-04-06 | Wilkinson | Mississippi | 28157 | 642 | 27 |
1194602 | 1194602 | 2021-04-06 | Winston | Mississippi | 28159 | 2257 | 81 |
1194603 | 1194603 | 2021-04-06 | Yalobusha | Mississippi | 28161 | 1574 | 36 |
1194604 | 1194604 | 2021-04-06 | Yazoo | Mississippi | 28163 | 3032 | 68 |
1191274 | 1191274 | 2021-04-05 | Adams | Mississippi | 28001 | 2435 | 82 |
1191275 | 1191275 | 2021-04-05 | Alcorn | Mississippi | 28003 | 2966 | 63 |
1191276 | 1191276 | 2021-04-05 | Amite | Mississippi | 28005 | 1186 | 39 |
1191277 | 1191277 | 2021-04-05 | Attala | Mississippi | 28007 | 2129 | 73 |
1191278 | 1191278 | 2021-04-05 | Benton | Mississippi | 28009 | 968 | 25 |
1191279 | 1191279 | 2021-04-05 | Bolivar | Mississippi | 28011 | 4765 | 128 |
1191280 | 1191280 | 2021-04-05 | Calhoun | Mississippi | 28013 | 1627 | 30 |
1191281 | 1191281 | 2021-04-05 | Carroll | Mississippi | 28015 | 1205 | 26 |
1191282 | 1191282 | 2021-04-05 | Chickasaw | Mississippi | 28017 | 2046 | 57 |
1191283 | 1191283 | 2021-04-05 | Choctaw | Mississippi | 28019 | 725 | 16 |
1191284 | 1191284 | 2021-04-05 | Claiborne | Mississippi | 28021 | 1012 | 30 |
1191285 | 1191285 | 2021-04-05 | Clarke | Mississippi | 28023 | 1759 | 75 |
1191286 | 1191286 | 2021-04-05 | Clay | Mississippi | 28025 | 1821 | 54 |
1191287 | 1191287 | 2021-04-05 | Coahoma | Mississippi | 28027 | 2888 | 76 |
1191288 | 1191288 | 2021-04-05 | Copiah | Mississippi | 28029 | 2916 | 62 |
1191289 | 1191289 | 2021-04-05 | Covington | Mississippi | 28031 | 2539 | 80 |
1191290 | 1191290 | 2021-04-05 | DeSoto | Mississippi | 28033 | 20638 | 248 |
1191291 | 1191291 | 2021-04-05 | Forrest | Mississippi | 28035 | 7502 | 145 |
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);