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 2022-04-18 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 100
- 19001 1
- 19003 1
- 19005 1
- 19007 1
- 19009 1
- 19011 1
- 19013 1
- 19015 1
- 19017 1
- 19019 1
- 19021 1
- 19023 1
- 19025 1
- 19027 1
- 19029 1
- 19031 1
- 19033 1
- 19035 1
- 19037 1
- 19039 1
- 19041 1
- 19043 1
- 19045 1
- 19047 1
- 19049 1
- 19051 1
- 19053 1
- 19055 1
- 19057 1
- 19059 1
- 19061 1
- 19063 1
- 19065 1
- 19067 1
- 19069 1
- 19071 1
- 19073 1
- 19075 1
- 19077 1
- 19079 1
- 19081 1
- 19083 1
- 19085 1
- 19087 1
- 19089 1
- 19091 1
- 19093 1
- 19095 1
- 19097 1
- 19099 1
- 19101 1
- 19103 1
- 19105 1
- 19107 1
- 19109 1
- 19111 1
- 19113 1
- 19115 1
- 19117 1
- 19119 1
- 19121 1
- 19123 1
- 19125 1
- 19127 1
- 19129 1
- 19131 1
- 19133 1
- 19135 1
- 19137 1
- 19139 1
- 19141 1
- 19143 1
- 19145 1
- 19147 1
- 19149 1
- 19151 1
- 19153 1
- 19155 1
- 19157 1
- 19159 1
- 19161 1
- 19163 1
- 19165 1
- 19167 1
- 19169 1
- 19171 1
- 19173 1
- 19175 1
- 19177 1
- 19179 1
- 19181 1
- 19183 1
- 19185 1
- 19187 1
- 19189 1
- 19191 1
- 19193 1
- 19195 1
- 19197 1
- - 1
county 100
- 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
- Dubuque 1
- Emmet 1
- Fayette 1
- Floyd 1
- Franklin 1
- Fremont 1
- Greene 1
- Grundy 1
- Guthrie 1
- Hamilton 1
- Hancock 1
- Hardin 1
- Harrison 1
- Henry 1
- Howard 1
- Humboldt 1
- Ida 1
- Iowa 1
- Jackson 1
- Jasper 1
- Jefferson 1
- Johnson 1
- Jones 1
- Keokuk 1
- Kossuth 1
- Lee 1
- Linn 1
- Louisa 1
- Lucas 1
- Lyon 1
- Madison 1
- Mahaska 1
- Marion 1
- Marshall 1
- Mills 1
- Mitchell 1
- Monona 1
- Monroe 1
- Montgomery 1
- Muscatine 1
- O'Brien 1
- Osceola 1
- Page 1
- Palo Alto 1
- Plymouth 1
- Pocahontas 1
- Polk 1
- Pottawattamie 1
- Poweshiek 1
- Ringgold 1
- Sac 1
- Scott 1
- Shelby 1
- Sioux 1
- Story 1
- Tama 1
- Taylor 1
- Union 1
- Unknown 1
- Van Buren 1
- Wapello 1
- Warren 1
- Washington 1
- Wayne 1
- Webster 1
- Winnebago 1
- Winneshiek 1
- Woodbury 1
- Worth 1
- Wright 1
state 1
- Iowa · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418958 | 2418958 | 2022-04-18 | Adair | Iowa | 19001 | 1583 | 50 |
2418959 | 2418959 | 2022-04-18 | Adams | Iowa | 19003 | 818 | 13 |
2418960 | 2418960 | 2022-04-18 | Allamakee | Iowa | 19005 | 2868 | 59 |
2418961 | 2418961 | 2022-04-18 | Appanoose | Iowa | 19007 | 2907 | 68 |
2418962 | 2418962 | 2022-04-18 | Audubon | Iowa | 19009 | 1102 | 19 |
2418963 | 2418963 | 2022-04-18 | Benton | Iowa | 19011 | 6023 | 77 |
2418964 | 2418964 | 2022-04-18 | Black Hawk | Iowa | 19013 | 32769 | 473 |
2418965 | 2418965 | 2022-04-18 | Boone | Iowa | 19015 | 5463 | 54 |
2418966 | 2418966 | 2022-04-18 | Bremer | Iowa | 19017 | 5496 | 82 |
2418967 | 2418967 | 2022-04-18 | Buchanan | Iowa | 19019 | 4584 | 58 |
2418968 | 2418968 | 2022-04-18 | Buena Vista | Iowa | 19021 | 6426 | 57 |
2418969 | 2418969 | 2022-04-18 | Butler | Iowa | 19023 | 3220 | 53 |
2418970 | 2418970 | 2022-04-18 | Calhoun | Iowa | 19025 | 2597 | 24 |
2418971 | 2418971 | 2022-04-18 | Carroll | Iowa | 19027 | 4932 | 65 |
2418972 | 2418972 | 2022-04-18 | Cass | Iowa | 19029 | 2958 | 78 |
2418973 | 2418973 | 2022-04-18 | Cedar | Iowa | 19031 | 4144 | 35 |
2418974 | 2418974 | 2022-04-18 | Cerro Gordo | Iowa | 19033 | 11091 | 169 |
2418975 | 2418975 | 2022-04-18 | Cherokee | Iowa | 19035 | 2964 | 61 |
2418976 | 2418976 | 2022-04-18 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2418977 | 2418977 | 2022-04-18 | Clarke | Iowa | 19039 | 2263 | 37 |
2418978 | 2418978 | 2022-04-18 | Clay | Iowa | 19041 | 4094 | 44 |
2418979 | 2418979 | 2022-04-18 | Clayton | Iowa | 19043 | 3471 | 72 |
2418980 | 2418980 | 2022-04-18 | Clinton | Iowa | 19045 | 11524 | 145 |
2418981 | 2418981 | 2022-04-18 | Crawford | Iowa | 19047 | 4525 | 53 |
2418982 | 2418982 | 2022-04-18 | Dallas | Iowa | 19049 | 23047 | 143 |
2418983 | 2418983 | 2022-04-18 | Davis | Iowa | 19051 | 1597 | 32 |
2418984 | 2418984 | 2022-04-18 | Decatur | Iowa | 19053 | 1511 | 26 |
2418985 | 2418985 | 2022-04-18 | Delaware | Iowa | 19055 | 4018 | 68 |
2418986 | 2418986 | 2022-04-18 | Des Moines | Iowa | 19057 | 9130 | 137 |
2418987 | 2418987 | 2022-04-18 | Dickinson | Iowa | 19059 | 4128 | 72 |
2418988 | 2418988 | 2022-04-18 | Dubuque | Iowa | 19061 | 25946 | 294 |
2418989 | 2418989 | 2022-04-18 | Emmet | Iowa | 19063 | 2353 | 51 |
2418990 | 2418990 | 2022-04-18 | Fayette | Iowa | 19065 | 4093 | 72 |
2418991 | 2418991 | 2022-04-18 | Floyd | Iowa | 19067 | 3554 | 62 |
2418992 | 2418992 | 2022-04-18 | Franklin | Iowa | 19069 | 2513 | 42 |
2418993 | 2418993 | 2022-04-18 | Fremont | Iowa | 19071 | 1386 | 25 |
2418994 | 2418994 | 2022-04-18 | Greene | Iowa | 19073 | 1741 | 21 |
2418995 | 2418995 | 2022-04-18 | Grundy | Iowa | 19075 | 2552 | 42 |
2418996 | 2418996 | 2022-04-18 | Guthrie | Iowa | 19077 | 2350 | 45 |
2418997 | 2418997 | 2022-04-18 | Hamilton | Iowa | 19079 | 3481 | 72 |
2418998 | 2418998 | 2022-04-18 | Hancock | Iowa | 19081 | 2841 | 47 |
2418999 | 2418999 | 2022-04-18 | Hardin | Iowa | 19083 | 4123 | 62 |
2419000 | 2419000 | 2022-04-18 | Harrison | Iowa | 19085 | 3430 | 95 |
2419001 | 2419001 | 2022-04-18 | Henry | Iowa | 19087 | 5558 | 74 |
2419002 | 2419002 | 2022-04-18 | Howard | Iowa | 19089 | 2042 | 35 |
2419003 | 2419003 | 2022-04-18 | Humboldt | Iowa | 19091 | 2610 | 38 |
2419004 | 2419004 | 2022-04-18 | Ida | Iowa | 19093 | 1810 | 49 |
2419005 | 2419005 | 2022-04-18 | Iowa | Iowa | 19095 | 3677 | 50 |
2419006 | 2419006 | 2022-04-18 | Jackson | Iowa | 19097 | 4602 | 68 |
2419007 | 2419007 | 2022-04-18 | Jasper | Iowa | 19099 | 8644 | 110 |
2419008 | 2419008 | 2022-04-18 | Jefferson | Iowa | 19101 | 3475 | 51 |
2419009 | 2419009 | 2022-04-18 | Johnson | Iowa | 19103 | 34193 | 150 |
2419010 | 2419010 | 2022-04-18 | Jones | Iowa | 19105 | 5458 | 73 |
2419011 | 2419011 | 2022-04-18 | Keokuk | Iowa | 19107 | 2070 | 48 |
2419012 | 2419012 | 2022-04-18 | Kossuth | Iowa | 19109 | 3769 | 88 |
2419013 | 2419013 | 2022-04-18 | Lee | Iowa | 19111 | 7856 | 142 |
2419014 | 2419014 | 2022-04-18 | Linn | Iowa | 19113 | 52173 | 579 |
2419015 | 2419015 | 2022-04-18 | Louisa | Iowa | 19115 | 2480 | 62 |
2419016 | 2419016 | 2022-04-18 | Lucas | Iowa | 19117 | 1754 | 32 |
2419017 | 2419017 | 2022-04-18 | Lyon | Iowa | 19119 | 2733 | 50 |
2419018 | 2419018 | 2022-04-18 | Madison | Iowa | 19121 | 3154 | 39 |
2419019 | 2419019 | 2022-04-18 | Mahaska | Iowa | 19123 | 4893 | 87 |
2419020 | 2419020 | 2022-04-18 | Marion | Iowa | 19125 | 7566 | 123 |
2419021 | 2419021 | 2022-04-18 | Marshall | Iowa | 19127 | 9413 | 110 |
2419022 | 2419022 | 2022-04-18 | Mills | Iowa | 19129 | 3351 | 41 |
2419023 | 2419023 | 2022-04-18 | Mitchell | Iowa | 19131 | 2474 | 49 |
2419024 | 2419024 | 2022-04-18 | Monona | Iowa | 19133 | 1719 | 48 |
2419025 | 2419025 | 2022-04-18 | Monroe | Iowa | 19135 | 1879 | 49 |
2419026 | 2419026 | 2022-04-18 | Montgomery | Iowa | 19137 | 2208 | 52 |
2419027 | 2419027 | 2022-04-18 | Muscatine | Iowa | 19139 | 9604 | 130 |
2419028 | 2419028 | 2022-04-18 | O'Brien | Iowa | 19141 | 3447 | 71 |
2419029 | 2419029 | 2022-04-18 | Osceola | Iowa | 19143 | 1394 | 22 |
2419030 | 2419030 | 2022-04-18 | Page | Iowa | 19145 | 3338 | 45 |
2419031 | 2419031 | 2022-04-18 | Palo Alto | Iowa | 19147 | 2036 | 38 |
2419032 | 2419032 | 2022-04-18 | Plymouth | Iowa | 19149 | 6321 | 100 |
2419033 | 2419033 | 2022-04-18 | Pocahontas | Iowa | 19151 | 1602 | 27 |
2419034 | 2419034 | 2022-04-18 | Polk | Iowa | 19153 | 124811 | 1092 |
2419035 | 2419035 | 2022-04-18 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2419036 | 2419036 | 2022-04-18 | Poweshiek | Iowa | 19157 | 3604 | 61 |
2419037 | 2419037 | 2022-04-18 | Ringgold | Iowa | 19159 | 1135 | 34 |
2419038 | 2419038 | 2022-04-18 | Sac | Iowa | 19161 | 2401 | 32 |
2419039 | 2419039 | 2022-04-18 | Scott | Iowa | 19163 | 41051 | 391 |
2419040 | 2419040 | 2022-04-18 | Shelby | Iowa | 19165 | 2716 | 50 |
2419041 | 2419041 | 2022-04-18 | Sioux | Iowa | 19167 | 7986 | 86 |
2419042 | 2419042 | 2022-04-18 | Story | Iowa | 19169 | 19779 | 89 |
2419043 | 2419043 | 2022-04-18 | Tama | Iowa | 19171 | 3868 | 90 |
2419044 | 2419044 | 2022-04-18 | Taylor | Iowa | 19173 | 1318 | 22 |
2419045 | 2419045 | 2022-04-18 | Union | Iowa | 19175 | 2716 | 50 |
2419046 | 2419046 | 2022-04-18 | Unknown | Iowa | 491 | 0 | |
2419047 | 2419047 | 2022-04-18 | Van Buren | Iowa | 19177 | 1383 | 27 |
2419048 | 2419048 | 2022-04-18 | Wapello | Iowa | 19179 | 8977 | 201 |
2419049 | 2419049 | 2022-04-18 | Warren | Iowa | 19181 | 12494 | 134 |
2419050 | 2419050 | 2022-04-18 | Washington | Iowa | 19183 | 5641 | 77 |
2419051 | 2419051 | 2022-04-18 | Wayne | Iowa | 19185 | 1265 | 33 |
2419052 | 2419052 | 2022-04-18 | Webster | Iowa | 19187 | 10331 | 163 |
2419053 | 2419053 | 2022-04-18 | Winnebago | Iowa | 19189 | 2955 | 46 |
2419054 | 2419054 | 2022-04-18 | Winneshiek | Iowa | 19191 | 3829 | 50 |
2419055 | 2419055 | 2022-04-18 | Woodbury | Iowa | 19193 | 28790 | 337 |
2419056 | 2419056 | 2022-04-18 | Worth | Iowa | 19195 | 1755 | 16 |
2419057 | 2419057 | 2022-04-18 | Wright | Iowa | 19197 | 3611 | 63 |
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);