ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Harrison" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193946 | 1193946 | 2021-04-06 | Harrison | Iowa | 19085 | 1728 | 73 |
1190696 | 1190696 | 2021-04-05 | Harrison | Iowa | 19085 | 1727 | 73 |
1187449 | 1187449 | 2021-04-04 | Harrison | Iowa | 19085 | 1725 | 73 |
1184202 | 1184202 | 2021-04-03 | Harrison | Iowa | 19085 | 1724 | 73 |
1180955 | 1180955 | 2021-04-02 | Harrison | Iowa | 19085 | 1720 | 71 |
1177708 | 1177708 | 2021-04-01 | Harrison | Iowa | 19085 | 1710 | 71 |
1174461 | 1174461 | 2021-03-31 | Harrison | Iowa | 19085 | 1709 | 71 |
1171214 | 1171214 | 2021-03-30 | Harrison | Iowa | 19085 | 1709 | 71 |
1167966 | 1167966 | 2021-03-29 | Harrison | Iowa | 19085 | 1709 | 71 |
1164718 | 1164718 | 2021-03-28 | Harrison | Iowa | 19085 | 1708 | 71 |
1161470 | 1161470 | 2021-03-27 | Harrison | Iowa | 19085 | 1708 | 71 |
1158222 | 1158222 | 2021-03-26 | Harrison | Iowa | 19085 | 1705 | 71 |
1154975 | 1154975 | 2021-03-25 | Harrison | Iowa | 19085 | 1706 | 71 |
1151728 | 1151728 | 2021-03-24 | Harrison | Iowa | 19085 | 1704 | 71 |
1148481 | 1148481 | 2021-03-23 | Harrison | Iowa | 19085 | 1703 | 70 |
1145234 | 1145234 | 2021-03-22 | Harrison | Iowa | 19085 | 1703 | 70 |
1141987 | 1141987 | 2021-03-21 | Harrison | Iowa | 19085 | 1700 | 70 |
1138741 | 1138741 | 2021-03-20 | Harrison | Iowa | 19085 | 1699 | 70 |
1135495 | 1135495 | 2021-03-19 | Harrison | Iowa | 19085 | 1695 | 70 |
1132248 | 1132248 | 2021-03-18 | Harrison | Iowa | 19085 | 1692 | 70 |
1129000 | 1129000 | 2021-03-17 | Harrison | Iowa | 19085 | 1691 | 70 |
1125754 | 1125754 | 2021-03-16 | Harrison | Iowa | 19085 | 1691 | 70 |
1122508 | 1122508 | 2021-03-15 | Harrison | Iowa | 19085 | 1688 | 70 |
1119261 | 1119261 | 2021-03-14 | Harrison | Iowa | 19085 | 1685 | 70 |
1116014 | 1116014 | 2021-03-13 | Harrison | Iowa | 19085 | 1686 | 70 |
1112768 | 1112768 | 2021-03-12 | Harrison | Iowa | 19085 | 1684 | 70 |
1109522 | 1109522 | 2021-03-11 | Harrison | Iowa | 19085 | 1682 | 70 |
1106276 | 1106276 | 2021-03-10 | Harrison | Iowa | 19085 | 1679 | 70 |
1103030 | 1103030 | 2021-03-09 | Harrison | Iowa | 19085 | 1678 | 70 |
1099784 | 1099784 | 2021-03-08 | Harrison | Iowa | 19085 | 1678 | 70 |
1096536 | 1096536 | 2021-03-07 | Harrison | Iowa | 19085 | 1674 | 70 |
1093290 | 1093290 | 2021-03-06 | Harrison | Iowa | 19085 | 1674 | 70 |
1090044 | 1090044 | 2021-03-05 | Harrison | Iowa | 19085 | 1674 | 70 |
1086799 | 1086799 | 2021-03-04 | Harrison | Iowa | 19085 | 1674 | 69 |
1083553 | 1083553 | 2021-03-03 | Harrison | Iowa | 19085 | 1671 | 69 |
1080307 | 1080307 | 2021-03-02 | Harrison | Iowa | 19085 | 1669 | 69 |
1077062 | 1077062 | 2021-03-01 | Harrison | Iowa | 19085 | 1669 | 69 |
1073816 | 1073816 | 2021-02-28 | Harrison | Iowa | 19085 | 1664 | 69 |
1070570 | 1070570 | 2021-02-27 | Harrison | Iowa | 19085 | 1664 | 69 |
1067325 | 1067325 | 2021-02-26 | Harrison | Iowa | 19085 | 1664 | 69 |
1064080 | 1064080 | 2021-02-25 | Harrison | Iowa | 19085 | 1663 | 69 |
1060835 | 1060835 | 2021-02-24 | Harrison | Iowa | 19085 | 1650 | 69 |
1057589 | 1057589 | 2021-02-23 | Harrison | Iowa | 19085 | 1650 | 69 |
1054343 | 1054343 | 2021-02-22 | Harrison | Iowa | 19085 | 1650 | 69 |
1051096 | 1051096 | 2021-02-21 | Harrison | Iowa | 19085 | 1650 | 68 |
1047849 | 1047849 | 2021-02-20 | Harrison | Iowa | 19085 | 1650 | 68 |
1044604 | 1044604 | 2021-02-19 | Harrison | Iowa | 19085 | 1650 | 68 |
1041359 | 1041359 | 2021-02-18 | Harrison | Iowa | 19085 | 1650 | 68 |
1038114 | 1038114 | 2021-02-17 | Harrison | Iowa | 19085 | 1650 | 68 |
1034869 | 1034869 | 2021-02-16 | Harrison | Iowa | 19085 | 1649 | 68 |
1031623 | 1031623 | 2021-02-15 | Harrison | Iowa | 19085 | 1645 | 68 |
1028376 | 1028376 | 2021-02-14 | Harrison | Iowa | 19085 | 1646 | 68 |
1025131 | 1025131 | 2021-02-13 | Harrison | Iowa | 19085 | 1645 | 68 |
1021886 | 1021886 | 2021-02-12 | Harrison | Iowa | 19085 | 1644 | 68 |
1018641 | 1018641 | 2021-02-11 | Harrison | Iowa | 19085 | 1640 | 68 |
1015396 | 1015396 | 2021-02-10 | Harrison | Iowa | 19085 | 1640 | 67 |
1012151 | 1012151 | 2021-02-09 | Harrison | Iowa | 19085 | 1637 | 67 |
1008905 | 1008905 | 2021-02-08 | Harrison | Iowa | 19085 | 1636 | 67 |
1005659 | 1005659 | 2021-02-07 | Harrison | Iowa | 19085 | 1633 | 67 |
1002413 | 1002413 | 2021-02-06 | Harrison | Iowa | 19085 | 1631 | 67 |
999167 | 999167 | 2021-02-05 | Harrison | Iowa | 19085 | 1631 | 67 |
995921 | 995921 | 2021-02-04 | Harrison | Iowa | 19085 | 1627 | 67 |
992675 | 992675 | 2021-02-03 | Harrison | Iowa | 19085 | 1625 | 67 |
989429 | 989429 | 2021-02-02 | Harrison | Iowa | 19085 | 1618 | 65 |
986182 | 986182 | 2021-02-01 | Harrison | Iowa | 19085 | 1613 | 65 |
982935 | 982935 | 2021-01-31 | Harrison | Iowa | 19085 | 1612 | 65 |
979689 | 979689 | 2021-01-30 | Harrison | Iowa | 19085 | 1610 | 65 |
976443 | 976443 | 2021-01-29 | Harrison | Iowa | 19085 | 1605 | 64 |
973198 | 973198 | 2021-01-28 | Harrison | Iowa | 19085 | 1600 | 63 |
969953 | 969953 | 2021-01-27 | Harrison | Iowa | 19085 | 1592 | 62 |
966709 | 966709 | 2021-01-26 | Harrison | Iowa | 19085 | 1591 | 62 |
963464 | 963464 | 2021-01-25 | Harrison | Iowa | 19085 | 1587 | 62 |
960219 | 960219 | 2021-01-24 | Harrison | Iowa | 19085 | 1585 | 62 |
956973 | 956973 | 2021-01-23 | Harrison | Iowa | 19085 | 1581 | 62 |
953728 | 953728 | 2021-01-22 | Harrison | Iowa | 19085 | 1579 | 62 |
950483 | 950483 | 2021-01-21 | Harrison | Iowa | 19085 | 1573 | 62 |
947237 | 947237 | 2021-01-20 | Harrison | Iowa | 19085 | 1567 | 62 |
943990 | 943990 | 2021-01-19 | Harrison | Iowa | 19085 | 1551 | 62 |
940745 | 940745 | 2021-01-18 | Harrison | Iowa | 19085 | 1548 | 62 |
937500 | 937500 | 2021-01-17 | Harrison | Iowa | 19085 | 1547 | 62 |
934255 | 934255 | 2021-01-16 | Harrison | Iowa | 19085 | 1544 | 62 |
931010 | 931010 | 2021-01-15 | Harrison | Iowa | 19085 | 1538 | 62 |
927765 | 927765 | 2021-01-14 | Harrison | Iowa | 19085 | 1529 | 61 |
924519 | 924519 | 2021-01-13 | Harrison | Iowa | 19085 | 1522 | 61 |
921274 | 921274 | 2021-01-12 | Harrison | Iowa | 19085 | 1516 | 61 |
918029 | 918029 | 2021-01-11 | Harrison | Iowa | 19085 | 1515 | 60 |
914784 | 914784 | 2021-01-10 | Harrison | Iowa | 19085 | 1509 | 60 |
911539 | 911539 | 2021-01-09 | Harrison | Iowa | 19085 | 1506 | 60 |
908294 | 908294 | 2021-01-08 | Harrison | Iowa | 19085 | 1501 | 59 |
905048 | 905048 | 2021-01-07 | Harrison | Iowa | 19085 | 1492 | 59 |
901803 | 901803 | 2021-01-06 | Harrison | Iowa | 19085 | 1482 | 59 |
898558 | 898558 | 2021-01-05 | Harrison | Iowa | 19085 | 1467 | 59 |
895313 | 895313 | 2021-01-04 | Harrison | Iowa | 19085 | 1464 | 59 |
892066 | 892066 | 2021-01-03 | Harrison | Iowa | 19085 | 1460 | 58 |
888820 | 888820 | 2021-01-02 | Harrison | Iowa | 19085 | 1458 | 58 |
885574 | 885574 | 2021-01-01 | Harrison | Iowa | 19085 | 1446 | 53 |
882329 | 882329 | 2020-12-31 | Harrison | Iowa | 19085 | 1443 | 53 |
879084 | 879084 | 2020-12-30 | Harrison | Iowa | 19085 | 1430 | 52 |
875839 | 875839 | 2020-12-29 | Harrison | Iowa | 19085 | 1412 | 52 |
872594 | 872594 | 2020-12-28 | Harrison | Iowa | 19085 | 1407 | 52 |
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);