ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,577 rows where county = "Medina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1085500 | 1085500 | 2021-03-03 | Medina | Texas | 48325 | 4628 | 97 |
1081581 | 1081581 | 2021-03-02 | Medina | Ohio | 39103 | 13394 | 226 |
1082254 | 1082254 | 2021-03-02 | Medina | Texas | 48325 | 4612 | 93 |
1078335 | 1078335 | 2021-03-01 | Medina | Ohio | 39103 | 13370 | 219 |
1079008 | 1079008 | 2021-03-01 | Medina | Texas | 48325 | 4604 | 93 |
1075090 | 1075090 | 2021-02-28 | Medina | Ohio | 39103 | 13347 | 219 |
1075763 | 1075763 | 2021-02-28 | Medina | Texas | 48325 | 4604 | 93 |
1071844 | 1071844 | 2021-02-27 | Medina | Ohio | 39103 | 13327 | 218 |
1072517 | 1072517 | 2021-02-27 | Medina | Texas | 48325 | 4584 | 93 |
1068598 | 1068598 | 2021-02-26 | Medina | Ohio | 39103 | 13290 | 219 |
1069271 | 1069271 | 2021-02-26 | Medina | Texas | 48325 | 4604 | 93 |
1065353 | 1065353 | 2021-02-25 | Medina | Ohio | 39103 | 13263 | 219 |
1066026 | 1066026 | 2021-02-25 | Medina | Texas | 48325 | 4604 | 93 |
1062109 | 1062109 | 2021-02-24 | Medina | Ohio | 39103 | 13220 | 219 |
1062781 | 1062781 | 2021-02-24 | Medina | Texas | 48325 | 4574 | 93 |
1058863 | 1058863 | 2021-02-23 | Medina | Ohio | 39103 | 13188 | 218 |
1059536 | 1059536 | 2021-02-23 | Medina | Texas | 48325 | 4574 | 91 |
1055617 | 1055617 | 2021-02-22 | Medina | Ohio | 39103 | 13130 | 217 |
1056290 | 1056290 | 2021-02-22 | Medina | Texas | 48325 | 4538 | 91 |
1052371 | 1052371 | 2021-02-21 | Medina | Ohio | 39103 | 13111 | 217 |
1053044 | 1053044 | 2021-02-21 | Medina | Texas | 48325 | 4538 | 91 |
1049124 | 1049124 | 2021-02-20 | Medina | Ohio | 39103 | 13097 | 216 |
1049797 | 1049797 | 2021-02-20 | Medina | Texas | 48325 | 4538 | 91 |
1045877 | 1045877 | 2021-02-19 | Medina | Ohio | 39103 | 13070 | 216 |
1046550 | 1046550 | 2021-02-19 | Medina | Texas | 48325 | 4538 | 91 |
1042632 | 1042632 | 2021-02-18 | Medina | Ohio | 39103 | 13025 | 214 |
1043305 | 1043305 | 2021-02-18 | Medina | Texas | 48325 | 4527 | 87 |
1039387 | 1039387 | 2021-02-17 | Medina | Ohio | 39103 | 12987 | 214 |
1040060 | 1040060 | 2021-02-17 | Medina | Texas | 48325 | 4527 | 87 |
1036142 | 1036142 | 2021-02-16 | Medina | Ohio | 39103 | 12954 | 213 |
1036815 | 1036815 | 2021-02-16 | Medina | Texas | 48325 | 4527 | 87 |
1032897 | 1032897 | 2021-02-15 | Medina | Ohio | 39103 | 12905 | 212 |
1033570 | 1033570 | 2021-02-15 | Medina | Texas | 48325 | 4527 | 87 |
1029651 | 1029651 | 2021-02-14 | Medina | Ohio | 39103 | 12868 | 211 |
1030324 | 1030324 | 2021-02-14 | Medina | Texas | 48325 | 4527 | 87 |
1026404 | 1026404 | 2021-02-13 | Medina | Ohio | 39103 | 12835 | 211 |
1027077 | 1027077 | 2021-02-13 | Medina | Texas | 48325 | 4527 | 85 |
1023159 | 1023159 | 2021-02-12 | Medina | Ohio | 39103 | 12783 | 204 |
1023832 | 1023832 | 2021-02-12 | Medina | Texas | 48325 | 4514 | 83 |
1019914 | 1019914 | 2021-02-11 | Medina | Ohio | 39103 | 12728 | 190 |
1020587 | 1020587 | 2021-02-11 | Medina | Texas | 48325 | 3848 | 83 |
1016669 | 1016669 | 2021-02-10 | Medina | Ohio | 39103 | 12689 | 185 |
1017342 | 1017342 | 2021-02-10 | Medina | Texas | 48325 | 3848 | 83 |
1013424 | 1013424 | 2021-02-09 | Medina | Ohio | 39103 | 12641 | 183 |
1014097 | 1014097 | 2021-02-09 | Medina | Texas | 48325 | 3848 | 81 |
1010179 | 1010179 | 2021-02-08 | Medina | Ohio | 39103 | 12592 | 181 |
1010852 | 1010852 | 2021-02-08 | Medina | Texas | 48325 | 3843 | 81 |
1006933 | 1006933 | 2021-02-07 | Medina | Ohio | 39103 | 12557 | 181 |
1007606 | 1007606 | 2021-02-07 | Medina | Texas | 48325 | 3843 | 79 |
1003687 | 1003687 | 2021-02-06 | Medina | Ohio | 39103 | 12522 | 177 |
1004360 | 1004360 | 2021-02-06 | Medina | Texas | 48325 | 3843 | 79 |
1000441 | 1000441 | 2021-02-05 | Medina | Ohio | 39103 | 12464 | 177 |
1001114 | 1001114 | 2021-02-05 | Medina | Texas | 48325 | 3843 | 78 |
997195 | 997195 | 2021-02-04 | Medina | Ohio | 39103 | 12417 | 177 |
997868 | 997868 | 2021-02-04 | Medina | Texas | 48325 | 3842 | 76 |
993949 | 993949 | 2021-02-03 | Medina | Ohio | 39103 | 12341 | 177 |
994622 | 994622 | 2021-02-03 | Medina | Texas | 48325 | 3841 | 75 |
990703 | 990703 | 2021-02-02 | Medina | Ohio | 39103 | 12285 | 177 |
991376 | 991376 | 2021-02-02 | Medina | Texas | 48325 | 3772 | 75 |
987457 | 987457 | 2021-02-01 | Medina | Ohio | 39103 | 12189 | 177 |
988130 | 988130 | 2021-02-01 | Medina | Texas | 48325 | 3727 | 74 |
984210 | 984210 | 2021-01-31 | Medina | Ohio | 39103 | 12138 | 173 |
984883 | 984883 | 2021-01-31 | Medina | Texas | 48325 | 3727 | 74 |
980963 | 980963 | 2021-01-30 | Medina | Ohio | 39103 | 12096 | 173 |
981636 | 981636 | 2021-01-30 | Medina | Texas | 48325 | 3727 | 74 |
977717 | 977717 | 2021-01-29 | Medina | Ohio | 39103 | 12027 | 173 |
978390 | 978390 | 2021-01-29 | Medina | Texas | 48325 | 3683 | 74 |
974472 | 974472 | 2021-01-28 | Medina | Ohio | 39103 | 11961 | 171 |
975145 | 975145 | 2021-01-28 | Medina | Texas | 48325 | 3609 | 72 |
971227 | 971227 | 2021-01-27 | Medina | Ohio | 39103 | 11865 | 169 |
971900 | 971900 | 2021-01-27 | Medina | Texas | 48325 | 3562 | 72 |
967982 | 967982 | 2021-01-26 | Medina | Ohio | 39103 | 11798 | 169 |
968655 | 968655 | 2021-01-26 | Medina | Texas | 48325 | 3506 | 70 |
964738 | 964738 | 2021-01-25 | Medina | Ohio | 39103 | 11732 | 168 |
965411 | 965411 | 2021-01-25 | Medina | Texas | 48325 | 3448 | 70 |
961493 | 961493 | 2021-01-24 | Medina | Ohio | 39103 | 11666 | 168 |
962166 | 962166 | 2021-01-24 | Medina | Texas | 48325 | 3464 | 70 |
958248 | 958248 | 2021-01-23 | Medina | Ohio | 39103 | 11591 | 168 |
958921 | 958921 | 2021-01-23 | Medina | Texas | 48325 | 3464 | 69 |
955002 | 955002 | 2021-01-22 | Medina | Ohio | 39103 | 11504 | 168 |
955675 | 955675 | 2021-01-22 | Medina | Texas | 48325 | 3433 | 66 |
951757 | 951757 | 2021-01-21 | Medina | Ohio | 39103 | 11439 | 167 |
952430 | 952430 | 2021-01-21 | Medina | Texas | 48325 | 3362 | 64 |
948512 | 948512 | 2021-01-20 | Medina | Ohio | 39103 | 11364 | 167 |
949185 | 949185 | 2021-01-20 | Medina | Texas | 48325 | 3326 | 64 |
945266 | 945266 | 2021-01-19 | Medina | Ohio | 39103 | 11286 | 165 |
945939 | 945939 | 2021-01-19 | Medina | Texas | 48325 | 3253 | 62 |
942019 | 942019 | 2021-01-18 | Medina | Ohio | 39103 | 11191 | 165 |
942692 | 942692 | 2021-01-18 | Medina | Texas | 48325 | 3253 | 61 |
938774 | 938774 | 2021-01-17 | Medina | Ohio | 39103 | 11128 | 165 |
939447 | 939447 | 2021-01-17 | Medina | Texas | 48325 | 3253 | 61 |
935529 | 935529 | 2021-01-16 | Medina | Ohio | 39103 | 11033 | 165 |
936202 | 936202 | 2021-01-16 | Medina | Texas | 48325 | 3253 | 61 |
932284 | 932284 | 2021-01-15 | Medina | Ohio | 39103 | 10949 | 165 |
932957 | 932957 | 2021-01-15 | Medina | Texas | 48325 | 3200 | 59 |
929039 | 929039 | 2021-01-14 | Medina | Ohio | 39103 | 10815 | 164 |
929712 | 929712 | 2021-01-14 | Medina | Texas | 48325 | 3157 | 59 |
925794 | 925794 | 2021-01-13 | Medina | Ohio | 39103 | 10737 | 155 |
926467 | 926467 | 2021-01-13 | Medina | Texas | 48325 | 3117 | 58 |
922548 | 922548 | 2021-01-12 | Medina | Ohio | 39103 | 10632 | 155 |
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);