ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 85 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
371286 | 371286 | 2020-07-26 | Franklin | Mississippi | 28037 | 85 | 2 |
361647 | 361647 | 2020-07-23 | Benton | Mississippi | 28009 | 85 | 0 |
336105 | 336105 | 2020-07-15 | Stone | Mississippi | 28131 | 85 | 2 |
316938 | 316938 | 2020-07-09 | Alcorn | Mississippi | 28003 | 85 | 2 |
272792 | 272792 | 2020-06-25 | Prentiss | Mississippi | 28117 | 85 | 3 |
272801 | 272801 | 2020-06-25 | Tallahatchie | Mississippi | 28135 | 85 | 1 |
266541 | 266541 | 2020-06-23 | Wilkinson | Mississippi | 28157 | 85 | 9 |
263415 | 263415 | 2020-06-22 | Wilkinson | Mississippi | 28157 | 85 | 9 |
260287 | 260287 | 2020-06-21 | Wilkinson | Mississippi | 28157 | 85 | 9 |
257161 | 257161 | 2020-06-20 | Wilkinson | Mississippi | 28157 | 85 | 9 |
254041 | 254041 | 2020-06-19 | Wilkinson | Mississippi | 28157 | 85 | 9 |
250926 | 250926 | 2020-06-18 | Wilkinson | Mississippi | 28157 | 85 | 9 |
247813 | 247813 | 2020-06-17 | Wilkinson | Mississippi | 28157 | 85 | 9 |
244700 | 244700 | 2020-06-16 | Wilkinson | Mississippi | 28157 | 85 | 9 |
241589 | 241589 | 2020-06-15 | Wilkinson | Mississippi | 28157 | 85 | 9 |
238480 | 238480 | 2020-06-14 | Wilkinson | Mississippi | 28157 | 85 | 9 |
235373 | 235373 | 2020-06-13 | Wilkinson | Mississippi | 28157 | 85 | 9 |
232267 | 232267 | 2020-06-12 | Wilkinson | Mississippi | 28157 | 85 | 9 |
229158 | 229158 | 2020-06-11 | Walthall | Mississippi | 28147 | 85 | 0 |
229163 | 229163 | 2020-06-11 | Wilkinson | Mississippi | 28157 | 85 | 9 |
226056 | 226056 | 2020-06-10 | Walthall | Mississippi | 28147 | 85 | 0 |
226061 | 226061 | 2020-06-10 | Wilkinson | Mississippi | 28157 | 85 | 9 |
222963 | 222963 | 2020-06-09 | Wilkinson | Mississippi | 28157 | 85 | 9 |
219822 | 219822 | 2020-06-08 | Jefferson Davis | Mississippi | 28065 | 85 | 3 |
219868 | 219868 | 2020-06-08 | Wilkinson | Mississippi | 28157 | 85 | 9 |
216746 | 216746 | 2020-06-07 | Montgomery | Mississippi | 28097 | 85 | 1 |
216776 | 216776 | 2020-06-07 | Wilkinson | Mississippi | 28157 | 85 | 9 |
213658 | 213658 | 2020-06-06 | Montgomery | Mississippi | 28097 | 85 | 1 |
213688 | 213688 | 2020-06-06 | Wilkinson | Mississippi | 28157 | 85 | 9 |
210604 | 210604 | 2020-06-05 | Wilkinson | Mississippi | 28157 | 85 | 9 |
207523 | 207523 | 2020-06-04 | Wilkinson | Mississippi | 28157 | 85 | 9 |
204410 | 204410 | 2020-06-03 | Marshall | Mississippi | 28093 | 85 | 3 |
204417 | 204417 | 2020-06-03 | Panola | Mississippi | 28107 | 85 | 3 |
204442 | 204442 | 2020-06-03 | Wilkinson | Mississippi | 28157 | 85 | 9 |
201335 | 201335 | 2020-06-02 | Montgomery | Mississippi | 28097 | 85 | 1 |
201353 | 201353 | 2020-06-02 | Sunflower | Mississippi | 28133 | 85 | 3 |
201359 | 201359 | 2020-06-02 | Union | Mississippi | 28145 | 85 | 7 |
201365 | 201365 | 2020-06-02 | Wilkinson | Mississippi | 28157 | 85 | 9 |
198262 | 198262 | 2020-06-01 | Montgomery | Mississippi | 28097 | 85 | 1 |
198280 | 198280 | 2020-06-01 | Sunflower | Mississippi | 28133 | 85 | 3 |
198292 | 198292 | 2020-06-01 | Wilkinson | Mississippi | 28157 | 85 | 9 |
195191 | 195191 | 2020-05-31 | Montgomery | Mississippi | 28097 | 85 | 1 |
195221 | 195221 | 2020-05-31 | Wilkinson | Mississippi | 28157 | 85 | 9 |
189039 | 189039 | 2020-05-29 | Itawamba | Mississippi | 28057 | 85 | 7 |
185975 | 185975 | 2020-05-28 | Grenada | Mississippi | 28043 | 85 | 3 |
186031 | 186031 | 2020-05-28 | Wilkinson | Mississippi | 28157 | 85 | 9 |
186033 | 186033 | 2020-05-28 | Yalobusha | Mississippi | 28161 | 85 | 5 |
182925 | 182925 | 2020-05-27 | Itawamba | Mississippi | 28057 | 85 | 7 |
182975 | 182975 | 2020-05-27 | Wilkinson | Mississippi | 28157 | 85 | 9 |
182977 | 182977 | 2020-05-27 | Yalobusha | Mississippi | 28161 | 85 | 5 |
179929 | 179929 | 2020-05-26 | Wilkinson | Mississippi | 28157 | 85 | 9 |
176835 | 176835 | 2020-05-25 | Itawamba | Mississippi | 28057 | 85 | 7 |
176870 | 176870 | 2020-05-25 | Simpson | Mississippi | 28127 | 85 | 0 |
173792 | 173792 | 2020-05-24 | Itawamba | Mississippi | 28057 | 85 | 7 |
173827 | 173827 | 2020-05-24 | Simpson | Mississippi | 28127 | 85 | 0 |
158607 | 158607 | 2020-05-19 | Coahoma | Mississippi | 28027 | 85 | 3 |
146585 | 146585 | 2020-05-15 | Lee | Mississippi | 28081 | 85 | 4 |
134641 | 134641 | 2020-05-11 | Washington | Mississippi | 28151 | 85 | 3 |
88189 | 88189 | 2020-04-25 | Lamar | Mississippi | 28073 | 85 | 2 |
74183 | 74183 | 2020-04-20 | Bolivar | Mississippi | 28011 | 85 | 6 |
68719 | 68719 | 2020-04-18 | Yazoo | Mississippi | 28163 | 85 | 1 |
44465 | 44465 | 2020-04-09 | Rankin | Mississippi | 28121 | 85 | 2 |
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);