ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Adair" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716894 | 1716894 | 2021-09-14 | Adair | Kentucky | 21001 | 2830 | 63 |
1713648 | 1713648 | 2021-09-13 | Adair | Kentucky | 21001 | 2749 | 62 |
1710401 | 1710401 | 2021-09-12 | Adair | Kentucky | 21001 | 2749 | 62 |
1707154 | 1707154 | 2021-09-11 | Adair | Kentucky | 21001 | 2749 | 62 |
1703906 | 1703906 | 2021-09-10 | Adair | Kentucky | 21001 | 2722 | 62 |
1700656 | 1700656 | 2021-09-09 | Adair | Kentucky | 21001 | 2687 | 62 |
1697407 | 1697407 | 2021-09-08 | Adair | Kentucky | 21001 | 2656 | 62 |
1694159 | 1694159 | 2021-09-07 | Adair | Kentucky | 21001 | 2623 | 61 |
1690910 | 1690910 | 2021-09-06 | Adair | Kentucky | 21001 | 2623 | 61 |
1687660 | 1687660 | 2021-09-05 | Adair | Kentucky | 21001 | 2623 | 61 |
1684410 | 1684410 | 2021-09-04 | Adair | Kentucky | 21001 | 2623 | 61 |
1681159 | 1681159 | 2021-09-03 | Adair | Kentucky | 21001 | 2596 | 61 |
1677911 | 1677911 | 2021-09-02 | Adair | Kentucky | 21001 | 2576 | 60 |
1674664 | 1674664 | 2021-09-01 | Adair | Kentucky | 21001 | 2576 | 60 |
1671415 | 1671415 | 2021-08-31 | Adair | Kentucky | 21001 | 2557 | 60 |
1668168 | 1668168 | 2021-08-30 | Adair | Kentucky | 21001 | 2526 | 60 |
1664921 | 1664921 | 2021-08-29 | Adair | Kentucky | 21001 | 2482 | 60 |
1661673 | 1661673 | 2021-08-28 | Adair | Kentucky | 21001 | 2482 | 60 |
1658425 | 1658425 | 2021-08-27 | Adair | Kentucky | 21001 | 2449 | 59 |
1655177 | 1655177 | 2021-08-26 | Adair | Kentucky | 21001 | 2419 | 59 |
1651930 | 1651930 | 2021-08-25 | Adair | Kentucky | 21001 | 2419 | 59 |
1648681 | 1648681 | 2021-08-24 | Adair | Kentucky | 21001 | 2370 | 58 |
1645433 | 1645433 | 2021-08-23 | Adair | Kentucky | 21001 | 2339 | 58 |
1642184 | 1642184 | 2021-08-22 | Adair | Kentucky | 21001 | 2339 | 58 |
1638934 | 1638934 | 2021-08-21 | Adair | Kentucky | 21001 | 2339 | 58 |
1635684 | 1635684 | 2021-08-20 | Adair | Kentucky | 21001 | 2339 | 58 |
1632434 | 1632434 | 2021-08-19 | Adair | Kentucky | 21001 | 2290 | 58 |
1629187 | 1629187 | 2021-08-18 | Adair | Kentucky | 21001 | 2290 | 58 |
1625940 | 1625940 | 2021-08-17 | Adair | Kentucky | 21001 | 2239 | 57 |
1622693 | 1622693 | 2021-08-16 | Adair | Kentucky | 21001 | 2239 | 57 |
1619446 | 1619446 | 2021-08-15 | Adair | Kentucky | 21001 | 2212 | 57 |
1616198 | 1616198 | 2021-08-14 | Adair | Kentucky | 21001 | 2212 | 57 |
1612949 | 1612949 | 2021-08-13 | Adair | Kentucky | 21001 | 2184 | 57 |
1609701 | 1609701 | 2021-08-12 | Adair | Kentucky | 21001 | 2167 | 57 |
1606452 | 1606452 | 2021-08-11 | Adair | Kentucky | 21001 | 2167 | 57 |
1603203 | 1603203 | 2021-08-10 | Adair | Kentucky | 21001 | 2134 | 57 |
1599954 | 1599954 | 2021-08-09 | Adair | Kentucky | 21001 | 2134 | 57 |
1596706 | 1596706 | 2021-08-08 | Adair | Kentucky | 21001 | 2131 | 56 |
1593457 | 1593457 | 2021-08-07 | Adair | Kentucky | 21001 | 2131 | 56 |
1590208 | 1590208 | 2021-08-06 | Adair | Kentucky | 21001 | 2121 | 56 |
1586959 | 1586959 | 2021-08-05 | Adair | Kentucky | 21001 | 2121 | 56 |
1583709 | 1583709 | 2021-08-04 | Adair | Kentucky | 21001 | 2101 | 55 |
1580459 | 1580459 | 2021-08-03 | Adair | Kentucky | 21001 | 2092 | 55 |
1577210 | 1577210 | 2021-08-02 | Adair | Kentucky | 21001 | 2092 | 55 |
1573962 | 1573962 | 2021-08-01 | Adair | Kentucky | 21001 | 2074 | 55 |
1570714 | 1570714 | 2021-07-31 | Adair | Kentucky | 21001 | 2074 | 55 |
1567466 | 1567466 | 2021-07-30 | Adair | Kentucky | 21001 | 2063 | 54 |
1564218 | 1564218 | 2021-07-29 | Adair | Kentucky | 21001 | 2052 | 54 |
1560970 | 1560970 | 2021-07-28 | Adair | Kentucky | 21001 | 2052 | 54 |
1557723 | 1557723 | 2021-07-27 | Adair | Kentucky | 21001 | 2018 | 54 |
1554476 | 1554476 | 2021-07-26 | Adair | Kentucky | 21001 | 2018 | 54 |
1551229 | 1551229 | 2021-07-25 | Adair | Kentucky | 21001 | 2018 | 54 |
1547982 | 1547982 | 2021-07-24 | Adair | Kentucky | 21001 | 2018 | 54 |
1544735 | 1544735 | 2021-07-23 | Adair | Kentucky | 21001 | 2018 | 54 |
1541487 | 1541487 | 2021-07-22 | Adair | Kentucky | 21001 | 1994 | 54 |
1538240 | 1538240 | 2021-07-21 | Adair | Kentucky | 21001 | 1990 | 54 |
1534992 | 1534992 | 2021-07-20 | Adair | Kentucky | 21001 | 1990 | 54 |
1531745 | 1531745 | 2021-07-19 | Adair | Kentucky | 21001 | 1990 | 54 |
1528498 | 1528498 | 2021-07-18 | Adair | Kentucky | 21001 | 1986 | 54 |
1525251 | 1525251 | 2021-07-17 | Adair | Kentucky | 21001 | 1986 | 54 |
1522003 | 1522003 | 2021-07-16 | Adair | Kentucky | 21001 | 1986 | 54 |
1518755 | 1518755 | 2021-07-15 | Adair | Kentucky | 21001 | 1985 | 54 |
1515508 | 1515508 | 2021-07-14 | Adair | Kentucky | 21001 | 1978 | 54 |
1512262 | 1512262 | 2021-07-13 | Adair | Kentucky | 21001 | 1974 | 54 |
1509015 | 1509015 | 2021-07-12 | Adair | Kentucky | 21001 | 1970 | 54 |
1505769 | 1505769 | 2021-07-11 | Adair | Kentucky | 21001 | 1968 | 54 |
1502523 | 1502523 | 2021-07-10 | Adair | Kentucky | 21001 | 1968 | 54 |
1499277 | 1499277 | 2021-07-09 | Adair | Kentucky | 21001 | 1968 | 54 |
1496030 | 1496030 | 2021-07-08 | Adair | Kentucky | 21001 | 1967 | 54 |
1492784 | 1492784 | 2021-07-07 | Adair | Kentucky | 21001 | 1967 | 54 |
1489537 | 1489537 | 2021-07-06 | Adair | Kentucky | 21001 | 1967 | 54 |
1486290 | 1486290 | 2021-07-05 | Adair | Kentucky | 21001 | 1963 | 54 |
1483044 | 1483044 | 2021-07-04 | Adair | Kentucky | 21001 | 1963 | 54 |
1479797 | 1479797 | 2021-07-03 | Adair | Kentucky | 21001 | 1963 | 54 |
1476551 | 1476551 | 2021-07-02 | Adair | Kentucky | 21001 | 1963 | 54 |
1473305 | 1473305 | 2021-07-01 | Adair | Kentucky | 21001 | 1960 | 54 |
1470059 | 1470059 | 2021-06-30 | Adair | Kentucky | 21001 | 1960 | 54 |
1466814 | 1466814 | 2021-06-29 | Adair | Kentucky | 21001 | 1960 | 54 |
1463569 | 1463569 | 2021-06-28 | Adair | Kentucky | 21001 | 1960 | 54 |
1460324 | 1460324 | 2021-06-27 | Adair | Kentucky | 21001 | 1960 | 54 |
1457079 | 1457079 | 2021-06-26 | Adair | Kentucky | 21001 | 1960 | 54 |
1453834 | 1453834 | 2021-06-25 | Adair | Kentucky | 21001 | 1960 | 54 |
1450588 | 1450588 | 2021-06-24 | Adair | Kentucky | 21001 | 1958 | 54 |
1447343 | 1447343 | 2021-06-23 | Adair | Kentucky | 21001 | 1958 | 54 |
1444098 | 1444098 | 2021-06-22 | Adair | Kentucky | 21001 | 1958 | 54 |
1440853 | 1440853 | 2021-06-21 | Adair | Kentucky | 21001 | 1958 | 54 |
1437606 | 1437606 | 2021-06-20 | Adair | Kentucky | 21001 | 1958 | 54 |
1434359 | 1434359 | 2021-06-19 | Adair | Kentucky | 21001 | 1952 | 54 |
1431113 | 1431113 | 2021-06-18 | Adair | Kentucky | 21001 | 1952 | 54 |
1427868 | 1427868 | 2021-06-17 | Adair | Kentucky | 21001 | 1952 | 54 |
1424623 | 1424623 | 2021-06-16 | Adair | Kentucky | 21001 | 1952 | 54 |
1421375 | 1421375 | 2021-06-15 | Adair | Kentucky | 21001 | 1952 | 54 |
1418130 | 1418130 | 2021-06-14 | Adair | Kentucky | 21001 | 1952 | 54 |
1414884 | 1414884 | 2021-06-13 | Adair | Kentucky | 21001 | 1952 | 54 |
1411639 | 1411639 | 2021-06-12 | Adair | Kentucky | 21001 | 1952 | 54 |
1408394 | 1408394 | 2021-06-11 | Adair | Kentucky | 21001 | 1952 | 54 |
1405148 | 1405148 | 2021-06-10 | Adair | Kentucky | 21001 | 1952 | 54 |
1401903 | 1401903 | 2021-06-09 | Adair | Kentucky | 21001 | 1952 | 54 |
1398658 | 1398658 | 2021-06-08 | Adair | Kentucky | 21001 | 1951 | 54 |
1395411 | 1395411 | 2021-06-07 | Adair | Kentucky | 21001 | 1950 | 54 |
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);