ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 21021 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716904 | 1716904 | 2021-09-14 | Boyle | Kentucky | 21021 | 4725 | 80 |
1713658 | 1713658 | 2021-09-13 | Boyle | Kentucky | 21021 | 4686 | 80 |
1710411 | 1710411 | 2021-09-12 | Boyle | Kentucky | 21021 | 4615 | 80 |
1707164 | 1707164 | 2021-09-11 | Boyle | Kentucky | 21021 | 4615 | 80 |
1703916 | 1703916 | 2021-09-10 | Boyle | Kentucky | 21021 | 4615 | 80 |
1700666 | 1700666 | 2021-09-09 | Boyle | Kentucky | 21021 | 4566 | 80 |
1697417 | 1697417 | 2021-09-08 | Boyle | Kentucky | 21021 | 4523 | 80 |
1694169 | 1694169 | 2021-09-07 | Boyle | Kentucky | 21021 | 4494 | 80 |
1690920 | 1690920 | 2021-09-06 | Boyle | Kentucky | 21021 | 4396 | 80 |
1687670 | 1687670 | 2021-09-05 | Boyle | Kentucky | 21021 | 4396 | 80 |
1684420 | 1684420 | 2021-09-04 | Boyle | Kentucky | 21021 | 4396 | 80 |
1681169 | 1681169 | 2021-09-03 | Boyle | Kentucky | 21021 | 4396 | 80 |
1677921 | 1677921 | 2021-09-02 | Boyle | Kentucky | 21021 | 4344 | 80 |
1674674 | 1674674 | 2021-09-01 | Boyle | Kentucky | 21021 | 4331 | 80 |
1671425 | 1671425 | 2021-08-31 | Boyle | Kentucky | 21021 | 4288 | 80 |
1668178 | 1668178 | 2021-08-30 | Boyle | Kentucky | 21021 | 4230 | 80 |
1664931 | 1664931 | 2021-08-29 | Boyle | Kentucky | 21021 | 4127 | 80 |
1661683 | 1661683 | 2021-08-28 | Boyle | Kentucky | 21021 | 4127 | 80 |
1658435 | 1658435 | 2021-08-27 | Boyle | Kentucky | 21021 | 4127 | 80 |
1655187 | 1655187 | 2021-08-26 | Boyle | Kentucky | 21021 | 4089 | 80 |
1651940 | 1651940 | 2021-08-25 | Boyle | Kentucky | 21021 | 4050 | 80 |
1648691 | 1648691 | 2021-08-24 | Boyle | Kentucky | 21021 | 4025 | 80 |
1645443 | 1645443 | 2021-08-23 | Boyle | Kentucky | 21021 | 3998 | 80 |
1642194 | 1642194 | 2021-08-22 | Boyle | Kentucky | 21021 | 3926 | 80 |
1638944 | 1638944 | 2021-08-21 | Boyle | Kentucky | 21021 | 3926 | 80 |
1635694 | 1635694 | 2021-08-20 | Boyle | Kentucky | 21021 | 3926 | 80 |
1632444 | 1632444 | 2021-08-19 | Boyle | Kentucky | 21021 | 3894 | 80 |
1629197 | 1629197 | 2021-08-18 | Boyle | Kentucky | 21021 | 3872 | 80 |
1625950 | 1625950 | 2021-08-17 | Boyle | Kentucky | 21021 | 3860 | 80 |
1622703 | 1622703 | 2021-08-16 | Boyle | Kentucky | 21021 | 3849 | 80 |
1619456 | 1619456 | 2021-08-15 | Boyle | Kentucky | 21021 | 3814 | 80 |
1616208 | 1616208 | 2021-08-14 | Boyle | Kentucky | 21021 | 3814 | 80 |
1612959 | 1612959 | 2021-08-13 | Boyle | Kentucky | 21021 | 3814 | 80 |
1609711 | 1609711 | 2021-08-12 | Boyle | Kentucky | 21021 | 3792 | 80 |
1606462 | 1606462 | 2021-08-11 | Boyle | Kentucky | 21021 | 3776 | 80 |
1603213 | 1603213 | 2021-08-10 | Boyle | Kentucky | 21021 | 3761 | 80 |
1599964 | 1599964 | 2021-08-09 | Boyle | Kentucky | 21021 | 3750 | 80 |
1596716 | 1596716 | 2021-08-08 | Boyle | Kentucky | 21021 | 3719 | 80 |
1593467 | 1593467 | 2021-08-07 | Boyle | Kentucky | 21021 | 3719 | 80 |
1590218 | 1590218 | 2021-08-06 | Boyle | Kentucky | 21021 | 3719 | 80 |
1586969 | 1586969 | 2021-08-05 | Boyle | Kentucky | 21021 | 3708 | 80 |
1583719 | 1583719 | 2021-08-04 | Boyle | Kentucky | 21021 | 3681 | 79 |
1580469 | 1580469 | 2021-08-03 | Boyle | Kentucky | 21021 | 3658 | 78 |
1577220 | 1577220 | 2021-08-02 | Boyle | Kentucky | 21021 | 3643 | 78 |
1573972 | 1573972 | 2021-08-01 | Boyle | Kentucky | 21021 | 3604 | 78 |
1570724 | 1570724 | 2021-07-31 | Boyle | Kentucky | 21021 | 3604 | 78 |
1567476 | 1567476 | 2021-07-30 | Boyle | Kentucky | 21021 | 3604 | 78 |
1564228 | 1564228 | 2021-07-29 | Boyle | Kentucky | 21021 | 3601 | 78 |
1560980 | 1560980 | 2021-07-28 | Boyle | Kentucky | 21021 | 3590 | 78 |
1557733 | 1557733 | 2021-07-27 | Boyle | Kentucky | 21021 | 3582 | 78 |
1554486 | 1554486 | 2021-07-26 | Boyle | Kentucky | 21021 | 3579 | 78 |
1551239 | 1551239 | 2021-07-25 | Boyle | Kentucky | 21021 | 3567 | 78 |
1547992 | 1547992 | 2021-07-24 | Boyle | Kentucky | 21021 | 3567 | 78 |
1544745 | 1544745 | 2021-07-23 | Boyle | Kentucky | 21021 | 3567 | 78 |
1541497 | 1541497 | 2021-07-22 | Boyle | Kentucky | 21021 | 3562 | 78 |
1538250 | 1538250 | 2021-07-21 | Boyle | Kentucky | 21021 | 3551 | 78 |
1535002 | 1535002 | 2021-07-20 | Boyle | Kentucky | 21021 | 3545 | 78 |
1531755 | 1531755 | 2021-07-19 | Boyle | Kentucky | 21021 | 3544 | 78 |
1528508 | 1528508 | 2021-07-18 | Boyle | Kentucky | 21021 | 3537 | 78 |
1525261 | 1525261 | 2021-07-17 | Boyle | Kentucky | 21021 | 3537 | 78 |
1522013 | 1522013 | 2021-07-16 | Boyle | Kentucky | 21021 | 3537 | 78 |
1518765 | 1518765 | 2021-07-15 | Boyle | Kentucky | 21021 | 3535 | 78 |
1515518 | 1515518 | 2021-07-14 | Boyle | Kentucky | 21021 | 3531 | 78 |
1512272 | 1512272 | 2021-07-13 | Boyle | Kentucky | 21021 | 3524 | 78 |
1509025 | 1509025 | 2021-07-12 | Boyle | Kentucky | 21021 | 3522 | 78 |
1505779 | 1505779 | 2021-07-11 | Boyle | Kentucky | 21021 | 3513 | 78 |
1502533 | 1502533 | 2021-07-10 | Boyle | Kentucky | 21021 | 3513 | 78 |
1499287 | 1499287 | 2021-07-09 | Boyle | Kentucky | 21021 | 3513 | 78 |
1496040 | 1496040 | 2021-07-08 | Boyle | Kentucky | 21021 | 3512 | 78 |
1492794 | 1492794 | 2021-07-07 | Boyle | Kentucky | 21021 | 3511 | 78 |
1489547 | 1489547 | 2021-07-06 | Boyle | Kentucky | 21021 | 3511 | 78 |
1486300 | 1486300 | 2021-07-05 | Boyle | Kentucky | 21021 | 3509 | 78 |
1483054 | 1483054 | 2021-07-04 | Boyle | Kentucky | 21021 | 3509 | 78 |
1479807 | 1479807 | 2021-07-03 | Boyle | Kentucky | 21021 | 3509 | 78 |
1476561 | 1476561 | 2021-07-02 | Boyle | Kentucky | 21021 | 3509 | 78 |
1473315 | 1473315 | 2021-07-01 | Boyle | Kentucky | 21021 | 3509 | 78 |
1470069 | 1470069 | 2021-06-30 | Boyle | Kentucky | 21021 | 3508 | 78 |
1466824 | 1466824 | 2021-06-29 | Boyle | Kentucky | 21021 | 3507 | 78 |
1463579 | 1463579 | 2021-06-28 | Boyle | Kentucky | 21021 | 3508 | 78 |
1460334 | 1460334 | 2021-06-27 | Boyle | Kentucky | 21021 | 3502 | 78 |
1457089 | 1457089 | 2021-06-26 | Boyle | Kentucky | 21021 | 3502 | 78 |
1453844 | 1453844 | 2021-06-25 | Boyle | Kentucky | 21021 | 3502 | 78 |
1450598 | 1450598 | 2021-06-24 | Boyle | Kentucky | 21021 | 3500 | 78 |
1447353 | 1447353 | 2021-06-23 | Boyle | Kentucky | 21021 | 3500 | 78 |
1444108 | 1444108 | 2021-06-22 | Boyle | Kentucky | 21021 | 3499 | 78 |
1440863 | 1440863 | 2021-06-21 | Boyle | Kentucky | 21021 | 3497 | 78 |
1437616 | 1437616 | 2021-06-20 | Boyle | Kentucky | 21021 | 3492 | 78 |
1434369 | 1434369 | 2021-06-19 | Boyle | Kentucky | 21021 | 3492 | 78 |
1431123 | 1431123 | 2021-06-18 | Boyle | Kentucky | 21021 | 3492 | 78 |
1427878 | 1427878 | 2021-06-17 | Boyle | Kentucky | 21021 | 3489 | 78 |
1424633 | 1424633 | 2021-06-16 | Boyle | Kentucky | 21021 | 3484 | 78 |
1421385 | 1421385 | 2021-06-15 | Boyle | Kentucky | 21021 | 3480 | 78 |
1418140 | 1418140 | 2021-06-14 | Boyle | Kentucky | 21021 | 3480 | 78 |
1414894 | 1414894 | 2021-06-13 | Boyle | Kentucky | 21021 | 3478 | 78 |
1411649 | 1411649 | 2021-06-12 | Boyle | Kentucky | 21021 | 3477 | 78 |
1408404 | 1408404 | 2021-06-11 | Boyle | Kentucky | 21021 | 3475 | 78 |
1405158 | 1405158 | 2021-06-10 | Boyle | Kentucky | 21021 | 3476 | 78 |
1401913 | 1401913 | 2021-06-09 | Boyle | Kentucky | 21021 | 3475 | 77 |
1398668 | 1398668 | 2021-06-08 | Boyle | Kentucky | 21021 | 3474 | 76 |
1395421 | 1395421 | 2021-06-07 | Boyle | Kentucky | 21021 | 3474 | 76 |
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);