ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Pickaway" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419252 | 1419252 | 2021-06-14 | Pickaway | Ohio | 39129 | 8652 | 122 |
1416007 | 1416007 | 2021-06-13 | Pickaway | Ohio | 39129 | 8649 | 122 |
1412761 | 1412761 | 2021-06-12 | Pickaway | Ohio | 39129 | 8646 | 122 |
1409516 | 1409516 | 2021-06-11 | Pickaway | Ohio | 39129 | 8647 | 122 |
1406271 | 1406271 | 2021-06-10 | Pickaway | Ohio | 39129 | 8643 | 122 |
1403025 | 1403025 | 2021-06-09 | Pickaway | Ohio | 39129 | 8643 | 122 |
1399780 | 1399780 | 2021-06-08 | Pickaway | Ohio | 39129 | 8642 | 122 |
1396535 | 1396535 | 2021-06-07 | Pickaway | Ohio | 39129 | 8642 | 122 |
1393288 | 1393288 | 2021-06-06 | Pickaway | Ohio | 39129 | 8640 | 122 |
1390043 | 1390043 | 2021-06-05 | Pickaway | Ohio | 39129 | 8640 | 122 |
1386798 | 1386798 | 2021-06-04 | Pickaway | Ohio | 39129 | 8639 | 122 |
1383553 | 1383553 | 2021-06-03 | Pickaway | Ohio | 39129 | 8635 | 122 |
1380307 | 1380307 | 2021-06-02 | Pickaway | Ohio | 39129 | 8632 | 122 |
1377062 | 1377062 | 2021-06-01 | Pickaway | Ohio | 39129 | 8632 | 122 |
1373816 | 1373816 | 2021-05-31 | Pickaway | Ohio | 39129 | 8629 | 122 |
1370571 | 1370571 | 2021-05-30 | Pickaway | Ohio | 39129 | 8629 | 122 |
1367325 | 1367325 | 2021-05-29 | Pickaway | Ohio | 39129 | 8626 | 122 |
1364079 | 1364079 | 2021-05-28 | Pickaway | Ohio | 39129 | 8624 | 122 |
1360833 | 1360833 | 2021-05-27 | Pickaway | Ohio | 39129 | 8622 | 121 |
1357587 | 1357587 | 2021-05-26 | Pickaway | Ohio | 39129 | 8619 | 121 |
1354341 | 1354341 | 2021-05-25 | Pickaway | Ohio | 39129 | 8617 | 121 |
1351095 | 1351095 | 2021-05-24 | Pickaway | Ohio | 39129 | 8616 | 121 |
1347849 | 1347849 | 2021-05-23 | Pickaway | Ohio | 39129 | 8615 | 121 |
1344601 | 1344601 | 2021-05-22 | Pickaway | Ohio | 39129 | 8613 | 121 |
1341353 | 1341353 | 2021-05-21 | Pickaway | Ohio | 39129 | 8610 | 121 |
1338105 | 1338105 | 2021-05-20 | Pickaway | Ohio | 39129 | 8608 | 121 |
1334858 | 1334858 | 2021-05-19 | Pickaway | Ohio | 39129 | 8606 | 121 |
1331611 | 1331611 | 2021-05-18 | Pickaway | Ohio | 39129 | 8601 | 121 |
1328364 | 1328364 | 2021-05-17 | Pickaway | Ohio | 39129 | 8596 | 121 |
1325118 | 1325118 | 2021-05-16 | Pickaway | Ohio | 39129 | 8595 | 121 |
1321872 | 1321872 | 2021-05-15 | Pickaway | Ohio | 39129 | 8593 | 121 |
1318626 | 1318626 | 2021-05-14 | Pickaway | Ohio | 39129 | 8589 | 121 |
1315378 | 1315378 | 2021-05-13 | Pickaway | Ohio | 39129 | 8589 | 121 |
1312132 | 1312132 | 2021-05-12 | Pickaway | Ohio | 39129 | 8584 | 121 |
1308885 | 1308885 | 2021-05-11 | Pickaway | Ohio | 39129 | 8582 | 121 |
1305639 | 1305639 | 2021-05-10 | Pickaway | Ohio | 39129 | 8575 | 121 |
1302393 | 1302393 | 2021-05-09 | Pickaway | Ohio | 39129 | 8571 | 121 |
1299145 | 1299145 | 2021-05-08 | Pickaway | Ohio | 39129 | 8564 | 121 |
1295899 | 1295899 | 2021-05-07 | Pickaway | Ohio | 39129 | 8551 | 121 |
1292653 | 1292653 | 2021-05-06 | Pickaway | Ohio | 39129 | 8547 | 121 |
1289407 | 1289407 | 2021-05-05 | Pickaway | Ohio | 39129 | 8540 | 121 |
1286161 | 1286161 | 2021-05-04 | Pickaway | Ohio | 39129 | 8527 | 121 |
1282915 | 1282915 | 2021-05-03 | Pickaway | Ohio | 39129 | 8521 | 121 |
1279668 | 1279668 | 2021-05-02 | Pickaway | Ohio | 39129 | 8517 | 121 |
1276421 | 1276421 | 2021-05-01 | Pickaway | Ohio | 39129 | 8515 | 121 |
1273174 | 1273174 | 2021-04-30 | Pickaway | Ohio | 39129 | 8512 | 121 |
1269927 | 1269927 | 2021-04-29 | Pickaway | Ohio | 39129 | 8510 | 121 |
1266680 | 1266680 | 2021-04-28 | Pickaway | Ohio | 39129 | 8505 | 121 |
1263433 | 1263433 | 2021-04-27 | Pickaway | Ohio | 39129 | 8490 | 121 |
1260186 | 1260186 | 2021-04-26 | Pickaway | Ohio | 39129 | 8480 | 121 |
1256939 | 1256939 | 2021-04-25 | Pickaway | Ohio | 39129 | 8471 | 121 |
1253692 | 1253692 | 2021-04-24 | Pickaway | Ohio | 39129 | 8470 | 121 |
1250445 | 1250445 | 2021-04-23 | Pickaway | Ohio | 39129 | 8465 | 121 |
1247198 | 1247198 | 2021-04-22 | Pickaway | Ohio | 39129 | 8456 | 121 |
1243951 | 1243951 | 2021-04-21 | Pickaway | Ohio | 39129 | 8454 | 121 |
1240704 | 1240704 | 2021-04-20 | Pickaway | Ohio | 39129 | 8444 | 121 |
1237457 | 1237457 | 2021-04-19 | Pickaway | Ohio | 39129 | 8439 | 121 |
1234210 | 1234210 | 2021-04-18 | Pickaway | Ohio | 39129 | 8436 | 121 |
1230962 | 1230962 | 2021-04-17 | Pickaway | Ohio | 39129 | 8436 | 121 |
1227714 | 1227714 | 2021-04-16 | Pickaway | Ohio | 39129 | 8429 | 121 |
1224466 | 1224466 | 2021-04-15 | Pickaway | Ohio | 39129 | 8421 | 120 |
1221219 | 1221219 | 2021-04-14 | Pickaway | Ohio | 39129 | 8414 | 120 |
1217971 | 1217971 | 2021-04-13 | Pickaway | Ohio | 39129 | 8407 | 120 |
1214723 | 1214723 | 2021-04-12 | Pickaway | Ohio | 39129 | 8402 | 120 |
1211476 | 1211476 | 2021-04-11 | Pickaway | Ohio | 39129 | 8394 | 120 |
1208227 | 1208227 | 2021-04-10 | Pickaway | Ohio | 39129 | 8388 | 120 |
1204979 | 1204979 | 2021-04-09 | Pickaway | Ohio | 39129 | 8386 | 120 |
1201731 | 1201731 | 2021-04-08 | Pickaway | Ohio | 39129 | 8381 | 120 |
1198482 | 1198482 | 2021-04-07 | Pickaway | Ohio | 39129 | 8369 | 120 |
1195233 | 1195233 | 2021-04-06 | Pickaway | Ohio | 39129 | 8355 | 120 |
1191985 | 1191985 | 2021-04-05 | Pickaway | Ohio | 39129 | 8347 | 119 |
1188736 | 1188736 | 2021-04-04 | Pickaway | Ohio | 39129 | 8331 | 119 |
1185489 | 1185489 | 2021-04-03 | Pickaway | Ohio | 39129 | 8331 | 119 |
1182242 | 1182242 | 2021-04-02 | Pickaway | Ohio | 39129 | 8315 | 119 |
1178995 | 1178995 | 2021-04-01 | Pickaway | Ohio | 39129 | 8311 | 119 |
1175748 | 1175748 | 2021-03-31 | Pickaway | Ohio | 39129 | 8296 | 119 |
1172501 | 1172501 | 2021-03-30 | Pickaway | Ohio | 39129 | 8282 | 119 |
1169254 | 1169254 | 2021-03-29 | Pickaway | Ohio | 39129 | 8274 | 118 |
1166006 | 1166006 | 2021-03-28 | Pickaway | Ohio | 39129 | 8270 | 118 |
1162758 | 1162758 | 2021-03-27 | Pickaway | Ohio | 39129 | 8268 | 118 |
1159509 | 1159509 | 2021-03-26 | Pickaway | Ohio | 39129 | 8265 | 118 |
1156262 | 1156262 | 2021-03-25 | Pickaway | Ohio | 39129 | 8252 | 116 |
1153015 | 1153015 | 2021-03-24 | Pickaway | Ohio | 39129 | 8245 | 116 |
1149768 | 1149768 | 2021-03-23 | Pickaway | Ohio | 39129 | 8233 | 116 |
1146521 | 1146521 | 2021-03-22 | Pickaway | Ohio | 39129 | 8221 | 116 |
1143274 | 1143274 | 2021-03-21 | Pickaway | Ohio | 39129 | 8217 | 116 |
1140027 | 1140027 | 2021-03-20 | Pickaway | Ohio | 39129 | 8215 | 116 |
1136781 | 1136781 | 2021-03-19 | Pickaway | Ohio | 39129 | 8198 | 116 |
1133535 | 1133535 | 2021-03-18 | Pickaway | Ohio | 39129 | 8185 | 114 |
1130287 | 1130287 | 2021-03-17 | Pickaway | Ohio | 39129 | 8179 | 114 |
1127040 | 1127040 | 2021-03-16 | Pickaway | Ohio | 39129 | 8174 | 114 |
1123794 | 1123794 | 2021-03-15 | Pickaway | Ohio | 39129 | 8162 | 112 |
1120548 | 1120548 | 2021-03-14 | Pickaway | Ohio | 39129 | 8157 | 112 |
1117301 | 1117301 | 2021-03-13 | Pickaway | Ohio | 39129 | 8154 | 112 |
1114054 | 1114054 | 2021-03-12 | Pickaway | Ohio | 39129 | 8142 | 112 |
1110808 | 1110808 | 2021-03-11 | Pickaway | Ohio | 39129 | 8125 | 112 |
1107562 | 1107562 | 2021-03-10 | Pickaway | Ohio | 39129 | 8118 | 112 |
1104316 | 1104316 | 2021-03-09 | Pickaway | Ohio | 39129 | 8109 | 112 |
1101070 | 1101070 | 2021-03-08 | Pickaway | Ohio | 39129 | 8099 | 111 |
1097824 | 1097824 | 2021-03-07 | Pickaway | Ohio | 39129 | 8096 | 111 |
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);