ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where deaths = 117 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427433 | 2427433 | 2022-04-20 | Kendall | Texas | 48259 | 8196 | 117 |
2424177 | 2424177 | 2022-04-19 | Kendall | Texas | 48259 | 8194 | 117 |
2420921 | 2420921 | 2022-04-18 | Kendall | Texas | 48259 | 8193 | 117 |
2417665 | 2417665 | 2022-04-17 | Kendall | Texas | 48259 | 8186 | 117 |
2414409 | 2414409 | 2022-04-16 | Kendall | Texas | 48259 | 8186 | 117 |
2411153 | 2411153 | 2022-04-15 | Kendall | Texas | 48259 | 8186 | 117 |
2407897 | 2407897 | 2022-04-14 | Kendall | Texas | 48259 | 8186 | 117 |
2333067 | 2333067 | 2022-03-22 | Lavaca | Texas | 48285 | 4184 | 117 |
2329814 | 2329814 | 2022-03-21 | Lavaca | Texas | 48285 | 4181 | 117 |
2326562 | 2326562 | 2022-03-20 | Lavaca | Texas | 48285 | 4180 | 117 |
2323309 | 2323309 | 2022-03-19 | Lavaca | Texas | 48285 | 4178 | 117 |
2320042 | 2320042 | 2022-03-18 | Kendall | Texas | 48259 | 8119 | 117 |
2320055 | 2320055 | 2022-03-18 | Lavaca | Texas | 48285 | 4175 | 117 |
2316788 | 2316788 | 2022-03-17 | Kendall | Texas | 48259 | 8114 | 117 |
2316801 | 2316801 | 2022-03-17 | Lavaca | Texas | 48285 | 4175 | 117 |
2313535 | 2313535 | 2022-03-16 | Kendall | Texas | 48259 | 8106 | 117 |
2310282 | 2310282 | 2022-03-15 | Kendall | Texas | 48259 | 8095 | 117 |
2307029 | 2307029 | 2022-03-14 | Kendall | Texas | 48259 | 8083 | 117 |
2303778 | 2303778 | 2022-03-13 | Kendall | Texas | 48259 | 8080 | 117 |
2300526 | 2300526 | 2022-03-12 | Kendall | Texas | 48259 | 8080 | 117 |
2297274 | 2297274 | 2022-03-11 | Kendall | Texas | 48259 | 8072 | 117 |
2251758 | 2251758 | 2022-02-25 | Lamb | Texas | 48279 | 4266 | 117 |
2238685 | 2238685 | 2022-02-21 | Erath | Texas | 48143 | 8435 | 117 |
2235434 | 2235434 | 2022-02-20 | Erath | Texas | 48143 | 8433 | 117 |
2232183 | 2232183 | 2022-02-19 | Erath | Texas | 48143 | 8431 | 117 |
2216003 | 2216003 | 2022-02-14 | Limestone | Texas | 48293 | 4995 | 117 |
2216025 | 2216025 | 2022-02-14 | Montague | Texas | 48337 | 4579 | 117 |
2212752 | 2212752 | 2022-02-13 | Limestone | Texas | 48293 | 4994 | 117 |
2212774 | 2212774 | 2022-02-13 | Montague | Texas | 48337 | 4577 | 117 |
2209499 | 2209499 | 2022-02-12 | Limestone | Texas | 48293 | 4983 | 117 |
2206246 | 2206246 | 2022-02-11 | Limestone | Texas | 48293 | 4969 | 117 |
2206282 | 2206282 | 2022-02-11 | Panola | Texas | 48365 | 4315 | 117 |
2203029 | 2203029 | 2022-02-10 | Panola | Texas | 48365 | 4288 | 117 |
2199775 | 2199775 | 2022-02-09 | Panola | Texas | 48365 | 4270 | 117 |
2196521 | 2196521 | 2022-02-08 | Panola | Texas | 48365 | 4267 | 117 |
2193267 | 2193267 | 2022-02-07 | Panola | Texas | 48365 | 4264 | 117 |
2190013 | 2190013 | 2022-02-06 | Panola | Texas | 48365 | 4254 | 117 |
2186760 | 2186760 | 2022-02-05 | Panola | Texas | 48365 | 4235 | 117 |
2183508 | 2183508 | 2022-02-04 | Panola | Texas | 48365 | 4225 | 117 |
2180256 | 2180256 | 2022-02-03 | Panola | Texas | 48365 | 4215 | 117 |
2177005 | 2177005 | 2022-02-02 | Panola | Texas | 48365 | 4198 | 117 |
2170526 | 2170526 | 2022-01-31 | Shelby | Texas | 48419 | 4141 | 117 |
2167272 | 2167272 | 2022-01-30 | Shelby | Texas | 48419 | 4127 | 117 |
2164017 | 2164017 | 2022-01-29 | Shelby | Texas | 48419 | 4104 | 117 |
2160762 | 2160762 | 2022-01-28 | Shelby | Texas | 48419 | 4078 | 117 |
2157506 | 2157506 | 2022-01-27 | Shelby | Texas | 48419 | 4060 | 117 |
2154253 | 2154253 | 2022-01-26 | Shelby | Texas | 48419 | 4044 | 117 |
2151001 | 2151001 | 2022-01-25 | Shelby | Texas | 48419 | 4035 | 117 |
2151037 | 2151037 | 2022-01-25 | Willacy | Texas | 48489 | 6098 | 117 |
2147749 | 2147749 | 2022-01-24 | Shelby | Texas | 48419 | 4023 | 117 |
2147785 | 2147785 | 2022-01-24 | Willacy | Texas | 48489 | 6047 | 117 |
2144495 | 2144495 | 2022-01-23 | Shelby | Texas | 48419 | 3995 | 117 |
2144531 | 2144531 | 2022-01-23 | Willacy | Texas | 48489 | 6022 | 117 |
2141240 | 2141240 | 2022-01-22 | Shelby | Texas | 48419 | 3951 | 117 |
2141276 | 2141276 | 2022-01-22 | Willacy | Texas | 48489 | 5973 | 117 |
2137984 | 2137984 | 2022-01-21 | Shelby | Texas | 48419 | 3881 | 117 |
2138020 | 2138020 | 2022-01-21 | Willacy | Texas | 48489 | 5883 | 117 |
2134730 | 2134730 | 2022-01-20 | Shelby | Texas | 48419 | 3832 | 117 |
2131478 | 2131478 | 2022-01-19 | Shelby | Texas | 48419 | 3788 | 117 |
2115124 | 2115124 | 2022-01-14 | Hutchinson | Texas | 48233 | 5710 | 117 |
2111872 | 2111872 | 2022-01-13 | Hutchinson | Texas | 48233 | 4669 | 117 |
2108620 | 2108620 | 2022-01-12 | Hutchinson | Texas | 48233 | 4651 | 117 |
1978709 | 1978709 | 2021-12-03 | Uvalde | Texas | 48463 | 6403 | 117 |
1975459 | 1975459 | 2021-12-02 | Uvalde | Texas | 48463 | 6401 | 117 |
1972210 | 1972210 | 2021-12-01 | Uvalde | Texas | 48463 | 6398 | 117 |
1968960 | 1968960 | 2021-11-30 | Uvalde | Texas | 48463 | 6398 | 117 |
1965709 | 1965709 | 2021-11-29 | Uvalde | Texas | 48463 | 6386 | 117 |
1962457 | 1962457 | 2021-11-28 | Uvalde | Texas | 48463 | 6386 | 117 |
1959206 | 1959206 | 2021-11-27 | Uvalde | Texas | 48463 | 6386 | 117 |
1955955 | 1955955 | 2021-11-26 | Uvalde | Texas | 48463 | 6386 | 117 |
1952704 | 1952704 | 2021-11-25 | Uvalde | Texas | 48463 | 6386 | 117 |
1949453 | 1949453 | 2021-11-24 | Uvalde | Texas | 48463 | 6386 | 117 |
1946202 | 1946202 | 2021-11-23 | Uvalde | Texas | 48463 | 6386 | 117 |
1942951 | 1942951 | 2021-11-22 | Uvalde | Texas | 48463 | 6386 | 117 |
1939701 | 1939701 | 2021-11-21 | Uvalde | Texas | 48463 | 6374 | 117 |
1936451 | 1936451 | 2021-11-20 | Uvalde | Texas | 48463 | 6374 | 117 |
1933201 | 1933201 | 2021-11-19 | Uvalde | Texas | 48463 | 6374 | 117 |
1929950 | 1929950 | 2021-11-18 | Uvalde | Texas | 48463 | 6362 | 117 |
1874656 | 1874656 | 2021-11-01 | Palo Pinto | Texas | 48363 | 4728 | 117 |
1871407 | 1871407 | 2021-10-31 | Palo Pinto | Texas | 48363 | 4728 | 117 |
1868158 | 1868158 | 2021-10-30 | Palo Pinto | Texas | 48363 | 4728 | 117 |
1864909 | 1864909 | 2021-10-29 | Palo Pinto | Texas | 48363 | 4719 | 117 |
1861660 | 1861660 | 2021-10-28 | Palo Pinto | Texas | 48363 | 4711 | 117 |
1858411 | 1858411 | 2021-10-27 | Palo Pinto | Texas | 48363 | 4705 | 117 |
1783512 | 1783512 | 2021-10-04 | Bee | Texas | 48025 | 5237 | 117 |
1780263 | 1780263 | 2021-10-03 | Bee | Texas | 48025 | 5237 | 117 |
1777013 | 1777013 | 2021-10-02 | Bee | Texas | 48025 | 5230 | 117 |
1773883 | 1773883 | 2021-10-01 | Kerr | Texas | 48265 | 6272 | 117 |
1770633 | 1770633 | 2021-09-30 | Kerr | Texas | 48265 | 6213 | 117 |
1767384 | 1767384 | 2021-09-29 | Kerr | Texas | 48265 | 6165 | 117 |
1751248 | 1751248 | 2021-09-24 | Washington | Texas | 48477 | 5455 | 117 |
1699057 | 1699057 | 2021-09-08 | Caldwell | Texas | 48055 | 7513 | 117 |
1699139 | 1699139 | 2021-09-08 | Hockley | Texas | 48219 | 3714 | 117 |
1695891 | 1695891 | 2021-09-07 | Hockley | Texas | 48219 | 3672 | 117 |
1692643 | 1692643 | 2021-09-06 | Hockley | Texas | 48219 | 3672 | 117 |
1689394 | 1689394 | 2021-09-05 | Hockley | Texas | 48219 | 3672 | 117 |
1686144 | 1686144 | 2021-09-04 | Hockley | Texas | 48219 | 3672 | 117 |
1682857 | 1682857 | 2021-09-03 | Fannin | Texas | 48147 | 4015 | 117 |
1679607 | 1679607 | 2021-09-02 | Fannin | Texas | 48147 | 3959 | 117 |
1676359 | 1676359 | 2021-09-01 | Fannin | Texas | 48147 | 3931 | 117 |
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);