ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
854 rows where deaths = 34 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Hancock 144
- Boone 89
- Buchanan 47
- Butler 43
- Jasper 38
- Adair 35
- Ringgold 31
- Grundy 28
- Guthrie 28
- Shelby 28
- Ida 18
- Pottawattamie 15
- Clarke 14
- Howard 14
- Iowa 14
- Jefferson 14
- Keokuk 14
- Marshall 14
- Monona 14
- Monroe 14
- Winnebago 14
- Appanoose 12
- Carroll 12
- Dallas 11
- Plymouth 11
- Union 11
- Hardin 8
- Mitchell 8
- Crawford 7
- Franklin 7
- …
state 1
- Iowa · 854 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500452 | 2500452 | 2022-05-13 | Ringgold | Iowa | 19159 | 1135 | 34 |
2497194 | 2497194 | 2022-05-12 | Ringgold | Iowa | 19159 | 1135 | 34 |
2493936 | 2493936 | 2022-05-11 | Ringgold | Iowa | 19159 | 1135 | 34 |
2490678 | 2490678 | 2022-05-10 | Ringgold | Iowa | 19159 | 1133 | 34 |
2487421 | 2487421 | 2022-05-09 | Ringgold | Iowa | 19159 | 1133 | 34 |
2484163 | 2484163 | 2022-05-08 | Ringgold | Iowa | 19159 | 1133 | 34 |
2480905 | 2480905 | 2022-05-07 | Ringgold | Iowa | 19159 | 1133 | 34 |
2477647 | 2477647 | 2022-05-06 | Ringgold | Iowa | 19159 | 1133 | 34 |
2474389 | 2474389 | 2022-05-05 | Ringgold | Iowa | 19159 | 1133 | 34 |
2471132 | 2471132 | 2022-05-04 | Ringgold | Iowa | 19159 | 1133 | 34 |
2467876 | 2467876 | 2022-05-03 | Ringgold | Iowa | 19159 | 1135 | 34 |
2464621 | 2464621 | 2022-05-02 | Ringgold | Iowa | 19159 | 1135 | 34 |
2461365 | 2461365 | 2022-05-01 | Ringgold | Iowa | 19159 | 1135 | 34 |
2458109 | 2458109 | 2022-04-30 | Ringgold | Iowa | 19159 | 1135 | 34 |
2454853 | 2454853 | 2022-04-29 | Ringgold | Iowa | 19159 | 1135 | 34 |
2451597 | 2451597 | 2022-04-28 | Ringgold | Iowa | 19159 | 1135 | 34 |
2448341 | 2448341 | 2022-04-27 | Ringgold | Iowa | 19159 | 1135 | 34 |
2445085 | 2445085 | 2022-04-26 | Ringgold | Iowa | 19159 | 1135 | 34 |
2441829 | 2441829 | 2022-04-25 | Ringgold | Iowa | 19159 | 1135 | 34 |
2438573 | 2438573 | 2022-04-24 | Ringgold | Iowa | 19159 | 1135 | 34 |
2435317 | 2435317 | 2022-04-23 | Ringgold | Iowa | 19159 | 1135 | 34 |
2432061 | 2432061 | 2022-04-22 | Ringgold | Iowa | 19159 | 1135 | 34 |
2428805 | 2428805 | 2022-04-21 | Ringgold | Iowa | 19159 | 1135 | 34 |
2425549 | 2425549 | 2022-04-20 | Ringgold | Iowa | 19159 | 1135 | 34 |
2422293 | 2422293 | 2022-04-19 | Ringgold | Iowa | 19159 | 1135 | 34 |
2419037 | 2419037 | 2022-04-18 | Ringgold | Iowa | 19159 | 1135 | 34 |
2415781 | 2415781 | 2022-04-17 | Ringgold | Iowa | 19159 | 1135 | 34 |
2412525 | 2412525 | 2022-04-16 | Ringgold | Iowa | 19159 | 1135 | 34 |
2409269 | 2409269 | 2022-04-15 | Ringgold | Iowa | 19159 | 1135 | 34 |
2406013 | 2406013 | 2022-04-14 | Ringgold | Iowa | 19159 | 1135 | 34 |
2402757 | 2402757 | 2022-04-13 | Ringgold | Iowa | 19159 | 1135 | 34 |
2331137 | 2331137 | 2022-03-22 | Howard | Iowa | 19089 | 2036 | 34 |
2327885 | 2327885 | 2022-03-21 | Howard | Iowa | 19089 | 2036 | 34 |
2324632 | 2324632 | 2022-03-20 | Howard | Iowa | 19089 | 2036 | 34 |
2321378 | 2321378 | 2022-03-19 | Howard | Iowa | 19089 | 2036 | 34 |
2318124 | 2318124 | 2022-03-18 | Howard | Iowa | 19089 | 2036 | 34 |
2314871 | 2314871 | 2022-03-17 | Howard | Iowa | 19089 | 2036 | 34 |
2311618 | 2311618 | 2022-03-16 | Howard | Iowa | 19089 | 2036 | 34 |
2308365 | 2308365 | 2022-03-15 | Howard | Iowa | 19089 | 2035 | 34 |
2305114 | 2305114 | 2022-03-14 | Howard | Iowa | 19089 | 2035 | 34 |
2301862 | 2301862 | 2022-03-13 | Howard | Iowa | 19089 | 2035 | 34 |
2298610 | 2298610 | 2022-03-12 | Howard | Iowa | 19089 | 2035 | 34 |
2295358 | 2295358 | 2022-03-11 | Howard | Iowa | 19089 | 2035 | 34 |
2292106 | 2292106 | 2022-03-10 | Howard | Iowa | 19089 | 2035 | 34 |
2288854 | 2288854 | 2022-03-09 | Howard | Iowa | 19089 | 2035 | 34 |
2240054 | 2240054 | 2022-02-22 | Clarke | Iowa | 19039 | 2225 | 34 |
2240095 | 2240095 | 2022-02-22 | Madison | Iowa | 19121 | 3090 | 34 |
2236803 | 2236803 | 2022-02-21 | Clarke | Iowa | 19039 | 2225 | 34 |
2236844 | 2236844 | 2022-02-21 | Madison | Iowa | 19121 | 3090 | 34 |
2233552 | 2233552 | 2022-02-20 | Clarke | Iowa | 19039 | 2225 | 34 |
2233593 | 2233593 | 2022-02-20 | Madison | Iowa | 19121 | 3090 | 34 |
2230301 | 2230301 | 2022-02-19 | Clarke | Iowa | 19039 | 2225 | 34 |
2230342 | 2230342 | 2022-02-19 | Madison | Iowa | 19121 | 3090 | 34 |
2227050 | 2227050 | 2022-02-18 | Clarke | Iowa | 19039 | 2225 | 34 |
2227091 | 2227091 | 2022-02-18 | Madison | Iowa | 19121 | 3090 | 34 |
2223799 | 2223799 | 2022-02-17 | Clarke | Iowa | 19039 | 2225 | 34 |
2223840 | 2223840 | 2022-02-17 | Madison | Iowa | 19121 | 3090 | 34 |
2220548 | 2220548 | 2022-02-16 | Clarke | Iowa | 19039 | 2225 | 34 |
2220589 | 2220589 | 2022-02-16 | Madison | Iowa | 19121 | 3090 | 34 |
2217297 | 2217297 | 2022-02-15 | Clarke | Iowa | 19039 | 2195 | 34 |
2214046 | 2214046 | 2022-02-14 | Clarke | Iowa | 19039 | 2195 | 34 |
2210794 | 2210794 | 2022-02-13 | Clarke | Iowa | 19039 | 2195 | 34 |
2207541 | 2207541 | 2022-02-12 | Clarke | Iowa | 19039 | 2195 | 34 |
2204288 | 2204288 | 2022-02-11 | Clarke | Iowa | 19039 | 2195 | 34 |
2201035 | 2201035 | 2022-02-10 | Clarke | Iowa | 19039 | 2195 | 34 |
2197781 | 2197781 | 2022-02-09 | Clarke | Iowa | 19039 | 2195 | 34 |
2149035 | 2149035 | 2022-01-25 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2145783 | 2145783 | 2022-01-24 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2142528 | 2142528 | 2022-01-23 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2139273 | 2139273 | 2022-01-22 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2136017 | 2136017 | 2022-01-21 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2132765 | 2132765 | 2022-01-20 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2129512 | 2129512 | 2022-01-19 | Palo Alto | Iowa | 19147 | 1849 | 34 |
2035194 | 2035194 | 2021-12-21 | Franklin | Iowa | 19069 | 1958 | 34 |
2031944 | 2031944 | 2021-12-20 | Franklin | Iowa | 19069 | 1958 | 34 |
2028693 | 2028693 | 2021-12-19 | Franklin | Iowa | 19069 | 1958 | 34 |
2025442 | 2025442 | 2021-12-18 | Franklin | Iowa | 19069 | 1958 | 34 |
2022191 | 2022191 | 2021-12-17 | Franklin | Iowa | 19069 | 1958 | 34 |
2018940 | 2018940 | 2021-12-16 | Franklin | Iowa | 19069 | 1958 | 34 |
2015690 | 2015690 | 2021-12-15 | Franklin | Iowa | 19069 | 1958 | 34 |
1966947 | 1966947 | 2021-11-30 | Iowa | Iowa | 19095 | 2302 | 34 |
1963695 | 1963695 | 2021-11-29 | Iowa | Iowa | 19095 | 2302 | 34 |
1960444 | 1960444 | 2021-11-28 | Iowa | Iowa | 19095 | 2302 | 34 |
1957193 | 1957193 | 2021-11-27 | Iowa | Iowa | 19095 | 2302 | 34 |
1953942 | 1953942 | 2021-11-26 | Iowa | Iowa | 19095 | 2302 | 34 |
1950691 | 1950691 | 2021-11-25 | Iowa | Iowa | 19095 | 2302 | 34 |
1947440 | 1947440 | 2021-11-24 | Iowa | Iowa | 19095 | 2302 | 34 |
1944189 | 1944189 | 2021-11-23 | Iowa | Iowa | 19095 | 2254 | 34 |
1940939 | 1940939 | 2021-11-22 | Iowa | Iowa | 19095 | 2254 | 34 |
1937689 | 1937689 | 2021-11-21 | Iowa | Iowa | 19095 | 2254 | 34 |
1934439 | 1934439 | 2021-11-20 | Iowa | Iowa | 19095 | 2254 | 34 |
1931188 | 1931188 | 2021-11-19 | Iowa | Iowa | 19095 | 2254 | 34 |
1927937 | 1927937 | 2021-11-18 | Iowa | Iowa | 19095 | 2254 | 34 |
1924687 | 1924687 | 2021-11-17 | Iowa | Iowa | 19095 | 2254 | 34 |
1921486 | 1921486 | 2021-11-16 | Winnebago | Iowa | 19189 | 2018 | 34 |
1918236 | 1918236 | 2021-11-15 | Winnebago | Iowa | 19189 | 2018 | 34 |
1914986 | 1914986 | 2021-11-14 | Winnebago | Iowa | 19189 | 2018 | 34 |
1911736 | 1911736 | 2021-11-13 | Winnebago | Iowa | 19189 | 2018 | 34 |
1908487 | 1908487 | 2021-11-12 | Winnebago | Iowa | 19189 | 2018 | 34 |
1905238 | 1905238 | 2021-11-11 | Winnebago | Iowa | 19189 | 2018 | 34 |
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);