ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 21009 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1814372 | 1814372 | 2021-10-14 | Barren | Kentucky | 21009 | 7796 | 132 |
1811123 | 1811123 | 2021-10-13 | Barren | Kentucky | 21009 | 7775 | 131 |
1807874 | 1807874 | 2021-10-12 | Barren | Kentucky | 21009 | 7760 | 131 |
1804623 | 1804623 | 2021-10-11 | Barren | Kentucky | 21009 | 7743 | 131 |
1801374 | 1801374 | 2021-10-10 | Barren | Kentucky | 21009 | 7721 | 127 |
1798125 | 1798125 | 2021-10-09 | Barren | Kentucky | 21009 | 7721 | 127 |
1794876 | 1794876 | 2021-10-08 | Barren | Kentucky | 21009 | 7721 | 127 |
1791628 | 1791628 | 2021-10-07 | Barren | Kentucky | 21009 | 7706 | 127 |
1788379 | 1788379 | 2021-10-06 | Barren | Kentucky | 21009 | 7692 | 124 |
1785130 | 1785130 | 2021-10-05 | Barren | Kentucky | 21009 | 7685 | 120 |
1781881 | 1781881 | 2021-10-04 | Barren | Kentucky | 21009 | 7658 | 120 |
1778631 | 1778631 | 2021-10-03 | Barren | Kentucky | 21009 | 7619 | 120 |
1775381 | 1775381 | 2021-10-02 | Barren | Kentucky | 21009 | 7619 | 120 |
1772131 | 1772131 | 2021-10-01 | Barren | Kentucky | 21009 | 7619 | 120 |
1768882 | 1768882 | 2021-09-30 | Barren | Kentucky | 21009 | 7598 | 120 |
1765633 | 1765633 | 2021-09-29 | Barren | Kentucky | 21009 | 7571 | 120 |
1762384 | 1762384 | 2021-09-28 | Barren | Kentucky | 21009 | 7549 | 118 |
1759136 | 1759136 | 2021-09-27 | Barren | Kentucky | 21009 | 7514 | 118 |
1755888 | 1755888 | 2021-09-26 | Barren | Kentucky | 21009 | 7428 | 117 |
1752640 | 1752640 | 2021-09-25 | Barren | Kentucky | 21009 | 7428 | 117 |
1749391 | 1749391 | 2021-09-24 | Barren | Kentucky | 21009 | 7428 | 117 |
1746141 | 1746141 | 2021-09-23 | Barren | Kentucky | 21009 | 7368 | 117 |
1742892 | 1742892 | 2021-09-22 | Barren | Kentucky | 21009 | 7258 | 117 |
1739643 | 1739643 | 2021-09-21 | Barren | Kentucky | 21009 | 7200 | 117 |
1736394 | 1736394 | 2021-09-20 | Barren | Kentucky | 21009 | 7144 | 117 |
1733144 | 1733144 | 2021-09-19 | Barren | Kentucky | 21009 | 6961 | 116 |
1729894 | 1729894 | 2021-09-18 | Barren | Kentucky | 21009 | 6961 | 116 |
1726644 | 1726644 | 2021-09-17 | Barren | Kentucky | 21009 | 6961 | 116 |
1723395 | 1723395 | 2021-09-16 | Barren | Kentucky | 21009 | 6856 | 116 |
1720146 | 1720146 | 2021-09-15 | Barren | Kentucky | 21009 | 6770 | 112 |
1716898 | 1716898 | 2021-09-14 | Barren | Kentucky | 21009 | 6684 | 111 |
1713652 | 1713652 | 2021-09-13 | Barren | Kentucky | 21009 | 6636 | 111 |
1710405 | 1710405 | 2021-09-12 | Barren | Kentucky | 21009 | 6503 | 111 |
1707158 | 1707158 | 2021-09-11 | Barren | Kentucky | 21009 | 6503 | 111 |
1703910 | 1703910 | 2021-09-10 | Barren | Kentucky | 21009 | 6503 | 111 |
1700660 | 1700660 | 2021-09-09 | Barren | Kentucky | 21009 | 6452 | 110 |
1697411 | 1697411 | 2021-09-08 | Barren | Kentucky | 21009 | 6360 | 110 |
1694163 | 1694163 | 2021-09-07 | Barren | Kentucky | 21009 | 6283 | 109 |
1690914 | 1690914 | 2021-09-06 | Barren | Kentucky | 21009 | 6059 | 109 |
1687664 | 1687664 | 2021-09-05 | Barren | Kentucky | 21009 | 6059 | 109 |
1684414 | 1684414 | 2021-09-04 | Barren | Kentucky | 21009 | 6059 | 109 |
1681163 | 1681163 | 2021-09-03 | Barren | Kentucky | 21009 | 6059 | 109 |
1677915 | 1677915 | 2021-09-02 | Barren | Kentucky | 21009 | 5992 | 109 |
1674668 | 1674668 | 2021-09-01 | Barren | Kentucky | 21009 | 5923 | 109 |
1671419 | 1671419 | 2021-08-31 | Barren | Kentucky | 21009 | 5863 | 109 |
1668172 | 1668172 | 2021-08-30 | Barren | Kentucky | 21009 | 5801 | 109 |
1664925 | 1664925 | 2021-08-29 | Barren | Kentucky | 21009 | 5647 | 109 |
1661677 | 1661677 | 2021-08-28 | Barren | Kentucky | 21009 | 5647 | 109 |
1658429 | 1658429 | 2021-08-27 | Barren | Kentucky | 21009 | 5647 | 109 |
1655181 | 1655181 | 2021-08-26 | Barren | Kentucky | 21009 | 5603 | 109 |
1651934 | 1651934 | 2021-08-25 | Barren | Kentucky | 21009 | 5563 | 109 |
1648685 | 1648685 | 2021-08-24 | Barren | Kentucky | 21009 | 5532 | 109 |
1645437 | 1645437 | 2021-08-23 | Barren | Kentucky | 21009 | 5476 | 108 |
1642188 | 1642188 | 2021-08-22 | Barren | Kentucky | 21009 | 5376 | 108 |
1638938 | 1638938 | 2021-08-21 | Barren | Kentucky | 21009 | 5376 | 108 |
1635688 | 1635688 | 2021-08-20 | Barren | Kentucky | 21009 | 5376 | 108 |
1632438 | 1632438 | 2021-08-19 | Barren | Kentucky | 21009 | 5336 | 108 |
1629191 | 1629191 | 2021-08-18 | Barren | Kentucky | 21009 | 5287 | 108 |
1625944 | 1625944 | 2021-08-17 | Barren | Kentucky | 21009 | 5256 | 108 |
1622697 | 1622697 | 2021-08-16 | Barren | Kentucky | 21009 | 5211 | 108 |
1619450 | 1619450 | 2021-08-15 | Barren | Kentucky | 21009 | 5147 | 108 |
1616202 | 1616202 | 2021-08-14 | Barren | Kentucky | 21009 | 5147 | 108 |
1612953 | 1612953 | 2021-08-13 | Barren | Kentucky | 21009 | 5147 | 108 |
1609705 | 1609705 | 2021-08-12 | Barren | Kentucky | 21009 | 5092 | 107 |
1606456 | 1606456 | 2021-08-11 | Barren | Kentucky | 21009 | 5070 | 106 |
1603207 | 1603207 | 2021-08-10 | Barren | Kentucky | 21009 | 5040 | 106 |
1599958 | 1599958 | 2021-08-09 | Barren | Kentucky | 21009 | 5013 | 106 |
1596710 | 1596710 | 2021-08-08 | Barren | Kentucky | 21009 | 4941 | 106 |
1593461 | 1593461 | 2021-08-07 | Barren | Kentucky | 21009 | 4941 | 106 |
1590212 | 1590212 | 2021-08-06 | Barren | Kentucky | 21009 | 4941 | 106 |
1586963 | 1586963 | 2021-08-05 | Barren | Kentucky | 21009 | 4904 | 105 |
1583713 | 1583713 | 2021-08-04 | Barren | Kentucky | 21009 | 4880 | 105 |
1580463 | 1580463 | 2021-08-03 | Barren | Kentucky | 21009 | 4830 | 105 |
1577214 | 1577214 | 2021-08-02 | Barren | Kentucky | 21009 | 4804 | 105 |
1573966 | 1573966 | 2021-08-01 | Barren | Kentucky | 21009 | 4755 | 105 |
1570718 | 1570718 | 2021-07-31 | Barren | Kentucky | 21009 | 4755 | 105 |
1567470 | 1567470 | 2021-07-30 | Barren | Kentucky | 21009 | 4755 | 105 |
1564222 | 1564222 | 2021-07-29 | Barren | Kentucky | 21009 | 4736 | 105 |
1560974 | 1560974 | 2021-07-28 | Barren | Kentucky | 21009 | 4714 | 104 |
1557727 | 1557727 | 2021-07-27 | Barren | Kentucky | 21009 | 4696 | 104 |
1554480 | 1554480 | 2021-07-26 | Barren | Kentucky | 21009 | 4680 | 104 |
1551233 | 1551233 | 2021-07-25 | Barren | Kentucky | 21009 | 4651 | 104 |
1547986 | 1547986 | 2021-07-24 | Barren | Kentucky | 21009 | 4651 | 104 |
1544739 | 1544739 | 2021-07-23 | Barren | Kentucky | 21009 | 4651 | 104 |
1541491 | 1541491 | 2021-07-22 | Barren | Kentucky | 21009 | 4645 | 104 |
1538244 | 1538244 | 2021-07-21 | Barren | Kentucky | 21009 | 4621 | 104 |
1534996 | 1534996 | 2021-07-20 | Barren | Kentucky | 21009 | 4604 | 104 |
1531749 | 1531749 | 2021-07-19 | Barren | Kentucky | 21009 | 4585 | 104 |
1528502 | 1528502 | 2021-07-18 | Barren | Kentucky | 21009 | 4563 | 104 |
1525255 | 1525255 | 2021-07-17 | Barren | Kentucky | 21009 | 4563 | 104 |
1522007 | 1522007 | 2021-07-16 | Barren | Kentucky | 21009 | 4563 | 104 |
1518759 | 1518759 | 2021-07-15 | Barren | Kentucky | 21009 | 4556 | 104 |
1515512 | 1515512 | 2021-07-14 | Barren | Kentucky | 21009 | 4551 | 104 |
1512266 | 1512266 | 2021-07-13 | Barren | Kentucky | 21009 | 4543 | 104 |
1509019 | 1509019 | 2021-07-12 | Barren | Kentucky | 21009 | 4538 | 104 |
1505773 | 1505773 | 2021-07-11 | Barren | Kentucky | 21009 | 4522 | 104 |
1502527 | 1502527 | 2021-07-10 | Barren | Kentucky | 21009 | 4522 | 104 |
1499281 | 1499281 | 2021-07-09 | Barren | Kentucky | 21009 | 4522 | 104 |
1496034 | 1496034 | 2021-07-08 | Barren | Kentucky | 21009 | 4520 | 104 |
1492788 | 1492788 | 2021-07-07 | Barren | Kentucky | 21009 | 4519 | 104 |
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);