ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Logan" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839640 | 1839640 | 2021-10-22 | Logan | Colorado | 8075 | 4663 | 80 |
1836391 | 1836391 | 2021-10-21 | Logan | Colorado | 8075 | 4641 | 80 |
1833142 | 1833142 | 2021-10-20 | Logan | Colorado | 8075 | 4625 | 80 |
1829893 | 1829893 | 2021-10-19 | Logan | Colorado | 8075 | 4613 | 79 |
1826644 | 1826644 | 2021-10-18 | Logan | Colorado | 8075 | 4604 | 79 |
1823395 | 1823395 | 2021-10-17 | Logan | Colorado | 8075 | 4579 | 79 |
1820146 | 1820146 | 2021-10-16 | Logan | Colorado | 8075 | 4579 | 79 |
1816897 | 1816897 | 2021-10-15 | Logan | Colorado | 8075 | 4579 | 79 |
1813649 | 1813649 | 2021-10-14 | Logan | Colorado | 8075 | 4559 | 79 |
1810400 | 1810400 | 2021-10-13 | Logan | Colorado | 8075 | 4548 | 79 |
1807151 | 1807151 | 2021-10-12 | Logan | Colorado | 8075 | 4535 | 79 |
1803900 | 1803900 | 2021-10-11 | Logan | Colorado | 8075 | 4527 | 79 |
1800651 | 1800651 | 2021-10-10 | Logan | Colorado | 8075 | 4480 | 79 |
1797402 | 1797402 | 2021-10-09 | Logan | Colorado | 8075 | 4480 | 79 |
1794153 | 1794153 | 2021-10-08 | Logan | Colorado | 8075 | 4480 | 79 |
1790905 | 1790905 | 2021-10-07 | Logan | Colorado | 8075 | 4476 | 79 |
1787656 | 1787656 | 2021-10-06 | Logan | Colorado | 8075 | 4463 | 78 |
1784407 | 1784407 | 2021-10-05 | Logan | Colorado | 8075 | 4452 | 78 |
1781158 | 1781158 | 2021-10-04 | Logan | Colorado | 8075 | 4448 | 78 |
1777908 | 1777908 | 2021-10-03 | Logan | Colorado | 8075 | 4429 | 75 |
1774658 | 1774658 | 2021-10-02 | Logan | Colorado | 8075 | 4429 | 75 |
1771408 | 1771408 | 2021-10-01 | Logan | Colorado | 8075 | 4429 | 75 |
1768159 | 1768159 | 2021-09-30 | Logan | Colorado | 8075 | 4409 | 74 |
1764910 | 1764910 | 2021-09-29 | Logan | Colorado | 8075 | 4405 | 74 |
1761661 | 1761661 | 2021-09-28 | Logan | Colorado | 8075 | 4399 | 73 |
1758413 | 1758413 | 2021-09-27 | Logan | Colorado | 8075 | 4391 | 73 |
1755165 | 1755165 | 2021-09-26 | Logan | Colorado | 8075 | 4366 | 73 |
1751917 | 1751917 | 2021-09-25 | Logan | Colorado | 8075 | 4366 | 73 |
1748668 | 1748668 | 2021-09-24 | Logan | Colorado | 8075 | 4366 | 73 |
1745418 | 1745418 | 2021-09-23 | Logan | Colorado | 8075 | 4358 | 72 |
1742169 | 1742169 | 2021-09-22 | Logan | Colorado | 8075 | 4356 | 72 |
1738920 | 1738920 | 2021-09-21 | Logan | Colorado | 8075 | 4355 | 72 |
1735671 | 1735671 | 2021-09-20 | Logan | Colorado | 8075 | 4350 | 72 |
1732421 | 1732421 | 2021-09-19 | Logan | Colorado | 8075 | 4328 | 72 |
1729171 | 1729171 | 2021-09-18 | Logan | Colorado | 8075 | 4328 | 72 |
1725921 | 1725921 | 2021-09-17 | Logan | Colorado | 8075 | 4328 | 72 |
1722672 | 1722672 | 2021-09-16 | Logan | Colorado | 8075 | 4320 | 72 |
1719423 | 1719423 | 2021-09-15 | Logan | Colorado | 8075 | 4309 | 72 |
1716175 | 1716175 | 2021-09-14 | Logan | Colorado | 8075 | 4304 | 72 |
1712929 | 1712929 | 2021-09-13 | Logan | Colorado | 8075 | 4290 | 72 |
1709682 | 1709682 | 2021-09-12 | Logan | Colorado | 8075 | 4262 | 71 |
1706435 | 1706435 | 2021-09-11 | Logan | Colorado | 8075 | 4262 | 71 |
1703187 | 1703187 | 2021-09-10 | Logan | Colorado | 8075 | 4262 | 71 |
1699937 | 1699937 | 2021-09-09 | Logan | Colorado | 8075 | 4250 | 71 |
1696688 | 1696688 | 2021-09-08 | Logan | Colorado | 8075 | 4241 | 71 |
1693440 | 1693440 | 2021-09-07 | Logan | Colorado | 8075 | 4234 | 69 |
1690191 | 1690191 | 2021-09-06 | Logan | Colorado | 8075 | 4222 | 69 |
1686941 | 1686941 | 2021-09-05 | Logan | Colorado | 8075 | 4196 | 69 |
1683691 | 1683691 | 2021-09-04 | Logan | Colorado | 8075 | 4196 | 69 |
1680440 | 1680440 | 2021-09-03 | Logan | Colorado | 8075 | 4196 | 69 |
1677192 | 1677192 | 2021-09-02 | Logan | Colorado | 8075 | 4193 | 69 |
1673945 | 1673945 | 2021-09-01 | Logan | Colorado | 8075 | 4184 | 69 |
1670697 | 1670697 | 2021-08-31 | Logan | Colorado | 8075 | 4177 | 69 |
1667450 | 1667450 | 2021-08-30 | Logan | Colorado | 8075 | 4173 | 69 |
1664203 | 1664203 | 2021-08-29 | Logan | Colorado | 8075 | 4164 | 69 |
1660955 | 1660955 | 2021-08-28 | Logan | Colorado | 8075 | 4164 | 69 |
1657707 | 1657707 | 2021-08-27 | Logan | Colorado | 8075 | 4164 | 69 |
1654459 | 1654459 | 2021-08-26 | Logan | Colorado | 8075 | 4157 | 69 |
1651212 | 1651212 | 2021-08-25 | Logan | Colorado | 8075 | 4152 | 69 |
1647963 | 1647963 | 2021-08-24 | Logan | Colorado | 8075 | 4145 | 69 |
1644715 | 1644715 | 2021-08-23 | Logan | Colorado | 8075 | 4141 | 69 |
1641465 | 1641465 | 2021-08-22 | Logan | Colorado | 8075 | 4134 | 69 |
1638215 | 1638215 | 2021-08-21 | Logan | Colorado | 8075 | 4134 | 69 |
1634965 | 1634965 | 2021-08-20 | Logan | Colorado | 8075 | 4134 | 69 |
1631716 | 1631716 | 2021-08-19 | Logan | Colorado | 8075 | 4122 | 69 |
1628469 | 1628469 | 2021-08-18 | Logan | Colorado | 8075 | 4115 | 69 |
1625222 | 1625222 | 2021-08-17 | Logan | Colorado | 8075 | 4106 | 69 |
1621975 | 1621975 | 2021-08-16 | Logan | Colorado | 8075 | 4105 | 69 |
1618728 | 1618728 | 2021-08-15 | Logan | Colorado | 8075 | 4101 | 69 |
1615480 | 1615480 | 2021-08-14 | Logan | Colorado | 8075 | 4101 | 69 |
1612231 | 1612231 | 2021-08-13 | Logan | Colorado | 8075 | 4101 | 69 |
1608983 | 1608983 | 2021-08-12 | Logan | Colorado | 8075 | 4099 | 69 |
1605734 | 1605734 | 2021-08-11 | Logan | Colorado | 8075 | 4095 | 69 |
1602485 | 1602485 | 2021-08-10 | Logan | Colorado | 8075 | 4093 | 69 |
1599236 | 1599236 | 2021-08-09 | Logan | Colorado | 8075 | 4093 | 69 |
1595987 | 1595987 | 2021-08-08 | Logan | Colorado | 8075 | 4088 | 69 |
1592738 | 1592738 | 2021-08-07 | Logan | Colorado | 8075 | 4088 | 69 |
1589489 | 1589489 | 2021-08-06 | Logan | Colorado | 8075 | 4088 | 69 |
1586240 | 1586240 | 2021-08-05 | Logan | Colorado | 8075 | 4084 | 69 |
1582990 | 1582990 | 2021-08-04 | Logan | Colorado | 8075 | 4080 | 69 |
1579740 | 1579740 | 2021-08-03 | Logan | Colorado | 8075 | 4078 | 69 |
1576492 | 1576492 | 2021-08-02 | Logan | Colorado | 8075 | 4075 | 69 |
1573244 | 1573244 | 2021-08-01 | Logan | Colorado | 8075 | 4072 | 69 |
1569996 | 1569996 | 2021-07-31 | Logan | Colorado | 8075 | 4072 | 69 |
1566748 | 1566748 | 2021-07-30 | Logan | Colorado | 8075 | 4072 | 69 |
1563500 | 1563500 | 2021-07-29 | Logan | Colorado | 8075 | 4072 | 69 |
1560252 | 1560252 | 2021-07-28 | Logan | Colorado | 8075 | 4072 | 69 |
1557005 | 1557005 | 2021-07-27 | Logan | Colorado | 8075 | 4072 | 69 |
1553758 | 1553758 | 2021-07-26 | Logan | Colorado | 8075 | 4072 | 69 |
1550511 | 1550511 | 2021-07-25 | Logan | Colorado | 8075 | 4071 | 69 |
1547264 | 1547264 | 2021-07-24 | Logan | Colorado | 8075 | 4071 | 69 |
1544017 | 1544017 | 2021-07-23 | Logan | Colorado | 8075 | 4071 | 69 |
1540769 | 1540769 | 2021-07-22 | Logan | Colorado | 8075 | 4071 | 69 |
1537522 | 1537522 | 2021-07-21 | Logan | Colorado | 8075 | 4071 | 69 |
1534274 | 1534274 | 2021-07-20 | Logan | Colorado | 8075 | 4071 | 69 |
1531027 | 1531027 | 2021-07-19 | Logan | Colorado | 8075 | 4071 | 69 |
1527780 | 1527780 | 2021-07-18 | Logan | Colorado | 8075 | 4069 | 69 |
1524533 | 1524533 | 2021-07-17 | Logan | Colorado | 8075 | 4069 | 69 |
1521285 | 1521285 | 2021-07-16 | Logan | Colorado | 8075 | 4069 | 69 |
1518037 | 1518037 | 2021-07-15 | Logan | Colorado | 8075 | 4069 | 69 |
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);