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)
cases 595 ✖
- 3 10
- 1 5
- 42912 5
- 11 4
- 31160 4
- 40997 4
- 44981 4
- 46679 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
- 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
state 1
- California 708
fips 1
- 6097 · 708 ✖
county 1
- Sonoma 708
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174430 | 2174430 | 2022-02-02 | Sonoma | California | 6097 | 78143 | 445 |
2171177 | 2171177 | 2022-02-01 | Sonoma | California | 6097 | 77963 | 445 |
2167924 | 2167924 | 2022-01-31 | Sonoma | California | 6097 | 77654 | 445 |
2164669 | 2164669 | 2022-01-30 | Sonoma | California | 6097 | 75608 | 445 |
2161414 | 2161414 | 2022-01-29 | Sonoma | California | 6097 | 75203 | 440 |
2158158 | 2158158 | 2022-01-28 | Sonoma | California | 6097 | 75203 | 440 |
2154905 | 2154905 | 2022-01-27 | Sonoma | California | 6097 | 74273 | 437 |
2151652 | 2151652 | 2022-01-26 | Sonoma | California | 6097 | 73163 | 432 |
2148400 | 2148400 | 2022-01-25 | Sonoma | California | 6097 | 72263 | 432 |
2145148 | 2145148 | 2022-01-24 | Sonoma | California | 6097 | 71321 | 432 |
2141893 | 2141893 | 2022-01-23 | Sonoma | California | 6097 | 68776 | 432 |
2138638 | 2138638 | 2022-01-22 | Sonoma | California | 6097 | 67646 | 432 |
2135382 | 2135382 | 2022-01-21 | Sonoma | California | 6097 | 67543 | 429 |
2132130 | 2132130 | 2022-01-20 | Sonoma | California | 6097 | 66219 | 429 |
2128877 | 2128877 | 2022-01-19 | Sonoma | California | 6097 | 64701 | 429 |
2125623 | 2125623 | 2022-01-18 | Sonoma | California | 6097 | 63750 | 426 |
2122371 | 2122371 | 2022-01-17 | Sonoma | California | 6097 | 62829 | 426 |
2119119 | 2119119 | 2022-01-16 | Sonoma | California | 6097 | 60574 | 426 |
2115867 | 2115867 | 2022-01-15 | Sonoma | California | 6097 | 59439 | 426 |
2112616 | 2112616 | 2022-01-14 | Sonoma | California | 6097 | 59168 | 423 |
2109364 | 2109364 | 2022-01-13 | Sonoma | California | 6097 | 57381 | 422 |
2106113 | 2106113 | 2022-01-12 | Sonoma | California | 6097 | 56159 | 421 |
2102862 | 2102862 | 2022-01-11 | Sonoma | California | 6097 | 55226 | 421 |
2099611 | 2099611 | 2022-01-10 | Sonoma | California | 6097 | 54291 | 421 |
2096360 | 2096360 | 2022-01-09 | Sonoma | California | 6097 | 50878 | 419 |
2093108 | 2093108 | 2022-01-08 | Sonoma | California | 6097 | 50878 | 419 |
2089856 | 2089856 | 2022-01-07 | Sonoma | California | 6097 | 50878 | 419 |
2086605 | 2086605 | 2022-01-06 | Sonoma | California | 6097 | 49868 | 418 |
2083353 | 2083353 | 2022-01-05 | Sonoma | California | 6097 | 49292 | 418 |
2080101 | 2080101 | 2022-01-04 | Sonoma | California | 6097 | 49030 | 418 |
2076849 | 2076849 | 2022-01-03 | Sonoma | California | 6097 | 46679 | 418 |
2073598 | 2073598 | 2022-01-02 | Sonoma | California | 6097 | 46679 | 418 |
2070347 | 2070347 | 2022-01-01 | Sonoma | California | 6097 | 46679 | 418 |
2067096 | 2067096 | 2021-12-31 | Sonoma | California | 6097 | 46679 | 418 |
2063845 | 2063845 | 2021-12-30 | Sonoma | California | 6097 | 46118 | 418 |
2060595 | 2060595 | 2021-12-29 | Sonoma | California | 6097 | 45709 | 418 |
2057346 | 2057346 | 2021-12-28 | Sonoma | California | 6097 | 45613 | 418 |
2054097 | 2054097 | 2021-12-27 | Sonoma | California | 6097 | 44981 | 418 |
2050847 | 2050847 | 2021-12-26 | Sonoma | California | 6097 | 44981 | 418 |
2047597 | 2047597 | 2021-12-25 | Sonoma | California | 6097 | 44981 | 418 |
2044347 | 2044347 | 2021-12-24 | Sonoma | California | 6097 | 44981 | 416 |
2041098 | 2041098 | 2021-12-23 | Sonoma | California | 6097 | 44824 | 416 |
2037848 | 2037848 | 2021-12-22 | Sonoma | California | 6097 | 44652 | 416 |
2034598 | 2034598 | 2021-12-21 | Sonoma | California | 6097 | 44583 | 416 |
2031348 | 2031348 | 2021-12-20 | Sonoma | California | 6097 | 44545 | 416 |
2028097 | 2028097 | 2021-12-19 | Sonoma | California | 6097 | 44259 | 416 |
2024846 | 2024846 | 2021-12-18 | Sonoma | California | 6097 | 44259 | 416 |
2021595 | 2021595 | 2021-12-17 | Sonoma | California | 6097 | 44259 | 416 |
2018344 | 2018344 | 2021-12-16 | Sonoma | California | 6097 | 44181 | 416 |
2015094 | 2015094 | 2021-12-15 | Sonoma | California | 6097 | 44122 | 416 |
2011843 | 2011843 | 2021-12-14 | Sonoma | California | 6097 | 44076 | 416 |
2008592 | 2008592 | 2021-12-13 | Sonoma | California | 6097 | 44008 | 416 |
2005341 | 2005341 | 2021-12-12 | Sonoma | California | 6097 | 43811 | 416 |
2002090 | 2002090 | 2021-12-11 | Sonoma | California | 6097 | 43811 | 416 |
1998840 | 1998840 | 2021-12-10 | Sonoma | California | 6097 | 43811 | 414 |
1995589 | 1995589 | 2021-12-09 | Sonoma | California | 6097 | 43763 | 414 |
1992338 | 1992338 | 2021-12-08 | Sonoma | California | 6097 | 43725 | 414 |
1989087 | 1989087 | 2021-12-07 | Sonoma | California | 6097 | 43685 | 414 |
1985837 | 1985837 | 2021-12-06 | Sonoma | California | 6097 | 43609 | 414 |
1982587 | 1982587 | 2021-12-05 | Sonoma | California | 6097 | 43349 | 414 |
1979337 | 1979337 | 2021-12-04 | Sonoma | California | 6097 | 43349 | 414 |
1976087 | 1976087 | 2021-12-03 | Sonoma | California | 6097 | 43349 | 414 |
1972838 | 1972838 | 2021-12-02 | Sonoma | California | 6097 | 43284 | 412 |
1969588 | 1969588 | 2021-12-01 | Sonoma | California | 6097 | 43207 | 412 |
1966338 | 1966338 | 2021-11-30 | Sonoma | California | 6097 | 43168 | 412 |
1963086 | 1963086 | 2021-11-29 | Sonoma | California | 6097 | 43127 | 412 |
1959835 | 1959835 | 2021-11-28 | Sonoma | California | 6097 | 42912 | 412 |
1956584 | 1956584 | 2021-11-27 | Sonoma | California | 6097 | 42912 | 412 |
1953333 | 1953333 | 2021-11-26 | Sonoma | California | 6097 | 42912 | 412 |
1950082 | 1950082 | 2021-11-25 | Sonoma | California | 6097 | 42912 | 412 |
1946831 | 1946831 | 2021-11-24 | Sonoma | California | 6097 | 42912 | 412 |
1943580 | 1943580 | 2021-11-23 | Sonoma | California | 6097 | 42888 | 412 |
1940330 | 1940330 | 2021-11-22 | Sonoma | California | 6097 | 42842 | 412 |
1937080 | 1937080 | 2021-11-21 | Sonoma | California | 6097 | 42695 | 412 |
1933830 | 1933830 | 2021-11-20 | Sonoma | California | 6097 | 42695 | 412 |
1930578 | 1930578 | 2021-11-19 | Sonoma | California | 6097 | 42695 | 412 |
1927328 | 1927328 | 2021-11-18 | Sonoma | California | 6097 | 42637 | 412 |
1924078 | 1924078 | 2021-11-17 | Sonoma | California | 6097 | 42596 | 410 |
1920829 | 1920829 | 2021-11-16 | Sonoma | California | 6097 | 42561 | 410 |
1917579 | 1917579 | 2021-11-15 | Sonoma | California | 6097 | 42514 | 410 |
1914329 | 1914329 | 2021-11-14 | Sonoma | California | 6097 | 42422 | 410 |
1911079 | 1911079 | 2021-11-13 | Sonoma | California | 6097 | 42422 | 410 |
1907830 | 1907830 | 2021-11-12 | Sonoma | California | 6097 | 42314 | 410 |
1904581 | 1904581 | 2021-11-11 | Sonoma | California | 6097 | 42314 | 410 |
1901331 | 1901331 | 2021-11-10 | Sonoma | California | 6097 | 42260 | 410 |
1898081 | 1898081 | 2021-11-09 | Sonoma | California | 6097 | 42202 | 408 |
1894831 | 1894831 | 2021-11-08 | Sonoma | California | 6097 | 42163 | 408 |
1891581 | 1891581 | 2021-11-07 | Sonoma | California | 6097 | 41931 | 408 |
1888331 | 1888331 | 2021-11-06 | Sonoma | California | 6097 | 41931 | 408 |
1885081 | 1885081 | 2021-11-05 | Sonoma | California | 6097 | 41931 | 408 |
1881832 | 1881832 | 2021-11-04 | Sonoma | California | 6097 | 41859 | 408 |
1878583 | 1878583 | 2021-11-03 | Sonoma | California | 6097 | 41817 | 406 |
1875334 | 1875334 | 2021-11-02 | Sonoma | California | 6097 | 41763 | 406 |
1872085 | 1872085 | 2021-11-01 | Sonoma | California | 6097 | 41712 | 406 |
1868836 | 1868836 | 2021-10-31 | Sonoma | California | 6097 | 41453 | 406 |
1865587 | 1865587 | 2021-10-30 | Sonoma | California | 6097 | 41453 | 406 |
1862338 | 1862338 | 2021-10-29 | Sonoma | California | 6097 | 41453 | 404 |
1859089 | 1859089 | 2021-10-28 | Sonoma | California | 6097 | 41358 | 404 |
1855840 | 1855840 | 2021-10-27 | Sonoma | California | 6097 | 41315 | 404 |
1852591 | 1852591 | 2021-10-26 | Sonoma | California | 6097 | 41267 | 404 |
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);