ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
685 rows where deaths = 49 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502374 | 2502374 | 2022-05-13 | Mitchell | Texas | 48335 | 1864 | 49 |
2499116 | 2499116 | 2022-05-12 | Mitchell | Texas | 48335 | 1864 | 49 |
2229045 | 2229045 | 2022-02-18 | Parmer | Texas | 48369 | 2230 | 49 |
2225794 | 2225794 | 2022-02-17 | Parmer | Texas | 48369 | 2226 | 49 |
2225862 | 2225862 | 2022-02-17 | Zapata | Texas | 48505 | 3474 | 49 |
2222543 | 2222543 | 2022-02-16 | Parmer | Texas | 48369 | 2221 | 49 |
2222611 | 2222611 | 2022-02-16 | Zapata | Texas | 48505 | 3448 | 49 |
2219292 | 2219292 | 2022-02-15 | Parmer | Texas | 48369 | 2216 | 49 |
2219360 | 2219360 | 2022-02-15 | Zapata | Texas | 48505 | 3387 | 49 |
2216041 | 2216041 | 2022-02-14 | Parmer | Texas | 48369 | 2210 | 49 |
2216109 | 2216109 | 2022-02-14 | Zapata | Texas | 48505 | 3375 | 49 |
2212790 | 2212790 | 2022-02-13 | Parmer | Texas | 48369 | 2210 | 49 |
2212858 | 2212858 | 2022-02-13 | Zapata | Texas | 48505 | 3341 | 49 |
2199616 | 2199616 | 2022-02-09 | Brooks | Texas | 48047 | 1531 | 49 |
2196362 | 2196362 | 2022-02-08 | Brooks | Texas | 48047 | 1523 | 49 |
2193108 | 2193108 | 2022-02-07 | Brooks | Texas | 48047 | 1520 | 49 |
2189854 | 2189854 | 2022-02-06 | Brooks | Texas | 48047 | 1519 | 49 |
2186601 | 2186601 | 2022-02-05 | Brooks | Texas | 48047 | 1517 | 49 |
2183349 | 2183349 | 2022-02-04 | Brooks | Texas | 48047 | 1509 | 49 |
2183479 | 2183479 | 2022-02-04 | Madison | Texas | 48313 | 3601 | 49 |
2180097 | 2180097 | 2022-02-03 | Brooks | Texas | 48047 | 1502 | 49 |
2180137 | 2180137 | 2022-02-03 | Dimmit | Texas | 48127 | 5391 | 49 |
2180227 | 2180227 | 2022-02-03 | Madison | Texas | 48313 | 3593 | 49 |
2176846 | 2176846 | 2022-02-02 | Brooks | Texas | 48047 | 1495 | 49 |
2176886 | 2176886 | 2022-02-02 | Dimmit | Texas | 48127 | 5354 | 49 |
2176976 | 2176976 | 2022-02-02 | Madison | Texas | 48313 | 3572 | 49 |
2173592 | 2173592 | 2022-02-01 | Brooks | Texas | 48047 | 1490 | 49 |
2173722 | 2173722 | 2022-02-01 | Madison | Texas | 48313 | 3559 | 49 |
2170340 | 2170340 | 2022-01-31 | Brooks | Texas | 48047 | 1481 | 49 |
2170470 | 2170470 | 2022-01-31 | Madison | Texas | 48313 | 3549 | 49 |
2167086 | 2167086 | 2022-01-30 | Brooks | Texas | 48047 | 1477 | 49 |
2167216 | 2167216 | 2022-01-30 | Madison | Texas | 48313 | 3543 | 49 |
2163831 | 2163831 | 2022-01-29 | Brooks | Texas | 48047 | 1475 | 49 |
2163961 | 2163961 | 2022-01-29 | Madison | Texas | 48313 | 3542 | 49 |
2160576 | 2160576 | 2022-01-28 | Brooks | Texas | 48047 | 1464 | 49 |
2160706 | 2160706 | 2022-01-28 | Madison | Texas | 48313 | 3524 | 49 |
2157320 | 2157320 | 2022-01-27 | Brooks | Texas | 48047 | 1449 | 49 |
2157450 | 2157450 | 2022-01-27 | Madison | Texas | 48313 | 3490 | 49 |
2154067 | 2154067 | 2022-01-26 | Brooks | Texas | 48047 | 1440 | 49 |
2154197 | 2154197 | 2022-01-26 | Madison | Texas | 48313 | 3467 | 49 |
2150945 | 2150945 | 2022-01-25 | Madison | Texas | 48313 | 3454 | 49 |
2147693 | 2147693 | 2022-01-24 | Madison | Texas | 48313 | 3448 | 49 |
2144439 | 2144439 | 2022-01-23 | Madison | Texas | 48313 | 3441 | 49 |
2141184 | 2141184 | 2022-01-22 | Madison | Texas | 48313 | 3424 | 49 |
2137928 | 2137928 | 2022-01-21 | Madison | Texas | 48313 | 3400 | 49 |
2134674 | 2134674 | 2022-01-20 | Madison | Texas | 48313 | 3386 | 49 |
2131422 | 2131422 | 2022-01-19 | Madison | Texas | 48313 | 3360 | 49 |
2128204 | 2128204 | 2022-01-18 | Rains | Texas | 48379 | 1575 | 49 |
2124952 | 2124952 | 2022-01-17 | Rains | Texas | 48379 | 1563 | 49 |
2121700 | 2121700 | 2022-01-16 | Rains | Texas | 48379 | 1531 | 49 |
2118448 | 2118448 | 2022-01-15 | Rains | Texas | 48379 | 1526 | 49 |
2115197 | 2115197 | 2022-01-14 | Rains | Texas | 48379 | 1513 | 49 |
2111945 | 2111945 | 2022-01-13 | Rains | Texas | 48379 | 1843 | 49 |
2108693 | 2108693 | 2022-01-12 | Rains | Texas | 48379 | 1808 | 49 |
2105442 | 2105442 | 2022-01-11 | Rains | Texas | 48379 | 1789 | 49 |
2102191 | 2102191 | 2022-01-10 | Rains | Texas | 48379 | 1780 | 49 |
2098940 | 2098940 | 2022-01-09 | Rains | Texas | 48379 | 1772 | 49 |
2095688 | 2095688 | 2022-01-08 | Rains | Texas | 48379 | 1762 | 49 |
2092436 | 2092436 | 2022-01-07 | Rains | Texas | 48379 | 1743 | 49 |
2089184 | 2089184 | 2022-01-06 | Rains | Texas | 48379 | 1735 | 49 |
2085933 | 2085933 | 2022-01-05 | Rains | Texas | 48379 | 1723 | 49 |
2082681 | 2082681 | 2022-01-04 | Rains | Texas | 48379 | 1716 | 49 |
2079429 | 2079429 | 2022-01-03 | Rains | Texas | 48379 | 1705 | 49 |
2076178 | 2076178 | 2022-01-02 | Rains | Texas | 48379 | 1677 | 49 |
2072927 | 2072927 | 2022-01-01 | Rains | Texas | 48379 | 1677 | 49 |
2069676 | 2069676 | 2021-12-31 | Rains | Texas | 48379 | 1677 | 49 |
2066425 | 2066425 | 2021-12-30 | Rains | Texas | 48379 | 1677 | 49 |
2063175 | 2063175 | 2021-12-29 | Rains | Texas | 48379 | 1675 | 49 |
2059925 | 2059925 | 2021-12-28 | Rains | Texas | 48379 | 1675 | 49 |
2056676 | 2056676 | 2021-12-27 | Rains | Texas | 48379 | 1674 | 49 |
2053427 | 2053427 | 2021-12-26 | Rains | Texas | 48379 | 1672 | 49 |
2050177 | 2050177 | 2021-12-25 | Rains | Texas | 48379 | 1672 | 49 |
2046927 | 2046927 | 2021-12-24 | Rains | Texas | 48379 | 1672 | 49 |
2043677 | 2043677 | 2021-12-23 | Rains | Texas | 48379 | 1672 | 49 |
2040428 | 2040428 | 2021-12-22 | Rains | Texas | 48379 | 1672 | 49 |
2037178 | 2037178 | 2021-12-21 | Rains | Texas | 48379 | 1672 | 49 |
2033928 | 2033928 | 2021-12-20 | Rains | Texas | 48379 | 1546 | 49 |
2030678 | 2030678 | 2021-12-19 | Rains | Texas | 48379 | 1546 | 49 |
2027427 | 2027427 | 2021-12-18 | Rains | Texas | 48379 | 1546 | 49 |
2024176 | 2024176 | 2021-12-17 | Rains | Texas | 48379 | 1546 | 49 |
2020925 | 2020925 | 2021-12-16 | Rains | Texas | 48379 | 1546 | 49 |
2017674 | 2017674 | 2021-12-15 | Rains | Texas | 48379 | 1546 | 49 |
2014424 | 2014424 | 2021-12-14 | Rains | Texas | 48379 | 1546 | 49 |
2011173 | 2011173 | 2021-12-13 | Rains | Texas | 48379 | 1545 | 49 |
2007922 | 2007922 | 2021-12-12 | Rains | Texas | 48379 | 1542 | 49 |
2004671 | 2004671 | 2021-12-11 | Rains | Texas | 48379 | 1542 | 49 |
2001420 | 2001420 | 2021-12-10 | Rains | Texas | 48379 | 1542 | 49 |
1998170 | 1998170 | 2021-12-09 | Rains | Texas | 48379 | 1539 | 49 |
1994919 | 1994919 | 2021-12-08 | Rains | Texas | 48379 | 1539 | 49 |
1991668 | 1991668 | 2021-12-07 | Rains | Texas | 48379 | 1539 | 49 |
1988417 | 1988417 | 2021-12-06 | Rains | Texas | 48379 | 1539 | 49 |
1985167 | 1985167 | 2021-12-05 | Rains | Texas | 48379 | 1537 | 49 |
1926541 | 1926541 | 2021-11-17 | Falls | Texas | 48145 | 2604 | 49 |
1855174 | 1855174 | 2021-10-26 | Red River | Texas | 48387 | 1380 | 49 |
1851925 | 1851925 | 2021-10-25 | Red River | Texas | 48387 | 1378 | 49 |
1848675 | 1848675 | 2021-10-24 | Red River | Texas | 48387 | 1378 | 49 |
1845417 | 1845417 | 2021-10-23 | Pecos | Texas | 48371 | 2294 | 49 |
1845425 | 1845425 | 2021-10-23 | Red River | Texas | 48387 | 1378 | 49 |
1842167 | 1842167 | 2021-10-22 | Pecos | Texas | 48371 | 2293 | 49 |
1842175 | 1842175 | 2021-10-22 | Red River | Texas | 48387 | 1378 | 49 |
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);