ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 377 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2150909 | 2150909 | 2022-01-25 | Irion | Texas | 48235 | 377 | 2 |
2095662 | 2095662 | 2022-01-08 | Menard | Texas | 48327 | 377 | 12 |
2063192 | 2063192 | 2021-12-29 | Schleicher | Texas | 48413 | 377 | 9 |
1809640 | 1809640 | 2021-10-12 | Lipscomb | Texas | 48295 | 377 | 12 |
1806390 | 1806390 | 2021-10-11 | Lipscomb | Texas | 48295 | 377 | 12 |
1803140 | 1803140 | 2021-10-10 | Lipscomb | Texas | 48295 | 377 | 12 |
1799891 | 1799891 | 2021-10-09 | Lipscomb | Texas | 48295 | 377 | 12 |
1682823 | 1682823 | 2021-09-03 | Cochran | Texas | 48079 | 377 | 15 |
1679573 | 1679573 | 2021-09-02 | Cochran | Texas | 48079 | 377 | 15 |
1650440 | 1650440 | 2021-08-24 | Kinney | Texas | 48271 | 377 | 7 |
1289953 | 1289953 | 2021-05-05 | Concho | Texas | 48095 | 377 | 8 |
1267370 | 1267370 | 2021-04-28 | Reagan | Texas | 48383 | 377 | 8 |
1254382 | 1254382 | 2021-04-24 | Reagan | Texas | 48383 | 377 | 8 |
1251135 | 1251135 | 2021-04-23 | Reagan | Texas | 48383 | 377 | 8 |
1247888 | 1247888 | 2021-04-22 | Reagan | Texas | 48383 | 377 | 8 |
1244641 | 1244641 | 2021-04-21 | Reagan | Texas | 48383 | 377 | 8 |
1241394 | 1241394 | 2021-04-20 | Reagan | Texas | 48383 | 377 | 8 |
1225156 | 1225156 | 2021-04-15 | Reagan | Texas | 48383 | 377 | 8 |
1221909 | 1221909 | 2021-04-14 | Reagan | Texas | 48383 | 377 | 8 |
1218661 | 1218661 | 2021-04-13 | Reagan | Texas | 48383 | 377 | 8 |
1215413 | 1215413 | 2021-04-12 | Reagan | Texas | 48383 | 377 | 8 |
1212166 | 1212166 | 2021-04-11 | Reagan | Texas | 48383 | 377 | 8 |
1208917 | 1208917 | 2021-04-10 | Reagan | Texas | 48383 | 377 | 8 |
1205542 | 1205542 | 2021-04-09 | Donley | Texas | 48129 | 377 | 15 |
1205669 | 1205669 | 2021-04-09 | Reagan | Texas | 48383 | 377 | 8 |
1202294 | 1202294 | 2021-04-08 | Donley | Texas | 48129 | 377 | 15 |
1202421 | 1202421 | 2021-04-08 | Reagan | Texas | 48383 | 377 | 8 |
1199172 | 1199172 | 2021-04-07 | Reagan | Texas | 48383 | 377 | 8 |
1195923 | 1195923 | 2021-04-06 | Reagan | Texas | 48383 | 377 | 8 |
1192675 | 1192675 | 2021-04-05 | Reagan | Texas | 48383 | 377 | 8 |
1189426 | 1189426 | 2021-04-04 | Reagan | Texas | 48383 | 377 | 8 |
1186179 | 1186179 | 2021-04-03 | Reagan | Texas | 48383 | 377 | 8 |
1147104 | 1147104 | 2021-03-22 | Garza | Texas | 48169 | 377 | 22 |
1143857 | 1143857 | 2021-03-21 | Garza | Texas | 48169 | 377 | 22 |
1140610 | 1140610 | 2021-03-20 | Garza | Texas | 48169 | 377 | 22 |
1140756 | 1140756 | 2021-03-20 | Upton | Texas | 48461 | 377 | 9 |
1137364 | 1137364 | 2021-03-19 | Garza | Texas | 48169 | 377 | 22 |
1137510 | 1137510 | 2021-03-19 | Upton | Texas | 48461 | 377 | 9 |
1134118 | 1134118 | 2021-03-18 | Garza | Texas | 48169 | 377 | 21 |
1134264 | 1134264 | 2021-03-18 | Upton | Texas | 48461 | 377 | 9 |
1130870 | 1130870 | 2021-03-17 | Garza | Texas | 48169 | 377 | 21 |
1127623 | 1127623 | 2021-03-16 | Garza | Texas | 48169 | 377 | 21 |
1124523 | 1124523 | 2021-03-15 | Upton | Texas | 48461 | 377 | 9 |
1121277 | 1121277 | 2021-03-14 | Upton | Texas | 48461 | 377 | 9 |
1118030 | 1118030 | 2021-03-13 | Upton | Texas | 48461 | 377 | 9 |
1056284 | 1056284 | 2021-02-22 | Mason | Texas | 48319 | 377 | 4 |
1053038 | 1053038 | 2021-02-21 | Mason | Texas | 48319 | 377 | 4 |
1049791 | 1049791 | 2021-02-20 | Mason | Texas | 48319 | 377 | 4 |
916786 | 916786 | 2021-01-10 | Sutton | Texas | 48435 | 377 | 6 |
913541 | 913541 | 2021-01-09 | Sutton | Texas | 48435 | 377 | 6 |
910132 | 910132 | 2021-01-08 | Crosby | Texas | 48107 | 377 | 21 |
803181 | 803181 | 2020-12-06 | San Augustine | Texas | 48405 | 377 | 18 |
799936 | 799936 | 2020-12-05 | San Augustine | Texas | 48405 | 377 | 18 |
796691 | 796691 | 2020-12-04 | San Augustine | Texas | 48405 | 377 | 18 |
793446 | 793446 | 2020-12-03 | San Augustine | Texas | 48405 | 377 | 18 |
725115 | 725115 | 2020-11-12 | Brooks | Texas | 48047 | 377 | 25 |
721872 | 721872 | 2020-11-11 | Brooks | Texas | 48047 | 377 | 25 |
657109 | 657109 | 2020-10-22 | Kendall | Texas | 48259 | 377 | 10 |
653864 | 653864 | 2020-10-21 | Kendall | Texas | 48259 | 377 | 10 |
650619 | 650619 | 2020-10-20 | Kendall | Texas | 48259 | 377 | 10 |
647375 | 647375 | 2020-10-19 | Kendall | Texas | 48259 | 377 | 10 |
627788 | 627788 | 2020-10-13 | Bosque | Texas | 48035 | 377 | 8 |
605204 | 605204 | 2020-10-06 | Kendall | Texas | 48259 | 377 | 9 |
601962 | 601962 | 2020-10-05 | Kendall | Texas | 48259 | 377 | 8 |
588977 | 588977 | 2020-10-01 | Houston | Texas | 48225 | 377 | 11 |
585807 | 585807 | 2020-09-30 | Pecos | Texas | 48371 | 377 | 5 |
498221 | 498221 | 2020-09-03 | Andrews | Texas | 48003 | 377 | 8 |
456452 | 456452 | 2020-08-21 | Wood | Texas | 48499 | 377 | 12 |
453097 | 453097 | 2020-08-20 | Jasper | Texas | 48241 | 377 | 16 |
424138 | 424138 | 2020-08-11 | Rusk | Texas | 48401 | 377 | 2 |
375900 | 375900 | 2020-07-27 | Waller | Texas | 48473 | 377 | 4 |
321414 | 321414 | 2020-07-10 | Lamar | Texas | 48277 | 377 | 14 |
299280 | 299280 | 2020-07-03 | Rockwall | Texas | 48397 | 377 | 16 |
295954 | 295954 | 2020-07-02 | Caldwell | Texas | 48055 | 377 | 2 |
245775 | 245775 | 2020-06-16 | Bowie | Texas | 48037 | 377 | 13 |
221005 | 221005 | 2020-06-08 | Grayson | Texas | 48181 | 377 | 2 |
132869 | 132869 | 2020-05-10 | Williamson | Texas | 48491 | 377 | 13 |
126776 | 126776 | 2020-05-08 | Hidalgo | Texas | 48215 | 377 | 7 |
72490 | 72490 | 2020-04-19 | Montgomery | Texas | 48339 | 377 | 7 |
69721 | 69721 | 2020-04-18 | Montgomery | Texas | 48339 | 377 | 7 |
55999 | 55999 | 2020-04-13 | Galveston | Texas | 48167 | 377 | 9 |
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);