ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
639 rows where county = "Harding" and state = "South Dakota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
430260 | 430260 | 2020-08-13 | Harding | South Dakota | 46063 | 2 | 0 |
433485 | 433485 | 2020-08-14 | Harding | South Dakota | 46063 | 2 | 0 |
436712 | 436712 | 2020-08-15 | Harding | South Dakota | 46063 | 2 | 0 |
439937 | 439937 | 2020-08-16 | Harding | South Dakota | 46063 | 2 | 0 |
443164 | 443164 | 2020-08-17 | Harding | South Dakota | 46063 | 2 | 0 |
446390 | 446390 | 2020-08-18 | Harding | South Dakota | 46063 | 2 | 0 |
449618 | 449618 | 2020-08-19 | Harding | South Dakota | 46063 | 2 | 0 |
452846 | 452846 | 2020-08-20 | Harding | South Dakota | 46063 | 2 | 0 |
456074 | 456074 | 2020-08-21 | Harding | South Dakota | 46063 | 2 | 0 |
459302 | 459302 | 2020-08-22 | Harding | South Dakota | 46063 | 2 | 0 |
462530 | 462530 | 2020-08-23 | Harding | South Dakota | 46063 | 2 | 0 |
465759 | 465759 | 2020-08-24 | Harding | South Dakota | 46063 | 2 | 0 |
468987 | 468987 | 2020-08-25 | Harding | South Dakota | 46063 | 2 | 0 |
472219 | 472219 | 2020-08-26 | Harding | South Dakota | 46063 | 2 | 0 |
475453 | 475453 | 2020-08-27 | Harding | South Dakota | 46063 | 2 | 0 |
478686 | 478686 | 2020-08-28 | Harding | South Dakota | 46063 | 2 | 0 |
481920 | 481920 | 2020-08-29 | Harding | South Dakota | 46063 | 2 | 0 |
485155 | 485155 | 2020-08-30 | Harding | South Dakota | 46063 | 2 | 0 |
488388 | 488388 | 2020-08-31 | Harding | South Dakota | 46063 | 2 | 0 |
491621 | 491621 | 2020-09-01 | Harding | South Dakota | 46063 | 2 | 0 |
494855 | 494855 | 2020-09-02 | Harding | South Dakota | 46063 | 2 | 0 |
498088 | 498088 | 2020-09-03 | Harding | South Dakota | 46063 | 2 | 0 |
501322 | 501322 | 2020-09-04 | Harding | South Dakota | 46063 | 2 | 0 |
504556 | 504556 | 2020-09-05 | Harding | South Dakota | 46063 | 2 | 0 |
507788 | 507788 | 2020-09-06 | Harding | South Dakota | 46063 | 2 | 0 |
511021 | 511021 | 2020-09-07 | Harding | South Dakota | 46063 | 2 | 0 |
514254 | 514254 | 2020-09-08 | Harding | South Dakota | 46063 | 2 | 0 |
517489 | 517489 | 2020-09-09 | Harding | South Dakota | 46063 | 3 | 0 |
520725 | 520725 | 2020-09-10 | Harding | South Dakota | 46063 | 3 | 0 |
523961 | 523961 | 2020-09-11 | Harding | South Dakota | 46063 | 3 | 0 |
527197 | 527197 | 2020-09-12 | Harding | South Dakota | 46063 | 3 | 0 |
530434 | 530434 | 2020-09-13 | Harding | South Dakota | 46063 | 3 | 0 |
533669 | 533669 | 2020-09-14 | Harding | South Dakota | 46063 | 3 | 0 |
536905 | 536905 | 2020-09-15 | Harding | South Dakota | 46063 | 3 | 0 |
540142 | 540142 | 2020-09-16 | Harding | South Dakota | 46063 | 3 | 0 |
543378 | 543378 | 2020-09-17 | Harding | South Dakota | 46063 | 3 | 0 |
546615 | 546615 | 2020-09-18 | Harding | South Dakota | 46063 | 3 | 0 |
549854 | 549854 | 2020-09-19 | Harding | South Dakota | 46063 | 3 | 0 |
553093 | 553093 | 2020-09-20 | Harding | South Dakota | 46063 | 3 | 0 |
556330 | 556330 | 2020-09-21 | Harding | South Dakota | 46063 | 3 | 0 |
559567 | 559567 | 2020-09-22 | Harding | South Dakota | 46063 | 3 | 0 |
562804 | 562804 | 2020-09-23 | Harding | South Dakota | 46063 | 5 | 0 |
566045 | 566045 | 2020-09-24 | Harding | South Dakota | 46063 | 5 | 0 |
569286 | 569286 | 2020-09-25 | Harding | South Dakota | 46063 | 5 | 0 |
572528 | 572528 | 2020-09-26 | Harding | South Dakota | 46063 | 5 | 0 |
575772 | 575772 | 2020-09-27 | Harding | South Dakota | 46063 | 4 | 0 |
579013 | 579013 | 2020-09-28 | Harding | South Dakota | 46063 | 4 | 0 |
582253 | 582253 | 2020-09-29 | Harding | South Dakota | 46063 | 4 | 0 |
585493 | 585493 | 2020-09-30 | Harding | South Dakota | 46063 | 4 | 0 |
588733 | 588733 | 2020-10-01 | Harding | South Dakota | 46063 | 4 | 0 |
591974 | 591974 | 2020-10-02 | Harding | South Dakota | 46063 | 4 | 0 |
595215 | 595215 | 2020-10-03 | Harding | South Dakota | 46063 | 4 | 0 |
598458 | 598458 | 2020-10-04 | Harding | South Dakota | 46063 | 5 | 0 |
601701 | 601701 | 2020-10-05 | Harding | South Dakota | 46063 | 5 | 0 |
604943 | 604943 | 2020-10-06 | Harding | South Dakota | 46063 | 5 | 0 |
608186 | 608186 | 2020-10-07 | Harding | South Dakota | 46063 | 5 | 0 |
611428 | 611428 | 2020-10-08 | Harding | South Dakota | 46063 | 6 | 0 |
614669 | 614669 | 2020-10-09 | Harding | South Dakota | 46063 | 6 | 0 |
617911 | 617911 | 2020-10-10 | Harding | South Dakota | 46063 | 7 | 0 |
621154 | 621154 | 2020-10-11 | Harding | South Dakota | 46063 | 8 | 0 |
624397 | 624397 | 2020-10-12 | Harding | South Dakota | 46063 | 9 | 0 |
627639 | 627639 | 2020-10-13 | Harding | South Dakota | 46063 | 9 | 0 |
630883 | 630883 | 2020-10-14 | Harding | South Dakota | 46063 | 10 | 0 |
634128 | 634128 | 2020-10-15 | Harding | South Dakota | 46063 | 16 | 0 |
637374 | 637374 | 2020-10-16 | Harding | South Dakota | 46063 | 18 | 0 |
640620 | 640620 | 2020-10-17 | Harding | South Dakota | 46063 | 19 | 0 |
643868 | 643868 | 2020-10-18 | Harding | South Dakota | 46063 | 32 | 0 |
647114 | 647114 | 2020-10-19 | Harding | South Dakota | 46063 | 33 | 0 |
650358 | 650358 | 2020-10-20 | Harding | South Dakota | 46063 | 34 | 0 |
653603 | 653603 | 2020-10-21 | Harding | South Dakota | 46063 | 38 | 0 |
656848 | 656848 | 2020-10-22 | Harding | South Dakota | 46063 | 39 | 0 |
660092 | 660092 | 2020-10-23 | Harding | South Dakota | 46063 | 42 | 0 |
663336 | 663336 | 2020-10-24 | Harding | South Dakota | 46063 | 44 | 0 |
666581 | 666581 | 2020-10-25 | Harding | South Dakota | 46063 | 46 | 0 |
669825 | 669825 | 2020-10-26 | Harding | South Dakota | 46063 | 46 | 0 |
673067 | 673067 | 2020-10-27 | Harding | South Dakota | 46063 | 46 | 0 |
676310 | 676310 | 2020-10-28 | Harding | South Dakota | 46063 | 52 | 0 |
679553 | 679553 | 2020-10-29 | Harding | South Dakota | 46063 | 56 | 0 |
682796 | 682796 | 2020-10-30 | Harding | South Dakota | 46063 | 56 | 0 |
686039 | 686039 | 2020-10-31 | Harding | South Dakota | 46063 | 57 | 0 |
689284 | 689284 | 2020-11-01 | Harding | South Dakota | 46063 | 58 | 0 |
692528 | 692528 | 2020-11-02 | Harding | South Dakota | 46063 | 60 | 0 |
695770 | 695770 | 2020-11-03 | Harding | South Dakota | 46063 | 62 | 0 |
699013 | 699013 | 2020-11-04 | Harding | South Dakota | 46063 | 63 | 0 |
702257 | 702257 | 2020-11-05 | Harding | South Dakota | 46063 | 63 | 0 |
705500 | 705500 | 2020-11-06 | Harding | South Dakota | 46063 | 63 | 0 |
708743 | 708743 | 2020-11-07 | Harding | South Dakota | 46063 | 63 | 0 |
711987 | 711987 | 2020-11-08 | Harding | South Dakota | 46063 | 62 | 0 |
715231 | 715231 | 2020-11-09 | Harding | South Dakota | 46063 | 61 | 0 |
718474 | 718474 | 2020-11-10 | Harding | South Dakota | 46063 | 61 | 0 |
721717 | 721717 | 2020-11-11 | Harding | South Dakota | 46063 | 61 | 0 |
724960 | 724960 | 2020-11-12 | Harding | South Dakota | 46063 | 63 | 0 |
728204 | 728204 | 2020-11-13 | Harding | South Dakota | 46063 | 64 | 0 |
731448 | 731448 | 2020-11-14 | Harding | South Dakota | 46063 | 65 | 0 |
734694 | 734694 | 2020-11-15 | Harding | South Dakota | 46063 | 65 | 0 |
737938 | 737938 | 2020-11-16 | Harding | South Dakota | 46063 | 65 | 0 |
741184 | 741184 | 2020-11-17 | Harding | South Dakota | 46063 | 64 | 0 |
744431 | 744431 | 2020-11-18 | Harding | South Dakota | 46063 | 64 | 0 |
747677 | 747677 | 2020-11-19 | Harding | South Dakota | 46063 | 64 | 0 |
750923 | 750923 | 2020-11-20 | Harding | South Dakota | 46063 | 64 | 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);