ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 648 ✖
- 3 10
- 86121 6
- 1 5
- 42912 5
- 11 4
- 31160 4
- 40997 4
- 44981 4
- 46679 4
- 82742 4
- 85756 4
- 86731 4
- 87282 4
- 88095 4
- 89082 4
- 3113 3
- 6142 3
- 29632 3
- 30336 3
- 30688 3
- 31612 3
- 31917 3
- 32321 3
- 32997 3
- 39609 3
- 40001 3
- 40356 3
- 40711 3
- 41453 3
- 41931 3
- 42695 3
- 43349 3
- 43811 3
- 44259 3
- 50878 3
- 79358 3
- 81684 3
- 83625 3
- 84380 3
- 84962 3
- 85250 3
- 85561 3
- 85882 3
- 86988 3
- 87684 3
- 88499 3
- 89730 3
- 2 2
- 9 2
- 50 2
- 145 2
- 180 2
- 261 2
- 309 2
- 312 2
- 411 2
- 671 2
- 835 2
- 1006 2
- 1267 2
- 1819 2
- 2241 2
- 4465 2
- 5654 2
- 7412 2
- 7578 2
- 9686 2
- 10248 2
- 10679 2
- 11608 2
- 11846 2
- 12049 2
- 13098 2
- 16024 2
- 17444 2
- 18872 2
- 27361 2
- 27414 2
- 29122 2
- 29448 2
- 30035 2
- 30493 2
- 30957 2
- 31026 2
- 33875 2
- 42314 2
- 42422 2
- 75203 2
- 4 1
- 5 1
- 8 1
- 29 1
- 34 1
- 39 1
- 49 1
- 57 1
- 73 1
- 85 1
- 91 1
- 95 1
- 100 1
- 105 1
- 107 1
- 115 1
- 120 1
- 123 1
- 136 1
- 147 1
- 152 1
- 160 1
- 163 1
- 172 1
- 181 1
- 182 1
- 192 1
- 194 1
- 216 1
- 217 1
- 218 1
- 220 1
- 222 1
- 228 1
- 232 1
- 244 1
- 248 1
- 252 1
- 257 1
- 286 1
- 292 1
- 300 1
- 337 1
- 351 1
- 364 1
- 373 1
- 387 1
- 391 1
- 433 1
- 467 1
- 482 1
- 500 1
- 515 1
- 524 1
- 530 1
- 531 1
- 548 1
- 553 1
- 564 1
- 566 1
- 579 1
- 593 1
- 610 1
- 624 1
- 642 1
- 653 1
- 664 1
- 701 1
- 722 1
- 752 1
- 758 1
- 765 1
- 774 1
- 803 1
- 822 1
- 885 1
- 935 1
- 956 1
- 974 1
- 1092 1
- 1118 1
- 1136 1
- 1185 1
- 1229 1
- 1359 1
- 1370 1
- 1466 1
- 1487 1
- 1519 1
- 1561 1
- 1650 1
- 1703 1
- 1886 1
- 1979 1
- 2027 1
- 2068 1
- 2121 1
- 2169 1
- 2212 1
- 2300 1
- 2466 1
- 2559 1
- 2570 1
- 2617 1
- 2662 1
- 2748 1
- 2842 1
- 2944 1
- 3055 1
- 3208 1
- 3358 1
- 3431 1
- 3556 1
- 3670 1
- 3753 1
- 3825 1
- 3859 1
- 4063 1
- 4157 1
- 4293 1
- 4377 1
- 4779 1
- 4863 1
- 4942 1
- 5067 1
- 5120 1
- 5212 1
- 5351 1
- 5422 1
- 5469 1
- 5588 1
- 5800 1
- 5917 1
- 6067 1
- 6303 1
- 6360 1
- 6488 1
- 6516 1
- 6561 1
- 6623 1
- 6666 1
- 6701 1
- 6738 1
- 6777 1
- 6827 1
- 6874 1
- 6987 1
- 6998 1
- 7060 1
- 7112 1
- 7160 1
- 7225 1
- 7262 1
- 7320 1
- 7369 1
- 7528 1
- 7752 1
- 7799 1
- 7861 1
- 7940 1
- 8037 1
- 8083 1
- 8155 1
- 8270 1
- 8352 1
- 8422 1
- 8500 1
- 8558 1
- 8615 1
- 8684 1
- 8717 1
- 8810 1
- 8858 1
- 8934 1
- 9016 1
- 9073 1
- 9099 1
- 9163 1
- 9245 1
- 9312 1
- 9402 1
- 9494 1
- 9569 1
- 9601 1
- 9646 1
- 9866 1
- 9953 1
- 10041 1
- 10116 1
- 10170 1
- 10424 1
- 10505 1
- 10606 1
- 10845 1
- 10970 1
- 11055 1
- 11133 1
- 11169 1
- 11316 1
- 11363 1
- 11428 1
- 11486 1
- 12198 1
- 12319 1
- 12662 1
- 12795 1
- 12923 1
- 13369 1
- 13439 1
- 13719 1
- 13912 1
- 14168 1
- 14282 1
- 14475 1
- 14705 1
- 14859 1
- 15096 1
- 15702 1
- 16495 1
- 16706 1
- 16802 1
- 17075 1
- 17903 1
- 18147 1
- 18539 1
- 18649 1
- 19055 1
- 19129 1
- 19513 1
- 19761 1
- 20015 1
- 20210 1
- 20501 1
- 20752 1
- 21067 1
- 21264 1
- 21393 1
- 21925 1
- 22191 1
- 22531 1
- 22840 1
- 23089 1
- 23204 1
- 23607 1
- 23871 1
- 24068 1
- 24184 1
- 24469 1
- 24571 1
- 24761 1
- 24935 1
- 25141 1
- 25160 1
- 25536 1
- 25678 1
- 25825 1
- 25992 1
- 26108 1
- 26189 1
- 26250 1
- 26306 1
- 26430 1
- 26595 1
- 26674 1
- 26836 1
- 26909 1
- 26939 1
- 26971 1
- 27056 1
- 27133 1
- 27143 1
- 27249 1
- 27542 1
- 27606 1
- 27703 1
- 27793 1
- 27845 1
- 27882 1
- 27954 1
- 28004 1
- 28063 1
- 28141 1
- 28193 1
- 28222 1
- 28261 1
- 28307 1
- 28379 1
- 28417 1
- 28484 1
- 28533 1
- 28571 1
- 28601 1
- 28638 1
- 28677 1
- 28714 1
- 28762 1
- 28798 1
- 28820 1
- 28850 1
- 28882 1
- 28915 1
- 28943 1
- 28981 1
- 29006 1
- 29045 1
- 29059 1
- 29090 1
- 29199 1
- 29219 1
- 29235 1
- 29255 1
- 29257 1
- 29310 1
- 29349 1
- 29372 1
- 29402 1
- 29423 1
- 29431 1
- 29501 1
- 29525 1
- 29536 1
- 29573 1
- 29608 1
- 29679 1
- 29696 1
- 29715 1
- 29720 1
- 29734 1
- 29747 1
- 29762 1
- 29776 1
- 29778 1
- 29794 1
- 29807 1
- 29818 1
- 29832 1
- 29856 1
- 29876 1
- 29886 1
- 29897 1
- 29910 1
- 29921 1
- 29951 1
- 29966 1
- 29975 1
- 29984 1
- 30002 1
- 30012 1
- 30053 1
- 30057 1
- 30067 1
- 30071 1
- 30101 1
- 30104 1
- 30130 1
- 30150 1
- 30168 1
- 30169 1
- 30187 1
- 30230 1
- 30257 1
- 30269 1
- 30298 1
- 30333 1
- 30393 1
- 30422 1
- 30454 1
- 30504 1
- 30569 1
- 30586 1
- 30616 1
- 30659 1
- 30752 1
- 30783 1
- 30825 1
- 30844 1
- 30868 1
- 30884 1
- 30950 1
- 30974 1
- 31059 1
- 31090 1
- 31103 1
- 31116 1
- 31129 1
- 31137 1
- 31553 1
- 31733 1
- 31758 1
- 31812 1
- 31851 1
- 32056 1
- 32094 1
- 32144 1
- 32182 1
- 32595 1
- 32676 1
- 32760 1
- 32830 1
- 33472 1
- 33528 1
- 33639 1
- 33731 1
- 34136 1
- 34225 1
- 34353 1
- 34474 1
- 34608 1
- 34719 1
- 34884 1
- 35026 1
- 35126 1
- 35264 1
- 35363 1
- 35503 1
- 35673 1
- 35856 1
- 36022 1
- 36116 1
- 36209 1
- 36289 1
- 36434 1
- 36550 1
- 36774 1
- 36914 1
- 37098 1
- 37212 1
- 37827 1
- 37914 1
- 38018 1
- 38159 1
- 38269 1
- 38341 1
- 38389 1
- 38473 1
- 38546 1
- 38642 1
- 38742 1
- 38870 1
- 38927 1
- 38984 1
- 39066 1
- 39114 1
- 39192 1
- 39293 1
- 39376 1
- 39441 1
- 39476 1
- 39527 1
- 39560 1
- 39799 1
- 39844 1
- 39892 1
- 39930 1
- 40183 1
- 40224 1
- 40260 1
- 40295 1
- 40535 1
- 40575 1
- 40613 1
- 40638 1
- 40822 1
- 40865 1
- 40895 1
- 40925 1
- 41267 1
- 41315 1
- 41358 1
- 41712 1
- 41763 1
- 41817 1
- 41859 1
- 42163 1
- 42202 1
- 42260 1
- 42514 1
- 42561 1
- 42596 1
- 42637 1
- 42842 1
- 42888 1
- 43127 1
- 43168 1
- 43207 1
- 43284 1
- 43609 1
- 43685 1
- 43725 1
- 43763 1
- 44008 1
- 44076 1
- 44122 1
- 44181 1
- 44545 1
- 44583 1
- 44652 1
- 44824 1
- 45613 1
- 45709 1
- 46118 1
- 49030 1
- 49292 1
- 49868 1
- 54291 1
- 55226 1
- 56159 1
- 57381 1
- 59168 1
- 59439 1
- 60574 1
- 62829 1
- 63750 1
- 64701 1
- 66219 1
- 67543 1
- 67646 1
- 68776 1
- 71321 1
- 72263 1
- 73163 1
- 74273 1
- 75608 1
- 77654 1
- 77963 1
- 78143 1
- 78826 1
- 80032 1
- 80441 1
- 80943 1
- 81316 1
- 82323 1
- 82487 1
- 82541 1
- 82584 1
- 83260 1
- 83311 1
- 83517 1
- 83964 1
- 83981 1
- 84026 1
- 84275 1
- 84525 1
- 84597 1
- 84638 1
- 84914 1
- 85051 1
- 85071 1
- 85077 1
- 85203 1
- 85377 1
- 85391 1
- 85454 1
- 85522 1
- 85536 1
- 85553 1
- 85578 1
- 85684 1
- 86592 1
- 90191 1
state 1
- California 808
fips 1
- 6097 · 808 ✖
county 1
- Sonoma 808
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499810 | 2499810 | 2022-05-13 | Sonoma | California | 6097 | 90191 | 490 |
2496552 | 2496552 | 2022-05-12 | Sonoma | California | 6097 | 89730 | 490 |
2493294 | 2493294 | 2022-05-11 | Sonoma | California | 6097 | 89730 | 490 |
2490036 | 2490036 | 2022-05-10 | Sonoma | California | 6097 | 89730 | 490 |
2486779 | 2486779 | 2022-05-09 | Sonoma | California | 6097 | 89082 | 490 |
2483521 | 2483521 | 2022-05-08 | Sonoma | California | 6097 | 89082 | 490 |
2480263 | 2480263 | 2022-05-07 | Sonoma | California | 6097 | 89082 | 490 |
2477005 | 2477005 | 2022-05-06 | Sonoma | California | 6097 | 89082 | 490 |
2473747 | 2473747 | 2022-05-05 | Sonoma | California | 6097 | 88499 | 490 |
2470490 | 2470490 | 2022-05-04 | Sonoma | California | 6097 | 88499 | 490 |
2467234 | 2467234 | 2022-05-03 | Sonoma | California | 6097 | 88499 | 490 |
2463979 | 2463979 | 2022-05-02 | Sonoma | California | 6097 | 88095 | 490 |
2460723 | 2460723 | 2022-05-01 | Sonoma | California | 6097 | 88095 | 490 |
2457467 | 2457467 | 2022-04-30 | Sonoma | California | 6097 | 88095 | 490 |
2454211 | 2454211 | 2022-04-29 | Sonoma | California | 6097 | 88095 | 490 |
2450955 | 2450955 | 2022-04-28 | Sonoma | California | 6097 | 87684 | 490 |
2447699 | 2447699 | 2022-04-27 | Sonoma | California | 6097 | 87684 | 490 |
2444443 | 2444443 | 2022-04-26 | Sonoma | California | 6097 | 87684 | 489 |
2441187 | 2441187 | 2022-04-25 | Sonoma | California | 6097 | 87282 | 489 |
2437931 | 2437931 | 2022-04-24 | Sonoma | California | 6097 | 87282 | 489 |
2434675 | 2434675 | 2022-04-23 | Sonoma | California | 6097 | 87282 | 489 |
2431419 | 2431419 | 2022-04-22 | Sonoma | California | 6097 | 87282 | 489 |
2428163 | 2428163 | 2022-04-21 | Sonoma | California | 6097 | 86988 | 489 |
2424907 | 2424907 | 2022-04-20 | Sonoma | California | 6097 | 86988 | 489 |
2421651 | 2421651 | 2022-04-19 | Sonoma | California | 6097 | 86988 | 489 |
2418395 | 2418395 | 2022-04-18 | Sonoma | California | 6097 | 86731 | 488 |
2415139 | 2415139 | 2022-04-17 | Sonoma | California | 6097 | 86731 | 488 |
2411883 | 2411883 | 2022-04-16 | Sonoma | California | 6097 | 86731 | 488 |
2408627 | 2408627 | 2022-04-15 | Sonoma | California | 6097 | 86731 | 488 |
2405371 | 2405371 | 2022-04-14 | Sonoma | California | 6097 | 86592 | 488 |
2402116 | 2402116 | 2022-04-13 | Sonoma | California | 6097 | 86121 | 488 |
2398861 | 2398861 | 2022-04-12 | Sonoma | California | 6097 | 86121 | 488 |
2395606 | 2395606 | 2022-04-11 | Sonoma | California | 6097 | 86121 | 488 |
2392350 | 2392350 | 2022-04-10 | Sonoma | California | 6097 | 86121 | 488 |
2389094 | 2389094 | 2022-04-09 | Sonoma | California | 6097 | 86121 | 488 |
2385839 | 2385839 | 2022-04-08 | Sonoma | California | 6097 | 86121 | 488 |
2382584 | 2382584 | 2022-04-07 | Sonoma | California | 6097 | 85882 | 488 |
2379329 | 2379329 | 2022-04-06 | Sonoma | California | 6097 | 85882 | 488 |
2376075 | 2376075 | 2022-04-05 | Sonoma | California | 6097 | 85882 | 488 |
2372823 | 2372823 | 2022-04-04 | Sonoma | California | 6097 | 85756 | 487 |
2369570 | 2369570 | 2022-04-03 | Sonoma | California | 6097 | 85756 | 487 |
2366317 | 2366317 | 2022-04-02 | Sonoma | California | 6097 | 85756 | 487 |
2363064 | 2363064 | 2022-04-01 | Sonoma | California | 6097 | 85756 | 487 |
2359810 | 2359810 | 2022-03-31 | Sonoma | California | 6097 | 85684 | 487 |
2356556 | 2356556 | 2022-03-30 | Sonoma | California | 6097 | 85578 | 487 |
2353303 | 2353303 | 2022-03-29 | Sonoma | California | 6097 | 85553 | 487 |
2350051 | 2350051 | 2022-03-28 | Sonoma | California | 6097 | 85536 | 487 |
2346798 | 2346798 | 2022-03-27 | Sonoma | California | 6097 | 85561 | 487 |
2343545 | 2343545 | 2022-03-26 | Sonoma | California | 6097 | 85561 | 487 |
2340292 | 2340292 | 2022-03-25 | Sonoma | California | 6097 | 85561 | 487 |
2337039 | 2337039 | 2022-03-24 | Sonoma | California | 6097 | 85522 | 487 |
2333785 | 2333785 | 2022-03-23 | Sonoma | California | 6097 | 85454 | 484 |
2330531 | 2330531 | 2022-03-22 | Sonoma | California | 6097 | 85391 | 484 |
2327279 | 2327279 | 2022-03-21 | Sonoma | California | 6097 | 85377 | 484 |
2324026 | 2324026 | 2022-03-20 | Sonoma | California | 6097 | 85250 | 484 |
2320772 | 2320772 | 2022-03-19 | Sonoma | California | 6097 | 85250 | 483 |
2317518 | 2317518 | 2022-03-18 | Sonoma | California | 6097 | 85250 | 481 |
2314265 | 2314265 | 2022-03-17 | Sonoma | California | 6097 | 85203 | 481 |
2311012 | 2311012 | 2022-03-16 | Sonoma | California | 6097 | 85077 | 481 |
2307759 | 2307759 | 2022-03-15 | Sonoma | California | 6097 | 85071 | 481 |
2304508 | 2304508 | 2022-03-14 | Sonoma | California | 6097 | 85051 | 478 |
2301256 | 2301256 | 2022-03-13 | Sonoma | California | 6097 | 84962 | 478 |
2298004 | 2298004 | 2022-03-12 | Sonoma | California | 6097 | 84962 | 478 |
2294752 | 2294752 | 2022-03-11 | Sonoma | California | 6097 | 84962 | 478 |
2291500 | 2291500 | 2022-03-10 | Sonoma | California | 6097 | 84914 | 477 |
2288248 | 2288248 | 2022-03-09 | Sonoma | California | 6097 | 84638 | 477 |
2284997 | 2284997 | 2022-03-08 | Sonoma | California | 6097 | 84597 | 477 |
2281745 | 2281745 | 2022-03-07 | Sonoma | California | 6097 | 84525 | 476 |
2278492 | 2278492 | 2022-03-06 | Sonoma | California | 6097 | 84380 | 476 |
2275239 | 2275239 | 2022-03-05 | Sonoma | California | 6097 | 84380 | 476 |
2271986 | 2271986 | 2022-03-04 | Sonoma | California | 6097 | 84380 | 475 |
2268734 | 2268734 | 2022-03-03 | Sonoma | California | 6097 | 84275 | 475 |
2265481 | 2265481 | 2022-03-02 | Sonoma | California | 6097 | 84026 | 477 |
2262230 | 2262230 | 2022-03-01 | Sonoma | California | 6097 | 83981 | 477 |
2258979 | 2258979 | 2022-02-28 | Sonoma | California | 6097 | 83964 | 476 |
2255728 | 2255728 | 2022-02-27 | Sonoma | California | 6097 | 83625 | 474 |
2252477 | 2252477 | 2022-02-26 | Sonoma | California | 6097 | 83625 | 474 |
2249226 | 2249226 | 2022-02-25 | Sonoma | California | 6097 | 83625 | 474 |
2245975 | 2245975 | 2022-02-24 | Sonoma | California | 6097 | 83517 | 472 |
2242724 | 2242724 | 2022-02-23 | Sonoma | California | 6097 | 83311 | 472 |
2239473 | 2239473 | 2022-02-22 | Sonoma | California | 6097 | 83260 | 469 |
2236222 | 2236222 | 2022-02-21 | Sonoma | California | 6097 | 82742 | 469 |
2232971 | 2232971 | 2022-02-20 | Sonoma | California | 6097 | 82742 | 469 |
2229720 | 2229720 | 2022-02-19 | Sonoma | California | 6097 | 82742 | 469 |
2226469 | 2226469 | 2022-02-18 | Sonoma | California | 6097 | 82742 | 469 |
2223218 | 2223218 | 2022-02-17 | Sonoma | California | 6097 | 82541 | 464 |
2219967 | 2219967 | 2022-02-16 | Sonoma | California | 6097 | 82584 | 461 |
2216716 | 2216716 | 2022-02-15 | Sonoma | California | 6097 | 82487 | 461 |
2213465 | 2213465 | 2022-02-14 | Sonoma | California | 6097 | 82323 | 461 |
2210213 | 2210213 | 2022-02-13 | Sonoma | California | 6097 | 81684 | 461 |
2206960 | 2206960 | 2022-02-12 | Sonoma | California | 6097 | 81684 | 459 |
2203707 | 2203707 | 2022-02-11 | Sonoma | California | 6097 | 81684 | 459 |
2200454 | 2200454 | 2022-02-10 | Sonoma | California | 6097 | 81316 | 455 |
2197200 | 2197200 | 2022-02-09 | Sonoma | California | 6097 | 80943 | 455 |
2193945 | 2193945 | 2022-02-08 | Sonoma | California | 6097 | 80441 | 452 |
2190692 | 2190692 | 2022-02-07 | Sonoma | California | 6097 | 80032 | 448 |
2187439 | 2187439 | 2022-02-06 | Sonoma | California | 6097 | 79358 | 448 |
2184186 | 2184186 | 2022-02-05 | Sonoma | California | 6097 | 79358 | 448 |
2180934 | 2180934 | 2022-02-04 | Sonoma | California | 6097 | 79358 | 445 |
2177683 | 2177683 | 2022-02-03 | Sonoma | California | 6097 | 78826 | 445 |
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);