ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Eagle" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810381 | 1810381 | 2021-10-13 | Eagle | Colorado | 8037 | 8082 | 31 |
1807132 | 1807132 | 2021-10-12 | Eagle | Colorado | 8037 | 8070 | 31 |
1803881 | 1803881 | 2021-10-11 | Eagle | Colorado | 8037 | 8058 | 31 |
1800632 | 1800632 | 2021-10-10 | Eagle | Colorado | 8037 | 8025 | 31 |
1797383 | 1797383 | 2021-10-09 | Eagle | Colorado | 8037 | 8025 | 31 |
1794134 | 1794134 | 2021-10-08 | Eagle | Colorado | 8037 | 8025 | 31 |
1790886 | 1790886 | 2021-10-07 | Eagle | Colorado | 8037 | 8003 | 31 |
1787637 | 1787637 | 2021-10-06 | Eagle | Colorado | 8037 | 7983 | 31 |
1784388 | 1784388 | 2021-10-05 | Eagle | Colorado | 8037 | 7971 | 31 |
1781139 | 1781139 | 2021-10-04 | Eagle | Colorado | 8037 | 7957 | 31 |
1777889 | 1777889 | 2021-10-03 | Eagle | Colorado | 8037 | 7914 | 31 |
1774639 | 1774639 | 2021-10-02 | Eagle | Colorado | 8037 | 7914 | 31 |
1771389 | 1771389 | 2021-10-01 | Eagle | Colorado | 8037 | 7914 | 31 |
1768140 | 1768140 | 2021-09-30 | Eagle | Colorado | 8037 | 7899 | 31 |
1764891 | 1764891 | 2021-09-29 | Eagle | Colorado | 8037 | 7886 | 31 |
1761642 | 1761642 | 2021-09-28 | Eagle | Colorado | 8037 | 7871 | 31 |
1758394 | 1758394 | 2021-09-27 | Eagle | Colorado | 8037 | 7848 | 31 |
1755146 | 1755146 | 2021-09-26 | Eagle | Colorado | 8037 | 7825 | 31 |
1751898 | 1751898 | 2021-09-25 | Eagle | Colorado | 8037 | 7825 | 31 |
1748649 | 1748649 | 2021-09-24 | Eagle | Colorado | 8037 | 7825 | 31 |
1745399 | 1745399 | 2021-09-23 | Eagle | Colorado | 8037 | 7807 | 30 |
1742150 | 1742150 | 2021-09-22 | Eagle | Colorado | 8037 | 7774 | 30 |
1738901 | 1738901 | 2021-09-21 | Eagle | Colorado | 8037 | 7769 | 30 |
1735652 | 1735652 | 2021-09-20 | Eagle | Colorado | 8037 | 7747 | 30 |
1732402 | 1732402 | 2021-09-19 | Eagle | Colorado | 8037 | 7715 | 29 |
1729152 | 1729152 | 2021-09-18 | Eagle | Colorado | 8037 | 7715 | 29 |
1725902 | 1725902 | 2021-09-17 | Eagle | Colorado | 8037 | 7715 | 29 |
1722653 | 1722653 | 2021-09-16 | Eagle | Colorado | 8037 | 7685 | 29 |
1719404 | 1719404 | 2021-09-15 | Eagle | Colorado | 8037 | 7670 | 29 |
1716156 | 1716156 | 2021-09-14 | Eagle | Colorado | 8037 | 7640 | 29 |
1712910 | 1712910 | 2021-09-13 | Eagle | Colorado | 8037 | 7621 | 29 |
1709663 | 1709663 | 2021-09-12 | Eagle | Colorado | 8037 | 7561 | 29 |
1706416 | 1706416 | 2021-09-11 | Eagle | Colorado | 8037 | 7561 | 29 |
1703168 | 1703168 | 2021-09-10 | Eagle | Colorado | 8037 | 7561 | 29 |
1699918 | 1699918 | 2021-09-09 | Eagle | Colorado | 8037 | 7517 | 29 |
1696669 | 1696669 | 2021-09-08 | Eagle | Colorado | 8037 | 7468 | 29 |
1693421 | 1693421 | 2021-09-07 | Eagle | Colorado | 8037 | 7445 | 29 |
1690172 | 1690172 | 2021-09-06 | Eagle | Colorado | 8037 | 7430 | 29 |
1686922 | 1686922 | 2021-09-05 | Eagle | Colorado | 8037 | 7356 | 29 |
1683672 | 1683672 | 2021-09-04 | Eagle | Colorado | 8037 | 7356 | 29 |
1680421 | 1680421 | 2021-09-03 | Eagle | Colorado | 8037 | 7356 | 29 |
1677173 | 1677173 | 2021-09-02 | Eagle | Colorado | 8037 | 7304 | 29 |
1673926 | 1673926 | 2021-09-01 | Eagle | Colorado | 8037 | 7260 | 29 |
1670678 | 1670678 | 2021-08-31 | Eagle | Colorado | 8037 | 7220 | 28 |
1667431 | 1667431 | 2021-08-30 | Eagle | Colorado | 8037 | 7160 | 28 |
1664184 | 1664184 | 2021-08-29 | Eagle | Colorado | 8037 | 7114 | 28 |
1660936 | 1660936 | 2021-08-28 | Eagle | Colorado | 8037 | 7114 | 28 |
1657688 | 1657688 | 2021-08-27 | Eagle | Colorado | 8037 | 7114 | 28 |
1654440 | 1654440 | 2021-08-26 | Eagle | Colorado | 8037 | 7094 | 28 |
1651193 | 1651193 | 2021-08-25 | Eagle | Colorado | 8037 | 7052 | 29 |
1647944 | 1647944 | 2021-08-24 | Eagle | Colorado | 8037 | 7030 | 26 |
1644696 | 1644696 | 2021-08-23 | Eagle | Colorado | 8037 | 6991 | 26 |
1641446 | 1641446 | 2021-08-22 | Eagle | Colorado | 8037 | 6971 | 26 |
1638196 | 1638196 | 2021-08-21 | Eagle | Colorado | 8037 | 6971 | 26 |
1634946 | 1634946 | 2021-08-20 | Eagle | Colorado | 8037 | 6971 | 26 |
1631697 | 1631697 | 2021-08-19 | Eagle | Colorado | 8037 | 6929 | 26 |
1628450 | 1628450 | 2021-08-18 | Eagle | Colorado | 8037 | 6912 | 26 |
1625203 | 1625203 | 2021-08-17 | Eagle | Colorado | 8037 | 6865 | 26 |
1621956 | 1621956 | 2021-08-16 | Eagle | Colorado | 8037 | 6816 | 26 |
1618709 | 1618709 | 2021-08-15 | Eagle | Colorado | 8037 | 6742 | 26 |
1615461 | 1615461 | 2021-08-14 | Eagle | Colorado | 8037 | 6742 | 26 |
1612212 | 1612212 | 2021-08-13 | Eagle | Colorado | 8037 | 6742 | 26 |
1608964 | 1608964 | 2021-08-12 | Eagle | Colorado | 8037 | 6723 | 26 |
1605715 | 1605715 | 2021-08-11 | Eagle | Colorado | 8037 | 6707 | 24 |
1602466 | 1602466 | 2021-08-10 | Eagle | Colorado | 8037 | 6668 | 23 |
1599217 | 1599217 | 2021-08-09 | Eagle | Colorado | 8037 | 6645 | 23 |
1595968 | 1595968 | 2021-08-08 | Eagle | Colorado | 8037 | 6622 | 23 |
1592719 | 1592719 | 2021-08-07 | Eagle | Colorado | 8037 | 6622 | 23 |
1589470 | 1589470 | 2021-08-06 | Eagle | Colorado | 8037 | 6622 | 23 |
1586221 | 1586221 | 2021-08-05 | Eagle | Colorado | 8037 | 6599 | 23 |
1582971 | 1582971 | 2021-08-04 | Eagle | Colorado | 8037 | 6585 | 23 |
1579721 | 1579721 | 2021-08-03 | Eagle | Colorado | 8037 | 6561 | 23 |
1576473 | 1576473 | 2021-08-02 | Eagle | Colorado | 8037 | 6551 | 23 |
1573225 | 1573225 | 2021-08-01 | Eagle | Colorado | 8037 | 6527 | 23 |
1569977 | 1569977 | 2021-07-31 | Eagle | Colorado | 8037 | 6527 | 23 |
1566729 | 1566729 | 2021-07-30 | Eagle | Colorado | 8037 | 6527 | 23 |
1563481 | 1563481 | 2021-07-29 | Eagle | Colorado | 8037 | 6512 | 23 |
1560233 | 1560233 | 2021-07-28 | Eagle | Colorado | 8037 | 6505 | 23 |
1556986 | 1556986 | 2021-07-27 | Eagle | Colorado | 8037 | 6485 | 23 |
1553739 | 1553739 | 2021-07-26 | Eagle | Colorado | 8037 | 6485 | 23 |
1550492 | 1550492 | 2021-07-25 | Eagle | Colorado | 8037 | 6474 | 23 |
1547245 | 1547245 | 2021-07-24 | Eagle | Colorado | 8037 | 6474 | 23 |
1543998 | 1543998 | 2021-07-23 | Eagle | Colorado | 8037 | 6474 | 23 |
1540750 | 1540750 | 2021-07-22 | Eagle | Colorado | 8037 | 6472 | 23 |
1537503 | 1537503 | 2021-07-21 | Eagle | Colorado | 8037 | 6458 | 23 |
1534255 | 1534255 | 2021-07-20 | Eagle | Colorado | 8037 | 6434 | 23 |
1531008 | 1531008 | 2021-07-19 | Eagle | Colorado | 8037 | 6434 | 23 |
1527761 | 1527761 | 2021-07-18 | Eagle | Colorado | 8037 | 6426 | 23 |
1524514 | 1524514 | 2021-07-17 | Eagle | Colorado | 8037 | 6426 | 23 |
1521266 | 1521266 | 2021-07-16 | Eagle | Colorado | 8037 | 6426 | 23 |
1518018 | 1518018 | 2021-07-15 | Eagle | Colorado | 8037 | 6420 | 24 |
1514771 | 1514771 | 2021-07-14 | Eagle | Colorado | 8037 | 6412 | 24 |
1511525 | 1511525 | 2021-07-13 | Eagle | Colorado | 8037 | 6404 | 23 |
1508278 | 1508278 | 2021-07-12 | Eagle | Colorado | 8037 | 6399 | 23 |
1505032 | 1505032 | 2021-07-11 | Eagle | Colorado | 8037 | 6398 | 23 |
1501786 | 1501786 | 2021-07-10 | Eagle | Colorado | 8037 | 6398 | 23 |
1498540 | 1498540 | 2021-07-09 | Eagle | Colorado | 8037 | 6387 | 23 |
1495293 | 1495293 | 2021-07-08 | Eagle | Colorado | 8037 | 6374 | 23 |
1492047 | 1492047 | 2021-07-07 | Eagle | Colorado | 8037 | 6372 | 23 |
1488800 | 1488800 | 2021-07-06 | Eagle | Colorado | 8037 | 6369 | 23 |
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);