ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where deaths = 340 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456812 | 2456812 | 2022-04-29 | San Patricio | Texas | 48409 | 11071 | 340 |
2453556 | 2453556 | 2022-04-28 | San Patricio | Texas | 48409 | 11069 | 340 |
2450300 | 2450300 | 2022-04-27 | San Patricio | Texas | 48409 | 11067 | 340 |
2447043 | 2447043 | 2022-04-26 | San Patricio | Texas | 48409 | 11064 | 340 |
2443788 | 2443788 | 2022-04-25 | San Patricio | Texas | 48409 | 11064 | 340 |
2440532 | 2440532 | 2022-04-24 | San Patricio | Texas | 48409 | 11064 | 340 |
2437276 | 2437276 | 2022-04-23 | San Patricio | Texas | 48409 | 11062 | 340 |
2434020 | 2434020 | 2022-04-22 | San Patricio | Texas | 48409 | 11061 | 340 |
2430764 | 2430764 | 2022-04-21 | San Patricio | Texas | 48409 | 11061 | 340 |
2427508 | 2427508 | 2022-04-20 | San Patricio | Texas | 48409 | 11061 | 340 |
2271306 | 2271306 | 2022-03-03 | Orange | Texas | 48361 | 14901 | 340 |
2180287 | 2180287 | 2022-02-03 | Starr | Texas | 48427 | 17076 | 340 |
2177036 | 2177036 | 2022-02-02 | Starr | Texas | 48427 | 16993 | 340 |
2173782 | 2173782 | 2022-02-01 | Starr | Texas | 48427 | 16858 | 340 |
2170530 | 2170530 | 2022-01-31 | Starr | Texas | 48427 | 16461 | 340 |
2167276 | 2167276 | 2022-01-30 | Starr | Texas | 48427 | 16406 | 340 |
2164021 | 2164021 | 2022-01-29 | Starr | Texas | 48427 | 16361 | 340 |
1923237 | 1923237 | 2021-11-16 | Bowie | Texas | 48037 | 12846 | 340 |
1907064 | 1907064 | 2021-11-11 | Guadalupe | Texas | 48187 | 24467 | 340 |
1903815 | 1903815 | 2021-11-10 | Guadalupe | Texas | 48187 | 24467 | 340 |
1900565 | 1900565 | 2021-11-09 | Guadalupe | Texas | 48187 | 24467 | 340 |
1897315 | 1897315 | 2021-11-08 | Guadalupe | Texas | 48187 | 24459 | 340 |
1897328 | 1897328 | 2021-11-08 | Henderson | Texas | 48213 | 9806 | 340 |
1894065 | 1894065 | 2021-11-07 | Guadalupe | Texas | 48187 | 24455 | 340 |
1894078 | 1894078 | 2021-11-07 | Henderson | Texas | 48213 | 9806 | 340 |
1890815 | 1890815 | 2021-11-06 | Guadalupe | Texas | 48187 | 24455 | 340 |
1890828 | 1890828 | 2021-11-06 | Henderson | Texas | 48213 | 9806 | 340 |
1887565 | 1887565 | 2021-11-05 | Guadalupe | Texas | 48187 | 24455 | 340 |
1887578 | 1887578 | 2021-11-05 | Henderson | Texas | 48213 | 9806 | 340 |
1884315 | 1884315 | 2021-11-04 | Guadalupe | Texas | 48187 | 24448 | 340 |
1855215 | 1855215 | 2021-10-26 | Victoria | Texas | 48469 | 13049 | 340 |
1851966 | 1851966 | 2021-10-25 | Victoria | Texas | 48469 | 13046 | 340 |
1848716 | 1848716 | 2021-10-24 | Victoria | Texas | 48469 | 13043 | 340 |
1845466 | 1845466 | 2021-10-23 | Victoria | Texas | 48469 | 13043 | 340 |
1773915 | 1773915 | 2021-10-01 | Midland | Texas | 48329 | 26831 | 340 |
1734891 | 1734891 | 2021-09-19 | Kaufman | Texas | 48257 | 21817 | 340 |
1731641 | 1731641 | 2021-09-18 | Kaufman | Texas | 48257 | 21817 | 340 |
1718621 | 1718621 | 2021-09-14 | Hays | Texas | 48209 | 30217 | 340 |
1718707 | 1718707 | 2021-09-14 | Randall | Texas | 48381 | 21605 | 340 |
1715373 | 1715373 | 2021-09-13 | Hays | Texas | 48209 | 29933 | 340 |
1335447 | 1335447 | 2021-05-19 | Grayson | Texas | 48181 | 11329 | 340 |
1332200 | 1332200 | 2021-05-18 | Grayson | Texas | 48181 | 11326 | 340 |
1328953 | 1328953 | 2021-05-17 | Grayson | Texas | 48181 | 11308 | 340 |
1325707 | 1325707 | 2021-05-16 | Grayson | Texas | 48181 | 11308 | 340 |
1322461 | 1322461 | 2021-05-15 | Grayson | Texas | 48181 | 11308 | 340 |
1319215 | 1319215 | 2021-05-14 | Grayson | Texas | 48181 | 11307 | 340 |
1315967 | 1315967 | 2021-05-13 | Grayson | Texas | 48181 | 11307 | 340 |
1312721 | 1312721 | 2021-05-12 | Grayson | Texas | 48181 | 11302 | 340 |
1309474 | 1309474 | 2021-05-11 | Grayson | Texas | 48181 | 11299 | 340 |
1306228 | 1306228 | 2021-05-10 | Grayson | Texas | 48181 | 11294 | 340 |
1302982 | 1302982 | 2021-05-09 | Grayson | Texas | 48181 | 11294 | 340 |
1299735 | 1299735 | 2021-05-08 | Grayson | Texas | 48181 | 11294 | 340 |
1296488 | 1296488 | 2021-05-07 | Grayson | Texas | 48181 | 11288 | 340 |
1293242 | 1293242 | 2021-05-06 | Grayson | Texas | 48181 | 11288 | 340 |
1289996 | 1289996 | 2021-05-05 | Grayson | Texas | 48181 | 11285 | 340 |
1286750 | 1286750 | 2021-05-04 | Grayson | Texas | 48181 | 11284 | 340 |
1283504 | 1283504 | 2021-05-03 | Grayson | Texas | 48181 | 11264 | 340 |
1280257 | 1280257 | 2021-05-02 | Grayson | Texas | 48181 | 11264 | 340 |
1277010 | 1277010 | 2021-05-01 | Grayson | Texas | 48181 | 11264 | 340 |
1273763 | 1273763 | 2021-04-30 | Grayson | Texas | 48181 | 11260 | 340 |
1270516 | 1270516 | 2021-04-29 | Grayson | Texas | 48181 | 11254 | 340 |
1267269 | 1267269 | 2021-04-28 | Grayson | Texas | 48181 | 11251 | 340 |
1264022 | 1264022 | 2021-04-27 | Grayson | Texas | 48181 | 11243 | 340 |
1260775 | 1260775 | 2021-04-26 | Grayson | Texas | 48181 | 11230 | 340 |
1257528 | 1257528 | 2021-04-25 | Grayson | Texas | 48181 | 11230 | 340 |
1254281 | 1254281 | 2021-04-24 | Grayson | Texas | 48181 | 11230 | 340 |
1251034 | 1251034 | 2021-04-23 | Grayson | Texas | 48181 | 11222 | 340 |
1247787 | 1247787 | 2021-04-22 | Grayson | Texas | 48181 | 11218 | 340 |
1244540 | 1244540 | 2021-04-21 | Grayson | Texas | 48181 | 11214 | 340 |
1072477 | 1072477 | 2021-02-27 | Jefferson | Texas | 48245 | 18159 | 340 |
1069231 | 1069231 | 2021-02-26 | Jefferson | Texas | 48245 | 18113 | 340 |
1065986 | 1065986 | 2021-02-25 | Jefferson | Texas | 48245 | 18072 | 340 |
1014155 | 1014155 | 2021-02-09 | Taylor | Texas | 48441 | 14843 | 340 |
997951 | 997951 | 2021-02-04 | Williamson | Texas | 48491 | 37674 | 340 |
978439 | 978439 | 2021-01-29 | Smith | Texas | 48423 | 17206 | 340 |
952437 | 952437 | 2021-01-21 | Montgomery | Texas | 48339 | 35171 | 340 |
858196 | 858196 | 2020-12-23 | Collin | Texas | 48085 | 43169 | 340 |
770680 | 770680 | 2020-11-26 | Lubbock | Texas | 48303 | 30911 | 340 |
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);