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 |
---|---|---|---|---|---|---|---|
1056228 | 1056228 | 2021-02-22 | Harris | Texas | 48201 | 343070 | 4858 |
1052982 | 1052982 | 2021-02-21 | Harris | Texas | 48201 | 342309 | 4851 |
1049735 | 1049735 | 2021-02-20 | Harris | Texas | 48201 | 340951 | 4829 |
1046488 | 1046488 | 2021-02-19 | Harris | Texas | 48201 | 340559 | 4790 |
1043243 | 1043243 | 2021-02-18 | Harris | Texas | 48201 | 339444 | 4771 |
1039998 | 1039998 | 2021-02-17 | Harris | Texas | 48201 | 339366 | 4766 |
1036753 | 1036753 | 2021-02-16 | Harris | Texas | 48201 | 338284 | 4760 |
1033508 | 1033508 | 2021-02-15 | Harris | Texas | 48201 | 338274 | 4760 |
1030262 | 1030262 | 2021-02-14 | Harris | Texas | 48201 | 337012 | 4753 |
1027015 | 1027015 | 2021-02-13 | Harris | Texas | 48201 | 335673 | 4735 |
1023770 | 1023770 | 2021-02-12 | Harris | Texas | 48201 | 333279 | 4702 |
1020525 | 1020525 | 2021-02-11 | Harris | Texas | 48201 | 331837 | 4664 |
1017280 | 1017280 | 2021-02-10 | Harris | Texas | 48201 | 330256 | 4607 |
1014035 | 1014035 | 2021-02-09 | Harris | Texas | 48201 | 329576 | 4569 |
1010790 | 1010790 | 2021-02-08 | Harris | Texas | 48201 | 329167 | 4520 |
1007544 | 1007544 | 2021-02-07 | Harris | Texas | 48201 | 328426 | 4506 |
1004298 | 1004298 | 2021-02-06 | Harris | Texas | 48201 | 327079 | 4488 |
1001052 | 1001052 | 2021-02-05 | Harris | Texas | 48201 | 326248 | 4441 |
997806 | 997806 | 2021-02-04 | Harris | Texas | 48201 | 325010 | 4410 |
994560 | 994560 | 2021-02-03 | Harris | Texas | 48201 | 323408 | 4356 |
991314 | 991314 | 2021-02-02 | Harris | Texas | 48201 | 320744 | 4314 |
988068 | 988068 | 2021-02-01 | Harris | Texas | 48201 | 319800 | 4264 |
984821 | 984821 | 2021-01-31 | Harris | Texas | 48201 | 317654 | 4257 |
981574 | 981574 | 2021-01-30 | Harris | Texas | 48201 | 314697 | 4242 |
978328 | 978328 | 2021-01-29 | Harris | Texas | 48201 | 311665 | 4196 |
975083 | 975083 | 2021-01-28 | Harris | Texas | 48201 | 308902 | 4152 |
971838 | 971838 | 2021-01-27 | Harris | Texas | 48201 | 306495 | 4111 |
968593 | 968593 | 2021-01-26 | Harris | Texas | 48201 | 304333 | 4060 |
965349 | 965349 | 2021-01-25 | Harris | Texas | 48201 | 301173 | 4024 |
962104 | 962104 | 2021-01-24 | Harris | Texas | 48201 | 297629 | 4013 |
958859 | 958859 | 2021-01-23 | Harris | Texas | 48201 | 296521 | 3978 |
955613 | 955613 | 2021-01-22 | Harris | Texas | 48201 | 294266 | 3941 |
952368 | 952368 | 2021-01-21 | Harris | Texas | 48201 | 293271 | 3898 |
949123 | 949123 | 2021-01-20 | Harris | Texas | 48201 | 290249 | 3866 |
945877 | 945877 | 2021-01-19 | Harris | Texas | 48201 | 287753 | 3825 |
942630 | 942630 | 2021-01-18 | Harris | Texas | 48201 | 286356 | 3795 |
939385 | 939385 | 2021-01-17 | Harris | Texas | 48201 | 284917 | 3792 |
936140 | 936140 | 2021-01-16 | Harris | Texas | 48201 | 281422 | 3777 |
932895 | 932895 | 2021-01-15 | Harris | Texas | 48201 | 278312 | 3723 |
929650 | 929650 | 2021-01-14 | Harris | Texas | 48201 | 274899 | 3691 |
926405 | 926405 | 2021-01-13 | Harris | Texas | 48201 | 269089 | 3658 |
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 |
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);