ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 8051 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810388 | 1810388 | 2021-10-13 | Gunnison | Colorado | 8051 | 1794 | 10 |
1807139 | 1807139 | 2021-10-12 | Gunnison | Colorado | 8051 | 1788 | 10 |
1803888 | 1803888 | 2021-10-11 | Gunnison | Colorado | 8051 | 1785 | 9 |
1800639 | 1800639 | 2021-10-10 | Gunnison | Colorado | 8051 | 1778 | 9 |
1797390 | 1797390 | 2021-10-09 | Gunnison | Colorado | 8051 | 1778 | 9 |
1794141 | 1794141 | 2021-10-08 | Gunnison | Colorado | 8051 | 1778 | 9 |
1790893 | 1790893 | 2021-10-07 | Gunnison | Colorado | 8051 | 1772 | 9 |
1787644 | 1787644 | 2021-10-06 | Gunnison | Colorado | 8051 | 1762 | 9 |
1784395 | 1784395 | 2021-10-05 | Gunnison | Colorado | 8051 | 1759 | 9 |
1781146 | 1781146 | 2021-10-04 | Gunnison | Colorado | 8051 | 1756 | 9 |
1777896 | 1777896 | 2021-10-03 | Gunnison | Colorado | 8051 | 1746 | 9 |
1774646 | 1774646 | 2021-10-02 | Gunnison | Colorado | 8051 | 1746 | 9 |
1771396 | 1771396 | 2021-10-01 | Gunnison | Colorado | 8051 | 1746 | 9 |
1768147 | 1768147 | 2021-09-30 | Gunnison | Colorado | 8051 | 1737 | 9 |
1764898 | 1764898 | 2021-09-29 | Gunnison | Colorado | 8051 | 1735 | 9 |
1761649 | 1761649 | 2021-09-28 | Gunnison | Colorado | 8051 | 1734 | 8 |
1758401 | 1758401 | 2021-09-27 | Gunnison | Colorado | 8051 | 1730 | 8 |
1755153 | 1755153 | 2021-09-26 | Gunnison | Colorado | 8051 | 1716 | 8 |
1751905 | 1751905 | 2021-09-25 | Gunnison | Colorado | 8051 | 1716 | 8 |
1748656 | 1748656 | 2021-09-24 | Gunnison | Colorado | 8051 | 1716 | 8 |
1745406 | 1745406 | 2021-09-23 | Gunnison | Colorado | 8051 | 1711 | 8 |
1742157 | 1742157 | 2021-09-22 | Gunnison | Colorado | 8051 | 1697 | 8 |
1738908 | 1738908 | 2021-09-21 | Gunnison | Colorado | 8051 | 1694 | 8 |
1735659 | 1735659 | 2021-09-20 | Gunnison | Colorado | 8051 | 1691 | 8 |
1732409 | 1732409 | 2021-09-19 | Gunnison | Colorado | 8051 | 1676 | 8 |
1729159 | 1729159 | 2021-09-18 | Gunnison | Colorado | 8051 | 1676 | 8 |
1725909 | 1725909 | 2021-09-17 | Gunnison | Colorado | 8051 | 1676 | 8 |
1722660 | 1722660 | 2021-09-16 | Gunnison | Colorado | 8051 | 1669 | 8 |
1719411 | 1719411 | 2021-09-15 | Gunnison | Colorado | 8051 | 1659 | 8 |
1716163 | 1716163 | 2021-09-14 | Gunnison | Colorado | 8051 | 1657 | 8 |
1712917 | 1712917 | 2021-09-13 | Gunnison | Colorado | 8051 | 1651 | 8 |
1709670 | 1709670 | 2021-09-12 | Gunnison | Colorado | 8051 | 1611 | 8 |
1706423 | 1706423 | 2021-09-11 | Gunnison | Colorado | 8051 | 1611 | 8 |
1703175 | 1703175 | 2021-09-10 | Gunnison | Colorado | 8051 | 1611 | 8 |
1699925 | 1699925 | 2021-09-09 | Gunnison | Colorado | 8051 | 1610 | 8 |
1696676 | 1696676 | 2021-09-08 | Gunnison | Colorado | 8051 | 1612 | 8 |
1693428 | 1693428 | 2021-09-07 | Gunnison | Colorado | 8051 | 1609 | 8 |
1690179 | 1690179 | 2021-09-06 | Gunnison | Colorado | 8051 | 1601 | 8 |
1686929 | 1686929 | 2021-09-05 | Gunnison | Colorado | 8051 | 1578 | 8 |
1683679 | 1683679 | 2021-09-04 | Gunnison | Colorado | 8051 | 1578 | 8 |
1680428 | 1680428 | 2021-09-03 | Gunnison | Colorado | 8051 | 1578 | 8 |
1677180 | 1677180 | 2021-09-02 | Gunnison | Colorado | 8051 | 1575 | 8 |
1673933 | 1673933 | 2021-09-01 | Gunnison | Colorado | 8051 | 1570 | 7 |
1670685 | 1670685 | 2021-08-31 | Gunnison | Colorado | 8051 | 1560 | 7 |
1667438 | 1667438 | 2021-08-30 | Gunnison | Colorado | 8051 | 1550 | 7 |
1664191 | 1664191 | 2021-08-29 | Gunnison | Colorado | 8051 | 1535 | 7 |
1660943 | 1660943 | 2021-08-28 | Gunnison | Colorado | 8051 | 1535 | 7 |
1657695 | 1657695 | 2021-08-27 | Gunnison | Colorado | 8051 | 1535 | 7 |
1654447 | 1654447 | 2021-08-26 | Gunnison | Colorado | 8051 | 1534 | 7 |
1651200 | 1651200 | 2021-08-25 | Gunnison | Colorado | 8051 | 1516 | 7 |
1647951 | 1647951 | 2021-08-24 | Gunnison | Colorado | 8051 | 1511 | 7 |
1644703 | 1644703 | 2021-08-23 | Gunnison | Colorado | 8051 | 1506 | 7 |
1641453 | 1641453 | 2021-08-22 | Gunnison | Colorado | 8051 | 1484 | 7 |
1638203 | 1638203 | 2021-08-21 | Gunnison | Colorado | 8051 | 1484 | 7 |
1634953 | 1634953 | 2021-08-20 | Gunnison | Colorado | 8051 | 1484 | 7 |
1631704 | 1631704 | 2021-08-19 | Gunnison | Colorado | 8051 | 1477 | 7 |
1628457 | 1628457 | 2021-08-18 | Gunnison | Colorado | 8051 | 1476 | 7 |
1625210 | 1625210 | 2021-08-17 | Gunnison | Colorado | 8051 | 1473 | 7 |
1621963 | 1621963 | 2021-08-16 | Gunnison | Colorado | 8051 | 1469 | 7 |
1618716 | 1618716 | 2021-08-15 | Gunnison | Colorado | 8051 | 1454 | 7 |
1615468 | 1615468 | 2021-08-14 | Gunnison | Colorado | 8051 | 1454 | 7 |
1612219 | 1612219 | 2021-08-13 | Gunnison | Colorado | 8051 | 1454 | 7 |
1608971 | 1608971 | 2021-08-12 | Gunnison | Colorado | 8051 | 1451 | 7 |
1605722 | 1605722 | 2021-08-11 | Gunnison | Colorado | 8051 | 1452 | 7 |
1602473 | 1602473 | 2021-08-10 | Gunnison | Colorado | 8051 | 1450 | 7 |
1599224 | 1599224 | 2021-08-09 | Gunnison | Colorado | 8051 | 1449 | 7 |
1595975 | 1595975 | 2021-08-08 | Gunnison | Colorado | 8051 | 1441 | 7 |
1592726 | 1592726 | 2021-08-07 | Gunnison | Colorado | 8051 | 1441 | 7 |
1589477 | 1589477 | 2021-08-06 | Gunnison | Colorado | 8051 | 1441 | 7 |
1586228 | 1586228 | 2021-08-05 | Gunnison | Colorado | 8051 | 1438 | 7 |
1582978 | 1582978 | 2021-08-04 | Gunnison | Colorado | 8051 | 1437 | 7 |
1579728 | 1579728 | 2021-08-03 | Gunnison | Colorado | 8051 | 1434 | 6 |
1576480 | 1576480 | 2021-08-02 | Gunnison | Colorado | 8051 | 1433 | 6 |
1573232 | 1573232 | 2021-08-01 | Gunnison | Colorado | 8051 | 1427 | 6 |
1569984 | 1569984 | 2021-07-31 | Gunnison | Colorado | 8051 | 1427 | 6 |
1566736 | 1566736 | 2021-07-30 | Gunnison | Colorado | 8051 | 1427 | 6 |
1563488 | 1563488 | 2021-07-29 | Gunnison | Colorado | 8051 | 1420 | 6 |
1560240 | 1560240 | 2021-07-28 | Gunnison | Colorado | 8051 | 1415 | 6 |
1556993 | 1556993 | 2021-07-27 | Gunnison | Colorado | 8051 | 1410 | 6 |
1553746 | 1553746 | 2021-07-26 | Gunnison | Colorado | 8051 | 1410 | 6 |
1550499 | 1550499 | 2021-07-25 | Gunnison | Colorado | 8051 | 1408 | 6 |
1547252 | 1547252 | 2021-07-24 | Gunnison | Colorado | 8051 | 1408 | 6 |
1544005 | 1544005 | 2021-07-23 | Gunnison | Colorado | 8051 | 1408 | 6 |
1540757 | 1540757 | 2021-07-22 | Gunnison | Colorado | 8051 | 1409 | 6 |
1537510 | 1537510 | 2021-07-21 | Gunnison | Colorado | 8051 | 1408 | 6 |
1534262 | 1534262 | 2021-07-20 | Gunnison | Colorado | 8051 | 1408 | 6 |
1531015 | 1531015 | 2021-07-19 | Gunnison | Colorado | 8051 | 1408 | 6 |
1527768 | 1527768 | 2021-07-18 | Gunnison | Colorado | 8051 | 1407 | 6 |
1524521 | 1524521 | 2021-07-17 | Gunnison | Colorado | 8051 | 1407 | 6 |
1521273 | 1521273 | 2021-07-16 | Gunnison | Colorado | 8051 | 1407 | 6 |
1518025 | 1518025 | 2021-07-15 | Gunnison | Colorado | 8051 | 1406 | 6 |
1514778 | 1514778 | 2021-07-14 | Gunnison | Colorado | 8051 | 1407 | 6 |
1511532 | 1511532 | 2021-07-13 | Gunnison | Colorado | 8051 | 1407 | 6 |
1508285 | 1508285 | 2021-07-12 | Gunnison | Colorado | 8051 | 1408 | 6 |
1505039 | 1505039 | 2021-07-11 | Gunnison | Colorado | 8051 | 1408 | 6 |
1501793 | 1501793 | 2021-07-10 | Gunnison | Colorado | 8051 | 1405 | 6 |
1498547 | 1498547 | 2021-07-09 | Gunnison | Colorado | 8051 | 1405 | 6 |
1495300 | 1495300 | 2021-07-08 | Gunnison | Colorado | 8051 | 1405 | 6 |
1492054 | 1492054 | 2021-07-07 | Gunnison | Colorado | 8051 | 1401 | 6 |
1488807 | 1488807 | 2021-07-06 | Gunnison | Colorado | 8051 | 1401 | 6 |
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);