ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Iowa" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417972 | 1417972 | 2021-06-14 | Iowa | Iowa | 19095 | 1498 | 24 |
1414726 | 1414726 | 2021-06-13 | Iowa | Iowa | 19095 | 1498 | 24 |
1411481 | 1411481 | 2021-06-12 | Iowa | Iowa | 19095 | 1498 | 24 |
1408236 | 1408236 | 2021-06-11 | Iowa | Iowa | 19095 | 1497 | 24 |
1404990 | 1404990 | 2021-06-10 | Iowa | Iowa | 19095 | 1497 | 24 |
1401745 | 1401745 | 2021-06-09 | Iowa | Iowa | 19095 | 1497 | 24 |
1398500 | 1398500 | 2021-06-08 | Iowa | Iowa | 19095 | 1497 | 24 |
1395253 | 1395253 | 2021-06-07 | Iowa | Iowa | 19095 | 1497 | 24 |
1392008 | 1392008 | 2021-06-06 | Iowa | Iowa | 19095 | 1497 | 24 |
1388763 | 1388763 | 2021-06-05 | Iowa | Iowa | 19095 | 1497 | 24 |
1385518 | 1385518 | 2021-06-04 | Iowa | Iowa | 19095 | 1497 | 24 |
1382272 | 1382272 | 2021-06-03 | Iowa | Iowa | 19095 | 1497 | 24 |
1379027 | 1379027 | 2021-06-02 | Iowa | Iowa | 19095 | 1497 | 24 |
1375781 | 1375781 | 2021-06-01 | Iowa | Iowa | 19095 | 1497 | 24 |
1372536 | 1372536 | 2021-05-31 | Iowa | Iowa | 19095 | 1497 | 24 |
1369291 | 1369291 | 2021-05-30 | Iowa | Iowa | 19095 | 1497 | 24 |
1366045 | 1366045 | 2021-05-29 | Iowa | Iowa | 19095 | 1497 | 24 |
1362799 | 1362799 | 2021-05-28 | Iowa | Iowa | 19095 | 1497 | 24 |
1359552 | 1359552 | 2021-05-27 | Iowa | Iowa | 19095 | 1496 | 24 |
1356306 | 1356306 | 2021-05-26 | Iowa | Iowa | 19095 | 1496 | 24 |
1353060 | 1353060 | 2021-05-25 | Iowa | Iowa | 19095 | 1494 | 24 |
1349814 | 1349814 | 2021-05-24 | Iowa | Iowa | 19095 | 1494 | 24 |
1346567 | 1346567 | 2021-05-23 | Iowa | Iowa | 19095 | 1491 | 24 |
1343319 | 1343319 | 2021-05-22 | Iowa | Iowa | 19095 | 1491 | 24 |
1340071 | 1340071 | 2021-05-21 | Iowa | Iowa | 19095 | 1491 | 24 |
1336824 | 1336824 | 2021-05-20 | Iowa | Iowa | 19095 | 1491 | 24 |
1333577 | 1333577 | 2021-05-19 | Iowa | Iowa | 19095 | 1491 | 24 |
1330330 | 1330330 | 2021-05-18 | Iowa | Iowa | 19095 | 1490 | 24 |
1327083 | 1327083 | 2021-05-17 | Iowa | Iowa | 19095 | 1489 | 24 |
1323837 | 1323837 | 2021-05-16 | Iowa | Iowa | 19095 | 1488 | 24 |
1320591 | 1320591 | 2021-05-15 | Iowa | Iowa | 19095 | 1488 | 24 |
1317344 | 1317344 | 2021-05-14 | Iowa | Iowa | 19095 | 1488 | 24 |
1314097 | 1314097 | 2021-05-13 | Iowa | Iowa | 19095 | 1487 | 24 |
1310850 | 1310850 | 2021-05-12 | Iowa | Iowa | 19095 | 1484 | 24 |
1307604 | 1307604 | 2021-05-11 | Iowa | Iowa | 19095 | 1483 | 24 |
1304358 | 1304358 | 2021-05-10 | Iowa | Iowa | 19095 | 1481 | 24 |
1301111 | 1301111 | 2021-05-09 | Iowa | Iowa | 19095 | 1482 | 24 |
1297864 | 1297864 | 2021-05-08 | Iowa | Iowa | 19095 | 1482 | 24 |
1294618 | 1294618 | 2021-05-07 | Iowa | Iowa | 19095 | 1481 | 24 |
1291372 | 1291372 | 2021-05-06 | Iowa | Iowa | 19095 | 1480 | 24 |
1288126 | 1288126 | 2021-05-05 | Iowa | Iowa | 19095 | 1480 | 24 |
1284880 | 1284880 | 2021-05-04 | Iowa | Iowa | 19095 | 1479 | 24 |
1281633 | 1281633 | 2021-05-03 | Iowa | Iowa | 19095 | 1478 | 24 |
1278386 | 1278386 | 2021-05-02 | Iowa | Iowa | 19095 | 1477 | 24 |
1275139 | 1275139 | 2021-05-01 | Iowa | Iowa | 19095 | 1476 | 24 |
1271892 | 1271892 | 2021-04-30 | Iowa | Iowa | 19095 | 1475 | 24 |
1268645 | 1268645 | 2021-04-29 | Iowa | Iowa | 19095 | 1474 | 24 |
1265398 | 1265398 | 2021-04-28 | Iowa | Iowa | 19095 | 1473 | 24 |
1262151 | 1262151 | 2021-04-27 | Iowa | Iowa | 19095 | 1472 | 24 |
1258904 | 1258904 | 2021-04-26 | Iowa | Iowa | 19095 | 1470 | 24 |
1255657 | 1255657 | 2021-04-25 | Iowa | Iowa | 19095 | 1468 | 24 |
1252410 | 1252410 | 2021-04-24 | Iowa | Iowa | 19095 | 1465 | 24 |
1249163 | 1249163 | 2021-04-23 | Iowa | Iowa | 19095 | 1465 | 24 |
1245916 | 1245916 | 2021-04-22 | Iowa | Iowa | 19095 | 1463 | 24 |
1242669 | 1242669 | 2021-04-21 | Iowa | Iowa | 19095 | 1462 | 24 |
1239422 | 1239422 | 2021-04-20 | Iowa | Iowa | 19095 | 1459 | 24 |
1236175 | 1236175 | 2021-04-19 | Iowa | Iowa | 19095 | 1457 | 24 |
1232928 | 1232928 | 2021-04-18 | Iowa | Iowa | 19095 | 1455 | 24 |
1229679 | 1229679 | 2021-04-17 | Iowa | Iowa | 19095 | 1455 | 24 |
1226431 | 1226431 | 2021-04-16 | Iowa | Iowa | 19095 | 1453 | 24 |
1223184 | 1223184 | 2021-04-15 | Iowa | Iowa | 19095 | 1453 | 24 |
1219936 | 1219936 | 2021-04-14 | Iowa | Iowa | 19095 | 1451 | 24 |
1216688 | 1216688 | 2021-04-13 | Iowa | Iowa | 19095 | 1450 | 24 |
1213441 | 1213441 | 2021-04-12 | Iowa | Iowa | 19095 | 1448 | 24 |
1210193 | 1210193 | 2021-04-11 | Iowa | Iowa | 19095 | 1446 | 24 |
1206944 | 1206944 | 2021-04-10 | Iowa | Iowa | 19095 | 1446 | 24 |
1203696 | 1203696 | 2021-04-09 | Iowa | Iowa | 19095 | 1446 | 24 |
1200448 | 1200448 | 2021-04-08 | Iowa | Iowa | 19095 | 1445 | 24 |
1197199 | 1197199 | 2021-04-07 | Iowa | Iowa | 19095 | 1444 | 24 |
1193951 | 1193951 | 2021-04-06 | Iowa | Iowa | 19095 | 1444 | 24 |
1190701 | 1190701 | 2021-04-05 | Iowa | Iowa | 19095 | 1442 | 24 |
1187454 | 1187454 | 2021-04-04 | Iowa | Iowa | 19095 | 1441 | 24 |
1184207 | 1184207 | 2021-04-03 | Iowa | Iowa | 19095 | 1441 | 24 |
1180960 | 1180960 | 2021-04-02 | Iowa | Iowa | 19095 | 1441 | 23 |
1177713 | 1177713 | 2021-04-01 | Iowa | Iowa | 19095 | 1438 | 23 |
1174466 | 1174466 | 2021-03-31 | Iowa | Iowa | 19095 | 1438 | 23 |
1171219 | 1171219 | 2021-03-30 | Iowa | Iowa | 19095 | 1437 | 23 |
1167971 | 1167971 | 2021-03-29 | Iowa | Iowa | 19095 | 1435 | 23 |
1164723 | 1164723 | 2021-03-28 | Iowa | Iowa | 19095 | 1435 | 23 |
1161475 | 1161475 | 2021-03-27 | Iowa | Iowa | 19095 | 1435 | 23 |
1158227 | 1158227 | 2021-03-26 | Iowa | Iowa | 19095 | 1434 | 23 |
1154980 | 1154980 | 2021-03-25 | Iowa | Iowa | 19095 | 1434 | 23 |
1151733 | 1151733 | 2021-03-24 | Iowa | Iowa | 19095 | 1432 | 23 |
1148486 | 1148486 | 2021-03-23 | Iowa | Iowa | 19095 | 1430 | 23 |
1145239 | 1145239 | 2021-03-22 | Iowa | Iowa | 19095 | 1430 | 23 |
1141992 | 1141992 | 2021-03-21 | Iowa | Iowa | 19095 | 1428 | 23 |
1138746 | 1138746 | 2021-03-20 | Iowa | Iowa | 19095 | 1428 | 23 |
1135500 | 1135500 | 2021-03-19 | Iowa | Iowa | 19095 | 1426 | 23 |
1132253 | 1132253 | 2021-03-18 | Iowa | Iowa | 19095 | 1426 | 23 |
1129005 | 1129005 | 2021-03-17 | Iowa | Iowa | 19095 | 1425 | 23 |
1125759 | 1125759 | 2021-03-16 | Iowa | Iowa | 19095 | 1422 | 23 |
1122513 | 1122513 | 2021-03-15 | Iowa | Iowa | 19095 | 1421 | 23 |
1119266 | 1119266 | 2021-03-14 | Iowa | Iowa | 19095 | 1419 | 23 |
1116019 | 1116019 | 2021-03-13 | Iowa | Iowa | 19095 | 1416 | 23 |
1112773 | 1112773 | 2021-03-12 | Iowa | Iowa | 19095 | 1413 | 23 |
1109527 | 1109527 | 2021-03-11 | Iowa | Iowa | 19095 | 1413 | 23 |
1106281 | 1106281 | 2021-03-10 | Iowa | Iowa | 19095 | 1410 | 23 |
1103035 | 1103035 | 2021-03-09 | Iowa | Iowa | 19095 | 1408 | 23 |
1099789 | 1099789 | 2021-03-08 | Iowa | Iowa | 19095 | 1407 | 23 |
1096541 | 1096541 | 2021-03-07 | Iowa | Iowa | 19095 | 1398 | 23 |
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);