ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 21221 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717004 | 1717004 | 2021-09-14 | Trigg | Kentucky | 21221 | 1625 | 17 |
1713758 | 1713758 | 2021-09-13 | Trigg | Kentucky | 21221 | 1615 | 17 |
1710511 | 1710511 | 2021-09-12 | Trigg | Kentucky | 21221 | 1594 | 17 |
1707264 | 1707264 | 2021-09-11 | Trigg | Kentucky | 21221 | 1594 | 17 |
1704016 | 1704016 | 2021-09-10 | Trigg | Kentucky | 21221 | 1594 | 17 |
1700766 | 1700766 | 2021-09-09 | Trigg | Kentucky | 21221 | 1586 | 16 |
1697517 | 1697517 | 2021-09-08 | Trigg | Kentucky | 21221 | 1575 | 16 |
1694269 | 1694269 | 2021-09-07 | Trigg | Kentucky | 21221 | 1571 | 16 |
1691020 | 1691020 | 2021-09-06 | Trigg | Kentucky | 21221 | 1554 | 16 |
1687770 | 1687770 | 2021-09-05 | Trigg | Kentucky | 21221 | 1554 | 16 |
1684520 | 1684520 | 2021-09-04 | Trigg | Kentucky | 21221 | 1554 | 16 |
1681269 | 1681269 | 2021-09-03 | Trigg | Kentucky | 21221 | 1554 | 16 |
1678021 | 1678021 | 2021-09-02 | Trigg | Kentucky | 21221 | 1544 | 16 |
1674774 | 1674774 | 2021-09-01 | Trigg | Kentucky | 21221 | 1539 | 16 |
1671525 | 1671525 | 2021-08-31 | Trigg | Kentucky | 21221 | 1533 | 16 |
1668278 | 1668278 | 2021-08-30 | Trigg | Kentucky | 21221 | 1529 | 16 |
1665031 | 1665031 | 2021-08-29 | Trigg | Kentucky | 21221 | 1512 | 16 |
1661783 | 1661783 | 2021-08-28 | Trigg | Kentucky | 21221 | 1512 | 16 |
1658535 | 1658535 | 2021-08-27 | Trigg | Kentucky | 21221 | 1512 | 16 |
1655287 | 1655287 | 2021-08-26 | Trigg | Kentucky | 21221 | 1509 | 16 |
1652040 | 1652040 | 2021-08-25 | Trigg | Kentucky | 21221 | 1497 | 16 |
1648791 | 1648791 | 2021-08-24 | Trigg | Kentucky | 21221 | 1496 | 16 |
1645543 | 1645543 | 2021-08-23 | Trigg | Kentucky | 21221 | 1490 | 15 |
1642294 | 1642294 | 2021-08-22 | Trigg | Kentucky | 21221 | 1470 | 15 |
1639044 | 1639044 | 2021-08-21 | Trigg | Kentucky | 21221 | 1470 | 15 |
1635794 | 1635794 | 2021-08-20 | Trigg | Kentucky | 21221 | 1470 | 15 |
1632544 | 1632544 | 2021-08-19 | Trigg | Kentucky | 21221 | 1460 | 15 |
1629297 | 1629297 | 2021-08-18 | Trigg | Kentucky | 21221 | 1455 | 15 |
1626050 | 1626050 | 2021-08-17 | Trigg | Kentucky | 21221 | 1454 | 15 |
1622803 | 1622803 | 2021-08-16 | Trigg | Kentucky | 21221 | 1447 | 15 |
1619556 | 1619556 | 2021-08-15 | Trigg | Kentucky | 21221 | 1441 | 15 |
1616308 | 1616308 | 2021-08-14 | Trigg | Kentucky | 21221 | 1441 | 15 |
1613059 | 1613059 | 2021-08-13 | Trigg | Kentucky | 21221 | 1441 | 15 |
1609811 | 1609811 | 2021-08-12 | Trigg | Kentucky | 21221 | 1421 | 15 |
1606562 | 1606562 | 2021-08-11 | Trigg | Kentucky | 21221 | 1400 | 15 |
1603313 | 1603313 | 2021-08-10 | Trigg | Kentucky | 21221 | 1386 | 15 |
1600064 | 1600064 | 2021-08-09 | Trigg | Kentucky | 21221 | 1376 | 15 |
1596816 | 1596816 | 2021-08-08 | Trigg | Kentucky | 21221 | 1365 | 15 |
1593567 | 1593567 | 2021-08-07 | Trigg | Kentucky | 21221 | 1365 | 15 |
1590318 | 1590318 | 2021-08-06 | Trigg | Kentucky | 21221 | 1365 | 15 |
1587069 | 1587069 | 2021-08-05 | Trigg | Kentucky | 21221 | 1356 | 15 |
1583819 | 1583819 | 2021-08-04 | Trigg | Kentucky | 21221 | 1356 | 15 |
1580569 | 1580569 | 2021-08-03 | Trigg | Kentucky | 21221 | 1354 | 15 |
1577320 | 1577320 | 2021-08-02 | Trigg | Kentucky | 21221 | 1354 | 15 |
1574072 | 1574072 | 2021-08-01 | Trigg | Kentucky | 21221 | 1352 | 15 |
1570824 | 1570824 | 2021-07-31 | Trigg | Kentucky | 21221 | 1352 | 15 |
1567576 | 1567576 | 2021-07-30 | Trigg | Kentucky | 21221 | 1352 | 15 |
1564328 | 1564328 | 2021-07-29 | Trigg | Kentucky | 21221 | 1351 | 15 |
1561080 | 1561080 | 2021-07-28 | Trigg | Kentucky | 21221 | 1349 | 15 |
1557833 | 1557833 | 2021-07-27 | Trigg | Kentucky | 21221 | 1349 | 15 |
1554586 | 1554586 | 2021-07-26 | Trigg | Kentucky | 21221 | 1347 | 15 |
1551339 | 1551339 | 2021-07-25 | Trigg | Kentucky | 21221 | 1347 | 15 |
1548092 | 1548092 | 2021-07-24 | Trigg | Kentucky | 21221 | 1347 | 15 |
1544845 | 1544845 | 2021-07-23 | Trigg | Kentucky | 21221 | 1347 | 15 |
1541597 | 1541597 | 2021-07-22 | Trigg | Kentucky | 21221 | 1347 | 15 |
1538350 | 1538350 | 2021-07-21 | Trigg | Kentucky | 21221 | 1347 | 14 |
1535102 | 1535102 | 2021-07-20 | Trigg | Kentucky | 21221 | 1348 | 14 |
1531855 | 1531855 | 2021-07-19 | Trigg | Kentucky | 21221 | 1346 | 14 |
1528608 | 1528608 | 2021-07-18 | Trigg | Kentucky | 21221 | 1346 | 14 |
1525361 | 1525361 | 2021-07-17 | Trigg | Kentucky | 21221 | 1346 | 14 |
1522113 | 1522113 | 2021-07-16 | Trigg | Kentucky | 21221 | 1346 | 14 |
1518865 | 1518865 | 2021-07-15 | Trigg | Kentucky | 21221 | 1346 | 14 |
1515618 | 1515618 | 2021-07-14 | Trigg | Kentucky | 21221 | 1346 | 14 |
1512372 | 1512372 | 2021-07-13 | Trigg | Kentucky | 21221 | 1346 | 14 |
1509125 | 1509125 | 2021-07-12 | Trigg | Kentucky | 21221 | 1345 | 14 |
1505879 | 1505879 | 2021-07-11 | Trigg | Kentucky | 21221 | 1345 | 14 |
1502633 | 1502633 | 2021-07-10 | Trigg | Kentucky | 21221 | 1345 | 14 |
1499387 | 1499387 | 2021-07-09 | Trigg | Kentucky | 21221 | 1345 | 14 |
1496140 | 1496140 | 2021-07-08 | Trigg | Kentucky | 21221 | 1342 | 14 |
1492894 | 1492894 | 2021-07-07 | Trigg | Kentucky | 21221 | 1342 | 14 |
1489647 | 1489647 | 2021-07-06 | Trigg | Kentucky | 21221 | 1342 | 14 |
1486400 | 1486400 | 2021-07-05 | Trigg | Kentucky | 21221 | 1341 | 14 |
1483154 | 1483154 | 2021-07-04 | Trigg | Kentucky | 21221 | 1341 | 14 |
1479907 | 1479907 | 2021-07-03 | Trigg | Kentucky | 21221 | 1341 | 14 |
1476661 | 1476661 | 2021-07-02 | Trigg | Kentucky | 21221 | 1341 | 14 |
1473415 | 1473415 | 2021-07-01 | Trigg | Kentucky | 21221 | 1341 | 14 |
1470169 | 1470169 | 2021-06-30 | Trigg | Kentucky | 21221 | 1341 | 14 |
1466924 | 1466924 | 2021-06-29 | Trigg | Kentucky | 21221 | 1341 | 15 |
1463679 | 1463679 | 2021-06-28 | Trigg | Kentucky | 21221 | 1339 | 15 |
1460434 | 1460434 | 2021-06-27 | Trigg | Kentucky | 21221 | 1339 | 15 |
1457189 | 1457189 | 2021-06-26 | Trigg | Kentucky | 21221 | 1339 | 15 |
1453944 | 1453944 | 2021-06-25 | Trigg | Kentucky | 21221 | 1339 | 15 |
1450698 | 1450698 | 2021-06-24 | Trigg | Kentucky | 21221 | 1339 | 15 |
1447453 | 1447453 | 2021-06-23 | Trigg | Kentucky | 21221 | 1337 | 15 |
1444208 | 1444208 | 2021-06-22 | Trigg | Kentucky | 21221 | 1336 | 15 |
1440963 | 1440963 | 2021-06-21 | Trigg | Kentucky | 21221 | 1336 | 15 |
1437716 | 1437716 | 2021-06-20 | Trigg | Kentucky | 21221 | 1335 | 15 |
1434469 | 1434469 | 2021-06-19 | Trigg | Kentucky | 21221 | 1335 | 15 |
1431223 | 1431223 | 2021-06-18 | Trigg | Kentucky | 21221 | 1335 | 15 |
1427978 | 1427978 | 2021-06-17 | Trigg | Kentucky | 21221 | 1335 | 15 |
1424733 | 1424733 | 2021-06-16 | Trigg | Kentucky | 21221 | 1335 | 15 |
1421485 | 1421485 | 2021-06-15 | Trigg | Kentucky | 21221 | 1335 | 15 |
1418240 | 1418240 | 2021-06-14 | Trigg | Kentucky | 21221 | 1335 | 15 |
1414994 | 1414994 | 2021-06-13 | Trigg | Kentucky | 21221 | 1335 | 15 |
1411749 | 1411749 | 2021-06-12 | Trigg | Kentucky | 21221 | 1335 | 15 |
1408504 | 1408504 | 2021-06-11 | Trigg | Kentucky | 21221 | 1327 | 15 |
1405258 | 1405258 | 2021-06-10 | Trigg | Kentucky | 21221 | 1327 | 15 |
1402013 | 1402013 | 2021-06-09 | Trigg | Kentucky | 21221 | 1326 | 15 |
1398768 | 1398768 | 2021-06-08 | Trigg | Kentucky | 21221 | 1323 | 15 |
1395521 | 1395521 | 2021-06-07 | Trigg | Kentucky | 21221 | 1345 | 15 |
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);