ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where cases = 27 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1749270 | 1749270 | 2021-09-24 | Unknown | Iowa | 27 | 0 | |
1746020 | 1746020 | 2021-09-23 | Unknown | Iowa | 27 | 0 | |
1742771 | 1742771 | 2021-09-22 | Unknown | Iowa | 27 | 1 | |
544926 | 544926 | 2020-09-18 | Adams | Iowa | 19003 | 27 | 0 |
541690 | 541690 | 2020-09-17 | Adams | Iowa | 19003 | 27 | 0 |
538453 | 538453 | 2020-09-16 | Adams | Iowa | 19003 | 27 | 0 |
535217 | 535217 | 2020-09-15 | Adams | Iowa | 19003 | 27 | 0 |
531982 | 531982 | 2020-09-14 | Adams | Iowa | 19003 | 27 | 0 |
528745 | 528745 | 2020-09-13 | Adams | Iowa | 19003 | 27 | 0 |
448029 | 448029 | 2020-08-19 | Wayne | Iowa | 19185 | 27 | 2 |
428604 | 428604 | 2020-08-13 | Decatur | Iowa | 19053 | 27 | 0 |
406030 | 406030 | 2020-08-06 | Adair | Iowa | 19001 | 27 | 0 |
380299 | 380299 | 2020-07-29 | Audubon | Iowa | 19009 | 27 | 1 |
380330 | 380330 | 2020-07-29 | Fremont | Iowa | 19071 | 27 | 0 |
380348 | 380348 | 2020-07-29 | Keokuk | Iowa | 19107 | 27 | 1 |
377131 | 377131 | 2020-07-28 | Keokuk | Iowa | 19107 | 27 | 1 |
373916 | 373916 | 2020-07-27 | Keokuk | Iowa | 19107 | 27 | 1 |
367494 | 367494 | 2020-07-25 | Keokuk | Iowa | 19107 | 27 | 1 |
364280 | 364280 | 2020-07-24 | Ida | Iowa | 19093 | 27 | 0 |
364287 | 364287 | 2020-07-24 | Keokuk | Iowa | 19107 | 27 | 1 |
361073 | 361073 | 2020-07-23 | Ida | Iowa | 19093 | 27 | 0 |
357868 | 357868 | 2020-07-22 | Ida | Iowa | 19093 | 27 | 0 |
329143 | 329143 | 2020-07-13 | Worth | Iowa | 19195 | 27 | 0 |
319513 | 319513 | 2020-07-10 | Cass | Iowa | 19029 | 27 | 0 |
316340 | 316340 | 2020-07-09 | Cass | Iowa | 19029 | 27 | 0 |
300572 | 300572 | 2020-07-04 | Union | Iowa | 19175 | 27 | 0 |
297371 | 297371 | 2020-07-03 | Jackson | Iowa | 19097 | 27 | 0 |
297410 | 297410 | 2020-07-03 | Union | Iowa | 19175 | 27 | 0 |
297418 | 297418 | 2020-07-03 | Winnebago | Iowa | 19189 | 27 | 0 |
294183 | 294183 | 2020-07-02 | Chickasaw | Iowa | 19037 | 27 | 0 |
294213 | 294213 | 2020-07-02 | Jackson | Iowa | 19097 | 27 | 0 |
294252 | 294252 | 2020-07-02 | Union | Iowa | 19175 | 27 | 0 |
294260 | 294260 | 2020-07-02 | Winnebago | Iowa | 19189 | 27 | 0 |
291029 | 291029 | 2020-07-01 | Chickasaw | Iowa | 19037 | 27 | 0 |
291055 | 291055 | 2020-07-01 | Howard | Iowa | 19089 | 27 | 0 |
291098 | 291098 | 2020-07-01 | Union | Iowa | 19175 | 27 | 0 |
281663 | 281663 | 2020-06-28 | Winneshiek | Iowa | 19191 | 27 | 0 |
278456 | 278456 | 2020-06-27 | Grundy | Iowa | 19075 | 27 | 0 |
275308 | 275308 | 2020-06-26 | Grundy | Iowa | 19075 | 27 | 0 |
272166 | 272166 | 2020-06-25 | Grundy | Iowa | 19075 | 27 | 0 |
265916 | 265916 | 2020-06-23 | Kossuth | Iowa | 19109 | 27 | 0 |
256517 | 256517 | 2020-06-20 | Greene | Iowa | 19073 | 27 | 0 |
253397 | 253397 | 2020-06-19 | Greene | Iowa | 19073 | 27 | 0 |
240937 | 240937 | 2020-06-15 | Delaware | Iowa | 19055 | 27 | 1 |
237829 | 237829 | 2020-06-14 | Delaware | Iowa | 19055 | 27 | 1 |
234722 | 234722 | 2020-06-13 | Delaware | Iowa | 19055 | 27 | 1 |
234735 | 234735 | 2020-06-13 | Hancock | Iowa | 19081 | 27 | 0 |
231616 | 231616 | 2020-06-12 | Delaware | Iowa | 19055 | 27 | 1 |
225429 | 225429 | 2020-06-10 | Humboldt | Iowa | 19091 | 27 | 1 |
222331 | 222331 | 2020-06-09 | Harrison | Iowa | 19085 | 27 | 0 |
219236 | 219236 | 2020-06-08 | Harrison | Iowa | 19085 | 27 | 0 |
219260 | 219260 | 2020-06-08 | Monona | Iowa | 19133 | 27 | 0 |
216168 | 216168 | 2020-06-07 | Monona | Iowa | 19133 | 27 | 0 |
213047 | 213047 | 2020-06-06 | Fayette | Iowa | 19065 | 27 | 0 |
213081 | 213081 | 2020-06-06 | Monona | Iowa | 19133 | 27 | 0 |
209961 | 209961 | 2020-06-05 | Emmet | Iowa | 19063 | 27 | 0 |
209962 | 209962 | 2020-06-05 | Fayette | Iowa | 19065 | 27 | 0 |
209996 | 209996 | 2020-06-05 | Monona | Iowa | 19133 | 27 | 0 |
206869 | 206869 | 2020-06-04 | Clay | Iowa | 19041 | 27 | 0 |
203794 | 203794 | 2020-06-03 | Davis | Iowa | 19051 | 27 | 0 |
203798 | 203798 | 2020-06-03 | Dickinson | Iowa | 19059 | 27 | 0 |
200725 | 200725 | 2020-06-02 | Fayette | Iowa | 19065 | 27 | 0 |
200748 | 200748 | 2020-06-02 | Lee | Iowa | 19111 | 27 | 0 |
197652 | 197652 | 2020-06-01 | Fayette | Iowa | 19065 | 27 | 0 |
197675 | 197675 | 2020-06-01 | Lee | Iowa | 19111 | 27 | 0 |
194582 | 194582 | 2020-05-31 | Fayette | Iowa | 19065 | 27 | 0 |
194605 | 194605 | 2020-05-31 | Lee | Iowa | 19111 | 27 | 0 |
191515 | 191515 | 2020-05-30 | Fayette | Iowa | 19065 | 27 | 0 |
188434 | 188434 | 2020-05-29 | Cerro Gordo | Iowa | 19033 | 27 | 1 |
188435 | 188435 | 2020-05-29 | Cherokee | Iowa | 19035 | 27 | 0 |
188478 | 188478 | 2020-05-29 | Madison | Iowa | 19121 | 27 | 1 |
185420 | 185420 | 2020-05-28 | Madison | Iowa | 19121 | 27 | 1 |
182376 | 182376 | 2020-05-27 | O'Brien | Iowa | 19141 | 27 | 0 |
179331 | 179331 | 2020-05-26 | O'Brien | Iowa | 19141 | 27 | 0 |
176311 | 176311 | 2020-05-25 | Webster | Iowa | 19187 | 27 | 1 |
173267 | 173267 | 2020-05-24 | Webster | Iowa | 19187 | 27 | 1 |
164124 | 164124 | 2020-05-21 | Marion | Iowa | 19125 | 27 | 0 |
164129 | 164129 | 2020-05-21 | Monroe | Iowa | 19135 | 27 | 2 |
164144 | 164144 | 2020-05-21 | Shelby | Iowa | 19165 | 27 | 0 |
155063 | 155063 | 2020-05-18 | Osceola | Iowa | 19143 | 27 | 0 |
146013 | 146013 | 2020-05-15 | Iowa | Iowa | 19095 | 27 | 0 |
134034 | 134034 | 2020-05-11 | Iowa | Iowa | 19095 | 27 | 0 |
128053 | 128053 | 2020-05-09 | Iowa | Iowa | 19095 | 27 | 0 |
125066 | 125066 | 2020-05-08 | Iowa | Iowa | 19095 | 27 | 0 |
113297 | 113297 | 2020-05-04 | Plymouth | Iowa | 19149 | 27 | 0 |
113313 | 113313 | 2020-05-04 | Warren | Iowa | 19181 | 27 | 0 |
107566 | 107566 | 2020-05-02 | Wapello | Iowa | 19179 | 27 | 0 |
101836 | 101836 | 2020-04-30 | Story | Iowa | 19169 | 27 | 1 |
98985 | 98985 | 2020-04-29 | Story | Iowa | 19169 | 27 | 1 |
93241 | 93241 | 2020-04-27 | Benton | Iowa | 19011 | 27 | 1 |
93303 | 93303 | 2020-04-27 | Pottawattamie | Iowa | 19155 | 27 | 1 |
90422 | 90422 | 2020-04-26 | Benton | Iowa | 19011 | 27 | 1 |
82005 | 82005 | 2020-04-23 | Cedar | Iowa | 19031 | 27 | 0 |
79212 | 79212 | 2020-04-22 | Cedar | Iowa | 19031 | 27 | 0 |
68140 | 68140 | 2020-04-18 | Henry | Iowa | 19087 | 27 | 1 |
65357 | 65357 | 2020-04-17 | Allamakee | Iowa | 19005 | 27 | 3 |
31480 | 31480 | 2020-04-04 | Muscatine | Iowa | 19139 | 27 | 1 |
24529 | 24529 | 2020-04-01 | Dallas | Iowa | 19049 | 27 | 0 |
6403 | 6403 | 2020-03-21 | Johnson | Iowa | 19103 | 27 | 0 |
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);