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 2021-10-09 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
1797916 | 1797916 | 2021-10-09 | Adair | Iowa | 19001 | 1010 | 34 |
1797917 | 1797917 | 2021-10-09 | Adams | Iowa | 19003 | 482 | 4 |
1797918 | 1797918 | 2021-10-09 | Allamakee | Iowa | 19005 | 1893 | 52 |
1797919 | 1797919 | 2021-10-09 | Appanoose | Iowa | 19007 | 1712 | 50 |
1797920 | 1797920 | 2021-10-09 | Audubon | Iowa | 19009 | 631 | 14 |
1797921 | 1797921 | 2021-10-09 | Benton | Iowa | 19011 | 3453 | 56 |
1797922 | 1797922 | 2021-10-09 | Black Hawk | Iowa | 19013 | 19899 | 345 |
1797923 | 1797923 | 2021-10-09 | Boone | Iowa | 19015 | 3387 | 36 |
1797924 | 1797924 | 2021-10-09 | Bremer | Iowa | 19017 | 3477 | 66 |
1797925 | 1797925 | 2021-10-09 | Buchanan | Iowa | 19019 | 2654 | 39 |
1797926 | 1797926 | 2021-10-09 | Buena Vista | Iowa | 19021 | 4868 | 43 |
1797927 | 1797927 | 2021-10-09 | Butler | Iowa | 19023 | 2003 | 37 |
1797928 | 1797928 | 2021-10-09 | Calhoun | Iowa | 19025 | 1827 | 13 |
1797929 | 1797929 | 2021-10-09 | Carroll | Iowa | 19027 | 3384 | 53 |
1797930 | 1797930 | 2021-10-09 | Cass | Iowa | 19029 | 1821 | 56 |
1797931 | 1797931 | 2021-10-09 | Cedar | Iowa | 19031 | 2397 | 25 |
1797932 | 1797932 | 2021-10-09 | Cerro Gordo | Iowa | 19033 | 6702 | 107 |
1797933 | 1797933 | 2021-10-09 | Cherokee | Iowa | 19035 | 1896 | 41 |
1797934 | 1797934 | 2021-10-09 | Chickasaw | Iowa | 19037 | 1523 | 18 |
1797935 | 1797935 | 2021-10-09 | Clarke | Iowa | 19039 | 1384 | 27 |
1797936 | 1797936 | 2021-10-09 | Clay | Iowa | 19041 | 2711 | 29 |
1797937 | 1797937 | 2021-10-09 | Clayton | Iowa | 19043 | 2070 | 58 |
1797938 | 1797938 | 2021-10-09 | Clinton | Iowa | 19045 | 6667 | 99 |
1797939 | 1797939 | 2021-10-09 | Crawford | Iowa | 19047 | 3346 | 45 |
1797940 | 1797940 | 2021-10-09 | Dallas | Iowa | 19049 | 13679 | 102 |
1797941 | 1797941 | 2021-10-09 | Davis | Iowa | 19051 | 1123 | 25 |
1797942 | 1797942 | 2021-10-09 | Decatur | Iowa | 19053 | 795 | 12 |
1797943 | 1797943 | 2021-10-09 | Delaware | Iowa | 19055 | 2499 | 44 |
1797944 | 1797944 | 2021-10-09 | Des Moines | Iowa | 19057 | 6466 | 88 |
1797945 | 1797945 | 2021-10-09 | Dickinson | Iowa | 19059 | 2915 | 51 |
1797946 | 1797946 | 2021-10-09 | Dubuque | Iowa | 19061 | 15269 | 226 |
1797947 | 1797947 | 2021-10-09 | Emmet | Iowa | 19063 | 1604 | 42 |
1797948 | 1797948 | 2021-10-09 | Fayette | Iowa | 19065 | 2471 | 47 |
1797949 | 1797949 | 2021-10-09 | Floyd | Iowa | 19067 | 2102 | 43 |
1797950 | 1797950 | 2021-10-09 | Franklin | Iowa | 19069 | 1605 | 26 |
1797951 | 1797951 | 2021-10-09 | Fremont | Iowa | 19071 | 810 | 11 |
1797952 | 1797952 | 2021-10-09 | Greene | Iowa | 19073 | 1117 | 12 |
1797953 | 1797953 | 2021-10-09 | Grundy | Iowa | 19075 | 1652 | 37 |
1797954 | 1797954 | 2021-10-09 | Guthrie | Iowa | 19077 | 1499 | 33 |
1797955 | 1797955 | 2021-10-09 | Hamilton | Iowa | 19079 | 2263 | 53 |
1797956 | 1797956 | 2021-10-09 | Hancock | Iowa | 19081 | 1813 | 39 |
1797957 | 1797957 | 2021-10-09 | Hardin | Iowa | 19083 | 2604 | 48 |
1797958 | 1797958 | 2021-10-09 | Harrison | Iowa | 19085 | 2131 | 77 |
1797959 | 1797959 | 2021-10-09 | Henry | Iowa | 19087 | 3713 | 43 |
1797960 | 1797960 | 2021-10-09 | Howard | Iowa | 19089 | 1222 | 22 |
1797961 | 1797961 | 2021-10-09 | Humboldt | Iowa | 19091 | 1593 | 26 |
1797962 | 1797962 | 2021-10-09 | Ida | Iowa | 19093 | 1145 | 40 |
1797963 | 1797963 | 2021-10-09 | Iowa | Iowa | 19095 | 2003 | 27 |
1797964 | 1797964 | 2021-10-09 | Jackson | Iowa | 19097 | 2654 | 45 |
1797965 | 1797965 | 2021-10-09 | Jasper | Iowa | 19099 | 5604 | 76 |
1797966 | 1797966 | 2021-10-09 | Jefferson | Iowa | 19101 | 1930 | 38 |
1797967 | 1797967 | 2021-10-09 | Johnson | Iowa | 19103 | 17624 | 98 |
1797968 | 1797968 | 2021-10-09 | Jones | Iowa | 19105 | 3572 | 59 |
1797969 | 1797969 | 2021-10-09 | Keokuk | Iowa | 19107 | 1345 | 34 |
1797970 | 1797970 | 2021-10-09 | Kossuth | Iowa | 19109 | 2657 | 72 |
1797971 | 1797971 | 2021-10-09 | Lee | Iowa | 19111 | 5536 | 86 |
1797972 | 1797972 | 2021-10-09 | Linn | Iowa | 19113 | 28154 | 375 |
1797973 | 1797973 | 2021-10-09 | Louisa | Iowa | 19115 | 1677 | 51 |
1797974 | 1797974 | 2021-10-09 | Lucas | Iowa | 19117 | 1096 | 24 |
1797975 | 1797975 | 2021-10-09 | Lyon | Iowa | 19119 | 1875 | 41 |
1797976 | 1797976 | 2021-10-09 | Madison | Iowa | 19121 | 2099 | 23 |
1797977 | 1797977 | 2021-10-09 | Mahaska | Iowa | 19123 | 3050 | 56 |
1797978 | 1797978 | 2021-10-09 | Marion | Iowa | 19125 | 4889 | 89 |
1797979 | 1797979 | 2021-10-09 | Marshall | Iowa | 19127 | 6259 | 83 |
1797980 | 1797980 | 2021-10-09 | Mills | Iowa | 19129 | 1941 | 26 |
1797981 | 1797981 | 2021-10-09 | Mitchell | Iowa | 19131 | 1586 | 43 |
1797982 | 1797982 | 2021-10-09 | Monona | Iowa | 19133 | 1051 | 35 |
1797983 | 1797983 | 2021-10-09 | Monroe | Iowa | 19135 | 1288 | 34 |
1797984 | 1797984 | 2021-10-09 | Montgomery | Iowa | 19137 | 1361 | 41 |
1797985 | 1797985 | 2021-10-09 | Muscatine | Iowa | 19139 | 6228 | 113 |
1797986 | 1797986 | 2021-10-09 | O'Brien | Iowa | 19141 | 2196 | 63 |
1797987 | 1797987 | 2021-10-09 | Osceola | Iowa | 19143 | 887 | 17 |
1797988 | 1797988 | 2021-10-09 | Page | Iowa | 19145 | 2381 | 24 |
1797989 | 1797989 | 2021-10-09 | Palo Alto | Iowa | 19147 | 1393 | 30 |
1797990 | 1797990 | 2021-10-09 | Plymouth | Iowa | 19149 | 4542 | 87 |
1797991 | 1797991 | 2021-10-09 | Pocahontas | Iowa | 19151 | 1068 | 23 |
1797992 | 1797992 | 2021-10-09 | Polk | Iowa | 19153 | 72571 | 710 |
1797993 | 1797993 | 2021-10-09 | Pottawattamie | Iowa | 19155 | 13843 | 192 |
1797994 | 1797994 | 2021-10-09 | Poweshiek | Iowa | 19157 | 2026 | 39 |
1797995 | 1797995 | 2021-10-09 | Ringgold | Iowa | 19159 | 654 | 27 |
1797996 | 1797996 | 2021-10-09 | Sac | Iowa | 19161 | 1535 | 23 |
1797997 | 1797997 | 2021-10-09 | Scott | Iowa | 19163 | 24172 | 270 |
1797998 | 1797998 | 2021-10-09 | Shelby | Iowa | 19165 | 1692 | 39 |
1797999 | 1797999 | 2021-10-09 | Sioux | Iowa | 19167 | 5568 | 76 |
1798000 | 1798000 | 2021-10-09 | Story | Iowa | 19169 | 12593 | 48 |
1798001 | 1798001 | 2021-10-09 | Tama | Iowa | 19171 | 2586 | 75 |
1798002 | 1798002 | 2021-10-09 | Taylor | Iowa | 19173 | 770 | 12 |
1798003 | 1798003 | 2021-10-09 | Union | Iowa | 19175 | 1569 | 37 |
1798004 | 1798004 | 2021-10-09 | Unknown | Iowa | 3085 | 0 | |
1798005 | 1798005 | 2021-10-09 | Van Buren | Iowa | 19177 | 811 | 21 |
1798006 | 1798006 | 2021-10-09 | Wapello | Iowa | 19179 | 5661 | 134 |
1798007 | 1798007 | 2021-10-09 | Warren | Iowa | 19181 | 7435 | 96 |
1798008 | 1798008 | 2021-10-09 | Washington | Iowa | 19183 | 3553 | 55 |
1798009 | 1798009 | 2021-10-09 | Wayne | Iowa | 19185 | 708 | 24 |
1798010 | 1798010 | 2021-10-09 | Webster | Iowa | 19187 | 6796 | 107 |
1798011 | 1798011 | 2021-10-09 | Winnebago | Iowa | 19189 | 1832 | 32 |
1798012 | 1798012 | 2021-10-09 | Winneshiek | Iowa | 19191 | 2277 | 37 |
1798013 | 1798013 | 2021-10-09 | Woodbury | Iowa | 19193 | 18442 | 241 |
1798014 | 1798014 | 2021-10-09 | Worth | Iowa | 19195 | 1035 | 8 |
1798015 | 1798015 | 2021-10-09 | Wright | Iowa | 19197 | 2350 | 44 |
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);