ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 24 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
619548 | 619548 | 2020-10-11 | Unknown | Iowa | 24 | 0 | |
438336 | 438336 | 2020-08-16 | Ringgold | Iowa | 19159 | 24 | 1 |
435110 | 435110 | 2020-08-15 | Ringgold | Iowa | 19159 | 24 | 1 |
431885 | 431885 | 2020-08-14 | Ringgold | Iowa | 19159 | 24 | 1 |
377167 | 377167 | 2020-07-28 | Van Buren | Iowa | 19177 | 24 | 1 |
373952 | 373952 | 2020-07-27 | Van Buren | Iowa | 19177 | 24 | 1 |
370686 | 370686 | 2020-07-26 | Fremont | Iowa | 19071 | 24 | 0 |
364238 | 364238 | 2020-07-24 | Audubon | Iowa | 19009 | 24 | 1 |
357875 | 357875 | 2020-07-22 | Keokuk | Iowa | 19107 | 24 | 1 |
354673 | 354673 | 2020-07-21 | Keokuk | Iowa | 19107 | 24 | 1 |
351471 | 351471 | 2020-07-20 | Keokuk | Iowa | 19107 | 24 | 1 |
348264 | 348264 | 2020-07-19 | Ida | Iowa | 19093 | 24 | 0 |
348271 | 348271 | 2020-07-19 | Keokuk | Iowa | 19107 | 24 | 1 |
345063 | 345063 | 2020-07-18 | Ida | Iowa | 19093 | 24 | 0 |
345070 | 345070 | 2020-07-18 | Keokuk | Iowa | 19107 | 24 | 1 |
341863 | 341863 | 2020-07-17 | Ida | Iowa | 19093 | 24 | 0 |
341889 | 341889 | 2020-07-17 | Page | Iowa | 19145 | 24 | 0 |
338667 | 338667 | 2020-07-16 | Ida | Iowa | 19093 | 24 | 0 |
335471 | 335471 | 2020-07-15 | Ida | Iowa | 19093 | 24 | 0 |
332278 | 332278 | 2020-07-14 | Ida | Iowa | 19093 | 24 | 0 |
329048 | 329048 | 2020-07-13 | Appanoose | Iowa | 19007 | 24 | 3 |
329098 | 329098 | 2020-07-13 | Keokuk | Iowa | 19107 | 24 | 1 |
313166 | 313166 | 2020-07-08 | Cass | Iowa | 19029 | 24 | 0 |
309996 | 309996 | 2020-07-07 | Cass | Iowa | 19029 | 24 | 0 |
306860 | 306860 | 2020-07-06 | Ida | Iowa | 19093 | 24 | 0 |
303695 | 303695 | 2020-07-05 | Ida | Iowa | 19093 | 24 | 0 |
287909 | 287909 | 2020-06-30 | Jackson | Iowa | 19097 | 24 | 0 |
287926 | 287926 | 2020-06-30 | Mitchell | Iowa | 19131 | 24 | 0 |
287956 | 287956 | 2020-06-30 | Winnebago | Iowa | 19189 | 24 | 0 |
281585 | 281585 | 2020-06-28 | Chickasaw | Iowa | 19037 | 24 | 0 |
278437 | 278437 | 2020-06-27 | Chickasaw | Iowa | 19037 | 24 | 0 |
278506 | 278506 | 2020-06-27 | Union | Iowa | 19175 | 24 | 0 |
278515 | 278515 | 2020-06-27 | Winneshiek | Iowa | 19191 | 24 | 0 |
275289 | 275289 | 2020-06-26 | Chickasaw | Iowa | 19037 | 24 | 0 |
275344 | 275344 | 2020-06-26 | Palo Alto | Iowa | 19147 | 24 | 0 |
275367 | 275367 | 2020-06-26 | Winneshiek | Iowa | 19191 | 24 | 0 |
272202 | 272202 | 2020-06-25 | Palo Alto | Iowa | 19147 | 24 | 0 |
272225 | 272225 | 2020-06-25 | Winneshiek | Iowa | 19191 | 24 | 0 |
269065 | 269065 | 2020-06-24 | Palo Alto | Iowa | 19147 | 24 | 0 |
265958 | 265958 | 2020-06-23 | Winneshiek | Iowa | 19191 | 24 | 0 |
262830 | 262830 | 2020-06-22 | Winneshiek | Iowa | 19191 | 24 | 0 |
259661 | 259661 | 2020-06-21 | Kossuth | Iowa | 19109 | 24 | 0 |
259703 | 259703 | 2020-06-21 | Winneshiek | Iowa | 19191 | 24 | 0 |
256577 | 256577 | 2020-06-20 | Winneshiek | Iowa | 19191 | 24 | 0 |
253457 | 253457 | 2020-06-19 | Winneshiek | Iowa | 19191 | 24 | 0 |
250342 | 250342 | 2020-06-18 | Winneshiek | Iowa | 19191 | 24 | 0 |
247230 | 247230 | 2020-06-17 | Winneshiek | Iowa | 19191 | 24 | 0 |
244032 | 244032 | 2020-06-16 | Butler | Iowa | 19023 | 24 | 2 |
244033 | 244033 | 2020-06-16 | Calhoun | Iowa | 19025 | 24 | 0 |
244058 | 244058 | 2020-06-16 | Grundy | Iowa | 19075 | 24 | 0 |
244085 | 244085 | 2020-06-16 | Mills | Iowa | 19129 | 24 | 0 |
244117 | 244117 | 2020-06-16 | Winneshiek | Iowa | 19191 | 24 | 0 |
240922 | 240922 | 2020-06-15 | Calhoun | Iowa | 19025 | 24 | 0 |
240974 | 240974 | 2020-06-15 | Mills | Iowa | 19129 | 24 | 0 |
241006 | 241006 | 2020-06-15 | Winneshiek | Iowa | 19191 | 24 | 0 |
237860 | 237860 | 2020-06-14 | Lucas | Iowa | 19117 | 24 | 3 |
237866 | 237866 | 2020-06-14 | Mills | Iowa | 19129 | 24 | 0 |
237898 | 237898 | 2020-06-14 | Winneshiek | Iowa | 19191 | 24 | 0 |
234753 | 234753 | 2020-06-13 | Lucas | Iowa | 19117 | 24 | 3 |
234791 | 234791 | 2020-06-13 | Winneshiek | Iowa | 19191 | 24 | 0 |
231626 | 231626 | 2020-06-12 | Grundy | Iowa | 19075 | 24 | 0 |
231685 | 231685 | 2020-06-12 | Winneshiek | Iowa | 19191 | 24 | 0 |
228582 | 228582 | 2020-06-11 | Winneshiek | Iowa | 19191 | 24 | 0 |
225421 | 225421 | 2020-06-10 | Grundy | Iowa | 19075 | 24 | 0 |
222334 | 222334 | 2020-06-09 | Humboldt | Iowa | 19091 | 24 | 1 |
222385 | 222385 | 2020-06-09 | Winneshiek | Iowa | 19191 | 24 | 0 |
219239 | 219239 | 2020-06-08 | Humboldt | Iowa | 19091 | 24 | 1 |
219290 | 219290 | 2020-06-08 | Winneshiek | Iowa | 19191 | 24 | 0 |
216198 | 216198 | 2020-06-07 | Winneshiek | Iowa | 19191 | 24 | 0 |
213111 | 213111 | 2020-06-06 | Winneshiek | Iowa | 19191 | 24 | 0 |
209989 | 209989 | 2020-06-05 | Lyon | Iowa | 19119 | 24 | 0 |
210026 | 210026 | 2020-06-05 | Winneshiek | Iowa | 19191 | 24 | 0 |
206908 | 206908 | 2020-06-04 | Lyon | Iowa | 19119 | 24 | 0 |
206945 | 206945 | 2020-06-04 | Winneshiek | Iowa | 19191 | 24 | 0 |
203864 | 203864 | 2020-06-03 | Winneshiek | Iowa | 19191 | 24 | 0 |
200752 | 200752 | 2020-06-02 | Lyon | Iowa | 19119 | 24 | 0 |
200788 | 200788 | 2020-06-02 | Winneshiek | Iowa | 19191 | 24 | 0 |
197645 | 197645 | 2020-06-01 | Davis | Iowa | 19051 | 24 | 0 |
197662 | 197662 | 2020-06-01 | Harrison | Iowa | 19085 | 24 | 0 |
197679 | 197679 | 2020-06-01 | Lyon | Iowa | 19119 | 24 | 0 |
197716 | 197716 | 2020-06-01 | Winneshiek | Iowa | 19191 | 24 | 0 |
194609 | 194609 | 2020-05-31 | Lyon | Iowa | 19119 | 24 | 0 |
194646 | 194646 | 2020-05-31 | Winneshiek | Iowa | 19191 | 24 | 0 |
191549 | 191549 | 2020-05-30 | Monona | Iowa | 19133 | 24 | 0 |
191578 | 191578 | 2020-05-30 | Winneshiek | Iowa | 19191 | 24 | 0 |
188484 | 188484 | 2020-05-29 | Monona | Iowa | 19133 | 24 | 0 |
185377 | 185377 | 2020-05-28 | Cherokee | Iowa | 19035 | 24 | 0 |
185415 | 185415 | 2020-05-28 | Lee | Iowa | 19111 | 24 | 0 |
185426 | 185426 | 2020-05-28 | Monona | Iowa | 19133 | 24 | 0 |
182322 | 182322 | 2020-05-27 | Cerro Gordo | Iowa | 19033 | 24 | 1 |
182372 | 182372 | 2020-05-27 | Monona | Iowa | 19133 | 24 | 0 |
179327 | 179327 | 2020-05-26 | Monona | Iowa | 19133 | 24 | 0 |
176277 | 176277 | 2020-05-25 | Madison | Iowa | 19121 | 24 | 1 |
176283 | 176283 | 2020-05-25 | Monona | Iowa | 19133 | 24 | 0 |
176287 | 176287 | 2020-05-25 | O'Brien | Iowa | 19141 | 24 | 0 |
173233 | 173233 | 2020-05-24 | Madison | Iowa | 19121 | 24 | 1 |
173239 | 173239 | 2020-05-24 | Monona | Iowa | 19133 | 24 | 0 |
173243 | 173243 | 2020-05-24 | O'Brien | Iowa | 19141 | 24 | 0 |
170202 | 170202 | 2020-05-23 | O'Brien | Iowa | 19141 | 24 | 0 |
167165 | 167165 | 2020-05-22 | O'Brien | Iowa | 19141 | 24 | 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);