ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where deaths = 203 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287513 | 2287513 | 2022-03-08 | Jim Wells | Texas | 48249 | 11084 | 203 |
2284261 | 2284261 | 2022-03-07 | Jim Wells | Texas | 48249 | 11080 | 203 |
2281009 | 2281009 | 2022-03-06 | Jim Wells | Texas | 48249 | 11077 | 203 |
2261420 | 2261420 | 2022-02-28 | Coryell | Texas | 48099 | 17077 | 203 |
2261611 | 2261611 | 2022-02-28 | Wharton | Texas | 48481 | 8712 | 203 |
2258169 | 2258169 | 2022-02-27 | Coryell | Texas | 48099 | 17074 | 203 |
2258360 | 2258360 | 2022-02-27 | Wharton | Texas | 48481 | 8664 | 203 |
2254918 | 2254918 | 2022-02-26 | Coryell | Texas | 48099 | 17074 | 203 |
2255109 | 2255109 | 2022-02-26 | Wharton | Texas | 48481 | 8663 | 203 |
2251667 | 2251667 | 2022-02-25 | Coryell | Texas | 48099 | 17070 | 203 |
2251858 | 2251858 | 2022-02-25 | Wharton | Texas | 48481 | 8652 | 203 |
2242100 | 2242100 | 2022-02-22 | Walker | Texas | 48471 | 18183 | 203 |
2238849 | 2238849 | 2022-02-21 | Walker | Texas | 48471 | 18172 | 203 |
2235598 | 2235598 | 2022-02-20 | Walker | Texas | 48471 | 18162 | 203 |
2232347 | 2232347 | 2022-02-19 | Walker | Texas | 48471 | 18157 | 203 |
2229096 | 2229096 | 2022-02-18 | Walker | Texas | 48471 | 18119 | 203 |
2225845 | 2225845 | 2022-02-17 | Walker | Texas | 48471 | 18083 | 203 |
2190031 | 2190031 | 2022-02-06 | Rusk | Texas | 48401 | 10251 | 203 |
2180084 | 2180084 | 2022-02-03 | Bastrop | Texas | 48021 | 20815 | 203 |
2176924 | 2176924 | 2022-02-02 | Harrison | Texas | 48203 | 12145 | 203 |
2173670 | 2173670 | 2022-02-01 | Harrison | Texas | 48203 | 12097 | 203 |
2170418 | 2170418 | 2022-01-31 | Harrison | Texas | 48203 | 12047 | 203 |
2170491 | 2170491 | 2022-01-31 | Navarro | Texas | 48349 | 11647 | 203 |
2167164 | 2167164 | 2022-01-30 | Harrison | Texas | 48203 | 12005 | 203 |
2163909 | 2163909 | 2022-01-29 | Harrison | Texas | 48203 | 11969 | 203 |
2163982 | 2163982 | 2022-01-29 | Navarro | Texas | 48349 | 11586 | 203 |
2160727 | 2160727 | 2022-01-28 | Navarro | Texas | 48349 | 11476 | 203 |
2157471 | 2157471 | 2022-01-27 | Navarro | Texas | 48349 | 11393 | 203 |
2076083 | 2076083 | 2022-01-02 | Hale | Texas | 48189 | 8368 | 203 |
2072832 | 2072832 | 2022-01-01 | Hale | Texas | 48189 | 8368 | 203 |
2069581 | 2069581 | 2021-12-31 | Hale | Texas | 48189 | 8368 | 203 |
2066330 | 2066330 | 2021-12-30 | Hale | Texas | 48189 | 8368 | 203 |
2063080 | 2063080 | 2021-12-29 | Hale | Texas | 48189 | 8365 | 203 |
2059830 | 2059830 | 2021-12-28 | Hale | Texas | 48189 | 8361 | 203 |
2056581 | 2056581 | 2021-12-27 | Hale | Texas | 48189 | 8355 | 203 |
2053332 | 2053332 | 2021-12-26 | Hale | Texas | 48189 | 8303 | 203 |
2050082 | 2050082 | 2021-12-25 | Hale | Texas | 48189 | 8303 | 203 |
2046832 | 2046832 | 2021-12-24 | Hale | Texas | 48189 | 8303 | 203 |
2043582 | 2043582 | 2021-12-23 | Hale | Texas | 48189 | 8303 | 203 |
1903970 | 1903970 | 2021-11-10 | Wise | Texas | 48497 | 11463 | 203 |
1900720 | 1900720 | 2021-11-09 | Wise | Texas | 48497 | 11463 | 203 |
1874661 | 1874661 | 2021-11-01 | Polk | Texas | 48373 | 5930 | 203 |
1871412 | 1871412 | 2021-10-31 | Polk | Texas | 48373 | 5930 | 203 |
1864734 | 1864734 | 2021-10-29 | Atascosa | Texas | 48013 | 8566 | 203 |
1861485 | 1861485 | 2021-10-28 | Atascosa | Texas | 48013 | 8563 | 203 |
1858236 | 1858236 | 2021-10-27 | Atascosa | Texas | 48013 | 8533 | 203 |
1855080 | 1855080 | 2021-10-26 | Hardin | Texas | 48199 | 10348 | 203 |
1842121 | 1842121 | 2021-10-22 | Lamar | Texas | 48277 | 8779 | 203 |
1838832 | 1838832 | 2021-10-21 | Hardin | Texas | 48199 | 10331 | 203 |
1829085 | 1829085 | 2021-10-18 | Hardin | Texas | 48199 | 10288 | 203 |
1829219 | 1829219 | 2021-10-18 | Van Zandt | Texas | 48467 | 7857 | 203 |
1825970 | 1825970 | 2021-10-17 | Van Zandt | Texas | 48467 | 7857 | 203 |
1777199 | 1777199 | 2021-10-02 | Rockwall | Texas | 48397 | 16832 | 203 |
1760927 | 1760927 | 2021-09-27 | Nacogdoches | Texas | 48347 | 7301 | 203 |
1757679 | 1757679 | 2021-09-26 | Nacogdoches | Texas | 48347 | 7301 | 203 |
1682899 | 1682899 | 2021-09-03 | Hunt | Texas | 48231 | 8474 | 203 |
1621252 | 1621252 | 2021-08-15 | Parker | Texas | 48367 | 18080 | 203 |
1618004 | 1618004 | 2021-08-14 | Parker | Texas | 48367 | 18080 | 203 |
1614756 | 1614756 | 2021-08-13 | Parker | Texas | 48367 | 17993 | 203 |
1611430 | 1611430 | 2021-08-12 | Henderson | Texas | 48213 | 6709 | 203 |
1595187 | 1595187 | 2021-08-07 | Henderson | Texas | 48213 | 6564 | 203 |
1565987 | 1565987 | 2021-07-29 | Liberty | Texas | 48291 | 8488 | 203 |
1562739 | 1562739 | 2021-07-28 | Liberty | Texas | 48291 | 8447 | 203 |
1559491 | 1559491 | 2021-07-27 | Liberty | Texas | 48291 | 8424 | 203 |
1556244 | 1556244 | 2021-07-26 | Liberty | Texas | 48291 | 8400 | 203 |
1552997 | 1552997 | 2021-07-25 | Liberty | Texas | 48291 | 8382 | 203 |
1549750 | 1549750 | 2021-07-24 | Liberty | Texas | 48291 | 8363 | 203 |
1546503 | 1546503 | 2021-07-23 | Liberty | Texas | 48291 | 8352 | 203 |
1543256 | 1543256 | 2021-07-22 | Liberty | Texas | 48291 | 8334 | 203 |
1540008 | 1540008 | 2021-07-21 | Liberty | Texas | 48291 | 8304 | 203 |
1536761 | 1536761 | 2021-07-20 | Liberty | Texas | 48291 | 8303 | 203 |
1533513 | 1533513 | 2021-07-19 | Liberty | Texas | 48291 | 8295 | 203 |
1530266 | 1530266 | 2021-07-18 | Liberty | Texas | 48291 | 8292 | 203 |
1527019 | 1527019 | 2021-07-17 | Liberty | Texas | 48291 | 8271 | 203 |
1523772 | 1523772 | 2021-07-16 | Liberty | Texas | 48291 | 8268 | 203 |
1520524 | 1520524 | 2021-07-15 | Liberty | Texas | 48291 | 8257 | 203 |
1517276 | 1517276 | 2021-07-14 | Liberty | Texas | 48291 | 8253 | 203 |
1514029 | 1514029 | 2021-07-13 | Liberty | Texas | 48291 | 8248 | 203 |
1176265 | 1176265 | 2021-03-31 | Bowie | Texas | 48037 | 6825 | 203 |
1160101 | 1160101 | 2021-03-26 | Guadalupe | Texas | 48187 | 13811 | 203 |
958761 | 958761 | 2021-01-23 | Angelina | Texas | 48005 | 6875 | 203 |
949187 | 949187 | 2021-01-20 | Midland | Texas | 48329 | 13334 | 203 |
932920 | 932920 | 2021-01-15 | Johnson | Texas | 48251 | 14259 | 203 |
894065 | 894065 | 2021-01-03 | Starr | Texas | 48427 | 6354 | 203 |
890819 | 890819 | 2021-01-02 | Starr | Texas | 48427 | 6260 | 203 |
887572 | 887572 | 2021-01-01 | Starr | Texas | 48427 | 6260 | 203 |
854976 | 854976 | 2020-12-22 | Ector | Texas | 48135 | 11463 | 203 |
845296 | 845296 | 2020-12-19 | Jefferson | Texas | 48245 | 12365 | 203 |
790159 | 790159 | 2020-12-02 | McLennan | Texas | 48309 | 14672 | 203 |
790210 | 790210 | 2020-12-02 | Smith | Texas | 48423 | 9900 | 203 |
786965 | 786965 | 2020-12-01 | Smith | Texas | 48423 | 9790 | 203 |
350233 | 350233 | 2020-07-19 | Travis | Texas | 48453 | 17646 | 203 |
347033 | 347033 | 2020-07-18 | Travis | Texas | 48453 | 17454 | 203 |
165800 | 165800 | 2020-05-21 | Dallas | Texas | 48113 | 8273 | 203 |
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);