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 county
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 |
---|---|---|---|---|---|---|---|
6196 | 6196 | 2020-03-21 | Elbert | Colorado | 8039 | 3 | 0 |
7231 | 7231 | 2020-03-22 | Elbert | Colorado | 8039 | 3 | 0 |
8374 | 8374 | 2020-03-23 | Elbert | Colorado | 8039 | 3 | 0 |
9617 | 9617 | 2020-03-24 | Elbert | Colorado | 8039 | 3 | 0 |
10990 | 10990 | 2020-03-25 | Elbert | Colorado | 8039 | 3 | 0 |
12535 | 12535 | 2020-03-26 | Elbert | Colorado | 8039 | 3 | 0 |
14203 | 14203 | 2020-03-27 | Elbert | Colorado | 8039 | 3 | 0 |
15986 | 15986 | 2020-03-28 | Elbert | Colorado | 8039 | 3 | 0 |
17876 | 17876 | 2020-03-29 | Elbert | Colorado | 8039 | 3 | 0 |
19854 | 19854 | 2020-03-30 | Elbert | Colorado | 8039 | 4 | 0 |
21929 | 21929 | 2020-03-31 | Elbert | Colorado | 8039 | 5 | 0 |
24088 | 24088 | 2020-04-01 | Elbert | Colorado | 8039 | 5 | 0 |
26318 | 26318 | 2020-04-02 | Elbert | Colorado | 8039 | 5 | 0 |
28618 | 28618 | 2020-04-03 | Elbert | Colorado | 8039 | 6 | 0 |
30975 | 30975 | 2020-04-04 | Elbert | Colorado | 8039 | 9 | 1 |
33381 | 33381 | 2020-04-05 | Elbert | Colorado | 8039 | 9 | 1 |
35826 | 35826 | 2020-04-06 | Elbert | Colorado | 8039 | 9 | 1 |
38316 | 38316 | 2020-04-07 | Elbert | Colorado | 8039 | 9 | 1 |
40859 | 40859 | 2020-04-08 | Elbert | Colorado | 8039 | 10 | 1 |
43431 | 43431 | 2020-04-09 | Elbert | Colorado | 8039 | 10 | 1 |
46031 | 46031 | 2020-04-10 | Elbert | Colorado | 8039 | 13 | 1 |
48661 | 48661 | 2020-04-11 | Elbert | Colorado | 8039 | 14 | 1 |
51323 | 51323 | 2020-04-12 | Elbert | Colorado | 8039 | 16 | 1 |
54002 | 54002 | 2020-04-13 | Elbert | Colorado | 8039 | 16 | 1 |
56694 | 56694 | 2020-04-14 | Elbert | Colorado | 8039 | 17 | 1 |
59402 | 59402 | 2020-04-15 | Elbert | Colorado | 8039 | 16 | 1 |
62121 | 62121 | 2020-04-16 | Elbert | Colorado | 8039 | 17 | 1 |
64854 | 64854 | 2020-04-17 | Elbert | Colorado | 8039 | 20 | 1 |
67602 | 67602 | 2020-04-18 | Elbert | Colorado | 8039 | 23 | 1 |
70364 | 70364 | 2020-04-19 | Elbert | Colorado | 8039 | 23 | 1 |
73133 | 73133 | 2020-04-20 | Elbert | Colorado | 8039 | 24 | 1 |
75909 | 75909 | 2020-04-21 | Elbert | Colorado | 8039 | 24 | 1 |
78693 | 78693 | 2020-04-22 | Elbert | Colorado | 8039 | 24 | 1 |
81487 | 81487 | 2020-04-23 | Elbert | Colorado | 8039 | 26 | 1 |
84287 | 84287 | 2020-04-24 | Elbert | Colorado | 8039 | 27 | 1 |
87095 | 87095 | 2020-04-25 | Elbert | Colorado | 8039 | 27 | 1 |
89912 | 89912 | 2020-04-26 | Elbert | Colorado | 8039 | 27 | 1 |
92730 | 92730 | 2020-04-27 | Elbert | Colorado | 8039 | 27 | 1 |
95562 | 95562 | 2020-04-28 | Elbert | Colorado | 8039 | 27 | 1 |
98407 | 98407 | 2020-04-29 | Elbert | Colorado | 8039 | 28 | 1 |
101257 | 101257 | 2020-04-30 | Elbert | Colorado | 8039 | 29 | 1 |
104112 | 104112 | 2020-05-01 | Elbert | Colorado | 8039 | 30 | 1 |
106977 | 106977 | 2020-05-02 | Elbert | Colorado | 8039 | 31 | 1 |
109846 | 109846 | 2020-05-03 | Elbert | Colorado | 8039 | 31 | 1 |
112721 | 112721 | 2020-05-04 | Elbert | Colorado | 8039 | 32 | 1 |
115604 | 115604 | 2020-05-05 | Elbert | Colorado | 8039 | 36 | 1 |
118563 | 118563 | 2020-05-06 | Elbert | Colorado | 8039 | 37 | 1 |
121532 | 121532 | 2020-05-07 | Elbert | Colorado | 8039 | 37 | 1 |
124512 | 124512 | 2020-05-08 | Elbert | Colorado | 8039 | 39 | 1 |
127498 | 127498 | 2020-05-09 | Elbert | Colorado | 8039 | 39 | 1 |
130489 | 130489 | 2020-05-10 | Elbert | Colorado | 8039 | 39 | 1 |
133480 | 133480 | 2020-05-11 | Elbert | Colorado | 8039 | 39 | 1 |
136469 | 136469 | 2020-05-12 | Elbert | Colorado | 8039 | 40 | 2 |
139460 | 139460 | 2020-05-13 | Elbert | Colorado | 8039 | 41 | 2 |
142456 | 142456 | 2020-05-14 | Elbert | Colorado | 8039 | 41 | 2 |
145456 | 145456 | 2020-05-15 | Elbert | Colorado | 8039 | 42 | 2 |
148459 | 148459 | 2020-05-16 | Elbert | Colorado | 8039 | 44 | 2 |
151468 | 151468 | 2020-05-17 | Elbert | Colorado | 8039 | 45 | 2 |
154480 | 154480 | 2020-05-18 | Elbert | Colorado | 8039 | 47 | 2 |
157496 | 157496 | 2020-05-19 | Elbert | Colorado | 8039 | 47 | 2 |
160522 | 160522 | 2020-05-20 | Elbert | Colorado | 8039 | 48 | 2 |
163550 | 163550 | 2020-05-21 | Elbert | Colorado | 8039 | 48 | 2 |
166583 | 166583 | 2020-05-22 | Elbert | Colorado | 8039 | 48 | 2 |
169620 | 169620 | 2020-05-23 | Elbert | Colorado | 8039 | 48 | 2 |
172661 | 172661 | 2020-05-24 | Elbert | Colorado | 8039 | 48 | 2 |
175705 | 175705 | 2020-05-25 | Elbert | Colorado | 8039 | 49 | 2 |
178749 | 178749 | 2020-05-26 | Elbert | Colorado | 8039 | 49 | 2 |
181793 | 181793 | 2020-05-27 | Elbert | Colorado | 8039 | 51 | 2 |
184847 | 184847 | 2020-05-28 | Elbert | Colorado | 8039 | 51 | 2 |
187903 | 187903 | 2020-05-29 | Elbert | Colorado | 8039 | 52 | 2 |
190968 | 190968 | 2020-05-30 | Elbert | Colorado | 8039 | 52 | 2 |
194035 | 194035 | 2020-05-31 | Elbert | Colorado | 8039 | 53 | 2 |
197105 | 197105 | 2020-06-01 | Elbert | Colorado | 8039 | 53 | 2 |
200178 | 200178 | 2020-06-02 | Elbert | Colorado | 8039 | 53 | 2 |
203254 | 203254 | 2020-06-03 | Elbert | Colorado | 8039 | 53 | 2 |
206334 | 206334 | 2020-06-04 | Elbert | Colorado | 8039 | 53 | 2 |
209415 | 209415 | 2020-06-05 | Elbert | Colorado | 8039 | 53 | 2 |
212500 | 212500 | 2020-06-06 | Elbert | Colorado | 8039 | 54 | 2 |
215587 | 215587 | 2020-06-07 | Elbert | Colorado | 8039 | 54 | 2 |
218678 | 218678 | 2020-06-08 | Elbert | Colorado | 8039 | 56 | 2 |
221773 | 221773 | 2020-06-09 | Elbert | Colorado | 8039 | 57 | 2 |
224868 | 224868 | 2020-06-10 | Elbert | Colorado | 8039 | 54 | 2 |
227970 | 227970 | 2020-06-11 | Elbert | Colorado | 8039 | 54 | 2 |
231073 | 231073 | 2020-06-12 | Elbert | Colorado | 8039 | 54 | 2 |
234179 | 234179 | 2020-06-13 | Elbert | Colorado | 8039 | 54 | 2 |
237286 | 237286 | 2020-06-14 | Elbert | Colorado | 8039 | 54 | 2 |
240394 | 240394 | 2020-06-15 | Elbert | Colorado | 8039 | 54 | 2 |
243505 | 243505 | 2020-06-16 | Elbert | Colorado | 8039 | 54 | 2 |
246618 | 246618 | 2020-06-17 | Elbert | Colorado | 8039 | 54 | 2 |
249730 | 249730 | 2020-06-18 | Elbert | Colorado | 8039 | 54 | 2 |
252845 | 252845 | 2020-06-19 | Elbert | Colorado | 8039 | 54 | 2 |
255964 | 255964 | 2020-06-20 | Elbert | Colorado | 8039 | 54 | 2 |
259091 | 259091 | 2020-06-21 | Elbert | Colorado | 8039 | 54 | 2 |
262218 | 262218 | 2020-06-22 | Elbert | Colorado | 8039 | 54 | 2 |
265346 | 265346 | 2020-06-23 | Elbert | Colorado | 8039 | 54 | 2 |
268476 | 268476 | 2020-06-24 | Elbert | Colorado | 8039 | 54 | 2 |
271611 | 271611 | 2020-06-25 | Elbert | Colorado | 8039 | 55 | 2 |
274751 | 274751 | 2020-06-26 | Elbert | Colorado | 8039 | 56 | 2 |
277899 | 277899 | 2020-06-27 | Elbert | Colorado | 8039 | 56 | 2 |
281046 | 281046 | 2020-06-28 | Elbert | Colorado | 8039 | 57 | 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);