ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 290 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2277864 | 2277864 | 2022-03-05 | Val Verde | Texas | 48465 | 14242 | 290 |
2274611 | 2274611 | 2022-03-04 | Val Verde | Texas | 48465 | 14242 | 290 |
1907151 | 1907151 | 2021-11-11 | Orange | Texas | 48361 | 13755 | 290 |
1858345 | 1858345 | 2021-10-27 | Hunt | Texas | 48231 | 10933 | 290 |
1819422 | 1819422 | 2021-10-15 | Parker | Texas | 48367 | 23683 | 290 |
1760860 | 1760860 | 2021-09-27 | Henderson | Texas | 48213 | 9239 | 290 |
1757612 | 1757612 | 2021-09-26 | Henderson | Texas | 48213 | 9239 | 290 |
1754351 | 1754351 | 2021-09-25 | Guadalupe | Texas | 48187 | 22409 | 290 |
1754364 | 1754364 | 2021-09-25 | Henderson | Texas | 48213 | 9239 | 290 |
1751116 | 1751116 | 2021-09-24 | Henderson | Texas | 48213 | 9239 | 290 |
1728497 | 1728497 | 2021-09-17 | Victoria | Texas | 48469 | 12556 | 290 |
1669811 | 1669811 | 2021-08-30 | Brazos | Texas | 48041 | 30997 | 290 |
1666564 | 1666564 | 2021-08-29 | Brazos | Texas | 48041 | 30828 | 290 |
1663316 | 1663316 | 2021-08-28 | Brazos | Texas | 48041 | 30828 | 290 |
1218660 | 1218660 | 2021-04-13 | Randall | Texas | 48381 | 16587 | 290 |
1215412 | 1215412 | 2021-04-12 | Randall | Texas | 48381 | 16576 | 290 |
1212165 | 1212165 | 2021-04-11 | Randall | Texas | 48381 | 16570 | 290 |
1208916 | 1208916 | 2021-04-10 | Randall | Texas | 48381 | 16570 | 290 |
1205668 | 1205668 | 2021-04-09 | Randall | Texas | 48381 | 16570 | 290 |
1192697 | 1192697 | 2021-04-05 | Starr | Texas | 48427 | 9307 | 290 |
1189448 | 1189448 | 2021-04-04 | Starr | Texas | 48427 | 9307 | 290 |
1062777 | 1062777 | 2021-02-24 | Maverick | Texas | 48323 | 10132 | 290 |
988051 | 988051 | 2021-02-01 | Galveston | Texas | 48167 | 30529 | 290 |
984804 | 984804 | 2021-01-31 | Galveston | Texas | 48167 | 30529 | 290 |
959004 | 959004 | 2021-01-23 | Williamson | Texas | 48491 | 32949 | 290 |
920025 | 920025 | 2021-01-11 | Smith | Texas | 48423 | 13854 | 290 |
585702 | 585702 | 2020-09-30 | Fort Bend | Texas | 48157 | 16472 | 290 |
572897 | 572897 | 2020-09-26 | Webb | Texas | 48479 | 13686 | 290 |
569655 | 569655 | 2020-09-25 | Webb | Texas | 48479 | 13651 | 290 |
443469 | 443469 | 2020-08-17 | Nueces | Texas | 48355 | 17124 | 290 |
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);