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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|
326 | 326 | 2020-02-26 | Sonoma | California | 6097 | 1 | 0 |
346 | 346 | 2020-02-27 | Sonoma | California | 6097 | 1 | 0 |
366 | 366 | 2020-02-28 | Sonoma | California | 6097 | 1 | 0 |
388 | 388 | 2020-02-29 | Sonoma | California | 6097 | 1 | 0 |
411 | 411 | 2020-03-01 | Sonoma | California | 6097 | 1 | 0 |
440 | 440 | 2020-03-02 | Sonoma | California | 6097 | 2 | 0 |
474 | 474 | 2020-03-03 | Sonoma | California | 6097 | 2 | 0 |
509 | 509 | 2020-03-04 | Sonoma | California | 6097 | 3 | 0 |
548 | 548 | 2020-03-05 | Sonoma | California | 6097 | 3 | 0 |
598 | 598 | 2020-03-06 | Sonoma | California | 6097 | 3 | 0 |
676 | 676 | 2020-03-07 | Sonoma | California | 6097 | 3 | 0 |
771 | 771 | 2020-03-08 | Sonoma | California | 6097 | 3 | 0 |
886 | 886 | 2020-03-09 | Sonoma | California | 6097 | 3 | 0 |
1019 | 1019 | 2020-03-10 | Sonoma | California | 6097 | 3 | 0 |
1185 | 1185 | 2020-03-11 | Sonoma | California | 6097 | 3 | 0 |
1391 | 1391 | 2020-03-12 | Sonoma | California | 6097 | 3 | 0 |
1652 | 1652 | 2020-03-13 | Sonoma | California | 6097 | 3 | 0 |
1970 | 1970 | 2020-03-14 | Sonoma | California | 6097 | 4 | 0 |
2351 | 2351 | 2020-03-15 | Sonoma | California | 6097 | 5 | 0 |
2786 | 2786 | 2020-03-16 | Sonoma | California | 6097 | 8 | 0 |
3268 | 3268 | 2020-03-17 | Sonoma | California | 6097 | 9 | 0 |
3822 | 3822 | 2020-03-18 | Sonoma | California | 6097 | 9 | 0 |
4482 | 4482 | 2020-03-19 | Sonoma | California | 6097 | 11 | 0 |
5257 | 5257 | 2020-03-20 | Sonoma | California | 6097 | 11 | 1 |
6179 | 6179 | 2020-03-21 | Sonoma | California | 6097 | 11 | 1 |
7213 | 7213 | 2020-03-22 | Sonoma | California | 6097 | 11 | 1 |
8356 | 8356 | 2020-03-23 | Sonoma | California | 6097 | 29 | 1 |
9599 | 9599 | 2020-03-24 | Sonoma | California | 6097 | 34 | 1 |
10971 | 10971 | 2020-03-25 | Sonoma | California | 6097 | 39 | 1 |
12516 | 12516 | 2020-03-26 | Sonoma | California | 6097 | 49 | 1 |
14182 | 14182 | 2020-03-27 | Sonoma | California | 6097 | 50 | 1 |
15964 | 15964 | 2020-03-28 | Sonoma | California | 6097 | 50 | 1 |
17853 | 17853 | 2020-03-29 | Sonoma | California | 6097 | 57 | 1 |
19830 | 19830 | 2020-03-30 | Sonoma | California | 6097 | 73 | 1 |
21905 | 21905 | 2020-03-31 | Sonoma | California | 6097 | 85 | 1 |
24063 | 24063 | 2020-04-01 | Sonoma | California | 6097 | 91 | 1 |
26292 | 26292 | 2020-04-02 | Sonoma | California | 6097 | 95 | 1 |
28591 | 28591 | 2020-04-03 | Sonoma | California | 6097 | 100 | 1 |
30949 | 30949 | 2020-04-04 | Sonoma | California | 6097 | 105 | 1 |
33355 | 33355 | 2020-04-05 | Sonoma | California | 6097 | 107 | 1 |
35800 | 35800 | 2020-04-06 | Sonoma | California | 6097 | 115 | 1 |
38289 | 38289 | 2020-04-07 | Sonoma | California | 6097 | 120 | 1 |
40833 | 40833 | 2020-04-08 | Sonoma | California | 6097 | 123 | 1 |
43405 | 43405 | 2020-04-09 | Sonoma | California | 6097 | 136 | 1 |
46005 | 46005 | 2020-04-10 | Sonoma | California | 6097 | 145 | 2 |
48635 | 48635 | 2020-04-11 | Sonoma | California | 6097 | 145 | 2 |
51297 | 51297 | 2020-04-12 | Sonoma | California | 6097 | 147 | 2 |
53976 | 53976 | 2020-04-13 | Sonoma | California | 6097 | 152 | 2 |
56668 | 56668 | 2020-04-14 | Sonoma | California | 6097 | 160 | 2 |
59376 | 59376 | 2020-04-15 | Sonoma | California | 6097 | 163 | 2 |
62095 | 62095 | 2020-04-16 | Sonoma | California | 6097 | 172 | 2 |
64828 | 64828 | 2020-04-17 | Sonoma | California | 6097 | 180 | 2 |
67576 | 67576 | 2020-04-18 | Sonoma | California | 6097 | 180 | 2 |
70338 | 70338 | 2020-04-19 | Sonoma | California | 6097 | 181 | 2 |
73107 | 73107 | 2020-04-20 | Sonoma | California | 6097 | 182 | 2 |
75883 | 75883 | 2020-04-21 | Sonoma | California | 6097 | 192 | 2 |
78667 | 78667 | 2020-04-22 | Sonoma | California | 6097 | 194 | 2 |
81461 | 81461 | 2020-04-23 | Sonoma | California | 6097 | 216 | 2 |
84261 | 84261 | 2020-04-24 | Sonoma | California | 6097 | 217 | 2 |
87069 | 87069 | 2020-04-25 | Sonoma | California | 6097 | 218 | 2 |
89886 | 89886 | 2020-04-26 | Sonoma | California | 6097 | 220 | 2 |
92704 | 92704 | 2020-04-27 | Sonoma | California | 6097 | 222 | 2 |
95536 | 95536 | 2020-04-28 | Sonoma | California | 6097 | 228 | 2 |
98381 | 98381 | 2020-04-29 | Sonoma | California | 6097 | 232 | 2 |
101231 | 101231 | 2020-04-30 | Sonoma | California | 6097 | 244 | 2 |
104086 | 104086 | 2020-05-01 | Sonoma | California | 6097 | 248 | 3 |
106951 | 106951 | 2020-05-02 | Sonoma | California | 6097 | 252 | 3 |
109820 | 109820 | 2020-05-03 | Sonoma | California | 6097 | 257 | 3 |
112695 | 112695 | 2020-05-04 | Sonoma | California | 6097 | 261 | 4 |
115578 | 115578 | 2020-05-05 | Sonoma | California | 6097 | 261 | 4 |
118537 | 118537 | 2020-05-06 | Sonoma | California | 6097 | 286 | 4 |
121504 | 121504 | 2020-05-07 | Sonoma | California | 6097 | 292 | 4 |
124484 | 124484 | 2020-05-08 | Sonoma | California | 6097 | 300 | 4 |
127469 | 127469 | 2020-05-09 | Sonoma | California | 6097 | 309 | 4 |
130459 | 130459 | 2020-05-10 | Sonoma | California | 6097 | 309 | 4 |
133449 | 133449 | 2020-05-11 | Sonoma | California | 6097 | 312 | 4 |
136439 | 136439 | 2020-05-12 | Sonoma | California | 6097 | 312 | 5 |
139430 | 139430 | 2020-05-13 | Sonoma | California | 6097 | 337 | 4 |
142426 | 142426 | 2020-05-14 | Sonoma | California | 6097 | 351 | 4 |
145425 | 145425 | 2020-05-15 | Sonoma | California | 6097 | 364 | 4 |
148429 | 148429 | 2020-05-16 | Sonoma | California | 6097 | 373 | 4 |
151438 | 151438 | 2020-05-17 | Sonoma | California | 6097 | 387 | 4 |
154450 | 154450 | 2020-05-18 | Sonoma | California | 6097 | 391 | 4 |
157466 | 157466 | 2020-05-19 | Sonoma | California | 6097 | 411 | 4 |
160492 | 160492 | 2020-05-20 | Sonoma | California | 6097 | 411 | 4 |
163520 | 163520 | 2020-05-21 | Sonoma | California | 6097 | 433 | 4 |
166553 | 166553 | 2020-05-22 | Sonoma | California | 6097 | 467 | 4 |
169590 | 169590 | 2020-05-23 | Sonoma | California | 6097 | 482 | 4 |
172631 | 172631 | 2020-05-24 | Sonoma | California | 6097 | 500 | 4 |
175675 | 175675 | 2020-05-25 | Sonoma | California | 6097 | 515 | 4 |
178719 | 178719 | 2020-05-26 | Sonoma | California | 6097 | 524 | 4 |
181763 | 181763 | 2020-05-27 | Sonoma | California | 6097 | 530 | 4 |
184817 | 184817 | 2020-05-28 | Sonoma | California | 6097 | 531 | 4 |
187873 | 187873 | 2020-05-29 | Sonoma | California | 6097 | 548 | 4 |
190938 | 190938 | 2020-05-30 | Sonoma | California | 6097 | 553 | 4 |
194005 | 194005 | 2020-05-31 | Sonoma | California | 6097 | 564 | 4 |
197075 | 197075 | 2020-06-01 | Sonoma | California | 6097 | 566 | 4 |
200148 | 200148 | 2020-06-02 | Sonoma | California | 6097 | 579 | 4 |
203224 | 203224 | 2020-06-03 | Sonoma | California | 6097 | 593 | 4 |
206304 | 206304 | 2020-06-04 | Sonoma | California | 6097 | 610 | 4 |
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);