ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where date = "2020-05-10" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
131576 | 131576 | 2020-05-10 | Adams | Mississippi | 28001 | 159 | 12 |
131577 | 131577 | 2020-05-10 | Alcorn | Mississippi | 28003 | 10 | 1 |
131578 | 131578 | 2020-05-10 | Amite | Mississippi | 28005 | 38 | 0 |
131579 | 131579 | 2020-05-10 | Attala | Mississippi | 28007 | 190 | 4 |
131580 | 131580 | 2020-05-10 | Benton | Mississippi | 28009 | 13 | 0 |
131581 | 131581 | 2020-05-10 | Bolivar | Mississippi | 28011 | 118 | 9 |
131582 | 131582 | 2020-05-10 | Calhoun | Mississippi | 28013 | 57 | 4 |
131583 | 131583 | 2020-05-10 | Carroll | Mississippi | 28015 | 103 | 4 |
131584 | 131584 | 2020-05-10 | Chickasaw | Mississippi | 28017 | 92 | 10 |
131585 | 131585 | 2020-05-10 | Choctaw | Mississippi | 28019 | 16 | 2 |
131586 | 131586 | 2020-05-10 | Claiborne | Mississippi | 28021 | 41 | 0 |
131587 | 131587 | 2020-05-10 | Clarke | Mississippi | 28023 | 81 | 8 |
131588 | 131588 | 2020-05-10 | Clay | Mississippi | 28025 | 66 | 3 |
131589 | 131589 | 2020-05-10 | Coahoma | Mississippi | 28027 | 71 | 3 |
131590 | 131590 | 2020-05-10 | Copiah | Mississippi | 28029 | 162 | 1 |
131591 | 131591 | 2020-05-10 | Covington | Mississippi | 28031 | 90 | 1 |
131592 | 131592 | 2020-05-10 | DeSoto | Mississippi | 28033 | 331 | 5 |
131593 | 131593 | 2020-05-10 | Forrest | Mississippi | 28035 | 314 | 21 |
131594 | 131594 | 2020-05-10 | Franklin | Mississippi | 28037 | 19 | 1 |
131595 | 131595 | 2020-05-10 | George | Mississippi | 28039 | 15 | 1 |
131596 | 131596 | 2020-05-10 | Greene | Mississippi | 28041 | 6 | 1 |
131597 | 131597 | 2020-05-10 | Grenada | Mississippi | 28043 | 51 | 2 |
131598 | 131598 | 2020-05-10 | Hancock | Mississippi | 28045 | 74 | 10 |
131599 | 131599 | 2020-05-10 | Harrison | Mississippi | 28047 | 198 | 6 |
131600 | 131600 | 2020-05-10 | Hinds | Mississippi | 28049 | 670 | 15 |
131601 | 131601 | 2020-05-10 | Holmes | Mississippi | 28051 | 213 | 19 |
131602 | 131602 | 2020-05-10 | Humphreys | Mississippi | 28053 | 30 | 4 |
131603 | 131603 | 2020-05-10 | Itawamba | Mississippi | 28057 | 68 | 6 |
131604 | 131604 | 2020-05-10 | Jackson | Mississippi | 28059 | 275 | 11 |
131605 | 131605 | 2020-05-10 | Jasper | Mississippi | 28061 | 86 | 2 |
131606 | 131606 | 2020-05-10 | Jefferson | Mississippi | 28063 | 30 | 0 |
131607 | 131607 | 2020-05-10 | Jefferson Davis | Mississippi | 28065 | 53 | 1 |
131608 | 131608 | 2020-05-10 | Jones | Mississippi | 28067 | 247 | 5 |
131609 | 131609 | 2020-05-10 | Kemper | Mississippi | 28069 | 92 | 6 |
131610 | 131610 | 2020-05-10 | Lafayette | Mississippi | 28071 | 98 | 3 |
131611 | 131611 | 2020-05-10 | Lamar | Mississippi | 28073 | 152 | 4 |
131612 | 131612 | 2020-05-10 | Lauderdale | Mississippi | 28075 | 482 | 43 |
131613 | 131613 | 2020-05-10 | Lawrence | Mississippi | 28077 | 66 | 0 |
131614 | 131614 | 2020-05-10 | Leake | Mississippi | 28079 | 299 | 3 |
131615 | 131615 | 2020-05-10 | Lee | Mississippi | 28081 | 77 | 4 |
131616 | 131616 | 2020-05-10 | Leflore | Mississippi | 28083 | 185 | 18 |
131617 | 131617 | 2020-05-10 | Lincoln | Mississippi | 28085 | 186 | 14 |
131618 | 131618 | 2020-05-10 | Lowndes | Mississippi | 28087 | 83 | 3 |
131619 | 131619 | 2020-05-10 | Madison | Mississippi | 28089 | 431 | 12 |
131620 | 131620 | 2020-05-10 | Marion | Mississippi | 28091 | 81 | 7 |
131621 | 131621 | 2020-05-10 | Marshall | Mississippi | 28093 | 55 | 2 |
131622 | 131622 | 2020-05-10 | Monroe | Mississippi | 28095 | 199 | 21 |
131623 | 131623 | 2020-05-10 | Montgomery | Mississippi | 28097 | 69 | 1 |
131624 | 131624 | 2020-05-10 | Neshoba | Mississippi | 28099 | 315 | 14 |
131625 | 131625 | 2020-05-10 | Newton | Mississippi | 28101 | 138 | 1 |
131626 | 131626 | 2020-05-10 | Noxubee | Mississippi | 28103 | 102 | 2 |
131627 | 131627 | 2020-05-10 | Oktibbeha | Mississippi | 28105 | 89 | 4 |
131628 | 131628 | 2020-05-10 | Panola | Mississippi | 28107 | 43 | 2 |
131629 | 131629 | 2020-05-10 | Pearl River | Mississippi | 28109 | 189 | 24 |
131630 | 131630 | 2020-05-10 | Perry | Mississippi | 28111 | 34 | 1 |
131631 | 131631 | 2020-05-10 | Pike | Mississippi | 28113 | 168 | 10 |
131632 | 131632 | 2020-05-10 | Pontotoc | Mississippi | 28115 | 24 | 2 |
131633 | 131633 | 2020-05-10 | Prentiss | Mississippi | 28117 | 36 | 2 |
131634 | 131634 | 2020-05-10 | Quitman | Mississippi | 28119 | 17 | 0 |
131635 | 131635 | 2020-05-10 | Rankin | Mississippi | 28121 | 250 | 6 |
131636 | 131636 | 2020-05-10 | Scott | Mississippi | 28123 | 457 | 6 |
131637 | 131637 | 2020-05-10 | Sharkey | Mississippi | 28125 | 5 | 0 |
131638 | 131638 | 2020-05-10 | Simpson | Mississippi | 28127 | 61 | 0 |
131639 | 131639 | 2020-05-10 | Smith | Mississippi | 28129 | 100 | 6 |
131640 | 131640 | 2020-05-10 | Stone | Mississippi | 28131 | 24 | 0 |
131641 | 131641 | 2020-05-10 | Sunflower | Mississippi | 28133 | 63 | 3 |
131642 | 131642 | 2020-05-10 | Tallahatchie | Mississippi | 28135 | 12 | 1 |
131643 | 131643 | 2020-05-10 | Tate | Mississippi | 28137 | 50 | 0 |
131644 | 131644 | 2020-05-10 | Tippah | Mississippi | 28139 | 65 | 11 |
131645 | 131645 | 2020-05-10 | Tishomingo | Mississippi | 28141 | 10 | 0 |
131646 | 131646 | 2020-05-10 | Tunica | Mississippi | 28143 | 38 | 2 |
131647 | 131647 | 2020-05-10 | Union | Mississippi | 28145 | 47 | 3 |
131648 | 131648 | 2020-05-10 | Walthall | Mississippi | 28147 | 39 | 0 |
131649 | 131649 | 2020-05-10 | Warren | Mississippi | 28149 | 117 | 2 |
131650 | 131650 | 2020-05-10 | Washington | Mississippi | 28151 | 82 | 3 |
131651 | 131651 | 2020-05-10 | Wayne | Mississippi | 28153 | 27 | 0 |
131652 | 131652 | 2020-05-10 | Webster | Mississippi | 28155 | 22 | 1 |
131653 | 131653 | 2020-05-10 | Wilkinson | Mississippi | 28157 | 77 | 9 |
131654 | 131654 | 2020-05-10 | Winston | Mississippi | 28159 | 63 | 0 |
131655 | 131655 | 2020-05-10 | Yalobusha | Mississippi | 28161 | 31 | 0 |
131656 | 131656 | 2020-05-10 | Yazoo | Mississippi | 28163 | 164 | 2 |
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);