ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where "date" is on date 2020-04-20 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
- Carroll 1
- Cass 1
- Cedar 1
- Cerro Gordo 1
- Chickasaw 1
- Clarke 1
- Clay 1
- Clayton 1
- Clinton 1
- Crawford 1
- Dallas 1
- Delaware 1
- Des Moines 1
- Dickinson 1
- Dubuque 1
- Fayette 1
- Franklin 1
- Greene 1
- Grundy 1
- …
state 1
- Iowa · 82 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
73638 | 73638 | 2020-04-20 | Adair | Iowa | 19001 | 1 | 0 |
73639 | 73639 | 2020-04-20 | Allamakee | Iowa | 19005 | 40 | 3 |
73640 | 73640 | 2020-04-20 | Appanoose | Iowa | 19007 | 2 | 2 |
73641 | 73641 | 2020-04-20 | Audubon | Iowa | 19009 | 1 | 0 |
73642 | 73642 | 2020-04-20 | Benton | Iowa | 19011 | 23 | 1 |
73643 | 73643 | 2020-04-20 | Black Hawk | Iowa | 19013 | 259 | 2 |
73644 | 73644 | 2020-04-20 | Boone | Iowa | 19015 | 6 | 0 |
73645 | 73645 | 2020-04-20 | Bremer | Iowa | 19017 | 28 | 0 |
73646 | 73646 | 2020-04-20 | Buchanan | Iowa | 19019 | 11 | 0 |
73647 | 73647 | 2020-04-20 | Buena Vista | Iowa | 19021 | 2 | 0 |
73648 | 73648 | 2020-04-20 | Butler | Iowa | 19023 | 1 | 0 |
73649 | 73649 | 2020-04-20 | Carroll | Iowa | 19027 | 1 | 0 |
73650 | 73650 | 2020-04-20 | Cass | Iowa | 19029 | 1 | 0 |
73651 | 73651 | 2020-04-20 | Cedar | Iowa | 19031 | 26 | 0 |
73652 | 73652 | 2020-04-20 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
73653 | 73653 | 2020-04-20 | Chickasaw | Iowa | 19037 | 3 | 0 |
73654 | 73654 | 2020-04-20 | Clarke | Iowa | 19039 | 2 | 0 |
73655 | 73655 | 2020-04-20 | Clay | Iowa | 19041 | 3 | 0 |
73656 | 73656 | 2020-04-20 | Clayton | Iowa | 19043 | 7 | 1 |
73657 | 73657 | 2020-04-20 | Clinton | Iowa | 19045 | 42 | 0 |
73658 | 73658 | 2020-04-20 | Crawford | Iowa | 19047 | 6 | 1 |
73659 | 73659 | 2020-04-20 | Dallas | Iowa | 19049 | 52 | 0 |
73660 | 73660 | 2020-04-20 | Delaware | Iowa | 19055 | 2 | 0 |
73661 | 73661 | 2020-04-20 | Des Moines | Iowa | 19057 | 14 | 0 |
73662 | 73662 | 2020-04-20 | Dickinson | Iowa | 19059 | 1 | 0 |
73663 | 73663 | 2020-04-20 | Dubuque | Iowa | 19061 | 46 | 1 |
73664 | 73664 | 2020-04-20 | Fayette | Iowa | 19065 | 6 | 0 |
73665 | 73665 | 2020-04-20 | Franklin | Iowa | 19069 | 1 | 0 |
73666 | 73666 | 2020-04-20 | Greene | Iowa | 19073 | 1 | 0 |
73667 | 73667 | 2020-04-20 | Grundy | Iowa | 19075 | 5 | 0 |
73668 | 73668 | 2020-04-20 | Guthrie | Iowa | 19077 | 4 | 0 |
73669 | 73669 | 2020-04-20 | Hamilton | Iowa | 19079 | 2 | 0 |
73670 | 73670 | 2020-04-20 | Hancock | Iowa | 19081 | 3 | 0 |
73671 | 73671 | 2020-04-20 | Hardin | Iowa | 19083 | 3 | 0 |
73672 | 73672 | 2020-04-20 | Harrison | Iowa | 19085 | 14 | 0 |
73673 | 73673 | 2020-04-20 | Henry | Iowa | 19087 | 28 | 1 |
73674 | 73674 | 2020-04-20 | Howard | Iowa | 19089 | 4 | 0 |
73675 | 73675 | 2020-04-20 | Iowa | Iowa | 19095 | 13 | 0 |
73676 | 73676 | 2020-04-20 | Jackson | Iowa | 19097 | 5 | 0 |
73677 | 73677 | 2020-04-20 | Jasper | Iowa | 19099 | 42 | 0 |
73678 | 73678 | 2020-04-20 | Jefferson | Iowa | 19101 | 6 | 0 |
73679 | 73679 | 2020-04-20 | Johnson | Iowa | 19103 | 311 | 3 |
73680 | 73680 | 2020-04-20 | Jones | Iowa | 19105 | 15 | 0 |
73681 | 73681 | 2020-04-20 | Keokuk | Iowa | 19107 | 3 | 0 |
73682 | 73682 | 2020-04-20 | Kossuth | Iowa | 19109 | 1 | 0 |
73683 | 73683 | 2020-04-20 | Lee | Iowa | 19111 | 3 | 0 |
73684 | 73684 | 2020-04-20 | Linn | Iowa | 19113 | 411 | 27 |
73685 | 73685 | 2020-04-20 | Louisa | Iowa | 19115 | 216 | 2 |
73686 | 73686 | 2020-04-20 | Lyon | Iowa | 19119 | 5 | 0 |
73687 | 73687 | 2020-04-20 | Madison | Iowa | 19121 | 3 | 1 |
73688 | 73688 | 2020-04-20 | Mahaska | Iowa | 19123 | 8 | 1 |
73689 | 73689 | 2020-04-20 | Marion | Iowa | 19125 | 5 | 0 |
73690 | 73690 | 2020-04-20 | Marshall | Iowa | 19127 | 173 | 0 |
73691 | 73691 | 2020-04-20 | Mills | Iowa | 19129 | 2 | 0 |
73692 | 73692 | 2020-04-20 | Mitchell | Iowa | 19131 | 2 | 0 |
73693 | 73693 | 2020-04-20 | Monona | Iowa | 19133 | 7 | 0 |
73694 | 73694 | 2020-04-20 | Montgomery | Iowa | 19137 | 1 | 0 |
73695 | 73695 | 2020-04-20 | Muscatine | Iowa | 19139 | 218 | 4 |
73696 | 73696 | 2020-04-20 | O'Brien | Iowa | 19141 | 3 | 0 |
73697 | 73697 | 2020-04-20 | Osceola | Iowa | 19143 | 3 | 0 |
73698 | 73698 | 2020-04-20 | Page | Iowa | 19145 | 4 | 0 |
73699 | 73699 | 2020-04-20 | Plymouth | Iowa | 19149 | 8 | 0 |
73700 | 73700 | 2020-04-20 | Polk | Iowa | 19153 | 387 | 13 |
73701 | 73701 | 2020-04-20 | Pottawattamie | Iowa | 19155 | 18 | 1 |
73702 | 73702 | 2020-04-20 | Poweshiek | Iowa | 19157 | 13 | 1 |
73703 | 73703 | 2020-04-20 | Scott | Iowa | 19163 | 172 | 3 |
73704 | 73704 | 2020-04-20 | Shelby | Iowa | 19165 | 9 | 0 |
73705 | 73705 | 2020-04-20 | Sioux | Iowa | 19167 | 7 | 0 |
73706 | 73706 | 2020-04-20 | Story | Iowa | 19169 | 20 | 0 |
73707 | 73707 | 2020-04-20 | Tama | Iowa | 19171 | 198 | 6 |
73708 | 73708 | 2020-04-20 | Taylor | Iowa | 19173 | 1 | 0 |
73709 | 73709 | 2020-04-20 | Union | Iowa | 19175 | 1 | 0 |
73710 | 73710 | 2020-04-20 | Van Buren | Iowa | 19177 | 8 | 0 |
73711 | 73711 | 2020-04-20 | Wapello | Iowa | 19179 | 7 | 0 |
73712 | 73712 | 2020-04-20 | Warren | Iowa | 19181 | 20 | 0 |
73713 | 73713 | 2020-04-20 | Washington | Iowa | 19183 | 123 | 5 |
73714 | 73714 | 2020-04-20 | Webster | Iowa | 19187 | 4 | 0 |
73715 | 73715 | 2020-04-20 | Winnebago | Iowa | 19189 | 2 | 0 |
73716 | 73716 | 2020-04-20 | Winneshiek | Iowa | 19191 | 6 | 0 |
73717 | 73717 | 2020-04-20 | Woodbury | Iowa | 19193 | 44 | 0 |
73718 | 73718 | 2020-04-20 | Worth | Iowa | 19195 | 1 | 0 |
73719 | 73719 | 2020-04-20 | Wright | Iowa | 19197 | 1 | 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);