ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Morgan" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850196 | 1850196 | 2021-10-25 | Morgan | Kentucky | 21175 | 2851 | 9 |
1846946 | 1846946 | 2021-10-24 | Morgan | Kentucky | 21175 | 2849 | 9 |
1843696 | 1843696 | 2021-10-23 | Morgan | Kentucky | 21175 | 2849 | 9 |
1840446 | 1840446 | 2021-10-22 | Morgan | Kentucky | 21175 | 2849 | 9 |
1837197 | 1837197 | 2021-10-21 | Morgan | Kentucky | 21175 | 2848 | 9 |
1833948 | 1833948 | 2021-10-20 | Morgan | Kentucky | 21175 | 2842 | 9 |
1830699 | 1830699 | 2021-10-19 | Morgan | Kentucky | 21175 | 2840 | 9 |
1827450 | 1827450 | 2021-10-18 | Morgan | Kentucky | 21175 | 2829 | 9 |
1824201 | 1824201 | 2021-10-17 | Morgan | Kentucky | 21175 | 2822 | 6 |
1820952 | 1820952 | 2021-10-16 | Morgan | Kentucky | 21175 | 2822 | 6 |
1817703 | 1817703 | 2021-10-15 | Morgan | Kentucky | 21175 | 2822 | 6 |
1814455 | 1814455 | 2021-10-14 | Morgan | Kentucky | 21175 | 2819 | 6 |
1811206 | 1811206 | 2021-10-13 | Morgan | Kentucky | 21175 | 2817 | 6 |
1807957 | 1807957 | 2021-10-12 | Morgan | Kentucky | 21175 | 2810 | 6 |
1804706 | 1804706 | 2021-10-11 | Morgan | Kentucky | 21175 | 2805 | 6 |
1801457 | 1801457 | 2021-10-10 | Morgan | Kentucky | 21175 | 2801 | 6 |
1798208 | 1798208 | 2021-10-09 | Morgan | Kentucky | 21175 | 2801 | 6 |
1794959 | 1794959 | 2021-10-08 | Morgan | Kentucky | 21175 | 2801 | 6 |
1791711 | 1791711 | 2021-10-07 | Morgan | Kentucky | 21175 | 2794 | 6 |
1788462 | 1788462 | 2021-10-06 | Morgan | Kentucky | 21175 | 2788 | 6 |
1785213 | 1785213 | 2021-10-05 | Morgan | Kentucky | 21175 | 2788 | 6 |
1781964 | 1781964 | 2021-10-04 | Morgan | Kentucky | 21175 | 2787 | 6 |
1778714 | 1778714 | 2021-10-03 | Morgan | Kentucky | 21175 | 2775 | 6 |
1775464 | 1775464 | 2021-10-02 | Morgan | Kentucky | 21175 | 2775 | 6 |
1772214 | 1772214 | 2021-10-01 | Morgan | Kentucky | 21175 | 2775 | 6 |
1768965 | 1768965 | 2021-09-30 | Morgan | Kentucky | 21175 | 2767 | 6 |
1765716 | 1765716 | 2021-09-29 | Morgan | Kentucky | 21175 | 2762 | 6 |
1762467 | 1762467 | 2021-09-28 | Morgan | Kentucky | 21175 | 2761 | 6 |
1759219 | 1759219 | 2021-09-27 | Morgan | Kentucky | 21175 | 2752 | 6 |
1755971 | 1755971 | 2021-09-26 | Morgan | Kentucky | 21175 | 2744 | 6 |
1752723 | 1752723 | 2021-09-25 | Morgan | Kentucky | 21175 | 2744 | 6 |
1749474 | 1749474 | 2021-09-24 | Morgan | Kentucky | 21175 | 2744 | 6 |
1746224 | 1746224 | 2021-09-23 | Morgan | Kentucky | 21175 | 2736 | 6 |
1742975 | 1742975 | 2021-09-22 | Morgan | Kentucky | 21175 | 2720 | 6 |
1739726 | 1739726 | 2021-09-21 | Morgan | Kentucky | 21175 | 2717 | 6 |
1736477 | 1736477 | 2021-09-20 | Morgan | Kentucky | 21175 | 2713 | 6 |
1733227 | 1733227 | 2021-09-19 | Morgan | Kentucky | 21175 | 2694 | 6 |
1729977 | 1729977 | 2021-09-18 | Morgan | Kentucky | 21175 | 2694 | 6 |
1726727 | 1726727 | 2021-09-17 | Morgan | Kentucky | 21175 | 2694 | 6 |
1723478 | 1723478 | 2021-09-16 | Morgan | Kentucky | 21175 | 2680 | 5 |
1720229 | 1720229 | 2021-09-15 | Morgan | Kentucky | 21175 | 2646 | 5 |
1716981 | 1716981 | 2021-09-14 | Morgan | Kentucky | 21175 | 2639 | 5 |
1713735 | 1713735 | 2021-09-13 | Morgan | Kentucky | 21175 | 2621 | 5 |
1710488 | 1710488 | 2021-09-12 | Morgan | Kentucky | 21175 | 2599 | 5 |
1707241 | 1707241 | 2021-09-11 | Morgan | Kentucky | 21175 | 2599 | 5 |
1703993 | 1703993 | 2021-09-10 | Morgan | Kentucky | 21175 | 2599 | 5 |
1700743 | 1700743 | 2021-09-09 | Morgan | Kentucky | 21175 | 2584 | 5 |
1697494 | 1697494 | 2021-09-08 | Morgan | Kentucky | 21175 | 2582 | 5 |
1694246 | 1694246 | 2021-09-07 | Morgan | Kentucky | 21175 | 2570 | 5 |
1690997 | 1690997 | 2021-09-06 | Morgan | Kentucky | 21175 | 2561 | 5 |
1687747 | 1687747 | 2021-09-05 | Morgan | Kentucky | 21175 | 2561 | 5 |
1684497 | 1684497 | 2021-09-04 | Morgan | Kentucky | 21175 | 2561 | 5 |
1681246 | 1681246 | 2021-09-03 | Morgan | Kentucky | 21175 | 2561 | 5 |
1677998 | 1677998 | 2021-09-02 | Morgan | Kentucky | 21175 | 2558 | 5 |
1674751 | 1674751 | 2021-09-01 | Morgan | Kentucky | 21175 | 2550 | 5 |
1671502 | 1671502 | 2021-08-31 | Morgan | Kentucky | 21175 | 2532 | 5 |
1668255 | 1668255 | 2021-08-30 | Morgan | Kentucky | 21175 | 2521 | 5 |
1665008 | 1665008 | 2021-08-29 | Morgan | Kentucky | 21175 | 2512 | 5 |
1661760 | 1661760 | 2021-08-28 | Morgan | Kentucky | 21175 | 2512 | 5 |
1658512 | 1658512 | 2021-08-27 | Morgan | Kentucky | 21175 | 2512 | 5 |
1655264 | 1655264 | 2021-08-26 | Morgan | Kentucky | 21175 | 2511 | 5 |
1652017 | 1652017 | 2021-08-25 | Morgan | Kentucky | 21175 | 2495 | 5 |
1648768 | 1648768 | 2021-08-24 | Morgan | Kentucky | 21175 | 2491 | 5 |
1645520 | 1645520 | 2021-08-23 | Morgan | Kentucky | 21175 | 2481 | 5 |
1642271 | 1642271 | 2021-08-22 | Morgan | Kentucky | 21175 | 2475 | 5 |
1639021 | 1639021 | 2021-08-21 | Morgan | Kentucky | 21175 | 2475 | 5 |
1635771 | 1635771 | 2021-08-20 | Morgan | Kentucky | 21175 | 2475 | 5 |
1632521 | 1632521 | 2021-08-19 | Morgan | Kentucky | 21175 | 2461 | 5 |
1629274 | 1629274 | 2021-08-18 | Morgan | Kentucky | 21175 | 2448 | 5 |
1626027 | 1626027 | 2021-08-17 | Morgan | Kentucky | 21175 | 2443 | 5 |
1622780 | 1622780 | 2021-08-16 | Morgan | Kentucky | 21175 | 2430 | 5 |
1619533 | 1619533 | 2021-08-15 | Morgan | Kentucky | 21175 | 2418 | 5 |
1616285 | 1616285 | 2021-08-14 | Morgan | Kentucky | 21175 | 2418 | 5 |
1613036 | 1613036 | 2021-08-13 | Morgan | Kentucky | 21175 | 2418 | 5 |
1609788 | 1609788 | 2021-08-12 | Morgan | Kentucky | 21175 | 2406 | 5 |
1606539 | 1606539 | 2021-08-11 | Morgan | Kentucky | 21175 | 2397 | 5 |
1603290 | 1603290 | 2021-08-10 | Morgan | Kentucky | 21175 | 2384 | 5 |
1600041 | 1600041 | 2021-08-09 | Morgan | Kentucky | 21175 | 2368 | 5 |
1596793 | 1596793 | 2021-08-08 | Morgan | Kentucky | 21175 | 2362 | 5 |
1593544 | 1593544 | 2021-08-07 | Morgan | Kentucky | 21175 | 2362 | 5 |
1590295 | 1590295 | 2021-08-06 | Morgan | Kentucky | 21175 | 2362 | 5 |
1587046 | 1587046 | 2021-08-05 | Morgan | Kentucky | 21175 | 2355 | 5 |
1583796 | 1583796 | 2021-08-04 | Morgan | Kentucky | 21175 | 2354 | 5 |
1580546 | 1580546 | 2021-08-03 | Morgan | Kentucky | 21175 | 2351 | 5 |
1577297 | 1577297 | 2021-08-02 | Morgan | Kentucky | 21175 | 2344 | 5 |
1574049 | 1574049 | 2021-08-01 | Morgan | Kentucky | 21175 | 2343 | 5 |
1570801 | 1570801 | 2021-07-31 | Morgan | Kentucky | 21175 | 2343 | 5 |
1567553 | 1567553 | 2021-07-30 | Morgan | Kentucky | 21175 | 2343 | 5 |
1564305 | 1564305 | 2021-07-29 | Morgan | Kentucky | 21175 | 2343 | 5 |
1561057 | 1561057 | 2021-07-28 | Morgan | Kentucky | 21175 | 2338 | 5 |
1557810 | 1557810 | 2021-07-27 | Morgan | Kentucky | 21175 | 2338 | 5 |
1554563 | 1554563 | 2021-07-26 | Morgan | Kentucky | 21175 | 2336 | 5 |
1551316 | 1551316 | 2021-07-25 | Morgan | Kentucky | 21175 | 2336 | 5 |
1548069 | 1548069 | 2021-07-24 | Morgan | Kentucky | 21175 | 2336 | 5 |
1544822 | 1544822 | 2021-07-23 | Morgan | Kentucky | 21175 | 2336 | 5 |
1541574 | 1541574 | 2021-07-22 | Morgan | Kentucky | 21175 | 2336 | 5 |
1538327 | 1538327 | 2021-07-21 | Morgan | Kentucky | 21175 | 2333 | 5 |
1535079 | 1535079 | 2021-07-20 | Morgan | Kentucky | 21175 | 2332 | 5 |
1531832 | 1531832 | 2021-07-19 | Morgan | Kentucky | 21175 | 2331 | 5 |
1528585 | 1528585 | 2021-07-18 | Morgan | Kentucky | 21175 | 2330 | 5 |
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);