ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 55 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
625947 | 625947 | 2020-10-13 | Adams | Iowa | 19003 | 55 | 0 |
622705 | 622705 | 2020-10-12 | Adams | Iowa | 19003 | 55 | 0 |
619461 | 619461 | 2020-10-11 | Adams | Iowa | 19003 | 55 | 0 |
590361 | 590361 | 2020-10-02 | Ringgold | Iowa | 19159 | 55 | 2 |
544929 | 544929 | 2020-09-18 | Audubon | Iowa | 19009 | 55 | 1 |
532007 | 532007 | 2020-09-14 | Decatur | Iowa | 19053 | 55 | 0 |
519035 | 519035 | 2020-09-10 | Adair | Iowa | 19001 | 55 | 1 |
515846 | 515846 | 2020-09-09 | Ida | Iowa | 19093 | 55 | 0 |
473801 | 473801 | 2020-08-27 | Fremont | Iowa | 19071 | 55 | 0 |
473819 | 473819 | 2020-08-27 | Keokuk | Iowa | 19107 | 55 | 1 |
470569 | 470569 | 2020-08-26 | Fremont | Iowa | 19071 | 55 | 0 |
460882 | 460882 | 2020-08-23 | Fremont | Iowa | 19071 | 55 | 0 |
431850 | 431850 | 2020-08-14 | Howard | Iowa | 19089 | 55 | 0 |
422151 | 422151 | 2020-08-11 | Chickasaw | Iowa | 19037 | 55 | 0 |
412494 | 412494 | 2020-08-08 | Davis | Iowa | 19051 | 55 | 1 |
380393 | 380393 | 2020-07-29 | Worth | Iowa | 19195 | 55 | 0 |
345038 | 345038 | 2020-07-18 | Clayton | Iowa | 19043 | 55 | 3 |
345054 | 345054 | 2020-07-18 | Grundy | Iowa | 19075 | 55 | 0 |
338685 | 338685 | 2020-07-16 | Mills | Iowa | 19129 | 55 | 0 |
335498 | 335498 | 2020-07-15 | Palo Alto | Iowa | 19147 | 55 | 0 |
325919 | 325919 | 2020-07-12 | Madison | Iowa | 19121 | 55 | 2 |
322738 | 322738 | 2020-07-11 | Madison | Iowa | 19121 | 55 | 2 |
310022 | 310022 | 2020-07-07 | Hancock | Iowa | 19081 | 55 | 1 |
310027 | 310027 | 2020-07-07 | Humboldt | Iowa | 19091 | 55 | 1 |
306823 | 306823 | 2020-07-06 | Buchanan | Iowa | 19019 | 55 | 1 |
306859 | 306859 | 2020-07-06 | Humboldt | Iowa | 19091 | 55 | 1 |
291061 | 291061 | 2020-07-01 | Jefferson | Iowa | 19101 | 55 | 0 |
291063 | 291063 | 2020-07-01 | Jones | Iowa | 19105 | 55 | 0 |
278424 | 278424 | 2020-06-27 | Benton | Iowa | 19011 | 55 | 1 |
275276 | 275276 | 2020-06-26 | Benton | Iowa | 19011 | 55 | 1 |
275333 | 275333 | 2020-06-26 | Marion | Iowa | 19125 | 55 | 0 |
272134 | 272134 | 2020-06-25 | Benton | Iowa | 19011 | 55 | 1 |
250261 | 250261 | 2020-06-18 | Cedar | Iowa | 19031 | 55 | 1 |
228503 | 228503 | 2020-06-11 | Cherokee | Iowa | 19035 | 55 | 0 |
228506 | 228506 | 2020-06-11 | Clay | Iowa | 19041 | 55 | 0 |
225422 | 225422 | 2020-06-10 | Guthrie | Iowa | 19077 | 55 | 3 |
222327 | 222327 | 2020-06-09 | Guthrie | Iowa | 19077 | 55 | 3 |
222359 | 222359 | 2020-06-09 | O'Brien | Iowa | 19141 | 55 | 1 |
219232 | 219232 | 2020-06-08 | Guthrie | Iowa | 19077 | 55 | 3 |
216140 | 216140 | 2020-06-07 | Guthrie | Iowa | 19077 | 55 | 3 |
213053 | 213053 | 2020-06-06 | Guthrie | Iowa | 19077 | 55 | 3 |
209968 | 209968 | 2020-06-05 | Guthrie | Iowa | 19077 | 55 | 3 |
194569 | 194569 | 2020-05-31 | Clarke | Iowa | 19039 | 55 | 0 |
179269 | 179269 | 2020-05-26 | Boone | Iowa | 19015 | 55 | 0 |
176225 | 176225 | 2020-05-25 | Boone | Iowa | 19015 | 55 | 0 |
173181 | 173181 | 2020-05-24 | Boone | Iowa | 19015 | 55 | 0 |
128031 | 128031 | 2020-05-09 | Clinton | Iowa | 19045 | 55 | 1 |
128088 | 128088 | 2020-05-09 | Story | Iowa | 19169 | 55 | 1 |
119080 | 119080 | 2020-05-06 | Bremer | Iowa | 19017 | 55 | 5 |
116120 | 116120 | 2020-05-05 | Bremer | Iowa | 19017 | 55 | 5 |
113237 | 113237 | 2020-05-04 | Bremer | Iowa | 19017 | 55 | 5 |
98981 | 98981 | 2020-04-29 | Poweshiek | Iowa | 19157 | 55 | 2 |
82033 | 82033 | 2020-04-23 | Jasper | Iowa | 19099 | 55 | 0 |
76437 | 76437 | 2020-04-21 | Dallas | Iowa | 19049 | 55 | 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);