ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
847212 | 847212 | 2020-12-20 | Adams | Mississippi | 28001 | 1709 | 53 |
847213 | 847213 | 2020-12-20 | Alcorn | Mississippi | 28003 | 1937 | 38 |
847214 | 847214 | 2020-12-20 | Amite | Mississippi | 28005 | 794 | 20 |
847215 | 847215 | 2020-12-20 | Attala | Mississippi | 28007 | 1537 | 43 |
847216 | 847216 | 2020-12-20 | Benton | Mississippi | 28009 | 604 | 20 |
847217 | 847217 | 2020-12-20 | Bolivar | Mississippi | 28011 | 3035 | 92 |
847218 | 847218 | 2020-12-20 | Calhoun | Mississippi | 28013 | 991 | 16 |
847219 | 847219 | 2020-12-20 | Carroll | Mississippi | 28015 | 892 | 17 |
847220 | 847220 | 2020-12-20 | Chickasaw | Mississippi | 28017 | 1429 | 35 |
847221 | 847221 | 2020-12-20 | Choctaw | Mississippi | 28019 | 451 | 10 |
847222 | 847222 | 2020-12-20 | Claiborne | Mississippi | 28021 | 660 | 18 |
847223 | 847223 | 2020-12-20 | Clarke | Mississippi | 28023 | 1112 | 55 |
847224 | 847224 | 2020-12-20 | Clay | Mississippi | 28025 | 1183 | 30 |
847225 | 847225 | 2020-12-20 | Coahoma | Mississippi | 28027 | 1824 | 48 |
847226 | 847226 | 2020-12-20 | Copiah | Mississippi | 28029 | 2050 | 42 |
847227 | 847227 | 2020-12-20 | Covington | Mississippi | 28031 | 1679 | 63 |
847228 | 847228 | 2020-12-20 | DeSoto | Mississippi | 28033 | 13081 | 128 |
847229 | 847229 | 2020-12-20 | Forrest | Mississippi | 28035 | 4792 | 93 |
847230 | 847230 | 2020-12-20 | Franklin | Mississippi | 28037 | 518 | 6 |
847231 | 847231 | 2020-12-20 | George | Mississippi | 28039 | 1594 | 33 |
847232 | 847232 | 2020-12-20 | Greene | Mississippi | 28041 | 923 | 25 |
847233 | 847233 | 2020-12-20 | Grenada | Mississippi | 28043 | 1840 | 54 |
847234 | 847234 | 2020-12-20 | Hancock | Mississippi | 28045 | 1687 | 50 |
847235 | 847235 | 2020-12-20 | Harrison | Mississippi | 28047 | 9478 | 135 |
847236 | 847236 | 2020-12-20 | Hinds | Mississippi | 28049 | 12849 | 236 |
847237 | 847237 | 2020-12-20 | Holmes | Mississippi | 28051 | 1512 | 63 |
847238 | 847238 | 2020-12-20 | Humphreys | Mississippi | 28053 | 669 | 22 |
847239 | 847239 | 2020-12-20 | Issaquena | Mississippi | 28055 | 140 | 4 |
847240 | 847240 | 2020-12-20 | Itawamba | Mississippi | 28057 | 1993 | 46 |
847241 | 847241 | 2020-12-20 | Jackson | Mississippi | 28059 | 7946 | 147 |
847242 | 847242 | 2020-12-20 | Jasper | Mississippi | 28061 | 1188 | 24 |
847243 | 847243 | 2020-12-20 | Jefferson | Mississippi | 28063 | 450 | 13 |
847244 | 847244 | 2020-12-20 | Jefferson Davis | Mississippi | 28065 | 709 | 22 |
847245 | 847245 | 2020-12-20 | Jones | Mississippi | 28067 | 4689 | 93 |
847246 | 847246 | 2020-12-20 | Kemper | Mississippi | 28069 | 624 | 19 |
847247 | 847247 | 2020-12-20 | Lafayette | Mississippi | 28071 | 3834 | 70 |
847248 | 847248 | 2020-12-20 | Lamar | Mississippi | 28073 | 3707 | 54 |
847249 | 847249 | 2020-12-20 | Lauderdale | Mississippi | 28075 | 4487 | 164 |
847250 | 847250 | 2020-12-20 | Lawrence | Mississippi | 28077 | 876 | 16 |
847251 | 847251 | 2020-12-20 | Leake | Mississippi | 28079 | 1777 | 46 |
847252 | 847252 | 2020-12-20 | Lee | Mississippi | 28081 | 6853 | 109 |
847253 | 847253 | 2020-12-20 | Leflore | Mississippi | 28083 | 2436 | 98 |
847254 | 847254 | 2020-12-20 | Lincoln | Mississippi | 28085 | 2326 | 73 |
847255 | 847255 | 2020-12-20 | Lowndes | Mississippi | 28087 | 3700 | 77 |
847256 | 847256 | 2020-12-20 | Madison | Mississippi | 28089 | 6482 | 126 |
847257 | 847257 | 2020-12-20 | Marion | Mississippi | 28091 | 1601 | 58 |
847258 | 847258 | 2020-12-20 | Marshall | Mississippi | 28093 | 2656 | 59 |
847259 | 847259 | 2020-12-20 | Monroe | Mississippi | 28095 | 2667 | 83 |
847260 | 847260 | 2020-12-20 | Montgomery | Mississippi | 28097 | 923 | 30 |
847261 | 847261 | 2020-12-20 | Neshoba | Mississippi | 28099 | 2738 | 133 |
847262 | 847262 | 2020-12-20 | Newton | Mississippi | 28101 | 1429 | 32 |
847263 | 847263 | 2020-12-20 | Noxubee | Mississippi | 28103 | 857 | 18 |
847264 | 847264 | 2020-12-20 | Oktibbeha | Mississippi | 28105 | 3066 | 67 |
847265 | 847265 | 2020-12-20 | Panola | Mississippi | 28107 | 2890 | 67 |
847266 | 847266 | 2020-12-20 | Pearl River | Mississippi | 28109 | 2238 | 77 |
847267 | 847267 | 2020-12-20 | Perry | Mississippi | 28111 | 788 | 30 |
847268 | 847268 | 2020-12-20 | Pike | Mississippi | 28113 | 2019 | 65 |
847269 | 847269 | 2020-12-20 | Pontotoc | Mississippi | 28115 | 2789 | 35 |
847270 | 847270 | 2020-12-20 | Prentiss | Mississippi | 28117 | 1890 | 40 |
847271 | 847271 | 2020-12-20 | Quitman | Mississippi | 28119 | 567 | 7 |
847272 | 847272 | 2020-12-20 | Rankin | Mississippi | 28121 | 7902 | 143 |
847273 | 847273 | 2020-12-20 | Scott | Mississippi | 28123 | 1931 | 36 |
847274 | 847274 | 2020-12-20 | Sharkey | Mississippi | 28125 | 371 | 17 |
847275 | 847275 | 2020-12-20 | Simpson | Mississippi | 28127 | 1825 | 57 |
847276 | 847276 | 2020-12-20 | Smith | Mississippi | 28129 | 933 | 17 |
847277 | 847277 | 2020-12-20 | Stone | Mississippi | 28131 | 1052 | 18 |
847278 | 847278 | 2020-12-20 | Sunflower | Mississippi | 28133 | 2217 | 57 |
847279 | 847279 | 2020-12-20 | Tallahatchie | Mississippi | 28135 | 1133 | 29 |
847280 | 847280 | 2020-12-20 | Tate | Mississippi | 28137 | 2207 | 54 |
847281 | 847281 | 2020-12-20 | Tippah | Mississippi | 28139 | 1770 | 38 |
847282 | 847282 | 2020-12-20 | Tishomingo | Mississippi | 28141 | 1420 | 50 |
847283 | 847283 | 2020-12-20 | Tunica | Mississippi | 28143 | 694 | 19 |
847284 | 847284 | 2020-12-20 | Union | Mississippi | 28145 | 2466 | 27 |
847285 | 847285 | 2020-12-20 | Walthall | Mississippi | 28147 | 916 | 32 |
847286 | 847286 | 2020-12-20 | Warren | Mississippi | 28149 | 2318 | 69 |
847287 | 847287 | 2020-12-20 | Washington | Mississippi | 28151 | 3839 | 111 |
847288 | 847288 | 2020-12-20 | Wayne | Mississippi | 28153 | 1544 | 25 |
847289 | 847289 | 2020-12-20 | Webster | Mississippi | 28155 | 656 | 17 |
847290 | 847290 | 2020-12-20 | Wilkinson | Mississippi | 28157 | 498 | 22 |
847291 | 847291 | 2020-12-20 | Winston | Mississippi | 28159 | 1650 | 44 |
847292 | 847292 | 2020-12-20 | Yalobusha | Mississippi | 28161 | 878 | 30 |
847293 | 847293 | 2020-12-20 | Yazoo | Mississippi | 28163 | 1948 | 50 |
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);