ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where deaths = 179 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495802 | 2495802 | 2022-05-11 | Hopkins | Texas | 48223 | 7261 | 179 |
2310382 | 2310382 | 2022-03-15 | Upshur | Texas | 48459 | 7708 | 179 |
2307013 | 2307013 | 2022-03-14 | Howard | Texas | 48227 | 6694 | 179 |
2307129 | 2307129 | 2022-03-14 | Upshur | Texas | 48459 | 7703 | 179 |
2303762 | 2303762 | 2022-03-13 | Howard | Texas | 48227 | 6694 | 179 |
2303878 | 2303878 | 2022-03-13 | Upshur | Texas | 48459 | 7703 | 179 |
2300510 | 2300510 | 2022-03-12 | Howard | Texas | 48227 | 6694 | 179 |
2297258 | 2297258 | 2022-03-11 | Howard | Texas | 48227 | 6694 | 179 |
2297277 | 2297277 | 2022-03-11 | Kerr | Texas | 48265 | 9514 | 179 |
2294006 | 2294006 | 2022-03-10 | Howard | Texas | 48227 | 6694 | 179 |
2294025 | 2294025 | 2022-03-10 | Kerr | Texas | 48265 | 9514 | 179 |
2290714 | 2290714 | 2022-03-09 | Fannin | Texas | 48147 | 6785 | 179 |
2290773 | 2290773 | 2022-03-09 | Kerr | Texas | 48265 | 9508 | 179 |
2287462 | 2287462 | 2022-03-08 | Fannin | Texas | 48147 | 6782 | 179 |
2287521 | 2287521 | 2022-03-08 | Kerr | Texas | 48265 | 9504 | 179 |
2284210 | 2284210 | 2022-03-07 | Fannin | Texas | 48147 | 6774 | 179 |
2280958 | 2280958 | 2022-03-06 | Fannin | Texas | 48147 | 6772 | 179 |
2206133 | 2206133 | 2022-02-11 | Cass | Texas | 48067 | 6684 | 179 |
2176872 | 2176872 | 2022-02-02 | Coryell | Texas | 48099 | 16275 | 179 |
2176985 | 2176985 | 2022-02-02 | Medina | Texas | 48325 | 9356 | 179 |
2173618 | 2173618 | 2022-02-01 | Coryell | Texas | 48099 | 16213 | 179 |
2173731 | 2173731 | 2022-02-01 | Medina | Texas | 48325 | 9304 | 179 |
2170479 | 2170479 | 2022-01-31 | Medina | Texas | 48325 | 9218 | 179 |
2167225 | 2167225 | 2022-01-30 | Medina | Texas | 48325 | 9186 | 179 |
1919980 | 1919980 | 2021-11-15 | Bastrop | Texas | 48021 | 14416 | 179 |
1920094 | 1920094 | 2021-11-15 | Jim Wells | Texas | 48249 | 7194 | 179 |
1916730 | 1916730 | 2021-11-14 | Bastrop | Texas | 48021 | 14416 | 179 |
1916844 | 1916844 | 2021-11-14 | Jim Wells | Texas | 48249 | 7194 | 179 |
1913480 | 1913480 | 2021-11-13 | Bastrop | Texas | 48021 | 14403 | 179 |
1913594 | 1913594 | 2021-11-13 | Jim Wells | Texas | 48249 | 7193 | 179 |
1910230 | 1910230 | 2021-11-12 | Bastrop | Texas | 48021 | 14403 | 179 |
1910344 | 1910344 | 2021-11-12 | Jim Wells | Texas | 48249 | 7190 | 179 |
1903922 | 1903922 | 2021-11-10 | Rusk | Texas | 48401 | 8160 | 179 |
1900672 | 1900672 | 2021-11-09 | Rusk | Texas | 48401 | 8160 | 179 |
1897422 | 1897422 | 2021-11-08 | Rusk | Texas | 48401 | 8171 | 179 |
1894172 | 1894172 | 2021-11-07 | Rusk | Texas | 48401 | 8171 | 179 |
1890922 | 1890922 | 2021-11-06 | Rusk | Texas | 48401 | 8171 | 179 |
1887573 | 1887573 | 2021-11-05 | Harrison | Texas | 48203 | 9189 | 179 |
1887672 | 1887672 | 2021-11-05 | Rusk | Texas | 48401 | 8165 | 179 |
1884323 | 1884323 | 2021-11-04 | Harrison | Texas | 48203 | 9186 | 179 |
1884422 | 1884422 | 2021-11-04 | Rusk | Texas | 48401 | 8169 | 179 |
1881074 | 1881074 | 2021-11-03 | Harrison | Texas | 48203 | 9183 | 179 |
1881173 | 1881173 | 2021-11-03 | Rusk | Texas | 48401 | 8163 | 179 |
1877825 | 1877825 | 2021-11-02 | Harrison | Texas | 48203 | 9182 | 179 |
1877924 | 1877924 | 2021-11-02 | Rusk | Texas | 48401 | 8166 | 179 |
1874576 | 1874576 | 2021-11-01 | Harrison | Texas | 48203 | 9168 | 179 |
1874675 | 1874675 | 2021-11-01 | Rusk | Texas | 48401 | 8155 | 179 |
1871426 | 1871426 | 2021-10-31 | Rusk | Texas | 48401 | 8155 | 179 |
1842222 | 1842222 | 2021-10-22 | Wharton | Texas | 48481 | 6218 | 179 |
1816014 | 1816014 | 2021-10-14 | Brown | Texas | 48049 | 6901 | 179 |
1816164 | 1816164 | 2021-10-14 | Navarro | Texas | 48349 | 8589 | 179 |
1812766 | 1812766 | 2021-10-13 | Brown | Texas | 48049 | 6901 | 179 |
1809517 | 1809517 | 2021-10-12 | Brown | Texas | 48049 | 6901 | 179 |
1806267 | 1806267 | 2021-10-11 | Brown | Texas | 48049 | 6901 | 179 |
1806491 | 1806491 | 2021-10-11 | Wise | Texas | 48497 | 10891 | 179 |
1803017 | 1803017 | 2021-10-10 | Brown | Texas | 48049 | 6901 | 179 |
1803241 | 1803241 | 2021-10-10 | Wise | Texas | 48497 | 10891 | 179 |
1799768 | 1799768 | 2021-10-09 | Brown | Texas | 48049 | 6901 | 179 |
1799992 | 1799992 | 2021-10-09 | Wise | Texas | 48497 | 10891 | 179 |
1796519 | 1796519 | 2021-10-08 | Brown | Texas | 48049 | 6901 | 179 |
1796743 | 1796743 | 2021-10-08 | Wise | Texas | 48497 | 10863 | 179 |
1777187 | 1777187 | 2021-10-02 | Polk | Texas | 48373 | 5730 | 179 |
1773937 | 1773937 | 2021-10-01 | Polk | Texas | 48373 | 5730 | 179 |
1747797 | 1747797 | 2021-09-23 | Cherokee | Texas | 48073 | 6469 | 179 |
1738152 | 1738152 | 2021-09-20 | Lamar | Texas | 48277 | 8157 | 179 |
1734902 | 1734902 | 2021-09-19 | Lamar | Texas | 48277 | 8013 | 179 |
1731652 | 1731652 | 2021-09-18 | Lamar | Texas | 48277 | 8013 | 179 |
1699228 | 1699228 | 2021-09-08 | Rockwall | Texas | 48397 | 15132 | 179 |
1669995 | 1669995 | 2021-08-30 | San Patricio | Texas | 48409 | 5559 | 179 |
1666748 | 1666748 | 2021-08-29 | San Patricio | Texas | 48409 | 5559 | 179 |
1653725 | 1653725 | 2021-08-25 | Nacogdoches | Texas | 48347 | 5940 | 179 |
1491274 | 1491274 | 2021-07-06 | Hunt | Texas | 48231 | 6272 | 179 |
1488027 | 1488027 | 2021-07-05 | Hunt | Texas | 48231 | 6267 | 179 |
1484780 | 1484780 | 2021-07-04 | Hunt | Texas | 48231 | 6264 | 179 |
1481534 | 1481534 | 2021-07-03 | Hunt | Texas | 48231 | 6263 | 179 |
1478287 | 1478287 | 2021-07-02 | Hunt | Texas | 48231 | 6261 | 179 |
1475041 | 1475041 | 2021-07-01 | Hunt | Texas | 48231 | 6256 | 179 |
1471795 | 1471795 | 2021-06-30 | Hunt | Texas | 48231 | 6253 | 179 |
1468550 | 1468550 | 2021-06-29 | Hunt | Texas | 48231 | 6251 | 179 |
1465305 | 1465305 | 2021-06-28 | Hunt | Texas | 48231 | 6248 | 179 |
1462060 | 1462060 | 2021-06-27 | Hunt | Texas | 48231 | 6239 | 179 |
1458815 | 1458815 | 2021-06-26 | Hunt | Texas | 48231 | 6239 | 179 |
1455570 | 1455570 | 2021-06-25 | Hunt | Texas | 48231 | 6234 | 179 |
1452325 | 1452325 | 2021-06-24 | Hunt | Texas | 48231 | 6230 | 179 |
1449079 | 1449079 | 2021-06-23 | Hunt | Texas | 48231 | 6226 | 179 |
1445834 | 1445834 | 2021-06-22 | Hunt | Texas | 48231 | 6219 | 179 |
1442589 | 1442589 | 2021-06-21 | Hunt | Texas | 48231 | 6219 | 179 |
1439344 | 1439344 | 2021-06-20 | Hunt | Texas | 48231 | 6217 | 179 |
1436097 | 1436097 | 2021-06-19 | Hunt | Texas | 48231 | 6212 | 179 |
1432850 | 1432850 | 2021-06-18 | Hunt | Texas | 48231 | 6205 | 179 |
1429604 | 1429604 | 2021-06-17 | Hunt | Texas | 48231 | 6199 | 179 |
1426359 | 1426359 | 2021-06-16 | Hunt | Texas | 48231 | 6196 | 179 |
1270609 | 1270609 | 2021-04-29 | Parker | Texas | 48367 | 15577 | 179 |
1267362 | 1267362 | 2021-04-28 | Parker | Texas | 48367 | 15560 | 179 |
1264077 | 1264077 | 2021-04-27 | Liberty | Texas | 48291 | 7685 | 179 |
1260830 | 1260830 | 2021-04-26 | Liberty | Texas | 48291 | 7680 | 179 |
1257583 | 1257583 | 2021-04-25 | Liberty | Texas | 48291 | 7662 | 179 |
1254336 | 1254336 | 2021-04-24 | Liberty | Texas | 48291 | 7630 | 179 |
1182847 | 1182847 | 2021-04-02 | Henderson | Texas | 48213 | 5707 | 179 |
1179600 | 1179600 | 2021-04-01 | Henderson | Texas | 48213 | 5707 | 179 |
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);