ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,070 rows where state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 100
- 19103 464
- 19155 463
- 19027 460
- 19085 459
- 19049 458
- 19005 457
- 19153 457
- 19001 455
- 19013 455
- 19183 454
- 19191 454
- 19061 453
- 19139 453
- 19065 451
- 19087 451
- 19113 451
- 19169 451
- 19033 450
- 19109 450
- 19157 450
- 19163 450
- 19167 450
- 19171 450
- 19193 450
- 19081 449
- 19179 449
- 19019 448
- 19031 448
- 19099 448
- 19181 448
- 19011 447
- 19007 446
- 19043 446
- 19057 446
- 19123 446
- 19133 446
- 19145 446
- 19023 445
- 19045 445
- 19059 445
- 19083 445
- 19095 445
- 19127 445
- 19137 445
- 19187 445
- 19197 445
- 19015 444
- 19107 444
- 19165 444
- 19173 444
- 19009 442
- 19047 442
- 19077 442
- 19097 442
- 19105 442
- 19177 442
- 19041 441
- 19121 440
- 19131 440
- 19017 439
- 19101 439
- 19141 439
- 19115 438
- 19119 438
- 19149 438
- 19075 437
- 19089 437
- 19111 437
- 19129 437
- 19039 436
- 19079 436
- 19037 435
- 19069 435
- 19125 435
- 19189 435
- 19021 434
- 19055 434
- 19073 434
- 19195 433
- 19143 431
- 19175 431
- 19029 428
- 19035 420
- 19091 420
- 19151 414
- 19051 412
- 19025 410
- 19067 410
- 19161 410
- 19185 410
- - 410
- 19135 408
- 19071 403
- 19147 403
- 19093 399
- 19063 398
- 19003 394
- 19117 394
- 19159 392
- 19053 384
county 100
- Johnson 464
- Pottawattamie 463
- Carroll 460
- Harrison 459
- Dallas 458
- Allamakee 457
- Polk 457
- Adair 455
- Black Hawk 455
- Washington 454
- Winneshiek 454
- Dubuque 453
- Muscatine 453
- Fayette 451
- Henry 451
- Linn 451
- Story 451
- Cerro Gordo 450
- Kossuth 450
- Poweshiek 450
- Scott 450
- Sioux 450
- Tama 450
- Woodbury 450
- Hancock 449
- Wapello 449
- Buchanan 448
- Cedar 448
- Jasper 448
- Warren 448
- Benton 447
- Appanoose 446
- Clayton 446
- Des Moines 446
- Mahaska 446
- Monona 446
- Page 446
- Butler 445
- Clinton 445
- Dickinson 445
- Hardin 445
- Iowa 445
- Marshall 445
- Montgomery 445
- Webster 445
- Wright 445
- Boone 444
- Keokuk 444
- Shelby 444
- Taylor 444
- Audubon 442
- Crawford 442
- Guthrie 442
- Jackson 442
- Jones 442
- Van Buren 442
- Clay 441
- Madison 440
- Mitchell 440
- Bremer 439
- Jefferson 439
- O'Brien 439
- Louisa 438
- Lyon 438
- Plymouth 438
- Grundy 437
- Howard 437
- Lee 437
- Mills 437
- Clarke 436
- Hamilton 436
- Chickasaw 435
- Franklin 435
- Marion 435
- Winnebago 435
- Buena Vista 434
- Delaware 434
- Greene 434
- Worth 433
- Osceola 431
- Union 431
- Cass 428
- Cherokee 420
- Humboldt 420
- Pocahontas 414
- Davis 412
- Calhoun 410
- Floyd 410
- Sac 410
- Unknown 410
- Wayne 410
- Monroe 408
- Fremont 403
- Palo Alto 403
- Ida 399
- Emmet 398
- Adams 394
- Lucas 394
- Ringgold 392
- Decatur 384
state 1
- Iowa · 43,770 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417925 | 1417925 | 2021-06-14 | Adair | Iowa | 19001 | 873 | 32 |
1417926 | 1417926 | 2021-06-14 | Adams | Iowa | 19003 | 344 | 4 |
1417927 | 1417927 | 2021-06-14 | Allamakee | Iowa | 19005 | 1526 | 52 |
1417928 | 1417928 | 2021-06-14 | Appanoose | Iowa | 19007 | 1290 | 49 |
1417929 | 1417929 | 2021-06-14 | Audubon | Iowa | 19009 | 529 | 10 |
1417930 | 1417930 | 2021-06-14 | Benton | Iowa | 19011 | 2591 | 55 |
1417931 | 1417931 | 2021-06-14 | Black Hawk | Iowa | 19013 | 16075 | 312 |
1417932 | 1417932 | 2021-06-14 | Boone | Iowa | 19015 | 2683 | 34 |
1417933 | 1417933 | 2021-06-14 | Bremer | Iowa | 19017 | 2878 | 60 |
1417934 | 1417934 | 2021-06-14 | Buchanan | Iowa | 19019 | 1933 | 33 |
1417935 | 1417935 | 2021-06-14 | Buena Vista | Iowa | 19021 | 4262 | 40 |
1417936 | 1417936 | 2021-06-14 | Butler | Iowa | 19023 | 1660 | 35 |
1417937 | 1417937 | 2021-06-14 | Calhoun | Iowa | 19025 | 1389 | 13 |
1417938 | 1417938 | 2021-06-14 | Carroll | Iowa | 19027 | 2868 | 52 |
1417939 | 1417939 | 2021-06-14 | Cass | Iowa | 19029 | 1392 | 55 |
1417940 | 1417940 | 2021-06-14 | Cedar | Iowa | 19031 | 1921 | 23 |
1417941 | 1417941 | 2021-06-14 | Cerro Gordo | Iowa | 19033 | 5533 | 93 |
1417942 | 1417942 | 2021-06-14 | Cherokee | Iowa | 19035 | 1594 | 38 |
1417943 | 1417943 | 2021-06-14 | Chickasaw | Iowa | 19037 | 1245 | 17 |
1417944 | 1417944 | 2021-06-14 | Clarke | Iowa | 19039 | 1009 | 24 |
1417945 | 1417945 | 2021-06-14 | Clay | Iowa | 19041 | 2165 | 27 |
1417946 | 1417946 | 2021-06-14 | Clayton | Iowa | 19043 | 1710 | 57 |
1417947 | 1417947 | 2021-06-14 | Clinton | Iowa | 19045 | 5614 | 93 |
1417948 | 1417948 | 2021-06-14 | Crawford | Iowa | 19047 | 2679 | 40 |
1417949 | 1417949 | 2021-06-14 | Dallas | Iowa | 19049 | 11286 | 99 |
1417950 | 1417950 | 2021-06-14 | Davis | Iowa | 19051 | 852 | 25 |
1417951 | 1417951 | 2021-06-14 | Decatur | Iowa | 19053 | 615 | 9 |
1417952 | 1417952 | 2021-06-14 | Delaware | Iowa | 19055 | 2109 | 43 |
1417953 | 1417953 | 2021-06-14 | Des Moines | Iowa | 19057 | 4669 | 70 |
1417954 | 1417954 | 2021-06-14 | Dickinson | Iowa | 19059 | 2494 | 44 |
1417955 | 1417955 | 2021-06-14 | Dubuque | Iowa | 19061 | 13500 | 211 |
1417956 | 1417956 | 2021-06-14 | Emmet | Iowa | 19063 | 1358 | 41 |
1417957 | 1417957 | 2021-06-14 | Fayette | Iowa | 19065 | 1864 | 43 |
1417958 | 1417958 | 2021-06-14 | Floyd | Iowa | 19067 | 1630 | 42 |
1417959 | 1417959 | 2021-06-14 | Franklin | Iowa | 19069 | 1233 | 23 |
1417960 | 1417960 | 2021-06-14 | Fremont | Iowa | 19071 | 626 | 9 |
1417961 | 1417961 | 2021-06-14 | Greene | Iowa | 19073 | 780 | 11 |
1417962 | 1417962 | 2021-06-14 | Grundy | Iowa | 19075 | 1371 | 33 |
1417963 | 1417963 | 2021-06-14 | Guthrie | Iowa | 19077 | 1230 | 32 |
1417964 | 1417964 | 2021-06-14 | Hamilton | Iowa | 19079 | 1817 | 51 |
1417965 | 1417965 | 2021-06-14 | Hancock | Iowa | 19081 | 1501 | 34 |
1417966 | 1417966 | 2021-06-14 | Hardin | Iowa | 19083 | 1873 | 44 |
1417967 | 1417967 | 2021-06-14 | Harrison | Iowa | 19085 | 1799 | 73 |
1417968 | 1417968 | 2021-06-14 | Henry | Iowa | 19087 | 2942 | 37 |
1417969 | 1417969 | 2021-06-14 | Howard | Iowa | 19089 | 1050 | 22 |
1417970 | 1417970 | 2021-06-14 | Humboldt | Iowa | 19091 | 1195 | 26 |
1417971 | 1417971 | 2021-06-14 | Ida | Iowa | 19093 | 916 | 35 |
1417972 | 1417972 | 2021-06-14 | Iowa | Iowa | 19095 | 1498 | 24 |
1417973 | 1417973 | 2021-06-14 | Jackson | Iowa | 19097 | 2252 | 42 |
1417974 | 1417974 | 2021-06-14 | Jasper | Iowa | 19099 | 4208 | 72 |
1417975 | 1417975 | 2021-06-14 | Jefferson | Iowa | 19101 | 1334 | 35 |
1417976 | 1417976 | 2021-06-14 | Johnson | Iowa | 19103 | 14613 | 85 |
1417977 | 1417977 | 2021-06-14 | Jones | Iowa | 19105 | 3008 | 57 |
1417978 | 1417978 | 2021-06-14 | Keokuk | Iowa | 19107 | 964 | 32 |
1417979 | 1417979 | 2021-06-14 | Kossuth | Iowa | 19109 | 2162 | 66 |
1417980 | 1417980 | 2021-06-14 | Lee | Iowa | 19111 | 3820 | 56 |
1417981 | 1417981 | 2021-06-14 | Linn | Iowa | 19113 | 21185 | 339 |
1417982 | 1417982 | 2021-06-14 | Louisa | Iowa | 19115 | 1297 | 49 |
1417983 | 1417983 | 2021-06-14 | Lucas | Iowa | 19117 | 779 | 23 |
1417984 | 1417984 | 2021-06-14 | Lyon | Iowa | 19119 | 1588 | 41 |
1417985 | 1417985 | 2021-06-14 | Madison | Iowa | 19121 | 1644 | 19 |
1417986 | 1417986 | 2021-06-14 | Mahaska | Iowa | 19123 | 2322 | 51 |
1417987 | 1417987 | 2021-06-14 | Marion | Iowa | 19125 | 3659 | 76 |
1417988 | 1417988 | 2021-06-14 | Marshall | Iowa | 19127 | 4864 | 76 |
1417989 | 1417989 | 2021-06-14 | Mills | Iowa | 19129 | 1633 | 24 |
1417990 | 1417990 | 2021-06-14 | Mitchell | Iowa | 19131 | 1266 | 43 |
1417991 | 1417991 | 2021-06-14 | Monona | Iowa | 19133 | 829 | 31 |
1417992 | 1417992 | 2021-06-14 | Monroe | Iowa | 19135 | 962 | 30 |
1417993 | 1417993 | 2021-06-14 | Montgomery | Iowa | 19137 | 1036 | 38 |
1417994 | 1417994 | 2021-06-14 | Muscatine | Iowa | 19139 | 4876 | 106 |
1417995 | 1417995 | 2021-06-14 | O'Brien | Iowa | 19141 | 1997 | 61 |
1417996 | 1417996 | 2021-06-14 | Osceola | Iowa | 19143 | 790 | 16 |
1417997 | 1417997 | 2021-06-14 | Page | Iowa | 19145 | 1945 | 22 |
1417998 | 1417998 | 2021-06-14 | Palo Alto | Iowa | 19147 | 1136 | 23 |
1417999 | 1417999 | 2021-06-14 | Plymouth | Iowa | 19149 | 4029 | 81 |
1418000 | 1418000 | 2021-06-14 | Pocahontas | Iowa | 19151 | 858 | 22 |
1418001 | 1418001 | 2021-06-14 | Polk | Iowa | 19153 | 58195 | 638 |
1418002 | 1418002 | 2021-06-14 | Pottawattamie | Iowa | 19155 | 11218 | 173 |
1418003 | 1418003 | 2021-06-14 | Poweshiek | Iowa | 19157 | 1569 | 36 |
1418004 | 1418004 | 2021-06-14 | Ringgold | Iowa | 19159 | 563 | 24 |
1418005 | 1418005 | 2021-06-14 | Sac | Iowa | 19161 | 1308 | 20 |
1418006 | 1418006 | 2021-06-14 | Scott | Iowa | 19163 | 20289 | 246 |
1418007 | 1418007 | 2021-06-14 | Shelby | Iowa | 19165 | 1316 | 37 |
1418008 | 1418008 | 2021-06-14 | Sioux | Iowa | 19167 | 5169 | 74 |
1418009 | 1418009 | 2021-06-14 | Story | Iowa | 19169 | 10710 | 48 |
1418010 | 1418010 | 2021-06-14 | Tama | Iowa | 19171 | 2117 | 71 |
1418011 | 1418011 | 2021-06-14 | Taylor | Iowa | 19173 | 667 | 12 |
1418012 | 1418012 | 2021-06-14 | Union | Iowa | 19175 | 1299 | 35 |
1418013 | 1418013 | 2021-06-14 | Unknown | Iowa | 931 | 0 | |
1418014 | 1418014 | 2021-06-14 | Van Buren | Iowa | 19177 | 564 | 18 |
1418015 | 1418015 | 2021-06-14 | Wapello | Iowa | 19179 | 4335 | 122 |
1418016 | 1418016 | 2021-06-14 | Warren | Iowa | 19181 | 5837 | 91 |
1418017 | 1418017 | 2021-06-14 | Washington | Iowa | 19183 | 2570 | 51 |
1418018 | 1418018 | 2021-06-14 | Wayne | Iowa | 19185 | 544 | 23 |
1418019 | 1418019 | 2021-06-14 | Webster | Iowa | 19187 | 5152 | 94 |
1418020 | 1418020 | 2021-06-14 | Winnebago | Iowa | 19189 | 1443 | 31 |
1418021 | 1418021 | 2021-06-14 | Winneshiek | Iowa | 19191 | 1980 | 35 |
1418022 | 1418022 | 2021-06-14 | Woodbury | Iowa | 19193 | 15229 | 230 |
1418023 | 1418023 | 2021-06-14 | Worth | Iowa | 19195 | 759 | 8 |
1418024 | 1418024 | 2021-06-14 | Wright | Iowa | 19197 | 1858 | 40 |
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);