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 date descending
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 |
---|---|---|---|---|---|---|---|
2499879 | 2499879 | 2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 |
2496621 | 2496621 | 2022-05-12 | Summit | Colorado | 8117 | 10081 | 14 |
2493363 | 2493363 | 2022-05-11 | Summit | Colorado | 8117 | 10003 | 14 |
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2486848 | 2486848 | 2022-05-09 | Summit | Colorado | 8117 | 9998 | 14 |
2483590 | 2483590 | 2022-05-08 | Summit | Colorado | 8117 | 9979 | 14 |
2480332 | 2480332 | 2022-05-07 | Summit | Colorado | 8117 | 9979 | 14 |
2477074 | 2477074 | 2022-05-06 | Summit | Colorado | 8117 | 9979 | 14 |
2473816 | 2473816 | 2022-05-05 | Summit | Colorado | 8117 | 9980 | 14 |
2470559 | 2470559 | 2022-05-04 | Summit | Colorado | 8117 | 9974 | 14 |
2467303 | 2467303 | 2022-05-03 | Summit | Colorado | 8117 | 9962 | 14 |
2464048 | 2464048 | 2022-05-02 | Summit | Colorado | 8117 | 9954 | 14 |
2460792 | 2460792 | 2022-05-01 | Summit | Colorado | 8117 | 9947 | 14 |
2457536 | 2457536 | 2022-04-30 | Summit | Colorado | 8117 | 9947 | 14 |
2454280 | 2454280 | 2022-04-29 | Summit | Colorado | 8117 | 9947 | 14 |
2451024 | 2451024 | 2022-04-28 | Summit | Colorado | 8117 | 9943 | 14 |
2447768 | 2447768 | 2022-04-27 | Summit | Colorado | 8117 | 9942 | 14 |
2444512 | 2444512 | 2022-04-26 | Summit | Colorado | 8117 | 9937 | 14 |
2441256 | 2441256 | 2022-04-25 | Summit | Colorado | 8117 | 9923 | 14 |
2438000 | 2438000 | 2022-04-24 | Summit | Colorado | 8117 | 9900 | 14 |
2434744 | 2434744 | 2022-04-23 | Summit | Colorado | 8117 | 9900 | 14 |
2431488 | 2431488 | 2022-04-22 | Summit | Colorado | 8117 | 9900 | 14 |
2428232 | 2428232 | 2022-04-21 | Summit | Colorado | 8117 | 9890 | 14 |
2424976 | 2424976 | 2022-04-20 | Summit | Colorado | 8117 | 9872 | 14 |
2421720 | 2421720 | 2022-04-19 | Summit | Colorado | 8117 | 9861 | 14 |
2418464 | 2418464 | 2022-04-18 | Summit | Colorado | 8117 | 9856 | 14 |
2415208 | 2415208 | 2022-04-17 | Summit | Colorado | 8117 | 9842 | 14 |
2411952 | 2411952 | 2022-04-16 | Summit | Colorado | 8117 | 9842 | 14 |
2408696 | 2408696 | 2022-04-15 | Summit | Colorado | 8117 | 9842 | 14 |
2405440 | 2405440 | 2022-04-14 | Summit | Colorado | 8117 | 9830 | 14 |
2402185 | 2402185 | 2022-04-13 | Summit | Colorado | 8117 | 9827 | 14 |
2398930 | 2398930 | 2022-04-12 | Summit | Colorado | 8117 | 9822 | 14 |
2395675 | 2395675 | 2022-04-11 | Summit | Colorado | 8117 | 9820 | 14 |
2392419 | 2392419 | 2022-04-10 | Summit | Colorado | 8117 | 9796 | 14 |
2389163 | 2389163 | 2022-04-09 | Summit | Colorado | 8117 | 9796 | 14 |
2385908 | 2385908 | 2022-04-08 | Summit | Colorado | 8117 | 9796 | 14 |
2382653 | 2382653 | 2022-04-07 | Summit | Colorado | 8117 | 9794 | 14 |
2379398 | 2379398 | 2022-04-06 | Summit | Colorado | 8117 | 9783 | 14 |
2376144 | 2376144 | 2022-04-05 | Summit | Colorado | 8117 | 9772 | 14 |
2372892 | 2372892 | 2022-04-04 | Summit | Colorado | 8117 | 9759 | 14 |
2369639 | 2369639 | 2022-04-03 | Summit | Colorado | 8117 | 9746 | 14 |
2366386 | 2366386 | 2022-04-02 | Summit | Colorado | 8117 | 9746 | 14 |
2363133 | 2363133 | 2022-04-01 | Summit | Colorado | 8117 | 9746 | 14 |
2359879 | 2359879 | 2022-03-31 | Summit | Colorado | 8117 | 9740 | 14 |
2356625 | 2356625 | 2022-03-30 | Summit | Colorado | 8117 | 9736 | 14 |
2353372 | 2353372 | 2022-03-29 | Summit | Colorado | 8117 | 9732 | 14 |
2350120 | 2350120 | 2022-03-28 | Summit | Colorado | 8117 | 9722 | 14 |
2346867 | 2346867 | 2022-03-27 | Summit | Colorado | 8117 | 9711 | 14 |
2343614 | 2343614 | 2022-03-26 | Summit | Colorado | 8117 | 9711 | 14 |
2340361 | 2340361 | 2022-03-25 | Summit | Colorado | 8117 | 9711 | 14 |
2337108 | 2337108 | 2022-03-24 | Summit | Colorado | 8117 | 9707 | 14 |
2333854 | 2333854 | 2022-03-23 | Summit | Colorado | 8117 | 9701 | 14 |
2330600 | 2330600 | 2022-03-22 | Summit | Colorado | 8117 | 9693 | 14 |
2327348 | 2327348 | 2022-03-21 | Summit | Colorado | 8117 | 9678 | 14 |
2324095 | 2324095 | 2022-03-20 | Summit | Colorado | 8117 | 9651 | 14 |
2320841 | 2320841 | 2022-03-19 | Summit | Colorado | 8117 | 9651 | 14 |
2317587 | 2317587 | 2022-03-18 | Summit | Colorado | 8117 | 9651 | 14 |
2314334 | 2314334 | 2022-03-17 | Summit | Colorado | 8117 | 9651 | 14 |
2311081 | 2311081 | 2022-03-16 | Summit | Colorado | 8117 | 9638 | 14 |
2307828 | 2307828 | 2022-03-15 | Summit | Colorado | 8117 | 9623 | 14 |
2304577 | 2304577 | 2022-03-14 | Summit | Colorado | 8117 | 9617 | 14 |
2301325 | 2301325 | 2022-03-13 | Summit | Colorado | 8117 | 9607 | 14 |
2298073 | 2298073 | 2022-03-12 | Summit | Colorado | 8117 | 9607 | 14 |
2294821 | 2294821 | 2022-03-11 | Summit | Colorado | 8117 | 9607 | 14 |
2291569 | 2291569 | 2022-03-10 | Summit | Colorado | 8117 | 9597 | 14 |
2288317 | 2288317 | 2022-03-09 | Summit | Colorado | 8117 | 9591 | 14 |
2285066 | 2285066 | 2022-03-08 | Summit | Colorado | 8117 | 9589 | 14 |
2281814 | 2281814 | 2022-03-07 | Summit | Colorado | 8117 | 9576 | 14 |
2278561 | 2278561 | 2022-03-06 | Summit | Colorado | 8117 | 9560 | 14 |
2275308 | 2275308 | 2022-03-05 | Summit | Colorado | 8117 | 9560 | 14 |
2272055 | 2272055 | 2022-03-04 | Summit | Colorado | 8117 | 9560 | 14 |
2268803 | 2268803 | 2022-03-03 | Summit | Colorado | 8117 | 9558 | 14 |
2265550 | 2265550 | 2022-03-02 | Summit | Colorado | 8117 | 9551 | 15 |
2262299 | 2262299 | 2022-03-01 | Summit | Colorado | 8117 | 9545 | 15 |
2259048 | 2259048 | 2022-02-28 | Summit | Colorado | 8117 | 9536 | 14 |
2255797 | 2255797 | 2022-02-27 | Summit | Colorado | 8117 | 9518 | 14 |
2252546 | 2252546 | 2022-02-26 | Summit | Colorado | 8117 | 9518 | 14 |
2249295 | 2249295 | 2022-02-25 | Summit | Colorado | 8117 | 9518 | 14 |
2246044 | 2246044 | 2022-02-24 | Summit | Colorado | 8117 | 9508 | 14 |
2242793 | 2242793 | 2022-02-23 | Summit | Colorado | 8117 | 9497 | 14 |
2239542 | 2239542 | 2022-02-22 | Summit | Colorado | 8117 | 9486 | 14 |
2236291 | 2236291 | 2022-02-21 | Summit | Colorado | 8117 | 9481 | 14 |
2233040 | 2233040 | 2022-02-20 | Summit | Colorado | 8117 | 9462 | 14 |
2229789 | 2229789 | 2022-02-19 | Summit | Colorado | 8117 | 9462 | 14 |
2226538 | 2226538 | 2022-02-18 | Summit | Colorado | 8117 | 9462 | 14 |
2223287 | 2223287 | 2022-02-17 | Summit | Colorado | 8117 | 9456 | 14 |
2220036 | 2220036 | 2022-02-16 | Summit | Colorado | 8117 | 9451 | 14 |
2216785 | 2216785 | 2022-02-15 | Summit | Colorado | 8117 | 9445 | 14 |
2213534 | 2213534 | 2022-02-14 | Summit | Colorado | 8117 | 9433 | 14 |
2210282 | 2210282 | 2022-02-13 | Summit | Colorado | 8117 | 9420 | 13 |
2207029 | 2207029 | 2022-02-12 | Summit | Colorado | 8117 | 9420 | 13 |
2203776 | 2203776 | 2022-02-11 | Summit | Colorado | 8117 | 9420 | 13 |
2200523 | 2200523 | 2022-02-10 | Summit | Colorado | 8117 | 9418 | 13 |
2197269 | 2197269 | 2022-02-09 | Summit | Colorado | 8117 | 9400 | 13 |
2194015 | 2194015 | 2022-02-08 | Summit | Colorado | 8117 | 9390 | 12 |
2190761 | 2190761 | 2022-02-07 | Summit | Colorado | 8117 | 9379 | 12 |
2187508 | 2187508 | 2022-02-06 | Summit | Colorado | 8117 | 9349 | 12 |
2184255 | 2184255 | 2022-02-05 | Summit | Colorado | 8117 | 9349 | 12 |
2181003 | 2181003 | 2022-02-04 | Summit | Colorado | 8117 | 9349 | 12 |
2177752 | 2177752 | 2022-02-03 | Summit | Colorado | 8117 | 9333 | 12 |
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);