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 2020-06-15 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
240910 | 240910 | 2020-06-15 | Adair | Iowa | 19001 | 11 | 0 |
240911 | 240911 | 2020-06-15 | Adams | Iowa | 19003 | 8 | 0 |
240912 | 240912 | 2020-06-15 | Allamakee | Iowa | 19005 | 121 | 4 |
240913 | 240913 | 2020-06-15 | Appanoose | Iowa | 19007 | 17 | 3 |
240914 | 240914 | 2020-06-15 | Audubon | Iowa | 19009 | 14 | 1 |
240915 | 240915 | 2020-06-15 | Benton | Iowa | 19011 | 46 | 1 |
240916 | 240916 | 2020-06-15 | Black Hawk | Iowa | 19013 | 1836 | 55 |
240917 | 240917 | 2020-06-15 | Boone | Iowa | 19015 | 101 | 1 |
240918 | 240918 | 2020-06-15 | Bremer | Iowa | 19017 | 74 | 6 |
240919 | 240919 | 2020-06-15 | Buchanan | Iowa | 19019 | 35 | 1 |
240920 | 240920 | 2020-06-15 | Buena Vista | Iowa | 19021 | 1595 | 7 |
240921 | 240921 | 2020-06-15 | Butler | Iowa | 19023 | 23 | 2 |
240922 | 240922 | 2020-06-15 | Calhoun | Iowa | 19025 | 24 | 0 |
240923 | 240923 | 2020-06-15 | Carroll | Iowa | 19027 | 48 | 1 |
240924 | 240924 | 2020-06-15 | Cass | Iowa | 19029 | 14 | 0 |
240925 | 240925 | 2020-06-15 | Cedar | Iowa | 19031 | 54 | 1 |
240926 | 240926 | 2020-06-15 | Cerro Gordo | Iowa | 19033 | 44 | 1 |
240927 | 240927 | 2020-06-15 | Cherokee | Iowa | 19035 | 59 | 0 |
240928 | 240928 | 2020-06-15 | Chickasaw | Iowa | 19037 | 15 | 0 |
240929 | 240929 | 2020-06-15 | Clarke | Iowa | 19039 | 89 | 1 |
240930 | 240930 | 2020-06-15 | Clay | Iowa | 19041 | 77 | 0 |
240931 | 240931 | 2020-06-15 | Clayton | Iowa | 19043 | 35 | 3 |
240932 | 240932 | 2020-06-15 | Clinton | Iowa | 19045 | 68 | 1 |
240933 | 240933 | 2020-06-15 | Crawford | Iowa | 19047 | 622 | 2 |
240934 | 240934 | 2020-06-15 | Dallas | Iowa | 19049 | 1029 | 26 |
240935 | 240935 | 2020-06-15 | Davis | Iowa | 19051 | 34 | 1 |
240936 | 240936 | 2020-06-15 | Decatur | Iowa | 19053 | 8 | 0 |
240937 | 240937 | 2020-06-15 | Delaware | Iowa | 19055 | 27 | 1 |
240938 | 240938 | 2020-06-15 | Des Moines | Iowa | 19057 | 66 | 2 |
240939 | 240939 | 2020-06-15 | Dickinson | Iowa | 19059 | 153 | 0 |
240940 | 240940 | 2020-06-15 | Dubuque | Iowa | 19061 | 388 | 22 |
240941 | 240941 | 2020-06-15 | Emmet | Iowa | 19063 | 41 | 0 |
240942 | 240942 | 2020-06-15 | Fayette | Iowa | 19065 | 28 | 0 |
240943 | 240943 | 2020-06-15 | Floyd | Iowa | 19067 | 20 | 1 |
240944 | 240944 | 2020-06-15 | Franklin | Iowa | 19069 | 49 | 0 |
240945 | 240945 | 2020-06-15 | Fremont | Iowa | 19071 | 4 | 0 |
240946 | 240946 | 2020-06-15 | Greene | Iowa | 19073 | 21 | 0 |
240947 | 240947 | 2020-06-15 | Grundy | Iowa | 19075 | 23 | 0 |
240948 | 240948 | 2020-06-15 | Guthrie | Iowa | 19077 | 59 | 3 |
240949 | 240949 | 2020-06-15 | Hamilton | Iowa | 19079 | 124 | 0 |
240950 | 240950 | 2020-06-15 | Hancock | Iowa | 19081 | 33 | 0 |
240951 | 240951 | 2020-06-15 | Hardin | Iowa | 19083 | 45 | 0 |
240952 | 240952 | 2020-06-15 | Harrison | Iowa | 19085 | 41 | 0 |
240953 | 240953 | 2020-06-15 | Henry | Iowa | 19087 | 74 | 2 |
240954 | 240954 | 2020-06-15 | Howard | Iowa | 19089 | 12 | 0 |
240955 | 240955 | 2020-06-15 | Humboldt | Iowa | 19091 | 34 | 1 |
240956 | 240956 | 2020-06-15 | Ida | Iowa | 19093 | 18 | 0 |
240957 | 240957 | 2020-06-15 | Iowa | Iowa | 19095 | 34 | 0 |
240958 | 240958 | 2020-06-15 | Jackson | Iowa | 19097 | 14 | 0 |
240959 | 240959 | 2020-06-15 | Jasper | Iowa | 19099 | 282 | 17 |
240960 | 240960 | 2020-06-15 | Jefferson | Iowa | 19101 | 48 | 0 |
240961 | 240961 | 2020-06-15 | Johnson | Iowa | 19103 | 644 | 8 |
240962 | 240962 | 2020-06-15 | Jones | Iowa | 19105 | 41 | 0 |
240963 | 240963 | 2020-06-15 | Keokuk | Iowa | 19107 | 15 | 0 |
240964 | 240964 | 2020-06-15 | Kossuth | Iowa | 19109 | 19 | 0 |
240965 | 240965 | 2020-06-15 | Lee | Iowa | 19111 | 40 | 1 |
240966 | 240966 | 2020-06-15 | Linn | Iowa | 19113 | 1019 | 80 |
240967 | 240967 | 2020-06-15 | Louisa | Iowa | 19115 | 355 | 12 |
240968 | 240968 | 2020-06-15 | Lucas | Iowa | 19117 | 25 | 3 |
240969 | 240969 | 2020-06-15 | Lyon | Iowa | 19119 | 31 | 0 |
240970 | 240970 | 2020-06-15 | Madison | Iowa | 19121 | 34 | 2 |
240971 | 240971 | 2020-06-15 | Mahaska | Iowa | 19123 | 108 | 14 |
240972 | 240972 | 2020-06-15 | Marion | Iowa | 19125 | 42 | 0 |
240973 | 240973 | 2020-06-15 | Marshall | Iowa | 19127 | 941 | 18 |
240974 | 240974 | 2020-06-15 | Mills | Iowa | 19129 | 24 | 0 |
240975 | 240975 | 2020-06-15 | Mitchell | Iowa | 19131 | 8 | 0 |
240976 | 240976 | 2020-06-15 | Monona | Iowa | 19133 | 49 | 0 |
240977 | 240977 | 2020-06-15 | Monroe | Iowa | 19135 | 47 | 6 |
240978 | 240978 | 2020-06-15 | Montgomery | Iowa | 19137 | 9 | 2 |
240979 | 240979 | 2020-06-15 | Muscatine | Iowa | 19139 | 574 | 43 |
240980 | 240980 | 2020-06-15 | O'Brien | Iowa | 19141 | 66 | 1 |
240981 | 240981 | 2020-06-15 | Osceola | Iowa | 19143 | 49 | 0 |
240982 | 240982 | 2020-06-15 | Page | Iowa | 19145 | 17 | 0 |
240983 | 240983 | 2020-06-15 | Palo Alto | Iowa | 19147 | 16 | 0 |
240984 | 240984 | 2020-06-15 | Plymouth | Iowa | 19149 | 201 | 4 |
240985 | 240985 | 2020-06-15 | Pocahontas | Iowa | 19151 | 30 | 0 |
240986 | 240986 | 2020-06-15 | Polk | Iowa | 19153 | 5180 | 163 |
240987 | 240987 | 2020-06-15 | Pottawattamie | Iowa | 19155 | 514 | 11 |
240988 | 240988 | 2020-06-15 | Poweshiek | Iowa | 19157 | 95 | 8 |
240989 | 240989 | 2020-06-15 | Ringgold | Iowa | 19159 | 8 | 0 |
240990 | 240990 | 2020-06-15 | Sac | Iowa | 19161 | 38 | 0 |
240991 | 240991 | 2020-06-15 | Scott | Iowa | 19163 | 407 | 10 |
240992 | 240992 | 2020-06-15 | Shelby | Iowa | 19165 | 49 | 0 |
240993 | 240993 | 2020-06-15 | Sioux | Iowa | 19167 | 361 | 0 |
240994 | 240994 | 2020-06-15 | Story | Iowa | 19169 | 255 | 2 |
240995 | 240995 | 2020-06-15 | Tama | Iowa | 19171 | 429 | 29 |
240996 | 240996 | 2020-06-15 | Taylor | Iowa | 19173 | 74 | 0 |
240997 | 240997 | 2020-06-15 | Union | Iowa | 19175 | 10 | 0 |
240998 | 240998 | 2020-06-15 | Unknown | Iowa | 5 | 0 | |
240999 | 240999 | 2020-06-15 | Van Buren | Iowa | 19177 | 11 | 0 |
241000 | 241000 | 2020-06-15 | Wapello | Iowa | 19179 | 675 | 26 |
241001 | 241001 | 2020-06-15 | Warren | Iowa | 19181 | 197 | 1 |
241002 | 241002 | 2020-06-15 | Washington | Iowa | 19183 | 208 | 9 |
241003 | 241003 | 2020-06-15 | Wayne | Iowa | 19185 | 5 | 0 |
241004 | 241004 | 2020-06-15 | Webster | Iowa | 19187 | 99 | 1 |
241005 | 241005 | 2020-06-15 | Winnebago | Iowa | 19189 | 13 | 0 |
241006 | 241006 | 2020-06-15 | Winneshiek | Iowa | 19191 | 24 | 0 |
241007 | 241007 | 2020-06-15 | Woodbury | Iowa | 19193 | 3011 | 40 |
241008 | 241008 | 2020-06-15 | Worth | Iowa | 19195 | 5 | 0 |
241009 | 241009 | 2020-06-15 | Wright | Iowa | 19197 | 294 | 0 |
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);