ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 197 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Pottawattamie 7
- Wapello 7
- Scott 2
- Woodbury 2
state 1
- Iowa · 18 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353955 | 2353955 | 2022-03-29 | Wapello | Iowa | 19179 | 8957 | 197 |
2350703 | 2350703 | 2022-03-28 | Wapello | Iowa | 19179 | 8957 | 197 |
2347450 | 2347450 | 2022-03-27 | Wapello | Iowa | 19179 | 8957 | 197 |
2344197 | 2344197 | 2022-03-26 | Wapello | Iowa | 19179 | 8957 | 197 |
2340944 | 2340944 | 2022-03-25 | Wapello | Iowa | 19179 | 8957 | 197 |
2337691 | 2337691 | 2022-03-24 | Wapello | Iowa | 19179 | 8957 | 197 |
2334437 | 2334437 | 2022-03-23 | Wapello | Iowa | 19179 | 8957 | 197 |
1830484 | 1830484 | 2021-10-19 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1827235 | 1827235 | 2021-10-18 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1823986 | 1823986 | 2021-10-17 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1820737 | 1820737 | 2021-10-16 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1817488 | 1817488 | 2021-10-15 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1814240 | 1814240 | 2021-10-14 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1810991 | 1810991 | 2021-10-13 | Pottawattamie | Iowa | 19155 | 14078 | 197 |
1038153 | 1038153 | 2021-02-17 | Scott | Iowa | 19163 | 16817 | 197 |
1034908 | 1034908 | 2021-02-16 | Scott | Iowa | 19163 | 16795 | 197 |
986237 | 986237 | 2021-02-01 | Woodbury | Iowa | 19193 | 13271 | 197 |
982990 | 982990 | 2021-01-31 | Woodbury | Iowa | 19193 | 13258 | 197 |
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);