ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39089 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419232 | 1419232 | 2021-06-14 | Licking | Ohio | 39089 | 16649 | 222 |
1415987 | 1415987 | 2021-06-13 | Licking | Ohio | 39089 | 16645 | 222 |
1412741 | 1412741 | 2021-06-12 | Licking | Ohio | 39089 | 16643 | 222 |
1409496 | 1409496 | 2021-06-11 | Licking | Ohio | 39089 | 16639 | 222 |
1406251 | 1406251 | 2021-06-10 | Licking | Ohio | 39089 | 16636 | 220 |
1403005 | 1403005 | 2021-06-09 | Licking | Ohio | 39089 | 16629 | 220 |
1399760 | 1399760 | 2021-06-08 | Licking | Ohio | 39089 | 16625 | 220 |
1396515 | 1396515 | 2021-06-07 | Licking | Ohio | 39089 | 16621 | 218 |
1393268 | 1393268 | 2021-06-06 | Licking | Ohio | 39089 | 16617 | 218 |
1390023 | 1390023 | 2021-06-05 | Licking | Ohio | 39089 | 16615 | 218 |
1386778 | 1386778 | 2021-06-04 | Licking | Ohio | 39089 | 16611 | 218 |
1383533 | 1383533 | 2021-06-03 | Licking | Ohio | 39089 | 16606 | 217 |
1380287 | 1380287 | 2021-06-02 | Licking | Ohio | 39089 | 16597 | 217 |
1377042 | 1377042 | 2021-06-01 | Licking | Ohio | 39089 | 16597 | 218 |
1373796 | 1373796 | 2021-05-31 | Licking | Ohio | 39089 | 16583 | 218 |
1370551 | 1370551 | 2021-05-30 | Licking | Ohio | 39089 | 16583 | 218 |
1367305 | 1367305 | 2021-05-29 | Licking | Ohio | 39089 | 16580 | 218 |
1364059 | 1364059 | 2021-05-28 | Licking | Ohio | 39089 | 16578 | 218 |
1360813 | 1360813 | 2021-05-27 | Licking | Ohio | 39089 | 16574 | 214 |
1357567 | 1357567 | 2021-05-26 | Licking | Ohio | 39089 | 16570 | 214 |
1354321 | 1354321 | 2021-05-25 | Licking | Ohio | 39089 | 16563 | 214 |
1351075 | 1351075 | 2021-05-24 | Licking | Ohio | 39089 | 16556 | 214 |
1347829 | 1347829 | 2021-05-23 | Licking | Ohio | 39089 | 16550 | 214 |
1344581 | 1344581 | 2021-05-22 | Licking | Ohio | 39089 | 16543 | 214 |
1341333 | 1341333 | 2021-05-21 | Licking | Ohio | 39089 | 16539 | 214 |
1338085 | 1338085 | 2021-05-20 | Licking | Ohio | 39089 | 16524 | 214 |
1334838 | 1334838 | 2021-05-19 | Licking | Ohio | 39089 | 16506 | 214 |
1331591 | 1331591 | 2021-05-18 | Licking | Ohio | 39089 | 16494 | 214 |
1328344 | 1328344 | 2021-05-17 | Licking | Ohio | 39089 | 16488 | 212 |
1325098 | 1325098 | 2021-05-16 | Licking | Ohio | 39089 | 16480 | 212 |
1321852 | 1321852 | 2021-05-15 | Licking | Ohio | 39089 | 16473 | 212 |
1318606 | 1318606 | 2021-05-14 | Licking | Ohio | 39089 | 16470 | 212 |
1315358 | 1315358 | 2021-05-13 | Licking | Ohio | 39089 | 16455 | 212 |
1312112 | 1312112 | 2021-05-12 | Licking | Ohio | 39089 | 16450 | 212 |
1308865 | 1308865 | 2021-05-11 | Licking | Ohio | 39089 | 16436 | 212 |
1305619 | 1305619 | 2021-05-10 | Licking | Ohio | 39089 | 16426 | 212 |
1302373 | 1302373 | 2021-05-09 | Licking | Ohio | 39089 | 16420 | 212 |
1299125 | 1299125 | 2021-05-08 | Licking | Ohio | 39089 | 16418 | 212 |
1295879 | 1295879 | 2021-05-07 | Licking | Ohio | 39089 | 16410 | 212 |
1292633 | 1292633 | 2021-05-06 | Licking | Ohio | 39089 | 16396 | 210 |
1289387 | 1289387 | 2021-05-05 | Licking | Ohio | 39089 | 16384 | 210 |
1286141 | 1286141 | 2021-05-04 | Licking | Ohio | 39089 | 16373 | 210 |
1282895 | 1282895 | 2021-05-03 | Licking | Ohio | 39089 | 16366 | 209 |
1279648 | 1279648 | 2021-05-02 | Licking | Ohio | 39089 | 16352 | 209 |
1276401 | 1276401 | 2021-05-01 | Licking | Ohio | 39089 | 16346 | 209 |
1273154 | 1273154 | 2021-04-30 | Licking | Ohio | 39089 | 16334 | 209 |
1269907 | 1269907 | 2021-04-29 | Licking | Ohio | 39089 | 16323 | 208 |
1266660 | 1266660 | 2021-04-28 | Licking | Ohio | 39089 | 16300 | 208 |
1263413 | 1263413 | 2021-04-27 | Licking | Ohio | 39089 | 16284 | 208 |
1260166 | 1260166 | 2021-04-26 | Licking | Ohio | 39089 | 16264 | 208 |
1256919 | 1256919 | 2021-04-25 | Licking | Ohio | 39089 | 16249 | 208 |
1253672 | 1253672 | 2021-04-24 | Licking | Ohio | 39089 | 16242 | 208 |
1250425 | 1250425 | 2021-04-23 | Licking | Ohio | 39089 | 16230 | 208 |
1247178 | 1247178 | 2021-04-22 | Licking | Ohio | 39089 | 16206 | 207 |
1243931 | 1243931 | 2021-04-21 | Licking | Ohio | 39089 | 16185 | 207 |
1240684 | 1240684 | 2021-04-20 | Licking | Ohio | 39089 | 16160 | 207 |
1237437 | 1237437 | 2021-04-19 | Licking | Ohio | 39089 | 16149 | 207 |
1234190 | 1234190 | 2021-04-18 | Licking | Ohio | 39089 | 16130 | 207 |
1230942 | 1230942 | 2021-04-17 | Licking | Ohio | 39089 | 16124 | 207 |
1227694 | 1227694 | 2021-04-16 | Licking | Ohio | 39089 | 16109 | 207 |
1224446 | 1224446 | 2021-04-15 | Licking | Ohio | 39089 | 16089 | 206 |
1221199 | 1221199 | 2021-04-14 | Licking | Ohio | 39089 | 16066 | 206 |
1217951 | 1217951 | 2021-04-13 | Licking | Ohio | 39089 | 16046 | 206 |
1214703 | 1214703 | 2021-04-12 | Licking | Ohio | 39089 | 16012 | 205 |
1211456 | 1211456 | 2021-04-11 | Licking | Ohio | 39089 | 15996 | 205 |
1208207 | 1208207 | 2021-04-10 | Licking | Ohio | 39089 | 15970 | 205 |
1204959 | 1204959 | 2021-04-09 | Licking | Ohio | 39089 | 15948 | 205 |
1201711 | 1201711 | 2021-04-08 | Licking | Ohio | 39089 | 15919 | 203 |
1198462 | 1198462 | 2021-04-07 | Licking | Ohio | 39089 | 15899 | 203 |
1195213 | 1195213 | 2021-04-06 | Licking | Ohio | 39089 | 15865 | 203 |
1191965 | 1191965 | 2021-04-05 | Licking | Ohio | 39089 | 15820 | 202 |
1188716 | 1188716 | 2021-04-04 | Licking | Ohio | 39089 | 15788 | 202 |
1185469 | 1185469 | 2021-04-03 | Licking | Ohio | 39089 | 15788 | 202 |
1182222 | 1182222 | 2021-04-02 | Licking | Ohio | 39089 | 15760 | 202 |
1178975 | 1178975 | 2021-04-01 | Licking | Ohio | 39089 | 15740 | 202 |
1175728 | 1175728 | 2021-03-31 | Licking | Ohio | 39089 | 15698 | 202 |
1172481 | 1172481 | 2021-03-30 | Licking | Ohio | 39089 | 15662 | 202 |
1169234 | 1169234 | 2021-03-29 | Licking | Ohio | 39089 | 15610 | 202 |
1165986 | 1165986 | 2021-03-28 | Licking | Ohio | 39089 | 15589 | 202 |
1162738 | 1162738 | 2021-03-27 | Licking | Ohio | 39089 | 15575 | 202 |
1159489 | 1159489 | 2021-03-26 | Licking | Ohio | 39089 | 15549 | 202 |
1156242 | 1156242 | 2021-03-25 | Licking | Ohio | 39089 | 15514 | 199 |
1152995 | 1152995 | 2021-03-24 | Licking | Ohio | 39089 | 15494 | 199 |
1149748 | 1149748 | 2021-03-23 | Licking | Ohio | 39089 | 15464 | 199 |
1146501 | 1146501 | 2021-03-22 | Licking | Ohio | 39089 | 15444 | 199 |
1143254 | 1143254 | 2021-03-21 | Licking | Ohio | 39089 | 15426 | 199 |
1140007 | 1140007 | 2021-03-20 | Licking | Ohio | 39089 | 15413 | 199 |
1136761 | 1136761 | 2021-03-19 | Licking | Ohio | 39089 | 15391 | 199 |
1133515 | 1133515 | 2021-03-18 | Licking | Ohio | 39089 | 15367 | 198 |
1130267 | 1130267 | 2021-03-17 | Licking | Ohio | 39089 | 15320 | 198 |
1127020 | 1127020 | 2021-03-16 | Licking | Ohio | 39089 | 15294 | 198 |
1123774 | 1123774 | 2021-03-15 | Licking | Ohio | 39089 | 15272 | 195 |
1120528 | 1120528 | 2021-03-14 | Licking | Ohio | 39089 | 15266 | 195 |
1117281 | 1117281 | 2021-03-13 | Licking | Ohio | 39089 | 15249 | 195 |
1114034 | 1114034 | 2021-03-12 | Licking | Ohio | 39089 | 15228 | 195 |
1110788 | 1110788 | 2021-03-11 | Licking | Ohio | 39089 | 15200 | 194 |
1107542 | 1107542 | 2021-03-10 | Licking | Ohio | 39089 | 15176 | 194 |
1104296 | 1104296 | 2021-03-09 | Licking | Ohio | 39089 | 15144 | 194 |
1101050 | 1101050 | 2021-03-08 | Licking | Ohio | 39089 | 15118 | 194 |
1097804 | 1097804 | 2021-03-07 | Licking | Ohio | 39089 | 15096 | 194 |
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);