ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2021-11-15" 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 |
---|---|---|---|---|---|---|---|
1918760 | 1918760 | 2021-11-15 | Adams | Mississippi | 28001 | 4675 | 125 |
1918761 | 1918761 | 2021-11-15 | Alcorn | Mississippi | 28003 | 5797 | 105 |
1918762 | 1918762 | 2021-11-15 | Amite | Mississippi | 28005 | 2088 | 56 |
1918763 | 1918763 | 2021-11-15 | Attala | Mississippi | 28007 | 3363 | 90 |
1918764 | 1918764 | 2021-11-15 | Benton | Mississippi | 28009 | 1515 | 39 |
1918765 | 1918765 | 2021-11-15 | Bolivar | Mississippi | 28011 | 6415 | 151 |
1918766 | 1918766 | 2021-11-15 | Calhoun | Mississippi | 28013 | 2827 | 49 |
1918767 | 1918767 | 2021-11-15 | Carroll | Mississippi | 28015 | 1719 | 40 |
1918768 | 1918768 | 2021-11-15 | Chickasaw | Mississippi | 28017 | 3072 | 67 |
1918769 | 1918769 | 2021-11-15 | Choctaw | Mississippi | 28019 | 1357 | 27 |
1918770 | 1918770 | 2021-11-15 | Claiborne | Mississippi | 28021 | 1339 | 38 |
1918771 | 1918771 | 2021-11-15 | Clarke | Mississippi | 28023 | 2993 | 95 |
1918772 | 1918772 | 2021-11-15 | Clay | Mississippi | 28025 | 3106 | 78 |
1918773 | 1918773 | 2021-11-15 | Coahoma | Mississippi | 28027 | 4212 | 109 |
1918774 | 1918774 | 2021-11-15 | Copiah | Mississippi | 28029 | 4521 | 94 |
1918775 | 1918775 | 2021-11-15 | Covington | Mississippi | 28031 | 4311 | 95 |
1918776 | 1918776 | 2021-11-15 | DeSoto | Mississippi | 28033 | 32830 | 422 |
1918777 | 1918777 | 2021-11-15 | Forrest | Mississippi | 28035 | 13645 | 255 |
1918778 | 1918778 | 2021-11-15 | Franklin | Mississippi | 28037 | 1228 | 29 |
1918779 | 1918779 | 2021-11-15 | George | Mississippi | 28039 | 5086 | 80 |
1918780 | 1918780 | 2021-11-15 | Greene | Mississippi | 28041 | 2237 | 49 |
1918781 | 1918781 | 2021-11-15 | Grenada | Mississippi | 28043 | 3759 | 109 |
1918782 | 1918782 | 2021-11-15 | Hancock | Mississippi | 28045 | 7809 | 130 |
1918783 | 1918783 | 2021-11-15 | Harrison | Mississippi | 28047 | 34667 | 552 |
1918784 | 1918784 | 2021-11-15 | Hinds | Mississippi | 28049 | 32411 | 639 |
1918785 | 1918785 | 2021-11-15 | Holmes | Mississippi | 28051 | 2702 | 89 |
1918786 | 1918786 | 2021-11-15 | Humphreys | Mississippi | 28053 | 1307 | 39 |
1918787 | 1918787 | 2021-11-15 | Issaquena | Mississippi | 28055 | 194 | 7 |
1918788 | 1918788 | 2021-11-15 | Itawamba | Mississippi | 28057 | 4740 | 107 |
1918789 | 1918789 | 2021-11-15 | Jackson | Mississippi | 28059 | 24757 | 386 |
1918790 | 1918790 | 2021-11-15 | Jasper | Mississippi | 28061 | 3390 | 66 |
1918791 | 1918791 | 2021-11-15 | Jefferson | Mississippi | 28063 | 962 | 34 |
1918792 | 1918792 | 2021-11-15 | Jefferson Davis | Mississippi | 28065 | 1729 | 43 |
1918793 | 1918793 | 2021-11-15 | Jones | Mississippi | 28067 | 14030 | 246 |
1918794 | 1918794 | 2021-11-15 | Kemper | Mississippi | 28069 | 1438 | 41 |
1918795 | 1918795 | 2021-11-15 | Lafayette | Mississippi | 28071 | 8737 | 141 |
1918796 | 1918796 | 2021-11-15 | Lamar | Mississippi | 28073 | 10600 | 140 |
1918797 | 1918797 | 2021-11-15 | Lauderdale | Mississippi | 28075 | 12155 | 324 |
1918798 | 1918798 | 2021-11-15 | Lawrence | Mississippi | 28077 | 2164 | 40 |
1918799 | 1918799 | 2021-11-15 | Leake | Mississippi | 28079 | 4119 | 90 |
1918800 | 1918800 | 2021-11-15 | Lee | Mississippi | 28081 | 16012 | 239 |
1918801 | 1918801 | 2021-11-15 | Leflore | Mississippi | 28083 | 4707 | 144 |
1918802 | 1918802 | 2021-11-15 | Lincoln | Mississippi | 28085 | 5498 | 136 |
1918803 | 1918803 | 2021-11-15 | Lowndes | Mississippi | 28087 | 11205 | 193 |
1918804 | 1918804 | 2021-11-15 | Madison | Mississippi | 28089 | 14820 | 282 |
1918805 | 1918805 | 2021-11-15 | Marion | Mississippi | 28091 | 4254 | 109 |
1918806 | 1918806 | 2021-11-15 | Marshall | Mississippi | 28093 | 6586 | 139 |
1918807 | 1918807 | 2021-11-15 | Monroe | Mississippi | 28095 | 6912 | 179 |
1918808 | 1918808 | 2021-11-15 | Montgomery | Mississippi | 28097 | 1810 | 57 |
1918809 | 1918809 | 2021-11-15 | Neshoba | Mississippi | 28099 | 6702 | 210 |
1918810 | 1918810 | 2021-11-15 | Newton | Mississippi | 28101 | 3935 | 81 |
1918811 | 1918811 | 2021-11-15 | Noxubee | Mississippi | 28103 | 1882 | 42 |
1918812 | 1918812 | 2021-11-15 | Oktibbeha | Mississippi | 28105 | 7185 | 138 |
1918813 | 1918813 | 2021-11-15 | Panola | Mississippi | 28107 | 6693 | 133 |
1918814 | 1918814 | 2021-11-15 | Pearl River | Mississippi | 28109 | 9672 | 242 |
1918815 | 1918815 | 2021-11-15 | Perry | Mississippi | 28111 | 2122 | 56 |
1918816 | 1918816 | 2021-11-15 | Pike | Mississippi | 28113 | 5906 | 155 |
1918817 | 1918817 | 2021-11-15 | Pontotoc | Mississippi | 28115 | 6869 | 109 |
1918818 | 1918818 | 2021-11-15 | Prentiss | Mississippi | 28117 | 4948 | 83 |
1918819 | 1918819 | 2021-11-15 | Quitman | Mississippi | 28119 | 1071 | 28 |
1918820 | 1918820 | 2021-11-15 | Rankin | Mississippi | 28121 | 22360 | 401 |
1918821 | 1918821 | 2021-11-15 | Scott | Mississippi | 28123 | 4756 | 98 |
1918822 | 1918822 | 2021-11-15 | Sharkey | Mississippi | 28125 | 650 | 21 |
1918823 | 1918823 | 2021-11-15 | Simpson | Mississippi | 28127 | 4520 | 117 |
1918824 | 1918824 | 2021-11-15 | Smith | Mississippi | 28129 | 2684 | 52 |
1918825 | 1918825 | 2021-11-15 | Stone | Mississippi | 28131 | 3643 | 66 |
1918826 | 1918826 | 2021-11-15 | Sunflower | Mississippi | 28133 | 4278 | 106 |
1918827 | 1918827 | 2021-11-15 | Tallahatchie | Mississippi | 28135 | 2307 | 52 |
1918828 | 1918828 | 2021-11-15 | Tate | Mississippi | 28137 | 4700 | 113 |
1918829 | 1918829 | 2021-11-15 | Tippah | Mississippi | 28139 | 4837 | 81 |
1918830 | 1918830 | 2021-11-15 | Tishomingo | Mississippi | 28141 | 3718 | 93 |
1918831 | 1918831 | 2021-11-15 | Tunica | Mississippi | 28143 | 1616 | 39 |
1918832 | 1918832 | 2021-11-15 | Union | Mississippi | 28145 | 6208 | 95 |
1918833 | 1918833 | 2021-11-15 | Walthall | Mississippi | 28147 | 2207 | 65 |
1918834 | 1918834 | 2021-11-15 | Warren | Mississippi | 28149 | 6819 | 177 |
1918835 | 1918835 | 2021-11-15 | Washington | Mississippi | 28151 | 7537 | 168 |
1918836 | 1918836 | 2021-11-15 | Wayne | Mississippi | 28153 | 4423 | 72 |
1918837 | 1918837 | 2021-11-15 | Webster | Mississippi | 28155 | 2042 | 48 |
1918838 | 1918838 | 2021-11-15 | Wilkinson | Mississippi | 28157 | 1057 | 39 |
1918839 | 1918839 | 2021-11-15 | Winston | Mississippi | 28159 | 3173 | 91 |
1918840 | 1918840 | 2021-11-15 | Yalobusha | Mississippi | 28161 | 2411 | 47 |
1918841 | 1918841 | 2021-11-15 | Yazoo | Mississippi | 28163 | 4534 | 91 |
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);