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 |
---|---|---|---|---|---|---|---|
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 |
1485564 | 1485564 | 2021-07-05 | Jefferson | Colorado | 8059 | 49017 | 806 |
1482318 | 1482318 | 2021-07-04 | Jefferson | Colorado | 8059 | 49008 | 806 |
1479071 | 1479071 | 2021-07-03 | Jefferson | Colorado | 8059 | 48997 | 807 |
1475825 | 1475825 | 2021-07-02 | Jefferson | Colorado | 8059 | 48976 | 806 |
1472579 | 1472579 | 2021-07-01 | Jefferson | Colorado | 8059 | 48950 | 805 |
1469333 | 1469333 | 2021-06-30 | Jefferson | Colorado | 8059 | 48913 | 804 |
1466088 | 1466088 | 2021-06-29 | Jefferson | Colorado | 8059 | 48892 | 803 |
1462843 | 1462843 | 2021-06-28 | Jefferson | Colorado | 8059 | 48867 | 801 |
1459598 | 1459598 | 2021-06-27 | Jefferson | Colorado | 8059 | 48850 | 802 |
1456353 | 1456353 | 2021-06-26 | Jefferson | Colorado | 8059 | 48833 | 800 |
1453108 | 1453108 | 2021-06-25 | Jefferson | Colorado | 8059 | 48779 | 800 |
1449862 | 1449862 | 2021-06-24 | Jefferson | Colorado | 8059 | 48744 | 797 |
1446617 | 1446617 | 2021-06-23 | Jefferson | Colorado | 8059 | 48711 | 797 |
1443372 | 1443372 | 2021-06-22 | Jefferson | Colorado | 8059 | 48698 | 797 |
1440127 | 1440127 | 2021-06-21 | Jefferson | Colorado | 8059 | 48678 | 796 |
1436880 | 1436880 | 2021-06-20 | Jefferson | Colorado | 8059 | 48666 | 795 |
1433633 | 1433633 | 2021-06-19 | Jefferson | Colorado | 8059 | 48650 | 795 |
1430387 | 1430387 | 2021-06-18 | Jefferson | Colorado | 8059 | 48615 | 795 |
1427142 | 1427142 | 2021-06-17 | Jefferson | Colorado | 8059 | 48589 | 794 |
1423897 | 1423897 | 2021-06-16 | Jefferson | Colorado | 8059 | 48546 | 793 |
1420649 | 1420649 | 2021-06-15 | Jefferson | Colorado | 8059 | 48520 | 793 |
1417404 | 1417404 | 2021-06-14 | Jefferson | Colorado | 8059 | 48510 | 793 |
1414158 | 1414158 | 2021-06-13 | Jefferson | Colorado | 8059 | 48497 | 793 |
1410913 | 1410913 | 2021-06-12 | Jefferson | Colorado | 8059 | 48452 | 793 |
1407668 | 1407668 | 2021-06-11 | Jefferson | Colorado | 8059 | 48410 | 792 |
1404422 | 1404422 | 2021-06-10 | Jefferson | Colorado | 8059 | 48351 | 792 |
1401177 | 1401177 | 2021-06-09 | Jefferson | Colorado | 8059 | 48303 | 791 |
1397932 | 1397932 | 2021-06-08 | Jefferson | Colorado | 8059 | 48259 | 790 |
1394685 | 1394685 | 2021-06-07 | Jefferson | Colorado | 8059 | 48216 | 790 |
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);