ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Butler" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055574 | 1055574 | 2021-02-22 | Butler | Ohio | 39017 | 34918 | 459 |
1052328 | 1052328 | 2021-02-21 | Butler | Ohio | 39017 | 34874 | 458 |
1049081 | 1049081 | 2021-02-20 | Butler | Ohio | 39017 | 34825 | 454 |
1045834 | 1045834 | 2021-02-19 | Butler | Ohio | 39017 | 34641 | 453 |
1042589 | 1042589 | 2021-02-18 | Butler | Ohio | 39017 | 34548 | 452 |
1039344 | 1039344 | 2021-02-17 | Butler | Ohio | 39017 | 34439 | 452 |
1036099 | 1036099 | 2021-02-16 | Butler | Ohio | 39017 | 34372 | 447 |
1032854 | 1032854 | 2021-02-15 | Butler | Ohio | 39017 | 34306 | 443 |
1029608 | 1029608 | 2021-02-14 | Butler | Ohio | 39017 | 34221 | 443 |
1026361 | 1026361 | 2021-02-13 | Butler | Ohio | 39017 | 34142 | 442 |
1023116 | 1023116 | 2021-02-12 | Butler | Ohio | 39017 | 34032 | 401 |
1019871 | 1019871 | 2021-02-11 | Butler | Ohio | 39017 | 33874 | 304 |
1016626 | 1016626 | 2021-02-10 | Butler | Ohio | 39017 | 33750 | 272 |
1013381 | 1013381 | 2021-02-09 | Butler | Ohio | 39017 | 33597 | 272 |
1010136 | 1010136 | 2021-02-08 | Butler | Ohio | 39017 | 33467 | 270 |
1006890 | 1006890 | 2021-02-07 | Butler | Ohio | 39017 | 33400 | 269 |
1003644 | 1003644 | 2021-02-06 | Butler | Ohio | 39017 | 33307 | 269 |
1000398 | 1000398 | 2021-02-05 | Butler | Ohio | 39017 | 33104 | 266 |
997152 | 997152 | 2021-02-04 | Butler | Ohio | 39017 | 32921 | 264 |
993906 | 993906 | 2021-02-03 | Butler | Ohio | 39017 | 32764 | 259 |
990660 | 990660 | 2021-02-02 | Butler | Ohio | 39017 | 32614 | 254 |
987414 | 987414 | 2021-02-01 | Butler | Ohio | 39017 | 32470 | 243 |
984167 | 984167 | 2021-01-31 | Butler | Ohio | 39017 | 32348 | 242 |
980920 | 980920 | 2021-01-30 | Butler | Ohio | 39017 | 32192 | 240 |
977674 | 977674 | 2021-01-29 | Butler | Ohio | 39017 | 32035 | 240 |
974429 | 974429 | 2021-01-28 | Butler | Ohio | 39017 | 31815 | 236 |
971184 | 971184 | 2021-01-27 | Butler | Ohio | 39017 | 31640 | 236 |
967939 | 967939 | 2021-01-26 | Butler | Ohio | 39017 | 31451 | 232 |
964695 | 964695 | 2021-01-25 | Butler | Ohio | 39017 | 31268 | 232 |
961450 | 961450 | 2021-01-24 | Butler | Ohio | 39017 | 31128 | 232 |
958205 | 958205 | 2021-01-23 | Butler | Ohio | 39017 | 30973 | 232 |
954959 | 954959 | 2021-01-22 | Butler | Ohio | 39017 | 30735 | 231 |
951714 | 951714 | 2021-01-21 | Butler | Ohio | 39017 | 30546 | 229 |
948469 | 948469 | 2021-01-20 | Butler | Ohio | 39017 | 30216 | 228 |
945223 | 945223 | 2021-01-19 | Butler | Ohio | 39017 | 30003 | 228 |
941976 | 941976 | 2021-01-18 | Butler | Ohio | 39017 | 29859 | 228 |
938731 | 938731 | 2021-01-17 | Butler | Ohio | 39017 | 29721 | 228 |
935486 | 935486 | 2021-01-16 | Butler | Ohio | 39017 | 29513 | 227 |
932241 | 932241 | 2021-01-15 | Butler | Ohio | 39017 | 29296 | 226 |
928996 | 928996 | 2021-01-14 | Butler | Ohio | 39017 | 29100 | 225 |
925751 | 925751 | 2021-01-13 | Butler | Ohio | 39017 | 28865 | 224 |
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 |
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);