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 |
---|---|---|---|---|---|---|---|
1419238 | 1419238 | 2021-06-14 | Marion | Ohio | 39101 | 8635 | 138 |
1415993 | 1415993 | 2021-06-13 | Marion | Ohio | 39101 | 8635 | 138 |
1412747 | 1412747 | 2021-06-12 | Marion | Ohio | 39101 | 8633 | 138 |
1409502 | 1409502 | 2021-06-11 | Marion | Ohio | 39101 | 8631 | 138 |
1406257 | 1406257 | 2021-06-10 | Marion | Ohio | 39101 | 8630 | 137 |
1403011 | 1403011 | 2021-06-09 | Marion | Ohio | 39101 | 8627 | 137 |
1399766 | 1399766 | 2021-06-08 | Marion | Ohio | 39101 | 8626 | 137 |
1396521 | 1396521 | 2021-06-07 | Marion | Ohio | 39101 | 8625 | 137 |
1393274 | 1393274 | 2021-06-06 | Marion | Ohio | 39101 | 8624 | 137 |
1390029 | 1390029 | 2021-06-05 | Marion | Ohio | 39101 | 8625 | 137 |
1386784 | 1386784 | 2021-06-04 | Marion | Ohio | 39101 | 8624 | 137 |
1383539 | 1383539 | 2021-06-03 | Marion | Ohio | 39101 | 8621 | 138 |
1380293 | 1380293 | 2021-06-02 | Marion | Ohio | 39101 | 8622 | 138 |
1377048 | 1377048 | 2021-06-01 | Marion | Ohio | 39101 | 8617 | 137 |
1373802 | 1373802 | 2021-05-31 | Marion | Ohio | 39101 | 8614 | 137 |
1370557 | 1370557 | 2021-05-30 | Marion | Ohio | 39101 | 8614 | 137 |
1367311 | 1367311 | 2021-05-29 | Marion | Ohio | 39101 | 8614 | 137 |
1364065 | 1364065 | 2021-05-28 | Marion | Ohio | 39101 | 8610 | 137 |
1360819 | 1360819 | 2021-05-27 | Marion | Ohio | 39101 | 8609 | 137 |
1357573 | 1357573 | 2021-05-26 | Marion | Ohio | 39101 | 8605 | 137 |
1354327 | 1354327 | 2021-05-25 | Marion | Ohio | 39101 | 8597 | 137 |
1351081 | 1351081 | 2021-05-24 | Marion | Ohio | 39101 | 8585 | 136 |
1347835 | 1347835 | 2021-05-23 | Marion | Ohio | 39101 | 8583 | 136 |
1344587 | 1344587 | 2021-05-22 | Marion | Ohio | 39101 | 8580 | 136 |
1341339 | 1341339 | 2021-05-21 | Marion | Ohio | 39101 | 8575 | 136 |
1338091 | 1338091 | 2021-05-20 | Marion | Ohio | 39101 | 8573 | 136 |
1334844 | 1334844 | 2021-05-19 | Marion | Ohio | 39101 | 8567 | 136 |
1331597 | 1331597 | 2021-05-18 | Marion | Ohio | 39101 | 8565 | 136 |
1328350 | 1328350 | 2021-05-17 | Marion | Ohio | 39101 | 8561 | 136 |
1325104 | 1325104 | 2021-05-16 | Marion | Ohio | 39101 | 8560 | 136 |
1321858 | 1321858 | 2021-05-15 | Marion | Ohio | 39101 | 8558 | 136 |
1318612 | 1318612 | 2021-05-14 | Marion | Ohio | 39101 | 8553 | 136 |
1315364 | 1315364 | 2021-05-13 | Marion | Ohio | 39101 | 8550 | 135 |
1312118 | 1312118 | 2021-05-12 | Marion | Ohio | 39101 | 8544 | 135 |
1308871 | 1308871 | 2021-05-11 | Marion | Ohio | 39101 | 8539 | 135 |
1305625 | 1305625 | 2021-05-10 | Marion | Ohio | 39101 | 8532 | 135 |
1302379 | 1302379 | 2021-05-09 | Marion | Ohio | 39101 | 8527 | 135 |
1299131 | 1299131 | 2021-05-08 | Marion | Ohio | 39101 | 8523 | 135 |
1295885 | 1295885 | 2021-05-07 | Marion | Ohio | 39101 | 8514 | 135 |
1292639 | 1292639 | 2021-05-06 | Marion | Ohio | 39101 | 8511 | 135 |
1289393 | 1289393 | 2021-05-05 | Marion | Ohio | 39101 | 8502 | 135 |
1286147 | 1286147 | 2021-05-04 | Marion | Ohio | 39101 | 8494 | 135 |
1282901 | 1282901 | 2021-05-03 | Marion | Ohio | 39101 | 8485 | 135 |
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 |
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);