ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where cases = 38 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2022245 | 2022245 | 2021-12-17 | Unknown | Iowa | 38 | 0 | |
2018994 | 2018994 | 2021-12-16 | Unknown | Iowa | 38 | 0 | |
2015744 | 2015744 | 2021-12-15 | Unknown | Iowa | 38 | 0 | |
587042 | 587042 | 2020-10-01 | Adams | Iowa | 19003 | 38 | 0 |
583802 | 583802 | 2020-09-30 | Adams | Iowa | 19003 | 38 | 0 |
489938 | 489938 | 2020-09-01 | Audubon | Iowa | 19009 | 38 | 1 |
473812 | 473812 | 2020-08-27 | Ida | Iowa | 19093 | 38 | 0 |
470560 | 470560 | 2020-08-26 | Decatur | Iowa | 19053 | 38 | 0 |
464169 | 464169 | 2020-08-24 | Wayne | Iowa | 19185 | 38 | 2 |
438257 | 438257 | 2020-08-16 | Adair | Iowa | 19001 | 38 | 0 |
435031 | 435031 | 2020-08-15 | Adair | Iowa | 19001 | 38 | 0 |
431806 | 431806 | 2020-08-14 | Adair | Iowa | 19001 | 38 | 0 |
428578 | 428578 | 2020-08-13 | Adair | Iowa | 19001 | 38 | 0 |
428667 | 428667 | 2020-08-13 | Van Buren | Iowa | 19177 | 38 | 1 |
409285 | 409285 | 2020-08-07 | Fremont | Iowa | 19071 | 38 | 0 |
402848 | 402848 | 2020-08-05 | Greene | Iowa | 19073 | 38 | 0 |
399632 | 399632 | 2020-08-04 | Greene | Iowa | 19073 | 38 | 0 |
396416 | 396416 | 2020-08-03 | Greene | Iowa | 19073 | 38 | 0 |
393200 | 393200 | 2020-08-02 | Greene | Iowa | 19073 | 38 | 0 |
389983 | 389983 | 2020-08-01 | Greene | Iowa | 19073 | 38 | 0 |
386766 | 386766 | 2020-07-31 | Greene | Iowa | 19073 | 38 | 0 |
373931 | 373931 | 2020-07-27 | Montgomery | Iowa | 19137 | 38 | 2 |
370719 | 370719 | 2020-07-26 | Montgomery | Iowa | 19137 | 38 | 2 |
357894 | 357894 | 2020-07-22 | Page | Iowa | 19145 | 38 | 0 |
354678 | 354678 | 2020-07-21 | Lucas | Iowa | 19117 | 38 | 4 |
354692 | 354692 | 2020-07-21 | Page | Iowa | 19145 | 38 | 0 |
351476 | 351476 | 2020-07-20 | Lucas | Iowa | 19117 | 38 | 4 |
348236 | 348236 | 2020-07-19 | Chickasaw | Iowa | 19037 | 38 | 0 |
345075 | 345075 | 2020-07-18 | Lucas | Iowa | 19117 | 38 | 4 |
341875 | 341875 | 2020-07-17 | Lucas | Iowa | 19117 | 38 | 4 |
322765 | 322765 | 2020-07-11 | Union | Iowa | 19175 | 38 | 0 |
319586 | 319586 | 2020-07-10 | Union | Iowa | 19175 | 38 | 0 |
313196 | 313196 | 2020-07-08 | Howard | Iowa | 19089 | 38 | 0 |
306851 | 306851 | 2020-07-06 | Grundy | Iowa | 19075 | 38 | 0 |
303745 | 303745 | 2020-07-05 | Winneshiek | Iowa | 19191 | 38 | 0 |
300522 | 300522 | 2020-07-04 | Grundy | Iowa | 19075 | 38 | 0 |
300581 | 300581 | 2020-07-04 | Winneshiek | Iowa | 19191 | 38 | 0 |
291036 | 291036 | 2020-07-01 | Davis | Iowa | 19051 | 38 | 1 |
291071 | 291071 | 2020-07-01 | Madison | Iowa | 19121 | 38 | 2 |
284733 | 284733 | 2020-06-29 | Clayton | Iowa | 19043 | 38 | 3 |
278440 | 278440 | 2020-06-27 | Clayton | Iowa | 19043 | 38 | 3 |
275298 | 275298 | 2020-06-26 | Delaware | Iowa | 19055 | 38 | 1 |
275330 | 275330 | 2020-06-26 | Lyon | Iowa | 19119 | 38 | 0 |
272150 | 272150 | 2020-06-25 | Clayton | Iowa | 19043 | 38 | 3 |
265902 | 265902 | 2020-06-23 | Hancock | Iowa | 19081 | 38 | 0 |
262743 | 262743 | 2020-06-22 | Buchanan | Iowa | 19019 | 38 | 1 |
262774 | 262774 | 2020-06-22 | Hancock | Iowa | 19081 | 38 | 0 |
259647 | 259647 | 2020-06-21 | Hancock | Iowa | 19081 | 38 | 0 |
259682 | 259682 | 2020-06-21 | Pocahontas | Iowa | 19151 | 38 | 1 |
256556 | 256556 | 2020-06-20 | Pocahontas | Iowa | 19151 | 38 | 1 |
250291 | 250291 | 2020-06-18 | Humboldt | Iowa | 19091 | 38 | 1 |
244101 | 244101 | 2020-06-16 | Sac | Iowa | 19161 | 38 | 0 |
240990 | 240990 | 2020-06-15 | Sac | Iowa | 19161 | 38 | 0 |
237857 | 237857 | 2020-06-14 | Lee | Iowa | 19111 | 38 | 1 |
237882 | 237882 | 2020-06-14 | Sac | Iowa | 19161 | 38 | 0 |
234726 | 234726 | 2020-06-13 | Emmet | Iowa | 19063 | 38 | 0 |
234750 | 234750 | 2020-06-13 | Lee | Iowa | 19111 | 38 | 1 |
231620 | 231620 | 2020-06-12 | Emmet | Iowa | 19063 | 38 | 0 |
228538 | 228538 | 2020-06-11 | Jones | Iowa | 19105 | 38 | 0 |
228541 | 228541 | 2020-06-11 | Lee | Iowa | 19111 | 38 | 1 |
225418 | 225418 | 2020-06-10 | Franklin | Iowa | 19069 | 38 | 0 |
225436 | 225436 | 2020-06-10 | Jones | Iowa | 19105 | 38 | 0 |
225446 | 225446 | 2020-06-10 | Marion | Iowa | 19125 | 38 | 0 |
222341 | 222341 | 2020-06-09 | Jones | Iowa | 19105 | 38 | 0 |
219244 | 219244 | 2020-06-08 | Jefferson | Iowa | 19101 | 38 | 0 |
219246 | 219246 | 2020-06-08 | Jones | Iowa | 19105 | 38 | 0 |
216173 | 216173 | 2020-06-07 | Osceola | Iowa | 19143 | 38 | 0 |
216184 | 216184 | 2020-06-07 | Shelby | Iowa | 19165 | 38 | 0 |
213097 | 213097 | 2020-06-06 | Shelby | Iowa | 19165 | 38 | 0 |
209959 | 209959 | 2020-06-05 | Dickinson | Iowa | 19059 | 38 | 0 |
210012 | 210012 | 2020-06-05 | Shelby | Iowa | 19165 | 38 | 0 |
203836 | 203836 | 2020-06-03 | Monroe | Iowa | 19135 | 38 | 5 |
200760 | 200760 | 2020-06-02 | Monroe | Iowa | 19135 | 38 | 5 |
197687 | 197687 | 2020-06-01 | Monroe | Iowa | 19135 | 38 | 5 |
194617 | 194617 | 2020-05-31 | Monroe | Iowa | 19135 | 38 | 5 |
191550 | 191550 | 2020-05-30 | Monroe | Iowa | 19135 | 38 | 5 |
188485 | 188485 | 2020-05-29 | Monroe | Iowa | 19135 | 38 | 5 |
185427 | 185427 | 2020-05-28 | Monroe | Iowa | 19135 | 38 | 5 |
155030 | 155030 | 2020-05-18 | Guthrie | Iowa | 19077 | 38 | 2 |
119087 | 119087 | 2020-05-06 | Cedar | Iowa | 19031 | 38 | 0 |
113306 | 113306 | 2020-05-04 | Story | Iowa | 19169 | 38 | 1 |
87609 | 87609 | 2020-04-25 | Bremer | Iowa | 19017 | 38 | 2 |
59920 | 59920 | 2020-04-15 | Clinton | Iowa | 19045 | 38 | 0 |
59922 | 59922 | 2020-04-15 | Dallas | Iowa | 19049 | 38 | 0 |
31487 | 31487 | 2020-04-04 | Scott | Iowa | 19163 | 38 | 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);