ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where fips = 8059 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810392 | 1810392 | 2021-10-13 | Jefferson | Colorado | 8059 | 60330 | 888 |
1807143 | 1807143 | 2021-10-12 | Jefferson | Colorado | 8059 | 60164 | 888 |
1803892 | 1803892 | 2021-10-11 | Jefferson | Colorado | 8059 | 59947 | 886 |
1800643 | 1800643 | 2021-10-10 | Jefferson | Colorado | 8059 | 59490 | 884 |
1797394 | 1797394 | 2021-10-09 | Jefferson | Colorado | 8059 | 59490 | 884 |
1794145 | 1794145 | 2021-10-08 | Jefferson | Colorado | 8059 | 59490 | 884 |
1790897 | 1790897 | 2021-10-07 | Jefferson | Colorado | 8059 | 59301 | 878 |
1787648 | 1787648 | 2021-10-06 | Jefferson | Colorado | 8059 | 59122 | 878 |
1784399 | 1784399 | 2021-10-05 | Jefferson | Colorado | 8059 | 58998 | 878 |
1781150 | 1781150 | 2021-10-04 | Jefferson | Colorado | 8059 | 58795 | 871 |
1777900 | 1777900 | 2021-10-03 | Jefferson | Colorado | 8059 | 58370 | 868 |
1774650 | 1774650 | 2021-10-02 | Jefferson | Colorado | 8059 | 58370 | 868 |
1771400 | 1771400 | 2021-10-01 | Jefferson | Colorado | 8059 | 58370 | 868 |
1768151 | 1768151 | 2021-09-30 | Jefferson | Colorado | 8059 | 58191 | 867 |
1764902 | 1764902 | 2021-09-29 | Jefferson | Colorado | 8059 | 57990 | 867 |
1761653 | 1761653 | 2021-09-28 | Jefferson | Colorado | 8059 | 57866 | 868 |
1758405 | 1758405 | 2021-09-27 | Jefferson | Colorado | 8059 | 57728 | 866 |
1755157 | 1755157 | 2021-09-26 | Jefferson | Colorado | 8059 | 57362 | 866 |
1751909 | 1751909 | 2021-09-25 | Jefferson | Colorado | 8059 | 57362 | 866 |
1748660 | 1748660 | 2021-09-24 | Jefferson | Colorado | 8059 | 57362 | 866 |
1745410 | 1745410 | 2021-09-23 | Jefferson | Colorado | 8059 | 57195 | 859 |
1742161 | 1742161 | 2021-09-22 | Jefferson | Colorado | 8059 | 57046 | 860 |
1738912 | 1738912 | 2021-09-21 | Jefferson | Colorado | 8059 | 56937 | 860 |
1735663 | 1735663 | 2021-09-20 | Jefferson | Colorado | 8059 | 56659 | 855 |
1732413 | 1732413 | 2021-09-19 | Jefferson | Colorado | 8059 | 56198 | 852 |
1729163 | 1729163 | 2021-09-18 | Jefferson | Colorado | 8059 | 56198 | 852 |
1725913 | 1725913 | 2021-09-17 | Jefferson | Colorado | 8059 | 56198 | 852 |
1722664 | 1722664 | 2021-09-16 | Jefferson | Colorado | 8059 | 56015 | 849 |
1719415 | 1719415 | 2021-09-15 | Jefferson | Colorado | 8059 | 55849 | 849 |
1716167 | 1716167 | 2021-09-14 | Jefferson | Colorado | 8059 | 55675 | 848 |
1712921 | 1712921 | 2021-09-13 | Jefferson | Colorado | 8059 | 55529 | 844 |
1709674 | 1709674 | 2021-09-12 | Jefferson | Colorado | 8059 | 55050 | 843 |
1706427 | 1706427 | 2021-09-11 | Jefferson | Colorado | 8059 | 55050 | 843 |
1703179 | 1703179 | 2021-09-10 | Jefferson | Colorado | 8059 | 55050 | 843 |
1699929 | 1699929 | 2021-09-09 | Jefferson | Colorado | 8059 | 54880 | 843 |
1696680 | 1696680 | 2021-09-08 | Jefferson | Colorado | 8059 | 54748 | 842 |
1693432 | 1693432 | 2021-09-07 | Jefferson | Colorado | 8059 | 54649 | 840 |
1690183 | 1690183 | 2021-09-06 | Jefferson | Colorado | 8059 | 54477 | 839 |
1686933 | 1686933 | 2021-09-05 | Jefferson | Colorado | 8059 | 54042 | 838 |
1683683 | 1683683 | 2021-09-04 | Jefferson | Colorado | 8059 | 54042 | 838 |
1680432 | 1680432 | 2021-09-03 | Jefferson | Colorado | 8059 | 54042 | 838 |
1677184 | 1677184 | 2021-09-02 | Jefferson | Colorado | 8059 | 53902 | 833 |
1673937 | 1673937 | 2021-09-01 | Jefferson | Colorado | 8059 | 53744 | 833 |
1670689 | 1670689 | 2021-08-31 | Jefferson | Colorado | 8059 | 53556 | 834 |
1667442 | 1667442 | 2021-08-30 | Jefferson | Colorado | 8059 | 53408 | 832 |
1664195 | 1664195 | 2021-08-29 | Jefferson | Colorado | 8059 | 53088 | 833 |
1660947 | 1660947 | 2021-08-28 | Jefferson | Colorado | 8059 | 53088 | 833 |
1657699 | 1657699 | 2021-08-27 | Jefferson | Colorado | 8059 | 53088 | 833 |
1654451 | 1654451 | 2021-08-26 | Jefferson | Colorado | 8059 | 52962 | 830 |
1651204 | 1651204 | 2021-08-25 | Jefferson | Colorado | 8059 | 52841 | 828 |
1647955 | 1647955 | 2021-08-24 | Jefferson | Colorado | 8059 | 52725 | 828 |
1644707 | 1644707 | 2021-08-23 | Jefferson | Colorado | 8059 | 52599 | 827 |
1641457 | 1641457 | 2021-08-22 | Jefferson | Colorado | 8059 | 52230 | 825 |
1638207 | 1638207 | 2021-08-21 | Jefferson | Colorado | 8059 | 52230 | 825 |
1634957 | 1634957 | 2021-08-20 | Jefferson | Colorado | 8059 | 52230 | 825 |
1631708 | 1631708 | 2021-08-19 | Jefferson | Colorado | 8059 | 52096 | 822 |
1628461 | 1628461 | 2021-08-18 | Jefferson | Colorado | 8059 | 51955 | 822 |
1625214 | 1625214 | 2021-08-17 | Jefferson | Colorado | 8059 | 51767 | 821 |
1621967 | 1621967 | 2021-08-16 | Jefferson | Colorado | 8059 | 51698 | 818 |
1618720 | 1618720 | 2021-08-15 | Jefferson | Colorado | 8059 | 51459 | 819 |
1615472 | 1615472 | 2021-08-14 | Jefferson | Colorado | 8059 | 51459 | 819 |
1612223 | 1612223 | 2021-08-13 | Jefferson | Colorado | 8059 | 51459 | 819 |
1608975 | 1608975 | 2021-08-12 | Jefferson | Colorado | 8059 | 51267 | 819 |
1605726 | 1605726 | 2021-08-11 | Jefferson | Colorado | 8059 | 51098 | 818 |
1602477 | 1602477 | 2021-08-10 | Jefferson | Colorado | 8059 | 51038 | 818 |
1599228 | 1599228 | 2021-08-09 | Jefferson | Colorado | 8059 | 51000 | 816 |
1595979 | 1595979 | 2021-08-08 | Jefferson | Colorado | 8059 | 50763 | 816 |
1592730 | 1592730 | 2021-08-07 | Jefferson | Colorado | 8059 | 50763 | 816 |
1589481 | 1589481 | 2021-08-06 | Jefferson | Colorado | 8059 | 50763 | 816 |
1586232 | 1586232 | 2021-08-05 | Jefferson | Colorado | 8059 | 50690 | 816 |
1582982 | 1582982 | 2021-08-04 | Jefferson | Colorado | 8059 | 50581 | 815 |
1579732 | 1579732 | 2021-08-03 | Jefferson | Colorado | 8059 | 50483 | 814 |
1576484 | 1576484 | 2021-08-02 | Jefferson | Colorado | 8059 | 50381 | 814 |
1573236 | 1573236 | 2021-08-01 | Jefferson | Colorado | 8059 | 50205 | 812 |
1569988 | 1569988 | 2021-07-31 | Jefferson | Colorado | 8059 | 50205 | 812 |
1566740 | 1566740 | 2021-07-30 | Jefferson | Colorado | 8059 | 50205 | 812 |
1563492 | 1563492 | 2021-07-29 | Jefferson | Colorado | 8059 | 50126 | 812 |
1560244 | 1560244 | 2021-07-28 | Jefferson | Colorado | 8059 | 50039 | 813 |
1556997 | 1556997 | 2021-07-27 | Jefferson | Colorado | 8059 | 49853 | 811 |
1553750 | 1553750 | 2021-07-26 | Jefferson | Colorado | 8059 | 49853 | 811 |
1550503 | 1550503 | 2021-07-25 | Jefferson | Colorado | 8059 | 49676 | 811 |
1547256 | 1547256 | 2021-07-24 | Jefferson | Colorado | 8059 | 49676 | 811 |
1544009 | 1544009 | 2021-07-23 | Jefferson | Colorado | 8059 | 49676 | 811 |
1540761 | 1540761 | 2021-07-22 | Jefferson | Colorado | 8059 | 49615 | 811 |
1537514 | 1537514 | 2021-07-21 | Jefferson | Colorado | 8059 | 49557 | 811 |
1534266 | 1534266 | 2021-07-20 | Jefferson | Colorado | 8059 | 49480 | 810 |
1531019 | 1531019 | 2021-07-19 | Jefferson | Colorado | 8059 | 49480 | 810 |
1527772 | 1527772 | 2021-07-18 | Jefferson | Colorado | 8059 | 49393 | 810 |
1524525 | 1524525 | 2021-07-17 | Jefferson | Colorado | 8059 | 49393 | 810 |
1521277 | 1521277 | 2021-07-16 | Jefferson | Colorado | 8059 | 49393 | 810 |
1518029 | 1518029 | 2021-07-15 | Jefferson | Colorado | 8059 | 49361 | 810 |
1514782 | 1514782 | 2021-07-14 | Jefferson | Colorado | 8059 | 49323 | 808 |
1511536 | 1511536 | 2021-07-13 | Jefferson | Colorado | 8059 | 49280 | 807 |
1508289 | 1508289 | 2021-07-12 | Jefferson | Colorado | 8059 | 49246 | 805 |
1505043 | 1505043 | 2021-07-11 | Jefferson | Colorado | 8059 | 49226 | 805 |
1501797 | 1501797 | 2021-07-10 | Jefferson | Colorado | 8059 | 49209 | 805 |
1498551 | 1498551 | 2021-07-09 | Jefferson | Colorado | 8059 | 49174 | 805 |
1495304 | 1495304 | 2021-07-08 | Jefferson | Colorado | 8059 | 49081 | 806 |
1492058 | 1492058 | 2021-07-07 | Jefferson | Colorado | 8059 | 49055 | 806 |
1488811 | 1488811 | 2021-07-06 | Jefferson | Colorado | 8059 | 49023 | 806 |
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);