ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where cases = 271 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1846770 | 1846770 | 2021-10-24 | Comanche | Kansas | 20033 | 271 | 12 |
1843520 | 1843520 | 2021-10-23 | Comanche | Kansas | 20033 | 271 | 12 |
1840270 | 1840270 | 2021-10-22 | Comanche | Kansas | 20033 | 271 | 12 |
1837042 | 1837042 | 2021-10-21 | Hamilton | Kansas | 20075 | 271 | 1 |
1833793 | 1833793 | 2021-10-20 | Hamilton | Kansas | 20075 | 271 | 1 |
1830600 | 1830600 | 2021-10-19 | Stanton | Kansas | 20187 | 271 | 6 |
1827351 | 1827351 | 2021-10-18 | Stanton | Kansas | 20187 | 271 | 6 |
1824102 | 1824102 | 2021-10-17 | Stanton | Kansas | 20187 | 271 | 6 |
1820853 | 1820853 | 2021-10-16 | Stanton | Kansas | 20187 | 271 | 6 |
1817604 | 1817604 | 2021-10-15 | Stanton | Kansas | 20187 | 271 | 6 |
1807789 | 1807789 | 2021-10-12 | Elk | Kansas | 20049 | 271 | 6 |
1804538 | 1804538 | 2021-10-11 | Elk | Kansas | 20049 | 271 | 6 |
1664864 | 1664864 | 2021-08-29 | Kiowa | Kansas | 20097 | 271 | 5 |
1661616 | 1661616 | 2021-08-28 | Kiowa | Kansas | 20097 | 271 | 5 |
1658368 | 1658368 | 2021-08-27 | Kiowa | Kansas | 20097 | 271 | 5 |
1655120 | 1655120 | 2021-08-26 | Kiowa | Kansas | 20097 | 271 | 5 |
1651873 | 1651873 | 2021-08-25 | Kiowa | Kansas | 20097 | 271 | 5 |
1648624 | 1648624 | 2021-08-24 | Kiowa | Kansas | 20097 | 271 | 5 |
1645376 | 1645376 | 2021-08-23 | Kiowa | Kansas | 20097 | 271 | 5 |
1642127 | 1642127 | 2021-08-22 | Kiowa | Kansas | 20097 | 271 | 5 |
1638877 | 1638877 | 2021-08-21 | Kiowa | Kansas | 20097 | 271 | 5 |
1635627 | 1635627 | 2021-08-20 | Kiowa | Kansas | 20097 | 271 | 5 |
1632377 | 1632377 | 2021-08-19 | Kiowa | Kansas | 20097 | 271 | 5 |
1629130 | 1629130 | 2021-08-18 | Kiowa | Kansas | 20097 | 271 | 5 |
1625883 | 1625883 | 2021-08-17 | Kiowa | Kansas | 20097 | 271 | 5 |
1622636 | 1622636 | 2021-08-16 | Kiowa | Kansas | 20097 | 271 | 5 |
1619389 | 1619389 | 2021-08-15 | Kiowa | Kansas | 20097 | 271 | 5 |
1616141 | 1616141 | 2021-08-14 | Kiowa | Kansas | 20097 | 271 | 5 |
1612892 | 1612892 | 2021-08-13 | Kiowa | Kansas | 20097 | 271 | 5 |
1609644 | 1609644 | 2021-08-12 | Kiowa | Kansas | 20097 | 271 | 5 |
1606395 | 1606395 | 2021-08-11 | Kiowa | Kansas | 20097 | 271 | 5 |
1603146 | 1603146 | 2021-08-10 | Kiowa | Kansas | 20097 | 271 | 5 |
1599897 | 1599897 | 2021-08-09 | Kiowa | Kansas | 20097 | 271 | 5 |
1596633 | 1596633 | 2021-08-08 | Graham | Kansas | 20065 | 271 | 9 |
1596649 | 1596649 | 2021-08-08 | Kiowa | Kansas | 20097 | 271 | 5 |
1593384 | 1593384 | 2021-08-07 | Graham | Kansas | 20065 | 271 | 9 |
1593400 | 1593400 | 2021-08-07 | Kiowa | Kansas | 20097 | 271 | 5 |
1590135 | 1590135 | 2021-08-06 | Graham | Kansas | 20065 | 271 | 9 |
1590151 | 1590151 | 2021-08-06 | Kiowa | Kansas | 20097 | 271 | 5 |
1586886 | 1586886 | 2021-08-05 | Graham | Kansas | 20065 | 271 | 9 |
1586902 | 1586902 | 2021-08-05 | Kiowa | Kansas | 20097 | 271 | 5 |
1583636 | 1583636 | 2021-08-04 | Graham | Kansas | 20065 | 271 | 9 |
1583652 | 1583652 | 2021-08-04 | Kiowa | Kansas | 20097 | 271 | 5 |
1580402 | 1580402 | 2021-08-03 | Kiowa | Kansas | 20097 | 271 | 5 |
1580406 | 1580406 | 2021-08-03 | Lincoln | Kansas | 20105 | 271 | 5 |
1577153 | 1577153 | 2021-08-02 | Kiowa | Kansas | 20097 | 271 | 5 |
1577157 | 1577157 | 2021-08-02 | Lincoln | Kansas | 20105 | 271 | 5 |
1573905 | 1573905 | 2021-08-01 | Kiowa | Kansas | 20097 | 271 | 5 |
1573909 | 1573909 | 2021-08-01 | Lincoln | Kansas | 20105 | 271 | 5 |
1570657 | 1570657 | 2021-07-31 | Kiowa | Kansas | 20097 | 271 | 5 |
1570661 | 1570661 | 2021-07-31 | Lincoln | Kansas | 20105 | 271 | 5 |
1567409 | 1567409 | 2021-07-30 | Kiowa | Kansas | 20097 | 271 | 5 |
1567413 | 1567413 | 2021-07-30 | Lincoln | Kansas | 20105 | 271 | 5 |
1564161 | 1564161 | 2021-07-29 | Kiowa | Kansas | 20097 | 271 | 5 |
1564165 | 1564165 | 2021-07-29 | Lincoln | Kansas | 20105 | 271 | 5 |
1560913 | 1560913 | 2021-07-28 | Kiowa | Kansas | 20097 | 271 | 5 |
1560917 | 1560917 | 2021-07-28 | Lincoln | Kansas | 20105 | 271 | 5 |
1557666 | 1557666 | 2021-07-27 | Kiowa | Kansas | 20097 | 271 | 5 |
1554419 | 1554419 | 2021-07-26 | Kiowa | Kansas | 20097 | 271 | 5 |
1551172 | 1551172 | 2021-07-25 | Kiowa | Kansas | 20097 | 271 | 5 |
1547925 | 1547925 | 2021-07-24 | Kiowa | Kansas | 20097 | 271 | 5 |
1544678 | 1544678 | 2021-07-23 | Kiowa | Kansas | 20097 | 271 | 5 |
1541430 | 1541430 | 2021-07-22 | Kiowa | Kansas | 20097 | 271 | 5 |
1538183 | 1538183 | 2021-07-21 | Kiowa | Kansas | 20097 | 271 | 5 |
1534935 | 1534935 | 2021-07-20 | Kiowa | Kansas | 20097 | 271 | 5 |
1531688 | 1531688 | 2021-07-19 | Kiowa | Kansas | 20097 | 271 | 5 |
1528441 | 1528441 | 2021-07-18 | Kiowa | Kansas | 20097 | 271 | 5 |
1525194 | 1525194 | 2021-07-17 | Kiowa | Kansas | 20097 | 271 | 5 |
1521946 | 1521946 | 2021-07-16 | Kiowa | Kansas | 20097 | 271 | 5 |
1518698 | 1518698 | 2021-07-15 | Kiowa | Kansas | 20097 | 271 | 5 |
1518714 | 1518714 | 2021-07-15 | Morton | Kansas | 20129 | 271 | 9 |
1515451 | 1515451 | 2021-07-14 | Kiowa | Kansas | 20097 | 271 | 5 |
1515467 | 1515467 | 2021-07-14 | Morton | Kansas | 20129 | 271 | 9 |
1512205 | 1512205 | 2021-07-13 | Kiowa | Kansas | 20097 | 271 | 5 |
1512221 | 1512221 | 2021-07-13 | Morton | Kansas | 20129 | 271 | 9 |
1508958 | 1508958 | 2021-07-12 | Kiowa | Kansas | 20097 | 271 | 5 |
1508974 | 1508974 | 2021-07-12 | Morton | Kansas | 20129 | 271 | 9 |
1505712 | 1505712 | 2021-07-11 | Kiowa | Kansas | 20097 | 271 | 5 |
1505728 | 1505728 | 2021-07-11 | Morton | Kansas | 20129 | 271 | 9 |
1502466 | 1502466 | 2021-07-10 | Kiowa | Kansas | 20097 | 271 | 5 |
1502482 | 1502482 | 2021-07-10 | Morton | Kansas | 20129 | 271 | 9 |
1499220 | 1499220 | 2021-07-09 | Kiowa | Kansas | 20097 | 271 | 5 |
1499236 | 1499236 | 2021-07-09 | Morton | Kansas | 20129 | 271 | 9 |
1495973 | 1495973 | 2021-07-08 | Kiowa | Kansas | 20097 | 271 | 5 |
1495989 | 1495989 | 2021-07-08 | Morton | Kansas | 20129 | 271 | 9 |
1492727 | 1492727 | 2021-07-07 | Kiowa | Kansas | 20097 | 271 | 5 |
1492743 | 1492743 | 2021-07-07 | Morton | Kansas | 20129 | 271 | 9 |
1489480 | 1489480 | 2021-07-06 | Kiowa | Kansas | 20097 | 271 | 5 |
1486233 | 1486233 | 2021-07-05 | Kiowa | Kansas | 20097 | 271 | 5 |
1482987 | 1482987 | 2021-07-04 | Kiowa | Kansas | 20097 | 271 | 5 |
1479740 | 1479740 | 2021-07-03 | Kiowa | Kansas | 20097 | 271 | 5 |
1476494 | 1476494 | 2021-07-02 | Kiowa | Kansas | 20097 | 271 | 5 |
1473209 | 1473209 | 2021-07-01 | Chautauqua | Kansas | 20019 | 271 | 6 |
1473248 | 1473248 | 2021-07-01 | Kiowa | Kansas | 20097 | 271 | 5 |
1469963 | 1469963 | 2021-06-30 | Chautauqua | Kansas | 20019 | 271 | 6 |
1470002 | 1470002 | 2021-06-30 | Kiowa | Kansas | 20097 | 271 | 5 |
1466718 | 1466718 | 2021-06-29 | Chautauqua | Kansas | 20019 | 271 | 6 |
1466757 | 1466757 | 2021-06-29 | Kiowa | Kansas | 20097 | 271 | 5 |
1463473 | 1463473 | 2021-06-28 | Chautauqua | Kansas | 20019 | 271 | 6 |
1463512 | 1463512 | 2021-06-28 | Kiowa | Kansas | 20097 | 271 | 5 |
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);