ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-11-03" 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 |
---|---|---|---|---|---|---|---|
694077 | 694077 | 2020-11-03 | Adair | Iowa | 19001 | 250 | 1 |
694078 | 694078 | 2020-11-03 | Adams | Iowa | 19003 | 91 | 1 |
694079 | 694079 | 2020-11-03 | Allamakee | Iowa | 19005 | 449 | 9 |
694080 | 694080 | 2020-11-03 | Appanoose | Iowa | 19007 | 297 | 3 |
694081 | 694081 | 2020-11-03 | Audubon | Iowa | 19009 | 206 | 1 |
694082 | 694082 | 2020-11-03 | Benton | Iowa | 19011 | 758 | 5 |
694083 | 694083 | 2020-11-03 | Black Hawk | Iowa | 19013 | 6666 | 106 |
694084 | 694084 | 2020-11-03 | Boone | Iowa | 19015 | 818 | 10 |
694085 | 694085 | 2020-11-03 | Bremer | Iowa | 19017 | 855 | 9 |
694086 | 694086 | 2020-11-03 | Buchanan | Iowa | 19019 | 578 | 5 |
694087 | 694087 | 2020-11-03 | Buena Vista | Iowa | 19021 | 2375 | 12 |
694088 | 694088 | 2020-11-03 | Butler | Iowa | 19023 | 468 | 3 |
694089 | 694089 | 2020-11-03 | Calhoun | Iowa | 19025 | 378 | 5 |
694090 | 694090 | 2020-11-03 | Carroll | Iowa | 19027 | 1298 | 13 |
694091 | 694091 | 2020-11-03 | Cass | Iowa | 19029 | 516 | 6 |
694092 | 694092 | 2020-11-03 | Cedar | Iowa | 19031 | 561 | 8 |
694093 | 694093 | 2020-11-03 | Cerro Gordo | Iowa | 19033 | 1686 | 27 |
694094 | 694094 | 2020-11-03 | Cherokee | Iowa | 19035 | 466 | 3 |
694095 | 694095 | 2020-11-03 | Chickasaw | Iowa | 19037 | 416 | 1 |
694096 | 694096 | 2020-11-03 | Clarke | Iowa | 19039 | 374 | 3 |
694097 | 694097 | 2020-11-03 | Clay | Iowa | 19041 | 608 | 4 |
694098 | 694098 | 2020-11-03 | Clayton | Iowa | 19043 | 613 | 3 |
694099 | 694099 | 2020-11-03 | Clinton | Iowa | 19045 | 1701 | 29 |
694100 | 694100 | 2020-11-03 | Crawford | Iowa | 19047 | 1437 | 15 |
694101 | 694101 | 2020-11-03 | Dallas | Iowa | 19049 | 3839 | 49 |
694102 | 694102 | 2020-11-03 | Davis | Iowa | 19051 | 222 | 4 |
694103 | 694103 | 2020-11-03 | Decatur | Iowa | 19053 | 186 | 0 |
694104 | 694104 | 2020-11-03 | Delaware | Iowa | 19055 | 924 | 16 |
694105 | 694105 | 2020-11-03 | Des Moines | Iowa | 19057 | 1656 | 12 |
694106 | 694106 | 2020-11-03 | Dickinson | Iowa | 19059 | 854 | 9 |
694107 | 694107 | 2020-11-03 | Dubuque | Iowa | 19061 | 6038 | 63 |
694108 | 694108 | 2020-11-03 | Emmet | Iowa | 19063 | 478 | 21 |
694109 | 694109 | 2020-11-03 | Fayette | Iowa | 19065 | 489 | 6 |
694110 | 694110 | 2020-11-03 | Floyd | Iowa | 19067 | 502 | 11 |
694111 | 694111 | 2020-11-03 | Franklin | Iowa | 19069 | 419 | 18 |
694112 | 694112 | 2020-11-03 | Fremont | Iowa | 19071 | 230 | 2 |
694113 | 694113 | 2020-11-03 | Greene | Iowa | 19073 | 218 | 0 |
694114 | 694114 | 2020-11-03 | Grundy | Iowa | 19075 | 391 | 6 |
694115 | 694115 | 2020-11-03 | Guthrie | Iowa | 19077 | 453 | 15 |
694116 | 694116 | 2020-11-03 | Hamilton | Iowa | 19079 | 520 | 5 |
694117 | 694117 | 2020-11-03 | Hancock | Iowa | 19081 | 437 | 6 |
694118 | 694118 | 2020-11-03 | Hardin | Iowa | 19083 | 585 | 7 |
694119 | 694119 | 2020-11-03 | Harrison | Iowa | 19085 | 755 | 18 |
694120 | 694120 | 2020-11-03 | Henry | Iowa | 19087 | 1200 | 6 |
694121 | 694121 | 2020-11-03 | Howard | Iowa | 19089 | 300 | 9 |
694122 | 694122 | 2020-11-03 | Humboldt | Iowa | 19091 | 416 | 3 |
694123 | 694123 | 2020-11-03 | Ida | Iowa | 19093 | 261 | 2 |
694124 | 694124 | 2020-11-03 | Iowa | Iowa | 19095 | 508 | 12 |
694125 | 694125 | 2020-11-03 | Jackson | Iowa | 19097 | 810 | 4 |
694126 | 694126 | 2020-11-03 | Jasper | Iowa | 19099 | 1353 | 34 |
694127 | 694127 | 2020-11-03 | Jefferson | Iowa | 19101 | 295 | 1 |
694128 | 694128 | 2020-11-03 | Johnson | Iowa | 19103 | 6375 | 33 |
694129 | 694129 | 2020-11-03 | Jones | Iowa | 19105 | 645 | 4 |
694130 | 694130 | 2020-11-03 | Keokuk | Iowa | 19107 | 232 | 1 |
694131 | 694131 | 2020-11-03 | Kossuth | Iowa | 19109 | 536 | 0 |
694132 | 694132 | 2020-11-03 | Lee | Iowa | 19111 | 1123 | 13 |
694133 | 694133 | 2020-11-03 | Linn | Iowa | 19113 | 7054 | 137 |
694134 | 694134 | 2020-11-03 | Louisa | Iowa | 19115 | 565 | 15 |
694135 | 694135 | 2020-11-03 | Lucas | Iowa | 19117 | 227 | 6 |
694136 | 694136 | 2020-11-03 | Lyon | Iowa | 19119 | 608 | 8 |
694137 | 694137 | 2020-11-03 | Madison | Iowa | 19121 | 405 | 3 |
694138 | 694138 | 2020-11-03 | Mahaska | Iowa | 19123 | 805 | 25 |
694139 | 694139 | 2020-11-03 | Marion | Iowa | 19125 | 1180 | 12 |
694140 | 694140 | 2020-11-03 | Marshall | Iowa | 19127 | 2324 | 37 |
694141 | 694141 | 2020-11-03 | Mills | Iowa | 19129 | 492 | 3 |
694142 | 694142 | 2020-11-03 | Mitchell | Iowa | 19131 | 332 | 2 |
694143 | 694143 | 2020-11-03 | Monona | Iowa | 19133 | 278 | 2 |
694144 | 694144 | 2020-11-03 | Monroe | Iowa | 19135 | 282 | 12 |
694145 | 694145 | 2020-11-03 | Montgomery | Iowa | 19137 | 219 | 7 |
694146 | 694146 | 2020-11-03 | Muscatine | Iowa | 19139 | 1649 | 58 |
694147 | 694147 | 2020-11-03 | O'Brien | Iowa | 19141 | 837 | 15 |
694148 | 694148 | 2020-11-03 | Osceola | Iowa | 19143 | 322 | 0 |
694149 | 694149 | 2020-11-03 | Page | Iowa | 19145 | 467 | 0 |
694150 | 694150 | 2020-11-03 | Palo Alto | Iowa | 19147 | 360 | 2 |
694151 | 694151 | 2020-11-03 | Plymouth | Iowa | 19149 | 1878 | 31 |
694152 | 694152 | 2020-11-03 | Pocahontas | Iowa | 19151 | 287 | 2 |
694153 | 694153 | 2020-11-03 | Polk | Iowa | 19153 | 21060 | 294 |
694154 | 694154 | 2020-11-03 | Pottawattamie | Iowa | 19155 | 3621 | 47 |
694155 | 694155 | 2020-11-03 | Poweshiek | Iowa | 19157 | 548 | 11 |
694156 | 694156 | 2020-11-03 | Ringgold | Iowa | 19159 | 110 | 2 |
694157 | 694157 | 2020-11-03 | Sac | Iowa | 19161 | 457 | 5 |
694158 | 694158 | 2020-11-03 | Scott | Iowa | 19163 | 5422 | 50 |
694159 | 694159 | 2020-11-03 | Shelby | Iowa | 19165 | 442 | 2 |
694160 | 694160 | 2020-11-03 | Sioux | Iowa | 19167 | 2701 | 19 |
694161 | 694161 | 2020-11-03 | Story | Iowa | 19169 | 4359 | 18 |
694162 | 694162 | 2020-11-03 | Tama | Iowa | 19171 | 1081 | 38 |
694163 | 694163 | 2020-11-03 | Taylor | Iowa | 19173 | 279 | 2 |
694164 | 694164 | 2020-11-03 | Union | Iowa | 19175 | 301 | 6 |
694165 | 694165 | 2020-11-03 | Unknown | Iowa | 78 | 0 | |
694166 | 694166 | 2020-11-03 | Van Buren | Iowa | 19177 | 213 | 2 |
694167 | 694167 | 2020-11-03 | Wapello | Iowa | 19179 | 1680 | 64 |
694168 | 694168 | 2020-11-03 | Warren | Iowa | 19181 | 1464 | 8 |
694169 | 694169 | 2020-11-03 | Washington | Iowa | 19183 | 773 | 12 |
694170 | 694170 | 2020-11-03 | Wayne | Iowa | 19185 | 194 | 4 |
694171 | 694171 | 2020-11-03 | Webster | Iowa | 19187 | 2118 | 16 |
694172 | 694172 | 2020-11-03 | Winnebago | Iowa | 19189 | 561 | 20 |
694173 | 694173 | 2020-11-03 | Winneshiek | Iowa | 19191 | 558 | 9 |
694174 | 694174 | 2020-11-03 | Woodbury | Iowa | 19193 | 7868 | 101 |
694175 | 694175 | 2020-11-03 | Worth | Iowa | 19195 | 171 | 0 |
694176 | 694176 | 2020-11-03 | Wright | Iowa | 19197 | 831 | 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);