ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where deaths = 196 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495724 | 2495724 | 2022-05-11 | Cass | Texas | 48067 | 7251 | 196 |
2492466 | 2492466 | 2022-05-10 | Cass | Texas | 48067 | 7247 | 196 |
2489208 | 2489208 | 2022-05-09 | Cass | Texas | 48067 | 7239 | 196 |
2485951 | 2485951 | 2022-05-08 | Cass | Texas | 48067 | 7238 | 196 |
2482693 | 2482693 | 2022-05-07 | Cass | Texas | 48067 | 7238 | 196 |
2479435 | 2479435 | 2022-05-06 | Cass | Texas | 48067 | 7238 | 196 |
2476177 | 2476177 | 2022-05-05 | Cass | Texas | 48067 | 7238 | 196 |
2472920 | 2472920 | 2022-05-04 | Cass | Texas | 48067 | 7238 | 196 |
2469664 | 2469664 | 2022-05-03 | Cass | Texas | 48067 | 7237 | 196 |
2466408 | 2466408 | 2022-05-02 | Cass | Texas | 48067 | 7237 | 196 |
2463153 | 2463153 | 2022-05-01 | Cass | Texas | 48067 | 7237 | 196 |
2459897 | 2459897 | 2022-04-30 | Cass | Texas | 48067 | 7237 | 196 |
2456641 | 2456641 | 2022-04-29 | Cass | Texas | 48067 | 7237 | 196 |
2453385 | 2453385 | 2022-04-28 | Cass | Texas | 48067 | 7236 | 196 |
2450129 | 2450129 | 2022-04-27 | Cass | Texas | 48067 | 7235 | 196 |
2446872 | 2446872 | 2022-04-26 | Cass | Texas | 48067 | 7234 | 196 |
2443617 | 2443617 | 2022-04-25 | Cass | Texas | 48067 | 7228 | 196 |
2440361 | 2440361 | 2022-04-24 | Cass | Texas | 48067 | 7228 | 196 |
2437105 | 2437105 | 2022-04-23 | Cass | Texas | 48067 | 7228 | 196 |
2433849 | 2433849 | 2022-04-22 | Cass | Texas | 48067 | 7226 | 196 |
2430593 | 2430593 | 2022-04-21 | Cass | Texas | 48067 | 7223 | 196 |
2427337 | 2427337 | 2022-04-20 | Cass | Texas | 48067 | 7223 | 196 |
2424081 | 2424081 | 2022-04-19 | Cass | Texas | 48067 | 7223 | 196 |
2420825 | 2420825 | 2022-04-18 | Cass | Texas | 48067 | 7221 | 196 |
2417569 | 2417569 | 2022-04-17 | Cass | Texas | 48067 | 7221 | 196 |
2414313 | 2414313 | 2022-04-16 | Cass | Texas | 48067 | 7221 | 196 |
2411057 | 2411057 | 2022-04-15 | Cass | Texas | 48067 | 7221 | 196 |
2407801 | 2407801 | 2022-04-14 | Cass | Texas | 48067 | 7221 | 196 |
2404545 | 2404545 | 2022-04-13 | Cass | Texas | 48067 | 7218 | 196 |
2401290 | 2401290 | 2022-04-12 | Cass | Texas | 48067 | 7214 | 196 |
2398035 | 2398035 | 2022-04-11 | Cass | Texas | 48067 | 7212 | 196 |
2394780 | 2394780 | 2022-04-10 | Cass | Texas | 48067 | 7212 | 196 |
2391524 | 2391524 | 2022-04-09 | Cass | Texas | 48067 | 7212 | 196 |
2388268 | 2388268 | 2022-04-08 | Cass | Texas | 48067 | 7212 | 196 |
2385013 | 2385013 | 2022-04-07 | Cass | Texas | 48067 | 7210 | 196 |
2381758 | 2381758 | 2022-04-06 | Cass | Texas | 48067 | 7210 | 196 |
2378503 | 2378503 | 2022-04-05 | Cass | Texas | 48067 | 7204 | 196 |
2375249 | 2375249 | 2022-04-04 | Cass | Texas | 48067 | 7203 | 196 |
2371997 | 2371997 | 2022-04-03 | Cass | Texas | 48067 | 7203 | 196 |
2368744 | 2368744 | 2022-04-02 | Cass | Texas | 48067 | 7203 | 196 |
2365491 | 2365491 | 2022-04-01 | Cass | Texas | 48067 | 7203 | 196 |
2362238 | 2362238 | 2022-03-31 | Cass | Texas | 48067 | 7203 | 196 |
2342848 | 2342848 | 2022-03-25 | Medina | Texas | 48325 | 10169 | 196 |
2339595 | 2339595 | 2022-03-24 | Medina | Texas | 48325 | 10167 | 196 |
2336341 | 2336341 | 2022-03-23 | Medina | Texas | 48325 | 10165 | 196 |
2333087 | 2333087 | 2022-03-22 | Medina | Texas | 48325 | 10157 | 196 |
2329834 | 2329834 | 2022-03-21 | Medina | Texas | 48325 | 10153 | 196 |
2326582 | 2326582 | 2022-03-20 | Medina | Texas | 48325 | 10150 | 196 |
2323329 | 2323329 | 2022-03-19 | Medina | Texas | 48325 | 10149 | 196 |
2241914 | 2241914 | 2022-02-22 | Coryell | Texas | 48099 | 17051 | 196 |
2170558 | 2170558 | 2022-01-31 | Wharton | Texas | 48481 | 8013 | 196 |
2167304 | 2167304 | 2022-01-30 | Wharton | Texas | 48481 | 7990 | 196 |
2164049 | 2164049 | 2022-01-29 | Wharton | Texas | 48481 | 7960 | 196 |
2154280 | 2154280 | 2022-01-26 | Walker | Texas | 48471 | 17132 | 196 |
2150802 | 2150802 | 2022-01-25 | Bastrop | Texas | 48021 | 20076 | 196 |
2147550 | 2147550 | 2022-01-24 | Bastrop | Texas | 48021 | 19930 | 196 |
2144296 | 2144296 | 2022-01-23 | Bastrop | Texas | 48021 | 19862 | 196 |
2141041 | 2141041 | 2022-01-22 | Bastrop | Texas | 48021 | 19746 | 196 |
2137785 | 2137785 | 2022-01-21 | Bastrop | Texas | 48021 | 19517 | 196 |
2134622 | 2134622 | 2022-01-20 | Harrison | Texas | 48203 | 11353 | 196 |
2131370 | 2131370 | 2022-01-19 | Harrison | Texas | 48203 | 11267 | 196 |
2124937 | 2124937 | 2022-01-17 | Navarro | Texas | 48349 | 10734 | 196 |
2121685 | 2121685 | 2022-01-16 | Navarro | Texas | 48349 | 10678 | 196 |
2118433 | 2118433 | 2022-01-15 | Navarro | Texas | 48349 | 10546 | 196 |
2115182 | 2115182 | 2022-01-14 | Navarro | Texas | 48349 | 10470 | 196 |
2111930 | 2111930 | 2022-01-13 | Navarro | Texas | 48349 | 10039 | 196 |
2108678 | 2108678 | 2022-01-12 | Navarro | Texas | 48349 | 9911 | 196 |
2105427 | 2105427 | 2022-01-11 | Navarro | Texas | 48349 | 9867 | 196 |
2102176 | 2102176 | 2022-01-10 | Navarro | Texas | 48349 | 9746 | 196 |
2098925 | 2098925 | 2022-01-09 | Navarro | Texas | 48349 | 9725 | 196 |
2095673 | 2095673 | 2022-01-08 | Navarro | Texas | 48349 | 9698 | 196 |
2089019 | 2089019 | 2022-01-06 | Brown | Texas | 48049 | 7580 | 196 |
2085768 | 2085768 | 2022-01-05 | Brown | Texas | 48049 | 7537 | 196 |
2082516 | 2082516 | 2022-01-04 | Brown | Texas | 48049 | 7537 | 196 |
2079264 | 2079264 | 2022-01-03 | Brown | Texas | 48049 | 7537 | 196 |
2076013 | 2076013 | 2022-01-02 | Brown | Texas | 48049 | 7537 | 196 |
2072762 | 2072762 | 2022-01-01 | Brown | Texas | 48049 | 7537 | 196 |
2069511 | 2069511 | 2021-12-31 | Brown | Texas | 48049 | 7537 | 196 |
2066260 | 2066260 | 2021-12-30 | Brown | Texas | 48049 | 7537 | 196 |
1968823 | 1968823 | 2021-11-30 | Hale | Texas | 48189 | 8119 | 196 |
1965572 | 1965572 | 2021-11-29 | Hale | Texas | 48189 | 8119 | 196 |
1848592 | 1848592 | 2021-10-24 | Hood | Texas | 48221 | 9640 | 196 |
1845342 | 1845342 | 2021-10-23 | Hood | Texas | 48221 | 9640 | 196 |
1838919 | 1838919 | 2021-10-21 | Polk | Texas | 48373 | 5900 | 196 |
1835670 | 1835670 | 2021-10-20 | Polk | Texas | 48373 | 5900 | 196 |
1832421 | 1832421 | 2021-10-19 | Polk | Texas | 48373 | 5885 | 196 |
1829172 | 1829172 | 2021-10-18 | Polk | Texas | 48373 | 5885 | 196 |
1809499 | 1809499 | 2021-10-12 | Atascosa | Texas | 48013 | 8428 | 196 |
1809632 | 1809632 | 2021-10-12 | Lamar | Texas | 48277 | 8661 | 196 |
1582266 | 1582266 | 2021-08-03 | Parker | Texas | 48367 | 17276 | 196 |
1579017 | 1579017 | 2021-08-02 | Parker | Texas | 48367 | 17126 | 196 |
1575769 | 1575769 | 2021-08-01 | Parker | Texas | 48367 | 17126 | 196 |
1572521 | 1572521 | 2021-07-31 | Parker | Texas | 48367 | 17126 | 196 |
1569273 | 1569273 | 2021-07-30 | Parker | Texas | 48367 | 17039 | 196 |
1536722 | 1536722 | 2021-07-20 | Henderson | Texas | 48213 | 6159 | 196 |
1533474 | 1533474 | 2021-07-19 | Henderson | Texas | 48213 | 6159 | 196 |
1530227 | 1530227 | 2021-07-18 | Henderson | Texas | 48213 | 6135 | 196 |
1526980 | 1526980 | 2021-07-17 | Henderson | Texas | 48213 | 6135 | 196 |
1523733 | 1523733 | 2021-07-16 | Henderson | Texas | 48213 | 6135 | 196 |
1520485 | 1520485 | 2021-07-15 | Henderson | Texas | 48213 | 6110 | 196 |
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);