ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-11-14" 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 |
---|---|---|---|---|---|---|---|
730372 | 730372 | 2020-11-14 | Adams | Mississippi | 28001 | 1222 | 47 |
730373 | 730373 | 2020-11-14 | Alcorn | Mississippi | 28003 | 1307 | 21 |
730374 | 730374 | 2020-11-14 | Amite | Mississippi | 28005 | 457 | 14 |
730375 | 730375 | 2020-11-14 | Attala | Mississippi | 28007 | 948 | 27 |
730376 | 730376 | 2020-11-14 | Benton | Mississippi | 28009 | 442 | 16 |
730377 | 730377 | 2020-11-14 | Bolivar | Mississippi | 28011 | 2245 | 82 |
730378 | 730378 | 2020-11-14 | Calhoun | Mississippi | 28013 | 680 | 13 |
730379 | 730379 | 2020-11-14 | Carroll | Mississippi | 28015 | 643 | 13 |
730380 | 730380 | 2020-11-14 | Chickasaw | Mississippi | 28017 | 964 | 31 |
730381 | 730381 | 2020-11-14 | Choctaw | Mississippi | 28019 | 258 | 7 |
730382 | 730382 | 2020-11-14 | Claiborne | Mississippi | 28021 | 562 | 16 |
730383 | 730383 | 2020-11-14 | Clarke | Mississippi | 28023 | 840 | 53 |
730384 | 730384 | 2020-11-14 | Clay | Mississippi | 28025 | 802 | 26 |
730385 | 730385 | 2020-11-14 | Coahoma | Mississippi | 28027 | 1358 | 39 |
730386 | 730386 | 2020-11-14 | Copiah | Mississippi | 28029 | 1499 | 38 |
730387 | 730387 | 2020-11-14 | Covington | Mississippi | 28031 | 1101 | 32 |
730388 | 730388 | 2020-11-14 | DeSoto | Mississippi | 28033 | 8763 | 87 |
730389 | 730389 | 2020-11-14 | Forrest | Mississippi | 28035 | 3401 | 83 |
730390 | 730390 | 2020-11-14 | Franklin | Mississippi | 28037 | 275 | 4 |
730391 | 730391 | 2020-11-14 | George | Mississippi | 28039 | 1150 | 22 |
730392 | 730392 | 2020-11-14 | Greene | Mississippi | 28041 | 554 | 19 |
730393 | 730393 | 2020-11-14 | Grenada | Mississippi | 28043 | 1298 | 43 |
730394 | 730394 | 2020-11-14 | Hancock | Mississippi | 28045 | 1060 | 34 |
730395 | 730395 | 2020-11-14 | Harrison | Mississippi | 28047 | 6404 | 101 |
730396 | 730396 | 2020-11-14 | Hinds | Mississippi | 28049 | 8914 | 186 |
730397 | 730397 | 2020-11-14 | Holmes | Mississippi | 28051 | 1193 | 60 |
730398 | 730398 | 2020-11-14 | Humphreys | Mississippi | 28053 | 499 | 18 |
730399 | 730399 | 2020-11-14 | Issaquena | Mississippi | 28055 | 108 | 4 |
730400 | 730400 | 2020-11-14 | Itawamba | Mississippi | 28057 | 1347 | 33 |
730401 | 730401 | 2020-11-14 | Jackson | Mississippi | 28059 | 5713 | 105 |
730402 | 730402 | 2020-11-14 | Jasper | Mississippi | 28061 | 770 | 20 |
730403 | 730403 | 2020-11-14 | Jefferson | Mississippi | 28063 | 298 | 11 |
730404 | 730404 | 2020-11-14 | Jefferson Davis | Mississippi | 28065 | 504 | 15 |
730405 | 730405 | 2020-11-14 | Jones | Mississippi | 28067 | 3234 | 86 |
730406 | 730406 | 2020-11-14 | Kemper | Mississippi | 28069 | 358 | 15 |
730407 | 730407 | 2020-11-14 | Lafayette | Mississippi | 28071 | 2847 | 45 |
730408 | 730408 | 2020-11-14 | Lamar | Mississippi | 28073 | 2583 | 47 |
730409 | 730409 | 2020-11-14 | Lauderdale | Mississippi | 28075 | 3017 | 141 |
730410 | 730410 | 2020-11-14 | Lawrence | Mississippi | 28077 | 633 | 14 |
730411 | 730411 | 2020-11-14 | Leake | Mississippi | 28079 | 1256 | 43 |
730412 | 730412 | 2020-11-14 | Lee | Mississippi | 28081 | 4369 | 89 |
730413 | 730413 | 2020-11-14 | Leflore | Mississippi | 28083 | 1906 | 88 |
730414 | 730414 | 2020-11-14 | Lincoln | Mississippi | 28085 | 1606 | 64 |
730415 | 730415 | 2020-11-14 | Lowndes | Mississippi | 28087 | 2114 | 62 |
730416 | 730416 | 2020-11-14 | Madison | Mississippi | 28089 | 4282 | 97 |
730417 | 730417 | 2020-11-14 | Marion | Mississippi | 28091 | 1035 | 46 |
730418 | 730418 | 2020-11-14 | Marshall | Mississippi | 28093 | 1882 | 39 |
730419 | 730419 | 2020-11-14 | Monroe | Mississippi | 28095 | 1742 | 76 |
730420 | 730420 | 2020-11-14 | Montgomery | Mississippi | 28097 | 663 | 24 |
730421 | 730421 | 2020-11-14 | Neshoba | Mississippi | 28099 | 2040 | 111 |
730422 | 730422 | 2020-11-14 | Newton | Mississippi | 28101 | 965 | 29 |
730423 | 730423 | 2020-11-14 | Noxubee | Mississippi | 28103 | 646 | 17 |
730424 | 730424 | 2020-11-14 | Oktibbeha | Mississippi | 28105 | 2239 | 58 |
730425 | 730425 | 2020-11-14 | Panola | Mississippi | 28107 | 1940 | 43 |
730426 | 730426 | 2020-11-14 | Pearl River | Mississippi | 28109 | 1310 | 65 |
730427 | 730427 | 2020-11-14 | Perry | Mississippi | 28111 | 592 | 24 |
730428 | 730428 | 2020-11-14 | Pike | Mississippi | 28113 | 1527 | 58 |
730429 | 730429 | 2020-11-14 | Pontotoc | Mississippi | 28115 | 1779 | 25 |
730430 | 730430 | 2020-11-14 | Prentiss | Mississippi | 28117 | 1279 | 24 |
730431 | 730431 | 2020-11-14 | Quitman | Mississippi | 28119 | 449 | 6 |
730432 | 730432 | 2020-11-14 | Rankin | Mississippi | 28121 | 4744 | 90 |
730433 | 730433 | 2020-11-14 | Scott | Mississippi | 28123 | 1380 | 29 |
730434 | 730434 | 2020-11-14 | Sharkey | Mississippi | 28125 | 294 | 16 |
730435 | 730435 | 2020-11-14 | Simpson | Mississippi | 28127 | 1351 | 52 |
730436 | 730436 | 2020-11-14 | Smith | Mississippi | 28129 | 658 | 16 |
730437 | 730437 | 2020-11-14 | Stone | Mississippi | 28131 | 621 | 14 |
730438 | 730438 | 2020-11-14 | Sunflower | Mississippi | 28133 | 1784 | 54 |
730439 | 730439 | 2020-11-14 | Tallahatchie | Mississippi | 28135 | 915 | 27 |
730440 | 730440 | 2020-11-14 | Tate | Mississippi | 28137 | 1487 | 45 |
730441 | 730441 | 2020-11-14 | Tippah | Mississippi | 28139 | 1102 | 28 |
730442 | 730442 | 2020-11-14 | Tishomingo | Mississippi | 28141 | 971 | 41 |
730443 | 730443 | 2020-11-14 | Tunica | Mississippi | 28143 | 572 | 18 |
730444 | 730444 | 2020-11-14 | Union | Mississippi | 28145 | 1452 | 25 |
730445 | 730445 | 2020-11-14 | Walthall | Mississippi | 28147 | 705 | 27 |
730446 | 730446 | 2020-11-14 | Warren | Mississippi | 28149 | 1649 | 56 |
730447 | 730447 | 2020-11-14 | Washington | Mississippi | 28151 | 2873 | 105 |
730448 | 730448 | 2020-11-14 | Wayne | Mississippi | 28153 | 1105 | 22 |
730449 | 730449 | 2020-11-14 | Webster | Mississippi | 28155 | 398 | 14 |
730450 | 730450 | 2020-11-14 | Wilkinson | Mississippi | 28157 | 360 | 22 |
730451 | 730451 | 2020-11-14 | Winston | Mississippi | 28159 | 1005 | 22 |
730452 | 730452 | 2020-11-14 | Yalobusha | Mississippi | 28161 | 629 | 25 |
730453 | 730453 | 2020-11-14 | Yazoo | Mississippi | 28163 | 1413 | 36 |
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);