ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 28 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
551403 | 551403 | 2020-09-20 | Adams | Iowa | 19003 | 28 | 0 |
548164 | 548164 | 2020-09-19 | Adams | Iowa | 19003 | 28 | 0 |
451243 | 451243 | 2020-08-20 | Ringgold | Iowa | 19159 | 28 | 1 |
431832 | 431832 | 2020-08-14 | Decatur | Iowa | 19053 | 28 | 0 |
418914 | 418914 | 2020-08-10 | Audubon | Iowa | 19009 | 28 | 1 |
415693 | 415693 | 2020-08-09 | Audubon | Iowa | 19009 | 28 | 1 |
412473 | 412473 | 2020-08-08 | Audubon | Iowa | 19009 | 28 | 1 |
409250 | 409250 | 2020-08-07 | Adair | Iowa | 19001 | 28 | 0 |
409254 | 409254 | 2020-08-07 | Audubon | Iowa | 19009 | 28 | 1 |
406034 | 406034 | 2020-08-06 | Audubon | Iowa | 19009 | 28 | 1 |
402816 | 402816 | 2020-08-05 | Audubon | Iowa | 19009 | 28 | 1 |
399600 | 399600 | 2020-08-04 | Audubon | Iowa | 19009 | 28 | 1 |
396384 | 396384 | 2020-08-03 | Audubon | Iowa | 19009 | 28 | 1 |
393168 | 393168 | 2020-08-02 | Audubon | Iowa | 19009 | 28 | 1 |
389951 | 389951 | 2020-08-01 | Audubon | Iowa | 19009 | 28 | 1 |
386734 | 386734 | 2020-07-31 | Audubon | Iowa | 19009 | 28 | 1 |
386783 | 386783 | 2020-07-31 | Keokuk | Iowa | 19107 | 28 | 1 |
383516 | 383516 | 2020-07-30 | Audubon | Iowa | 19009 | 28 | 1 |
383565 | 383565 | 2020-07-30 | Keokuk | Iowa | 19107 | 28 | 1 |
383601 | 383601 | 2020-07-30 | Van Buren | Iowa | 19177 | 28 | 1 |
377124 | 377124 | 2020-07-28 | Ida | Iowa | 19093 | 28 | 0 |
373909 | 373909 | 2020-07-27 | Ida | Iowa | 19093 | 28 | 0 |
370704 | 370704 | 2020-07-26 | Keokuk | Iowa | 19107 | 28 | 1 |
367487 | 367487 | 2020-07-25 | Ida | Iowa | 19093 | 28 | 0 |
332330 | 332330 | 2020-07-14 | Worth | Iowa | 19195 | 28 | 0 |
322692 | 322692 | 2020-07-11 | Cass | Iowa | 19029 | 28 | 0 |
319587 | 319587 | 2020-07-10 | Unknown | Iowa | 28 | 0 | |
303736 | 303736 | 2020-07-05 | Union | Iowa | 19175 | 28 | 0 |
303744 | 303744 | 2020-07-05 | Winnebago | Iowa | 19189 | 28 | 0 |
300503 | 300503 | 2020-07-04 | Chickasaw | Iowa | 19037 | 28 | 0 |
300580 | 300580 | 2020-07-04 | Winnebago | Iowa | 19189 | 28 | 0 |
297341 | 297341 | 2020-07-03 | Chickasaw | Iowa | 19037 | 28 | 0 |
294201 | 294201 | 2020-07-02 | Greene | Iowa | 19073 | 28 | 0 |
294209 | 294209 | 2020-07-02 | Howard | Iowa | 19089 | 28 | 0 |
291047 | 291047 | 2020-07-01 | Greene | Iowa | 19073 | 28 | 0 |
291076 | 291076 | 2020-07-01 | Mitchell | Iowa | 19131 | 28 | 0 |
287897 | 287897 | 2020-06-30 | Greene | Iowa | 19073 | 28 | 0 |
284748 | 284748 | 2020-06-29 | Greene | Iowa | 19073 | 28 | 0 |
284808 | 284808 | 2020-06-29 | Winneshiek | Iowa | 19191 | 28 | 0 |
281603 | 281603 | 2020-06-28 | Greene | Iowa | 19073 | 28 | 0 |
278455 | 278455 | 2020-06-27 | Greene | Iowa | 19073 | 28 | 0 |
275307 | 275307 | 2020-06-26 | Greene | Iowa | 19073 | 28 | 0 |
272165 | 272165 | 2020-06-25 | Greene | Iowa | 19073 | 28 | 0 |
272187 | 272187 | 2020-06-25 | Lucas | Iowa | 19117 | 28 | 3 |
269028 | 269028 | 2020-06-24 | Greene | Iowa | 19073 | 28 | 0 |
265898 | 265898 | 2020-06-23 | Greene | Iowa | 19073 | 28 | 0 |
265920 | 265920 | 2020-06-23 | Lucas | Iowa | 19117 | 28 | 3 |
262770 | 262770 | 2020-06-22 | Greene | Iowa | 19073 | 28 | 0 |
259643 | 259643 | 2020-06-21 | Greene | Iowa | 19073 | 28 | 0 |
256513 | 256513 | 2020-06-20 | Fayette | Iowa | 19065 | 28 | 0 |
253393 | 253393 | 2020-06-19 | Fayette | Iowa | 19065 | 28 | 0 |
250278 | 250278 | 2020-06-18 | Fayette | Iowa | 19065 | 28 | 0 |
247145 | 247145 | 2020-06-17 | Butler | Iowa | 19023 | 28 | 2 |
247166 | 247166 | 2020-06-17 | Fayette | Iowa | 19065 | 28 | 0 |
244048 | 244048 | 2020-06-16 | Delaware | Iowa | 19055 | 28 | 1 |
244053 | 244053 | 2020-06-16 | Fayette | Iowa | 19065 | 28 | 0 |
240942 | 240942 | 2020-06-15 | Fayette | Iowa | 19065 | 28 | 0 |
237834 | 237834 | 2020-06-14 | Fayette | Iowa | 19065 | 28 | 0 |
234727 | 234727 | 2020-06-13 | Fayette | Iowa | 19065 | 28 | 0 |
231621 | 231621 | 2020-06-12 | Fayette | Iowa | 19065 | 28 | 0 |
228518 | 228518 | 2020-06-11 | Fayette | Iowa | 19065 | 28 | 0 |
228545 | 228545 | 2020-06-11 | Lyon | Iowa | 19119 | 28 | 0 |
225416 | 225416 | 2020-06-10 | Fayette | Iowa | 19065 | 28 | 0 |
222321 | 222321 | 2020-06-09 | Fayette | Iowa | 19065 | 28 | 0 |
222355 | 222355 | 2020-06-09 | Monona | Iowa | 19133 | 28 | 0 |
219226 | 219226 | 2020-06-08 | Fayette | Iowa | 19065 | 28 | 0 |
216134 | 216134 | 2020-06-07 | Fayette | Iowa | 19065 | 28 | 0 |
213040 | 213040 | 2020-06-06 | Davis | Iowa | 19051 | 28 | 0 |
213046 | 213046 | 2020-06-06 | Emmet | Iowa | 19063 | 28 | 0 |
209955 | 209955 | 2020-06-05 | Davis | Iowa | 19051 | 28 | 0 |
206874 | 206874 | 2020-06-04 | Davis | Iowa | 19051 | 28 | 0 |
206881 | 206881 | 2020-06-04 | Fayette | Iowa | 19065 | 28 | 0 |
206929 | 206929 | 2020-06-04 | Sac | Iowa | 19161 | 28 | 0 |
203801 | 203801 | 2020-06-03 | Fayette | Iowa | 19065 | 28 | 0 |
203824 | 203824 | 2020-06-03 | Lee | Iowa | 19111 | 28 | 0 |
191500 | 191500 | 2020-05-30 | Cherokee | Iowa | 19035 | 28 | 0 |
191543 | 191543 | 2020-05-30 | Madison | Iowa | 19121 | 28 | 2 |
191553 | 191553 | 2020-05-30 | O'Brien | Iowa | 19141 | 28 | 0 |
185430 | 185430 | 2020-05-28 | O'Brien | Iowa | 19141 | 28 | 0 |
179355 | 179355 | 2020-05-26 | Webster | Iowa | 19187 | 28 | 1 |
170194 | 170194 | 2020-05-23 | Marion | Iowa | 19125 | 28 | 0 |
170214 | 170214 | 2020-05-23 | Shelby | Iowa | 19165 | 28 | 0 |
167157 | 167157 | 2020-05-22 | Marion | Iowa | 19125 | 28 | 0 |
167177 | 167177 | 2020-05-22 | Shelby | Iowa | 19165 | 28 | 0 |
158079 | 158079 | 2020-05-19 | Osceola | Iowa | 19143 | 28 | 0 |
152002 | 152002 | 2020-05-17 | Clayton | Iowa | 19043 | 28 | 3 |
148992 | 148992 | 2020-05-16 | Clayton | Iowa | 19043 | 28 | 3 |
149017 | 149017 | 2020-05-16 | Iowa | Iowa | 19095 | 28 | 0 |
145988 | 145988 | 2020-05-15 | Clayton | Iowa | 19043 | 28 | 3 |
142988 | 142988 | 2020-05-14 | Clayton | Iowa | 19043 | 28 | 3 |
143013 | 143013 | 2020-05-14 | Iowa | Iowa | 19095 | 28 | 0 |
139992 | 139992 | 2020-05-13 | Clayton | Iowa | 19043 | 28 | 3 |
137000 | 137000 | 2020-05-12 | Clayton | Iowa | 19043 | 28 | 3 |
116119 | 116119 | 2020-05-05 | Boone | Iowa | 19015 | 28 | 0 |
116195 | 116195 | 2020-05-05 | Warren | Iowa | 19181 | 28 | 0 |
113236 | 113236 | 2020-05-04 | Boone | Iowa | 19015 | 28 | 0 |
96135 | 96135 | 2020-04-28 | Pottawattamie | Iowa | 19155 | 28 | 1 |
93250 | 93250 | 2020-04-27 | Cedar | Iowa | 19031 | 28 | 0 |
90431 | 90431 | 2020-04-26 | Cedar | Iowa | 19031 | 28 | 0 |
87615 | 87615 | 2020-04-25 | Cedar | Iowa | 19031 | 28 | 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);