ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48167 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923142 | 923142 | 2021-01-12 | Galveston | Texas | 48167 | 24548 | 234 |
919897 | 919897 | 2021-01-11 | Galveston | Texas | 48167 | 24028 | 231 |
916652 | 916652 | 2021-01-10 | Galveston | Texas | 48167 | 24028 | 231 |
913407 | 913407 | 2021-01-09 | Galveston | Texas | 48167 | 23755 | 230 |
910162 | 910162 | 2021-01-08 | Galveston | Texas | 48167 | 23485 | 227 |
906917 | 906917 | 2021-01-07 | Galveston | Texas | 48167 | 23176 | 226 |
903671 | 903671 | 2021-01-06 | Galveston | Texas | 48167 | 22980 | 225 |
900426 | 900426 | 2021-01-05 | Galveston | Texas | 48167 | 22697 | 222 |
897181 | 897181 | 2021-01-04 | Galveston | Texas | 48167 | 22338 | 221 |
893935 | 893935 | 2021-01-03 | Galveston | Texas | 48167 | 22338 | 221 |
890689 | 890689 | 2021-01-02 | Galveston | Texas | 48167 | 21725 | 221 |
887442 | 887442 | 2021-01-01 | Galveston | Texas | 48167 | 21725 | 220 |
884197 | 884197 | 2020-12-31 | Galveston | Texas | 48167 | 21429 | 217 |
880952 | 880952 | 2020-12-30 | Galveston | Texas | 48167 | 21117 | 216 |
877707 | 877707 | 2020-12-29 | Galveston | Texas | 48167 | 20874 | 214 |
874462 | 874462 | 2020-12-28 | Galveston | Texas | 48167 | 20655 | 211 |
871217 | 871217 | 2020-12-27 | Galveston | Texas | 48167 | 20655 | 211 |
867972 | 867972 | 2020-12-26 | Galveston | Texas | 48167 | 19806 | 211 |
864727 | 864727 | 2020-12-25 | Galveston | Texas | 48167 | 19806 | 211 |
861482 | 861482 | 2020-12-24 | Galveston | Texas | 48167 | 19806 | 205 |
858237 | 858237 | 2020-12-23 | Galveston | Texas | 48167 | 19428 | 205 |
854992 | 854992 | 2020-12-22 | Galveston | Texas | 48167 | 18880 | 204 |
851747 | 851747 | 2020-12-21 | Galveston | Texas | 48167 | 18606 | 200 |
848502 | 848502 | 2020-12-20 | Galveston | Texas | 48167 | 18606 | 200 |
845257 | 845257 | 2020-12-19 | Galveston | Texas | 48167 | 18355 | 198 |
842011 | 842011 | 2020-12-18 | Galveston | Texas | 48167 | 18170 | 198 |
838766 | 838766 | 2020-12-17 | Galveston | Texas | 48167 | 17983 | 196 |
835520 | 835520 | 2020-12-16 | Galveston | Texas | 48167 | 17753 | 196 |
832274 | 832274 | 2020-12-15 | Galveston | Texas | 48167 | 17629 | 196 |
829027 | 829027 | 2020-12-14 | Galveston | Texas | 48167 | 17362 | 195 |
825781 | 825781 | 2020-12-13 | Galveston | Texas | 48167 | 17362 | 195 |
822534 | 822534 | 2020-12-12 | Galveston | Texas | 48167 | 17131 | 195 |
819288 | 819288 | 2020-12-11 | Galveston | Texas | 48167 | 16909 | 194 |
816042 | 816042 | 2020-12-10 | Galveston | Texas | 48167 | 16126 | 193 |
812796 | 812796 | 2020-12-09 | Galveston | Texas | 48167 | 16005 | 191 |
809552 | 809552 | 2020-12-08 | Galveston | Texas | 48167 | 15857 | 189 |
806307 | 806307 | 2020-12-07 | Galveston | Texas | 48167 | 15776 | 188 |
803062 | 803062 | 2020-12-06 | Galveston | Texas | 48167 | 15537 | 188 |
799817 | 799817 | 2020-12-05 | Galveston | Texas | 48167 | 15537 | 187 |
796572 | 796572 | 2020-12-04 | Galveston | Texas | 48167 | 15348 | 186 |
793327 | 793327 | 2020-12-03 | Galveston | Texas | 48167 | 15240 | 185 |
790082 | 790082 | 2020-12-02 | Galveston | Texas | 48167 | 15113 | 183 |
786837 | 786837 | 2020-12-01 | Galveston | Texas | 48167 | 14976 | 181 |
783593 | 783593 | 2020-11-30 | Galveston | Texas | 48167 | 14961 | 180 |
780348 | 780348 | 2020-11-29 | Galveston | Texas | 48167 | 14691 | 180 |
777102 | 777102 | 2020-11-28 | Galveston | Texas | 48167 | 14691 | 180 |
773857 | 773857 | 2020-11-27 | Galveston | Texas | 48167 | 14635 | 180 |
770612 | 770612 | 2020-11-26 | Galveston | Texas | 48167 | 14465 | 180 |
767366 | 767366 | 2020-11-25 | Galveston | Texas | 48167 | 14465 | 179 |
764121 | 764121 | 2020-11-24 | Galveston | Texas | 48167 | 14388 | 179 |
760876 | 760876 | 2020-11-23 | Galveston | Texas | 48167 | 14259 | 178 |
757631 | 757631 | 2020-11-22 | Galveston | Texas | 48167 | 14126 | 178 |
754384 | 754384 | 2020-11-21 | Galveston | Texas | 48167 | 14126 | 178 |
751138 | 751138 | 2020-11-20 | Galveston | Texas | 48167 | 14020 | 177 |
747892 | 747892 | 2020-11-19 | Galveston | Texas | 48167 | 13922 | 177 |
744646 | 744646 | 2020-11-18 | Galveston | Texas | 48167 | 13827 | 176 |
741399 | 741399 | 2020-11-17 | Galveston | Texas | 48167 | 13760 | 174 |
738153 | 738153 | 2020-11-16 | Galveston | Texas | 48167 | 13696 | 174 |
734909 | 734909 | 2020-11-15 | Galveston | Texas | 48167 | 13570 | 174 |
731663 | 731663 | 2020-11-14 | Galveston | Texas | 48167 | 13570 | 172 |
728418 | 728418 | 2020-11-13 | Galveston | Texas | 48167 | 13457 | 172 |
725175 | 725175 | 2020-11-12 | Galveston | Texas | 48167 | 13392 | 171 |
721932 | 721932 | 2020-11-11 | Galveston | Texas | 48167 | 13260 | 171 |
718689 | 718689 | 2020-11-10 | Galveston | Texas | 48167 | 13260 | 171 |
715446 | 715446 | 2020-11-09 | Galveston | Texas | 48167 | 13194 | 171 |
712202 | 712202 | 2020-11-08 | Galveston | Texas | 48167 | 13078 | 171 |
708958 | 708958 | 2020-11-07 | Galveston | Texas | 48167 | 13078 | 170 |
705714 | 705714 | 2020-11-06 | Galveston | Texas | 48167 | 13023 | 170 |
702471 | 702471 | 2020-11-05 | Galveston | Texas | 48167 | 12979 | 169 |
699228 | 699228 | 2020-11-04 | Galveston | Texas | 48167 | 12910 | 169 |
695984 | 695984 | 2020-11-03 | Galveston | Texas | 48167 | 12857 | 169 |
692742 | 692742 | 2020-11-02 | Galveston | Texas | 48167 | 12787 | 169 |
689498 | 689498 | 2020-11-01 | Galveston | Texas | 48167 | 12703 | 169 |
686253 | 686253 | 2020-10-31 | Galveston | Texas | 48167 | 12703 | 169 |
683010 | 683010 | 2020-10-30 | Galveston | Texas | 48167 | 12663 | 169 |
679767 | 679767 | 2020-10-29 | Galveston | Texas | 48167 | 12606 | 169 |
676524 | 676524 | 2020-10-28 | Galveston | Texas | 48167 | 12533 | 169 |
673281 | 673281 | 2020-10-27 | Galveston | Texas | 48167 | 12490 | 169 |
670039 | 670039 | 2020-10-26 | Galveston | Texas | 48167 | 12404 | 169 |
666796 | 666796 | 2020-10-25 | Galveston | Texas | 48167 | 12368 | 169 |
663551 | 663551 | 2020-10-24 | Galveston | Texas | 48167 | 12368 | 169 |
660307 | 660307 | 2020-10-23 | Galveston | Texas | 48167 | 12297 | 168 |
657063 | 657063 | 2020-10-22 | Galveston | Texas | 48167 | 12262 | 168 |
653818 | 653818 | 2020-10-21 | Galveston | Texas | 48167 | 12222 | 168 |
650573 | 650573 | 2020-10-20 | Galveston | Texas | 48167 | 12172 | 168 |
647329 | 647329 | 2020-10-19 | Galveston | Texas | 48167 | 12123 | 166 |
644083 | 644083 | 2020-10-18 | Galveston | Texas | 48167 | 12090 | 166 |
640835 | 640835 | 2020-10-17 | Galveston | Texas | 48167 | 12090 | 166 |
637588 | 637588 | 2020-10-16 | Galveston | Texas | 48167 | 12046 | 166 |
634343 | 634343 | 2020-10-15 | Galveston | Texas | 48167 | 12015 | 166 |
631098 | 631098 | 2020-10-14 | Galveston | Texas | 48167 | 12005 | 166 |
627854 | 627854 | 2020-10-13 | Galveston | Texas | 48167 | 11979 | 166 |
624612 | 624612 | 2020-10-12 | Galveston | Texas | 48167 | 11954 | 165 |
621369 | 621369 | 2020-10-11 | Galveston | Texas | 48167 | 11930 | 165 |
618126 | 618126 | 2020-10-10 | Galveston | Texas | 48167 | 11930 | 165 |
614884 | 614884 | 2020-10-09 | Galveston | Texas | 48167 | 11901 | 165 |
611643 | 611643 | 2020-10-08 | Galveston | Texas | 48167 | 11878 | 165 |
608401 | 608401 | 2020-10-07 | Galveston | Texas | 48167 | 11851 | 165 |
605158 | 605158 | 2020-10-06 | Galveston | Texas | 48167 | 11833 | 164 |
601916 | 601916 | 2020-10-05 | Galveston | Texas | 48167 | 11807 | 164 |
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);