ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Anderson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923059 | 923059 | 2021-01-12 | Anderson | Texas | 48001 | 5421 | 73 |
919814 | 919814 | 2021-01-11 | Anderson | Texas | 48001 | 5484 | 71 |
916569 | 916569 | 2021-01-10 | Anderson | Texas | 48001 | 5484 | 71 |
913324 | 913324 | 2021-01-09 | Anderson | Texas | 48001 | 5461 | 71 |
910079 | 910079 | 2021-01-08 | Anderson | Texas | 48001 | 5419 | 70 |
906834 | 906834 | 2021-01-07 | Anderson | Texas | 48001 | 5419 | 68 |
903588 | 903588 | 2021-01-06 | Anderson | Texas | 48001 | 5399 | 65 |
900343 | 900343 | 2021-01-05 | Anderson | Texas | 48001 | 5277 | 65 |
897098 | 897098 | 2021-01-04 | Anderson | Texas | 48001 | 4814 | 65 |
893852 | 893852 | 2021-01-03 | Anderson | Texas | 48001 | 4814 | 65 |
890606 | 890606 | 2021-01-02 | Anderson | Texas | 48001 | 4814 | 65 |
887359 | 887359 | 2021-01-01 | Anderson | Texas | 48001 | 4814 | 65 |
884114 | 884114 | 2020-12-31 | Anderson | Texas | 48001 | 4538 | 63 |
880869 | 880869 | 2020-12-30 | Anderson | Texas | 48001 | 4510 | 63 |
877624 | 877624 | 2020-12-29 | Anderson | Texas | 48001 | 4505 | 63 |
874379 | 874379 | 2020-12-28 | Anderson | Texas | 48001 | 4270 | 61 |
871134 | 871134 | 2020-12-27 | Anderson | Texas | 48001 | 4270 | 61 |
867889 | 867889 | 2020-12-26 | Anderson | Texas | 48001 | 4270 | 57 |
864644 | 864644 | 2020-12-25 | Anderson | Texas | 48001 | 4270 | 57 |
861399 | 861399 | 2020-12-24 | Anderson | Texas | 48001 | 4276 | 57 |
858154 | 858154 | 2020-12-23 | Anderson | Texas | 48001 | 4236 | 57 |
854909 | 854909 | 2020-12-22 | Anderson | Texas | 48001 | 4219 | 57 |
851664 | 851664 | 2020-12-21 | Anderson | Texas | 48001 | 4174 | 57 |
848419 | 848419 | 2020-12-20 | Anderson | Texas | 48001 | 4174 | 57 |
845174 | 845174 | 2020-12-19 | Anderson | Texas | 48001 | 4174 | 56 |
841928 | 841928 | 2020-12-18 | Anderson | Texas | 48001 | 4149 | 56 |
838683 | 838683 | 2020-12-17 | Anderson | Texas | 48001 | 4134 | 56 |
835437 | 835437 | 2020-12-16 | Anderson | Texas | 48001 | 4030 | 55 |
832191 | 832191 | 2020-12-15 | Anderson | Texas | 48001 | 4003 | 54 |
828944 | 828944 | 2020-12-14 | Anderson | Texas | 48001 | 3973 | 54 |
825698 | 825698 | 2020-12-13 | Anderson | Texas | 48001 | 3973 | 54 |
822451 | 822451 | 2020-12-12 | Anderson | Texas | 48001 | 3973 | 54 |
819205 | 819205 | 2020-12-11 | Anderson | Texas | 48001 | 3919 | 54 |
815959 | 815959 | 2020-12-10 | Anderson | Texas | 48001 | 3246 | 51 |
812713 | 812713 | 2020-12-09 | Anderson | Texas | 48001 | 3250 | 51 |
809469 | 809469 | 2020-12-08 | Anderson | Texas | 48001 | 3248 | 51 |
806224 | 806224 | 2020-12-07 | Anderson | Texas | 48001 | 3223 | 50 |
802979 | 802979 | 2020-12-06 | Anderson | Texas | 48001 | 3223 | 50 |
799734 | 799734 | 2020-12-05 | Anderson | Texas | 48001 | 3223 | 50 |
796489 | 796489 | 2020-12-04 | Anderson | Texas | 48001 | 3217 | 49 |
793244 | 793244 | 2020-12-03 | Anderson | Texas | 48001 | 3211 | 49 |
789999 | 789999 | 2020-12-02 | Anderson | Texas | 48001 | 3198 | 49 |
786754 | 786754 | 2020-12-01 | Anderson | Texas | 48001 | 3190 | 49 |
783510 | 783510 | 2020-11-30 | Anderson | Texas | 48001 | 3167 | 49 |
780265 | 780265 | 2020-11-29 | Anderson | Texas | 48001 | 3167 | 49 |
777019 | 777019 | 2020-11-28 | Anderson | Texas | 48001 | 3167 | 49 |
773774 | 773774 | 2020-11-27 | Anderson | Texas | 48001 | 3172 | 47 |
770529 | 770529 | 2020-11-26 | Anderson | Texas | 48001 | 3171 | 47 |
767283 | 767283 | 2020-11-25 | Anderson | Texas | 48001 | 3150 | 47 |
764038 | 764038 | 2020-11-24 | Anderson | Texas | 48001 | 3143 | 47 |
760793 | 760793 | 2020-11-23 | Anderson | Texas | 48001 | 3118 | 46 |
757548 | 757548 | 2020-11-22 | Anderson | Texas | 48001 | 3127 | 46 |
754301 | 754301 | 2020-11-21 | Anderson | Texas | 48001 | 3127 | 46 |
751055 | 751055 | 2020-11-20 | Anderson | Texas | 48001 | 3092 | 46 |
747809 | 747809 | 2020-11-19 | Anderson | Texas | 48001 | 3101 | 46 |
744563 | 744563 | 2020-11-18 | Anderson | Texas | 48001 | 3095 | 45 |
741316 | 741316 | 2020-11-17 | Anderson | Texas | 48001 | 3065 | 45 |
738070 | 738070 | 2020-11-16 | Anderson | Texas | 48001 | 3051 | 45 |
734826 | 734826 | 2020-11-15 | Anderson | Texas | 48001 | 3051 | 45 |
731580 | 731580 | 2020-11-14 | Anderson | Texas | 48001 | 3045 | 44 |
728335 | 728335 | 2020-11-13 | Anderson | Texas | 48001 | 3041 | 43 |
725092 | 725092 | 2020-11-12 | Anderson | Texas | 48001 | 3045 | 43 |
721849 | 721849 | 2020-11-11 | Anderson | Texas | 48001 | 3035 | 42 |
718606 | 718606 | 2020-11-10 | Anderson | Texas | 48001 | 3028 | 42 |
715363 | 715363 | 2020-11-09 | Anderson | Texas | 48001 | 3021 | 41 |
712119 | 712119 | 2020-11-08 | Anderson | Texas | 48001 | 3021 | 41 |
708875 | 708875 | 2020-11-07 | Anderson | Texas | 48001 | 3018 | 41 |
705631 | 705631 | 2020-11-06 | Anderson | Texas | 48001 | 3008 | 41 |
702388 | 702388 | 2020-11-05 | Anderson | Texas | 48001 | 3011 | 41 |
699145 | 699145 | 2020-11-04 | Anderson | Texas | 48001 | 2981 | 41 |
695901 | 695901 | 2020-11-03 | Anderson | Texas | 48001 | 2987 | 39 |
692659 | 692659 | 2020-11-02 | Anderson | Texas | 48001 | 2979 | 39 |
689415 | 689415 | 2020-11-01 | Anderson | Texas | 48001 | 2979 | 39 |
686170 | 686170 | 2020-10-31 | Anderson | Texas | 48001 | 2979 | 39 |
682927 | 682927 | 2020-10-30 | Anderson | Texas | 48001 | 2970 | 39 |
679684 | 679684 | 2020-10-29 | Anderson | Texas | 48001 | 2970 | 39 |
676441 | 676441 | 2020-10-28 | Anderson | Texas | 48001 | 2961 | 39 |
673198 | 673198 | 2020-10-27 | Anderson | Texas | 48001 | 2949 | 39 |
669956 | 669956 | 2020-10-26 | Anderson | Texas | 48001 | 2946 | 39 |
666713 | 666713 | 2020-10-25 | Anderson | Texas | 48001 | 2941 | 39 |
663468 | 663468 | 2020-10-24 | Anderson | Texas | 48001 | 2941 | 39 |
660224 | 660224 | 2020-10-23 | Anderson | Texas | 48001 | 2934 | 39 |
656980 | 656980 | 2020-10-22 | Anderson | Texas | 48001 | 2922 | 39 |
653735 | 653735 | 2020-10-21 | Anderson | Texas | 48001 | 2922 | 39 |
650490 | 650490 | 2020-10-20 | Anderson | Texas | 48001 | 2920 | 38 |
647246 | 647246 | 2020-10-19 | Anderson | Texas | 48001 | 2909 | 38 |
644000 | 644000 | 2020-10-18 | Anderson | Texas | 48001 | 2909 | 38 |
640752 | 640752 | 2020-10-17 | Anderson | Texas | 48001 | 2909 | 38 |
637505 | 637505 | 2020-10-16 | Anderson | Texas | 48001 | 2906 | 38 |
634260 | 634260 | 2020-10-15 | Anderson | Texas | 48001 | 2903 | 38 |
631015 | 631015 | 2020-10-14 | Anderson | Texas | 48001 | 2885 | 38 |
627771 | 627771 | 2020-10-13 | Anderson | Texas | 48001 | 2892 | 37 |
624529 | 624529 | 2020-10-12 | Anderson | Texas | 48001 | 2879 | 37 |
621286 | 621286 | 2020-10-11 | Anderson | Texas | 48001 | 2868 | 37 |
618043 | 618043 | 2020-10-10 | Anderson | Texas | 48001 | 2868 | 37 |
614801 | 614801 | 2020-10-09 | Anderson | Texas | 48001 | 2872 | 37 |
611560 | 611560 | 2020-10-08 | Anderson | Texas | 48001 | 2858 | 37 |
608318 | 608318 | 2020-10-07 | Anderson | Texas | 48001 | 2849 | 37 |
605075 | 605075 | 2020-10-06 | Anderson | Texas | 48001 | 2836 | 37 |
601833 | 601833 | 2020-10-05 | Anderson | Texas | 48001 | 2859 | 36 |
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);