ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 21019 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716903 | 1716903 | 2021-09-14 | Boyd | Kentucky | 21019 | 7116 | 86 |
1713657 | 1713657 | 2021-09-13 | Boyd | Kentucky | 21019 | 7054 | 86 |
1710410 | 1710410 | 2021-09-12 | Boyd | Kentucky | 21019 | 6924 | 85 |
1707163 | 1707163 | 2021-09-11 | Boyd | Kentucky | 21019 | 6924 | 85 |
1703915 | 1703915 | 2021-09-10 | Boyd | Kentucky | 21019 | 6924 | 85 |
1700665 | 1700665 | 2021-09-09 | Boyd | Kentucky | 21019 | 6849 | 85 |
1697416 | 1697416 | 2021-09-08 | Boyd | Kentucky | 21019 | 6795 | 85 |
1694168 | 1694168 | 2021-09-07 | Boyd | Kentucky | 21019 | 6731 | 85 |
1690919 | 1690919 | 2021-09-06 | Boyd | Kentucky | 21019 | 6585 | 84 |
1687669 | 1687669 | 2021-09-05 | Boyd | Kentucky | 21019 | 6585 | 84 |
1684419 | 1684419 | 2021-09-04 | Boyd | Kentucky | 21019 | 6585 | 84 |
1681168 | 1681168 | 2021-09-03 | Boyd | Kentucky | 21019 | 6585 | 84 |
1677920 | 1677920 | 2021-09-02 | Boyd | Kentucky | 21019 | 6520 | 84 |
1674673 | 1674673 | 2021-09-01 | Boyd | Kentucky | 21019 | 6460 | 84 |
1671424 | 1671424 | 2021-08-31 | Boyd | Kentucky | 21019 | 6413 | 84 |
1668177 | 1668177 | 2021-08-30 | Boyd | Kentucky | 21019 | 6356 | 84 |
1664930 | 1664930 | 2021-08-29 | Boyd | Kentucky | 21019 | 6235 | 84 |
1661682 | 1661682 | 2021-08-28 | Boyd | Kentucky | 21019 | 6235 | 84 |
1658434 | 1658434 | 2021-08-27 | Boyd | Kentucky | 21019 | 6235 | 84 |
1655186 | 1655186 | 2021-08-26 | Boyd | Kentucky | 21019 | 6159 | 83 |
1651939 | 1651939 | 2021-08-25 | Boyd | Kentucky | 21019 | 6113 | 83 |
1648690 | 1648690 | 2021-08-24 | Boyd | Kentucky | 21019 | 6063 | 82 |
1645442 | 1645442 | 2021-08-23 | Boyd | Kentucky | 21019 | 6001 | 81 |
1642193 | 1642193 | 2021-08-22 | Boyd | Kentucky | 21019 | 5898 | 79 |
1638943 | 1638943 | 2021-08-21 | Boyd | Kentucky | 21019 | 5898 | 79 |
1635693 | 1635693 | 2021-08-20 | Boyd | Kentucky | 21019 | 5898 | 79 |
1632443 | 1632443 | 2021-08-19 | Boyd | Kentucky | 21019 | 5852 | 77 |
1629196 | 1629196 | 2021-08-18 | Boyd | Kentucky | 21019 | 5809 | 77 |
1625949 | 1625949 | 2021-08-17 | Boyd | Kentucky | 21019 | 5763 | 77 |
1622702 | 1622702 | 2021-08-16 | Boyd | Kentucky | 21019 | 5736 | 77 |
1619455 | 1619455 | 2021-08-15 | Boyd | Kentucky | 21019 | 5630 | 77 |
1616207 | 1616207 | 2021-08-14 | Boyd | Kentucky | 21019 | 5630 | 77 |
1612958 | 1612958 | 2021-08-13 | Boyd | Kentucky | 21019 | 5630 | 77 |
1609710 | 1609710 | 2021-08-12 | Boyd | Kentucky | 21019 | 5610 | 77 |
1606461 | 1606461 | 2021-08-11 | Boyd | Kentucky | 21019 | 5577 | 77 |
1603212 | 1603212 | 2021-08-10 | Boyd | Kentucky | 21019 | 5544 | 77 |
1599963 | 1599963 | 2021-08-09 | Boyd | Kentucky | 21019 | 5511 | 77 |
1596715 | 1596715 | 2021-08-08 | Boyd | Kentucky | 21019 | 5449 | 77 |
1593466 | 1593466 | 2021-08-07 | Boyd | Kentucky | 21019 | 5449 | 77 |
1590217 | 1590217 | 2021-08-06 | Boyd | Kentucky | 21019 | 5449 | 77 |
1586968 | 1586968 | 2021-08-05 | Boyd | Kentucky | 21019 | 5426 | 77 |
1583718 | 1583718 | 2021-08-04 | Boyd | Kentucky | 21019 | 5402 | 77 |
1580468 | 1580468 | 2021-08-03 | Boyd | Kentucky | 21019 | 5385 | 77 |
1577219 | 1577219 | 2021-08-02 | Boyd | Kentucky | 21019 | 5358 | 77 |
1573971 | 1573971 | 2021-08-01 | Boyd | Kentucky | 21019 | 5330 | 77 |
1570723 | 1570723 | 2021-07-31 | Boyd | Kentucky | 21019 | 5330 | 77 |
1567475 | 1567475 | 2021-07-30 | Boyd | Kentucky | 21019 | 5330 | 77 |
1564227 | 1564227 | 2021-07-29 | Boyd | Kentucky | 21019 | 5305 | 77 |
1560979 | 1560979 | 2021-07-28 | Boyd | Kentucky | 21019 | 5293 | 77 |
1557732 | 1557732 | 2021-07-27 | Boyd | Kentucky | 21019 | 5277 | 77 |
1554485 | 1554485 | 2021-07-26 | Boyd | Kentucky | 21019 | 5272 | 76 |
1551238 | 1551238 | 2021-07-25 | Boyd | Kentucky | 21019 | 5239 | 76 |
1547991 | 1547991 | 2021-07-24 | Boyd | Kentucky | 21019 | 5239 | 76 |
1544744 | 1544744 | 2021-07-23 | Boyd | Kentucky | 21019 | 5239 | 76 |
1541496 | 1541496 | 2021-07-22 | Boyd | Kentucky | 21019 | 5238 | 76 |
1538249 | 1538249 | 2021-07-21 | Boyd | Kentucky | 21019 | 5228 | 76 |
1535001 | 1535001 | 2021-07-20 | Boyd | Kentucky | 21019 | 5221 | 76 |
1531754 | 1531754 | 2021-07-19 | Boyd | Kentucky | 21019 | 5219 | 76 |
1528507 | 1528507 | 2021-07-18 | Boyd | Kentucky | 21019 | 5211 | 76 |
1525260 | 1525260 | 2021-07-17 | Boyd | Kentucky | 21019 | 5211 | 76 |
1522012 | 1522012 | 2021-07-16 | Boyd | Kentucky | 21019 | 5211 | 76 |
1518764 | 1518764 | 2021-07-15 | Boyd | Kentucky | 21019 | 5208 | 76 |
1515517 | 1515517 | 2021-07-14 | Boyd | Kentucky | 21019 | 5203 | 76 |
1512271 | 1512271 | 2021-07-13 | Boyd | Kentucky | 21019 | 5203 | 76 |
1509024 | 1509024 | 2021-07-12 | Boyd | Kentucky | 21019 | 5194 | 76 |
1505778 | 1505778 | 2021-07-11 | Boyd | Kentucky | 21019 | 5177 | 76 |
1502532 | 1502532 | 2021-07-10 | Boyd | Kentucky | 21019 | 5177 | 76 |
1499286 | 1499286 | 2021-07-09 | Boyd | Kentucky | 21019 | 5177 | 76 |
1496039 | 1496039 | 2021-07-08 | Boyd | Kentucky | 21019 | 5165 | 76 |
1492793 | 1492793 | 2021-07-07 | Boyd | Kentucky | 21019 | 5160 | 76 |
1489546 | 1489546 | 2021-07-06 | Boyd | Kentucky | 21019 | 5158 | 76 |
1486299 | 1486299 | 2021-07-05 | Boyd | Kentucky | 21019 | 5146 | 76 |
1483053 | 1483053 | 2021-07-04 | Boyd | Kentucky | 21019 | 5146 | 76 |
1479806 | 1479806 | 2021-07-03 | Boyd | Kentucky | 21019 | 5146 | 76 |
1476560 | 1476560 | 2021-07-02 | Boyd | Kentucky | 21019 | 5146 | 76 |
1473314 | 1473314 | 2021-07-01 | Boyd | Kentucky | 21019 | 5144 | 76 |
1470068 | 1470068 | 2021-06-30 | Boyd | Kentucky | 21019 | 5142 | 76 |
1466823 | 1466823 | 2021-06-29 | Boyd | Kentucky | 21019 | 5135 | 76 |
1463578 | 1463578 | 2021-06-28 | Boyd | Kentucky | 21019 | 5135 | 76 |
1460333 | 1460333 | 2021-06-27 | Boyd | Kentucky | 21019 | 5128 | 76 |
1457088 | 1457088 | 2021-06-26 | Boyd | Kentucky | 21019 | 5128 | 76 |
1453843 | 1453843 | 2021-06-25 | Boyd | Kentucky | 21019 | 5128 | 76 |
1450597 | 1450597 | 2021-06-24 | Boyd | Kentucky | 21019 | 5121 | 76 |
1447352 | 1447352 | 2021-06-23 | Boyd | Kentucky | 21019 | 5120 | 76 |
1444107 | 1444107 | 2021-06-22 | Boyd | Kentucky | 21019 | 5119 | 76 |
1440862 | 1440862 | 2021-06-21 | Boyd | Kentucky | 21019 | 5114 | 76 |
1437615 | 1437615 | 2021-06-20 | Boyd | Kentucky | 21019 | 5107 | 76 |
1434368 | 1434368 | 2021-06-19 | Boyd | Kentucky | 21019 | 5107 | 76 |
1431122 | 1431122 | 2021-06-18 | Boyd | Kentucky | 21019 | 5107 | 76 |
1427877 | 1427877 | 2021-06-17 | Boyd | Kentucky | 21019 | 5100 | 75 |
1424632 | 1424632 | 2021-06-16 | Boyd | Kentucky | 21019 | 5097 | 75 |
1421384 | 1421384 | 2021-06-15 | Boyd | Kentucky | 21019 | 5093 | 75 |
1418139 | 1418139 | 2021-06-14 | Boyd | Kentucky | 21019 | 5092 | 75 |
1414893 | 1414893 | 2021-06-13 | Boyd | Kentucky | 21019 | 5091 | 75 |
1411648 | 1411648 | 2021-06-12 | Boyd | Kentucky | 21019 | 5089 | 75 |
1408403 | 1408403 | 2021-06-11 | Boyd | Kentucky | 21019 | 5087 | 75 |
1405157 | 1405157 | 2021-06-10 | Boyd | Kentucky | 21019 | 5085 | 75 |
1401912 | 1401912 | 2021-06-09 | Boyd | Kentucky | 21019 | 5084 | 75 |
1398667 | 1398667 | 2021-06-08 | Boyd | Kentucky | 21019 | 5080 | 75 |
1395420 | 1395420 | 2021-06-07 | Boyd | Kentucky | 21019 | 5076 | 75 |
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);