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 582
- 28029 580
- 28083 580
- 28109 580
- 28049 578
- 28045 577
- 28095 577
- 28047 576
- 28059 576
- 28011 575
- 28027 575
- 28033 575
- 28089 575
- 28111 575
- 28051 574
- 28067 574
- 28123 574
- 28147 574
- 28157 574
- 28159 574
- 28163 574
- 28001 573
- 28037 573
- 28053 573
- 28071 573
- 28077 573
- 28081 573
- 28093 573
- 28113 573
- 28121 573
- …
county >30
- Forrest 582
- Copiah 580
- Leflore 580
- Pearl River 580
- Hinds 578
- Hancock 577
- Monroe 577
- Harrison 576
- Jackson 576
- Bolivar 575
- Coahoma 575
- DeSoto 575
- Madison 575
- Perry 575
- Holmes 574
- Jones 574
- Scott 574
- Walthall 574
- Wilkinson 574
- Winston 574
- Yazoo 574
- Adams 573
- Franklin 573
- Humphreys 573
- Lafayette 573
- Lawrence 573
- Lee 573
- Marshall 573
- Pike 573
- Rankin 573
- …
state 1
- Mississippi · 46,706 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811533 | 1811533 | 2021-10-13 | Adams | Mississippi | 28001 | 4567 | 119 |
1811534 | 1811534 | 2021-10-13 | Alcorn | Mississippi | 28003 | 5623 | 100 |
1811535 | 1811535 | 2021-10-13 | Amite | Mississippi | 28005 | 2033 | 54 |
1811536 | 1811536 | 2021-10-13 | Attala | Mississippi | 28007 | 3299 | 89 |
1811537 | 1811537 | 2021-10-13 | Benton | Mississippi | 28009 | 1470 | 38 |
1811538 | 1811538 | 2021-10-13 | Bolivar | Mississippi | 28011 | 6259 | 145 |
1811539 | 1811539 | 2021-10-13 | Calhoun | Mississippi | 28013 | 2771 | 45 |
1811540 | 1811540 | 2021-10-13 | Carroll | Mississippi | 28015 | 1670 | 38 |
1811541 | 1811541 | 2021-10-13 | Chickasaw | Mississippi | 28017 | 2959 | 67 |
1811542 | 1811542 | 2021-10-13 | Choctaw | Mississippi | 28019 | 1329 | 26 |
1811543 | 1811543 | 2021-10-13 | Claiborne | Mississippi | 28021 | 1305 | 37 |
1811544 | 1811544 | 2021-10-13 | Clarke | Mississippi | 28023 | 2895 | 94 |
1811545 | 1811545 | 2021-10-13 | Clay | Mississippi | 28025 | 3054 | 75 |
1811546 | 1811546 | 2021-10-13 | Coahoma | Mississippi | 28027 | 4110 | 104 |
1811547 | 1811547 | 2021-10-13 | Copiah | Mississippi | 28029 | 4444 | 91 |
1811548 | 1811548 | 2021-10-13 | Covington | Mississippi | 28031 | 4266 | 94 |
1811549 | 1811549 | 2021-10-13 | DeSoto | Mississippi | 28033 | 31773 | 397 |
1811550 | 1811550 | 2021-10-13 | Forrest | Mississippi | 28035 | 13398 | 251 |
1811551 | 1811551 | 2021-10-13 | Franklin | Mississippi | 28037 | 1189 | 28 |
1811552 | 1811552 | 2021-10-13 | George | Mississippi | 28039 | 4899 | 79 |
1811553 | 1811553 | 2021-10-13 | Greene | Mississippi | 28041 | 2148 | 48 |
1811554 | 1811554 | 2021-10-13 | Grenada | Mississippi | 28043 | 3680 | 108 |
1811555 | 1811555 | 2021-10-13 | Hancock | Mississippi | 28045 | 7685 | 126 |
1811556 | 1811556 | 2021-10-13 | Harrison | Mississippi | 28047 | 34022 | 530 |
1811557 | 1811557 | 2021-10-13 | Hinds | Mississippi | 28049 | 31778 | 621 |
1811558 | 1811558 | 2021-10-13 | Holmes | Mississippi | 28051 | 2662 | 87 |
1811559 | 1811559 | 2021-10-13 | Humphreys | Mississippi | 28053 | 1287 | 38 |
1811560 | 1811560 | 2021-10-13 | Issaquena | Mississippi | 28055 | 193 | 7 |
1811561 | 1811561 | 2021-10-13 | Itawamba | Mississippi | 28057 | 4584 | 104 |
1811562 | 1811562 | 2021-10-13 | Jackson | Mississippi | 28059 | 24289 | 377 |
1811563 | 1811563 | 2021-10-13 | Jasper | Mississippi | 28061 | 3276 | 65 |
1811564 | 1811564 | 2021-10-13 | Jefferson | Mississippi | 28063 | 943 | 34 |
1811565 | 1811565 | 2021-10-13 | Jefferson Davis | Mississippi | 28065 | 1706 | 42 |
1811566 | 1811566 | 2021-10-13 | Jones | Mississippi | 28067 | 13759 | 241 |
1811567 | 1811567 | 2021-10-13 | Kemper | Mississippi | 28069 | 1412 | 41 |
1811568 | 1811568 | 2021-10-13 | Lafayette | Mississippi | 28071 | 8443 | 137 |
1811569 | 1811569 | 2021-10-13 | Lamar | Mississippi | 28073 | 10452 | 135 |
1811570 | 1811570 | 2021-10-13 | Lauderdale | Mississippi | 28075 | 11933 | 314 |
1811571 | 1811571 | 2021-10-13 | Lawrence | Mississippi | 28077 | 2110 | 39 |
1811572 | 1811572 | 2021-10-13 | Leake | Mississippi | 28079 | 4072 | 87 |
1811573 | 1811573 | 2021-10-13 | Lee | Mississippi | 28081 | 15398 | 233 |
1811574 | 1811574 | 2021-10-13 | Leflore | Mississippi | 28083 | 4621 | 142 |
1811575 | 1811575 | 2021-10-13 | Lincoln | Mississippi | 28085 | 5412 | 134 |
1811576 | 1811576 | 2021-10-13 | Lowndes | Mississippi | 28087 | 10873 | 184 |
1811577 | 1811577 | 2021-10-13 | Madison | Mississippi | 28089 | 14507 | 278 |
1811578 | 1811578 | 2021-10-13 | Marion | Mississippi | 28091 | 4205 | 106 |
1811579 | 1811579 | 2021-10-13 | Marshall | Mississippi | 28093 | 6365 | 132 |
1811580 | 1811580 | 2021-10-13 | Monroe | Mississippi | 28095 | 6702 | 173 |
1811581 | 1811581 | 2021-10-13 | Montgomery | Mississippi | 28097 | 1788 | 56 |
1811582 | 1811582 | 2021-10-13 | Neshoba | Mississippi | 28099 | 6604 | 204 |
1811583 | 1811583 | 2021-10-13 | Newton | Mississippi | 28101 | 3808 | 79 |
1811584 | 1811584 | 2021-10-13 | Noxubee | Mississippi | 28103 | 1848 | 40 |
1811585 | 1811585 | 2021-10-13 | Oktibbeha | Mississippi | 28105 | 7107 | 128 |
1811586 | 1811586 | 2021-10-13 | Panola | Mississippi | 28107 | 6455 | 130 |
1811587 | 1811587 | 2021-10-13 | Pearl River | Mississippi | 28109 | 9410 | 237 |
1811588 | 1811588 | 2021-10-13 | Perry | Mississippi | 28111 | 2043 | 54 |
1811589 | 1811589 | 2021-10-13 | Pike | Mississippi | 28113 | 5749 | 152 |
1811590 | 1811590 | 2021-10-13 | Pontotoc | Mississippi | 28115 | 6596 | 101 |
1811591 | 1811591 | 2021-10-13 | Prentiss | Mississippi | 28117 | 4640 | 81 |
1811592 | 1811592 | 2021-10-13 | Quitman | Mississippi | 28119 | 1057 | 27 |
1811593 | 1811593 | 2021-10-13 | Rankin | Mississippi | 28121 | 21834 | 387 |
1811594 | 1811594 | 2021-10-13 | Scott | Mississippi | 28123 | 4703 | 98 |
1811595 | 1811595 | 2021-10-13 | Sharkey | Mississippi | 28125 | 639 | 20 |
1811596 | 1811596 | 2021-10-13 | Simpson | Mississippi | 28127 | 4413 | 116 |
1811597 | 1811597 | 2021-10-13 | Smith | Mississippi | 28129 | 2622 | 50 |
1811598 | 1811598 | 2021-10-13 | Stone | Mississippi | 28131 | 3578 | 64 |
1811599 | 1811599 | 2021-10-13 | Sunflower | Mississippi | 28133 | 4214 | 104 |
1811600 | 1811600 | 2021-10-13 | Tallahatchie | Mississippi | 28135 | 2250 | 51 |
1811601 | 1811601 | 2021-10-13 | Tate | Mississippi | 28137 | 4534 | 108 |
1811602 | 1811602 | 2021-10-13 | Tippah | Mississippi | 28139 | 4646 | 81 |
1811603 | 1811603 | 2021-10-13 | Tishomingo | Mississippi | 28141 | 3554 | 91 |
1811604 | 1811604 | 2021-10-13 | Tunica | Mississippi | 28143 | 1584 | 39 |
1811605 | 1811605 | 2021-10-13 | Union | Mississippi | 28145 | 5937 | 94 |
1811606 | 1811606 | 2021-10-13 | Walthall | Mississippi | 28147 | 2174 | 63 |
1811607 | 1811607 | 2021-10-13 | Warren | Mississippi | 28149 | 6632 | 175 |
1811608 | 1811608 | 2021-10-13 | Washington | Mississippi | 28151 | 7353 | 156 |
1811609 | 1811609 | 2021-10-13 | Wayne | Mississippi | 28153 | 4381 | 72 |
1811610 | 1811610 | 2021-10-13 | Webster | Mississippi | 28155 | 2015 | 45 |
1811611 | 1811611 | 2021-10-13 | Wilkinson | Mississippi | 28157 | 1037 | 39 |
1811612 | 1811612 | 2021-10-13 | Winston | Mississippi | 28159 | 3126 | 91 |
1811613 | 1811613 | 2021-10-13 | Yalobusha | Mississippi | 28161 | 2323 | 47 |
1811614 | 1811614 | 2021-10-13 | Yazoo | Mississippi | 28163 | 4367 | 86 |
1808284 | 1808284 | 2021-10-12 | Adams | Mississippi | 28001 | 4563 | 119 |
1808285 | 1808285 | 2021-10-12 | Alcorn | Mississippi | 28003 | 5616 | 98 |
1808286 | 1808286 | 2021-10-12 | Amite | Mississippi | 28005 | 2031 | 53 |
1808287 | 1808287 | 2021-10-12 | Attala | Mississippi | 28007 | 3295 | 89 |
1808288 | 1808288 | 2021-10-12 | Benton | Mississippi | 28009 | 1471 | 38 |
1808289 | 1808289 | 2021-10-12 | Bolivar | Mississippi | 28011 | 6248 | 145 |
1808290 | 1808290 | 2021-10-12 | Calhoun | Mississippi | 28013 | 2767 | 45 |
1808291 | 1808291 | 2021-10-12 | Carroll | Mississippi | 28015 | 1664 | 38 |
1808292 | 1808292 | 2021-10-12 | Chickasaw | Mississippi | 28017 | 2952 | 67 |
1808293 | 1808293 | 2021-10-12 | Choctaw | Mississippi | 28019 | 1328 | 26 |
1808294 | 1808294 | 2021-10-12 | Claiborne | Mississippi | 28021 | 1303 | 37 |
1808295 | 1808295 | 2021-10-12 | Clarke | Mississippi | 28023 | 2889 | 94 |
1808296 | 1808296 | 2021-10-12 | Clay | Mississippi | 28025 | 3046 | 75 |
1808297 | 1808297 | 2021-10-12 | Coahoma | Mississippi | 28027 | 4105 | 104 |
1808298 | 1808298 | 2021-10-12 | Copiah | Mississippi | 28029 | 4411 | 91 |
1808299 | 1808299 | 2021-10-12 | Covington | Mississippi | 28031 | 4263 | 93 |
1808300 | 1808300 | 2021-10-12 | DeSoto | Mississippi | 28033 | 31721 | 395 |
1808301 | 1808301 | 2021-10-12 | Forrest | Mississippi | 28035 | 13387 | 249 |
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);