ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2269915 | 2269915 | 2022-03-03 | Adams | Mississippi | 28001 | 7104 | 141 |
2269916 | 2269916 | 2022-03-03 | Alcorn | Mississippi | 28003 | 9878 | 148 |
2269917 | 2269917 | 2022-03-03 | Amite | Mississippi | 28005 | 3208 | 67 |
2269918 | 2269918 | 2022-03-03 | Attala | Mississippi | 28007 | 5238 | 111 |
2269919 | 2269919 | 2022-03-03 | Benton | Mississippi | 28009 | 2264 | 49 |
2269920 | 2269920 | 2022-03-03 | Bolivar | Mississippi | 28011 | 9216 | 177 |
2269921 | 2269921 | 2022-03-03 | Calhoun | Mississippi | 28013 | 4632 | 70 |
2269922 | 2269922 | 2022-03-03 | Carroll | Mississippi | 28015 | 2555 | 50 |
2269923 | 2269923 | 2022-03-03 | Chickasaw | Mississippi | 28017 | 5573 | 95 |
2269924 | 2269924 | 2022-03-03 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2269925 | 2269925 | 2022-03-03 | Claiborne | Mississippi | 28021 | 2134 | 46 |
2269926 | 2269926 | 2022-03-03 | Clarke | Mississippi | 28023 | 4204 | 105 |
2269927 | 2269927 | 2022-03-03 | Clay | Mississippi | 28025 | 4933 | 97 |
2269928 | 2269928 | 2022-03-03 | Coahoma | Mississippi | 28027 | 6429 | 120 |
2269929 | 2269929 | 2022-03-03 | Copiah | Mississippi | 28029 | 7098 | 113 |
2269930 | 2269930 | 2022-03-03 | Covington | Mississippi | 28031 | 7052 | 108 |
2269931 | 2269931 | 2022-03-03 | DeSoto | Mississippi | 28033 | 49872 | 539 |
2269932 | 2269932 | 2022-03-03 | Forrest | Mississippi | 28035 | 21896 | 306 |
2269933 | 2269933 | 2022-03-03 | Franklin | Mississippi | 28037 | 1921 | 37 |
2269934 | 2269934 | 2022-03-03 | George | Mississippi | 28039 | 7116 | 86 |
2269935 | 2269935 | 2022-03-03 | Greene | Mississippi | 28041 | 3177 | 56 |
2269936 | 2269936 | 2022-03-03 | Grenada | Mississippi | 28043 | 5490 | 126 |
2269937 | 2269937 | 2022-03-03 | Hancock | Mississippi | 28045 | 12141 | 149 |
2269938 | 2269938 | 2022-03-03 | Harrison | Mississippi | 28047 | 53248 | 646 |
2269939 | 2269939 | 2022-03-03 | Hinds | Mississippi | 28049 | 51928 | 767 |
2269940 | 2269940 | 2022-03-03 | Holmes | Mississippi | 28051 | 4436 | 104 |
2269941 | 2269941 | 2022-03-03 | Humphreys | Mississippi | 28053 | 2007 | 44 |
2269942 | 2269942 | 2022-03-03 | Issaquena | Mississippi | 28055 | 261 | 9 |
2269943 | 2269943 | 2022-03-03 | Itawamba | Mississippi | 28057 | 7357 | 143 |
2269944 | 2269944 | 2022-03-03 | Jackson | Mississippi | 28059 | 36738 | 443 |
2269945 | 2269945 | 2022-03-03 | Jasper | Mississippi | 28061 | 4813 | 73 |
2269946 | 2269946 | 2022-03-03 | Jefferson | Mississippi | 28063 | 1470 | 37 |
2269947 | 2269947 | 2022-03-03 | Jefferson Davis | Mississippi | 28065 | 2841 | 50 |
2269948 | 2269948 | 2022-03-03 | Jones | Mississippi | 28067 | 21097 | 287 |
2269949 | 2269949 | 2022-03-03 | Kemper | Mississippi | 28069 | 2162 | 47 |
2269950 | 2269950 | 2022-03-03 | Lafayette | Mississippi | 28071 | 15108 | 176 |
2269951 | 2269951 | 2022-03-03 | Lamar | Mississippi | 28073 | 17309 | 160 |
2269952 | 2269952 | 2022-03-03 | Lauderdale | Mississippi | 28075 | 18709 | 358 |
2269953 | 2269953 | 2022-03-03 | Lawrence | Mississippi | 28077 | 3562 | 54 |
2269954 | 2269954 | 2022-03-03 | Leake | Mississippi | 28079 | 6370 | 114 |
2269955 | 2269955 | 2022-03-03 | Lee | Mississippi | 28081 | 26528 | 292 |
2269956 | 2269956 | 2022-03-03 | Leflore | Mississippi | 28083 | 7291 | 166 |
2269957 | 2269957 | 2022-03-03 | Lincoln | Mississippi | 28085 | 8249 | 155 |
2269958 | 2269958 | 2022-03-03 | Lowndes | Mississippi | 28087 | 17455 | 233 |
2269959 | 2269959 | 2022-03-03 | Madison | Mississippi | 28089 | 23877 | 319 |
2269960 | 2269960 | 2022-03-03 | Marion | Mississippi | 28091 | 6936 | 134 |
2269961 | 2269961 | 2022-03-03 | Marshall | Mississippi | 28093 | 9875 | 172 |
2269962 | 2269962 | 2022-03-03 | Monroe | Mississippi | 28095 | 10937 | 214 |
2269963 | 2269963 | 2022-03-03 | Montgomery | Mississippi | 28097 | 2946 | 74 |
2269964 | 2269964 | 2022-03-03 | Neshoba | Mississippi | 28099 | 10558 | 235 |
2269965 | 2269965 | 2022-03-03 | Newton | Mississippi | 28101 | 5978 | 96 |
2269966 | 2269966 | 2022-03-03 | Noxubee | Mississippi | 28103 | 2714 | 48 |
2269967 | 2269967 | 2022-03-03 | Oktibbeha | Mississippi | 28105 | 11054 | 158 |
2269968 | 2269968 | 2022-03-03 | Panola | Mississippi | 28107 | 10363 | 165 |
2269969 | 2269969 | 2022-03-03 | Pearl River | Mississippi | 28109 | 14971 | 267 |
2269970 | 2269970 | 2022-03-03 | Perry | Mississippi | 28111 | 3032 | 63 |
2269971 | 2269971 | 2022-03-03 | Pike | Mississippi | 28113 | 9449 | 183 |
2269972 | 2269972 | 2022-03-03 | Pontotoc | Mississippi | 28115 | 10274 | 137 |
2269973 | 2269973 | 2022-03-03 | Prentiss | Mississippi | 28117 | 8164 | 103 |
2269974 | 2269974 | 2022-03-03 | Quitman | Mississippi | 28119 | 1559 | 31 |
2269975 | 2269975 | 2022-03-03 | Rankin | Mississippi | 28121 | 36340 | 476 |
2269976 | 2269976 | 2022-03-03 | Scott | Mississippi | 28123 | 6477 | 118 |
2269977 | 2269977 | 2022-03-03 | Sharkey | Mississippi | 28125 | 950 | 25 |
2269978 | 2269978 | 2022-03-03 | Simpson | Mississippi | 28127 | 6933 | 143 |
2269979 | 2269979 | 2022-03-03 | Smith | Mississippi | 28129 | 4087 | 66 |
2269980 | 2269980 | 2022-03-03 | Stone | Mississippi | 28131 | 5383 | 70 |
2269981 | 2269981 | 2022-03-03 | Sunflower | Mississippi | 28133 | 5736 | 120 |
2269982 | 2269982 | 2022-03-03 | Tallahatchie | Mississippi | 28135 | 3176 | 60 |
2269983 | 2269983 | 2022-03-03 | Tate | Mississippi | 28137 | 7270 | 139 |
2269984 | 2269984 | 2022-03-03 | Tippah | Mississippi | 28139 | 7294 | 106 |
2269985 | 2269985 | 2022-03-03 | Tishomingo | Mississippi | 28141 | 6100 | 122 |
2269986 | 2269986 | 2022-03-03 | Tunica | Mississippi | 28143 | 2508 | 45 |
2269987 | 2269987 | 2022-03-03 | Union | Mississippi | 28145 | 9446 | 117 |
2269988 | 2269988 | 2022-03-03 | Walthall | Mississippi | 28147 | 3572 | 78 |
2269989 | 2269989 | 2022-03-03 | Warren | Mississippi | 28149 | 10179 | 199 |
2269990 | 2269990 | 2022-03-03 | Washington | Mississippi | 28151 | 10224 | 195 |
2269991 | 2269991 | 2022-03-03 | Wayne | Mississippi | 28153 | 5943 | 84 |
2269992 | 2269992 | 2022-03-03 | Webster | Mississippi | 28155 | 3374 | 68 |
2269993 | 2269993 | 2022-03-03 | Wilkinson | Mississippi | 28157 | 1790 | 45 |
2269994 | 2269994 | 2022-03-03 | Winston | Mississippi | 28159 | 5197 | 103 |
2269995 | 2269995 | 2022-03-03 | Yalobusha | Mississippi | 28161 | 4052 | 56 |
2269996 | 2269996 | 2022-03-03 | Yazoo | Mississippi | 28163 | 7999 | 103 |
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);