ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 39135 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 626 ✖
- 27 10
- 39 9
- 25 8
- 28 8
- 30 8
- 9437 7
- 9445 7
- 9449 7
- 9453 7
- 9455 7
- 9459 7
- 9472 7
- 9476 7
- 3833 5
- 3847 5
- 1 4
- 3843 4
- 9435 4
- 21 3
- 51 3
- 73 3
- 3558 3
- 3813 3
- 3897 3
- 9434 3
- 5 2
- 20 2
- 31 2
- 35 2
- 40 2
- 44 2
- 57 2
- 66 2
- 96 2
- 126 2
- 411 2
- 420 2
- 1565 2
- 2538 2
- 2719 2
- 3387 2
- 3536 2
- 3649 2
- 3796 2
- 3810 2
- 3831 2
- 3839 2
- 3841 2
- 3848 2
- 3856 2
- 3882 2
- 3886 2
- 6131 2
- 6861 2
- 7062 2
- 9287 2
- 9494 2
- 3 1
- 4 1
- 7 1
- 8 1
- 9 1
- 10 1
- 11 1
- 15 1
- 16 1
- 17 1
- 24 1
- 29 1
- 33 1
- 37 1
- 41 1
- 42 1
- 43 1
- 45 1
- 46 1
- 49 1
- 50 1
- 52 1
- 55 1
- 59 1
- 60 1
- 62 1
- 70 1
- 78 1
- 80 1
- 81 1
- 82 1
- 90 1
- 91 1
- 97 1
- 102 1
- 104 1
- 105 1
- 107 1
- 108 1
- 110 1
- 113 1
- 114 1
- 115 1
- 122 1
- 123 1
- 131 1
- 140 1
- 154 1
- 162 1
- 164 1
- 166 1
- 172 1
- 175 1
- 176 1
- 180 1
- 201 1
- 203 1
- 204 1
- 207 1
- 212 1
- 219 1
- 230 1
- 250 1
- 256 1
- 259 1
- 268 1
- 270 1
- 289 1
- 298 1
- 299 1
- 309 1
- 317 1
- 320 1
- 323 1
- 328 1
- 329 1
- 343 1
- 345 1
- 347 1
- 352 1
- 359 1
- 364 1
- 373 1
- 374 1
- 376 1
- 380 1
- 381 1
- 388 1
- 391 1
- 394 1
- 397 1
- 398 1
- 403 1
- 409 1
- 415 1
- 418 1
- 422 1
- 425 1
- 430 1
- 433 1
- 435 1
- 440 1
- 445 1
- 447 1
- 453 1
- 464 1
- 470 1
- 472 1
- 474 1
- 476 1
- 480 1
- 484 1
- 490 1
- 500 1
- 510 1
- 513 1
- 521 1
- 525 1
- 533 1
- 547 1
- 555 1
- 568 1
- 574 1
- 588 1
- 595 1
- 610 1
- 624 1
- 635 1
- 647 1
- 657 1
- 677 1
- 691 1
- 707 1
- 721 1
- 743 1
- 763 1
- 798 1
- 807 1
- 828 1
- 840 1
- 870 1
- 891 1
- 928 1
- 940 1
- 961 1
- 995 1
- 1022 1
- 1050 1
- 1088 1
- 1128 1
- 1177 1
- 1210 1
- 1247 1
- 1286 1
- 1325 1
- 1367 1
- 1395 1
- 1438 1
- 1484 1
- 1526 1
- 1625 1
- 1657 1
- 1691 1
- 1710 1
- 1740 1
- 1773 1
- 1800 1
- 1830 1
- 1876 1
- 1908 1
- 1945 1
- 2055 1
- 2118 1
- 2149 1
- 2187 1
- 2228 1
- 2250 1
- 2283 1
- 2311 1
- 2331 1
- 2372 1
- 2404 1
- 2440 1
- 2464 1
- 2476 1
- 2499 1
- 2507 1
- 2595 1
- 2628 1
- 2630 1
- 2653 1
- 2678 1
- 2759 1
- 2775 1
- 2788 1
- 2818 1
- 2855 1
- 2881 1
- 2914 1
- 2945 1
- 2966 1
- 2973 1
- 3019 1
- 3035 1
- 3064 1
- 3081 1
- 3100 1
- 3115 1
- 3124 1
- 3138 1
- 3153 1
- 3184 1
- 3191 1
- 3206 1
- 3214 1
- 3227 1
- 3236 1
- 3250 1
- 3276 1
- 3289 1
- 3300 1
- 3306 1
- 3313 1
- 3320 1
- 3336 1
- 3353 1
- 3363 1
- 3381 1
- 3407 1
- 3421 1
- 3435 1
- 3440 1
- 3451 1
- 3456 1
- 3462 1
- 3470 1
- 3474 1
- 3479 1
- 3483 1
- 3491 1
- 3493 1
- 3495 1
- 3505 1
- 3510 1
- 3513 1
- 3517 1
- 3524 1
- 3525 1
- 3526 1
- 3533 1
- 3538 1
- 3539 1
- 3541 1
- 3543 1
- 3545 1
- 3547 1
- 3552 1
- 3564 1
- 3569 1
- 3571 1
- 3576 1
- 3581 1
- 3587 1
- 3588 1
- 3594 1
- 3601 1
- 3604 1
- 3608 1
- 3615 1
- 3619 1
- 3622 1
- 3625 1
- 3631 1
- 3634 1
- 3643 1
- 3644 1
- 3655 1
- 3656 1
- 3666 1
- 3671 1
- 3675 1
- 3679 1
- 3682 1
- 3684 1
- 3689 1
- 3692 1
- 3695 1
- 3698 1
- 3703 1
- 3704 1
- 3710 1
- 3716 1
- 3724 1
- 3728 1
- 3730 1
- 3735 1
- 3739 1
- 3749 1
- 3752 1
- 3757 1
- 3761 1
- 3767 1
- 3770 1
- 3772 1
- 3776 1
- 3782 1
- 3784 1
- 3790 1
- 3793 1
- 3795 1
- 3798 1
- 3807 1
- 3811 1
- 3812 1
- 3819 1
- 3823 1
- 3825 1
- 3827 1
- 3834 1
- 3835 1
- 3844 1
- 3852 1
- 3855 1
- 3858 1
- 3859 1
- 3863 1
- 3864 1
- 3866 1
- 3867 1
- 3868 1
- 3871 1
- 3874 1
- 3879 1
- 3880 1
- 3883 1
- 3888 1
- 3893 1
- 3894 1
- 3902 1
- 3903 1
- 3910 1
- 3916 1
- 3919 1
- 3922 1
- 3925 1
- 3926 1
- 3933 1
- 3940 1
- 3941 1
- 3944 1
- 3946 1
- 3949 1
- 3956 1
- 3959 1
- 3969 1
- 3976 1
- 3980 1
- 3982 1
- 3988 1
- 3991 1
- 3998 1
- 4003 1
- 4013 1
- 4019 1
- 4024 1
- 4035 1
- 4049 1
- 4060 1
- 4076 1
- 4081 1
- 4086 1
- 4087 1
- 4108 1
- 4113 1
- 4127 1
- 4138 1
- 4156 1
- 4161 1
- 4173 1
- 4179 1
- 4210 1
- 4237 1
- 4255 1
- 4293 1
- 4305 1
- 4315 1
- 4346 1
- 4371 1
- 4420 1
- 4450 1
- 4472 1
- 4506 1
- 4520 1
- 4536 1
- 4576 1
- 4622 1
- 4645 1
- 4688 1
- 4706 1
- 4725 1
- 4747 1
- 4788 1
- 4825 1
- 4873 1
- 4902 1
- 4917 1
- 4938 1
- 4960 1
- 4994 1
- 5033 1
- 5058 1
- 5102 1
- 5123 1
- 5131 1
- 5152 1
- 5183 1
- 5252 1
- 5285 1
- 5317 1
- 5331 1
- 5348 1
- 5375 1
- 5412 1
- 5462 1
- 5493 1
- 5508 1
- 5526 1
- 5536 1
- 5553 1
- 5580 1
- 5599 1
- 5623 1
- 5640 1
- 5648 1
- 5660 1
- 5668 1
- 5686 1
- 5692 1
- 5710 1
- 5720 1
- 5728 1
- 5730 1
- 5750 1
- 5759 1
- 5779 1
- 5784 1
- 5798 1
- 5804 1
- 5806 1
- 5815 1
- 5817 1
- 5830 1
- 5846 1
- 5859 1
- 5868 1
- 5877 1
- 5884 1
- 5892 1
- 5910 1
- 5930 1
- 5951 1
- 5964 1
- 5972 1
- 5990 1
- 6020 1
- 6039 1
- 6059 1
- 6071 1
- 6075 1
- 6086 1
- 6103 1
- 6147 1
- 6153 1
- 6161 1
- 6171 1
- 6194 1
- 6223 1
- 6243 1
- 6274 1
- 6310 1
- 6334 1
- 6343 1
- 6362 1
- 6397 1
- 6430 1
- 6462 1
- 6498 1
- 6511 1
- 6537 1
- 6573 1
- 6594 1
- 6622 1
- 6650 1
- 6667 1
- 6689 1
- 6711 1
- 6751 1
- 6789 1
- 6826 1
- 6887 1
- 6899 1
- 6935 1
- 6963 1
- 7016 1
- 7128 1
- 7169 1
- 7203 1
- 7241 1
- 7291 1
- 7329 1
- 7362 1
- 7402 1
- 7437 1
- 7499 1
- 7550 1
- 7612 1
- 7700 1
- 7854 1
- 7950 1
- 8002 1
- 8069 1
- 8145 1
- 8265 1
- 8362 1
- 8428 1
- 8476 1
- 8524 1
- 8557 1
- 8660 1
- 8743 1
- 8804 1
- 8863 1
- 8891 1
- 8917 1
- 8950 1
- 9004 1
- 9041 1
- 9095 1
- 9123 1
- 9136 1
- 9148 1
- 9183 1
- 9223 1
- 9263 1
- 9291 1
- 9299 1
- 9305 1
- 9314 1
- 9323 1
- 9331 1
- 9341 1
- 9343 1
- 9345 1
- 9348 1
- 9363 1
- 9374 1
- 9380 1
- 9386 1
- 9388 1
- 9391 1
- 9395 1
- 9398 1
- 9408 1
- 9416 1
- 9419 1
- 9420 1
- 9421 1
- 9423 1
- 9427 1
state 1
- Ohio · 775 ✖
fips 1
- 39135 · 775 ✖
county 1
- Preble 775
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501711 | 2501711 | 2022-05-13 | Preble | Ohio | 39135 | 9494 | 201 |
2498453 | 2498453 | 2022-05-12 | Preble | Ohio | 39135 | 9494 | 201 |
2495195 | 2495195 | 2022-05-11 | Preble | Ohio | 39135 | 9476 | 199 |
2491937 | 2491937 | 2022-05-10 | Preble | Ohio | 39135 | 9476 | 199 |
2488679 | 2488679 | 2022-05-09 | Preble | Ohio | 39135 | 9476 | 199 |
2485422 | 2485422 | 2022-05-08 | Preble | Ohio | 39135 | 9476 | 199 |
2482164 | 2482164 | 2022-05-07 | Preble | Ohio | 39135 | 9476 | 199 |
2478906 | 2478906 | 2022-05-06 | Preble | Ohio | 39135 | 9476 | 199 |
2475648 | 2475648 | 2022-05-05 | Preble | Ohio | 39135 | 9476 | 199 |
2472391 | 2472391 | 2022-05-04 | Preble | Ohio | 39135 | 9472 | 198 |
2469135 | 2469135 | 2022-05-03 | Preble | Ohio | 39135 | 9472 | 198 |
2465879 | 2465879 | 2022-05-02 | Preble | Ohio | 39135 | 9472 | 198 |
2462624 | 2462624 | 2022-05-01 | Preble | Ohio | 39135 | 9472 | 198 |
2459368 | 2459368 | 2022-04-30 | Preble | Ohio | 39135 | 9472 | 198 |
2456112 | 2456112 | 2022-04-29 | Preble | Ohio | 39135 | 9472 | 198 |
2452856 | 2452856 | 2022-04-28 | Preble | Ohio | 39135 | 9472 | 198 |
2449600 | 2449600 | 2022-04-27 | Preble | Ohio | 39135 | 9459 | 197 |
2446343 | 2446343 | 2022-04-26 | Preble | Ohio | 39135 | 9459 | 197 |
2443088 | 2443088 | 2022-04-25 | Preble | Ohio | 39135 | 9459 | 197 |
2439832 | 2439832 | 2022-04-24 | Preble | Ohio | 39135 | 9459 | 197 |
2436576 | 2436576 | 2022-04-23 | Preble | Ohio | 39135 | 9459 | 197 |
2433320 | 2433320 | 2022-04-22 | Preble | Ohio | 39135 | 9459 | 197 |
2430064 | 2430064 | 2022-04-21 | Preble | Ohio | 39135 | 9459 | 197 |
2426808 | 2426808 | 2022-04-20 | Preble | Ohio | 39135 | 9455 | 197 |
2423552 | 2423552 | 2022-04-19 | Preble | Ohio | 39135 | 9455 | 197 |
2420295 | 2420295 | 2022-04-18 | Preble | Ohio | 39135 | 9455 | 197 |
2417040 | 2417040 | 2022-04-17 | Preble | Ohio | 39135 | 9455 | 197 |
2413784 | 2413784 | 2022-04-16 | Preble | Ohio | 39135 | 9455 | 197 |
2410528 | 2410528 | 2022-04-15 | Preble | Ohio | 39135 | 9455 | 197 |
2407272 | 2407272 | 2022-04-14 | Preble | Ohio | 39135 | 9455 | 197 |
2404016 | 2404016 | 2022-04-13 | Preble | Ohio | 39135 | 9453 | 197 |
2400761 | 2400761 | 2022-04-12 | Preble | Ohio | 39135 | 9453 | 197 |
2397506 | 2397506 | 2022-04-11 | Preble | Ohio | 39135 | 9453 | 197 |
2394251 | 2394251 | 2022-04-10 | Preble | Ohio | 39135 | 9453 | 197 |
2390995 | 2390995 | 2022-04-09 | Preble | Ohio | 39135 | 9453 | 197 |
2387739 | 2387739 | 2022-04-08 | Preble | Ohio | 39135 | 9453 | 197 |
2384484 | 2384484 | 2022-04-07 | Preble | Ohio | 39135 | 9453 | 197 |
2381229 | 2381229 | 2022-04-06 | Preble | Ohio | 39135 | 9449 | 196 |
2377974 | 2377974 | 2022-04-05 | Preble | Ohio | 39135 | 9449 | 196 |
2374720 | 2374720 | 2022-04-04 | Preble | Ohio | 39135 | 9449 | 196 |
2371468 | 2371468 | 2022-04-03 | Preble | Ohio | 39135 | 9449 | 196 |
2368215 | 2368215 | 2022-04-02 | Preble | Ohio | 39135 | 9449 | 196 |
2364962 | 2364962 | 2022-04-01 | Preble | Ohio | 39135 | 9449 | 196 |
2361709 | 2361709 | 2022-03-31 | Preble | Ohio | 39135 | 9449 | 196 |
2358455 | 2358455 | 2022-03-30 | Preble | Ohio | 39135 | 9445 | 195 |
2355201 | 2355201 | 2022-03-29 | Preble | Ohio | 39135 | 9445 | 195 |
2351948 | 2351948 | 2022-03-28 | Preble | Ohio | 39135 | 9445 | 195 |
2348696 | 2348696 | 2022-03-27 | Preble | Ohio | 39135 | 9445 | 195 |
2345443 | 2345443 | 2022-03-26 | Preble | Ohio | 39135 | 9445 | 195 |
2342190 | 2342190 | 2022-03-25 | Preble | Ohio | 39135 | 9445 | 195 |
2338937 | 2338937 | 2022-03-24 | Preble | Ohio | 39135 | 9445 | 195 |
2335683 | 2335683 | 2022-03-23 | Preble | Ohio | 39135 | 9437 | 194 |
2332429 | 2332429 | 2022-03-22 | Preble | Ohio | 39135 | 9437 | 194 |
2329176 | 2329176 | 2022-03-21 | Preble | Ohio | 39135 | 9437 | 194 |
2325924 | 2325924 | 2022-03-20 | Preble | Ohio | 39135 | 9437 | 194 |
2322671 | 2322671 | 2022-03-19 | Preble | Ohio | 39135 | 9437 | 194 |
2319417 | 2319417 | 2022-03-18 | Preble | Ohio | 39135 | 9437 | 194 |
2316163 | 2316163 | 2022-03-17 | Preble | Ohio | 39135 | 9437 | 194 |
2312910 | 2312910 | 2022-03-16 | Preble | Ohio | 39135 | 9435 | 195 |
2309657 | 2309657 | 2022-03-15 | Preble | Ohio | 39135 | 9435 | 195 |
2306404 | 2306404 | 2022-03-14 | Preble | Ohio | 39135 | 9435 | 195 |
2303153 | 2303153 | 2022-03-13 | Preble | Ohio | 39135 | 9435 | 195 |
2299901 | 2299901 | 2022-03-12 | Preble | Ohio | 39135 | 9434 | 195 |
2296649 | 2296649 | 2022-03-11 | Preble | Ohio | 39135 | 9434 | 195 |
2293397 | 2293397 | 2022-03-10 | Preble | Ohio | 39135 | 9434 | 193 |
2290145 | 2290145 | 2022-03-09 | Preble | Ohio | 39135 | 9427 | 193 |
2286893 | 2286893 | 2022-03-08 | Preble | Ohio | 39135 | 9423 | 193 |
2283641 | 2283641 | 2022-03-07 | Preble | Ohio | 39135 | 9421 | 192 |
2280389 | 2280389 | 2022-03-06 | Preble | Ohio | 39135 | 9420 | 192 |
2277136 | 2277136 | 2022-03-05 | Preble | Ohio | 39135 | 9419 | 192 |
2273883 | 2273883 | 2022-03-04 | Preble | Ohio | 39135 | 9416 | 192 |
2270630 | 2270630 | 2022-03-03 | Preble | Ohio | 39135 | 9408 | 191 |
2267378 | 2267378 | 2022-03-02 | Preble | Ohio | 39135 | 9398 | 191 |
2264125 | 2264125 | 2022-03-01 | Preble | Ohio | 39135 | 9395 | 191 |
2260875 | 2260875 | 2022-02-28 | Preble | Ohio | 39135 | 9391 | 189 |
2257624 | 2257624 | 2022-02-27 | Preble | Ohio | 39135 | 9388 | 189 |
2254373 | 2254373 | 2022-02-26 | Preble | Ohio | 39135 | 9386 | 189 |
2251122 | 2251122 | 2022-02-25 | Preble | Ohio | 39135 | 9380 | 189 |
2247871 | 2247871 | 2022-02-24 | Preble | Ohio | 39135 | 9374 | 189 |
2244620 | 2244620 | 2022-02-23 | Preble | Ohio | 39135 | 9363 | 189 |
2241369 | 2241369 | 2022-02-22 | Preble | Ohio | 39135 | 9348 | 189 |
2238118 | 2238118 | 2022-02-21 | Preble | Ohio | 39135 | 9345 | 183 |
2234867 | 2234867 | 2022-02-20 | Preble | Ohio | 39135 | 9343 | 183 |
2231616 | 2231616 | 2022-02-19 | Preble | Ohio | 39135 | 9341 | 183 |
2228365 | 2228365 | 2022-02-18 | Preble | Ohio | 39135 | 9331 | 183 |
2225114 | 2225114 | 2022-02-17 | Preble | Ohio | 39135 | 9323 | 183 |
2221863 | 2221863 | 2022-02-16 | Preble | Ohio | 39135 | 9314 | 183 |
2218612 | 2218612 | 2022-02-15 | Preble | Ohio | 39135 | 9305 | 183 |
2215361 | 2215361 | 2022-02-14 | Preble | Ohio | 39135 | 9299 | 182 |
2212110 | 2212110 | 2022-02-13 | Preble | Ohio | 39135 | 9291 | 182 |
2208857 | 2208857 | 2022-02-12 | Preble | Ohio | 39135 | 9287 | 182 |
2205604 | 2205604 | 2022-02-11 | Preble | Ohio | 39135 | 9287 | 182 |
2202351 | 2202351 | 2022-02-10 | Preble | Ohio | 39135 | 9263 | 179 |
2199097 | 2199097 | 2022-02-09 | Preble | Ohio | 39135 | 9223 | 179 |
2195843 | 2195843 | 2022-02-08 | Preble | Ohio | 39135 | 9183 | 179 |
2192589 | 2192589 | 2022-02-07 | Preble | Ohio | 39135 | 9148 | 179 |
2189335 | 2189335 | 2022-02-06 | Preble | Ohio | 39135 | 9136 | 179 |
2186082 | 2186082 | 2022-02-05 | Preble | Ohio | 39135 | 9123 | 179 |
2182830 | 2182830 | 2022-02-04 | Preble | Ohio | 39135 | 9095 | 179 |
2179578 | 2179578 | 2022-02-03 | Preble | Ohio | 39135 | 9041 | 178 |
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);