ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 34, fips = 48371 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 |
---|---|---|---|---|---|---|---|
1465375 | 1465375 | 2021-06-28 | Pecos | Texas | 48371 | 1693 | 34 |
1462130 | 1462130 | 2021-06-27 | Pecos | Texas | 48371 | 1693 | 34 |
1458885 | 1458885 | 2021-06-26 | Pecos | Texas | 48371 | 1693 | 34 |
1455640 | 1455640 | 2021-06-25 | Pecos | Texas | 48371 | 1697 | 34 |
1452395 | 1452395 | 2021-06-24 | Pecos | Texas | 48371 | 1693 | 34 |
1449149 | 1449149 | 2021-06-23 | Pecos | Texas | 48371 | 1692 | 34 |
1445904 | 1445904 | 2021-06-22 | Pecos | Texas | 48371 | 1691 | 34 |
1442659 | 1442659 | 2021-06-21 | Pecos | Texas | 48371 | 1691 | 34 |
1439414 | 1439414 | 2021-06-20 | Pecos | Texas | 48371 | 1691 | 34 |
1436167 | 1436167 | 2021-06-19 | Pecos | Texas | 48371 | 1691 | 34 |
1432920 | 1432920 | 2021-06-18 | Pecos | Texas | 48371 | 1681 | 34 |
1429674 | 1429674 | 2021-06-17 | Pecos | Texas | 48371 | 1678 | 34 |
1426429 | 1426429 | 2021-06-16 | Pecos | Texas | 48371 | 1678 | 34 |
1423182 | 1423182 | 2021-06-15 | Pecos | Texas | 48371 | 1676 | 34 |
1419936 | 1419936 | 2021-06-14 | Pecos | Texas | 48371 | 1676 | 34 |
1416691 | 1416691 | 2021-06-13 | Pecos | Texas | 48371 | 1676 | 34 |
1413445 | 1413445 | 2021-06-12 | Pecos | Texas | 48371 | 1675 | 34 |
1410200 | 1410200 | 2021-06-11 | Pecos | Texas | 48371 | 1678 | 34 |
1406955 | 1406955 | 2021-06-10 | Pecos | Texas | 48371 | 1671 | 34 |
1403709 | 1403709 | 2021-06-09 | Pecos | Texas | 48371 | 1673 | 34 |
1400464 | 1400464 | 2021-06-08 | Pecos | Texas | 48371 | 1673 | 34 |
1397219 | 1397219 | 2021-06-07 | Pecos | Texas | 48371 | 1673 | 34 |
1393972 | 1393972 | 2021-06-06 | Pecos | Texas | 48371 | 1673 | 34 |
1390727 | 1390727 | 2021-06-05 | Pecos | Texas | 48371 | 1676 | 34 |
1387482 | 1387482 | 2021-06-04 | Pecos | Texas | 48371 | 1676 | 34 |
1384237 | 1384237 | 2021-06-03 | Pecos | Texas | 48371 | 1673 | 34 |
1380991 | 1380991 | 2021-06-02 | Pecos | Texas | 48371 | 1677 | 34 |
1377746 | 1377746 | 2021-06-01 | Pecos | Texas | 48371 | 1675 | 34 |
1374500 | 1374500 | 2021-05-31 | Pecos | Texas | 48371 | 1675 | 34 |
1371255 | 1371255 | 2021-05-30 | Pecos | Texas | 48371 | 1675 | 34 |
1368009 | 1368009 | 2021-05-29 | Pecos | Texas | 48371 | 1675 | 34 |
1364763 | 1364763 | 2021-05-28 | Pecos | Texas | 48371 | 1678 | 34 |
1361517 | 1361517 | 2021-05-27 | Pecos | Texas | 48371 | 1677 | 34 |
1358271 | 1358271 | 2021-05-26 | Pecos | Texas | 48371 | 1678 | 34 |
1355025 | 1355025 | 2021-05-25 | Pecos | Texas | 48371 | 1678 | 34 |
1351779 | 1351779 | 2021-05-24 | Pecos | Texas | 48371 | 1679 | 34 |
1348533 | 1348533 | 2021-05-23 | Pecos | Texas | 48371 | 1679 | 34 |
1345285 | 1345285 | 2021-05-22 | Pecos | Texas | 48371 | 1679 | 34 |
1342037 | 1342037 | 2021-05-21 | Pecos | Texas | 48371 | 1681 | 34 |
1338789 | 1338789 | 2021-05-20 | Pecos | Texas | 48371 | 1674 | 34 |
1335542 | 1335542 | 2021-05-19 | Pecos | Texas | 48371 | 1677 | 34 |
1332295 | 1332295 | 2021-05-18 | Pecos | Texas | 48371 | 1672 | 34 |
1329048 | 1329048 | 2021-05-17 | Pecos | Texas | 48371 | 1670 | 34 |
1325802 | 1325802 | 2021-05-16 | Pecos | Texas | 48371 | 1670 | 34 |
1322556 | 1322556 | 2021-05-15 | Pecos | Texas | 48371 | 1673 | 34 |
1319310 | 1319310 | 2021-05-14 | Pecos | Texas | 48371 | 1670 | 34 |
1316062 | 1316062 | 2021-05-13 | Pecos | Texas | 48371 | 1667 | 34 |
1312816 | 1312816 | 2021-05-12 | Pecos | Texas | 48371 | 1668 | 34 |
1309569 | 1309569 | 2021-05-11 | Pecos | Texas | 48371 | 1663 | 34 |
1306323 | 1306323 | 2021-05-10 | Pecos | Texas | 48371 | 1663 | 34 |
1303077 | 1303077 | 2021-05-09 | Pecos | Texas | 48371 | 1663 | 34 |
1299830 | 1299830 | 2021-05-08 | Pecos | Texas | 48371 | 1663 | 34 |
1296583 | 1296583 | 2021-05-07 | Pecos | Texas | 48371 | 1667 | 34 |
1293337 | 1293337 | 2021-05-06 | Pecos | Texas | 48371 | 1660 | 34 |
1290091 | 1290091 | 2021-05-05 | Pecos | Texas | 48371 | 1660 | 34 |
1286845 | 1286845 | 2021-05-04 | Pecos | Texas | 48371 | 1660 | 34 |
1283599 | 1283599 | 2021-05-03 | Pecos | Texas | 48371 | 1658 | 34 |
1280352 | 1280352 | 2021-05-02 | Pecos | Texas | 48371 | 1658 | 34 |
1277105 | 1277105 | 2021-05-01 | Pecos | Texas | 48371 | 1657 | 34 |
1273858 | 1273858 | 2021-04-30 | Pecos | Texas | 48371 | 1659 | 34 |
1270611 | 1270611 | 2021-04-29 | Pecos | Texas | 48371 | 1654 | 34 |
1267364 | 1267364 | 2021-04-28 | Pecos | Texas | 48371 | 1654 | 34 |
1264117 | 1264117 | 2021-04-27 | Pecos | Texas | 48371 | 1659 | 34 |
1260870 | 1260870 | 2021-04-26 | Pecos | Texas | 48371 | 1657 | 34 |
1257623 | 1257623 | 2021-04-25 | Pecos | Texas | 48371 | 1656 | 34 |
1254376 | 1254376 | 2021-04-24 | Pecos | Texas | 48371 | 1657 | 34 |
1251129 | 1251129 | 2021-04-23 | Pecos | Texas | 48371 | 1662 | 34 |
1247882 | 1247882 | 2021-04-22 | Pecos | Texas | 48371 | 1613 | 34 |
1244635 | 1244635 | 2021-04-21 | Pecos | Texas | 48371 | 1594 | 34 |
1241388 | 1241388 | 2021-04-20 | Pecos | Texas | 48371 | 1588 | 34 |
1238141 | 1238141 | 2021-04-19 | Pecos | Texas | 48371 | 1587 | 34 |
1234894 | 1234894 | 2021-04-18 | Pecos | Texas | 48371 | 1587 | 34 |
1231646 | 1231646 | 2021-04-17 | Pecos | Texas | 48371 | 1584 | 34 |
1228398 | 1228398 | 2021-04-16 | Pecos | Texas | 48371 | 1588 | 34 |
1225150 | 1225150 | 2021-04-15 | Pecos | Texas | 48371 | 1585 | 34 |
1221903 | 1221903 | 2021-04-14 | Pecos | Texas | 48371 | 1593 | 34 |
1218655 | 1218655 | 2021-04-13 | Pecos | Texas | 48371 | 1588 | 34 |
1215407 | 1215407 | 2021-04-12 | Pecos | Texas | 48371 | 1578 | 34 |
1212160 | 1212160 | 2021-04-11 | Pecos | Texas | 48371 | 1575 | 34 |
1208911 | 1208911 | 2021-04-10 | Pecos | Texas | 48371 | 1574 | 34 |
1205663 | 1205663 | 2021-04-09 | Pecos | Texas | 48371 | 1574 | 34 |
1202415 | 1202415 | 2021-04-08 | Pecos | Texas | 48371 | 1572 | 34 |
1199166 | 1199166 | 2021-04-07 | Pecos | Texas | 48371 | 1577 | 34 |
1195917 | 1195917 | 2021-04-06 | Pecos | Texas | 48371 | 1572 | 34 |
1192669 | 1192669 | 2021-04-05 | Pecos | Texas | 48371 | 1575 | 34 |
1189420 | 1189420 | 2021-04-04 | Pecos | Texas | 48371 | 1575 | 34 |
1186173 | 1186173 | 2021-04-03 | Pecos | Texas | 48371 | 1575 | 34 |
1182926 | 1182926 | 2021-04-02 | Pecos | Texas | 48371 | 1564 | 34 |
1179679 | 1179679 | 2021-04-01 | Pecos | Texas | 48371 | 1564 | 34 |
1176432 | 1176432 | 2021-03-31 | Pecos | Texas | 48371 | 1561 | 34 |
1173185 | 1173185 | 2021-03-30 | Pecos | Texas | 48371 | 1561 | 34 |
1169938 | 1169938 | 2021-03-29 | Pecos | Texas | 48371 | 1561 | 34 |
1166690 | 1166690 | 2021-03-28 | Pecos | Texas | 48371 | 1561 | 34 |
1163442 | 1163442 | 2021-03-27 | Pecos | Texas | 48371 | 1556 | 34 |
1160193 | 1160193 | 2021-03-26 | Pecos | Texas | 48371 | 1558 | 34 |
1156946 | 1156946 | 2021-03-25 | Pecos | Texas | 48371 | 1554 | 34 |
1153699 | 1153699 | 2021-03-24 | Pecos | Texas | 48371 | 1556 | 34 |
1150452 | 1150452 | 2021-03-23 | Pecos | Texas | 48371 | 1554 | 34 |
1147205 | 1147205 | 2021-03-22 | Pecos | Texas | 48371 | 1554 | 34 |
1143958 | 1143958 | 2021-03-21 | Pecos | Texas | 48371 | 1553 | 34 |
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);