ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-06-30" 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 |
---|---|---|---|---|---|---|---|
288468 | 288468 | 2020-06-30 | Adams | Mississippi | 28001 | 263 | 18 |
288469 | 288469 | 2020-06-30 | Alcorn | Mississippi | 28003 | 55 | 1 |
288470 | 288470 | 2020-06-30 | Amite | Mississippi | 28005 | 81 | 2 |
288471 | 288471 | 2020-06-30 | Attala | Mississippi | 28007 | 350 | 23 |
288472 | 288472 | 2020-06-30 | Benton | Mississippi | 28009 | 27 | 0 |
288473 | 288473 | 2020-06-30 | Bolivar | Mississippi | 28011 | 261 | 13 |
288474 | 288474 | 2020-06-30 | Calhoun | Mississippi | 28013 | 119 | 4 |
288475 | 288475 | 2020-06-30 | Carroll | Mississippi | 28015 | 157 | 11 |
288476 | 288476 | 2020-06-30 | Chickasaw | Mississippi | 28017 | 254 | 18 |
288477 | 288477 | 2020-06-30 | Choctaw | Mississippi | 28019 | 71 | 4 |
288478 | 288478 | 2020-06-30 | Claiborne | Mississippi | 28021 | 228 | 10 |
288479 | 288479 | 2020-06-30 | Clarke | Mississippi | 28023 | 198 | 24 |
288480 | 288480 | 2020-06-30 | Clay | Mississippi | 28025 | 240 | 10 |
288481 | 288481 | 2020-06-30 | Coahoma | Mississippi | 28027 | 183 | 6 |
288482 | 288482 | 2020-06-30 | Copiah | Mississippi | 28029 | 562 | 14 |
288483 | 288483 | 2020-06-30 | Covington | Mississippi | 28031 | 290 | 5 |
288484 | 288484 | 2020-06-30 | DeSoto | Mississippi | 28033 | 1311 | 15 |
288485 | 288485 | 2020-06-30 | Forrest | Mississippi | 28035 | 798 | 42 |
288486 | 288486 | 2020-06-30 | Franklin | Mississippi | 28037 | 38 | 2 |
288487 | 288487 | 2020-06-30 | George | Mississippi | 28039 | 73 | 3 |
288488 | 288488 | 2020-06-30 | Greene | Mississippi | 28041 | 91 | 7 |
288489 | 288489 | 2020-06-30 | Grenada | Mississippi | 28043 | 367 | 5 |
288490 | 288490 | 2020-06-30 | Hancock | Mississippi | 28045 | 120 | 13 |
288491 | 288491 | 2020-06-30 | Harrison | Mississippi | 28047 | 719 | 8 |
288492 | 288492 | 2020-06-30 | Hinds | Mississippi | 28049 | 2111 | 39 |
288493 | 288493 | 2020-06-30 | Holmes | Mississippi | 28051 | 520 | 40 |
288494 | 288494 | 2020-06-30 | Humphreys | Mississippi | 28053 | 120 | 9 |
288495 | 288495 | 2020-06-30 | Issaquena | Mississippi | 28055 | 6 | 1 |
288496 | 288496 | 2020-06-30 | Itawamba | Mississippi | 28057 | 122 | 8 |
288497 | 288497 | 2020-06-30 | Jackson | Mississippi | 28059 | 505 | 16 |
288498 | 288498 | 2020-06-30 | Jasper | Mississippi | 28061 | 245 | 6 |
288499 | 288499 | 2020-06-30 | Jefferson | Mississippi | 28063 | 84 | 3 |
288500 | 288500 | 2020-06-30 | Jefferson Davis | Mississippi | 28065 | 103 | 4 |
288501 | 288501 | 2020-06-30 | Jones | Mississippi | 28067 | 1061 | 49 |
288502 | 288502 | 2020-06-30 | Kemper | Mississippi | 28069 | 174 | 13 |
288503 | 288503 | 2020-06-30 | Lafayette | Mississippi | 28071 | 339 | 4 |
288504 | 288504 | 2020-06-30 | Lamar | Mississippi | 28073 | 407 | 7 |
288505 | 288505 | 2020-06-30 | Lauderdale | Mississippi | 28075 | 879 | 78 |
288506 | 288506 | 2020-06-30 | Lawrence | Mississippi | 28077 | 154 | 1 |
288507 | 288507 | 2020-06-30 | Leake | Mississippi | 28079 | 547 | 19 |
288508 | 288508 | 2020-06-30 | Lee | Mississippi | 28081 | 477 | 16 |
288509 | 288509 | 2020-06-30 | Leflore | Mississippi | 28083 | 469 | 48 |
288510 | 288510 | 2020-06-30 | Lincoln | Mississippi | 28085 | 434 | 34 |
288511 | 288511 | 2020-06-30 | Lowndes | Mississippi | 28087 | 444 | 11 |
288512 | 288512 | 2020-06-30 | Madison | Mississippi | 28089 | 1206 | 34 |
288513 | 288513 | 2020-06-30 | Marion | Mississippi | 28091 | 240 | 11 |
288514 | 288514 | 2020-06-30 | Marshall | Mississippi | 28093 | 196 | 3 |
288515 | 288515 | 2020-06-30 | Monroe | Mississippi | 28095 | 355 | 29 |
288516 | 288516 | 2020-06-30 | Montgomery | Mississippi | 28097 | 116 | 2 |
288517 | 288517 | 2020-06-30 | Neshoba | Mississippi | 28099 | 952 | 68 |
288518 | 288518 | 2020-06-30 | Newton | Mississippi | 28101 | 329 | 9 |
288519 | 288519 | 2020-06-30 | Noxubee | Mississippi | 28103 | 245 | 8 |
288520 | 288520 | 2020-06-30 | Oktibbeha | Mississippi | 28105 | 483 | 24 |
288521 | 288521 | 2020-06-30 | Panola | Mississippi | 28107 | 254 | 6 |
288522 | 288522 | 2020-06-30 | Pearl River | Mississippi | 28109 | 239 | 32 |
288523 | 288523 | 2020-06-30 | Perry | Mississippi | 28111 | 59 | 4 |
288524 | 288524 | 2020-06-30 | Pike | Mississippi | 28113 | 356 | 12 |
288525 | 288525 | 2020-06-30 | Pontotoc | Mississippi | 28115 | 231 | 4 |
288526 | 288526 | 2020-06-30 | Prentiss | Mississippi | 28117 | 97 | 3 |
288527 | 288527 | 2020-06-30 | Quitman | Mississippi | 28119 | 67 | 0 |
288528 | 288528 | 2020-06-30 | Rankin | Mississippi | 28121 | 816 | 12 |
288529 | 288529 | 2020-06-30 | Scott | Mississippi | 28123 | 742 | 15 |
288530 | 288530 | 2020-06-30 | Sharkey | Mississippi | 28125 | 24 | 0 |
288531 | 288531 | 2020-06-30 | Simpson | Mississippi | 28127 | 218 | 3 |
288532 | 288532 | 2020-06-30 | Smith | Mississippi | 28129 | 204 | 11 |
288533 | 288533 | 2020-06-30 | Stone | Mississippi | 28131 | 51 | 1 |
288534 | 288534 | 2020-06-30 | Sunflower | Mississippi | 28133 | 280 | 6 |
288535 | 288535 | 2020-06-30 | Tallahatchie | Mississippi | 28135 | 94 | 3 |
288536 | 288536 | 2020-06-30 | Tate | Mississippi | 28137 | 245 | 7 |
288537 | 288537 | 2020-06-30 | Tippah | Mississippi | 28139 | 121 | 11 |
288538 | 288538 | 2020-06-30 | Tishomingo | Mississippi | 28141 | 65 | 1 |
288539 | 288539 | 2020-06-30 | Tunica | Mississippi | 28143 | 89 | 3 |
288540 | 288540 | 2020-06-30 | Union | Mississippi | 28145 | 172 | 9 |
288541 | 288541 | 2020-06-30 | Walthall | Mississippi | 28147 | 169 | 4 |
288542 | 288542 | 2020-06-30 | Warren | Mississippi | 28149 | 425 | 17 |
288543 | 288543 | 2020-06-30 | Washington | Mississippi | 28151 | 465 | 9 |
288544 | 288544 | 2020-06-30 | Wayne | Mississippi | 28153 | 515 | 11 |
288545 | 288545 | 2020-06-30 | Webster | Mississippi | 28155 | 123 | 10 |
288546 | 288546 | 2020-06-30 | Wilkinson | Mississippi | 28157 | 89 | 9 |
288547 | 288547 | 2020-06-30 | Winston | Mississippi | 28159 | 240 | 5 |
288548 | 288548 | 2020-06-30 | Yalobusha | Mississippi | 28161 | 152 | 7 |
288549 | 288549 | 2020-06-30 | Yazoo | Mississippi | 28163 | 467 | 6 |
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);