ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39017 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922505 | 922505 | 2021-01-12 | Butler | Ohio | 39017 | 28643 | 216 |
919260 | 919260 | 2021-01-11 | Butler | Ohio | 39017 | 28349 | 211 |
916015 | 916015 | 2021-01-10 | Butler | Ohio | 39017 | 28128 | 211 |
912770 | 912770 | 2021-01-09 | Butler | Ohio | 39017 | 27909 | 211 |
909525 | 909525 | 2021-01-08 | Butler | Ohio | 39017 | 27664 | 211 |
906280 | 906280 | 2021-01-07 | Butler | Ohio | 39017 | 27360 | 211 |
903034 | 903034 | 2021-01-06 | Butler | Ohio | 39017 | 27064 | 211 |
899789 | 899789 | 2021-01-05 | Butler | Ohio | 39017 | 26837 | 197 |
896544 | 896544 | 2021-01-04 | Butler | Ohio | 39017 | 26620 | 190 |
893298 | 893298 | 2021-01-03 | Butler | Ohio | 39017 | 26461 | 188 |
890052 | 890052 | 2021-01-02 | Butler | Ohio | 39017 | 26229 | 188 |
886805 | 886805 | 2021-01-01 | Butler | Ohio | 39017 | 25723 | 188 |
883560 | 883560 | 2020-12-31 | Butler | Ohio | 39017 | 25723 | 188 |
880315 | 880315 | 2020-12-30 | Butler | Ohio | 39017 | 25416 | 188 |
877070 | 877070 | 2020-12-29 | Butler | Ohio | 39017 | 25079 | 187 |
873825 | 873825 | 2020-12-28 | Butler | Ohio | 39017 | 24838 | 186 |
870580 | 870580 | 2020-12-27 | Butler | Ohio | 39017 | 24702 | 183 |
867335 | 867335 | 2020-12-26 | Butler | Ohio | 39017 | 24509 | 183 |
864090 | 864090 | 2020-12-25 | Butler | Ohio | 39017 | 24170 | 183 |
860845 | 860845 | 2020-12-24 | Butler | Ohio | 39017 | 24170 | 183 |
857600 | 857600 | 2020-12-23 | Butler | Ohio | 39017 | 23882 | 182 |
854355 | 854355 | 2020-12-22 | Butler | Ohio | 39017 | 23717 | 181 |
851110 | 851110 | 2020-12-21 | Butler | Ohio | 39017 | 23487 | 179 |
847865 | 847865 | 2020-12-20 | Butler | Ohio | 39017 | 23321 | 179 |
844620 | 844620 | 2020-12-19 | Butler | Ohio | 39017 | 23057 | 179 |
841374 | 841374 | 2020-12-18 | Butler | Ohio | 39017 | 22796 | 179 |
838129 | 838129 | 2020-12-17 | Butler | Ohio | 39017 | 22488 | 179 |
834883 | 834883 | 2020-12-16 | Butler | Ohio | 39017 | 22095 | 176 |
831637 | 831637 | 2020-12-15 | Butler | Ohio | 39017 | 21940 | 172 |
828390 | 828390 | 2020-12-14 | Butler | Ohio | 39017 | 21583 | 172 |
825144 | 825144 | 2020-12-13 | Butler | Ohio | 39017 | 21391 | 169 |
821897 | 821897 | 2020-12-12 | Butler | Ohio | 39017 | 21106 | 169 |
818651 | 818651 | 2020-12-11 | Butler | Ohio | 39017 | 20738 | 169 |
815405 | 815405 | 2020-12-10 | Butler | Ohio | 39017 | 20306 | 169 |
812159 | 812159 | 2020-12-09 | Butler | Ohio | 39017 | 19919 | 169 |
808915 | 808915 | 2020-12-08 | Butler | Ohio | 39017 | 19620 | 166 |
805670 | 805670 | 2020-12-07 | Butler | Ohio | 39017 | 18890 | 163 |
802425 | 802425 | 2020-12-06 | Butler | Ohio | 39017 | 18576 | 160 |
799180 | 799180 | 2020-12-05 | Butler | Ohio | 39017 | 18288 | 160 |
795935 | 795935 | 2020-12-04 | Butler | Ohio | 39017 | 17918 | 160 |
792690 | 792690 | 2020-12-03 | Butler | Ohio | 39017 | 17529 | 154 |
789445 | 789445 | 2020-12-02 | Butler | Ohio | 39017 | 17186 | 152 |
786200 | 786200 | 2020-12-01 | Butler | Ohio | 39017 | 16902 | 152 |
782956 | 782956 | 2020-11-30 | Butler | Ohio | 39017 | 16589 | 150 |
779710 | 779710 | 2020-11-29 | Butler | Ohio | 39017 | 16280 | 149 |
776465 | 776465 | 2020-11-28 | Butler | Ohio | 39017 | 16020 | 149 |
773220 | 773220 | 2020-11-27 | Butler | Ohio | 39017 | 15768 | 149 |
769975 | 769975 | 2020-11-26 | Butler | Ohio | 39017 | 15199 | 148 |
766729 | 766729 | 2020-11-25 | Butler | Ohio | 39017 | 15199 | 148 |
763484 | 763484 | 2020-11-24 | Butler | Ohio | 39017 | 14769 | 146 |
760239 | 760239 | 2020-11-23 | Butler | Ohio | 39017 | 14472 | 144 |
756994 | 756994 | 2020-11-22 | Butler | Ohio | 39017 | 14138 | 144 |
753747 | 753747 | 2020-11-21 | Butler | Ohio | 39017 | 13913 | 144 |
750501 | 750501 | 2020-11-20 | Butler | Ohio | 39017 | 13610 | 144 |
747255 | 747255 | 2020-11-19 | Butler | Ohio | 39017 | 13328 | 142 |
744009 | 744009 | 2020-11-18 | Butler | Ohio | 39017 | 13050 | 142 |
740762 | 740762 | 2020-11-17 | Butler | Ohio | 39017 | 12874 | 139 |
737516 | 737516 | 2020-11-16 | Butler | Ohio | 39017 | 12610 | 139 |
734272 | 734272 | 2020-11-15 | Butler | Ohio | 39017 | 12362 | 139 |
731026 | 731026 | 2020-11-14 | Butler | Ohio | 39017 | 12104 | 139 |
727782 | 727782 | 2020-11-13 | Butler | Ohio | 39017 | 11711 | 138 |
724538 | 724538 | 2020-11-12 | Butler | Ohio | 39017 | 11484 | 136 |
721295 | 721295 | 2020-11-11 | Butler | Ohio | 39017 | 11275 | 135 |
718052 | 718052 | 2020-11-10 | Butler | Ohio | 39017 | 11122 | 135 |
714809 | 714809 | 2020-11-09 | Butler | Ohio | 39017 | 10926 | 134 |
711565 | 711565 | 2020-11-08 | Butler | Ohio | 39017 | 10761 | 134 |
708321 | 708321 | 2020-11-07 | Butler | Ohio | 39017 | 10622 | 134 |
705078 | 705078 | 2020-11-06 | Butler | Ohio | 39017 | 10395 | 134 |
701835 | 701835 | 2020-11-05 | Butler | Ohio | 39017 | 10205 | 134 |
698591 | 698591 | 2020-11-04 | Butler | Ohio | 39017 | 9962 | 134 |
695348 | 695348 | 2020-11-03 | Butler | Ohio | 39017 | 9836 | 134 |
692106 | 692106 | 2020-11-02 | Butler | Ohio | 39017 | 9683 | 134 |
688862 | 688862 | 2020-11-01 | Butler | Ohio | 39017 | 9565 | 134 |
685617 | 685617 | 2020-10-31 | Butler | Ohio | 39017 | 9427 | 134 |
682374 | 682374 | 2020-10-30 | Butler | Ohio | 39017 | 9298 | 133 |
679131 | 679131 | 2020-10-29 | Butler | Ohio | 39017 | 9082 | 133 |
675888 | 675888 | 2020-10-28 | Butler | Ohio | 39017 | 8981 | 132 |
672645 | 672645 | 2020-10-27 | Butler | Ohio | 39017 | 8821 | 132 |
669403 | 669403 | 2020-10-26 | Butler | Ohio | 39017 | 8727 | 131 |
666159 | 666159 | 2020-10-25 | Butler | Ohio | 39017 | 8654 | 131 |
662914 | 662914 | 2020-10-24 | Butler | Ohio | 39017 | 8557 | 131 |
659670 | 659670 | 2020-10-23 | Butler | Ohio | 39017 | 8401 | 130 |
656426 | 656426 | 2020-10-22 | Butler | Ohio | 39017 | 8276 | 129 |
653181 | 653181 | 2020-10-21 | Butler | Ohio | 39017 | 8145 | 128 |
649936 | 649936 | 2020-10-20 | Butler | Ohio | 39017 | 8028 | 123 |
646692 | 646692 | 2020-10-19 | Butler | Ohio | 39017 | 7914 | 123 |
643446 | 643446 | 2020-10-18 | Butler | Ohio | 39017 | 7856 | 122 |
640198 | 640198 | 2020-10-17 | Butler | Ohio | 39017 | 7779 | 122 |
636952 | 636952 | 2020-10-16 | Butler | Ohio | 39017 | 7654 | 119 |
633706 | 633706 | 2020-10-15 | Butler | Ohio | 39017 | 7549 | 118 |
630461 | 630461 | 2020-10-14 | Butler | Ohio | 39017 | 7423 | 118 |
627217 | 627217 | 2020-10-13 | Butler | Ohio | 39017 | 7335 | 117 |
623975 | 623975 | 2020-10-12 | Butler | Ohio | 39017 | 7253 | 116 |
620732 | 620732 | 2020-10-11 | Butler | Ohio | 39017 | 7178 | 115 |
617490 | 617490 | 2020-10-10 | Butler | Ohio | 39017 | 7098 | 115 |
614248 | 614248 | 2020-10-09 | Butler | Ohio | 39017 | 7014 | 116 |
611007 | 611007 | 2020-10-08 | Butler | Ohio | 39017 | 6911 | 115 |
607765 | 607765 | 2020-10-07 | Butler | Ohio | 39017 | 6828 | 114 |
604522 | 604522 | 2020-10-06 | Butler | Ohio | 39017 | 6726 | 114 |
601280 | 601280 | 2020-10-05 | Butler | Ohio | 39017 | 6617 | 113 |
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);