ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Pitkin" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810411 | 1810411 | 2021-10-13 | Pitkin | Colorado | 8097 | 3065 | 5 |
1807162 | 1807162 | 2021-10-12 | Pitkin | Colorado | 8097 | 3062 | 5 |
1803911 | 1803911 | 2021-10-11 | Pitkin | Colorado | 8097 | 3058 | 5 |
1800662 | 1800662 | 2021-10-10 | Pitkin | Colorado | 8097 | 3045 | 5 |
1797413 | 1797413 | 2021-10-09 | Pitkin | Colorado | 8097 | 3045 | 5 |
1794164 | 1794164 | 2021-10-08 | Pitkin | Colorado | 8097 | 3045 | 5 |
1790916 | 1790916 | 2021-10-07 | Pitkin | Colorado | 8097 | 3041 | 5 |
1787667 | 1787667 | 2021-10-06 | Pitkin | Colorado | 8097 | 3035 | 5 |
1784418 | 1784418 | 2021-10-05 | Pitkin | Colorado | 8097 | 3033 | 5 |
1781169 | 1781169 | 2021-10-04 | Pitkin | Colorado | 8097 | 3028 | 5 |
1777919 | 1777919 | 2021-10-03 | Pitkin | Colorado | 8097 | 3008 | 5 |
1774669 | 1774669 | 2021-10-02 | Pitkin | Colorado | 8097 | 3008 | 5 |
1771419 | 1771419 | 2021-10-01 | Pitkin | Colorado | 8097 | 3008 | 5 |
1768170 | 1768170 | 2021-09-30 | Pitkin | Colorado | 8097 | 3002 | 5 |
1764921 | 1764921 | 2021-09-29 | Pitkin | Colorado | 8097 | 2996 | 5 |
1761672 | 1761672 | 2021-09-28 | Pitkin | Colorado | 8097 | 2994 | 5 |
1758424 | 1758424 | 2021-09-27 | Pitkin | Colorado | 8097 | 2988 | 5 |
1755176 | 1755176 | 2021-09-26 | Pitkin | Colorado | 8097 | 2975 | 5 |
1751928 | 1751928 | 2021-09-25 | Pitkin | Colorado | 8097 | 2975 | 5 |
1748679 | 1748679 | 2021-09-24 | Pitkin | Colorado | 8097 | 2975 | 5 |
1745429 | 1745429 | 2021-09-23 | Pitkin | Colorado | 8097 | 2968 | 5 |
1742180 | 1742180 | 2021-09-22 | Pitkin | Colorado | 8097 | 2958 | 5 |
1738931 | 1738931 | 2021-09-21 | Pitkin | Colorado | 8097 | 2954 | 5 |
1735682 | 1735682 | 2021-09-20 | Pitkin | Colorado | 8097 | 2951 | 5 |
1732432 | 1732432 | 2021-09-19 | Pitkin | Colorado | 8097 | 2938 | 4 |
1729182 | 1729182 | 2021-09-18 | Pitkin | Colorado | 8097 | 2938 | 4 |
1725932 | 1725932 | 2021-09-17 | Pitkin | Colorado | 8097 | 2938 | 4 |
1722683 | 1722683 | 2021-09-16 | Pitkin | Colorado | 8097 | 2927 | 4 |
1719434 | 1719434 | 2021-09-15 | Pitkin | Colorado | 8097 | 2919 | 4 |
1716186 | 1716186 | 2021-09-14 | Pitkin | Colorado | 8097 | 2918 | 4 |
1712940 | 1712940 | 2021-09-13 | Pitkin | Colorado | 8097 | 2907 | 4 |
1709693 | 1709693 | 2021-09-12 | Pitkin | Colorado | 8097 | 2888 | 4 |
1706446 | 1706446 | 2021-09-11 | Pitkin | Colorado | 8097 | 2888 | 4 |
1703198 | 1703198 | 2021-09-10 | Pitkin | Colorado | 8097 | 2888 | 4 |
1699948 | 1699948 | 2021-09-09 | Pitkin | Colorado | 8097 | 2877 | 4 |
1696699 | 1696699 | 2021-09-08 | Pitkin | Colorado | 8097 | 2868 | 4 |
1693451 | 1693451 | 2021-09-07 | Pitkin | Colorado | 8097 | 2862 | 4 |
1690202 | 1690202 | 2021-09-06 | Pitkin | Colorado | 8097 | 2858 | 4 |
1686952 | 1686952 | 2021-09-05 | Pitkin | Colorado | 8097 | 2847 | 4 |
1683702 | 1683702 | 2021-09-04 | Pitkin | Colorado | 8097 | 2847 | 4 |
1680451 | 1680451 | 2021-09-03 | Pitkin | Colorado | 8097 | 2847 | 4 |
1677203 | 1677203 | 2021-09-02 | Pitkin | Colorado | 8097 | 2838 | 4 |
1673956 | 1673956 | 2021-09-01 | Pitkin | Colorado | 8097 | 2828 | 4 |
1670708 | 1670708 | 2021-08-31 | Pitkin | Colorado | 8097 | 2824 | 4 |
1667461 | 1667461 | 2021-08-30 | Pitkin | Colorado | 8097 | 2813 | 4 |
1664214 | 1664214 | 2021-08-29 | Pitkin | Colorado | 8097 | 2805 | 4 |
1660966 | 1660966 | 2021-08-28 | Pitkin | Colorado | 8097 | 2805 | 4 |
1657718 | 1657718 | 2021-08-27 | Pitkin | Colorado | 8097 | 2805 | 4 |
1654470 | 1654470 | 2021-08-26 | Pitkin | Colorado | 8097 | 2791 | 4 |
1651223 | 1651223 | 2021-08-25 | Pitkin | Colorado | 8097 | 2790 | 4 |
1647974 | 1647974 | 2021-08-24 | Pitkin | Colorado | 8097 | 2786 | 5 |
1644726 | 1644726 | 2021-08-23 | Pitkin | Colorado | 8097 | 2773 | 5 |
1641476 | 1641476 | 2021-08-22 | Pitkin | Colorado | 8097 | 2757 | 4 |
1638226 | 1638226 | 2021-08-21 | Pitkin | Colorado | 8097 | 2757 | 4 |
1634976 | 1634976 | 2021-08-20 | Pitkin | Colorado | 8097 | 2757 | 4 |
1631727 | 1631727 | 2021-08-19 | Pitkin | Colorado | 8097 | 2753 | 4 |
1628480 | 1628480 | 2021-08-18 | Pitkin | Colorado | 8097 | 2745 | 4 |
1625233 | 1625233 | 2021-08-17 | Pitkin | Colorado | 8097 | 2745 | 4 |
1621986 | 1621986 | 2021-08-16 | Pitkin | Colorado | 8097 | 2743 | 4 |
1618739 | 1618739 | 2021-08-15 | Pitkin | Colorado | 8097 | 2730 | 4 |
1615491 | 1615491 | 2021-08-14 | Pitkin | Colorado | 8097 | 2730 | 4 |
1612242 | 1612242 | 2021-08-13 | Pitkin | Colorado | 8097 | 2730 | 4 |
1608994 | 1608994 | 2021-08-12 | Pitkin | Colorado | 8097 | 2733 | 4 |
1605745 | 1605745 | 2021-08-11 | Pitkin | Colorado | 8097 | 2728 | 4 |
1602496 | 1602496 | 2021-08-10 | Pitkin | Colorado | 8097 | 2727 | 4 |
1599247 | 1599247 | 2021-08-09 | Pitkin | Colorado | 8097 | 2724 | 4 |
1595998 | 1595998 | 2021-08-08 | Pitkin | Colorado | 8097 | 2707 | 4 |
1592749 | 1592749 | 2021-08-07 | Pitkin | Colorado | 8097 | 2707 | 4 |
1589500 | 1589500 | 2021-08-06 | Pitkin | Colorado | 8097 | 2707 | 4 |
1586251 | 1586251 | 2021-08-05 | Pitkin | Colorado | 8097 | 2704 | 4 |
1583001 | 1583001 | 2021-08-04 | Pitkin | Colorado | 8097 | 2704 | 4 |
1579751 | 1579751 | 2021-08-03 | Pitkin | Colorado | 8097 | 2702 | 4 |
1576503 | 1576503 | 2021-08-02 | Pitkin | Colorado | 8097 | 2694 | 4 |
1573255 | 1573255 | 2021-08-01 | Pitkin | Colorado | 8097 | 2682 | 4 |
1570007 | 1570007 | 2021-07-31 | Pitkin | Colorado | 8097 | 2682 | 4 |
1566759 | 1566759 | 2021-07-30 | Pitkin | Colorado | 8097 | 2682 | 4 |
1563511 | 1563511 | 2021-07-29 | Pitkin | Colorado | 8097 | 2675 | 4 |
1560263 | 1560263 | 2021-07-28 | Pitkin | Colorado | 8097 | 2667 | 4 |
1557016 | 1557016 | 2021-07-27 | Pitkin | Colorado | 8097 | 2662 | 4 |
1553769 | 1553769 | 2021-07-26 | Pitkin | Colorado | 8097 | 2662 | 4 |
1550522 | 1550522 | 2021-07-25 | Pitkin | Colorado | 8097 | 2650 | 4 |
1547275 | 1547275 | 2021-07-24 | Pitkin | Colorado | 8097 | 2650 | 4 |
1544028 | 1544028 | 2021-07-23 | Pitkin | Colorado | 8097 | 2650 | 4 |
1540780 | 1540780 | 2021-07-22 | Pitkin | Colorado | 8097 | 2647 | 4 |
1537533 | 1537533 | 2021-07-21 | Pitkin | Colorado | 8097 | 2643 | 4 |
1534285 | 1534285 | 2021-07-20 | Pitkin | Colorado | 8097 | 2640 | 4 |
1531038 | 1531038 | 2021-07-19 | Pitkin | Colorado | 8097 | 2640 | 4 |
1527791 | 1527791 | 2021-07-18 | Pitkin | Colorado | 8097 | 2637 | 4 |
1524544 | 1524544 | 2021-07-17 | Pitkin | Colorado | 8097 | 2637 | 4 |
1521296 | 1521296 | 2021-07-16 | Pitkin | Colorado | 8097 | 2637 | 4 |
1518048 | 1518048 | 2021-07-15 | Pitkin | Colorado | 8097 | 2636 | 4 |
1514801 | 1514801 | 2021-07-14 | Pitkin | Colorado | 8097 | 2635 | 4 |
1511555 | 1511555 | 2021-07-13 | Pitkin | Colorado | 8097 | 2635 | 4 |
1508308 | 1508308 | 2021-07-12 | Pitkin | Colorado | 8097 | 2633 | 4 |
1505062 | 1505062 | 2021-07-11 | Pitkin | Colorado | 8097 | 2630 | 4 |
1501816 | 1501816 | 2021-07-10 | Pitkin | Colorado | 8097 | 2628 | 4 |
1498570 | 1498570 | 2021-07-09 | Pitkin | Colorado | 8097 | 2627 | 4 |
1495323 | 1495323 | 2021-07-08 | Pitkin | Colorado | 8097 | 2625 | 4 |
1492077 | 1492077 | 2021-07-07 | Pitkin | Colorado | 8097 | 2624 | 4 |
1488830 | 1488830 | 2021-07-06 | Pitkin | Colorado | 8097 | 2623 | 4 |
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);