ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8053 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810389 | 1810389 | 2021-10-13 | Hinsdale | Colorado | 8053 | 54 | 0 |
1807140 | 1807140 | 2021-10-12 | Hinsdale | Colorado | 8053 | 54 | 0 |
1803889 | 1803889 | 2021-10-11 | Hinsdale | Colorado | 8053 | 54 | 0 |
1800640 | 1800640 | 2021-10-10 | Hinsdale | Colorado | 8053 | 54 | 0 |
1797391 | 1797391 | 2021-10-09 | Hinsdale | Colorado | 8053 | 54 | 0 |
1794142 | 1794142 | 2021-10-08 | Hinsdale | Colorado | 8053 | 54 | 0 |
1790894 | 1790894 | 2021-10-07 | Hinsdale | Colorado | 8053 | 54 | 0 |
1787645 | 1787645 | 2021-10-06 | Hinsdale | Colorado | 8053 | 54 | 0 |
1784396 | 1784396 | 2021-10-05 | Hinsdale | Colorado | 8053 | 54 | 0 |
1781147 | 1781147 | 2021-10-04 | Hinsdale | Colorado | 8053 | 53 | 0 |
1777897 | 1777897 | 2021-10-03 | Hinsdale | Colorado | 8053 | 53 | 0 |
1774647 | 1774647 | 2021-10-02 | Hinsdale | Colorado | 8053 | 53 | 0 |
1771397 | 1771397 | 2021-10-01 | Hinsdale | Colorado | 8053 | 53 | 0 |
1768148 | 1768148 | 2021-09-30 | Hinsdale | Colorado | 8053 | 53 | 0 |
1764899 | 1764899 | 2021-09-29 | Hinsdale | Colorado | 8053 | 53 | 0 |
1761650 | 1761650 | 2021-09-28 | Hinsdale | Colorado | 8053 | 53 | 0 |
1758402 | 1758402 | 2021-09-27 | Hinsdale | Colorado | 8053 | 53 | 0 |
1755154 | 1755154 | 2021-09-26 | Hinsdale | Colorado | 8053 | 53 | 0 |
1751906 | 1751906 | 2021-09-25 | Hinsdale | Colorado | 8053 | 53 | 0 |
1748657 | 1748657 | 2021-09-24 | Hinsdale | Colorado | 8053 | 53 | 0 |
1745407 | 1745407 | 2021-09-23 | Hinsdale | Colorado | 8053 | 53 | 0 |
1742158 | 1742158 | 2021-09-22 | Hinsdale | Colorado | 8053 | 52 | 0 |
1738909 | 1738909 | 2021-09-21 | Hinsdale | Colorado | 8053 | 52 | 0 |
1735660 | 1735660 | 2021-09-20 | Hinsdale | Colorado | 8053 | 51 | 0 |
1732410 | 1732410 | 2021-09-19 | Hinsdale | Colorado | 8053 | 51 | 0 |
1729160 | 1729160 | 2021-09-18 | Hinsdale | Colorado | 8053 | 51 | 0 |
1725910 | 1725910 | 2021-09-17 | Hinsdale | Colorado | 8053 | 51 | 0 |
1722661 | 1722661 | 2021-09-16 | Hinsdale | Colorado | 8053 | 52 | 0 |
1719412 | 1719412 | 2021-09-15 | Hinsdale | Colorado | 8053 | 51 | 0 |
1716164 | 1716164 | 2021-09-14 | Hinsdale | Colorado | 8053 | 52 | 0 |
1712918 | 1712918 | 2021-09-13 | Hinsdale | Colorado | 8053 | 51 | 0 |
1709671 | 1709671 | 2021-09-12 | Hinsdale | Colorado | 8053 | 50 | 0 |
1706424 | 1706424 | 2021-09-11 | Hinsdale | Colorado | 8053 | 50 | 0 |
1703176 | 1703176 | 2021-09-10 | Hinsdale | Colorado | 8053 | 50 | 0 |
1699926 | 1699926 | 2021-09-09 | Hinsdale | Colorado | 8053 | 50 | 0 |
1696677 | 1696677 | 2021-09-08 | Hinsdale | Colorado | 8053 | 49 | 0 |
1693429 | 1693429 | 2021-09-07 | Hinsdale | Colorado | 8053 | 48 | 0 |
1690180 | 1690180 | 2021-09-06 | Hinsdale | Colorado | 8053 | 49 | 0 |
1686930 | 1686930 | 2021-09-05 | Hinsdale | Colorado | 8053 | 49 | 0 |
1683680 | 1683680 | 2021-09-04 | Hinsdale | Colorado | 8053 | 49 | 0 |
1680429 | 1680429 | 2021-09-03 | Hinsdale | Colorado | 8053 | 49 | 0 |
1677181 | 1677181 | 2021-09-02 | Hinsdale | Colorado | 8053 | 47 | 0 |
1673934 | 1673934 | 2021-09-01 | Hinsdale | Colorado | 8053 | 47 | 0 |
1670686 | 1670686 | 2021-08-31 | Hinsdale | Colorado | 8053 | 47 | 0 |
1667439 | 1667439 | 2021-08-30 | Hinsdale | Colorado | 8053 | 47 | 0 |
1664192 | 1664192 | 2021-08-29 | Hinsdale | Colorado | 8053 | 48 | 0 |
1660944 | 1660944 | 2021-08-28 | Hinsdale | Colorado | 8053 | 48 | 0 |
1657696 | 1657696 | 2021-08-27 | Hinsdale | Colorado | 8053 | 48 | 0 |
1654448 | 1654448 | 2021-08-26 | Hinsdale | Colorado | 8053 | 45 | 0 |
1651201 | 1651201 | 2021-08-25 | Hinsdale | Colorado | 8053 | 42 | 0 |
1647952 | 1647952 | 2021-08-24 | Hinsdale | Colorado | 8053 | 43 | 0 |
1644704 | 1644704 | 2021-08-23 | Hinsdale | Colorado | 8053 | 40 | 0 |
1641454 | 1641454 | 2021-08-22 | Hinsdale | Colorado | 8053 | 40 | 0 |
1638204 | 1638204 | 2021-08-21 | Hinsdale | Colorado | 8053 | 40 | 0 |
1634954 | 1634954 | 2021-08-20 | Hinsdale | Colorado | 8053 | 40 | 0 |
1631705 | 1631705 | 2021-08-19 | Hinsdale | Colorado | 8053 | 39 | 0 |
1628458 | 1628458 | 2021-08-18 | Hinsdale | Colorado | 8053 | 38 | 0 |
1625211 | 1625211 | 2021-08-17 | Hinsdale | Colorado | 8053 | 38 | 0 |
1621964 | 1621964 | 2021-08-16 | Hinsdale | Colorado | 8053 | 38 | 0 |
1618717 | 1618717 | 2021-08-15 | Hinsdale | Colorado | 8053 | 37 | 0 |
1615469 | 1615469 | 2021-08-14 | Hinsdale | Colorado | 8053 | 37 | 0 |
1612220 | 1612220 | 2021-08-13 | Hinsdale | Colorado | 8053 | 37 | 0 |
1608972 | 1608972 | 2021-08-12 | Hinsdale | Colorado | 8053 | 37 | 0 |
1605723 | 1605723 | 2021-08-11 | Hinsdale | Colorado | 8053 | 37 | 0 |
1602474 | 1602474 | 2021-08-10 | Hinsdale | Colorado | 8053 | 37 | 0 |
1599225 | 1599225 | 2021-08-09 | Hinsdale | Colorado | 8053 | 36 | 0 |
1595976 | 1595976 | 2021-08-08 | Hinsdale | Colorado | 8053 | 34 | 0 |
1592727 | 1592727 | 2021-08-07 | Hinsdale | Colorado | 8053 | 34 | 0 |
1589478 | 1589478 | 2021-08-06 | Hinsdale | Colorado | 8053 | 34 | 0 |
1586229 | 1586229 | 2021-08-05 | Hinsdale | Colorado | 8053 | 34 | 0 |
1582979 | 1582979 | 2021-08-04 | Hinsdale | Colorado | 8053 | 34 | 0 |
1579729 | 1579729 | 2021-08-03 | Hinsdale | Colorado | 8053 | 34 | 0 |
1576481 | 1576481 | 2021-08-02 | Hinsdale | Colorado | 8053 | 34 | 0 |
1573233 | 1573233 | 2021-08-01 | Hinsdale | Colorado | 8053 | 33 | 0 |
1569985 | 1569985 | 2021-07-31 | Hinsdale | Colorado | 8053 | 33 | 0 |
1566737 | 1566737 | 2021-07-30 | Hinsdale | Colorado | 8053 | 33 | 0 |
1563489 | 1563489 | 2021-07-29 | Hinsdale | Colorado | 8053 | 32 | 0 |
1560241 | 1560241 | 2021-07-28 | Hinsdale | Colorado | 8053 | 32 | 0 |
1556994 | 1556994 | 2021-07-27 | Hinsdale | Colorado | 8053 | 31 | 0 |
1553747 | 1553747 | 2021-07-26 | Hinsdale | Colorado | 8053 | 31 | 0 |
1550500 | 1550500 | 2021-07-25 | Hinsdale | Colorado | 8053 | 31 | 0 |
1547253 | 1547253 | 2021-07-24 | Hinsdale | Colorado | 8053 | 31 | 0 |
1544006 | 1544006 | 2021-07-23 | Hinsdale | Colorado | 8053 | 31 | 0 |
1540758 | 1540758 | 2021-07-22 | Hinsdale | Colorado | 8053 | 31 | 0 |
1537511 | 1537511 | 2021-07-21 | Hinsdale | Colorado | 8053 | 31 | 0 |
1534263 | 1534263 | 2021-07-20 | Hinsdale | Colorado | 8053 | 30 | 0 |
1531016 | 1531016 | 2021-07-19 | Hinsdale | Colorado | 8053 | 30 | 0 |
1527769 | 1527769 | 2021-07-18 | Hinsdale | Colorado | 8053 | 30 | 0 |
1524522 | 1524522 | 2021-07-17 | Hinsdale | Colorado | 8053 | 30 | 0 |
1521274 | 1521274 | 2021-07-16 | Hinsdale | Colorado | 8053 | 30 | 0 |
1518026 | 1518026 | 2021-07-15 | Hinsdale | Colorado | 8053 | 30 | 0 |
1514779 | 1514779 | 2021-07-14 | Hinsdale | Colorado | 8053 | 28 | 0 |
1511533 | 1511533 | 2021-07-13 | Hinsdale | Colorado | 8053 | 27 | 0 |
1508286 | 1508286 | 2021-07-12 | Hinsdale | Colorado | 8053 | 25 | 0 |
1505040 | 1505040 | 2021-07-11 | Hinsdale | Colorado | 8053 | 26 | 0 |
1501794 | 1501794 | 2021-07-10 | Hinsdale | Colorado | 8053 | 26 | 0 |
1498548 | 1498548 | 2021-07-09 | Hinsdale | Colorado | 8053 | 26 | 0 |
1495301 | 1495301 | 2021-07-08 | Hinsdale | Colorado | 8053 | 22 | 0 |
1492055 | 1492055 | 2021-07-07 | Hinsdale | Colorado | 8053 | 20 | 0 |
1488808 | 1488808 | 2021-07-06 | Hinsdale | Colorado | 8053 | 20 | 0 |
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);