ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 21231 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717009 | 1717009 | 2021-09-14 | Wayne | Kentucky | 21231 | 2795 | 55 |
1713763 | 1713763 | 2021-09-13 | Wayne | Kentucky | 21231 | 2753 | 55 |
1710516 | 1710516 | 2021-09-12 | Wayne | Kentucky | 21231 | 2753 | 55 |
1707269 | 1707269 | 2021-09-11 | Wayne | Kentucky | 21231 | 2753 | 55 |
1704021 | 1704021 | 2021-09-10 | Wayne | Kentucky | 21231 | 2714 | 55 |
1700771 | 1700771 | 2021-09-09 | Wayne | Kentucky | 21231 | 2672 | 54 |
1697522 | 1697522 | 2021-09-08 | Wayne | Kentucky | 21231 | 2660 | 54 |
1694274 | 1694274 | 2021-09-07 | Wayne | Kentucky | 21231 | 2632 | 54 |
1691025 | 1691025 | 2021-09-06 | Wayne | Kentucky | 21231 | 2632 | 54 |
1687775 | 1687775 | 2021-09-05 | Wayne | Kentucky | 21231 | 2632 | 54 |
1684525 | 1684525 | 2021-09-04 | Wayne | Kentucky | 21231 | 2632 | 54 |
1681274 | 1681274 | 2021-09-03 | Wayne | Kentucky | 21231 | 2603 | 54 |
1678026 | 1678026 | 2021-09-02 | Wayne | Kentucky | 21231 | 2567 | 54 |
1674779 | 1674779 | 2021-09-01 | Wayne | Kentucky | 21231 | 2567 | 54 |
1671530 | 1671530 | 2021-08-31 | Wayne | Kentucky | 21231 | 2549 | 54 |
1668283 | 1668283 | 2021-08-30 | Wayne | Kentucky | 21231 | 2538 | 54 |
1665036 | 1665036 | 2021-08-29 | Wayne | Kentucky | 21231 | 2509 | 54 |
1661788 | 1661788 | 2021-08-28 | Wayne | Kentucky | 21231 | 2509 | 54 |
1658540 | 1658540 | 2021-08-27 | Wayne | Kentucky | 21231 | 2505 | 53 |
1655292 | 1655292 | 2021-08-26 | Wayne | Kentucky | 21231 | 2478 | 53 |
1652045 | 1652045 | 2021-08-25 | Wayne | Kentucky | 21231 | 2478 | 53 |
1648796 | 1648796 | 2021-08-24 | Wayne | Kentucky | 21231 | 2440 | 53 |
1645548 | 1645548 | 2021-08-23 | Wayne | Kentucky | 21231 | 2409 | 52 |
1642299 | 1642299 | 2021-08-22 | Wayne | Kentucky | 21231 | 2409 | 52 |
1639049 | 1639049 | 2021-08-21 | Wayne | Kentucky | 21231 | 2409 | 52 |
1635799 | 1635799 | 2021-08-20 | Wayne | Kentucky | 21231 | 2409 | 52 |
1632549 | 1632549 | 2021-08-19 | Wayne | Kentucky | 21231 | 2381 | 51 |
1629302 | 1629302 | 2021-08-18 | Wayne | Kentucky | 21231 | 2381 | 51 |
1626055 | 1626055 | 2021-08-17 | Wayne | Kentucky | 21231 | 2367 | 51 |
1622808 | 1622808 | 2021-08-16 | Wayne | Kentucky | 21231 | 2367 | 51 |
1619561 | 1619561 | 2021-08-15 | Wayne | Kentucky | 21231 | 2360 | 51 |
1616313 | 1616313 | 2021-08-14 | Wayne | Kentucky | 21231 | 2360 | 51 |
1613064 | 1613064 | 2021-08-13 | Wayne | Kentucky | 21231 | 2340 | 51 |
1609816 | 1609816 | 2021-08-12 | Wayne | Kentucky | 21231 | 2331 | 51 |
1606567 | 1606567 | 2021-08-11 | Wayne | Kentucky | 21231 | 2331 | 51 |
1603318 | 1603318 | 2021-08-10 | Wayne | Kentucky | 21231 | 2307 | 51 |
1600069 | 1600069 | 2021-08-09 | Wayne | Kentucky | 21231 | 2307 | 51 |
1596821 | 1596821 | 2021-08-08 | Wayne | Kentucky | 21231 | 2304 | 51 |
1593572 | 1593572 | 2021-08-07 | Wayne | Kentucky | 21231 | 2304 | 51 |
1590323 | 1590323 | 2021-08-06 | Wayne | Kentucky | 21231 | 2300 | 51 |
1587074 | 1587074 | 2021-08-05 | Wayne | Kentucky | 21231 | 2300 | 51 |
1583824 | 1583824 | 2021-08-04 | Wayne | Kentucky | 21231 | 2287 | 51 |
1580574 | 1580574 | 2021-08-03 | Wayne | Kentucky | 21231 | 2281 | 50 |
1577325 | 1577325 | 2021-08-02 | Wayne | Kentucky | 21231 | 2281 | 50 |
1574077 | 1574077 | 2021-08-01 | Wayne | Kentucky | 21231 | 2279 | 50 |
1570829 | 1570829 | 2021-07-31 | Wayne | Kentucky | 21231 | 2279 | 50 |
1567581 | 1567581 | 2021-07-30 | Wayne | Kentucky | 21231 | 2275 | 50 |
1564333 | 1564333 | 2021-07-29 | Wayne | Kentucky | 21231 | 2267 | 50 |
1561085 | 1561085 | 2021-07-28 | Wayne | Kentucky | 21231 | 2267 | 50 |
1557838 | 1557838 | 2021-07-27 | Wayne | Kentucky | 21231 | 2255 | 50 |
1554591 | 1554591 | 2021-07-26 | Wayne | Kentucky | 21231 | 2255 | 50 |
1551344 | 1551344 | 2021-07-25 | Wayne | Kentucky | 21231 | 2255 | 50 |
1548097 | 1548097 | 2021-07-24 | Wayne | Kentucky | 21231 | 2255 | 50 |
1544850 | 1544850 | 2021-07-23 | Wayne | Kentucky | 21231 | 2255 | 50 |
1541602 | 1541602 | 2021-07-22 | Wayne | Kentucky | 21231 | 2247 | 50 |
1538355 | 1538355 | 2021-07-21 | Wayne | Kentucky | 21231 | 2247 | 50 |
1535107 | 1535107 | 2021-07-20 | Wayne | Kentucky | 21231 | 2247 | 50 |
1531860 | 1531860 | 2021-07-19 | Wayne | Kentucky | 21231 | 2247 | 50 |
1528613 | 1528613 | 2021-07-18 | Wayne | Kentucky | 21231 | 2247 | 50 |
1525366 | 1525366 | 2021-07-17 | Wayne | Kentucky | 21231 | 2247 | 50 |
1522118 | 1522118 | 2021-07-16 | Wayne | Kentucky | 21231 | 2247 | 50 |
1518870 | 1518870 | 2021-07-15 | Wayne | Kentucky | 21231 | 2237 | 50 |
1515623 | 1515623 | 2021-07-14 | Wayne | Kentucky | 21231 | 2237 | 50 |
1512377 | 1512377 | 2021-07-13 | Wayne | Kentucky | 21231 | 2237 | 50 |
1509130 | 1509130 | 2021-07-12 | Wayne | Kentucky | 21231 | 2237 | 50 |
1505884 | 1505884 | 2021-07-11 | Wayne | Kentucky | 21231 | 2237 | 50 |
1502638 | 1502638 | 2021-07-10 | Wayne | Kentucky | 21231 | 2237 | 50 |
1499392 | 1499392 | 2021-07-09 | Wayne | Kentucky | 21231 | 2237 | 50 |
1496145 | 1496145 | 2021-07-08 | Wayne | Kentucky | 21231 | 2229 | 50 |
1492899 | 1492899 | 2021-07-07 | Wayne | Kentucky | 21231 | 2229 | 50 |
1489652 | 1489652 | 2021-07-06 | Wayne | Kentucky | 21231 | 2229 | 50 |
1486405 | 1486405 | 2021-07-05 | Wayne | Kentucky | 21231 | 2229 | 50 |
1483159 | 1483159 | 2021-07-04 | Wayne | Kentucky | 21231 | 2229 | 50 |
1479912 | 1479912 | 2021-07-03 | Wayne | Kentucky | 21231 | 2229 | 50 |
1476666 | 1476666 | 2021-07-02 | Wayne | Kentucky | 21231 | 2229 | 50 |
1473420 | 1473420 | 2021-07-01 | Wayne | Kentucky | 21231 | 2222 | 50 |
1470174 | 1470174 | 2021-06-30 | Wayne | Kentucky | 21231 | 2222 | 50 |
1466929 | 1466929 | 2021-06-29 | Wayne | Kentucky | 21231 | 2222 | 50 |
1463684 | 1463684 | 2021-06-28 | Wayne | Kentucky | 21231 | 2222 | 50 |
1460439 | 1460439 | 2021-06-27 | Wayne | Kentucky | 21231 | 2222 | 50 |
1457194 | 1457194 | 2021-06-26 | Wayne | Kentucky | 21231 | 2222 | 50 |
1453949 | 1453949 | 2021-06-25 | Wayne | Kentucky | 21231 | 2222 | 50 |
1450703 | 1450703 | 2021-06-24 | Wayne | Kentucky | 21231 | 2215 | 50 |
1447458 | 1447458 | 2021-06-23 | Wayne | Kentucky | 21231 | 2215 | 50 |
1444213 | 1444213 | 2021-06-22 | Wayne | Kentucky | 21231 | 2215 | 50 |
1440968 | 1440968 | 2021-06-21 | Wayne | Kentucky | 21231 | 2215 | 50 |
1437721 | 1437721 | 2021-06-20 | Wayne | Kentucky | 21231 | 2215 | 50 |
1434474 | 1434474 | 2021-06-19 | Wayne | Kentucky | 21231 | 2214 | 50 |
1431228 | 1431228 | 2021-06-18 | Wayne | Kentucky | 21231 | 2214 | 50 |
1427983 | 1427983 | 2021-06-17 | Wayne | Kentucky | 21231 | 2223 | 50 |
1424738 | 1424738 | 2021-06-16 | Wayne | Kentucky | 21231 | 2229 | 50 |
1421490 | 1421490 | 2021-06-15 | Wayne | Kentucky | 21231 | 2230 | 50 |
1418245 | 1418245 | 2021-06-14 | Wayne | Kentucky | 21231 | 2228 | 50 |
1414999 | 1414999 | 2021-06-13 | Wayne | Kentucky | 21231 | 2228 | 50 |
1411754 | 1411754 | 2021-06-12 | Wayne | Kentucky | 21231 | 2228 | 50 |
1408509 | 1408509 | 2021-06-11 | Wayne | Kentucky | 21231 | 2226 | 50 |
1405263 | 1405263 | 2021-06-10 | Wayne | Kentucky | 21231 | 2226 | 50 |
1402018 | 1402018 | 2021-06-09 | Wayne | Kentucky | 21231 | 2226 | 50 |
1398773 | 1398773 | 2021-06-08 | Wayne | Kentucky | 21231 | 2225 | 50 |
1395526 | 1395526 | 2021-06-07 | Wayne | Kentucky | 21231 | 2225 | 50 |
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);