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 350
- 28083 349
- 28109 349
- 28029 348
- 28049 346
- 28095 346
- 28045 345
- 28047 344
- 28059 344
- 28089 344
- 28111 344
- 28011 343
- 28027 343
- 28033 343
- 28123 343
- 28147 343
- 28157 343
- 28159 343
- 28163 343
- 28051 342
- 28067 342
- 28077 342
- 28081 342
- 28093 342
- 28113 342
- 28121 342
- 28129 342
- 28139 342
- 28001 341
- 28037 341
- …
county >30
- Forrest 350
- Leflore 349
- Pearl River 349
- Copiah 348
- Hinds 346
- Monroe 346
- Hancock 345
- Harrison 344
- Jackson 344
- Madison 344
- Perry 344
- Bolivar 343
- Coahoma 343
- DeSoto 343
- Scott 343
- Walthall 343
- Wilkinson 343
- Winston 343
- Yazoo 343
- Holmes 342
- Jones 342
- Lawrence 342
- Lee 342
- Marshall 342
- Pike 342
- Rankin 342
- Smith 342
- Tippah 342
- Adams 341
- Franklin 341
- …
state 1
- Mississippi · 27,728 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1061449 | 1061449 | 2021-02-24 | Lamar | Mississippi | 28073 | 5811 | 80 |
1061450 | 1061450 | 2021-02-24 | Lauderdale | Mississippi | 28075 | 6760 | 225 |
1061451 | 1061451 | 2021-02-24 | Lawrence | Mississippi | 28077 | 1190 | 21 |
1061452 | 1061452 | 2021-02-24 | Leake | Mississippi | 28079 | 2513 | 70 |
1061453 | 1061453 | 2021-02-24 | Lee | Mississippi | 28081 | 9641 | 160 |
1061454 | 1061454 | 2021-02-24 | Leflore | Mississippi | 28083 | 3349 | 118 |
1061455 | 1061455 | 2021-02-24 | Lincoln | Mississippi | 28085 | 3447 | 100 |
1061456 | 1061456 | 2021-02-24 | Lowndes | Mississippi | 28087 | 5998 | 137 |
1061457 | 1061457 | 2021-02-24 | Madison | Mississippi | 28089 | 9378 | 194 |
1061458 | 1061458 | 2021-02-24 | Marion | Mississippi | 28091 | 2498 | 78 |
1061459 | 1061459 | 2021-02-24 | Marshall | Mississippi | 28093 | 3983 | 92 |
1061460 | 1061460 | 2021-02-24 | Monroe | Mississippi | 28095 | 3977 | 126 |
1061461 | 1061461 | 2021-02-24 | Montgomery | Mississippi | 28097 | 1205 | 37 |
1061462 | 1061462 | 2021-02-24 | Neshoba | Mississippi | 28099 | 3758 | 166 |
1061463 | 1061463 | 2021-02-24 | Newton | Mississippi | 28101 | 2231 | 51 |
1061464 | 1061464 | 2021-02-24 | Noxubee | Mississippi | 28103 | 1226 | 29 |
1061465 | 1061465 | 2021-02-24 | Oktibbeha | Mississippi | 28105 | 4386 | 91 |
1061466 | 1061466 | 2021-02-24 | Panola | Mississippi | 28107 | 4249 | 92 |
1061467 | 1061467 | 2021-02-24 | Pearl River | Mississippi | 28109 | 4083 | 128 |
1061468 | 1061468 | 2021-02-24 | Perry | Mississippi | 28111 | 1209 | 34 |
1061469 | 1061469 | 2021-02-24 | Pike | Mississippi | 28113 | 2982 | 93 |
1061470 | 1061470 | 2021-02-24 | Pontotoc | Mississippi | 28115 | 4066 | 68 |
1061471 | 1061471 | 2021-02-24 | Prentiss | Mississippi | 28117 | 2676 | 58 |
1061472 | 1061472 | 2021-02-24 | Quitman | Mississippi | 28119 | 766 | 14 |
1061473 | 1061473 | 2021-02-24 | Rankin | Mississippi | 28121 | 12543 | 261 |
1061474 | 1061474 | 2021-02-24 | Scott | Mississippi | 28123 | 2918 | 67 |
1061475 | 1061475 | 2021-02-24 | Sharkey | Mississippi | 28125 | 488 | 17 |
1061476 | 1061476 | 2021-02-24 | Simpson | Mississippi | 28127 | 2707 | 78 |
1061477 | 1061477 | 2021-02-24 | Smith | Mississippi | 28129 | 1515 | 31 |
1061478 | 1061478 | 2021-02-24 | Stone | Mississippi | 28131 | 1711 | 29 |
1061479 | 1061479 | 2021-02-24 | Sunflower | Mississippi | 28133 | 3166 | 85 |
1061480 | 1061480 | 2021-02-24 | Tallahatchie | Mississippi | 28135 | 1692 | 39 |
1061481 | 1061481 | 2021-02-24 | Tate | Mississippi | 28137 | 2998 | 74 |
1061482 | 1061482 | 2021-02-24 | Tippah | Mississippi | 28139 | 2754 | 65 |
1061483 | 1061483 | 2021-02-24 | Tishomingo | Mississippi | 28141 | 2114 | 65 |
1061484 | 1061484 | 2021-02-24 | Tunica | Mississippi | 28143 | 980 | 23 |
1061485 | 1061485 | 2021-02-24 | Union | Mississippi | 28145 | 3921 | 73 |
1061486 | 1061486 | 2021-02-24 | Walthall | Mississippi | 28147 | 1233 | 40 |
1061487 | 1061487 | 2021-02-24 | Warren | Mississippi | 28149 | 4101 | 113 |
1061488 | 1061488 | 2021-02-24 | Washington | Mississippi | 28151 | 5135 | 128 |
1061489 | 1061489 | 2021-02-24 | Wayne | Mississippi | 28153 | 2505 | 40 |
1061490 | 1061490 | 2021-02-24 | Webster | Mississippi | 28155 | 1092 | 29 |
1061491 | 1061491 | 2021-02-24 | Wilkinson | Mississippi | 28157 | 622 | 26 |
1061492 | 1061492 | 2021-02-24 | Winston | Mississippi | 28159 | 2202 | 74 |
1061493 | 1061493 | 2021-02-24 | Yalobusha | Mississippi | 28161 | 1422 | 36 |
1061494 | 1061494 | 2021-02-24 | Yazoo | Mississippi | 28163 | 2832 | 62 |
1058167 | 1058167 | 2021-02-23 | Adams | Mississippi | 28001 | 2323 | 74 |
1058168 | 1058168 | 2021-02-23 | Alcorn | Mississippi | 28003 | 2897 | 60 |
1058169 | 1058169 | 2021-02-23 | Amite | Mississippi | 28005 | 1106 | 32 |
1058170 | 1058170 | 2021-02-23 | Attala | Mississippi | 28007 | 2056 | 69 |
1058171 | 1058171 | 2021-02-23 | Benton | Mississippi | 28009 | 925 | 24 |
1058172 | 1058172 | 2021-02-23 | Bolivar | Mississippi | 28011 | 4567 | 120 |
1058173 | 1058173 | 2021-02-23 | Calhoun | Mississippi | 28013 | 1553 | 27 |
1058174 | 1058174 | 2021-02-23 | Carroll | Mississippi | 28015 | 1171 | 23 |
1058175 | 1058175 | 2021-02-23 | Chickasaw | Mississippi | 28017 | 2002 | 50 |
1058176 | 1058176 | 2021-02-23 | Choctaw | Mississippi | 28019 | 693 | 16 |
1058177 | 1058177 | 2021-02-23 | Claiborne | Mississippi | 28021 | 973 | 29 |
1058178 | 1058178 | 2021-02-23 | Clarke | Mississippi | 28023 | 1676 | 71 |
1058179 | 1058179 | 2021-02-23 | Clay | Mississippi | 28025 | 1773 | 48 |
1058180 | 1058180 | 2021-02-23 | Coahoma | Mississippi | 28027 | 2722 | 65 |
1058181 | 1058181 | 2021-02-23 | Copiah | Mississippi | 28029 | 2733 | 57 |
1058182 | 1058182 | 2021-02-23 | Covington | Mississippi | 28031 | 2462 | 77 |
1058183 | 1058183 | 2021-02-23 | DeSoto | Mississippi | 28033 | 19470 | 226 |
1058184 | 1058184 | 2021-02-23 | Forrest | Mississippi | 28035 | 7055 | 135 |
1058185 | 1058185 | 2021-02-23 | Franklin | Mississippi | 28037 | 753 | 19 |
1058186 | 1058186 | 2021-02-23 | George | Mississippi | 28039 | 2295 | 45 |
1058187 | 1058187 | 2021-02-23 | Greene | Mississippi | 28041 | 1263 | 33 |
1058188 | 1058188 | 2021-02-23 | Grenada | Mississippi | 28043 | 2445 | 76 |
1058189 | 1058189 | 2021-02-23 | Hancock | Mississippi | 28045 | 3377 | 73 |
1058190 | 1058190 | 2021-02-23 | Harrison | Mississippi | 28047 | 16385 | 273 |
1058191 | 1058191 | 2021-02-23 | Hinds | Mississippi | 28049 | 18555 | 383 |
1058192 | 1058192 | 2021-02-23 | Holmes | Mississippi | 28051 | 1814 | 70 |
1058193 | 1058193 | 2021-02-23 | Humphreys | Mississippi | 28053 | 912 | 26 |
1058194 | 1058194 | 2021-02-23 | Issaquena | Mississippi | 28055 | 167 | 6 |
1058195 | 1058195 | 2021-02-23 | Itawamba | Mississippi | 28057 | 2884 | 71 |
1058196 | 1058196 | 2021-02-23 | Jackson | Mississippi | 28059 | 12401 | 216 |
1058197 | 1058197 | 2021-02-23 | Jasper | Mississippi | 28061 | 2103 | 43 |
1058198 | 1058198 | 2021-02-23 | Jefferson | Mississippi | 28063 | 608 | 27 |
1058199 | 1058199 | 2021-02-23 | Jefferson Davis | Mississippi | 28065 | 998 | 31 |
1058200 | 1058200 | 2021-02-23 | Jones | Mississippi | 28067 | 7836 | 144 |
1058201 | 1058201 | 2021-02-23 | Kemper | Mississippi | 28069 | 892 | 22 |
1058202 | 1058202 | 2021-02-23 | Lafayette | Mississippi | 28071 | 5688 | 113 |
1058203 | 1058203 | 2021-02-23 | Lamar | Mississippi | 28073 | 5793 | 79 |
1058204 | 1058204 | 2021-02-23 | Lauderdale | Mississippi | 28075 | 6735 | 225 |
1058205 | 1058205 | 2021-02-23 | Lawrence | Mississippi | 28077 | 1184 | 20 |
1058206 | 1058206 | 2021-02-23 | Leake | Mississippi | 28079 | 2508 | 70 |
1058207 | 1058207 | 2021-02-23 | Lee | Mississippi | 28081 | 9635 | 160 |
1058208 | 1058208 | 2021-02-23 | Leflore | Mississippi | 28083 | 3346 | 118 |
1058209 | 1058209 | 2021-02-23 | Lincoln | Mississippi | 28085 | 3437 | 99 |
1058210 | 1058210 | 2021-02-23 | Lowndes | Mississippi | 28087 | 5989 | 137 |
1058211 | 1058211 | 2021-02-23 | Madison | Mississippi | 28089 | 9353 | 193 |
1058212 | 1058212 | 2021-02-23 | Marion | Mississippi | 28091 | 2494 | 78 |
1058213 | 1058213 | 2021-02-23 | Marshall | Mississippi | 28093 | 3979 | 92 |
1058214 | 1058214 | 2021-02-23 | Monroe | Mississippi | 28095 | 3971 | 125 |
1058215 | 1058215 | 2021-02-23 | Montgomery | Mississippi | 28097 | 1205 | 37 |
1058216 | 1058216 | 2021-02-23 | Neshoba | Mississippi | 28099 | 3746 | 166 |
1058217 | 1058217 | 2021-02-23 | Newton | Mississippi | 28101 | 2225 | 51 |
1058218 | 1058218 | 2021-02-23 | Noxubee | Mississippi | 28103 | 1224 | 29 |
1058219 | 1058219 | 2021-02-23 | Oktibbeha | Mississippi | 28105 | 4380 | 91 |
1058220 | 1058220 | 2021-02-23 | Panola | Mississippi | 28107 | 4240 | 92 |
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);