ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-03-21" 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 |
---|---|---|---|---|---|---|---|
1141945 | 1141945 | 2021-03-21 | Adair | Iowa | 19001 | 834 | 31 |
1141946 | 1141946 | 2021-03-21 | Adams | Iowa | 19003 | 319 | 4 |
1141947 | 1141947 | 2021-03-21 | Allamakee | Iowa | 19005 | 1474 | 48 |
1141948 | 1141948 | 2021-03-21 | Appanoose | Iowa | 19007 | 1246 | 47 |
1141949 | 1141949 | 2021-03-21 | Audubon | Iowa | 19009 | 479 | 9 |
1141950 | 1141950 | 2021-03-21 | Benton | Iowa | 19011 | 2451 | 54 |
1141951 | 1141951 | 2021-03-21 | Black Hawk | Iowa | 19013 | 15146 | 299 |
1141952 | 1141952 | 2021-03-21 | Boone | Iowa | 19015 | 2485 | 30 |
1141953 | 1141953 | 2021-03-21 | Bremer | Iowa | 19017 | 2741 | 57 |
1141954 | 1141954 | 2021-03-21 | Buchanan | Iowa | 19019 | 1820 | 30 |
1141955 | 1141955 | 2021-03-21 | Buena Vista | Iowa | 19021 | 4166 | 38 |
1141956 | 1141956 | 2021-03-21 | Butler | Iowa | 19023 | 1606 | 32 |
1141957 | 1141957 | 2021-03-21 | Calhoun | Iowa | 19025 | 1316 | 11 |
1141958 | 1141958 | 2021-03-21 | Carroll | Iowa | 19027 | 2713 | 49 |
1141959 | 1141959 | 2021-03-21 | Cass | Iowa | 19029 | 1320 | 52 |
1141960 | 1141960 | 2021-03-21 | Cedar | Iowa | 19031 | 1763 | 23 |
1141961 | 1141961 | 2021-03-21 | Cerro Gordo | Iowa | 19033 | 5061 | 85 |
1141962 | 1141962 | 2021-03-21 | Cherokee | Iowa | 19035 | 1513 | 37 |
1141963 | 1141963 | 2021-03-21 | Chickasaw | Iowa | 19037 | 1208 | 15 |
1141964 | 1141964 | 2021-03-21 | Clarke | Iowa | 19039 | 966 | 21 |
1141965 | 1141965 | 2021-03-21 | Clay | Iowa | 19041 | 1932 | 25 |
1141966 | 1141966 | 2021-03-21 | Clayton | Iowa | 19043 | 1617 | 55 |
1141967 | 1141967 | 2021-03-21 | Clinton | Iowa | 19045 | 5099 | 87 |
1141968 | 1141968 | 2021-03-21 | Crawford | Iowa | 19047 | 2583 | 36 |
1141969 | 1141969 | 2021-03-21 | Dallas | Iowa | 19049 | 10464 | 93 |
1141970 | 1141970 | 2021-03-21 | Davis | Iowa | 19051 | 777 | 24 |
1141971 | 1141971 | 2021-03-21 | Decatur | Iowa | 19053 | 577 | 9 |
1141972 | 1141972 | 2021-03-21 | Delaware | Iowa | 19055 | 1899 | 40 |
1141973 | 1141973 | 2021-03-21 | Des Moines | Iowa | 19057 | 4329 | 63 |
1141974 | 1141974 | 2021-03-21 | Dickinson | Iowa | 19059 | 2162 | 41 |
1141975 | 1141975 | 2021-03-21 | Dubuque | Iowa | 19061 | 12562 | 200 |
1141976 | 1141976 | 2021-03-21 | Emmet | Iowa | 19063 | 1183 | 40 |
1141977 | 1141977 | 2021-03-21 | Fayette | Iowa | 19065 | 1807 | 37 |
1141978 | 1141978 | 2021-03-21 | Floyd | Iowa | 19067 | 1508 | 41 |
1141979 | 1141979 | 2021-03-21 | Franklin | Iowa | 19069 | 1105 | 20 |
1141980 | 1141980 | 2021-03-21 | Fremont | Iowa | 19071 | 571 | 10 |
1141981 | 1141981 | 2021-03-21 | Greene | Iowa | 19073 | 747 | 10 |
1141982 | 1141982 | 2021-03-21 | Grundy | Iowa | 19075 | 1331 | 31 |
1141983 | 1141983 | 2021-03-21 | Guthrie | Iowa | 19077 | 1113 | 28 |
1141984 | 1141984 | 2021-03-21 | Hamilton | Iowa | 19079 | 1751 | 44 |
1141985 | 1141985 | 2021-03-21 | Hancock | Iowa | 19081 | 1396 | 33 |
1141986 | 1141986 | 2021-03-21 | Hardin | Iowa | 19083 | 1739 | 39 |
1141987 | 1141987 | 2021-03-21 | Harrison | Iowa | 19085 | 1700 | 70 |
1141988 | 1141988 | 2021-03-21 | Henry | Iowa | 19087 | 2816 | 37 |
1141989 | 1141989 | 2021-03-21 | Howard | Iowa | 19089 | 1016 | 22 |
1141990 | 1141990 | 2021-03-21 | Humboldt | Iowa | 19091 | 1158 | 25 |
1141991 | 1141991 | 2021-03-21 | Ida | Iowa | 19093 | 863 | 32 |
1141992 | 1141992 | 2021-03-21 | Iowa | Iowa | 19095 | 1428 | 23 |
1141993 | 1141993 | 2021-03-21 | Jackson | Iowa | 19097 | 2126 | 40 |
1141994 | 1141994 | 2021-03-21 | Jasper | Iowa | 19099 | 3941 | 69 |
1141995 | 1141995 | 2021-03-21 | Jefferson | Iowa | 19101 | 1294 | 35 |
1141996 | 1141996 | 2021-03-21 | Johnson | Iowa | 19103 | 13335 | 76 |
1141997 | 1141997 | 2021-03-21 | Jones | Iowa | 19105 | 2880 | 55 |
1141998 | 1141998 | 2021-03-21 | Keokuk | Iowa | 19107 | 930 | 29 |
1141999 | 1141999 | 2021-03-21 | Kossuth | Iowa | 19109 | 2035 | 58 |
1142000 | 1142000 | 2021-03-21 | Lee | Iowa | 19111 | 3552 | 54 |
1142001 | 1142001 | 2021-03-21 | Linn | Iowa | 19113 | 19722 | 321 |
1142002 | 1142002 | 2021-03-21 | Louisa | Iowa | 19115 | 1240 | 48 |
1142003 | 1142003 | 2021-03-21 | Lucas | Iowa | 19117 | 743 | 21 |
1142004 | 1142004 | 2021-03-21 | Lyon | Iowa | 19119 | 1483 | 41 |
1142005 | 1142005 | 2021-03-21 | Madison | Iowa | 19121 | 1482 | 19 |
1142006 | 1142006 | 2021-03-21 | Mahaska | Iowa | 19123 | 2181 | 47 |
1142007 | 1142007 | 2021-03-21 | Marion | Iowa | 19125 | 3473 | 74 |
1142008 | 1142008 | 2021-03-21 | Marshall | Iowa | 19127 | 4707 | 74 |
1142009 | 1142009 | 2021-03-21 | Mills | Iowa | 19129 | 1528 | 20 |
1142010 | 1142010 | 2021-03-21 | Mitchell | Iowa | 19131 | 1230 | 40 |
1142011 | 1142011 | 2021-03-21 | Monona | Iowa | 19133 | 781 | 30 |
1142012 | 1142012 | 2021-03-21 | Monroe | Iowa | 19135 | 912 | 28 |
1142013 | 1142013 | 2021-03-21 | Montgomery | Iowa | 19137 | 974 | 36 |
1142014 | 1142014 | 2021-03-21 | Muscatine | Iowa | 19139 | 4357 | 94 |
1142015 | 1142015 | 2021-03-21 | O'Brien | Iowa | 19141 | 1888 | 58 |
1142016 | 1142016 | 2021-03-21 | Osceola | Iowa | 19143 | 691 | 15 |
1142017 | 1142017 | 2021-03-21 | Page | Iowa | 19145 | 1829 | 19 |
1142018 | 1142018 | 2021-03-21 | Palo Alto | Iowa | 19147 | 1039 | 22 |
1142019 | 1142019 | 2021-03-21 | Plymouth | Iowa | 19149 | 3778 | 79 |
1142020 | 1142020 | 2021-03-21 | Pocahontas | Iowa | 19151 | 823 | 19 |
1142021 | 1142021 | 2021-03-21 | Polk | Iowa | 19153 | 53448 | 577 |
1142022 | 1142022 | 2021-03-21 | Pottawattamie | Iowa | 19155 | 10100 | 149 |
1142023 | 1142023 | 2021-03-21 | Poweshiek | Iowa | 19157 | 1507 | 31 |
1142024 | 1142024 | 2021-03-21 | Ringgold | Iowa | 19159 | 517 | 22 |
1142025 | 1142025 | 2021-03-21 | Sac | Iowa | 19161 | 1216 | 18 |
1142026 | 1142026 | 2021-03-21 | Scott | Iowa | 19163 | 17516 | 224 |
1142027 | 1142027 | 2021-03-21 | Shelby | Iowa | 19165 | 1206 | 34 |
1142028 | 1142028 | 2021-03-21 | Sioux | Iowa | 19167 | 4894 | 69 |
1142029 | 1142029 | 2021-03-21 | Story | Iowa | 19169 | 9847 | 46 |
1142030 | 1142030 | 2021-03-21 | Tama | Iowa | 19171 | 2046 | 68 |
1142031 | 1142031 | 2021-03-21 | Taylor | Iowa | 19173 | 642 | 12 |
1142032 | 1142032 | 2021-03-21 | Union | Iowa | 19175 | 1209 | 31 |
1142033 | 1142033 | 2021-03-21 | Unknown | Iowa | 1001 | 0 | |
1142034 | 1142034 | 2021-03-21 | Van Buren | Iowa | 19177 | 539 | 18 |
1142035 | 1142035 | 2021-03-21 | Wapello | Iowa | 19179 | 4180 | 114 |
1142036 | 1142036 | 2021-03-21 | Warren | Iowa | 19181 | 5278 | 80 |
1142037 | 1142037 | 2021-03-21 | Washington | Iowa | 19183 | 2420 | 48 |
1142038 | 1142038 | 2021-03-21 | Wayne | Iowa | 19185 | 504 | 21 |
1142039 | 1142039 | 2021-03-21 | Webster | Iowa | 19187 | 5009 | 88 |
1142040 | 1142040 | 2021-03-21 | Winnebago | Iowa | 19189 | 1330 | 31 |
1142041 | 1142041 | 2021-03-21 | Winneshiek | Iowa | 19191 | 1871 | 31 |
1142042 | 1142042 | 2021-03-21 | Woodbury | Iowa | 19193 | 14257 | 216 |
1142043 | 1142043 | 2021-03-21 | Worth | Iowa | 19195 | 675 | 8 |
1142044 | 1142044 | 2021-03-21 | Wright | Iowa | 19197 | 1759 | 32 |
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);