ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where deaths = 185 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450325 | 2450325 | 2022-04-27 | Upshur | Texas | 48459 | 7899 | 185 |
2447068 | 2447068 | 2022-04-26 | Upshur | Texas | 48459 | 7898 | 185 |
2443813 | 2443813 | 2022-04-25 | Upshur | Texas | 48459 | 7897 | 185 |
2440557 | 2440557 | 2022-04-24 | Upshur | Texas | 48459 | 7897 | 185 |
2437301 | 2437301 | 2022-04-23 | Upshur | Texas | 48459 | 7897 | 185 |
2434045 | 2434045 | 2022-04-22 | Upshur | Texas | 48459 | 7890 | 185 |
2378590 | 2378590 | 2022-04-05 | Jasper | Texas | 48241 | 6075 | 185 |
2375336 | 2375336 | 2022-04-04 | Jasper | Texas | 48241 | 6075 | 185 |
2372084 | 2372084 | 2022-04-03 | Jasper | Texas | 48241 | 6075 | 185 |
2368831 | 2368831 | 2022-04-02 | Jasper | Texas | 48241 | 6074 | 185 |
2365578 | 2365578 | 2022-04-01 | Jasper | Texas | 48241 | 6074 | 185 |
2362325 | 2362325 | 2022-03-31 | Jasper | Texas | 48241 | 6074 | 185 |
2359071 | 2359071 | 2022-03-30 | Jasper | Texas | 48241 | 6072 | 185 |
2355817 | 2355817 | 2022-03-29 | Jasper | Texas | 48241 | 6071 | 185 |
2352564 | 2352564 | 2022-03-28 | Jasper | Texas | 48241 | 6071 | 185 |
2349312 | 2349312 | 2022-03-27 | Jasper | Texas | 48241 | 6071 | 185 |
2346059 | 2346059 | 2022-03-26 | Jasper | Texas | 48241 | 6071 | 185 |
2342806 | 2342806 | 2022-03-25 | Jasper | Texas | 48241 | 6071 | 185 |
2339553 | 2339553 | 2022-03-24 | Jasper | Texas | 48241 | 6070 | 185 |
2336299 | 2336299 | 2022-03-23 | Jasper | Texas | 48241 | 6068 | 185 |
2333045 | 2333045 | 2022-03-22 | Jasper | Texas | 48241 | 6066 | 185 |
2329792 | 2329792 | 2022-03-21 | Jasper | Texas | 48241 | 6065 | 185 |
2326540 | 2326540 | 2022-03-20 | Jasper | Texas | 48241 | 6065 | 185 |
2323287 | 2323287 | 2022-03-19 | Jasper | Texas | 48241 | 6064 | 185 |
2320033 | 2320033 | 2022-03-18 | Jasper | Texas | 48241 | 6064 | 185 |
2261404 | 2261404 | 2022-02-28 | Cass | Texas | 48067 | 6987 | 185 |
2258153 | 2258153 | 2022-02-27 | Cass | Texas | 48067 | 6983 | 185 |
2254902 | 2254902 | 2022-02-26 | Cass | Texas | 48067 | 6973 | 185 |
2251651 | 2251651 | 2022-02-25 | Cass | Texas | 48067 | 6944 | 185 |
2248400 | 2248400 | 2022-02-24 | Cass | Texas | 48067 | 6932 | 185 |
2245149 | 2245149 | 2022-02-23 | Cass | Texas | 48067 | 6902 | 185 |
2206208 | 2206208 | 2022-02-11 | Hill | Texas | 48217 | 8658 | 185 |
2202955 | 2202955 | 2022-02-10 | Hill | Texas | 48217 | 8649 | 185 |
2199642 | 2199642 | 2022-02-09 | Coryell | Texas | 48099 | 16876 | 185 |
2199701 | 2199701 | 2022-02-09 | Hill | Texas | 48217 | 8636 | 185 |
2196447 | 2196447 | 2022-02-08 | Hill | Texas | 48217 | 8615 | 185 |
2196501 | 2196501 | 2022-02-08 | Medina | Texas | 48325 | 9526 | 185 |
2163932 | 2163932 | 2022-01-29 | Jim Wells | Texas | 48249 | 10155 | 185 |
2160677 | 2160677 | 2022-01-28 | Jim Wells | Texas | 48249 | 10062 | 185 |
2157421 | 2157421 | 2022-01-27 | Jim Wells | Texas | 48249 | 9988 | 185 |
2154168 | 2154168 | 2022-01-26 | Jim Wells | Texas | 48249 | 9906 | 185 |
2150916 | 2150916 | 2022-01-25 | Jim Wells | Texas | 48249 | 9874 | 185 |
2147664 | 2147664 | 2022-01-24 | Jim Wells | Texas | 48249 | 9822 | 185 |
2144410 | 2144410 | 2022-01-23 | Jim Wells | Texas | 48249 | 9754 | 185 |
2141155 | 2141155 | 2022-01-22 | Jim Wells | Texas | 48249 | 9643 | 185 |
2137899 | 2137899 | 2022-01-21 | Jim Wells | Texas | 48249 | 9499 | 185 |
2134645 | 2134645 | 2022-01-20 | Jim Wells | Texas | 48249 | 9296 | 185 |
2131393 | 2131393 | 2022-01-19 | Jim Wells | Texas | 48249 | 9141 | 185 |
2128139 | 2128139 | 2022-01-18 | Jim Wells | Texas | 48249 | 9077 | 185 |
2124887 | 2124887 | 2022-01-17 | Jim Wells | Texas | 48249 | 8980 | 185 |
2121635 | 2121635 | 2022-01-16 | Jim Wells | Texas | 48249 | 8935 | 185 |
2118383 | 2118383 | 2022-01-15 | Jim Wells | Texas | 48249 | 8759 | 185 |
1981738 | 1981738 | 2021-12-04 | Bastrop | Texas | 48021 | 14499 | 185 |
1978488 | 1978488 | 2021-12-03 | Bastrop | Texas | 48021 | 14496 | 185 |
1975238 | 1975238 | 2021-12-02 | Bastrop | Texas | 48021 | 14488 | 185 |
1975463 | 1975463 | 2021-12-02 | Walker | Texas | 48471 | 11828 | 185 |
1971989 | 1971989 | 2021-12-01 | Bastrop | Texas | 48021 | 14479 | 185 |
1972214 | 1972214 | 2021-12-01 | Walker | Texas | 48471 | 11821 | 185 |
1968964 | 1968964 | 2021-11-30 | Walker | Texas | 48471 | 11818 | 185 |
1965579 | 1965579 | 2021-11-29 | Harrison | Texas | 48203 | 9238 | 185 |
1965713 | 1965713 | 2021-11-29 | Walker | Texas | 48471 | 11803 | 185 |
1962461 | 1962461 | 2021-11-28 | Walker | Texas | 48471 | 11798 | 185 |
1959210 | 1959210 | 2021-11-27 | Walker | Texas | 48471 | 11798 | 185 |
1955959 | 1955959 | 2021-11-26 | Walker | Texas | 48471 | 11798 | 185 |
1952708 | 1952708 | 2021-11-25 | Walker | Texas | 48471 | 11798 | 185 |
1949457 | 1949457 | 2021-11-24 | Walker | Texas | 48471 | 11798 | 185 |
1946206 | 1946206 | 2021-11-23 | Walker | Texas | 48471 | 11807 | 185 |
1942955 | 1942955 | 2021-11-22 | Walker | Texas | 48471 | 11802 | 185 |
1939705 | 1939705 | 2021-11-21 | Walker | Texas | 48471 | 11802 | 185 |
1936455 | 1936455 | 2021-11-20 | Walker | Texas | 48471 | 11789 | 185 |
1933205 | 1933205 | 2021-11-19 | Walker | Texas | 48471 | 11807 | 185 |
1929954 | 1929954 | 2021-11-18 | Walker | Texas | 48471 | 11799 | 185 |
1926669 | 1926669 | 2021-11-17 | Rusk | Texas | 48401 | 8162 | 185 |
1926704 | 1926704 | 2021-11-17 | Walker | Texas | 48471 | 11849 | 185 |
1923419 | 1923419 | 2021-11-16 | Rusk | Texas | 48401 | 8160 | 185 |
1907211 | 1907211 | 2021-11-11 | Wharton | Texas | 48481 | 6276 | 185 |
1903962 | 1903962 | 2021-11-10 | Wharton | Texas | 48481 | 6267 | 185 |
1900712 | 1900712 | 2021-11-09 | Wharton | Texas | 48481 | 6267 | 185 |
1864902 | 1864902 | 2021-10-29 | Navarro | Texas | 48349 | 8721 | 185 |
1861653 | 1861653 | 2021-10-28 | Navarro | Texas | 48349 | 8713 | 185 |
1858404 | 1858404 | 2021-10-27 | Navarro | Texas | 48349 | 8707 | 185 |
1835578 | 1835578 | 2021-10-20 | Hale | Texas | 48189 | 7842 | 185 |
1832329 | 1832329 | 2021-10-19 | Hale | Texas | 48189 | 7820 | 185 |
1829080 | 1829080 | 2021-10-18 | Hale | Texas | 48189 | 7820 | 185 |
1825831 | 1825831 | 2021-10-17 | Hale | Texas | 48189 | 7820 | 185 |
1822582 | 1822582 | 2021-10-16 | Hale | Texas | 48189 | 7820 | 185 |
1819333 | 1819333 | 2021-10-15 | Hale | Texas | 48189 | 7782 | 185 |
1816084 | 1816084 | 2021-10-14 | Hale | Texas | 48189 | 7782 | 185 |
1816238 | 1816238 | 2021-10-14 | Wise | Texas | 48497 | 10994 | 185 |
1812836 | 1812836 | 2021-10-13 | Hale | Texas | 48189 | 7782 | 185 |
1809587 | 1809587 | 2021-10-12 | Hale | Texas | 48189 | 7739 | 185 |
1806337 | 1806337 | 2021-10-11 | Hale | Texas | 48189 | 7739 | 185 |
1803087 | 1803087 | 2021-10-10 | Hale | Texas | 48189 | 7739 | 185 |
1799838 | 1799838 | 2021-10-09 | Hale | Texas | 48189 | 7739 | 185 |
1796589 | 1796589 | 2021-10-08 | Hale | Texas | 48189 | 7682 | 185 |
1793246 | 1793246 | 2021-10-07 | Anderson | Texas | 48001 | 7847 | 185 |
1793340 | 1793340 | 2021-10-07 | Hale | Texas | 48189 | 7682 | 185 |
1793356 | 1793356 | 2021-10-07 | Hood | Texas | 48221 | 9279 | 185 |
1789997 | 1789997 | 2021-10-06 | Anderson | Texas | 48001 | 7850 | 185 |
1790183 | 1790183 | 2021-10-06 | Polk | Texas | 48373 | 5811 | 185 |
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);