ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2020-06-25" 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 |
---|---|---|---|---|---|---|---|
272734 | 272734 | 2020-06-25 | Adams | Mississippi | 28001 | 242 | 18 |
272735 | 272735 | 2020-06-25 | Alcorn | Mississippi | 28003 | 47 | 1 |
272736 | 272736 | 2020-06-25 | Amite | Mississippi | 28005 | 81 | 2 |
272737 | 272737 | 2020-06-25 | Attala | Mississippi | 28007 | 341 | 23 |
272738 | 272738 | 2020-06-25 | Benton | Mississippi | 28009 | 25 | 0 |
272739 | 272739 | 2020-06-25 | Bolivar | Mississippi | 28011 | 233 | 13 |
272740 | 272740 | 2020-06-25 | Calhoun | Mississippi | 28013 | 108 | 4 |
272741 | 272741 | 2020-06-25 | Carroll | Mississippi | 28015 | 141 | 11 |
272742 | 272742 | 2020-06-25 | Chickasaw | Mississippi | 28017 | 217 | 18 |
272743 | 272743 | 2020-06-25 | Choctaw | Mississippi | 28019 | 68 | 3 |
272744 | 272744 | 2020-06-25 | Claiborne | Mississippi | 28021 | 200 | 10 |
272745 | 272745 | 2020-06-25 | Clarke | Mississippi | 28023 | 193 | 22 |
272746 | 272746 | 2020-06-25 | Clay | Mississippi | 28025 | 229 | 7 |
272747 | 272747 | 2020-06-25 | Coahoma | Mississippi | 28027 | 175 | 6 |
272748 | 272748 | 2020-06-25 | Copiah | Mississippi | 28029 | 528 | 12 |
272749 | 272749 | 2020-06-25 | Covington | Mississippi | 28031 | 253 | 5 |
272750 | 272750 | 2020-06-25 | DeSoto | Mississippi | 28033 | 1091 | 15 |
272751 | 272751 | 2020-06-25 | Forrest | Mississippi | 28035 | 759 | 42 |
272752 | 272752 | 2020-06-25 | Franklin | Mississippi | 28037 | 32 | 2 |
272753 | 272753 | 2020-06-25 | George | Mississippi | 28039 | 60 | 3 |
272754 | 272754 | 2020-06-25 | Greene | Mississippi | 28041 | 75 | 5 |
272755 | 272755 | 2020-06-25 | Grenada | Mississippi | 28043 | 252 | 4 |
272756 | 272756 | 2020-06-25 | Hancock | Mississippi | 28045 | 112 | 13 |
272757 | 272757 | 2020-06-25 | Harrison | Mississippi | 28047 | 562 | 7 |
272758 | 272758 | 2020-06-25 | Hinds | Mississippi | 28049 | 1772 | 34 |
272759 | 272759 | 2020-06-25 | Holmes | Mississippi | 28051 | 501 | 39 |
272760 | 272760 | 2020-06-25 | Humphreys | Mississippi | 28053 | 107 | 9 |
272761 | 272761 | 2020-06-25 | Issaquena | Mississippi | 28055 | 2 | 0 |
272762 | 272762 | 2020-06-25 | Itawamba | Mississippi | 28057 | 112 | 8 |
272763 | 272763 | 2020-06-25 | Jackson | Mississippi | 28059 | 458 | 16 |
272764 | 272764 | 2020-06-25 | Jasper | Mississippi | 28061 | 221 | 6 |
272765 | 272765 | 2020-06-25 | Jefferson | Mississippi | 28063 | 69 | 3 |
272766 | 272766 | 2020-06-25 | Jefferson Davis | Mississippi | 28065 | 94 | 3 |
272767 | 272767 | 2020-06-25 | Jones | Mississippi | 28067 | 994 | 48 |
272768 | 272768 | 2020-06-25 | Kemper | Mississippi | 28069 | 170 | 13 |
272769 | 272769 | 2020-06-25 | Lafayette | Mississippi | 28071 | 303 | 4 |
272770 | 272770 | 2020-06-25 | Lamar | Mississippi | 28073 | 369 | 7 |
272771 | 272771 | 2020-06-25 | Lauderdale | Mississippi | 28075 | 864 | 78 |
272772 | 272772 | 2020-06-25 | Lawrence | Mississippi | 28077 | 140 | 1 |
272773 | 272773 | 2020-06-25 | Leake | Mississippi | 28079 | 520 | 17 |
272774 | 272774 | 2020-06-25 | Lee | Mississippi | 28081 | 429 | 15 |
272775 | 272775 | 2020-06-25 | Leflore | Mississippi | 28083 | 439 | 48 |
272776 | 272776 | 2020-06-25 | Lincoln | Mississippi | 28085 | 411 | 32 |
272777 | 272777 | 2020-06-25 | Lowndes | Mississippi | 28087 | 412 | 10 |
272778 | 272778 | 2020-06-25 | Madison | Mississippi | 28089 | 1082 | 31 |
272779 | 272779 | 2020-06-25 | Marion | Mississippi | 28091 | 215 | 10 |
272780 | 272780 | 2020-06-25 | Marshall | Mississippi | 28093 | 160 | 3 |
272781 | 272781 | 2020-06-25 | Monroe | Mississippi | 28095 | 328 | 28 |
272782 | 272782 | 2020-06-25 | Montgomery | Mississippi | 28097 | 110 | 2 |
272783 | 272783 | 2020-06-25 | Neshoba | Mississippi | 28099 | 922 | 63 |
272784 | 272784 | 2020-06-25 | Newton | Mississippi | 28101 | 325 | 8 |
272785 | 272785 | 2020-06-25 | Noxubee | Mississippi | 28103 | 234 | 7 |
272786 | 272786 | 2020-06-25 | Oktibbeha | Mississippi | 28105 | 448 | 21 |
272787 | 272787 | 2020-06-25 | Panola | Mississippi | 28107 | 221 | 5 |
272788 | 272788 | 2020-06-25 | Pearl River | Mississippi | 28109 | 232 | 32 |
272789 | 272789 | 2020-06-25 | Perry | Mississippi | 28111 | 56 | 4 |
272790 | 272790 | 2020-06-25 | Pike | Mississippi | 28113 | 321 | 11 |
272791 | 272791 | 2020-06-25 | Pontotoc | Mississippi | 28115 | 175 | 3 |
272792 | 272792 | 2020-06-25 | Prentiss | Mississippi | 28117 | 85 | 3 |
272793 | 272793 | 2020-06-25 | Quitman | Mississippi | 28119 | 56 | 0 |
272794 | 272794 | 2020-06-25 | Rankin | Mississippi | 28121 | 682 | 12 |
272795 | 272795 | 2020-06-25 | Scott | Mississippi | 28123 | 721 | 14 |
272796 | 272796 | 2020-06-25 | Sharkey | Mississippi | 28125 | 20 | 0 |
272797 | 272797 | 2020-06-25 | Simpson | Mississippi | 28127 | 187 | 2 |
272798 | 272798 | 2020-06-25 | Smith | Mississippi | 28129 | 199 | 11 |
272799 | 272799 | 2020-06-25 | Stone | Mississippi | 28131 | 48 | 1 |
272800 | 272800 | 2020-06-25 | Sunflower | Mississippi | 28133 | 209 | 6 |
272801 | 272801 | 2020-06-25 | Tallahatchie | Mississippi | 28135 | 85 | 1 |
272802 | 272802 | 2020-06-25 | Tate | Mississippi | 28137 | 221 | 5 |
272803 | 272803 | 2020-06-25 | Tippah | Mississippi | 28139 | 115 | 11 |
272804 | 272804 | 2020-06-25 | Tishomingo | Mississippi | 28141 | 58 | 1 |
272805 | 272805 | 2020-06-25 | Tunica | Mississippi | 28143 | 81 | 3 |
272806 | 272806 | 2020-06-25 | Union | Mississippi | 28145 | 150 | 8 |
272807 | 272807 | 2020-06-25 | Walthall | Mississippi | 28147 | 163 | 3 |
272808 | 272808 | 2020-06-25 | Warren | Mississippi | 28149 | 371 | 16 |
272809 | 272809 | 2020-06-25 | Washington | Mississippi | 28151 | 369 | 9 |
272810 | 272810 | 2020-06-25 | Wayne | Mississippi | 28153 | 461 | 9 |
272811 | 272811 | 2020-06-25 | Webster | Mississippi | 28155 | 124 | 10 |
272812 | 272812 | 2020-06-25 | Wilkinson | Mississippi | 28157 | 87 | 9 |
272813 | 272813 | 2020-06-25 | Winston | Mississippi | 28159 | 217 | 4 |
272814 | 272814 | 2020-06-25 | Yalobusha | Mississippi | 28161 | 141 | 7 |
272815 | 272815 | 2020-06-25 | Yazoo | Mississippi | 28163 | 426 | 6 |
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);