ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
606 rows where deaths = 30 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Monona 62
- Mills 42
- Boone 39
- Grundy 34
- Winnebago 30
- Howard 28
- Keokuk 28
- Ida 26
- Buchanan 21
- Cedar 21
- Chickasaw 21
- Poweshiek 19
- Johnson 16
- Jasper 15
- Louisa 11
- Hamilton 10
- Butler 9
- Guthrie 9
- Monroe 9
- Tama 9
- Wapello 9
- Allamakee 8
- Henry 8
- Humboldt 7
- Madison 7
- Page 7
- Palo Alto 7
- Ringgold 7
- Sac 7
- Winneshiek 7
- …
state 1
- Iowa · 606 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2262836 | 2262836 | 2022-03-01 | Howard | Iowa | 19089 | 2022 | 30 |
2259585 | 2259585 | 2022-02-28 | Howard | Iowa | 19089 | 2022 | 30 |
2256334 | 2256334 | 2022-02-27 | Howard | Iowa | 19089 | 2022 | 30 |
2253083 | 2253083 | 2022-02-26 | Howard | Iowa | 19089 | 2022 | 30 |
2249832 | 2249832 | 2022-02-25 | Howard | Iowa | 19089 | 2022 | 30 |
2246581 | 2246581 | 2022-02-24 | Howard | Iowa | 19089 | 2022 | 30 |
2243330 | 2243330 | 2022-02-23 | Howard | Iowa | 19089 | 2022 | 30 |
2240050 | 2240050 | 2022-02-22 | Cedar | Iowa | 19031 | 4060 | 30 |
2240053 | 2240053 | 2022-02-22 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2240079 | 2240079 | 2022-02-22 | Howard | Iowa | 19089 | 2013 | 30 |
2236799 | 2236799 | 2022-02-21 | Cedar | Iowa | 19031 | 4060 | 30 |
2236802 | 2236802 | 2022-02-21 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2236828 | 2236828 | 2022-02-21 | Howard | Iowa | 19089 | 2013 | 30 |
2233548 | 2233548 | 2022-02-20 | Cedar | Iowa | 19031 | 4060 | 30 |
2233551 | 2233551 | 2022-02-20 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2233577 | 2233577 | 2022-02-20 | Howard | Iowa | 19089 | 2013 | 30 |
2230297 | 2230297 | 2022-02-19 | Cedar | Iowa | 19031 | 4060 | 30 |
2230300 | 2230300 | 2022-02-19 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2230326 | 2230326 | 2022-02-19 | Howard | Iowa | 19089 | 2013 | 30 |
2227046 | 2227046 | 2022-02-18 | Cedar | Iowa | 19031 | 4060 | 30 |
2227049 | 2227049 | 2022-02-18 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2227075 | 2227075 | 2022-02-18 | Howard | Iowa | 19089 | 2013 | 30 |
2223795 | 2223795 | 2022-02-17 | Cedar | Iowa | 19031 | 4060 | 30 |
2223798 | 2223798 | 2022-02-17 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2223824 | 2223824 | 2022-02-17 | Howard | Iowa | 19089 | 2013 | 30 |
2220544 | 2220544 | 2022-02-16 | Cedar | Iowa | 19031 | 4060 | 30 |
2220547 | 2220547 | 2022-02-16 | Chickasaw | Iowa | 19037 | 2637 | 30 |
2220573 | 2220573 | 2022-02-16 | Howard | Iowa | 19089 | 2013 | 30 |
2217293 | 2217293 | 2022-02-15 | Cedar | Iowa | 19031 | 3991 | 30 |
2217296 | 2217296 | 2022-02-15 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2217322 | 2217322 | 2022-02-15 | Howard | Iowa | 19089 | 1998 | 30 |
2214042 | 2214042 | 2022-02-14 | Cedar | Iowa | 19031 | 3991 | 30 |
2214045 | 2214045 | 2022-02-14 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2214071 | 2214071 | 2022-02-14 | Howard | Iowa | 19089 | 1998 | 30 |
2210790 | 2210790 | 2022-02-13 | Cedar | Iowa | 19031 | 3991 | 30 |
2210793 | 2210793 | 2022-02-13 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2210819 | 2210819 | 2022-02-13 | Howard | Iowa | 19089 | 1998 | 30 |
2207537 | 2207537 | 2022-02-12 | Cedar | Iowa | 19031 | 3991 | 30 |
2207540 | 2207540 | 2022-02-12 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2207566 | 2207566 | 2022-02-12 | Howard | Iowa | 19089 | 1998 | 30 |
2204284 | 2204284 | 2022-02-11 | Cedar | Iowa | 19031 | 3991 | 30 |
2204287 | 2204287 | 2022-02-11 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2204313 | 2204313 | 2022-02-11 | Howard | Iowa | 19089 | 1998 | 30 |
2201031 | 2201031 | 2022-02-10 | Cedar | Iowa | 19031 | 3991 | 30 |
2201034 | 2201034 | 2022-02-10 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2201060 | 2201060 | 2022-02-10 | Howard | Iowa | 19089 | 1998 | 30 |
2197777 | 2197777 | 2022-02-09 | Cedar | Iowa | 19031 | 3991 | 30 |
2197780 | 2197780 | 2022-02-09 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2197806 | 2197806 | 2022-02-09 | Howard | Iowa | 19089 | 1998 | 30 |
2194523 | 2194523 | 2022-02-08 | Cedar | Iowa | 19031 | 3880 | 30 |
2194526 | 2194526 | 2022-02-08 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2194552 | 2194552 | 2022-02-08 | Howard | Iowa | 19089 | 1972 | 30 |
2191269 | 2191269 | 2022-02-07 | Cedar | Iowa | 19031 | 3880 | 30 |
2191272 | 2191272 | 2022-02-07 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2191298 | 2191298 | 2022-02-07 | Howard | Iowa | 19089 | 1972 | 30 |
2188016 | 2188016 | 2022-02-06 | Cedar | Iowa | 19031 | 3880 | 30 |
2188019 | 2188019 | 2022-02-06 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2188045 | 2188045 | 2022-02-06 | Howard | Iowa | 19089 | 1972 | 30 |
2184763 | 2184763 | 2022-02-05 | Cedar | Iowa | 19031 | 3880 | 30 |
2184766 | 2184766 | 2022-02-05 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2184792 | 2184792 | 2022-02-05 | Howard | Iowa | 19089 | 1972 | 30 |
2181511 | 2181511 | 2022-02-04 | Cedar | Iowa | 19031 | 3880 | 30 |
2181514 | 2181514 | 2022-02-04 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2181540 | 2181540 | 2022-02-04 | Howard | Iowa | 19089 | 1972 | 30 |
2178260 | 2178260 | 2022-02-03 | Cedar | Iowa | 19031 | 3880 | 30 |
2178263 | 2178263 | 2022-02-03 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2178289 | 2178289 | 2022-02-03 | Howard | Iowa | 19089 | 1972 | 30 |
2175007 | 2175007 | 2022-02-02 | Cedar | Iowa | 19031 | 3880 | 30 |
2175010 | 2175010 | 2022-02-02 | Chickasaw | Iowa | 19037 | 2572 | 30 |
2175036 | 2175036 | 2022-02-02 | Howard | Iowa | 19089 | 1972 | 30 |
2171799 | 2171799 | 2022-02-01 | Madison | Iowa | 19121 | 2953 | 30 |
2171819 | 2171819 | 2022-02-01 | Sac | Iowa | 19161 | 2247 | 30 |
2168546 | 2168546 | 2022-01-31 | Madison | Iowa | 19121 | 2953 | 30 |
2168566 | 2168566 | 2022-01-31 | Sac | Iowa | 19161 | 2247 | 30 |
2165291 | 2165291 | 2022-01-30 | Madison | Iowa | 19121 | 2953 | 30 |
2165311 | 2165311 | 2022-01-30 | Sac | Iowa | 19161 | 2247 | 30 |
2162036 | 2162036 | 2022-01-29 | Madison | Iowa | 19121 | 2953 | 30 |
2162056 | 2162056 | 2022-01-29 | Sac | Iowa | 19161 | 2247 | 30 |
2158781 | 2158781 | 2022-01-28 | Madison | Iowa | 19121 | 2953 | 30 |
2158801 | 2158801 | 2022-01-28 | Sac | Iowa | 19161 | 2247 | 30 |
2155527 | 2155527 | 2022-01-27 | Madison | Iowa | 19121 | 2953 | 30 |
2155547 | 2155547 | 2022-01-27 | Sac | Iowa | 19161 | 2247 | 30 |
2152274 | 2152274 | 2022-01-26 | Madison | Iowa | 19121 | 2953 | 30 |
2152294 | 2152294 | 2022-01-26 | Sac | Iowa | 19161 | 2247 | 30 |
2080727 | 2080727 | 2022-01-04 | Mills | Iowa | 19129 | 2496 | 30 |
2077475 | 2077475 | 2022-01-03 | Mills | Iowa | 19129 | 2496 | 30 |
2074224 | 2074224 | 2022-01-02 | Mills | Iowa | 19129 | 2496 | 30 |
2070973 | 2070973 | 2022-01-01 | Mills | Iowa | 19129 | 2496 | 30 |
2067722 | 2067722 | 2021-12-31 | Mills | Iowa | 19129 | 2496 | 30 |
2064471 | 2064471 | 2021-12-30 | Mills | Iowa | 19129 | 2496 | 30 |
2061221 | 2061221 | 2021-12-29 | Mills | Iowa | 19129 | 2496 | 30 |
2057972 | 2057972 | 2021-12-28 | Mills | Iowa | 19129 | 2438 | 30 |
2054723 | 2054723 | 2021-12-27 | Mills | Iowa | 19129 | 2438 | 30 |
2051473 | 2051473 | 2021-12-26 | Mills | Iowa | 19129 | 2438 | 30 |
2048223 | 2048223 | 2021-12-25 | Mills | Iowa | 19129 | 2438 | 30 |
2044973 | 2044973 | 2021-12-24 | Mills | Iowa | 19129 | 2438 | 30 |
2041724 | 2041724 | 2021-12-23 | Mills | Iowa | 19129 | 2438 | 30 |
2038474 | 2038474 | 2021-12-22 | Mills | Iowa | 19129 | 2438 | 30 |
2035224 | 2035224 | 2021-12-21 | Mills | Iowa | 19129 | 2380 | 30 |
2031974 | 2031974 | 2021-12-20 | Mills | Iowa | 19129 | 2380 | 30 |
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);