ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where deaths = 272 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342796 | 2342796 | 2022-03-25 | Hood | Texas | 48221 | 13339 | 272 |
2339543 | 2339543 | 2022-03-24 | Hood | Texas | 48221 | 13336 | 272 |
2336289 | 2336289 | 2022-03-23 | Hood | Texas | 48221 | 13333 | 272 |
2333035 | 2333035 | 2022-03-22 | Hood | Texas | 48221 | 13329 | 272 |
2329782 | 2329782 | 2022-03-21 | Hood | Texas | 48221 | 13327 | 272 |
2326530 | 2326530 | 2022-03-20 | Hood | Texas | 48221 | 13326 | 272 |
2323277 | 2323277 | 2022-03-19 | Hood | Texas | 48221 | 13324 | 272 |
2284370 | 2284370 | 2022-03-07 | Van Zandt | Texas | 48467 | 10338 | 272 |
2281118 | 2281118 | 2022-03-06 | Van Zandt | Texas | 48467 | 10193 | 272 |
2277865 | 2277865 | 2022-03-05 | Van Zandt | Texas | 48467 | 10192 | 272 |
2255118 | 2255118 | 2022-02-26 | Wood | Texas | 48499 | 7960 | 272 |
2251867 | 2251867 | 2022-02-25 | Wood | Texas | 48499 | 7957 | 272 |
1809673 | 1809673 | 2021-10-12 | Orange | Texas | 48361 | 13565 | 272 |
1796610 | 1796610 | 2021-10-08 | Hunt | Texas | 48231 | 10568 | 272 |
1783683 | 1783683 | 2021-10-04 | Parker | Texas | 48367 | 22776 | 272 |
1744529 | 1744529 | 2021-09-22 | Bowie | Texas | 48037 | 11873 | 272 |
1741280 | 1741280 | 2021-09-21 | Bowie | Texas | 48037 | 11801 | 272 |
1738031 | 1738031 | 2021-09-20 | Bowie | Texas | 48037 | 11702 | 272 |
1734781 | 1734781 | 2021-09-19 | Bowie | Texas | 48037 | 11702 | 272 |
1708869 | 1708869 | 2021-09-11 | Guadalupe | Texas | 48187 | 21244 | 272 |
1699264 | 1699264 | 2021-09-08 | Victoria | Texas | 48469 | 12110 | 272 |
1611344 | 1611344 | 2021-08-12 | Brazos | Texas | 48041 | 29565 | 272 |
1475151 | 1475151 | 2021-07-01 | Tom Green | Texas | 48451 | 16953 | 272 |
1471905 | 1471905 | 2021-06-30 | Tom Green | Texas | 48451 | 16947 | 272 |
1468660 | 1468660 | 2021-06-29 | Tom Green | Texas | 48451 | 16945 | 272 |
1465415 | 1465415 | 2021-06-28 | Tom Green | Texas | 48451 | 16940 | 272 |
1462170 | 1462170 | 2021-06-27 | Tom Green | Texas | 48451 | 16932 | 272 |
1458925 | 1458925 | 2021-06-26 | Tom Green | Texas | 48451 | 16932 | 272 |
1455680 | 1455680 | 2021-06-25 | Tom Green | Texas | 48451 | 16932 | 272 |
1452435 | 1452435 | 2021-06-24 | Tom Green | Texas | 48451 | 16932 | 272 |
1449189 | 1449189 | 2021-06-23 | Tom Green | Texas | 48451 | 16930 | 272 |
1445944 | 1445944 | 2021-06-22 | Tom Green | Texas | 48451 | 16929 | 272 |
1442699 | 1442699 | 2021-06-21 | Tom Green | Texas | 48451 | 16928 | 272 |
1439454 | 1439454 | 2021-06-20 | Tom Green | Texas | 48451 | 16927 | 272 |
1436146 | 1436146 | 2021-06-19 | Midland | Texas | 48329 | 17776 | 272 |
1436207 | 1436207 | 2021-06-19 | Tom Green | Texas | 48451 | 16927 | 272 |
1432899 | 1432899 | 2021-06-18 | Midland | Texas | 48329 | 17774 | 272 |
1432960 | 1432960 | 2021-06-18 | Tom Green | Texas | 48451 | 16927 | 272 |
1429653 | 1429653 | 2021-06-17 | Midland | Texas | 48329 | 17772 | 272 |
1429714 | 1429714 | 2021-06-17 | Tom Green | Texas | 48451 | 16926 | 272 |
1426408 | 1426408 | 2021-06-16 | Midland | Texas | 48329 | 17765 | 272 |
1426469 | 1426469 | 2021-06-16 | Tom Green | Texas | 48451 | 16925 | 272 |
1423161 | 1423161 | 2021-06-15 | Midland | Texas | 48329 | 17761 | 272 |
1423222 | 1423222 | 2021-06-15 | Tom Green | Texas | 48451 | 16923 | 272 |
1419915 | 1419915 | 2021-06-14 | Midland | Texas | 48329 | 17761 | 272 |
1419976 | 1419976 | 2021-06-14 | Tom Green | Texas | 48451 | 16921 | 272 |
1416670 | 1416670 | 2021-06-13 | Midland | Texas | 48329 | 17748 | 272 |
1416731 | 1416731 | 2021-06-13 | Tom Green | Texas | 48451 | 16919 | 272 |
1413424 | 1413424 | 2021-06-12 | Midland | Texas | 48329 | 17748 | 272 |
1413485 | 1413485 | 2021-06-12 | Tom Green | Texas | 48451 | 16919 | 272 |
1410179 | 1410179 | 2021-06-11 | Midland | Texas | 48329 | 17748 | 272 |
1410240 | 1410240 | 2021-06-11 | Tom Green | Texas | 48451 | 16919 | 272 |
1406934 | 1406934 | 2021-06-10 | Midland | Texas | 48329 | 17738 | 272 |
1406995 | 1406995 | 2021-06-10 | Tom Green | Texas | 48451 | 16919 | 272 |
1403688 | 1403688 | 2021-06-09 | Midland | Texas | 48329 | 17708 | 272 |
1403749 | 1403749 | 2021-06-09 | Tom Green | Texas | 48451 | 16914 | 272 |
1400443 | 1400443 | 2021-06-08 | Midland | Texas | 48329 | 17708 | 272 |
1400504 | 1400504 | 2021-06-08 | Tom Green | Texas | 48451 | 16914 | 272 |
1397198 | 1397198 | 2021-06-07 | Midland | Texas | 48329 | 17708 | 272 |
1393951 | 1393951 | 2021-06-06 | Midland | Texas | 48329 | 17708 | 272 |
1390706 | 1390706 | 2021-06-05 | Midland | Texas | 48329 | 17708 | 272 |
1387461 | 1387461 | 2021-06-04 | Midland | Texas | 48329 | 17708 | 272 |
1384216 | 1384216 | 2021-06-03 | Midland | Texas | 48329 | 17708 | 272 |
1380970 | 1380970 | 2021-06-02 | Midland | Texas | 48329 | 17708 | 272 |
1377725 | 1377725 | 2021-06-01 | Midland | Texas | 48329 | 17708 | 272 |
1374479 | 1374479 | 2021-05-31 | Midland | Texas | 48329 | 17665 | 272 |
1371234 | 1371234 | 2021-05-30 | Midland | Texas | 48329 | 17665 | 272 |
1367988 | 1367988 | 2021-05-29 | Midland | Texas | 48329 | 17665 | 272 |
1189237 | 1189237 | 2021-04-04 | Angelina | Texas | 48005 | 8213 | 272 |
1185990 | 1185990 | 2021-04-03 | Angelina | Texas | 48005 | 8213 | 272 |
1182743 | 1182743 | 2021-04-02 | Angelina | Texas | 48005 | 8213 | 272 |
1179496 | 1179496 | 2021-04-01 | Angelina | Texas | 48005 | 8213 | 272 |
1065934 | 1065934 | 2021-02-25 | Ellis | Texas | 48139 | 20589 | 272 |
952488 | 952488 | 2021-01-21 | Taylor | Texas | 48441 | 13636 | 272 |
900554 | 900554 | 2021-01-05 | Smith | Texas | 48423 | 13340 | 272 |
796531 | 796531 | 2020-12-04 | Collin | Texas | 48085 | 28105 | 272 |
731730 | 731730 | 2020-11-14 | Lubbock | Texas | 48303 | 25038 | 272 |
534037 | 534037 | 2020-09-14 | Webb | Texas | 48479 | 12676 | 272 |
375697 | 375697 | 2020-07-27 | Cameron | Texas | 48061 | 8201 | 272 |
334235 | 334235 | 2020-07-14 | Tarrant | Texas | 48439 | 19014 | 272 |
331042 | 331042 | 2020-07-13 | Tarrant | Texas | 48439 | 18483 | 272 |
327856 | 327856 | 2020-07-12 | Tarrant | Texas | 48439 | 18161 | 272 |
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);