ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 48183 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923150 | 923150 | 2021-01-12 | Gregg | Texas | 48183 | 7872 | 200 |
919905 | 919905 | 2021-01-11 | Gregg | Texas | 48183 | 7446 | 199 |
916660 | 916660 | 2021-01-10 | Gregg | Texas | 48183 | 7446 | 197 |
913415 | 913415 | 2021-01-09 | Gregg | Texas | 48183 | 7446 | 193 |
910170 | 910170 | 2021-01-08 | Gregg | Texas | 48183 | 7446 | 188 |
906925 | 906925 | 2021-01-07 | Gregg | Texas | 48183 | 7299 | 181 |
903679 | 903679 | 2021-01-06 | Gregg | Texas | 48183 | 7299 | 177 |
900434 | 900434 | 2021-01-05 | Gregg | Texas | 48183 | 7183 | 174 |
897189 | 897189 | 2021-01-04 | Gregg | Texas | 48183 | 7151 | 173 |
893943 | 893943 | 2021-01-03 | Gregg | Texas | 48183 | 6923 | 173 |
890697 | 890697 | 2021-01-02 | Gregg | Texas | 48183 | 6923 | 173 |
887450 | 887450 | 2021-01-01 | Gregg | Texas | 48183 | 6923 | 172 |
884205 | 884205 | 2020-12-31 | Gregg | Texas | 48183 | 6923 | 167 |
880960 | 880960 | 2020-12-30 | Gregg | Texas | 48183 | 6812 | 162 |
877715 | 877715 | 2020-12-29 | Gregg | Texas | 48183 | 6752 | 158 |
874470 | 874470 | 2020-12-28 | Gregg | Texas | 48183 | 6728 | 155 |
871225 | 871225 | 2020-12-27 | Gregg | Texas | 48183 | 6548 | 154 |
867980 | 867980 | 2020-12-26 | Gregg | Texas | 48183 | 6548 | 154 |
864735 | 864735 | 2020-12-25 | Gregg | Texas | 48183 | 6548 | 154 |
861490 | 861490 | 2020-12-24 | Gregg | Texas | 48183 | 6548 | 147 |
858245 | 858245 | 2020-12-23 | Gregg | Texas | 48183 | 6548 | 143 |
855000 | 855000 | 2020-12-22 | Gregg | Texas | 48183 | 6537 | 143 |
851755 | 851755 | 2020-12-21 | Gregg | Texas | 48183 | 6402 | 141 |
848510 | 848510 | 2020-12-20 | Gregg | Texas | 48183 | 6151 | 140 |
845265 | 845265 | 2020-12-19 | Gregg | Texas | 48183 | 6151 | 139 |
842019 | 842019 | 2020-12-18 | Gregg | Texas | 48183 | 6151 | 138 |
838774 | 838774 | 2020-12-17 | Gregg | Texas | 48183 | 6099 | 137 |
835528 | 835528 | 2020-12-16 | Gregg | Texas | 48183 | 6064 | 132 |
832282 | 832282 | 2020-12-15 | Gregg | Texas | 48183 | 5974 | 128 |
829035 | 829035 | 2020-12-14 | Gregg | Texas | 48183 | 5888 | 127 |
825789 | 825789 | 2020-12-13 | Gregg | Texas | 48183 | 5781 | 127 |
822542 | 822542 | 2020-12-12 | Gregg | Texas | 48183 | 5781 | 127 |
819296 | 819296 | 2020-12-11 | Gregg | Texas | 48183 | 5781 | 126 |
816050 | 816050 | 2020-12-10 | Gregg | Texas | 48183 | 5748 | 125 |
812804 | 812804 | 2020-12-09 | Gregg | Texas | 48183 | 5694 | 120 |
809560 | 809560 | 2020-12-08 | Gregg | Texas | 48183 | 5646 | 119 |
806315 | 806315 | 2020-12-07 | Gregg | Texas | 48183 | 5585 | 117 |
803070 | 803070 | 2020-12-06 | Gregg | Texas | 48183 | 5426 | 117 |
799825 | 799825 | 2020-12-05 | Gregg | Texas | 48183 | 5426 | 117 |
796580 | 796580 | 2020-12-04 | Gregg | Texas | 48183 | 5426 | 115 |
793335 | 793335 | 2020-12-03 | Gregg | Texas | 48183 | 5390 | 112 |
790090 | 790090 | 2020-12-02 | Gregg | Texas | 48183 | 5270 | 110 |
786845 | 786845 | 2020-12-01 | Gregg | Texas | 48183 | 5199 | 108 |
783601 | 783601 | 2020-11-30 | Gregg | Texas | 48183 | 5094 | 108 |
780356 | 780356 | 2020-11-29 | Gregg | Texas | 48183 | 4930 | 108 |
777110 | 777110 | 2020-11-28 | Gregg | Texas | 48183 | 4930 | 108 |
773865 | 773865 | 2020-11-27 | Gregg | Texas | 48183 | 4930 | 108 |
770620 | 770620 | 2020-11-26 | Gregg | Texas | 48183 | 4930 | 108 |
767374 | 767374 | 2020-11-25 | Gregg | Texas | 48183 | 4930 | 108 |
764129 | 764129 | 2020-11-24 | Gregg | Texas | 48183 | 4872 | 108 |
760884 | 760884 | 2020-11-23 | Gregg | Texas | 48183 | 4768 | 108 |
757639 | 757639 | 2020-11-22 | Gregg | Texas | 48183 | 4681 | 108 |
754392 | 754392 | 2020-11-21 | Gregg | Texas | 48183 | 4681 | 108 |
751146 | 751146 | 2020-11-20 | Gregg | Texas | 48183 | 4681 | 108 |
747900 | 747900 | 2020-11-19 | Gregg | Texas | 48183 | 4613 | 108 |
744654 | 744654 | 2020-11-18 | Gregg | Texas | 48183 | 4546 | 108 |
741407 | 741407 | 2020-11-17 | Gregg | Texas | 48183 | 4457 | 103 |
738161 | 738161 | 2020-11-16 | Gregg | Texas | 48183 | 4334 | 103 |
734917 | 734917 | 2020-11-15 | Gregg | Texas | 48183 | 4179 | 103 |
731671 | 731671 | 2020-11-14 | Gregg | Texas | 48183 | 4179 | 103 |
728426 | 728426 | 2020-11-13 | Gregg | Texas | 48183 | 4179 | 103 |
725183 | 725183 | 2020-11-12 | Gregg | Texas | 48183 | 4115 | 96 |
721940 | 721940 | 2020-11-11 | Gregg | Texas | 48183 | 4026 | 96 |
718697 | 718697 | 2020-11-10 | Gregg | Texas | 48183 | 3949 | 92 |
715454 | 715454 | 2020-11-09 | Gregg | Texas | 48183 | 3857 | 91 |
712210 | 712210 | 2020-11-08 | Gregg | Texas | 48183 | 3804 | 91 |
708966 | 708966 | 2020-11-07 | Gregg | Texas | 48183 | 3804 | 91 |
705722 | 705722 | 2020-11-06 | Gregg | Texas | 48183 | 3804 | 90 |
702479 | 702479 | 2020-11-05 | Gregg | Texas | 48183 | 3715 | 88 |
699236 | 699236 | 2020-11-04 | Gregg | Texas | 48183 | 3648 | 88 |
695992 | 695992 | 2020-11-03 | Gregg | Texas | 48183 | 3552 | 88 |
692750 | 692750 | 2020-11-02 | Gregg | Texas | 48183 | 3552 | 88 |
689506 | 689506 | 2020-11-01 | Gregg | Texas | 48183 | 3531 | 87 |
686261 | 686261 | 2020-10-31 | Gregg | Texas | 48183 | 3531 | 87 |
683018 | 683018 | 2020-10-30 | Gregg | Texas | 48183 | 3531 | 87 |
679775 | 679775 | 2020-10-29 | Gregg | Texas | 48183 | 3486 | 87 |
676532 | 676532 | 2020-10-28 | Gregg | Texas | 48183 | 3454 | 86 |
673289 | 673289 | 2020-10-27 | Gregg | Texas | 48183 | 3423 | 86 |
670047 | 670047 | 2020-10-26 | Gregg | Texas | 48183 | 3372 | 86 |
666804 | 666804 | 2020-10-25 | Gregg | Texas | 48183 | 3337 | 85 |
663559 | 663559 | 2020-10-24 | Gregg | Texas | 48183 | 3337 | 85 |
660315 | 660315 | 2020-10-23 | Gregg | Texas | 48183 | 3337 | 84 |
657071 | 657071 | 2020-10-22 | Gregg | Texas | 48183 | 3303 | 83 |
653826 | 653826 | 2020-10-21 | Gregg | Texas | 48183 | 3263 | 83 |
650581 | 650581 | 2020-10-20 | Gregg | Texas | 48183 | 3207 | 83 |
647337 | 647337 | 2020-10-19 | Gregg | Texas | 48183 | 3156 | 82 |
644091 | 644091 | 2020-10-18 | Gregg | Texas | 48183 | 3114 | 82 |
640843 | 640843 | 2020-10-17 | Gregg | Texas | 48183 | 3114 | 82 |
637596 | 637596 | 2020-10-16 | Gregg | Texas | 48183 | 3114 | 81 |
634351 | 634351 | 2020-10-15 | Gregg | Texas | 48183 | 3090 | 80 |
631106 | 631106 | 2020-10-14 | Gregg | Texas | 48183 | 3046 | 78 |
627862 | 627862 | 2020-10-13 | Gregg | Texas | 48183 | 3009 | 76 |
624620 | 624620 | 2020-10-12 | Gregg | Texas | 48183 | 2975 | 76 |
621377 | 621377 | 2020-10-11 | Gregg | Texas | 48183 | 2937 | 76 |
618134 | 618134 | 2020-10-10 | Gregg | Texas | 48183 | 2937 | 76 |
614892 | 614892 | 2020-10-09 | Gregg | Texas | 48183 | 2937 | 76 |
611651 | 611651 | 2020-10-08 | Gregg | Texas | 48183 | 2917 | 76 |
608409 | 608409 | 2020-10-07 | Gregg | Texas | 48183 | 2904 | 76 |
605166 | 605166 | 2020-10-06 | Gregg | Texas | 48183 | 2873 | 75 |
601924 | 601924 | 2020-10-05 | Gregg | Texas | 48183 | 2851 | 74 |
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);