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-12-17 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
837476 | 837476 | 2020-12-17 | Adams | Mississippi | 28001 | 1644 | 52 |
837477 | 837477 | 2020-12-17 | Alcorn | Mississippi | 28003 | 1885 | 37 |
837478 | 837478 | 2020-12-17 | Amite | Mississippi | 28005 | 769 | 16 |
837479 | 837479 | 2020-12-17 | Attala | Mississippi | 28007 | 1490 | 43 |
837480 | 837480 | 2020-12-17 | Benton | Mississippi | 28009 | 586 | 19 |
837481 | 837481 | 2020-12-17 | Bolivar | Mississippi | 28011 | 2941 | 91 |
837482 | 837482 | 2020-12-17 | Calhoun | Mississippi | 28013 | 951 | 15 |
837483 | 837483 | 2020-12-17 | Carroll | Mississippi | 28015 | 873 | 17 |
837484 | 837484 | 2020-12-17 | Chickasaw | Mississippi | 28017 | 1355 | 35 |
837485 | 837485 | 2020-12-17 | Choctaw | Mississippi | 28019 | 441 | 10 |
837486 | 837486 | 2020-12-17 | Claiborne | Mississippi | 28021 | 631 | 18 |
837487 | 837487 | 2020-12-17 | Clarke | Mississippi | 28023 | 1085 | 55 |
837488 | 837488 | 2020-12-17 | Clay | Mississippi | 28025 | 1145 | 28 |
837489 | 837489 | 2020-12-17 | Coahoma | Mississippi | 28027 | 1780 | 47 |
837490 | 837490 | 2020-12-17 | Copiah | Mississippi | 28029 | 1997 | 42 |
837491 | 837491 | 2020-12-17 | Covington | Mississippi | 28031 | 1631 | 63 |
837492 | 837492 | 2020-12-17 | DeSoto | Mississippi | 28033 | 12561 | 117 |
837493 | 837493 | 2020-12-17 | Forrest | Mississippi | 28035 | 4642 | 93 |
837494 | 837494 | 2020-12-17 | Franklin | Mississippi | 28037 | 491 | 6 |
837495 | 837495 | 2020-12-17 | George | Mississippi | 28039 | 1534 | 30 |
837496 | 837496 | 2020-12-17 | Greene | Mississippi | 28041 | 894 | 25 |
837497 | 837497 | 2020-12-17 | Grenada | Mississippi | 28043 | 1779 | 53 |
837498 | 837498 | 2020-12-17 | Hancock | Mississippi | 28045 | 1624 | 49 |
837499 | 837499 | 2020-12-17 | Harrison | Mississippi | 28047 | 9181 | 130 |
837500 | 837500 | 2020-12-17 | Hinds | Mississippi | 28049 | 12361 | 230 |
837501 | 837501 | 2020-12-17 | Holmes | Mississippi | 28051 | 1494 | 63 |
837502 | 837502 | 2020-12-17 | Humphreys | Mississippi | 28053 | 651 | 21 |
837503 | 837503 | 2020-12-17 | Issaquena | Mississippi | 28055 | 139 | 4 |
837504 | 837504 | 2020-12-17 | Itawamba | Mississippi | 28057 | 1932 | 46 |
837505 | 837505 | 2020-12-17 | Jackson | Mississippi | 28059 | 7711 | 145 |
837506 | 837506 | 2020-12-17 | Jasper | Mississippi | 28061 | 1130 | 24 |
837507 | 837507 | 2020-12-17 | Jefferson | Mississippi | 28063 | 434 | 12 |
837508 | 837508 | 2020-12-17 | Jefferson Davis | Mississippi | 28065 | 685 | 21 |
837509 | 837509 | 2020-12-17 | Jones | Mississippi | 28067 | 4536 | 91 |
837510 | 837510 | 2020-12-17 | Kemper | Mississippi | 28069 | 615 | 19 |
837511 | 837511 | 2020-12-17 | Lafayette | Mississippi | 28071 | 3752 | 70 |
837512 | 837512 | 2020-12-17 | Lamar | Mississippi | 28073 | 3610 | 52 |
837513 | 837513 | 2020-12-17 | Lauderdale | Mississippi | 28075 | 4357 | 159 |
837514 | 837514 | 2020-12-17 | Lawrence | Mississippi | 28077 | 857 | 15 |
837515 | 837515 | 2020-12-17 | Leake | Mississippi | 28079 | 1698 | 45 |
837516 | 837516 | 2020-12-17 | Lee | Mississippi | 28081 | 6595 | 106 |
837517 | 837517 | 2020-12-17 | Leflore | Mississippi | 28083 | 2388 | 98 |
837518 | 837518 | 2020-12-17 | Lincoln | Mississippi | 28085 | 2265 | 73 |
837519 | 837519 | 2020-12-17 | Lowndes | Mississippi | 28087 | 3507 | 74 |
837520 | 837520 | 2020-12-17 | Madison | Mississippi | 28089 | 6196 | 125 |
837521 | 837521 | 2020-12-17 | Marion | Mississippi | 28091 | 1518 | 55 |
837522 | 837522 | 2020-12-17 | Marshall | Mississippi | 28093 | 2587 | 58 |
837523 | 837523 | 2020-12-17 | Monroe | Mississippi | 28095 | 2580 | 83 |
837524 | 837524 | 2020-12-17 | Montgomery | Mississippi | 28097 | 908 | 30 |
837525 | 837525 | 2020-12-17 | Neshoba | Mississippi | 28099 | 2675 | 133 |
837526 | 837526 | 2020-12-17 | Newton | Mississippi | 28101 | 1369 | 32 |
837527 | 837527 | 2020-12-17 | Noxubee | Mississippi | 28103 | 843 | 17 |
837528 | 837528 | 2020-12-17 | Oktibbeha | Mississippi | 28105 | 2985 | 67 |
837529 | 837529 | 2020-12-17 | Panola | Mississippi | 28107 | 2800 | 67 |
837530 | 837530 | 2020-12-17 | Pearl River | Mississippi | 28109 | 2139 | 75 |
837531 | 837531 | 2020-12-17 | Perry | Mississippi | 28111 | 764 | 30 |
837532 | 837532 | 2020-12-17 | Pike | Mississippi | 28113 | 1939 | 65 |
837533 | 837533 | 2020-12-17 | Pontotoc | Mississippi | 28115 | 2684 | 34 |
837534 | 837534 | 2020-12-17 | Prentiss | Mississippi | 28117 | 1817 | 40 |
837535 | 837535 | 2020-12-17 | Quitman | Mississippi | 28119 | 556 | 7 |
837536 | 837536 | 2020-12-17 | Rankin | Mississippi | 28121 | 7636 | 140 |
837537 | 837537 | 2020-12-17 | Scott | Mississippi | 28123 | 1873 | 34 |
837538 | 837538 | 2020-12-17 | Sharkey | Mississippi | 28125 | 362 | 17 |
837539 | 837539 | 2020-12-17 | Simpson | Mississippi | 28127 | 1774 | 57 |
837540 | 837540 | 2020-12-17 | Smith | Mississippi | 28129 | 891 | 17 |
837541 | 837541 | 2020-12-17 | Stone | Mississippi | 28131 | 1015 | 18 |
837542 | 837542 | 2020-12-17 | Sunflower | Mississippi | 28133 | 2167 | 57 |
837543 | 837543 | 2020-12-17 | Tallahatchie | Mississippi | 28135 | 1113 | 29 |
837544 | 837544 | 2020-12-17 | Tate | Mississippi | 28137 | 2158 | 53 |
837545 | 837545 | 2020-12-17 | Tippah | Mississippi | 28139 | 1708 | 36 |
837546 | 837546 | 2020-12-17 | Tishomingo | Mississippi | 28141 | 1369 | 48 |
837547 | 837547 | 2020-12-17 | Tunica | Mississippi | 28143 | 679 | 19 |
837548 | 837548 | 2020-12-17 | Union | Mississippi | 28145 | 2358 | 27 |
837549 | 837549 | 2020-12-17 | Walthall | Mississippi | 28147 | 890 | 32 |
837550 | 837550 | 2020-12-17 | Warren | Mississippi | 28149 | 2243 | 67 |
837551 | 837551 | 2020-12-17 | Washington | Mississippi | 28151 | 3754 | 110 |
837552 | 837552 | 2020-12-17 | Wayne | Mississippi | 28153 | 1505 | 25 |
837553 | 837553 | 2020-12-17 | Webster | Mississippi | 28155 | 632 | 17 |
837554 | 837554 | 2020-12-17 | Wilkinson | Mississippi | 28157 | 489 | 22 |
837555 | 837555 | 2020-12-17 | Winston | Mississippi | 28159 | 1612 | 44 |
837556 | 837556 | 2020-12-17 | Yalobusha | Mississippi | 28161 | 860 | 30 |
837557 | 837557 | 2020-12-17 | Yazoo | Mississippi | 28163 | 1829 | 44 |
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);