ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where date = "2020-07-26" 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 |
---|---|---|---|---|---|---|---|
371268 | 371268 | 2020-07-26 | Adams | Mississippi | 28001 | 511 | 22 |
371269 | 371269 | 2020-07-26 | Alcorn | Mississippi | 28003 | 274 | 3 |
371270 | 371270 | 2020-07-26 | Amite | Mississippi | 28005 | 179 | 4 |
371271 | 371271 | 2020-07-26 | Attala | Mississippi | 28007 | 457 | 23 |
371272 | 371272 | 2020-07-26 | Benton | Mississippi | 28009 | 88 | 0 |
371273 | 371273 | 2020-07-26 | Bolivar | Mississippi | 28011 | 758 | 25 |
371274 | 371274 | 2020-07-26 | Calhoun | Mississippi | 28013 | 339 | 8 |
371275 | 371275 | 2020-07-26 | Carroll | Mississippi | 28015 | 231 | 11 |
371276 | 371276 | 2020-07-26 | Chickasaw | Mississippi | 28017 | 390 | 19 |
371277 | 371277 | 2020-07-26 | Choctaw | Mississippi | 28019 | 105 | 4 |
371278 | 371278 | 2020-07-26 | Claiborne | Mississippi | 28021 | 379 | 12 |
371279 | 371279 | 2020-07-26 | Clarke | Mississippi | 28023 | 277 | 25 |
371280 | 371280 | 2020-07-26 | Clay | Mississippi | 28025 | 340 | 13 |
371281 | 371281 | 2020-07-26 | Coahoma | Mississippi | 28027 | 535 | 7 |
371282 | 371282 | 2020-07-26 | Copiah | Mississippi | 28029 | 829 | 21 |
371283 | 371283 | 2020-07-26 | Covington | Mississippi | 28031 | 531 | 8 |
371284 | 371284 | 2020-07-26 | DeSoto | Mississippi | 28033 | 2784 | 23 |
371285 | 371285 | 2020-07-26 | Forrest | Mississippi | 28035 | 1405 | 46 |
371286 | 371286 | 2020-07-26 | Franklin | Mississippi | 28037 | 85 | 2 |
371287 | 371287 | 2020-07-26 | George | Mississippi | 28039 | 243 | 5 |
371288 | 371288 | 2020-07-26 | Greene | Mississippi | 28041 | 192 | 10 |
371289 | 371289 | 2020-07-26 | Grenada | Mississippi | 28043 | 766 | 17 |
371290 | 371290 | 2020-07-26 | Hancock | Mississippi | 28045 | 269 | 14 |
371291 | 371291 | 2020-07-26 | Harrison | Mississippi | 28047 | 1810 | 26 |
371292 | 371292 | 2020-07-26 | Hinds | Mississippi | 28049 | 4553 | 82 |
371293 | 371293 | 2020-07-26 | Holmes | Mississippi | 28051 | 760 | 45 |
371294 | 371294 | 2020-07-26 | Humphreys | Mississippi | 28053 | 245 | 10 |
371295 | 371295 | 2020-07-26 | Issaquena | Mississippi | 28055 | 18 | 1 |
371296 | 371296 | 2020-07-26 | Itawamba | Mississippi | 28057 | 254 | 9 |
371297 | 371297 | 2020-07-26 | Jackson | Mississippi | 28059 | 1582 | 27 |
371298 | 371298 | 2020-07-26 | Jasper | Mississippi | 28061 | 336 | 6 |
371299 | 371299 | 2020-07-26 | Jefferson | Mississippi | 28063 | 163 | 4 |
371300 | 371300 | 2020-07-26 | Jefferson Davis | Mississippi | 28065 | 174 | 5 |
371301 | 371301 | 2020-07-26 | Jones | Mississippi | 28067 | 1563 | 56 |
371302 | 371302 | 2020-07-26 | Kemper | Mississippi | 28069 | 209 | 15 |
371303 | 371303 | 2020-07-26 | Lafayette | Mississippi | 28071 | 723 | 4 |
371304 | 371304 | 2020-07-26 | Lamar | Mississippi | 28073 | 954 | 11 |
371305 | 371305 | 2020-07-26 | Lauderdale | Mississippi | 28075 | 1218 | 84 |
371306 | 371306 | 2020-07-26 | Lawrence | Mississippi | 28077 | 271 | 3 |
371307 | 371307 | 2020-07-26 | Leake | Mississippi | 28079 | 724 | 24 |
371308 | 371308 | 2020-07-26 | Lee | Mississippi | 28081 | 1002 | 26 |
371309 | 371309 | 2020-07-26 | Leflore | Mississippi | 28083 | 735 | 57 |
371310 | 371310 | 2020-07-26 | Lincoln | Mississippi | 28085 | 681 | 38 |
371311 | 371311 | 2020-07-26 | Lowndes | Mississippi | 28087 | 811 | 22 |
371312 | 371312 | 2020-07-26 | Madison | Mississippi | 28089 | 2058 | 50 |
371313 | 371313 | 2020-07-26 | Marion | Mississippi | 28091 | 502 | 16 |
371314 | 371314 | 2020-07-26 | Marshall | Mississippi | 28093 | 454 | 5 |
371315 | 371315 | 2020-07-26 | Monroe | Mississippi | 28095 | 592 | 45 |
371316 | 371316 | 2020-07-26 | Montgomery | Mississippi | 28097 | 250 | 3 |
371317 | 371317 | 2020-07-26 | Neshoba | Mississippi | 28099 | 1148 | 82 |
371318 | 371318 | 2020-07-26 | Newton | Mississippi | 28101 | 472 | 10 |
371319 | 371319 | 2020-07-26 | Noxubee | Mississippi | 28103 | 365 | 10 |
371320 | 371320 | 2020-07-26 | Oktibbeha | Mississippi | 28105 | 893 | 31 |
371321 | 371321 | 2020-07-26 | Panola | Mississippi | 28107 | 732 | 9 |
371322 | 371322 | 2020-07-26 | Pearl River | Mississippi | 28109 | 427 | 34 |
371323 | 371323 | 2020-07-26 | Perry | Mississippi | 28111 | 175 | 6 |
371324 | 371324 | 2020-07-26 | Pike | Mississippi | 28113 | 720 | 29 |
371325 | 371325 | 2020-07-26 | Pontotoc | Mississippi | 28115 | 607 | 6 |
371326 | 371326 | 2020-07-26 | Prentiss | Mississippi | 28117 | 251 | 6 |
371327 | 371327 | 2020-07-26 | Quitman | Mississippi | 28119 | 168 | 1 |
371328 | 371328 | 2020-07-26 | Rankin | Mississippi | 28121 | 1830 | 23 |
371329 | 371329 | 2020-07-26 | Scott | Mississippi | 28123 | 930 | 16 |
371330 | 371330 | 2020-07-26 | Sharkey | Mississippi | 28125 | 103 | 1 |
371331 | 371331 | 2020-07-26 | Simpson | Mississippi | 28127 | 623 | 13 |
371332 | 371332 | 2020-07-26 | Smith | Mississippi | 28129 | 349 | 12 |
371333 | 371333 | 2020-07-26 | Stone | Mississippi | 28131 | 128 | 2 |
371334 | 371334 | 2020-07-26 | Sunflower | Mississippi | 28133 | 790 | 14 |
371335 | 371335 | 2020-07-26 | Tallahatchie | Mississippi | 28135 | 349 | 6 |
371336 | 371336 | 2020-07-26 | Tate | Mississippi | 28137 | 565 | 19 |
371337 | 371337 | 2020-07-26 | Tippah | Mississippi | 28139 | 236 | 11 |
371338 | 371338 | 2020-07-26 | Tishomingo | Mississippi | 28141 | 226 | 3 |
371339 | 371339 | 2020-07-26 | Tunica | Mississippi | 28143 | 182 | 4 |
371340 | 371340 | 2020-07-26 | Union | Mississippi | 28145 | 408 | 12 |
371341 | 371341 | 2020-07-26 | Unknown | Mississippi | 34 | 0 | |
371342 | 371342 | 2020-07-26 | Walthall | Mississippi | 28147 | 396 | 15 |
371343 | 371343 | 2020-07-26 | Warren | Mississippi | 28149 | 853 | 24 |
371344 | 371344 | 2020-07-26 | Washington | Mississippi | 28151 | 1285 | 24 |
371345 | 371345 | 2020-07-26 | Wayne | Mississippi | 28153 | 689 | 21 |
371346 | 371346 | 2020-07-26 | Webster | Mississippi | 28155 | 166 | 11 |
371347 | 371347 | 2020-07-26 | Wilkinson | Mississippi | 28157 | 151 | 12 |
371348 | 371348 | 2020-07-26 | Winston | Mississippi | 28159 | 479 | 14 |
371349 | 371349 | 2020-07-26 | Yalobusha | Mississippi | 28161 | 276 | 9 |
371350 | 371350 | 2020-07-26 | Yazoo | Mississippi | 28163 | 689 | 9 |
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);