ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 20085 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716831 | 1716831 | 2021-09-14 | Jackson | Kansas | 20085 | 1821 | 19 |
1713585 | 1713585 | 2021-09-13 | Jackson | Kansas | 20085 | 1821 | 19 |
1710338 | 1710338 | 2021-09-12 | Jackson | Kansas | 20085 | 1817 | 19 |
1707091 | 1707091 | 2021-09-11 | Jackson | Kansas | 20085 | 1817 | 19 |
1703843 | 1703843 | 2021-09-10 | Jackson | Kansas | 20085 | 1817 | 19 |
1700593 | 1700593 | 2021-09-09 | Jackson | Kansas | 20085 | 1797 | 18 |
1697344 | 1697344 | 2021-09-08 | Jackson | Kansas | 20085 | 1797 | 18 |
1694096 | 1694096 | 2021-09-07 | Jackson | Kansas | 20085 | 1764 | 18 |
1690847 | 1690847 | 2021-09-06 | Jackson | Kansas | 20085 | 1764 | 18 |
1687597 | 1687597 | 2021-09-05 | Jackson | Kansas | 20085 | 1764 | 18 |
1684347 | 1684347 | 2021-09-04 | Jackson | Kansas | 20085 | 1764 | 18 |
1681096 | 1681096 | 2021-09-03 | Jackson | Kansas | 20085 | 1764 | 18 |
1677848 | 1677848 | 2021-09-02 | Jackson | Kansas | 20085 | 1743 | 18 |
1674601 | 1674601 | 2021-09-01 | Jackson | Kansas | 20085 | 1743 | 18 |
1671352 | 1671352 | 2021-08-31 | Jackson | Kansas | 20085 | 1709 | 18 |
1668105 | 1668105 | 2021-08-30 | Jackson | Kansas | 20085 | 1709 | 18 |
1664858 | 1664858 | 2021-08-29 | Jackson | Kansas | 20085 | 1680 | 18 |
1661610 | 1661610 | 2021-08-28 | Jackson | Kansas | 20085 | 1680 | 18 |
1658362 | 1658362 | 2021-08-27 | Jackson | Kansas | 20085 | 1680 | 18 |
1655114 | 1655114 | 2021-08-26 | Jackson | Kansas | 20085 | 1654 | 18 |
1651867 | 1651867 | 2021-08-25 | Jackson | Kansas | 20085 | 1654 | 18 |
1648618 | 1648618 | 2021-08-24 | Jackson | Kansas | 20085 | 1612 | 18 |
1645370 | 1645370 | 2021-08-23 | Jackson | Kansas | 20085 | 1612 | 18 |
1642121 | 1642121 | 2021-08-22 | Jackson | Kansas | 20085 | 1593 | 18 |
1638871 | 1638871 | 2021-08-21 | Jackson | Kansas | 20085 | 1593 | 18 |
1635621 | 1635621 | 2021-08-20 | Jackson | Kansas | 20085 | 1593 | 18 |
1632371 | 1632371 | 2021-08-19 | Jackson | Kansas | 20085 | 1582 | 17 |
1629124 | 1629124 | 2021-08-18 | Jackson | Kansas | 20085 | 1582 | 17 |
1625877 | 1625877 | 2021-08-17 | Jackson | Kansas | 20085 | 1560 | 17 |
1622630 | 1622630 | 2021-08-16 | Jackson | Kansas | 20085 | 1560 | 17 |
1619383 | 1619383 | 2021-08-15 | Jackson | Kansas | 20085 | 1549 | 17 |
1616135 | 1616135 | 2021-08-14 | Jackson | Kansas | 20085 | 1549 | 17 |
1612886 | 1612886 | 2021-08-13 | Jackson | Kansas | 20085 | 1549 | 17 |
1609638 | 1609638 | 2021-08-12 | Jackson | Kansas | 20085 | 1534 | 17 |
1606389 | 1606389 | 2021-08-11 | Jackson | Kansas | 20085 | 1534 | 17 |
1603140 | 1603140 | 2021-08-10 | Jackson | Kansas | 20085 | 1522 | 17 |
1599891 | 1599891 | 2021-08-09 | Jackson | Kansas | 20085 | 1522 | 17 |
1596643 | 1596643 | 2021-08-08 | Jackson | Kansas | 20085 | 1509 | 17 |
1593394 | 1593394 | 2021-08-07 | Jackson | Kansas | 20085 | 1509 | 17 |
1590145 | 1590145 | 2021-08-06 | Jackson | Kansas | 20085 | 1509 | 17 |
1586896 | 1586896 | 2021-08-05 | Jackson | Kansas | 20085 | 1497 | 17 |
1583646 | 1583646 | 2021-08-04 | Jackson | Kansas | 20085 | 1497 | 17 |
1580396 | 1580396 | 2021-08-03 | Jackson | Kansas | 20085 | 1487 | 17 |
1577147 | 1577147 | 2021-08-02 | Jackson | Kansas | 20085 | 1487 | 17 |
1573899 | 1573899 | 2021-08-01 | Jackson | Kansas | 20085 | 1479 | 17 |
1570651 | 1570651 | 2021-07-31 | Jackson | Kansas | 20085 | 1479 | 17 |
1567403 | 1567403 | 2021-07-30 | Jackson | Kansas | 20085 | 1479 | 17 |
1564155 | 1564155 | 2021-07-29 | Jackson | Kansas | 20085 | 1469 | 17 |
1560907 | 1560907 | 2021-07-28 | Jackson | Kansas | 20085 | 1469 | 17 |
1557660 | 1557660 | 2021-07-27 | Jackson | Kansas | 20085 | 1464 | 17 |
1554413 | 1554413 | 2021-07-26 | Jackson | Kansas | 20085 | 1464 | 17 |
1551166 | 1551166 | 2021-07-25 | Jackson | Kansas | 20085 | 1456 | 17 |
1547919 | 1547919 | 2021-07-24 | Jackson | Kansas | 20085 | 1456 | 17 |
1544672 | 1544672 | 2021-07-23 | Jackson | Kansas | 20085 | 1456 | 17 |
1541424 | 1541424 | 2021-07-22 | Jackson | Kansas | 20085 | 1446 | 17 |
1538177 | 1538177 | 2021-07-21 | Jackson | Kansas | 20085 | 1446 | 17 |
1534929 | 1534929 | 2021-07-20 | Jackson | Kansas | 20085 | 1437 | 17 |
1531682 | 1531682 | 2021-07-19 | Jackson | Kansas | 20085 | 1437 | 17 |
1528435 | 1528435 | 2021-07-18 | Jackson | Kansas | 20085 | 1433 | 17 |
1525188 | 1525188 | 2021-07-17 | Jackson | Kansas | 20085 | 1433 | 17 |
1521940 | 1521940 | 2021-07-16 | Jackson | Kansas | 20085 | 1433 | 17 |
1518692 | 1518692 | 2021-07-15 | Jackson | Kansas | 20085 | 1426 | 17 |
1515445 | 1515445 | 2021-07-14 | Jackson | Kansas | 20085 | 1426 | 17 |
1512199 | 1512199 | 2021-07-13 | Jackson | Kansas | 20085 | 1426 | 17 |
1508952 | 1508952 | 2021-07-12 | Jackson | Kansas | 20085 | 1426 | 17 |
1505706 | 1505706 | 2021-07-11 | Jackson | Kansas | 20085 | 1423 | 17 |
1502460 | 1502460 | 2021-07-10 | Jackson | Kansas | 20085 | 1423 | 17 |
1499214 | 1499214 | 2021-07-09 | Jackson | Kansas | 20085 | 1423 | 17 |
1495967 | 1495967 | 2021-07-08 | Jackson | Kansas | 20085 | 1418 | 17 |
1492721 | 1492721 | 2021-07-07 | Jackson | Kansas | 20085 | 1418 | 17 |
1489474 | 1489474 | 2021-07-06 | Jackson | Kansas | 20085 | 1419 | 17 |
1486227 | 1486227 | 2021-07-05 | Jackson | Kansas | 20085 | 1419 | 17 |
1482981 | 1482981 | 2021-07-04 | Jackson | Kansas | 20085 | 1419 | 17 |
1479734 | 1479734 | 2021-07-03 | Jackson | Kansas | 20085 | 1419 | 17 |
1476488 | 1476488 | 2021-07-02 | Jackson | Kansas | 20085 | 1419 | 17 |
1473242 | 1473242 | 2021-07-01 | Jackson | Kansas | 20085 | 1419 | 17 |
1469996 | 1469996 | 2021-06-30 | Jackson | Kansas | 20085 | 1419 | 17 |
1466751 | 1466751 | 2021-06-29 | Jackson | Kansas | 20085 | 1418 | 16 |
1463506 | 1463506 | 2021-06-28 | Jackson | Kansas | 20085 | 1418 | 16 |
1460261 | 1460261 | 2021-06-27 | Jackson | Kansas | 20085 | 1417 | 16 |
1457016 | 1457016 | 2021-06-26 | Jackson | Kansas | 20085 | 1417 | 16 |
1453771 | 1453771 | 2021-06-25 | Jackson | Kansas | 20085 | 1417 | 16 |
1450525 | 1450525 | 2021-06-24 | Jackson | Kansas | 20085 | 1416 | 16 |
1447280 | 1447280 | 2021-06-23 | Jackson | Kansas | 20085 | 1416 | 16 |
1444035 | 1444035 | 2021-06-22 | Jackson | Kansas | 20085 | 1416 | 16 |
1440790 | 1440790 | 2021-06-21 | Jackson | Kansas | 20085 | 1416 | 16 |
1437543 | 1437543 | 2021-06-20 | Jackson | Kansas | 20085 | 1416 | 16 |
1434296 | 1434296 | 2021-06-19 | Jackson | Kansas | 20085 | 1416 | 16 |
1431050 | 1431050 | 2021-06-18 | Jackson | Kansas | 20085 | 1416 | 16 |
1427805 | 1427805 | 2021-06-17 | Jackson | Kansas | 20085 | 1418 | 16 |
1424560 | 1424560 | 2021-06-16 | Jackson | Kansas | 20085 | 1418 | 16 |
1421312 | 1421312 | 2021-06-15 | Jackson | Kansas | 20085 | 1417 | 16 |
1418067 | 1418067 | 2021-06-14 | Jackson | Kansas | 20085 | 1417 | 16 |
1414821 | 1414821 | 2021-06-13 | Jackson | Kansas | 20085 | 1416 | 16 |
1411576 | 1411576 | 2021-06-12 | Jackson | Kansas | 20085 | 1416 | 16 |
1408331 | 1408331 | 2021-06-11 | Jackson | Kansas | 20085 | 1416 | 16 |
1405085 | 1405085 | 2021-06-10 | Jackson | Kansas | 20085 | 1413 | 16 |
1401840 | 1401840 | 2021-06-09 | Jackson | Kansas | 20085 | 1413 | 16 |
1398595 | 1398595 | 2021-06-08 | Jackson | Kansas | 20085 | 1413 | 16 |
1395348 | 1395348 | 2021-06-07 | Jackson | Kansas | 20085 | 1413 | 16 |
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);