ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where deaths = 191 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2388343 | 2388343 | 2022-04-08 | Hill | Texas | 48217 | 8914 | 191 |
2385088 | 2385088 | 2022-04-07 | Hill | Texas | 48217 | 8912 | 191 |
2381833 | 2381833 | 2022-04-06 | Hill | Texas | 48217 | 8911 | 191 |
2378578 | 2378578 | 2022-04-05 | Hill | Texas | 48217 | 8909 | 191 |
2375324 | 2375324 | 2022-04-04 | Hill | Texas | 48217 | 8906 | 191 |
2372072 | 2372072 | 2022-04-03 | Hill | Texas | 48217 | 8906 | 191 |
2368819 | 2368819 | 2022-04-02 | Hill | Texas | 48217 | 8906 | 191 |
2365566 | 2365566 | 2022-04-01 | Hill | Texas | 48217 | 8903 | 191 |
2362313 | 2362313 | 2022-03-31 | Hill | Texas | 48217 | 8901 | 191 |
2359059 | 2359059 | 2022-03-30 | Hill | Texas | 48217 | 8897 | 191 |
2355805 | 2355805 | 2022-03-29 | Hill | Texas | 48217 | 8893 | 191 |
2352552 | 2352552 | 2022-03-28 | Hill | Texas | 48217 | 8869 | 191 |
2349300 | 2349300 | 2022-03-27 | Hill | Texas | 48217 | 8869 | 191 |
2346047 | 2346047 | 2022-03-26 | Hill | Texas | 48217 | 8869 | 191 |
2342794 | 2342794 | 2022-03-25 | Hill | Texas | 48217 | 8869 | 191 |
2339541 | 2339541 | 2022-03-24 | Hill | Texas | 48217 | 8864 | 191 |
2336287 | 2336287 | 2022-03-23 | Hill | Texas | 48217 | 8859 | 191 |
2333033 | 2333033 | 2022-03-22 | Hill | Texas | 48217 | 8856 | 191 |
2329780 | 2329780 | 2022-03-21 | Hill | Texas | 48217 | 8855 | 191 |
2326528 | 2326528 | 2022-03-20 | Hill | Texas | 48217 | 8855 | 191 |
2323275 | 2323275 | 2022-03-19 | Hill | Texas | 48217 | 8854 | 191 |
2320021 | 2320021 | 2022-03-18 | Hill | Texas | 48217 | 8854 | 191 |
2316767 | 2316767 | 2022-03-17 | Hill | Texas | 48217 | 8852 | 191 |
2313514 | 2313514 | 2022-03-16 | Hill | Texas | 48217 | 8851 | 191 |
2310261 | 2310261 | 2022-03-15 | Hill | Texas | 48217 | 8851 | 191 |
2307008 | 2307008 | 2022-03-14 | Hill | Texas | 48217 | 8842 | 191 |
2303757 | 2303757 | 2022-03-13 | Hill | Texas | 48217 | 8841 | 191 |
2300430 | 2300430 | 2022-03-12 | Cass | Texas | 48067 | 7146 | 191 |
2300505 | 2300505 | 2022-03-12 | Hill | Texas | 48217 | 8841 | 191 |
2297178 | 2297178 | 2022-03-11 | Cass | Texas | 48067 | 7125 | 191 |
2297253 | 2297253 | 2022-03-11 | Hill | Texas | 48217 | 8835 | 191 |
2294001 | 2294001 | 2022-03-10 | Hill | Texas | 48217 | 8827 | 191 |
2290749 | 2290749 | 2022-03-09 | Hill | Texas | 48217 | 8818 | 191 |
2287497 | 2287497 | 2022-03-08 | Hill | Texas | 48217 | 8809 | 191 |
2284245 | 2284245 | 2022-03-07 | Hill | Texas | 48217 | 8803 | 191 |
2280993 | 2280993 | 2022-03-06 | Hill | Texas | 48217 | 8800 | 191 |
2277740 | 2277740 | 2022-03-05 | Hill | Texas | 48217 | 8800 | 191 |
2274487 | 2274487 | 2022-03-04 | Hill | Texas | 48217 | 8796 | 191 |
2271234 | 2271234 | 2022-03-03 | Hill | Texas | 48217 | 8789 | 191 |
2261533 | 2261533 | 2022-02-28 | Medina | Texas | 48325 | 9909 | 191 |
2258282 | 2258282 | 2022-02-27 | Medina | Texas | 48325 | 9905 | 191 |
2255031 | 2255031 | 2022-02-26 | Medina | Texas | 48325 | 9904 | 191 |
2251780 | 2251780 | 2022-02-25 | Medina | Texas | 48325 | 9876 | 191 |
2209402 | 2209402 | 2022-02-12 | Coryell | Texas | 48099 | 16941 | 191 |
2206149 | 2206149 | 2022-02-11 | Coryell | Texas | 48099 | 16917 | 191 |
2206224 | 2206224 | 2022-02-11 | Jim Wells | Texas | 48249 | 10797 | 191 |
2134757 | 2134757 | 2022-01-20 | Walker | Texas | 48471 | 16182 | 191 |
2131505 | 2131505 | 2022-01-19 | Walker | Texas | 48471 | 16007 | 191 |
2128215 | 2128215 | 2022-01-18 | Rusk | Texas | 48401 | 9489 | 191 |
2128251 | 2128251 | 2022-01-18 | Walker | Texas | 48471 | 15776 | 191 |
2124963 | 2124963 | 2022-01-17 | Rusk | Texas | 48401 | 9456 | 191 |
2124999 | 2124999 | 2022-01-17 | Walker | Texas | 48471 | 15725 | 191 |
2121711 | 2121711 | 2022-01-16 | Rusk | Texas | 48401 | 9395 | 191 |
2121747 | 2121747 | 2022-01-16 | Walker | Texas | 48471 | 15642 | 191 |
2118459 | 2118459 | 2022-01-15 | Rusk | Texas | 48401 | 9375 | 191 |
2118495 | 2118495 | 2022-01-15 | Walker | Texas | 48471 | 15534 | 191 |
2115208 | 2115208 | 2022-01-14 | Rusk | Texas | 48401 | 9317 | 191 |
2111956 | 2111956 | 2022-01-13 | Rusk | Texas | 48401 | 8963 | 191 |
2108704 | 2108704 | 2022-01-12 | Rusk | Texas | 48401 | 8907 | 191 |
2105453 | 2105453 | 2022-01-11 | Rusk | Texas | 48401 | 8852 | 191 |
2102202 | 2102202 | 2022-01-10 | Rusk | Texas | 48401 | 8808 | 191 |
2098951 | 2098951 | 2022-01-09 | Rusk | Texas | 48401 | 8766 | 191 |
2095699 | 2095699 | 2022-01-08 | Rusk | Texas | 48401 | 8726 | 191 |
2092447 | 2092447 | 2022-01-07 | Rusk | Texas | 48401 | 8679 | 191 |
2089195 | 2089195 | 2022-01-06 | Rusk | Texas | 48401 | 8632 | 191 |
2085944 | 2085944 | 2022-01-05 | Rusk | Texas | 48401 | 8583 | 191 |
2082692 | 2082692 | 2022-01-04 | Rusk | Texas | 48401 | 8552 | 191 |
2079440 | 2079440 | 2022-01-03 | Rusk | Texas | 48401 | 8517 | 191 |
2075999 | 2075999 | 2022-01-02 | Bastrop | Texas | 48021 | 15008 | 191 |
2076189 | 2076189 | 2022-01-02 | Rusk | Texas | 48401 | 8428 | 191 |
2072748 | 2072748 | 2022-01-01 | Bastrop | Texas | 48021 | 15008 | 191 |
2072938 | 2072938 | 2022-01-01 | Rusk | Texas | 48401 | 8428 | 191 |
2069497 | 2069497 | 2021-12-31 | Bastrop | Texas | 48021 | 15008 | 191 |
2069687 | 2069687 | 2021-12-31 | Rusk | Texas | 48401 | 8428 | 191 |
2066246 | 2066246 | 2021-12-30 | Bastrop | Texas | 48021 | 15008 | 191 |
2066436 | 2066436 | 2021-12-30 | Rusk | Texas | 48401 | 8428 | 191 |
2062996 | 2062996 | 2021-12-29 | Bastrop | Texas | 48021 | 14965 | 191 |
2063186 | 2063186 | 2021-12-29 | Rusk | Texas | 48401 | 8405 | 191 |
2059746 | 2059746 | 2021-12-28 | Bastrop | Texas | 48021 | 14936 | 191 |
2059936 | 2059936 | 2021-12-28 | Rusk | Texas | 48401 | 8400 | 191 |
2056497 | 2056497 | 2021-12-27 | Bastrop | Texas | 48021 | 14878 | 191 |
2056687 | 2056687 | 2021-12-27 | Rusk | Texas | 48401 | 8382 | 191 |
2053248 | 2053248 | 2021-12-26 | Bastrop | Texas | 48021 | 14775 | 191 |
2049998 | 2049998 | 2021-12-25 | Bastrop | Texas | 48021 | 14775 | 191 |
2046748 | 2046748 | 2021-12-24 | Bastrop | Texas | 48021 | 14775 | 191 |
2043498 | 2043498 | 2021-12-23 | Bastrop | Texas | 48021 | 14775 | 191 |
2040249 | 2040249 | 2021-12-22 | Bastrop | Texas | 48021 | 14751 | 191 |
2037229 | 2037229 | 2021-12-21 | Wharton | Texas | 48481 | 6391 | 191 |
2033979 | 2033979 | 2021-12-20 | Wharton | Texas | 48481 | 6378 | 191 |
2030729 | 2030729 | 2021-12-19 | Wharton | Texas | 48481 | 6372 | 191 |
2027478 | 2027478 | 2021-12-18 | Wharton | Texas | 48481 | 6370 | 191 |
2014409 | 2014409 | 2021-12-14 | Navarro | Texas | 48349 | 9043 | 191 |
1975252 | 1975252 | 2021-12-02 | Brown | Texas | 48049 | 7157 | 191 |
1972003 | 1972003 | 2021-12-01 | Brown | Texas | 48049 | 7155 | 191 |
1968753 | 1968753 | 2021-11-30 | Brown | Texas | 48049 | 7137 | 191 |
1965502 | 1965502 | 2021-11-29 | Brown | Texas | 48049 | 7137 | 191 |
1962250 | 1962250 | 2021-11-28 | Brown | Texas | 48049 | 7137 | 191 |
1958999 | 1958999 | 2021-11-27 | Brown | Texas | 48049 | 7137 | 191 |
1955748 | 1955748 | 2021-11-26 | Brown | Texas | 48049 | 7137 | 191 |
1952497 | 1952497 | 2021-11-25 | Brown | Texas | 48049 | 7137 | 191 |
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);