ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2022-05-09" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487962 | 2487962 | 2022-05-09 | Adams | Mississippi | 28001 | 7224 | 143 |
2487963 | 2487963 | 2022-05-09 | Alcorn | Mississippi | 28003 | 10080 | 160 |
2487964 | 2487964 | 2022-05-09 | Amite | Mississippi | 28005 | 3259 | 69 |
2487965 | 2487965 | 2022-05-09 | Attala | Mississippi | 28007 | 5361 | 113 |
2487966 | 2487966 | 2022-05-09 | Benton | Mississippi | 28009 | 2274 | 49 |
2487967 | 2487967 | 2022-05-09 | Bolivar | Mississippi | 28011 | 9354 | 179 |
2487968 | 2487968 | 2022-05-09 | Calhoun | Mississippi | 28013 | 4641 | 71 |
2487969 | 2487969 | 2022-05-09 | Carroll | Mississippi | 28015 | 2565 | 54 |
2487970 | 2487970 | 2022-05-09 | Chickasaw | Mississippi | 28017 | 5603 | 96 |
2487971 | 2487971 | 2022-05-09 | Choctaw | Mississippi | 28019 | 2318 | 33 |
2487972 | 2487972 | 2022-05-09 | Claiborne | Mississippi | 28021 | 2152 | 46 |
2487973 | 2487973 | 2022-05-09 | Clarke | Mississippi | 28023 | 4239 | 108 |
2487974 | 2487974 | 2022-05-09 | Clay | Mississippi | 28025 | 4974 | 98 |
2487975 | 2487975 | 2022-05-09 | Coahoma | Mississippi | 28027 | 6486 | 126 |
2487976 | 2487976 | 2022-05-09 | Copiah | Mississippi | 28029 | 7287 | 121 |
2487977 | 2487977 | 2022-05-09 | Covington | Mississippi | 28031 | 7086 | 113 |
2487978 | 2487978 | 2022-05-09 | DeSoto | Mississippi | 28033 | 50344 | 554 |
2487979 | 2487979 | 2022-05-09 | Forrest | Mississippi | 28035 | 22076 | 315 |
2487980 | 2487980 | 2022-05-09 | Franklin | Mississippi | 28037 | 1927 | 38 |
2487981 | 2487981 | 2022-05-09 | George | Mississippi | 28039 | 7163 | 87 |
2487982 | 2487982 | 2022-05-09 | Greene | Mississippi | 28041 | 3198 | 59 |
2487983 | 2487983 | 2022-05-09 | Grenada | Mississippi | 28043 | 5533 | 131 |
2487984 | 2487984 | 2022-05-09 | Hancock | Mississippi | 28045 | 12277 | 152 |
2487985 | 2487985 | 2022-05-09 | Harrison | Mississippi | 28047 | 53859 | 665 |
2487986 | 2487986 | 2022-05-09 | Hinds | Mississippi | 28049 | 52682 | 791 |
2487987 | 2487987 | 2022-05-09 | Holmes | Mississippi | 28051 | 4455 | 104 |
2487988 | 2487988 | 2022-05-09 | Humphreys | Mississippi | 28053 | 2030 | 46 |
2487989 | 2487989 | 2022-05-09 | Issaquena | Mississippi | 28055 | 262 | 9 |
2487990 | 2487990 | 2022-05-09 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2487991 | 2487991 | 2022-05-09 | Jackson | Mississippi | 28059 | 37055 | 463 |
2487992 | 2487992 | 2022-05-09 | Jasper | Mississippi | 28061 | 4943 | 75 |
2487993 | 2487993 | 2022-05-09 | Jefferson | Mississippi | 28063 | 1494 | 37 |
2487994 | 2487994 | 2022-05-09 | Jefferson Davis | Mississippi | 28065 | 2865 | 53 |
2487995 | 2487995 | 2022-05-09 | Jones | Mississippi | 28067 | 21234 | 295 |
2487996 | 2487996 | 2022-05-09 | Kemper | Mississippi | 28069 | 2187 | 48 |
2487997 | 2487997 | 2022-05-09 | Lafayette | Mississippi | 28071 | 15364 | 179 |
2487998 | 2487998 | 2022-05-09 | Lamar | Mississippi | 28073 | 17441 | 160 |
2487999 | 2487999 | 2022-05-09 | Lauderdale | Mississippi | 28075 | 18898 | 367 |
2488000 | 2488000 | 2022-05-09 | Lawrence | Mississippi | 28077 | 3590 | 56 |
2488001 | 2488001 | 2022-05-09 | Leake | Mississippi | 28079 | 6427 | 120 |
2488002 | 2488002 | 2022-05-09 | Lee | Mississippi | 28081 | 26783 | 301 |
2488003 | 2488003 | 2022-05-09 | Leflore | Mississippi | 28083 | 7326 | 169 |
2488004 | 2488004 | 2022-05-09 | Lincoln | Mississippi | 28085 | 8324 | 157 |
2488005 | 2488005 | 2022-05-09 | Lowndes | Mississippi | 28087 | 17528 | 238 |
2488006 | 2488006 | 2022-05-09 | Madison | Mississippi | 28089 | 24189 | 329 |
2488007 | 2488007 | 2022-05-09 | Marion | Mississippi | 28091 | 6974 | 135 |
2488008 | 2488008 | 2022-05-09 | Marshall | Mississippi | 28093 | 9941 | 174 |
2488009 | 2488009 | 2022-05-09 | Monroe | Mississippi | 28095 | 10997 | 220 |
2488010 | 2488010 | 2022-05-09 | Montgomery | Mississippi | 28097 | 2963 | 77 |
2488011 | 2488011 | 2022-05-09 | Neshoba | Mississippi | 28099 | 10622 | 241 |
2488012 | 2488012 | 2022-05-09 | Newton | Mississippi | 28101 | 6059 | 98 |
2488013 | 2488013 | 2022-05-09 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2488014 | 2488014 | 2022-05-09 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2488015 | 2488015 | 2022-05-09 | Panola | Mississippi | 28107 | 10566 | 169 |
2488016 | 2488016 | 2022-05-09 | Pearl River | Mississippi | 28109 | 15151 | 275 |
2488017 | 2488017 | 2022-05-09 | Perry | Mississippi | 28111 | 3048 | 64 |
2488018 | 2488018 | 2022-05-09 | Pike | Mississippi | 28113 | 9751 | 189 |
2488019 | 2488019 | 2022-05-09 | Pontotoc | Mississippi | 28115 | 10364 | 145 |
2488020 | 2488020 | 2022-05-09 | Prentiss | Mississippi | 28117 | 8245 | 103 |
2488021 | 2488021 | 2022-05-09 | Quitman | Mississippi | 28119 | 1579 | 31 |
2488022 | 2488022 | 2022-05-09 | Rankin | Mississippi | 28121 | 36738 | 489 |
2488023 | 2488023 | 2022-05-09 | Scott | Mississippi | 28123 | 6559 | 119 |
2488024 | 2488024 | 2022-05-09 | Sharkey | Mississippi | 28125 | 953 | 26 |
2488025 | 2488025 | 2022-05-09 | Simpson | Mississippi | 28127 | 7026 | 149 |
2488026 | 2488026 | 2022-05-09 | Smith | Mississippi | 28129 | 4127 | 68 |
2488027 | 2488027 | 2022-05-09 | Stone | Mississippi | 28131 | 5409 | 71 |
2488028 | 2488028 | 2022-05-09 | Sunflower | Mississippi | 28133 | 5773 | 125 |
2488029 | 2488029 | 2022-05-09 | Tallahatchie | Mississippi | 28135 | 3203 | 60 |
2488030 | 2488030 | 2022-05-09 | Tate | Mississippi | 28137 | 7396 | 143 |
2488031 | 2488031 | 2022-05-09 | Tippah | Mississippi | 28139 | 7361 | 109 |
2488032 | 2488032 | 2022-05-09 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2488033 | 2488033 | 2022-05-09 | Tunica | Mississippi | 28143 | 2559 | 48 |
2488034 | 2488034 | 2022-05-09 | Union | Mississippi | 28145 | 9487 | 122 |
2488035 | 2488035 | 2022-05-09 | Walthall | Mississippi | 28147 | 3622 | 79 |
2488036 | 2488036 | 2022-05-09 | Warren | Mississippi | 28149 | 10250 | 202 |
2488037 | 2488037 | 2022-05-09 | Washington | Mississippi | 28151 | 10470 | 199 |
2488038 | 2488038 | 2022-05-09 | Wayne | Mississippi | 28153 | 6008 | 87 |
2488039 | 2488039 | 2022-05-09 | Webster | Mississippi | 28155 | 3388 | 70 |
2488040 | 2488040 | 2022-05-09 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2488041 | 2488041 | 2022-05-09 | Winston | Mississippi | 28159 | 5231 | 104 |
2488042 | 2488042 | 2022-05-09 | Yalobusha | Mississippi | 28161 | 4114 | 57 |
2488043 | 2488043 | 2022-05-09 | Yazoo | Mississippi | 28163 | 8054 | 107 |
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);