ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where deaths = 136 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2196475 | 2196475 | 2022-02-08 | Kleberg | Texas | 48273 | 6616 | 136 |
2193221 | 2193221 | 2022-02-07 | Kleberg | Texas | 48273 | 6580 | 136 |
2189967 | 2189967 | 2022-02-06 | Kleberg | Texas | 48273 | 6549 | 136 |
2186714 | 2186714 | 2022-02-05 | Kleberg | Texas | 48273 | 6508 | 136 |
2183462 | 2183462 | 2022-02-04 | Kleberg | Texas | 48273 | 6481 | 136 |
2180210 | 2180210 | 2022-02-03 | Kleberg | Texas | 48273 | 6417 | 136 |
2157536 | 2157536 | 2022-01-27 | Washington | Texas | 48477 | 8449 | 136 |
2154283 | 2154283 | 2022-01-26 | Washington | Texas | 48477 | 8417 | 136 |
2151031 | 2151031 | 2022-01-25 | Washington | Texas | 48477 | 8351 | 136 |
2147779 | 2147779 | 2022-01-24 | Washington | Texas | 48477 | 8330 | 136 |
2144525 | 2144525 | 2022-01-23 | Washington | Texas | 48477 | 8285 | 136 |
2085756 | 2085756 | 2022-01-05 | Bee | Texas | 48025 | 5648 | 136 |
2085770 | 2085770 | 2022-01-05 | Burnet | Texas | 48053 | 8095 | 136 |
2082504 | 2082504 | 2022-01-04 | Bee | Texas | 48025 | 5612 | 136 |
2082518 | 2082518 | 2022-01-04 | Burnet | Texas | 48053 | 8043 | 136 |
2079252 | 2079252 | 2022-01-03 | Bee | Texas | 48025 | 5576 | 136 |
2076001 | 2076001 | 2022-01-02 | Bee | Texas | 48025 | 5476 | 136 |
2072750 | 2072750 | 2022-01-01 | Bee | Texas | 48025 | 5476 | 136 |
2069499 | 2069499 | 2021-12-31 | Bee | Texas | 48025 | 5476 | 136 |
2066248 | 2066248 | 2021-12-30 | Bee | Texas | 48025 | 5476 | 136 |
2062998 | 2062998 | 2021-12-29 | Bee | Texas | 48025 | 5471 | 136 |
2059748 | 2059748 | 2021-12-28 | Bee | Texas | 48025 | 5461 | 136 |
2056499 | 2056499 | 2021-12-27 | Bee | Texas | 48025 | 5451 | 136 |
2053250 | 2053250 | 2021-12-26 | Bee | Texas | 48025 | 5432 | 136 |
2050000 | 2050000 | 2021-12-25 | Bee | Texas | 48025 | 5432 | 136 |
2046750 | 2046750 | 2021-12-24 | Bee | Texas | 48025 | 5432 | 136 |
2043500 | 2043500 | 2021-12-23 | Bee | Texas | 48025 | 5432 | 136 |
2040251 | 2040251 | 2021-12-22 | Bee | Texas | 48025 | 5426 | 136 |
2037001 | 2037001 | 2021-12-21 | Bee | Texas | 48025 | 5423 | 136 |
2033751 | 2033751 | 2021-12-20 | Bee | Texas | 48025 | 5422 | 136 |
2030501 | 2030501 | 2021-12-19 | Bee | Texas | 48025 | 5418 | 136 |
2027250 | 2027250 | 2021-12-18 | Bee | Texas | 48025 | 5418 | 136 |
2023999 | 2023999 | 2021-12-17 | Bee | Texas | 48025 | 5414 | 136 |
1991588 | 1991588 | 2021-12-07 | Hockley | Texas | 48219 | 4498 | 136 |
1988337 | 1988337 | 2021-12-06 | Hockley | Texas | 48219 | 4493 | 136 |
1985087 | 1985087 | 2021-12-05 | Hockley | Texas | 48219 | 4490 | 136 |
1981837 | 1981837 | 2021-12-04 | Hockley | Texas | 48219 | 4481 | 136 |
1978587 | 1978587 | 2021-12-03 | Hockley | Texas | 48219 | 4470 | 136 |
1975337 | 1975337 | 2021-12-02 | Hockley | Texas | 48219 | 4464 | 136 |
1972088 | 1972088 | 2021-12-01 | Hockley | Texas | 48219 | 4453 | 136 |
1968838 | 1968838 | 2021-11-30 | Hockley | Texas | 48219 | 4449 | 136 |
1965587 | 1965587 | 2021-11-29 | Hockley | Texas | 48219 | 4446 | 136 |
1907103 | 1907103 | 2021-11-11 | Kerr | Texas | 48265 | 6577 | 136 |
1868223 | 1868223 | 2021-10-30 | Wilson | Texas | 48493 | 7531 | 136 |
1864974 | 1864974 | 2021-10-29 | Wilson | Texas | 48493 | 7531 | 136 |
1861725 | 1861725 | 2021-10-28 | Wilson | Texas | 48493 | 7529 | 136 |
1858476 | 1858476 | 2021-10-27 | Wilson | Texas | 48493 | 7511 | 136 |
1832464 | 1832464 | 2021-10-19 | Upshur | Texas | 48459 | 5766 | 136 |
1812775 | 1812775 | 2021-10-13 | Cass | Texas | 48067 | 4408 | 136 |
1809526 | 1809526 | 2021-10-12 | Cass | Texas | 48067 | 4367 | 136 |
1793319 | 1793319 | 2021-10-07 | Fannin | Texas | 48147 | 4782 | 136 |
1790070 | 1790070 | 2021-10-06 | Fannin | Texas | 48147 | 4756 | 136 |
1790108 | 1790108 | 2021-10-06 | Hopkins | Texas | 48223 | 5155 | 136 |
1786822 | 1786822 | 2021-10-05 | Fannin | Texas | 48147 | 4719 | 136 |
1786860 | 1786860 | 2021-10-05 | Hopkins | Texas | 48223 | 5145 | 136 |
1783573 | 1783573 | 2021-10-04 | Fannin | Texas | 48147 | 4669 | 136 |
1783611 | 1783611 | 2021-10-04 | Hopkins | Texas | 48223 | 5112 | 136 |
1780324 | 1780324 | 2021-10-03 | Fannin | Texas | 48147 | 4669 | 136 |
1780362 | 1780362 | 2021-10-03 | Hopkins | Texas | 48223 | 5112 | 136 |
1777112 | 1777112 | 2021-10-02 | Hopkins | Texas | 48223 | 5112 | 136 |
1773859 | 1773859 | 2021-10-01 | Hill | Texas | 48217 | 5632 | 136 |
1773862 | 1773862 | 2021-10-01 | Hopkins | Texas | 48223 | 5098 | 136 |
1770612 | 1770612 | 2021-09-30 | Hopkins | Texas | 48223 | 5082 | 136 |
1767279 | 1767279 | 2021-09-29 | Caldwell | Texas | 48055 | 8198 | 136 |
1718527 | 1718527 | 2021-09-14 | Bastrop | Texas | 48021 | 13290 | 136 |
1715279 | 1715279 | 2021-09-13 | Bastrop | Texas | 48021 | 13215 | 136 |
1712033 | 1712033 | 2021-09-12 | Bastrop | Texas | 48021 | 13091 | 136 |
1666730 | 1666730 | 2021-08-29 | Polk | Texas | 48373 | 4733 | 136 |
1663482 | 1663482 | 2021-08-28 | Polk | Texas | 48373 | 4733 | 136 |
1660048 | 1660048 | 2021-08-27 | Anderson | Texas | 48001 | 6625 | 136 |
1660234 | 1660234 | 2021-08-27 | Polk | Texas | 48373 | 4621 | 136 |
1656799 | 1656799 | 2021-08-26 | Anderson | Texas | 48001 | 6506 | 136 |
1653552 | 1653552 | 2021-08-25 | Anderson | Texas | 48001 | 6498 | 136 |
1650305 | 1650305 | 2021-08-24 | Anderson | Texas | 48001 | 6240 | 136 |
1650553 | 1650553 | 2021-08-24 | Wise | Texas | 48497 | 8735 | 136 |
1647304 | 1647304 | 2021-08-23 | Wise | Texas | 48497 | 8614 | 136 |
1644055 | 1644055 | 2021-08-22 | Wise | Texas | 48497 | 8614 | 136 |
1640805 | 1640805 | 2021-08-21 | Wise | Texas | 48497 | 8614 | 136 |
1637556 | 1637556 | 2021-08-20 | Wood | Texas | 48499 | 4256 | 136 |
1631045 | 1631045 | 2021-08-18 | Walker | Texas | 48471 | 9509 | 136 |
1627796 | 1627796 | 2021-08-17 | Van Zandt | Texas | 48467 | 5383 | 136 |
1627798 | 1627798 | 2021-08-17 | Walker | Texas | 48471 | 9475 | 136 |
1624549 | 1624549 | 2021-08-16 | Van Zandt | Texas | 48467 | 5170 | 136 |
1624551 | 1624551 | 2021-08-16 | Walker | Texas | 48471 | 9446 | 136 |
1621302 | 1621302 | 2021-08-15 | Van Zandt | Texas | 48467 | 5170 | 136 |
1621304 | 1621304 | 2021-08-15 | Walker | Texas | 48471 | 9422 | 136 |
1618056 | 1618056 | 2021-08-14 | Walker | Texas | 48471 | 9369 | 136 |
1614808 | 1614808 | 2021-08-13 | Walker | Texas | 48471 | 9338 | 136 |
1546468 | 1546468 | 2021-07-23 | Hood | Texas | 48221 | 6858 | 136 |
1543221 | 1543221 | 2021-07-22 | Hood | Texas | 48221 | 6838 | 136 |
1539973 | 1539973 | 2021-07-21 | Hood | Texas | 48221 | 6811 | 136 |
1536726 | 1536726 | 2021-07-20 | Hood | Texas | 48221 | 6801 | 136 |
1533478 | 1533478 | 2021-07-19 | Hood | Texas | 48221 | 6801 | 136 |
1530231 | 1530231 | 2021-07-18 | Hood | Texas | 48221 | 6801 | 136 |
1293176 | 1293176 | 2021-05-06 | Brown | Texas | 48049 | 4235 | 136 |
1289930 | 1289930 | 2021-05-05 | Brown | Texas | 48049 | 4235 | 136 |
1286684 | 1286684 | 2021-05-04 | Brown | Texas | 48049 | 4235 | 136 |
1283438 | 1283438 | 2021-05-03 | Brown | Texas | 48049 | 4235 | 136 |
1280191 | 1280191 | 2021-05-02 | Brown | Texas | 48049 | 4235 | 136 |
1276944 | 1276944 | 2021-05-01 | Brown | Texas | 48049 | 4235 | 136 |
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);