ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39109 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1243941 | 1243941 | 2021-04-21 | Miami | Ohio | 39109 | 10568 | 214 |
1240694 | 1240694 | 2021-04-20 | Miami | Ohio | 39109 | 10556 | 214 |
1237447 | 1237447 | 2021-04-19 | Miami | Ohio | 39109 | 10548 | 214 |
1234200 | 1234200 | 2021-04-18 | Miami | Ohio | 39109 | 10541 | 214 |
1230952 | 1230952 | 2021-04-17 | Miami | Ohio | 39109 | 10536 | 214 |
1227704 | 1227704 | 2021-04-16 | Miami | Ohio | 39109 | 10525 | 214 |
1224456 | 1224456 | 2021-04-15 | Miami | Ohio | 39109 | 10511 | 212 |
1221209 | 1221209 | 2021-04-14 | Miami | Ohio | 39109 | 10500 | 212 |
1217961 | 1217961 | 2021-04-13 | Miami | Ohio | 39109 | 10484 | 212 |
1214713 | 1214713 | 2021-04-12 | Miami | Ohio | 39109 | 10480 | 211 |
1211466 | 1211466 | 2021-04-11 | Miami | Ohio | 39109 | 10470 | 211 |
1208217 | 1208217 | 2021-04-10 | Miami | Ohio | 39109 | 10455 | 211 |
1204969 | 1204969 | 2021-04-09 | Miami | Ohio | 39109 | 10436 | 211 |
1201721 | 1201721 | 2021-04-08 | Miami | Ohio | 39109 | 10426 | 210 |
1198472 | 1198472 | 2021-04-07 | Miami | Ohio | 39109 | 10407 | 210 |
1195223 | 1195223 | 2021-04-06 | Miami | Ohio | 39109 | 10394 | 210 |
1191975 | 1191975 | 2021-04-05 | Miami | Ohio | 39109 | 10386 | 206 |
1188726 | 1188726 | 2021-04-04 | Miami | Ohio | 39109 | 10373 | 206 |
1185479 | 1185479 | 2021-04-03 | Miami | Ohio | 39109 | 10373 | 206 |
1182232 | 1182232 | 2021-04-02 | Miami | Ohio | 39109 | 10355 | 206 |
1178985 | 1178985 | 2021-04-01 | Miami | Ohio | 39109 | 10346 | 206 |
1175738 | 1175738 | 2021-03-31 | Miami | Ohio | 39109 | 10335 | 206 |
1172491 | 1172491 | 2021-03-30 | Miami | Ohio | 39109 | 10326 | 206 |
1169244 | 1169244 | 2021-03-29 | Miami | Ohio | 39109 | 10310 | 205 |
1165996 | 1165996 | 2021-03-28 | Miami | Ohio | 39109 | 10305 | 205 |
1162748 | 1162748 | 2021-03-27 | Miami | Ohio | 39109 | 10298 | 205 |
1159499 | 1159499 | 2021-03-26 | Miami | Ohio | 39109 | 10281 | 205 |
1156252 | 1156252 | 2021-03-25 | Miami | Ohio | 39109 | 10262 | 204 |
1153005 | 1153005 | 2021-03-24 | Miami | Ohio | 39109 | 10256 | 204 |
1149758 | 1149758 | 2021-03-23 | Miami | Ohio | 39109 | 10242 | 204 |
1146511 | 1146511 | 2021-03-22 | Miami | Ohio | 39109 | 10221 | 203 |
1143264 | 1143264 | 2021-03-21 | Miami | Ohio | 39109 | 10208 | 203 |
1140017 | 1140017 | 2021-03-20 | Miami | Ohio | 39109 | 10201 | 203 |
1136771 | 1136771 | 2021-03-19 | Miami | Ohio | 39109 | 10196 | 203 |
1133525 | 1133525 | 2021-03-18 | Miami | Ohio | 39109 | 10183 | 200 |
1130277 | 1130277 | 2021-03-17 | Miami | Ohio | 39109 | 10164 | 200 |
1127030 | 1127030 | 2021-03-16 | Miami | Ohio | 39109 | 10151 | 200 |
1123784 | 1123784 | 2021-03-15 | Miami | Ohio | 39109 | 10130 | 199 |
1120538 | 1120538 | 2021-03-14 | Miami | Ohio | 39109 | 10116 | 199 |
1117291 | 1117291 | 2021-03-13 | Miami | Ohio | 39109 | 10112 | 199 |
1114044 | 1114044 | 2021-03-12 | Miami | Ohio | 39109 | 10102 | 199 |
1110798 | 1110798 | 2021-03-11 | Miami | Ohio | 39109 | 10090 | 198 |
1107552 | 1107552 | 2021-03-10 | Miami | Ohio | 39109 | 10083 | 198 |
1104306 | 1104306 | 2021-03-09 | Miami | Ohio | 39109 | 10077 | 198 |
1101060 | 1101060 | 2021-03-08 | Miami | Ohio | 39109 | 10068 | 194 |
1097814 | 1097814 | 2021-03-07 | Miami | Ohio | 39109 | 10065 | 194 |
1094566 | 1094566 | 2021-03-06 | Miami | Ohio | 39109 | 10059 | 194 |
1091320 | 1091320 | 2021-03-05 | Miami | Ohio | 39109 | 10055 | 194 |
1088075 | 1088075 | 2021-03-04 | Miami | Ohio | 39109 | 10048 | 189 |
1084830 | 1084830 | 2021-03-03 | Miami | Ohio | 39109 | 10035 | 189 |
1081584 | 1081584 | 2021-03-02 | Miami | Ohio | 39109 | 10022 | 189 |
1078338 | 1078338 | 2021-03-01 | Miami | Ohio | 39109 | 10011 | 190 |
1075093 | 1075093 | 2021-02-28 | Miami | Ohio | 39109 | 10006 | 190 |
1071847 | 1071847 | 2021-02-27 | Miami | Ohio | 39109 | 9999 | 189 |
1068601 | 1068601 | 2021-02-26 | Miami | Ohio | 39109 | 9984 | 187 |
1065356 | 1065356 | 2021-02-25 | Miami | Ohio | 39109 | 9969 | 184 |
1062112 | 1062112 | 2021-02-24 | Miami | Ohio | 39109 | 9954 | 179 |
1058866 | 1058866 | 2021-02-23 | Miami | Ohio | 39109 | 9937 | 179 |
1055620 | 1055620 | 2021-02-22 | Miami | Ohio | 39109 | 9917 | 178 |
1052374 | 1052374 | 2021-02-21 | Miami | Ohio | 39109 | 9910 | 177 |
1049127 | 1049127 | 2021-02-20 | Miami | Ohio | 39109 | 9897 | 177 |
1045880 | 1045880 | 2021-02-19 | Miami | Ohio | 39109 | 9884 | 177 |
1042635 | 1042635 | 2021-02-18 | Miami | Ohio | 39109 | 9877 | 177 |
1039390 | 1039390 | 2021-02-17 | Miami | Ohio | 39109 | 9853 | 175 |
1036145 | 1036145 | 2021-02-16 | Miami | Ohio | 39109 | 9851 | 175 |
1032900 | 1032900 | 2021-02-15 | Miami | Ohio | 39109 | 9834 | 175 |
1029654 | 1029654 | 2021-02-14 | Miami | Ohio | 39109 | 9817 | 173 |
1026407 | 1026407 | 2021-02-13 | Miami | Ohio | 39109 | 9801 | 172 |
1023162 | 1023162 | 2021-02-12 | Miami | Ohio | 39109 | 9779 | 157 |
1019917 | 1019917 | 2021-02-11 | Miami | Ohio | 39109 | 9766 | 132 |
1016672 | 1016672 | 2021-02-10 | Miami | Ohio | 39109 | 9741 | 127 |
1013427 | 1013427 | 2021-02-09 | Miami | Ohio | 39109 | 9719 | 126 |
1010182 | 1010182 | 2021-02-08 | Miami | Ohio | 39109 | 9684 | 122 |
1006936 | 1006936 | 2021-02-07 | Miami | Ohio | 39109 | 9673 | 122 |
1003690 | 1003690 | 2021-02-06 | Miami | Ohio | 39109 | 9649 | 122 |
1000444 | 1000444 | 2021-02-05 | Miami | Ohio | 39109 | 9621 | 80 |
997198 | 997198 | 2021-02-04 | Miami | Ohio | 39109 | 9588 | 78 |
993952 | 993952 | 2021-02-03 | Miami | Ohio | 39109 | 9556 | 74 |
990706 | 990706 | 2021-02-02 | Miami | Ohio | 39109 | 9527 | 73 |
987460 | 987460 | 2021-02-01 | Miami | Ohio | 39109 | 9489 | 73 |
984213 | 984213 | 2021-01-31 | Miami | Ohio | 39109 | 9468 | 73 |
980966 | 980966 | 2021-01-30 | Miami | Ohio | 39109 | 9430 | 73 |
977720 | 977720 | 2021-01-29 | Miami | Ohio | 39109 | 9386 | 73 |
974475 | 974475 | 2021-01-28 | Miami | Ohio | 39109 | 9355 | 73 |
971230 | 971230 | 2021-01-27 | Miami | Ohio | 39109 | 9321 | 73 |
967985 | 967985 | 2021-01-26 | Miami | Ohio | 39109 | 9272 | 73 |
964741 | 964741 | 2021-01-25 | Miami | Ohio | 39109 | 9244 | 73 |
961496 | 961496 | 2021-01-24 | Miami | Ohio | 39109 | 9210 | 73 |
958251 | 958251 | 2021-01-23 | Miami | Ohio | 39109 | 9168 | 73 |
955005 | 955005 | 2021-01-22 | Miami | Ohio | 39109 | 9113 | 73 |
951760 | 951760 | 2021-01-21 | Miami | Ohio | 39109 | 9073 | 73 |
948515 | 948515 | 2021-01-20 | Miami | Ohio | 39109 | 8999 | 73 |
945269 | 945269 | 2021-01-19 | Miami | Ohio | 39109 | 8952 | 73 |
942022 | 942022 | 2021-01-18 | Miami | Ohio | 39109 | 8905 | 73 |
938777 | 938777 | 2021-01-17 | Miami | Ohio | 39109 | 8865 | 73 |
935532 | 935532 | 2021-01-16 | Miami | Ohio | 39109 | 8801 | 73 |
932287 | 932287 | 2021-01-15 | Miami | Ohio | 39109 | 8736 | 73 |
929042 | 929042 | 2021-01-14 | Miami | Ohio | 39109 | 8673 | 73 |
925797 | 925797 | 2021-01-13 | Miami | Ohio | 39109 | 8621 | 73 |
922551 | 922551 | 2021-01-12 | Miami | Ohio | 39109 | 8553 | 73 |
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);