ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Weld" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1621999 | 1621999 | 2021-08-16 | Weld | Colorado | 8123 | 35653 | 359 |
1618752 | 1618752 | 2021-08-15 | Weld | Colorado | 8123 | 35460 | 359 |
1615504 | 1615504 | 2021-08-14 | Weld | Colorado | 8123 | 35460 | 359 |
1612255 | 1612255 | 2021-08-13 | Weld | Colorado | 8123 | 35460 | 359 |
1609007 | 1609007 | 2021-08-12 | Weld | Colorado | 8123 | 35384 | 359 |
1605758 | 1605758 | 2021-08-11 | Weld | Colorado | 8123 | 35268 | 359 |
1602509 | 1602509 | 2021-08-10 | Weld | Colorado | 8123 | 35159 | 359 |
1599260 | 1599260 | 2021-08-09 | Weld | Colorado | 8123 | 35082 | 359 |
1596011 | 1596011 | 2021-08-08 | Weld | Colorado | 8123 | 34883 | 359 |
1592762 | 1592762 | 2021-08-07 | Weld | Colorado | 8123 | 34883 | 359 |
1589513 | 1589513 | 2021-08-06 | Weld | Colorado | 8123 | 34883 | 359 |
1586264 | 1586264 | 2021-08-05 | Weld | Colorado | 8123 | 34825 | 359 |
1583014 | 1583014 | 2021-08-04 | Weld | Colorado | 8123 | 34749 | 358 |
1579764 | 1579764 | 2021-08-03 | Weld | Colorado | 8123 | 34678 | 358 |
1576516 | 1576516 | 2021-08-02 | Weld | Colorado | 8123 | 34632 | 358 |
1573268 | 1573268 | 2021-08-01 | Weld | Colorado | 8123 | 34488 | 357 |
1570020 | 1570020 | 2021-07-31 | Weld | Colorado | 8123 | 34488 | 357 |
1566772 | 1566772 | 2021-07-30 | Weld | Colorado | 8123 | 34488 | 357 |
1563524 | 1563524 | 2021-07-29 | Weld | Colorado | 8123 | 34413 | 356 |
1560276 | 1560276 | 2021-07-28 | Weld | Colorado | 8123 | 34345 | 356 |
1557029 | 1557029 | 2021-07-27 | Weld | Colorado | 8123 | 34289 | 356 |
1553782 | 1553782 | 2021-07-26 | Weld | Colorado | 8123 | 34240 | 356 |
1550535 | 1550535 | 2021-07-25 | Weld | Colorado | 8123 | 34144 | 355 |
1547288 | 1547288 | 2021-07-24 | Weld | Colorado | 8123 | 34144 | 355 |
1544041 | 1544041 | 2021-07-23 | Weld | Colorado | 8123 | 34144 | 355 |
1540793 | 1540793 | 2021-07-22 | Weld | Colorado | 8123 | 34101 | 355 |
1537546 | 1537546 | 2021-07-21 | Weld | Colorado | 8123 | 34041 | 355 |
1534298 | 1534298 | 2021-07-20 | Weld | Colorado | 8123 | 34019 | 354 |
1531051 | 1531051 | 2021-07-19 | Weld | Colorado | 8123 | 33993 | 354 |
1527804 | 1527804 | 2021-07-18 | Weld | Colorado | 8123 | 33893 | 354 |
1524557 | 1524557 | 2021-07-17 | Weld | Colorado | 8123 | 33893 | 354 |
1521309 | 1521309 | 2021-07-16 | Weld | Colorado | 8123 | 33893 | 354 |
1518061 | 1518061 | 2021-07-15 | Weld | Colorado | 8123 | 33840 | 353 |
1514814 | 1514814 | 2021-07-14 | Weld | Colorado | 8123 | 33818 | 354 |
1511568 | 1511568 | 2021-07-13 | Weld | Colorado | 8123 | 33792 | 353 |
1508321 | 1508321 | 2021-07-12 | Weld | Colorado | 8123 | 33757 | 353 |
1505075 | 1505075 | 2021-07-11 | Weld | Colorado | 8123 | 33720 | 353 |
1501829 | 1501829 | 2021-07-10 | Weld | Colorado | 8123 | 33709 | 352 |
1498583 | 1498583 | 2021-07-09 | Weld | Colorado | 8123 | 33709 | 352 |
1495336 | 1495336 | 2021-07-08 | Weld | Colorado | 8123 | 33660 | 352 |
1492090 | 1492090 | 2021-07-07 | Weld | Colorado | 8123 | 33637 | 352 |
1488843 | 1488843 | 2021-07-06 | Weld | Colorado | 8123 | 33613 | 352 |
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);