ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where deaths = 396 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329765 | 2329765 | 2022-03-21 | Guadalupe | Texas | 48187 | 37813 | 396 |
2326513 | 2326513 | 2022-03-20 | Guadalupe | Texas | 48187 | 37811 | 396 |
2323260 | 2323260 | 2022-03-19 | Guadalupe | Texas | 48187 | 37804 | 396 |
2320006 | 2320006 | 2022-03-18 | Guadalupe | Texas | 48187 | 37799 | 396 |
2316752 | 2316752 | 2022-03-17 | Guadalupe | Texas | 48187 | 37754 | 396 |
2313499 | 2313499 | 2022-03-16 | Guadalupe | Texas | 48187 | 37695 | 396 |
2310246 | 2310246 | 2022-03-15 | Guadalupe | Texas | 48187 | 37659 | 396 |
2306993 | 2306993 | 2022-03-14 | Guadalupe | Texas | 48187 | 37618 | 396 |
2303742 | 2303742 | 2022-03-13 | Guadalupe | Texas | 48187 | 37614 | 396 |
2294038 | 2294038 | 2022-03-10 | Liberty | Texas | 48291 | 17592 | 396 |
2290786 | 2290786 | 2022-03-09 | Liberty | Texas | 48291 | 17576 | 396 |
2287534 | 2287534 | 2022-03-08 | Liberty | Texas | 48291 | 17559 | 396 |
2245350 | 2245350 | 2022-02-23 | Victoria | Texas | 48469 | 18338 | 396 |
2241885 | 2241885 | 2022-02-22 | Brazos | Texas | 48041 | 59467 | 396 |
2238634 | 2238634 | 2022-02-21 | Brazos | Texas | 48041 | 59432 | 396 |
2235383 | 2235383 | 2022-02-20 | Brazos | Texas | 48041 | 59420 | 396 |
2232132 | 2232132 | 2022-02-19 | Brazos | Texas | 48041 | 59403 | 396 |
2225716 | 2225716 | 2022-02-17 | Henderson | Texas | 48213 | 15201 | 396 |
2203030 | 2203030 | 2022-02-10 | Parker | Texas | 48367 | 33312 | 396 |
2102227 | 2102227 | 2022-01-10 | Tom Green | Texas | 48451 | 29969 | 396 |
2098976 | 2098976 | 2022-01-09 | Tom Green | Texas | 48451 | 29451 | 396 |
2095724 | 2095724 | 2022-01-08 | Tom Green | Texas | 48451 | 29451 | 396 |
2092472 | 2092472 | 2022-01-07 | Tom Green | Texas | 48451 | 29451 | 396 |
2089220 | 2089220 | 2022-01-06 | Tom Green | Texas | 48451 | 28846 | 396 |
2014399 | 2014399 | 2021-12-14 | Midland | Texas | 48329 | 30040 | 396 |
2011148 | 2011148 | 2021-12-13 | Midland | Texas | 48329 | 29888 | 396 |
2007897 | 2007897 | 2021-12-12 | Midland | Texas | 48329 | 29888 | 396 |
1858334 | 1858334 | 2021-10-27 | Hays | Texas | 48209 | 32892 | 396 |
1855085 | 1855085 | 2021-10-26 | Hays | Texas | 48209 | 32847 | 396 |
1845234 | 1845234 | 2021-10-23 | Angelina | Texas | 48005 | 13665 | 396 |
1841984 | 1841984 | 2021-10-22 | Angelina | Texas | 48005 | 13665 | 396 |
1809621 | 1809621 | 2021-10-12 | Kaufman | Texas | 48257 | 23332 | 396 |
1637374 | 1637374 | 2021-08-20 | Ector | Texas | 48135 | 20544 | 396 |
1630935 | 1630935 | 2021-08-18 | Johnson | Texas | 48251 | 22062 | 396 |
1627688 | 1627688 | 2021-08-17 | Johnson | Texas | 48251 | 21963 | 396 |
1624441 | 1624441 | 2021-08-16 | Johnson | Texas | 48251 | 21763 | 396 |
1621194 | 1621194 | 2021-08-15 | Johnson | Texas | 48251 | 21763 | 396 |
1095094 | 1095094 | 2021-03-06 | Brazoria | Texas | 48039 | 33450 | 396 |
1066075 | 1066075 | 2021-02-25 | Smith | Texas | 48423 | 18743 | 396 |
767522 | 767522 | 2020-11-25 | Webb | Texas | 48479 | 19350 | 396 |
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);