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 793
- 28083 791
- 28109 791
- 28029 790
- 28049 789
- 28045 788
- 28095 788
- 28047 787
- 28059 787
- 28089 786
- 28111 786
- 28011 785
- 28027 785
- 28033 785
- 28051 785
- 28067 785
- 28123 785
- 28147 785
- 28157 785
- 28159 785
- 28163 785
- 28037 784
- 28053 784
- 28071 784
- 28077 784
- 28081 784
- 28093 784
- 28113 784
- 28121 784
- 28129 784
- …
county >30
- Forrest 793
- Leflore 791
- Pearl River 791
- Copiah 790
- Hinds 789
- Hancock 788
- Monroe 788
- Harrison 787
- Jackson 787
- Madison 786
- Perry 786
- Bolivar 785
- Coahoma 785
- DeSoto 785
- Holmes 785
- Jones 785
- Scott 785
- Walthall 785
- Wilkinson 785
- Winston 785
- Yazoo 785
- Franklin 784
- Humphreys 784
- Lafayette 784
- Lawrence 784
- Lee 784
- Marshall 784
- Pike 784
- Rankin 784
- Smith 784
- …
state 1
- Mississippi · 64,047 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497752 | 2497752 | 2022-05-12 | Forrest | Mississippi | 28035 | 22076 | 315 |
2497753 | 2497753 | 2022-05-12 | Franklin | Mississippi | 28037 | 1927 | 38 |
2497754 | 2497754 | 2022-05-12 | George | Mississippi | 28039 | 7163 | 87 |
2497755 | 2497755 | 2022-05-12 | Greene | Mississippi | 28041 | 3198 | 59 |
2497756 | 2497756 | 2022-05-12 | Grenada | Mississippi | 28043 | 5533 | 131 |
2497757 | 2497757 | 2022-05-12 | Hancock | Mississippi | 28045 | 12277 | 152 |
2497758 | 2497758 | 2022-05-12 | Harrison | Mississippi | 28047 | 53859 | 665 |
2497759 | 2497759 | 2022-05-12 | Hinds | Mississippi | 28049 | 52682 | 791 |
2497760 | 2497760 | 2022-05-12 | Holmes | Mississippi | 28051 | 4455 | 104 |
2497761 | 2497761 | 2022-05-12 | Humphreys | Mississippi | 28053 | 2030 | 46 |
2497762 | 2497762 | 2022-05-12 | Issaquena | Mississippi | 28055 | 262 | 9 |
2497763 | 2497763 | 2022-05-12 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2497764 | 2497764 | 2022-05-12 | Jackson | Mississippi | 28059 | 37055 | 463 |
2497765 | 2497765 | 2022-05-12 | Jasper | Mississippi | 28061 | 4943 | 75 |
2497766 | 2497766 | 2022-05-12 | Jefferson | Mississippi | 28063 | 1494 | 37 |
2497767 | 2497767 | 2022-05-12 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2497768 | 2497768 | 2022-05-12 | Jones | Mississippi | 28067 | 21234 | 295 |
2497769 | 2497769 | 2022-05-12 | Kemper | Mississippi | 28069 | 2187 | 48 |
2497770 | 2497770 | 2022-05-12 | Lafayette | Mississippi | 28071 | 15364 | 179 |
2497771 | 2497771 | 2022-05-12 | Lamar | Mississippi | 28073 | 17441 | 160 |
2497772 | 2497772 | 2022-05-12 | Lauderdale | Mississippi | 28075 | 18898 | 367 |
2497773 | 2497773 | 2022-05-12 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2497774 | 2497774 | 2022-05-12 | Leake | Mississippi | 28079 | 6427 | 120 |
2497775 | 2497775 | 2022-05-12 | Lee | Mississippi | 28081 | 26783 | 301 |
2497776 | 2497776 | 2022-05-12 | Leflore | Mississippi | 28083 | 7326 | 169 |
2497777 | 2497777 | 2022-05-12 | Lincoln | Mississippi | 28085 | 8324 | 157 |
2497778 | 2497778 | 2022-05-12 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2497779 | 2497779 | 2022-05-12 | Madison | Mississippi | 28089 | 24189 | 329 |
2497780 | 2497780 | 2022-05-12 | Marion | Mississippi | 28091 | 6974 | 135 |
2497781 | 2497781 | 2022-05-12 | Marshall | Mississippi | 28093 | 9941 | 174 |
2497782 | 2497782 | 2022-05-12 | Monroe | Mississippi | 28095 | 10997 | 220 |
2497783 | 2497783 | 2022-05-12 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2497784 | 2497784 | 2022-05-12 | Neshoba | Mississippi | 28099 | 10622 | 241 |
2497785 | 2497785 | 2022-05-12 | Newton | Mississippi | 28101 | 6059 | 98 |
2497786 | 2497786 | 2022-05-12 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2497787 | 2497787 | 2022-05-12 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2497788 | 2497788 | 2022-05-12 | Panola | Mississippi | 28107 | 10566 | 169 |
2497789 | 2497789 | 2022-05-12 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2497790 | 2497790 | 2022-05-12 | Perry | Mississippi | 28111 | 3048 | 64 |
2497791 | 2497791 | 2022-05-12 | Pike | Mississippi | 28113 | 9751 | 189 |
2497792 | 2497792 | 2022-05-12 | Pontotoc | Mississippi | 28115 | 10364 | 145 |
2497793 | 2497793 | 2022-05-12 | Prentiss | Mississippi | 28117 | 8245 | 103 |
2497794 | 2497794 | 2022-05-12 | Quitman | Mississippi | 28119 | 1579 | 31 |
2497795 | 2497795 | 2022-05-12 | Rankin | Mississippi | 28121 | 36738 | 489 |
2497796 | 2497796 | 2022-05-12 | Scott | Mississippi | 28123 | 6559 | 119 |
2497797 | 2497797 | 2022-05-12 | Sharkey | Mississippi | 28125 | 953 | 26 |
2497798 | 2497798 | 2022-05-12 | Simpson | Mississippi | 28127 | 7026 | 149 |
2497799 | 2497799 | 2022-05-12 | Smith | Mississippi | 28129 | 4127 | 68 |
2497800 | 2497800 | 2022-05-12 | Stone | Mississippi | 28131 | 5409 | 71 |
2497801 | 2497801 | 2022-05-12 | Sunflower | Mississippi | 28133 | 5773 | 125 |
2497802 | 2497802 | 2022-05-12 | Tallahatchie | Mississippi | 28135 | 3203 | 60 |
2497803 | 2497803 | 2022-05-12 | Tate | Mississippi | 28137 | 7396 | 143 |
2497804 | 2497804 | 2022-05-12 | Tippah | Mississippi | 28139 | 7361 | 109 |
2497805 | 2497805 | 2022-05-12 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2497806 | 2497806 | 2022-05-12 | Tunica | Mississippi | 28143 | 2559 | 48 |
2497807 | 2497807 | 2022-05-12 | Union | Mississippi | 28145 | 9487 | 122 |
2497808 | 2497808 | 2022-05-12 | Unknown | Mississippi | 1218 | 3 | |
2497809 | 2497809 | 2022-05-12 | Walthall | Mississippi | 28147 | 3622 | 79 |
2497810 | 2497810 | 2022-05-12 | Warren | Mississippi | 28149 | 10250 | 202 |
2497811 | 2497811 | 2022-05-12 | Washington | Mississippi | 28151 | 10470 | 199 |
2497812 | 2497812 | 2022-05-12 | Wayne | Mississippi | 28153 | 6008 | 87 |
2497813 | 2497813 | 2022-05-12 | Webster | Mississippi | 28155 | 3388 | 70 |
2497814 | 2497814 | 2022-05-12 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2497815 | 2497815 | 2022-05-12 | Winston | Mississippi | 28159 | 5231 | 104 |
2497816 | 2497816 | 2022-05-12 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2497817 | 2497817 | 2022-05-12 | Yazoo | Mississippi | 28163 | 8054 | 107 |
2494477 | 2494477 | 2022-05-11 | Adams | Mississippi | 28001 | 7224 | 143 |
2494478 | 2494478 | 2022-05-11 | Alcorn | Mississippi | 28003 | 10080 | 160 |
2494479 | 2494479 | 2022-05-11 | Amite | Mississippi | 28005 | 3259 | 69 |
2494480 | 2494480 | 2022-05-11 | Attala | Mississippi | 28007 | 5361 | 113 |
2494481 | 2494481 | 2022-05-11 | Benton | Mississippi | 28009 | 2274 | 49 |
2494482 | 2494482 | 2022-05-11 | Bolivar | Mississippi | 28011 | 9354 | 179 |
2494483 | 2494483 | 2022-05-11 | Calhoun | Mississippi | 28013 | 4641 | 71 |
2494484 | 2494484 | 2022-05-11 | Carroll | Mississippi | 28015 | 2565 | 54 |
2494485 | 2494485 | 2022-05-11 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2494486 | 2494486 | 2022-05-11 | Choctaw | Mississippi | 28019 | 2318 | 33 |
2494487 | 2494487 | 2022-05-11 | Claiborne | Mississippi | 28021 | 2152 | 46 |
2494488 | 2494488 | 2022-05-11 | Clarke | Mississippi | 28023 | 4239 | 108 |
2494489 | 2494489 | 2022-05-11 | Clay | Mississippi | 28025 | 4974 | 98 |
2494490 | 2494490 | 2022-05-11 | Coahoma | Mississippi | 28027 | 6486 | 126 |
2494491 | 2494491 | 2022-05-11 | Copiah | Mississippi | 28029 | 7287 | 121 |
2494492 | 2494492 | 2022-05-11 | Covington | Mississippi | 28031 | 7086 | 113 |
2494493 | 2494493 | 2022-05-11 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2494494 | 2494494 | 2022-05-11 | Forrest | Mississippi | 28035 | 22076 | 315 |
2494495 | 2494495 | 2022-05-11 | Franklin | Mississippi | 28037 | 1927 | 38 |
2494496 | 2494496 | 2022-05-11 | George | Mississippi | 28039 | 7163 | 87 |
2494497 | 2494497 | 2022-05-11 | Greene | Mississippi | 28041 | 3198 | 59 |
2494498 | 2494498 | 2022-05-11 | Grenada | Mississippi | 28043 | 5533 | 131 |
2494499 | 2494499 | 2022-05-11 | Hancock | Mississippi | 28045 | 12277 | 152 |
2494500 | 2494500 | 2022-05-11 | Harrison | Mississippi | 28047 | 53859 | 665 |
2494501 | 2494501 | 2022-05-11 | Hinds | Mississippi | 28049 | 52682 | 791 |
2494502 | 2494502 | 2022-05-11 | Holmes | Mississippi | 28051 | 4455 | 104 |
2494503 | 2494503 | 2022-05-11 | Humphreys | Mississippi | 28053 | 2030 | 46 |
2494504 | 2494504 | 2022-05-11 | Issaquena | Mississippi | 28055 | 262 | 9 |
2494505 | 2494505 | 2022-05-11 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2494506 | 2494506 | 2022-05-11 | Jackson | Mississippi | 28059 | 37055 | 463 |
2494507 | 2494507 | 2022-05-11 | Jasper | Mississippi | 28061 | 4943 | 75 |
2494508 | 2494508 | 2022-05-11 | Jefferson | Mississippi | 28063 | 1494 | 37 |
2494509 | 2494509 | 2022-05-11 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2494510 | 2494510 | 2022-05-11 | Jones | Mississippi | 28067 | 21234 | 295 |
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);