ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where date = "2020-05-22" 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 |
---|---|---|---|---|---|---|---|
167685 | 167685 | 2020-05-22 | Adams | Mississippi | 28001 | 180 | 15 |
167686 | 167686 | 2020-05-22 | Alcorn | Mississippi | 28003 | 15 | 1 |
167687 | 167687 | 2020-05-22 | Amite | Mississippi | 28005 | 49 | 1 |
167688 | 167688 | 2020-05-22 | Attala | Mississippi | 28007 | 269 | 12 |
167689 | 167689 | 2020-05-22 | Benton | Mississippi | 28009 | 13 | 0 |
167690 | 167690 | 2020-05-22 | Bolivar | Mississippi | 28011 | 134 | 10 |
167691 | 167691 | 2020-05-22 | Calhoun | Mississippi | 28013 | 60 | 4 |
167692 | 167692 | 2020-05-22 | Carroll | Mississippi | 28015 | 113 | 9 |
167693 | 167693 | 2020-05-22 | Chickasaw | Mississippi | 28017 | 125 | 12 |
167694 | 167694 | 2020-05-22 | Choctaw | Mississippi | 28019 | 29 | 2 |
167695 | 167695 | 2020-05-22 | Claiborne | Mississippi | 28021 | 58 | 1 |
167696 | 167696 | 2020-05-22 | Clarke | Mississippi | 28023 | 123 | 16 |
167697 | 167697 | 2020-05-22 | Clay | Mississippi | 28025 | 95 | 3 |
167698 | 167698 | 2020-05-22 | Coahoma | Mississippi | 28027 | 92 | 3 |
167699 | 167699 | 2020-05-22 | Copiah | Mississippi | 28029 | 259 | 4 |
167700 | 167700 | 2020-05-22 | Covington | Mississippi | 28031 | 125 | 1 |
167701 | 167701 | 2020-05-22 | DeSoto | Mississippi | 28033 | 442 | 6 |
167702 | 167702 | 2020-05-22 | Forrest | Mississippi | 28035 | 462 | 32 |
167703 | 167703 | 2020-05-22 | Franklin | Mississippi | 28037 | 23 | 2 |
167704 | 167704 | 2020-05-22 | George | Mississippi | 28039 | 19 | 1 |
167705 | 167705 | 2020-05-22 | Greene | Mississippi | 28041 | 7 | 1 |
167706 | 167706 | 2020-05-22 | Grenada | Mississippi | 28043 | 68 | 2 |
167707 | 167707 | 2020-05-22 | Hancock | Mississippi | 28045 | 86 | 10 |
167708 | 167708 | 2020-05-22 | Harrison | Mississippi | 28047 | 230 | 6 |
167709 | 167709 | 2020-05-22 | Hinds | Mississippi | 28049 | 855 | 24 |
167710 | 167710 | 2020-05-22 | Holmes | Mississippi | 28051 | 343 | 22 |
167711 | 167711 | 2020-05-22 | Humphreys | Mississippi | 28053 | 50 | 6 |
167712 | 167712 | 2020-05-22 | Itawamba | Mississippi | 28057 | 81 | 7 |
167713 | 167713 | 2020-05-22 | Jackson | Mississippi | 28059 | 291 | 13 |
167714 | 167714 | 2020-05-22 | Jasper | Mississippi | 28061 | 131 | 3 |
167715 | 167715 | 2020-05-22 | Jefferson | Mississippi | 28063 | 40 | 0 |
167716 | 167716 | 2020-05-22 | Jefferson Davis | Mississippi | 28065 | 69 | 2 |
167717 | 167717 | 2020-05-22 | Jones | Mississippi | 28067 | 422 | 12 |
167718 | 167718 | 2020-05-22 | Kemper | Mississippi | 28069 | 116 | 10 |
167719 | 167719 | 2020-05-22 | Lafayette | Mississippi | 28071 | 116 | 3 |
167720 | 167720 | 2020-05-22 | Lamar | Mississippi | 28073 | 215 | 4 |
167721 | 167721 | 2020-05-22 | Lauderdale | Mississippi | 28075 | 647 | 51 |
167722 | 167722 | 2020-05-22 | Lawrence | Mississippi | 28077 | 82 | 1 |
167723 | 167723 | 2020-05-22 | Leake | Mississippi | 28079 | 373 | 8 |
167724 | 167724 | 2020-05-22 | Lee | Mississippi | 28081 | 99 | 5 |
167725 | 167725 | 2020-05-22 | Leflore | Mississippi | 28083 | 211 | 25 |
167726 | 167726 | 2020-05-22 | Lincoln | Mississippi | 28085 | 231 | 19 |
167727 | 167727 | 2020-05-22 | Lowndes | Mississippi | 28087 | 139 | 7 |
167728 | 167728 | 2020-05-22 | Madison | Mississippi | 28089 | 618 | 20 |
167729 | 167729 | 2020-05-22 | Marion | Mississippi | 28091 | 103 | 8 |
167730 | 167730 | 2020-05-22 | Marshall | Mississippi | 28093 | 68 | 3 |
167731 | 167731 | 2020-05-22 | Monroe | Mississippi | 28095 | 231 | 24 |
167732 | 167732 | 2020-05-22 | Montgomery | Mississippi | 28097 | 77 | 1 |
167733 | 167733 | 2020-05-22 | Neshoba | Mississippi | 28099 | 477 | 27 |
167734 | 167734 | 2020-05-22 | Newton | Mississippi | 28101 | 214 | 3 |
167735 | 167735 | 2020-05-22 | Noxubee | Mississippi | 28103 | 152 | 4 |
167736 | 167736 | 2020-05-22 | Oktibbeha | Mississippi | 28105 | 126 | 9 |
167737 | 167737 | 2020-05-22 | Panola | Mississippi | 28107 | 59 | 2 |
167738 | 167738 | 2020-05-22 | Pearl River | Mississippi | 28109 | 203 | 27 |
167739 | 167739 | 2020-05-22 | Perry | Mississippi | 28111 | 40 | 2 |
167740 | 167740 | 2020-05-22 | Pike | Mississippi | 28113 | 190 | 11 |
167741 | 167741 | 2020-05-22 | Pontotoc | Mississippi | 28115 | 26 | 2 |
167742 | 167742 | 2020-05-22 | Prentiss | Mississippi | 28117 | 37 | 3 |
167743 | 167743 | 2020-05-22 | Quitman | Mississippi | 28119 | 23 | 0 |
167744 | 167744 | 2020-05-22 | Rankin | Mississippi | 28121 | 325 | 6 |
167745 | 167745 | 2020-05-22 | Scott | Mississippi | 28123 | 578 | 10 |
167746 | 167746 | 2020-05-22 | Sharkey | Mississippi | 28125 | 7 | 0 |
167747 | 167747 | 2020-05-22 | Simpson | Mississippi | 28127 | 82 | 0 |
167748 | 167748 | 2020-05-22 | Smith | Mississippi | 28129 | 127 | 10 |
167749 | 167749 | 2020-05-22 | Stone | Mississippi | 28131 | 27 | 0 |
167750 | 167750 | 2020-05-22 | Sunflower | Mississippi | 28133 | 73 | 3 |
167751 | 167751 | 2020-05-22 | Tallahatchie | Mississippi | 28135 | 23 | 1 |
167752 | 167752 | 2020-05-22 | Tate | Mississippi | 28137 | 59 | 1 |
167753 | 167753 | 2020-05-22 | Tippah | Mississippi | 28139 | 69 | 11 |
167754 | 167754 | 2020-05-22 | Tishomingo | Mississippi | 28141 | 22 | 0 |
167755 | 167755 | 2020-05-22 | Tunica | Mississippi | 28143 | 47 | 2 |
167756 | 167756 | 2020-05-22 | Union | Mississippi | 28145 | 68 | 4 |
167757 | 167757 | 2020-05-22 | Walthall | Mississippi | 28147 | 50 | 0 |
167758 | 167758 | 2020-05-22 | Warren | Mississippi | 28149 | 144 | 6 |
167759 | 167759 | 2020-05-22 | Washington | Mississippi | 28151 | 143 | 4 |
167760 | 167760 | 2020-05-22 | Wayne | Mississippi | 28153 | 72 | 0 |
167761 | 167761 | 2020-05-22 | Webster | Mississippi | 28155 | 27 | 1 |
167762 | 167762 | 2020-05-22 | Wilkinson | Mississippi | 28157 | 81 | 9 |
167763 | 167763 | 2020-05-22 | Winston | Mississippi | 28159 | 92 | 0 |
167764 | 167764 | 2020-05-22 | Yalobusha | Mississippi | 28161 | 79 | 4 |
167765 | 167765 | 2020-05-22 | Yazoo | Mississippi | 28163 | 198 | 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);