ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Cherokee" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936076 | 936076 | 2021-01-16 | Cherokee | Texas | 48073 | 3491 | 88 |
932831 | 932831 | 2021-01-15 | Cherokee | Texas | 48073 | 3469 | 86 |
929586 | 929586 | 2021-01-14 | Cherokee | Texas | 48073 | 3440 | 86 |
926341 | 926341 | 2021-01-13 | Cherokee | Texas | 48073 | 3413 | 85 |
923095 | 923095 | 2021-01-12 | Cherokee | Texas | 48073 | 3401 | 85 |
919850 | 919850 | 2021-01-11 | Cherokee | Texas | 48073 | 3348 | 84 |
916605 | 916605 | 2021-01-10 | Cherokee | Texas | 48073 | 3348 | 84 |
913360 | 913360 | 2021-01-09 | Cherokee | Texas | 48073 | 3348 | 84 |
910115 | 910115 | 2021-01-08 | Cherokee | Texas | 48073 | 3314 | 83 |
906870 | 906870 | 2021-01-07 | Cherokee | Texas | 48073 | 3258 | 82 |
903624 | 903624 | 2021-01-06 | Cherokee | Texas | 48073 | 3197 | 80 |
900379 | 900379 | 2021-01-05 | Cherokee | Texas | 48073 | 3177 | 78 |
897134 | 897134 | 2021-01-04 | Cherokee | Texas | 48073 | 3101 | 77 |
893888 | 893888 | 2021-01-03 | Cherokee | Texas | 48073 | 3101 | 77 |
890642 | 890642 | 2021-01-02 | Cherokee | Texas | 48073 | 3101 | 77 |
887395 | 887395 | 2021-01-01 | Cherokee | Texas | 48073 | 3101 | 77 |
884150 | 884150 | 2020-12-31 | Cherokee | Texas | 48073 | 3026 | 72 |
880905 | 880905 | 2020-12-30 | Cherokee | Texas | 48073 | 3026 | 71 |
877660 | 877660 | 2020-12-29 | Cherokee | Texas | 48073 | 2998 | 71 |
874415 | 874415 | 2020-12-28 | Cherokee | Texas | 48073 | 2943 | 71 |
871170 | 871170 | 2020-12-27 | Cherokee | Texas | 48073 | 2943 | 71 |
867925 | 867925 | 2020-12-26 | Cherokee | Texas | 48073 | 2943 | 71 |
864680 | 864680 | 2020-12-25 | Cherokee | Texas | 48073 | 2943 | 71 |
861435 | 861435 | 2020-12-24 | Cherokee | Texas | 48073 | 2943 | 70 |
858190 | 858190 | 2020-12-23 | Cherokee | Texas | 48073 | 2933 | 70 |
854945 | 854945 | 2020-12-22 | Cherokee | Texas | 48073 | 2906 | 69 |
851700 | 851700 | 2020-12-21 | Cherokee | Texas | 48073 | 2880 | 69 |
848455 | 848455 | 2020-12-20 | Cherokee | Texas | 48073 | 2880 | 69 |
845210 | 845210 | 2020-12-19 | Cherokee | Texas | 48073 | 2880 | 69 |
841964 | 841964 | 2020-12-18 | Cherokee | Texas | 48073 | 2833 | 69 |
838719 | 838719 | 2020-12-17 | Cherokee | Texas | 48073 | 2807 | 69 |
835473 | 835473 | 2020-12-16 | Cherokee | Texas | 48073 | 2791 | 69 |
832227 | 832227 | 2020-12-15 | Cherokee | Texas | 48073 | 2756 | 68 |
828980 | 828980 | 2020-12-14 | Cherokee | Texas | 48073 | 2720 | 68 |
825734 | 825734 | 2020-12-13 | Cherokee | Texas | 48073 | 2720 | 68 |
822487 | 822487 | 2020-12-12 | Cherokee | Texas | 48073 | 2720 | 68 |
819241 | 819241 | 2020-12-11 | Cherokee | Texas | 48073 | 2720 | 68 |
815995 | 815995 | 2020-12-10 | Cherokee | Texas | 48073 | 1792 | 67 |
812749 | 812749 | 2020-12-09 | Cherokee | Texas | 48073 | 1786 | 66 |
809505 | 809505 | 2020-12-08 | Cherokee | Texas | 48073 | 1779 | 63 |
806260 | 806260 | 2020-12-07 | Cherokee | Texas | 48073 | 1768 | 62 |
803015 | 803015 | 2020-12-06 | Cherokee | Texas | 48073 | 1768 | 62 |
799770 | 799770 | 2020-12-05 | Cherokee | Texas | 48073 | 1768 | 62 |
796525 | 796525 | 2020-12-04 | Cherokee | Texas | 48073 | 1766 | 61 |
793280 | 793280 | 2020-12-03 | Cherokee | Texas | 48073 | 1763 | 59 |
790035 | 790035 | 2020-12-02 | Cherokee | Texas | 48073 | 1757 | 59 |
786790 | 786790 | 2020-12-01 | Cherokee | Texas | 48073 | 1756 | 58 |
783546 | 783546 | 2020-11-30 | Cherokee | Texas | 48073 | 1752 | 55 |
780301 | 780301 | 2020-11-29 | Cherokee | Texas | 48073 | 1752 | 55 |
777055 | 777055 | 2020-11-28 | Cherokee | Texas | 48073 | 1752 | 54 |
773810 | 773810 | 2020-11-27 | Cherokee | Texas | 48073 | 1752 | 52 |
770565 | 770565 | 2020-11-26 | Cherokee | Texas | 48073 | 1750 | 52 |
767319 | 767319 | 2020-11-25 | Cherokee | Texas | 48073 | 1750 | 52 |
764074 | 764074 | 2020-11-24 | Cherokee | Texas | 48073 | 1744 | 52 |
760829 | 760829 | 2020-11-23 | Cherokee | Texas | 48073 | 1726 | 51 |
757584 | 757584 | 2020-11-22 | Cherokee | Texas | 48073 | 1726 | 51 |
754337 | 754337 | 2020-11-21 | Cherokee | Texas | 48073 | 1726 | 49 |
751091 | 751091 | 2020-11-20 | Cherokee | Texas | 48073 | 1717 | 49 |
747845 | 747845 | 2020-11-19 | Cherokee | Texas | 48073 | 1690 | 47 |
744599 | 744599 | 2020-11-18 | Cherokee | Texas | 48073 | 1690 | 47 |
741352 | 741352 | 2020-11-17 | Cherokee | Texas | 48073 | 1690 | 47 |
738106 | 738106 | 2020-11-16 | Cherokee | Texas | 48073 | 1690 | 46 |
734862 | 734862 | 2020-11-15 | Cherokee | Texas | 48073 | 1690 | 46 |
731616 | 731616 | 2020-11-14 | Cherokee | Texas | 48073 | 1690 | 46 |
728371 | 728371 | 2020-11-13 | Cherokee | Texas | 48073 | 1690 | 45 |
725128 | 725128 | 2020-11-12 | Cherokee | Texas | 48073 | 1690 | 45 |
721885 | 721885 | 2020-11-11 | Cherokee | Texas | 48073 | 1689 | 45 |
718642 | 718642 | 2020-11-10 | Cherokee | Texas | 48073 | 1687 | 45 |
715399 | 715399 | 2020-11-09 | Cherokee | Texas | 48073 | 1670 | 44 |
712155 | 712155 | 2020-11-08 | Cherokee | Texas | 48073 | 1670 | 44 |
708911 | 708911 | 2020-11-07 | Cherokee | Texas | 48073 | 1670 | 42 |
705667 | 705667 | 2020-11-06 | Cherokee | Texas | 48073 | 1670 | 42 |
702424 | 702424 | 2020-11-05 | Cherokee | Texas | 48073 | 1668 | 42 |
699181 | 699181 | 2020-11-04 | Cherokee | Texas | 48073 | 1666 | 42 |
695937 | 695937 | 2020-11-03 | Cherokee | Texas | 48073 | 1660 | 38 |
692695 | 692695 | 2020-11-02 | Cherokee | Texas | 48073 | 1657 | 38 |
689451 | 689451 | 2020-11-01 | Cherokee | Texas | 48073 | 1657 | 38 |
686206 | 686206 | 2020-10-31 | Cherokee | Texas | 48073 | 1657 | 38 |
682963 | 682963 | 2020-10-30 | Cherokee | Texas | 48073 | 1647 | 38 |
679720 | 679720 | 2020-10-29 | Cherokee | Texas | 48073 | 1643 | 38 |
676477 | 676477 | 2020-10-28 | Cherokee | Texas | 48073 | 1642 | 37 |
673234 | 673234 | 2020-10-27 | Cherokee | Texas | 48073 | 1640 | 37 |
669992 | 669992 | 2020-10-26 | Cherokee | Texas | 48073 | 1633 | 36 |
666749 | 666749 | 2020-10-25 | Cherokee | Texas | 48073 | 1626 | 36 |
663504 | 663504 | 2020-10-24 | Cherokee | Texas | 48073 | 1626 | 34 |
660260 | 660260 | 2020-10-23 | Cherokee | Texas | 48073 | 1618 | 32 |
657016 | 657016 | 2020-10-22 | Cherokee | Texas | 48073 | 1616 | 32 |
653771 | 653771 | 2020-10-21 | Cherokee | Texas | 48073 | 1616 | 32 |
650526 | 650526 | 2020-10-20 | Cherokee | Texas | 48073 | 1615 | 32 |
647282 | 647282 | 2020-10-19 | Cherokee | Texas | 48073 | 1611 | 31 |
644036 | 644036 | 2020-10-18 | Cherokee | Texas | 48073 | 1611 | 31 |
640788 | 640788 | 2020-10-17 | Cherokee | Texas | 48073 | 1611 | 31 |
637541 | 637541 | 2020-10-16 | Cherokee | Texas | 48073 | 1606 | 31 |
634296 | 634296 | 2020-10-15 | Cherokee | Texas | 48073 | 1601 | 31 |
631051 | 631051 | 2020-10-14 | Cherokee | Texas | 48073 | 1595 | 31 |
627807 | 627807 | 2020-10-13 | Cherokee | Texas | 48073 | 1591 | 31 |
624565 | 624565 | 2020-10-12 | Cherokee | Texas | 48073 | 1581 | 30 |
621322 | 621322 | 2020-10-11 | Cherokee | Texas | 48073 | 1581 | 30 |
618079 | 618079 | 2020-10-10 | Cherokee | Texas | 48073 | 1581 | 30 |
614837 | 614837 | 2020-10-09 | Cherokee | Texas | 48073 | 1581 | 30 |
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);