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-11-05 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 |
---|---|---|---|---|---|---|---|
701183 | 701183 | 2020-11-05 | Adams | Mississippi | 28001 | 1148 | 46 |
701184 | 701184 | 2020-11-05 | Alcorn | Mississippi | 28003 | 1182 | 14 |
701185 | 701185 | 2020-11-05 | Amite | Mississippi | 28005 | 440 | 14 |
701186 | 701186 | 2020-11-05 | Attala | Mississippi | 28007 | 838 | 27 |
701187 | 701187 | 2020-11-05 | Benton | Mississippi | 28009 | 396 | 12 |
701188 | 701188 | 2020-11-05 | Bolivar | Mississippi | 28011 | 2103 | 81 |
701189 | 701189 | 2020-11-05 | Calhoun | Mississippi | 28013 | 648 | 13 |
701190 | 701190 | 2020-11-05 | Carroll | Mississippi | 28015 | 552 | 12 |
701191 | 701191 | 2020-11-05 | Chickasaw | Mississippi | 28017 | 890 | 31 |
701192 | 701192 | 2020-11-05 | Choctaw | Mississippi | 28019 | 226 | 7 |
701193 | 701193 | 2020-11-05 | Claiborne | Mississippi | 28021 | 548 | 16 |
701194 | 701194 | 2020-11-05 | Clarke | Mississippi | 28023 | 812 | 53 |
701195 | 701195 | 2020-11-05 | Clay | Mississippi | 28025 | 748 | 23 |
701196 | 701196 | 2020-11-05 | Coahoma | Mississippi | 28027 | 1305 | 37 |
701197 | 701197 | 2020-11-05 | Copiah | Mississippi | 28029 | 1427 | 38 |
701198 | 701198 | 2020-11-05 | Covington | Mississippi | 28031 | 1043 | 31 |
701199 | 701199 | 2020-11-05 | DeSoto | Mississippi | 28033 | 7916 | 82 |
701200 | 701200 | 2020-11-05 | Forrest | Mississippi | 28035 | 3230 | 81 |
701201 | 701201 | 2020-11-05 | Franklin | Mississippi | 28037 | 260 | 3 |
701202 | 701202 | 2020-11-05 | George | Mississippi | 28039 | 1068 | 21 |
701203 | 701203 | 2020-11-05 | Greene | Mississippi | 28041 | 503 | 18 |
701204 | 701204 | 2020-11-05 | Grenada | Mississippi | 28043 | 1262 | 42 |
701205 | 701205 | 2020-11-05 | Hancock | Mississippi | 28045 | 933 | 32 |
701206 | 701206 | 2020-11-05 | Harrison | Mississippi | 28047 | 5868 | 91 |
701207 | 701207 | 2020-11-05 | Hinds | Mississippi | 28049 | 8362 | 181 |
701208 | 701208 | 2020-11-05 | Holmes | Mississippi | 28051 | 1160 | 60 |
701209 | 701209 | 2020-11-05 | Humphreys | Mississippi | 28053 | 480 | 18 |
701210 | 701210 | 2020-11-05 | Issaquena | Mississippi | 28055 | 107 | 4 |
701211 | 701211 | 2020-11-05 | Itawamba | Mississippi | 28057 | 1239 | 29 |
701212 | 701212 | 2020-11-05 | Jackson | Mississippi | 28059 | 5184 | 100 |
701213 | 701213 | 2020-11-05 | Jasper | Mississippi | 28061 | 724 | 19 |
701214 | 701214 | 2020-11-05 | Jefferson | Mississippi | 28063 | 288 | 11 |
701215 | 701215 | 2020-11-05 | Jefferson Davis | Mississippi | 28065 | 454 | 13 |
701216 | 701216 | 2020-11-05 | Jones | Mississippi | 28067 | 3082 | 84 |
701217 | 701217 | 2020-11-05 | Kemper | Mississippi | 28069 | 341 | 15 |
701218 | 701218 | 2020-11-05 | Lafayette | Mississippi | 28071 | 2658 | 43 |
701219 | 701219 | 2020-11-05 | Lamar | Mississippi | 28073 | 2451 | 41 |
701220 | 701220 | 2020-11-05 | Lauderdale | Mississippi | 28075 | 2749 | 135 |
701221 | 701221 | 2020-11-05 | Lawrence | Mississippi | 28077 | 589 | 14 |
701222 | 701222 | 2020-11-05 | Leake | Mississippi | 28079 | 1195 | 42 |
701223 | 701223 | 2020-11-05 | Lee | Mississippi | 28081 | 3888 | 84 |
701224 | 701224 | 2020-11-05 | Leflore | Mississippi | 28083 | 1802 | 88 |
701225 | 701225 | 2020-11-05 | Lincoln | Mississippi | 28085 | 1504 | 61 |
701226 | 701226 | 2020-11-05 | Lowndes | Mississippi | 28087 | 1941 | 62 |
701227 | 701227 | 2020-11-05 | Madison | Mississippi | 28089 | 3986 | 94 |
701228 | 701228 | 2020-11-05 | Marion | Mississippi | 28091 | 991 | 46 |
701229 | 701229 | 2020-11-05 | Marshall | Mississippi | 28093 | 1639 | 34 |
701230 | 701230 | 2020-11-05 | Monroe | Mississippi | 28095 | 1629 | 75 |
701231 | 701231 | 2020-11-05 | Montgomery | Mississippi | 28097 | 600 | 23 |
701232 | 701232 | 2020-11-05 | Neshoba | Mississippi | 28099 | 1929 | 111 |
701233 | 701233 | 2020-11-05 | Newton | Mississippi | 28101 | 901 | 28 |
701234 | 701234 | 2020-11-05 | Noxubee | Mississippi | 28103 | 615 | 17 |
701235 | 701235 | 2020-11-05 | Oktibbeha | Mississippi | 28105 | 2117 | 57 |
701236 | 701236 | 2020-11-05 | Panola | Mississippi | 28107 | 1789 | 41 |
701237 | 701237 | 2020-11-05 | Pearl River | Mississippi | 28109 | 1251 | 62 |
701238 | 701238 | 2020-11-05 | Perry | Mississippi | 28111 | 553 | 23 |
701239 | 701239 | 2020-11-05 | Pike | Mississippi | 28113 | 1442 | 56 |
701240 | 701240 | 2020-11-05 | Pontotoc | Mississippi | 28115 | 1619 | 21 |
701241 | 701241 | 2020-11-05 | Prentiss | Mississippi | 28117 | 1157 | 20 |
701242 | 701242 | 2020-11-05 | Quitman | Mississippi | 28119 | 431 | 7 |
701243 | 701243 | 2020-11-05 | Rankin | Mississippi | 28121 | 4309 | 88 |
701244 | 701244 | 2020-11-05 | Scott | Mississippi | 28123 | 1313 | 29 |
701245 | 701245 | 2020-11-05 | Sharkey | Mississippi | 28125 | 293 | 15 |
701246 | 701246 | 2020-11-05 | Simpson | Mississippi | 28127 | 1286 | 50 |
701247 | 701247 | 2020-11-05 | Smith | Mississippi | 28129 | 630 | 16 |
701248 | 701248 | 2020-11-05 | Stone | Mississippi | 28131 | 531 | 14 |
701249 | 701249 | 2020-11-05 | Sunflower | Mississippi | 28133 | 1711 | 52 |
701250 | 701250 | 2020-11-05 | Tallahatchie | Mississippi | 28135 | 892 | 26 |
701251 | 701251 | 2020-11-05 | Tate | Mississippi | 28137 | 1330 | 39 |
701252 | 701252 | 2020-11-05 | Tippah | Mississippi | 28139 | 1009 | 25 |
701253 | 701253 | 2020-11-05 | Tishomingo | Mississippi | 28141 | 872 | 41 |
701254 | 701254 | 2020-11-05 | Tunica | Mississippi | 28143 | 549 | 17 |
701255 | 701255 | 2020-11-05 | Union | Mississippi | 28145 | 1325 | 25 |
701256 | 701256 | 2020-11-05 | Walthall | Mississippi | 28147 | 669 | 27 |
701257 | 701257 | 2020-11-05 | Warren | Mississippi | 28149 | 1600 | 56 |
701258 | 701258 | 2020-11-05 | Washington | Mississippi | 28151 | 2751 | 104 |
701259 | 701259 | 2020-11-05 | Wayne | Mississippi | 28153 | 1059 | 22 |
701260 | 701260 | 2020-11-05 | Webster | Mississippi | 28155 | 388 | 13 |
701261 | 701261 | 2020-11-05 | Wilkinson | Mississippi | 28157 | 350 | 21 |
701262 | 701262 | 2020-11-05 | Winston | Mississippi | 28159 | 911 | 22 |
701263 | 701263 | 2020-11-05 | Yalobusha | Mississippi | 28161 | 593 | 23 |
701264 | 701264 | 2020-11-05 | Yazoo | Mississippi | 28163 | 1323 | 36 |
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);