ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-12-26" 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 |
---|---|---|---|---|---|---|---|
866062 | 866062 | 2020-12-26 | Adair | Iowa | 19001 | 581 | 17 |
866063 | 866063 | 2020-12-26 | Adams | Iowa | 19003 | 251 | 2 |
866064 | 866064 | 2020-12-26 | Allamakee | Iowa | 19005 | 1142 | 20 |
866065 | 866065 | 2020-12-26 | Appanoose | Iowa | 19007 | 942 | 34 |
866066 | 866066 | 2020-12-26 | Audubon | Iowa | 19009 | 363 | 7 |
866067 | 866067 | 2020-12-26 | Benton | Iowa | 19011 | 1960 | 36 |
866068 | 866068 | 2020-12-26 | Black Hawk | Iowa | 19013 | 12518 | 215 |
866069 | 866069 | 2020-12-26 | Boone | Iowa | 19015 | 1813 | 15 |
866070 | 866070 | 2020-12-26 | Bremer | Iowa | 19017 | 2223 | 41 |
866071 | 866071 | 2020-12-26 | Buchanan | Iowa | 19019 | 1404 | 16 |
866072 | 866072 | 2020-12-26 | Buena Vista | Iowa | 19021 | 3646 | 25 |
866073 | 866073 | 2020-12-26 | Butler | Iowa | 19023 | 1245 | 18 |
866074 | 866074 | 2020-12-26 | Calhoun | Iowa | 19025 | 1164 | 9 |
866075 | 866075 | 2020-12-26 | Carroll | Iowa | 19027 | 2318 | 27 |
866076 | 866076 | 2020-12-26 | Cass | Iowa | 19029 | 1013 | 38 |
866077 | 866077 | 2020-12-26 | Cedar | Iowa | 19031 | 1345 | 18 |
866078 | 866078 | 2020-12-26 | Cerro Gordo | Iowa | 19033 | 4243 | 59 |
866079 | 866079 | 2020-12-26 | Cherokee | Iowa | 19035 | 1191 | 20 |
866080 | 866080 | 2020-12-26 | Chickasaw | Iowa | 19037 | 1014 | 10 |
866081 | 866081 | 2020-12-26 | Clarke | Iowa | 19039 | 650 | 6 |
866082 | 866082 | 2020-12-26 | Clay | Iowa | 19041 | 1514 | 11 |
866083 | 866083 | 2020-12-26 | Clayton | Iowa | 19043 | 1341 | 39 |
866084 | 866084 | 2020-12-26 | Clinton | Iowa | 19045 | 4036 | 53 |
866085 | 866085 | 2020-12-26 | Crawford | Iowa | 19047 | 2065 | 21 |
866086 | 866086 | 2020-12-26 | Dallas | Iowa | 19049 | 7724 | 64 |
866087 | 866087 | 2020-12-26 | Davis | Iowa | 19051 | 625 | 18 |
866088 | 866088 | 2020-12-26 | Decatur | Iowa | 19053 | 414 | 3 |
866089 | 866089 | 2020-12-26 | Delaware | Iowa | 19055 | 1601 | 29 |
866090 | 866090 | 2020-12-26 | Des Moines | Iowa | 19057 | 3443 | 32 |
866091 | 866091 | 2020-12-26 | Dickinson | Iowa | 19059 | 1667 | 15 |
866092 | 866092 | 2020-12-26 | Dubuque | Iowa | 19061 | 10439 | 135 |
866093 | 866093 | 2020-12-26 | Emmet | Iowa | 19063 | 983 | 23 |
866094 | 866094 | 2020-12-26 | Fayette | Iowa | 19065 | 1329 | 16 |
866095 | 866095 | 2020-12-26 | Floyd | Iowa | 19067 | 1253 | 33 |
866096 | 866096 | 2020-12-26 | Franklin | Iowa | 19069 | 870 | 17 |
866097 | 866097 | 2020-12-26 | Fremont | Iowa | 19071 | 454 | 5 |
866098 | 866098 | 2020-12-26 | Greene | Iowa | 19073 | 633 | 7 |
866099 | 866099 | 2020-12-26 | Grundy | Iowa | 19075 | 1050 | 15 |
866100 | 866100 | 2020-12-26 | Guthrie | Iowa | 19077 | 931 | 22 |
866101 | 866101 | 2020-12-26 | Hamilton | Iowa | 19079 | 1434 | 22 |
866102 | 866102 | 2020-12-26 | Hancock | Iowa | 19081 | 1146 | 24 |
866103 | 866103 | 2020-12-26 | Hardin | Iowa | 19083 | 1428 | 25 |
866104 | 866104 | 2020-12-26 | Harrison | Iowa | 19085 | 1397 | 52 |
866105 | 866105 | 2020-12-26 | Henry | Iowa | 19087 | 2439 | 24 |
866106 | 866106 | 2020-12-26 | Howard | Iowa | 19089 | 688 | 15 |
866107 | 866107 | 2020-12-26 | Humboldt | Iowa | 19091 | 937 | 18 |
866108 | 866108 | 2020-12-26 | Ida | Iowa | 19093 | 682 | 22 |
866109 | 866109 | 2020-12-26 | Iowa | Iowa | 19095 | 1121 | 20 |
866110 | 866110 | 2020-12-26 | Jackson | Iowa | 19097 | 1752 | 29 |
866111 | 866111 | 2020-12-26 | Jasper | Iowa | 19099 | 2813 | 52 |
866112 | 866112 | 2020-12-26 | Jefferson | Iowa | 19101 | 970 | 20 |
866113 | 866113 | 2020-12-26 | Johnson | Iowa | 19103 | 10817 | 47 |
866114 | 866114 | 2020-12-26 | Jones | Iowa | 19105 | 2561 | 44 |
866115 | 866115 | 2020-12-26 | Keokuk | Iowa | 19107 | 769 | 23 |
866116 | 866116 | 2020-12-26 | Kossuth | Iowa | 19109 | 1472 | 28 |
866117 | 866117 | 2020-12-26 | Lee | Iowa | 19111 | 2802 | 24 |
866118 | 866118 | 2020-12-26 | Linn | Iowa | 19113 | 16349 | 240 |
866119 | 866119 | 2020-12-26 | Louisa | Iowa | 19115 | 1042 | 24 |
866120 | 866120 | 2020-12-26 | Lucas | Iowa | 19117 | 532 | 7 |
866121 | 866121 | 2020-12-26 | Lyon | Iowa | 19119 | 1224 | 24 |
866122 | 866122 | 2020-12-26 | Madison | Iowa | 19121 | 918 | 8 |
866123 | 866123 | 2020-12-26 | Mahaska | Iowa | 19123 | 1655 | 32 |
866124 | 866124 | 2020-12-26 | Marion | Iowa | 19125 | 2617 | 46 |
866125 | 866125 | 2020-12-26 | Marshall | Iowa | 19127 | 3941 | 54 |
866126 | 866126 | 2020-12-26 | Mills | Iowa | 19129 | 1259 | 14 |
866127 | 866127 | 2020-12-26 | Mitchell | Iowa | 19131 | 998 | 27 |
866128 | 866128 | 2020-12-26 | Monona | Iowa | 19133 | 538 | 15 |
866129 | 866129 | 2020-12-26 | Monroe | Iowa | 19135 | 612 | 16 |
866130 | 866130 | 2020-12-26 | Montgomery | Iowa | 19137 | 713 | 15 |
866131 | 866131 | 2020-12-26 | Muscatine | Iowa | 19139 | 3481 | 73 |
866132 | 866132 | 2020-12-26 | O'Brien | Iowa | 19141 | 1573 | 50 |
866133 | 866133 | 2020-12-26 | Osceola | Iowa | 19143 | 606 | 7 |
866134 | 866134 | 2020-12-26 | Page | Iowa | 19145 | 1335 | 13 |
866135 | 866135 | 2020-12-26 | Palo Alto | Iowa | 19147 | 788 | 8 |
866136 | 866136 | 2020-12-26 | Plymouth | Iowa | 19149 | 3305 | 51 |
866137 | 866137 | 2020-12-26 | Pocahontas | Iowa | 19151 | 683 | 11 |
866138 | 866138 | 2020-12-26 | Polk | Iowa | 19153 | 40482 | 406 |
866139 | 866139 | 2020-12-26 | Pottawattamie | Iowa | 19155 | 8074 | 90 |
866140 | 866140 | 2020-12-26 | Poweshiek | Iowa | 19157 | 1172 | 24 |
866141 | 866141 | 2020-12-26 | Ringgold | Iowa | 19159 | 352 | 7 |
866142 | 866142 | 2020-12-26 | Sac | Iowa | 19161 | 1020 | 14 |
866143 | 866143 | 2020-12-26 | Scott | Iowa | 19163 | 13800 | 146 |
866144 | 866144 | 2020-12-26 | Shelby | Iowa | 19165 | 924 | 23 |
866145 | 866145 | 2020-12-26 | Sioux | Iowa | 19167 | 4275 | 41 |
866146 | 866146 | 2020-12-26 | Story | Iowa | 19169 | 7862 | 29 |
866147 | 866147 | 2020-12-26 | Tama | Iowa | 19171 | 1739 | 55 |
866148 | 866148 | 2020-12-26 | Taylor | Iowa | 19173 | 528 | 8 |
866149 | 866149 | 2020-12-26 | Union | Iowa | 19175 | 1003 | 16 |
866150 | 866150 | 2020-12-26 | Unknown | Iowa | 620 | 1 | |
866151 | 866151 | 2020-12-26 | Van Buren | Iowa | 19177 | 447 | 11 |
866152 | 866152 | 2020-12-26 | Wapello | Iowa | 19179 | 3042 | 90 |
866153 | 866153 | 2020-12-26 | Warren | Iowa | 19181 | 3653 | 33 |
866154 | 866154 | 2020-12-26 | Washington | Iowa | 19183 | 1816 | 27 |
866155 | 866155 | 2020-12-26 | Wayne | Iowa | 19185 | 363 | 21 |
866156 | 866156 | 2020-12-26 | Webster | Iowa | 19187 | 4336 | 61 |
866157 | 866157 | 2020-12-26 | Winnebago | Iowa | 19189 | 1090 | 28 |
866158 | 866158 | 2020-12-26 | Winneshiek | Iowa | 19191 | 1344 | 17 |
866159 | 866159 | 2020-12-26 | Woodbury | Iowa | 19193 | 12058 | 163 |
866160 | 866160 | 2020-12-26 | Worth | Iowa | 19195 | 501 | 2 |
866161 | 866161 | 2020-12-26 | Wright | Iowa | 19197 | 1497 | 16 |
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);