ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Grand" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810387 | 1810387 | 2021-10-13 | Grand | Colorado | 8049 | 2093 | 10 |
1807138 | 1807138 | 2021-10-12 | Grand | Colorado | 8049 | 2083 | 10 |
1803887 | 1803887 | 2021-10-11 | Grand | Colorado | 8049 | 2078 | 10 |
1800638 | 1800638 | 2021-10-10 | Grand | Colorado | 8049 | 2065 | 10 |
1797389 | 1797389 | 2021-10-09 | Grand | Colorado | 8049 | 2065 | 10 |
1794140 | 1794140 | 2021-10-08 | Grand | Colorado | 8049 | 2065 | 10 |
1790892 | 1790892 | 2021-10-07 | Grand | Colorado | 8049 | 2059 | 10 |
1787643 | 1787643 | 2021-10-06 | Grand | Colorado | 8049 | 2053 | 10 |
1784394 | 1784394 | 2021-10-05 | Grand | Colorado | 8049 | 2044 | 10 |
1781145 | 1781145 | 2021-10-04 | Grand | Colorado | 8049 | 2041 | 10 |
1777895 | 1777895 | 2021-10-03 | Grand | Colorado | 8049 | 2025 | 10 |
1774645 | 1774645 | 2021-10-02 | Grand | Colorado | 8049 | 2025 | 10 |
1771395 | 1771395 | 2021-10-01 | Grand | Colorado | 8049 | 2025 | 10 |
1768146 | 1768146 | 2021-09-30 | Grand | Colorado | 8049 | 2012 | 10 |
1764897 | 1764897 | 2021-09-29 | Grand | Colorado | 8049 | 1999 | 10 |
1761648 | 1761648 | 2021-09-28 | Grand | Colorado | 8049 | 1993 | 10 |
1758400 | 1758400 | 2021-09-27 | Grand | Colorado | 8049 | 1982 | 11 |
1755152 | 1755152 | 2021-09-26 | Grand | Colorado | 8049 | 1939 | 10 |
1751904 | 1751904 | 2021-09-25 | Grand | Colorado | 8049 | 1939 | 10 |
1748655 | 1748655 | 2021-09-24 | Grand | Colorado | 8049 | 1939 | 10 |
1745405 | 1745405 | 2021-09-23 | Grand | Colorado | 8049 | 1924 | 10 |
1742156 | 1742156 | 2021-09-22 | Grand | Colorado | 8049 | 1907 | 10 |
1738907 | 1738907 | 2021-09-21 | Grand | Colorado | 8049 | 1889 | 8 |
1735658 | 1735658 | 2021-09-20 | Grand | Colorado | 8049 | 1866 | 8 |
1732408 | 1732408 | 2021-09-19 | Grand | Colorado | 8049 | 1823 | 8 |
1729158 | 1729158 | 2021-09-18 | Grand | Colorado | 8049 | 1823 | 8 |
1725908 | 1725908 | 2021-09-17 | Grand | Colorado | 8049 | 1823 | 8 |
1722659 | 1722659 | 2021-09-16 | Grand | Colorado | 8049 | 1808 | 7 |
1719410 | 1719410 | 2021-09-15 | Grand | Colorado | 8049 | 1797 | 7 |
1716162 | 1716162 | 2021-09-14 | Grand | Colorado | 8049 | 1780 | 8 |
1712916 | 1712916 | 2021-09-13 | Grand | Colorado | 8049 | 1773 | 8 |
1709669 | 1709669 | 2021-09-12 | Grand | Colorado | 8049 | 1751 | 7 |
1706422 | 1706422 | 2021-09-11 | Grand | Colorado | 8049 | 1751 | 7 |
1703174 | 1703174 | 2021-09-10 | Grand | Colorado | 8049 | 1751 | 7 |
1699924 | 1699924 | 2021-09-09 | Grand | Colorado | 8049 | 1747 | 7 |
1696675 | 1696675 | 2021-09-08 | Grand | Colorado | 8049 | 1740 | 7 |
1693427 | 1693427 | 2021-09-07 | Grand | Colorado | 8049 | 1733 | 7 |
1690178 | 1690178 | 2021-09-06 | Grand | Colorado | 8049 | 1724 | 7 |
1686928 | 1686928 | 2021-09-05 | Grand | Colorado | 8049 | 1695 | 7 |
1683678 | 1683678 | 2021-09-04 | Grand | Colorado | 8049 | 1695 | 7 |
1680427 | 1680427 | 2021-09-03 | Grand | Colorado | 8049 | 1695 | 7 |
1677179 | 1677179 | 2021-09-02 | Grand | Colorado | 8049 | 1691 | 7 |
1673932 | 1673932 | 2021-09-01 | Grand | Colorado | 8049 | 1682 | 7 |
1670684 | 1670684 | 2021-08-31 | Grand | Colorado | 8049 | 1672 | 7 |
1667437 | 1667437 | 2021-08-30 | Grand | Colorado | 8049 | 1662 | 7 |
1664190 | 1664190 | 2021-08-29 | Grand | Colorado | 8049 | 1646 | 7 |
1660942 | 1660942 | 2021-08-28 | Grand | Colorado | 8049 | 1646 | 7 |
1657694 | 1657694 | 2021-08-27 | Grand | Colorado | 8049 | 1646 | 7 |
1654446 | 1654446 | 2021-08-26 | Grand | Colorado | 8049 | 1637 | 7 |
1651199 | 1651199 | 2021-08-25 | Grand | Colorado | 8049 | 1632 | 7 |
1647950 | 1647950 | 2021-08-24 | Grand | Colorado | 8049 | 1621 | 7 |
1644702 | 1644702 | 2021-08-23 | Grand | Colorado | 8049 | 1617 | 7 |
1641452 | 1641452 | 2021-08-22 | Grand | Colorado | 8049 | 1595 | 7 |
1638202 | 1638202 | 2021-08-21 | Grand | Colorado | 8049 | 1595 | 7 |
1634952 | 1634952 | 2021-08-20 | Grand | Colorado | 8049 | 1595 | 7 |
1631703 | 1631703 | 2021-08-19 | Grand | Colorado | 8049 | 1586 | 7 |
1628456 | 1628456 | 2021-08-18 | Grand | Colorado | 8049 | 1582 | 7 |
1625209 | 1625209 | 2021-08-17 | Grand | Colorado | 8049 | 1578 | 7 |
1621962 | 1621962 | 2021-08-16 | Grand | Colorado | 8049 | 1575 | 7 |
1618715 | 1618715 | 2021-08-15 | Grand | Colorado | 8049 | 1563 | 7 |
1615467 | 1615467 | 2021-08-14 | Grand | Colorado | 8049 | 1563 | 7 |
1612218 | 1612218 | 2021-08-13 | Grand | Colorado | 8049 | 1563 | 7 |
1608970 | 1608970 | 2021-08-12 | Grand | Colorado | 8049 | 1558 | 7 |
1605721 | 1605721 | 2021-08-11 | Grand | Colorado | 8049 | 1555 | 7 |
1602472 | 1602472 | 2021-08-10 | Grand | Colorado | 8049 | 1553 | 7 |
1599223 | 1599223 | 2021-08-09 | Grand | Colorado | 8049 | 1552 | 7 |
1595974 | 1595974 | 2021-08-08 | Grand | Colorado | 8049 | 1546 | 7 |
1592725 | 1592725 | 2021-08-07 | Grand | Colorado | 8049 | 1546 | 7 |
1589476 | 1589476 | 2021-08-06 | Grand | Colorado | 8049 | 1546 | 7 |
1586227 | 1586227 | 2021-08-05 | Grand | Colorado | 8049 | 1546 | 7 |
1582977 | 1582977 | 2021-08-04 | Grand | Colorado | 8049 | 1542 | 7 |
1579727 | 1579727 | 2021-08-03 | Grand | Colorado | 8049 | 1541 | 7 |
1576479 | 1576479 | 2021-08-02 | Grand | Colorado | 8049 | 1540 | 7 |
1573231 | 1573231 | 2021-08-01 | Grand | Colorado | 8049 | 1533 | 7 |
1569983 | 1569983 | 2021-07-31 | Grand | Colorado | 8049 | 1533 | 7 |
1566735 | 1566735 | 2021-07-30 | Grand | Colorado | 8049 | 1533 | 7 |
1563487 | 1563487 | 2021-07-29 | Grand | Colorado | 8049 | 1532 | 7 |
1560239 | 1560239 | 2021-07-28 | Grand | Colorado | 8049 | 1529 | 7 |
1556992 | 1556992 | 2021-07-27 | Grand | Colorado | 8049 | 1529 | 7 |
1553745 | 1553745 | 2021-07-26 | Grand | Colorado | 8049 | 1529 | 7 |
1550498 | 1550498 | 2021-07-25 | Grand | Colorado | 8049 | 1529 | 7 |
1547251 | 1547251 | 2021-07-24 | Grand | Colorado | 8049 | 1529 | 7 |
1544004 | 1544004 | 2021-07-23 | Grand | Colorado | 8049 | 1529 | 7 |
1540756 | 1540756 | 2021-07-22 | Grand | Colorado | 8049 | 1524 | 7 |
1537509 | 1537509 | 2021-07-21 | Grand | Colorado | 8049 | 1522 | 7 |
1534261 | 1534261 | 2021-07-20 | Grand | Colorado | 8049 | 1516 | 7 |
1531014 | 1531014 | 2021-07-19 | Grand | Colorado | 8049 | 1516 | 7 |
1527767 | 1527767 | 2021-07-18 | Grand | Colorado | 8049 | 1516 | 7 |
1524520 | 1524520 | 2021-07-17 | Grand | Colorado | 8049 | 1516 | 7 |
1521272 | 1521272 | 2021-07-16 | Grand | Colorado | 8049 | 1516 | 7 |
1518024 | 1518024 | 2021-07-15 | Grand | Colorado | 8049 | 1516 | 7 |
1514777 | 1514777 | 2021-07-14 | Grand | Colorado | 8049 | 1515 | 7 |
1511531 | 1511531 | 2021-07-13 | Grand | Colorado | 8049 | 1513 | 7 |
1508284 | 1508284 | 2021-07-12 | Grand | Colorado | 8049 | 1513 | 7 |
1505038 | 1505038 | 2021-07-11 | Grand | Colorado | 8049 | 1511 | 7 |
1501792 | 1501792 | 2021-07-10 | Grand | Colorado | 8049 | 1510 | 7 |
1498546 | 1498546 | 2021-07-09 | Grand | Colorado | 8049 | 1510 | 7 |
1495299 | 1495299 | 2021-07-08 | Grand | Colorado | 8049 | 1509 | 7 |
1492053 | 1492053 | 2021-07-07 | Grand | Colorado | 8049 | 1507 | 7 |
1488806 | 1488806 | 2021-07-06 | Grand | Colorado | 8049 | 1507 | 7 |
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);