ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39101 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279654 | 1279654 | 2021-05-02 | Marion | Ohio | 39101 | 8482 | 135 |
1276407 | 1276407 | 2021-05-01 | Marion | Ohio | 39101 | 8475 | 135 |
1273160 | 1273160 | 2021-04-30 | Marion | Ohio | 39101 | 8469 | 135 |
1269913 | 1269913 | 2021-04-29 | Marion | Ohio | 39101 | 8460 | 135 |
1266666 | 1266666 | 2021-04-28 | Marion | Ohio | 39101 | 8447 | 135 |
1263419 | 1263419 | 2021-04-27 | Marion | Ohio | 39101 | 8441 | 135 |
1260172 | 1260172 | 2021-04-26 | Marion | Ohio | 39101 | 8435 | 135 |
1256925 | 1256925 | 2021-04-25 | Marion | Ohio | 39101 | 8431 | 135 |
1253678 | 1253678 | 2021-04-24 | Marion | Ohio | 39101 | 8431 | 135 |
1250431 | 1250431 | 2021-04-23 | Marion | Ohio | 39101 | 8427 | 135 |
1247184 | 1247184 | 2021-04-22 | Marion | Ohio | 39101 | 8421 | 135 |
1243937 | 1243937 | 2021-04-21 | Marion | Ohio | 39101 | 8409 | 135 |
1240690 | 1240690 | 2021-04-20 | Marion | Ohio | 39101 | 8405 | 135 |
1237443 | 1237443 | 2021-04-19 | Marion | Ohio | 39101 | 8390 | 135 |
1234196 | 1234196 | 2021-04-18 | Marion | Ohio | 39101 | 8380 | 135 |
1230948 | 1230948 | 2021-04-17 | Marion | Ohio | 39101 | 8377 | 135 |
1227700 | 1227700 | 2021-04-16 | Marion | Ohio | 39101 | 8365 | 135 |
1224452 | 1224452 | 2021-04-15 | Marion | Ohio | 39101 | 8360 | 135 |
1221205 | 1221205 | 2021-04-14 | Marion | Ohio | 39101 | 8342 | 135 |
1217957 | 1217957 | 2021-04-13 | Marion | Ohio | 39101 | 8327 | 135 |
1214709 | 1214709 | 2021-04-12 | Marion | Ohio | 39101 | 8308 | 135 |
1211462 | 1211462 | 2021-04-11 | Marion | Ohio | 39101 | 8302 | 135 |
1208213 | 1208213 | 2021-04-10 | Marion | Ohio | 39101 | 8297 | 135 |
1204965 | 1204965 | 2021-04-09 | Marion | Ohio | 39101 | 8291 | 135 |
1201717 | 1201717 | 2021-04-08 | Marion | Ohio | 39101 | 8287 | 135 |
1198468 | 1198468 | 2021-04-07 | Marion | Ohio | 39101 | 8268 | 135 |
1195219 | 1195219 | 2021-04-06 | Marion | Ohio | 39101 | 8261 | 135 |
1191971 | 1191971 | 2021-04-05 | Marion | Ohio | 39101 | 8257 | 135 |
1188722 | 1188722 | 2021-04-04 | Marion | Ohio | 39101 | 8249 | 135 |
1185475 | 1185475 | 2021-04-03 | Marion | Ohio | 39101 | 8249 | 135 |
1182228 | 1182228 | 2021-04-02 | Marion | Ohio | 39101 | 8241 | 135 |
1178981 | 1178981 | 2021-04-01 | Marion | Ohio | 39101 | 8233 | 135 |
1175734 | 1175734 | 2021-03-31 | Marion | Ohio | 39101 | 8225 | 135 |
1172487 | 1172487 | 2021-03-30 | Marion | Ohio | 39101 | 8215 | 135 |
1169240 | 1169240 | 2021-03-29 | Marion | Ohio | 39101 | 8198 | 133 |
1165992 | 1165992 | 2021-03-28 | Marion | Ohio | 39101 | 8190 | 133 |
1162744 | 1162744 | 2021-03-27 | Marion | Ohio | 39101 | 8190 | 133 |
1159495 | 1159495 | 2021-03-26 | Marion | Ohio | 39101 | 8184 | 133 |
1156248 | 1156248 | 2021-03-25 | Marion | Ohio | 39101 | 8172 | 133 |
1153001 | 1153001 | 2021-03-24 | Marion | Ohio | 39101 | 8165 | 133 |
1149754 | 1149754 | 2021-03-23 | Marion | Ohio | 39101 | 8158 | 133 |
1146507 | 1146507 | 2021-03-22 | Marion | Ohio | 39101 | 8152 | 132 |
1143260 | 1143260 | 2021-03-21 | Marion | Ohio | 39101 | 8137 | 132 |
1140013 | 1140013 | 2021-03-20 | Marion | Ohio | 39101 | 8131 | 132 |
1136767 | 1136767 | 2021-03-19 | Marion | Ohio | 39101 | 8117 | 132 |
1133521 | 1133521 | 2021-03-18 | Marion | Ohio | 39101 | 8115 | 132 |
1130273 | 1130273 | 2021-03-17 | Marion | Ohio | 39101 | 8102 | 132 |
1127026 | 1127026 | 2021-03-16 | Marion | Ohio | 39101 | 8093 | 132 |
1123780 | 1123780 | 2021-03-15 | Marion | Ohio | 39101 | 8081 | 130 |
1120534 | 1120534 | 2021-03-14 | Marion | Ohio | 39101 | 8076 | 130 |
1117287 | 1117287 | 2021-03-13 | Marion | Ohio | 39101 | 8074 | 130 |
1114040 | 1114040 | 2021-03-12 | Marion | Ohio | 39101 | 8069 | 130 |
1110794 | 1110794 | 2021-03-11 | Marion | Ohio | 39101 | 8064 | 128 |
1107548 | 1107548 | 2021-03-10 | Marion | Ohio | 39101 | 8056 | 128 |
1104302 | 1104302 | 2021-03-09 | Marion | Ohio | 39101 | 8046 | 128 |
1101056 | 1101056 | 2021-03-08 | Marion | Ohio | 39101 | 8027 | 127 |
1097810 | 1097810 | 2021-03-07 | Marion | Ohio | 39101 | 8021 | 127 |
1094562 | 1094562 | 2021-03-06 | Marion | Ohio | 39101 | 8020 | 127 |
1091316 | 1091316 | 2021-03-05 | Marion | Ohio | 39101 | 8015 | 127 |
1088071 | 1088071 | 2021-03-04 | Marion | Ohio | 39101 | 8006 | 125 |
1084826 | 1084826 | 2021-03-03 | Marion | Ohio | 39101 | 7996 | 125 |
1081580 | 1081580 | 2021-03-02 | Marion | Ohio | 39101 | 7989 | 125 |
1078334 | 1078334 | 2021-03-01 | Marion | Ohio | 39101 | 7982 | 137 |
1075089 | 1075089 | 2021-02-28 | Marion | Ohio | 39101 | 7979 | 137 |
1071843 | 1071843 | 2021-02-27 | Marion | Ohio | 39101 | 7973 | 137 |
1068597 | 1068597 | 2021-02-26 | Marion | Ohio | 39101 | 7963 | 137 |
1065352 | 1065352 | 2021-02-25 | Marion | Ohio | 39101 | 7954 | 137 |
1062108 | 1062108 | 2021-02-24 | Marion | Ohio | 39101 | 7944 | 135 |
1058862 | 1058862 | 2021-02-23 | Marion | Ohio | 39101 | 7936 | 134 |
1055616 | 1055616 | 2021-02-22 | Marion | Ohio | 39101 | 7928 | 134 |
1052370 | 1052370 | 2021-02-21 | Marion | Ohio | 39101 | 7915 | 133 |
1049123 | 1049123 | 2021-02-20 | Marion | Ohio | 39101 | 7913 | 133 |
1045876 | 1045876 | 2021-02-19 | Marion | Ohio | 39101 | 7900 | 133 |
1042631 | 1042631 | 2021-02-18 | Marion | Ohio | 39101 | 7884 | 132 |
1039386 | 1039386 | 2021-02-17 | Marion | Ohio | 39101 | 7869 | 132 |
1036141 | 1036141 | 2021-02-16 | Marion | Ohio | 39101 | 7863 | 132 |
1032896 | 1032896 | 2021-02-15 | Marion | Ohio | 39101 | 7848 | 132 |
1029650 | 1029650 | 2021-02-14 | Marion | Ohio | 39101 | 7834 | 131 |
1026403 | 1026403 | 2021-02-13 | Marion | Ohio | 39101 | 7828 | 131 |
1023158 | 1023158 | 2021-02-12 | Marion | Ohio | 39101 | 7817 | 120 |
1019913 | 1019913 | 2021-02-11 | Marion | Ohio | 39101 | 7795 | 113 |
1016668 | 1016668 | 2021-02-10 | Marion | Ohio | 39101 | 7782 | 113 |
1013423 | 1013423 | 2021-02-09 | Marion | Ohio | 39101 | 7762 | 113 |
1010178 | 1010178 | 2021-02-08 | Marion | Ohio | 39101 | 7736 | 113 |
1006932 | 1006932 | 2021-02-07 | Marion | Ohio | 39101 | 7731 | 113 |
1003686 | 1003686 | 2021-02-06 | Marion | Ohio | 39101 | 7724 | 113 |
1000440 | 1000440 | 2021-02-05 | Marion | Ohio | 39101 | 7705 | 113 |
997194 | 997194 | 2021-02-04 | Marion | Ohio | 39101 | 7691 | 113 |
993948 | 993948 | 2021-02-03 | Marion | Ohio | 39101 | 7663 | 113 |
990702 | 990702 | 2021-02-02 | Marion | Ohio | 39101 | 7657 | 113 |
987456 | 987456 | 2021-02-01 | Marion | Ohio | 39101 | 7639 | 113 |
984209 | 984209 | 2021-01-31 | Marion | Ohio | 39101 | 7624 | 113 |
980962 | 980962 | 2021-01-30 | Marion | Ohio | 39101 | 7613 | 113 |
977716 | 977716 | 2021-01-29 | Marion | Ohio | 39101 | 7580 | 113 |
974471 | 974471 | 2021-01-28 | Marion | Ohio | 39101 | 7571 | 113 |
971226 | 971226 | 2021-01-27 | Marion | Ohio | 39101 | 7540 | 113 |
967981 | 967981 | 2021-01-26 | Marion | Ohio | 39101 | 7512 | 113 |
964737 | 964737 | 2021-01-25 | Marion | Ohio | 39101 | 7486 | 113 |
961492 | 961492 | 2021-01-24 | Marion | Ohio | 39101 | 7467 | 113 |
958247 | 958247 | 2021-01-23 | Marion | Ohio | 39101 | 7459 | 113 |
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);