ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8117 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 608 ✖
- 262 5
- 344 5
- 293 4
- 327 4
- 363 4
- 366 4
- 3735 4
- 3742 4
- 9651 4
- 2 3
- 7 3
- 88 3
- 269 3
- 346 3
- 349 3
- 368 3
- 2623 3
- 3073 3
- 3705 3
- 3737 3
- 3771 3
- 3774 3
- 3811 3
- 3866 3
- 3952 3
- 4019 3
- 4117 3
- 4194 3
- 4270 3
- 4330 3
- 4385 3
- 4444 3
- 4487 3
- 4540 3
- 4610 3
- 4688 3
- 4747 3
- 4822 3
- 4916 3
- 5049 3
- 5196 3
- 5310 3
- 5444 3
- 5496 3
- 5574 3
- 5984 3
- 7124 3
- 7829 3
- 8640 3
- 8998 3
- 9349 3
- 9420 3
- 9462 3
- 9518 3
- 9560 3
- 9607 3
- 9711 3
- 9746 3
- 9796 3
- 9842 3
- 9900 3
- 9947 3
- 9979 3
- 3 2
- 9 2
- 10 2
- 11 2
- 68 2
- 86 2
- 97 2
- 144 2
- 155 2
- 239 2
- 248 2
- 256 2
- 264 2
- 267 2
- 281 2
- 294 2
- 304 2
- 306 2
- 318 2
- 323 2
- 339 2
- 361 2
- 365 2
- 370 2
- 423 2
- 463 2
- 1826 2
- 2190 2
- 2532 2
- 3000 2
- 3145 2
- 3494 2
- 3666 2
- 3673 2
- 3690 2
- 3702 2
- 3730 2
- 3738 2
- 3740 2
- 3745 2
- 3748 2
- 3755 2
- 3772 2
- 3827 2
- 3903 2
- 9202 2
- 9220 2
- 4 1
- 5 1
- 8 1
- 14 1
- 20 1
- 23 1
- 26 1
- 35 1
- 43 1
- 45 1
- 47 1
- 53 1
- 56 1
- 57 1
- 61 1
- 72 1
- 74 1
- 76 1
- 77 1
- 82 1
- 89 1
- 105 1
- 106 1
- 119 1
- 121 1
- 128 1
- 130 1
- 136 1
- 151 1
- 156 1
- 162 1
- 165 1
- 169 1
- 171 1
- 174 1
- 175 1
- 178 1
- 182 1
- 183 1
- 186 1
- 192 1
- 194 1
- 195 1
- 197 1
- 203 1
- 205 1
- 207 1
- 212 1
- 213 1
- 214 1
- 219 1
- 224 1
- 226 1
- 231 1
- 233 1
- 237 1
- 243 1
- 247 1
- 252 1
- 253 1
- 254 1
- 257 1
- 258 1
- 263 1
- 265 1
- 274 1
- 276 1
- 277 1
- 278 1
- 286 1
- 288 1
- 289 1
- 298 1
- 308 1
- 311 1
- 312 1
- 313 1
- 315 1
- 316 1
- 320 1
- 322 1
- 324 1
- 328 1
- 333 1
- 338 1
- 345 1
- 352 1
- 358 1
- 364 1
- 372 1
- 376 1
- 377 1
- 391 1
- 403 1
- 408 1
- 417 1
- 422 1
- 428 1
- 447 1
- 451 1
- 458 1
- 462 1
- 465 1
- 471 1
- 473 1
- 479 1
- 487 1
- 489 1
- 492 1
- 500 1
- 505 1
- 512 1
- 516 1
- 517 1
- 523 1
- 525 1
- 529 1
- 537 1
- 540 1
- 549 1
- 563 1
- 567 1
- 593 1
- 605 1
- 621 1
- 636 1
- 653 1
- 667 1
- 679 1
- 696 1
- 719 1
- 731 1
- 751 1
- 753 1
- 779 1
- 800 1
- 827 1
- 858 1
- 874 1
- 904 1
- 937 1
- 962 1
- 979 1
- 1024 1
- 1031 1
- 1058 1
- 1094 1
- 1116 1
- 1129 1
- 1150 1
- 1174 1
- 1189 1
- 1230 1
- 1242 1
- 1287 1
- 1330 1
- 1344 1
- 1366 1
- 1392 1
- 1426 1
- 1451 1
- 1469 1
- 1488 1
- 1517 1
- 1553 1
- 1582 1
- 1621 1
- 1646 1
- 1677 1
- 1698 1
- 1714 1
- 1739 1
- 1752 1
- 1776 1
- 1789 1
- 1811 1
- 1859 1
- 1882 1
- 1890 1
- 1915 1
- 1934 1
- 1939 1
- 1961 1
- 1990 1
- 2030 1
- 2039 1
- 2065 1
- 2073 1
- 2077 1
- 2092 1
- 2099 1
- 2114 1
- 2134 1
- 2143 1
- 2166 1
- 2167 1
- 2185 1
- 2210 1
- 2231 1
- 2265 1
- 2285 1
- 2295 1
- 2312 1
- 2333 1
- 2346 1
- 2363 1
- 2383 1
- 2400 1
- 2410 1
- 2426 1
- 2441 1
- 2460 1
- 2476 1
- 2505 1
- 2566 1
- 2587 1
- 2611 1
- 2675 1
- 2684 1
- 2702 1
- 2712 1
- 2734 1
- 2760 1
- 2775 1
- 2797 1
- 2806 1
- 2811 1
- 2834 1
- 2859 1
- 2878 1
- 2896 1
- 2901 1
- 2907 1
- 2920 1
- 2929 1
- 2941 1
- 2948 1
- 2958 1
- 2961 1
- 2983 1
- 2990 1
- 3019 1
- 3029 1
- 3036 1
- 3047 1
- 3053 1
- 3060 1
- 3086 1
- 3097 1
- 3104 1
- 3111 1
- 3121 1
- 3131 1
- 3149 1
- 3162 1
- 3177 1
- 3193 1
- 3203 1
- 3216 1
- 3223 1
- 3247 1
- 3263 1
- 3278 1
- 3307 1
- 3335 1
- 3342 1
- 3359 1
- 3364 1
- 3392 1
- 3405 1
- 3430 1
- 3453 1
- 3471 1
- 3477 1
- 3529 1
- 3546 1
- 3563 1
- 3570 1
- 3574 1
- 3586 1
- 3599 1
- 3601 1
- 3614 1
- 3618 1
- 3621 1
- 3627 1
- 3641 1
- 3647 1
- 3652 1
- 3656 1
- 3665 1
- 3675 1
- 3676 1
- 3677 1
- 3679 1
- 3683 1
- 3694 1
- 3698 1
- 3700 1
- 3701 1
- 3706 1
- 3708 1
- 3711 1
- 3712 1
- 3714 1
- 3715 1
- 3716 1
- 3717 1
- 3720 1
- 3724 1
- 3725 1
- 3728 1
- 3736 1
- 3739 1
- 3744 1
- 3746 1
- 3749 1
- 3751 1
- 3757 1
- 3766 1
- 3768 1
- 3769 1
- 3777 1
- 3778 1
- 3779 1
- 3785 1
- 3787 1
- 3790 1
- 3794 1
- 3802 1
- 3808 1
- 3834 1
- 3853 1
- 3925 1
- 3943 1
- 3981 1
- 3987 1
- 3995 1
- 4011 1
- 4062 1
- 4080 1
- 4096 1
- 4114 1
- 4146 1
- 4155 1
- 4168 1
- 4180 1
- 4229 1
- 4231 1
- 4250 1
- 4264 1
- 4284 1
- 4305 1
- 4314 1
- 4326 1
- 4359 1
- 4363 1
- 4366 1
- 4372 1
- 4409 1
- 4410 1
- 4422 1
- 4428 1
- 4463 1
- 4471 1
- 4474 1
- 4482 1
- 4505 1
- 4517 1
- 4521 1
- 4539 1
- 4569 1
- 4574 1
- 4582 1
- 4604 1
- 4653 1
- 4656 1
- 4665 1
- 4677 1
- 4711 1
- 4721 1
- 4727 1
- 4741 1
- 4759 1
- 4773 1
- 4774 1
- 4801 1
- 4855 1
- 4862 1
- 4877 1
- 4897 1
- 4956 1
- 4966 1
- 4993 1
- 5024 1
- 5088 1
- 5098 1
- 5138 1
- 5165 1
- 5235 1
- 5263 1
- 5288 1
- 5317 1
- 5337 1
- 5376 1
- 5394 1
- 5423 1
- 5459 1
- 5474 1
- 5489 1
- 5495 1
- 5521 1
- 5526 1
- 5531 1
- 5550 1
- 5613 1
- 5674 1
- 5829 1
- 5845 1
- 6367 1
- 6494 1
- 6670 1
- 6873 1
- 7444 1
- 7520 1
- 7619 1
- 7690 1
- 8240 1
- 8381 1
- 8470 1
- 8528 1
- 8761 1
- 8858 1
- 8895 1
- 8976 1
- 9133 1
- 9154 1
- 9161 1
- 9293 1
- 9295 1
- 9315 1
- 9333 1
- 9379 1
- 9390 1
- 9400 1
- 9418 1
- 9433 1
- 9445 1
- 9451 1
- 9456 1
- 9481 1
- 9486 1
- 9497 1
- 9508 1
- 9536 1
- 9545 1
- 9551 1
- 9558 1
- 9576 1
- 9589 1
- 9591 1
- 9597 1
- 9617 1
- 9623 1
- 9638 1
- 9678 1
- 9693 1
- 9701 1
- 9707 1
- 9722 1
- 9732 1
- 9736 1
- 9740 1
- 9759 1
- 9772 1
- 9783 1
- 9794 1
- 9820 1
- 9822 1
- 9827 1
- 9830 1
- 9856 1
- 9861 1
- 9872 1
- 9890 1
- 9923 1
- 9937 1
- 9942 1
- 9943 1
- 9954 1
- 9962 1
- 9974 1
- 9980 1
- 9998 1
- 10003 1
- 10004 1
- 10081 1
- 10087 1
state 1
- Colorado 792
fips 1
- 8117 · 792 ✖
county 1
- Summit 792
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1670 | 1670 | 2020-03-13 | Summit | Colorado | 8117 | 2 | 0 |
1990 | 1990 | 2020-03-14 | Summit | Colorado | 8117 | 2 | 0 |
2372 | 2372 | 2020-03-15 | Summit | Colorado | 8117 | 2 | 0 |
2807 | 2807 | 2020-03-16 | Summit | Colorado | 8117 | 3 | 0 |
3289 | 3289 | 2020-03-17 | Summit | Colorado | 8117 | 3 | 0 |
3843 | 3843 | 2020-03-18 | Summit | Colorado | 8117 | 4 | 0 |
4506 | 4506 | 2020-03-19 | Summit | Colorado | 8117 | 5 | 0 |
5284 | 5284 | 2020-03-20 | Summit | Colorado | 8117 | 7 | 0 |
6211 | 6211 | 2020-03-21 | Summit | Colorado | 8117 | 7 | 0 |
7246 | 7246 | 2020-03-22 | Summit | Colorado | 8117 | 7 | 0 |
8391 | 8391 | 2020-03-23 | Summit | Colorado | 8117 | 8 | 0 |
9636 | 9636 | 2020-03-24 | Summit | Colorado | 8117 | 10 | 0 |
11010 | 11010 | 2020-03-25 | Summit | Colorado | 8117 | 9 | 0 |
12557 | 12557 | 2020-03-26 | Summit | Colorado | 8117 | 9 | 0 |
14226 | 14226 | 2020-03-27 | Summit | Colorado | 8117 | 10 | 0 |
16010 | 16010 | 2020-03-28 | Summit | Colorado | 8117 | 11 | 0 |
17902 | 17902 | 2020-03-29 | Summit | Colorado | 8117 | 11 | 0 |
19881 | 19881 | 2020-03-30 | Summit | Colorado | 8117 | 14 | 0 |
21958 | 21958 | 2020-03-31 | Summit | Colorado | 8117 | 20 | 0 |
24117 | 24117 | 2020-04-01 | Summit | Colorado | 8117 | 23 | 0 |
26347 | 26347 | 2020-04-02 | Summit | Colorado | 8117 | 26 | 0 |
28649 | 28649 | 2020-04-03 | Summit | Colorado | 8117 | 35 | 0 |
31007 | 31007 | 2020-04-04 | Summit | Colorado | 8117 | 43 | 0 |
33413 | 33413 | 2020-04-05 | Summit | Colorado | 8117 | 45 | 0 |
35858 | 35858 | 2020-04-06 | Summit | Colorado | 8117 | 47 | 0 |
38348 | 38348 | 2020-04-07 | Summit | Colorado | 8117 | 53 | 0 |
40891 | 40891 | 2020-04-08 | Summit | Colorado | 8117 | 56 | 0 |
43465 | 43465 | 2020-04-09 | Summit | Colorado | 8117 | 57 | 0 |
46065 | 46065 | 2020-04-10 | Summit | Colorado | 8117 | 61 | 0 |
48695 | 48695 | 2020-04-11 | Summit | Colorado | 8117 | 68 | 0 |
51357 | 51357 | 2020-04-12 | Summit | Colorado | 8117 | 68 | 1 |
54036 | 54036 | 2020-04-13 | Summit | Colorado | 8117 | 72 | 1 |
56728 | 56728 | 2020-04-14 | Summit | Colorado | 8117 | 74 | 1 |
59436 | 59436 | 2020-04-15 | Summit | Colorado | 8117 | 76 | 1 |
62155 | 62155 | 2020-04-16 | Summit | Colorado | 8117 | 77 | 1 |
64888 | 64888 | 2020-04-17 | Summit | Colorado | 8117 | 82 | 1 |
67636 | 67636 | 2020-04-18 | Summit | Colorado | 8117 | 86 | 1 |
70398 | 70398 | 2020-04-19 | Summit | Colorado | 8117 | 86 | 1 |
73167 | 73167 | 2020-04-20 | Summit | Colorado | 8117 | 88 | 1 |
75943 | 75943 | 2020-04-21 | Summit | Colorado | 8117 | 88 | 1 |
78727 | 78727 | 2020-04-22 | Summit | Colorado | 8117 | 88 | 1 |
81521 | 81521 | 2020-04-23 | Summit | Colorado | 8117 | 89 | 1 |
84321 | 84321 | 2020-04-24 | Summit | Colorado | 8117 | 97 | 1 |
87129 | 87129 | 2020-04-25 | Summit | Colorado | 8117 | 97 | 1 |
89946 | 89946 | 2020-04-26 | Summit | Colorado | 8117 | 105 | 2 |
92764 | 92764 | 2020-04-27 | Summit | Colorado | 8117 | 106 | 2 |
95596 | 95596 | 2020-04-28 | Summit | Colorado | 8117 | 119 | 2 |
98441 | 98441 | 2020-04-29 | Summit | Colorado | 8117 | 121 | 2 |
101291 | 101291 | 2020-04-30 | Summit | Colorado | 8117 | 128 | 2 |
104146 | 104146 | 2020-05-01 | Summit | Colorado | 8117 | 130 | 2 |
107011 | 107011 | 2020-05-02 | Summit | Colorado | 8117 | 136 | 2 |
109880 | 109880 | 2020-05-03 | Summit | Colorado | 8117 | 144 | 2 |
112755 | 112755 | 2020-05-04 | Summit | Colorado | 8117 | 144 | 2 |
115638 | 115638 | 2020-05-05 | Summit | Colorado | 8117 | 151 | 2 |
118598 | 118598 | 2020-05-06 | Summit | Colorado | 8117 | 155 | 2 |
121567 | 121567 | 2020-05-07 | Summit | Colorado | 8117 | 155 | 2 |
124547 | 124547 | 2020-05-08 | Summit | Colorado | 8117 | 156 | 2 |
127533 | 127533 | 2020-05-09 | Summit | Colorado | 8117 | 162 | 2 |
130524 | 130524 | 2020-05-10 | Summit | Colorado | 8117 | 165 | 2 |
133515 | 133515 | 2020-05-11 | Summit | Colorado | 8117 | 169 | 2 |
136504 | 136504 | 2020-05-12 | Summit | Colorado | 8117 | 171 | 2 |
139495 | 139495 | 2020-05-13 | Summit | Colorado | 8117 | 174 | 2 |
142491 | 142491 | 2020-05-14 | Summit | Colorado | 8117 | 175 | 2 |
145491 | 145491 | 2020-05-15 | Summit | Colorado | 8117 | 178 | 2 |
148494 | 148494 | 2020-05-16 | Summit | Colorado | 8117 | 182 | 2 |
151503 | 151503 | 2020-05-17 | Summit | Colorado | 8117 | 183 | 2 |
154515 | 154515 | 2020-05-18 | Summit | Colorado | 8117 | 186 | 2 |
157531 | 157531 | 2020-05-19 | Summit | Colorado | 8117 | 192 | 2 |
160557 | 160557 | 2020-05-20 | Summit | Colorado | 8117 | 194 | 2 |
163585 | 163585 | 2020-05-21 | Summit | Colorado | 8117 | 195 | 2 |
166618 | 166618 | 2020-05-22 | Summit | Colorado | 8117 | 197 | 2 |
169655 | 169655 | 2020-05-23 | Summit | Colorado | 8117 | 203 | 2 |
172696 | 172696 | 2020-05-24 | Summit | Colorado | 8117 | 207 | 2 |
175740 | 175740 | 2020-05-25 | Summit | Colorado | 8117 | 205 | 2 |
178784 | 178784 | 2020-05-26 | Summit | Colorado | 8117 | 212 | 2 |
181828 | 181828 | 2020-05-27 | Summit | Colorado | 8117 | 214 | 2 |
184882 | 184882 | 2020-05-28 | Summit | Colorado | 8117 | 213 | 2 |
187938 | 187938 | 2020-05-29 | Summit | Colorado | 8117 | 219 | 2 |
191003 | 191003 | 2020-05-30 | Summit | Colorado | 8117 | 224 | 2 |
194070 | 194070 | 2020-05-31 | Summit | Colorado | 8117 | 226 | 2 |
197140 | 197140 | 2020-06-01 | Summit | Colorado | 8117 | 231 | 2 |
200213 | 200213 | 2020-06-02 | Summit | Colorado | 8117 | 233 | 2 |
203289 | 203289 | 2020-06-03 | Summit | Colorado | 8117 | 237 | 2 |
206369 | 206369 | 2020-06-04 | Summit | Colorado | 8117 | 239 | 2 |
209450 | 209450 | 2020-06-05 | Summit | Colorado | 8117 | 239 | 2 |
212535 | 212535 | 2020-06-06 | Summit | Colorado | 8117 | 243 | 2 |
215622 | 215622 | 2020-06-07 | Summit | Colorado | 8117 | 248 | 2 |
218713 | 218713 | 2020-06-08 | Summit | Colorado | 8117 | 247 | 2 |
221808 | 221808 | 2020-06-09 | Summit | Colorado | 8117 | 248 | 2 |
224903 | 224903 | 2020-06-10 | Summit | Colorado | 8117 | 252 | 2 |
228005 | 228005 | 2020-06-11 | Summit | Colorado | 8117 | 253 | 2 |
231108 | 231108 | 2020-06-12 | Summit | Colorado | 8117 | 254 | 2 |
234214 | 234214 | 2020-06-13 | Summit | Colorado | 8117 | 256 | 2 |
237321 | 237321 | 2020-06-14 | Summit | Colorado | 8117 | 256 | 2 |
240429 | 240429 | 2020-06-15 | Summit | Colorado | 8117 | 257 | 2 |
243540 | 243540 | 2020-06-16 | Summit | Colorado | 8117 | 258 | 3 |
246653 | 246653 | 2020-06-17 | Summit | Colorado | 8117 | 262 | 3 |
249765 | 249765 | 2020-06-18 | Summit | Colorado | 8117 | 262 | 3 |
252880 | 252880 | 2020-06-19 | Summit | Colorado | 8117 | 262 | 3 |
255999 | 255999 | 2020-06-20 | Summit | Colorado | 8117 | 262 | 3 |
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);