ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
187 rows where deaths = 189 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2287422 | 2287422 | 2022-03-08 | Cass | Texas | 48067 | 7055 | 189 |
2284170 | 2284170 | 2022-03-07 | Cass | Texas | 48067 | 7038 | 189 |
2280918 | 2280918 | 2022-03-06 | Cass | Texas | 48067 | 7036 | 189 |
2277665 | 2277665 | 2022-03-05 | Cass | Texas | 48067 | 7035 | 189 |
2274412 | 2274412 | 2022-03-04 | Cass | Texas | 48067 | 7030 | 189 |
2264729 | 2264729 | 2022-03-01 | Hill | Texas | 48217 | 8780 | 189 |
2261479 | 2261479 | 2022-02-28 | Hill | Texas | 48217 | 8769 | 189 |
2258228 | 2258228 | 2022-02-27 | Hill | Texas | 48217 | 8768 | 189 |
2254977 | 2254977 | 2022-02-26 | Hill | Texas | 48217 | 8768 | 189 |
2251726 | 2251726 | 2022-02-25 | Hill | Texas | 48217 | 8761 | 189 |
2248475 | 2248475 | 2022-02-24 | Hill | Texas | 48217 | 8757 | 189 |
2245224 | 2245224 | 2022-02-23 | Hill | Texas | 48217 | 8750 | 189 |
2241973 | 2241973 | 2022-02-22 | Hill | Texas | 48217 | 8742 | 189 |
2238722 | 2238722 | 2022-02-21 | Hill | Texas | 48217 | 8738 | 189 |
2235471 | 2235471 | 2022-02-20 | Hill | Texas | 48217 | 8736 | 189 |
2232220 | 2232220 | 2022-02-19 | Hill | Texas | 48217 | 8736 | 189 |
2228969 | 2228969 | 2022-02-18 | Hill | Texas | 48217 | 8728 | 189 |
2225718 | 2225718 | 2022-02-17 | Hill | Texas | 48217 | 8726 | 189 |
2225772 | 2225772 | 2022-02-17 | Medina | Texas | 48325 | 9702 | 189 |
2222467 | 2222467 | 2022-02-16 | Hill | Texas | 48217 | 8718 | 189 |
2222521 | 2222521 | 2022-02-16 | Medina | Texas | 48325 | 9661 | 189 |
2219216 | 2219216 | 2022-02-15 | Hill | Texas | 48217 | 8717 | 189 |
2219270 | 2219270 | 2022-02-15 | Medina | Texas | 48325 | 9637 | 189 |
2216019 | 2216019 | 2022-02-14 | Medina | Texas | 48325 | 9616 | 189 |
2212768 | 2212768 | 2022-02-13 | Medina | Texas | 48325 | 9608 | 189 |
2209515 | 2209515 | 2022-02-12 | Medina | Texas | 48325 | 9603 | 189 |
2186702 | 2186702 | 2022-02-05 | Jim Wells | Texas | 48249 | 10587 | 189 |
2115243 | 2115243 | 2022-01-14 | Walker | Texas | 48471 | 15366 | 189 |
2111991 | 2111991 | 2022-01-13 | Walker | Texas | 48471 | 14343 | 189 |
2108739 | 2108739 | 2022-01-12 | Walker | Texas | 48471 | 14200 | 189 |
2105488 | 2105488 | 2022-01-11 | Walker | Texas | 48471 | 14041 | 189 |
2102237 | 2102237 | 2022-01-10 | Walker | Texas | 48471 | 13947 | 189 |
2098986 | 2098986 | 2022-01-09 | Walker | Texas | 48471 | 13850 | 189 |
2095734 | 2095734 | 2022-01-08 | Walker | Texas | 48471 | 13752 | 189 |
2092482 | 2092482 | 2022-01-07 | Walker | Texas | 48471 | 13598 | 189 |
2089230 | 2089230 | 2022-01-06 | Walker | Texas | 48471 | 13325 | 189 |
2085979 | 2085979 | 2022-01-05 | Walker | Texas | 48471 | 13237 | 189 |
2082727 | 2082727 | 2022-01-04 | Walker | Texas | 48471 | 13071 | 189 |
2079475 | 2079475 | 2022-01-03 | Walker | Texas | 48471 | 12929 | 189 |
2076090 | 2076090 | 2022-01-02 | Harrison | Texas | 48203 | 9526 | 189 |
2076224 | 2076224 | 2022-01-02 | Walker | Texas | 48471 | 12419 | 189 |
2072839 | 2072839 | 2022-01-01 | Harrison | Texas | 48203 | 9526 | 189 |
2072973 | 2072973 | 2022-01-01 | Walker | Texas | 48471 | 12419 | 189 |
2069588 | 2069588 | 2021-12-31 | Harrison | Texas | 48203 | 9526 | 189 |
2069722 | 2069722 | 2021-12-31 | Walker | Texas | 48471 | 12419 | 189 |
2066337 | 2066337 | 2021-12-30 | Harrison | Texas | 48203 | 9526 | 189 |
2066471 | 2066471 | 2021-12-30 | Walker | Texas | 48471 | 12419 | 189 |
2063087 | 2063087 | 2021-12-29 | Harrison | Texas | 48203 | 9512 | 189 |
2063221 | 2063221 | 2021-12-29 | Walker | Texas | 48471 | 12372 | 189 |
2033749 | 2033749 | 2021-12-20 | Bastrop | Texas | 48021 | 14710 | 189 |
2030499 | 2030499 | 2021-12-19 | Bastrop | Texas | 48021 | 14693 | 189 |
2027248 | 2027248 | 2021-12-18 | Bastrop | Texas | 48021 | 14682 | 189 |
2023997 | 2023997 | 2021-12-17 | Bastrop | Texas | 48021 | 14669 | 189 |
2020936 | 2020936 | 2021-12-16 | Rusk | Texas | 48401 | 8309 | 189 |
2017685 | 2017685 | 2021-12-15 | Rusk | Texas | 48401 | 8299 | 189 |
2014435 | 2014435 | 2021-12-14 | Rusk | Texas | 48401 | 8280 | 189 |
2011184 | 2011184 | 2021-12-13 | Rusk | Texas | 48401 | 8263 | 189 |
2007933 | 2007933 | 2021-12-12 | Rusk | Texas | 48401 | 8261 | 189 |
2004682 | 2004682 | 2021-12-11 | Rusk | Texas | 48401 | 8261 | 189 |
2001431 | 2001431 | 2021-12-10 | Rusk | Texas | 48401 | 8251 | 189 |
1998181 | 1998181 | 2021-12-09 | Rusk | Texas | 48401 | 8236 | 189 |
1998221 | 1998221 | 2021-12-09 | Wharton | Texas | 48481 | 6319 | 189 |
1994930 | 1994930 | 2021-12-08 | Rusk | Texas | 48401 | 8230 | 189 |
1994970 | 1994970 | 2021-12-08 | Wharton | Texas | 48481 | 6314 | 189 |
1991679 | 1991679 | 2021-12-07 | Rusk | Texas | 48401 | 8213 | 189 |
1991719 | 1991719 | 2021-12-07 | Wharton | Texas | 48481 | 6311 | 189 |
1988428 | 1988428 | 2021-12-06 | Rusk | Texas | 48401 | 8203 | 189 |
1988468 | 1988468 | 2021-12-06 | Wharton | Texas | 48481 | 6311 | 189 |
1985178 | 1985178 | 2021-12-05 | Rusk | Texas | 48401 | 8201 | 189 |
1985218 | 1985218 | 2021-12-05 | Wharton | Texas | 48481 | 6309 | 189 |
1981928 | 1981928 | 2021-12-04 | Rusk | Texas | 48401 | 8201 | 189 |
1981968 | 1981968 | 2021-12-04 | Wharton | Texas | 48481 | 6307 | 189 |
1978652 | 1978652 | 2021-12-03 | Navarro | Texas | 48349 | 8941 | 189 |
1978678 | 1978678 | 2021-12-03 | Rusk | Texas | 48401 | 8194 | 189 |
1978718 | 1978718 | 2021-12-03 | Wharton | Texas | 48481 | 6303 | 189 |
1975402 | 1975402 | 2021-12-02 | Navarro | Texas | 48349 | 8933 | 189 |
1975428 | 1975428 | 2021-12-02 | Rusk | Texas | 48401 | 8189 | 189 |
1975468 | 1975468 | 2021-12-02 | Wharton | Texas | 48481 | 6297 | 189 |
1972153 | 1972153 | 2021-12-01 | Navarro | Texas | 48349 | 8931 | 189 |
1972179 | 1972179 | 2021-12-01 | Rusk | Texas | 48401 | 8181 | 189 |
1972219 | 1972219 | 2021-12-01 | Wharton | Texas | 48481 | 6296 | 189 |
1968903 | 1968903 | 2021-11-30 | Navarro | Texas | 48349 | 8910 | 189 |
1968929 | 1968929 | 2021-11-30 | Rusk | Texas | 48401 | 8177 | 189 |
1968969 | 1968969 | 2021-11-30 | Wharton | Texas | 48481 | 6292 | 189 |
1965652 | 1965652 | 2021-11-29 | Navarro | Texas | 48349 | 8880 | 189 |
1965718 | 1965718 | 2021-11-29 | Wharton | Texas | 48481 | 6286 | 189 |
1962400 | 1962400 | 2021-11-28 | Navarro | Texas | 48349 | 8866 | 189 |
1962466 | 1962466 | 2021-11-28 | Wharton | Texas | 48481 | 6285 | 189 |
1959149 | 1959149 | 2021-11-27 | Navarro | Texas | 48349 | 8866 | 189 |
1959215 | 1959215 | 2021-11-27 | Wharton | Texas | 48481 | 6285 | 189 |
1955898 | 1955898 | 2021-11-26 | Navarro | Texas | 48349 | 8866 | 189 |
1955964 | 1955964 | 2021-11-26 | Wharton | Texas | 48481 | 6285 | 189 |
1952647 | 1952647 | 2021-11-25 | Navarro | Texas | 48349 | 8866 | 189 |
1952713 | 1952713 | 2021-11-25 | Wharton | Texas | 48481 | 6285 | 189 |
1949396 | 1949396 | 2021-11-24 | Navarro | Texas | 48349 | 8866 | 189 |
1949462 | 1949462 | 2021-11-24 | Wharton | Texas | 48481 | 6285 | 189 |
1946145 | 1946145 | 2021-11-23 | Navarro | Texas | 48349 | 8858 | 189 |
1946211 | 1946211 | 2021-11-23 | Wharton | Texas | 48481 | 6284 | 189 |
1942894 | 1942894 | 2021-11-22 | Navarro | Texas | 48349 | 8846 | 189 |
1942960 | 1942960 | 2021-11-22 | Wharton | Texas | 48481 | 6283 | 189 |
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);