ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where deaths = 207 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476268 | 2476268 | 2022-05-05 | Jim Wells | Texas | 48249 | 11384 | 207 |
2473011 | 2473011 | 2022-05-04 | Jim Wells | Texas | 48249 | 11378 | 207 |
2469755 | 2469755 | 2022-05-03 | Jim Wells | Texas | 48249 | 11374 | 207 |
2466499 | 2466499 | 2022-05-02 | Jim Wells | Texas | 48249 | 11368 | 207 |
2463244 | 2463244 | 2022-05-01 | Jim Wells | Texas | 48249 | 11367 | 207 |
2459988 | 2459988 | 2022-04-30 | Jim Wells | Texas | 48249 | 11366 | 207 |
2456732 | 2456732 | 2022-04-29 | Jim Wells | Texas | 48249 | 11356 | 207 |
2453476 | 2453476 | 2022-04-28 | Jim Wells | Texas | 48249 | 11334 | 207 |
2450220 | 2450220 | 2022-04-27 | Jim Wells | Texas | 48249 | 11324 | 207 |
2446963 | 2446963 | 2022-04-26 | Jim Wells | Texas | 48249 | 11318 | 207 |
2443708 | 2443708 | 2022-04-25 | Jim Wells | Texas | 48249 | 11298 | 207 |
2440452 | 2440452 | 2022-04-24 | Jim Wells | Texas | 48249 | 11297 | 207 |
2437196 | 2437196 | 2022-04-23 | Jim Wells | Texas | 48249 | 11297 | 207 |
2433940 | 2433940 | 2022-04-22 | Jim Wells | Texas | 48249 | 11292 | 207 |
2430684 | 2430684 | 2022-04-21 | Jim Wells | Texas | 48249 | 11283 | 207 |
2427428 | 2427428 | 2022-04-20 | Jim Wells | Texas | 48249 | 11278 | 207 |
2424172 | 2424172 | 2022-04-19 | Jim Wells | Texas | 48249 | 11270 | 207 |
2420916 | 2420916 | 2022-04-18 | Jim Wells | Texas | 48249 | 11266 | 207 |
2417660 | 2417660 | 2022-04-17 | Jim Wells | Texas | 48249 | 11257 | 207 |
2414404 | 2414404 | 2022-04-16 | Jim Wells | Texas | 48249 | 11257 | 207 |
2411148 | 2411148 | 2022-04-15 | Jim Wells | Texas | 48249 | 11257 | 207 |
2407892 | 2407892 | 2022-04-14 | Jim Wells | Texas | 48249 | 11257 | 207 |
2404636 | 2404636 | 2022-04-13 | Jim Wells | Texas | 48249 | 11255 | 207 |
2401381 | 2401381 | 2022-04-12 | Jim Wells | Texas | 48249 | 11252 | 207 |
2398126 | 2398126 | 2022-04-11 | Jim Wells | Texas | 48249 | 11247 | 207 |
2394871 | 2394871 | 2022-04-10 | Jim Wells | Texas | 48249 | 11247 | 207 |
2391615 | 2391615 | 2022-04-09 | Jim Wells | Texas | 48249 | 11247 | 207 |
2290881 | 2290881 | 2022-03-09 | Wharton | Texas | 48481 | 8850 | 207 |
2264856 | 2264856 | 2022-03-01 | Walker | Texas | 48471 | 18260 | 207 |
2261606 | 2261606 | 2022-02-28 | Walker | Texas | 48471 | 18245 | 207 |
2203047 | 2203047 | 2022-02-10 | Rusk | Texas | 48401 | 10324 | 207 |
2199694 | 2199694 | 2022-02-09 | Harrison | Texas | 48203 | 12445 | 207 |
2180248 | 2180248 | 2022-02-03 | Navarro | Texas | 48349 | 11828 | 207 |
2176997 | 2176997 | 2022-02-02 | Navarro | Texas | 48349 | 11714 | 207 |
2001479 | 2001479 | 2021-12-10 | Wise | Texas | 48497 | 11718 | 207 |
1998229 | 1998229 | 2021-12-09 | Wise | Texas | 48497 | 11668 | 207 |
1994978 | 1994978 | 2021-12-08 | Wise | Texas | 48497 | 11662 | 207 |
1991727 | 1991727 | 2021-12-07 | Wise | Texas | 48497 | 11647 | 207 |
1988476 | 1988476 | 2021-12-06 | Wise | Texas | 48497 | 11641 | 207 |
1985226 | 1985226 | 2021-12-05 | Wise | Texas | 48497 | 11632 | 207 |
1981976 | 1981976 | 2021-12-04 | Wise | Texas | 48497 | 11630 | 207 |
1978484 | 1978484 | 2021-12-03 | Atascosa | Texas | 48013 | 8756 | 207 |
1978726 | 1978726 | 2021-12-03 | Wise | Texas | 48497 | 11613 | 207 |
1975234 | 1975234 | 2021-12-02 | Atascosa | Texas | 48013 | 8747 | 207 |
1975476 | 1975476 | 2021-12-02 | Wise | Texas | 48497 | 11604 | 207 |
1920080 | 1920080 | 2021-11-15 | Hood | Texas | 48221 | 9826 | 207 |
1916830 | 1916830 | 2021-11-14 | Hood | Texas | 48221 | 9826 | 207 |
1913580 | 1913580 | 2021-11-13 | Hood | Texas | 48221 | 9826 | 207 |
1910330 | 1910330 | 2021-11-12 | Hood | Texas | 48221 | 9812 | 207 |
1877910 | 1877910 | 2021-11-02 | Polk | Texas | 48373 | 5930 | 207 |
1871365 | 1871365 | 2021-10-31 | Lamar | Texas | 48277 | 8828 | 207 |
1868116 | 1868116 | 2021-10-30 | Lamar | Texas | 48277 | 8828 | 207 |
1864867 | 1864867 | 2021-10-29 | Lamar | Texas | 48277 | 8828 | 207 |
1861618 | 1861618 | 2021-10-28 | Lamar | Texas | 48277 | 8828 | 207 |
1858369 | 1858369 | 2021-10-27 | Lamar | Texas | 48277 | 8828 | 207 |
1842215 | 1842215 | 2021-10-22 | Van Zandt | Texas | 48467 | 7896 | 207 |
1838966 | 1838966 | 2021-10-21 | Van Zandt | Texas | 48467 | 7896 | 207 |
1835717 | 1835717 | 2021-10-20 | Van Zandt | Texas | 48467 | 7896 | 207 |
1809691 | 1809691 | 2021-10-12 | Rockwall | Texas | 48397 | 17184 | 207 |
1806441 | 1806441 | 2021-10-11 | Rockwall | Texas | 48397 | 17077 | 207 |
1803191 | 1803191 | 2021-10-10 | Rockwall | Texas | 48397 | 17077 | 207 |
1799942 | 1799942 | 2021-10-09 | Rockwall | Texas | 48397 | 17077 | 207 |
1796693 | 1796693 | 2021-10-08 | Rockwall | Texas | 48397 | 17039 | 207 |
1770674 | 1770674 | 2021-09-30 | Nacogdoches | Texas | 48347 | 7426 | 207 |
1695897 | 1695897 | 2021-09-07 | Hunt | Texas | 48231 | 8929 | 207 |
1692649 | 1692649 | 2021-09-06 | Hunt | Texas | 48231 | 8781 | 207 |
1689400 | 1689400 | 2021-09-05 | Hunt | Texas | 48231 | 8599 | 207 |
1630916 | 1630916 | 2021-08-18 | Henderson | Texas | 48213 | 6975 | 207 |
1591977 | 1591977 | 2021-08-06 | Liberty | Texas | 48291 | 8827 | 207 |
1588728 | 1588728 | 2021-08-05 | Liberty | Texas | 48291 | 8761 | 207 |
1286894 | 1286894 | 2021-05-04 | Victoria | Texas | 48469 | 8634 | 207 |
1202248 | 1202248 | 2021-04-08 | Bowie | Texas | 48037 | 6858 | 207 |
1198999 | 1198999 | 2021-04-07 | Bowie | Texas | 48037 | 6856 | 207 |
1195750 | 1195750 | 2021-04-06 | Bowie | Texas | 48037 | 6852 | 207 |
1195825 | 1195825 | 2021-04-06 | Guadalupe | Texas | 48187 | 13992 | 207 |
1192502 | 1192502 | 2021-04-05 | Bowie | Texas | 48037 | 6855 | 207 |
1192577 | 1192577 | 2021-04-05 | Guadalupe | Texas | 48187 | 13960 | 207 |
1189253 | 1189253 | 2021-04-04 | Bowie | Texas | 48037 | 6848 | 207 |
1189328 | 1189328 | 2021-04-04 | Guadalupe | Texas | 48187 | 13960 | 207 |
1186006 | 1186006 | 2021-04-03 | Bowie | Texas | 48037 | 6848 | 207 |
1186081 | 1186081 | 2021-04-03 | Guadalupe | Texas | 48187 | 13960 | 207 |
939410 | 939410 | 2021-01-17 | Johnson | Texas | 48251 | 14435 | 207 |
923217 | 923217 | 2021-01-12 | Maverick | Texas | 48323 | 7473 | 207 |
919972 | 919972 | 2021-01-11 | Maverick | Texas | 48323 | 7227 | 207 |
916727 | 916727 | 2021-01-10 | Maverick | Texas | 48323 | 7227 | 207 |
913482 | 913482 | 2021-01-09 | Maverick | Texas | 48323 | 7227 | 207 |
907024 | 907024 | 2021-01-07 | Randall | Texas | 48381 | 14585 | 207 |
858221 | 858221 | 2020-12-23 | Ector | Texas | 48135 | 11463 | 207 |
858276 | 858276 | 2020-12-23 | Jefferson | Texas | 48245 | 12756 | 207 |
802998 | 802998 | 2020-12-06 | Brazoria | Texas | 48039 | 15213 | 207 |
799753 | 799753 | 2020-12-05 | Brazoria | Texas | 48039 | 15088 | 207 |
796700 | 796700 | 2020-12-04 | Smith | Texas | 48423 | 10366 | 207 |
786941 | 786941 | 2020-12-01 | Potter | Texas | 48375 | 12833 | 207 |
767452 | 767452 | 2020-11-25 | Montgomery | Texas | 48339 | 16982 | 207 |
725134 | 725134 | 2020-11-12 | Collin | Texas | 48085 | 21034 | 207 |
446758 | 446758 | 2020-08-18 | Webb | Texas | 48479 | 9857 | 207 |
255307 | 255307 | 2020-06-19 | Tarrant | Texas | 48439 | 8331 | 207 |
168836 | 168836 | 2020-05-22 | Dallas | Texas | 48113 | 8477 | 207 |
159784 | 159784 | 2020-05-19 | Harris | Texas | 48201 | 9859 | 207 |
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);