ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Daviess" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811148 | 1811148 | 2021-10-13 | Daviess | Kentucky | 21059 | 16519 | 254 |
1807899 | 1807899 | 2021-10-12 | Daviess | Kentucky | 21059 | 16467 | 252 |
1804648 | 1804648 | 2021-10-11 | Daviess | Kentucky | 21059 | 16426 | 251 |
1801399 | 1801399 | 2021-10-10 | Daviess | Kentucky | 21059 | 16300 | 248 |
1798150 | 1798150 | 2021-10-09 | Daviess | Kentucky | 21059 | 16300 | 248 |
1794901 | 1794901 | 2021-10-08 | Daviess | Kentucky | 21059 | 16300 | 248 |
1791653 | 1791653 | 2021-10-07 | Daviess | Kentucky | 21059 | 16239 | 248 |
1788404 | 1788404 | 2021-10-06 | Daviess | Kentucky | 21059 | 16204 | 248 |
1785155 | 1785155 | 2021-10-05 | Daviess | Kentucky | 21059 | 16137 | 245 |
1781906 | 1781906 | 2021-10-04 | Daviess | Kentucky | 21059 | 16107 | 245 |
1778656 | 1778656 | 2021-10-03 | Daviess | Kentucky | 21059 | 15972 | 242 |
1775406 | 1775406 | 2021-10-02 | Daviess | Kentucky | 21059 | 15972 | 242 |
1772156 | 1772156 | 2021-10-01 | Daviess | Kentucky | 21059 | 15972 | 242 |
1768907 | 1768907 | 2021-09-30 | Daviess | Kentucky | 21059 | 15901 | 242 |
1765658 | 1765658 | 2021-09-29 | Daviess | Kentucky | 21059 | 15816 | 242 |
1762409 | 1762409 | 2021-09-28 | Daviess | Kentucky | 21059 | 15735 | 242 |
1759161 | 1759161 | 2021-09-27 | Daviess | Kentucky | 21059 | 15697 | 237 |
1755913 | 1755913 | 2021-09-26 | Daviess | Kentucky | 21059 | 15540 | 237 |
1752665 | 1752665 | 2021-09-25 | Daviess | Kentucky | 21059 | 15540 | 237 |
1749416 | 1749416 | 2021-09-24 | Daviess | Kentucky | 21059 | 15540 | 237 |
1746166 | 1746166 | 2021-09-23 | Daviess | Kentucky | 21059 | 15481 | 237 |
1742917 | 1742917 | 2021-09-22 | Daviess | Kentucky | 21059 | 15420 | 236 |
1739668 | 1739668 | 2021-09-21 | Daviess | Kentucky | 21059 | 15350 | 233 |
1736419 | 1736419 | 2021-09-20 | Daviess | Kentucky | 21059 | 15303 | 230 |
1733169 | 1733169 | 2021-09-19 | Daviess | Kentucky | 21059 | 15167 | 230 |
1729919 | 1729919 | 2021-09-18 | Daviess | Kentucky | 21059 | 15167 | 230 |
1726669 | 1726669 | 2021-09-17 | Daviess | Kentucky | 21059 | 15167 | 230 |
1723420 | 1723420 | 2021-09-16 | Daviess | Kentucky | 21059 | 15094 | 227 |
1720171 | 1720171 | 2021-09-15 | Daviess | Kentucky | 21059 | 14998 | 226 |
1716923 | 1716923 | 2021-09-14 | Daviess | Kentucky | 21059 | 14918 | 224 |
1713677 | 1713677 | 2021-09-13 | Daviess | Kentucky | 21059 | 14853 | 222 |
1710430 | 1710430 | 2021-09-12 | Daviess | Kentucky | 21059 | 14656 | 222 |
1707183 | 1707183 | 2021-09-11 | Daviess | Kentucky | 21059 | 14656 | 222 |
1703935 | 1703935 | 2021-09-10 | Daviess | Kentucky | 21059 | 14656 | 222 |
1700685 | 1700685 | 2021-09-09 | Daviess | Kentucky | 21059 | 14556 | 219 |
1697436 | 1697436 | 2021-09-08 | Daviess | Kentucky | 21059 | 14468 | 218 |
1694188 | 1694188 | 2021-09-07 | Daviess | Kentucky | 21059 | 14354 | 218 |
1690939 | 1690939 | 2021-09-06 | Daviess | Kentucky | 21059 | 14096 | 217 |
1687689 | 1687689 | 2021-09-05 | Daviess | Kentucky | 21059 | 14096 | 217 |
1684439 | 1684439 | 2021-09-04 | Daviess | Kentucky | 21059 | 14096 | 217 |
1681188 | 1681188 | 2021-09-03 | Daviess | Kentucky | 21059 | 14096 | 217 |
1677940 | 1677940 | 2021-09-02 | Daviess | Kentucky | 21059 | 13983 | 217 |
1674693 | 1674693 | 2021-09-01 | Daviess | Kentucky | 21059 | 13867 | 217 |
1671444 | 1671444 | 2021-08-31 | Daviess | Kentucky | 21059 | 13763 | 217 |
1668197 | 1668197 | 2021-08-30 | Daviess | Kentucky | 21059 | 13706 | 214 |
1664950 | 1664950 | 2021-08-29 | Daviess | Kentucky | 21059 | 13509 | 212 |
1661702 | 1661702 | 2021-08-28 | Daviess | Kentucky | 21059 | 13509 | 212 |
1658454 | 1658454 | 2021-08-27 | Daviess | Kentucky | 21059 | 13509 | 212 |
1655206 | 1655206 | 2021-08-26 | Daviess | Kentucky | 21059 | 13413 | 211 |
1651959 | 1651959 | 2021-08-25 | Daviess | Kentucky | 21059 | 13314 | 210 |
1648710 | 1648710 | 2021-08-24 | Daviess | Kentucky | 21059 | 13216 | 207 |
1645462 | 1645462 | 2021-08-23 | Daviess | Kentucky | 21059 | 13137 | 207 |
1642213 | 1642213 | 2021-08-22 | Daviess | Kentucky | 21059 | 12915 | 207 |
1638963 | 1638963 | 2021-08-21 | Daviess | Kentucky | 21059 | 12915 | 207 |
1635713 | 1635713 | 2021-08-20 | Daviess | Kentucky | 21059 | 12915 | 207 |
1632463 | 1632463 | 2021-08-19 | Daviess | Kentucky | 21059 | 12810 | 207 |
1629216 | 1629216 | 2021-08-18 | Daviess | Kentucky | 21059 | 12699 | 207 |
1625969 | 1625969 | 2021-08-17 | Daviess | Kentucky | 21059 | 12609 | 206 |
1622722 | 1622722 | 2021-08-16 | Daviess | Kentucky | 21059 | 12560 | 202 |
1619475 | 1619475 | 2021-08-15 | Daviess | Kentucky | 21059 | 12395 | 202 |
1616227 | 1616227 | 2021-08-14 | Daviess | Kentucky | 21059 | 12395 | 202 |
1612978 | 1612978 | 2021-08-13 | Daviess | Kentucky | 21059 | 12395 | 202 |
1609730 | 1609730 | 2021-08-12 | Daviess | Kentucky | 21059 | 12293 | 202 |
1606481 | 1606481 | 2021-08-11 | Daviess | Kentucky | 21059 | 12242 | 202 |
1603232 | 1603232 | 2021-08-10 | Daviess | Kentucky | 21059 | 12143 | 202 |
1599983 | 1599983 | 2021-08-09 | Daviess | Kentucky | 21059 | 12093 | 202 |
1596735 | 1596735 | 2021-08-08 | Daviess | Kentucky | 21059 | 11955 | 198 |
1593486 | 1593486 | 2021-08-07 | Daviess | Kentucky | 21059 | 11955 | 198 |
1590237 | 1590237 | 2021-08-06 | Daviess | Kentucky | 21059 | 11955 | 198 |
1586988 | 1586988 | 2021-08-05 | Daviess | Kentucky | 21059 | 11827 | 198 |
1583738 | 1583738 | 2021-08-04 | Daviess | Kentucky | 21059 | 11778 | 197 |
1580488 | 1580488 | 2021-08-03 | Daviess | Kentucky | 21059 | 11693 | 196 |
1577239 | 1577239 | 2021-08-02 | Daviess | Kentucky | 21059 | 11656 | 196 |
1573991 | 1573991 | 2021-08-01 | Daviess | Kentucky | 21059 | 11550 | 196 |
1570743 | 1570743 | 2021-07-31 | Daviess | Kentucky | 21059 | 11550 | 196 |
1567495 | 1567495 | 2021-07-30 | Daviess | Kentucky | 21059 | 11550 | 196 |
1564247 | 1564247 | 2021-07-29 | Daviess | Kentucky | 21059 | 11502 | 196 |
1560999 | 1560999 | 2021-07-28 | Daviess | Kentucky | 21059 | 11457 | 196 |
1557752 | 1557752 | 2021-07-27 | Daviess | Kentucky | 21059 | 11422 | 196 |
1554505 | 1554505 | 2021-07-26 | Daviess | Kentucky | 21059 | 11380 | 196 |
1551258 | 1551258 | 2021-07-25 | Daviess | Kentucky | 21059 | 11278 | 196 |
1548011 | 1548011 | 2021-07-24 | Daviess | Kentucky | 21059 | 11278 | 196 |
1544764 | 1544764 | 2021-07-23 | Daviess | Kentucky | 21059 | 11278 | 196 |
1541516 | 1541516 | 2021-07-22 | Daviess | Kentucky | 21059 | 11247 | 196 |
1538269 | 1538269 | 2021-07-21 | Daviess | Kentucky | 21059 | 11217 | 196 |
1535021 | 1535021 | 2021-07-20 | Daviess | Kentucky | 21059 | 11170 | 196 |
1531774 | 1531774 | 2021-07-19 | Daviess | Kentucky | 21059 | 11135 | 196 |
1528527 | 1528527 | 2021-07-18 | Daviess | Kentucky | 21059 | 11099 | 195 |
1525280 | 1525280 | 2021-07-17 | Daviess | Kentucky | 21059 | 11099 | 195 |
1522032 | 1522032 | 2021-07-16 | Daviess | Kentucky | 21059 | 11099 | 195 |
1518784 | 1518784 | 2021-07-15 | Daviess | Kentucky | 21059 | 11080 | 195 |
1515537 | 1515537 | 2021-07-14 | Daviess | Kentucky | 21059 | 11071 | 195 |
1512291 | 1512291 | 2021-07-13 | Daviess | Kentucky | 21059 | 11052 | 195 |
1509044 | 1509044 | 2021-07-12 | Daviess | Kentucky | 21059 | 11042 | 195 |
1505798 | 1505798 | 2021-07-11 | Daviess | Kentucky | 21059 | 11024 | 193 |
1502552 | 1502552 | 2021-07-10 | Daviess | Kentucky | 21059 | 11024 | 193 |
1499306 | 1499306 | 2021-07-09 | Daviess | Kentucky | 21059 | 11024 | 193 |
1496059 | 1496059 | 2021-07-08 | Daviess | Kentucky | 21059 | 11016 | 193 |
1492813 | 1492813 | 2021-07-07 | Daviess | Kentucky | 21059 | 11015 | 193 |
1489566 | 1489566 | 2021-07-06 | Daviess | Kentucky | 21059 | 11012 | 193 |
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);