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 |
---|---|---|---|---|---|---|---|
1082183 | 1082183 | 2021-03-02 | Gregg | Texas | 48183 | 10693 | 309 |
1078937 | 1078937 | 2021-03-01 | Gregg | Texas | 48183 | 10693 | 308 |
1075692 | 1075692 | 2021-02-28 | Gregg | Texas | 48183 | 10669 | 308 |
1072446 | 1072446 | 2021-02-27 | Gregg | Texas | 48183 | 10669 | 305 |
1069200 | 1069200 | 2021-02-26 | Gregg | Texas | 48183 | 10669 | 301 |
1065955 | 1065955 | 2021-02-25 | Gregg | Texas | 48183 | 10638 | 299 |
1062710 | 1062710 | 2021-02-24 | Gregg | Texas | 48183 | 10591 | 296 |
1059465 | 1059465 | 2021-02-23 | Gregg | Texas | 48183 | 10591 | 294 |
1056219 | 1056219 | 2021-02-22 | Gregg | Texas | 48183 | 10591 | 293 |
1052973 | 1052973 | 2021-02-21 | Gregg | Texas | 48183 | 10561 | 293 |
1049726 | 1049726 | 2021-02-20 | Gregg | Texas | 48183 | 10561 | 292 |
1046479 | 1046479 | 2021-02-19 | Gregg | Texas | 48183 | 10561 | 292 |
1043234 | 1043234 | 2021-02-18 | Gregg | Texas | 48183 | 10555 | 291 |
1039989 | 1039989 | 2021-02-17 | Gregg | Texas | 48183 | 10555 | 291 |
1036744 | 1036744 | 2021-02-16 | Gregg | Texas | 48183 | 10518 | 289 |
1033499 | 1033499 | 2021-02-15 | Gregg | Texas | 48183 | 10449 | 289 |
1030253 | 1030253 | 2021-02-14 | Gregg | Texas | 48183 | 10449 | 289 |
1027006 | 1027006 | 2021-02-13 | Gregg | Texas | 48183 | 10449 | 288 |
1023761 | 1023761 | 2021-02-12 | Gregg | Texas | 48183 | 10449 | 286 |
1020516 | 1020516 | 2021-02-11 | Gregg | Texas | 48183 | 10384 | 283 |
1017271 | 1017271 | 2021-02-10 | Gregg | Texas | 48183 | 10384 | 277 |
1014026 | 1014026 | 2021-02-09 | Gregg | Texas | 48183 | 10248 | 275 |
1010781 | 1010781 | 2021-02-08 | Gregg | Texas | 48183 | 10248 | 275 |
1007535 | 1007535 | 2021-02-07 | Gregg | Texas | 48183 | 10082 | 274 |
1004289 | 1004289 | 2021-02-06 | Gregg | Texas | 48183 | 10082 | 271 |
1001043 | 1001043 | 2021-02-05 | Gregg | Texas | 48183 | 10082 | 268 |
997797 | 997797 | 2021-02-04 | Gregg | Texas | 48183 | 9941 | 266 |
994551 | 994551 | 2021-02-03 | Gregg | Texas | 48183 | 9941 | 261 |
991305 | 991305 | 2021-02-02 | Gregg | Texas | 48183 | 9839 | 256 |
988059 | 988059 | 2021-02-01 | Gregg | Texas | 48183 | 9839 | 255 |
984812 | 984812 | 2021-01-31 | Gregg | Texas | 48183 | 9724 | 255 |
981565 | 981565 | 2021-01-30 | Gregg | Texas | 48183 | 9724 | 255 |
978319 | 978319 | 2021-01-29 | Gregg | Texas | 48183 | 9627 | 254 |
975074 | 975074 | 2021-01-28 | Gregg | Texas | 48183 | 9627 | 253 |
971829 | 971829 | 2021-01-27 | Gregg | Texas | 48183 | 9409 | 252 |
968584 | 968584 | 2021-01-26 | Gregg | Texas | 48183 | 9409 | 250 |
965340 | 965340 | 2021-01-25 | Gregg | Texas | 48183 | 9125 | 249 |
962095 | 962095 | 2021-01-24 | Gregg | Texas | 48183 | 9125 | 249 |
958850 | 958850 | 2021-01-23 | Gregg | Texas | 48183 | 9125 | 249 |
955604 | 955604 | 2021-01-22 | Gregg | Texas | 48183 | 9125 | 243 |
952359 | 952359 | 2021-01-21 | Gregg | Texas | 48183 | 8960 | 231 |
949114 | 949114 | 2021-01-20 | Gregg | Texas | 48183 | 8960 | 222 |
945868 | 945868 | 2021-01-19 | Gregg | Texas | 48183 | 8818 | 221 |
942621 | 942621 | 2021-01-18 | Gregg | Texas | 48183 | 8451 | 217 |
939376 | 939376 | 2021-01-17 | Gregg | Texas | 48183 | 8451 | 217 |
936131 | 936131 | 2021-01-16 | Gregg | Texas | 48183 | 8451 | 216 |
932886 | 932886 | 2021-01-15 | Gregg | Texas | 48183 | 8451 | 213 |
929641 | 929641 | 2021-01-14 | Gregg | Texas | 48183 | 8320 | 210 |
926396 | 926396 | 2021-01-13 | Gregg | Texas | 48183 | 8147 | 205 |
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 |
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);