ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 79 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
661643 | 661643 | 2020-10-24 | Adams | Iowa | 19003 | 79 | 0 |
544960 | 544960 | 2020-09-18 | Fremont | Iowa | 19071 | 79 | 0 |
545018 | 545018 | 2020-09-18 | Wayne | Iowa | 19185 | 79 | 2 |
522325 | 522325 | 2020-09-11 | Keokuk | Iowa | 19107 | 79 | 1 |
483564 | 483564 | 2020-08-30 | Worth | Iowa | 19195 | 79 | 0 |
480330 | 480330 | 2020-08-29 | Worth | Iowa | 19195 | 79 | 0 |
477097 | 477097 | 2020-08-28 | Worth | Iowa | 19195 | 79 | 0 |
457678 | 457678 | 2020-08-22 | Lucas | Iowa | 19117 | 79 | 4 |
454450 | 454450 | 2020-08-21 | Lucas | Iowa | 19117 | 79 | 4 |
451182 | 451182 | 2020-08-20 | Chickasaw | Iowa | 19037 | 79 | 0 |
451222 | 451222 | 2020-08-20 | Lucas | Iowa | 19117 | 79 | 4 |
441550 | 441550 | 2020-08-17 | Monroe | Iowa | 19135 | 79 | 8 |
422147 | 422147 | 2020-08-11 | Cass | Iowa | 19029 | 79 | 1 |
422198 | 422198 | 2020-08-11 | Mitchell | Iowa | 19131 | 79 | 0 |
418947 | 418947 | 2020-08-10 | Grundy | Iowa | 19075 | 79 | 1 |
415726 | 415726 | 2020-08-09 | Grundy | Iowa | 19075 | 79 | 1 |
412506 | 412506 | 2020-08-08 | Grundy | Iowa | 19075 | 79 | 1 |
412564 | 412564 | 2020-08-08 | Winnebago | Iowa | 19189 | 79 | 0 |
409321 | 409321 | 2020-08-07 | Osceola | Iowa | 19143 | 79 | 0 |
409344 | 409344 | 2020-08-07 | Winnebago | Iowa | 19189 | 79 | 0 |
406101 | 406101 | 2020-08-06 | Osceola | Iowa | 19143 | 79 | 0 |
396453 | 396453 | 2020-08-03 | Palo Alto | Iowa | 19147 | 79 | 0 |
393196 | 393196 | 2020-08-02 | Fayette | Iowa | 19065 | 79 | 0 |
390011 | 390011 | 2020-08-01 | Mills | Iowa | 19129 | 79 | 0 |
386810 | 386810 | 2020-07-31 | Sac | Iowa | 19161 | 79 | 0 |
383592 | 383592 | 2020-07-30 | Sac | Iowa | 19161 | 79 | 0 |
373890 | 373890 | 2020-07-27 | Delaware | Iowa | 19055 | 79 | 1 |
370672 | 370672 | 2020-07-26 | Clayton | Iowa | 19043 | 79 | 3 |
361087 | 361087 | 2020-07-23 | Madison | Iowa | 19121 | 79 | 2 |
354679 | 354679 | 2020-07-21 | Lyon | Iowa | 19119 | 79 | 0 |
341883 | 341883 | 2020-07-17 | Monona | Iowa | 19133 | 79 | 0 |
332237 | 332237 | 2020-07-14 | Benton | Iowa | 19011 | 79 | 1 |
313169 | 313169 | 2020-07-08 | Cherokee | Iowa | 19035 | 79 | 1 |
306900 | 306900 | 2020-07-06 | Taylor | Iowa | 19173 | 79 | 0 |
303735 | 303735 | 2020-07-05 | Taylor | Iowa | 19173 | 79 | 0 |
300571 | 300571 | 2020-07-04 | Taylor | Iowa | 19173 | 79 | 0 |
297409 | 297409 | 2020-07-03 | Taylor | Iowa | 19173 | 79 | 0 |
294251 | 294251 | 2020-07-02 | Taylor | Iowa | 19173 | 79 | 0 |
291097 | 291097 | 2020-07-01 | Taylor | Iowa | 19173 | 79 | 0 |
287947 | 287947 | 2020-06-30 | Taylor | Iowa | 19173 | 79 | 0 |
281580 | 281580 | 2020-06-28 | Carroll | Iowa | 19027 | 79 | 1 |
272172 | 272172 | 2020-06-25 | Henry | Iowa | 19087 | 79 | 3 |
269020 | 269020 | 2020-06-24 | Des Moines | Iowa | 19057 | 79 | 2 |
269062 | 269062 | 2020-06-24 | O'Brien | Iowa | 19141 | 79 | 1 |
265905 | 265905 | 2020-06-23 | Henry | Iowa | 19087 | 79 | 3 |
259689 | 259689 | 2020-06-21 | Shelby | Iowa | 19165 | 79 | 0 |
225391 | 225391 | 2020-06-10 | Boone | Iowa | 19015 | 79 | 0 |
222308 | 222308 | 2020-06-09 | Clarke | Iowa | 19039 | 79 | 1 |
155075 | 155075 | 2020-05-18 | Story | Iowa | 19169 | 79 | 1 |
131074 | 131074 | 2020-05-10 | Poweshiek | Iowa | 19157 | 79 | 5 |
128083 | 128083 | 2020-05-09 | Poweshiek | Iowa | 19157 | 79 | 5 |
87643 | 87643 | 2020-04-25 | Jasper | Iowa | 19099 | 79 | 0 |
54547 | 54547 | 2020-04-13 | Louisa | Iowa | 19115 | 79 | 0 |
49229 | 49229 | 2020-04-11 | Washington | Iowa | 19183 | 79 | 3 |
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);