ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48453 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923285 | 923285 | 2021-01-12 | Travis | Texas | 48453 | 56825 | 584 |
920040 | 920040 | 2021-01-11 | Travis | Texas | 48453 | 56825 | 581 |
916795 | 916795 | 2021-01-10 | Travis | Texas | 48453 | 55870 | 581 |
913550 | 913550 | 2021-01-09 | Travis | Texas | 48453 | 55870 | 579 |
910305 | 910305 | 2021-01-08 | Travis | Texas | 48453 | 55406 | 576 |
907060 | 907060 | 2021-01-07 | Travis | Texas | 48453 | 54814 | 565 |
903814 | 903814 | 2021-01-06 | Travis | Texas | 48453 | 53935 | 564 |
900569 | 900569 | 2021-01-05 | Travis | Texas | 48453 | 53272 | 561 |
897324 | 897324 | 2021-01-04 | Travis | Texas | 48453 | 52708 | 554 |
894078 | 894078 | 2021-01-03 | Travis | Texas | 48453 | 51956 | 551 |
890832 | 890832 | 2021-01-02 | Travis | Texas | 48453 | 51558 | 550 |
887585 | 887585 | 2021-01-01 | Travis | Texas | 48453 | 50595 | 549 |
884340 | 884340 | 2020-12-31 | Travis | Texas | 48453 | 50595 | 549 |
881095 | 881095 | 2020-12-30 | Travis | Texas | 48453 | 50194 | 548 |
877850 | 877850 | 2020-12-29 | Travis | Texas | 48453 | 49648 | 544 |
874605 | 874605 | 2020-12-28 | Travis | Texas | 48453 | 48951 | 542 |
871360 | 871360 | 2020-12-27 | Travis | Texas | 48453 | 48424 | 532 |
868115 | 868115 | 2020-12-26 | Travis | Texas | 48453 | 48208 | 531 |
864870 | 864870 | 2020-12-25 | Travis | Texas | 48453 | 47076 | 528 |
861625 | 861625 | 2020-12-24 | Travis | Texas | 48453 | 47076 | 528 |
858380 | 858380 | 2020-12-23 | Travis | Texas | 48453 | 47076 | 528 |
855135 | 855135 | 2020-12-22 | Travis | Texas | 48453 | 46701 | 525 |
851890 | 851890 | 2020-12-21 | Travis | Texas | 48453 | 46029 | 522 |
848645 | 848645 | 2020-12-20 | Travis | Texas | 48453 | 45492 | 516 |
845400 | 845400 | 2020-12-19 | Travis | Texas | 48453 | 45070 | 516 |
842154 | 842154 | 2020-12-18 | Travis | Texas | 48453 | 44796 | 516 |
838909 | 838909 | 2020-12-17 | Travis | Texas | 48453 | 44381 | 512 |
835663 | 835663 | 2020-12-16 | Travis | Texas | 48453 | 43836 | 511 |
832417 | 832417 | 2020-12-15 | Travis | Texas | 48453 | 43469 | 507 |
829170 | 829170 | 2020-12-14 | Travis | Texas | 48453 | 42856 | 507 |
825924 | 825924 | 2020-12-13 | Travis | Texas | 48453 | 42441 | 505 |
822677 | 822677 | 2020-12-12 | Travis | Texas | 48453 | 42136 | 505 |
819431 | 819431 | 2020-12-11 | Travis | Texas | 48453 | 41901 | 504 |
816185 | 816185 | 2020-12-10 | Travis | Texas | 48453 | 41519 | 502 |
812939 | 812939 | 2020-12-09 | Travis | Texas | 48453 | 41092 | 499 |
809695 | 809695 | 2020-12-08 | Travis | Texas | 48453 | 40836 | 496 |
806450 | 806450 | 2020-12-07 | Travis | Texas | 48453 | 40481 | 495 |
803205 | 803205 | 2020-12-06 | Travis | Texas | 48453 | 40209 | 494 |
799960 | 799960 | 2020-12-05 | Travis | Texas | 48453 | 39925 | 494 |
796715 | 796715 | 2020-12-04 | Travis | Texas | 48453 | 39566 | 493 |
793470 | 793470 | 2020-12-03 | Travis | Texas | 48453 | 39267 | 492 |
790225 | 790225 | 2020-12-02 | Travis | Texas | 48453 | 39037 | 486 |
786980 | 786980 | 2020-12-01 | Travis | Texas | 48453 | 38757 | 484 |
783736 | 783736 | 2020-11-30 | Travis | Texas | 48453 | 38377 | 483 |
780491 | 780491 | 2020-11-29 | Travis | Texas | 48453 | 38045 | 483 |
777245 | 777245 | 2020-11-28 | Travis | Texas | 48453 | 37898 | 483 |
774000 | 774000 | 2020-11-27 | Travis | Texas | 48453 | 37666 | 483 |
770755 | 770755 | 2020-11-26 | Travis | Texas | 48453 | 37238 | 483 |
767509 | 767509 | 2020-11-25 | Travis | Texas | 48453 | 37238 | 483 |
764264 | 764264 | 2020-11-24 | Travis | Texas | 48453 | 37120 | 478 |
761019 | 761019 | 2020-11-23 | Travis | Texas | 48453 | 36754 | 476 |
757774 | 757774 | 2020-11-22 | Travis | Texas | 48453 | 36436 | 476 |
754527 | 754527 | 2020-11-21 | Travis | Texas | 48453 | 36175 | 476 |
751281 | 751281 | 2020-11-20 | Travis | Texas | 48453 | 35984 | 476 |
748035 | 748035 | 2020-11-19 | Travis | Texas | 48453 | 35616 | 473 |
744789 | 744789 | 2020-11-18 | Travis | Texas | 48453 | 35326 | 469 |
741542 | 741542 | 2020-11-17 | Travis | Texas | 48453 | 35020 | 469 |
738295 | 738295 | 2020-11-16 | Travis | Texas | 48453 | 34769 | 466 |
735051 | 735051 | 2020-11-15 | Travis | Texas | 48453 | 34612 | 466 |
731805 | 731805 | 2020-11-14 | Travis | Texas | 48453 | 34504 | 466 |
728560 | 728560 | 2020-11-13 | Travis | Texas | 48453 | 34204 | 465 |
725317 | 725317 | 2020-11-12 | Travis | Texas | 48453 | 33960 | 465 |
722074 | 722074 | 2020-11-11 | Travis | Texas | 48453 | 33769 | 462 |
718831 | 718831 | 2020-11-10 | Travis | Texas | 48453 | 33559 | 461 |
715588 | 715588 | 2020-11-09 | Travis | Texas | 48453 | 33382 | 457 |
712344 | 712344 | 2020-11-08 | Travis | Texas | 48453 | 33168 | 457 |
709100 | 709100 | 2020-11-07 | Travis | Texas | 48453 | 33016 | 457 |
705856 | 705856 | 2020-11-06 | Travis | Texas | 48453 | 32928 | 457 |
702613 | 702613 | 2020-11-05 | Travis | Texas | 48453 | 32748 | 456 |
699370 | 699370 | 2020-11-04 | Travis | Texas | 48453 | 32605 | 456 |
696126 | 696126 | 2020-11-03 | Travis | Texas | 48453 | 32451 | 456 |
692884 | 692884 | 2020-11-02 | Travis | Texas | 48453 | 32303 | 454 |
689640 | 689640 | 2020-11-01 | Travis | Texas | 48453 | 32220 | 452 |
686395 | 686395 | 2020-10-31 | Travis | Texas | 48453 | 32143 | 452 |
683152 | 683152 | 2020-10-30 | Travis | Texas | 48453 | 32024 | 451 |
679909 | 679909 | 2020-10-29 | Travis | Texas | 48453 | 31943 | 450 |
676666 | 676666 | 2020-10-28 | Travis | Texas | 48453 | 31851 | 449 |
673423 | 673423 | 2020-10-27 | Travis | Texas | 48453 | 31775 | 449 |
670181 | 670181 | 2020-10-26 | Travis | Texas | 48453 | 31653 | 449 |
666938 | 666938 | 2020-10-25 | Travis | Texas | 48453 | 31551 | 449 |
663693 | 663693 | 2020-10-24 | Travis | Texas | 48453 | 31493 | 449 |
660449 | 660449 | 2020-10-23 | Travis | Texas | 48453 | 31411 | 448 |
657205 | 657205 | 2020-10-22 | Travis | Texas | 48453 | 31327 | 448 |
653960 | 653960 | 2020-10-21 | Travis | Texas | 48453 | 31228 | 448 |
650715 | 650715 | 2020-10-20 | Travis | Texas | 48453 | 31159 | 448 |
647471 | 647471 | 2020-10-19 | Travis | Texas | 48453 | 31053 | 446 |
644225 | 644225 | 2020-10-18 | Travis | Texas | 48453 | 30956 | 445 |
640977 | 640977 | 2020-10-17 | Travis | Texas | 48453 | 30908 | 445 |
637730 | 637730 | 2020-10-16 | Travis | Texas | 48453 | 30797 | 443 |
634485 | 634485 | 2020-10-15 | Travis | Texas | 48453 | 30688 | 442 |
631240 | 631240 | 2020-10-14 | Travis | Texas | 48453 | 30601 | 442 |
627996 | 627996 | 2020-10-13 | Travis | Texas | 48453 | 30398 | 442 |
624753 | 624753 | 2020-10-12 | Travis | Texas | 48453 | 30398 | 442 |
621510 | 621510 | 2020-10-11 | Travis | Texas | 48453 | 30265 | 441 |
618267 | 618267 | 2020-10-10 | Travis | Texas | 48453 | 30199 | 441 |
615025 | 615025 | 2020-10-09 | Travis | Texas | 48453 | 30165 | 441 |
611784 | 611784 | 2020-10-08 | Travis | Texas | 48453 | 30075 | 437 |
608542 | 608542 | 2020-10-07 | Travis | Texas | 48453 | 29997 | 436 |
605299 | 605299 | 2020-10-06 | Travis | Texas | 48453 | 29952 | 434 |
602057 | 602057 | 2020-10-05 | Travis | Texas | 48453 | 29857 | 430 |
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);