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 |
---|---|---|---|---|---|---|---|
535859 | 535859 | 2020-09-15 | Holmes | Mississippi | 28051 | 1075 | 58 |
532624 | 532624 | 2020-09-14 | Holmes | Mississippi | 28051 | 1075 | 57 |
529388 | 529388 | 2020-09-13 | Holmes | Mississippi | 28051 | 1075 | 56 |
526152 | 526152 | 2020-09-12 | Holmes | Mississippi | 28051 | 1074 | 56 |
522916 | 522916 | 2020-09-11 | Holmes | Mississippi | 28051 | 1073 | 56 |
519679 | 519679 | 2020-09-10 | Holmes | Mississippi | 28051 | 1070 | 56 |
516444 | 516444 | 2020-09-09 | Holmes | Mississippi | 28051 | 1070 | 55 |
513210 | 513210 | 2020-09-08 | Holmes | Mississippi | 28051 | 1065 | 55 |
509978 | 509978 | 2020-09-07 | Holmes | Mississippi | 28051 | 1064 | 55 |
506745 | 506745 | 2020-09-06 | Holmes | Mississippi | 28051 | 1062 | 55 |
503512 | 503512 | 2020-09-05 | Holmes | Mississippi | 28051 | 1058 | 54 |
500278 | 500278 | 2020-09-04 | Holmes | Mississippi | 28051 | 1056 | 54 |
497044 | 497044 | 2020-09-03 | Holmes | Mississippi | 28051 | 1052 | 54 |
493811 | 493811 | 2020-09-02 | Holmes | Mississippi | 28051 | 1047 | 54 |
490577 | 490577 | 2020-09-01 | Holmes | Mississippi | 28051 | 1045 | 54 |
487344 | 487344 | 2020-08-31 | Holmes | Mississippi | 28051 | 1041 | 54 |
484110 | 484110 | 2020-08-30 | Holmes | Mississippi | 28051 | 1039 | 54 |
480875 | 480875 | 2020-08-29 | Holmes | Mississippi | 28051 | 1039 | 54 |
477643 | 477643 | 2020-08-28 | Holmes | Mississippi | 28051 | 1032 | 54 |
474410 | 474410 | 2020-08-27 | Holmes | Mississippi | 28051 | 1027 | 54 |
471178 | 471178 | 2020-08-26 | Holmes | Mississippi | 28051 | 1038 | 52 |
467948 | 467948 | 2020-08-25 | Holmes | Mississippi | 28051 | 1019 | 52 |
464719 | 464719 | 2020-08-24 | Holmes | Mississippi | 28051 | 1013 | 50 |
461488 | 461488 | 2020-08-23 | Holmes | Mississippi | 28051 | 1009 | 50 |
458261 | 458261 | 2020-08-22 | Holmes | Mississippi | 28051 | 1003 | 50 |
455033 | 455033 | 2020-08-21 | Holmes | Mississippi | 28051 | 995 | 50 |
451805 | 451805 | 2020-08-20 | Holmes | Mississippi | 28051 | 983 | 50 |
448577 | 448577 | 2020-08-19 | Holmes | Mississippi | 28051 | 978 | 50 |
445351 | 445351 | 2020-08-18 | Holmes | Mississippi | 28051 | 964 | 50 |
442125 | 442125 | 2020-08-17 | Holmes | Mississippi | 28051 | 957 | 50 |
438898 | 438898 | 2020-08-16 | Holmes | Mississippi | 28051 | 951 | 50 |
435673 | 435673 | 2020-08-15 | Holmes | Mississippi | 28051 | 945 | 50 |
432447 | 432447 | 2020-08-14 | Holmes | Mississippi | 28051 | 938 | 50 |
429220 | 429220 | 2020-08-13 | Holmes | Mississippi | 28051 | 928 | 49 |
425996 | 425996 | 2020-08-12 | Holmes | Mississippi | 28051 | 923 | 49 |
422774 | 422774 | 2020-08-11 | Holmes | Mississippi | 28051 | 910 | 49 |
419552 | 419552 | 2020-08-10 | Holmes | Mississippi | 28051 | 900 | 49 |
416331 | 416331 | 2020-08-09 | Holmes | Mississippi | 28051 | 892 | 48 |
413111 | 413111 | 2020-08-08 | Holmes | Mississippi | 28051 | 890 | 48 |
409891 | 409891 | 2020-08-07 | Holmes | Mississippi | 28051 | 873 | 48 |
406671 | 406671 | 2020-08-06 | Holmes | Mississippi | 28051 | 863 | 48 |
403453 | 403453 | 2020-08-05 | Holmes | Mississippi | 28051 | 859 | 48 |
400236 | 400236 | 2020-08-04 | Holmes | Mississippi | 28051 | 851 | 48 |
397022 | 397022 | 2020-08-03 | Holmes | Mississippi | 28051 | 847 | 47 |
393806 | 393806 | 2020-08-02 | Holmes | Mississippi | 28051 | 843 | 47 |
390589 | 390589 | 2020-08-01 | Holmes | Mississippi | 28051 | 835 | 46 |
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 |
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);