ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lyon" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811069 | 1811069 | 2021-10-13 | Lyon | Kansas | 20111 | 5338 | 91 |
1807820 | 1807820 | 2021-10-12 | Lyon | Kansas | 20111 | 5313 | 91 |
1804569 | 1804569 | 2021-10-11 | Lyon | Kansas | 20111 | 5313 | 91 |
1801320 | 1801320 | 2021-10-10 | Lyon | Kansas | 20111 | 5306 | 91 |
1798071 | 1798071 | 2021-10-09 | Lyon | Kansas | 20111 | 5306 | 91 |
1794822 | 1794822 | 2021-10-08 | Lyon | Kansas | 20111 | 5306 | 91 |
1791574 | 1791574 | 2021-10-07 | Lyon | Kansas | 20111 | 5282 | 91 |
1788325 | 1788325 | 2021-10-06 | Lyon | Kansas | 20111 | 5282 | 91 |
1785076 | 1785076 | 2021-10-05 | Lyon | Kansas | 20111 | 5249 | 91 |
1781827 | 1781827 | 2021-10-04 | Lyon | Kansas | 20111 | 5249 | 91 |
1778577 | 1778577 | 2021-10-03 | Lyon | Kansas | 20111 | 5227 | 91 |
1775327 | 1775327 | 2021-10-02 | Lyon | Kansas | 20111 | 5227 | 91 |
1772077 | 1772077 | 2021-10-01 | Lyon | Kansas | 20111 | 5227 | 91 |
1768828 | 1768828 | 2021-09-30 | Lyon | Kansas | 20111 | 5209 | 91 |
1765579 | 1765579 | 2021-09-29 | Lyon | Kansas | 20111 | 5209 | 91 |
1762330 | 1762330 | 2021-09-28 | Lyon | Kansas | 20111 | 5190 | 91 |
1759082 | 1759082 | 2021-09-27 | Lyon | Kansas | 20111 | 5190 | 91 |
1755834 | 1755834 | 2021-09-26 | Lyon | Kansas | 20111 | 5171 | 91 |
1752586 | 1752586 | 2021-09-25 | Lyon | Kansas | 20111 | 5171 | 91 |
1749337 | 1749337 | 2021-09-24 | Lyon | Kansas | 20111 | 5171 | 91 |
1746087 | 1746087 | 2021-09-23 | Lyon | Kansas | 20111 | 5135 | 90 |
1742838 | 1742838 | 2021-09-22 | Lyon | Kansas | 20111 | 5135 | 90 |
1739589 | 1739589 | 2021-09-21 | Lyon | Kansas | 20111 | 5114 | 90 |
1736340 | 1736340 | 2021-09-20 | Lyon | Kansas | 20111 | 5114 | 90 |
1733090 | 1733090 | 2021-09-19 | Lyon | Kansas | 20111 | 5090 | 90 |
1729840 | 1729840 | 2021-09-18 | Lyon | Kansas | 20111 | 5090 | 90 |
1726590 | 1726590 | 2021-09-17 | Lyon | Kansas | 20111 | 5090 | 90 |
1723341 | 1723341 | 2021-09-16 | Lyon | Kansas | 20111 | 5050 | 90 |
1720092 | 1720092 | 2021-09-15 | Lyon | Kansas | 20111 | 5050 | 90 |
1716844 | 1716844 | 2021-09-14 | Lyon | Kansas | 20111 | 5005 | 89 |
1713598 | 1713598 | 2021-09-13 | Lyon | Kansas | 20111 | 5005 | 89 |
1710351 | 1710351 | 2021-09-12 | Lyon | Kansas | 20111 | 4967 | 89 |
1707104 | 1707104 | 2021-09-11 | Lyon | Kansas | 20111 | 4967 | 89 |
1703856 | 1703856 | 2021-09-10 | Lyon | Kansas | 20111 | 4967 | 89 |
1700606 | 1700606 | 2021-09-09 | Lyon | Kansas | 20111 | 4922 | 89 |
1697357 | 1697357 | 2021-09-08 | Lyon | Kansas | 20111 | 4922 | 89 |
1694109 | 1694109 | 2021-09-07 | Lyon | Kansas | 20111 | 4864 | 89 |
1690860 | 1690860 | 2021-09-06 | Lyon | Kansas | 20111 | 4864 | 89 |
1687610 | 1687610 | 2021-09-05 | Lyon | Kansas | 20111 | 4864 | 89 |
1684360 | 1684360 | 2021-09-04 | Lyon | Kansas | 20111 | 4864 | 89 |
1681109 | 1681109 | 2021-09-03 | Lyon | Kansas | 20111 | 4864 | 89 |
1677861 | 1677861 | 2021-09-02 | Lyon | Kansas | 20111 | 4833 | 88 |
1674614 | 1674614 | 2021-09-01 | Lyon | Kansas | 20111 | 4833 | 88 |
1671365 | 1671365 | 2021-08-31 | Lyon | Kansas | 20111 | 4794 | 88 |
1668118 | 1668118 | 2021-08-30 | Lyon | Kansas | 20111 | 4794 | 88 |
1664871 | 1664871 | 2021-08-29 | Lyon | Kansas | 20111 | 4776 | 88 |
1661623 | 1661623 | 2021-08-28 | Lyon | Kansas | 20111 | 4776 | 88 |
1658375 | 1658375 | 2021-08-27 | Lyon | Kansas | 20111 | 4776 | 88 |
1655127 | 1655127 | 2021-08-26 | Lyon | Kansas | 20111 | 4731 | 88 |
1651880 | 1651880 | 2021-08-25 | Lyon | Kansas | 20111 | 4731 | 88 |
1648631 | 1648631 | 2021-08-24 | Lyon | Kansas | 20111 | 4690 | 88 |
1645383 | 1645383 | 2021-08-23 | Lyon | Kansas | 20111 | 4690 | 88 |
1642134 | 1642134 | 2021-08-22 | Lyon | Kansas | 20111 | 4667 | 88 |
1638884 | 1638884 | 2021-08-21 | Lyon | Kansas | 20111 | 4667 | 88 |
1635634 | 1635634 | 2021-08-20 | Lyon | Kansas | 20111 | 4667 | 88 |
1632384 | 1632384 | 2021-08-19 | Lyon | Kansas | 20111 | 4646 | 88 |
1629137 | 1629137 | 2021-08-18 | Lyon | Kansas | 20111 | 4646 | 88 |
1625890 | 1625890 | 2021-08-17 | Lyon | Kansas | 20111 | 4618 | 88 |
1622643 | 1622643 | 2021-08-16 | Lyon | Kansas | 20111 | 4618 | 88 |
1619396 | 1619396 | 2021-08-15 | Lyon | Kansas | 20111 | 4598 | 88 |
1616148 | 1616148 | 2021-08-14 | Lyon | Kansas | 20111 | 4598 | 88 |
1612899 | 1612899 | 2021-08-13 | Lyon | Kansas | 20111 | 4598 | 88 |
1609651 | 1609651 | 2021-08-12 | Lyon | Kansas | 20111 | 4551 | 88 |
1606402 | 1606402 | 2021-08-11 | Lyon | Kansas | 20111 | 4551 | 88 |
1603153 | 1603153 | 2021-08-10 | Lyon | Kansas | 20111 | 4510 | 87 |
1599904 | 1599904 | 2021-08-09 | Lyon | Kansas | 20111 | 4510 | 87 |
1596656 | 1596656 | 2021-08-08 | Lyon | Kansas | 20111 | 4471 | 87 |
1593407 | 1593407 | 2021-08-07 | Lyon | Kansas | 20111 | 4471 | 87 |
1590158 | 1590158 | 2021-08-06 | Lyon | Kansas | 20111 | 4471 | 87 |
1586909 | 1586909 | 2021-08-05 | Lyon | Kansas | 20111 | 4455 | 87 |
1583659 | 1583659 | 2021-08-04 | Lyon | Kansas | 20111 | 4455 | 87 |
1580409 | 1580409 | 2021-08-03 | Lyon | Kansas | 20111 | 4435 | 87 |
1577160 | 1577160 | 2021-08-02 | Lyon | Kansas | 20111 | 4435 | 88 |
1573912 | 1573912 | 2021-08-01 | Lyon | Kansas | 20111 | 4432 | 88 |
1570664 | 1570664 | 2021-07-31 | Lyon | Kansas | 20111 | 4432 | 88 |
1567416 | 1567416 | 2021-07-30 | Lyon | Kansas | 20111 | 4432 | 88 |
1564168 | 1564168 | 2021-07-29 | Lyon | Kansas | 20111 | 4423 | 88 |
1560920 | 1560920 | 2021-07-28 | Lyon | Kansas | 20111 | 4423 | 88 |
1557673 | 1557673 | 2021-07-27 | Lyon | Kansas | 20111 | 4404 | 88 |
1554426 | 1554426 | 2021-07-26 | Lyon | Kansas | 20111 | 4404 | 88 |
1551179 | 1551179 | 2021-07-25 | Lyon | Kansas | 20111 | 4401 | 88 |
1547932 | 1547932 | 2021-07-24 | Lyon | Kansas | 20111 | 4401 | 88 |
1544685 | 1544685 | 2021-07-23 | Lyon | Kansas | 20111 | 4401 | 88 |
1541437 | 1541437 | 2021-07-22 | Lyon | Kansas | 20111 | 4387 | 86 |
1538190 | 1538190 | 2021-07-21 | Lyon | Kansas | 20111 | 4387 | 86 |
1534942 | 1534942 | 2021-07-20 | Lyon | Kansas | 20111 | 4379 | 86 |
1531695 | 1531695 | 2021-07-19 | Lyon | Kansas | 20111 | 4379 | 86 |
1528448 | 1528448 | 2021-07-18 | Lyon | Kansas | 20111 | 4378 | 86 |
1525201 | 1525201 | 2021-07-17 | Lyon | Kansas | 20111 | 4378 | 86 |
1521953 | 1521953 | 2021-07-16 | Lyon | Kansas | 20111 | 4378 | 86 |
1518705 | 1518705 | 2021-07-15 | Lyon | Kansas | 20111 | 4348 | 86 |
1515458 | 1515458 | 2021-07-14 | Lyon | Kansas | 20111 | 4348 | 86 |
1512212 | 1512212 | 2021-07-13 | Lyon | Kansas | 20111 | 4348 | 86 |
1508965 | 1508965 | 2021-07-12 | Lyon | Kansas | 20111 | 4348 | 86 |
1505719 | 1505719 | 2021-07-11 | Lyon | Kansas | 20111 | 4339 | 86 |
1502473 | 1502473 | 2021-07-10 | Lyon | Kansas | 20111 | 4339 | 86 |
1499227 | 1499227 | 2021-07-09 | Lyon | Kansas | 20111 | 4339 | 86 |
1495980 | 1495980 | 2021-07-08 | Lyon | Kansas | 20111 | 4335 | 86 |
1492734 | 1492734 | 2021-07-07 | Lyon | Kansas | 20111 | 4335 | 86 |
1489487 | 1489487 | 2021-07-06 | Lyon | Kansas | 20111 | 4329 | 86 |
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);