ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Harris" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923159 | 923159 | 2021-01-12 | Harris | Texas | 48201 | 267729 | 3618 |
919914 | 919914 | 2021-01-11 | Harris | Texas | 48201 | 266525 | 3591 |
916669 | 916669 | 2021-01-10 | Harris | Texas | 48201 | 262525 | 3588 |
913424 | 913424 | 2021-01-09 | Harris | Texas | 48201 | 259773 | 3581 |
910179 | 910179 | 2021-01-08 | Harris | Texas | 48201 | 256046 | 3549 |
906934 | 906934 | 2021-01-07 | Harris | Texas | 48201 | 253612 | 3522 |
903688 | 903688 | 2021-01-06 | Harris | Texas | 48201 | 250854 | 3482 |
900443 | 900443 | 2021-01-05 | Harris | Texas | 48201 | 249488 | 3453 |
897198 | 897198 | 2021-01-04 | Harris | Texas | 48201 | 247458 | 3435 |
893952 | 893952 | 2021-01-03 | Harris | Texas | 48201 | 245551 | 3431 |
890706 | 890706 | 2021-01-02 | Harris | Texas | 48201 | 243059 | 3424 |
887459 | 887459 | 2021-01-01 | Harris | Texas | 48201 | 239657 | 3417 |
884214 | 884214 | 2020-12-31 | Harris | Texas | 48201 | 237727 | 3402 |
880969 | 880969 | 2020-12-30 | Harris | Texas | 48201 | 236673 | 3371 |
877724 | 877724 | 2020-12-29 | Harris | Texas | 48201 | 234736 | 3348 |
874479 | 874479 | 2020-12-28 | Harris | Texas | 48201 | 233330 | 3332 |
871234 | 871234 | 2020-12-27 | Harris | Texas | 48201 | 231707 | 3331 |
867989 | 867989 | 2020-12-26 | Harris | Texas | 48201 | 225443 | 3328 |
864744 | 864744 | 2020-12-25 | Harris | Texas | 48201 | 225365 | 3328 |
861499 | 861499 | 2020-12-24 | Harris | Texas | 48201 | 225102 | 3306 |
858254 | 858254 | 2020-12-23 | Harris | Texas | 48201 | 224245 | 3283 |
855009 | 855009 | 2020-12-22 | Harris | Texas | 48201 | 222931 | 3260 |
851764 | 851764 | 2020-12-21 | Harris | Texas | 48201 | 221860 | 3245 |
848519 | 848519 | 2020-12-20 | Harris | Texas | 48201 | 219265 | 3242 |
845274 | 845274 | 2020-12-19 | Harris | Texas | 48201 | 217086 | 3233 |
842028 | 842028 | 2020-12-18 | Harris | Texas | 48201 | 215779 | 3215 |
838783 | 838783 | 2020-12-17 | Harris | Texas | 48201 | 214180 | 3203 |
835537 | 835537 | 2020-12-16 | Harris | Texas | 48201 | 212686 | 3178 |
832291 | 832291 | 2020-12-15 | Harris | Texas | 48201 | 210362 | 3162 |
829044 | 829044 | 2020-12-14 | Harris | Texas | 48201 | 208737 | 3150 |
825798 | 825798 | 2020-12-13 | Harris | Texas | 48201 | 207406 | 3150 |
822551 | 822551 | 2020-12-12 | Harris | Texas | 48201 | 205928 | 3142 |
819305 | 819305 | 2020-12-11 | Harris | Texas | 48201 | 204850 | 3128 |
816059 | 816059 | 2020-12-10 | Harris | Texas | 48201 | 202861 | 3110 |
812813 | 812813 | 2020-12-09 | Harris | Texas | 48201 | 201496 | 3103 |
809569 | 809569 | 2020-12-08 | Harris | Texas | 48201 | 200397 | 3086 |
806324 | 806324 | 2020-12-07 | Harris | Texas | 48201 | 199597 | 3069 |
803079 | 803079 | 2020-12-06 | Harris | Texas | 48201 | 198961 | 3067 |
799834 | 799834 | 2020-12-05 | Harris | Texas | 48201 | 196658 | 3060 |
796589 | 796589 | 2020-12-04 | Harris | Texas | 48201 | 195558 | 3046 |
793344 | 793344 | 2020-12-03 | Harris | Texas | 48201 | 194899 | 3032 |
790099 | 790099 | 2020-12-02 | Harris | Texas | 48201 | 193089 | 3023 |
786854 | 786854 | 2020-12-01 | Harris | Texas | 48201 | 192127 | 3013 |
783610 | 783610 | 2020-11-30 | Harris | Texas | 48201 | 191513 | 3009 |
780365 | 780365 | 2020-11-29 | Harris | Texas | 48201 | 190631 | 3009 |
777119 | 777119 | 2020-11-28 | Harris | Texas | 48201 | 187932 | 3001 |
773874 | 773874 | 2020-11-27 | Harris | Texas | 48201 | 187867 | 2995 |
770629 | 770629 | 2020-11-26 | Harris | Texas | 48201 | 187759 | 2992 |
767383 | 767383 | 2020-11-25 | Harris | Texas | 48201 | 187163 | 2984 |
764138 | 764138 | 2020-11-24 | Harris | Texas | 48201 | 185304 | 2974 |
760893 | 760893 | 2020-11-23 | Harris | Texas | 48201 | 183252 | 2965 |
757648 | 757648 | 2020-11-22 | Harris | Texas | 48201 | 182192 | 2965 |
754401 | 754401 | 2020-11-21 | Harris | Texas | 48201 | 181361 | 2964 |
751155 | 751155 | 2020-11-20 | Harris | Texas | 48201 | 179911 | 2954 |
747909 | 747909 | 2020-11-19 | Harris | Texas | 48201 | 178811 | 2943 |
744663 | 744663 | 2020-11-18 | Harris | Texas | 48201 | 177466 | 2928 |
741416 | 741416 | 2020-11-17 | Harris | Texas | 48201 | 175959 | 2919 |
738170 | 738170 | 2020-11-16 | Harris | Texas | 48201 | 175414 | 2910 |
734926 | 734926 | 2020-11-15 | Harris | Texas | 48201 | 174493 | 2909 |
731680 | 731680 | 2020-11-14 | Harris | Texas | 48201 | 173436 | 2908 |
728435 | 728435 | 2020-11-13 | Harris | Texas | 48201 | 172763 | 2895 |
725192 | 725192 | 2020-11-12 | Harris | Texas | 48201 | 171916 | 2887 |
721949 | 721949 | 2020-11-11 | Harris | Texas | 48201 | 170835 | 2877 |
718706 | 718706 | 2020-11-10 | Harris | Texas | 48201 | 168746 | 2871 |
715463 | 715463 | 2020-11-09 | Harris | Texas | 48201 | 167956 | 2866 |
712219 | 712219 | 2020-11-08 | Harris | Texas | 48201 | 167331 | 2866 |
708975 | 708975 | 2020-11-07 | Harris | Texas | 48201 | 166545 | 2865 |
705731 | 705731 | 2020-11-06 | Harris | Texas | 48201 | 165967 | 2854 |
702488 | 702488 | 2020-11-05 | Harris | Texas | 48201 | 165252 | 2851 |
699245 | 699245 | 2020-11-04 | Harris | Texas | 48201 | 164445 | 2841 |
696001 | 696001 | 2020-11-03 | Harris | Texas | 48201 | 163845 | 2823 |
692759 | 692759 | 2020-11-02 | Harris | Texas | 48201 | 163287 | 2814 |
689515 | 689515 | 2020-11-01 | Harris | Texas | 48201 | 162807 | 2811 |
686270 | 686270 | 2020-10-31 | Harris | Texas | 48201 | 162306 | 2809 |
683027 | 683027 | 2020-10-30 | Harris | Texas | 48201 | 161613 | 2806 |
679784 | 679784 | 2020-10-29 | Harris | Texas | 48201 | 160984 | 2800 |
676541 | 676541 | 2020-10-28 | Harris | Texas | 48201 | 160532 | 2791 |
673298 | 673298 | 2020-10-27 | Harris | Texas | 48201 | 159617 | 2785 |
670056 | 670056 | 2020-10-26 | Harris | Texas | 48201 | 159272 | 2783 |
666813 | 666813 | 2020-10-25 | Harris | Texas | 48201 | 158758 | 2783 |
663568 | 663568 | 2020-10-24 | Harris | Texas | 48201 | 158379 | 2775 |
660324 | 660324 | 2020-10-23 | Harris | Texas | 48201 | 157392 | 2759 |
657080 | 657080 | 2020-10-22 | Harris | Texas | 48201 | 156742 | 2750 |
653835 | 653835 | 2020-10-21 | Harris | Texas | 48201 | 156035 | 2750 |
650590 | 650590 | 2020-10-20 | Harris | Texas | 48201 | 155192 | 2735 |
647346 | 647346 | 2020-10-19 | Harris | Texas | 48201 | 154765 | 2729 |
644100 | 644100 | 2020-10-18 | Harris | Texas | 48201 | 154367 | 2728 |
640852 | 640852 | 2020-10-17 | Harris | Texas | 48201 | 153955 | 2726 |
637605 | 637605 | 2020-10-16 | Harris | Texas | 48201 | 153571 | 2718 |
634360 | 634360 | 2020-10-15 | Harris | Texas | 48201 | 152977 | 2708 |
631115 | 631115 | 2020-10-14 | Harris | Texas | 48201 | 152623 | 2698 |
627871 | 627871 | 2020-10-13 | Harris | Texas | 48201 | 151880 | 2689 |
624629 | 624629 | 2020-10-12 | Harris | Texas | 48201 | 151463 | 2682 |
621386 | 621386 | 2020-10-11 | Harris | Texas | 48201 | 151161 | 2682 |
618143 | 618143 | 2020-10-10 | Harris | Texas | 48201 | 150626 | 2675 |
614901 | 614901 | 2020-10-09 | Harris | Texas | 48201 | 150176 | 2668 |
611660 | 611660 | 2020-10-08 | Harris | Texas | 48201 | 149771 | 2657 |
608418 | 608418 | 2020-10-07 | Harris | Texas | 48201 | 149394 | 2647 |
605175 | 605175 | 2020-10-06 | Harris | Texas | 48201 | 148769 | 2632 |
601933 | 601933 | 2020-10-05 | Harris | Texas | 48201 | 148235 | 2628 |
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);