ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
116 rows where deaths = 181 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381954 | 2381954 | 2022-04-06 | Upshur | Texas | 48459 | 7757 | 181 |
2378699 | 2378699 | 2022-04-05 | Upshur | Texas | 48459 | 7757 | 181 |
2375445 | 2375445 | 2022-04-04 | Upshur | Texas | 48459 | 7755 | 181 |
2372193 | 2372193 | 2022-04-03 | Upshur | Texas | 48459 | 7755 | 181 |
2368940 | 2368940 | 2022-04-02 | Upshur | Texas | 48459 | 7755 | 181 |
2365687 | 2365687 | 2022-04-01 | Upshur | Texas | 48459 | 7754 | 181 |
2362434 | 2362434 | 2022-03-31 | Upshur | Texas | 48459 | 7752 | 181 |
2359180 | 2359180 | 2022-03-30 | Upshur | Texas | 48459 | 7751 | 181 |
2355926 | 2355926 | 2022-03-29 | Upshur | Texas | 48459 | 7750 | 181 |
2352673 | 2352673 | 2022-03-28 | Upshur | Texas | 48459 | 7750 | 181 |
2349421 | 2349421 | 2022-03-27 | Upshur | Texas | 48459 | 7750 | 181 |
2346168 | 2346168 | 2022-03-26 | Upshur | Texas | 48459 | 7750 | 181 |
2342915 | 2342915 | 2022-03-25 | Upshur | Texas | 48459 | 7735 | 181 |
2339565 | 2339565 | 2022-03-24 | Kerr | Texas | 48265 | 9591 | 181 |
2339662 | 2339662 | 2022-03-24 | Upshur | Texas | 48459 | 7733 | 181 |
2336311 | 2336311 | 2022-03-23 | Kerr | Texas | 48265 | 9573 | 181 |
2336408 | 2336408 | 2022-03-23 | Upshur | Texas | 48459 | 7731 | 181 |
2333057 | 2333057 | 2022-03-22 | Kerr | Texas | 48265 | 9557 | 181 |
2333154 | 2333154 | 2022-03-22 | Upshur | Texas | 48459 | 7730 | 181 |
2329804 | 2329804 | 2022-03-21 | Kerr | Texas | 48265 | 9545 | 181 |
2329901 | 2329901 | 2022-03-21 | Upshur | Texas | 48459 | 7724 | 181 |
2326552 | 2326552 | 2022-03-20 | Kerr | Texas | 48265 | 9545 | 181 |
2326649 | 2326649 | 2022-03-20 | Upshur | Texas | 48459 | 7723 | 181 |
2323299 | 2323299 | 2022-03-19 | Kerr | Texas | 48265 | 9543 | 181 |
2323396 | 2323396 | 2022-03-19 | Upshur | Texas | 48459 | 7723 | 181 |
2320045 | 2320045 | 2022-03-18 | Kerr | Texas | 48265 | 9534 | 181 |
2316791 | 2316791 | 2022-03-17 | Kerr | Texas | 48265 | 9533 | 181 |
2313538 | 2313538 | 2022-03-16 | Kerr | Texas | 48265 | 9528 | 181 |
2310285 | 2310285 | 2022-03-15 | Kerr | Texas | 48265 | 9524 | 181 |
2293966 | 2293966 | 2022-03-10 | Fannin | Texas | 48147 | 6788 | 181 |
2290761 | 2290761 | 2022-03-09 | Jasper | Texas | 48241 | 6059 | 181 |
2287509 | 2287509 | 2022-03-08 | Jasper | Texas | 48241 | 6059 | 181 |
2284257 | 2284257 | 2022-03-07 | Jasper | Texas | 48241 | 6056 | 181 |
2281005 | 2281005 | 2022-03-06 | Jasper | Texas | 48241 | 6056 | 181 |
2277752 | 2277752 | 2022-03-05 | Jasper | Texas | 48241 | 6055 | 181 |
2274499 | 2274499 | 2022-03-04 | Jasper | Texas | 48241 | 6054 | 181 |
2271246 | 2271246 | 2022-03-03 | Jasper | Texas | 48241 | 6051 | 181 |
2238647 | 2238647 | 2022-02-21 | Cass | Texas | 48067 | 6878 | 181 |
2235396 | 2235396 | 2022-02-20 | Cass | Texas | 48067 | 6876 | 181 |
2232145 | 2232145 | 2022-02-19 | Cass | Texas | 48067 | 6875 | 181 |
2228894 | 2228894 | 2022-02-18 | Cass | Texas | 48067 | 6853 | 181 |
2225643 | 2225643 | 2022-02-17 | Cass | Texas | 48067 | 6842 | 181 |
2222392 | 2222392 | 2022-02-16 | Cass | Texas | 48067 | 6819 | 181 |
2219141 | 2219141 | 2022-02-15 | Cass | Texas | 48067 | 6793 | 181 |
2215890 | 2215890 | 2022-02-14 | Cass | Texas | 48067 | 6750 | 181 |
2212639 | 2212639 | 2022-02-13 | Cass | Texas | 48067 | 6744 | 181 |
1962350 | 1962350 | 2021-11-28 | Jim Wells | Texas | 48249 | 7223 | 181 |
1959099 | 1959099 | 2021-11-27 | Jim Wells | Texas | 48249 | 7223 | 181 |
1955848 | 1955848 | 2021-11-26 | Jim Wells | Texas | 48249 | 7223 | 181 |
1952597 | 1952597 | 2021-11-25 | Jim Wells | Texas | 48249 | 7223 | 181 |
1949346 | 1949346 | 2021-11-24 | Jim Wells | Texas | 48249 | 7223 | 181 |
1946095 | 1946095 | 2021-11-23 | Jim Wells | Texas | 48249 | 7220 | 181 |
1942844 | 1942844 | 2021-11-22 | Jim Wells | Texas | 48249 | 7220 | 181 |
1939594 | 1939594 | 2021-11-21 | Jim Wells | Texas | 48249 | 7220 | 181 |
1936344 | 1936344 | 2021-11-20 | Jim Wells | Texas | 48249 | 7215 | 181 |
1933094 | 1933094 | 2021-11-19 | Jim Wells | Texas | 48249 | 7211 | 181 |
1923229 | 1923229 | 2021-11-16 | Bastrop | Texas | 48021 | 14440 | 181 |
1910321 | 1910321 | 2021-11-12 | Harrison | Texas | 48203 | 9212 | 181 |
1881208 | 1881208 | 2021-11-03 | Walker | Texas | 48471 | 11753 | 181 |
1877959 | 1877959 | 2021-11-02 | Walker | Texas | 48471 | 11741 | 181 |
1874710 | 1874710 | 2021-11-01 | Walker | Texas | 48471 | 11726 | 181 |
1871461 | 1871461 | 2021-10-31 | Walker | Texas | 48471 | 11720 | 181 |
1868212 | 1868212 | 2021-10-30 | Walker | Texas | 48471 | 11711 | 181 |
1864963 | 1864963 | 2021-10-29 | Walker | Texas | 48471 | 11696 | 181 |
1861719 | 1861719 | 2021-10-28 | Wharton | Texas | 48481 | 6241 | 181 |
1858470 | 1858470 | 2021-10-27 | Wharton | Texas | 48481 | 6236 | 181 |
1855221 | 1855221 | 2021-10-26 | Wharton | Texas | 48481 | 6235 | 181 |
1851972 | 1851972 | 2021-10-25 | Wharton | Texas | 48481 | 6232 | 181 |
1848722 | 1848722 | 2021-10-24 | Wharton | Texas | 48481 | 6231 | 181 |
1845472 | 1845472 | 2021-10-23 | Wharton | Texas | 48481 | 6225 | 181 |
1835658 | 1835658 | 2021-10-20 | Navarro | Texas | 48349 | 8671 | 181 |
1832409 | 1832409 | 2021-10-19 | Navarro | Texas | 48349 | 8656 | 181 |
1829160 | 1829160 | 2021-10-18 | Navarro | Texas | 48349 | 8642 | 181 |
1825911 | 1825911 | 2021-10-17 | Navarro | Texas | 48349 | 8642 | 181 |
1822662 | 1822662 | 2021-10-16 | Navarro | Texas | 48349 | 8642 | 181 |
1819413 | 1819413 | 2021-10-15 | Navarro | Texas | 48349 | 8589 | 181 |
1783500 | 1783500 | 2021-10-04 | Anderson | Texas | 48001 | 7805 | 181 |
1783686 | 1783686 | 2021-10-04 | Polk | Texas | 48373 | 5730 | 181 |
1780437 | 1780437 | 2021-10-03 | Polk | Texas | 48373 | 5730 | 181 |
1777111 | 1777111 | 2021-10-02 | Hood | Texas | 48221 | 9199 | 181 |
1754294 | 1754294 | 2021-09-25 | Cherokee | Texas | 48073 | 6469 | 181 |
1751243 | 1751243 | 2021-09-24 | Van Zandt | Texas | 48467 | 7354 | 181 |
1747900 | 1747900 | 2021-09-23 | Lamar | Texas | 48277 | 8237 | 181 |
1656972 | 1656972 | 2021-08-26 | Nacogdoches | Texas | 48347 | 5976 | 181 |
1309567 | 1309567 | 2021-05-11 | Parker | Texas | 48367 | 15752 | 181 |
1306321 | 1306321 | 2021-05-10 | Parker | Texas | 48367 | 15713 | 181 |
1303075 | 1303075 | 2021-05-09 | Parker | Texas | 48367 | 15713 | 181 |
1299828 | 1299828 | 2021-05-08 | Parker | Texas | 48367 | 15713 | 181 |
1296581 | 1296581 | 2021-05-07 | Parker | Texas | 48367 | 15703 | 181 |
1293335 | 1293335 | 2021-05-06 | Parker | Texas | 48367 | 15699 | 181 |
1277065 | 1277065 | 2021-05-01 | Liberty | Texas | 48291 | 7762 | 181 |
1202336 | 1202336 | 2021-04-08 | Henderson | Texas | 48213 | 5728 | 181 |
1199087 | 1199087 | 2021-04-07 | Henderson | Texas | 48213 | 5720 | 181 |
1078864 | 1078864 | 2021-03-01 | Bowie | Texas | 48037 | 6545 | 181 |
1075619 | 1075619 | 2021-02-28 | Bowie | Texas | 48037 | 6543 | 181 |
1072373 | 1072373 | 2021-02-27 | Bowie | Texas | 48037 | 6532 | 181 |
1049728 | 1049728 | 2021-02-20 | Guadalupe | Texas | 48187 | 12571 | 181 |
971842 | 971842 | 2021-01-27 | Hays | Texas | 48209 | 16395 | 181 |
910149 | 910149 | 2021-01-08 | Ellis | Texas | 48139 | 14836 | 181 |
906925 | 906925 | 2021-01-07 | Gregg | Texas | 48183 | 7299 | 181 |
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);