ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where county = "Dallam", deaths = 26 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 |
---|---|---|---|---|---|---|---|
1747816 | 1747816 | 2021-09-23 | Dallam | Texas | 48111 | 1140 | 26 |
1744566 | 1744566 | 2021-09-22 | Dallam | Texas | 48111 | 1139 | 26 |
1741317 | 1741317 | 2021-09-21 | Dallam | Texas | 48111 | 1123 | 26 |
1738068 | 1738068 | 2021-09-20 | Dallam | Texas | 48111 | 1123 | 26 |
1734818 | 1734818 | 2021-09-19 | Dallam | Texas | 48111 | 1123 | 26 |
1731568 | 1731568 | 2021-09-18 | Dallam | Texas | 48111 | 1123 | 26 |
1728318 | 1728318 | 2021-09-17 | Dallam | Texas | 48111 | 1123 | 26 |
1725069 | 1725069 | 2021-09-16 | Dallam | Texas | 48111 | 1123 | 26 |
1721820 | 1721820 | 2021-09-15 | Dallam | Texas | 48111 | 1123 | 26 |
1718572 | 1718572 | 2021-09-14 | Dallam | Texas | 48111 | 1121 | 26 |
1715324 | 1715324 | 2021-09-13 | Dallam | Texas | 48111 | 1103 | 26 |
1712078 | 1712078 | 2021-09-12 | Dallam | Texas | 48111 | 1103 | 26 |
1708831 | 1708831 | 2021-09-11 | Dallam | Texas | 48111 | 1103 | 26 |
1705584 | 1705584 | 2021-09-10 | Dallam | Texas | 48111 | 1094 | 26 |
1702334 | 1702334 | 2021-09-09 | Dallam | Texas | 48111 | 1097 | 26 |
1699085 | 1699085 | 2021-09-08 | Dallam | Texas | 48111 | 1078 | 26 |
1695837 | 1695837 | 2021-09-07 | Dallam | Texas | 48111 | 1076 | 26 |
1692589 | 1692589 | 2021-09-06 | Dallam | Texas | 48111 | 1076 | 26 |
1689340 | 1689340 | 2021-09-05 | Dallam | Texas | 48111 | 1076 | 26 |
1686090 | 1686090 | 2021-09-04 | Dallam | Texas | 48111 | 1076 | 26 |
1682839 | 1682839 | 2021-09-03 | Dallam | Texas | 48111 | 1075 | 26 |
1679589 | 1679589 | 2021-09-02 | Dallam | Texas | 48111 | 1064 | 26 |
1676341 | 1676341 | 2021-09-01 | Dallam | Texas | 48111 | 1061 | 26 |
1673094 | 1673094 | 2021-08-31 | Dallam | Texas | 48111 | 1035 | 26 |
1669846 | 1669846 | 2021-08-30 | Dallam | Texas | 48111 | 1035 | 26 |
1666599 | 1666599 | 2021-08-29 | Dallam | Texas | 48111 | 1035 | 26 |
1663351 | 1663351 | 2021-08-28 | Dallam | Texas | 48111 | 1035 | 26 |
1660103 | 1660103 | 2021-08-27 | Dallam | Texas | 48111 | 1034 | 26 |
1656854 | 1656854 | 2021-08-26 | Dallam | Texas | 48111 | 1032 | 26 |
1653607 | 1653607 | 2021-08-25 | Dallam | Texas | 48111 | 1027 | 26 |
1650360 | 1650360 | 2021-08-24 | Dallam | Texas | 48111 | 1027 | 26 |
1647111 | 1647111 | 2021-08-23 | Dallam | Texas | 48111 | 1020 | 26 |
1643862 | 1643862 | 2021-08-22 | Dallam | Texas | 48111 | 1020 | 26 |
1640612 | 1640612 | 2021-08-21 | Dallam | Texas | 48111 | 1020 | 26 |
1637362 | 1637362 | 2021-08-20 | Dallam | Texas | 48111 | 1020 | 26 |
1634112 | 1634112 | 2021-08-19 | Dallam | Texas | 48111 | 1011 | 26 |
1630865 | 1630865 | 2021-08-18 | Dallam | Texas | 48111 | 1004 | 26 |
1627618 | 1627618 | 2021-08-17 | Dallam | Texas | 48111 | 1006 | 26 |
1624371 | 1624371 | 2021-08-16 | Dallam | Texas | 48111 | 1005 | 26 |
1621124 | 1621124 | 2021-08-15 | Dallam | Texas | 48111 | 1005 | 26 |
1617876 | 1617876 | 2021-08-14 | Dallam | Texas | 48111 | 1005 | 26 |
1614628 | 1614628 | 2021-08-13 | Dallam | Texas | 48111 | 993 | 26 |
1611379 | 1611379 | 2021-08-12 | Dallam | Texas | 48111 | 997 | 26 |
1608131 | 1608131 | 2021-08-11 | Dallam | Texas | 48111 | 1011 | 26 |
1604882 | 1604882 | 2021-08-10 | Dallam | Texas | 48111 | 1001 | 26 |
1601633 | 1601633 | 2021-08-09 | Dallam | Texas | 48111 | 1003 | 26 |
1598385 | 1598385 | 2021-08-08 | Dallam | Texas | 48111 | 1003 | 26 |
1595136 | 1595136 | 2021-08-07 | Dallam | Texas | 48111 | 1003 | 26 |
1591887 | 1591887 | 2021-08-06 | Dallam | Texas | 48111 | 1003 | 26 |
1588638 | 1588638 | 2021-08-05 | Dallam | Texas | 48111 | 996 | 26 |
1585388 | 1585388 | 2021-08-04 | Dallam | Texas | 48111 | 997 | 26 |
1582138 | 1582138 | 2021-08-03 | Dallam | Texas | 48111 | 996 | 26 |
1578889 | 1578889 | 2021-08-02 | Dallam | Texas | 48111 | 996 | 26 |
1575641 | 1575641 | 2021-08-01 | Dallam | Texas | 48111 | 996 | 26 |
1572393 | 1572393 | 2021-07-31 | Dallam | Texas | 48111 | 996 | 26 |
1569145 | 1569145 | 2021-07-30 | Dallam | Texas | 48111 | 995 | 26 |
1565897 | 1565897 | 2021-07-29 | Dallam | Texas | 48111 | 995 | 26 |
1562649 | 1562649 | 2021-07-28 | Dallam | Texas | 48111 | 994 | 26 |
1559401 | 1559401 | 2021-07-27 | Dallam | Texas | 48111 | 994 | 26 |
1556154 | 1556154 | 2021-07-26 | Dallam | Texas | 48111 | 993 | 26 |
1552907 | 1552907 | 2021-07-25 | Dallam | Texas | 48111 | 993 | 26 |
1549660 | 1549660 | 2021-07-24 | Dallam | Texas | 48111 | 993 | 26 |
1546413 | 1546413 | 2021-07-23 | Dallam | Texas | 48111 | 994 | 26 |
1543166 | 1543166 | 2021-07-22 | Dallam | Texas | 48111 | 994 | 26 |
1539918 | 1539918 | 2021-07-21 | Dallam | Texas | 48111 | 992 | 26 |
1536671 | 1536671 | 2021-07-20 | Dallam | Texas | 48111 | 990 | 26 |
1533423 | 1533423 | 2021-07-19 | Dallam | Texas | 48111 | 989 | 26 |
1530176 | 1530176 | 2021-07-18 | Dallam | Texas | 48111 | 989 | 26 |
1526929 | 1526929 | 2021-07-17 | Dallam | Texas | 48111 | 989 | 26 |
1523682 | 1523682 | 2021-07-16 | Dallam | Texas | 48111 | 989 | 26 |
1520434 | 1520434 | 2021-07-15 | Dallam | Texas | 48111 | 989 | 26 |
1517186 | 1517186 | 2021-07-14 | Dallam | Texas | 48111 | 988 | 26 |
1513939 | 1513939 | 2021-07-13 | Dallam | Texas | 48111 | 988 | 26 |
1510693 | 1510693 | 2021-07-12 | Dallam | Texas | 48111 | 988 | 26 |
1507446 | 1507446 | 2021-07-11 | Dallam | Texas | 48111 | 988 | 26 |
1504200 | 1504200 | 2021-07-10 | Dallam | Texas | 48111 | 988 | 26 |
1500954 | 1500954 | 2021-07-09 | Dallam | Texas | 48111 | 987 | 26 |
1497708 | 1497708 | 2021-07-08 | Dallam | Texas | 48111 | 987 | 26 |
1494461 | 1494461 | 2021-07-07 | Dallam | Texas | 48111 | 987 | 26 |
1491214 | 1491214 | 2021-07-06 | Dallam | Texas | 48111 | 987 | 26 |
1487967 | 1487967 | 2021-07-05 | Dallam | Texas | 48111 | 987 | 26 |
1484720 | 1484720 | 2021-07-04 | Dallam | Texas | 48111 | 987 | 26 |
1481474 | 1481474 | 2021-07-03 | Dallam | Texas | 48111 | 987 | 26 |
1478227 | 1478227 | 2021-07-02 | Dallam | Texas | 48111 | 987 | 26 |
1474981 | 1474981 | 2021-07-01 | Dallam | Texas | 48111 | 987 | 26 |
1471735 | 1471735 | 2021-06-30 | Dallam | Texas | 48111 | 987 | 26 |
1468490 | 1468490 | 2021-06-29 | Dallam | Texas | 48111 | 987 | 26 |
1465245 | 1465245 | 2021-06-28 | Dallam | Texas | 48111 | 986 | 26 |
1462000 | 1462000 | 2021-06-27 | Dallam | Texas | 48111 | 986 | 26 |
1458755 | 1458755 | 2021-06-26 | Dallam | Texas | 48111 | 986 | 26 |
1455510 | 1455510 | 2021-06-25 | Dallam | Texas | 48111 | 987 | 26 |
1452265 | 1452265 | 2021-06-24 | Dallam | Texas | 48111 | 987 | 26 |
1449019 | 1449019 | 2021-06-23 | Dallam | Texas | 48111 | 987 | 26 |
1445774 | 1445774 | 2021-06-22 | Dallam | Texas | 48111 | 987 | 26 |
1442529 | 1442529 | 2021-06-21 | Dallam | Texas | 48111 | 989 | 26 |
1439284 | 1439284 | 2021-06-20 | Dallam | Texas | 48111 | 989 | 26 |
1436037 | 1436037 | 2021-06-19 | Dallam | Texas | 48111 | 989 | 26 |
1432790 | 1432790 | 2021-06-18 | Dallam | Texas | 48111 | 989 | 26 |
1429544 | 1429544 | 2021-06-17 | Dallam | Texas | 48111 | 989 | 26 |
1426299 | 1426299 | 2021-06-16 | Dallam | Texas | 48111 | 989 | 26 |
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);