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 |
---|---|---|---|---|---|---|---|
922524 | 922524 | 2021-01-12 | Geauga | Ohio | 39055 | 4609 | 55 |
919279 | 919279 | 2021-01-11 | Geauga | Ohio | 39055 | 4559 | 55 |
916034 | 916034 | 2021-01-10 | Geauga | Ohio | 39055 | 4522 | 54 |
912789 | 912789 | 2021-01-09 | Geauga | Ohio | 39055 | 4465 | 54 |
909544 | 909544 | 2021-01-08 | Geauga | Ohio | 39055 | 4423 | 54 |
906299 | 906299 | 2021-01-07 | Geauga | Ohio | 39055 | 4356 | 54 |
903053 | 903053 | 2021-01-06 | Geauga | Ohio | 39055 | 4291 | 54 |
899808 | 899808 | 2021-01-05 | Geauga | Ohio | 39055 | 4242 | 53 |
896563 | 896563 | 2021-01-04 | Geauga | Ohio | 39055 | 4202 | 53 |
893317 | 893317 | 2021-01-03 | Geauga | Ohio | 39055 | 4156 | 53 |
890071 | 890071 | 2021-01-02 | Geauga | Ohio | 39055 | 4113 | 53 |
886824 | 886824 | 2021-01-01 | Geauga | Ohio | 39055 | 4022 | 53 |
883579 | 883579 | 2020-12-31 | Geauga | Ohio | 39055 | 4022 | 53 |
880334 | 880334 | 2020-12-30 | Geauga | Ohio | 39055 | 3964 | 53 |
877089 | 877089 | 2020-12-29 | Geauga | Ohio | 39055 | 3928 | 51 |
873844 | 873844 | 2020-12-28 | Geauga | Ohio | 39055 | 3882 | 51 |
870599 | 870599 | 2020-12-27 | Geauga | Ohio | 39055 | 3856 | 51 |
867354 | 867354 | 2020-12-26 | Geauga | Ohio | 39055 | 3819 | 51 |
864109 | 864109 | 2020-12-25 | Geauga | Ohio | 39055 | 3760 | 51 |
860864 | 860864 | 2020-12-24 | Geauga | Ohio | 39055 | 3760 | 51 |
857619 | 857619 | 2020-12-23 | Geauga | Ohio | 39055 | 3704 | 51 |
854374 | 854374 | 2020-12-22 | Geauga | Ohio | 39055 | 3666 | 51 |
851129 | 851129 | 2020-12-21 | Geauga | Ohio | 39055 | 3625 | 51 |
847884 | 847884 | 2020-12-20 | Geauga | Ohio | 39055 | 3599 | 51 |
844639 | 844639 | 2020-12-19 | Geauga | Ohio | 39055 | 3539 | 51 |
841393 | 841393 | 2020-12-18 | Geauga | Ohio | 39055 | 3494 | 51 |
838148 | 838148 | 2020-12-17 | Geauga | Ohio | 39055 | 3446 | 51 |
834902 | 834902 | 2020-12-16 | Geauga | Ohio | 39055 | 3389 | 51 |
831656 | 831656 | 2020-12-15 | Geauga | Ohio | 39055 | 3372 | 51 |
828409 | 828409 | 2020-12-14 | Geauga | Ohio | 39055 | 3325 | 51 |
825163 | 825163 | 2020-12-13 | Geauga | Ohio | 39055 | 3275 | 51 |
821916 | 821916 | 2020-12-12 | Geauga | Ohio | 39055 | 3223 | 51 |
818670 | 818670 | 2020-12-11 | Geauga | Ohio | 39055 | 3152 | 51 |
815424 | 815424 | 2020-12-10 | Geauga | Ohio | 39055 | 3090 | 51 |
812178 | 812178 | 2020-12-09 | Geauga | Ohio | 39055 | 3049 | 51 |
808934 | 808934 | 2020-12-08 | Geauga | Ohio | 39055 | 2966 | 51 |
805689 | 805689 | 2020-12-07 | Geauga | Ohio | 39055 | 2803 | 51 |
802444 | 802444 | 2020-12-06 | Geauga | Ohio | 39055 | 2727 | 51 |
799199 | 799199 | 2020-12-05 | Geauga | Ohio | 39055 | 2678 | 51 |
795954 | 795954 | 2020-12-04 | Geauga | Ohio | 39055 | 2631 | 51 |
792709 | 792709 | 2020-12-03 | Geauga | Ohio | 39055 | 2572 | 51 |
789464 | 789464 | 2020-12-02 | Geauga | Ohio | 39055 | 2556 | 51 |
786219 | 786219 | 2020-12-01 | Geauga | Ohio | 39055 | 2511 | 51 |
782975 | 782975 | 2020-11-30 | Geauga | Ohio | 39055 | 2430 | 51 |
779729 | 779729 | 2020-11-29 | Geauga | Ohio | 39055 | 2385 | 51 |
776484 | 776484 | 2020-11-28 | Geauga | Ohio | 39055 | 2318 | 51 |
773239 | 773239 | 2020-11-27 | Geauga | Ohio | 39055 | 2270 | 51 |
769994 | 769994 | 2020-11-26 | Geauga | Ohio | 39055 | 2118 | 51 |
766748 | 766748 | 2020-11-25 | Geauga | Ohio | 39055 | 2118 | 51 |
763503 | 763503 | 2020-11-24 | Geauga | Ohio | 39055 | 2033 | 51 |
760258 | 760258 | 2020-11-23 | Geauga | Ohio | 39055 | 1973 | 51 |
757013 | 757013 | 2020-11-22 | Geauga | Ohio | 39055 | 1894 | 51 |
753766 | 753766 | 2020-11-21 | Geauga | Ohio | 39055 | 1814 | 51 |
750520 | 750520 | 2020-11-20 | Geauga | Ohio | 39055 | 1776 | 51 |
747274 | 747274 | 2020-11-19 | Geauga | Ohio | 39055 | 1707 | 51 |
744028 | 744028 | 2020-11-18 | Geauga | Ohio | 39055 | 1646 | 51 |
740781 | 740781 | 2020-11-17 | Geauga | Ohio | 39055 | 1613 | 51 |
737535 | 737535 | 2020-11-16 | Geauga | Ohio | 39055 | 1564 | 51 |
734291 | 734291 | 2020-11-15 | Geauga | Ohio | 39055 | 1497 | 51 |
731045 | 731045 | 2020-11-14 | Geauga | Ohio | 39055 | 1454 | 51 |
727801 | 727801 | 2020-11-13 | Geauga | Ohio | 39055 | 1411 | 51 |
724557 | 724557 | 2020-11-12 | Geauga | Ohio | 39055 | 1352 | 51 |
721314 | 721314 | 2020-11-11 | Geauga | Ohio | 39055 | 1294 | 51 |
718071 | 718071 | 2020-11-10 | Geauga | Ohio | 39055 | 1237 | 51 |
714828 | 714828 | 2020-11-09 | Geauga | Ohio | 39055 | 1203 | 51 |
711584 | 711584 | 2020-11-08 | Geauga | Ohio | 39055 | 1154 | 51 |
708340 | 708340 | 2020-11-07 | Geauga | Ohio | 39055 | 1131 | 51 |
705097 | 705097 | 2020-11-06 | Geauga | Ohio | 39055 | 1101 | 51 |
701854 | 701854 | 2020-11-05 | Geauga | Ohio | 39055 | 1068 | 50 |
698610 | 698610 | 2020-11-04 | Geauga | Ohio | 39055 | 1044 | 50 |
695367 | 695367 | 2020-11-03 | Geauga | Ohio | 39055 | 1023 | 50 |
692125 | 692125 | 2020-11-02 | Geauga | Ohio | 39055 | 1001 | 50 |
688881 | 688881 | 2020-11-01 | Geauga | Ohio | 39055 | 991 | 50 |
685636 | 685636 | 2020-10-31 | Geauga | Ohio | 39055 | 980 | 50 |
682393 | 682393 | 2020-10-30 | Geauga | Ohio | 39055 | 966 | 50 |
679150 | 679150 | 2020-10-29 | Geauga | Ohio | 39055 | 943 | 50 |
675907 | 675907 | 2020-10-28 | Geauga | Ohio | 39055 | 925 | 50 |
672664 | 672664 | 2020-10-27 | Geauga | Ohio | 39055 | 913 | 50 |
669422 | 669422 | 2020-10-26 | Geauga | Ohio | 39055 | 898 | 50 |
666178 | 666178 | 2020-10-25 | Geauga | Ohio | 39055 | 890 | 50 |
662933 | 662933 | 2020-10-24 | Geauga | Ohio | 39055 | 879 | 50 |
659689 | 659689 | 2020-10-23 | Geauga | Ohio | 39055 | 869 | 50 |
656445 | 656445 | 2020-10-22 | Geauga | Ohio | 39055 | 859 | 50 |
653200 | 653200 | 2020-10-21 | Geauga | Ohio | 39055 | 844 | 50 |
649955 | 649955 | 2020-10-20 | Geauga | Ohio | 39055 | 836 | 50 |
646711 | 646711 | 2020-10-19 | Geauga | Ohio | 39055 | 825 | 50 |
643465 | 643465 | 2020-10-18 | Geauga | Ohio | 39055 | 819 | 50 |
640217 | 640217 | 2020-10-17 | Geauga | Ohio | 39055 | 811 | 50 |
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 |
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);