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-12 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 |
---|---|---|---|---|---|---|---|
231589 | 231589 | 2020-06-12 | Adair | Iowa | 19001 | 11 | 0 |
231590 | 231590 | 2020-06-12 | Adams | Iowa | 19003 | 7 | 0 |
231591 | 231591 | 2020-06-12 | Allamakee | Iowa | 19005 | 121 | 4 |
231592 | 231592 | 2020-06-12 | Appanoose | Iowa | 19007 | 16 | 3 |
231593 | 231593 | 2020-06-12 | Audubon | Iowa | 19009 | 13 | 1 |
231594 | 231594 | 2020-06-12 | Benton | Iowa | 19011 | 46 | 1 |
231595 | 231595 | 2020-06-12 | Black Hawk | Iowa | 19013 | 1825 | 53 |
231596 | 231596 | 2020-06-12 | Boone | Iowa | 19015 | 94 | 0 |
231597 | 231597 | 2020-06-12 | Bremer | Iowa | 19017 | 74 | 6 |
231598 | 231598 | 2020-06-12 | Buchanan | Iowa | 19019 | 34 | 1 |
231599 | 231599 | 2020-06-12 | Buena Vista | Iowa | 19021 | 1488 | 6 |
231600 | 231600 | 2020-06-12 | Butler | Iowa | 19023 | 19 | 2 |
231601 | 231601 | 2020-06-12 | Calhoun | Iowa | 19025 | 19 | 0 |
231602 | 231602 | 2020-06-12 | Carroll | Iowa | 19027 | 34 | 1 |
231603 | 231603 | 2020-06-12 | Cass | Iowa | 19029 | 13 | 0 |
231604 | 231604 | 2020-06-12 | Cedar | Iowa | 19031 | 53 | 1 |
231605 | 231605 | 2020-06-12 | Cerro Gordo | Iowa | 19033 | 41 | 1 |
231606 | 231606 | 2020-06-12 | Cherokee | Iowa | 19035 | 56 | 0 |
231607 | 231607 | 2020-06-12 | Chickasaw | Iowa | 19037 | 15 | 0 |
231608 | 231608 | 2020-06-12 | Clarke | Iowa | 19039 | 86 | 1 |
231609 | 231609 | 2020-06-12 | Clay | Iowa | 19041 | 62 | 0 |
231610 | 231610 | 2020-06-12 | Clayton | Iowa | 19043 | 35 | 3 |
231611 | 231611 | 2020-06-12 | Clinton | Iowa | 19045 | 67 | 1 |
231612 | 231612 | 2020-06-12 | Crawford | Iowa | 19047 | 595 | 2 |
231613 | 231613 | 2020-06-12 | Dallas | Iowa | 19049 | 1005 | 26 |
231614 | 231614 | 2020-06-12 | Davis | Iowa | 19051 | 33 | 1 |
231615 | 231615 | 2020-06-12 | Decatur | Iowa | 19053 | 4 | 0 |
231616 | 231616 | 2020-06-12 | Delaware | Iowa | 19055 | 27 | 1 |
231617 | 231617 | 2020-06-12 | Des Moines | Iowa | 19057 | 68 | 2 |
231618 | 231618 | 2020-06-12 | Dickinson | Iowa | 19059 | 122 | 0 |
231619 | 231619 | 2020-06-12 | Dubuque | Iowa | 19061 | 383 | 21 |
231620 | 231620 | 2020-06-12 | Emmet | Iowa | 19063 | 38 | 0 |
231621 | 231621 | 2020-06-12 | Fayette | Iowa | 19065 | 28 | 0 |
231622 | 231622 | 2020-06-12 | Floyd | Iowa | 19067 | 20 | 1 |
231623 | 231623 | 2020-06-12 | Franklin | Iowa | 19069 | 42 | 0 |
231624 | 231624 | 2020-06-12 | Fremont | Iowa | 19071 | 4 | 0 |
231625 | 231625 | 2020-06-12 | Greene | Iowa | 19073 | 20 | 0 |
231626 | 231626 | 2020-06-12 | Grundy | Iowa | 19075 | 24 | 0 |
231627 | 231627 | 2020-06-12 | Guthrie | Iowa | 19077 | 57 | 3 |
231628 | 231628 | 2020-06-12 | Hamilton | Iowa | 19079 | 112 | 0 |
231629 | 231629 | 2020-06-12 | Hancock | Iowa | 19081 | 26 | 0 |
231630 | 231630 | 2020-06-12 | Hardin | Iowa | 19083 | 42 | 0 |
231631 | 231631 | 2020-06-12 | Harrison | Iowa | 19085 | 33 | 0 |
231632 | 231632 | 2020-06-12 | Henry | Iowa | 19087 | 73 | 2 |
231633 | 231633 | 2020-06-12 | Howard | Iowa | 19089 | 12 | 0 |
231634 | 231634 | 2020-06-12 | Humboldt | Iowa | 19091 | 30 | 1 |
231635 | 231635 | 2020-06-12 | Ida | Iowa | 19093 | 17 | 0 |
231636 | 231636 | 2020-06-12 | Iowa | Iowa | 19095 | 34 | 0 |
231637 | 231637 | 2020-06-12 | Jackson | Iowa | 19097 | 14 | 0 |
231638 | 231638 | 2020-06-12 | Jasper | Iowa | 19099 | 279 | 17 |
231639 | 231639 | 2020-06-12 | Jefferson | Iowa | 19101 | 44 | 0 |
231640 | 231640 | 2020-06-12 | Johnson | Iowa | 19103 | 636 | 8 |
231641 | 231641 | 2020-06-12 | Jones | Iowa | 19105 | 41 | 0 |
231642 | 231642 | 2020-06-12 | Keokuk | Iowa | 19107 | 15 | 0 |
231643 | 231643 | 2020-06-12 | Kossuth | Iowa | 19109 | 16 | 0 |
231644 | 231644 | 2020-06-12 | Lee | Iowa | 19111 | 37 | 1 |
231645 | 231645 | 2020-06-12 | Linn | Iowa | 19113 | 1014 | 80 |
231646 | 231646 | 2020-06-12 | Louisa | Iowa | 19115 | 355 | 11 |
231647 | 231647 | 2020-06-12 | Lucas | Iowa | 19117 | 23 | 3 |
231648 | 231648 | 2020-06-12 | Lyon | Iowa | 19119 | 30 | 0 |
231649 | 231649 | 2020-06-12 | Madison | Iowa | 19121 | 31 | 2 |
231650 | 231650 | 2020-06-12 | Mahaska | Iowa | 19123 | 107 | 14 |
231651 | 231651 | 2020-06-12 | Marion | Iowa | 19125 | 40 | 0 |
231652 | 231652 | 2020-06-12 | Marshall | Iowa | 19127 | 940 | 18 |
231653 | 231653 | 2020-06-12 | Mills | Iowa | 19129 | 22 | 0 |
231654 | 231654 | 2020-06-12 | Mitchell | Iowa | 19131 | 6 | 0 |
231655 | 231655 | 2020-06-12 | Monona | Iowa | 19133 | 32 | 0 |
231656 | 231656 | 2020-06-12 | Monroe | Iowa | 19135 | 47 | 6 |
231657 | 231657 | 2020-06-12 | Montgomery | Iowa | 19137 | 9 | 2 |
231658 | 231658 | 2020-06-12 | Muscatine | Iowa | 19139 | 572 | 43 |
231659 | 231659 | 2020-06-12 | O'Brien | Iowa | 19141 | 64 | 1 |
231660 | 231660 | 2020-06-12 | Osceola | Iowa | 19143 | 49 | 0 |
231661 | 231661 | 2020-06-12 | Page | Iowa | 19145 | 16 | 0 |
231662 | 231662 | 2020-06-12 | Palo Alto | Iowa | 19147 | 13 | 0 |
231663 | 231663 | 2020-06-12 | Plymouth | Iowa | 19149 | 196 | 4 |
231664 | 231664 | 2020-06-12 | Pocahontas | Iowa | 19151 | 30 | 0 |
231665 | 231665 | 2020-06-12 | Polk | Iowa | 19153 | 5046 | 159 |
231666 | 231666 | 2020-06-12 | Pottawattamie | Iowa | 19155 | 489 | 10 |
231667 | 231667 | 2020-06-12 | Poweshiek | Iowa | 19157 | 95 | 8 |
231668 | 231668 | 2020-06-12 | Ringgold | Iowa | 19159 | 8 | 0 |
231669 | 231669 | 2020-06-12 | Sac | Iowa | 19161 | 37 | 0 |
231670 | 231670 | 2020-06-12 | Scott | Iowa | 19163 | 404 | 10 |
231671 | 231671 | 2020-06-12 | Shelby | Iowa | 19165 | 43 | 0 |
231672 | 231672 | 2020-06-12 | Sioux | Iowa | 19167 | 351 | 0 |
231673 | 231673 | 2020-06-12 | Story | Iowa | 19169 | 216 | 2 |
231674 | 231674 | 2020-06-12 | Tama | Iowa | 19171 | 427 | 29 |
231675 | 231675 | 2020-06-12 | Taylor | Iowa | 19173 | 72 | 0 |
231676 | 231676 | 2020-06-12 | Union | Iowa | 19175 | 10 | 0 |
231677 | 231677 | 2020-06-12 | Unknown | Iowa | 6 | 0 | |
231678 | 231678 | 2020-06-12 | Van Buren | Iowa | 19177 | 11 | 0 |
231679 | 231679 | 2020-06-12 | Wapello | Iowa | 19179 | 672 | 26 |
231680 | 231680 | 2020-06-12 | Warren | Iowa | 19181 | 191 | 1 |
231681 | 231681 | 2020-06-12 | Washington | Iowa | 19183 | 208 | 9 |
231682 | 231682 | 2020-06-12 | Wayne | Iowa | 19185 | 4 | 0 |
231683 | 231683 | 2020-06-12 | Webster | Iowa | 19187 | 95 | 1 |
231684 | 231684 | 2020-06-12 | Winnebago | Iowa | 19189 | 12 | 0 |
231685 | 231685 | 2020-06-12 | Winneshiek | Iowa | 19191 | 24 | 0 |
231686 | 231686 | 2020-06-12 | Woodbury | Iowa | 19193 | 2994 | 40 |
231687 | 231687 | 2020-06-12 | Worth | Iowa | 19195 | 4 | 0 |
231688 | 231688 | 2020-06-12 | Wright | Iowa | 19197 | 280 | 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);