ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lake" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810396 | 1810396 | 2021-10-13 | Lake | Colorado | 8065 | 978 | 1 |
1807147 | 1807147 | 2021-10-12 | Lake | Colorado | 8065 | 974 | 1 |
1803896 | 1803896 | 2021-10-11 | Lake | Colorado | 8065 | 973 | 1 |
1800647 | 1800647 | 2021-10-10 | Lake | Colorado | 8065 | 972 | 1 |
1797398 | 1797398 | 2021-10-09 | Lake | Colorado | 8065 | 972 | 1 |
1794149 | 1794149 | 2021-10-08 | Lake | Colorado | 8065 | 972 | 1 |
1790901 | 1790901 | 2021-10-07 | Lake | Colorado | 8065 | 969 | 1 |
1787652 | 1787652 | 2021-10-06 | Lake | Colorado | 8065 | 966 | 1 |
1784403 | 1784403 | 2021-10-05 | Lake | Colorado | 8065 | 965 | 1 |
1781154 | 1781154 | 2021-10-04 | Lake | Colorado | 8065 | 962 | 1 |
1777904 | 1777904 | 2021-10-03 | Lake | Colorado | 8065 | 959 | 1 |
1774654 | 1774654 | 2021-10-02 | Lake | Colorado | 8065 | 959 | 1 |
1771404 | 1771404 | 2021-10-01 | Lake | Colorado | 8065 | 959 | 1 |
1768155 | 1768155 | 2021-09-30 | Lake | Colorado | 8065 | 961 | 1 |
1764906 | 1764906 | 2021-09-29 | Lake | Colorado | 8065 | 960 | 1 |
1761657 | 1761657 | 2021-09-28 | Lake | Colorado | 8065 | 958 | 1 |
1758409 | 1758409 | 2021-09-27 | Lake | Colorado | 8065 | 954 | 1 |
1755161 | 1755161 | 2021-09-26 | Lake | Colorado | 8065 | 953 | 1 |
1751913 | 1751913 | 2021-09-25 | Lake | Colorado | 8065 | 953 | 1 |
1748664 | 1748664 | 2021-09-24 | Lake | Colorado | 8065 | 953 | 1 |
1745414 | 1745414 | 2021-09-23 | Lake | Colorado | 8065 | 950 | 1 |
1742165 | 1742165 | 2021-09-22 | Lake | Colorado | 8065 | 949 | 1 |
1738916 | 1738916 | 2021-09-21 | Lake | Colorado | 8065 | 948 | 1 |
1735667 | 1735667 | 2021-09-20 | Lake | Colorado | 8065 | 944 | 1 |
1732417 | 1732417 | 2021-09-19 | Lake | Colorado | 8065 | 944 | 1 |
1729167 | 1729167 | 2021-09-18 | Lake | Colorado | 8065 | 944 | 1 |
1725917 | 1725917 | 2021-09-17 | Lake | Colorado | 8065 | 944 | 1 |
1722668 | 1722668 | 2021-09-16 | Lake | Colorado | 8065 | 943 | 1 |
1719419 | 1719419 | 2021-09-15 | Lake | Colorado | 8065 | 942 | 1 |
1716171 | 1716171 | 2021-09-14 | Lake | Colorado | 8065 | 938 | 1 |
1712925 | 1712925 | 2021-09-13 | Lake | Colorado | 8065 | 936 | 1 |
1709678 | 1709678 | 2021-09-12 | Lake | Colorado | 8065 | 932 | 1 |
1706431 | 1706431 | 2021-09-11 | Lake | Colorado | 8065 | 932 | 1 |
1703183 | 1703183 | 2021-09-10 | Lake | Colorado | 8065 | 932 | 1 |
1699933 | 1699933 | 2021-09-09 | Lake | Colorado | 8065 | 931 | 1 |
1696684 | 1696684 | 2021-09-08 | Lake | Colorado | 8065 | 929 | 1 |
1693436 | 1693436 | 2021-09-07 | Lake | Colorado | 8065 | 927 | 2 |
1690187 | 1690187 | 2021-09-06 | Lake | Colorado | 8065 | 926 | 2 |
1686937 | 1686937 | 2021-09-05 | Lake | Colorado | 8065 | 923 | 2 |
1683687 | 1683687 | 2021-09-04 | Lake | Colorado | 8065 | 923 | 2 |
1680436 | 1680436 | 2021-09-03 | Lake | Colorado | 8065 | 923 | 2 |
1677188 | 1677188 | 2021-09-02 | Lake | Colorado | 8065 | 919 | 1 |
1673941 | 1673941 | 2021-09-01 | Lake | Colorado | 8065 | 917 | 1 |
1670693 | 1670693 | 2021-08-31 | Lake | Colorado | 8065 | 916 | 1 |
1667446 | 1667446 | 2021-08-30 | Lake | Colorado | 8065 | 913 | 1 |
1664199 | 1664199 | 2021-08-29 | Lake | Colorado | 8065 | 908 | 1 |
1660951 | 1660951 | 2021-08-28 | Lake | Colorado | 8065 | 908 | 1 |
1657703 | 1657703 | 2021-08-27 | Lake | Colorado | 8065 | 908 | 1 |
1654455 | 1654455 | 2021-08-26 | Lake | Colorado | 8065 | 905 | 1 |
1651208 | 1651208 | 2021-08-25 | Lake | Colorado | 8065 | 902 | 1 |
1647959 | 1647959 | 2021-08-24 | Lake | Colorado | 8065 | 897 | 1 |
1644711 | 1644711 | 2021-08-23 | Lake | Colorado | 8065 | 889 | 1 |
1641461 | 1641461 | 2021-08-22 | Lake | Colorado | 8065 | 884 | 1 |
1638211 | 1638211 | 2021-08-21 | Lake | Colorado | 8065 | 884 | 1 |
1634961 | 1634961 | 2021-08-20 | Lake | Colorado | 8065 | 884 | 1 |
1631712 | 1631712 | 2021-08-19 | Lake | Colorado | 8065 | 879 | 1 |
1628465 | 1628465 | 2021-08-18 | Lake | Colorado | 8065 | 880 | 1 |
1625218 | 1625218 | 2021-08-17 | Lake | Colorado | 8065 | 876 | 1 |
1621971 | 1621971 | 2021-08-16 | Lake | Colorado | 8065 | 874 | 1 |
1618724 | 1618724 | 2021-08-15 | Lake | Colorado | 8065 | 865 | 1 |
1615476 | 1615476 | 2021-08-14 | Lake | Colorado | 8065 | 865 | 1 |
1612227 | 1612227 | 2021-08-13 | Lake | Colorado | 8065 | 865 | 1 |
1608979 | 1608979 | 2021-08-12 | Lake | Colorado | 8065 | 862 | 1 |
1605730 | 1605730 | 2021-08-11 | Lake | Colorado | 8065 | 860 | 1 |
1602481 | 1602481 | 2021-08-10 | Lake | Colorado | 8065 | 858 | 1 |
1599232 | 1599232 | 2021-08-09 | Lake | Colorado | 8065 | 859 | 1 |
1595983 | 1595983 | 2021-08-08 | Lake | Colorado | 8065 | 850 | 1 |
1592734 | 1592734 | 2021-08-07 | Lake | Colorado | 8065 | 850 | 1 |
1589485 | 1589485 | 2021-08-06 | Lake | Colorado | 8065 | 850 | 1 |
1586236 | 1586236 | 2021-08-05 | Lake | Colorado | 8065 | 849 | 1 |
1582986 | 1582986 | 2021-08-04 | Lake | Colorado | 8065 | 850 | 1 |
1579736 | 1579736 | 2021-08-03 | Lake | Colorado | 8065 | 848 | 1 |
1576488 | 1576488 | 2021-08-02 | Lake | Colorado | 8065 | 845 | 1 |
1573240 | 1573240 | 2021-08-01 | Lake | Colorado | 8065 | 845 | 1 |
1569992 | 1569992 | 2021-07-31 | Lake | Colorado | 8065 | 845 | 1 |
1566744 | 1566744 | 2021-07-30 | Lake | Colorado | 8065 | 845 | 1 |
1563496 | 1563496 | 2021-07-29 | Lake | Colorado | 8065 | 845 | 1 |
1560248 | 1560248 | 2021-07-28 | Lake | Colorado | 8065 | 846 | 1 |
1557001 | 1557001 | 2021-07-27 | Lake | Colorado | 8065 | 844 | 1 |
1553754 | 1553754 | 2021-07-26 | Lake | Colorado | 8065 | 844 | 1 |
1550507 | 1550507 | 2021-07-25 | Lake | Colorado | 8065 | 845 | 1 |
1547260 | 1547260 | 2021-07-24 | Lake | Colorado | 8065 | 845 | 1 |
1544013 | 1544013 | 2021-07-23 | Lake | Colorado | 8065 | 845 | 1 |
1540765 | 1540765 | 2021-07-22 | Lake | Colorado | 8065 | 843 | 1 |
1537518 | 1537518 | 2021-07-21 | Lake | Colorado | 8065 | 843 | 1 |
1534270 | 1534270 | 2021-07-20 | Lake | Colorado | 8065 | 841 | 0 |
1531023 | 1531023 | 2021-07-19 | Lake | Colorado | 8065 | 841 | 0 |
1527776 | 1527776 | 2021-07-18 | Lake | Colorado | 8065 | 842 | 0 |
1524529 | 1524529 | 2021-07-17 | Lake | Colorado | 8065 | 842 | 0 |
1521281 | 1521281 | 2021-07-16 | Lake | Colorado | 8065 | 842 | 0 |
1518033 | 1518033 | 2021-07-15 | Lake | Colorado | 8065 | 839 | 0 |
1514786 | 1514786 | 2021-07-14 | Lake | Colorado | 8065 | 839 | 0 |
1511540 | 1511540 | 2021-07-13 | Lake | Colorado | 8065 | 839 | 0 |
1508293 | 1508293 | 2021-07-12 | Lake | Colorado | 8065 | 838 | 0 |
1505047 | 1505047 | 2021-07-11 | Lake | Colorado | 8065 | 838 | 0 |
1501801 | 1501801 | 2021-07-10 | Lake | Colorado | 8065 | 837 | 0 |
1498555 | 1498555 | 2021-07-09 | Lake | Colorado | 8065 | 837 | 0 |
1495308 | 1495308 | 2021-07-08 | Lake | Colorado | 8065 | 836 | 0 |
1492062 | 1492062 | 2021-07-07 | Lake | Colorado | 8065 | 836 | 0 |
1488815 | 1488815 | 2021-07-06 | Lake | Colorado | 8065 | 836 | 0 |
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);