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-05-31 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
195144 | 195144 | 2020-05-31 | Adams | Mississippi | 28001 | 199 | 15 |
195145 | 195145 | 2020-05-31 | Alcorn | Mississippi | 28003 | 17 | 1 |
195146 | 195146 | 2020-05-31 | Amite | Mississippi | 28005 | 64 | 1 |
195147 | 195147 | 2020-05-31 | Attala | Mississippi | 28007 | 298 | 17 |
195148 | 195148 | 2020-05-31 | Benton | Mississippi | 28009 | 14 | 0 |
195149 | 195149 | 2020-05-31 | Bolivar | Mississippi | 28011 | 162 | 11 |
195150 | 195150 | 2020-05-31 | Calhoun | Mississippi | 28013 | 65 | 4 |
195151 | 195151 | 2020-05-31 | Carroll | Mississippi | 28015 | 117 | 11 |
195152 | 195152 | 2020-05-31 | Chickasaw | Mississippi | 28017 | 135 | 12 |
195153 | 195153 | 2020-05-31 | Choctaw | Mississippi | 28019 | 43 | 2 |
195154 | 195154 | 2020-05-31 | Claiborne | Mississippi | 28021 | 110 | 2 |
195155 | 195155 | 2020-05-31 | Clarke | Mississippi | 28023 | 144 | 18 |
195156 | 195156 | 2020-05-31 | Clay | Mississippi | 28025 | 112 | 4 |
195157 | 195157 | 2020-05-31 | Coahoma | Mississippi | 28027 | 125 | 4 |
195158 | 195158 | 2020-05-31 | Copiah | Mississippi | 28029 | 312 | 4 |
195159 | 195159 | 2020-05-31 | Covington | Mississippi | 28031 | 164 | 2 |
195160 | 195160 | 2020-05-31 | DeSoto | Mississippi | 28033 | 542 | 7 |
195161 | 195161 | 2020-05-31 | Forrest | Mississippi | 28035 | 564 | 38 |
195162 | 195162 | 2020-05-31 | Franklin | Mississippi | 28037 | 29 | 2 |
195163 | 195163 | 2020-05-31 | George | Mississippi | 28039 | 25 | 1 |
195164 | 195164 | 2020-05-31 | Greene | Mississippi | 28041 | 13 | 1 |
195165 | 195165 | 2020-05-31 | Grenada | Mississippi | 28043 | 94 | 3 |
195166 | 195166 | 2020-05-31 | Hancock | Mississippi | 28045 | 91 | 11 |
195167 | 195167 | 2020-05-31 | Harrison | Mississippi | 28047 | 258 | 7 |
195168 | 195168 | 2020-05-31 | Hinds | Mississippi | 28049 | 1006 | 25 |
195169 | 195169 | 2020-05-31 | Holmes | Mississippi | 28051 | 429 | 28 |
195170 | 195170 | 2020-05-31 | Humphreys | Mississippi | 28053 | 59 | 7 |
195171 | 195171 | 2020-05-31 | Itawamba | Mississippi | 28057 | 86 | 7 |
195172 | 195172 | 2020-05-31 | Jackson | Mississippi | 28059 | 308 | 13 |
195173 | 195173 | 2020-05-31 | Jasper | Mississippi | 28061 | 163 | 4 |
195174 | 195174 | 2020-05-31 | Jefferson | Mississippi | 28063 | 42 | 1 |
195175 | 195175 | 2020-05-31 | Jefferson Davis | Mississippi | 28065 | 77 | 3 |
195176 | 195176 | 2020-05-31 | Jones | Mississippi | 28067 | 629 | 28 |
195177 | 195177 | 2020-05-31 | Kemper | Mississippi | 28069 | 144 | 11 |
195178 | 195178 | 2020-05-31 | Lafayette | Mississippi | 28071 | 136 | 4 |
195179 | 195179 | 2020-05-31 | Lamar | Mississippi | 28073 | 238 | 5 |
195180 | 195180 | 2020-05-31 | Lauderdale | Mississippi | 28075 | 738 | 62 |
195181 | 195181 | 2020-05-31 | Lawrence | Mississippi | 28077 | 102 | 1 |
195182 | 195182 | 2020-05-31 | Leake | Mississippi | 28079 | 427 | 12 |
195183 | 195183 | 2020-05-31 | Lee | Mississippi | 28081 | 153 | 6 |
195184 | 195184 | 2020-05-31 | Leflore | Mississippi | 28083 | 264 | 31 |
195185 | 195185 | 2020-05-31 | Lincoln | Mississippi | 28085 | 263 | 29 |
195186 | 195186 | 2020-05-31 | Lowndes | Mississippi | 28087 | 211 | 9 |
195187 | 195187 | 2020-05-31 | Madison | Mississippi | 28089 | 724 | 23 |
195188 | 195188 | 2020-05-31 | Marion | Mississippi | 28091 | 114 | 9 |
195189 | 195189 | 2020-05-31 | Marshall | Mississippi | 28093 | 81 | 3 |
195190 | 195190 | 2020-05-31 | Monroe | Mississippi | 28095 | 257 | 25 |
195191 | 195191 | 2020-05-31 | Montgomery | Mississippi | 28097 | 85 | 1 |
195192 | 195192 | 2020-05-31 | Neshoba | Mississippi | 28099 | 646 | 39 |
195193 | 195193 | 2020-05-31 | Newton | Mississippi | 28101 | 270 | 4 |
195194 | 195194 | 2020-05-31 | Noxubee | Mississippi | 28103 | 186 | 6 |
195195 | 195195 | 2020-05-31 | Oktibbeha | Mississippi | 28105 | 239 | 12 |
195196 | 195196 | 2020-05-31 | Panola | Mississippi | 28107 | 71 | 3 |
195197 | 195197 | 2020-05-31 | Pearl River | Mississippi | 28109 | 209 | 31 |
195198 | 195198 | 2020-05-31 | Perry | Mississippi | 28111 | 50 | 3 |
195199 | 195199 | 2020-05-31 | Pike | Mississippi | 28113 | 203 | 11 |
195200 | 195200 | 2020-05-31 | Pontotoc | Mississippi | 28115 | 35 | 3 |
195201 | 195201 | 2020-05-31 | Prentiss | Mississippi | 28117 | 53 | 3 |
195202 | 195202 | 2020-05-31 | Quitman | Mississippi | 28119 | 33 | 0 |
195203 | 195203 | 2020-05-31 | Rankin | Mississippi | 28121 | 439 | 8 |
195204 | 195204 | 2020-05-31 | Scott | Mississippi | 28123 | 644 | 12 |
195205 | 195205 | 2020-05-31 | Sharkey | Mississippi | 28125 | 7 | 0 |
195206 | 195206 | 2020-05-31 | Simpson | Mississippi | 28127 | 98 | 0 |
195207 | 195207 | 2020-05-31 | Smith | Mississippi | 28129 | 152 | 11 |
195208 | 195208 | 2020-05-31 | Stone | Mississippi | 28131 | 30 | 0 |
195209 | 195209 | 2020-05-31 | Sunflower | Mississippi | 28133 | 84 | 3 |
195210 | 195210 | 2020-05-31 | Tallahatchie | Mississippi | 28135 | 27 | 1 |
195211 | 195211 | 2020-05-31 | Tate | Mississippi | 28137 | 94 | 1 |
195212 | 195212 | 2020-05-31 | Tippah | Mississippi | 28139 | 73 | 11 |
195213 | 195213 | 2020-05-31 | Tishomingo | Mississippi | 28141 | 32 | 0 |
195214 | 195214 | 2020-05-31 | Tunica | Mississippi | 28143 | 55 | 3 |
195215 | 195215 | 2020-05-31 | Union | Mississippi | 28145 | 82 | 5 |
195216 | 195216 | 2020-05-31 | Walthall | Mississippi | 28147 | 56 | 0 |
195217 | 195217 | 2020-05-31 | Warren | Mississippi | 28149 | 173 | 10 |
195218 | 195218 | 2020-05-31 | Washington | Mississippi | 28151 | 178 | 7 |
195219 | 195219 | 2020-05-31 | Wayne | Mississippi | 28153 | 204 | 1 |
195220 | 195220 | 2020-05-31 | Webster | Mississippi | 28155 | 69 | 2 |
195221 | 195221 | 2020-05-31 | Wilkinson | Mississippi | 28157 | 85 | 9 |
195222 | 195222 | 2020-05-31 | Winston | Mississippi | 28159 | 117 | 1 |
195223 | 195223 | 2020-05-31 | Yalobusha | Mississippi | 28161 | 93 | 5 |
195224 | 195224 | 2020-05-31 | Yazoo | Mississippi | 28163 | 281 | 4 |
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);