ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-01-06" 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 |
---|---|---|---|---|---|---|---|
902381 | 902381 | 2021-01-06 | Adams | Mississippi | 28001 | 1868 | 63 |
902382 | 902382 | 2021-01-06 | Alcorn | Mississippi | 28003 | 2340 | 45 |
902383 | 902383 | 2021-01-06 | Amite | Mississippi | 28005 | 903 | 23 |
902384 | 902384 | 2021-01-06 | Attala | Mississippi | 28007 | 1825 | 52 |
902385 | 902385 | 2021-01-06 | Benton | Mississippi | 28009 | 721 | 21 |
902386 | 902386 | 2021-01-06 | Bolivar | Mississippi | 28011 | 3595 | 96 |
902387 | 902387 | 2021-01-06 | Calhoun | Mississippi | 28013 | 1239 | 18 |
902388 | 902388 | 2021-01-06 | Carroll | Mississippi | 28015 | 964 | 18 |
902389 | 902389 | 2021-01-06 | Chickasaw | Mississippi | 28017 | 1693 | 38 |
902390 | 902390 | 2021-01-06 | Choctaw | Mississippi | 28019 | 552 | 11 |
902391 | 902391 | 2021-01-06 | Claiborne | Mississippi | 28021 | 749 | 22 |
902392 | 902392 | 2021-01-06 | Clarke | Mississippi | 28023 | 1251 | 59 |
902393 | 902393 | 2021-01-06 | Clay | Mississippi | 28025 | 1430 | 30 |
902394 | 902394 | 2021-01-06 | Coahoma | Mississippi | 28027 | 2044 | 52 |
902395 | 902395 | 2021-01-06 | Copiah | Mississippi | 28029 | 2253 | 47 |
902396 | 902396 | 2021-01-06 | Covington | Mississippi | 28031 | 1958 | 68 |
902397 | 902397 | 2021-01-06 | DeSoto | Mississippi | 28033 | 15586 | 148 |
902398 | 902398 | 2021-01-06 | Forrest | Mississippi | 28035 | 5513 | 106 |
902399 | 902399 | 2021-01-06 | Franklin | Mississippi | 28037 | 620 | 11 |
902400 | 902400 | 2021-01-06 | George | Mississippi | 28039 | 1783 | 37 |
902401 | 902401 | 2021-01-06 | Greene | Mississippi | 28041 | 1019 | 27 |
902402 | 902402 | 2021-01-06 | Grenada | Mississippi | 28043 | 2041 | 65 |
902403 | 902403 | 2021-01-06 | Hancock | Mississippi | 28045 | 2204 | 56 |
902404 | 902404 | 2021-01-06 | Harrison | Mississippi | 28047 | 11518 | 168 |
902405 | 902405 | 2021-01-06 | Hinds | Mississippi | 28049 | 14652 | 291 |
902406 | 902406 | 2021-01-06 | Holmes | Mississippi | 28051 | 1622 | 67 |
902407 | 902407 | 2021-01-06 | Humphreys | Mississippi | 28053 | 763 | 22 |
902408 | 902408 | 2021-01-06 | Issaquena | Mississippi | 28055 | 152 | 5 |
902409 | 902409 | 2021-01-06 | Itawamba | Mississippi | 28057 | 2441 | 51 |
902410 | 902410 | 2021-01-06 | Jackson | Mississippi | 28059 | 9189 | 164 |
902411 | 902411 | 2021-01-06 | Jasper | Mississippi | 28061 | 1533 | 30 |
902412 | 902412 | 2021-01-06 | Jefferson | Mississippi | 28063 | 487 | 16 |
902413 | 902413 | 2021-01-06 | Jefferson Davis | Mississippi | 28065 | 796 | 24 |
902414 | 902414 | 2021-01-06 | Jones | Mississippi | 28067 | 5523 | 98 |
902415 | 902415 | 2021-01-06 | Kemper | Mississippi | 28069 | 705 | 19 |
902416 | 902416 | 2021-01-06 | Lafayette | Mississippi | 28071 | 4456 | 86 |
902417 | 902417 | 2021-01-06 | Lamar | Mississippi | 28073 | 4393 | 61 |
902418 | 902418 | 2021-01-06 | Lauderdale | Mississippi | 28075 | 5217 | 171 |
902419 | 902419 | 2021-01-06 | Lawrence | Mississippi | 28077 | 945 | 17 |
902420 | 902420 | 2021-01-06 | Leake | Mississippi | 28079 | 2145 | 60 |
902421 | 902421 | 2021-01-06 | Lee | Mississippi | 28081 | 8161 | 125 |
902422 | 902422 | 2021-01-06 | Leflore | Mississippi | 28083 | 2788 | 103 |
902423 | 902423 | 2021-01-06 | Lincoln | Mississippi | 28085 | 2721 | 81 |
902424 | 902424 | 2021-01-06 | Lowndes | Mississippi | 28087 | 4761 | 97 |
902425 | 902425 | 2021-01-06 | Madison | Mississippi | 28089 | 7551 | 146 |
902426 | 902426 | 2021-01-06 | Marion | Mississippi | 28091 | 1840 | 68 |
902427 | 902427 | 2021-01-06 | Marshall | Mississippi | 28093 | 3068 | 63 |
902428 | 902428 | 2021-01-06 | Monroe | Mississippi | 28095 | 3241 | 91 |
902429 | 902429 | 2021-01-06 | Montgomery | Mississippi | 28097 | 1027 | 31 |
902430 | 902430 | 2021-01-06 | Neshoba | Mississippi | 28099 | 3109 | 144 |
902431 | 902431 | 2021-01-06 | Newton | Mississippi | 28101 | 1701 | 40 |
902432 | 902432 | 2021-01-06 | Noxubee | Mississippi | 28103 | 1018 | 20 |
902433 | 902433 | 2021-01-06 | Oktibbeha | Mississippi | 28105 | 3618 | 78 |
902434 | 902434 | 2021-01-06 | Panola | Mississippi | 28107 | 3355 | 71 |
902435 | 902435 | 2021-01-06 | Pearl River | Mississippi | 28109 | 2821 | 87 |
902436 | 902436 | 2021-01-06 | Perry | Mississippi | 28111 | 928 | 31 |
902437 | 902437 | 2021-01-06 | Pike | Mississippi | 28113 | 2344 | 73 |
902438 | 902438 | 2021-01-06 | Pontotoc | Mississippi | 28115 | 3321 | 45 |
902439 | 902439 | 2021-01-06 | Prentiss | Mississippi | 28117 | 2249 | 45 |
902440 | 902440 | 2021-01-06 | Quitman | Mississippi | 28119 | 624 | 7 |
902441 | 902441 | 2021-01-06 | Rankin | Mississippi | 28121 | 9361 | 178 |
902442 | 902442 | 2021-01-06 | Scott | Mississippi | 28123 | 2228 | 41 |
902443 | 902443 | 2021-01-06 | Sharkey | Mississippi | 28125 | 403 | 17 |
902444 | 902444 | 2021-01-06 | Simpson | Mississippi | 28127 | 2161 | 66 |
902445 | 902445 | 2021-01-06 | Smith | Mississippi | 28129 | 1090 | 20 |
902446 | 902446 | 2021-01-06 | Stone | Mississippi | 28131 | 1259 | 18 |
902447 | 902447 | 2021-01-06 | Sunflower | Mississippi | 28133 | 2539 | 63 |
902448 | 902448 | 2021-01-06 | Tallahatchie | Mississippi | 28135 | 1278 | 33 |
902449 | 902449 | 2021-01-06 | Tate | Mississippi | 28137 | 2496 | 56 |
902450 | 902450 | 2021-01-06 | Tippah | Mississippi | 28139 | 2088 | 42 |
902451 | 902451 | 2021-01-06 | Tishomingo | Mississippi | 28141 | 1644 | 54 |
902452 | 902452 | 2021-01-06 | Tunica | Mississippi | 28143 | 783 | 19 |
902453 | 902453 | 2021-01-06 | Union | Mississippi | 28145 | 3078 | 48 |
902454 | 902454 | 2021-01-06 | Walthall | Mississippi | 28147 | 1046 | 35 |
902455 | 902455 | 2021-01-06 | Warren | Mississippi | 28149 | 2997 | 81 |
902456 | 902456 | 2021-01-06 | Washington | Mississippi | 28151 | 4526 | 119 |
902457 | 902457 | 2021-01-06 | Wayne | Mississippi | 28153 | 1786 | 27 |
902458 | 902458 | 2021-01-06 | Webster | Mississippi | 28155 | 842 | 21 |
902459 | 902459 | 2021-01-06 | Wilkinson | Mississippi | 28157 | 542 | 24 |
902460 | 902460 | 2021-01-06 | Winston | Mississippi | 28159 | 1899 | 58 |
902461 | 902461 | 2021-01-06 | Yalobusha | Mississippi | 28161 | 1065 | 33 |
902462 | 902462 | 2021-01-06 | Yazoo | Mississippi | 28163 | 2190 | 51 |
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);