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 2020-07-12 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
326474 | 326474 | 2020-07-12 | Adams | Mississippi | 28001 | 358 | 20 |
326475 | 326475 | 2020-07-12 | Alcorn | Mississippi | 28003 | 107 | 2 |
326476 | 326476 | 2020-07-12 | Amite | Mississippi | 28005 | 112 | 3 |
326477 | 326477 | 2020-07-12 | Attala | Mississippi | 28007 | 386 | 24 |
326478 | 326478 | 2020-07-12 | Benton | Mississippi | 28009 | 47 | 0 |
326479 | 326479 | 2020-07-12 | Bolivar | Mississippi | 28011 | 412 | 18 |
326480 | 326480 | 2020-07-12 | Calhoun | Mississippi | 28013 | 170 | 5 |
326481 | 326481 | 2020-07-12 | Carroll | Mississippi | 28015 | 182 | 11 |
326482 | 326482 | 2020-07-12 | Chickasaw | Mississippi | 28017 | 300 | 19 |
326483 | 326483 | 2020-07-12 | Choctaw | Mississippi | 28019 | 76 | 4 |
326484 | 326484 | 2020-07-12 | Claiborne | Mississippi | 28021 | 308 | 11 |
326485 | 326485 | 2020-07-12 | Clarke | Mississippi | 28023 | 223 | 25 |
326486 | 326486 | 2020-07-12 | Clay | Mississippi | 28025 | 261 | 11 |
326487 | 326487 | 2020-07-12 | Coahoma | Mississippi | 28027 | 230 | 6 |
326488 | 326488 | 2020-07-12 | Copiah | Mississippi | 28029 | 670 | 16 |
326489 | 326489 | 2020-07-12 | Covington | Mississippi | 28031 | 446 | 5 |
326490 | 326490 | 2020-07-12 | DeSoto | Mississippi | 28033 | 1959 | 20 |
326491 | 326491 | 2020-07-12 | Forrest | Mississippi | 28035 | 1038 | 43 |
326492 | 326492 | 2020-07-12 | Franklin | Mississippi | 28037 | 54 | 2 |
326493 | 326493 | 2020-07-12 | George | Mississippi | 28039 | 123 | 3 |
326494 | 326494 | 2020-07-12 | Greene | Mississippi | 28041 | 116 | 10 |
326495 | 326495 | 2020-07-12 | Grenada | Mississippi | 28043 | 604 | 9 |
326496 | 326496 | 2020-07-12 | Hancock | Mississippi | 28045 | 148 | 13 |
326497 | 326497 | 2020-07-12 | Harrison | Mississippi | 28047 | 1177 | 16 |
326498 | 326498 | 2020-07-12 | Hinds | Mississippi | 28049 | 2992 | 54 |
326499 | 326499 | 2020-07-12 | Holmes | Mississippi | 28051 | 595 | 41 |
326500 | 326500 | 2020-07-12 | Humphreys | Mississippi | 28053 | 169 | 10 |
326501 | 326501 | 2020-07-12 | Issaquena | Mississippi | 28055 | 10 | 1 |
326502 | 326502 | 2020-07-12 | Itawamba | Mississippi | 28057 | 147 | 8 |
326503 | 326503 | 2020-07-12 | Jackson | Mississippi | 28059 | 798 | 19 |
326504 | 326504 | 2020-07-12 | Jasper | Mississippi | 28061 | 281 | 6 |
326505 | 326505 | 2020-07-12 | Jefferson | Mississippi | 28063 | 128 | 3 |
326506 | 326506 | 2020-07-12 | Jefferson Davis | Mississippi | 28065 | 125 | 4 |
326507 | 326507 | 2020-07-12 | Jones | Mississippi | 28067 | 1224 | 49 |
326508 | 326508 | 2020-07-12 | Kemper | Mississippi | 28069 | 184 | 14 |
326509 | 326509 | 2020-07-12 | Lafayette | Mississippi | 28071 | 506 | 4 |
326510 | 326510 | 2020-07-12 | Lamar | Mississippi | 28073 | 583 | 7 |
326511 | 326511 | 2020-07-12 | Lauderdale | Mississippi | 28075 | 966 | 81 |
326512 | 326512 | 2020-07-12 | Lawrence | Mississippi | 28077 | 213 | 2 |
326513 | 326513 | 2020-07-12 | Leake | Mississippi | 28079 | 634 | 20 |
326514 | 326514 | 2020-07-12 | Lee | Mississippi | 28081 | 628 | 22 |
326515 | 326515 | 2020-07-12 | Leflore | Mississippi | 28083 | 534 | 56 |
326516 | 326516 | 2020-07-12 | Lincoln | Mississippi | 28085 | 533 | 35 |
326517 | 326517 | 2020-07-12 | Lowndes | Mississippi | 28087 | 548 | 17 |
326518 | 326518 | 2020-07-12 | Madison | Mississippi | 28089 | 1484 | 39 |
326519 | 326519 | 2020-07-12 | Marion | Mississippi | 28091 | 345 | 12 |
326520 | 326520 | 2020-07-12 | Marshall | Mississippi | 28093 | 292 | 3 |
326521 | 326521 | 2020-07-12 | Monroe | Mississippi | 28095 | 461 | 35 |
326522 | 326522 | 2020-07-12 | Montgomery | Mississippi | 28097 | 179 | 3 |
326523 | 326523 | 2020-07-12 | Neshoba | Mississippi | 28099 | 1046 | 77 |
326524 | 326524 | 2020-07-12 | Newton | Mississippi | 28101 | 376 | 10 |
326525 | 326525 | 2020-07-12 | Noxubee | Mississippi | 28103 | 279 | 9 |
326526 | 326526 | 2020-07-12 | Oktibbeha | Mississippi | 28105 | 619 | 28 |
326527 | 326527 | 2020-07-12 | Panola | Mississippi | 28107 | 454 | 6 |
326528 | 326528 | 2020-07-12 | Pearl River | Mississippi | 28109 | 303 | 32 |
326529 | 326529 | 2020-07-12 | Perry | Mississippi | 28111 | 91 | 4 |
326530 | 326530 | 2020-07-12 | Pike | Mississippi | 28113 | 505 | 20 |
326531 | 326531 | 2020-07-12 | Pontotoc | Mississippi | 28115 | 355 | 6 |
326532 | 326532 | 2020-07-12 | Prentiss | Mississippi | 28117 | 127 | 4 |
326533 | 326533 | 2020-07-12 | Quitman | Mississippi | 28119 | 101 | 1 |
326534 | 326534 | 2020-07-12 | Rankin | Mississippi | 28121 | 1126 | 19 |
326535 | 326535 | 2020-07-12 | Scott | Mississippi | 28123 | 824 | 15 |
326536 | 326536 | 2020-07-12 | Sharkey | Mississippi | 28125 | 48 | 0 |
326537 | 326537 | 2020-07-12 | Simpson | Mississippi | 28127 | 443 | 3 |
326538 | 326538 | 2020-07-12 | Smith | Mississippi | 28129 | 252 | 12 |
326539 | 326539 | 2020-07-12 | Stone | Mississippi | 28131 | 77 | 2 |
326540 | 326540 | 2020-07-12 | Sunflower | Mississippi | 28133 | 504 | 8 |
326541 | 326541 | 2020-07-12 | Tallahatchie | Mississippi | 28135 | 195 | 4 |
326542 | 326542 | 2020-07-12 | Tate | Mississippi | 28137 | 392 | 13 |
326543 | 326543 | 2020-07-12 | Tippah | Mississippi | 28139 | 146 | 11 |
326544 | 326544 | 2020-07-12 | Tishomingo | Mississippi | 28141 | 106 | 1 |
326545 | 326545 | 2020-07-12 | Tunica | Mississippi | 28143 | 125 | 3 |
326546 | 326546 | 2020-07-12 | Union | Mississippi | 28145 | 254 | 12 |
326547 | 326547 | 2020-07-12 | Walthall | Mississippi | 28147 | 270 | 8 |
326548 | 326548 | 2020-07-12 | Warren | Mississippi | 28149 | 600 | 21 |
326549 | 326549 | 2020-07-12 | Washington | Mississippi | 28151 | 737 | 13 |
326550 | 326550 | 2020-07-12 | Wayne | Mississippi | 28153 | 565 | 19 |
326551 | 326551 | 2020-07-12 | Webster | Mississippi | 28155 | 134 | 11 |
326552 | 326552 | 2020-07-12 | Wilkinson | Mississippi | 28157 | 98 | 9 |
326553 | 326553 | 2020-07-12 | Winston | Mississippi | 28159 | 301 | 11 |
326554 | 326554 | 2020-07-12 | Yalobusha | Mississippi | 28161 | 208 | 9 |
326555 | 326555 | 2020-07-12 | Yazoo | Mississippi | 28163 | 560 | 7 |
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);