ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39077 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922535 | 922535 | 2021-01-12 | Huron | Ohio | 39077 | 3914 | 38 |
919290 | 919290 | 2021-01-11 | Huron | Ohio | 39077 | 3861 | 38 |
916045 | 916045 | 2021-01-10 | Huron | Ohio | 39077 | 3804 | 38 |
912800 | 912800 | 2021-01-09 | Huron | Ohio | 39077 | 3773 | 38 |
909555 | 909555 | 2021-01-08 | Huron | Ohio | 39077 | 3734 | 38 |
906310 | 906310 | 2021-01-07 | Huron | Ohio | 39077 | 3664 | 38 |
903064 | 903064 | 2021-01-06 | Huron | Ohio | 39077 | 3582 | 37 |
899819 | 899819 | 2021-01-05 | Huron | Ohio | 39077 | 3538 | 37 |
896574 | 896574 | 2021-01-04 | Huron | Ohio | 39077 | 3494 | 37 |
893328 | 893328 | 2021-01-03 | Huron | Ohio | 39077 | 3472 | 37 |
890082 | 890082 | 2021-01-02 | Huron | Ohio | 39077 | 3444 | 37 |
886835 | 886835 | 2021-01-01 | Huron | Ohio | 39077 | 3389 | 37 |
883590 | 883590 | 2020-12-31 | Huron | Ohio | 39077 | 3389 | 37 |
880345 | 880345 | 2020-12-30 | Huron | Ohio | 39077 | 3311 | 37 |
877100 | 877100 | 2020-12-29 | Huron | Ohio | 39077 | 3261 | 37 |
873855 | 873855 | 2020-12-28 | Huron | Ohio | 39077 | 3210 | 37 |
870610 | 870610 | 2020-12-27 | Huron | Ohio | 39077 | 3196 | 37 |
867365 | 867365 | 2020-12-26 | Huron | Ohio | 39077 | 3176 | 37 |
864120 | 864120 | 2020-12-25 | Huron | Ohio | 39077 | 3136 | 37 |
860875 | 860875 | 2020-12-24 | Huron | Ohio | 39077 | 3136 | 37 |
857630 | 857630 | 2020-12-23 | Huron | Ohio | 39077 | 3062 | 37 |
854385 | 854385 | 2020-12-22 | Huron | Ohio | 39077 | 3027 | 37 |
851140 | 851140 | 2020-12-21 | Huron | Ohio | 39077 | 2995 | 37 |
847895 | 847895 | 2020-12-20 | Huron | Ohio | 39077 | 2936 | 37 |
844650 | 844650 | 2020-12-19 | Huron | Ohio | 39077 | 2905 | 37 |
841404 | 841404 | 2020-12-18 | Huron | Ohio | 39077 | 2856 | 37 |
838159 | 838159 | 2020-12-17 | Huron | Ohio | 39077 | 2761 | 37 |
834913 | 834913 | 2020-12-16 | Huron | Ohio | 39077 | 2712 | 36 |
831667 | 831667 | 2020-12-15 | Huron | Ohio | 39077 | 2701 | 36 |
828420 | 828420 | 2020-12-14 | Huron | Ohio | 39077 | 2630 | 35 |
825174 | 825174 | 2020-12-13 | Huron | Ohio | 39077 | 2581 | 33 |
821927 | 821927 | 2020-12-12 | Huron | Ohio | 39077 | 2548 | 33 |
818681 | 818681 | 2020-12-11 | Huron | Ohio | 39077 | 2511 | 33 |
815435 | 815435 | 2020-12-10 | Huron | Ohio | 39077 | 2468 | 31 |
812189 | 812189 | 2020-12-09 | Huron | Ohio | 39077 | 2395 | 25 |
808945 | 808945 | 2020-12-08 | Huron | Ohio | 39077 | 2351 | 22 |
805700 | 805700 | 2020-12-07 | Huron | Ohio | 39077 | 2012 | 22 |
802455 | 802455 | 2020-12-06 | Huron | Ohio | 39077 | 1981 | 22 |
799210 | 799210 | 2020-12-05 | Huron | Ohio | 39077 | 1956 | 22 |
795965 | 795965 | 2020-12-04 | Huron | Ohio | 39077 | 1899 | 22 |
792720 | 792720 | 2020-12-03 | Huron | Ohio | 39077 | 1854 | 22 |
789475 | 789475 | 2020-12-02 | Huron | Ohio | 39077 | 1809 | 22 |
786230 | 786230 | 2020-12-01 | Huron | Ohio | 39077 | 1781 | 22 |
782986 | 782986 | 2020-11-30 | Huron | Ohio | 39077 | 1741 | 22 |
779740 | 779740 | 2020-11-29 | Huron | Ohio | 39077 | 1727 | 22 |
776495 | 776495 | 2020-11-28 | Huron | Ohio | 39077 | 1697 | 22 |
773250 | 773250 | 2020-11-27 | Huron | Ohio | 39077 | 1630 | 22 |
770005 | 770005 | 2020-11-26 | Huron | Ohio | 39077 | 1555 | 19 |
766759 | 766759 | 2020-11-25 | Huron | Ohio | 39077 | 1555 | 19 |
763514 | 763514 | 2020-11-24 | Huron | Ohio | 39077 | 1523 | 18 |
760269 | 760269 | 2020-11-23 | Huron | Ohio | 39077 | 1475 | 18 |
757024 | 757024 | 2020-11-22 | Huron | Ohio | 39077 | 1392 | 18 |
753777 | 753777 | 2020-11-21 | Huron | Ohio | 39077 | 1359 | 18 |
750531 | 750531 | 2020-11-20 | Huron | Ohio | 39077 | 1325 | 18 |
747285 | 747285 | 2020-11-19 | Huron | Ohio | 39077 | 1263 | 18 |
744039 | 744039 | 2020-11-18 | Huron | Ohio | 39077 | 1219 | 18 |
740792 | 740792 | 2020-11-17 | Huron | Ohio | 39077 | 1186 | 18 |
737546 | 737546 | 2020-11-16 | Huron | Ohio | 39077 | 1147 | 18 |
734302 | 734302 | 2020-11-15 | Huron | Ohio | 39077 | 1107 | 18 |
731056 | 731056 | 2020-11-14 | Huron | Ohio | 39077 | 1067 | 18 |
727812 | 727812 | 2020-11-13 | Huron | Ohio | 39077 | 1043 | 18 |
724568 | 724568 | 2020-11-12 | Huron | Ohio | 39077 | 1011 | 18 |
721325 | 721325 | 2020-11-11 | Huron | Ohio | 39077 | 976 | 18 |
718082 | 718082 | 2020-11-10 | Huron | Ohio | 39077 | 940 | 16 |
714839 | 714839 | 2020-11-09 | Huron | Ohio | 39077 | 913 | 16 |
711595 | 711595 | 2020-11-08 | Huron | Ohio | 39077 | 888 | 16 |
708351 | 708351 | 2020-11-07 | Huron | Ohio | 39077 | 880 | 16 |
705108 | 705108 | 2020-11-06 | Huron | Ohio | 39077 | 859 | 16 |
701865 | 701865 | 2020-11-05 | Huron | Ohio | 39077 | 839 | 16 |
698621 | 698621 | 2020-11-04 | Huron | Ohio | 39077 | 817 | 16 |
695378 | 695378 | 2020-11-03 | Huron | Ohio | 39077 | 797 | 16 |
692136 | 692136 | 2020-11-02 | Huron | Ohio | 39077 | 784 | 16 |
688892 | 688892 | 2020-11-01 | Huron | Ohio | 39077 | 773 | 16 |
685647 | 685647 | 2020-10-31 | Huron | Ohio | 39077 | 769 | 16 |
682404 | 682404 | 2020-10-30 | Huron | Ohio | 39077 | 765 | 16 |
679161 | 679161 | 2020-10-29 | Huron | Ohio | 39077 | 752 | 15 |
675918 | 675918 | 2020-10-28 | Huron | Ohio | 39077 | 741 | 15 |
672675 | 672675 | 2020-10-27 | Huron | Ohio | 39077 | 737 | 15 |
669433 | 669433 | 2020-10-26 | Huron | Ohio | 39077 | 729 | 15 |
666189 | 666189 | 2020-10-25 | Huron | Ohio | 39077 | 723 | 15 |
662944 | 662944 | 2020-10-24 | Huron | Ohio | 39077 | 719 | 15 |
659700 | 659700 | 2020-10-23 | Huron | Ohio | 39077 | 716 | 14 |
656456 | 656456 | 2020-10-22 | Huron | Ohio | 39077 | 709 | 12 |
653211 | 653211 | 2020-10-21 | Huron | Ohio | 39077 | 706 | 11 |
649966 | 649966 | 2020-10-20 | Huron | Ohio | 39077 | 699 | 10 |
646722 | 646722 | 2020-10-19 | Huron | Ohio | 39077 | 698 | 9 |
643476 | 643476 | 2020-10-18 | Huron | Ohio | 39077 | 690 | 9 |
640228 | 640228 | 2020-10-17 | Huron | Ohio | 39077 | 687 | 9 |
636982 | 636982 | 2020-10-16 | Huron | Ohio | 39077 | 682 | 9 |
633736 | 633736 | 2020-10-15 | Huron | Ohio | 39077 | 680 | 9 |
630491 | 630491 | 2020-10-14 | Huron | Ohio | 39077 | 674 | 9 |
627247 | 627247 | 2020-10-13 | Huron | Ohio | 39077 | 664 | 8 |
624005 | 624005 | 2020-10-12 | Huron | Ohio | 39077 | 654 | 8 |
620762 | 620762 | 2020-10-11 | Huron | Ohio | 39077 | 646 | 8 |
617520 | 617520 | 2020-10-10 | Huron | Ohio | 39077 | 643 | 8 |
614278 | 614278 | 2020-10-09 | Huron | Ohio | 39077 | 641 | 8 |
611037 | 611037 | 2020-10-08 | Huron | Ohio | 39077 | 636 | 8 |
607795 | 607795 | 2020-10-07 | Huron | Ohio | 39077 | 629 | 8 |
604552 | 604552 | 2020-10-06 | Huron | Ohio | 39077 | 629 | 7 |
601310 | 601310 | 2020-10-05 | Huron | Ohio | 39077 | 618 | 7 |
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);