ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 20027 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716802 | 1716802 | 2021-09-14 | Clay | Kansas | 20027 | 1058 | 31 |
1713556 | 1713556 | 2021-09-13 | Clay | Kansas | 20027 | 1058 | 31 |
1710309 | 1710309 | 2021-09-12 | Clay | Kansas | 20027 | 1045 | 31 |
1707062 | 1707062 | 2021-09-11 | Clay | Kansas | 20027 | 1045 | 31 |
1703814 | 1703814 | 2021-09-10 | Clay | Kansas | 20027 | 1045 | 31 |
1700564 | 1700564 | 2021-09-09 | Clay | Kansas | 20027 | 1026 | 31 |
1697315 | 1697315 | 2021-09-08 | Clay | Kansas | 20027 | 1026 | 31 |
1694067 | 1694067 | 2021-09-07 | Clay | Kansas | 20027 | 988 | 31 |
1690818 | 1690818 | 2021-09-06 | Clay | Kansas | 20027 | 988 | 31 |
1687568 | 1687568 | 2021-09-05 | Clay | Kansas | 20027 | 988 | 31 |
1684318 | 1684318 | 2021-09-04 | Clay | Kansas | 20027 | 988 | 31 |
1681067 | 1681067 | 2021-09-03 | Clay | Kansas | 20027 | 988 | 31 |
1677819 | 1677819 | 2021-09-02 | Clay | Kansas | 20027 | 975 | 31 |
1674572 | 1674572 | 2021-09-01 | Clay | Kansas | 20027 | 975 | 31 |
1671323 | 1671323 | 2021-08-31 | Clay | Kansas | 20027 | 942 | 31 |
1668076 | 1668076 | 2021-08-30 | Clay | Kansas | 20027 | 942 | 31 |
1664829 | 1664829 | 2021-08-29 | Clay | Kansas | 20027 | 929 | 31 |
1661581 | 1661581 | 2021-08-28 | Clay | Kansas | 20027 | 929 | 31 |
1658333 | 1658333 | 2021-08-27 | Clay | Kansas | 20027 | 929 | 31 |
1655085 | 1655085 | 2021-08-26 | Clay | Kansas | 20027 | 924 | 31 |
1651838 | 1651838 | 2021-08-25 | Clay | Kansas | 20027 | 924 | 31 |
1648589 | 1648589 | 2021-08-24 | Clay | Kansas | 20027 | 917 | 30 |
1645341 | 1645341 | 2021-08-23 | Clay | Kansas | 20027 | 917 | 30 |
1642092 | 1642092 | 2021-08-22 | Clay | Kansas | 20027 | 913 | 30 |
1638842 | 1638842 | 2021-08-21 | Clay | Kansas | 20027 | 913 | 30 |
1635592 | 1635592 | 2021-08-20 | Clay | Kansas | 20027 | 913 | 30 |
1632342 | 1632342 | 2021-08-19 | Clay | Kansas | 20027 | 907 | 30 |
1629095 | 1629095 | 2021-08-18 | Clay | Kansas | 20027 | 907 | 30 |
1625848 | 1625848 | 2021-08-17 | Clay | Kansas | 20027 | 900 | 30 |
1622601 | 1622601 | 2021-08-16 | Clay | Kansas | 20027 | 900 | 30 |
1619354 | 1619354 | 2021-08-15 | Clay | Kansas | 20027 | 893 | 30 |
1616106 | 1616106 | 2021-08-14 | Clay | Kansas | 20027 | 893 | 30 |
1612857 | 1612857 | 2021-08-13 | Clay | Kansas | 20027 | 893 | 30 |
1609609 | 1609609 | 2021-08-12 | Clay | Kansas | 20027 | 892 | 30 |
1606360 | 1606360 | 2021-08-11 | Clay | Kansas | 20027 | 892 | 30 |
1603111 | 1603111 | 2021-08-10 | Clay | Kansas | 20027 | 883 | 30 |
1599862 | 1599862 | 2021-08-09 | Clay | Kansas | 20027 | 883 | 30 |
1596614 | 1596614 | 2021-08-08 | Clay | Kansas | 20027 | 878 | 30 |
1593365 | 1593365 | 2021-08-07 | Clay | Kansas | 20027 | 878 | 30 |
1590116 | 1590116 | 2021-08-06 | Clay | Kansas | 20027 | 878 | 30 |
1586867 | 1586867 | 2021-08-05 | Clay | Kansas | 20027 | 871 | 30 |
1583617 | 1583617 | 2021-08-04 | Clay | Kansas | 20027 | 871 | 30 |
1580367 | 1580367 | 2021-08-03 | Clay | Kansas | 20027 | 865 | 30 |
1577118 | 1577118 | 2021-08-02 | Clay | Kansas | 20027 | 865 | 30 |
1573870 | 1573870 | 2021-08-01 | Clay | Kansas | 20027 | 863 | 30 |
1570622 | 1570622 | 2021-07-31 | Clay | Kansas | 20027 | 863 | 30 |
1567374 | 1567374 | 2021-07-30 | Clay | Kansas | 20027 | 863 | 30 |
1564126 | 1564126 | 2021-07-29 | Clay | Kansas | 20027 | 859 | 30 |
1560878 | 1560878 | 2021-07-28 | Clay | Kansas | 20027 | 859 | 30 |
1557631 | 1557631 | 2021-07-27 | Clay | Kansas | 20027 | 846 | 30 |
1554384 | 1554384 | 2021-07-26 | Clay | Kansas | 20027 | 846 | 30 |
1551137 | 1551137 | 2021-07-25 | Clay | Kansas | 20027 | 842 | 30 |
1547890 | 1547890 | 2021-07-24 | Clay | Kansas | 20027 | 842 | 30 |
1544643 | 1544643 | 2021-07-23 | Clay | Kansas | 20027 | 842 | 30 |
1541395 | 1541395 | 2021-07-22 | Clay | Kansas | 20027 | 835 | 30 |
1538148 | 1538148 | 2021-07-21 | Clay | Kansas | 20027 | 835 | 30 |
1534900 | 1534900 | 2021-07-20 | Clay | Kansas | 20027 | 831 | 30 |
1531653 | 1531653 | 2021-07-19 | Clay | Kansas | 20027 | 831 | 30 |
1528406 | 1528406 | 2021-07-18 | Clay | Kansas | 20027 | 828 | 30 |
1525159 | 1525159 | 2021-07-17 | Clay | Kansas | 20027 | 828 | 30 |
1521911 | 1521911 | 2021-07-16 | Clay | Kansas | 20027 | 828 | 30 |
1518663 | 1518663 | 2021-07-15 | Clay | Kansas | 20027 | 826 | 30 |
1515416 | 1515416 | 2021-07-14 | Clay | Kansas | 20027 | 826 | 30 |
1512170 | 1512170 | 2021-07-13 | Clay | Kansas | 20027 | 826 | 30 |
1508923 | 1508923 | 2021-07-12 | Clay | Kansas | 20027 | 826 | 30 |
1505677 | 1505677 | 2021-07-11 | Clay | Kansas | 20027 | 826 | 30 |
1502431 | 1502431 | 2021-07-10 | Clay | Kansas | 20027 | 826 | 30 |
1499185 | 1499185 | 2021-07-09 | Clay | Kansas | 20027 | 826 | 30 |
1495938 | 1495938 | 2021-07-08 | Clay | Kansas | 20027 | 826 | 30 |
1492692 | 1492692 | 2021-07-07 | Clay | Kansas | 20027 | 826 | 30 |
1489445 | 1489445 | 2021-07-06 | Clay | Kansas | 20027 | 826 | 30 |
1486198 | 1486198 | 2021-07-05 | Clay | Kansas | 20027 | 826 | 30 |
1482952 | 1482952 | 2021-07-04 | Clay | Kansas | 20027 | 826 | 30 |
1479705 | 1479705 | 2021-07-03 | Clay | Kansas | 20027 | 826 | 30 |
1476459 | 1476459 | 2021-07-02 | Clay | Kansas | 20027 | 826 | 30 |
1473213 | 1473213 | 2021-07-01 | Clay | Kansas | 20027 | 826 | 30 |
1469967 | 1469967 | 2021-06-30 | Clay | Kansas | 20027 | 826 | 30 |
1466722 | 1466722 | 2021-06-29 | Clay | Kansas | 20027 | 826 | 30 |
1463477 | 1463477 | 2021-06-28 | Clay | Kansas | 20027 | 826 | 30 |
1460232 | 1460232 | 2021-06-27 | Clay | Kansas | 20027 | 826 | 30 |
1456987 | 1456987 | 2021-06-26 | Clay | Kansas | 20027 | 826 | 30 |
1453742 | 1453742 | 2021-06-25 | Clay | Kansas | 20027 | 826 | 30 |
1450496 | 1450496 | 2021-06-24 | Clay | Kansas | 20027 | 826 | 29 |
1447251 | 1447251 | 2021-06-23 | Clay | Kansas | 20027 | 826 | 29 |
1444006 | 1444006 | 2021-06-22 | Clay | Kansas | 20027 | 826 | 29 |
1440761 | 1440761 | 2021-06-21 | Clay | Kansas | 20027 | 826 | 29 |
1437514 | 1437514 | 2021-06-20 | Clay | Kansas | 20027 | 826 | 29 |
1434267 | 1434267 | 2021-06-19 | Clay | Kansas | 20027 | 826 | 29 |
1431021 | 1431021 | 2021-06-18 | Clay | Kansas | 20027 | 826 | 29 |
1427776 | 1427776 | 2021-06-17 | Clay | Kansas | 20027 | 826 | 29 |
1424531 | 1424531 | 2021-06-16 | Clay | Kansas | 20027 | 826 | 29 |
1421283 | 1421283 | 2021-06-15 | Clay | Kansas | 20027 | 826 | 29 |
1418038 | 1418038 | 2021-06-14 | Clay | Kansas | 20027 | 826 | 29 |
1414792 | 1414792 | 2021-06-13 | Clay | Kansas | 20027 | 826 | 29 |
1411547 | 1411547 | 2021-06-12 | Clay | Kansas | 20027 | 826 | 29 |
1408302 | 1408302 | 2021-06-11 | Clay | Kansas | 20027 | 826 | 29 |
1405056 | 1405056 | 2021-06-10 | Clay | Kansas | 20027 | 826 | 29 |
1401811 | 1401811 | 2021-06-09 | Clay | Kansas | 20027 | 826 | 29 |
1398566 | 1398566 | 2021-06-08 | Clay | Kansas | 20027 | 826 | 29 |
1395319 | 1395319 | 2021-06-07 | Clay | Kansas | 20027 | 826 | 29 |
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);