ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 305 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1972189 | 1972189 | 2021-12-01 | Sherman | Texas | 48421 | 305 | 16 |
1741330 | 1741330 | 2021-09-21 | Edwards | Texas | 48137 | 305 | 7 |
1738081 | 1738081 | 2021-09-20 | Edwards | Texas | 48137 | 305 | 7 |
1734831 | 1734831 | 2021-09-19 | Edwards | Texas | 48137 | 305 | 7 |
1731581 | 1731581 | 2021-09-18 | Edwards | Texas | 48137 | 305 | 7 |
1728331 | 1728331 | 2021-09-17 | Edwards | Texas | 48137 | 305 | 7 |
1725082 | 1725082 | 2021-09-16 | Edwards | Texas | 48137 | 305 | 6 |
1721833 | 1721833 | 2021-09-15 | Edwards | Texas | 48137 | 305 | 6 |
1718585 | 1718585 | 2021-09-14 | Edwards | Texas | 48137 | 305 | 6 |
1569101 | 1569101 | 2021-07-30 | Baylor | Texas | 48023 | 305 | 13 |
1565853 | 1565853 | 2021-07-29 | Baylor | Texas | 48023 | 305 | 13 |
1562605 | 1562605 | 2021-07-28 | Baylor | Texas | 48023 | 305 | 13 |
1400354 | 1400354 | 2021-06-08 | Fisher | Texas | 48151 | 305 | 14 |
1397109 | 1397109 | 2021-06-07 | Fisher | Texas | 48151 | 305 | 14 |
1393862 | 1393862 | 2021-06-06 | Fisher | Texas | 48151 | 305 | 14 |
1390617 | 1390617 | 2021-06-05 | Fisher | Texas | 48151 | 305 | 14 |
1387372 | 1387372 | 2021-06-04 | Fisher | Texas | 48151 | 305 | 14 |
1384127 | 1384127 | 2021-06-03 | Fisher | Texas | 48151 | 305 | 14 |
1380881 | 1380881 | 2021-06-02 | Fisher | Texas | 48151 | 305 | 14 |
1338643 | 1338643 | 2021-05-20 | Cochran | Texas | 48079 | 305 | 15 |
1335396 | 1335396 | 2021-05-19 | Cochran | Texas | 48079 | 305 | 15 |
1332149 | 1332149 | 2021-05-18 | Cochran | Texas | 48079 | 305 | 15 |
1328902 | 1328902 | 2021-05-17 | Cochran | Texas | 48079 | 305 | 15 |
1325656 | 1325656 | 2021-05-16 | Cochran | Texas | 48079 | 305 | 15 |
1322410 | 1322410 | 2021-05-15 | Cochran | Texas | 48079 | 305 | 15 |
1319164 | 1319164 | 2021-05-14 | Cochran | Texas | 48079 | 305 | 15 |
1315916 | 1315916 | 2021-05-13 | Cochran | Texas | 48079 | 305 | 15 |
1312670 | 1312670 | 2021-05-12 | Cochran | Texas | 48079 | 305 | 15 |
1309423 | 1309423 | 2021-05-11 | Cochran | Texas | 48079 | 305 | 15 |
1192631 | 1192631 | 2021-04-05 | Lipscomb | Texas | 48295 | 305 | 12 |
1189382 | 1189382 | 2021-04-04 | Lipscomb | Texas | 48295 | 305 | 12 |
1186135 | 1186135 | 2021-04-03 | Lipscomb | Texas | 48295 | 305 | 12 |
1182888 | 1182888 | 2021-04-02 | Lipscomb | Texas | 48295 | 305 | 12 |
1179641 | 1179641 | 2021-04-01 | Lipscomb | Texas | 48295 | 305 | 12 |
1176394 | 1176394 | 2021-03-31 | Lipscomb | Texas | 48295 | 305 | 12 |
1173147 | 1173147 | 2021-03-30 | Lipscomb | Texas | 48295 | 305 | 12 |
1169900 | 1169900 | 2021-03-29 | Lipscomb | Texas | 48295 | 305 | 12 |
1166652 | 1166652 | 2021-03-28 | Lipscomb | Texas | 48295 | 305 | 12 |
1163404 | 1163404 | 2021-03-27 | Lipscomb | Texas | 48295 | 305 | 12 |
1082284 | 1082284 | 2021-03-02 | Real | Texas | 48385 | 305 | 12 |
923074 | 923074 | 2021-01-12 | Blanco | Texas | 48031 | 305 | 9 |
919829 | 919829 | 2021-01-11 | Blanco | Texas | 48031 | 305 | 9 |
916584 | 916584 | 2021-01-10 | Blanco | Texas | 48031 | 305 | 9 |
910233 | 910233 | 2021-01-08 | Marion | Texas | 48315 | 305 | 18 |
783738 | 783738 | 2020-11-30 | Tyler | Texas | 48457 | 305 | 5 |
780470 | 780470 | 2020-11-29 | San Saba | Texas | 48411 | 305 | 8 |
780493 | 780493 | 2020-11-29 | Tyler | Texas | 48457 | 305 | 5 |
777057 | 777057 | 2020-11-28 | Clay | Texas | 48077 | 305 | 6 |
777168 | 777168 | 2020-11-28 | Llano | Texas | 48299 | 305 | 4 |
777247 | 777247 | 2020-11-28 | Tyler | Texas | 48457 | 305 | 5 |
773812 | 773812 | 2020-11-27 | Clay | Texas | 48077 | 305 | 6 |
774002 | 774002 | 2020-11-27 | Tyler | Texas | 48457 | 305 | 5 |
770567 | 770567 | 2020-11-26 | Clay | Texas | 48077 | 305 | 6 |
770757 | 770757 | 2020-11-26 | Tyler | Texas | 48457 | 305 | 5 |
767511 | 767511 | 2020-11-25 | Tyler | Texas | 48457 | 305 | 4 |
715564 | 715564 | 2020-11-09 | San Augustine | Texas | 48405 | 305 | 15 |
679861 | 679861 | 2020-10-29 | Ochiltree | Texas | 48357 | 305 | 5 |
676582 | 676582 | 2020-10-28 | Lampasas | Texas | 48281 | 305 | 9 |
676618 | 676618 | 2020-10-28 | Ochiltree | Texas | 48357 | 305 | 5 |
673339 | 673339 | 2020-10-27 | Lampasas | Texas | 48281 | 305 | 9 |
673375 | 673375 | 2020-10-27 | Ochiltree | Texas | 48357 | 305 | 5 |
670097 | 670097 | 2020-10-26 | Lampasas | Texas | 48281 | 305 | 9 |
666854 | 666854 | 2020-10-25 | Lampasas | Texas | 48281 | 305 | 9 |
660418 | 660418 | 2020-10-23 | Refugio | Texas | 48391 | 305 | 16 |
657174 | 657174 | 2020-10-22 | Refugio | Texas | 48391 | 305 | 16 |
653929 | 653929 | 2020-10-21 | Refugio | Texas | 48391 | 305 | 16 |
650684 | 650684 | 2020-10-20 | Refugio | Texas | 48391 | 305 | 16 |
647440 | 647440 | 2020-10-19 | Refugio | Texas | 48391 | 305 | 15 |
644194 | 644194 | 2020-10-18 | Refugio | Texas | 48391 | 305 | 15 |
640946 | 640946 | 2020-10-17 | Refugio | Texas | 48391 | 305 | 15 |
537145 | 537145 | 2020-09-15 | Hockley | Texas | 48219 | 305 | 7 |
469299 | 469299 | 2020-08-25 | Panola | Texas | 48365 | 305 | 20 |
385500 | 385500 | 2020-07-30 | Parmer | Texas | 48369 | 305 | 7 |
292831 | 292831 | 2020-07-01 | Deaf Smith | Texas | 48117 | 305 | 16 |
258275 | 258275 | 2020-06-20 | Coryell | Texas | 48099 | 305 | 2 |
255149 | 255149 | 2020-06-19 | Coryell | Texas | 48099 | 305 | 2 |
224176 | 224176 | 2020-06-09 | Nacogdoches | Texas | 48347 | 305 | 21 |
187125 | 187125 | 2020-05-28 | Ellis | Texas | 48139 | 305 | 13 |
144650 | 144650 | 2020-05-14 | Brazos | Texas | 48041 | 305 | 18 |
103414 | 103414 | 2020-04-30 | Jefferson | Texas | 48245 | 305 | 21 |
28114 | 28114 | 2020-04-02 | Travis | Texas | 48453 | 305 | 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);