ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 336 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2316863 | 2316863 | 2022-03-17 | San Patricio | Texas | 48409 | 11017 | 336 |
2313610 | 2313610 | 2022-03-16 | San Patricio | Texas | 48409 | 11013 | 336 |
2310357 | 2310357 | 2022-03-15 | San Patricio | Texas | 48409 | 11012 | 336 |
2307104 | 2307104 | 2022-03-14 | San Patricio | Texas | 48409 | 11010 | 336 |
2303853 | 2303853 | 2022-03-13 | San Patricio | Texas | 48409 | 11006 | 336 |
2300601 | 2300601 | 2022-03-12 | San Patricio | Texas | 48409 | 11005 | 336 |
2297349 | 2297349 | 2022-03-11 | San Patricio | Texas | 48409 | 11004 | 336 |
2294097 | 2294097 | 2022-03-10 | San Patricio | Texas | 48409 | 11003 | 336 |
2290845 | 2290845 | 2022-03-09 | San Patricio | Texas | 48409 | 11001 | 336 |
2199708 | 2199708 | 2022-02-09 | Hunt | Texas | 48231 | 15443 | 336 |
2053451 | 2053451 | 2021-12-26 | Starr | Texas | 48427 | 11991 | 336 |
2050201 | 2050201 | 2021-12-25 | Starr | Texas | 48427 | 11991 | 336 |
2046951 | 2046951 | 2021-12-24 | Starr | Texas | 48427 | 11991 | 336 |
2043701 | 2043701 | 2021-12-23 | Starr | Texas | 48427 | 11991 | 336 |
2040452 | 2040452 | 2021-12-22 | Starr | Texas | 48427 | 11989 | 336 |
2037202 | 2037202 | 2021-12-21 | Starr | Texas | 48427 | 11969 | 336 |
2033952 | 2033952 | 2021-12-20 | Starr | Texas | 48427 | 11969 | 336 |
2030702 | 2030702 | 2021-12-19 | Starr | Texas | 48427 | 11964 | 336 |
2027451 | 2027451 | 2021-12-18 | Starr | Texas | 48427 | 11964 | 336 |
2024200 | 2024200 | 2021-12-17 | Starr | Texas | 48427 | 11958 | 336 |
2020949 | 2020949 | 2021-12-16 | Starr | Texas | 48427 | 11944 | 336 |
2017698 | 2017698 | 2021-12-15 | Starr | Texas | 48427 | 11933 | 336 |
2014448 | 2014448 | 2021-12-14 | Starr | Texas | 48427 | 11912 | 336 |
2011197 | 2011197 | 2021-12-13 | Starr | Texas | 48427 | 11896 | 336 |
2007946 | 2007946 | 2021-12-12 | Starr | Texas | 48427 | 11895 | 336 |
2004695 | 2004695 | 2021-12-11 | Starr | Texas | 48427 | 11894 | 336 |
2001444 | 2001444 | 2021-12-10 | Starr | Texas | 48427 | 11867 | 336 |
1998194 | 1998194 | 2021-12-09 | Starr | Texas | 48427 | 11814 | 336 |
1910403 | 1910403 | 2021-11-12 | Parker | Texas | 48367 | 24653 | 336 |
1877830 | 1877830 | 2021-11-02 | Henderson | Texas | 48213 | 9791 | 336 |
1874568 | 1874568 | 2021-11-01 | Guadalupe | Texas | 48187 | 24446 | 336 |
1874581 | 1874581 | 2021-11-01 | Henderson | Texas | 48213 | 9756 | 336 |
1871319 | 1871319 | 2021-10-31 | Guadalupe | Texas | 48187 | 24425 | 336 |
1871332 | 1871332 | 2021-10-31 | Henderson | Texas | 48213 | 9756 | 336 |
1868070 | 1868070 | 2021-10-30 | Guadalupe | Texas | 48187 | 24425 | 336 |
1868083 | 1868083 | 2021-10-30 | Henderson | Texas | 48213 | 9756 | 336 |
1864821 | 1864821 | 2021-10-29 | Guadalupe | Texas | 48187 | 24425 | 336 |
1864834 | 1864834 | 2021-10-29 | Henderson | Texas | 48213 | 9756 | 336 |
1793266 | 1793266 | 2021-10-07 | Brazos | Texas | 48041 | 37956 | 336 |
1790017 | 1790017 | 2021-10-06 | Brazos | Texas | 48041 | 37870 | 336 |
1728265 | 1728265 | 2021-09-17 | Angelina | Texas | 48005 | 12620 | 336 |
1725142 | 1725142 | 2021-09-16 | Kaufman | Texas | 48257 | 21638 | 336 |
1647126 | 1647126 | 2021-08-23 | Ellis | Texas | 48139 | 25854 | 336 |
1643877 | 1643877 | 2021-08-22 | Ellis | Texas | 48139 | 25854 | 336 |
1640627 | 1640627 | 2021-08-21 | Ellis | Texas | 48139 | 25854 | 336 |
1637377 | 1637377 | 2021-08-20 | Ellis | Texas | 48139 | 25790 | 336 |
1169843 | 1169843 | 2021-03-29 | Grayson | Texas | 48181 | 11039 | 336 |
1166595 | 1166595 | 2021-03-28 | Grayson | Texas | 48181 | 11039 | 336 |
1163347 | 1163347 | 2021-03-27 | Grayson | Texas | 48181 | 11039 | 336 |
1130877 | 1130877 | 2021-03-17 | Gregg | Texas | 48183 | 10814 | 336 |
1101694 | 1101694 | 2021-03-08 | Johnson | Texas | 48251 | 18775 | 336 |
1085405 | 1085405 | 2021-03-03 | Ector | Texas | 48135 | 16373 | 336 |
1082159 | 1082159 | 2021-03-02 | Ector | Texas | 48135 | 16365 | 336 |
1065947 | 1065947 | 2021-02-25 | Galveston | Texas | 48167 | 34137 | 336 |
1059616 | 1059616 | 2021-02-23 | Wichita | Texas | 48485 | 14509 | 336 |
1010910 | 1010910 | 2021-02-08 | Taylor | Texas | 48441 | 14832 | 336 |
1007664 | 1007664 | 2021-02-07 | Taylor | Texas | 48441 | 14743 | 336 |
790077 | 790077 | 2020-12-02 | Fort Bend | Texas | 48157 | 23353 | 336 |
631253 | 631253 | 2020-10-14 | Webb | Texas | 48479 | 14488 | 336 |
472526 | 472526 | 2020-08-26 | Nueces | Texas | 48355 | 18444 | 336 |
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);