ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 21229 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717008 | 1717008 | 2021-09-14 | Washington | Kentucky | 21229 | 2095 | 42 |
1713762 | 1713762 | 2021-09-13 | Washington | Kentucky | 21229 | 2079 | 42 |
1710515 | 1710515 | 2021-09-12 | Washington | Kentucky | 21229 | 2059 | 42 |
1707268 | 1707268 | 2021-09-11 | Washington | Kentucky | 21229 | 2059 | 42 |
1704020 | 1704020 | 2021-09-10 | Washington | Kentucky | 21229 | 2059 | 42 |
1700770 | 1700770 | 2021-09-09 | Washington | Kentucky | 21229 | 2037 | 42 |
1697521 | 1697521 | 2021-09-08 | Washington | Kentucky | 21229 | 2022 | 42 |
1694273 | 1694273 | 2021-09-07 | Washington | Kentucky | 21229 | 1999 | 42 |
1691024 | 1691024 | 2021-09-06 | Washington | Kentucky | 21229 | 1968 | 42 |
1687774 | 1687774 | 2021-09-05 | Washington | Kentucky | 21229 | 1968 | 42 |
1684524 | 1684524 | 2021-09-04 | Washington | Kentucky | 21229 | 1968 | 42 |
1681273 | 1681273 | 2021-09-03 | Washington | Kentucky | 21229 | 1968 | 42 |
1678025 | 1678025 | 2021-09-02 | Washington | Kentucky | 21229 | 1947 | 42 |
1674778 | 1674778 | 2021-09-01 | Washington | Kentucky | 21229 | 1929 | 42 |
1671529 | 1671529 | 2021-08-31 | Washington | Kentucky | 21229 | 1911 | 42 |
1668282 | 1668282 | 2021-08-30 | Washington | Kentucky | 21229 | 1889 | 42 |
1665035 | 1665035 | 2021-08-29 | Washington | Kentucky | 21229 | 1863 | 42 |
1661787 | 1661787 | 2021-08-28 | Washington | Kentucky | 21229 | 1863 | 42 |
1658539 | 1658539 | 2021-08-27 | Washington | Kentucky | 21229 | 1863 | 42 |
1655291 | 1655291 | 2021-08-26 | Washington | Kentucky | 21229 | 1841 | 42 |
1652044 | 1652044 | 2021-08-25 | Washington | Kentucky | 21229 | 1830 | 42 |
1648795 | 1648795 | 2021-08-24 | Washington | Kentucky | 21229 | 1813 | 42 |
1645547 | 1645547 | 2021-08-23 | Washington | Kentucky | 21229 | 1798 | 42 |
1642298 | 1642298 | 2021-08-22 | Washington | Kentucky | 21229 | 1768 | 42 |
1639048 | 1639048 | 2021-08-21 | Washington | Kentucky | 21229 | 1768 | 42 |
1635798 | 1635798 | 2021-08-20 | Washington | Kentucky | 21229 | 1768 | 42 |
1632548 | 1632548 | 2021-08-19 | Washington | Kentucky | 21229 | 1754 | 41 |
1629301 | 1629301 | 2021-08-18 | Washington | Kentucky | 21229 | 1736 | 41 |
1626054 | 1626054 | 2021-08-17 | Washington | Kentucky | 21229 | 1724 | 41 |
1622807 | 1622807 | 2021-08-16 | Washington | Kentucky | 21229 | 1707 | 41 |
1619560 | 1619560 | 2021-08-15 | Washington | Kentucky | 21229 | 1681 | 41 |
1616312 | 1616312 | 2021-08-14 | Washington | Kentucky | 21229 | 1681 | 41 |
1613063 | 1613063 | 2021-08-13 | Washington | Kentucky | 21229 | 1681 | 41 |
1609815 | 1609815 | 2021-08-12 | Washington | Kentucky | 21229 | 1655 | 41 |
1606566 | 1606566 | 2021-08-11 | Washington | Kentucky | 21229 | 1647 | 41 |
1603317 | 1603317 | 2021-08-10 | Washington | Kentucky | 21229 | 1642 | 41 |
1600068 | 1600068 | 2021-08-09 | Washington | Kentucky | 21229 | 1642 | 41 |
1596820 | 1596820 | 2021-08-08 | Washington | Kentucky | 21229 | 1608 | 41 |
1593571 | 1593571 | 2021-08-07 | Washington | Kentucky | 21229 | 1608 | 41 |
1590322 | 1590322 | 2021-08-06 | Washington | Kentucky | 21229 | 1608 | 41 |
1587073 | 1587073 | 2021-08-05 | Washington | Kentucky | 21229 | 1598 | 41 |
1583823 | 1583823 | 2021-08-04 | Washington | Kentucky | 21229 | 1585 | 41 |
1580573 | 1580573 | 2021-08-03 | Washington | Kentucky | 21229 | 1575 | 41 |
1577324 | 1577324 | 2021-08-02 | Washington | Kentucky | 21229 | 1563 | 41 |
1574076 | 1574076 | 2021-08-01 | Washington | Kentucky | 21229 | 1548 | 41 |
1570828 | 1570828 | 2021-07-31 | Washington | Kentucky | 21229 | 1548 | 41 |
1567580 | 1567580 | 2021-07-30 | Washington | Kentucky | 21229 | 1548 | 41 |
1564332 | 1564332 | 2021-07-29 | Washington | Kentucky | 21229 | 1542 | 41 |
1561084 | 1561084 | 2021-07-28 | Washington | Kentucky | 21229 | 1534 | 41 |
1557837 | 1557837 | 2021-07-27 | Washington | Kentucky | 21229 | 1530 | 41 |
1554590 | 1554590 | 2021-07-26 | Washington | Kentucky | 21229 | 1524 | 41 |
1551343 | 1551343 | 2021-07-25 | Washington | Kentucky | 21229 | 1515 | 41 |
1548096 | 1548096 | 2021-07-24 | Washington | Kentucky | 21229 | 1515 | 41 |
1544849 | 1544849 | 2021-07-23 | Washington | Kentucky | 21229 | 1515 | 41 |
1541601 | 1541601 | 2021-07-22 | Washington | Kentucky | 21229 | 1507 | 41 |
1538354 | 1538354 | 2021-07-21 | Washington | Kentucky | 21229 | 1503 | 41 |
1535106 | 1535106 | 2021-07-20 | Washington | Kentucky | 21229 | 1493 | 41 |
1531859 | 1531859 | 2021-07-19 | Washington | Kentucky | 21229 | 1487 | 41 |
1528612 | 1528612 | 2021-07-18 | Washington | Kentucky | 21229 | 1476 | 41 |
1525365 | 1525365 | 2021-07-17 | Washington | Kentucky | 21229 | 1476 | 41 |
1522117 | 1522117 | 2021-07-16 | Washington | Kentucky | 21229 | 1476 | 41 |
1518869 | 1518869 | 2021-07-15 | Washington | Kentucky | 21229 | 1470 | 41 |
1515622 | 1515622 | 2021-07-14 | Washington | Kentucky | 21229 | 1465 | 41 |
1512376 | 1512376 | 2021-07-13 | Washington | Kentucky | 21229 | 1465 | 41 |
1509129 | 1509129 | 2021-07-12 | Washington | Kentucky | 21229 | 1464 | 41 |
1505883 | 1505883 | 2021-07-11 | Washington | Kentucky | 21229 | 1463 | 41 |
1502637 | 1502637 | 2021-07-10 | Washington | Kentucky | 21229 | 1463 | 41 |
1499391 | 1499391 | 2021-07-09 | Washington | Kentucky | 21229 | 1463 | 41 |
1496144 | 1496144 | 2021-07-08 | Washington | Kentucky | 21229 | 1460 | 41 |
1492898 | 1492898 | 2021-07-07 | Washington | Kentucky | 21229 | 1460 | 41 |
1489651 | 1489651 | 2021-07-06 | Washington | Kentucky | 21229 | 1461 | 41 |
1486404 | 1486404 | 2021-07-05 | Washington | Kentucky | 21229 | 1461 | 41 |
1483158 | 1483158 | 2021-07-04 | Washington | Kentucky | 21229 | 1461 | 41 |
1479911 | 1479911 | 2021-07-03 | Washington | Kentucky | 21229 | 1461 | 41 |
1476665 | 1476665 | 2021-07-02 | Washington | Kentucky | 21229 | 1461 | 41 |
1473419 | 1473419 | 2021-07-01 | Washington | Kentucky | 21229 | 1461 | 41 |
1470173 | 1470173 | 2021-06-30 | Washington | Kentucky | 21229 | 1462 | 41 |
1466928 | 1466928 | 2021-06-29 | Washington | Kentucky | 21229 | 1461 | 41 |
1463683 | 1463683 | 2021-06-28 | Washington | Kentucky | 21229 | 1461 | 41 |
1460438 | 1460438 | 2021-06-27 | Washington | Kentucky | 21229 | 1461 | 41 |
1457193 | 1457193 | 2021-06-26 | Washington | Kentucky | 21229 | 1461 | 41 |
1453948 | 1453948 | 2021-06-25 | Washington | Kentucky | 21229 | 1461 | 41 |
1450702 | 1450702 | 2021-06-24 | Washington | Kentucky | 21229 | 1461 | 41 |
1447457 | 1447457 | 2021-06-23 | Washington | Kentucky | 21229 | 1460 | 41 |
1444212 | 1444212 | 2021-06-22 | Washington | Kentucky | 21229 | 1459 | 41 |
1440967 | 1440967 | 2021-06-21 | Washington | Kentucky | 21229 | 1458 | 41 |
1437720 | 1437720 | 2021-06-20 | Washington | Kentucky | 21229 | 1458 | 41 |
1434473 | 1434473 | 2021-06-19 | Washington | Kentucky | 21229 | 1458 | 41 |
1431227 | 1431227 | 2021-06-18 | Washington | Kentucky | 21229 | 1458 | 41 |
1427982 | 1427982 | 2021-06-17 | Washington | Kentucky | 21229 | 1458 | 41 |
1424737 | 1424737 | 2021-06-16 | Washington | Kentucky | 21229 | 1458 | 41 |
1421489 | 1421489 | 2021-06-15 | Washington | Kentucky | 21229 | 1457 | 41 |
1418244 | 1418244 | 2021-06-14 | Washington | Kentucky | 21229 | 1456 | 41 |
1414998 | 1414998 | 2021-06-13 | Washington | Kentucky | 21229 | 1456 | 41 |
1411753 | 1411753 | 2021-06-12 | Washington | Kentucky | 21229 | 1455 | 41 |
1408508 | 1408508 | 2021-06-11 | Washington | Kentucky | 21229 | 1454 | 41 |
1405262 | 1405262 | 2021-06-10 | Washington | Kentucky | 21229 | 1454 | 41 |
1402017 | 1402017 | 2021-06-09 | Washington | Kentucky | 21229 | 1454 | 41 |
1398772 | 1398772 | 2021-06-08 | Washington | Kentucky | 21229 | 1454 | 41 |
1395525 | 1395525 | 2021-06-07 | Washington | Kentucky | 21229 | 1454 | 41 |
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);