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-01-03 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 |
---|---|---|---|---|---|---|---|
892024 | 892024 | 2021-01-03 | Adair | Iowa | 19001 | 616 | 17 |
892025 | 892025 | 2021-01-03 | Adams | Iowa | 19003 | 271 | 2 |
892026 | 892026 | 2021-01-03 | Allamakee | Iowa | 19005 | 1194 | 26 |
892027 | 892027 | 2021-01-03 | Appanoose | Iowa | 19007 | 984 | 36 |
892028 | 892028 | 2021-01-03 | Audubon | Iowa | 19009 | 385 | 7 |
892029 | 892029 | 2021-01-03 | Benton | Iowa | 19011 | 1998 | 38 |
892030 | 892030 | 2021-01-03 | Black Hawk | Iowa | 19013 | 12903 | 220 |
892031 | 892031 | 2021-01-03 | Boone | Iowa | 19015 | 1946 | 15 |
892032 | 892032 | 2021-01-03 | Bremer | Iowa | 19017 | 2278 | 44 |
892033 | 892033 | 2021-01-03 | Buchanan | Iowa | 19019 | 1462 | 17 |
892034 | 892034 | 2021-01-03 | Buena Vista | Iowa | 19021 | 3746 | 26 |
892035 | 892035 | 2021-01-03 | Butler | Iowa | 19023 | 1299 | 23 |
892036 | 892036 | 2021-01-03 | Calhoun | Iowa | 19025 | 1174 | 9 |
892037 | 892037 | 2021-01-03 | Carroll | Iowa | 19027 | 2406 | 31 |
892038 | 892038 | 2021-01-03 | Cass | Iowa | 19029 | 1064 | 39 |
892039 | 892039 | 2021-01-03 | Cedar | Iowa | 19031 | 1406 | 19 |
892040 | 892040 | 2021-01-03 | Cerro Gordo | Iowa | 19033 | 4361 | 62 |
892041 | 892041 | 2021-01-03 | Cherokee | Iowa | 19035 | 1264 | 22 |
892042 | 892042 | 2021-01-03 | Chickasaw | Iowa | 19037 | 1050 | 11 |
892043 | 892043 | 2021-01-03 | Clarke | Iowa | 19039 | 698 | 6 |
892044 | 892044 | 2021-01-03 | Clay | Iowa | 19041 | 1559 | 13 |
892045 | 892045 | 2021-01-03 | Clayton | Iowa | 19043 | 1410 | 46 |
892046 | 892046 | 2021-01-03 | Clinton | Iowa | 19045 | 4160 | 55 |
892047 | 892047 | 2021-01-03 | Crawford | Iowa | 19047 | 2134 | 22 |
892048 | 892048 | 2021-01-03 | Dallas | Iowa | 19049 | 8028 | 67 |
892049 | 892049 | 2021-01-03 | Davis | Iowa | 19051 | 651 | 20 |
892050 | 892050 | 2021-01-03 | Decatur | Iowa | 19053 | 431 | 4 |
892051 | 892051 | 2021-01-03 | Delaware | Iowa | 19055 | 1645 | 32 |
892052 | 892052 | 2021-01-03 | Des Moines | Iowa | 19057 | 3577 | 35 |
892053 | 892053 | 2021-01-03 | Dickinson | Iowa | 19059 | 1729 | 20 |
892054 | 892054 | 2021-01-03 | Dubuque | Iowa | 19061 | 10719 | 139 |
892055 | 892055 | 2021-01-03 | Emmet | Iowa | 19063 | 1023 | 27 |
892056 | 892056 | 2021-01-03 | Fayette | Iowa | 19065 | 1436 | 19 |
892057 | 892057 | 2021-01-03 | Floyd | Iowa | 19067 | 1292 | 34 |
892058 | 892058 | 2021-01-03 | Franklin | Iowa | 19069 | 922 | 17 |
892059 | 892059 | 2021-01-03 | Fremont | Iowa | 19071 | 473 | 5 |
892060 | 892060 | 2021-01-03 | Greene | Iowa | 19073 | 649 | 7 |
892061 | 892061 | 2021-01-03 | Grundy | Iowa | 19075 | 1105 | 18 |
892062 | 892062 | 2021-01-03 | Guthrie | Iowa | 19077 | 961 | 23 |
892063 | 892063 | 2021-01-03 | Hamilton | Iowa | 19079 | 1493 | 24 |
892064 | 892064 | 2021-01-03 | Hancock | Iowa | 19081 | 1189 | 24 |
892065 | 892065 | 2021-01-03 | Hardin | Iowa | 19083 | 1464 | 26 |
892066 | 892066 | 2021-01-03 | Harrison | Iowa | 19085 | 1460 | 58 |
892067 | 892067 | 2021-01-03 | Henry | Iowa | 19087 | 2494 | 27 |
892068 | 892068 | 2021-01-03 | Howard | Iowa | 19089 | 743 | 17 |
892069 | 892069 | 2021-01-03 | Humboldt | Iowa | 19091 | 984 | 18 |
892070 | 892070 | 2021-01-03 | Ida | Iowa | 19093 | 701 | 29 |
892071 | 892071 | 2021-01-03 | Iowa | Iowa | 19095 | 1149 | 21 |
892072 | 892072 | 2021-01-03 | Jackson | Iowa | 19097 | 1788 | 29 |
892073 | 892073 | 2021-01-03 | Jasper | Iowa | 19099 | 2930 | 54 |
892074 | 892074 | 2021-01-03 | Jefferson | Iowa | 19101 | 1042 | 20 |
892075 | 892075 | 2021-01-03 | Johnson | Iowa | 19103 | 11277 | 47 |
892076 | 892076 | 2021-01-03 | Jones | Iowa | 19105 | 2603 | 48 |
892077 | 892077 | 2021-01-03 | Keokuk | Iowa | 19107 | 798 | 25 |
892078 | 892078 | 2021-01-03 | Kossuth | Iowa | 19109 | 1566 | 32 |
892079 | 892079 | 2021-01-03 | Lee | Iowa | 19111 | 2906 | 25 |
892080 | 892080 | 2021-01-03 | Linn | Iowa | 19113 | 16752 | 249 |
892081 | 892081 | 2021-01-03 | Louisa | Iowa | 19115 | 1083 | 24 |
892082 | 892082 | 2021-01-03 | Lucas | Iowa | 19117 | 591 | 8 |
892083 | 892083 | 2021-01-03 | Lyon | Iowa | 19119 | 1266 | 25 |
892084 | 892084 | 2021-01-03 | Madison | Iowa | 19121 | 987 | 8 |
892085 | 892085 | 2021-01-03 | Mahaska | Iowa | 19123 | 1758 | 35 |
892086 | 892086 | 2021-01-03 | Marion | Iowa | 19125 | 2741 | 49 |
892087 | 892087 | 2021-01-03 | Marshall | Iowa | 19127 | 4048 | 57 |
892088 | 892088 | 2021-01-03 | Mills | Iowa | 19129 | 1298 | 15 |
892089 | 892089 | 2021-01-03 | Mitchell | Iowa | 19131 | 1057 | 30 |
892090 | 892090 | 2021-01-03 | Monona | Iowa | 19133 | 554 | 16 |
892091 | 892091 | 2021-01-03 | Monroe | Iowa | 19135 | 696 | 17 |
892092 | 892092 | 2021-01-03 | Montgomery | Iowa | 19137 | 770 | 15 |
892093 | 892093 | 2021-01-03 | Muscatine | Iowa | 19139 | 3611 | 75 |
892094 | 892094 | 2021-01-03 | O'Brien | Iowa | 19141 | 1603 | 53 |
892095 | 892095 | 2021-01-03 | Osceola | Iowa | 19143 | 616 | 8 |
892096 | 892096 | 2021-01-03 | Page | Iowa | 19145 | 1386 | 14 |
892097 | 892097 | 2021-01-03 | Palo Alto | Iowa | 19147 | 823 | 8 |
892098 | 892098 | 2021-01-03 | Plymouth | Iowa | 19149 | 3376 | 53 |
892099 | 892099 | 2021-01-03 | Pocahontas | Iowa | 19151 | 729 | 12 |
892100 | 892100 | 2021-01-03 | Polk | Iowa | 19153 | 41943 | 413 |
892101 | 892101 | 2021-01-03 | Pottawattamie | Iowa | 19155 | 8390 | 98 |
892102 | 892102 | 2021-01-03 | Poweshiek | Iowa | 19157 | 1222 | 24 |
892103 | 892103 | 2021-01-03 | Ringgold | Iowa | 19159 | 367 | 8 |
892104 | 892104 | 2021-01-03 | Sac | Iowa | 19161 | 1046 | 14 |
892105 | 892105 | 2021-01-03 | Scott | Iowa | 19163 | 14293 | 152 |
892106 | 892106 | 2021-01-03 | Shelby | Iowa | 19165 | 957 | 25 |
892107 | 892107 | 2021-01-03 | Sioux | Iowa | 19167 | 4370 | 44 |
892108 | 892108 | 2021-01-03 | Story | Iowa | 19169 | 8070 | 31 |
892109 | 892109 | 2021-01-03 | Tama | Iowa | 19171 | 1766 | 56 |
892110 | 892110 | 2021-01-03 | Taylor | Iowa | 19173 | 547 | 9 |
892111 | 892111 | 2021-01-03 | Union | Iowa | 19175 | 1035 | 19 |
892112 | 892112 | 2021-01-03 | Unknown | Iowa | 762 | 0 | |
892113 | 892113 | 2021-01-03 | Van Buren | Iowa | 19177 | 458 | 11 |
892114 | 892114 | 2021-01-03 | Wapello | Iowa | 19179 | 3154 | 92 |
892115 | 892115 | 2021-01-03 | Warren | Iowa | 19181 | 3872 | 34 |
892116 | 892116 | 2021-01-03 | Washington | Iowa | 19183 | 1903 | 28 |
892117 | 892117 | 2021-01-03 | Wayne | Iowa | 19185 | 389 | 21 |
892118 | 892118 | 2021-01-03 | Webster | Iowa | 19187 | 4462 | 64 |
892119 | 892119 | 2021-01-03 | Winnebago | Iowa | 19189 | 1108 | 28 |
892120 | 892120 | 2021-01-03 | Winneshiek | Iowa | 19191 | 1398 | 18 |
892121 | 892121 | 2021-01-03 | Woodbury | Iowa | 19193 | 12388 | 168 |
892122 | 892122 | 2021-01-03 | Worth | Iowa | 19195 | 535 | 3 |
892123 | 892123 | 2021-01-03 | Wright | Iowa | 19197 | 1539 | 18 |
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);