ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Geauga" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636971 | 636971 | 2020-10-16 | Geauga | Ohio | 39055 | 804 | 50 |
633725 | 633725 | 2020-10-15 | Geauga | Ohio | 39055 | 790 | 50 |
630480 | 630480 | 2020-10-14 | Geauga | Ohio | 39055 | 781 | 50 |
627236 | 627236 | 2020-10-13 | Geauga | Ohio | 39055 | 773 | 50 |
623994 | 623994 | 2020-10-12 | Geauga | Ohio | 39055 | 770 | 50 |
620751 | 620751 | 2020-10-11 | Geauga | Ohio | 39055 | 767 | 50 |
617509 | 617509 | 2020-10-10 | Geauga | Ohio | 39055 | 758 | 50 |
614267 | 614267 | 2020-10-09 | Geauga | Ohio | 39055 | 755 | 50 |
611026 | 611026 | 2020-10-08 | Geauga | Ohio | 39055 | 755 | 49 |
607784 | 607784 | 2020-10-07 | Geauga | Ohio | 39055 | 753 | 49 |
604541 | 604541 | 2020-10-06 | Geauga | Ohio | 39055 | 752 | 49 |
601299 | 601299 | 2020-10-05 | Geauga | Ohio | 39055 | 750 | 49 |
598056 | 598056 | 2020-10-04 | Geauga | Ohio | 39055 | 750 | 49 |
594813 | 594813 | 2020-10-03 | Geauga | Ohio | 39055 | 749 | 49 |
591572 | 591572 | 2020-10-02 | Geauga | Ohio | 39055 | 746 | 49 |
588331 | 588331 | 2020-10-01 | Geauga | Ohio | 39055 | 739 | 49 |
585091 | 585091 | 2020-09-30 | Geauga | Ohio | 39055 | 735 | 49 |
581851 | 581851 | 2020-09-29 | Geauga | Ohio | 39055 | 733 | 49 |
578611 | 578611 | 2020-09-28 | Geauga | Ohio | 39055 | 726 | 49 |
575370 | 575370 | 2020-09-27 | Geauga | Ohio | 39055 | 723 | 49 |
572126 | 572126 | 2020-09-26 | Geauga | Ohio | 39055 | 720 | 49 |
568884 | 568884 | 2020-09-25 | Geauga | Ohio | 39055 | 713 | 49 |
565643 | 565643 | 2020-09-24 | Geauga | Ohio | 39055 | 713 | 48 |
562402 | 562402 | 2020-09-23 | Geauga | Ohio | 39055 | 709 | 48 |
559165 | 559165 | 2020-09-22 | Geauga | Ohio | 39055 | 705 | 47 |
555928 | 555928 | 2020-09-21 | Geauga | Ohio | 39055 | 705 | 47 |
552691 | 552691 | 2020-09-20 | Geauga | Ohio | 39055 | 703 | 47 |
549452 | 549452 | 2020-09-19 | Geauga | Ohio | 39055 | 701 | 47 |
546213 | 546213 | 2020-09-18 | Geauga | Ohio | 39055 | 701 | 47 |
542976 | 542976 | 2020-09-17 | Geauga | Ohio | 39055 | 697 | 47 |
539740 | 539740 | 2020-09-16 | Geauga | Ohio | 39055 | 696 | 47 |
536503 | 536503 | 2020-09-15 | Geauga | Ohio | 39055 | 691 | 47 |
533267 | 533267 | 2020-09-14 | Geauga | Ohio | 39055 | 687 | 46 |
530032 | 530032 | 2020-09-13 | Geauga | Ohio | 39055 | 689 | 46 |
526795 | 526795 | 2020-09-12 | Geauga | Ohio | 39055 | 680 | 46 |
523559 | 523559 | 2020-09-11 | Geauga | Ohio | 39055 | 674 | 46 |
520323 | 520323 | 2020-09-10 | Geauga | Ohio | 39055 | 671 | 46 |
517087 | 517087 | 2020-09-09 | Geauga | Ohio | 39055 | 667 | 46 |
513852 | 513852 | 2020-09-08 | Geauga | Ohio | 39055 | 663 | 46 |
510619 | 510619 | 2020-09-07 | Geauga | Ohio | 39055 | 663 | 46 |
507386 | 507386 | 2020-09-06 | Geauga | Ohio | 39055 | 658 | 46 |
504154 | 504154 | 2020-09-05 | Geauga | Ohio | 39055 | 660 | 46 |
500920 | 500920 | 2020-09-04 | Geauga | Ohio | 39055 | 642 | 46 |
497686 | 497686 | 2020-09-03 | Geauga | Ohio | 39055 | 634 | 46 |
494453 | 494453 | 2020-09-02 | Geauga | Ohio | 39055 | 627 | 46 |
491219 | 491219 | 2020-09-01 | Geauga | Ohio | 39055 | 623 | 46 |
487986 | 487986 | 2020-08-31 | Geauga | Ohio | 39055 | 616 | 46 |
484753 | 484753 | 2020-08-30 | Geauga | Ohio | 39055 | 608 | 46 |
481518 | 481518 | 2020-08-29 | Geauga | Ohio | 39055 | 611 | 46 |
478284 | 478284 | 2020-08-28 | Geauga | Ohio | 39055 | 608 | 46 |
475051 | 475051 | 2020-08-27 | Geauga | Ohio | 39055 | 605 | 46 |
471817 | 471817 | 2020-08-26 | Geauga | Ohio | 39055 | 598 | 46 |
468585 | 468585 | 2020-08-25 | Geauga | Ohio | 39055 | 595 | 46 |
465357 | 465357 | 2020-08-24 | Geauga | Ohio | 39055 | 595 | 46 |
462128 | 462128 | 2020-08-23 | Geauga | Ohio | 39055 | 594 | 46 |
458900 | 458900 | 2020-08-22 | Geauga | Ohio | 39055 | 592 | 46 |
455672 | 455672 | 2020-08-21 | Geauga | Ohio | 39055 | 588 | 46 |
452444 | 452444 | 2020-08-20 | Geauga | Ohio | 39055 | 586 | 46 |
449216 | 449216 | 2020-08-19 | Geauga | Ohio | 39055 | 583 | 46 |
445988 | 445988 | 2020-08-18 | Geauga | Ohio | 39055 | 579 | 46 |
442762 | 442762 | 2020-08-17 | Geauga | Ohio | 39055 | 574 | 46 |
439535 | 439535 | 2020-08-16 | Geauga | Ohio | 39055 | 570 | 45 |
436310 | 436310 | 2020-08-15 | Geauga | Ohio | 39055 | 565 | 45 |
433084 | 433084 | 2020-08-14 | Geauga | Ohio | 39055 | 564 | 45 |
429858 | 429858 | 2020-08-13 | Geauga | Ohio | 39055 | 565 | 45 |
426633 | 426633 | 2020-08-12 | Geauga | Ohio | 39055 | 561 | 44 |
423410 | 423410 | 2020-08-11 | Geauga | Ohio | 39055 | 559 | 44 |
420187 | 420187 | 2020-08-10 | Geauga | Ohio | 39055 | 558 | 44 |
416967 | 416967 | 2020-08-09 | Geauga | Ohio | 39055 | 556 | 44 |
413746 | 413746 | 2020-08-08 | Geauga | Ohio | 39055 | 554 | 44 |
410526 | 410526 | 2020-08-07 | Geauga | Ohio | 39055 | 552 | 44 |
407306 | 407306 | 2020-08-06 | Geauga | Ohio | 39055 | 548 | 44 |
404087 | 404087 | 2020-08-05 | Geauga | Ohio | 39055 | 540 | 44 |
400869 | 400869 | 2020-08-04 | Geauga | Ohio | 39055 | 535 | 44 |
397654 | 397654 | 2020-08-03 | Geauga | Ohio | 39055 | 531 | 43 |
394437 | 394437 | 2020-08-02 | Geauga | Ohio | 39055 | 528 | 43 |
391221 | 391221 | 2020-08-01 | Geauga | Ohio | 39055 | 522 | 43 |
388004 | 388004 | 2020-07-31 | Geauga | Ohio | 39055 | 519 | 43 |
384787 | 384787 | 2020-07-30 | Geauga | Ohio | 39055 | 515 | 43 |
381569 | 381569 | 2020-07-29 | Geauga | Ohio | 39055 | 513 | 43 |
378352 | 378352 | 2020-07-28 | Geauga | Ohio | 39055 | 509 | 43 |
375135 | 375135 | 2020-07-27 | Geauga | Ohio | 39055 | 506 | 43 |
371923 | 371923 | 2020-07-26 | Geauga | Ohio | 39055 | 502 | 43 |
368711 | 368711 | 2020-07-25 | Geauga | Ohio | 39055 | 498 | 43 |
365502 | 365502 | 2020-07-24 | Geauga | Ohio | 39055 | 493 | 43 |
362296 | 362296 | 2020-07-23 | Geauga | Ohio | 39055 | 482 | 43 |
359090 | 359090 | 2020-07-22 | Geauga | Ohio | 39055 | 474 | 43 |
355886 | 355886 | 2020-07-21 | Geauga | Ohio | 39055 | 468 | 43 |
352683 | 352683 | 2020-07-20 | Geauga | Ohio | 39055 | 466 | 43 |
349480 | 349480 | 2020-07-19 | Geauga | Ohio | 39055 | 465 | 43 |
346279 | 346279 | 2020-07-18 | Geauga | Ohio | 39055 | 458 | 42 |
343080 | 343080 | 2020-07-17 | Geauga | Ohio | 39055 | 453 | 42 |
339882 | 339882 | 2020-07-16 | Geauga | Ohio | 39055 | 448 | 42 |
336686 | 336686 | 2020-07-15 | Geauga | Ohio | 39055 | 447 | 42 |
333492 | 333492 | 2020-07-14 | Geauga | Ohio | 39055 | 436 | 43 |
330300 | 330300 | 2020-07-13 | Geauga | Ohio | 39055 | 431 | 43 |
327113 | 327113 | 2020-07-12 | Geauga | Ohio | 39055 | 428 | 43 |
323928 | 323928 | 2020-07-11 | Geauga | Ohio | 39055 | 425 | 43 |
320748 | 320748 | 2020-07-10 | Geauga | Ohio | 39055 | 425 | 43 |
317571 | 317571 | 2020-07-09 | Geauga | Ohio | 39055 | 415 | 43 |
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);