ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where deaths = 140 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313637 | 2313637 | 2022-03-16 | Uvalde | Texas | 48463 | 10553 | 140 |
2310384 | 2310384 | 2022-03-15 | Uvalde | Texas | 48463 | 10551 | 140 |
2307131 | 2307131 | 2022-03-14 | Uvalde | Texas | 48463 | 10548 | 140 |
2303880 | 2303880 | 2022-03-13 | Uvalde | Texas | 48463 | 10548 | 140 |
2300628 | 2300628 | 2022-03-12 | Uvalde | Texas | 48463 | 10547 | 140 |
2264757 | 2264757 | 2022-03-01 | Kleberg | Texas | 48273 | 7071 | 140 |
2261507 | 2261507 | 2022-02-28 | Kleberg | Texas | 48273 | 7067 | 140 |
2258256 | 2258256 | 2022-02-27 | Kleberg | Texas | 48273 | 7057 | 140 |
2255005 | 2255005 | 2022-02-26 | Kleberg | Texas | 48273 | 7055 | 140 |
2251754 | 2251754 | 2022-02-25 | Kleberg | Texas | 48273 | 7028 | 140 |
2248503 | 2248503 | 2022-02-24 | Kleberg | Texas | 48273 | 6996 | 140 |
2245252 | 2245252 | 2022-02-23 | Kleberg | Texas | 48273 | 6978 | 140 |
2242001 | 2242001 | 2022-02-22 | Kleberg | Texas | 48273 | 6932 | 140 |
2199774 | 2199774 | 2022-02-09 | Palo Pinto | Texas | 48363 | 6897 | 140 |
2193323 | 2193323 | 2022-02-07 | Washington | Texas | 48477 | 8774 | 140 |
2190070 | 2190070 | 2022-02-06 | Washington | Texas | 48477 | 8771 | 140 |
2186817 | 2186817 | 2022-02-05 | Washington | Texas | 48477 | 8761 | 140 |
2183564 | 2183564 | 2022-02-04 | Washington | Texas | 48477 | 8748 | 140 |
2063095 | 2063095 | 2021-12-29 | Hockley | Texas | 48219 | 4661 | 140 |
2059845 | 2059845 | 2021-12-28 | Hockley | Texas | 48219 | 4652 | 140 |
2056596 | 2056596 | 2021-12-27 | Hockley | Texas | 48219 | 4645 | 140 |
2053347 | 2053347 | 2021-12-26 | Hockley | Texas | 48219 | 4618 | 140 |
2050097 | 2050097 | 2021-12-25 | Hockley | Texas | 48219 | 4618 | 140 |
2046847 | 2046847 | 2021-12-24 | Hockley | Texas | 48219 | 4618 | 140 |
2043597 | 2043597 | 2021-12-23 | Hockley | Texas | 48219 | 4618 | 140 |
2040348 | 2040348 | 2021-12-22 | Hockley | Texas | 48219 | 4608 | 140 |
1994862 | 1994862 | 2021-12-08 | Kerr | Texas | 48265 | 7244 | 140 |
1991611 | 1991611 | 2021-12-07 | Kerr | Texas | 48265 | 7230 | 140 |
1988360 | 1988360 | 2021-12-06 | Kerr | Texas | 48265 | 7229 | 140 |
1985110 | 1985110 | 2021-12-05 | Kerr | Texas | 48265 | 7225 | 140 |
1981860 | 1981860 | 2021-12-04 | Kerr | Texas | 48265 | 7224 | 140 |
1978610 | 1978610 | 2021-12-03 | Kerr | Texas | 48265 | 7224 | 140 |
1929832 | 1929832 | 2021-11-18 | Howard | Texas | 48227 | 5843 | 140 |
1913716 | 1913716 | 2021-11-13 | Wilson | Texas | 48493 | 7544 | 140 |
1910466 | 1910466 | 2021-11-12 | Wilson | Texas | 48493 | 7544 | 140 |
1907217 | 1907217 | 2021-11-11 | Wilson | Texas | 48493 | 7531 | 140 |
1874704 | 1874704 | 2021-11-01 | Upshur | Texas | 48459 | 5831 | 140 |
1871455 | 1871455 | 2021-10-31 | Upshur | Texas | 48459 | 5831 | 140 |
1868206 | 1868206 | 2021-10-30 | Upshur | Texas | 48459 | 5831 | 140 |
1864957 | 1864957 | 2021-10-29 | Upshur | Texas | 48459 | 5822 | 140 |
1861708 | 1861708 | 2021-10-28 | Upshur | Texas | 48459 | 5819 | 140 |
1858459 | 1858459 | 2021-10-27 | Upshur | Texas | 48459 | 5815 | 140 |
1855210 | 1855210 | 2021-10-26 | Upshur | Texas | 48459 | 5811 | 140 |
1812853 | 1812853 | 2021-10-13 | Hopkins | Texas | 48223 | 5246 | 140 |
1809566 | 1809566 | 2021-10-12 | Fannin | Texas | 48147 | 4860 | 140 |
1786776 | 1786776 | 2021-10-05 | Caldwell | Texas | 48055 | 8257 | 140 |
1747923 | 1747923 | 2021-09-23 | Medina | Texas | 48325 | 6536 | 140 |
1744673 | 1744673 | 2021-09-22 | Medina | Texas | 48325 | 6525 | 140 |
1741272 | 1741272 | 2021-09-21 | Bastrop | Texas | 48021 | 13562 | 140 |
1738023 | 1738023 | 2021-09-20 | Bastrop | Texas | 48021 | 13510 | 140 |
1734773 | 1734773 | 2021-09-19 | Bastrop | Texas | 48021 | 13510 | 140 |
1734920 | 1734920 | 2021-09-19 | Matagorda | Texas | 48321 | 5772 | 140 |
1731523 | 1731523 | 2021-09-18 | Bastrop | Texas | 48021 | 13510 | 140 |
1731670 | 1731670 | 2021-09-18 | Matagorda | Texas | 48321 | 5755 | 140 |
1728463 | 1728463 | 2021-09-17 | Rusk | Texas | 48401 | 7342 | 140 |
1725214 | 1725214 | 2021-09-16 | Rusk | Texas | 48401 | 7290 | 140 |
1712263 | 1712263 | 2021-09-12 | Wharton | Texas | 48481 | 5489 | 140 |
1709016 | 1709016 | 2021-09-11 | Wharton | Texas | 48481 | 5450 | 140 |
1699030 | 1699030 | 2021-09-08 | Anderson | Texas | 48001 | 6967 | 140 |
1682883 | 1682883 | 2021-09-03 | Hardin | Texas | 48199 | 8661 | 140 |
1657034 | 1657034 | 2021-08-26 | Walker | Texas | 48471 | 9829 | 140 |
1653787 | 1653787 | 2021-08-25 | Walker | Texas | 48471 | 9780 | 140 |
1588693 | 1588693 | 2021-08-05 | Hood | Texas | 48221 | 7262 | 140 |
1585443 | 1585443 | 2021-08-04 | Hood | Texas | 48221 | 7215 | 140 |
1543135 | 1543135 | 2021-07-22 | Brown | Texas | 48049 | 4423 | 140 |
1539887 | 1539887 | 2021-07-21 | Brown | Texas | 48049 | 4423 | 140 |
1536640 | 1536640 | 2021-07-20 | Brown | Texas | 48049 | 4423 | 140 |
1533392 | 1533392 | 2021-07-19 | Brown | Texas | 48049 | 4423 | 140 |
1530145 | 1530145 | 2021-07-18 | Brown | Texas | 48049 | 4423 | 140 |
1526898 | 1526898 | 2021-07-17 | Brown | Texas | 48049 | 4423 | 140 |
1523651 | 1523651 | 2021-07-16 | Brown | Texas | 48049 | 4423 | 140 |
1520403 | 1520403 | 2021-07-15 | Brown | Texas | 48049 | 4386 | 140 |
1517155 | 1517155 | 2021-07-14 | Brown | Texas | 48049 | 4386 | 140 |
1513908 | 1513908 | 2021-07-13 | Brown | Texas | 48049 | 4386 | 140 |
1510662 | 1510662 | 2021-07-12 | Brown | Texas | 48049 | 4386 | 140 |
1507415 | 1507415 | 2021-07-11 | Brown | Texas | 48049 | 4386 | 140 |
1504169 | 1504169 | 2021-07-10 | Brown | Texas | 48049 | 4386 | 140 |
1500923 | 1500923 | 2021-07-09 | Brown | Texas | 48049 | 4386 | 140 |
1497677 | 1497677 | 2021-07-08 | Brown | Texas | 48049 | 4370 | 140 |
1494430 | 1494430 | 2021-07-07 | Brown | Texas | 48049 | 4370 | 140 |
1491183 | 1491183 | 2021-07-06 | Brown | Texas | 48049 | 4370 | 140 |
1487936 | 1487936 | 2021-07-05 | Brown | Texas | 48049 | 4370 | 140 |
1484689 | 1484689 | 2021-07-04 | Brown | Texas | 48049 | 4370 | 140 |
1481443 | 1481443 | 2021-07-03 | Brown | Texas | 48049 | 4370 | 140 |
1478196 | 1478196 | 2021-07-02 | Brown | Texas | 48049 | 4370 | 140 |
1474950 | 1474950 | 2021-07-01 | Brown | Texas | 48049 | 4361 | 140 |
1471704 | 1471704 | 2021-06-30 | Brown | Texas | 48049 | 4361 | 140 |
1468459 | 1468459 | 2021-06-29 | Brown | Texas | 48049 | 4361 | 140 |
1465214 | 1465214 | 2021-06-28 | Brown | Texas | 48049 | 4361 | 140 |
1461969 | 1461969 | 2021-06-27 | Brown | Texas | 48049 | 4361 | 140 |
1458724 | 1458724 | 2021-06-26 | Brown | Texas | 48049 | 4361 | 140 |
1455479 | 1455479 | 2021-06-25 | Brown | Texas | 48049 | 4361 | 140 |
1341888 | 1341888 | 2021-05-21 | Cherokee | Texas | 48073 | 4238 | 140 |
1338640 | 1338640 | 2021-05-20 | Cherokee | Texas | 48073 | 4234 | 140 |
1335393 | 1335393 | 2021-05-19 | Cherokee | Texas | 48073 | 4231 | 140 |
1332146 | 1332146 | 2021-05-18 | Cherokee | Texas | 48073 | 4209 | 140 |
1328899 | 1328899 | 2021-05-17 | Cherokee | Texas | 48073 | 4209 | 140 |
1325653 | 1325653 | 2021-05-16 | Cherokee | Texas | 48073 | 4209 | 140 |
1322407 | 1322407 | 2021-05-15 | Cherokee | Texas | 48073 | 4209 | 140 |
1319161 | 1319161 | 2021-05-14 | Cherokee | Texas | 48073 | 4209 | 140 |
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);