ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 19019 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193913 | 1193913 | 2021-04-06 | Buchanan | Iowa | 19019 | 1862 | 31 |
1190663 | 1190663 | 2021-04-05 | Buchanan | Iowa | 19019 | 1861 | 31 |
1187416 | 1187416 | 2021-04-04 | Buchanan | Iowa | 19019 | 1860 | 31 |
1184169 | 1184169 | 2021-04-03 | Buchanan | Iowa | 19019 | 1856 | 31 |
1180922 | 1180922 | 2021-04-02 | Buchanan | Iowa | 19019 | 1851 | 31 |
1177675 | 1177675 | 2021-04-01 | Buchanan | Iowa | 19019 | 1848 | 31 |
1174428 | 1174428 | 2021-03-31 | Buchanan | Iowa | 19019 | 1843 | 31 |
1171181 | 1171181 | 2021-03-30 | Buchanan | Iowa | 19019 | 1841 | 31 |
1167933 | 1167933 | 2021-03-29 | Buchanan | Iowa | 19019 | 1837 | 31 |
1164685 | 1164685 | 2021-03-28 | Buchanan | Iowa | 19019 | 1835 | 30 |
1161437 | 1161437 | 2021-03-27 | Buchanan | Iowa | 19019 | 1834 | 30 |
1158189 | 1158189 | 2021-03-26 | Buchanan | Iowa | 19019 | 1831 | 30 |
1154942 | 1154942 | 2021-03-25 | Buchanan | Iowa | 19019 | 1829 | 30 |
1151695 | 1151695 | 2021-03-24 | Buchanan | Iowa | 19019 | 1828 | 30 |
1148448 | 1148448 | 2021-03-23 | Buchanan | Iowa | 19019 | 1823 | 30 |
1145201 | 1145201 | 2021-03-22 | Buchanan | Iowa | 19019 | 1821 | 30 |
1141954 | 1141954 | 2021-03-21 | Buchanan | Iowa | 19019 | 1820 | 30 |
1138708 | 1138708 | 2021-03-20 | Buchanan | Iowa | 19019 | 1818 | 30 |
1135462 | 1135462 | 2021-03-19 | Buchanan | Iowa | 19019 | 1815 | 30 |
1132215 | 1132215 | 2021-03-18 | Buchanan | Iowa | 19019 | 1808 | 30 |
1128967 | 1128967 | 2021-03-17 | Buchanan | Iowa | 19019 | 1802 | 30 |
1125721 | 1125721 | 2021-03-16 | Buchanan | Iowa | 19019 | 1800 | 30 |
1122475 | 1122475 | 2021-03-15 | Buchanan | Iowa | 19019 | 1799 | 30 |
1119228 | 1119228 | 2021-03-14 | Buchanan | Iowa | 19019 | 1797 | 30 |
1115981 | 1115981 | 2021-03-13 | Buchanan | Iowa | 19019 | 1797 | 30 |
1112735 | 1112735 | 2021-03-12 | Buchanan | Iowa | 19019 | 1796 | 30 |
1109489 | 1109489 | 2021-03-11 | Buchanan | Iowa | 19019 | 1790 | 30 |
1106243 | 1106243 | 2021-03-10 | Buchanan | Iowa | 19019 | 1789 | 30 |
1102997 | 1102997 | 2021-03-09 | Buchanan | Iowa | 19019 | 1785 | 29 |
1099751 | 1099751 | 2021-03-08 | Buchanan | Iowa | 19019 | 1780 | 29 |
1096503 | 1096503 | 2021-03-07 | Buchanan | Iowa | 19019 | 1775 | 29 |
1093257 | 1093257 | 2021-03-06 | Buchanan | Iowa | 19019 | 1775 | 29 |
1090011 | 1090011 | 2021-03-05 | Buchanan | Iowa | 19019 | 1775 | 29 |
1086766 | 1086766 | 2021-03-04 | Buchanan | Iowa | 19019 | 1770 | 29 |
1083520 | 1083520 | 2021-03-03 | Buchanan | Iowa | 19019 | 1765 | 29 |
1080274 | 1080274 | 2021-03-02 | Buchanan | Iowa | 19019 | 1759 | 29 |
1077029 | 1077029 | 2021-03-01 | Buchanan | Iowa | 19019 | 1755 | 29 |
1073783 | 1073783 | 2021-02-28 | Buchanan | Iowa | 19019 | 1750 | 29 |
1070537 | 1070537 | 2021-02-27 | Buchanan | Iowa | 19019 | 1750 | 29 |
1067292 | 1067292 | 2021-02-26 | Buchanan | Iowa | 19019 | 1750 | 29 |
1064047 | 1064047 | 2021-02-25 | Buchanan | Iowa | 19019 | 1747 | 30 |
1060802 | 1060802 | 2021-02-24 | Buchanan | Iowa | 19019 | 1732 | 30 |
1057556 | 1057556 | 2021-02-23 | Buchanan | Iowa | 19019 | 1732 | 28 |
1054310 | 1054310 | 2021-02-22 | Buchanan | Iowa | 19019 | 1732 | 28 |
1051063 | 1051063 | 2021-02-21 | Buchanan | Iowa | 19019 | 1732 | 27 |
1047816 | 1047816 | 2021-02-20 | Buchanan | Iowa | 19019 | 1732 | 27 |
1044571 | 1044571 | 2021-02-19 | Buchanan | Iowa | 19019 | 1732 | 27 |
1041326 | 1041326 | 2021-02-18 | Buchanan | Iowa | 19019 | 1730 | 27 |
1038081 | 1038081 | 2021-02-17 | Buchanan | Iowa | 19019 | 1727 | 27 |
1034836 | 1034836 | 2021-02-16 | Buchanan | Iowa | 19019 | 1725 | 26 |
1031590 | 1031590 | 2021-02-15 | Buchanan | Iowa | 19019 | 1722 | 26 |
1028343 | 1028343 | 2021-02-14 | Buchanan | Iowa | 19019 | 1720 | 26 |
1025098 | 1025098 | 2021-02-13 | Buchanan | Iowa | 19019 | 1718 | 26 |
1021853 | 1021853 | 2021-02-12 | Buchanan | Iowa | 19019 | 1711 | 26 |
1018608 | 1018608 | 2021-02-11 | Buchanan | Iowa | 19019 | 1704 | 26 |
1015363 | 1015363 | 2021-02-10 | Buchanan | Iowa | 19019 | 1702 | 26 |
1012118 | 1012118 | 2021-02-09 | Buchanan | Iowa | 19019 | 1696 | 26 |
1008872 | 1008872 | 2021-02-08 | Buchanan | Iowa | 19019 | 1690 | 26 |
1005626 | 1005626 | 2021-02-07 | Buchanan | Iowa | 19019 | 1688 | 26 |
1002380 | 1002380 | 2021-02-06 | Buchanan | Iowa | 19019 | 1685 | 26 |
999134 | 999134 | 2021-02-05 | Buchanan | Iowa | 19019 | 1684 | 26 |
995888 | 995888 | 2021-02-04 | Buchanan | Iowa | 19019 | 1683 | 25 |
992642 | 992642 | 2021-02-03 | Buchanan | Iowa | 19019 | 1674 | 25 |
989396 | 989396 | 2021-02-02 | Buchanan | Iowa | 19019 | 1669 | 24 |
986149 | 986149 | 2021-02-01 | Buchanan | Iowa | 19019 | 1661 | 24 |
982902 | 982902 | 2021-01-31 | Buchanan | Iowa | 19019 | 1653 | 24 |
979656 | 979656 | 2021-01-30 | Buchanan | Iowa | 19019 | 1652 | 24 |
976410 | 976410 | 2021-01-29 | Buchanan | Iowa | 19019 | 1644 | 24 |
973165 | 973165 | 2021-01-28 | Buchanan | Iowa | 19019 | 1642 | 24 |
969920 | 969920 | 2021-01-27 | Buchanan | Iowa | 19019 | 1640 | 24 |
966676 | 966676 | 2021-01-26 | Buchanan | Iowa | 19019 | 1629 | 24 |
963431 | 963431 | 2021-01-25 | Buchanan | Iowa | 19019 | 1623 | 24 |
960186 | 960186 | 2021-01-24 | Buchanan | Iowa | 19019 | 1622 | 24 |
956940 | 956940 | 2021-01-23 | Buchanan | Iowa | 19019 | 1620 | 24 |
953695 | 953695 | 2021-01-22 | Buchanan | Iowa | 19019 | 1616 | 24 |
950450 | 950450 | 2021-01-21 | Buchanan | Iowa | 19019 | 1610 | 23 |
947204 | 947204 | 2021-01-20 | Buchanan | Iowa | 19019 | 1604 | 23 |
943957 | 943957 | 2021-01-19 | Buchanan | Iowa | 19019 | 1599 | 23 |
940712 | 940712 | 2021-01-18 | Buchanan | Iowa | 19019 | 1591 | 23 |
937467 | 937467 | 2021-01-17 | Buchanan | Iowa | 19019 | 1583 | 23 |
934222 | 934222 | 2021-01-16 | Buchanan | Iowa | 19019 | 1580 | 23 |
930977 | 930977 | 2021-01-15 | Buchanan | Iowa | 19019 | 1578 | 20 |
927732 | 927732 | 2021-01-14 | Buchanan | Iowa | 19019 | 1569 | 20 |
924486 | 924486 | 2021-01-13 | Buchanan | Iowa | 19019 | 1554 | 20 |
921241 | 921241 | 2021-01-12 | Buchanan | Iowa | 19019 | 1548 | 20 |
917996 | 917996 | 2021-01-11 | Buchanan | Iowa | 19019 | 1543 | 19 |
914751 | 914751 | 2021-01-10 | Buchanan | Iowa | 19019 | 1538 | 19 |
911506 | 911506 | 2021-01-09 | Buchanan | Iowa | 19019 | 1526 | 19 |
908261 | 908261 | 2021-01-08 | Buchanan | Iowa | 19019 | 1522 | 19 |
905015 | 905015 | 2021-01-07 | Buchanan | Iowa | 19019 | 1509 | 17 |
901770 | 901770 | 2021-01-06 | Buchanan | Iowa | 19019 | 1496 | 17 |
898525 | 898525 | 2021-01-05 | Buchanan | Iowa | 19019 | 1487 | 17 |
895280 | 895280 | 2021-01-04 | Buchanan | Iowa | 19019 | 1472 | 17 |
892033 | 892033 | 2021-01-03 | Buchanan | Iowa | 19019 | 1462 | 17 |
888787 | 888787 | 2021-01-02 | Buchanan | Iowa | 19019 | 1458 | 17 |
885541 | 885541 | 2021-01-01 | Buchanan | Iowa | 19019 | 1445 | 16 |
882296 | 882296 | 2020-12-31 | Buchanan | Iowa | 19019 | 1441 | 16 |
879051 | 879051 | 2020-12-30 | Buchanan | Iowa | 19019 | 1439 | 16 |
875806 | 875806 | 2020-12-29 | Buchanan | Iowa | 19019 | 1434 | 16 |
872561 | 872561 | 2020-12-28 | Buchanan | Iowa | 19019 | 1414 | 16 |
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);