ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8123 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946903 | 1946903 | 2021-11-24 | Weld | Colorado | 8123 | 52077 | 522 |
1943652 | 1943652 | 2021-11-23 | Weld | Colorado | 8123 | 51904 | 518 |
1940402 | 1940402 | 2021-11-22 | Weld | Colorado | 8123 | 51760 | 512 |
1937152 | 1937152 | 2021-11-21 | Weld | Colorado | 8123 | 51354 | 510 |
1933902 | 1933902 | 2021-11-20 | Weld | Colorado | 8123 | 51354 | 510 |
1930650 | 1930650 | 2021-11-19 | Weld | Colorado | 8123 | 51354 | 510 |
1927400 | 1927400 | 2021-11-18 | Weld | Colorado | 8123 | 51165 | 509 |
1924150 | 1924150 | 2021-11-17 | Weld | Colorado | 8123 | 50889 | 504 |
1920901 | 1920901 | 2021-11-16 | Weld | Colorado | 8123 | 50616 | 499 |
1917651 | 1917651 | 2021-11-15 | Weld | Colorado | 8123 | 50428 | 493 |
1914401 | 1914401 | 2021-11-14 | Weld | Colorado | 8123 | 49990 | 488 |
1911151 | 1911151 | 2021-11-13 | Weld | Colorado | 8123 | 49990 | 488 |
1907902 | 1907902 | 2021-11-12 | Weld | Colorado | 8123 | 49990 | 488 |
1904653 | 1904653 | 2021-11-11 | Weld | Colorado | 8123 | 49701 | 485 |
1901403 | 1901403 | 2021-11-10 | Weld | Colorado | 8123 | 49551 | 484 |
1898153 | 1898153 | 2021-11-09 | Weld | Colorado | 8123 | 49327 | 483 |
1894903 | 1894903 | 2021-11-08 | Weld | Colorado | 8123 | 49165 | 483 |
1891653 | 1891653 | 2021-11-07 | Weld | Colorado | 8123 | 48612 | 473 |
1888403 | 1888403 | 2021-11-06 | Weld | Colorado | 8123 | 48612 | 473 |
1885153 | 1885153 | 2021-11-05 | Weld | Colorado | 8123 | 48612 | 473 |
1881904 | 1881904 | 2021-11-04 | Weld | Colorado | 8123 | 48366 | 469 |
1878655 | 1878655 | 2021-11-03 | Weld | Colorado | 8123 | 48148 | 464 |
1875406 | 1875406 | 2021-11-02 | Weld | Colorado | 8123 | 47892 | 463 |
1872157 | 1872157 | 2021-11-01 | Weld | Colorado | 8123 | 47694 | 460 |
1868908 | 1868908 | 2021-10-31 | Weld | Colorado | 8123 | 47208 | 455 |
1865659 | 1865659 | 2021-10-30 | Weld | Colorado | 8123 | 47208 | 455 |
1862410 | 1862410 | 2021-10-29 | Weld | Colorado | 8123 | 47208 | 455 |
1859161 | 1859161 | 2021-10-28 | Weld | Colorado | 8123 | 46980 | 454 |
1855912 | 1855912 | 2021-10-27 | Weld | Colorado | 8123 | 46743 | 453 |
1852663 | 1852663 | 2021-10-26 | Weld | Colorado | 8123 | 46487 | 451 |
1849414 | 1849414 | 2021-10-25 | Weld | Colorado | 8123 | 46296 | 448 |
1846164 | 1846164 | 2021-10-24 | Weld | Colorado | 8123 | 45764 | 440 |
1842914 | 1842914 | 2021-10-23 | Weld | Colorado | 8123 | 45764 | 440 |
1839664 | 1839664 | 2021-10-22 | Weld | Colorado | 8123 | 45764 | 440 |
1836415 | 1836415 | 2021-10-21 | Weld | Colorado | 8123 | 45545 | 438 |
1833166 | 1833166 | 2021-10-20 | Weld | Colorado | 8123 | 45291 | 435 |
1829917 | 1829917 | 2021-10-19 | Weld | Colorado | 8123 | 45031 | 434 |
1826668 | 1826668 | 2021-10-18 | Weld | Colorado | 8123 | 44879 | 433 |
1823419 | 1823419 | 2021-10-17 | Weld | Colorado | 8123 | 44488 | 430 |
1820170 | 1820170 | 2021-10-16 | Weld | Colorado | 8123 | 44488 | 430 |
1816921 | 1816921 | 2021-10-15 | Weld | Colorado | 8123 | 44488 | 430 |
1813673 | 1813673 | 2021-10-14 | Weld | Colorado | 8123 | 44295 | 422 |
1810424 | 1810424 | 2021-10-13 | Weld | Colorado | 8123 | 44051 | 422 |
1807175 | 1807175 | 2021-10-12 | Weld | Colorado | 8123 | 43847 | 420 |
1803924 | 1803924 | 2021-10-11 | Weld | Colorado | 8123 | 43692 | 416 |
1800675 | 1800675 | 2021-10-10 | Weld | Colorado | 8123 | 43268 | 412 |
1797426 | 1797426 | 2021-10-09 | Weld | Colorado | 8123 | 43268 | 412 |
1794177 | 1794177 | 2021-10-08 | Weld | Colorado | 8123 | 43268 | 412 |
1790929 | 1790929 | 2021-10-07 | Weld | Colorado | 8123 | 43102 | 409 |
1787680 | 1787680 | 2021-10-06 | Weld | Colorado | 8123 | 42911 | 406 |
1784431 | 1784431 | 2021-10-05 | Weld | Colorado | 8123 | 42696 | 406 |
1781182 | 1781182 | 2021-10-04 | Weld | Colorado | 8123 | 42556 | 406 |
1777932 | 1777932 | 2021-10-03 | Weld | Colorado | 8123 | 42177 | 405 |
1774682 | 1774682 | 2021-10-02 | Weld | Colorado | 8123 | 42177 | 405 |
1771432 | 1771432 | 2021-10-01 | Weld | Colorado | 8123 | 42177 | 405 |
1768183 | 1768183 | 2021-09-30 | Weld | Colorado | 8123 | 42032 | 398 |
1764934 | 1764934 | 2021-09-29 | Weld | Colorado | 8123 | 41875 | 398 |
1761685 | 1761685 | 2021-09-28 | Weld | Colorado | 8123 | 41681 | 396 |
1758437 | 1758437 | 2021-09-27 | Weld | Colorado | 8123 | 41541 | 394 |
1755189 | 1755189 | 2021-09-26 | Weld | Colorado | 8123 | 41211 | 390 |
1751941 | 1751941 | 2021-09-25 | Weld | Colorado | 8123 | 41211 | 390 |
1748692 | 1748692 | 2021-09-24 | Weld | Colorado | 8123 | 41211 | 390 |
1745442 | 1745442 | 2021-09-23 | Weld | Colorado | 8123 | 41072 | 390 |
1742193 | 1742193 | 2021-09-22 | Weld | Colorado | 8123 | 40948 | 387 |
1738944 | 1738944 | 2021-09-21 | Weld | Colorado | 8123 | 40802 | 387 |
1735695 | 1735695 | 2021-09-20 | Weld | Colorado | 8123 | 40669 | 386 |
1732445 | 1732445 | 2021-09-19 | Weld | Colorado | 8123 | 40259 | 386 |
1729195 | 1729195 | 2021-09-18 | Weld | Colorado | 8123 | 40259 | 386 |
1725945 | 1725945 | 2021-09-17 | Weld | Colorado | 8123 | 40259 | 386 |
1722696 | 1722696 | 2021-09-16 | Weld | Colorado | 8123 | 40108 | 379 |
1719447 | 1719447 | 2021-09-15 | Weld | Colorado | 8123 | 39954 | 379 |
1716199 | 1716199 | 2021-09-14 | Weld | Colorado | 8123 | 39804 | 375 |
1712953 | 1712953 | 2021-09-13 | Weld | Colorado | 8123 | 39675 | 375 |
1709706 | 1709706 | 2021-09-12 | Weld | Colorado | 8123 | 39212 | 372 |
1706459 | 1706459 | 2021-09-11 | Weld | Colorado | 8123 | 39212 | 372 |
1703211 | 1703211 | 2021-09-10 | Weld | Colorado | 8123 | 39212 | 372 |
1699961 | 1699961 | 2021-09-09 | Weld | Colorado | 8123 | 39002 | 371 |
1696712 | 1696712 | 2021-09-08 | Weld | Colorado | 8123 | 38860 | 370 |
1693464 | 1693464 | 2021-09-07 | Weld | Colorado | 8123 | 38728 | 369 |
1690215 | 1690215 | 2021-09-06 | Weld | Colorado | 8123 | 38493 | 369 |
1686965 | 1686965 | 2021-09-05 | Weld | Colorado | 8123 | 38193 | 366 |
1683715 | 1683715 | 2021-09-04 | Weld | Colorado | 8123 | 38193 | 366 |
1680464 | 1680464 | 2021-09-03 | Weld | Colorado | 8123 | 38193 | 366 |
1677216 | 1677216 | 2021-09-02 | Weld | Colorado | 8123 | 37994 | 364 |
1673969 | 1673969 | 2021-09-01 | Weld | Colorado | 8123 | 37803 | 363 |
1670721 | 1670721 | 2021-08-31 | Weld | Colorado | 8123 | 37619 | 362 |
1667474 | 1667474 | 2021-08-30 | Weld | Colorado | 8123 | 37459 | 362 |
1664227 | 1664227 | 2021-08-29 | Weld | Colorado | 8123 | 37111 | 361 |
1660979 | 1660979 | 2021-08-28 | Weld | Colorado | 8123 | 37111 | 361 |
1657731 | 1657731 | 2021-08-27 | Weld | Colorado | 8123 | 37111 | 361 |
1654483 | 1654483 | 2021-08-26 | Weld | Colorado | 8123 | 36977 | 361 |
1651236 | 1651236 | 2021-08-25 | Weld | Colorado | 8123 | 36793 | 360 |
1647987 | 1647987 | 2021-08-24 | Weld | Colorado | 8123 | 36684 | 360 |
1644739 | 1644739 | 2021-08-23 | Weld | Colorado | 8123 | 36555 | 360 |
1641489 | 1641489 | 2021-08-22 | Weld | Colorado | 8123 | 36232 | 360 |
1638239 | 1638239 | 2021-08-21 | Weld | Colorado | 8123 | 36232 | 360 |
1634989 | 1634989 | 2021-08-20 | Weld | Colorado | 8123 | 36232 | 360 |
1631740 | 1631740 | 2021-08-19 | Weld | Colorado | 8123 | 36084 | 360 |
1628493 | 1628493 | 2021-08-18 | Weld | Colorado | 8123 | 35924 | 360 |
1625246 | 1625246 | 2021-08-17 | Weld | Colorado | 8123 | 35812 | 360 |
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);