ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64,147 rows where state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 28035 307
- 28029 305
- 28083 305
- 28109 305
- 28049 303
- 28045 302
- 28095 302
- 28047 301
- 28059 301
- 28011 300
- 28027 300
- 28033 300
- 28089 300
- 28111 300
- 28051 299
- 28067 299
- 28123 299
- 28147 299
- 28157 299
- 28159 299
- 28163 299
- 28001 298
- 28037 298
- 28053 298
- 28071 298
- 28077 298
- 28081 298
- 28093 298
- 28113 298
- 28121 298
- …
county >30
- Forrest 307
- Copiah 305
- Leflore 305
- Pearl River 305
- Hinds 303
- Hancock 302
- Monroe 302
- Harrison 301
- Jackson 301
- Bolivar 300
- Coahoma 300
- DeSoto 300
- Madison 300
- Perry 300
- Holmes 299
- Jones 299
- Scott 299
- Walthall 299
- Wilkinson 299
- Winston 299
- Yazoo 299
- Adams 298
- Franklin 298
- Humphreys 298
- Lafayette 298
- Lawrence 298
- Lee 298
- Marshall 298
- Pike 298
- Rankin 298
- …
state 1
- Mississippi · 24,156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
918607 | 918607 | 2021-01-11 | Adams | Mississippi | 28001 | 1960 | 65 |
918608 | 918608 | 2021-01-11 | Alcorn | Mississippi | 28003 | 2488 | 45 |
918609 | 918609 | 2021-01-11 | Amite | Mississippi | 28005 | 942 | 25 |
918610 | 918610 | 2021-01-11 | Attala | Mississippi | 28007 | 1884 | 55 |
918611 | 918611 | 2021-01-11 | Benton | Mississippi | 28009 | 780 | 22 |
918612 | 918612 | 2021-01-11 | Bolivar | Mississippi | 28011 | 3842 | 101 |
918613 | 918613 | 2021-01-11 | Calhoun | Mississippi | 28013 | 1293 | 19 |
918614 | 918614 | 2021-01-11 | Carroll | Mississippi | 28015 | 1011 | 20 |
918615 | 918615 | 2021-01-11 | Chickasaw | Mississippi | 28017 | 1766 | 42 |
918616 | 918616 | 2021-01-11 | Choctaw | Mississippi | 28019 | 575 | 12 |
918617 | 918617 | 2021-01-11 | Claiborne | Mississippi | 28021 | 827 | 23 |
918618 | 918618 | 2021-01-11 | Clarke | Mississippi | 28023 | 1322 | 60 |
918619 | 918619 | 2021-01-11 | Clay | Mississippi | 28025 | 1507 | 31 |
918620 | 918620 | 2021-01-11 | Coahoma | Mississippi | 28027 | 2146 | 53 |
918621 | 918621 | 2021-01-11 | Copiah | Mississippi | 28029 | 2328 | 47 |
918622 | 918622 | 2021-01-11 | Covington | Mississippi | 28031 | 2033 | 69 |
918623 | 918623 | 2021-01-11 | DeSoto | Mississippi | 28033 | 16358 | 155 |
918624 | 918624 | 2021-01-11 | Forrest | Mississippi | 28035 | 5733 | 111 |
918625 | 918625 | 2021-01-11 | Franklin | Mississippi | 28037 | 640 | 12 |
918626 | 918626 | 2021-01-11 | George | Mississippi | 28039 | 1897 | 37 |
918627 | 918627 | 2021-01-11 | Greene | Mississippi | 28041 | 1059 | 28 |
918628 | 918628 | 2021-01-11 | Grenada | Mississippi | 28043 | 2107 | 67 |
918629 | 918629 | 2021-01-11 | Hancock | Mississippi | 28045 | 2370 | 56 |
918630 | 918630 | 2021-01-11 | Harrison | Mississippi | 28047 | 12347 | 172 |
918631 | 918631 | 2021-01-11 | Hinds | Mississippi | 28049 | 15477 | 299 |
918632 | 918632 | 2021-01-11 | Holmes | Mississippi | 28051 | 1656 | 67 |
918633 | 918633 | 2021-01-11 | Humphreys | Mississippi | 28053 | 788 | 22 |
918634 | 918634 | 2021-01-11 | Issaquena | Mississippi | 28055 | 154 | 6 |
918635 | 918635 | 2021-01-11 | Itawamba | Mississippi | 28057 | 2503 | 56 |
918636 | 918636 | 2021-01-11 | Jackson | Mississippi | 28059 | 9717 | 167 |
918637 | 918637 | 2021-01-11 | Jasper | Mississippi | 28061 | 1603 | 31 |
918638 | 918638 | 2021-01-11 | Jefferson | Mississippi | 28063 | 511 | 18 |
918639 | 918639 | 2021-01-11 | Jefferson Davis | Mississippi | 28065 | 821 | 25 |
918640 | 918640 | 2021-01-11 | Jones | Mississippi | 28067 | 5953 | 103 |
918641 | 918641 | 2021-01-11 | Kemper | Mississippi | 28069 | 741 | 19 |
918642 | 918642 | 2021-01-11 | Lafayette | Mississippi | 28071 | 4713 | 88 |
918643 | 918643 | 2021-01-11 | Lamar | Mississippi | 28073 | 4601 | 61 |
918644 | 918644 | 2021-01-11 | Lauderdale | Mississippi | 28075 | 5510 | 174 |
918645 | 918645 | 2021-01-11 | Lawrence | Mississippi | 28077 | 976 | 17 |
918646 | 918646 | 2021-01-11 | Leake | Mississippi | 28079 | 2223 | 63 |
918647 | 918647 | 2021-01-11 | Lee | Mississippi | 28081 | 8472 | 133 |
918648 | 918648 | 2021-01-11 | Leflore | Mississippi | 28083 | 2912 | 104 |
918649 | 918649 | 2021-01-11 | Lincoln | Mississippi | 28085 | 2842 | 81 |
918650 | 918650 | 2021-01-11 | Lowndes | Mississippi | 28087 | 5059 | 100 |
918651 | 918651 | 2021-01-11 | Madison | Mississippi | 28089 | 7868 | 152 |
918652 | 918652 | 2021-01-11 | Marion | Mississippi | 28091 | 1988 | 69 |
918653 | 918653 | 2021-01-11 | Marshall | Mississippi | 28093 | 3264 | 63 |
918654 | 918654 | 2021-01-11 | Monroe | Mississippi | 28095 | 3394 | 98 |
918655 | 918655 | 2021-01-11 | Montgomery | Mississippi | 28097 | 1061 | 32 |
918656 | 918656 | 2021-01-11 | Neshoba | Mississippi | 28099 | 3221 | 148 |
918657 | 918657 | 2021-01-11 | Newton | Mississippi | 28101 | 1780 | 41 |
918658 | 918658 | 2021-01-11 | Noxubee | Mississippi | 28103 | 1065 | 21 |
918659 | 918659 | 2021-01-11 | Oktibbeha | Mississippi | 28105 | 3793 | 79 |
918660 | 918660 | 2021-01-11 | Panola | Mississippi | 28107 | 3493 | 73 |
918661 | 918661 | 2021-01-11 | Pearl River | Mississippi | 28109 | 3041 | 89 |
918662 | 918662 | 2021-01-11 | Perry | Mississippi | 28111 | 963 | 31 |
918663 | 918663 | 2021-01-11 | Pike | Mississippi | 28113 | 2483 | 75 |
918664 | 918664 | 2021-01-11 | Pontotoc | Mississippi | 28115 | 3499 | 49 |
918665 | 918665 | 2021-01-11 | Prentiss | Mississippi | 28117 | 2347 | 47 |
918666 | 918666 | 2021-01-11 | Quitman | Mississippi | 28119 | 645 | 7 |
918667 | 918667 | 2021-01-11 | Rankin | Mississippi | 28121 | 10084 | 189 |
918668 | 918668 | 2021-01-11 | Scott | Mississippi | 28123 | 2332 | 42 |
918669 | 918669 | 2021-01-11 | Sharkey | Mississippi | 28125 | 412 | 17 |
918670 | 918670 | 2021-01-11 | Simpson | Mississippi | 28127 | 2254 | 66 |
918671 | 918671 | 2021-01-11 | Smith | Mississippi | 28129 | 1142 | 20 |
918672 | 918672 | 2021-01-11 | Stone | Mississippi | 28131 | 1358 | 18 |
918673 | 918673 | 2021-01-11 | Sunflower | Mississippi | 28133 | 2711 | 68 |
918674 | 918674 | 2021-01-11 | Tallahatchie | Mississippi | 28135 | 1343 | 33 |
918675 | 918675 | 2021-01-11 | Tate | Mississippi | 28137 | 2572 | 58 |
918676 | 918676 | 2021-01-11 | Tippah | Mississippi | 28139 | 2246 | 45 |
918677 | 918677 | 2021-01-11 | Tishomingo | Mississippi | 28141 | 1747 | 56 |
918678 | 918678 | 2021-01-11 | Tunica | Mississippi | 28143 | 820 | 21 |
918679 | 918679 | 2021-01-11 | Union | Mississippi | 28145 | 3266 | 54 |
918680 | 918680 | 2021-01-11 | Walthall | Mississippi | 28147 | 1082 | 36 |
918681 | 918681 | 2021-01-11 | Warren | Mississippi | 28149 | 3252 | 90 |
918682 | 918682 | 2021-01-11 | Washington | Mississippi | 28151 | 4649 | 119 |
918683 | 918683 | 2021-01-11 | Wayne | Mississippi | 28153 | 1893 | 27 |
918684 | 918684 | 2021-01-11 | Webster | Mississippi | 28155 | 875 | 23 |
918685 | 918685 | 2021-01-11 | Wilkinson | Mississippi | 28157 | 560 | 24 |
918686 | 918686 | 2021-01-11 | Winston | Mississippi | 28159 | 1946 | 59 |
918687 | 918687 | 2021-01-11 | Yalobusha | Mississippi | 28161 | 1107 | 34 |
918688 | 918688 | 2021-01-11 | Yazoo | Mississippi | 28163 | 2306 | 52 |
915362 | 915362 | 2021-01-10 | Adams | Mississippi | 28001 | 1945 | 64 |
915363 | 915363 | 2021-01-10 | Alcorn | Mississippi | 28003 | 2479 | 45 |
915364 | 915364 | 2021-01-10 | Amite | Mississippi | 28005 | 940 | 25 |
915365 | 915365 | 2021-01-10 | Attala | Mississippi | 28007 | 1876 | 55 |
915366 | 915366 | 2021-01-10 | Benton | Mississippi | 28009 | 776 | 22 |
915367 | 915367 | 2021-01-10 | Bolivar | Mississippi | 28011 | 3828 | 101 |
915368 | 915368 | 2021-01-10 | Calhoun | Mississippi | 28013 | 1286 | 19 |
915369 | 915369 | 2021-01-10 | Carroll | Mississippi | 28015 | 1011 | 20 |
915370 | 915370 | 2021-01-10 | Chickasaw | Mississippi | 28017 | 1758 | 42 |
915371 | 915371 | 2021-01-10 | Choctaw | Mississippi | 28019 | 572 | 12 |
915372 | 915372 | 2021-01-10 | Claiborne | Mississippi | 28021 | 808 | 22 |
915373 | 915373 | 2021-01-10 | Clarke | Mississippi | 28023 | 1315 | 60 |
915374 | 915374 | 2021-01-10 | Clay | Mississippi | 28025 | 1496 | 31 |
915375 | 915375 | 2021-01-10 | Coahoma | Mississippi | 28027 | 2133 | 53 |
915376 | 915376 | 2021-01-10 | Copiah | Mississippi | 28029 | 2323 | 47 |
915377 | 915377 | 2021-01-10 | Covington | Mississippi | 28031 | 2030 | 69 |
915378 | 915378 | 2021-01-10 | DeSoto | Mississippi | 28033 | 16277 | 154 |
915379 | 915379 | 2021-01-10 | Forrest | Mississippi | 28035 | 5705 | 110 |
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);