ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39159 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922576 | 922576 | 2021-01-12 | Union | Ohio | 39159 | 4131 | 23 |
919331 | 919331 | 2021-01-11 | Union | Ohio | 39159 | 4103 | 23 |
916086 | 916086 | 2021-01-10 | Union | Ohio | 39159 | 4041 | 23 |
912841 | 912841 | 2021-01-09 | Union | Ohio | 39159 | 4015 | 23 |
909596 | 909596 | 2021-01-08 | Union | Ohio | 39159 | 3992 | 23 |
906351 | 906351 | 2021-01-07 | Union | Ohio | 39159 | 3930 | 23 |
903105 | 903105 | 2021-01-06 | Union | Ohio | 39159 | 3843 | 21 |
899860 | 899860 | 2021-01-05 | Union | Ohio | 39159 | 3777 | 20 |
896615 | 896615 | 2021-01-04 | Union | Ohio | 39159 | 3743 | 19 |
893369 | 893369 | 2021-01-03 | Union | Ohio | 39159 | 3725 | 19 |
890123 | 890123 | 2021-01-02 | Union | Ohio | 39159 | 3701 | 19 |
886876 | 886876 | 2021-01-01 | Union | Ohio | 39159 | 3597 | 19 |
883631 | 883631 | 2020-12-31 | Union | Ohio | 39159 | 3597 | 19 |
880386 | 880386 | 2020-12-30 | Union | Ohio | 39159 | 3519 | 19 |
877141 | 877141 | 2020-12-29 | Union | Ohio | 39159 | 3459 | 19 |
873896 | 873896 | 2020-12-28 | Union | Ohio | 39159 | 3424 | 19 |
870651 | 870651 | 2020-12-27 | Union | Ohio | 39159 | 3404 | 19 |
867406 | 867406 | 2020-12-26 | Union | Ohio | 39159 | 3383 | 19 |
864161 | 864161 | 2020-12-25 | Union | Ohio | 39159 | 3321 | 19 |
860916 | 860916 | 2020-12-24 | Union | Ohio | 39159 | 3321 | 19 |
857671 | 857671 | 2020-12-23 | Union | Ohio | 39159 | 3261 | 19 |
854426 | 854426 | 2020-12-22 | Union | Ohio | 39159 | 3228 | 19 |
851181 | 851181 | 2020-12-21 | Union | Ohio | 39159 | 3193 | 18 |
847936 | 847936 | 2020-12-20 | Union | Ohio | 39159 | 3148 | 18 |
844691 | 844691 | 2020-12-19 | Union | Ohio | 39159 | 3107 | 18 |
841445 | 841445 | 2020-12-18 | Union | Ohio | 39159 | 3064 | 16 |
838200 | 838200 | 2020-12-17 | Union | Ohio | 39159 | 2995 | 16 |
834954 | 834954 | 2020-12-16 | Union | Ohio | 39159 | 2923 | 16 |
831708 | 831708 | 2020-12-15 | Union | Ohio | 39159 | 2905 | 16 |
828461 | 828461 | 2020-12-14 | Union | Ohio | 39159 | 2885 | 16 |
825215 | 825215 | 2020-12-13 | Union | Ohio | 39159 | 2859 | 16 |
821968 | 821968 | 2020-12-12 | Union | Ohio | 39159 | 2823 | 16 |
818722 | 818722 | 2020-12-11 | Union | Ohio | 39159 | 2767 | 16 |
815476 | 815476 | 2020-12-10 | Union | Ohio | 39159 | 2741 | 16 |
812230 | 812230 | 2020-12-09 | Union | Ohio | 39159 | 2652 | 14 |
808986 | 808986 | 2020-12-08 | Union | Ohio | 39159 | 2599 | 14 |
805741 | 805741 | 2020-12-07 | Union | Ohio | 39159 | 2536 | 14 |
802496 | 802496 | 2020-12-06 | Union | Ohio | 39159 | 2505 | 14 |
799251 | 799251 | 2020-12-05 | Union | Ohio | 39159 | 2454 | 14 |
796006 | 796006 | 2020-12-04 | Union | Ohio | 39159 | 2385 | 14 |
792761 | 792761 | 2020-12-03 | Union | Ohio | 39159 | 2322 | 13 |
789516 | 789516 | 2020-12-02 | Union | Ohio | 39159 | 2261 | 13 |
786271 | 786271 | 2020-12-01 | Union | Ohio | 39159 | 2203 | 8 |
783027 | 783027 | 2020-11-30 | Union | Ohio | 39159 | 2180 | 8 |
779781 | 779781 | 2020-11-29 | Union | Ohio | 39159 | 2138 | 8 |
776536 | 776536 | 2020-11-28 | Union | Ohio | 39159 | 2118 | 8 |
773291 | 773291 | 2020-11-27 | Union | Ohio | 39159 | 2083 | 8 |
770046 | 770046 | 2020-11-26 | Union | Ohio | 39159 | 1966 | 8 |
766800 | 766800 | 2020-11-25 | Union | Ohio | 39159 | 1966 | 8 |
763555 | 763555 | 2020-11-24 | Union | Ohio | 39159 | 1911 | 8 |
760310 | 760310 | 2020-11-23 | Union | Ohio | 39159 | 1865 | 8 |
757065 | 757065 | 2020-11-22 | Union | Ohio | 39159 | 1792 | 8 |
753818 | 753818 | 2020-11-21 | Union | Ohio | 39159 | 1744 | 8 |
750572 | 750572 | 2020-11-20 | Union | Ohio | 39159 | 1707 | 8 |
747326 | 747326 | 2020-11-19 | Union | Ohio | 39159 | 1623 | 7 |
744080 | 744080 | 2020-11-18 | Union | Ohio | 39159 | 1582 | 6 |
740833 | 740833 | 2020-11-17 | Union | Ohio | 39159 | 1548 | 3 |
737587 | 737587 | 2020-11-16 | Union | Ohio | 39159 | 1516 | 3 |
734343 | 734343 | 2020-11-15 | Union | Ohio | 39159 | 1477 | 3 |
731097 | 731097 | 2020-11-14 | Union | Ohio | 39159 | 1384 | 3 |
727853 | 727853 | 2020-11-13 | Union | Ohio | 39159 | 1350 | 3 |
724609 | 724609 | 2020-11-12 | Union | Ohio | 39159 | 1292 | 3 |
721366 | 721366 | 2020-11-11 | Union | Ohio | 39159 | 1258 | 3 |
718123 | 718123 | 2020-11-10 | Union | Ohio | 39159 | 1223 | 3 |
714880 | 714880 | 2020-11-09 | Union | Ohio | 39159 | 1186 | 3 |
711636 | 711636 | 2020-11-08 | Union | Ohio | 39159 | 1152 | 3 |
708392 | 708392 | 2020-11-07 | Union | Ohio | 39159 | 1100 | 3 |
705149 | 705149 | 2020-11-06 | Union | Ohio | 39159 | 1066 | 3 |
701906 | 701906 | 2020-11-05 | Union | Ohio | 39159 | 1033 | 3 |
698662 | 698662 | 2020-11-04 | Union | Ohio | 39159 | 1008 | 3 |
695419 | 695419 | 2020-11-03 | Union | Ohio | 39159 | 945 | 3 |
692177 | 692177 | 2020-11-02 | Union | Ohio | 39159 | 916 | 3 |
688933 | 688933 | 2020-11-01 | Union | Ohio | 39159 | 902 | 3 |
685688 | 685688 | 2020-10-31 | Union | Ohio | 39159 | 860 | 3 |
682445 | 682445 | 2020-10-30 | Union | Ohio | 39159 | 852 | 3 |
679202 | 679202 | 2020-10-29 | Union | Ohio | 39159 | 827 | 3 |
675959 | 675959 | 2020-10-28 | Union | Ohio | 39159 | 815 | 3 |
672716 | 672716 | 2020-10-27 | Union | Ohio | 39159 | 802 | 3 |
669474 | 669474 | 2020-10-26 | Union | Ohio | 39159 | 799 | 3 |
666230 | 666230 | 2020-10-25 | Union | Ohio | 39159 | 790 | 3 |
662985 | 662985 | 2020-10-24 | Union | Ohio | 39159 | 782 | 3 |
659741 | 659741 | 2020-10-23 | Union | Ohio | 39159 | 770 | 3 |
656497 | 656497 | 2020-10-22 | Union | Ohio | 39159 | 758 | 3 |
653252 | 653252 | 2020-10-21 | Union | Ohio | 39159 | 747 | 3 |
650007 | 650007 | 2020-10-20 | Union | Ohio | 39159 | 734 | 3 |
646763 | 646763 | 2020-10-19 | Union | Ohio | 39159 | 726 | 3 |
643517 | 643517 | 2020-10-18 | Union | Ohio | 39159 | 720 | 3 |
640269 | 640269 | 2020-10-17 | Union | Ohio | 39159 | 715 | 3 |
637023 | 637023 | 2020-10-16 | Union | Ohio | 39159 | 700 | 3 |
633777 | 633777 | 2020-10-15 | Union | Ohio | 39159 | 693 | 3 |
630532 | 630532 | 2020-10-14 | Union | Ohio | 39159 | 685 | 3 |
627288 | 627288 | 2020-10-13 | Union | Ohio | 39159 | 676 | 2 |
624046 | 624046 | 2020-10-12 | Union | Ohio | 39159 | 673 | 2 |
620803 | 620803 | 2020-10-11 | Union | Ohio | 39159 | 660 | 2 |
617561 | 617561 | 2020-10-10 | Union | Ohio | 39159 | 647 | 2 |
614319 | 614319 | 2020-10-09 | Union | Ohio | 39159 | 644 | 2 |
611078 | 611078 | 2020-10-08 | Union | Ohio | 39159 | 627 | 2 |
607836 | 607836 | 2020-10-07 | Union | Ohio | 39159 | 618 | 2 |
604593 | 604593 | 2020-10-06 | Union | Ohio | 39159 | 606 | 2 |
601351 | 601351 | 2020-10-05 | Union | Ohio | 39159 | 603 | 2 |
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);