ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 19043 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417946 | 1417946 | 2021-06-14 | Clayton | Iowa | 19043 | 1710 | 57 |
1414700 | 1414700 | 2021-06-13 | Clayton | Iowa | 19043 | 1711 | 57 |
1411455 | 1411455 | 2021-06-12 | Clayton | Iowa | 19043 | 1710 | 57 |
1408210 | 1408210 | 2021-06-11 | Clayton | Iowa | 19043 | 1710 | 57 |
1404964 | 1404964 | 2021-06-10 | Clayton | Iowa | 19043 | 1710 | 57 |
1401719 | 1401719 | 2021-06-09 | Clayton | Iowa | 19043 | 1709 | 57 |
1398474 | 1398474 | 2021-06-08 | Clayton | Iowa | 19043 | 1709 | 57 |
1395227 | 1395227 | 2021-06-07 | Clayton | Iowa | 19043 | 1709 | 57 |
1391982 | 1391982 | 2021-06-06 | Clayton | Iowa | 19043 | 1708 | 57 |
1388737 | 1388737 | 2021-06-05 | Clayton | Iowa | 19043 | 1705 | 57 |
1385492 | 1385492 | 2021-06-04 | Clayton | Iowa | 19043 | 1705 | 57 |
1382246 | 1382246 | 2021-06-03 | Clayton | Iowa | 19043 | 1705 | 57 |
1379001 | 1379001 | 2021-06-02 | Clayton | Iowa | 19043 | 1705 | 57 |
1375755 | 1375755 | 2021-06-01 | Clayton | Iowa | 19043 | 1706 | 57 |
1372510 | 1372510 | 2021-05-31 | Clayton | Iowa | 19043 | 1705 | 56 |
1369265 | 1369265 | 2021-05-30 | Clayton | Iowa | 19043 | 1704 | 56 |
1366019 | 1366019 | 2021-05-29 | Clayton | Iowa | 19043 | 1705 | 56 |
1362773 | 1362773 | 2021-05-28 | Clayton | Iowa | 19043 | 1704 | 56 |
1359526 | 1359526 | 2021-05-27 | Clayton | Iowa | 19043 | 1704 | 56 |
1356280 | 1356280 | 2021-05-26 | Clayton | Iowa | 19043 | 1704 | 56 |
1353034 | 1353034 | 2021-05-25 | Clayton | Iowa | 19043 | 1702 | 56 |
1349788 | 1349788 | 2021-05-24 | Clayton | Iowa | 19043 | 1702 | 56 |
1346541 | 1346541 | 2021-05-23 | Clayton | Iowa | 19043 | 1702 | 56 |
1343293 | 1343293 | 2021-05-22 | Clayton | Iowa | 19043 | 1701 | 56 |
1340045 | 1340045 | 2021-05-21 | Clayton | Iowa | 19043 | 1701 | 56 |
1336798 | 1336798 | 2021-05-20 | Clayton | Iowa | 19043 | 1697 | 56 |
1333551 | 1333551 | 2021-05-19 | Clayton | Iowa | 19043 | 1697 | 56 |
1330304 | 1330304 | 2021-05-18 | Clayton | Iowa | 19043 | 1696 | 56 |
1327057 | 1327057 | 2021-05-17 | Clayton | Iowa | 19043 | 1696 | 56 |
1323811 | 1323811 | 2021-05-16 | Clayton | Iowa | 19043 | 1696 | 56 |
1320565 | 1320565 | 2021-05-15 | Clayton | Iowa | 19043 | 1696 | 56 |
1317318 | 1317318 | 2021-05-14 | Clayton | Iowa | 19043 | 1696 | 56 |
1314071 | 1314071 | 2021-05-13 | Clayton | Iowa | 19043 | 1694 | 56 |
1310824 | 1310824 | 2021-05-12 | Clayton | Iowa | 19043 | 1694 | 56 |
1307578 | 1307578 | 2021-05-11 | Clayton | Iowa | 19043 | 1694 | 56 |
1304332 | 1304332 | 2021-05-10 | Clayton | Iowa | 19043 | 1693 | 56 |
1301085 | 1301085 | 2021-05-09 | Clayton | Iowa | 19043 | 1694 | 56 |
1297838 | 1297838 | 2021-05-08 | Clayton | Iowa | 19043 | 1692 | 56 |
1294592 | 1294592 | 2021-05-07 | Clayton | Iowa | 19043 | 1692 | 56 |
1291346 | 1291346 | 2021-05-06 | Clayton | Iowa | 19043 | 1692 | 56 |
1288100 | 1288100 | 2021-05-05 | Clayton | Iowa | 19043 | 1689 | 56 |
1284854 | 1284854 | 2021-05-04 | Clayton | Iowa | 19043 | 1684 | 56 |
1281607 | 1281607 | 2021-05-03 | Clayton | Iowa | 19043 | 1683 | 56 |
1278360 | 1278360 | 2021-05-02 | Clayton | Iowa | 19043 | 1683 | 56 |
1275113 | 1275113 | 2021-05-01 | Clayton | Iowa | 19043 | 1682 | 56 |
1271866 | 1271866 | 2021-04-30 | Clayton | Iowa | 19043 | 1683 | 56 |
1268619 | 1268619 | 2021-04-29 | Clayton | Iowa | 19043 | 1682 | 56 |
1265372 | 1265372 | 2021-04-28 | Clayton | Iowa | 19043 | 1680 | 56 |
1262125 | 1262125 | 2021-04-27 | Clayton | Iowa | 19043 | 1678 | 56 |
1258878 | 1258878 | 2021-04-26 | Clayton | Iowa | 19043 | 1677 | 56 |
1255631 | 1255631 | 2021-04-25 | Clayton | Iowa | 19043 | 1675 | 56 |
1252384 | 1252384 | 2021-04-24 | Clayton | Iowa | 19043 | 1675 | 56 |
1249137 | 1249137 | 2021-04-23 | Clayton | Iowa | 19043 | 1674 | 55 |
1245890 | 1245890 | 2021-04-22 | Clayton | Iowa | 19043 | 1674 | 55 |
1242643 | 1242643 | 2021-04-21 | Clayton | Iowa | 19043 | 1673 | 55 |
1239396 | 1239396 | 2021-04-20 | Clayton | Iowa | 19043 | 1672 | 55 |
1236149 | 1236149 | 2021-04-19 | Clayton | Iowa | 19043 | 1670 | 55 |
1232902 | 1232902 | 2021-04-18 | Clayton | Iowa | 19043 | 1670 | 55 |
1229653 | 1229653 | 2021-04-17 | Clayton | Iowa | 19043 | 1670 | 55 |
1226405 | 1226405 | 2021-04-16 | Clayton | Iowa | 19043 | 1668 | 55 |
1223158 | 1223158 | 2021-04-15 | Clayton | Iowa | 19043 | 1666 | 55 |
1219910 | 1219910 | 2021-04-14 | Clayton | Iowa | 19043 | 1664 | 55 |
1216662 | 1216662 | 2021-04-13 | Clayton | Iowa | 19043 | 1658 | 55 |
1213415 | 1213415 | 2021-04-12 | Clayton | Iowa | 19043 | 1654 | 55 |
1210167 | 1210167 | 2021-04-11 | Clayton | Iowa | 19043 | 1654 | 55 |
1206918 | 1206918 | 2021-04-10 | Clayton | Iowa | 19043 | 1652 | 55 |
1203670 | 1203670 | 2021-04-09 | Clayton | Iowa | 19043 | 1652 | 55 |
1200422 | 1200422 | 2021-04-08 | Clayton | Iowa | 19043 | 1651 | 55 |
1197173 | 1197173 | 2021-04-07 | Clayton | Iowa | 19043 | 1643 | 55 |
1193925 | 1193925 | 2021-04-06 | Clayton | Iowa | 19043 | 1641 | 55 |
1190675 | 1190675 | 2021-04-05 | Clayton | Iowa | 19043 | 1638 | 55 |
1187428 | 1187428 | 2021-04-04 | Clayton | Iowa | 19043 | 1632 | 55 |
1184181 | 1184181 | 2021-04-03 | Clayton | Iowa | 19043 | 1630 | 55 |
1180934 | 1180934 | 2021-04-02 | Clayton | Iowa | 19043 | 1631 | 55 |
1177687 | 1177687 | 2021-04-01 | Clayton | Iowa | 19043 | 1628 | 55 |
1174440 | 1174440 | 2021-03-31 | Clayton | Iowa | 19043 | 1627 | 55 |
1171193 | 1171193 | 2021-03-30 | Clayton | Iowa | 19043 | 1627 | 55 |
1167945 | 1167945 | 2021-03-29 | Clayton | Iowa | 19043 | 1624 | 55 |
1164697 | 1164697 | 2021-03-28 | Clayton | Iowa | 19043 | 1623 | 55 |
1161449 | 1161449 | 2021-03-27 | Clayton | Iowa | 19043 | 1623 | 55 |
1158201 | 1158201 | 2021-03-26 | Clayton | Iowa | 19043 | 1622 | 55 |
1154954 | 1154954 | 2021-03-25 | Clayton | Iowa | 19043 | 1620 | 55 |
1151707 | 1151707 | 2021-03-24 | Clayton | Iowa | 19043 | 1618 | 55 |
1148460 | 1148460 | 2021-03-23 | Clayton | Iowa | 19043 | 1619 | 55 |
1145213 | 1145213 | 2021-03-22 | Clayton | Iowa | 19043 | 1618 | 55 |
1141966 | 1141966 | 2021-03-21 | Clayton | Iowa | 19043 | 1617 | 55 |
1138720 | 1138720 | 2021-03-20 | Clayton | Iowa | 19043 | 1617 | 55 |
1135474 | 1135474 | 2021-03-19 | Clayton | Iowa | 19043 | 1617 | 55 |
1132227 | 1132227 | 2021-03-18 | Clayton | Iowa | 19043 | 1615 | 55 |
1128979 | 1128979 | 2021-03-17 | Clayton | Iowa | 19043 | 1614 | 55 |
1125733 | 1125733 | 2021-03-16 | Clayton | Iowa | 19043 | 1613 | 55 |
1122487 | 1122487 | 2021-03-15 | Clayton | Iowa | 19043 | 1611 | 55 |
1119240 | 1119240 | 2021-03-14 | Clayton | Iowa | 19043 | 1609 | 55 |
1115993 | 1115993 | 2021-03-13 | Clayton | Iowa | 19043 | 1607 | 54 |
1112747 | 1112747 | 2021-03-12 | Clayton | Iowa | 19043 | 1605 | 54 |
1109501 | 1109501 | 2021-03-11 | Clayton | Iowa | 19043 | 1604 | 54 |
1106255 | 1106255 | 2021-03-10 | Clayton | Iowa | 19043 | 1604 | 54 |
1103009 | 1103009 | 2021-03-09 | Clayton | Iowa | 19043 | 1602 | 54 |
1099763 | 1099763 | 2021-03-08 | Clayton | Iowa | 19043 | 1602 | 54 |
1096515 | 1096515 | 2021-03-07 | Clayton | Iowa | 19043 | 1600 | 54 |
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);