ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716966 | 1716966 | 2021-09-14 | Madison | Kentucky | 21151 | 13131 | 124 |
1713720 | 1713720 | 2021-09-13 | Madison | Kentucky | 21151 | 12982 | 124 |
1710473 | 1710473 | 2021-09-12 | Madison | Kentucky | 21151 | 12733 | 121 |
1707226 | 1707226 | 2021-09-11 | Madison | Kentucky | 21151 | 12733 | 121 |
1703978 | 1703978 | 2021-09-10 | Madison | Kentucky | 21151 | 12733 | 121 |
1700728 | 1700728 | 2021-09-09 | Madison | Kentucky | 21151 | 12614 | 121 |
1697479 | 1697479 | 2021-09-08 | Madison | Kentucky | 21151 | 12488 | 119 |
1694231 | 1694231 | 2021-09-07 | Madison | Kentucky | 21151 | 12389 | 119 |
1690982 | 1690982 | 2021-09-06 | Madison | Kentucky | 21151 | 12120 | 118 |
1687732 | 1687732 | 2021-09-05 | Madison | Kentucky | 21151 | 12120 | 118 |
1684482 | 1684482 | 2021-09-04 | Madison | Kentucky | 21151 | 12120 | 118 |
1681231 | 1681231 | 2021-09-03 | Madison | Kentucky | 21151 | 12120 | 118 |
1677983 | 1677983 | 2021-09-02 | Madison | Kentucky | 21151 | 11994 | 118 |
1674736 | 1674736 | 2021-09-01 | Madison | Kentucky | 21151 | 11822 | 117 |
1671487 | 1671487 | 2021-08-31 | Madison | Kentucky | 21151 | 11744 | 117 |
1668240 | 1668240 | 2021-08-30 | Madison | Kentucky | 21151 | 11627 | 116 |
1664993 | 1664993 | 2021-08-29 | Madison | Kentucky | 21151 | 11456 | 116 |
1661745 | 1661745 | 2021-08-28 | Madison | Kentucky | 21151 | 11456 | 116 |
1658497 | 1658497 | 2021-08-27 | Madison | Kentucky | 21151 | 11456 | 116 |
1655249 | 1655249 | 2021-08-26 | Madison | Kentucky | 21151 | 11365 | 115 |
1652002 | 1652002 | 2021-08-25 | Madison | Kentucky | 21151 | 11253 | 115 |
1648753 | 1648753 | 2021-08-24 | Madison | Kentucky | 21151 | 11140 | 115 |
1645505 | 1645505 | 2021-08-23 | Madison | Kentucky | 21151 | 11058 | 115 |
1642256 | 1642256 | 2021-08-22 | Madison | Kentucky | 21151 | 10928 | 113 |
1639006 | 1639006 | 2021-08-21 | Madison | Kentucky | 21151 | 10928 | 113 |
1635756 | 1635756 | 2021-08-20 | Madison | Kentucky | 21151 | 10928 | 113 |
1632506 | 1632506 | 2021-08-19 | Madison | Kentucky | 21151 | 10866 | 113 |
1629259 | 1629259 | 2021-08-18 | Madison | Kentucky | 21151 | 10732 | 113 |
1626012 | 1626012 | 2021-08-17 | Madison | Kentucky | 21151 | 10661 | 113 |
1622765 | 1622765 | 2021-08-16 | Madison | Kentucky | 21151 | 10595 | 113 |
1619518 | 1619518 | 2021-08-15 | Madison | Kentucky | 21151 | 10511 | 113 |
1616270 | 1616270 | 2021-08-14 | Madison | Kentucky | 21151 | 10511 | 113 |
1613021 | 1613021 | 2021-08-13 | Madison | Kentucky | 21151 | 10511 | 113 |
1609773 | 1609773 | 2021-08-12 | Madison | Kentucky | 21151 | 10427 | 113 |
1606524 | 1606524 | 2021-08-11 | Madison | Kentucky | 21151 | 10348 | 113 |
1603275 | 1603275 | 2021-08-10 | Madison | Kentucky | 21151 | 10304 | 113 |
1600026 | 1600026 | 2021-08-09 | Madison | Kentucky | 21151 | 10243 | 113 |
1596778 | 1596778 | 2021-08-08 | Madison | Kentucky | 21151 | 10164 | 113 |
1593529 | 1593529 | 2021-08-07 | Madison | Kentucky | 21151 | 10164 | 113 |
1590280 | 1590280 | 2021-08-06 | Madison | Kentucky | 21151 | 10164 | 113 |
1587031 | 1587031 | 2021-08-05 | Madison | Kentucky | 21151 | 10129 | 113 |
1583781 | 1583781 | 2021-08-04 | Madison | Kentucky | 21151 | 10092 | 113 |
1580531 | 1580531 | 2021-08-03 | Madison | Kentucky | 21151 | 10027 | 113 |
1577282 | 1577282 | 2021-08-02 | Madison | Kentucky | 21151 | 9999 | 113 |
1574034 | 1574034 | 2021-08-01 | Madison | Kentucky | 21151 | 9960 | 113 |
1570786 | 1570786 | 2021-07-31 | Madison | Kentucky | 21151 | 9960 | 113 |
1567538 | 1567538 | 2021-07-30 | Madison | Kentucky | 21151 | 9960 | 113 |
1564290 | 1564290 | 2021-07-29 | Madison | Kentucky | 21151 | 9920 | 113 |
1561042 | 1561042 | 2021-07-28 | Madison | Kentucky | 21151 | 9890 | 113 |
1557795 | 1557795 | 2021-07-27 | Madison | Kentucky | 21151 | 9870 | 113 |
1554548 | 1554548 | 2021-07-26 | Madison | Kentucky | 21151 | 9820 | 113 |
1551301 | 1551301 | 2021-07-25 | Madison | Kentucky | 21151 | 9784 | 113 |
1548054 | 1548054 | 2021-07-24 | Madison | Kentucky | 21151 | 9784 | 113 |
1544807 | 1544807 | 2021-07-23 | Madison | Kentucky | 21151 | 9784 | 113 |
1541559 | 1541559 | 2021-07-22 | Madison | Kentucky | 21151 | 9760 | 113 |
1538312 | 1538312 | 2021-07-21 | Madison | Kentucky | 21151 | 9733 | 113 |
1535064 | 1535064 | 2021-07-20 | Madison | Kentucky | 21151 | 9728 | 113 |
1531817 | 1531817 | 2021-07-19 | Madison | Kentucky | 21151 | 9693 | 113 |
1528570 | 1528570 | 2021-07-18 | Madison | Kentucky | 21151 | 9680 | 112 |
1525323 | 1525323 | 2021-07-17 | Madison | Kentucky | 21151 | 9680 | 112 |
1522075 | 1522075 | 2021-07-16 | Madison | Kentucky | 21151 | 9680 | 112 |
1518827 | 1518827 | 2021-07-15 | Madison | Kentucky | 21151 | 9659 | 112 |
1515580 | 1515580 | 2021-07-14 | Madison | Kentucky | 21151 | 9650 | 112 |
1512334 | 1512334 | 2021-07-13 | Madison | Kentucky | 21151 | 9639 | 112 |
1509087 | 1509087 | 2021-07-12 | Madison | Kentucky | 21151 | 9632 | 112 |
1505841 | 1505841 | 2021-07-11 | Madison | Kentucky | 21151 | 9615 | 112 |
1502595 | 1502595 | 2021-07-10 | Madison | Kentucky | 21151 | 9615 | 112 |
1499349 | 1499349 | 2021-07-09 | Madison | Kentucky | 21151 | 9615 | 112 |
1496102 | 1496102 | 2021-07-08 | Madison | Kentucky | 21151 | 9607 | 112 |
1492856 | 1492856 | 2021-07-07 | Madison | Kentucky | 21151 | 9602 | 112 |
1489609 | 1489609 | 2021-07-06 | Madison | Kentucky | 21151 | 9595 | 112 |
1486362 | 1486362 | 2021-07-05 | Madison | Kentucky | 21151 | 9594 | 112 |
1483116 | 1483116 | 2021-07-04 | Madison | Kentucky | 21151 | 9594 | 112 |
1479869 | 1479869 | 2021-07-03 | Madison | Kentucky | 21151 | 9594 | 112 |
1476623 | 1476623 | 2021-07-02 | Madison | Kentucky | 21151 | 9594 | 112 |
1473377 | 1473377 | 2021-07-01 | Madison | Kentucky | 21151 | 9590 | 112 |
1470131 | 1470131 | 2021-06-30 | Madison | Kentucky | 21151 | 9582 | 112 |
1466886 | 1466886 | 2021-06-29 | Madison | Kentucky | 21151 | 9575 | 112 |
1463641 | 1463641 | 2021-06-28 | Madison | Kentucky | 21151 | 9563 | 112 |
1460396 | 1460396 | 2021-06-27 | Madison | Kentucky | 21151 | 9560 | 112 |
1457151 | 1457151 | 2021-06-26 | Madison | Kentucky | 21151 | 9560 | 112 |
1453906 | 1453906 | 2021-06-25 | Madison | Kentucky | 21151 | 9560 | 112 |
1450660 | 1450660 | 2021-06-24 | Madison | Kentucky | 21151 | 9555 | 112 |
1447415 | 1447415 | 2021-06-23 | Madison | Kentucky | 21151 | 9553 | 112 |
1444170 | 1444170 | 2021-06-22 | Madison | Kentucky | 21151 | 9553 | 112 |
1440925 | 1440925 | 2021-06-21 | Madison | Kentucky | 21151 | 9548 | 112 |
1437678 | 1437678 | 2021-06-20 | Madison | Kentucky | 21151 | 9537 | 112 |
1434431 | 1434431 | 2021-06-19 | Madison | Kentucky | 21151 | 9537 | 112 |
1431185 | 1431185 | 2021-06-18 | Madison | Kentucky | 21151 | 9537 | 112 |
1427940 | 1427940 | 2021-06-17 | Madison | Kentucky | 21151 | 9535 | 112 |
1424695 | 1424695 | 2021-06-16 | Madison | Kentucky | 21151 | 9530 | 112 |
1421447 | 1421447 | 2021-06-15 | Madison | Kentucky | 21151 | 9529 | 111 |
1418202 | 1418202 | 2021-06-14 | Madison | Kentucky | 21151 | 9523 | 111 |
1414956 | 1414956 | 2021-06-13 | Madison | Kentucky | 21151 | 9522 | 111 |
1411711 | 1411711 | 2021-06-12 | Madison | Kentucky | 21151 | 9522 | 111 |
1408466 | 1408466 | 2021-06-11 | Madison | Kentucky | 21151 | 9519 | 111 |
1405220 | 1405220 | 2021-06-10 | Madison | Kentucky | 21151 | 9516 | 111 |
1401975 | 1401975 | 2021-06-09 | Madison | Kentucky | 21151 | 9505 | 111 |
1398730 | 1398730 | 2021-06-08 | Madison | Kentucky | 21151 | 9497 | 111 |
1395483 | 1395483 | 2021-06-07 | Madison | Kentucky | 21151 | 9475 | 111 |
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);