ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Clay" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1824022 | 1824022 | 2021-10-17 | Clay | Kansas | 20027 | 1204 | 31 |
1820773 | 1820773 | 2021-10-16 | Clay | Kansas | 20027 | 1204 | 31 |
1817524 | 1817524 | 2021-10-15 | Clay | Kansas | 20027 | 1204 | 31 |
1814276 | 1814276 | 2021-10-14 | Clay | Kansas | 20027 | 1199 | 31 |
1811027 | 1811027 | 2021-10-13 | Clay | Kansas | 20027 | 1199 | 31 |
1807778 | 1807778 | 2021-10-12 | Clay | Kansas | 20027 | 1183 | 31 |
1804527 | 1804527 | 2021-10-11 | Clay | Kansas | 20027 | 1183 | 31 |
1801278 | 1801278 | 2021-10-10 | Clay | Kansas | 20027 | 1170 | 31 |
1798029 | 1798029 | 2021-10-09 | Clay | Kansas | 20027 | 1170 | 31 |
1794780 | 1794780 | 2021-10-08 | Clay | Kansas | 20027 | 1170 | 31 |
1791532 | 1791532 | 2021-10-07 | Clay | Kansas | 20027 | 1161 | 31 |
1788283 | 1788283 | 2021-10-06 | Clay | Kansas | 20027 | 1161 | 31 |
1785034 | 1785034 | 2021-10-05 | Clay | Kansas | 20027 | 1149 | 31 |
1781785 | 1781785 | 2021-10-04 | Clay | Kansas | 20027 | 1149 | 31 |
1778535 | 1778535 | 2021-10-03 | Clay | Kansas | 20027 | 1147 | 31 |
1775285 | 1775285 | 2021-10-02 | Clay | Kansas | 20027 | 1147 | 31 |
1772035 | 1772035 | 2021-10-01 | Clay | Kansas | 20027 | 1147 | 31 |
1768786 | 1768786 | 2021-09-30 | Clay | Kansas | 20027 | 1138 | 31 |
1765537 | 1765537 | 2021-09-29 | Clay | Kansas | 20027 | 1138 | 31 |
1762288 | 1762288 | 2021-09-28 | Clay | Kansas | 20027 | 1126 | 31 |
1759040 | 1759040 | 2021-09-27 | Clay | Kansas | 20027 | 1126 | 31 |
1755792 | 1755792 | 2021-09-26 | Clay | Kansas | 20027 | 1122 | 31 |
1752544 | 1752544 | 2021-09-25 | Clay | Kansas | 20027 | 1122 | 31 |
1749295 | 1749295 | 2021-09-24 | Clay | Kansas | 20027 | 1122 | 31 |
1746045 | 1746045 | 2021-09-23 | Clay | Kansas | 20027 | 1114 | 31 |
1742796 | 1742796 | 2021-09-22 | Clay | Kansas | 20027 | 1114 | 31 |
1739547 | 1739547 | 2021-09-21 | Clay | Kansas | 20027 | 1104 | 31 |
1736298 | 1736298 | 2021-09-20 | Clay | Kansas | 20027 | 1104 | 31 |
1733048 | 1733048 | 2021-09-19 | Clay | Kansas | 20027 | 1099 | 31 |
1729798 | 1729798 | 2021-09-18 | Clay | Kansas | 20027 | 1099 | 31 |
1726548 | 1726548 | 2021-09-17 | Clay | Kansas | 20027 | 1099 | 31 |
1723299 | 1723299 | 2021-09-16 | Clay | Kansas | 20027 | 1084 | 31 |
1720050 | 1720050 | 2021-09-15 | Clay | Kansas | 20027 | 1084 | 31 |
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 |
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);