ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-10-20" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
649283 | 649283 | 2020-10-20 | Adams | Mississippi | 28001 | 1043 | 43 |
649284 | 649284 | 2020-10-20 | Alcorn | Mississippi | 28003 | 960 | 12 |
649285 | 649285 | 2020-10-20 | Amite | Mississippi | 28005 | 417 | 13 |
649286 | 649286 | 2020-10-20 | Attala | Mississippi | 28007 | 776 | 26 |
649287 | 649287 | 2020-10-20 | Benton | Mississippi | 28009 | 315 | 4 |
649288 | 649288 | 2020-10-20 | Bolivar | Mississippi | 28011 | 1983 | 77 |
649289 | 649289 | 2020-10-20 | Calhoun | Mississippi | 28013 | 614 | 12 |
649290 | 649290 | 2020-10-20 | Carroll | Mississippi | 28015 | 463 | 12 |
649291 | 649291 | 2020-10-20 | Chickasaw | Mississippi | 28017 | 826 | 25 |
649292 | 649292 | 2020-10-20 | Choctaw | Mississippi | 28019 | 203 | 6 |
649293 | 649293 | 2020-10-20 | Claiborne | Mississippi | 28021 | 532 | 16 |
649294 | 649294 | 2020-10-20 | Clarke | Mississippi | 28023 | 723 | 49 |
649295 | 649295 | 2020-10-20 | Clay | Mississippi | 28025 | 676 | 21 |
649296 | 649296 | 2020-10-20 | Coahoma | Mississippi | 28027 | 1234 | 36 |
649297 | 649297 | 2020-10-20 | Copiah | Mississippi | 28029 | 1350 | 36 |
649298 | 649298 | 2020-10-20 | Covington | Mississippi | 28031 | 925 | 25 |
649299 | 649299 | 2020-10-20 | DeSoto | Mississippi | 28033 | 6701 | 78 |
649300 | 649300 | 2020-10-20 | Forrest | Mississippi | 28035 | 2963 | 77 |
649301 | 649301 | 2020-10-20 | Franklin | Mississippi | 28037 | 237 | 3 |
649302 | 649302 | 2020-10-20 | George | Mississippi | 28039 | 939 | 17 |
649303 | 649303 | 2020-10-20 | Greene | Mississippi | 28041 | 455 | 18 |
649304 | 649304 | 2020-10-20 | Grenada | Mississippi | 28043 | 1200 | 38 |
649305 | 649305 | 2020-10-20 | Hancock | Mississippi | 28045 | 781 | 27 |
649306 | 649306 | 2020-10-20 | Harrison | Mississippi | 28047 | 4844 | 83 |
649307 | 649307 | 2020-10-20 | Hinds | Mississippi | 28049 | 7796 | 173 |
649308 | 649308 | 2020-10-20 | Holmes | Mississippi | 28051 | 1135 | 60 |
649309 | 649309 | 2020-10-20 | Humphreys | Mississippi | 28053 | 412 | 16 |
649310 | 649310 | 2020-10-20 | Issaquena | Mississippi | 28055 | 106 | 3 |
649311 | 649311 | 2020-10-20 | Itawamba | Mississippi | 28057 | 1104 | 24 |
649312 | 649312 | 2020-10-20 | Jackson | Mississippi | 28059 | 4350 | 81 |
649313 | 649313 | 2020-10-20 | Jasper | Mississippi | 28061 | 674 | 17 |
649314 | 649314 | 2020-10-20 | Jefferson | Mississippi | 28063 | 270 | 10 |
649315 | 649315 | 2020-10-20 | Jefferson Davis | Mississippi | 28065 | 398 | 11 |
649316 | 649316 | 2020-10-20 | Jones | Mississippi | 28067 | 2837 | 82 |
649317 | 649317 | 2020-10-20 | Kemper | Mississippi | 28069 | 320 | 15 |
649318 | 649318 | 2020-10-20 | Lafayette | Mississippi | 28071 | 2426 | 42 |
649319 | 649319 | 2020-10-20 | Lamar | Mississippi | 28073 | 2171 | 38 |
649320 | 649320 | 2020-10-20 | Lauderdale | Mississippi | 28075 | 2376 | 131 |
649321 | 649321 | 2020-10-20 | Lawrence | Mississippi | 28077 | 499 | 14 |
649322 | 649322 | 2020-10-20 | Leake | Mississippi | 28079 | 1133 | 40 |
649323 | 649323 | 2020-10-20 | Lee | Mississippi | 28081 | 3449 | 79 |
649324 | 649324 | 2020-10-20 | Leflore | Mississippi | 28083 | 1607 | 87 |
649325 | 649325 | 2020-10-20 | Lincoln | Mississippi | 28085 | 1355 | 55 |
649326 | 649326 | 2020-10-20 | Lowndes | Mississippi | 28087 | 1749 | 62 |
649327 | 649327 | 2020-10-20 | Madison | Mississippi | 28089 | 3739 | 93 |
649328 | 649328 | 2020-10-20 | Marion | Mississippi | 28091 | 929 | 42 |
649329 | 649329 | 2020-10-20 | Marshall | Mississippi | 28093 | 1348 | 26 |
649330 | 649330 | 2020-10-20 | Monroe | Mississippi | 28095 | 1459 | 72 |
649331 | 649331 | 2020-10-20 | Montgomery | Mississippi | 28097 | 529 | 23 |
649332 | 649332 | 2020-10-20 | Neshoba | Mississippi | 28099 | 1814 | 111 |
649333 | 649333 | 2020-10-20 | Newton | Mississippi | 28101 | 844 | 27 |
649334 | 649334 | 2020-10-20 | Noxubee | Mississippi | 28103 | 596 | 17 |
649335 | 649335 | 2020-10-20 | Oktibbeha | Mississippi | 28105 | 1958 | 54 |
649336 | 649336 | 2020-10-20 | Panola | Mississippi | 28107 | 1663 | 37 |
649337 | 649337 | 2020-10-20 | Pearl River | Mississippi | 28109 | 1089 | 58 |
649338 | 649338 | 2020-10-20 | Perry | Mississippi | 28111 | 481 | 22 |
649339 | 649339 | 2020-10-20 | Pike | Mississippi | 28113 | 1372 | 56 |
649340 | 649340 | 2020-10-20 | Pontotoc | Mississippi | 28115 | 1438 | 19 |
649341 | 649341 | 2020-10-20 | Prentiss | Mississippi | 28117 | 1026 | 19 |
649342 | 649342 | 2020-10-20 | Quitman | Mississippi | 28119 | 414 | 6 |
649343 | 649343 | 2020-10-20 | Rankin | Mississippi | 28121 | 3837 | 86 |
649344 | 649344 | 2020-10-20 | Scott | Mississippi | 28123 | 1238 | 29 |
649345 | 649345 | 2020-10-20 | Sharkey | Mississippi | 28125 | 278 | 14 |
649346 | 649346 | 2020-10-20 | Simpson | Mississippi | 28127 | 1186 | 49 |
649347 | 649347 | 2020-10-20 | Smith | Mississippi | 28129 | 583 | 16 |
649348 | 649348 | 2020-10-20 | Stone | Mississippi | 28131 | 450 | 14 |
649349 | 649349 | 2020-10-20 | Sunflower | Mississippi | 28133 | 1576 | 49 |
649350 | 649350 | 2020-10-20 | Tallahatchie | Mississippi | 28135 | 818 | 25 |
649351 | 649351 | 2020-10-20 | Tate | Mississippi | 28137 | 1132 | 39 |
649352 | 649352 | 2020-10-20 | Tippah | Mississippi | 28139 | 859 | 21 |
649353 | 649353 | 2020-10-20 | Tishomingo | Mississippi | 28141 | 793 | 41 |
649354 | 649354 | 2020-10-20 | Tunica | Mississippi | 28143 | 522 | 17 |
649355 | 649355 | 2020-10-20 | Union | Mississippi | 28145 | 1152 | 25 |
649356 | 649356 | 2020-10-20 | Walthall | Mississippi | 28147 | 633 | 27 |
649357 | 649357 | 2020-10-20 | Warren | Mississippi | 28149 | 1527 | 55 |
649358 | 649358 | 2020-10-20 | Washington | Mississippi | 28151 | 2521 | 97 |
649359 | 649359 | 2020-10-20 | Wayne | Mississippi | 28153 | 987 | 21 |
649360 | 649360 | 2020-10-20 | Webster | Mississippi | 28155 | 366 | 13 |
649361 | 649361 | 2020-10-20 | Wilkinson | Mississippi | 28157 | 330 | 20 |
649362 | 649362 | 2020-10-20 | Winston | Mississippi | 28159 | 822 | 21 |
649363 | 649363 | 2020-10-20 | Yalobusha | Mississippi | 28161 | 493 | 14 |
649364 | 649364 | 2020-10-20 | Yazoo | Mississippi | 28163 | 1193 | 33 |
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);