ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 2261 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Iowa · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2194546 | 2194546 | 2022-02-08 | Guthrie | Iowa | 19077 | 2261 | 42 |
2191292 | 2191292 | 2022-02-07 | Guthrie | Iowa | 19077 | 2261 | 42 |
2188039 | 2188039 | 2022-02-06 | Guthrie | Iowa | 19077 | 2261 | 42 |
2184786 | 2184786 | 2022-02-05 | Guthrie | Iowa | 19077 | 2261 | 42 |
2181534 | 2181534 | 2022-02-04 | Guthrie | Iowa | 19077 | 2261 | 42 |
2178283 | 2178283 | 2022-02-03 | Guthrie | Iowa | 19077 | 2261 | 42 |
2175030 | 2175030 | 2022-02-02 | Guthrie | Iowa | 19077 | 2261 | 42 |
2148996 | 2148996 | 2022-01-25 | Franklin | Iowa | 19069 | 2261 | 36 |
2145744 | 2145744 | 2022-01-24 | Franklin | Iowa | 19069 | 2261 | 36 |
2142489 | 2142489 | 2022-01-23 | Franklin | Iowa | 19069 | 2261 | 36 |
2139234 | 2139234 | 2022-01-22 | Franklin | Iowa | 19069 | 2261 | 36 |
2135978 | 2135978 | 2022-01-21 | Franklin | Iowa | 19069 | 2261 | 36 |
2132726 | 2132726 | 2022-01-20 | Franklin | Iowa | 19069 | 2261 | 36 |
2129473 | 2129473 | 2022-01-19 | Franklin | Iowa | 19069 | 2261 | 36 |
1989713 | 1989713 | 2021-12-07 | Mills | Iowa | 19129 | 2261 | 30 |
1986463 | 1986463 | 2021-12-06 | Mills | Iowa | 19129 | 2261 | 30 |
1983213 | 1983213 | 2021-12-05 | Mills | Iowa | 19129 | 2261 | 30 |
1979963 | 1979963 | 2021-12-04 | Mills | Iowa | 19129 | 2261 | 30 |
1976713 | 1976713 | 2021-12-03 | Mills | Iowa | 19129 | 2261 | 30 |
1973464 | 1973464 | 2021-12-02 | Mills | Iowa | 19129 | 2261 | 30 |
1970214 | 1970214 | 2021-12-01 | Mills | Iowa | 19129 | 2261 | 30 |
1694039 | 1694039 | 2021-09-07 | Tama | Iowa | 19171 | 2261 | 73 |
1690790 | 1690790 | 2021-09-06 | Tama | Iowa | 19171 | 2261 | 73 |
1687540 | 1687540 | 2021-09-05 | Tama | Iowa | 19171 | 2261 | 73 |
1684290 | 1684290 | 2021-09-04 | Tama | Iowa | 19171 | 2261 | 73 |
1681039 | 1681039 | 2021-09-03 | Tama | Iowa | 19171 | 2261 | 73 |
1677791 | 1677791 | 2021-09-02 | Tama | Iowa | 19171 | 2261 | 73 |
1674544 | 1674544 | 2021-09-01 | Tama | Iowa | 19171 | 2261 | 73 |
1249177 | 1249177 | 2021-04-23 | Mahaska | Iowa | 19123 | 2261 | 50 |
1018604 | 1018604 | 2021-02-11 | Benton | Iowa | 19011 | 2261 | 53 |
729821 | 729821 | 2020-11-14 | Muscatine | Iowa | 19139 | 2261 | 61 |
668141 | 668141 | 2020-10-26 | Buena Vista | Iowa | 19021 | 2261 | 12 |
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);