ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
747 rows where fips = 48101 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923109 | 923109 | 2021-01-12 | Cottle | Texas | 48101 | 170 | 6 |
919864 | 919864 | 2021-01-11 | Cottle | Texas | 48101 | 168 | 6 |
916619 | 916619 | 2021-01-10 | Cottle | Texas | 48101 | 168 | 6 |
913374 | 913374 | 2021-01-09 | Cottle | Texas | 48101 | 168 | 6 |
910129 | 910129 | 2021-01-08 | Cottle | Texas | 48101 | 166 | 6 |
906884 | 906884 | 2021-01-07 | Cottle | Texas | 48101 | 166 | 6 |
903638 | 903638 | 2021-01-06 | Cottle | Texas | 48101 | 166 | 5 |
900393 | 900393 | 2021-01-05 | Cottle | Texas | 48101 | 165 | 5 |
897148 | 897148 | 2021-01-04 | Cottle | Texas | 48101 | 152 | 5 |
893902 | 893902 | 2021-01-03 | Cottle | Texas | 48101 | 152 | 5 |
890656 | 890656 | 2021-01-02 | Cottle | Texas | 48101 | 152 | 5 |
887409 | 887409 | 2021-01-01 | Cottle | Texas | 48101 | 152 | 5 |
884164 | 884164 | 2020-12-31 | Cottle | Texas | 48101 | 152 | 5 |
880919 | 880919 | 2020-12-30 | Cottle | Texas | 48101 | 150 | 5 |
877674 | 877674 | 2020-12-29 | Cottle | Texas | 48101 | 145 | 5 |
874429 | 874429 | 2020-12-28 | Cottle | Texas | 48101 | 140 | 5 |
871184 | 871184 | 2020-12-27 | Cottle | Texas | 48101 | 140 | 5 |
867939 | 867939 | 2020-12-26 | Cottle | Texas | 48101 | 139 | 5 |
864694 | 864694 | 2020-12-25 | Cottle | Texas | 48101 | 139 | 5 |
861449 | 861449 | 2020-12-24 | Cottle | Texas | 48101 | 139 | 5 |
858204 | 858204 | 2020-12-23 | Cottle | Texas | 48101 | 139 | 5 |
854959 | 854959 | 2020-12-22 | Cottle | Texas | 48101 | 139 | 5 |
851714 | 851714 | 2020-12-21 | Cottle | Texas | 48101 | 133 | 5 |
848469 | 848469 | 2020-12-20 | Cottle | Texas | 48101 | 133 | 5 |
845224 | 845224 | 2020-12-19 | Cottle | Texas | 48101 | 133 | 5 |
841978 | 841978 | 2020-12-18 | Cottle | Texas | 48101 | 129 | 5 |
838733 | 838733 | 2020-12-17 | Cottle | Texas | 48101 | 128 | 5 |
835487 | 835487 | 2020-12-16 | Cottle | Texas | 48101 | 124 | 5 |
832241 | 832241 | 2020-12-15 | Cottle | Texas | 48101 | 124 | 5 |
828994 | 828994 | 2020-12-14 | Cottle | Texas | 48101 | 117 | 5 |
825748 | 825748 | 2020-12-13 | Cottle | Texas | 48101 | 117 | 5 |
822501 | 822501 | 2020-12-12 | Cottle | Texas | 48101 | 117 | 5 |
819255 | 819255 | 2020-12-11 | Cottle | Texas | 48101 | 116 | 5 |
816009 | 816009 | 2020-12-10 | Cottle | Texas | 48101 | 70 | 5 |
812763 | 812763 | 2020-12-09 | Cottle | Texas | 48101 | 70 | 5 |
809519 | 809519 | 2020-12-08 | Cottle | Texas | 48101 | 70 | 4 |
806274 | 806274 | 2020-12-07 | Cottle | Texas | 48101 | 68 | 4 |
803029 | 803029 | 2020-12-06 | Cottle | Texas | 48101 | 68 | 4 |
799784 | 799784 | 2020-12-05 | Cottle | Texas | 48101 | 68 | 4 |
796539 | 796539 | 2020-12-04 | Cottle | Texas | 48101 | 68 | 4 |
793294 | 793294 | 2020-12-03 | Cottle | Texas | 48101 | 65 | 4 |
790049 | 790049 | 2020-12-02 | Cottle | Texas | 48101 | 63 | 4 |
786804 | 786804 | 2020-12-01 | Cottle | Texas | 48101 | 58 | 4 |
783560 | 783560 | 2020-11-30 | Cottle | Texas | 48101 | 58 | 4 |
780315 | 780315 | 2020-11-29 | Cottle | Texas | 48101 | 58 | 4 |
777069 | 777069 | 2020-11-28 | Cottle | Texas | 48101 | 56 | 4 |
773824 | 773824 | 2020-11-27 | Cottle | Texas | 48101 | 56 | 4 |
770579 | 770579 | 2020-11-26 | Cottle | Texas | 48101 | 56 | 4 |
767333 | 767333 | 2020-11-25 | Cottle | Texas | 48101 | 53 | 4 |
764088 | 764088 | 2020-11-24 | Cottle | Texas | 48101 | 53 | 4 |
760843 | 760843 | 2020-11-23 | Cottle | Texas | 48101 | 52 | 4 |
757598 | 757598 | 2020-11-22 | Cottle | Texas | 48101 | 52 | 4 |
754351 | 754351 | 2020-11-21 | Cottle | Texas | 48101 | 52 | 4 |
751105 | 751105 | 2020-11-20 | Cottle | Texas | 48101 | 52 | 4 |
747859 | 747859 | 2020-11-19 | Cottle | Texas | 48101 | 49 | 4 |
744613 | 744613 | 2020-11-18 | Cottle | Texas | 48101 | 48 | 4 |
741366 | 741366 | 2020-11-17 | Cottle | Texas | 48101 | 45 | 4 |
738120 | 738120 | 2020-11-16 | Cottle | Texas | 48101 | 45 | 4 |
734876 | 734876 | 2020-11-15 | Cottle | Texas | 48101 | 45 | 4 |
731630 | 731630 | 2020-11-14 | Cottle | Texas | 48101 | 45 | 4 |
728385 | 728385 | 2020-11-13 | Cottle | Texas | 48101 | 45 | 4 |
725142 | 725142 | 2020-11-12 | Cottle | Texas | 48101 | 45 | 4 |
721899 | 721899 | 2020-11-11 | Cottle | Texas | 48101 | 45 | 4 |
718656 | 718656 | 2020-11-10 | Cottle | Texas | 48101 | 45 | 3 |
715413 | 715413 | 2020-11-09 | Cottle | Texas | 48101 | 44 | 3 |
712169 | 712169 | 2020-11-08 | Cottle | Texas | 48101 | 44 | 3 |
708925 | 708925 | 2020-11-07 | Cottle | Texas | 48101 | 44 | 3 |
705681 | 705681 | 2020-11-06 | Cottle | Texas | 48101 | 44 | 3 |
702438 | 702438 | 2020-11-05 | Cottle | Texas | 48101 | 42 | 3 |
699195 | 699195 | 2020-11-04 | Cottle | Texas | 48101 | 42 | 3 |
695951 | 695951 | 2020-11-03 | Cottle | Texas | 48101 | 42 | 3 |
692709 | 692709 | 2020-11-02 | Cottle | Texas | 48101 | 40 | 3 |
689465 | 689465 | 2020-11-01 | Cottle | Texas | 48101 | 40 | 3 |
686220 | 686220 | 2020-10-31 | Cottle | Texas | 48101 | 40 | 3 |
682977 | 682977 | 2020-10-30 | Cottle | Texas | 48101 | 40 | 3 |
679734 | 679734 | 2020-10-29 | Cottle | Texas | 48101 | 40 | 3 |
676491 | 676491 | 2020-10-28 | Cottle | Texas | 48101 | 40 | 3 |
673248 | 673248 | 2020-10-27 | Cottle | Texas | 48101 | 39 | 3 |
670006 | 670006 | 2020-10-26 | Cottle | Texas | 48101 | 35 | 3 |
666763 | 666763 | 2020-10-25 | Cottle | Texas | 48101 | 35 | 3 |
663518 | 663518 | 2020-10-24 | Cottle | Texas | 48101 | 35 | 3 |
660274 | 660274 | 2020-10-23 | Cottle | Texas | 48101 | 33 | 3 |
657030 | 657030 | 2020-10-22 | Cottle | Texas | 48101 | 33 | 3 |
653785 | 653785 | 2020-10-21 | Cottle | Texas | 48101 | 33 | 3 |
650540 | 650540 | 2020-10-20 | Cottle | Texas | 48101 | 33 | 3 |
647296 | 647296 | 2020-10-19 | Cottle | Texas | 48101 | 33 | 3 |
644050 | 644050 | 2020-10-18 | Cottle | Texas | 48101 | 33 | 3 |
640802 | 640802 | 2020-10-17 | Cottle | Texas | 48101 | 33 | 3 |
637555 | 637555 | 2020-10-16 | Cottle | Texas | 48101 | 33 | 3 |
634310 | 634310 | 2020-10-15 | Cottle | Texas | 48101 | 33 | 3 |
631065 | 631065 | 2020-10-14 | Cottle | Texas | 48101 | 33 | 3 |
627821 | 627821 | 2020-10-13 | Cottle | Texas | 48101 | 33 | 3 |
624579 | 624579 | 2020-10-12 | Cottle | Texas | 48101 | 32 | 3 |
621336 | 621336 | 2020-10-11 | Cottle | Texas | 48101 | 32 | 3 |
618093 | 618093 | 2020-10-10 | Cottle | Texas | 48101 | 32 | 3 |
614851 | 614851 | 2020-10-09 | Cottle | Texas | 48101 | 32 | 3 |
611610 | 611610 | 2020-10-08 | Cottle | Texas | 48101 | 32 | 3 |
608368 | 608368 | 2020-10-07 | Cottle | Texas | 48101 | 32 | 3 |
605125 | 605125 | 2020-10-06 | Cottle | Texas | 48101 | 32 | 3 |
601883 | 601883 | 2020-10-05 | Cottle | Texas | 48101 | 30 | 3 |
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);