ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2021-01-17 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
938078 | 938078 | 2021-01-17 | Adams | Mississippi | 28001 | 2046 | 70 |
938079 | 938079 | 2021-01-17 | Alcorn | Mississippi | 28003 | 2632 | 53 |
938080 | 938080 | 2021-01-17 | Amite | Mississippi | 28005 | 977 | 25 |
938081 | 938081 | 2021-01-17 | Attala | Mississippi | 28007 | 1935 | 59 |
938082 | 938082 | 2021-01-17 | Benton | Mississippi | 28009 | 815 | 23 |
938083 | 938083 | 2021-01-17 | Bolivar | Mississippi | 28011 | 3966 | 108 |
938084 | 938084 | 2021-01-17 | Calhoun | Mississippi | 28013 | 1357 | 21 |
938085 | 938085 | 2021-01-17 | Carroll | Mississippi | 28015 | 1042 | 21 |
938086 | 938086 | 2021-01-17 | Chickasaw | Mississippi | 28017 | 1836 | 44 |
938087 | 938087 | 2021-01-17 | Choctaw | Mississippi | 28019 | 603 | 13 |
938088 | 938088 | 2021-01-17 | Claiborne | Mississippi | 28021 | 861 | 25 |
938089 | 938089 | 2021-01-17 | Clarke | Mississippi | 28023 | 1386 | 60 |
938090 | 938090 | 2021-01-17 | Clay | Mississippi | 28025 | 1590 | 33 |
938091 | 938091 | 2021-01-17 | Coahoma | Mississippi | 28027 | 2300 | 54 |
938092 | 938092 | 2021-01-17 | Copiah | Mississippi | 28029 | 2408 | 49 |
938093 | 938093 | 2021-01-17 | Covington | Mississippi | 28031 | 2113 | 71 |
938094 | 938094 | 2021-01-17 | DeSoto | Mississippi | 28033 | 17120 | 175 |
938095 | 938095 | 2021-01-17 | Forrest | Mississippi | 28035 | 5949 | 119 |
938096 | 938096 | 2021-01-17 | Franklin | Mississippi | 28037 | 664 | 15 |
938097 | 938097 | 2021-01-17 | George | Mississippi | 28039 | 1990 | 38 |
938098 | 938098 | 2021-01-17 | Greene | Mississippi | 28041 | 1097 | 29 |
938099 | 938099 | 2021-01-17 | Grenada | Mississippi | 28043 | 2177 | 70 |
938100 | 938100 | 2021-01-17 | Hancock | Mississippi | 28045 | 2665 | 59 |
938101 | 938101 | 2021-01-17 | Harrison | Mississippi | 28047 | 13353 | 193 |
938102 | 938102 | 2021-01-17 | Hinds | Mississippi | 28049 | 16207 | 322 |
938103 | 938103 | 2021-01-17 | Holmes | Mississippi | 28051 | 1685 | 67 |
938104 | 938104 | 2021-01-17 | Humphreys | Mississippi | 28053 | 829 | 24 |
938105 | 938105 | 2021-01-17 | Issaquena | Mississippi | 28055 | 159 | 6 |
938106 | 938106 | 2021-01-17 | Itawamba | Mississippi | 28057 | 2624 | 59 |
938107 | 938107 | 2021-01-17 | Jackson | Mississippi | 28059 | 10303 | 183 |
938108 | 938108 | 2021-01-17 | Jasper | Mississippi | 28061 | 1697 | 35 |
938109 | 938109 | 2021-01-17 | Jefferson | Mississippi | 28063 | 538 | 19 |
938110 | 938110 | 2021-01-17 | Jefferson Davis | Mississippi | 28065 | 841 | 25 |
938111 | 938111 | 2021-01-17 | Jones | Mississippi | 28067 | 6288 | 110 |
938112 | 938112 | 2021-01-17 | Kemper | Mississippi | 28069 | 771 | 20 |
938113 | 938113 | 2021-01-17 | Lafayette | Mississippi | 28071 | 4942 | 92 |
938114 | 938114 | 2021-01-17 | Lamar | Mississippi | 28073 | 4841 | 65 |
938115 | 938115 | 2021-01-17 | Lauderdale | Mississippi | 28075 | 5847 | 180 |
938116 | 938116 | 2021-01-17 | Lawrence | Mississippi | 28077 | 1024 | 17 |
938117 | 938117 | 2021-01-17 | Leake | Mississippi | 28079 | 2305 | 64 |
938118 | 938118 | 2021-01-17 | Lee | Mississippi | 28081 | 8796 | 141 |
938119 | 938119 | 2021-01-17 | Leflore | Mississippi | 28083 | 3002 | 105 |
938120 | 938120 | 2021-01-17 | Lincoln | Mississippi | 28085 | 2970 | 85 |
938121 | 938121 | 2021-01-17 | Lowndes | Mississippi | 28087 | 5355 | 116 |
938122 | 938122 | 2021-01-17 | Madison | Mississippi | 28089 | 8232 | 162 |
938123 | 938123 | 2021-01-17 | Marion | Mississippi | 28091 | 2106 | 72 |
938124 | 938124 | 2021-01-17 | Marshall | Mississippi | 28093 | 3416 | 65 |
938125 | 938125 | 2021-01-17 | Monroe | Mississippi | 28095 | 3533 | 105 |
938126 | 938126 | 2021-01-17 | Montgomery | Mississippi | 28097 | 1094 | 34 |
938127 | 938127 | 2021-01-17 | Neshoba | Mississippi | 28099 | 3370 | 152 |
938128 | 938128 | 2021-01-17 | Newton | Mississippi | 28101 | 1913 | 42 |
938129 | 938129 | 2021-01-17 | Noxubee | Mississippi | 28103 | 1103 | 22 |
938130 | 938130 | 2021-01-17 | Oktibbeha | Mississippi | 28105 | 3924 | 80 |
938131 | 938131 | 2021-01-17 | Panola | Mississippi | 28107 | 3683 | 78 |
938132 | 938132 | 2021-01-17 | Pearl River | Mississippi | 28109 | 3278 | 99 |
938133 | 938133 | 2021-01-17 | Perry | Mississippi | 28111 | 1016 | 31 |
938134 | 938134 | 2021-01-17 | Pike | Mississippi | 28113 | 2620 | 77 |
938135 | 938135 | 2021-01-17 | Pontotoc | Mississippi | 28115 | 3628 | 53 |
938136 | 938136 | 2021-01-17 | Prentiss | Mississippi | 28117 | 2450 | 52 |
938137 | 938137 | 2021-01-17 | Quitman | Mississippi | 28119 | 688 | 8 |
938138 | 938138 | 2021-01-17 | Rankin | Mississippi | 28121 | 10689 | 211 |
938139 | 938139 | 2021-01-17 | Scott | Mississippi | 28123 | 2462 | 45 |
938140 | 938140 | 2021-01-17 | Sharkey | Mississippi | 28125 | 427 | 17 |
938141 | 938141 | 2021-01-17 | Simpson | Mississippi | 28127 | 2348 | 67 |
938142 | 938142 | 2021-01-17 | Smith | Mississippi | 28129 | 1201 | 23 |
938143 | 938143 | 2021-01-17 | Stone | Mississippi | 28131 | 1423 | 20 |
938144 | 938144 | 2021-01-17 | Sunflower | Mississippi | 28133 | 2826 | 69 |
938145 | 938145 | 2021-01-17 | Tallahatchie | Mississippi | 28135 | 1401 | 34 |
938146 | 938146 | 2021-01-17 | Tate | Mississippi | 28137 | 2708 | 62 |
938147 | 938147 | 2021-01-17 | Tippah | Mississippi | 28139 | 2404 | 50 |
938148 | 938148 | 2021-01-17 | Tishomingo | Mississippi | 28141 | 1844 | 59 |
938149 | 938149 | 2021-01-17 | Tunica | Mississippi | 28143 | 863 | 21 |
938150 | 938150 | 2021-01-17 | Union | Mississippi | 28145 | 3430 | 60 |
938151 | 938151 | 2021-01-17 | Walthall | Mississippi | 28147 | 1118 | 36 |
938152 | 938152 | 2021-01-17 | Warren | Mississippi | 28149 | 3484 | 98 |
938153 | 938153 | 2021-01-17 | Washington | Mississippi | 28151 | 4777 | 123 |
938154 | 938154 | 2021-01-17 | Wayne | Mississippi | 28153 | 1996 | 30 |
938155 | 938155 | 2021-01-17 | Webster | Mississippi | 28155 | 922 | 24 |
938156 | 938156 | 2021-01-17 | Wilkinson | Mississippi | 28157 | 583 | 25 |
938157 | 938157 | 2021-01-17 | Winston | Mississippi | 28159 | 2001 | 64 |
938158 | 938158 | 2021-01-17 | Yalobusha | Mississippi | 28161 | 1165 | 34 |
938159 | 938159 | 2021-01-17 | Yazoo | Mississippi | 28163 | 2443 | 55 |
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);