ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 188 ✖
- 12 23
- 8 17
- 737 16
- 6 14
- 44 14
- 730 14
- 732 14
- 45 12
- 60 12
- 390 12
- 396 11
- 0 10
- 56 10
- 66 10
- 391 9
- 57 8
- 62 8
- 7 7
- 126 7
- 354 7
- 362 7
- 366 7
- 368 7
- 369 7
- 384 7
- 397 7
- 399 7
- 401 7
- 404 7
- 405 7
- 422 7
- 432 7
- 694 7
- 734 7
- 736 7
- 17 6
- 23 6
- 43 6
- 49 6
- 59 6
- 120 6
- 725 6
- 3 5
- 38 5
- 51 5
- 98 5
- 113 5
- 294 5
- 381 5
- 1 4
- 11 4
- 14 4
- 18 4
- 22 4
- 81 4
- 135 4
- 154 4
- 163 4
- 332 4
- 338 4
- 349 4
- 355 4
- 360 4
- 371 4
- 373 4
- 385 4
- 388 4
- 394 4
- 408 4
- 416 4
- 424 4
- 434 4
- 448 4
- 454 4
- 461 4
- 470 4
- 482 4
- 493 4
- 501 4
- 516 4
- 531 4
- 545 4
- 556 4
- 565 4
- 586 4
- 611 4
- 646 4
- 666 4
- 690 4
- 715 4
- 719 4
- 9 3
- 13 3
- 27 3
- 46 3
- 61 3
- 67 3
- 97 3
- 300 3
- 305 3
- 318 3
- 335 3
- 342 3
- 353 3
- 357 3
- 365 3
- 372 3
- 374 3
- 387 3
- 389 3
- 395 3
- 398 3
- 411 3
- 417 3
- 428 3
- 443 3
- 451 3
- 457 3
- 468 3
- 474 3
- 486 3
- 495 3
- 506 3
- 519 3
- 533 3
- 547 3
- 557 3
- 579 3
- 605 3
- 636 3
- 661 3
- 687 3
- 709 3
- 717 3
- 723 3
- 2 2
- 4 2
- 16 2
- 24 2
- 25 2
- 34 2
- 36 2
- 50 2
- 53 2
- 94 2
- 123 2
- 136 2
- 161 2
- 169 2
- 171 2
- 178 2
- 183 2
- 383 2
- 5 1
- 15 1
- 19 1
- 20 1
- 26 1
- 28 1
- 29 1
- 31 1
- 33 1
- 35 1
- 37 1
- 41 1
- 42 1
- 54 1
- 77 1
- 80 1
- 84 1
- 85 1
- 87 1
- 90 1
- 95 1
- 107 1
- 121 1
- 134 1
- 153 1
- 162 1
- 177 1
- 204 1
- 265 1
- 291 1
- 293 1
- 295 1
- 299 1
- 301 1
- 304 1
state 1
- Ohio 788
fips 1
- 39085 · 788 ✖
county 1
- Lake 788
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501686 | 2501686 | 2022-05-13 | Lake | Ohio | 39085 | 49961 | 737 |
2498428 | 2498428 | 2022-05-12 | Lake | Ohio | 39085 | 49961 | 737 |
2495170 | 2495170 | 2022-05-11 | Lake | Ohio | 39085 | 49672 | 737 |
2491912 | 2491912 | 2022-05-10 | Lake | Ohio | 39085 | 49672 | 737 |
2488654 | 2488654 | 2022-05-09 | Lake | Ohio | 39085 | 49672 | 737 |
2485397 | 2485397 | 2022-05-08 | Lake | Ohio | 39085 | 49672 | 737 |
2482139 | 2482139 | 2022-05-07 | Lake | Ohio | 39085 | 49672 | 737 |
2478881 | 2478881 | 2022-05-06 | Lake | Ohio | 39085 | 49672 | 737 |
2475623 | 2475623 | 2022-05-05 | Lake | Ohio | 39085 | 49672 | 737 |
2472366 | 2472366 | 2022-05-04 | Lake | Ohio | 39085 | 49421 | 737 |
2469110 | 2469110 | 2022-05-03 | Lake | Ohio | 39085 | 49421 | 737 |
2465854 | 2465854 | 2022-05-02 | Lake | Ohio | 39085 | 49421 | 737 |
2462599 | 2462599 | 2022-05-01 | Lake | Ohio | 39085 | 49421 | 737 |
2459343 | 2459343 | 2022-04-30 | Lake | Ohio | 39085 | 49421 | 737 |
2456087 | 2456087 | 2022-04-29 | Lake | Ohio | 39085 | 49421 | 737 |
2452831 | 2452831 | 2022-04-28 | Lake | Ohio | 39085 | 49421 | 737 |
2449575 | 2449575 | 2022-04-27 | Lake | Ohio | 39085 | 49198 | 736 |
2446318 | 2446318 | 2022-04-26 | Lake | Ohio | 39085 | 49198 | 736 |
2443063 | 2443063 | 2022-04-25 | Lake | Ohio | 39085 | 49198 | 736 |
2439807 | 2439807 | 2022-04-24 | Lake | Ohio | 39085 | 49198 | 736 |
2436551 | 2436551 | 2022-04-23 | Lake | Ohio | 39085 | 49198 | 736 |
2433295 | 2433295 | 2022-04-22 | Lake | Ohio | 39085 | 49198 | 736 |
2430039 | 2430039 | 2022-04-21 | Lake | Ohio | 39085 | 49198 | 736 |
2426783 | 2426783 | 2022-04-20 | Lake | Ohio | 39085 | 49028 | 734 |
2423527 | 2423527 | 2022-04-19 | Lake | Ohio | 39085 | 49028 | 734 |
2420270 | 2420270 | 2022-04-18 | Lake | Ohio | 39085 | 49028 | 734 |
2417015 | 2417015 | 2022-04-17 | Lake | Ohio | 39085 | 49028 | 734 |
2413759 | 2413759 | 2022-04-16 | Lake | Ohio | 39085 | 49028 | 734 |
2410503 | 2410503 | 2022-04-15 | Lake | Ohio | 39085 | 49028 | 734 |
2407247 | 2407247 | 2022-04-14 | Lake | Ohio | 39085 | 49028 | 734 |
2403991 | 2403991 | 2022-04-13 | Lake | Ohio | 39085 | 48894 | 732 |
2400736 | 2400736 | 2022-04-12 | Lake | Ohio | 39085 | 48894 | 732 |
2397481 | 2397481 | 2022-04-11 | Lake | Ohio | 39085 | 48894 | 732 |
2394226 | 2394226 | 2022-04-10 | Lake | Ohio | 39085 | 48894 | 732 |
2390970 | 2390970 | 2022-04-09 | Lake | Ohio | 39085 | 48894 | 732 |
2387714 | 2387714 | 2022-04-08 | Lake | Ohio | 39085 | 48894 | 732 |
2384459 | 2384459 | 2022-04-07 | Lake | Ohio | 39085 | 48894 | 732 |
2381204 | 2381204 | 2022-04-06 | Lake | Ohio | 39085 | 48829 | 732 |
2377949 | 2377949 | 2022-04-05 | Lake | Ohio | 39085 | 48829 | 732 |
2374695 | 2374695 | 2022-04-04 | Lake | Ohio | 39085 | 48829 | 732 |
2371443 | 2371443 | 2022-04-03 | Lake | Ohio | 39085 | 48829 | 732 |
2368190 | 2368190 | 2022-04-02 | Lake | Ohio | 39085 | 48829 | 732 |
2364937 | 2364937 | 2022-04-01 | Lake | Ohio | 39085 | 48829 | 732 |
2361684 | 2361684 | 2022-03-31 | Lake | Ohio | 39085 | 48829 | 732 |
2358430 | 2358430 | 2022-03-30 | Lake | Ohio | 39085 | 48779 | 730 |
2355176 | 2355176 | 2022-03-29 | Lake | Ohio | 39085 | 48779 | 730 |
2351923 | 2351923 | 2022-03-28 | Lake | Ohio | 39085 | 48779 | 730 |
2348671 | 2348671 | 2022-03-27 | Lake | Ohio | 39085 | 48779 | 730 |
2345418 | 2345418 | 2022-03-26 | Lake | Ohio | 39085 | 48779 | 730 |
2342165 | 2342165 | 2022-03-25 | Lake | Ohio | 39085 | 48779 | 730 |
2338912 | 2338912 | 2022-03-24 | Lake | Ohio | 39085 | 48779 | 730 |
2335658 | 2335658 | 2022-03-23 | Lake | Ohio | 39085 | 48723 | 730 |
2332404 | 2332404 | 2022-03-22 | Lake | Ohio | 39085 | 48723 | 730 |
2329151 | 2329151 | 2022-03-21 | Lake | Ohio | 39085 | 48723 | 730 |
2325899 | 2325899 | 2022-03-20 | Lake | Ohio | 39085 | 48723 | 730 |
2322646 | 2322646 | 2022-03-19 | Lake | Ohio | 39085 | 48723 | 730 |
2319392 | 2319392 | 2022-03-18 | Lake | Ohio | 39085 | 48723 | 730 |
2316138 | 2316138 | 2022-03-17 | Lake | Ohio | 39085 | 48723 | 730 |
2312885 | 2312885 | 2022-03-16 | Lake | Ohio | 39085 | 48680 | 725 |
2309632 | 2309632 | 2022-03-15 | Lake | Ohio | 39085 | 48680 | 725 |
2306379 | 2306379 | 2022-03-14 | Lake | Ohio | 39085 | 48680 | 725 |
2303128 | 2303128 | 2022-03-13 | Lake | Ohio | 39085 | 48680 | 725 |
2299876 | 2299876 | 2022-03-12 | Lake | Ohio | 39085 | 48677 | 725 |
2296624 | 2296624 | 2022-03-11 | Lake | Ohio | 39085 | 48669 | 725 |
2293372 | 2293372 | 2022-03-10 | Lake | Ohio | 39085 | 48667 | 723 |
2290120 | 2290120 | 2022-03-09 | Lake | Ohio | 39085 | 48656 | 723 |
2286868 | 2286868 | 2022-03-08 | Lake | Ohio | 39085 | 48646 | 723 |
2283616 | 2283616 | 2022-03-07 | Lake | Ohio | 39085 | 48632 | 719 |
2280364 | 2280364 | 2022-03-06 | Lake | Ohio | 39085 | 48629 | 719 |
2277111 | 2277111 | 2022-03-05 | Lake | Ohio | 39085 | 48625 | 719 |
2273858 | 2273858 | 2022-03-04 | Lake | Ohio | 39085 | 48614 | 719 |
2270605 | 2270605 | 2022-03-03 | Lake | Ohio | 39085 | 48600 | 717 |
2267353 | 2267353 | 2022-03-02 | Lake | Ohio | 39085 | 48588 | 717 |
2264100 | 2264100 | 2022-03-01 | Lake | Ohio | 39085 | 48573 | 717 |
2260850 | 2260850 | 2022-02-28 | Lake | Ohio | 39085 | 48565 | 715 |
2257599 | 2257599 | 2022-02-27 | Lake | Ohio | 39085 | 48554 | 715 |
2254348 | 2254348 | 2022-02-26 | Lake | Ohio | 39085 | 48550 | 715 |
2251097 | 2251097 | 2022-02-25 | Lake | Ohio | 39085 | 48531 | 715 |
2247846 | 2247846 | 2022-02-24 | Lake | Ohio | 39085 | 48513 | 709 |
2244595 | 2244595 | 2022-02-23 | Lake | Ohio | 39085 | 48497 | 709 |
2241344 | 2241344 | 2022-02-22 | Lake | Ohio | 39085 | 48479 | 709 |
2238093 | 2238093 | 2022-02-21 | Lake | Ohio | 39085 | 48466 | 694 |
2234842 | 2234842 | 2022-02-20 | Lake | Ohio | 39085 | 48459 | 694 |
2231591 | 2231591 | 2022-02-19 | Lake | Ohio | 39085 | 48454 | 694 |
2228340 | 2228340 | 2022-02-18 | Lake | Ohio | 39085 | 48426 | 694 |
2225089 | 2225089 | 2022-02-17 | Lake | Ohio | 39085 | 48408 | 694 |
2221838 | 2221838 | 2022-02-16 | Lake | Ohio | 39085 | 48391 | 694 |
2218587 | 2218587 | 2022-02-15 | Lake | Ohio | 39085 | 48373 | 694 |
2215336 | 2215336 | 2022-02-14 | Lake | Ohio | 39085 | 48361 | 690 |
2212085 | 2212085 | 2022-02-13 | Lake | Ohio | 39085 | 48343 | 690 |
2208832 | 2208832 | 2022-02-12 | Lake | Ohio | 39085 | 48322 | 690 |
2205579 | 2205579 | 2022-02-11 | Lake | Ohio | 39085 | 48296 | 690 |
2202326 | 2202326 | 2022-02-10 | Lake | Ohio | 39085 | 48267 | 687 |
2199072 | 2199072 | 2022-02-09 | Lake | Ohio | 39085 | 48235 | 687 |
2195818 | 2195818 | 2022-02-08 | Lake | Ohio | 39085 | 48205 | 687 |
2192564 | 2192564 | 2022-02-07 | Lake | Ohio | 39085 | 48178 | 666 |
2189310 | 2189310 | 2022-02-06 | Lake | Ohio | 39085 | 48162 | 666 |
2186057 | 2186057 | 2022-02-05 | Lake | Ohio | 39085 | 48148 | 666 |
2182805 | 2182805 | 2022-02-04 | Lake | Ohio | 39085 | 48122 | 666 |
2179553 | 2179553 | 2022-02-03 | Lake | Ohio | 39085 | 48091 | 661 |
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);