ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 39103 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081581 | 1081581 | 2021-03-02 | Medina | Ohio | 39103 | 13394 | 226 |
1078335 | 1078335 | 2021-03-01 | Medina | Ohio | 39103 | 13370 | 219 |
1075090 | 1075090 | 2021-02-28 | Medina | Ohio | 39103 | 13347 | 219 |
1071844 | 1071844 | 2021-02-27 | Medina | Ohio | 39103 | 13327 | 218 |
1068598 | 1068598 | 2021-02-26 | Medina | Ohio | 39103 | 13290 | 219 |
1065353 | 1065353 | 2021-02-25 | Medina | Ohio | 39103 | 13263 | 219 |
1062109 | 1062109 | 2021-02-24 | Medina | Ohio | 39103 | 13220 | 219 |
1058863 | 1058863 | 2021-02-23 | Medina | Ohio | 39103 | 13188 | 218 |
1055617 | 1055617 | 2021-02-22 | Medina | Ohio | 39103 | 13130 | 217 |
1052371 | 1052371 | 2021-02-21 | Medina | Ohio | 39103 | 13111 | 217 |
1049124 | 1049124 | 2021-02-20 | Medina | Ohio | 39103 | 13097 | 216 |
1045877 | 1045877 | 2021-02-19 | Medina | Ohio | 39103 | 13070 | 216 |
1042632 | 1042632 | 2021-02-18 | Medina | Ohio | 39103 | 13025 | 214 |
1039387 | 1039387 | 2021-02-17 | Medina | Ohio | 39103 | 12987 | 214 |
1036142 | 1036142 | 2021-02-16 | Medina | Ohio | 39103 | 12954 | 213 |
1032897 | 1032897 | 2021-02-15 | Medina | Ohio | 39103 | 12905 | 212 |
1029651 | 1029651 | 2021-02-14 | Medina | Ohio | 39103 | 12868 | 211 |
1026404 | 1026404 | 2021-02-13 | Medina | Ohio | 39103 | 12835 | 211 |
1023159 | 1023159 | 2021-02-12 | Medina | Ohio | 39103 | 12783 | 204 |
1019914 | 1019914 | 2021-02-11 | Medina | Ohio | 39103 | 12728 | 190 |
1016669 | 1016669 | 2021-02-10 | Medina | Ohio | 39103 | 12689 | 185 |
1013424 | 1013424 | 2021-02-09 | Medina | Ohio | 39103 | 12641 | 183 |
1010179 | 1010179 | 2021-02-08 | Medina | Ohio | 39103 | 12592 | 181 |
1006933 | 1006933 | 2021-02-07 | Medina | Ohio | 39103 | 12557 | 181 |
1003687 | 1003687 | 2021-02-06 | Medina | Ohio | 39103 | 12522 | 177 |
1000441 | 1000441 | 2021-02-05 | Medina | Ohio | 39103 | 12464 | 177 |
997195 | 997195 | 2021-02-04 | Medina | Ohio | 39103 | 12417 | 177 |
993949 | 993949 | 2021-02-03 | Medina | Ohio | 39103 | 12341 | 177 |
990703 | 990703 | 2021-02-02 | Medina | Ohio | 39103 | 12285 | 177 |
987457 | 987457 | 2021-02-01 | Medina | Ohio | 39103 | 12189 | 177 |
984210 | 984210 | 2021-01-31 | Medina | Ohio | 39103 | 12138 | 173 |
980963 | 980963 | 2021-01-30 | Medina | Ohio | 39103 | 12096 | 173 |
977717 | 977717 | 2021-01-29 | Medina | Ohio | 39103 | 12027 | 173 |
974472 | 974472 | 2021-01-28 | Medina | Ohio | 39103 | 11961 | 171 |
971227 | 971227 | 2021-01-27 | Medina | Ohio | 39103 | 11865 | 169 |
967982 | 967982 | 2021-01-26 | Medina | Ohio | 39103 | 11798 | 169 |
964738 | 964738 | 2021-01-25 | Medina | Ohio | 39103 | 11732 | 168 |
961493 | 961493 | 2021-01-24 | Medina | Ohio | 39103 | 11666 | 168 |
958248 | 958248 | 2021-01-23 | Medina | Ohio | 39103 | 11591 | 168 |
955002 | 955002 | 2021-01-22 | Medina | Ohio | 39103 | 11504 | 168 |
951757 | 951757 | 2021-01-21 | Medina | Ohio | 39103 | 11439 | 167 |
948512 | 948512 | 2021-01-20 | Medina | Ohio | 39103 | 11364 | 167 |
945266 | 945266 | 2021-01-19 | Medina | Ohio | 39103 | 11286 | 165 |
942019 | 942019 | 2021-01-18 | Medina | Ohio | 39103 | 11191 | 165 |
938774 | 938774 | 2021-01-17 | Medina | Ohio | 39103 | 11128 | 165 |
935529 | 935529 | 2021-01-16 | Medina | Ohio | 39103 | 11033 | 165 |
932284 | 932284 | 2021-01-15 | Medina | Ohio | 39103 | 10949 | 165 |
929039 | 929039 | 2021-01-14 | Medina | Ohio | 39103 | 10815 | 164 |
925794 | 925794 | 2021-01-13 | Medina | Ohio | 39103 | 10737 | 155 |
922548 | 922548 | 2021-01-12 | Medina | Ohio | 39103 | 10632 | 155 |
919303 | 919303 | 2021-01-11 | Medina | Ohio | 39103 | 10551 | 167 |
916058 | 916058 | 2021-01-10 | Medina | Ohio | 39103 | 10435 | 121 |
912813 | 912813 | 2021-01-09 | Medina | Ohio | 39103 | 10349 | 121 |
909568 | 909568 | 2021-01-08 | Medina | Ohio | 39103 | 10227 | 121 |
906323 | 906323 | 2021-01-07 | Medina | Ohio | 39103 | 10102 | 118 |
903077 | 903077 | 2021-01-06 | Medina | Ohio | 39103 | 9930 | 117 |
899832 | 899832 | 2021-01-05 | Medina | Ohio | 39103 | 9830 | 116 |
896587 | 896587 | 2021-01-04 | Medina | Ohio | 39103 | 9700 | 115 |
893341 | 893341 | 2021-01-03 | Medina | Ohio | 39103 | 9601 | 114 |
890095 | 890095 | 2021-01-02 | Medina | Ohio | 39103 | 9515 | 114 |
886848 | 886848 | 2021-01-01 | Medina | Ohio | 39103 | 9312 | 114 |
883603 | 883603 | 2020-12-31 | Medina | Ohio | 39103 | 9312 | 114 |
880358 | 880358 | 2020-12-30 | Medina | Ohio | 39103 | 9195 | 103 |
877113 | 877113 | 2020-12-29 | Medina | Ohio | 39103 | 9048 | 102 |
873868 | 873868 | 2020-12-28 | Medina | Ohio | 39103 | 8919 | 99 |
870623 | 870623 | 2020-12-27 | Medina | Ohio | 39103 | 8829 | 98 |
867378 | 867378 | 2020-12-26 | Medina | Ohio | 39103 | 8760 | 93 |
864133 | 864133 | 2020-12-25 | Medina | Ohio | 39103 | 8622 | 93 |
860888 | 860888 | 2020-12-24 | Medina | Ohio | 39103 | 8622 | 93 |
857643 | 857643 | 2020-12-23 | Medina | Ohio | 39103 | 8514 | 93 |
854398 | 854398 | 2020-12-22 | Medina | Ohio | 39103 | 8426 | 91 |
851153 | 851153 | 2020-12-21 | Medina | Ohio | 39103 | 8296 | 91 |
847908 | 847908 | 2020-12-20 | Medina | Ohio | 39103 | 8218 | 91 |
844663 | 844663 | 2020-12-19 | Medina | Ohio | 39103 | 8104 | 89 |
841417 | 841417 | 2020-12-18 | Medina | Ohio | 39103 | 7941 | 84 |
838172 | 838172 | 2020-12-17 | Medina | Ohio | 39103 | 7800 | 81 |
834926 | 834926 | 2020-12-16 | Medina | Ohio | 39103 | 7635 | 76 |
831680 | 831680 | 2020-12-15 | Medina | Ohio | 39103 | 7533 | 75 |
828433 | 828433 | 2020-12-14 | Medina | Ohio | 39103 | 7407 | 72 |
825187 | 825187 | 2020-12-13 | Medina | Ohio | 39103 | 7297 | 72 |
821940 | 821940 | 2020-12-12 | Medina | Ohio | 39103 | 7122 | 72 |
818694 | 818694 | 2020-12-11 | Medina | Ohio | 39103 | 6983 | 70 |
815448 | 815448 | 2020-12-10 | Medina | Ohio | 39103 | 6872 | 67 |
812202 | 812202 | 2020-12-09 | Medina | Ohio | 39103 | 6725 | 66 |
808958 | 808958 | 2020-12-08 | Medina | Ohio | 39103 | 6506 | 63 |
805713 | 805713 | 2020-12-07 | Medina | Ohio | 39103 | 6165 | 63 |
802468 | 802468 | 2020-12-06 | Medina | Ohio | 39103 | 6049 | 62 |
799223 | 799223 | 2020-12-05 | Medina | Ohio | 39103 | 5952 | 62 |
795978 | 795978 | 2020-12-04 | Medina | Ohio | 39103 | 5830 | 61 |
792733 | 792733 | 2020-12-03 | Medina | Ohio | 39103 | 5658 | 58 |
789488 | 789488 | 2020-12-02 | Medina | Ohio | 39103 | 5533 | 57 |
786243 | 786243 | 2020-12-01 | Medina | Ohio | 39103 | 5433 | 57 |
782999 | 782999 | 2020-11-30 | Medina | Ohio | 39103 | 5266 | 57 |
779753 | 779753 | 2020-11-29 | Medina | Ohio | 39103 | 5180 | 57 |
776508 | 776508 | 2020-11-28 | Medina | Ohio | 39103 | 5064 | 57 |
773263 | 773263 | 2020-11-27 | Medina | Ohio | 39103 | 4965 | 57 |
770018 | 770018 | 2020-11-26 | Medina | Ohio | 39103 | 4716 | 57 |
766772 | 766772 | 2020-11-25 | Medina | Ohio | 39103 | 4716 | 57 |
763527 | 763527 | 2020-11-24 | Medina | Ohio | 39103 | 4477 | 56 |
760282 | 760282 | 2020-11-23 | Medina | Ohio | 39103 | 4286 | 54 |
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);