ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39165 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
cases 668 ✖
- 2 2
- 20 2
- 112 2
- 124 2
- 131 2
- 757 2
- 8419 2
- 14490 2
- 15752 2
- 23455 2
- 24506 2
- 24519 2
- 24532 2
- 24660 2
- 35033 2
- 39061 2
- 40697 2
- 3 1
- 5 1
- 7 1
- 8 1
- 10 1
- 11 1
- 16 1
- 21 1
- 23 1
- 26 1
- 31 1
- 35 1
- 36 1
- 37 1
- 45 1
- 46 1
- 53 1
- 72 1
- 74 1
- 75 1
- 76 1
- 78 1
- 85 1
- 89 1
- 93 1
- 116 1
- 117 1
- 118 1
- 128 1
- 133 1
- 134 1
- 146 1
- 160 1
- 166 1
- 168 1
- 172 1
- 178 1
- 179 1
- 188 1
- 191 1
- 202 1
- 206 1
- 209 1
- 213 1
- 237 1
- 252 1
- 259 1
- 269 1
- 275 1
- 283 1
- 285 1
- 292 1
- 309 1
- 310 1
- 319 1
- 328 1
- 336 1
- 340 1
- 344 1
- 351 1
- 359 1
- 366 1
- 373 1
- 378 1
- 383 1
- 390 1
- 398 1
- 407 1
- 413 1
- 419 1
- 427 1
- 443 1
- 461 1
- 473 1
- 497 1
- 508 1
- 512 1
- 517 1
- 525 1
- 532 1
- 549 1
- 559 1
- 571 1
- 584 1
- 594 1
- 614 1
- 629 1
- 649 1
- 698 1
- 708 1
- 725 1
- 731 1
- 738 1
- 814 1
- 823 1
- 839 1
- 860 1
- 881 1
- 895 1
- 918 1
- 945 1
- 977 1
- 1009 1
- 1018 1
- 1068 1
- 1098 1
- 1124 1
- 1171 1
- 1203 1
- 1228 1
- 1256 1
- 1272 1
- 1307 1
- 1326 1
- 1358 1
- 1383 1
- 1400 1
- 1421 1
- 1451 1
- 1481 1
- 1517 1
- 1551 1
- 1579 1
- 1600 1
- 1634 1
- 1669 1
- 1689 1
- 1711 1
- 1742 1
- 1767 1
- 1789 1
- 1803 1
- 1821 1
- 1850 1
- 1877 1
- 1914 1
- 1937 1
- 1946 1
- 1962 1
- 1981 1
- 2009 1
- 2034 1
- 2067 1
- 2090 1
- 2105 1
- 2130 1
- 2155 1
- 2173 1
- 2198 1
- 2234 1
- 2259 1
- 2286 1
- 2313 1
- 2367 1
- 2388 1
- 2417 1
- 2444 1
- 2475 1
- 2503 1
- 2528 1
- 2545 1
- 2555 1
- 2603 1
- 2649 1
- 2692 1
- 2717 1
- 2748 1
- 2795 1
- 2818 1
- 2856 1
- 2876 1
- 2893 1
- 2910 1
- 2927 1
- 2947 1
- 2978 1
- 3002 1
- 3023 1
- 3083 1
- 3096 1
- 3115 1
- 3136 1
- 3167 1
- 3189 1
- 3215 1
- 3241 1
- 3265 1
- 3271 1
- 3324 1
- 3365 1
- 3414 1
- 3468 1
- 3514 1
- 3543 1
- 3564 1
- 3606 1
- 3679 1
- 3735 1
- 3799 1
- 3879 1
- 3933 1
- 3981 1
- 4063 1
- 4135 1
- 4200 1
- 4284 1
- 4359 1
- 4410 1
- 4465 1
- 4541 1
- 4612 1
- 4711 1
- 4780 1
- 4853 1
- 4921 1
- 4980 1
- 5084 1
- 5157 1
- 5264 1
- 5375 1
- 5522 1
- 5590 1
- 5666 1
- 5810 1
- 5923 1
- 6039 1
- 6225 1
- 6387 1
- 6538 1
- 6751 1
- 6912 1
- 7031 1
- 7169 1
- 7373 1
- 7543 1
- 7703 1
- 7989 1
- 8191 1
- 8787 1
- 8921 1
- 9090 1
- 9263 1
- 9500 1
- 9704 1
- 9943 1
- 10193 1
- 10404 1
- 10573 1
- 10708 1
- 11240 1
- 11480 1
- 11705 1
- 11970 1
- 12189 1
- 12362 1
- 12501 1
- 12739 1
- 12889 1
- 13156 1
- 13372 1
- 13610 1
- 13800 1
- 13918 1
- 14104 1
- 14279 1
- 14742 1
- 14921 1
- 15023 1
- 15242 1
- 15502 1
- 16139 1
- 16262 1
- 16387 1
- 16620 1
- 16873 1
- 17135 1
- 17396 1
- 17562 1
- 17737 1
- 17861 1
- 18095 1
- 18268 1
- 18471 1
- 18659 1
- 18792 1
- 18917 1
- 18974 1
- 19083 1
- 19222 1
- 19436 1
- 19552 1
- 19671 1
- 19746 1
- 19830 1
- 19939 1
- 20053 1
- 20222 1
- 20356 1
- 20444 1
- 20531 1
- 20618 1
- 20726 1
- 20836 1
- 20929 1
- 21020 1
- 21112 1
- 21162 1
- 21220 1
- 21307 1
- 21375 1
- 21427 1
- 21499 1
- 21573 1
- 21596 1
- 21634 1
- 21702 1
- 21748 1
- 21806 1
- 21875 1
- 21997 1
- 22041 1
- 22083 1
- 22137 1
- 22166 1
- 22244 1
- 22294 1
- 22334 1
- 22361 1
- 22381 1
- 22421 1
- 22464 1
- 22510 1
- 22539 1
- 22574 1
- 22593 1
- 22609 1
- 22669 1
- 22710 1
- 22736 1
- 22772 1
- 22812 1
- 22833 1
- 22849 1
- 22904 1
- 22932 1
- 22975 1
- 23006 1
- 23040 1
- 23063 1
- 23092 1
- 23116 1
- 23144 1
- 23166 1
- 23219 1
- 23245 1
- 23259 1
- 23290 1
- 23328 1
- 23350 1
- 23390 1
- 23415 1
- 23511 1
- 23555 1
- 23583 1
- 23634 1
- 23660 1
- 23688 1
- 23725 1
- 23743 1
- 23788 1
- 23805 1
- 23835 1
- 23864 1
- 23885 1
- 23893 1
- 23910 1
- 23937 1
- 23964 1
- 23987 1
- 24018 1
- 24033 1
- 24043 1
- 24062 1
- 24086 1
- 24104 1
- 24120 1
- 24139 1
- 24163 1
- 24175 1
- 24186 1
- 24214 1
- 24236 1
- 24249 1
- 24262 1
- 24274 1
- 24282 1
- 24296 1
- 24313 1
- 24329 1
- 24344 1
- 24359 1
- 24369 1
- 24380 1
- 24390 1
- 24398 1
- 24410 1
- 24427 1
- 24448 1
- 24462 1
- 24473 1
- 24481 1
- 24488 1
- 24498 1
- 24513 1
- 24514 1
- 24523 1
- 24527 1
- 24533 1
- 24536 1
- 24540 1
- 24541 1
- 24546 1
- 24550 1
- 24554 1
- 24557 1
- 24558 1
- 24566 1
- 24573 1
- 24580 1
- 24586 1
- 24591 1
- 24595 1
- 24600 1
- 24607 1
- 24612 1
- 24619 1
- 24624 1
- 24636 1
- 24639 1
- 24640 1
- 24646 1
- 24652 1
- 24655 1
- 24657 1
- 24665 1
- 24667 1
- 24671 1
- 24672 1
- 24683 1
- 24690 1
- 24700 1
- 24703 1
- 24721 1
- 24731 1
- 24741 1
- 24752 1
- 24766 1
- 24773 1
- 24778 1
- 24793 1
- 24810 1
- 24828 1
- 24850 1
- 24864 1
- 24887 1
- 24896 1
- 24919 1
- 24959 1
- 24987 1
- 25011 1
- 25045 1
- 25075 1
- 25089 1
- 25125 1
- 25169 1
- 25226 1
- 25267 1
- 25314 1
- 25353 1
- 25374 1
- 25434 1
- 25526 1
- 25607 1
- 25653 1
- 25693 1
- 25724 1
- 25775 1
- 25836 1
- 25895 1
- 25955 1
- 26037 1
- 26096 1
- 26139 1
- 26176 1
- 26273 1
- 26390 1
- 26508 1
- 26607 1
- 26716 1
- 26852 1
- 26890 1
- 27037 1
- 27314 1
- 27497 1
- 27641 1
- 27785 1
- 27936 1
- 28000 1
- 28104 1
- 28228 1
- 28384 1
- 28563 1
- 28738 1
- 28797 1
- 28905 1
- 29045 1
- 29170 1
- 29315 1
- 29470 1
- 29609 1
- 29684 1
- 29781 1
- 29899 1
- 30001 1
- 30182 1
- 30328 1
- 30404 1
- 30497 1
- 30544 1
- 30684 1
- 30776 1
- 30905 1
- 31028 1
- 31125 1
- 31182 1
- 31259 1
- 31348 1
- 31471 1
- 31586 1
- 31700 1
- 31782 1
- 31892 1
- 31925 1
- 31985 1
- 32071 1
- 32183 1
- 32293 1
- 32373 1
- 32425 1
- 32476 1
- 32526 1
- 32631 1
- 32687 1
- 32769 1
- 32836 1
- 32880 1
- 32903 1
- 32958 1
- 33012 1
- 33061 1
- 33095 1
- 33158 1
- 33209 1
- 33247 1
- 33306 1
- 33384 1
- 33457 1
- 33529 1
- 33582 1
- 33659 1
- 33686 1
- 33763 1
- 33838 1
- 33914 1
- 34027 1
- 34083 1
- 34144 1
- 34193 1
- 34291 1
- 34388 1
- 34495 1
- 34589 1
- 34696 1
- 34747 1
- 34829 1
- 34928 1
- 35195 1
- 35239 1
- 35309 1
- 35404 1
- 35509 1
- 35651 1
- 35785 1
- 35959 1
- 36097 1
- 36183 1
- 36238 1
- 36377 1
- 36582 1
- 36736 1
- 36841 1
- 36976 1
- 37046 1
- 37191 1
- 37547 1
- 37703 1
- 38008 1
- 38122 1
- 38251 1
- 38337 1
- 38432 1
- 38553 1
- 38681 1
- 38874 1
- 39289 1
- 39413 1
- 39665 1
- 39935 1
- 40358 1
- 41293 1
- 41555 1
- 42009 1
- 42393 1
- 42750 1
- 43254 1
- 43653 1
- 44065 1
- 44444 1
- 45004 1
- 45399 1
- 46009 1
- 47468 1
- 48822 1
- 49505 1
- 49934 1
- 50411 1
- 51040 1
- 51721 1
- 52395 1
- 52895 1
- 53167 1
- 53428 1
- 53550 1
- 54195 1
- 54489 1
- 54761 1
- 55049 1
- 55226 1
- 55320 1
- 55494 1
- 55764 1
state 1
- Ohio 685
fips 1
- 39165 · 685 ✖
county 1
- Warren 685
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176343 | 2176343 | 2022-02-02 | Warren | Ohio | 39165 | 55764 | 508 |
2173089 | 2173089 | 2022-02-01 | Warren | Ohio | 39165 | 55494 | 508 |
2169837 | 2169837 | 2022-01-31 | Warren | Ohio | 39165 | 55320 | 503 |
2166582 | 2166582 | 2022-01-30 | Warren | Ohio | 39165 | 55226 | 503 |
2163327 | 2163327 | 2022-01-29 | Warren | Ohio | 39165 | 55049 | 503 |
2160072 | 2160072 | 2022-01-28 | Warren | Ohio | 39165 | 54761 | 503 |
2156817 | 2156817 | 2022-01-27 | Warren | Ohio | 39165 | 54489 | 493 |
2153564 | 2153564 | 2022-01-26 | Warren | Ohio | 39165 | 54195 | 493 |
2150312 | 2150312 | 2022-01-25 | Warren | Ohio | 39165 | 53550 | 493 |
2147060 | 2147060 | 2022-01-24 | Warren | Ohio | 39165 | 53428 | 489 |
2143806 | 2143806 | 2022-01-23 | Warren | Ohio | 39165 | 53167 | 489 |
2140551 | 2140551 | 2022-01-22 | Warren | Ohio | 39165 | 52895 | 489 |
2137295 | 2137295 | 2022-01-21 | Warren | Ohio | 39165 | 52395 | 489 |
2134041 | 2134041 | 2022-01-20 | Warren | Ohio | 39165 | 51721 | 475 |
2130789 | 2130789 | 2022-01-19 | Warren | Ohio | 39165 | 51040 | 475 |
2127535 | 2127535 | 2022-01-18 | Warren | Ohio | 39165 | 50411 | 475 |
2124283 | 2124283 | 2022-01-17 | Warren | Ohio | 39165 | 49934 | 468 |
2121031 | 2121031 | 2022-01-16 | Warren | Ohio | 39165 | 49505 | 468 |
2117779 | 2117779 | 2022-01-15 | Warren | Ohio | 39165 | 48822 | 468 |
2114528 | 2114528 | 2022-01-14 | Warren | Ohio | 39165 | 47468 | 468 |
2111276 | 2111276 | 2022-01-13 | Warren | Ohio | 39165 | 46009 | 465 |
2108024 | 2108024 | 2022-01-12 | Warren | Ohio | 39165 | 45399 | 465 |
2104773 | 2104773 | 2022-01-11 | Warren | Ohio | 39165 | 45004 | 465 |
2101522 | 2101522 | 2022-01-10 | Warren | Ohio | 39165 | 44444 | 458 |
2098271 | 2098271 | 2022-01-09 | Warren | Ohio | 39165 | 44065 | 458 |
2095019 | 2095019 | 2022-01-08 | Warren | Ohio | 39165 | 43653 | 458 |
2091767 | 2091767 | 2022-01-07 | Warren | Ohio | 39165 | 43254 | 458 |
2088515 | 2088515 | 2022-01-06 | Warren | Ohio | 39165 | 42750 | 453 |
2085264 | 2085264 | 2022-01-05 | Warren | Ohio | 39165 | 42393 | 453 |
2082012 | 2082012 | 2022-01-04 | Warren | Ohio | 39165 | 42009 | 453 |
2078760 | 2078760 | 2022-01-03 | Warren | Ohio | 39165 | 41555 | 449 |
2075509 | 2075509 | 2022-01-02 | Warren | Ohio | 39165 | 41293 | 449 |
2072258 | 2072258 | 2022-01-01 | Warren | Ohio | 39165 | 40697 | 449 |
2069007 | 2069007 | 2021-12-31 | Warren | Ohio | 39165 | 40697 | 449 |
2065756 | 2065756 | 2021-12-30 | Warren | Ohio | 39165 | 40358 | 444 |
2062506 | 2062506 | 2021-12-29 | Warren | Ohio | 39165 | 39935 | 444 |
2059256 | 2059256 | 2021-12-28 | Warren | Ohio | 39165 | 39665 | 444 |
2056007 | 2056007 | 2021-12-27 | Warren | Ohio | 39165 | 39413 | 441 |
2052758 | 2052758 | 2021-12-26 | Warren | Ohio | 39165 | 39289 | 441 |
2049508 | 2049508 | 2021-12-25 | Warren | Ohio | 39165 | 39061 | 441 |
2046258 | 2046258 | 2021-12-24 | Warren | Ohio | 39165 | 39061 | 441 |
2043008 | 2043008 | 2021-12-23 | Warren | Ohio | 39165 | 38874 | 436 |
2039759 | 2039759 | 2021-12-22 | Warren | Ohio | 39165 | 38681 | 436 |
2036509 | 2036509 | 2021-12-21 | Warren | Ohio | 39165 | 38553 | 436 |
2033259 | 2033259 | 2021-12-20 | Warren | Ohio | 39165 | 38432 | 433 |
2030009 | 2030009 | 2021-12-19 | Warren | Ohio | 39165 | 38337 | 433 |
2026758 | 2026758 | 2021-12-18 | Warren | Ohio | 39165 | 38251 | 433 |
2023507 | 2023507 | 2021-12-17 | Warren | Ohio | 39165 | 38122 | 433 |
2020256 | 2020256 | 2021-12-16 | Warren | Ohio | 39165 | 38008 | 425 |
2017005 | 2017005 | 2021-12-15 | Warren | Ohio | 39165 | 37703 | 425 |
2013755 | 2013755 | 2021-12-14 | Warren | Ohio | 39165 | 37547 | 425 |
2010504 | 2010504 | 2021-12-13 | Warren | Ohio | 39165 | 37191 | 423 |
2007253 | 2007253 | 2021-12-12 | Warren | Ohio | 39165 | 37046 | 423 |
2004002 | 2004002 | 2021-12-11 | Warren | Ohio | 39165 | 36976 | 423 |
2000751 | 2000751 | 2021-12-10 | Warren | Ohio | 39165 | 36841 | 423 |
1997501 | 1997501 | 2021-12-09 | Warren | Ohio | 39165 | 36736 | 418 |
1994250 | 1994250 | 2021-12-08 | Warren | Ohio | 39165 | 36582 | 418 |
1990999 | 1990999 | 2021-12-07 | Warren | Ohio | 39165 | 36377 | 418 |
1987748 | 1987748 | 2021-12-06 | Warren | Ohio | 39165 | 36238 | 417 |
1984498 | 1984498 | 2021-12-05 | Warren | Ohio | 39165 | 36183 | 417 |
1981248 | 1981248 | 2021-12-04 | Warren | Ohio | 39165 | 36097 | 417 |
1977998 | 1977998 | 2021-12-03 | Warren | Ohio | 39165 | 35959 | 417 |
1974748 | 1974748 | 2021-12-02 | Warren | Ohio | 39165 | 35785 | 412 |
1971499 | 1971499 | 2021-12-01 | Warren | Ohio | 39165 | 35651 | 412 |
1968249 | 1968249 | 2021-11-30 | Warren | Ohio | 39165 | 35509 | 412 |
1964998 | 1964998 | 2021-11-29 | Warren | Ohio | 39165 | 35404 | 412 |
1961746 | 1961746 | 2021-11-28 | Warren | Ohio | 39165 | 35309 | 412 |
1958495 | 1958495 | 2021-11-27 | Warren | Ohio | 39165 | 35239 | 412 |
1955244 | 1955244 | 2021-11-26 | Warren | Ohio | 39165 | 35195 | 412 |
1951993 | 1951993 | 2021-11-25 | Warren | Ohio | 39165 | 35033 | 408 |
1948742 | 1948742 | 2021-11-24 | Warren | Ohio | 39165 | 35033 | 408 |
1945491 | 1945491 | 2021-11-23 | Warren | Ohio | 39165 | 34928 | 408 |
1942240 | 1942240 | 2021-11-22 | Warren | Ohio | 39165 | 34829 | 408 |
1938990 | 1938990 | 2021-11-21 | Warren | Ohio | 39165 | 34747 | 408 |
1935740 | 1935740 | 2021-11-20 | Warren | Ohio | 39165 | 34696 | 408 |
1932490 | 1932490 | 2021-11-19 | Warren | Ohio | 39165 | 34589 | 408 |
1929239 | 1929239 | 2021-11-18 | Warren | Ohio | 39165 | 34495 | 404 |
1925989 | 1925989 | 2021-11-17 | Warren | Ohio | 39165 | 34388 | 404 |
1922739 | 1922739 | 2021-11-16 | Warren | Ohio | 39165 | 34291 | 404 |
1919490 | 1919490 | 2021-11-15 | Warren | Ohio | 39165 | 34193 | 401 |
1916240 | 1916240 | 2021-11-14 | Warren | Ohio | 39165 | 34144 | 401 |
1912990 | 1912990 | 2021-11-13 | Warren | Ohio | 39165 | 34083 | 401 |
1909740 | 1909740 | 2021-11-12 | Warren | Ohio | 39165 | 34027 | 401 |
1906491 | 1906491 | 2021-11-11 | Warren | Ohio | 39165 | 33914 | 398 |
1903242 | 1903242 | 2021-11-10 | Warren | Ohio | 39165 | 33838 | 398 |
1899992 | 1899992 | 2021-11-09 | Warren | Ohio | 39165 | 33763 | 398 |
1896742 | 1896742 | 2021-11-08 | Warren | Ohio | 39165 | 33686 | 393 |
1893492 | 1893492 | 2021-11-07 | Warren | Ohio | 39165 | 33659 | 393 |
1890242 | 1890242 | 2021-11-06 | Warren | Ohio | 39165 | 33582 | 393 |
1886992 | 1886992 | 2021-11-05 | Warren | Ohio | 39165 | 33529 | 393 |
1883742 | 1883742 | 2021-11-04 | Warren | Ohio | 39165 | 33457 | 389 |
1880493 | 1880493 | 2021-11-03 | Warren | Ohio | 39165 | 33384 | 389 |
1877244 | 1877244 | 2021-11-02 | Warren | Ohio | 39165 | 33306 | 389 |
1873995 | 1873995 | 2021-11-01 | Warren | Ohio | 39165 | 33247 | 384 |
1870746 | 1870746 | 2021-10-31 | Warren | Ohio | 39165 | 33209 | 384 |
1867497 | 1867497 | 2021-10-30 | Warren | Ohio | 39165 | 33158 | 384 |
1864248 | 1864248 | 2021-10-29 | Warren | Ohio | 39165 | 33095 | 384 |
1860999 | 1860999 | 2021-10-28 | Warren | Ohio | 39165 | 33061 | 377 |
1857750 | 1857750 | 2021-10-27 | Warren | Ohio | 39165 | 33012 | 377 |
1854501 | 1854501 | 2021-10-26 | Warren | Ohio | 39165 | 32958 | 377 |
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);