ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Winston" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387426 | 387426 | 2020-07-31 | Winston | Mississippi | 28159 | 560 | 14 |
384208 | 384208 | 2020-07-30 | Winston | Mississippi | 28159 | 544 | 14 |
380992 | 380992 | 2020-07-29 | Winston | Mississippi | 28159 | 527 | 14 |
377775 | 377775 | 2020-07-28 | Winston | Mississippi | 28159 | 505 | 14 |
374560 | 374560 | 2020-07-27 | Winston | Mississippi | 28159 | 483 | 14 |
371348 | 371348 | 2020-07-26 | Winston | Mississippi | 28159 | 479 | 14 |
368137 | 368137 | 2020-07-25 | Winston | Mississippi | 28159 | 475 | 14 |
364929 | 364929 | 2020-07-24 | Winston | Mississippi | 28159 | 471 | 14 |
361722 | 361722 | 2020-07-23 | Winston | Mississippi | 28159 | 461 | 14 |
358517 | 358517 | 2020-07-22 | Winston | Mississippi | 28159 | 458 | 14 |
355314 | 355314 | 2020-07-21 | Winston | Mississippi | 28159 | 411 | 13 |
352112 | 352112 | 2020-07-20 | Winston | Mississippi | 28159 | 348 | 13 |
348912 | 348912 | 2020-07-19 | Winston | Mississippi | 28159 | 348 | 13 |
345711 | 345711 | 2020-07-18 | Winston | Mississippi | 28159 | 340 | 13 |
342511 | 342511 | 2020-07-17 | Winston | Mississippi | 28159 | 336 | 13 |
339315 | 339315 | 2020-07-16 | Winston | Mississippi | 28159 | 323 | 13 |
336119 | 336119 | 2020-07-15 | Winston | Mississippi | 28159 | 314 | 13 |
332926 | 332926 | 2020-07-14 | Winston | Mississippi | 28159 | 305 | 13 |
329739 | 329739 | 2020-07-13 | Winston | Mississippi | 28159 | 302 | 11 |
326553 | 326553 | 2020-07-12 | Winston | Mississippi | 28159 | 301 | 11 |
323370 | 323370 | 2020-07-11 | Winston | Mississippi | 28159 | 295 | 11 |
320191 | 320191 | 2020-07-10 | Winston | Mississippi | 28159 | 296 | 11 |
317016 | 317016 | 2020-07-09 | Winston | Mississippi | 28159 | 287 | 11 |
313842 | 313842 | 2020-07-08 | Winston | Mississippi | 28159 | 282 | 10 |
310672 | 310672 | 2020-07-07 | Winston | Mississippi | 28159 | 280 | 8 |
307504 | 307504 | 2020-07-06 | Winston | Mississippi | 28159 | 266 | 6 |
304337 | 304337 | 2020-07-05 | Winston | Mississippi | 28159 | 261 | 6 |
301173 | 301173 | 2020-07-04 | Winston | Mississippi | 28159 | 259 | 6 |
298010 | 298010 | 2020-07-03 | Winston | Mississippi | 28159 | 254 | 6 |
294852 | 294852 | 2020-07-02 | Winston | Mississippi | 28159 | 244 | 6 |
291698 | 291698 | 2020-07-01 | Winston | Mississippi | 28159 | 243 | 5 |
288547 | 288547 | 2020-06-30 | Winston | Mississippi | 28159 | 240 | 5 |
285397 | 285397 | 2020-06-29 | Winston | Mississippi | 28159 | 230 | 5 |
282252 | 282252 | 2020-06-28 | Winston | Mississippi | 28159 | 230 | 4 |
279104 | 279104 | 2020-06-27 | Winston | Mississippi | 28159 | 228 | 4 |
275956 | 275956 | 2020-06-26 | Winston | Mississippi | 28159 | 223 | 4 |
272813 | 272813 | 2020-06-25 | Winston | Mississippi | 28159 | 217 | 4 |
269675 | 269675 | 2020-06-24 | Winston | Mississippi | 28159 | 194 | 4 |
266542 | 266542 | 2020-06-23 | Winston | Mississippi | 28159 | 193 | 3 |
263416 | 263416 | 2020-06-22 | Winston | Mississippi | 28159 | 178 | 2 |
260288 | 260288 | 2020-06-21 | Winston | Mississippi | 28159 | 158 | 2 |
257162 | 257162 | 2020-06-20 | Winston | Mississippi | 28159 | 158 | 2 |
254042 | 254042 | 2020-06-19 | Winston | Mississippi | 28159 | 158 | 2 |
250927 | 250927 | 2020-06-18 | Winston | Mississippi | 28159 | 158 | 2 |
247814 | 247814 | 2020-06-17 | Winston | Mississippi | 28159 | 158 | 2 |
244701 | 244701 | 2020-06-16 | Winston | Mississippi | 28159 | 155 | 2 |
241590 | 241590 | 2020-06-15 | Winston | Mississippi | 28159 | 150 | 2 |
238481 | 238481 | 2020-06-14 | Winston | Mississippi | 28159 | 149 | 2 |
235374 | 235374 | 2020-06-13 | Winston | Mississippi | 28159 | 148 | 2 |
232268 | 232268 | 2020-06-12 | Winston | Mississippi | 28159 | 143 | 2 |
229164 | 229164 | 2020-06-11 | Winston | Mississippi | 28159 | 139 | 2 |
226062 | 226062 | 2020-06-10 | Winston | Mississippi | 28159 | 139 | 2 |
222964 | 222964 | 2020-06-09 | Winston | Mississippi | 28159 | 136 | 1 |
219869 | 219869 | 2020-06-08 | Winston | Mississippi | 28159 | 136 | 1 |
216777 | 216777 | 2020-06-07 | Winston | Mississippi | 28159 | 128 | 1 |
213689 | 213689 | 2020-06-06 | Winston | Mississippi | 28159 | 125 | 1 |
210605 | 210605 | 2020-06-05 | Winston | Mississippi | 28159 | 124 | 1 |
207524 | 207524 | 2020-06-04 | Winston | Mississippi | 28159 | 124 | 1 |
204443 | 204443 | 2020-06-03 | Winston | Mississippi | 28159 | 122 | 1 |
201366 | 201366 | 2020-06-02 | Winston | Mississippi | 28159 | 121 | 1 |
198293 | 198293 | 2020-06-01 | Winston | Mississippi | 28159 | 120 | 1 |
195222 | 195222 | 2020-05-31 | Winston | Mississippi | 28159 | 117 | 1 |
192154 | 192154 | 2020-05-30 | Winston | Mississippi | 28159 | 112 | 1 |
189090 | 189090 | 2020-05-29 | Winston | Mississippi | 28159 | 109 | 1 |
186032 | 186032 | 2020-05-28 | Winston | Mississippi | 28159 | 105 | 1 |
182976 | 182976 | 2020-05-27 | Winston | Mississippi | 28159 | 105 | 1 |
179930 | 179930 | 2020-05-26 | Winston | Mississippi | 28159 | 102 | 1 |
176886 | 176886 | 2020-05-25 | Winston | Mississippi | 28159 | 98 | 1 |
173843 | 173843 | 2020-05-24 | Winston | Mississippi | 28159 | 98 | 1 |
170801 | 170801 | 2020-05-23 | Winston | Mississippi | 28159 | 98 | 1 |
167763 | 167763 | 2020-05-22 | Winston | Mississippi | 28159 | 92 | 0 |
164727 | 164727 | 2020-05-21 | Winston | Mississippi | 28159 | 92 | 0 |
161698 | 161698 | 2020-05-20 | Winston | Mississippi | 28159 | 86 | 0 |
158672 | 158672 | 2020-05-19 | Winston | Mississippi | 28159 | 86 | 0 |
155654 | 155654 | 2020-05-18 | Winston | Mississippi | 28159 | 83 | 0 |
152640 | 152640 | 2020-05-17 | Winston | Mississippi | 28159 | 81 | 0 |
149629 | 149629 | 2020-05-16 | Winston | Mississippi | 28159 | 75 | 0 |
146624 | 146624 | 2020-05-15 | Winston | Mississippi | 28159 | 73 | 0 |
143624 | 143624 | 2020-05-14 | Winston | Mississippi | 28159 | 70 | 0 |
140629 | 140629 | 2020-05-13 | Winston | Mississippi | 28159 | 67 | 0 |
137635 | 137635 | 2020-05-12 | Winston | Mississippi | 28159 | 67 | 0 |
134645 | 134645 | 2020-05-11 | Winston | Mississippi | 28159 | 66 | 0 |
131654 | 131654 | 2020-05-10 | Winston | Mississippi | 28159 | 63 | 0 |
128664 | 128664 | 2020-05-09 | Winston | Mississippi | 28159 | 61 | 0 |
125677 | 125677 | 2020-05-08 | Winston | Mississippi | 28159 | 61 | 0 |
122695 | 122695 | 2020-05-07 | Winston | Mississippi | 28159 | 57 | 0 |
119721 | 119721 | 2020-05-06 | Winston | Mississippi | 28159 | 53 | 0 |
116761 | 116761 | 2020-05-05 | Winston | Mississippi | 28159 | 52 | 0 |
113879 | 113879 | 2020-05-04 | Winston | Mississippi | 28159 | 49 | 0 |
111000 | 111000 | 2020-05-03 | Winston | Mississippi | 28159 | 47 | 0 |
108129 | 108129 | 2020-05-02 | Winston | Mississippi | 28159 | 47 | 0 |
105264 | 105264 | 2020-05-01 | Winston | Mississippi | 28159 | 44 | 0 |
102403 | 102403 | 2020-04-30 | Winston | Mississippi | 28159 | 42 | 0 |
99551 | 99551 | 2020-04-29 | Winston | Mississippi | 28159 | 43 | 0 |
96705 | 96705 | 2020-04-28 | Winston | Mississippi | 28159 | 41 | 0 |
93869 | 93869 | 2020-04-27 | Winston | Mississippi | 28159 | 40 | 0 |
91048 | 91048 | 2020-04-26 | Winston | Mississippi | 28159 | 38 | 0 |
88232 | 88232 | 2020-04-25 | Winston | Mississippi | 28159 | 38 | 0 |
85422 | 85422 | 2020-04-24 | Winston | Mississippi | 28159 | 38 | 0 |
82618 | 82618 | 2020-04-23 | Winston | Mississippi | 28159 | 37 | 0 |
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);