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-06-02 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
201288 | 201288 | 2020-06-02 | Adams | Mississippi | 28001 | 200 | 15 |
201289 | 201289 | 2020-06-02 | Alcorn | Mississippi | 28003 | 18 | 1 |
201290 | 201290 | 2020-06-02 | Amite | Mississippi | 28005 | 64 | 1 |
201291 | 201291 | 2020-06-02 | Attala | Mississippi | 28007 | 303 | 18 |
201292 | 201292 | 2020-06-02 | Benton | Mississippi | 28009 | 14 | 0 |
201293 | 201293 | 2020-06-02 | Bolivar | Mississippi | 28011 | 165 | 11 |
201294 | 201294 | 2020-06-02 | Calhoun | Mississippi | 28013 | 67 | 4 |
201295 | 201295 | 2020-06-02 | Carroll | Mississippi | 28015 | 116 | 11 |
201296 | 201296 | 2020-06-02 | Chickasaw | Mississippi | 28017 | 137 | 14 |
201297 | 201297 | 2020-06-02 | Choctaw | Mississippi | 28019 | 47 | 2 |
201298 | 201298 | 2020-06-02 | Claiborne | Mississippi | 28021 | 112 | 2 |
201299 | 201299 | 2020-06-02 | Clarke | Mississippi | 28023 | 154 | 19 |
201300 | 201300 | 2020-06-02 | Clay | Mississippi | 28025 | 115 | 4 |
201301 | 201301 | 2020-06-02 | Coahoma | Mississippi | 28027 | 127 | 4 |
201302 | 201302 | 2020-06-02 | Copiah | Mississippi | 28029 | 315 | 4 |
201303 | 201303 | 2020-06-02 | Covington | Mississippi | 28031 | 173 | 2 |
201304 | 201304 | 2020-06-02 | DeSoto | Mississippi | 28033 | 553 | 8 |
201305 | 201305 | 2020-06-02 | Forrest | Mississippi | 28035 | 594 | 39 |
201306 | 201306 | 2020-06-02 | Franklin | Mississippi | 28037 | 29 | 2 |
201307 | 201307 | 2020-06-02 | George | Mississippi | 28039 | 26 | 1 |
201308 | 201308 | 2020-06-02 | Greene | Mississippi | 28041 | 22 | 1 |
201309 | 201309 | 2020-06-02 | Grenada | Mississippi | 28043 | 99 | 3 |
201310 | 201310 | 2020-06-02 | Hancock | Mississippi | 28045 | 91 | 12 |
201311 | 201311 | 2020-06-02 | Harrison | Mississippi | 28047 | 263 | 7 |
201312 | 201312 | 2020-06-02 | Hinds | Mississippi | 28049 | 1035 | 26 |
201313 | 201313 | 2020-06-02 | Holmes | Mississippi | 28051 | 439 | 28 |
201314 | 201314 | 2020-06-02 | Humphreys | Mississippi | 28053 | 59 | 7 |
201315 | 201315 | 2020-06-02 | Itawamba | Mississippi | 28057 | 89 | 7 |
201316 | 201316 | 2020-06-02 | Jackson | Mississippi | 28059 | 308 | 13 |
201317 | 201317 | 2020-06-02 | Jasper | Mississippi | 28061 | 165 | 4 |
201318 | 201318 | 2020-06-02 | Jefferson | Mississippi | 28063 | 43 | 1 |
201319 | 201319 | 2020-06-02 | Jefferson Davis | Mississippi | 28065 | 80 | 3 |
201320 | 201320 | 2020-06-02 | Jones | Mississippi | 28067 | 663 | 31 |
201321 | 201321 | 2020-06-02 | Kemper | Mississippi | 28069 | 147 | 11 |
201322 | 201322 | 2020-06-02 | Lafayette | Mississippi | 28071 | 141 | 4 |
201323 | 201323 | 2020-06-02 | Lamar | Mississippi | 28073 | 248 | 5 |
201324 | 201324 | 2020-06-02 | Lauderdale | Mississippi | 28075 | 745 | 68 |
201325 | 201325 | 2020-06-02 | Lawrence | Mississippi | 28077 | 105 | 1 |
201326 | 201326 | 2020-06-02 | Leake | Mississippi | 28079 | 447 | 12 |
201327 | 201327 | 2020-06-02 | Lee | Mississippi | 28081 | 165 | 7 |
201328 | 201328 | 2020-06-02 | Leflore | Mississippi | 28083 | 273 | 34 |
201329 | 201329 | 2020-06-02 | Lincoln | Mississippi | 28085 | 270 | 29 |
201330 | 201330 | 2020-06-02 | Lowndes | Mississippi | 28087 | 230 | 9 |
201331 | 201331 | 2020-06-02 | Madison | Mississippi | 28089 | 745 | 25 |
201332 | 201332 | 2020-06-02 | Marion | Mississippi | 28091 | 115 | 9 |
201333 | 201333 | 2020-06-02 | Marshall | Mississippi | 28093 | 81 | 3 |
201334 | 201334 | 2020-06-02 | Monroe | Mississippi | 28095 | 265 | 25 |
201335 | 201335 | 2020-06-02 | Montgomery | Mississippi | 28097 | 85 | 1 |
201336 | 201336 | 2020-06-02 | Neshoba | Mississippi | 28099 | 707 | 42 |
201337 | 201337 | 2020-06-02 | Newton | Mississippi | 28101 | 282 | 4 |
201338 | 201338 | 2020-06-02 | Noxubee | Mississippi | 28103 | 191 | 6 |
201339 | 201339 | 2020-06-02 | Oktibbeha | Mississippi | 28105 | 253 | 14 |
201340 | 201340 | 2020-06-02 | Panola | Mississippi | 28107 | 84 | 3 |
201341 | 201341 | 2020-06-02 | Pearl River | Mississippi | 28109 | 211 | 31 |
201342 | 201342 | 2020-06-02 | Perry | Mississippi | 28111 | 51 | 3 |
201343 | 201343 | 2020-06-02 | Pike | Mississippi | 28113 | 204 | 11 |
201344 | 201344 | 2020-06-02 | Pontotoc | Mississippi | 28115 | 43 | 3 |
201345 | 201345 | 2020-06-02 | Prentiss | Mississippi | 28117 | 51 | 3 |
201346 | 201346 | 2020-06-02 | Quitman | Mississippi | 28119 | 30 | 0 |
201347 | 201347 | 2020-06-02 | Rankin | Mississippi | 28121 | 446 | 8 |
201348 | 201348 | 2020-06-02 | Scott | Mississippi | 28123 | 661 | 12 |
201349 | 201349 | 2020-06-02 | Sharkey | Mississippi | 28125 | 7 | 0 |
201350 | 201350 | 2020-06-02 | Simpson | Mississippi | 28127 | 102 | 0 |
201351 | 201351 | 2020-06-02 | Smith | Mississippi | 28129 | 153 | 11 |
201352 | 201352 | 2020-06-02 | Stone | Mississippi | 28131 | 31 | 0 |
201353 | 201353 | 2020-06-02 | Sunflower | Mississippi | 28133 | 85 | 3 |
201354 | 201354 | 2020-06-02 | Tallahatchie | Mississippi | 28135 | 29 | 1 |
201355 | 201355 | 2020-06-02 | Tate | Mississippi | 28137 | 89 | 1 |
201356 | 201356 | 2020-06-02 | Tippah | Mississippi | 28139 | 76 | 11 |
201357 | 201357 | 2020-06-02 | Tishomingo | Mississippi | 28141 | 34 | 0 |
201358 | 201358 | 2020-06-02 | Tunica | Mississippi | 28143 | 56 | 3 |
201359 | 201359 | 2020-06-02 | Union | Mississippi | 28145 | 85 | 7 |
201360 | 201360 | 2020-06-02 | Walthall | Mississippi | 28147 | 61 | 0 |
201361 | 201361 | 2020-06-02 | Warren | Mississippi | 28149 | 181 | 10 |
201362 | 201362 | 2020-06-02 | Washington | Mississippi | 28151 | 191 | 7 |
201363 | 201363 | 2020-06-02 | Wayne | Mississippi | 28153 | 224 | 2 |
201364 | 201364 | 2020-06-02 | Webster | Mississippi | 28155 | 67 | 3 |
201365 | 201365 | 2020-06-02 | Wilkinson | Mississippi | 28157 | 85 | 9 |
201366 | 201366 | 2020-06-02 | Winston | Mississippi | 28159 | 121 | 1 |
201367 | 201367 | 2020-06-02 | Yalobusha | Mississippi | 28161 | 96 | 6 |
201368 | 201368 | 2020-06-02 | Yazoo | Mississippi | 28163 | 286 | 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);