ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
170 rows where deaths = 121 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2274450 | 2274450 | 2022-03-04 | Erath | Texas | 48143 | 8597 | 121 |
2271197 | 2271197 | 2022-03-03 | Erath | Texas | 48143 | 8582 | 121 |
2271266 | 2271266 | 2022-03-03 | Lamb | Texas | 48279 | 4268 | 121 |
2271294 | 2271294 | 2022-03-03 | Montague | Texas | 48337 | 4625 | 121 |
2267945 | 2267945 | 2022-03-02 | Erath | Texas | 48143 | 8561 | 121 |
2268042 | 2268042 | 2022-03-02 | Montague | Texas | 48337 | 4622 | 121 |
2264789 | 2264789 | 2022-03-01 | Montague | Texas | 48337 | 4621 | 121 |
2261539 | 2261539 | 2022-02-28 | Montague | Texas | 48337 | 4620 | 121 |
2258288 | 2258288 | 2022-02-27 | Montague | Texas | 48337 | 4620 | 121 |
2255037 | 2255037 | 2022-02-26 | Montague | Texas | 48337 | 4620 | 121 |
2228950 | 2228950 | 2022-02-18 | Gray | Texas | 48179 | 6014 | 121 |
2219332 | 2219332 | 2022-02-15 | Titus | Texas | 48449 | 8145 | 121 |
2216081 | 2216081 | 2022-02-14 | Titus | Texas | 48449 | 8117 | 121 |
2212830 | 2212830 | 2022-02-13 | Titus | Texas | 48449 | 8112 | 121 |
2196387 | 2196387 | 2022-02-08 | Cooke | Texas | 48097 | 7014 | 121 |
2196548 | 2196548 | 2022-02-08 | Shelby | Texas | 48419 | 4220 | 121 |
2193294 | 2193294 | 2022-02-07 | Shelby | Texas | 48419 | 4212 | 121 |
2193329 | 2193329 | 2022-02-07 | Willacy | Texas | 48489 | 6467 | 121 |
2190040 | 2190040 | 2022-02-06 | Shelby | Texas | 48419 | 4204 | 121 |
2190076 | 2190076 | 2022-02-06 | Willacy | Texas | 48489 | 6447 | 121 |
2186823 | 2186823 | 2022-02-05 | Willacy | Texas | 48489 | 6439 | 121 |
2183570 | 2183570 | 2022-02-04 | Willacy | Texas | 48489 | 6417 | 121 |
2180318 | 2180318 | 2022-02-03 | Willacy | Texas | 48489 | 6402 | 121 |
2173685 | 2173685 | 2022-02-01 | Hutchinson | Texas | 48233 | 6314 | 121 |
2173801 | 2173801 | 2022-02-01 | Uvalde | Texas | 48463 | 10137 | 121 |
2170549 | 2170549 | 2022-01-31 | Uvalde | Texas | 48463 | 10109 | 121 |
2167295 | 2167295 | 2022-01-30 | Uvalde | Texas | 48463 | 10022 | 121 |
2163924 | 2163924 | 2022-01-29 | Hutchinson | Texas | 48233 | 6248 | 121 |
2164040 | 2164040 | 2022-01-29 | Uvalde | Texas | 48463 | 9983 | 121 |
2160669 | 2160669 | 2022-01-28 | Hutchinson | Texas | 48233 | 6207 | 121 |
2160785 | 2160785 | 2022-01-28 | Uvalde | Texas | 48463 | 9907 | 121 |
2157529 | 2157529 | 2022-01-27 | Uvalde | Texas | 48463 | 9840 | 121 |
2154276 | 2154276 | 2022-01-26 | Uvalde | Texas | 48463 | 9749 | 121 |
2151024 | 2151024 | 2022-01-25 | Uvalde | Texas | 48463 | 9663 | 121 |
2147772 | 2147772 | 2022-01-24 | Uvalde | Texas | 48463 | 9579 | 121 |
2144518 | 2144518 | 2022-01-23 | Uvalde | Texas | 48463 | 9478 | 121 |
2141263 | 2141263 | 2022-01-22 | Uvalde | Texas | 48463 | 9349 | 121 |
1851758 | 1851758 | 2021-10-25 | Burnet | Texas | 48053 | 7380 | 121 |
1848508 | 1848508 | 2021-10-24 | Burnet | Texas | 48053 | 7355 | 121 |
1845258 | 1845258 | 2021-10-23 | Burnet | Texas | 48053 | 7355 | 121 |
1793484 | 1793484 | 2021-10-07 | Washington | Texas | 48477 | 5616 | 121 |
1790235 | 1790235 | 2021-10-06 | Washington | Texas | 48477 | 5601 | 121 |
1786987 | 1786987 | 2021-10-05 | Washington | Texas | 48477 | 5593 | 121 |
1783738 | 1783738 | 2021-10-04 | Washington | Texas | 48477 | 5583 | 121 |
1783746 | 1783746 | 2021-10-04 | Wilson | Texas | 48493 | 7058 | 121 |
1780489 | 1780489 | 2021-10-03 | Washington | Texas | 48477 | 5567 | 121 |
1777239 | 1777239 | 2021-10-02 | Washington | Texas | 48477 | 5567 | 121 |
1770730 | 1770730 | 2021-09-30 | Upshur | Texas | 48459 | 5576 | 121 |
1760890 | 1760890 | 2021-09-27 | Kleberg | Texas | 48273 | 4177 | 121 |
1757642 | 1757642 | 2021-09-26 | Kleberg | Texas | 48273 | 4177 | 121 |
1754394 | 1754394 | 2021-09-25 | Kleberg | Texas | 48273 | 4174 | 121 |
1751146 | 1751146 | 2021-09-24 | Kleberg | Texas | 48273 | 4164 | 121 |
1747897 | 1747897 | 2021-09-23 | Kleberg | Texas | 48273 | 4152 | 121 |
1744647 | 1744647 | 2021-09-22 | Kleberg | Texas | 48273 | 4136 | 121 |
1741398 | 1741398 | 2021-09-21 | Kleberg | Texas | 48273 | 4124 | 121 |
1718626 | 1718626 | 2021-09-14 | Hockley | Texas | 48219 | 3828 | 121 |
1718637 | 1718637 | 2021-09-14 | Jasper | Texas | 48241 | 3647 | 121 |
1702352 | 1702352 | 2021-09-09 | Fannin | Texas | 48147 | 4132 | 121 |
1682941 | 1682941 | 2021-09-03 | Matagorda | Texas | 48321 | 5238 | 121 |
1679691 | 1679691 | 2021-09-02 | Matagorda | Texas | 48321 | 5186 | 121 |
1676443 | 1676443 | 2021-09-01 | Matagorda | Texas | 48321 | 5111 | 121 |
1673049 | 1673049 | 2021-08-31 | Bastrop | Texas | 48021 | 12224 | 121 |
1673147 | 1673147 | 2021-08-31 | Hill | Texas | 48217 | 5146 | 121 |
1669801 | 1669801 | 2021-08-30 | Bastrop | Texas | 48021 | 12199 | 121 |
1666554 | 1666554 | 2021-08-29 | Bastrop | Texas | 48021 | 12080 | 121 |
1663306 | 1663306 | 2021-08-28 | Bastrop | Texas | 48021 | 12080 | 121 |
1660248 | 1660248 | 2021-08-27 | Rusk | Texas | 48401 | 5723 | 121 |
1656923 | 1656923 | 2021-08-26 | Jim Wells | Texas | 48249 | 5917 | 121 |
1653676 | 1653676 | 2021-08-25 | Jim Wells | Texas | 48249 | 5858 | 121 |
1650429 | 1650429 | 2021-08-24 | Jim Wells | Texas | 48249 | 5808 | 121 |
1647218 | 1647218 | 2021-08-23 | Medina | Texas | 48325 | 5590 | 121 |
1643969 | 1643969 | 2021-08-22 | Medina | Texas | 48325 | 5586 | 121 |
1640719 | 1640719 | 2021-08-21 | Medina | Texas | 48325 | 5586 | 121 |
1611423 | 1611423 | 2021-08-12 | Hardin | Texas | 48199 | 6959 | 121 |
1608175 | 1608175 | 2021-08-11 | Hardin | Texas | 48199 | 6924 | 121 |
1604926 | 1604926 | 2021-08-10 | Hardin | Texas | 48199 | 6893 | 121 |
1566028 | 1566028 | 2021-07-29 | Polk | Texas | 48373 | 3681 | 121 |
1562780 | 1562780 | 2021-07-28 | Polk | Texas | 48373 | 3650 | 121 |
1559532 | 1559532 | 2021-07-27 | Polk | Texas | 48373 | 3615 | 121 |
1559586 | 1559586 | 2021-07-27 | Wharton | Texas | 48481 | 4372 | 121 |
1556285 | 1556285 | 2021-07-26 | Polk | Texas | 48373 | 3615 | 121 |
1553038 | 1553038 | 2021-07-25 | Polk | Texas | 48373 | 3585 | 121 |
1549791 | 1549791 | 2021-07-24 | Polk | Texas | 48373 | 3585 | 121 |
1546544 | 1546544 | 2021-07-23 | Polk | Texas | 48373 | 3585 | 121 |
1413493 | 1413493 | 2021-06-12 | Van Zandt | Texas | 48467 | 4419 | 121 |
1384300 | 1384300 | 2021-06-03 | Wise | Texas | 48497 | 7421 | 121 |
1381054 | 1381054 | 2021-06-02 | Wise | Texas | 48497 | 7420 | 121 |
1377809 | 1377809 | 2021-06-01 | Wise | Texas | 48497 | 7406 | 121 |
1374563 | 1374563 | 2021-05-31 | Wise | Texas | 48497 | 7406 | 121 |
1371318 | 1371318 | 2021-05-30 | Wise | Texas | 48497 | 7406 | 121 |
1368072 | 1368072 | 2021-05-29 | Wise | Texas | 48497 | 7406 | 121 |
1364826 | 1364826 | 2021-05-28 | Wise | Texas | 48497 | 7398 | 121 |
1361580 | 1361580 | 2021-05-27 | Wise | Texas | 48497 | 7389 | 121 |
1358334 | 1358334 | 2021-05-26 | Wise | Texas | 48497 | 7381 | 121 |
1355088 | 1355088 | 2021-05-25 | Wise | Texas | 48497 | 7379 | 121 |
1351842 | 1351842 | 2021-05-24 | Wise | Texas | 48497 | 7370 | 121 |
1348596 | 1348596 | 2021-05-23 | Wise | Texas | 48497 | 7370 | 121 |
1345348 | 1345348 | 2021-05-22 | Wise | Texas | 48497 | 7370 | 121 |
1342100 | 1342100 | 2021-05-21 | Wise | Texas | 48497 | 7367 | 121 |
1338852 | 1338852 | 2021-05-20 | Wise | Texas | 48497 | 7365 | 121 |
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);