ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Mercer" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716977 | 1716977 | 2021-09-14 | Mercer | Kentucky | 21167 | 3785 | 59 |
1713731 | 1713731 | 2021-09-13 | Mercer | Kentucky | 21167 | 3766 | 59 |
1710484 | 1710484 | 2021-09-12 | Mercer | Kentucky | 21167 | 3674 | 57 |
1707237 | 1707237 | 2021-09-11 | Mercer | Kentucky | 21167 | 3674 | 57 |
1703989 | 1703989 | 2021-09-10 | Mercer | Kentucky | 21167 | 3674 | 57 |
1700739 | 1700739 | 2021-09-09 | Mercer | Kentucky | 21167 | 3643 | 57 |
1697490 | 1697490 | 2021-09-08 | Mercer | Kentucky | 21167 | 3602 | 57 |
1694242 | 1694242 | 2021-09-07 | Mercer | Kentucky | 21167 | 3542 | 57 |
1690993 | 1690993 | 2021-09-06 | Mercer | Kentucky | 21167 | 3489 | 57 |
1687743 | 1687743 | 2021-09-05 | Mercer | Kentucky | 21167 | 3489 | 57 |
1684493 | 1684493 | 2021-09-04 | Mercer | Kentucky | 21167 | 3489 | 57 |
1681242 | 1681242 | 2021-09-03 | Mercer | Kentucky | 21167 | 3489 | 57 |
1677994 | 1677994 | 2021-09-02 | Mercer | Kentucky | 21167 | 3424 | 57 |
1674747 | 1674747 | 2021-09-01 | Mercer | Kentucky | 21167 | 3394 | 57 |
1671498 | 1671498 | 2021-08-31 | Mercer | Kentucky | 21167 | 3365 | 57 |
1668251 | 1668251 | 2021-08-30 | Mercer | Kentucky | 21167 | 3310 | 57 |
1665004 | 1665004 | 2021-08-29 | Mercer | Kentucky | 21167 | 3244 | 56 |
1661756 | 1661756 | 2021-08-28 | Mercer | Kentucky | 21167 | 3244 | 56 |
1658508 | 1658508 | 2021-08-27 | Mercer | Kentucky | 21167 | 3244 | 56 |
1655260 | 1655260 | 2021-08-26 | Mercer | Kentucky | 21167 | 3202 | 56 |
1652013 | 1652013 | 2021-08-25 | Mercer | Kentucky | 21167 | 3173 | 56 |
1648764 | 1648764 | 2021-08-24 | Mercer | Kentucky | 21167 | 3150 | 54 |
1645516 | 1645516 | 2021-08-23 | Mercer | Kentucky | 21167 | 3089 | 54 |
1642267 | 1642267 | 2021-08-22 | Mercer | Kentucky | 21167 | 3067 | 53 |
1639017 | 1639017 | 2021-08-21 | Mercer | Kentucky | 21167 | 3067 | 53 |
1635767 | 1635767 | 2021-08-20 | Mercer | Kentucky | 21167 | 3067 | 53 |
1632517 | 1632517 | 2021-08-19 | Mercer | Kentucky | 21167 | 3038 | 52 |
1629270 | 1629270 | 2021-08-18 | Mercer | Kentucky | 21167 | 3003 | 52 |
1626023 | 1626023 | 2021-08-17 | Mercer | Kentucky | 21167 | 2974 | 52 |
1622776 | 1622776 | 2021-08-16 | Mercer | Kentucky | 21167 | 2954 | 52 |
1619529 | 1619529 | 2021-08-15 | Mercer | Kentucky | 21167 | 2906 | 52 |
1616281 | 1616281 | 2021-08-14 | Mercer | Kentucky | 21167 | 2906 | 52 |
1613032 | 1613032 | 2021-08-13 | Mercer | Kentucky | 21167 | 2906 | 52 |
1609784 | 1609784 | 2021-08-12 | Mercer | Kentucky | 21167 | 2883 | 52 |
1606535 | 1606535 | 2021-08-11 | Mercer | Kentucky | 21167 | 2857 | 52 |
1603286 | 1603286 | 2021-08-10 | Mercer | Kentucky | 21167 | 2840 | 52 |
1600037 | 1600037 | 2021-08-09 | Mercer | Kentucky | 21167 | 2831 | 52 |
1596789 | 1596789 | 2021-08-08 | Mercer | Kentucky | 21167 | 2797 | 52 |
1593540 | 1593540 | 2021-08-07 | Mercer | Kentucky | 21167 | 2797 | 52 |
1590291 | 1590291 | 2021-08-06 | Mercer | Kentucky | 21167 | 2797 | 52 |
1587042 | 1587042 | 2021-08-05 | Mercer | Kentucky | 21167 | 2782 | 52 |
1583792 | 1583792 | 2021-08-04 | Mercer | Kentucky | 21167 | 2765 | 53 |
1580542 | 1580542 | 2021-08-03 | Mercer | Kentucky | 21167 | 2753 | 54 |
1577293 | 1577293 | 2021-08-02 | Mercer | Kentucky | 21167 | 2739 | 54 |
1574045 | 1574045 | 2021-08-01 | Mercer | Kentucky | 21167 | 2717 | 54 |
1570797 | 1570797 | 2021-07-31 | Mercer | Kentucky | 21167 | 2717 | 54 |
1567549 | 1567549 | 2021-07-30 | Mercer | Kentucky | 21167 | 2717 | 54 |
1564301 | 1564301 | 2021-07-29 | Mercer | Kentucky | 21167 | 2715 | 54 |
1561053 | 1561053 | 2021-07-28 | Mercer | Kentucky | 21167 | 2710 | 54 |
1557806 | 1557806 | 2021-07-27 | Mercer | Kentucky | 21167 | 2702 | 54 |
1554559 | 1554559 | 2021-07-26 | Mercer | Kentucky | 21167 | 2701 | 54 |
1551312 | 1551312 | 2021-07-25 | Mercer | Kentucky | 21167 | 2687 | 54 |
1548065 | 1548065 | 2021-07-24 | Mercer | Kentucky | 21167 | 2687 | 54 |
1544818 | 1544818 | 2021-07-23 | Mercer | Kentucky | 21167 | 2687 | 54 |
1541570 | 1541570 | 2021-07-22 | Mercer | Kentucky | 21167 | 2684 | 54 |
1538323 | 1538323 | 2021-07-21 | Mercer | Kentucky | 21167 | 2682 | 54 |
1535075 | 1535075 | 2021-07-20 | Mercer | Kentucky | 21167 | 2669 | 54 |
1531828 | 1531828 | 2021-07-19 | Mercer | Kentucky | 21167 | 2663 | 54 |
1528581 | 1528581 | 2021-07-18 | Mercer | Kentucky | 21167 | 2660 | 54 |
1525334 | 1525334 | 2021-07-17 | Mercer | Kentucky | 21167 | 2660 | 54 |
1522086 | 1522086 | 2021-07-16 | Mercer | Kentucky | 21167 | 2660 | 54 |
1518838 | 1518838 | 2021-07-15 | Mercer | Kentucky | 21167 | 2658 | 54 |
1515591 | 1515591 | 2021-07-14 | Mercer | Kentucky | 21167 | 2657 | 54 |
1512345 | 1512345 | 2021-07-13 | Mercer | Kentucky | 21167 | 2653 | 54 |
1509098 | 1509098 | 2021-07-12 | Mercer | Kentucky | 21167 | 2653 | 54 |
1505852 | 1505852 | 2021-07-11 | Mercer | Kentucky | 21167 | 2644 | 54 |
1502606 | 1502606 | 2021-07-10 | Mercer | Kentucky | 21167 | 2644 | 54 |
1499360 | 1499360 | 2021-07-09 | Mercer | Kentucky | 21167 | 2644 | 54 |
1496113 | 1496113 | 2021-07-08 | Mercer | Kentucky | 21167 | 2644 | 54 |
1492867 | 1492867 | 2021-07-07 | Mercer | Kentucky | 21167 | 2641 | 54 |
1489620 | 1489620 | 2021-07-06 | Mercer | Kentucky | 21167 | 2640 | 54 |
1486373 | 1486373 | 2021-07-05 | Mercer | Kentucky | 21167 | 2639 | 54 |
1483127 | 1483127 | 2021-07-04 | Mercer | Kentucky | 21167 | 2639 | 54 |
1479880 | 1479880 | 2021-07-03 | Mercer | Kentucky | 21167 | 2639 | 54 |
1476634 | 1476634 | 2021-07-02 | Mercer | Kentucky | 21167 | 2639 | 54 |
1473388 | 1473388 | 2021-07-01 | Mercer | Kentucky | 21167 | 2637 | 54 |
1470142 | 1470142 | 2021-06-30 | Mercer | Kentucky | 21167 | 2635 | 54 |
1466897 | 1466897 | 2021-06-29 | Mercer | Kentucky | 21167 | 2635 | 54 |
1463652 | 1463652 | 2021-06-28 | Mercer | Kentucky | 21167 | 2634 | 54 |
1460407 | 1460407 | 2021-06-27 | Mercer | Kentucky | 21167 | 2633 | 54 |
1457162 | 1457162 | 2021-06-26 | Mercer | Kentucky | 21167 | 2633 | 54 |
1453917 | 1453917 | 2021-06-25 | Mercer | Kentucky | 21167 | 2633 | 54 |
1450671 | 1450671 | 2021-06-24 | Mercer | Kentucky | 21167 | 2634 | 54 |
1447426 | 1447426 | 2021-06-23 | Mercer | Kentucky | 21167 | 2636 | 54 |
1444181 | 1444181 | 2021-06-22 | Mercer | Kentucky | 21167 | 2636 | 54 |
1440936 | 1440936 | 2021-06-21 | Mercer | Kentucky | 21167 | 2637 | 54 |
1437689 | 1437689 | 2021-06-20 | Mercer | Kentucky | 21167 | 2636 | 54 |
1434442 | 1434442 | 2021-06-19 | Mercer | Kentucky | 21167 | 2636 | 54 |
1431196 | 1431196 | 2021-06-18 | Mercer | Kentucky | 21167 | 2636 | 54 |
1427951 | 1427951 | 2021-06-17 | Mercer | Kentucky | 21167 | 2636 | 54 |
1424706 | 1424706 | 2021-06-16 | Mercer | Kentucky | 21167 | 2635 | 54 |
1421458 | 1421458 | 2021-06-15 | Mercer | Kentucky | 21167 | 2633 | 54 |
1418213 | 1418213 | 2021-06-14 | Mercer | Kentucky | 21167 | 2631 | 54 |
1414967 | 1414967 | 2021-06-13 | Mercer | Kentucky | 21167 | 2630 | 54 |
1411722 | 1411722 | 2021-06-12 | Mercer | Kentucky | 21167 | 2630 | 54 |
1408477 | 1408477 | 2021-06-11 | Mercer | Kentucky | 21167 | 2630 | 54 |
1405231 | 1405231 | 2021-06-10 | Mercer | Kentucky | 21167 | 2630 | 54 |
1401986 | 1401986 | 2021-06-09 | Mercer | Kentucky | 21167 | 2625 | 54 |
1398741 | 1398741 | 2021-06-08 | Mercer | Kentucky | 21167 | 2624 | 54 |
1395494 | 1395494 | 2021-06-07 | Mercer | Kentucky | 21167 | 2621 | 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);