ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2020-05-15 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adair 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
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Emmet 1
- …
state 1
- Iowa · 96 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
145968 | 145968 | 2020-05-15 | Adair | Iowa | 19001 | 4 | 0 |
145969 | 145969 | 2020-05-15 | Allamakee | Iowa | 19005 | 116 | 4 |
145970 | 145970 | 2020-05-15 | Appanoose | Iowa | 19007 | 7 | 3 |
145971 | 145971 | 2020-05-15 | Audubon | Iowa | 19009 | 11 | 1 |
145972 | 145972 | 2020-05-15 | Benton | Iowa | 19011 | 37 | 1 |
145973 | 145973 | 2020-05-15 | Black Hawk | Iowa | 19013 | 1548 | 29 |
145974 | 145974 | 2020-05-15 | Boone | Iowa | 19015 | 41 | 0 |
145975 | 145975 | 2020-05-15 | Bremer | Iowa | 19017 | 63 | 5 |
145976 | 145976 | 2020-05-15 | Buchanan | Iowa | 19019 | 26 | 0 |
145977 | 145977 | 2020-05-15 | Buena Vista | Iowa | 19021 | 83 | 0 |
145978 | 145978 | 2020-05-15 | Butler | Iowa | 19023 | 13 | 0 |
145979 | 145979 | 2020-05-15 | Calhoun | Iowa | 19025 | 1 | 0 |
145980 | 145980 | 2020-05-15 | Carroll | Iowa | 19027 | 8 | 0 |
145981 | 145981 | 2020-05-15 | Cass | Iowa | 19029 | 1 | 0 |
145982 | 145982 | 2020-05-15 | Cedar | Iowa | 19031 | 42 | 1 |
145983 | 145983 | 2020-05-15 | Cerro Gordo | Iowa | 19033 | 15 | 0 |
145984 | 145984 | 2020-05-15 | Cherokee | Iowa | 19035 | 8 | 0 |
145985 | 145985 | 2020-05-15 | Chickasaw | Iowa | 19037 | 7 | 0 |
145986 | 145986 | 2020-05-15 | Clarke | Iowa | 19039 | 11 | 0 |
145987 | 145987 | 2020-05-15 | Clay | Iowa | 19041 | 10 | 0 |
145988 | 145988 | 2020-05-15 | Clayton | Iowa | 19043 | 28 | 3 |
145989 | 145989 | 2020-05-15 | Clinton | Iowa | 19045 | 60 | 1 |
145990 | 145990 | 2020-05-15 | Crawford | Iowa | 19047 | 336 | 1 |
145991 | 145991 | 2020-05-15 | Dallas | Iowa | 19049 | 757 | 10 |
145992 | 145992 | 2020-05-15 | Davis | Iowa | 19051 | 13 | 0 |
145993 | 145993 | 2020-05-15 | Delaware | Iowa | 19055 | 11 | 0 |
145994 | 145994 | 2020-05-15 | Des Moines | Iowa | 19057 | 39 | 1 |
145995 | 145995 | 2020-05-15 | Dickinson | Iowa | 19059 | 6 | 0 |
145996 | 145996 | 2020-05-15 | Dubuque | Iowa | 19061 | 249 | 10 |
145997 | 145997 | 2020-05-15 | Emmet | Iowa | 19063 | 1 | 0 |
145998 | 145998 | 2020-05-15 | Fayette | Iowa | 19065 | 25 | 0 |
145999 | 145999 | 2020-05-15 | Floyd | Iowa | 19067 | 10 | 1 |
146000 | 146000 | 2020-05-15 | Franklin | Iowa | 19069 | 7 | 0 |
146001 | 146001 | 2020-05-15 | Fremont | Iowa | 19071 | 3 | 0 |
146002 | 146002 | 2020-05-15 | Greene | Iowa | 19073 | 13 | 0 |
146003 | 146003 | 2020-05-15 | Grundy | Iowa | 19075 | 17 | 0 |
146004 | 146004 | 2020-05-15 | Guthrie | Iowa | 19077 | 37 | 2 |
146005 | 146005 | 2020-05-15 | Hamilton | Iowa | 19079 | 11 | 0 |
146006 | 146006 | 2020-05-15 | Hancock | Iowa | 19081 | 3 | 0 |
146007 | 146007 | 2020-05-15 | Hardin | Iowa | 19083 | 11 | 0 |
146008 | 146008 | 2020-05-15 | Harrison | Iowa | 19085 | 17 | 0 |
146009 | 146009 | 2020-05-15 | Henry | Iowa | 19087 | 44 | 1 |
146010 | 146010 | 2020-05-15 | Howard | Iowa | 19089 | 12 | 0 |
146011 | 146011 | 2020-05-15 | Humboldt | Iowa | 19091 | 7 | 0 |
146012 | 146012 | 2020-05-15 | Ida | Iowa | 19093 | 4 | 0 |
146013 | 146013 | 2020-05-15 | Iowa | Iowa | 19095 | 27 | 0 |
146014 | 146014 | 2020-05-15 | Jackson | Iowa | 19097 | 8 | 0 |
146015 | 146015 | 2020-05-15 | Jasper | Iowa | 19099 | 241 | 11 |
146016 | 146016 | 2020-05-15 | Jefferson | Iowa | 19101 | 10 | 0 |
146017 | 146017 | 2020-05-15 | Johnson | Iowa | 19103 | 565 | 7 |
146018 | 146018 | 2020-05-15 | Jones | Iowa | 19105 | 36 | 0 |
146019 | 146019 | 2020-05-15 | Keokuk | Iowa | 19107 | 9 | 0 |
146020 | 146020 | 2020-05-15 | Kossuth | Iowa | 19109 | 2 | 0 |
146021 | 146021 | 2020-05-15 | Lee | Iowa | 19111 | 18 | 0 |
146022 | 146022 | 2020-05-15 | Linn | Iowa | 19113 | 882 | 69 |
146023 | 146023 | 2020-05-15 | Louisa | Iowa | 19115 | 304 | 3 |
146024 | 146024 | 2020-05-15 | Lyon | Iowa | 19119 | 16 | 0 |
146025 | 146025 | 2020-05-15 | Madison | Iowa | 19121 | 14 | 1 |
146026 | 146026 | 2020-05-15 | Mahaska | Iowa | 19123 | 22 | 1 |
146027 | 146027 | 2020-05-15 | Marion | Iowa | 19125 | 19 | 0 |
146028 | 146028 | 2020-05-15 | Marshall | Iowa | 19127 | 771 | 5 |
146029 | 146029 | 2020-05-15 | Mills | Iowa | 19129 | 9 | 0 |
146030 | 146030 | 2020-05-15 | Mitchell | Iowa | 19131 | 4 | 0 |
146031 | 146031 | 2020-05-15 | Monona | Iowa | 19133 | 15 | 0 |
146032 | 146032 | 2020-05-15 | Monroe | Iowa | 19135 | 18 | 1 |
146033 | 146033 | 2020-05-15 | Montgomery | Iowa | 19137 | 5 | 0 |
146034 | 146034 | 2020-05-15 | Muscatine | Iowa | 19139 | 519 | 29 |
146035 | 146035 | 2020-05-15 | O'Brien | Iowa | 19141 | 20 | 0 |
146036 | 146036 | 2020-05-15 | Osceola | Iowa | 19143 | 25 | 0 |
146037 | 146037 | 2020-05-15 | Page | Iowa | 19145 | 10 | 0 |
146038 | 146038 | 2020-05-15 | Palo Alto | Iowa | 19147 | 1 | 0 |
146039 | 146039 | 2020-05-15 | Plymouth | Iowa | 19149 | 78 | 0 |
146040 | 146040 | 2020-05-15 | Pocahontas | Iowa | 19151 | 3 | 0 |
146041 | 146041 | 2020-05-15 | Polk | Iowa | 19153 | 2767 | 76 |
146042 | 146042 | 2020-05-15 | Pottawattamie | Iowa | 19155 | 151 | 2 |
146043 | 146043 | 2020-05-15 | Poweshiek | Iowa | 19157 | 83 | 8 |
146044 | 146044 | 2020-05-15 | Sac | Iowa | 19161 | 4 | 0 |
146045 | 146045 | 2020-05-15 | Scott | Iowa | 19163 | 297 | 8 |
146046 | 146046 | 2020-05-15 | Shelby | Iowa | 19165 | 20 | 0 |
146047 | 146047 | 2020-05-15 | Sioux | Iowa | 19167 | 126 | 0 |
146048 | 146048 | 2020-05-15 | Story | Iowa | 19169 | 73 | 1 |
146049 | 146049 | 2020-05-15 | Tama | Iowa | 19171 | 350 | 15 |
146050 | 146050 | 2020-05-15 | Taylor | Iowa | 19173 | 1 | 0 |
146051 | 146051 | 2020-05-15 | Union | Iowa | 19175 | 1 | 0 |
146052 | 146052 | 2020-05-15 | Unknown | Iowa | 10 | 0 | |
146053 | 146053 | 2020-05-15 | Van Buren | Iowa | 19177 | 8 | 0 |
146054 | 146054 | 2020-05-15 | Wapello | Iowa | 19179 | 350 | 2 |
146055 | 146055 | 2020-05-15 | Warren | Iowa | 19181 | 63 | 0 |
146056 | 146056 | 2020-05-15 | Washington | Iowa | 19183 | 163 | 8 |
146057 | 146057 | 2020-05-15 | Wayne | Iowa | 19185 | 1 | 0 |
146058 | 146058 | 2020-05-15 | Webster | Iowa | 19187 | 13 | 1 |
146059 | 146059 | 2020-05-15 | Winnebago | Iowa | 19189 | 6 | 0 |
146060 | 146060 | 2020-05-15 | Winneshiek | Iowa | 19191 | 18 | 0 |
146061 | 146061 | 2020-05-15 | Woodbury | Iowa | 19193 | 2111 | 14 |
146062 | 146062 | 2020-05-15 | Worth | Iowa | 19195 | 2 | 0 |
146063 | 146063 | 2020-05-15 | Wright | Iowa | 19197 | 7 | 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);