ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 19103 146
- 19155 145
- 19027 142
- 19085 141
- 19049 140
- 19005 139
- 19153 139
- 19001 137
- 19013 137
- 19183 136
- 19191 136
- 19061 135
- 19139 135
- 19065 133
- 19087 133
- 19113 133
- 19169 133
- 19033 132
- 19109 132
- 19157 132
- 19163 132
- 19167 132
- 19171 132
- 19193 132
- 19081 131
- 19179 131
- 19019 130
- 19031 130
- 19099 130
- 19181 130
- …
county >30
- Johnson 146
- Pottawattamie 145
- Carroll 142
- Harrison 141
- Dallas 140
- Allamakee 139
- Polk 139
- Adair 137
- Black Hawk 137
- Washington 136
- Winneshiek 136
- Dubuque 135
- Muscatine 135
- Fayette 133
- Henry 133
- Linn 133
- Story 133
- Cerro Gordo 132
- Kossuth 132
- Poweshiek 132
- Scott 132
- Sioux 132
- Tama 132
- Woodbury 132
- Hancock 131
- Wapello 131
- Buchanan 130
- Cedar 130
- Jasper 130
- Warren 130
- …
state 1
- Iowa · 11,973 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386730 | 386730 | 2020-07-31 | Adair | Iowa | 19001 | 20 | 0 |
386731 | 386731 | 2020-07-31 | Adams | Iowa | 19003 | 15 | 0 |
386732 | 386732 | 2020-07-31 | Allamakee | Iowa | 19005 | 148 | 4 |
386733 | 386733 | 2020-07-31 | Appanoose | Iowa | 19007 | 40 | 3 |
386734 | 386734 | 2020-07-31 | Audubon | Iowa | 19009 | 28 | 1 |
386735 | 386735 | 2020-07-31 | Benton | Iowa | 19011 | 130 | 1 |
386736 | 386736 | 2020-07-31 | Black Hawk | Iowa | 19013 | 2970 | 62 |
386737 | 386737 | 2020-07-31 | Boone | Iowa | 19015 | 226 | 2 |
386738 | 386738 | 2020-07-31 | Bremer | Iowa | 19017 | 181 | 7 |
386739 | 386739 | 2020-07-31 | Buchanan | Iowa | 19019 | 105 | 1 |
386740 | 386740 | 2020-07-31 | Buena Vista | Iowa | 19021 | 1782 | 12 |
386741 | 386741 | 2020-07-31 | Butler | Iowa | 19023 | 111 | 2 |
386742 | 386742 | 2020-07-31 | Calhoun | Iowa | 19025 | 81 | 2 |
386743 | 386743 | 2020-07-31 | Carroll | Iowa | 19027 | 175 | 1 |
386744 | 386744 | 2020-07-31 | Cass | Iowa | 19029 | 42 | 1 |
386745 | 386745 | 2020-07-31 | Cedar | Iowa | 19031 | 117 | 1 |
386746 | 386746 | 2020-07-31 | Cerro Gordo | Iowa | 19033 | 572 | 17 |
386747 | 386747 | 2020-07-31 | Cherokee | Iowa | 19035 | 97 | 1 |
386748 | 386748 | 2020-07-31 | Chickasaw | Iowa | 19037 | 48 | 0 |
386749 | 386749 | 2020-07-31 | Clarke | Iowa | 19039 | 174 | 3 |
386750 | 386750 | 2020-07-31 | Clay | Iowa | 19041 | 168 | 1 |
386751 | 386751 | 2020-07-31 | Clayton | Iowa | 19043 | 94 | 3 |
386752 | 386752 | 2020-07-31 | Clinton | Iowa | 19045 | 288 | 3 |
386753 | 386753 | 2020-07-31 | Crawford | Iowa | 19047 | 707 | 3 |
386754 | 386754 | 2020-07-31 | Dallas | Iowa | 19049 | 1739 | 35 |
386755 | 386755 | 2020-07-31 | Davis | Iowa | 19051 | 49 | 1 |
386756 | 386756 | 2020-07-31 | Decatur | Iowa | 19053 | 21 | 0 |
386757 | 386757 | 2020-07-31 | Delaware | Iowa | 19055 | 85 | 1 |
386758 | 386758 | 2020-07-31 | Des Moines | Iowa | 19057 | 144 | 2 |
386759 | 386759 | 2020-07-31 | Dickinson | Iowa | 19059 | 371 | 4 |
386760 | 386760 | 2020-07-31 | Dubuque | Iowa | 19061 | 1484 | 28 |
386761 | 386761 | 2020-07-31 | Emmet | Iowa | 19063 | 178 | 1 |
386762 | 386762 | 2020-07-31 | Fayette | Iowa | 19065 | 77 | 0 |
386763 | 386763 | 2020-07-31 | Floyd | Iowa | 19067 | 109 | 2 |
386764 | 386764 | 2020-07-31 | Franklin | Iowa | 19069 | 209 | 4 |
386765 | 386765 | 2020-07-31 | Fremont | Iowa | 19071 | 32 | 0 |
386766 | 386766 | 2020-07-31 | Greene | Iowa | 19073 | 38 | 0 |
386767 | 386767 | 2020-07-31 | Grundy | Iowa | 19075 | 72 | 1 |
386768 | 386768 | 2020-07-31 | Guthrie | Iowa | 19077 | 124 | 5 |
386769 | 386769 | 2020-07-31 | Hamilton | Iowa | 19079 | 237 | 1 |
386770 | 386770 | 2020-07-31 | Hancock | Iowa | 19081 | 114 | 2 |
386771 | 386771 | 2020-07-31 | Hardin | Iowa | 19083 | 161 | 0 |
386772 | 386772 | 2020-07-31 | Harrison | Iowa | 19085 | 90 | 0 |
386773 | 386773 | 2020-07-31 | Henry | Iowa | 19087 | 109 | 3 |
386774 | 386774 | 2020-07-31 | Howard | Iowa | 19089 | 47 | 0 |
386775 | 386775 | 2020-07-31 | Humboldt | Iowa | 19091 | 87 | 1 |
386776 | 386776 | 2020-07-31 | Ida | Iowa | 19093 | 29 | 0 |
386777 | 386777 | 2020-07-31 | Iowa | Iowa | 19095 | 87 | 1 |
386778 | 386778 | 2020-07-31 | Jackson | Iowa | 19097 | 132 | 1 |
386779 | 386779 | 2020-07-31 | Jasper | Iowa | 19099 | 450 | 24 |
386780 | 386780 | 2020-07-31 | Jefferson | Iowa | 19101 | 75 | 0 |
386781 | 386781 | 2020-07-31 | Johnson | Iowa | 19103 | 1881 | 15 |
386782 | 386782 | 2020-07-31 | Jones | Iowa | 19105 | 122 | 1 |
386783 | 386783 | 2020-07-31 | Keokuk | Iowa | 19107 | 28 | 1 |
386784 | 386784 | 2020-07-31 | Kossuth | Iowa | 19109 | 76 | 0 |
386785 | 386785 | 2020-07-31 | Lee | Iowa | 19111 | 89 | 3 |
386786 | 386786 | 2020-07-31 | Linn | Iowa | 19113 | 2005 | 87 |
386787 | 386787 | 2020-07-31 | Louisa | Iowa | 19115 | 378 | 14 |
386788 | 386788 | 2020-07-31 | Lucas | Iowa | 19117 | 42 | 4 |
386789 | 386789 | 2020-07-31 | Lyon | Iowa | 19119 | 99 | 0 |
386790 | 386790 | 2020-07-31 | Madison | Iowa | 19121 | 93 | 2 |
386791 | 386791 | 2020-07-31 | Mahaska | Iowa | 19123 | 133 | 17 |
386792 | 386792 | 2020-07-31 | Marion | Iowa | 19125 | 147 | 0 |
386793 | 386793 | 2020-07-31 | Marshall | Iowa | 19127 | 1373 | 24 |
386794 | 386794 | 2020-07-31 | Mills | Iowa | 19129 | 76 | 0 |
386795 | 386795 | 2020-07-31 | Mitchell | Iowa | 19131 | 76 | 0 |
386796 | 386796 | 2020-07-31 | Monona | Iowa | 19133 | 89 | 0 |
386797 | 386797 | 2020-07-31 | Monroe | Iowa | 19135 | 66 | 7 |
386798 | 386798 | 2020-07-31 | Montgomery | Iowa | 19137 | 42 | 3 |
386799 | 386799 | 2020-07-31 | Muscatine | Iowa | 19139 | 807 | 47 |
386800 | 386800 | 2020-07-31 | O'Brien | Iowa | 19141 | 116 | 1 |
386801 | 386801 | 2020-07-31 | Osceola | Iowa | 19143 | 77 | 0 |
386802 | 386802 | 2020-07-31 | Page | Iowa | 19145 | 69 | 0 |
386803 | 386803 | 2020-07-31 | Palo Alto | Iowa | 19147 | 74 | 0 |
386804 | 386804 | 2020-07-31 | Plymouth | Iowa | 19149 | 435 | 8 |
386805 | 386805 | 2020-07-31 | Pocahontas | Iowa | 19151 | 113 | 1 |
386806 | 386806 | 2020-07-31 | Polk | Iowa | 19153 | 9479 | 201 |
386807 | 386807 | 2020-07-31 | Pottawattamie | Iowa | 19155 | 1153 | 21 |
386808 | 386808 | 2020-07-31 | Poweshiek | Iowa | 19157 | 137 | 8 |
386809 | 386809 | 2020-07-31 | Ringgold | Iowa | 19159 | 21 | 1 |
386810 | 386810 | 2020-07-31 | Sac | Iowa | 19161 | 79 | 0 |
386811 | 386811 | 2020-07-31 | Scott | Iowa | 19163 | 1557 | 12 |
386812 | 386812 | 2020-07-31 | Shelby | Iowa | 19165 | 155 | 1 |
386813 | 386813 | 2020-07-31 | Sioux | Iowa | 19167 | 588 | 2 |
386814 | 386814 | 2020-07-31 | Story | Iowa | 19169 | 1088 | 13 |
386815 | 386815 | 2020-07-31 | Tama | Iowa | 19171 | 534 | 29 |
386816 | 386816 | 2020-07-31 | Taylor | Iowa | 19173 | 93 | 0 |
386817 | 386817 | 2020-07-31 | Union | Iowa | 19175 | 66 | 1 |
386818 | 386818 | 2020-07-31 | Unknown | Iowa | 5 | 0 | |
386819 | 386819 | 2020-07-31 | Van Buren | Iowa | 19177 | 29 | 1 |
386820 | 386820 | 2020-07-31 | Wapello | Iowa | 19179 | 827 | 31 |
386821 | 386821 | 2020-07-31 | Warren | Iowa | 19181 | 503 | 1 |
386822 | 386822 | 2020-07-31 | Washington | Iowa | 19183 | 284 | 10 |
386823 | 386823 | 2020-07-31 | Wayne | Iowa | 19185 | 15 | 1 |
386824 | 386824 | 2020-07-31 | Webster | Iowa | 19187 | 699 | 5 |
386825 | 386825 | 2020-07-31 | Winnebago | Iowa | 19189 | 71 | 0 |
386826 | 386826 | 2020-07-31 | Winneshiek | Iowa | 19191 | 77 | 1 |
386827 | 386827 | 2020-07-31 | Woodbury | Iowa | 19193 | 3620 | 49 |
386828 | 386828 | 2020-07-31 | Worth | Iowa | 19195 | 59 | 0 |
386829 | 386829 | 2020-07-31 | Wright | Iowa | 19197 | 439 | 1 |
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);