ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-12-24" 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 |
---|---|---|---|---|---|---|---|
860192 | 860192 | 2020-12-24 | Adams | Mississippi | 28001 | 1742 | 57 |
860193 | 860193 | 2020-12-24 | Alcorn | Mississippi | 28003 | 2028 | 39 |
860194 | 860194 | 2020-12-24 | Amite | Mississippi | 28005 | 817 | 20 |
860195 | 860195 | 2020-12-24 | Attala | Mississippi | 28007 | 1626 | 44 |
860196 | 860196 | 2020-12-24 | Benton | Mississippi | 28009 | 638 | 20 |
860197 | 860197 | 2020-12-24 | Bolivar | Mississippi | 28011 | 3202 | 95 |
860198 | 860198 | 2020-12-24 | Calhoun | Mississippi | 28013 | 1074 | 16 |
860199 | 860199 | 2020-12-24 | Carroll | Mississippi | 28015 | 904 | 17 |
860200 | 860200 | 2020-12-24 | Chickasaw | Mississippi | 28017 | 1507 | 35 |
860201 | 860201 | 2020-12-24 | Choctaw | Mississippi | 28019 | 468 | 10 |
860202 | 860202 | 2020-12-24 | Claiborne | Mississippi | 28021 | 672 | 18 |
860203 | 860203 | 2020-12-24 | Clarke | Mississippi | 28023 | 1146 | 57 |
860204 | 860204 | 2020-12-24 | Clay | Mississippi | 28025 | 1235 | 30 |
860205 | 860205 | 2020-12-24 | Coahoma | Mississippi | 28027 | 1884 | 51 |
860206 | 860206 | 2020-12-24 | Copiah | Mississippi | 28029 | 2100 | 43 |
860207 | 860207 | 2020-12-24 | Covington | Mississippi | 28031 | 1748 | 66 |
860208 | 860208 | 2020-12-24 | DeSoto | Mississippi | 28033 | 13674 | 129 |
860209 | 860209 | 2020-12-24 | Forrest | Mississippi | 28035 | 4966 | 94 |
860210 | 860210 | 2020-12-24 | Franklin | Mississippi | 28037 | 550 | 7 |
860211 | 860211 | 2020-12-24 | George | Mississippi | 28039 | 1646 | 34 |
860212 | 860212 | 2020-12-24 | Greene | Mississippi | 28041 | 952 | 25 |
860213 | 860213 | 2020-12-24 | Grenada | Mississippi | 28043 | 1900 | 60 |
860214 | 860214 | 2020-12-24 | Hancock | Mississippi | 28045 | 1832 | 53 |
860215 | 860215 | 2020-12-24 | Harrison | Mississippi | 28047 | 9974 | 139 |
860216 | 860216 | 2020-12-24 | Hinds | Mississippi | 28049 | 13255 | 248 |
860217 | 860217 | 2020-12-24 | Holmes | Mississippi | 28051 | 1539 | 64 |
860218 | 860218 | 2020-12-24 | Humphreys | Mississippi | 28053 | 697 | 22 |
860219 | 860219 | 2020-12-24 | Issaquena | Mississippi | 28055 | 144 | 4 |
860220 | 860220 | 2020-12-24 | Itawamba | Mississippi | 28057 | 2143 | 49 |
860221 | 860221 | 2020-12-24 | Jackson | Mississippi | 28059 | 8290 | 151 |
860222 | 860222 | 2020-12-24 | Jasper | Mississippi | 28061 | 1288 | 25 |
860223 | 860223 | 2020-12-24 | Jefferson | Mississippi | 28063 | 458 | 14 |
860224 | 860224 | 2020-12-24 | Jefferson Davis | Mississippi | 28065 | 727 | 22 |
860225 | 860225 | 2020-12-24 | Jones | Mississippi | 28067 | 4881 | 95 |
860226 | 860226 | 2020-12-24 | Kemper | Mississippi | 28069 | 638 | 19 |
860227 | 860227 | 2020-12-24 | Lafayette | Mississippi | 28071 | 3997 | 76 |
860228 | 860228 | 2020-12-24 | Lamar | Mississippi | 28073 | 3862 | 55 |
860229 | 860229 | 2020-12-24 | Lauderdale | Mississippi | 28075 | 4664 | 168 |
860230 | 860230 | 2020-12-24 | Lawrence | Mississippi | 28077 | 898 | 16 |
860231 | 860231 | 2020-12-24 | Leake | Mississippi | 28079 | 1883 | 49 |
860232 | 860232 | 2020-12-24 | Lee | Mississippi | 28081 | 7188 | 111 |
860233 | 860233 | 2020-12-24 | Leflore | Mississippi | 28083 | 2512 | 98 |
860234 | 860234 | 2020-12-24 | Lincoln | Mississippi | 28085 | 2417 | 74 |
860235 | 860235 | 2020-12-24 | Lowndes | Mississippi | 28087 | 4008 | 85 |
860236 | 860236 | 2020-12-24 | Madison | Mississippi | 28089 | 6733 | 128 |
860237 | 860237 | 2020-12-24 | Marion | Mississippi | 28091 | 1672 | 59 |
860238 | 860238 | 2020-12-24 | Marshall | Mississippi | 28093 | 2778 | 62 |
860239 | 860239 | 2020-12-24 | Monroe | Mississippi | 28095 | 2799 | 84 |
860240 | 860240 | 2020-12-24 | Montgomery | Mississippi | 28097 | 946 | 30 |
860241 | 860241 | 2020-12-24 | Neshoba | Mississippi | 28099 | 2852 | 137 |
860242 | 860242 | 2020-12-24 | Newton | Mississippi | 28101 | 1506 | 32 |
860243 | 860243 | 2020-12-24 | Noxubee | Mississippi | 28103 | 879 | 20 |
860244 | 860244 | 2020-12-24 | Oktibbeha | Mississippi | 28105 | 3190 | 70 |
860245 | 860245 | 2020-12-24 | Panola | Mississippi | 28107 | 2998 | 68 |
860246 | 860246 | 2020-12-24 | Pearl River | Mississippi | 28109 | 2354 | 79 |
860247 | 860247 | 2020-12-24 | Perry | Mississippi | 28111 | 820 | 30 |
860248 | 860248 | 2020-12-24 | Pike | Mississippi | 28113 | 2080 | 65 |
860249 | 860249 | 2020-12-24 | Pontotoc | Mississippi | 28115 | 2969 | 37 |
860250 | 860250 | 2020-12-24 | Prentiss | Mississippi | 28117 | 1961 | 41 |
860251 | 860251 | 2020-12-24 | Quitman | Mississippi | 28119 | 586 | 7 |
860252 | 860252 | 2020-12-24 | Rankin | Mississippi | 28121 | 8197 | 156 |
860253 | 860253 | 2020-12-24 | Scott | Mississippi | 28123 | 2029 | 38 |
860254 | 860254 | 2020-12-24 | Sharkey | Mississippi | 28125 | 377 | 17 |
860255 | 860255 | 2020-12-24 | Simpson | Mississippi | 28127 | 1892 | 60 |
860256 | 860256 | 2020-12-24 | Smith | Mississippi | 28129 | 956 | 18 |
860257 | 860257 | 2020-12-24 | Stone | Mississippi | 28131 | 1095 | 18 |
860258 | 860258 | 2020-12-24 | Sunflower | Mississippi | 28133 | 2309 | 59 |
860259 | 860259 | 2020-12-24 | Tallahatchie | Mississippi | 28135 | 1163 | 29 |
860260 | 860260 | 2020-12-24 | Tate | Mississippi | 28137 | 2283 | 56 |
860261 | 860261 | 2020-12-24 | Tippah | Mississippi | 28139 | 1858 | 40 |
860262 | 860262 | 2020-12-24 | Tishomingo | Mississippi | 28141 | 1486 | 51 |
860263 | 860263 | 2020-12-24 | Tunica | Mississippi | 28143 | 712 | 19 |
860264 | 860264 | 2020-12-24 | Union | Mississippi | 28145 | 2604 | 34 |
860265 | 860265 | 2020-12-24 | Walthall | Mississippi | 28147 | 942 | 33 |
860266 | 860266 | 2020-12-24 | Warren | Mississippi | 28149 | 2443 | 74 |
860267 | 860267 | 2020-12-24 | Washington | Mississippi | 28151 | 3971 | 112 |
860268 | 860268 | 2020-12-24 | Wayne | Mississippi | 28153 | 1577 | 25 |
860269 | 860269 | 2020-12-24 | Webster | Mississippi | 28155 | 682 | 17 |
860270 | 860270 | 2020-12-24 | Wilkinson | Mississippi | 28157 | 511 | 22 |
860271 | 860271 | 2020-12-24 | Winston | Mississippi | 28159 | 1739 | 44 |
860272 | 860272 | 2020-12-24 | Yalobusha | Mississippi | 28161 | 931 | 31 |
860273 | 860273 | 2020-12-24 | Yazoo | Mississippi | 28163 | 1997 | 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);