ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 121 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
668224 | 668224 | 2020-10-26 | Wayne | Iowa | 19185 | 121 | 3 |
638951 | 638951 | 2020-10-17 | Decatur | Iowa | 19053 | 121 | 0 |
635705 | 635705 | 2020-10-16 | Decatur | Iowa | 19053 | 121 | 0 |
629287 | 629287 | 2020-10-14 | Worth | Iowa | 19195 | 121 | 0 |
577356 | 577356 | 2020-09-28 | Fremont | Iowa | 19071 | 121 | 0 |
544996 | 544996 | 2020-09-18 | Osceola | Iowa | 19143 | 121 | 0 |
535282 | 535282 | 2020-09-15 | Monona | Iowa | 19133 | 121 | 1 |
506169 | 506169 | 2020-09-06 | Monroe | Iowa | 19135 | 121 | 8 |
502935 | 502935 | 2020-09-05 | Monroe | Iowa | 19135 | 121 | 8 |
499652 | 499652 | 2020-09-04 | Chickasaw | Iowa | 19037 | 121 | 0 |
499681 | 499681 | 2020-09-04 | Iowa | Iowa | 19095 | 121 | 1 |
499684 | 499684 | 2020-09-04 | Jefferson | Iowa | 19101 | 121 | 1 |
496448 | 496448 | 2020-09-03 | Iowa | Iowa | 19095 | 121 | 1 |
493247 | 493247 | 2020-09-02 | Sac | Iowa | 19161 | 121 | 0 |
483520 | 483520 | 2020-08-30 | Kossuth | Iowa | 19109 | 121 | 0 |
457695 | 457695 | 2020-08-22 | Pocahontas | Iowa | 19151 | 121 | 2 |
454467 | 454467 | 2020-08-21 | Pocahontas | Iowa | 19151 | 121 | 2 |
428653 | 428653 | 2020-08-13 | Pocahontas | Iowa | 19151 | 121 | 2 |
425409 | 425409 | 2020-08-12 | Lee | Iowa | 19111 | 121 | 4 |
422173 | 422173 | 2020-08-11 | Hancock | Iowa | 19081 | 121 | 2 |
418921 | 418921 | 2020-08-10 | Butler | Iowa | 19023 | 121 | 2 |
415700 | 415700 | 2020-08-09 | Butler | Iowa | 19023 | 121 | 2 |
415749 | 415749 | 2020-08-09 | Madison | Iowa | 19121 | 121 | 2 |
412509 | 412509 | 2020-08-08 | Hancock | Iowa | 19081 | 121 | 2 |
409290 | 409290 | 2020-08-07 | Hancock | Iowa | 19081 | 121 | 2 |
406070 | 406070 | 2020-08-06 | Hancock | Iowa | 19081 | 121 | 2 |
364312 | 364312 | 2020-07-24 | Poweshiek | Iowa | 19157 | 121 | 8 |
335438 | 335438 | 2020-07-15 | Carroll | Iowa | 19027 | 121 | 1 |
332314 | 332314 | 2020-07-14 | Shelby | Iowa | 19165 | 121 | 0 |
316348 | 316348 | 2020-07-09 | Clinton | Iowa | 19045 | 121 | 1 |
268994 | 268994 | 2020-06-24 | Allamakee | Iowa | 19005 | 121 | 4 |
259609 | 259609 | 2020-06-21 | Allamakee | Iowa | 19005 | 121 | 4 |
256483 | 256483 | 2020-06-20 | Allamakee | Iowa | 19005 | 121 | 4 |
253363 | 253363 | 2020-06-19 | Allamakee | Iowa | 19005 | 121 | 4 |
250248 | 250248 | 2020-06-18 | Allamakee | Iowa | 19005 | 121 | 4 |
247136 | 247136 | 2020-06-17 | Allamakee | Iowa | 19005 | 121 | 4 |
244023 | 244023 | 2020-06-16 | Allamakee | Iowa | 19005 | 121 | 4 |
240912 | 240912 | 2020-06-15 | Allamakee | Iowa | 19005 | 121 | 4 |
237804 | 237804 | 2020-06-14 | Allamakee | Iowa | 19005 | 121 | 4 |
234697 | 234697 | 2020-06-13 | Allamakee | Iowa | 19005 | 121 | 4 |
231591 | 231591 | 2020-06-12 | Allamakee | Iowa | 19005 | 121 | 4 |
228488 | 228488 | 2020-06-11 | Allamakee | Iowa | 19005 | 121 | 4 |
225386 | 225386 | 2020-06-10 | Allamakee | Iowa | 19005 | 121 | 4 |
194552 | 194552 | 2020-05-31 | Allamakee | Iowa | 19005 | 121 | 4 |
188509 | 188509 | 2020-05-29 | Warren | Iowa | 19181 | 121 | 0 |
65425 | 65425 | 2020-04-17 | Tama | Iowa | 19171 | 121 | 5 |
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);