ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-09-30" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 1
- Adams 1
- Allamakee 1
- Appanoose 1
- Audubon 1
- Benton 1
- Black Hawk 1
- Boone 1
- Bremer 1
- Buchanan 1
- Buena Vista 1
- Butler 1
- Calhoun 1
- Carroll 1
- Cass 1
- Cedar 1
- Cerro Gordo 1
- Cherokee 1
- Chickasaw 1
- Clarke 1
- Clay 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Davis 1
- Decatur 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- …
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1768673 | 1768673 | 2021-09-30 | Adair | Iowa | 19001 | 990 | 34 |
1768674 | 1768674 | 2021-09-30 | Adams | Iowa | 19003 | 455 | 4 |
1768675 | 1768675 | 2021-09-30 | Allamakee | Iowa | 19005 | 1846 | 52 |
1768676 | 1768676 | 2021-09-30 | Appanoose | Iowa | 19007 | 1635 | 50 |
1768677 | 1768677 | 2021-09-30 | Audubon | Iowa | 19009 | 615 | 14 |
1768678 | 1768678 | 2021-09-30 | Benton | Iowa | 19011 | 3366 | 56 |
1768679 | 1768679 | 2021-09-30 | Black Hawk | Iowa | 19013 | 19659 | 344 |
1768680 | 1768680 | 2021-09-30 | Boone | Iowa | 19015 | 3290 | 36 |
1768681 | 1768681 | 2021-09-30 | Bremer | Iowa | 19017 | 3392 | 66 |
1768682 | 1768682 | 2021-09-30 | Buchanan | Iowa | 19019 | 2570 | 38 |
1768683 | 1768683 | 2021-09-30 | Buena Vista | Iowa | 19021 | 4825 | 43 |
1768684 | 1768684 | 2021-09-30 | Butler | Iowa | 19023 | 1967 | 37 |
1768685 | 1768685 | 2021-09-30 | Calhoun | Iowa | 19025 | 1784 | 13 |
1768686 | 1768686 | 2021-09-30 | Carroll | Iowa | 19027 | 3324 | 53 |
1768687 | 1768687 | 2021-09-30 | Cass | Iowa | 19029 | 1734 | 56 |
1768688 | 1768688 | 2021-09-30 | Cedar | Iowa | 19031 | 2349 | 25 |
1768689 | 1768689 | 2021-09-30 | Cerro Gordo | Iowa | 19033 | 6550 | 106 |
1768690 | 1768690 | 2021-09-30 | Cherokee | Iowa | 19035 | 1875 | 40 |
1768691 | 1768691 | 2021-09-30 | Chickasaw | Iowa | 19037 | 1466 | 18 |
1768692 | 1768692 | 2021-09-30 | Clarke | Iowa | 19039 | 1344 | 27 |
1768693 | 1768693 | 2021-09-30 | Clay | Iowa | 19041 | 2657 | 29 |
1768694 | 1768694 | 2021-09-30 | Clayton | Iowa | 19043 | 2033 | 58 |
1768695 | 1768695 | 2021-09-30 | Clinton | Iowa | 19045 | 6510 | 99 |
1768696 | 1768696 | 2021-09-30 | Crawford | Iowa | 19047 | 3283 | 45 |
1768697 | 1768697 | 2021-09-30 | Dallas | Iowa | 19049 | 13384 | 102 |
1768698 | 1768698 | 2021-09-30 | Davis | Iowa | 19051 | 1081 | 25 |
1768699 | 1768699 | 2021-09-30 | Decatur | Iowa | 19053 | 779 | 11 |
1768700 | 1768700 | 2021-09-30 | Delaware | Iowa | 19055 | 2442 | 44 |
1768701 | 1768701 | 2021-09-30 | Des Moines | Iowa | 19057 | 6367 | 87 |
1768702 | 1768702 | 2021-09-30 | Dickinson | Iowa | 19059 | 2860 | 50 |
1768703 | 1768703 | 2021-09-30 | Dubuque | Iowa | 19061 | 15022 | 224 |
1768704 | 1768704 | 2021-09-30 | Emmet | Iowa | 19063 | 1567 | 41 |
1768705 | 1768705 | 2021-09-30 | Fayette | Iowa | 19065 | 2368 | 45 |
1768706 | 1768706 | 2021-09-30 | Floyd | Iowa | 19067 | 2050 | 42 |
1768707 | 1768707 | 2021-09-30 | Franklin | Iowa | 19069 | 1562 | 24 |
1768708 | 1768708 | 2021-09-30 | Fremont | Iowa | 19071 | 787 | 11 |
1768709 | 1768709 | 2021-09-30 | Greene | Iowa | 19073 | 1072 | 12 |
1768710 | 1768710 | 2021-09-30 | Grundy | Iowa | 19075 | 1639 | 36 |
1768711 | 1768711 | 2021-09-30 | Guthrie | Iowa | 19077 | 1470 | 32 |
1768712 | 1768712 | 2021-09-30 | Hamilton | Iowa | 19079 | 2222 | 53 |
1768713 | 1768713 | 2021-09-30 | Hancock | Iowa | 19081 | 1765 | 37 |
1768714 | 1768714 | 2021-09-30 | Hardin | Iowa | 19083 | 2539 | 47 |
1768715 | 1768715 | 2021-09-30 | Harrison | Iowa | 19085 | 2092 | 76 |
1768716 | 1768716 | 2021-09-30 | Henry | Iowa | 19087 | 3622 | 42 |
1768717 | 1768717 | 2021-09-30 | Howard | Iowa | 19089 | 1206 | 22 |
1768718 | 1768718 | 2021-09-30 | Humboldt | Iowa | 19091 | 1561 | 26 |
1768719 | 1768719 | 2021-09-30 | Ida | Iowa | 19093 | 1128 | 39 |
1768720 | 1768720 | 2021-09-30 | Iowa | Iowa | 19095 | 1923 | 27 |
1768721 | 1768721 | 2021-09-30 | Jackson | Iowa | 19097 | 2603 | 44 |
1768722 | 1768722 | 2021-09-30 | Jasper | Iowa | 19099 | 5472 | 76 |
1768723 | 1768723 | 2021-09-30 | Jefferson | Iowa | 19101 | 1868 | 38 |
1768724 | 1768724 | 2021-09-30 | Johnson | Iowa | 19103 | 17358 | 95 |
1768725 | 1768725 | 2021-09-30 | Jones | Iowa | 19105 | 3482 | 59 |
1768726 | 1768726 | 2021-09-30 | Keokuk | Iowa | 19107 | 1292 | 33 |
1768727 | 1768727 | 2021-09-30 | Kossuth | Iowa | 19109 | 2625 | 71 |
1768728 | 1768728 | 2021-09-30 | Lee | Iowa | 19111 | 5457 | 84 |
1768729 | 1768729 | 2021-09-30 | Linn | Iowa | 19113 | 27427 | 367 |
1768730 | 1768730 | 2021-09-30 | Louisa | Iowa | 19115 | 1658 | 51 |
1768731 | 1768731 | 2021-09-30 | Lucas | Iowa | 19117 | 1045 | 23 |
1768732 | 1768732 | 2021-09-30 | Lyon | Iowa | 19119 | 1829 | 41 |
1768733 | 1768733 | 2021-09-30 | Madison | Iowa | 19121 | 2047 | 21 |
1768734 | 1768734 | 2021-09-30 | Mahaska | Iowa | 19123 | 2941 | 56 |
1768735 | 1768735 | 2021-09-30 | Marion | Iowa | 19125 | 4768 | 86 |
1768736 | 1768736 | 2021-09-30 | Marshall | Iowa | 19127 | 6083 | 82 |
1768737 | 1768737 | 2021-09-30 | Mills | Iowa | 19129 | 1914 | 25 |
1768738 | 1768738 | 2021-09-30 | Mitchell | Iowa | 19131 | 1544 | 43 |
1768739 | 1768739 | 2021-09-30 | Monona | Iowa | 19133 | 1017 | 34 |
1768740 | 1768740 | 2021-09-30 | Monroe | Iowa | 19135 | 1235 | 33 |
1768741 | 1768741 | 2021-09-30 | Montgomery | Iowa | 19137 | 1313 | 40 |
1768742 | 1768742 | 2021-09-30 | Muscatine | Iowa | 19139 | 6119 | 111 |
1768743 | 1768743 | 2021-09-30 | O'Brien | Iowa | 19141 | 2156 | 63 |
1768744 | 1768744 | 2021-09-30 | Osceola | Iowa | 19143 | 865 | 17 |
1768745 | 1768745 | 2021-09-30 | Page | Iowa | 19145 | 2306 | 24 |
1768746 | 1768746 | 2021-09-30 | Palo Alto | Iowa | 19147 | 1371 | 29 |
1768747 | 1768747 | 2021-09-30 | Plymouth | Iowa | 19149 | 4488 | 86 |
1768748 | 1768748 | 2021-09-30 | Pocahontas | Iowa | 19151 | 1044 | 23 |
1768749 | 1768749 | 2021-09-30 | Polk | Iowa | 19153 | 71219 | 695 |
1768750 | 1768750 | 2021-09-30 | Pottawattamie | Iowa | 19155 | 13607 | 190 |
1768751 | 1768751 | 2021-09-30 | Poweshiek | Iowa | 19157 | 1959 | 37 |
1768752 | 1768752 | 2021-09-30 | Ringgold | Iowa | 19159 | 641 | 27 |
1768753 | 1768753 | 2021-09-30 | Sac | Iowa | 19161 | 1512 | 23 |
1768754 | 1768754 | 2021-09-30 | Scott | Iowa | 19163 | 23799 | 266 |
1768755 | 1768755 | 2021-09-30 | Shelby | Iowa | 19165 | 1627 | 39 |
1768756 | 1768756 | 2021-09-30 | Sioux | Iowa | 19167 | 5523 | 76 |
1768757 | 1768757 | 2021-09-30 | Story | Iowa | 19169 | 12371 | 48 |
1768758 | 1768758 | 2021-09-30 | Tama | Iowa | 19171 | 2548 | 75 |
1768759 | 1768759 | 2021-09-30 | Taylor | Iowa | 19173 | 751 | 12 |
1768760 | 1768760 | 2021-09-30 | Union | Iowa | 19175 | 1539 | 37 |
1768761 | 1768761 | 2021-09-30 | Unknown | Iowa | 15 | 0 | |
1768762 | 1768762 | 2021-09-30 | Van Buren | Iowa | 19177 | 776 | 21 |
1768763 | 1768763 | 2021-09-30 | Wapello | Iowa | 19179 | 5460 | 130 |
1768764 | 1768764 | 2021-09-30 | Warren | Iowa | 19181 | 7270 | 95 |
1768765 | 1768765 | 2021-09-30 | Washington | Iowa | 19183 | 3451 | 54 |
1768766 | 1768766 | 2021-09-30 | Wayne | Iowa | 19185 | 680 | 23 |
1768767 | 1768767 | 2021-09-30 | Webster | Iowa | 19187 | 6646 | 106 |
1768768 | 1768768 | 2021-09-30 | Winnebago | Iowa | 19189 | 1769 | 31 |
1768769 | 1768769 | 2021-09-30 | Winneshiek | Iowa | 19191 | 2235 | 37 |
1768770 | 1768770 | 2021-09-30 | Woodbury | Iowa | 19193 | 18019 | 239 |
1768771 | 1768771 | 2021-09-30 | Worth | Iowa | 19195 | 1001 | 8 |
1768772 | 1768772 | 2021-09-30 | Wright | Iowa | 19197 | 2285 | 41 |
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);