ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Defiance" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 618 ✖
- 4323 11
- 26 9
- 40 9
- 20 7
- 10184 7
- 10192 7
- 10201 7
- 10209 7
- 10214 7
- 10221 7
- 10229 7
- 10253 7
- 2 6
- 34 6
- 4325 6
- 5 5
- 32 5
- 12 4
- 21 4
- 33 4
- 43 4
- 10179 4
- 6 3
- 11 3
- 19 3
- 42 3
- 45 3
- 53 3
- 129 3
- 4296 3
- 4309 3
- 4317 3
- 7 2
- 10 2
- 13 2
- 15 2
- 17 2
- 30 2
- 48 2
- 50 2
- 51 2
- 54 2
- 133 2
- 184 2
- 188 2
- 233 2
- 382 2
- 1448 2
- 2547 2
- 2722 2
- 3898 2
- 4326 2
- 4361 2
- 4384 2
- 7117 2
- 7885 2
- 8041 2
- 10163 2
- 10175 2
- 10275 2
- 8 1
- 9 1
- 14 1
- 18 1
- 27 1
- 28 1
- 35 1
- 36 1
- 37 1
- 38 1
- 39 1
- 44 1
- 49 1
- 55 1
- 56 1
- 58 1
- 62 1
- 68 1
- 72 1
- 75 1
- 77 1
- 80 1
- 88 1
- 96 1
- 102 1
- 106 1
- 110 1
- 115 1
- 118 1
- 120 1
- 124 1
- 127 1
- 132 1
- 139 1
- 142 1
- 144 1
- 148 1
- 150 1
- 154 1
- 155 1
- 157 1
- 164 1
- 169 1
- 172 1
- 178 1
- 180 1
- 191 1
- 192 1
- 196 1
- 202 1
- 203 1
- 207 1
- 209 1
- 210 1
- 212 1
- 213 1
- 215 1
- 223 1
- 227 1
- 237 1
- 238 1
- 246 1
- 248 1
- 250 1
- 253 1
- 258 1
- 260 1
- 263 1
- 269 1
- 276 1
- 279 1
- 281 1
- 283 1
- 286 1
- 287 1
- 288 1
- 289 1
- 292 1
- 325 1
- 330 1
- 332 1
- 334 1
- 350 1
- 370 1
- 371 1
- 375 1
- 385 1
- 390 1
- 397 1
- 399 1
- 405 1
- 410 1
- 416 1
- 418 1
- 422 1
- 425 1
- 429 1
- 437 1
- 442 1
- 444 1
- 446 1
- 460 1
- 466 1
- 481 1
- 493 1
- 505 1
- 514 1
- 529 1
- 549 1
- 567 1
- 586 1
- 607 1
- 619 1
- 667 1
- 694 1
- 715 1
- 746 1
- 773 1
- 804 1
- 832 1
- 869 1
- 882 1
- 903 1
- 954 1
- 995 1
- 1035 1
- 1061 1
- 1092 1
- 1117 1
- 1153 1
- 1250 1
- 1302 1
- 1311 1
- 1379 1
- 1395 1
- 1499 1
- 1550 1
- 1583 1
- 1592 1
- 1626 1
- 1653 1
- 1677 1
- 1709 1
- 1792 1
- 1817 1
- 1865 1
- 1941 1
- 1963 1
- 2006 1
- 2069 1
- 2112 1
- 2147 1
- 2187 1
- 2230 1
- 2241 1
- 2307 1
- 2332 1
- 2380 1
- 2427 1
- 2474 1
- 2491 1
- 2514 1
- 2619 1
- 2636 1
- 2641 1
- 2659 1
- 2682 1
- 2781 1
- 2801 1
- 2821 1
- 2839 1
- 2860 1
- 2910 1
- 2941 1
- 2971 1
- 2982 1
- 3034 1
- 3066 1
- 3079 1
- 3114 1
- 3143 1
- 3170 1
- 3192 1
- 3201 1
- 3225 1
- 3239 1
- 3277 1
- 3282 1
- 3300 1
- 3322 1
- 3344 1
- 3361 1
- 3381 1
- 3425 1
- 3435 1
- 3446 1
- 3459 1
- 3466 1
- 3478 1
- 3488 1
- 3510 1
- 3518 1
- 3530 1
- 3534 1
- 3536 1
- 3555 1
- 3563 1
- 3569 1
- 3577 1
- 3593 1
- 3597 1
- 3602 1
- 3609 1
- 3616 1
- 3625 1
- 3640 1
- 3648 1
- 3654 1
- 3667 1
- 3670 1
- 3682 1
- 3688 1
- 3699 1
- 3706 1
- 3711 1
- 3714 1
- 3718 1
- 3725 1
- 3729 1
- 3735 1
- 3737 1
- 3740 1
- 3744 1
- 3754 1
- 3764 1
- 3769 1
- 3777 1
- 3779 1
- 3783 1
- 3792 1
- 3794 1
- 3798 1
- 3808 1
- 3815 1
- 3819 1
- 3822 1
- 3825 1
- 3829 1
- 3834 1
- 3843 1
- 3850 1
- 3856 1
- 3860 1
- 3866 1
- 3877 1
- 3883 1
- 3887 1
- 3891 1
- 3902 1
- 3911 1
- 3915 1
- 3925 1
- 3936 1
- 3950 1
- 3963 1
- 3967 1
- 3984 1
- 3994 1
- 3999 1
- 4008 1
- 4025 1
- 4030 1
- 4042 1
- 4048 1
- 4055 1
- 4066 1
- 4075 1
- 4081 1
- 4082 1
- 4090 1
- 4098 1
- 4117 1
- 4128 1
- 4136 1
- 4139 1
- 4146 1
- 4153 1
- 4165 1
- 4177 1
- 4189 1
- 4192 1
- 4196 1
- 4200 1
- 4204 1
- 4210 1
- 4230 1
- 4236 1
- 4239 1
- 4240 1
- 4242 1
- 4246 1
- 4253 1
- 4255 1
- 4261 1
- 4266 1
- 4272 1
- 4275 1
- 4278 1
- 4284 1
- 4287 1
- 4293 1
- 4295 1
- 4300 1
- 4302 1
- 4304 1
- 4307 1
- 4313 1
- 4314 1
- 4315 1
- 4316 1
- 4318 1
- 4321 1
- 4322 1
- 4327 1
- 4330 1
- 4332 1
- 4334 1
- 4339 1
- 4340 1
- 4343 1
- 4346 1
- 4352 1
- 4357 1
- 4358 1
- 4368 1
- 4373 1
- 4374 1
- 4380 1
- 4381 1
- 4387 1
- 4394 1
- 4402 1
- 4415 1
- 4419 1
- 4423 1
- 4427 1
- 4445 1
- 4452 1
- 4462 1
- 4469 1
- 4478 1
- 4482 1
- 4493 1
- 4502 1
- 4525 1
- 4544 1
- 4565 1
- 4576 1
- 4579 1
- 4587 1
- 4603 1
- 4628 1
- 4647 1
- 4662 1
- 4682 1
- 4689 1
- 4710 1
- 4728 1
- 4737 1
- 4761 1
- 4782 1
- 4795 1
- 4814 1
- 4824 1
- 4851 1
- 4885 1
- 4926 1
- 4961 1
- 4988 1
- 5011 1
- 5038 1
- 5047 1
- 5085 1
- 5124 1
- 5171 1
- 5188 1
- 5199 1
- 5209 1
- 5242 1
- 5278 1
- 5304 1
- 5337 1
- 5361 1
- 5387 1
- 5396 1
- 5445 1
- 5483 1
- 5511 1
- 5538 1
- 5564 1
- 5579 1
- 5587 1
- 5624 1
- 5658 1
- 5677 1
- 5717 1
- 5736 1
- 5751 1
- 5758 1
- 5787 1
- 5814 1
- 5828 1
- 5863 1
- 5877 1
- 5910 1
- 5918 1
- 5939 1
- 5983 1
- 6009 1
- 6043 1
- 6059 1
- 6067 1
- 6087 1
- 6123 1
- 6141 1
- 6162 1
- 6192 1
- 6218 1
- 6234 1
- 6241 1
- 6268 1
- 6295 1
- 6329 1
- 6356 1
- 6365 1
- 6379 1
- 6385 1
- 6410 1
- 6449 1
- 6489 1
- 6531 1
- 6546 1
- 6571 1
- 6590 1
- 6625 1
- 6670 1
- 6718 1
- 6748 1
- 6779 1
- 6803 1
- 6823 1
- 6855 1
- 6896 1
- 6938 1
- 6971 1
- 7006 1
- 7031 1
- 7044 1
- 7088 1
- 7162 1
- 7174 1
- 7186 1
- 7210 1
- 7243 1
- 7280 1
- 7331 1
- 7358 1
- 7404 1
- 7418 1
- 7431 1
- 7471 1
- 7502 1
- 7544 1
- 7566 1
- 7586 1
- 7608 1
- 7618 1
- 7653 1
- 7680 1
- 7707 1
- 7740 1
- 7762 1
- 7780 1
- 7794 1
- 7818 1
- 7836 1
- 7863 1
- 7910 1
- 7913 1
- 7935 1
- 7973 1
- 7993 1
- 8084 1
- 8121 1
- 8156 1
- 8229 1
- 8262 1
- 8324 1
- 8376 1
- 8414 1
- 8447 1
- 8493 1
- 8573 1
- 8623 1
- 8800 1
- 8917 1
- 8990 1
- 9057 1
- 9116 1
- 9209 1
- 9321 1
- 9406 1
- 9486 1
- 9533 1
- 9567 1
- 9583 1
- 9693 1
- 9750 1
- 9794 1
- 9846 1
- 9861 1
- 9872 1
- 9894 1
- 9937 1
- 9950 1
- 9964 1
- 9971 1
- 9979 1
- 9989 1
- 10004 1
- 10024 1
- 10048 1
- 10062 1
- 10072 1
- 10075 1
- 10077 1
- 10082 1
- 10096 1
- 10103 1
- 10109 1
- 10113 1
- 10116 1
- 10118 1
- 10125 1
- 10128 1
- 10131 1
- 10136 1
- 10140 1
- 10141 1
- 10144 1
- 10148 1
- 10152 1
- 10155 1
- 10160 1
- 10165 1
- 10171 1
- 10174 1
- 10178 1
state 1
- Ohio 784
fips 1
- 39039 784
county 1
- Defiance · 784 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501663 | 2501663 | 2022-05-13 | Defiance | Ohio | 39039 | 10275 | 165 |
2498405 | 2498405 | 2022-05-12 | Defiance | Ohio | 39039 | 10275 | 165 |
2495147 | 2495147 | 2022-05-11 | Defiance | Ohio | 39039 | 10253 | 164 |
2491889 | 2491889 | 2022-05-10 | Defiance | Ohio | 39039 | 10253 | 164 |
2488631 | 2488631 | 2022-05-09 | Defiance | Ohio | 39039 | 10253 | 164 |
2485374 | 2485374 | 2022-05-08 | Defiance | Ohio | 39039 | 10253 | 164 |
2482116 | 2482116 | 2022-05-07 | Defiance | Ohio | 39039 | 10253 | 164 |
2478858 | 2478858 | 2022-05-06 | Defiance | Ohio | 39039 | 10253 | 164 |
2475600 | 2475600 | 2022-05-05 | Defiance | Ohio | 39039 | 10253 | 164 |
2472343 | 2472343 | 2022-05-04 | Defiance | Ohio | 39039 | 10229 | 164 |
2469087 | 2469087 | 2022-05-03 | Defiance | Ohio | 39039 | 10229 | 164 |
2465831 | 2465831 | 2022-05-02 | Defiance | Ohio | 39039 | 10229 | 164 |
2462576 | 2462576 | 2022-05-01 | Defiance | Ohio | 39039 | 10229 | 164 |
2459320 | 2459320 | 2022-04-30 | Defiance | Ohio | 39039 | 10229 | 164 |
2456064 | 2456064 | 2022-04-29 | Defiance | Ohio | 39039 | 10229 | 164 |
2452808 | 2452808 | 2022-04-28 | Defiance | Ohio | 39039 | 10229 | 164 |
2449552 | 2449552 | 2022-04-27 | Defiance | Ohio | 39039 | 10221 | 164 |
2446295 | 2446295 | 2022-04-26 | Defiance | Ohio | 39039 | 10221 | 164 |
2443040 | 2443040 | 2022-04-25 | Defiance | Ohio | 39039 | 10221 | 164 |
2439784 | 2439784 | 2022-04-24 | Defiance | Ohio | 39039 | 10221 | 164 |
2436528 | 2436528 | 2022-04-23 | Defiance | Ohio | 39039 | 10221 | 164 |
2433272 | 2433272 | 2022-04-22 | Defiance | Ohio | 39039 | 10221 | 164 |
2430016 | 2430016 | 2022-04-21 | Defiance | Ohio | 39039 | 10221 | 164 |
2426760 | 2426760 | 2022-04-20 | Defiance | Ohio | 39039 | 10214 | 164 |
2423504 | 2423504 | 2022-04-19 | Defiance | Ohio | 39039 | 10214 | 164 |
2420247 | 2420247 | 2022-04-18 | Defiance | Ohio | 39039 | 10214 | 164 |
2416992 | 2416992 | 2022-04-17 | Defiance | Ohio | 39039 | 10214 | 164 |
2413736 | 2413736 | 2022-04-16 | Defiance | Ohio | 39039 | 10214 | 164 |
2410480 | 2410480 | 2022-04-15 | Defiance | Ohio | 39039 | 10214 | 164 |
2407224 | 2407224 | 2022-04-14 | Defiance | Ohio | 39039 | 10214 | 164 |
2403968 | 2403968 | 2022-04-13 | Defiance | Ohio | 39039 | 10209 | 164 |
2400713 | 2400713 | 2022-04-12 | Defiance | Ohio | 39039 | 10209 | 164 |
2397458 | 2397458 | 2022-04-11 | Defiance | Ohio | 39039 | 10209 | 164 |
2394203 | 2394203 | 2022-04-10 | Defiance | Ohio | 39039 | 10209 | 164 |
2390947 | 2390947 | 2022-04-09 | Defiance | Ohio | 39039 | 10209 | 164 |
2387691 | 2387691 | 2022-04-08 | Defiance | Ohio | 39039 | 10209 | 164 |
2384436 | 2384436 | 2022-04-07 | Defiance | Ohio | 39039 | 10209 | 164 |
2381181 | 2381181 | 2022-04-06 | Defiance | Ohio | 39039 | 10201 | 164 |
2377926 | 2377926 | 2022-04-05 | Defiance | Ohio | 39039 | 10201 | 164 |
2374672 | 2374672 | 2022-04-04 | Defiance | Ohio | 39039 | 10201 | 164 |
2371420 | 2371420 | 2022-04-03 | Defiance | Ohio | 39039 | 10201 | 164 |
2368167 | 2368167 | 2022-04-02 | Defiance | Ohio | 39039 | 10201 | 164 |
2364914 | 2364914 | 2022-04-01 | Defiance | Ohio | 39039 | 10201 | 164 |
2361661 | 2361661 | 2022-03-31 | Defiance | Ohio | 39039 | 10201 | 164 |
2358407 | 2358407 | 2022-03-30 | Defiance | Ohio | 39039 | 10192 | 163 |
2355153 | 2355153 | 2022-03-29 | Defiance | Ohio | 39039 | 10192 | 163 |
2351900 | 2351900 | 2022-03-28 | Defiance | Ohio | 39039 | 10192 | 163 |
2348648 | 2348648 | 2022-03-27 | Defiance | Ohio | 39039 | 10192 | 163 |
2345395 | 2345395 | 2022-03-26 | Defiance | Ohio | 39039 | 10192 | 163 |
2342142 | 2342142 | 2022-03-25 | Defiance | Ohio | 39039 | 10192 | 163 |
2338889 | 2338889 | 2022-03-24 | Defiance | Ohio | 39039 | 10192 | 163 |
2335635 | 2335635 | 2022-03-23 | Defiance | Ohio | 39039 | 10184 | 163 |
2332381 | 2332381 | 2022-03-22 | Defiance | Ohio | 39039 | 10184 | 163 |
2329128 | 2329128 | 2022-03-21 | Defiance | Ohio | 39039 | 10184 | 163 |
2325876 | 2325876 | 2022-03-20 | Defiance | Ohio | 39039 | 10184 | 163 |
2322623 | 2322623 | 2022-03-19 | Defiance | Ohio | 39039 | 10184 | 163 |
2319369 | 2319369 | 2022-03-18 | Defiance | Ohio | 39039 | 10184 | 163 |
2316115 | 2316115 | 2022-03-17 | Defiance | Ohio | 39039 | 10184 | 163 |
2312862 | 2312862 | 2022-03-16 | Defiance | Ohio | 39039 | 10179 | 162 |
2309609 | 2309609 | 2022-03-15 | Defiance | Ohio | 39039 | 10179 | 162 |
2306356 | 2306356 | 2022-03-14 | Defiance | Ohio | 39039 | 10179 | 162 |
2303105 | 2303105 | 2022-03-13 | Defiance | Ohio | 39039 | 10179 | 162 |
2299853 | 2299853 | 2022-03-12 | Defiance | Ohio | 39039 | 10178 | 162 |
2296601 | 2296601 | 2022-03-11 | Defiance | Ohio | 39039 | 10175 | 162 |
2293349 | 2293349 | 2022-03-10 | Defiance | Ohio | 39039 | 10175 | 162 |
2290097 | 2290097 | 2022-03-09 | Defiance | Ohio | 39039 | 10174 | 162 |
2286845 | 2286845 | 2022-03-08 | Defiance | Ohio | 39039 | 10171 | 162 |
2283593 | 2283593 | 2022-03-07 | Defiance | Ohio | 39039 | 10165 | 161 |
2280341 | 2280341 | 2022-03-06 | Defiance | Ohio | 39039 | 10163 | 161 |
2277088 | 2277088 | 2022-03-05 | Defiance | Ohio | 39039 | 10163 | 161 |
2273835 | 2273835 | 2022-03-04 | Defiance | Ohio | 39039 | 10160 | 161 |
2270582 | 2270582 | 2022-03-03 | Defiance | Ohio | 39039 | 10155 | 161 |
2267330 | 2267330 | 2022-03-02 | Defiance | Ohio | 39039 | 10152 | 161 |
2264077 | 2264077 | 2022-03-01 | Defiance | Ohio | 39039 | 10148 | 161 |
2260827 | 2260827 | 2022-02-28 | Defiance | Ohio | 39039 | 10144 | 156 |
2257576 | 2257576 | 2022-02-27 | Defiance | Ohio | 39039 | 10141 | 156 |
2254325 | 2254325 | 2022-02-26 | Defiance | Ohio | 39039 | 10140 | 156 |
2251074 | 2251074 | 2022-02-25 | Defiance | Ohio | 39039 | 10136 | 156 |
2247823 | 2247823 | 2022-02-24 | Defiance | Ohio | 39039 | 10131 | 156 |
2244572 | 2244572 | 2022-02-23 | Defiance | Ohio | 39039 | 10128 | 156 |
2241321 | 2241321 | 2022-02-22 | Defiance | Ohio | 39039 | 10125 | 156 |
2238070 | 2238070 | 2022-02-21 | Defiance | Ohio | 39039 | 10118 | 153 |
2234819 | 2234819 | 2022-02-20 | Defiance | Ohio | 39039 | 10116 | 153 |
2231568 | 2231568 | 2022-02-19 | Defiance | Ohio | 39039 | 10113 | 153 |
2228317 | 2228317 | 2022-02-18 | Defiance | Ohio | 39039 | 10109 | 153 |
2225066 | 2225066 | 2022-02-17 | Defiance | Ohio | 39039 | 10103 | 153 |
2221815 | 2221815 | 2022-02-16 | Defiance | Ohio | 39039 | 10096 | 153 |
2218564 | 2218564 | 2022-02-15 | Defiance | Ohio | 39039 | 10082 | 153 |
2215313 | 2215313 | 2022-02-14 | Defiance | Ohio | 39039 | 10077 | 152 |
2212062 | 2212062 | 2022-02-13 | Defiance | Ohio | 39039 | 10075 | 152 |
2208809 | 2208809 | 2022-02-12 | Defiance | Ohio | 39039 | 10072 | 152 |
2205556 | 2205556 | 2022-02-11 | Defiance | Ohio | 39039 | 10062 | 152 |
2202303 | 2202303 | 2022-02-10 | Defiance | Ohio | 39039 | 10048 | 152 |
2199049 | 2199049 | 2022-02-09 | Defiance | Ohio | 39039 | 10024 | 152 |
2195795 | 2195795 | 2022-02-08 | Defiance | Ohio | 39039 | 10004 | 152 |
2192541 | 2192541 | 2022-02-07 | Defiance | Ohio | 39039 | 9989 | 147 |
2189287 | 2189287 | 2022-02-06 | Defiance | Ohio | 39039 | 9979 | 147 |
2186034 | 2186034 | 2022-02-05 | Defiance | Ohio | 39039 | 9971 | 147 |
2182782 | 2182782 | 2022-02-04 | Defiance | Ohio | 39039 | 9964 | 147 |
2179530 | 2179530 | 2022-02-03 | Defiance | Ohio | 39039 | 9950 | 146 |
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);