ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where deaths = 309 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2157501 | 2157501 | 2022-01-27 | San Patricio | Texas | 48409 | 9800 | 309 |
2154248 | 2154248 | 2022-01-26 | San Patricio | Texas | 48409 | 9707 | 309 |
2128195 | 2128195 | 2022-01-18 | Orange | Texas | 48361 | 13650 | 309 |
2124943 | 2124943 | 2022-01-17 | Orange | Texas | 48361 | 13597 | 309 |
2121691 | 2121691 | 2022-01-16 | Orange | Texas | 48361 | 13555 | 309 |
2118439 | 2118439 | 2022-01-15 | Orange | Texas | 48361 | 13506 | 309 |
2115188 | 2115188 | 2022-01-14 | Orange | Texas | 48361 | 13442 | 309 |
2111936 | 2111936 | 2022-01-13 | Orange | Texas | 48361 | 14715 | 309 |
2108684 | 2108684 | 2022-01-12 | Orange | Texas | 48361 | 14642 | 309 |
1923334 | 1923334 | 2021-11-16 | Hunt | Texas | 48231 | 11044 | 309 |
1920085 | 1920085 | 2021-11-15 | Hunt | Texas | 48231 | 11044 | 309 |
1916835 | 1916835 | 2021-11-14 | Hunt | Texas | 48231 | 11044 | 309 |
1913585 | 1913585 | 2021-11-13 | Hunt | Texas | 48231 | 11044 | 309 |
1845415 | 1845415 | 2021-10-23 | Parker | Texas | 48367 | 24096 | 309 |
1721785 | 1721785 | 2021-09-15 | Brazos | Texas | 48041 | 33073 | 309 |
1712187 | 1712187 | 2021-09-12 | Midland | Texas | 48329 | 23620 | 309 |
1708940 | 1708940 | 2021-09-11 | Midland | Texas | 48329 | 23620 | 309 |
1705693 | 1705693 | 2021-09-10 | Midland | Texas | 48329 | 23620 | 309 |
1241273 | 1241273 | 2021-04-20 | Ellis | Texas | 48139 | 22412 | 309 |
1238026 | 1238026 | 2021-04-19 | Ellis | Texas | 48139 | 22368 | 309 |
1234779 | 1234779 | 2021-04-18 | Ellis | Texas | 48139 | 22368 | 309 |
1231531 | 1231531 | 2021-04-17 | Ellis | Texas | 48139 | 22368 | 309 |
1228283 | 1228283 | 2021-04-16 | Ellis | Texas | 48139 | 22359 | 309 |
1225035 | 1225035 | 2021-04-15 | Ellis | Texas | 48139 | 22349 | 309 |
1221788 | 1221788 | 2021-04-14 | Ellis | Texas | 48139 | 22334 | 309 |
1218540 | 1218540 | 2021-04-13 | Ellis | Texas | 48139 | 22314 | 309 |
1215292 | 1215292 | 2021-04-12 | Ellis | Texas | 48139 | 22252 | 309 |
1212045 | 1212045 | 2021-04-11 | Ellis | Texas | 48139 | 22252 | 309 |
1208796 | 1208796 | 2021-04-10 | Ellis | Texas | 48139 | 22252 | 309 |
1205548 | 1205548 | 2021-04-09 | Ellis | Texas | 48139 | 22237 | 309 |
1202300 | 1202300 | 2021-04-08 | Ellis | Texas | 48139 | 22223 | 309 |
1199051 | 1199051 | 2021-04-07 | Ellis | Texas | 48139 | 22203 | 309 |
1195777 | 1195777 | 2021-04-06 | Comal | Texas | 48091 | 9764 | 309 |
1195802 | 1195802 | 2021-04-06 | Ellis | Texas | 48139 | 22183 | 309 |
1192529 | 1192529 | 2021-04-05 | Comal | Texas | 48091 | 9711 | 309 |
1189280 | 1189280 | 2021-04-04 | Comal | Texas | 48091 | 9711 | 309 |
1186033 | 1186033 | 2021-04-03 | Comal | Texas | 48091 | 9711 | 309 |
1182786 | 1182786 | 2021-04-02 | Comal | Texas | 48091 | 9711 | 309 |
1179539 | 1179539 | 2021-04-01 | Comal | Texas | 48091 | 9697 | 309 |
1176292 | 1176292 | 2021-03-31 | Comal | Texas | 48091 | 9686 | 309 |
1082183 | 1082183 | 2021-03-02 | Gregg | Texas | 48183 | 10693 | 309 |
1059499 | 1059499 | 2021-02-23 | Johnson | Texas | 48251 | 18277 | 309 |
1023683 | 1023683 | 2021-02-12 | Bell | Texas | 48027 | 20049 | 309 |
1017263 | 1017263 | 2021-02-10 | Galveston | Texas | 48167 | 32476 | 309 |
987987 | 987987 | 2021-02-01 | Brazoria | Texas | 48039 | 28688 | 309 |
981694 | 981694 | 2021-01-30 | Taylor | Texas | 48441 | 14424 | 309 |
945988 | 945988 | 2021-01-19 | Smith | Texas | 48423 | 15874 | 309 |
932964 | 932964 | 2021-01-15 | Montgomery | Texas | 48339 | 33006 | 309 |
897285 | 897285 | 2021-01-04 | Potter | Texas | 48375 | 15269 | 309 |
835479 | 835479 | 2020-12-16 | Collin | Texas | 48085 | 37433 | 309 |
686248 | 686248 | 2020-10-31 | Fort Bend | Texas | 48157 | 18416 | 309 |
683005 | 683005 | 2020-10-30 | Fort Bend | Texas | 48157 | 18340 | 309 |
679762 | 679762 | 2020-10-29 | Fort Bend | Texas | 48157 | 18302 | 309 |
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);