ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Holmes" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387372 | 387372 | 2020-07-31 | Holmes | Mississippi | 28051 | 825 | 46 |
384154 | 384154 | 2020-07-30 | Holmes | Mississippi | 28051 | 809 | 45 |
380937 | 380937 | 2020-07-29 | Holmes | Mississippi | 28051 | 799 | 45 |
377720 | 377720 | 2020-07-28 | Holmes | Mississippi | 28051 | 791 | 45 |
374505 | 374505 | 2020-07-27 | Holmes | Mississippi | 28051 | 772 | 45 |
371293 | 371293 | 2020-07-26 | Holmes | Mississippi | 28051 | 760 | 45 |
368083 | 368083 | 2020-07-25 | Holmes | Mississippi | 28051 | 737 | 44 |
364875 | 364875 | 2020-07-24 | Holmes | Mississippi | 28051 | 714 | 44 |
361668 | 361668 | 2020-07-23 | Holmes | Mississippi | 28051 | 697 | 43 |
358463 | 358463 | 2020-07-22 | Holmes | Mississippi | 28051 | 687 | 43 |
355260 | 355260 | 2020-07-21 | Holmes | Mississippi | 28051 | 675 | 43 |
352058 | 352058 | 2020-07-20 | Holmes | Mississippi | 28051 | 640 | 43 |
348858 | 348858 | 2020-07-19 | Holmes | Mississippi | 28051 | 631 | 43 |
345657 | 345657 | 2020-07-18 | Holmes | Mississippi | 28051 | 631 | 43 |
342457 | 342457 | 2020-07-17 | Holmes | Mississippi | 28051 | 639 | 43 |
339261 | 339261 | 2020-07-16 | Holmes | Mississippi | 28051 | 633 | 42 |
336065 | 336065 | 2020-07-15 | Holmes | Mississippi | 28051 | 614 | 42 |
332872 | 332872 | 2020-07-14 | Holmes | Mississippi | 28051 | 608 | 42 |
329685 | 329685 | 2020-07-13 | Holmes | Mississippi | 28051 | 598 | 41 |
326499 | 326499 | 2020-07-12 | Holmes | Mississippi | 28051 | 595 | 41 |
323316 | 323316 | 2020-07-11 | Holmes | Mississippi | 28051 | 586 | 41 |
320137 | 320137 | 2020-07-10 | Holmes | Mississippi | 28051 | 579 | 41 |
316962 | 316962 | 2020-07-09 | Holmes | Mississippi | 28051 | 573 | 41 |
313788 | 313788 | 2020-07-08 | Holmes | Mississippi | 28051 | 570 | 41 |
310618 | 310618 | 2020-07-07 | Holmes | Mississippi | 28051 | 560 | 41 |
307450 | 307450 | 2020-07-06 | Holmes | Mississippi | 28051 | 557 | 41 |
304283 | 304283 | 2020-07-05 | Holmes | Mississippi | 28051 | 553 | 41 |
301119 | 301119 | 2020-07-04 | Holmes | Mississippi | 28051 | 551 | 41 |
297956 | 297956 | 2020-07-03 | Holmes | Mississippi | 28051 | 544 | 41 |
294798 | 294798 | 2020-07-02 | Holmes | Mississippi | 28051 | 536 | 41 |
291644 | 291644 | 2020-07-01 | Holmes | Mississippi | 28051 | 527 | 41 |
288493 | 288493 | 2020-06-30 | Holmes | Mississippi | 28051 | 520 | 40 |
285343 | 285343 | 2020-06-29 | Holmes | Mississippi | 28051 | 514 | 40 |
282198 | 282198 | 2020-06-28 | Holmes | Mississippi | 28051 | 507 | 39 |
279050 | 279050 | 2020-06-27 | Holmes | Mississippi | 28051 | 507 | 39 |
275902 | 275902 | 2020-06-26 | Holmes | Mississippi | 28051 | 506 | 39 |
272759 | 272759 | 2020-06-25 | Holmes | Mississippi | 28051 | 501 | 39 |
269622 | 269622 | 2020-06-24 | Holmes | Mississippi | 28051 | 496 | 39 |
266489 | 266489 | 2020-06-23 | Holmes | Mississippi | 28051 | 491 | 37 |
263363 | 263363 | 2020-06-22 | Holmes | Mississippi | 28051 | 489 | 37 |
260234 | 260234 | 2020-06-21 | Holmes | Mississippi | 28051 | 477 | 35 |
257108 | 257108 | 2020-06-20 | Holmes | Mississippi | 28051 | 477 | 35 |
253988 | 253988 | 2020-06-19 | Holmes | Mississippi | 28051 | 477 | 35 |
250873 | 250873 | 2020-06-18 | Holmes | Mississippi | 28051 | 477 | 35 |
247761 | 247761 | 2020-06-17 | Holmes | Mississippi | 28051 | 477 | 35 |
244648 | 244648 | 2020-06-16 | Holmes | Mississippi | 28051 | 474 | 34 |
241537 | 241537 | 2020-06-15 | Holmes | Mississippi | 28051 | 471 | 34 |
238428 | 238428 | 2020-06-14 | Holmes | Mississippi | 28051 | 468 | 34 |
235321 | 235321 | 2020-06-13 | Holmes | Mississippi | 28051 | 465 | 33 |
232215 | 232215 | 2020-06-12 | Holmes | Mississippi | 28051 | 463 | 32 |
229111 | 229111 | 2020-06-11 | Holmes | Mississippi | 28051 | 460 | 32 |
226009 | 226009 | 2020-06-10 | Holmes | Mississippi | 28051 | 460 | 32 |
222911 | 222911 | 2020-06-09 | Holmes | Mississippi | 28051 | 457 | 31 |
219816 | 219816 | 2020-06-08 | Holmes | Mississippi | 28051 | 461 | 31 |
216724 | 216724 | 2020-06-07 | Holmes | Mississippi | 28051 | 454 | 31 |
213636 | 213636 | 2020-06-06 | Holmes | Mississippi | 28051 | 444 | 31 |
210552 | 210552 | 2020-06-05 | Holmes | Mississippi | 28051 | 444 | 31 |
207471 | 207471 | 2020-06-04 | Holmes | Mississippi | 28051 | 443 | 30 |
204390 | 204390 | 2020-06-03 | Holmes | Mississippi | 28051 | 441 | 30 |
201313 | 201313 | 2020-06-02 | Holmes | Mississippi | 28051 | 439 | 28 |
198240 | 198240 | 2020-06-01 | Holmes | Mississippi | 28051 | 434 | 28 |
195169 | 195169 | 2020-05-31 | Holmes | Mississippi | 28051 | 429 | 28 |
192101 | 192101 | 2020-05-30 | Holmes | Mississippi | 28051 | 397 | 28 |
189037 | 189037 | 2020-05-29 | Holmes | Mississippi | 28051 | 389 | 24 |
185979 | 185979 | 2020-05-28 | Holmes | Mississippi | 28051 | 385 | 24 |
182923 | 182923 | 2020-05-27 | Holmes | Mississippi | 28051 | 373 | 24 |
179877 | 179877 | 2020-05-26 | Holmes | Mississippi | 28051 | 370 | 24 |
176833 | 176833 | 2020-05-25 | Holmes | Mississippi | 28051 | 369 | 23 |
173790 | 173790 | 2020-05-24 | Holmes | Mississippi | 28051 | 365 | 23 |
170748 | 170748 | 2020-05-23 | Holmes | Mississippi | 28051 | 359 | 23 |
167710 | 167710 | 2020-05-22 | Holmes | Mississippi | 28051 | 343 | 22 |
164674 | 164674 | 2020-05-21 | Holmes | Mississippi | 28051 | 333 | 21 |
161645 | 161645 | 2020-05-20 | Holmes | Mississippi | 28051 | 320 | 21 |
158619 | 158619 | 2020-05-19 | Holmes | Mississippi | 28051 | 310 | 20 |
155601 | 155601 | 2020-05-18 | Holmes | Mississippi | 28051 | 298 | 20 |
152587 | 152587 | 2020-05-17 | Holmes | Mississippi | 28051 | 293 | 20 |
149576 | 149576 | 2020-05-16 | Holmes | Mississippi | 28051 | 288 | 20 |
146571 | 146571 | 2020-05-15 | Holmes | Mississippi | 28051 | 278 | 19 |
143571 | 143571 | 2020-05-14 | Holmes | Mississippi | 28051 | 262 | 19 |
140576 | 140576 | 2020-05-13 | Holmes | Mississippi | 28051 | 231 | 19 |
137582 | 137582 | 2020-05-12 | Holmes | Mississippi | 28051 | 224 | 19 |
134592 | 134592 | 2020-05-11 | Holmes | Mississippi | 28051 | 223 | 19 |
131601 | 131601 | 2020-05-10 | Holmes | Mississippi | 28051 | 213 | 19 |
128611 | 128611 | 2020-05-09 | Holmes | Mississippi | 28051 | 206 | 18 |
125624 | 125624 | 2020-05-08 | Holmes | Mississippi | 28051 | 196 | 17 |
122642 | 122642 | 2020-05-07 | Holmes | Mississippi | 28051 | 190 | 16 |
119668 | 119668 | 2020-05-06 | Holmes | Mississippi | 28051 | 176 | 12 |
116708 | 116708 | 2020-05-05 | Holmes | Mississippi | 28051 | 168 | 10 |
113826 | 113826 | 2020-05-04 | Holmes | Mississippi | 28051 | 168 | 10 |
110947 | 110947 | 2020-05-03 | Holmes | Mississippi | 28051 | 161 | 9 |
108076 | 108076 | 2020-05-02 | Holmes | Mississippi | 28051 | 159 | 9 |
105211 | 105211 | 2020-05-01 | Holmes | Mississippi | 28051 | 153 | 9 |
102350 | 102350 | 2020-04-30 | Holmes | Mississippi | 28051 | 133 | 5 |
99498 | 99498 | 2020-04-29 | Holmes | Mississippi | 28051 | 129 | 5 |
96652 | 96652 | 2020-04-28 | Holmes | Mississippi | 28051 | 121 | 5 |
93816 | 93816 | 2020-04-27 | Holmes | Mississippi | 28051 | 114 | 5 |
90995 | 90995 | 2020-04-26 | Holmes | Mississippi | 28051 | 105 | 5 |
88179 | 88179 | 2020-04-25 | Holmes | Mississippi | 28051 | 100 | 5 |
85369 | 85369 | 2020-04-24 | Holmes | Mississippi | 28051 | 92 | 5 |
82565 | 82565 | 2020-04-23 | Holmes | Mississippi | 28051 | 83 | 5 |
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);