ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48293 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923205 | 923205 | 2021-01-12 | Limestone | Texas | 48293 | 1352 | 32 |
919960 | 919960 | 2021-01-11 | Limestone | Texas | 48293 | 1352 | 32 |
916715 | 916715 | 2021-01-10 | Limestone | Texas | 48293 | 1351 | 32 |
913470 | 913470 | 2021-01-09 | Limestone | Texas | 48293 | 1347 | 32 |
910225 | 910225 | 2021-01-08 | Limestone | Texas | 48293 | 1336 | 32 |
906980 | 906980 | 2021-01-07 | Limestone | Texas | 48293 | 1334 | 31 |
903734 | 903734 | 2021-01-06 | Limestone | Texas | 48293 | 1328 | 31 |
900489 | 900489 | 2021-01-05 | Limestone | Texas | 48293 | 1308 | 29 |
897244 | 897244 | 2021-01-04 | Limestone | Texas | 48293 | 1286 | 28 |
893998 | 893998 | 2021-01-03 | Limestone | Texas | 48293 | 1286 | 28 |
890752 | 890752 | 2021-01-02 | Limestone | Texas | 48293 | 1283 | 28 |
887505 | 887505 | 2021-01-01 | Limestone | Texas | 48293 | 1283 | 28 |
884260 | 884260 | 2020-12-31 | Limestone | Texas | 48293 | 1251 | 28 |
881015 | 881015 | 2020-12-30 | Limestone | Texas | 48293 | 1237 | 26 |
877770 | 877770 | 2020-12-29 | Limestone | Texas | 48293 | 1231 | 23 |
874525 | 874525 | 2020-12-28 | Limestone | Texas | 48293 | 1199 | 22 |
871280 | 871280 | 2020-12-27 | Limestone | Texas | 48293 | 1198 | 22 |
868035 | 868035 | 2020-12-26 | Limestone | Texas | 48293 | 1198 | 22 |
864790 | 864790 | 2020-12-25 | Limestone | Texas | 48293 | 1198 | 22 |
861545 | 861545 | 2020-12-24 | Limestone | Texas | 48293 | 1198 | 22 |
858300 | 858300 | 2020-12-23 | Limestone | Texas | 48293 | 1180 | 22 |
855055 | 855055 | 2020-12-22 | Limestone | Texas | 48293 | 1167 | 22 |
851810 | 851810 | 2020-12-21 | Limestone | Texas | 48293 | 1148 | 21 |
848565 | 848565 | 2020-12-20 | Limestone | Texas | 48293 | 1148 | 21 |
845320 | 845320 | 2020-12-19 | Limestone | Texas | 48293 | 1148 | 21 |
842074 | 842074 | 2020-12-18 | Limestone | Texas | 48293 | 1144 | 21 |
838829 | 838829 | 2020-12-17 | Limestone | Texas | 48293 | 1119 | 20 |
835583 | 835583 | 2020-12-16 | Limestone | Texas | 48293 | 1107 | 20 |
832337 | 832337 | 2020-12-15 | Limestone | Texas | 48293 | 1080 | 20 |
829090 | 829090 | 2020-12-14 | Limestone | Texas | 48293 | 1069 | 20 |
825844 | 825844 | 2020-12-13 | Limestone | Texas | 48293 | 1069 | 20 |
822597 | 822597 | 2020-12-12 | Limestone | Texas | 48293 | 1067 | 20 |
819351 | 819351 | 2020-12-11 | Limestone | Texas | 48293 | 1042 | 20 |
816105 | 816105 | 2020-12-10 | Limestone | Texas | 48293 | 873 | 20 |
812859 | 812859 | 2020-12-09 | Limestone | Texas | 48293 | 858 | 20 |
809615 | 809615 | 2020-12-08 | Limestone | Texas | 48293 | 850 | 20 |
806370 | 806370 | 2020-12-07 | Limestone | Texas | 48293 | 848 | 20 |
803125 | 803125 | 2020-12-06 | Limestone | Texas | 48293 | 848 | 20 |
799880 | 799880 | 2020-12-05 | Limestone | Texas | 48293 | 848 | 20 |
796635 | 796635 | 2020-12-04 | Limestone | Texas | 48293 | 831 | 18 |
793390 | 793390 | 2020-12-03 | Limestone | Texas | 48293 | 815 | 18 |
790145 | 790145 | 2020-12-02 | Limestone | Texas | 48293 | 800 | 18 |
786900 | 786900 | 2020-12-01 | Limestone | Texas | 48293 | 794 | 18 |
783656 | 783656 | 2020-11-30 | Limestone | Texas | 48293 | 788 | 18 |
780411 | 780411 | 2020-11-29 | Limestone | Texas | 48293 | 788 | 18 |
777165 | 777165 | 2020-11-28 | Limestone | Texas | 48293 | 786 | 18 |
773920 | 773920 | 2020-11-27 | Limestone | Texas | 48293 | 780 | 18 |
770675 | 770675 | 2020-11-26 | Limestone | Texas | 48293 | 780 | 18 |
767429 | 767429 | 2020-11-25 | Limestone | Texas | 48293 | 779 | 18 |
764184 | 764184 | 2020-11-24 | Limestone | Texas | 48293 | 771 | 18 |
760939 | 760939 | 2020-11-23 | Limestone | Texas | 48293 | 764 | 18 |
757694 | 757694 | 2020-11-22 | Limestone | Texas | 48293 | 764 | 18 |
754447 | 754447 | 2020-11-21 | Limestone | Texas | 48293 | 764 | 18 |
751201 | 751201 | 2020-11-20 | Limestone | Texas | 48293 | 752 | 17 |
747955 | 747955 | 2020-11-19 | Limestone | Texas | 48293 | 748 | 17 |
744709 | 744709 | 2020-11-18 | Limestone | Texas | 48293 | 741 | 17 |
741462 | 741462 | 2020-11-17 | Limestone | Texas | 48293 | 708 | 16 |
738216 | 738216 | 2020-11-16 | Limestone | Texas | 48293 | 707 | 16 |
734972 | 734972 | 2020-11-15 | Limestone | Texas | 48293 | 706 | 16 |
731726 | 731726 | 2020-11-14 | Limestone | Texas | 48293 | 706 | 16 |
728481 | 728481 | 2020-11-13 | Limestone | Texas | 48293 | 698 | 16 |
725238 | 725238 | 2020-11-12 | Limestone | Texas | 48293 | 694 | 16 |
721995 | 721995 | 2020-11-11 | Limestone | Texas | 48293 | 701 | 16 |
718752 | 718752 | 2020-11-10 | Limestone | Texas | 48293 | 700 | 16 |
715509 | 715509 | 2020-11-09 | Limestone | Texas | 48293 | 699 | 16 |
712265 | 712265 | 2020-11-08 | Limestone | Texas | 48293 | 699 | 16 |
709021 | 709021 | 2020-11-07 | Limestone | Texas | 48293 | 698 | 16 |
705777 | 705777 | 2020-11-06 | Limestone | Texas | 48293 | 695 | 16 |
702534 | 702534 | 2020-11-05 | Limestone | Texas | 48293 | 695 | 16 |
699291 | 699291 | 2020-11-04 | Limestone | Texas | 48293 | 692 | 16 |
696047 | 696047 | 2020-11-03 | Limestone | Texas | 48293 | 688 | 16 |
692805 | 692805 | 2020-11-02 | Limestone | Texas | 48293 | 684 | 16 |
689561 | 689561 | 2020-11-01 | Limestone | Texas | 48293 | 684 | 16 |
686316 | 686316 | 2020-10-31 | Limestone | Texas | 48293 | 684 | 16 |
683073 | 683073 | 2020-10-30 | Limestone | Texas | 48293 | 681 | 16 |
679830 | 679830 | 2020-10-29 | Limestone | Texas | 48293 | 681 | 16 |
676587 | 676587 | 2020-10-28 | Limestone | Texas | 48293 | 679 | 16 |
673344 | 673344 | 2020-10-27 | Limestone | Texas | 48293 | 677 | 16 |
670102 | 670102 | 2020-10-26 | Limestone | Texas | 48293 | 673 | 16 |
666859 | 666859 | 2020-10-25 | Limestone | Texas | 48293 | 673 | 16 |
663614 | 663614 | 2020-10-24 | Limestone | Texas | 48293 | 671 | 16 |
660370 | 660370 | 2020-10-23 | Limestone | Texas | 48293 | 661 | 16 |
657126 | 657126 | 2020-10-22 | Limestone | Texas | 48293 | 659 | 16 |
653881 | 653881 | 2020-10-21 | Limestone | Texas | 48293 | 659 | 16 |
650636 | 650636 | 2020-10-20 | Limestone | Texas | 48293 | 664 | 16 |
647392 | 647392 | 2020-10-19 | Limestone | Texas | 48293 | 659 | 16 |
644146 | 644146 | 2020-10-18 | Limestone | Texas | 48293 | 659 | 16 |
640898 | 640898 | 2020-10-17 | Limestone | Texas | 48293 | 659 | 16 |
637651 | 637651 | 2020-10-16 | Limestone | Texas | 48293 | 658 | 16 |
634406 | 634406 | 2020-10-15 | Limestone | Texas | 48293 | 645 | 16 |
631161 | 631161 | 2020-10-14 | Limestone | Texas | 48293 | 639 | 15 |
627917 | 627917 | 2020-10-13 | Limestone | Texas | 48293 | 623 | 15 |
624674 | 624674 | 2020-10-12 | Limestone | Texas | 48293 | 618 | 15 |
621431 | 621431 | 2020-10-11 | Limestone | Texas | 48293 | 618 | 15 |
618188 | 618188 | 2020-10-10 | Limestone | Texas | 48293 | 618 | 15 |
614946 | 614946 | 2020-10-09 | Limestone | Texas | 48293 | 611 | 15 |
611705 | 611705 | 2020-10-08 | Limestone | Texas | 48293 | 605 | 15 |
608463 | 608463 | 2020-10-07 | Limestone | Texas | 48293 | 600 | 15 |
605220 | 605220 | 2020-10-06 | Limestone | Texas | 48293 | 594 | 15 |
601978 | 601978 | 2020-10-05 | Limestone | Texas | 48293 | 591 | 15 |
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);