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 2021-11-17 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1925259 | 1925259 | 2021-11-17 | Adams | Mississippi | 28001 | 4682 | 125 |
1925260 | 1925260 | 2021-11-17 | Alcorn | Mississippi | 28003 | 5826 | 105 |
1925261 | 1925261 | 2021-11-17 | Amite | Mississippi | 28005 | 2090 | 56 |
1925262 | 1925262 | 2021-11-17 | Attala | Mississippi | 28007 | 3365 | 90 |
1925263 | 1925263 | 2021-11-17 | Benton | Mississippi | 28009 | 1514 | 39 |
1925264 | 1925264 | 2021-11-17 | Bolivar | Mississippi | 28011 | 6418 | 151 |
1925265 | 1925265 | 2021-11-17 | Calhoun | Mississippi | 28013 | 2831 | 49 |
1925266 | 1925266 | 2021-11-17 | Carroll | Mississippi | 28015 | 1723 | 41 |
1925267 | 1925267 | 2021-11-17 | Chickasaw | Mississippi | 28017 | 3085 | 67 |
1925268 | 1925268 | 2021-11-17 | Choctaw | Mississippi | 28019 | 1358 | 27 |
1925269 | 1925269 | 2021-11-17 | Claiborne | Mississippi | 28021 | 1339 | 38 |
1925270 | 1925270 | 2021-11-17 | Clarke | Mississippi | 28023 | 3003 | 95 |
1925271 | 1925271 | 2021-11-17 | Clay | Mississippi | 28025 | 3111 | 78 |
1925272 | 1925272 | 2021-11-17 | Coahoma | Mississippi | 28027 | 4214 | 109 |
1925273 | 1925273 | 2021-11-17 | Copiah | Mississippi | 28029 | 4526 | 94 |
1925274 | 1925274 | 2021-11-17 | Covington | Mississippi | 28031 | 4313 | 95 |
1925275 | 1925275 | 2021-11-17 | DeSoto | Mississippi | 28033 | 32889 | 424 |
1925276 | 1925276 | 2021-11-17 | Forrest | Mississippi | 28035 | 13672 | 258 |
1925277 | 1925277 | 2021-11-17 | Franklin | Mississippi | 28037 | 1234 | 29 |
1925278 | 1925278 | 2021-11-17 | George | Mississippi | 28039 | 5089 | 80 |
1925279 | 1925279 | 2021-11-17 | Greene | Mississippi | 28041 | 2239 | 49 |
1925280 | 1925280 | 2021-11-17 | Grenada | Mississippi | 28043 | 3764 | 109 |
1925281 | 1925281 | 2021-11-17 | Hancock | Mississippi | 28045 | 7813 | 130 |
1925282 | 1925282 | 2021-11-17 | Harrison | Mississippi | 28047 | 34694 | 552 |
1925283 | 1925283 | 2021-11-17 | Hinds | Mississippi | 28049 | 32454 | 639 |
1925284 | 1925284 | 2021-11-17 | Holmes | Mississippi | 28051 | 2703 | 89 |
1925285 | 1925285 | 2021-11-17 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1925286 | 1925286 | 2021-11-17 | Issaquena | Mississippi | 28055 | 195 | 7 |
1925287 | 1925287 | 2021-11-17 | Itawamba | Mississippi | 28057 | 4752 | 107 |
1925288 | 1925288 | 2021-11-17 | Jackson | Mississippi | 28059 | 24778 | 388 |
1925289 | 1925289 | 2021-11-17 | Jasper | Mississippi | 28061 | 3392 | 66 |
1925290 | 1925290 | 2021-11-17 | Jefferson | Mississippi | 28063 | 966 | 34 |
1925291 | 1925291 | 2021-11-17 | Jefferson Davis | Mississippi | 28065 | 1730 | 43 |
1925292 | 1925292 | 2021-11-17 | Jones | Mississippi | 28067 | 14032 | 246 |
1925293 | 1925293 | 2021-11-17 | Kemper | Mississippi | 28069 | 1439 | 41 |
1925294 | 1925294 | 2021-11-17 | Lafayette | Mississippi | 28071 | 8751 | 141 |
1925295 | 1925295 | 2021-11-17 | Lamar | Mississippi | 28073 | 10610 | 140 |
1925296 | 1925296 | 2021-11-17 | Lauderdale | Mississippi | 28075 | 12174 | 324 |
1925297 | 1925297 | 2021-11-17 | Lawrence | Mississippi | 28077 | 2166 | 40 |
1925298 | 1925298 | 2021-11-17 | Leake | Mississippi | 28079 | 4124 | 90 |
1925299 | 1925299 | 2021-11-17 | Lee | Mississippi | 28081 | 16074 | 240 |
1925300 | 1925300 | 2021-11-17 | Leflore | Mississippi | 28083 | 4706 | 144 |
1925301 | 1925301 | 2021-11-17 | Lincoln | Mississippi | 28085 | 5500 | 136 |
1925302 | 1925302 | 2021-11-17 | Lowndes | Mississippi | 28087 | 11226 | 193 |
1925303 | 1925303 | 2021-11-17 | Madison | Mississippi | 28089 | 14832 | 282 |
1925304 | 1925304 | 2021-11-17 | Marion | Mississippi | 28091 | 4254 | 111 |
1925305 | 1925305 | 2021-11-17 | Marshall | Mississippi | 28093 | 6595 | 139 |
1925306 | 1925306 | 2021-11-17 | Monroe | Mississippi | 28095 | 6924 | 179 |
1925307 | 1925307 | 2021-11-17 | Montgomery | Mississippi | 28097 | 1810 | 57 |
1925308 | 1925308 | 2021-11-17 | Neshoba | Mississippi | 28099 | 6708 | 210 |
1925309 | 1925309 | 2021-11-17 | Newton | Mississippi | 28101 | 3938 | 81 |
1925310 | 1925310 | 2021-11-17 | Noxubee | Mississippi | 28103 | 1882 | 42 |
1925311 | 1925311 | 2021-11-17 | Oktibbeha | Mississippi | 28105 | 7191 | 138 |
1925312 | 1925312 | 2021-11-17 | Panola | Mississippi | 28107 | 6704 | 133 |
1925313 | 1925313 | 2021-11-17 | Pearl River | Mississippi | 28109 | 9674 | 243 |
1925314 | 1925314 | 2021-11-17 | Perry | Mississippi | 28111 | 2124 | 56 |
1925315 | 1925315 | 2021-11-17 | Pike | Mississippi | 28113 | 5909 | 155 |
1925316 | 1925316 | 2021-11-17 | Pontotoc | Mississippi | 28115 | 6889 | 109 |
1925317 | 1925317 | 2021-11-17 | Prentiss | Mississippi | 28117 | 4958 | 83 |
1925318 | 1925318 | 2021-11-17 | Quitman | Mississippi | 28119 | 1072 | 28 |
1925319 | 1925319 | 2021-11-17 | Rankin | Mississippi | 28121 | 22374 | 401 |
1925320 | 1925320 | 2021-11-17 | Scott | Mississippi | 28123 | 4758 | 98 |
1925321 | 1925321 | 2021-11-17 | Sharkey | Mississippi | 28125 | 650 | 21 |
1925322 | 1925322 | 2021-11-17 | Simpson | Mississippi | 28127 | 4523 | 117 |
1925323 | 1925323 | 2021-11-17 | Smith | Mississippi | 28129 | 2685 | 52 |
1925324 | 1925324 | 2021-11-17 | Stone | Mississippi | 28131 | 3653 | 66 |
1925325 | 1925325 | 2021-11-17 | Sunflower | Mississippi | 28133 | 4280 | 106 |
1925326 | 1925326 | 2021-11-17 | Tallahatchie | Mississippi | 28135 | 2308 | 52 |
1925327 | 1925327 | 2021-11-17 | Tate | Mississippi | 28137 | 4715 | 113 |
1925328 | 1925328 | 2021-11-17 | Tippah | Mississippi | 28139 | 4862 | 81 |
1925329 | 1925329 | 2021-11-17 | Tishomingo | Mississippi | 28141 | 3724 | 93 |
1925330 | 1925330 | 2021-11-17 | Tunica | Mississippi | 28143 | 1622 | 39 |
1925331 | 1925331 | 2021-11-17 | Union | Mississippi | 28145 | 6232 | 96 |
1925332 | 1925332 | 2021-11-17 | Walthall | Mississippi | 28147 | 2209 | 65 |
1925333 | 1925333 | 2021-11-17 | Warren | Mississippi | 28149 | 6825 | 177 |
1925334 | 1925334 | 2021-11-17 | Washington | Mississippi | 28151 | 7539 | 168 |
1925335 | 1925335 | 2021-11-17 | Wayne | Mississippi | 28153 | 4423 | 72 |
1925336 | 1925336 | 2021-11-17 | Webster | Mississippi | 28155 | 2045 | 48 |
1925337 | 1925337 | 2021-11-17 | Wilkinson | Mississippi | 28157 | 1057 | 39 |
1925338 | 1925338 | 2021-11-17 | Winston | Mississippi | 28159 | 3174 | 92 |
1925339 | 1925339 | 2021-11-17 | Yalobusha | Mississippi | 28161 | 2412 | 47 |
1925340 | 1925340 | 2021-11-17 | Yazoo | Mississippi | 28163 | 4537 | 91 |
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);