ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Medina" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195220 | 1195220 | 2021-04-06 | Medina | Ohio | 39103 | 14525 | 255 |
1191972 | 1191972 | 2021-04-05 | Medina | Ohio | 39103 | 14506 | 254 |
1188723 | 1188723 | 2021-04-04 | Medina | Ohio | 39103 | 14464 | 254 |
1185476 | 1185476 | 2021-04-03 | Medina | Ohio | 39103 | 14464 | 254 |
1182229 | 1182229 | 2021-04-02 | Medina | Ohio | 39103 | 14418 | 254 |
1178982 | 1178982 | 2021-04-01 | Medina | Ohio | 39103 | 14386 | 254 |
1175735 | 1175735 | 2021-03-31 | Medina | Ohio | 39103 | 14349 | 254 |
1172488 | 1172488 | 2021-03-30 | Medina | Ohio | 39103 | 14317 | 254 |
1169241 | 1169241 | 2021-03-29 | Medina | Ohio | 39103 | 14283 | 250 |
1165993 | 1165993 | 2021-03-28 | Medina | Ohio | 39103 | 14260 | 250 |
1162745 | 1162745 | 2021-03-27 | Medina | Ohio | 39103 | 14236 | 250 |
1159496 | 1159496 | 2021-03-26 | Medina | Ohio | 39103 | 14201 | 250 |
1156249 | 1156249 | 2021-03-25 | Medina | Ohio | 39103 | 14145 | 247 |
1153002 | 1153002 | 2021-03-24 | Medina | Ohio | 39103 | 14128 | 247 |
1149755 | 1149755 | 2021-03-23 | Medina | Ohio | 39103 | 14095 | 247 |
1146508 | 1146508 | 2021-03-22 | Medina | Ohio | 39103 | 14065 | 247 |
1143261 | 1143261 | 2021-03-21 | Medina | Ohio | 39103 | 14037 | 247 |
1140014 | 1140014 | 2021-03-20 | Medina | Ohio | 39103 | 14018 | 247 |
1136768 | 1136768 | 2021-03-19 | Medina | Ohio | 39103 | 13991 | 247 |
1133522 | 1133522 | 2021-03-18 | Medina | Ohio | 39103 | 13969 | 243 |
1130274 | 1130274 | 2021-03-17 | Medina | Ohio | 39103 | 13918 | 243 |
1127027 | 1127027 | 2021-03-16 | Medina | Ohio | 39103 | 13882 | 243 |
1123781 | 1123781 | 2021-03-15 | Medina | Ohio | 39103 | 13818 | 239 |
1120535 | 1120535 | 2021-03-14 | Medina | Ohio | 39103 | 13799 | 239 |
1117288 | 1117288 | 2021-03-13 | Medina | Ohio | 39103 | 13783 | 239 |
1114041 | 1114041 | 2021-03-12 | Medina | Ohio | 39103 | 13728 | 239 |
1110795 | 1110795 | 2021-03-11 | Medina | Ohio | 39103 | 13678 | 238 |
1107549 | 1107549 | 2021-03-10 | Medina | Ohio | 39103 | 13662 | 238 |
1104303 | 1104303 | 2021-03-09 | Medina | Ohio | 39103 | 13604 | 238 |
1101057 | 1101057 | 2021-03-08 | Medina | Ohio | 39103 | 13559 | 237 |
1097811 | 1097811 | 2021-03-07 | Medina | Ohio | 39103 | 13531 | 237 |
1094563 | 1094563 | 2021-03-06 | Medina | Ohio | 39103 | 13517 | 237 |
1091317 | 1091317 | 2021-03-05 | Medina | Ohio | 39103 | 13484 | 237 |
1088072 | 1088072 | 2021-03-04 | Medina | Ohio | 39103 | 13448 | 226 |
1084827 | 1084827 | 2021-03-03 | Medina | Ohio | 39103 | 13423 | 226 |
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 |
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);