ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 566 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1693958 | 1693958 | 2021-09-07 | Audubon | Iowa | 19009 | 566 | 14 |
1690709 | 1690709 | 2021-09-06 | Audubon | Iowa | 19009 | 566 | 14 |
1687459 | 1687459 | 2021-09-05 | Audubon | Iowa | 19009 | 566 | 14 |
1684209 | 1684209 | 2021-09-04 | Audubon | Iowa | 19009 | 566 | 14 |
1680958 | 1680958 | 2021-09-03 | Audubon | Iowa | 19009 | 566 | 14 |
1677710 | 1677710 | 2021-09-02 | Audubon | Iowa | 19009 | 566 | 14 |
1674463 | 1674463 | 2021-09-01 | Audubon | Iowa | 19009 | 566 | 14 |
1580347 | 1580347 | 2021-08-03 | Wayne | Iowa | 19185 | 566 | 23 |
1577098 | 1577098 | 2021-08-02 | Wayne | Iowa | 19185 | 566 | 23 |
1573850 | 1573850 | 2021-08-01 | Wayne | Iowa | 19185 | 566 | 23 |
1570602 | 1570602 | 2021-07-31 | Wayne | Iowa | 19185 | 566 | 23 |
1567354 | 1567354 | 2021-07-30 | Wayne | Iowa | 19185 | 566 | 23 |
1564106 | 1564106 | 2021-07-29 | Wayne | Iowa | 19185 | 566 | 23 |
1560858 | 1560858 | 2021-07-28 | Wayne | Iowa | 19185 | 566 | 23 |
1489421 | 1489421 | 2021-07-06 | Van Buren | Iowa | 19177 | 566 | 18 |
1486174 | 1486174 | 2021-07-05 | Van Buren | Iowa | 19177 | 566 | 18 |
1482928 | 1482928 | 2021-07-04 | Van Buren | Iowa | 19177 | 566 | 18 |
1479681 | 1479681 | 2021-07-03 | Van Buren | Iowa | 19177 | 566 | 18 |
1132241 | 1132241 | 2021-03-18 | Fremont | Iowa | 19071 | 566 | 10 |
911595 | 911595 | 2021-01-09 | Worth | Iowa | 19195 | 566 | 3 |
901847 | 901847 | 2021-01-06 | Taylor | Iowa | 19173 | 566 | 9 |
859572 | 859572 | 2020-12-24 | Adair | Iowa | 19001 | 566 | 17 |
820649 | 820649 | 2020-12-12 | Davis | Iowa | 19051 | 566 | 12 |
697397 | 697397 | 2020-11-04 | Poweshiek | Iowa | 19157 | 566 | 11 |
557977 | 557977 | 2020-09-22 | Wright | Iowa | 19197 | 566 | 1 |
361121 | 361121 | 2020-07-23 | Webster | Iowa | 19187 | 566 | 5 |
219263 | 219263 | 2020-06-08 | Muscatine | Iowa | 19139 | 566 | 41 |
216171 | 216171 | 2020-06-07 | Muscatine | Iowa | 19139 | 566 | 41 |
206918 | 206918 | 2020-06-04 | Muscatine | Iowa | 19139 | 566 | 41 |
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);