ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Williamson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923304 | 923304 | 2021-01-12 | Williamson | Texas | 48491 | 28187 | 239 |
920059 | 920059 | 2021-01-11 | Williamson | Texas | 48491 | 27645 | 238 |
916814 | 916814 | 2021-01-10 | Williamson | Texas | 48491 | 26512 | 238 |
913569 | 913569 | 2021-01-09 | Williamson | Texas | 48491 | 26512 | 234 |
910324 | 910324 | 2021-01-08 | Williamson | Texas | 48491 | 26512 | 230 |
907079 | 907079 | 2021-01-07 | Williamson | Texas | 48491 | 26084 | 223 |
903833 | 903833 | 2021-01-06 | Williamson | Texas | 48491 | 25762 | 222 |
900588 | 900588 | 2021-01-05 | Williamson | Texas | 48491 | 25233 | 215 |
897343 | 897343 | 2021-01-04 | Williamson | Texas | 48491 | 24482 | 215 |
894097 | 894097 | 2021-01-03 | Williamson | Texas | 48491 | 22884 | 215 |
890851 | 890851 | 2021-01-02 | Williamson | Texas | 48491 | 22884 | 215 |
887604 | 887604 | 2021-01-01 | Williamson | Texas | 48491 | 22884 | 213 |
884359 | 884359 | 2020-12-31 | Williamson | Texas | 48491 | 22884 | 210 |
881114 | 881114 | 2020-12-30 | Williamson | Texas | 48491 | 22884 | 204 |
877869 | 877869 | 2020-12-29 | Williamson | Texas | 48491 | 22444 | 204 |
874624 | 874624 | 2020-12-28 | Williamson | Texas | 48491 | 21710 | 202 |
871379 | 871379 | 2020-12-27 | Williamson | Texas | 48491 | 20624 | 201 |
868134 | 868134 | 2020-12-26 | Williamson | Texas | 48491 | 20624 | 201 |
864889 | 864889 | 2020-12-25 | Williamson | Texas | 48491 | 20624 | 201 |
861644 | 861644 | 2020-12-24 | Williamson | Texas | 48491 | 20624 | 200 |
858399 | 858399 | 2020-12-23 | Williamson | Texas | 48491 | 20624 | 199 |
855154 | 855154 | 2020-12-22 | Williamson | Texas | 48491 | 20624 | 197 |
851909 | 851909 | 2020-12-21 | Williamson | Texas | 48491 | 19948 | 195 |
848664 | 848664 | 2020-12-20 | Williamson | Texas | 48491 | 19100 | 194 |
845419 | 845419 | 2020-12-19 | Williamson | Texas | 48491 | 19100 | 194 |
842173 | 842173 | 2020-12-18 | Williamson | Texas | 48491 | 19100 | 190 |
838928 | 838928 | 2020-12-17 | Williamson | Texas | 48491 | 18833 | 188 |
835682 | 835682 | 2020-12-16 | Williamson | Texas | 48491 | 18522 | 187 |
832436 | 832436 | 2020-12-15 | Williamson | Texas | 48491 | 18091 | 183 |
829189 | 829189 | 2020-12-14 | Williamson | Texas | 48491 | 17687 | 182 |
825943 | 825943 | 2020-12-13 | Williamson | Texas | 48491 | 17129 | 182 |
822696 | 822696 | 2020-12-12 | Williamson | Texas | 48491 | 17129 | 182 |
819450 | 819450 | 2020-12-11 | Williamson | Texas | 48491 | 17129 | 184 |
816204 | 816204 | 2020-12-10 | Williamson | Texas | 48491 | 16858 | 183 |
812958 | 812958 | 2020-12-09 | Williamson | Texas | 48491 | 16607 | 181 |
809714 | 809714 | 2020-12-08 | Williamson | Texas | 48491 | 16385 | 175 |
806469 | 806469 | 2020-12-07 | Williamson | Texas | 48491 | 16036 | 175 |
803224 | 803224 | 2020-12-06 | Williamson | Texas | 48491 | 15463 | 175 |
799979 | 799979 | 2020-12-05 | Williamson | Texas | 48491 | 15463 | 175 |
796734 | 796734 | 2020-12-04 | Williamson | Texas | 48491 | 15463 | 175 |
793489 | 793489 | 2020-12-03 | Williamson | Texas | 48491 | 15261 | 171 |
790244 | 790244 | 2020-12-02 | Williamson | Texas | 48491 | 15046 | 170 |
786999 | 786999 | 2020-12-01 | Williamson | Texas | 48491 | 14908 | 166 |
783755 | 783755 | 2020-11-30 | Williamson | Texas | 48491 | 14653 | 165 |
780510 | 780510 | 2020-11-29 | Williamson | Texas | 48491 | 13574 | 165 |
777264 | 777264 | 2020-11-28 | Williamson | Texas | 48491 | 13574 | 165 |
774019 | 774019 | 2020-11-27 | Williamson | Texas | 48491 | 13574 | 165 |
770774 | 770774 | 2020-11-26 | Williamson | Texas | 48491 | 13574 | 165 |
767528 | 767528 | 2020-11-25 | Williamson | Texas | 48491 | 13574 | 164 |
764283 | 764283 | 2020-11-24 | Williamson | Texas | 48491 | 13574 | 163 |
761038 | 761038 | 2020-11-23 | Williamson | Texas | 48491 | 13215 | 164 |
757793 | 757793 | 2020-11-22 | Williamson | Texas | 48491 | 12799 | 164 |
754546 | 754546 | 2020-11-21 | Williamson | Texas | 48491 | 12799 | 163 |
751300 | 751300 | 2020-11-20 | Williamson | Texas | 48491 | 12799 | 162 |
748054 | 748054 | 2020-11-19 | Williamson | Texas | 48491 | 12506 | 161 |
744808 | 744808 | 2020-11-18 | Williamson | Texas | 48491 | 12340 | 160 |
741561 | 741561 | 2020-11-17 | Williamson | Texas | 48491 | 12225 | 160 |
738314 | 738314 | 2020-11-16 | Williamson | Texas | 48491 | 12106 | 160 |
735070 | 735070 | 2020-11-15 | Williamson | Texas | 48491 | 11903 | 160 |
731824 | 731824 | 2020-11-14 | Williamson | Texas | 48491 | 11903 | 160 |
728579 | 728579 | 2020-11-13 | Williamson | Texas | 48491 | 11903 | 159 |
725336 | 725336 | 2020-11-12 | Williamson | Texas | 48491 | 11812 | 159 |
722093 | 722093 | 2020-11-11 | Williamson | Texas | 48491 | 11699 | 159 |
718850 | 718850 | 2020-11-10 | Williamson | Texas | 48491 | 10200 | 159 |
715607 | 715607 | 2020-11-09 | Williamson | Texas | 48491 | 10200 | 159 |
712363 | 712363 | 2020-11-08 | Williamson | Texas | 48491 | 10038 | 159 |
709119 | 709119 | 2020-11-07 | Williamson | Texas | 48491 | 10038 | 159 |
705875 | 705875 | 2020-11-06 | Williamson | Texas | 48491 | 10038 | 159 |
702632 | 702632 | 2020-11-05 | Williamson | Texas | 48491 | 10004 | 159 |
699389 | 699389 | 2020-11-04 | Williamson | Texas | 48491 | 9944 | 157 |
696145 | 696145 | 2020-11-03 | Williamson | Texas | 48491 | 9898 | 156 |
692903 | 692903 | 2020-11-02 | Williamson | Texas | 48491 | 9854 | 156 |
689659 | 689659 | 2020-11-01 | Williamson | Texas | 48491 | 9776 | 156 |
686414 | 686414 | 2020-10-31 | Williamson | Texas | 48491 | 9776 | 156 |
683171 | 683171 | 2020-10-30 | Williamson | Texas | 48491 | 9776 | 156 |
679928 | 679928 | 2020-10-29 | Williamson | Texas | 48491 | 9717 | 155 |
676685 | 676685 | 2020-10-28 | Williamson | Texas | 48491 | 9698 | 154 |
673442 | 673442 | 2020-10-27 | Williamson | Texas | 48491 | 9668 | 153 |
670200 | 670200 | 2020-10-26 | Williamson | Texas | 48491 | 9608 | 152 |
666957 | 666957 | 2020-10-25 | Williamson | Texas | 48491 | 9523 | 152 |
663712 | 663712 | 2020-10-24 | Williamson | Texas | 48491 | 9523 | 152 |
660468 | 660468 | 2020-10-23 | Williamson | Texas | 48491 | 9523 | 151 |
657224 | 657224 | 2020-10-22 | Williamson | Texas | 48491 | 9478 | 151 |
653979 | 653979 | 2020-10-21 | Williamson | Texas | 48491 | 9453 | 151 |
650734 | 650734 | 2020-10-20 | Williamson | Texas | 48491 | 9327 | 151 |
647490 | 647490 | 2020-10-19 | Williamson | Texas | 48491 | 9327 | 150 |
644244 | 644244 | 2020-10-18 | Williamson | Texas | 48491 | 9327 | 150 |
640996 | 640996 | 2020-10-17 | Williamson | Texas | 48491 | 9327 | 150 |
637749 | 637749 | 2020-10-16 | Williamson | Texas | 48491 | 9327 | 149 |
634504 | 634504 | 2020-10-15 | Williamson | Texas | 48491 | 9281 | 148 |
631259 | 631259 | 2020-10-14 | Williamson | Texas | 48491 | 9262 | 147 |
628015 | 628015 | 2020-10-13 | Williamson | Texas | 48491 | 9231 | 146 |
624772 | 624772 | 2020-10-12 | Williamson | Texas | 48491 | 9190 | 146 |
621529 | 621529 | 2020-10-11 | Williamson | Texas | 48491 | 9104 | 146 |
618286 | 618286 | 2020-10-10 | Williamson | Texas | 48491 | 9104 | 146 |
615044 | 615044 | 2020-10-09 | Williamson | Texas | 48491 | 9104 | 145 |
611803 | 611803 | 2020-10-08 | Williamson | Texas | 48491 | 9082 | 145 |
608561 | 608561 | 2020-10-07 | Williamson | Texas | 48491 | 9070 | 145 |
605318 | 605318 | 2020-10-06 | Williamson | Texas | 48491 | 9049 | 144 |
602076 | 602076 | 2020-10-05 | Williamson | Texas | 48491 | 8990 | 144 |
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);