ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where "date" is on date 2020-04-15 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 81
- 28001 1
- 28003 1
- 28005 1
- 28007 1
- 28009 1
- 28011 1
- 28013 1
- 28015 1
- 28017 1
- 28019 1
- 28021 1
- 28023 1
- 28025 1
- 28027 1
- 28029 1
- 28031 1
- 28033 1
- 28035 1
- 28037 1
- 28039 1
- 28041 1
- 28043 1
- 28045 1
- 28047 1
- 28049 1
- 28051 1
- 28053 1
- 28057 1
- 28059 1
- 28061 1
- 28063 1
- 28065 1
- 28067 1
- 28069 1
- 28071 1
- 28073 1
- 28075 1
- 28077 1
- 28079 1
- 28081 1
- 28083 1
- 28085 1
- 28087 1
- 28089 1
- 28091 1
- 28093 1
- 28095 1
- 28097 1
- 28099 1
- 28101 1
- 28103 1
- 28105 1
- 28107 1
- 28109 1
- 28111 1
- 28113 1
- 28115 1
- 28117 1
- 28119 1
- 28121 1
- 28123 1
- 28125 1
- 28127 1
- 28129 1
- 28131 1
- 28133 1
- 28135 1
- 28137 1
- 28139 1
- 28141 1
- 28143 1
- 28145 1
- 28147 1
- 28149 1
- 28151 1
- 28153 1
- 28155 1
- 28157 1
- 28159 1
- 28161 1
- 28163 1
county 81
- Adams 1
- Alcorn 1
- Amite 1
- Attala 1
- Benton 1
- Bolivar 1
- Calhoun 1
- Carroll 1
- Chickasaw 1
- Choctaw 1
- Claiborne 1
- Clarke 1
- Clay 1
- Coahoma 1
- Copiah 1
- Covington 1
- DeSoto 1
- Forrest 1
- Franklin 1
- George 1
- Greene 1
- Grenada 1
- Hancock 1
- Harrison 1
- Hinds 1
- Holmes 1
- Humphreys 1
- Itawamba 1
- Jackson 1
- Jasper 1
- Jefferson 1
- Jefferson Davis 1
- Jones 1
- Kemper 1
- Lafayette 1
- Lamar 1
- Lauderdale 1
- Lawrence 1
- Leake 1
- Lee 1
- Leflore 1
- Lincoln 1
- Lowndes 1
- Madison 1
- Marion 1
- Marshall 1
- Monroe 1
- Montgomery 1
- Neshoba 1
- Newton 1
- Noxubee 1
- Oktibbeha 1
- Panola 1
- Pearl River 1
- Perry 1
- Pike 1
- Pontotoc 1
- Prentiss 1
- Quitman 1
- Rankin 1
- Scott 1
- Sharkey 1
- Simpson 1
- Smith 1
- Stone 1
- Sunflower 1
- Tallahatchie 1
- Tate 1
- Tippah 1
- Tishomingo 1
- Tunica 1
- Union 1
- Walthall 1
- Warren 1
- Washington 1
- Wayne 1
- Webster 1
- Wilkinson 1
- Winston 1
- Yalobusha 1
- Yazoo 1
state 1
- Mississippi · 81 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
60425 | 60425 | 2020-04-15 | Adams | Mississippi | 28001 | 64 | 3 |
60426 | 60426 | 2020-04-15 | Alcorn | Mississippi | 28003 | 7 | 0 |
60427 | 60427 | 2020-04-15 | Amite | Mississippi | 28005 | 15 | 1 |
60428 | 60428 | 2020-04-15 | Attala | Mississippi | 28007 | 25 | 0 |
60429 | 60429 | 2020-04-15 | Benton | Mississippi | 28009 | 5 | 0 |
60430 | 60430 | 2020-04-15 | Bolivar | Mississippi | 28011 | 70 | 5 |
60431 | 60431 | 2020-04-15 | Calhoun | Mississippi | 28013 | 27 | 2 |
60432 | 60432 | 2020-04-15 | Carroll | Mississippi | 28015 | 9 | 0 |
60433 | 60433 | 2020-04-15 | Chickasaw | Mississippi | 28017 | 33 | 2 |
60434 | 60434 | 2020-04-15 | Choctaw | Mississippi | 28019 | 11 | 1 |
60435 | 60435 | 2020-04-15 | Claiborne | Mississippi | 28021 | 8 | 0 |
60436 | 60436 | 2020-04-15 | Clarke | Mississippi | 28023 | 19 | 1 |
60437 | 60437 | 2020-04-15 | Clay | Mississippi | 28025 | 21 | 0 |
60438 | 60438 | 2020-04-15 | Coahoma | Mississippi | 28027 | 43 | 1 |
60439 | 60439 | 2020-04-15 | Copiah | Mississippi | 28029 | 35 | 0 |
60440 | 60440 | 2020-04-15 | Covington | Mississippi | 28031 | 19 | 0 |
60441 | 60441 | 2020-04-15 | DeSoto | Mississippi | 28033 | 199 | 3 |
60442 | 60442 | 2020-04-15 | Forrest | Mississippi | 28035 | 122 | 2 |
60443 | 60443 | 2020-04-15 | Franklin | Mississippi | 28037 | 10 | 0 |
60444 | 60444 | 2020-04-15 | George | Mississippi | 28039 | 8 | 0 |
60445 | 60445 | 2020-04-15 | Greene | Mississippi | 28041 | 3 | 0 |
60446 | 60446 | 2020-04-15 | Grenada | Mississippi | 28043 | 14 | 0 |
60447 | 60447 | 2020-04-15 | Hancock | Mississippi | 28045 | 49 | 5 |
60448 | 60448 | 2020-04-15 | Harrison | Mississippi | 28047 | 129 | 5 |
60449 | 60449 | 2020-04-15 | Hinds | Mississippi | 28049 | 280 | 4 |
60450 | 60450 | 2020-04-15 | Holmes | Mississippi | 28051 | 52 | 3 |
60451 | 60451 | 2020-04-15 | Humphreys | Mississippi | 28053 | 12 | 2 |
60452 | 60452 | 2020-04-15 | Itawamba | Mississippi | 28057 | 11 | 0 |
60453 | 60453 | 2020-04-15 | Jackson | Mississippi | 28059 | 182 | 5 |
60454 | 60454 | 2020-04-15 | Jasper | Mississippi | 28061 | 15 | 0 |
60455 | 60455 | 2020-04-15 | Jefferson | Mississippi | 28063 | 4 | 0 |
60456 | 60456 | 2020-04-15 | Jefferson Davis | Mississippi | 28065 | 7 | 1 |
60457 | 60457 | 2020-04-15 | Jones | Mississippi | 28067 | 42 | 0 |
60458 | 60458 | 2020-04-15 | Kemper | Mississippi | 28069 | 15 | 0 |
60459 | 60459 | 2020-04-15 | Lafayette | Mississippi | 28071 | 36 | 2 |
60460 | 60460 | 2020-04-15 | Lamar | Mississippi | 28073 | 48 | 1 |
60461 | 60461 | 2020-04-15 | Lauderdale | Mississippi | 28075 | 165 | 12 |
60462 | 60462 | 2020-04-15 | Lawrence | Mississippi | 28077 | 7 | 0 |
60463 | 60463 | 2020-04-15 | Leake | Mississippi | 28079 | 40 | 1 |
60464 | 60464 | 2020-04-15 | Lee | Mississippi | 28081 | 46 | 4 |
60465 | 60465 | 2020-04-15 | Leflore | Mississippi | 28083 | 55 | 6 |
60466 | 60466 | 2020-04-15 | Lincoln | Mississippi | 28085 | 81 | 4 |
60467 | 60467 | 2020-04-15 | Lowndes | Mississippi | 28087 | 27 | 0 |
60468 | 60468 | 2020-04-15 | Madison | Mississippi | 28089 | 112 | 3 |
60469 | 60469 | 2020-04-15 | Marion | Mississippi | 28091 | 34 | 0 |
60470 | 60470 | 2020-04-15 | Marshall | Mississippi | 28093 | 35 | 2 |
60471 | 60471 | 2020-04-15 | Monroe | Mississippi | 28095 | 46 | 2 |
60472 | 60472 | 2020-04-15 | Montgomery | Mississippi | 28097 | 15 | 1 |
60473 | 60473 | 2020-04-15 | Neshoba | Mississippi | 28099 | 35 | 1 |
60474 | 60474 | 2020-04-15 | Newton | Mississippi | 28101 | 14 | 0 |
60475 | 60475 | 2020-04-15 | Noxubee | Mississippi | 28103 | 10 | 0 |
60476 | 60476 | 2020-04-15 | Oktibbeha | Mississippi | 28105 | 41 | 1 |
60477 | 60477 | 2020-04-15 | Panola | Mississippi | 28107 | 26 | 2 |
60478 | 60478 | 2020-04-15 | Pearl River | Mississippi | 28109 | 102 | 8 |
60479 | 60479 | 2020-04-15 | Perry | Mississippi | 28111 | 20 | 1 |
60480 | 60480 | 2020-04-15 | Pike | Mississippi | 28113 | 72 | 2 |
60481 | 60481 | 2020-04-15 | Pontotoc | Mississippi | 28115 | 15 | 2 |
60482 | 60482 | 2020-04-15 | Prentiss | Mississippi | 28117 | 15 | 0 |
60483 | 60483 | 2020-04-15 | Quitman | Mississippi | 28119 | 13 | 0 |
60484 | 60484 | 2020-04-15 | Rankin | Mississippi | 28121 | 113 | 2 |
60485 | 60485 | 2020-04-15 | Scott | Mississippi | 28123 | 79 | 0 |
60486 | 60486 | 2020-04-15 | Sharkey | Mississippi | 28125 | 3 | 0 |
60487 | 60487 | 2020-04-15 | Simpson | Mississippi | 28127 | 12 | 0 |
60488 | 60488 | 2020-04-15 | Smith | Mississippi | 28129 | 36 | 1 |
60489 | 60489 | 2020-04-15 | Stone | Mississippi | 28131 | 15 | 0 |
60490 | 60490 | 2020-04-15 | Sunflower | Mississippi | 28133 | 42 | 2 |
60491 | 60491 | 2020-04-15 | Tallahatchie | Mississippi | 28135 | 6 | 0 |
60492 | 60492 | 2020-04-15 | Tate | Mississippi | 28137 | 26 | 0 |
60493 | 60493 | 2020-04-15 | Tippah | Mississippi | 28139 | 45 | 6 |
60494 | 60494 | 2020-04-15 | Tishomingo | Mississippi | 28141 | 2 | 0 |
60495 | 60495 | 2020-04-15 | Tunica | Mississippi | 28143 | 23 | 1 |
60496 | 60496 | 2020-04-15 | Union | Mississippi | 28145 | 9 | 1 |
60497 | 60497 | 2020-04-15 | Walthall | Mississippi | 28147 | 22 | 0 |
60498 | 60498 | 2020-04-15 | Warren | Mississippi | 28149 | 15 | 1 |
60499 | 60499 | 2020-04-15 | Washington | Mississippi | 28151 | 62 | 2 |
60500 | 60500 | 2020-04-15 | Wayne | Mississippi | 28153 | 9 | 0 |
60501 | 60501 | 2020-04-15 | Webster | Mississippi | 28155 | 14 | 1 |
60502 | 60502 | 2020-04-15 | Wilkinson | Mississippi | 28157 | 51 | 3 |
60503 | 60503 | 2020-04-15 | Winston | Mississippi | 28159 | 22 | 0 |
60504 | 60504 | 2020-04-15 | Yalobusha | Mississippi | 28161 | 14 | 0 |
60505 | 60505 | 2020-04-15 | Yazoo | Mississippi | 28163 | 65 | 1 |
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);