ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2021-03-29 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 100
- 19001 1
- 19003 1
- 19005 1
- 19007 1
- 19009 1
- 19011 1
- 19013 1
- 19015 1
- 19017 1
- 19019 1
- 19021 1
- 19023 1
- 19025 1
- 19027 1
- 19029 1
- 19031 1
- 19033 1
- 19035 1
- 19037 1
- 19039 1
- 19041 1
- 19043 1
- 19045 1
- 19047 1
- 19049 1
- 19051 1
- 19053 1
- 19055 1
- 19057 1
- 19059 1
- 19061 1
- 19063 1
- 19065 1
- 19067 1
- 19069 1
- 19071 1
- 19073 1
- 19075 1
- 19077 1
- 19079 1
- 19081 1
- 19083 1
- 19085 1
- 19087 1
- 19089 1
- 19091 1
- 19093 1
- 19095 1
- 19097 1
- 19099 1
- 19101 1
- 19103 1
- 19105 1
- 19107 1
- 19109 1
- 19111 1
- 19113 1
- 19115 1
- 19117 1
- 19119 1
- 19121 1
- 19123 1
- 19125 1
- 19127 1
- 19129 1
- 19131 1
- 19133 1
- 19135 1
- 19137 1
- 19139 1
- 19141 1
- 19143 1
- 19145 1
- 19147 1
- 19149 1
- 19151 1
- 19153 1
- 19155 1
- 19157 1
- 19159 1
- 19161 1
- 19163 1
- 19165 1
- 19167 1
- 19169 1
- 19171 1
- 19173 1
- 19175 1
- 19177 1
- 19179 1
- 19181 1
- 19183 1
- 19185 1
- 19187 1
- 19189 1
- 19191 1
- 19193 1
- 19195 1
- 19197 1
- - 1
county 100
- 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
- Dubuque 1
- Emmet 1
- Fayette 1
- Floyd 1
- Franklin 1
- Fremont 1
- Greene 1
- Grundy 1
- Guthrie 1
- Hamilton 1
- Hancock 1
- Hardin 1
- Harrison 1
- Henry 1
- Howard 1
- Humboldt 1
- Ida 1
- Iowa 1
- Jackson 1
- Jasper 1
- Jefferson 1
- Johnson 1
- Jones 1
- Keokuk 1
- Kossuth 1
- Lee 1
- Linn 1
- Louisa 1
- Lucas 1
- Lyon 1
- Madison 1
- Mahaska 1
- Marion 1
- Marshall 1
- Mills 1
- Mitchell 1
- Monona 1
- Monroe 1
- Montgomery 1
- Muscatine 1
- O'Brien 1
- Osceola 1
- Page 1
- Palo Alto 1
- Plymouth 1
- Pocahontas 1
- Polk 1
- Pottawattamie 1
- Poweshiek 1
- Ringgold 1
- Sac 1
- Scott 1
- Shelby 1
- Sioux 1
- Story 1
- Tama 1
- Taylor 1
- Union 1
- Unknown 1
- Van Buren 1
- Wapello 1
- Warren 1
- Washington 1
- Wayne 1
- Webster 1
- Winnebago 1
- Winneshiek 1
- Woodbury 1
- Worth 1
- Wright 1
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1167924 | 1167924 | 2021-03-29 | Adair | Iowa | 19001 | 837 | 32 |
1167925 | 1167925 | 2021-03-29 | Adams | Iowa | 19003 | 319 | 4 |
1167926 | 1167926 | 2021-03-29 | Allamakee | Iowa | 19005 | 1483 | 49 |
1167927 | 1167927 | 2021-03-29 | Appanoose | Iowa | 19007 | 1250 | 47 |
1167928 | 1167928 | 2021-03-29 | Audubon | Iowa | 19009 | 484 | 9 |
1167929 | 1167929 | 2021-03-29 | Benton | Iowa | 19011 | 2471 | 54 |
1167930 | 1167930 | 2021-03-29 | Black Hawk | Iowa | 19013 | 15257 | 300 |
1167931 | 1167931 | 2021-03-29 | Boone | Iowa | 19015 | 2510 | 31 |
1167932 | 1167932 | 2021-03-29 | Bremer | Iowa | 19017 | 2758 | 57 |
1167933 | 1167933 | 2021-03-29 | Buchanan | Iowa | 19019 | 1837 | 31 |
1167934 | 1167934 | 2021-03-29 | Buena Vista | Iowa | 19021 | 4180 | 39 |
1167935 | 1167935 | 2021-03-29 | Butler | Iowa | 19023 | 1610 | 33 |
1167936 | 1167936 | 2021-03-29 | Calhoun | Iowa | 19025 | 1321 | 11 |
1167937 | 1167937 | 2021-03-29 | Carroll | Iowa | 19027 | 2733 | 49 |
1167938 | 1167938 | 2021-03-29 | Cass | Iowa | 19029 | 1327 | 53 |
1167939 | 1167939 | 2021-03-29 | Cedar | Iowa | 19031 | 1787 | 23 |
1167940 | 1167940 | 2021-03-29 | Cerro Gordo | Iowa | 19033 | 5098 | 85 |
1167941 | 1167941 | 2021-03-29 | Cherokee | Iowa | 19035 | 1539 | 37 |
1167942 | 1167942 | 2021-03-29 | Chickasaw | Iowa | 19037 | 1211 | 15 |
1167943 | 1167943 | 2021-03-29 | Clarke | Iowa | 19039 | 972 | 23 |
1167944 | 1167944 | 2021-03-29 | Clay | Iowa | 19041 | 2007 | 25 |
1167945 | 1167945 | 2021-03-29 | Clayton | Iowa | 19043 | 1624 | 55 |
1167946 | 1167946 | 2021-03-29 | Clinton | Iowa | 19045 | 5182 | 87 |
1167947 | 1167947 | 2021-03-29 | Crawford | Iowa | 19047 | 2588 | 36 |
1167948 | 1167948 | 2021-03-29 | Dallas | Iowa | 19049 | 10655 | 95 |
1167949 | 1167949 | 2021-03-29 | Davis | Iowa | 19051 | 785 | 24 |
1167950 | 1167950 | 2021-03-29 | Decatur | Iowa | 19053 | 580 | 9 |
1167951 | 1167951 | 2021-03-29 | Delaware | Iowa | 19055 | 1933 | 39 |
1167952 | 1167952 | 2021-03-29 | Des Moines | Iowa | 19057 | 4346 | 64 |
1167953 | 1167953 | 2021-03-29 | Dickinson | Iowa | 19059 | 2249 | 41 |
1167954 | 1167954 | 2021-03-29 | Dubuque | Iowa | 19061 | 12692 | 200 |
1167955 | 1167955 | 2021-03-29 | Emmet | Iowa | 19063 | 1221 | 40 |
1167956 | 1167956 | 2021-03-29 | Fayette | Iowa | 19065 | 1817 | 39 |
1167957 | 1167957 | 2021-03-29 | Floyd | Iowa | 19067 | 1521 | 41 |
1167958 | 1167958 | 2021-03-29 | Franklin | Iowa | 19069 | 1112 | 21 |
1167959 | 1167959 | 2021-03-29 | Fremont | Iowa | 19071 | 583 | 10 |
1167960 | 1167960 | 2021-03-29 | Greene | Iowa | 19073 | 753 | 10 |
1167961 | 1167961 | 2021-03-29 | Grundy | Iowa | 19075 | 1337 | 31 |
1167962 | 1167962 | 2021-03-29 | Guthrie | Iowa | 19077 | 1142 | 28 |
1167963 | 1167963 | 2021-03-29 | Hamilton | Iowa | 19079 | 1757 | 46 |
1167964 | 1167964 | 2021-03-29 | Hancock | Iowa | 19081 | 1406 | 33 |
1167965 | 1167965 | 2021-03-29 | Hardin | Iowa | 19083 | 1753 | 40 |
1167966 | 1167966 | 2021-03-29 | Harrison | Iowa | 19085 | 1709 | 71 |
1167967 | 1167967 | 2021-03-29 | Henry | Iowa | 19087 | 2833 | 37 |
1167968 | 1167968 | 2021-03-29 | Howard | Iowa | 19089 | 1021 | 22 |
1167969 | 1167969 | 2021-03-29 | Humboldt | Iowa | 19091 | 1174 | 26 |
1167970 | 1167970 | 2021-03-29 | Ida | Iowa | 19093 | 876 | 32 |
1167971 | 1167971 | 2021-03-29 | Iowa | Iowa | 19095 | 1435 | 23 |
1167972 | 1167972 | 2021-03-29 | Jackson | Iowa | 19097 | 2144 | 42 |
1167973 | 1167973 | 2021-03-29 | Jasper | Iowa | 19099 | 4023 | 69 |
1167974 | 1167974 | 2021-03-29 | Jefferson | Iowa | 19101 | 1299 | 35 |
1167975 | 1167975 | 2021-03-29 | Johnson | Iowa | 19103 | 13515 | 78 |
1167976 | 1167976 | 2021-03-29 | Jones | Iowa | 19105 | 2893 | 55 |
1167977 | 1167977 | 2021-03-29 | Keokuk | Iowa | 19107 | 934 | 30 |
1167978 | 1167978 | 2021-03-29 | Kossuth | Iowa | 19109 | 2067 | 58 |
1167979 | 1167979 | 2021-03-29 | Lee | Iowa | 19111 | 3633 | 55 |
1167980 | 1167980 | 2021-03-29 | Linn | Iowa | 19113 | 19850 | 324 |
1167981 | 1167981 | 2021-03-29 | Louisa | Iowa | 19115 | 1246 | 48 |
1167982 | 1167982 | 2021-03-29 | Lucas | Iowa | 19117 | 746 | 22 |
1167983 | 1167983 | 2021-03-29 | Lyon | Iowa | 19119 | 1502 | 41 |
1167984 | 1167984 | 2021-03-29 | Madison | Iowa | 19121 | 1502 | 19 |
1167985 | 1167985 | 2021-03-29 | Mahaska | Iowa | 19123 | 2195 | 49 |
1167986 | 1167986 | 2021-03-29 | Marion | Iowa | 19125 | 3503 | 74 |
1167987 | 1167987 | 2021-03-29 | Marshall | Iowa | 19127 | 4733 | 74 |
1167988 | 1167988 | 2021-03-29 | Mills | Iowa | 19129 | 1551 | 20 |
1167989 | 1167989 | 2021-03-29 | Mitchell | Iowa | 19131 | 1243 | 41 |
1167990 | 1167990 | 2021-03-29 | Monona | Iowa | 19133 | 790 | 30 |
1167991 | 1167991 | 2021-03-29 | Monroe | Iowa | 19135 | 913 | 28 |
1167992 | 1167992 | 2021-03-29 | Montgomery | Iowa | 19137 | 979 | 36 |
1167993 | 1167993 | 2021-03-29 | Muscatine | Iowa | 19139 | 4434 | 95 |
1167994 | 1167994 | 2021-03-29 | O'Brien | Iowa | 19141 | 1920 | 58 |
1167995 | 1167995 | 2021-03-29 | Osceola | Iowa | 19143 | 714 | 16 |
1167996 | 1167996 | 2021-03-29 | Page | Iowa | 19145 | 1852 | 19 |
1167997 | 1167997 | 2021-03-29 | Palo Alto | Iowa | 19147 | 1063 | 22 |
1167998 | 1167998 | 2021-03-29 | Plymouth | Iowa | 19149 | 3832 | 79 |
1167999 | 1167999 | 2021-03-29 | Pocahontas | Iowa | 19151 | 827 | 19 |
1168000 | 1168000 | 2021-03-29 | Polk | Iowa | 19153 | 54330 | 579 |
1168001 | 1168001 | 2021-03-29 | Pottawattamie | Iowa | 19155 | 10282 | 152 |
1168002 | 1168002 | 2021-03-29 | Poweshiek | Iowa | 19157 | 1510 | 32 |
1168003 | 1168003 | 2021-03-29 | Ringgold | Iowa | 19159 | 527 | 22 |
1168004 | 1168004 | 2021-03-29 | Sac | Iowa | 19161 | 1230 | 18 |
1168005 | 1168005 | 2021-03-29 | Scott | Iowa | 19163 | 17948 | 226 |
1168006 | 1168006 | 2021-03-29 | Shelby | Iowa | 19165 | 1240 | 34 |
1168007 | 1168007 | 2021-03-29 | Sioux | Iowa | 19167 | 4950 | 69 |
1168008 | 1168008 | 2021-03-29 | Story | Iowa | 19169 | 10028 | 46 |
1168009 | 1168009 | 2021-03-29 | Tama | Iowa | 19171 | 2051 | 68 |
1168010 | 1168010 | 2021-03-29 | Taylor | Iowa | 19173 | 643 | 12 |
1168011 | 1168011 | 2021-03-29 | Union | Iowa | 19175 | 1219 | 32 |
1168012 | 1168012 | 2021-03-29 | Unknown | Iowa | 1016 | 0 | |
1168013 | 1168013 | 2021-03-29 | Van Buren | Iowa | 19177 | 546 | 18 |
1168014 | 1168014 | 2021-03-29 | Wapello | Iowa | 19179 | 4209 | 116 |
1168015 | 1168015 | 2021-03-29 | Warren | Iowa | 19181 | 5369 | 80 |
1168016 | 1168016 | 2021-03-29 | Washington | Iowa | 19183 | 2443 | 49 |
1168017 | 1168017 | 2021-03-29 | Wayne | Iowa | 19185 | 514 | 23 |
1168018 | 1168018 | 2021-03-29 | Webster | Iowa | 19187 | 5036 | 89 |
1168019 | 1168019 | 2021-03-29 | Winnebago | Iowa | 19189 | 1339 | 31 |
1168020 | 1168020 | 2021-03-29 | Winneshiek | Iowa | 19191 | 1890 | 31 |
1168021 | 1168021 | 2021-03-29 | Woodbury | Iowa | 19193 | 14474 | 217 |
1168022 | 1168022 | 2021-03-29 | Worth | Iowa | 19195 | 678 | 8 |
1168023 | 1168023 | 2021-03-29 | Wright | Iowa | 19197 | 1769 | 34 |
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);