ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 8065 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 446 ✖
- 80 12
- 79 11
- 27 9
- 23 8
- 845 8
- 51 7
- 1770 7
- 3 6
- 8 6
- 38 6
- 61 6
- 99 6
- 834 6
- 836 6
- 1789 6
- 4 5
- 52 5
- 81 5
- 824 5
- 1780 5
- 1787 5
- 1820 5
- 17 4
- 26 4
- 48 4
- 54 4
- 60 4
- 87 4
- 661 4
- 671 4
- 697 4
- 793 4
- 825 4
- 850 4
- 944 4
- 1076 4
- 1128 4
- 1779 4
- 21 3
- 31 3
- 39 3
- 50 3
- 77 3
- 91 3
- 133 3
- 401 3
- 461 3
- 514 3
- 651 3
- 776 3
- 786 3
- 787 3
- 816 3
- 835 3
- 839 3
- 842 3
- 865 3
- 884 3
- 908 3
- 923 3
- 932 3
- 953 3
- 959 3
- 972 3
- 997 3
- 1023 3
- 1044 3
- 1063 3
- 1100 3
- 1161 3
- 1208 3
- 1229 3
- 1245 3
- 1275 3
- 1375 3
- 1592 3
- 1654 3
- 1735 3
- 1758 3
- 1767 3
- 1774 3
- 1777 3
- 1792 3
- 1793 3
- 1795 3
- 1808 3
- 1817 3
- 2 2
- 5 2
- 20 2
- 29 2
- 46 2
- 70 2
- 73 2
- 74 2
- 83 2
- 90 2
- 94 2
- 104 2
- 105 2
- 117 2
- 122 2
- 135 2
- 143 2
- 151 2
- 354 2
- 437 2
- 448 2
- 476 2
- 479 2
- 486 2
- 487 2
- 656 2
- 659 2
- 660 2
- 686 2
- 688 2
- 699 2
- 705 2
- 714 2
- 734 2
- 767 2
- 785 2
- 790 2
- 796 2
- 808 2
- 809 2
- 815 2
- 826 2
- 827 2
- 829 2
- 837 2
- 838 2
- 841 2
- 843 2
- 844 2
- 1056 2
- 1078 2
- 1701 2
- 1710 2
- 1765 2
- 1768 2
- 1772 2
- 1778 2
- 1784 2
- 1790 2
- 1 1
- 9 1
- 10 1
- 12 1
- 16 1
- 18 1
- 19 1
- 24 1
- 32 1
- 34 1
- 35 1
- 36 1
- 37 1
- 40 1
- 42 1
- 53 1
- 56 1
- 57 1
- 59 1
- 67 1
- 68 1
- 69 1
- 71 1
- 82 1
- 84 1
- 85 1
- 86 1
- 88 1
- 89 1
- 92 1
- 93 1
- 95 1
- 96 1
- 98 1
- 101 1
- 103 1
- 110 1
- 112 1
- 114 1
- 116 1
- 118 1
- 121 1
- 124 1
- 127 1
- 132 1
- 152 1
- 155 1
- 160 1
- 162 1
- 163 1
- 168 1
- 172 1
- 173 1
- 175 1
- 181 1
- 184 1
- 196 1
- 199 1
- 202 1
- 209 1
- 221 1
- 224 1
- 230 1
- 237 1
- 239 1
- 248 1
- 255 1
- 265 1
- 267 1
- 272 1
- 273 1
- 276 1
- 281 1
- 291 1
- 304 1
- 314 1
- 318 1
- 319 1
- 333 1
- 336 1
- 340 1
- 346 1
- 350 1
- 352 1
- 371 1
- 378 1
- 383 1
- 385 1
- 387 1
- 391 1
- 392 1
- 397 1
- 399 1
- 400 1
- 407 1
- 413 1
- 419 1
- 426 1
- 433 1
- 444 1
- 457 1
- 458 1
- 465 1
- 468 1
- 471 1
- 477 1
- 478 1
- 482 1
- 495 1
- 497 1
- 502 1
- 535 1
- 541 1
- 565 1
- 579 1
- 586 1
- 595 1
- 597 1
- 600 1
- 606 1
- 610 1
- 613 1
- 617 1
- 621 1
- 623 1
- 624 1
- 631 1
- 641 1
- 646 1
- 650 1
- 653 1
- 655 1
- 658 1
- 665 1
- 667 1
- 669 1
- 670 1
- 675 1
- 677 1
- 680 1
- 685 1
- 691 1
- 693 1
- 694 1
- 701 1
- 702 1
- 703 1
- 704 1
- 709 1
- 715 1
- 717 1
- 722 1
- 723 1
- 727 1
- 731 1
- 733 1
- 735 1
- 737 1
- 739 1
- 749 1
- 765 1
- 769 1
- 771 1
- 772 1
- 773 1
- 778 1
- 782 1
- 789 1
- 792 1
- 798 1
- 800 1
- 803 1
- 806 1
- 811 1
- 812 1
- 819 1
- 846 1
- 848 1
- 849 1
- 858 1
- 859 1
- 860 1
- 862 1
- 874 1
- 876 1
- 879 1
- 880 1
- 889 1
- 897 1
- 902 1
- 905 1
- 913 1
- 916 1
- 917 1
- 919 1
- 926 1
- 927 1
- 929 1
- 931 1
- 936 1
- 938 1
- 942 1
- 943 1
- 948 1
- 949 1
- 950 1
- 954 1
- 958 1
- 960 1
- 961 1
- 962 1
- 965 1
- 966 1
- 969 1
- 973 1
- 974 1
- 978 1
- 994 1
- 1002 1
- 1009 1
- 1012 1
- 1017 1
- 1025 1
- 1029 1
- 1035 1
- 1041 1
- 1058 1
- 1060 1
- 1068 1
- 1073 1
- 1075 1
- 1086 1
- 1097 1
- 1104 1
- 1119 1
- 1127 1
- 1130 1
- 1134 1
- 1136 1
- 1150 1
- 1179 1
- 1191 1
- 1194 1
- 1202 1
- 1210 1
- 1213 1
- 1218 1
- 1226 1
- 1231 1
- 1236 1
- 1240 1
- 1242 1
- 1250 1
- 1255 1
- 1260 1
- 1271 1
- 1286 1
- 1314 1
- 1338 1
- 1341 1
- 1460 1
- 1517 1
- 1552 1
- 1564 1
- 1604 1
- 1617 1
- 1631 1
- 1649 1
- 1680 1
- 1690 1
- 1698 1
- 1718 1
- 1721 1
- 1724 1
- 1731 1
- 1745 1
- 1751 1
- 1753 1
- 1755 1
- 1760 1
- 1763 1
- 1782 1
- 1785 1
- 1786 1
- 1794 1
- 1797 1
- 1799 1
- 1803 1
- 1804 1
- 1809 1
- 1811 1
- 1814 1
- 1815 1
- 1818 1
- 1819 1
- 1824 1
- 1825 1
- 1826 1
- 1842 1
- 1843 1
state 1
- Colorado · 774 ✖
fips 1
- 8065 · 774 ✖
county 1
- Lake 774
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499854 | 2499854 | 2022-05-13 | Lake | Colorado | 8065 | 1843 | 2 |
2496596 | 2496596 | 2022-05-12 | Lake | Colorado | 8065 | 1842 | 2 |
2493338 | 2493338 | 2022-05-11 | Lake | Colorado | 8065 | 1826 | 2 |
2490080 | 2490080 | 2022-05-10 | Lake | Colorado | 8065 | 1825 | 2 |
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2483565 | 2483565 | 2022-05-08 | Lake | Colorado | 8065 | 1820 | 2 |
2480307 | 2480307 | 2022-05-07 | Lake | Colorado | 8065 | 1820 | 2 |
2477049 | 2477049 | 2022-05-06 | Lake | Colorado | 8065 | 1820 | 2 |
2473791 | 2473791 | 2022-05-05 | Lake | Colorado | 8065 | 1820 | 2 |
2470534 | 2470534 | 2022-05-04 | Lake | Colorado | 8065 | 1819 | 2 |
2467278 | 2467278 | 2022-05-03 | Lake | Colorado | 8065 | 1820 | 2 |
2464023 | 2464023 | 2022-05-02 | Lake | Colorado | 8065 | 1818 | 2 |
2460767 | 2460767 | 2022-05-01 | Lake | Colorado | 8065 | 1817 | 2 |
2457511 | 2457511 | 2022-04-30 | Lake | Colorado | 8065 | 1817 | 2 |
2454255 | 2454255 | 2022-04-29 | Lake | Colorado | 8065 | 1817 | 2 |
2450999 | 2450999 | 2022-04-28 | Lake | Colorado | 8065 | 1815 | 2 |
2447743 | 2447743 | 2022-04-27 | Lake | Colorado | 8065 | 1814 | 2 |
2444487 | 2444487 | 2022-04-26 | Lake | Colorado | 8065 | 1811 | 2 |
2441231 | 2441231 | 2022-04-25 | Lake | Colorado | 8065 | 1809 | 2 |
2437975 | 2437975 | 2022-04-24 | Lake | Colorado | 8065 | 1808 | 2 |
2434719 | 2434719 | 2022-04-23 | Lake | Colorado | 8065 | 1808 | 2 |
2431463 | 2431463 | 2022-04-22 | Lake | Colorado | 8065 | 1808 | 2 |
2428207 | 2428207 | 2022-04-21 | Lake | Colorado | 8065 | 1804 | 2 |
2424951 | 2424951 | 2022-04-20 | Lake | Colorado | 8065 | 1803 | 2 |
2421695 | 2421695 | 2022-04-19 | Lake | Colorado | 8065 | 1799 | 2 |
2418439 | 2418439 | 2022-04-18 | Lake | Colorado | 8065 | 1797 | 2 |
2415183 | 2415183 | 2022-04-17 | Lake | Colorado | 8065 | 1795 | 2 |
2411927 | 2411927 | 2022-04-16 | Lake | Colorado | 8065 | 1795 | 2 |
2408671 | 2408671 | 2022-04-15 | Lake | Colorado | 8065 | 1795 | 2 |
2405415 | 2405415 | 2022-04-14 | Lake | Colorado | 8065 | 1794 | 2 |
2402160 | 2402160 | 2022-04-13 | Lake | Colorado | 8065 | 1793 | 2 |
2398905 | 2398905 | 2022-04-12 | Lake | Colorado | 8065 | 1793 | 2 |
2395650 | 2395650 | 2022-04-11 | Lake | Colorado | 8065 | 1793 | 2 |
2392394 | 2392394 | 2022-04-10 | Lake | Colorado | 8065 | 1792 | 2 |
2389138 | 2389138 | 2022-04-09 | Lake | Colorado | 8065 | 1792 | 2 |
2385883 | 2385883 | 2022-04-08 | Lake | Colorado | 8065 | 1792 | 2 |
2382628 | 2382628 | 2022-04-07 | Lake | Colorado | 8065 | 1790 | 2 |
2379373 | 2379373 | 2022-04-06 | Lake | Colorado | 8065 | 1790 | 2 |
2376119 | 2376119 | 2022-04-05 | Lake | Colorado | 8065 | 1789 | 2 |
2372867 | 2372867 | 2022-04-04 | Lake | Colorado | 8065 | 1789 | 2 |
2369614 | 2369614 | 2022-04-03 | Lake | Colorado | 8065 | 1789 | 2 |
2366361 | 2366361 | 2022-04-02 | Lake | Colorado | 8065 | 1789 | 2 |
2363108 | 2363108 | 2022-04-01 | Lake | Colorado | 8065 | 1789 | 2 |
2359854 | 2359854 | 2022-03-31 | Lake | Colorado | 8065 | 1789 | 2 |
2356600 | 2356600 | 2022-03-30 | Lake | Colorado | 8065 | 1786 | 2 |
2353347 | 2353347 | 2022-03-29 | Lake | Colorado | 8065 | 1787 | 2 |
2350095 | 2350095 | 2022-03-28 | Lake | Colorado | 8065 | 1787 | 2 |
2346842 | 2346842 | 2022-03-27 | Lake | Colorado | 8065 | 1787 | 2 |
2343589 | 2343589 | 2022-03-26 | Lake | Colorado | 8065 | 1787 | 2 |
2340336 | 2340336 | 2022-03-25 | Lake | Colorado | 8065 | 1787 | 2 |
2337083 | 2337083 | 2022-03-24 | Lake | Colorado | 8065 | 1785 | 2 |
2333829 | 2333829 | 2022-03-23 | Lake | Colorado | 8065 | 1784 | 2 |
2330575 | 2330575 | 2022-03-22 | Lake | Colorado | 8065 | 1784 | 2 |
2327323 | 2327323 | 2022-03-21 | Lake | Colorado | 8065 | 1782 | 2 |
2324070 | 2324070 | 2022-03-20 | Lake | Colorado | 8065 | 1780 | 2 |
2320816 | 2320816 | 2022-03-19 | Lake | Colorado | 8065 | 1780 | 2 |
2317562 | 2317562 | 2022-03-18 | Lake | Colorado | 8065 | 1780 | 2 |
2314309 | 2314309 | 2022-03-17 | Lake | Colorado | 8065 | 1780 | 2 |
2311056 | 2311056 | 2022-03-16 | Lake | Colorado | 8065 | 1780 | 2 |
2307803 | 2307803 | 2022-03-15 | Lake | Colorado | 8065 | 1779 | 2 |
2304552 | 2304552 | 2022-03-14 | Lake | Colorado | 8065 | 1779 | 2 |
2301300 | 2301300 | 2022-03-13 | Lake | Colorado | 8065 | 1777 | 2 |
2298048 | 2298048 | 2022-03-12 | Lake | Colorado | 8065 | 1777 | 2 |
2294796 | 2294796 | 2022-03-11 | Lake | Colorado | 8065 | 1777 | 2 |
2291544 | 2291544 | 2022-03-10 | Lake | Colorado | 8065 | 1779 | 2 |
2288292 | 2288292 | 2022-03-09 | Lake | Colorado | 8065 | 1779 | 2 |
2285041 | 2285041 | 2022-03-08 | Lake | Colorado | 8065 | 1778 | 2 |
2281789 | 2281789 | 2022-03-07 | Lake | Colorado | 8065 | 1778 | 2 |
2278536 | 2278536 | 2022-03-06 | Lake | Colorado | 8065 | 1774 | 2 |
2275283 | 2275283 | 2022-03-05 | Lake | Colorado | 8065 | 1774 | 2 |
2272030 | 2272030 | 2022-03-04 | Lake | Colorado | 8065 | 1774 | 2 |
2268778 | 2268778 | 2022-03-03 | Lake | Colorado | 8065 | 1772 | 2 |
2265525 | 2265525 | 2022-03-02 | Lake | Colorado | 8065 | 1772 | 2 |
2262274 | 2262274 | 2022-03-01 | Lake | Colorado | 8065 | 1770 | 2 |
2259023 | 2259023 | 2022-02-28 | Lake | Colorado | 8065 | 1770 | 2 |
2255772 | 2255772 | 2022-02-27 | Lake | Colorado | 8065 | 1770 | 2 |
2252521 | 2252521 | 2022-02-26 | Lake | Colorado | 8065 | 1770 | 2 |
2249270 | 2249270 | 2022-02-25 | Lake | Colorado | 8065 | 1770 | 2 |
2246019 | 2246019 | 2022-02-24 | Lake | Colorado | 8065 | 1770 | 2 |
2242768 | 2242768 | 2022-02-23 | Lake | Colorado | 8065 | 1770 | 2 |
2239517 | 2239517 | 2022-02-22 | Lake | Colorado | 8065 | 1768 | 2 |
2236266 | 2236266 | 2022-02-21 | Lake | Colorado | 8065 | 1768 | 2 |
2233015 | 2233015 | 2022-02-20 | Lake | Colorado | 8065 | 1767 | 2 |
2229764 | 2229764 | 2022-02-19 | Lake | Colorado | 8065 | 1767 | 2 |
2226513 | 2226513 | 2022-02-18 | Lake | Colorado | 8065 | 1767 | 2 |
2223262 | 2223262 | 2022-02-17 | Lake | Colorado | 8065 | 1765 | 2 |
2220011 | 2220011 | 2022-02-16 | Lake | Colorado | 8065 | 1765 | 2 |
2216760 | 2216760 | 2022-02-15 | Lake | Colorado | 8065 | 1763 | 2 |
2213509 | 2213509 | 2022-02-14 | Lake | Colorado | 8065 | 1760 | 2 |
2210257 | 2210257 | 2022-02-13 | Lake | Colorado | 8065 | 1758 | 2 |
2207004 | 2207004 | 2022-02-12 | Lake | Colorado | 8065 | 1758 | 2 |
2203751 | 2203751 | 2022-02-11 | Lake | Colorado | 8065 | 1758 | 2 |
2200498 | 2200498 | 2022-02-10 | Lake | Colorado | 8065 | 1755 | 2 |
2197244 | 2197244 | 2022-02-09 | Lake | Colorado | 8065 | 1753 | 2 |
2193990 | 2193990 | 2022-02-08 | Lake | Colorado | 8065 | 1751 | 2 |
2190736 | 2190736 | 2022-02-07 | Lake | Colorado | 8065 | 1745 | 2 |
2187483 | 2187483 | 2022-02-06 | Lake | Colorado | 8065 | 1735 | 2 |
2184230 | 2184230 | 2022-02-05 | Lake | Colorado | 8065 | 1735 | 2 |
2180978 | 2180978 | 2022-02-04 | Lake | Colorado | 8065 | 1735 | 2 |
2177727 | 2177727 | 2022-02-03 | Lake | Colorado | 8065 | 1731 | 2 |
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);