ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-11-06" 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 |
---|---|---|---|---|---|---|---|
1889512 | 1889512 | 2021-11-06 | Adams | Mississippi | 28001 | 4660 | 123 |
1889513 | 1889513 | 2021-11-06 | Alcorn | Mississippi | 28003 | 5745 | 103 |
1889514 | 1889514 | 2021-11-06 | Amite | Mississippi | 28005 | 2072 | 56 |
1889515 | 1889515 | 2021-11-06 | Attala | Mississippi | 28007 | 3355 | 90 |
1889516 | 1889516 | 2021-11-06 | Benton | Mississippi | 28009 | 1506 | 39 |
1889517 | 1889517 | 2021-11-06 | Bolivar | Mississippi | 28011 | 6389 | 151 |
1889518 | 1889518 | 2021-11-06 | Calhoun | Mississippi | 28013 | 2819 | 49 |
1889519 | 1889519 | 2021-11-06 | Carroll | Mississippi | 28015 | 1709 | 40 |
1889520 | 1889520 | 2021-11-06 | Chickasaw | Mississippi | 28017 | 3045 | 67 |
1889521 | 1889521 | 2021-11-06 | Choctaw | Mississippi | 28019 | 1352 | 27 |
1889522 | 1889522 | 2021-11-06 | Claiborne | Mississippi | 28021 | 1334 | 38 |
1889523 | 1889523 | 2021-11-06 | Clarke | Mississippi | 28023 | 2983 | 95 |
1889524 | 1889524 | 2021-11-06 | Clay | Mississippi | 28025 | 3099 | 77 |
1889525 | 1889525 | 2021-11-06 | Coahoma | Mississippi | 28027 | 4201 | 109 |
1889526 | 1889526 | 2021-11-06 | Copiah | Mississippi | 28029 | 4510 | 93 |
1889527 | 1889527 | 2021-11-06 | Covington | Mississippi | 28031 | 4309 | 95 |
1889528 | 1889528 | 2021-11-06 | DeSoto | Mississippi | 28033 | 32567 | 420 |
1889529 | 1889529 | 2021-11-06 | Forrest | Mississippi | 28035 | 13555 | 254 |
1889530 | 1889530 | 2021-11-06 | Franklin | Mississippi | 28037 | 1217 | 28 |
1889531 | 1889531 | 2021-11-06 | George | Mississippi | 28039 | 5059 | 80 |
1889532 | 1889532 | 2021-11-06 | Greene | Mississippi | 28041 | 2216 | 49 |
1889533 | 1889533 | 2021-11-06 | Grenada | Mississippi | 28043 | 3745 | 109 |
1889534 | 1889534 | 2021-11-06 | Hancock | Mississippi | 28045 | 7782 | 130 |
1889535 | 1889535 | 2021-11-06 | Harrison | Mississippi | 28047 | 34563 | 548 |
1889536 | 1889536 | 2021-11-06 | Hinds | Mississippi | 28049 | 32255 | 637 |
1889537 | 1889537 | 2021-11-06 | Holmes | Mississippi | 28051 | 2693 | 88 |
1889538 | 1889538 | 2021-11-06 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1889539 | 1889539 | 2021-11-06 | Issaquena | Mississippi | 28055 | 193 | 7 |
1889540 | 1889540 | 2021-11-06 | Itawamba | Mississippi | 28057 | 4688 | 106 |
1889541 | 1889541 | 2021-11-06 | Jackson | Mississippi | 28059 | 24658 | 386 |
1889542 | 1889542 | 2021-11-06 | Jasper | Mississippi | 28061 | 3377 | 65 |
1889543 | 1889543 | 2021-11-06 | Jefferson | Mississippi | 28063 | 960 | 34 |
1889544 | 1889544 | 2021-11-06 | Jefferson Davis | Mississippi | 28065 | 1725 | 43 |
1889545 | 1889545 | 2021-11-06 | Jones | Mississippi | 28067 | 13947 | 243 |
1889546 | 1889546 | 2021-11-06 | Kemper | Mississippi | 28069 | 1426 | 41 |
1889547 | 1889547 | 2021-11-06 | Lafayette | Mississippi | 28071 | 8683 | 141 |
1889548 | 1889548 | 2021-11-06 | Lamar | Mississippi | 28073 | 10556 | 138 |
1889549 | 1889549 | 2021-11-06 | Lauderdale | Mississippi | 28075 | 12096 | 323 |
1889550 | 1889550 | 2021-11-06 | Lawrence | Mississippi | 28077 | 2147 | 40 |
1889551 | 1889551 | 2021-11-06 | Leake | Mississippi | 28079 | 4107 | 89 |
1889552 | 1889552 | 2021-11-06 | Lee | Mississippi | 28081 | 15814 | 238 |
1889553 | 1889553 | 2021-11-06 | Leflore | Mississippi | 28083 | 4693 | 144 |
1889554 | 1889554 | 2021-11-06 | Lincoln | Mississippi | 28085 | 5484 | 136 |
1889555 | 1889555 | 2021-11-06 | Lowndes | Mississippi | 28087 | 11171 | 192 |
1889556 | 1889556 | 2021-11-06 | Madison | Mississippi | 28089 | 14756 | 282 |
1889557 | 1889557 | 2021-11-06 | Marion | Mississippi | 28091 | 4244 | 108 |
1889558 | 1889558 | 2021-11-06 | Marshall | Mississippi | 28093 | 6530 | 139 |
1889559 | 1889559 | 2021-11-06 | Monroe | Mississippi | 28095 | 6856 | 179 |
1889560 | 1889560 | 2021-11-06 | Montgomery | Mississippi | 28097 | 1804 | 57 |
1889561 | 1889561 | 2021-11-06 | Neshoba | Mississippi | 28099 | 6680 | 209 |
1889562 | 1889562 | 2021-11-06 | Newton | Mississippi | 28101 | 3863 | 81 |
1889563 | 1889563 | 2021-11-06 | Noxubee | Mississippi | 28103 | 1875 | 41 |
1889564 | 1889564 | 2021-11-06 | Oktibbeha | Mississippi | 28105 | 7175 | 133 |
1889565 | 1889565 | 2021-11-06 | Panola | Mississippi | 28107 | 6651 | 131 |
1889566 | 1889566 | 2021-11-06 | Pearl River | Mississippi | 28109 | 9631 | 241 |
1889567 | 1889567 | 2021-11-06 | Perry | Mississippi | 28111 | 2091 | 56 |
1889568 | 1889568 | 2021-11-06 | Pike | Mississippi | 28113 | 5882 | 155 |
1889569 | 1889569 | 2021-11-06 | Pontotoc | Mississippi | 28115 | 6821 | 107 |
1889570 | 1889570 | 2021-11-06 | Prentiss | Mississippi | 28117 | 4863 | 82 |
1889571 | 1889571 | 2021-11-06 | Quitman | Mississippi | 28119 | 1069 | 28 |
1889572 | 1889572 | 2021-11-06 | Rankin | Mississippi | 28121 | 22271 | 397 |
1889573 | 1889573 | 2021-11-06 | Scott | Mississippi | 28123 | 4749 | 98 |
1889574 | 1889574 | 2021-11-06 | Sharkey | Mississippi | 28125 | 648 | 21 |
1889575 | 1889575 | 2021-11-06 | Simpson | Mississippi | 28127 | 4499 | 116 |
1889576 | 1889576 | 2021-11-06 | Smith | Mississippi | 28129 | 2679 | 52 |
1889577 | 1889577 | 2021-11-06 | Stone | Mississippi | 28131 | 3633 | 66 |
1889578 | 1889578 | 2021-11-06 | Sunflower | Mississippi | 28133 | 4266 | 105 |
1889579 | 1889579 | 2021-11-06 | Tallahatchie | Mississippi | 28135 | 2299 | 52 |
1889580 | 1889580 | 2021-11-06 | Tate | Mississippi | 28137 | 4657 | 113 |
1889581 | 1889581 | 2021-11-06 | Tippah | Mississippi | 28139 | 4764 | 81 |
1889582 | 1889582 | 2021-11-06 | Tishomingo | Mississippi | 28141 | 3692 | 93 |
1889583 | 1889583 | 2021-11-06 | Tunica | Mississippi | 28143 | 1612 | 39 |
1889584 | 1889584 | 2021-11-06 | Union | Mississippi | 28145 | 6148 | 94 |
1889585 | 1889585 | 2021-11-06 | Walthall | Mississippi | 28147 | 2202 | 64 |
1889586 | 1889586 | 2021-11-06 | Warren | Mississippi | 28149 | 6789 | 176 |
1889587 | 1889587 | 2021-11-06 | Washington | Mississippi | 28151 | 7522 | 165 |
1889588 | 1889588 | 2021-11-06 | Wayne | Mississippi | 28153 | 4414 | 72 |
1889589 | 1889589 | 2021-11-06 | Webster | Mississippi | 28155 | 2041 | 48 |
1889590 | 1889590 | 2021-11-06 | Wilkinson | Mississippi | 28157 | 1053 | 39 |
1889591 | 1889591 | 2021-11-06 | Winston | Mississippi | 28159 | 3164 | 91 |
1889592 | 1889592 | 2021-11-06 | Yalobusha | Mississippi | 28161 | 2398 | 47 |
1889593 | 1889593 | 2021-11-06 | Yazoo | Mississippi | 28163 | 4498 | 90 |
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);