ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48423 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923270 | 923270 | 2021-01-12 | Smith | Texas | 48423 | 14526 | 292 |
920025 | 920025 | 2021-01-11 | Smith | Texas | 48423 | 13854 | 290 |
916780 | 916780 | 2021-01-10 | Smith | Texas | 48423 | 13854 | 289 |
913535 | 913535 | 2021-01-09 | Smith | Texas | 48423 | 13854 | 287 |
910290 | 910290 | 2021-01-08 | Smith | Texas | 48423 | 13854 | 284 |
907045 | 907045 | 2021-01-07 | Smith | Texas | 48423 | 13545 | 280 |
903799 | 903799 | 2021-01-06 | Smith | Texas | 48423 | 13544 | 273 |
900554 | 900554 | 2021-01-05 | Smith | Texas | 48423 | 13340 | 272 |
897309 | 897309 | 2021-01-04 | Smith | Texas | 48423 | 13161 | 269 |
894063 | 894063 | 2021-01-03 | Smith | Texas | 48423 | 12844 | 269 |
890817 | 890817 | 2021-01-02 | Smith | Texas | 48423 | 12844 | 269 |
887570 | 887570 | 2021-01-01 | Smith | Texas | 48423 | 12844 | 267 |
884325 | 884325 | 2020-12-31 | Smith | Texas | 48423 | 12844 | 261 |
881080 | 881080 | 2020-12-30 | Smith | Texas | 48423 | 12749 | 259 |
877835 | 877835 | 2020-12-29 | Smith | Texas | 48423 | 12614 | 256 |
874590 | 874590 | 2020-12-28 | Smith | Texas | 48423 | 12482 | 254 |
871345 | 871345 | 2020-12-27 | Smith | Texas | 48423 | 12138 | 252 |
868100 | 868100 | 2020-12-26 | Smith | Texas | 48423 | 12138 | 251 |
864855 | 864855 | 2020-12-25 | Smith | Texas | 48423 | 12138 | 251 |
861610 | 861610 | 2020-12-24 | Smith | Texas | 48423 | 12137 | 248 |
858365 | 858365 | 2020-12-23 | Smith | Texas | 48423 | 12137 | 243 |
855120 | 855120 | 2020-12-22 | Smith | Texas | 48423 | 12024 | 237 |
851875 | 851875 | 2020-12-21 | Smith | Texas | 48423 | 11900 | 235 |
848630 | 848630 | 2020-12-20 | Smith | Texas | 48423 | 11733 | 235 |
845385 | 845385 | 2020-12-19 | Smith | Texas | 48423 | 11733 | 235 |
842139 | 842139 | 2020-12-18 | Smith | Texas | 48423 | 11733 | 232 |
838894 | 838894 | 2020-12-17 | Smith | Texas | 48423 | 11659 | 226 |
835648 | 835648 | 2020-12-16 | Smith | Texas | 48423 | 11595 | 221 |
832402 | 832402 | 2020-12-15 | Smith | Texas | 48423 | 11503 | 219 |
829155 | 829155 | 2020-12-14 | Smith | Texas | 48423 | 11399 | 219 |
825909 | 825909 | 2020-12-13 | Smith | Texas | 48423 | 11225 | 219 |
822662 | 822662 | 2020-12-12 | Smith | Texas | 48423 | 11225 | 219 |
819416 | 819416 | 2020-12-11 | Smith | Texas | 48423 | 11225 | 218 |
816170 | 816170 | 2020-12-10 | Smith | Texas | 48423 | 11059 | 215 |
812924 | 812924 | 2020-12-09 | Smith | Texas | 48423 | 10939 | 213 |
809680 | 809680 | 2020-12-08 | Smith | Texas | 48423 | 10822 | 212 |
806435 | 806435 | 2020-12-07 | Smith | Texas | 48423 | 10650 | 211 |
803190 | 803190 | 2020-12-06 | Smith | Texas | 48423 | 10366 | 211 |
799945 | 799945 | 2020-12-05 | Smith | Texas | 48423 | 10366 | 211 |
796700 | 796700 | 2020-12-04 | Smith | Texas | 48423 | 10366 | 207 |
793455 | 793455 | 2020-12-03 | Smith | Texas | 48423 | 10162 | 204 |
790210 | 790210 | 2020-12-02 | Smith | Texas | 48423 | 9900 | 203 |
786965 | 786965 | 2020-12-01 | Smith | Texas | 48423 | 9790 | 203 |
783721 | 783721 | 2020-11-30 | Smith | Texas | 48423 | 9685 | 200 |
780476 | 780476 | 2020-11-29 | Smith | Texas | 48423 | 9393 | 196 |
777230 | 777230 | 2020-11-28 | Smith | Texas | 48423 | 9393 | 196 |
773985 | 773985 | 2020-11-27 | Smith | Texas | 48423 | 9393 | 196 |
770740 | 770740 | 2020-11-26 | Smith | Texas | 48423 | 9393 | 196 |
767494 | 767494 | 2020-11-25 | Smith | Texas | 48423 | 9393 | 196 |
764249 | 764249 | 2020-11-24 | Smith | Texas | 48423 | 9273 | 197 |
761004 | 761004 | 2020-11-23 | Smith | Texas | 48423 | 9139 | 192 |
757759 | 757759 | 2020-11-22 | Smith | Texas | 48423 | 9000 | 190 |
754512 | 754512 | 2020-11-21 | Smith | Texas | 48423 | 9000 | 190 |
751266 | 751266 | 2020-11-20 | Smith | Texas | 48423 | 9000 | 190 |
748020 | 748020 | 2020-11-19 | Smith | Texas | 48423 | 8862 | 189 |
744774 | 744774 | 2020-11-18 | Smith | Texas | 48423 | 8777 | 188 |
741527 | 741527 | 2020-11-17 | Smith | Texas | 48423 | 8540 | 189 |
738280 | 738280 | 2020-11-16 | Smith | Texas | 48423 | 8389 | 189 |
735036 | 735036 | 2020-11-15 | Smith | Texas | 48423 | 8038 | 187 |
731790 | 731790 | 2020-11-14 | Smith | Texas | 48423 | 8038 | 187 |
728545 | 728545 | 2020-11-13 | Smith | Texas | 48423 | 8038 | 187 |
725302 | 725302 | 2020-11-12 | Smith | Texas | 48423 | 7901 | 167 |
722059 | 722059 | 2020-11-11 | Smith | Texas | 48423 | 7708 | 161 |
718816 | 718816 | 2020-11-10 | Smith | Texas | 48423 | 7608 | 159 |
715573 | 715573 | 2020-11-09 | Smith | Texas | 48423 | 7501 | 156 |
712329 | 712329 | 2020-11-08 | Smith | Texas | 48423 | 7225 | 156 |
709085 | 709085 | 2020-11-07 | Smith | Texas | 48423 | 7225 | 156 |
705841 | 705841 | 2020-11-06 | Smith | Texas | 48423 | 7225 | 150 |
702598 | 702598 | 2020-11-05 | Smith | Texas | 48423 | 7063 | 147 |
699355 | 699355 | 2020-11-04 | Smith | Texas | 48423 | 6981 | 146 |
696111 | 696111 | 2020-11-03 | Smith | Texas | 48423 | 6786 | 145 |
692869 | 692869 | 2020-11-02 | Smith | Texas | 48423 | 6786 | 145 |
689625 | 689625 | 2020-11-01 | Smith | Texas | 48423 | 6685 | 145 |
686380 | 686380 | 2020-10-31 | Smith | Texas | 48423 | 6685 | 144 |
683137 | 683137 | 2020-10-30 | Smith | Texas | 48423 | 6685 | 141 |
679894 | 679894 | 2020-10-29 | Smith | Texas | 48423 | 6622 | 139 |
676651 | 676651 | 2020-10-28 | Smith | Texas | 48423 | 6563 | 137 |
673408 | 673408 | 2020-10-27 | Smith | Texas | 48423 | 6458 | 135 |
670166 | 670166 | 2020-10-26 | Smith | Texas | 48423 | 6383 | 134 |
666923 | 666923 | 2020-10-25 | Smith | Texas | 48423 | 6258 | 134 |
663678 | 663678 | 2020-10-24 | Smith | Texas | 48423 | 6258 | 132 |
660434 | 660434 | 2020-10-23 | Smith | Texas | 48423 | 6258 | 127 |
657190 | 657190 | 2020-10-22 | Smith | Texas | 48423 | 6114 | 125 |
653945 | 653945 | 2020-10-21 | Smith | Texas | 48423 | 6058 | 125 |
650700 | 650700 | 2020-10-20 | Smith | Texas | 48423 | 5980 | 125 |
647456 | 647456 | 2020-10-19 | Smith | Texas | 48423 | 5910 | 124 |
644210 | 644210 | 2020-10-18 | Smith | Texas | 48423 | 5765 | 124 |
640962 | 640962 | 2020-10-17 | Smith | Texas | 48423 | 5765 | 123 |
637715 | 637715 | 2020-10-16 | Smith | Texas | 48423 | 5765 | 120 |
634470 | 634470 | 2020-10-15 | Smith | Texas | 48423 | 5714 | 119 |
631225 | 631225 | 2020-10-14 | Smith | Texas | 48423 | 5665 | 117 |
627981 | 627981 | 2020-10-13 | Smith | Texas | 48423 | 5559 | 115 |
624738 | 624738 | 2020-10-12 | Smith | Texas | 48423 | 5477 | 115 |
621495 | 621495 | 2020-10-11 | Smith | Texas | 48423 | 5350 | 115 |
618252 | 618252 | 2020-10-10 | Smith | Texas | 48423 | 5350 | 115 |
615010 | 615010 | 2020-10-09 | Smith | Texas | 48423 | 5350 | 113 |
611769 | 611769 | 2020-10-08 | Smith | Texas | 48423 | 5290 | 112 |
608527 | 608527 | 2020-10-07 | Smith | Texas | 48423 | 5234 | 110 |
605284 | 605284 | 2020-10-06 | Smith | Texas | 48423 | 5127 | 110 |
602042 | 602042 | 2020-10-05 | Smith | Texas | 48423 | 5067 | 110 |
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);