ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 71 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
307426 | 307426 | 2020-07-06 | Alcorn | Mississippi | 28003 | 71 | 2 |
291628 | 291628 | 2020-07-01 | Choctaw | Mississippi | 28019 | 71 | 4 |
288477 | 288477 | 2020-06-30 | Choctaw | Mississippi | 28019 | 71 | 4 |
285327 | 285327 | 2020-06-29 | Choctaw | Mississippi | 28019 | 71 | 4 |
282182 | 282182 | 2020-06-28 | Choctaw | Mississippi | 28019 | 71 | 4 |
269617 | 269617 | 2020-06-24 | Greene | Mississippi | 28041 | 71 | 5 |
266484 | 266484 | 2020-06-23 | Greene | Mississippi | 28041 | 71 | 5 |
260218 | 260218 | 2020-06-21 | Choctaw | Mississippi | 28019 | 71 | 2 |
257092 | 257092 | 2020-06-20 | Choctaw | Mississippi | 28019 | 71 | 2 |
253972 | 253972 | 2020-06-19 | Choctaw | Mississippi | 28019 | 71 | 2 |
250857 | 250857 | 2020-06-18 | Choctaw | Mississippi | 28019 | 71 | 2 |
247745 | 247745 | 2020-06-17 | Choctaw | Mississippi | 28019 | 71 | 2 |
244625 | 244625 | 2020-06-16 | Amite | Mississippi | 28005 | 71 | 2 |
235352 | 235352 | 2020-06-13 | Pontotoc | Mississippi | 28115 | 71 | 3 |
198267 | 198267 | 2020-06-01 | Panola | Mississippi | 28107 | 71 | 3 |
195196 | 195196 | 2020-05-31 | Panola | Mississippi | 28107 | 71 | 3 |
189080 | 189080 | 2020-05-29 | Tippah | Mississippi | 28139 | 71 | 11 |
186022 | 186022 | 2020-05-28 | Tippah | Mississippi | 28139 | 71 | 11 |
182966 | 182966 | 2020-05-27 | Tippah | Mississippi | 28139 | 71 | 11 |
179897 | 179897 | 2020-05-26 | Marshall | Mississippi | 28093 | 71 | 3 |
179920 | 179920 | 2020-05-26 | Tippah | Mississippi | 28139 | 71 | 11 |
176839 | 176839 | 2020-05-25 | Jefferson Davis | Mississippi | 28065 | 71 | 2 |
176853 | 176853 | 2020-05-25 | Marshall | Mississippi | 28093 | 71 | 3 |
173796 | 173796 | 2020-05-24 | Jefferson Davis | Mississippi | 28065 | 71 | 2 |
173836 | 173836 | 2020-05-24 | Union | Mississippi | 28145 | 71 | 5 |
164714 | 164714 | 2020-05-21 | Sunflower | Mississippi | 28133 | 71 | 3 |
152641 | 152641 | 2020-05-17 | Yalobusha | Mississippi | 28161 | 71 | 0 |
149598 | 149598 | 2020-05-16 | Montgomery | Mississippi | 28097 | 71 | 1 |
149630 | 149630 | 2020-05-16 | Yalobusha | Mississippi | 28161 | 71 | 0 |
146593 | 146593 | 2020-05-15 | Montgomery | Mississippi | 28097 | 71 | 1 |
140578 | 140578 | 2020-05-13 | Itawamba | Mississippi | 28057 | 71 | 7 |
140588 | 140588 | 2020-05-13 | Lawrence | Mississippi | 28077 | 71 | 0 |
134580 | 134580 | 2020-05-11 | Coahoma | Mississippi | 28027 | 71 | 3 |
131589 | 131589 | 2020-05-10 | Coahoma | Mississippi | 28027 | 71 | 3 |
128599 | 128599 | 2020-05-09 | Coahoma | Mississippi | 28027 | 71 | 3 |
125612 | 125612 | 2020-05-08 | Coahoma | Mississippi | 28027 | 71 | 3 |
122628 | 122628 | 2020-05-07 | Clarke | Mississippi | 28023 | 71 | 6 |
122659 | 122659 | 2020-05-07 | Lowndes | Mississippi | 28087 | 71 | 3 |
116760 | 116760 | 2020-05-05 | Wilkinson | Mississippi | 28157 | 71 | 7 |
110961 | 110961 | 2020-05-03 | Lee | Mississippi | 28081 | 71 | 4 |
108090 | 108090 | 2020-05-02 | Lee | Mississippi | 28081 | 71 | 4 |
105225 | 105225 | 2020-05-01 | Lee | Mississippi | 28081 | 71 | 4 |
96666 | 96666 | 2020-04-28 | Lee | Mississippi | 28081 | 71 | 4 |
90984 | 90984 | 2020-04-26 | Copiah | Mississippi | 28029 | 71 | 1 |
82614 | 82614 | 2020-04-23 | Washington | Mississippi | 28151 | 71 | 3 |
79818 | 79818 | 2020-04-22 | Washington | Mississippi | 28151 | 71 | 3 |
77033 | 77033 | 2020-04-21 | Washington | Mississippi | 28151 | 71 | 3 |
74213 | 74213 | 2020-04-20 | Lamar | Mississippi | 28073 | 71 | 2 |
74252 | 74252 | 2020-04-20 | Washington | Mississippi | 28151 | 71 | 3 |
71479 | 71479 | 2020-04-19 | Washington | Mississippi | 28151 | 71 | 3 |
44423 | 44423 | 2020-04-09 | Forrest | Mississippi | 28035 | 71 | 2 |
18615 | 18615 | 2020-03-29 | DeSoto | Mississippi | 28033 | 71 | 1 |
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);