ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 48407 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923262 | 923262 | 2021-01-12 | San Jacinto | Texas | 48407 | 567 | 21 |
920017 | 920017 | 2021-01-11 | San Jacinto | Texas | 48407 | 553 | 21 |
916772 | 916772 | 2021-01-10 | San Jacinto | Texas | 48407 | 537 | 21 |
913527 | 913527 | 2021-01-09 | San Jacinto | Texas | 48407 | 516 | 21 |
910282 | 910282 | 2021-01-08 | San Jacinto | Texas | 48407 | 512 | 21 |
907037 | 907037 | 2021-01-07 | San Jacinto | Texas | 48407 | 492 | 20 |
903791 | 903791 | 2021-01-06 | San Jacinto | Texas | 48407 | 483 | 20 |
900546 | 900546 | 2021-01-05 | San Jacinto | Texas | 48407 | 470 | 19 |
897301 | 897301 | 2021-01-04 | San Jacinto | Texas | 48407 | 464 | 19 |
894055 | 894055 | 2021-01-03 | San Jacinto | Texas | 48407 | 460 | 19 |
890809 | 890809 | 2021-01-02 | San Jacinto | Texas | 48407 | 441 | 19 |
887562 | 887562 | 2021-01-01 | San Jacinto | Texas | 48407 | 433 | 19 |
884317 | 884317 | 2020-12-31 | San Jacinto | Texas | 48407 | 424 | 19 |
881072 | 881072 | 2020-12-30 | San Jacinto | Texas | 48407 | 425 | 19 |
877827 | 877827 | 2020-12-29 | San Jacinto | Texas | 48407 | 425 | 19 |
874582 | 874582 | 2020-12-28 | San Jacinto | Texas | 48407 | 422 | 19 |
871337 | 871337 | 2020-12-27 | San Jacinto | Texas | 48407 | 422 | 19 |
868092 | 868092 | 2020-12-26 | San Jacinto | Texas | 48407 | 419 | 19 |
864847 | 864847 | 2020-12-25 | San Jacinto | Texas | 48407 | 419 | 19 |
861602 | 861602 | 2020-12-24 | San Jacinto | Texas | 48407 | 418 | 18 |
858357 | 858357 | 2020-12-23 | San Jacinto | Texas | 48407 | 417 | 18 |
855112 | 855112 | 2020-12-22 | San Jacinto | Texas | 48407 | 416 | 18 |
851867 | 851867 | 2020-12-21 | San Jacinto | Texas | 48407 | 416 | 18 |
848622 | 848622 | 2020-12-20 | San Jacinto | Texas | 48407 | 416 | 18 |
845377 | 845377 | 2020-12-19 | San Jacinto | Texas | 48407 | 410 | 18 |
842131 | 842131 | 2020-12-18 | San Jacinto | Texas | 48407 | 407 | 17 |
838886 | 838886 | 2020-12-17 | San Jacinto | Texas | 48407 | 407 | 17 |
835640 | 835640 | 2020-12-16 | San Jacinto | Texas | 48407 | 404 | 17 |
832394 | 832394 | 2020-12-15 | San Jacinto | Texas | 48407 | 401 | 17 |
829147 | 829147 | 2020-12-14 | San Jacinto | Texas | 48407 | 396 | 16 |
825901 | 825901 | 2020-12-13 | San Jacinto | Texas | 48407 | 395 | 16 |
822654 | 822654 | 2020-12-12 | San Jacinto | Texas | 48407 | 395 | 16 |
819408 | 819408 | 2020-12-11 | San Jacinto | Texas | 48407 | 393 | 16 |
816162 | 816162 | 2020-12-10 | San Jacinto | Texas | 48407 | 266 | 16 |
812916 | 812916 | 2020-12-09 | San Jacinto | Texas | 48407 | 266 | 16 |
809672 | 809672 | 2020-12-08 | San Jacinto | Texas | 48407 | 264 | 15 |
806427 | 806427 | 2020-12-07 | San Jacinto | Texas | 48407 | 261 | 15 |
803182 | 803182 | 2020-12-06 | San Jacinto | Texas | 48407 | 261 | 15 |
799937 | 799937 | 2020-12-05 | San Jacinto | Texas | 48407 | 261 | 15 |
796692 | 796692 | 2020-12-04 | San Jacinto | Texas | 48407 | 261 | 15 |
793447 | 793447 | 2020-12-03 | San Jacinto | Texas | 48407 | 258 | 15 |
790202 | 790202 | 2020-12-02 | San Jacinto | Texas | 48407 | 257 | 15 |
786957 | 786957 | 2020-12-01 | San Jacinto | Texas | 48407 | 257 | 15 |
783713 | 783713 | 2020-11-30 | San Jacinto | Texas | 48407 | 257 | 15 |
780468 | 780468 | 2020-11-29 | San Jacinto | Texas | 48407 | 257 | 15 |
777222 | 777222 | 2020-11-28 | San Jacinto | Texas | 48407 | 257 | 15 |
773977 | 773977 | 2020-11-27 | San Jacinto | Texas | 48407 | 256 | 15 |
770732 | 770732 | 2020-11-26 | San Jacinto | Texas | 48407 | 256 | 15 |
767486 | 767486 | 2020-11-25 | San Jacinto | Texas | 48407 | 255 | 15 |
764241 | 764241 | 2020-11-24 | San Jacinto | Texas | 48407 | 253 | 14 |
760996 | 760996 | 2020-11-23 | San Jacinto | Texas | 48407 | 251 | 14 |
757751 | 757751 | 2020-11-22 | San Jacinto | Texas | 48407 | 251 | 14 |
754504 | 754504 | 2020-11-21 | San Jacinto | Texas | 48407 | 250 | 14 |
751258 | 751258 | 2020-11-20 | San Jacinto | Texas | 48407 | 250 | 14 |
748012 | 748012 | 2020-11-19 | San Jacinto | Texas | 48407 | 250 | 14 |
744766 | 744766 | 2020-11-18 | San Jacinto | Texas | 48407 | 250 | 14 |
741519 | 741519 | 2020-11-17 | San Jacinto | Texas | 48407 | 250 | 14 |
738272 | 738272 | 2020-11-16 | San Jacinto | Texas | 48407 | 250 | 14 |
735028 | 735028 | 2020-11-15 | San Jacinto | Texas | 48407 | 250 | 14 |
731782 | 731782 | 2020-11-14 | San Jacinto | Texas | 48407 | 248 | 14 |
728537 | 728537 | 2020-11-13 | San Jacinto | Texas | 48407 | 248 | 14 |
725294 | 725294 | 2020-11-12 | San Jacinto | Texas | 48407 | 245 | 14 |
722051 | 722051 | 2020-11-11 | San Jacinto | Texas | 48407 | 245 | 14 |
718808 | 718808 | 2020-11-10 | San Jacinto | Texas | 48407 | 245 | 14 |
715565 | 715565 | 2020-11-09 | San Jacinto | Texas | 48407 | 245 | 14 |
712321 | 712321 | 2020-11-08 | San Jacinto | Texas | 48407 | 245 | 14 |
709077 | 709077 | 2020-11-07 | San Jacinto | Texas | 48407 | 245 | 14 |
705833 | 705833 | 2020-11-06 | San Jacinto | Texas | 48407 | 245 | 14 |
702590 | 702590 | 2020-11-05 | San Jacinto | Texas | 48407 | 244 | 14 |
699347 | 699347 | 2020-11-04 | San Jacinto | Texas | 48407 | 242 | 14 |
696103 | 696103 | 2020-11-03 | San Jacinto | Texas | 48407 | 242 | 13 |
692861 | 692861 | 2020-11-02 | San Jacinto | Texas | 48407 | 242 | 13 |
689617 | 689617 | 2020-11-01 | San Jacinto | Texas | 48407 | 242 | 13 |
686372 | 686372 | 2020-10-31 | San Jacinto | Texas | 48407 | 242 | 13 |
683129 | 683129 | 2020-10-30 | San Jacinto | Texas | 48407 | 241 | 13 |
679886 | 679886 | 2020-10-29 | San Jacinto | Texas | 48407 | 240 | 13 |
676643 | 676643 | 2020-10-28 | San Jacinto | Texas | 48407 | 239 | 13 |
673400 | 673400 | 2020-10-27 | San Jacinto | Texas | 48407 | 238 | 12 |
670158 | 670158 | 2020-10-26 | San Jacinto | Texas | 48407 | 237 | 11 |
666915 | 666915 | 2020-10-25 | San Jacinto | Texas | 48407 | 236 | 11 |
663670 | 663670 | 2020-10-24 | San Jacinto | Texas | 48407 | 236 | 11 |
660426 | 660426 | 2020-10-23 | San Jacinto | Texas | 48407 | 236 | 11 |
657182 | 657182 | 2020-10-22 | San Jacinto | Texas | 48407 | 236 | 11 |
653937 | 653937 | 2020-10-21 | San Jacinto | Texas | 48407 | 236 | 11 |
650692 | 650692 | 2020-10-20 | San Jacinto | Texas | 48407 | 236 | 11 |
647448 | 647448 | 2020-10-19 | San Jacinto | Texas | 48407 | 235 | 11 |
644202 | 644202 | 2020-10-18 | San Jacinto | Texas | 48407 | 231 | 11 |
640954 | 640954 | 2020-10-17 | San Jacinto | Texas | 48407 | 231 | 11 |
637707 | 637707 | 2020-10-16 | San Jacinto | Texas | 48407 | 230 | 11 |
634462 | 634462 | 2020-10-15 | San Jacinto | Texas | 48407 | 230 | 11 |
631217 | 631217 | 2020-10-14 | San Jacinto | Texas | 48407 | 229 | 11 |
627973 | 627973 | 2020-10-13 | San Jacinto | Texas | 48407 | 229 | 11 |
624730 | 624730 | 2020-10-12 | San Jacinto | Texas | 48407 | 229 | 11 |
621487 | 621487 | 2020-10-11 | San Jacinto | Texas | 48407 | 229 | 11 |
618244 | 618244 | 2020-10-10 | San Jacinto | Texas | 48407 | 229 | 11 |
615002 | 615002 | 2020-10-09 | San Jacinto | Texas | 48407 | 229 | 11 |
611761 | 611761 | 2020-10-08 | San Jacinto | Texas | 48407 | 228 | 11 |
608519 | 608519 | 2020-10-07 | San Jacinto | Texas | 48407 | 228 | 11 |
605276 | 605276 | 2020-10-06 | San Jacinto | Texas | 48407 | 228 | 9 |
602034 | 602034 | 2020-10-05 | San Jacinto | Texas | 48407 | 228 | 9 |
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);