ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 560 ✖
- 54 17
- 3 9
- 57 9
- 53 6
- 117 6
- 27 5
- 48 5
- 1873 5
- 1886 5
- 9 4
- 39 4
- 121 4
- 1888 4
- 4676 4
- 4689 4
- 4813 4
- 5 3
- 16 3
- 24 3
- 56 3
- 60 3
- 67 3
- 163 3
- 172 3
- 1141 3
- 1910 3
- 1919 3
- 1949 3
- 1968 3
- 1988 3
- 2018 3
- 2064 3
- 2140 3
- 2214 3
- 2288 3
- 2357 3
- 2438 3
- 2516 3
- 2597 3
- 2684 3
- 2759 3
- 2814 3
- 2870 3
- 2925 3
- 2981 3
- 3049 3
- 3099 3
- 3142 3
- 3205 3
- 3330 3
- 3557 3
- 3916 3
- 4199 3
- 4501 3
- 4554 3
- 4594 3
- 4647 3
- 4664 3
- 4716 3
- 4739 3
- 4752 3
- 4775 3
- 4800 3
- 4824 3
- 10 2
- 17 2
- 23 2
- 31 2
- 37 2
- 41 2
- 47 2
- 49 2
- 51 2
- 52 2
- 62 2
- 76 2
- 77 2
- 85 2
- 105 2
- 108 2
- 110 2
- 120 2
- 129 2
- 130 2
- 136 2
- 144 2
- 152 2
- 168 2
- 173 2
- 177 2
- 180 2
- 817 2
- 1028 2
- 1080 2
- 1120 2
- 1271 2
- 1297 2
- 1375 2
- 1455 2
- 1617 2
- 1735 2
- 1782 2
- 1826 2
- 1859 2
- 1883 2
- 1904 2
- 1911 2
- 1927 2
- 1982 2
- 4397 2
- 4413 2
- 4674 2
- 4785 2
- 4 1
- 6 1
- 13 1
- 14 1
- 20 1
- 26 1
- 28 1
- 29 1
- 30 1
- 32 1
- 36 1
- 40 1
- 42 1
- 44 1
- 45 1
- 55 1
- 58 1
- 61 1
- 63 1
- 65 1
- 68 1
- 69 1
- 70 1
- 73 1
- 75 1
- 79 1
- 81 1
- 82 1
- 83 1
- 86 1
- 87 1
- 92 1
- 97 1
- 102 1
- 103 1
- 104 1
- 107 1
- 109 1
- 111 1
- 114 1
- 115 1
- 119 1
- 122 1
- 125 1
- 128 1
- 131 1
- 134 1
- 138 1
- 140 1
- 141 1
- 145 1
- 146 1
- 147 1
- 148 1
- 155 1
- 156 1
- 157 1
- 158 1
- 161 1
- 162 1
- 167 1
- 170 1
- 174 1
- 175 1
- 179 1
- 183 1
- 184 1
- 190 1
- 191 1
- 193 1
- 200 1
- 204 1
- 215 1
- 219 1
- 224 1
- 226 1
- 232 1
- 242 1
- 246 1
- 254 1
- 261 1
- 268 1
- 274 1
- 282 1
- 292 1
- 304 1
- 314 1
- 325 1
- 335 1
- 347 1
- 361 1
- 371 1
- 392 1
- 406 1
- 419 1
- 431 1
- 447 1
- 475 1
- 503 1
- 515 1
- 526 1
- 534 1
- 540 1
- 557 1
- 570 1
- 583 1
- 596 1
- 608 1
- 624 1
- 633 1
- 650 1
- 676 1
- 695 1
- 709 1
- 735 1
- 747 1
- 759 1
- 775 1
- 790 1
- 806 1
- 835 1
- 841 1
- 849 1
- 857 1
- 885 1
- 893 1
- 901 1
- 912 1
- 931 1
- 942 1
- 950 1
- 954 1
- 955 1
- 959 1
- 964 1
- 969 1
- 987 1
- 996 1
- 1002 1
- 1006 1
- 1012 1
- 1043 1
- 1048 1
- 1055 1
- 1062 1
- 1069 1
- 1072 1
- 1074 1
- 1083 1
- 1085 1
- 1090 1
- 1094 1
- 1099 1
- 1103 1
- 1106 1
- 1115 1
- 1123 1
- 1134 1
- 1138 1
- 1160 1
- 1161 1
- 1164 1
- 1174 1
- 1187 1
- 1196 1
- 1202 1
- 1207 1
- 1212 1
- 1216 1
- 1219 1
- 1222 1
- 1227 1
- 1230 1
- 1232 1
- 1233 1
- 1240 1
- 1242 1
- 1250 1
- 1251 1
- 1254 1
- 1257 1
- 1263 1
- 1268 1
- 1281 1
- 1286 1
- 1287 1
- 1288 1
- 1289 1
- 1295 1
- 1296 1
- 1307 1
- 1312 1
- 1314 1
- 1318 1
- 1326 1
- 1327 1
- 1334 1
- 1335 1
- 1337 1
- 1340 1
- 1346 1
- 1358 1
- 1368 1
- 1384 1
- 1388 1
- 1394 1
- 1396 1
- 1399 1
- 1403 1
- 1408 1
- 1411 1
- 1421 1
- 1427 1
- 1429 1
- 1439 1
- 1442 1
- 1447 1
- 1471 1
- 1478 1
- 1484 1
- 1491 1
- 1498 1
- 1502 1
- 1513 1
- 1523 1
- 1539 1
- 1549 1
- 1552 1
- 1555 1
- 1565 1
- 1573 1
- 1587 1
- 1596 1
- 1604 1
- 1641 1
- 1644 1
- 1659 1
- 1662 1
- 1669 1
- 1674 1
- 1678 1
- 1691 1
- 1700 1
- 1714 1
- 1719 1
- 1725 1
- 1728 1
- 1729 1
- 1742 1
- 1750 1
- 1754 1
- 1755 1
- 1760 1
- 1764 1
- 1770 1
- 1776 1
- 1779 1
- 1780 1
- 1790 1
- 1796 1
- 1802 1
- 1803 1
- 1805 1
- 1807 1
- 1810 1
- 1811 1
- 1816 1
- 1820 1
- 1825 1
- 1828 1
- 1830 1
- 1834 1
- 1837 1
- 1842 1
- 1848 1
- 1856 1
- 1857 1
- 1867 1
- 1882 1
- 1890 1
- 1891 1
- 1895 1
- 1897 1
- 1900 1
- 1902 1
- 1903 1
- 1907 1
- 1908 1
- 1913 1
- 1916 1
- 1938 1
- 1943 1
- 1954 1
- 1957 1
- 1963 1
- 1967 1
- 1978 1
- 1987 1
- 1999 1
- 2002 1
- 2005 1
- 2010 1
- 2031 1
- 2038 1
- 2052 1
- 2059 1
- 2089 1
- 2106 1
- 2115 1
- 2126 1
- 2161 1
- 2173 1
- 2183 1
- 2194 1
- 2241 1
- 2251 1
- 2267 1
- 2277 1
- 2318 1
- 2327 1
- 2332 1
- 2340 1
- 2378 1
- 2397 1
- 2406 1
- 2421 1
- 2458 1
- 2473 1
- 2484 1
- 2500 1
- 2546 1
- 2555 1
- 2567 1
- 2585 1
- 2622 1
- 2633 1
- 2646 1
- 2662 1
- 2711 1
- 2720 1
- 2729 1
- 2740 1
- 2778 1
- 2787 1
- 2797 1
- 2810 1
- 2832 1
- 2841 1
- 2851 1
- 2864 1
- 2889 1
- 2894 1
- 2912 1
- 2917 1
- 2946 1
- 2957 1
- 2969 1
- 2984 1
- 3001 1
- 3014 1
- 3023 1
- 3036 1
- 3063 1
- 3074 1
- 3084 1
- 3094 1
- 3113 1
- 3117 1
- 3125 1
- 3133 1
- 3157 1
- 3168 1
- 3180 1
- 3190 1
- 3227 1
- 3254 1
- 3276 1
- 3303 1
- 3419 1
- 3439 1
- 3477 1
- 3519 1
- 3692 1
- 3780 1
- 3815 1
- 3861 1
- 4027 1
- 4065 1
- 4110 1
- 4153 1
- 4290 1
- 4314 1
- 4353 1
- 4453 1
- 4460 1
- 4476 1
- 4489 1
- 4518 1
- 4534 1
- 4541 1
- 4548 1
- 4567 1
- 4574 1
- 4579 1
- 4588 1
- 4622 1
- 4627 1
- 4639 1
- 4641 1
- 4650 1
- 4656 1
- 4658 1
- 4660 1
- 4670 1
- 4680 1
- 4683 1
- 4687 1
- 4703 1
- 4708 1
- 4712 1
- 4715 1
- 4718 1
- 4723 1
- 4729 1
- 4734 1
- 4740 1
- 4741 1
- 4745 1
- 4748 1
- 4762 1
- 4763 1
- 4764 1
- 4770 1
- 4793 1
- 4798 1
- 4806 1
- 4809 1
- 4810 1
- 4814 1
- 4816 1
- 4817 1
- 4822 1
- 4826 1
- 4831 1
- 4834 1
- 4874 1
- 4880 1
state 1
- Colorado 784
fips 1
- 8039 · 784 ✖
county 1
- Elbert 784
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499841 | 2499841 | 2022-05-13 | Elbert | Colorado | 8039 | 4880 | 40 |
2496583 | 2496583 | 2022-05-12 | Elbert | Colorado | 8039 | 4874 | 40 |
2493325 | 2493325 | 2022-05-11 | Elbert | Colorado | 8039 | 4834 | 40 |
2490067 | 2490067 | 2022-05-10 | Elbert | Colorado | 8039 | 4831 | 40 |
2486810 | 2486810 | 2022-05-09 | Elbert | Colorado | 8039 | 4826 | 40 |
2483552 | 2483552 | 2022-05-08 | Elbert | Colorado | 8039 | 4824 | 40 |
2480294 | 2480294 | 2022-05-07 | Elbert | Colorado | 8039 | 4824 | 40 |
2477036 | 2477036 | 2022-05-06 | Elbert | Colorado | 8039 | 4824 | 40 |
2473778 | 2473778 | 2022-05-05 | Elbert | Colorado | 8039 | 4822 | 40 |
2470521 | 2470521 | 2022-05-04 | Elbert | Colorado | 8039 | 4817 | 40 |
2467265 | 2467265 | 2022-05-03 | Elbert | Colorado | 8039 | 4816 | 40 |
2464010 | 2464010 | 2022-05-02 | Elbert | Colorado | 8039 | 4814 | 39 |
2460754 | 2460754 | 2022-05-01 | Elbert | Colorado | 8039 | 4813 | 39 |
2457498 | 2457498 | 2022-04-30 | Elbert | Colorado | 8039 | 4813 | 39 |
2454242 | 2454242 | 2022-04-29 | Elbert | Colorado | 8039 | 4813 | 39 |
2450986 | 2450986 | 2022-04-28 | Elbert | Colorado | 8039 | 4813 | 39 |
2447730 | 2447730 | 2022-04-27 | Elbert | Colorado | 8039 | 4810 | 39 |
2444474 | 2444474 | 2022-04-26 | Elbert | Colorado | 8039 | 4809 | 39 |
2441218 | 2441218 | 2022-04-25 | Elbert | Colorado | 8039 | 4806 | 39 |
2437962 | 2437962 | 2022-04-24 | Elbert | Colorado | 8039 | 4800 | 39 |
2434706 | 2434706 | 2022-04-23 | Elbert | Colorado | 8039 | 4800 | 39 |
2431450 | 2431450 | 2022-04-22 | Elbert | Colorado | 8039 | 4800 | 39 |
2428194 | 2428194 | 2022-04-21 | Elbert | Colorado | 8039 | 4798 | 39 |
2424938 | 2424938 | 2022-04-20 | Elbert | Colorado | 8039 | 4793 | 37 |
2421682 | 2421682 | 2022-04-19 | Elbert | Colorado | 8039 | 4785 | 37 |
2418426 | 2418426 | 2022-04-18 | Elbert | Colorado | 8039 | 4785 | 37 |
2415170 | 2415170 | 2022-04-17 | Elbert | Colorado | 8039 | 4775 | 37 |
2411914 | 2411914 | 2022-04-16 | Elbert | Colorado | 8039 | 4775 | 37 |
2408658 | 2408658 | 2022-04-15 | Elbert | Colorado | 8039 | 4775 | 37 |
2405402 | 2405402 | 2022-04-14 | Elbert | Colorado | 8039 | 4770 | 37 |
2402147 | 2402147 | 2022-04-13 | Elbert | Colorado | 8039 | 4764 | 37 |
2398892 | 2398892 | 2022-04-12 | Elbert | Colorado | 8039 | 4763 | 37 |
2395637 | 2395637 | 2022-04-11 | Elbert | Colorado | 8039 | 4762 | 37 |
2392381 | 2392381 | 2022-04-10 | Elbert | Colorado | 8039 | 4752 | 37 |
2389125 | 2389125 | 2022-04-09 | Elbert | Colorado | 8039 | 4752 | 37 |
2385870 | 2385870 | 2022-04-08 | Elbert | Colorado | 8039 | 4752 | 37 |
2382615 | 2382615 | 2022-04-07 | Elbert | Colorado | 8039 | 4748 | 37 |
2379360 | 2379360 | 2022-04-06 | Elbert | Colorado | 8039 | 4745 | 37 |
2376106 | 2376106 | 2022-04-05 | Elbert | Colorado | 8039 | 4741 | 37 |
2372854 | 2372854 | 2022-04-04 | Elbert | Colorado | 8039 | 4740 | 37 |
2369601 | 2369601 | 2022-04-03 | Elbert | Colorado | 8039 | 4739 | 37 |
2366348 | 2366348 | 2022-04-02 | Elbert | Colorado | 8039 | 4739 | 37 |
2363095 | 2363095 | 2022-04-01 | Elbert | Colorado | 8039 | 4739 | 37 |
2359841 | 2359841 | 2022-03-31 | Elbert | Colorado | 8039 | 4734 | 37 |
2356587 | 2356587 | 2022-03-30 | Elbert | Colorado | 8039 | 4729 | 37 |
2353334 | 2353334 | 2022-03-29 | Elbert | Colorado | 8039 | 4723 | 37 |
2350082 | 2350082 | 2022-03-28 | Elbert | Colorado | 8039 | 4718 | 37 |
2346829 | 2346829 | 2022-03-27 | Elbert | Colorado | 8039 | 4716 | 37 |
2343576 | 2343576 | 2022-03-26 | Elbert | Colorado | 8039 | 4716 | 37 |
2340323 | 2340323 | 2022-03-25 | Elbert | Colorado | 8039 | 4716 | 37 |
2337070 | 2337070 | 2022-03-24 | Elbert | Colorado | 8039 | 4715 | 37 |
2333816 | 2333816 | 2022-03-23 | Elbert | Colorado | 8039 | 4712 | 37 |
2330562 | 2330562 | 2022-03-22 | Elbert | Colorado | 8039 | 4708 | 37 |
2327310 | 2327310 | 2022-03-21 | Elbert | Colorado | 8039 | 4703 | 37 |
2324057 | 2324057 | 2022-03-20 | Elbert | Colorado | 8039 | 4689 | 37 |
2320803 | 2320803 | 2022-03-19 | Elbert | Colorado | 8039 | 4689 | 37 |
2317549 | 2317549 | 2022-03-18 | Elbert | Colorado | 8039 | 4689 | 37 |
2314296 | 2314296 | 2022-03-17 | Elbert | Colorado | 8039 | 4689 | 37 |
2311043 | 2311043 | 2022-03-16 | Elbert | Colorado | 8039 | 4687 | 37 |
2307790 | 2307790 | 2022-03-15 | Elbert | Colorado | 8039 | 4683 | 37 |
2304539 | 2304539 | 2022-03-14 | Elbert | Colorado | 8039 | 4680 | 37 |
2301287 | 2301287 | 2022-03-13 | Elbert | Colorado | 8039 | 4676 | 37 |
2298035 | 2298035 | 2022-03-12 | Elbert | Colorado | 8039 | 4676 | 37 |
2294783 | 2294783 | 2022-03-11 | Elbert | Colorado | 8039 | 4676 | 37 |
2291531 | 2291531 | 2022-03-10 | Elbert | Colorado | 8039 | 4676 | 37 |
2288279 | 2288279 | 2022-03-09 | Elbert | Colorado | 8039 | 4674 | 37 |
2285028 | 2285028 | 2022-03-08 | Elbert | Colorado | 8039 | 4674 | 37 |
2281776 | 2281776 | 2022-03-07 | Elbert | Colorado | 8039 | 4670 | 37 |
2278523 | 2278523 | 2022-03-06 | Elbert | Colorado | 8039 | 4664 | 37 |
2275270 | 2275270 | 2022-03-05 | Elbert | Colorado | 8039 | 4664 | 37 |
2272017 | 2272017 | 2022-03-04 | Elbert | Colorado | 8039 | 4664 | 37 |
2268765 | 2268765 | 2022-03-03 | Elbert | Colorado | 8039 | 4658 | 37 |
2265512 | 2265512 | 2022-03-02 | Elbert | Colorado | 8039 | 4660 | 37 |
2262261 | 2262261 | 2022-03-01 | Elbert | Colorado | 8039 | 4656 | 37 |
2259010 | 2259010 | 2022-02-28 | Elbert | Colorado | 8039 | 4650 | 37 |
2255759 | 2255759 | 2022-02-27 | Elbert | Colorado | 8039 | 4647 | 36 |
2252508 | 2252508 | 2022-02-26 | Elbert | Colorado | 8039 | 4647 | 36 |
2249257 | 2249257 | 2022-02-25 | Elbert | Colorado | 8039 | 4647 | 36 |
2246006 | 2246006 | 2022-02-24 | Elbert | Colorado | 8039 | 4641 | 36 |
2242755 | 2242755 | 2022-02-23 | Elbert | Colorado | 8039 | 4639 | 37 |
2239504 | 2239504 | 2022-02-22 | Elbert | Colorado | 8039 | 4627 | 36 |
2236253 | 2236253 | 2022-02-21 | Elbert | Colorado | 8039 | 4622 | 36 |
2233002 | 2233002 | 2022-02-20 | Elbert | Colorado | 8039 | 4594 | 36 |
2229751 | 2229751 | 2022-02-19 | Elbert | Colorado | 8039 | 4594 | 36 |
2226500 | 2226500 | 2022-02-18 | Elbert | Colorado | 8039 | 4594 | 36 |
2223249 | 2223249 | 2022-02-17 | Elbert | Colorado | 8039 | 4588 | 36 |
2219998 | 2219998 | 2022-02-16 | Elbert | Colorado | 8039 | 4579 | 36 |
2216747 | 2216747 | 2022-02-15 | Elbert | Colorado | 8039 | 4574 | 36 |
2213496 | 2213496 | 2022-02-14 | Elbert | Colorado | 8039 | 4567 | 36 |
2210244 | 2210244 | 2022-02-13 | Elbert | Colorado | 8039 | 4554 | 35 |
2206991 | 2206991 | 2022-02-12 | Elbert | Colorado | 8039 | 4554 | 35 |
2203738 | 2203738 | 2022-02-11 | Elbert | Colorado | 8039 | 4554 | 35 |
2200485 | 2200485 | 2022-02-10 | Elbert | Colorado | 8039 | 4548 | 35 |
2197231 | 2197231 | 2022-02-09 | Elbert | Colorado | 8039 | 4541 | 35 |
2193977 | 2193977 | 2022-02-08 | Elbert | Colorado | 8039 | 4534 | 34 |
2190723 | 2190723 | 2022-02-07 | Elbert | Colorado | 8039 | 4518 | 34 |
2187470 | 2187470 | 2022-02-06 | Elbert | Colorado | 8039 | 4501 | 33 |
2184217 | 2184217 | 2022-02-05 | Elbert | Colorado | 8039 | 4501 | 33 |
2180965 | 2180965 | 2022-02-04 | Elbert | Colorado | 8039 | 4501 | 33 |
2177714 | 2177714 | 2022-02-03 | Elbert | Colorado | 8039 | 4489 | 33 |
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);