ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where deaths = 79 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 20
county 20
- Plymouth 58
- Marshall 56
- Bremer 35
- Washington 17
- Harrison 14
- Cerro Gordo 11
- Des Moines 7
- Jasper 7
- Mahaska 7
- Marion 7
- Story 7
- Linn 6
- Warren 6
- Johnson 3
- Black Hawk 2
- Muscatine 2
- Dallas 1
- Dubuque 1
- Polk 1
- Pottawattamie 1
state 1
- Iowa · 249 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500465 | 2500465 | 2022-05-13 | Washington | Iowa | 19183 | 5681 | 79 |
2497207 | 2497207 | 2022-05-12 | Washington | Iowa | 19183 | 5681 | 79 |
2493949 | 2493949 | 2022-05-11 | Washington | Iowa | 19183 | 5681 | 79 |
2490691 | 2490691 | 2022-05-10 | Washington | Iowa | 19183 | 5665 | 79 |
2487434 | 2487434 | 2022-05-09 | Washington | Iowa | 19183 | 5665 | 79 |
2484176 | 2484176 | 2022-05-08 | Washington | Iowa | 19183 | 5665 | 79 |
2480918 | 2480918 | 2022-05-07 | Washington | Iowa | 19183 | 5665 | 79 |
2477660 | 2477660 | 2022-05-06 | Washington | Iowa | 19183 | 5665 | 79 |
2474402 | 2474402 | 2022-05-05 | Washington | Iowa | 19183 | 5665 | 79 |
2471145 | 2471145 | 2022-05-04 | Washington | Iowa | 19183 | 5665 | 79 |
2467889 | 2467889 | 2022-05-03 | Washington | Iowa | 19183 | 5651 | 79 |
2464634 | 2464634 | 2022-05-02 | Washington | Iowa | 19183 | 5651 | 79 |
2461378 | 2461378 | 2022-05-01 | Washington | Iowa | 19183 | 5651 | 79 |
2458122 | 2458122 | 2022-04-30 | Washington | Iowa | 19183 | 5651 | 79 |
2454866 | 2454866 | 2022-04-29 | Washington | Iowa | 19183 | 5651 | 79 |
2451610 | 2451610 | 2022-04-28 | Washington | Iowa | 19183 | 5651 | 79 |
2448354 | 2448354 | 2022-04-27 | Washington | Iowa | 19183 | 5651 | 79 |
2308329 | 2308329 | 2022-03-15 | Bremer | Iowa | 19017 | 5465 | 79 |
2305078 | 2305078 | 2022-03-14 | Bremer | Iowa | 19017 | 5465 | 79 |
2301826 | 2301826 | 2022-03-13 | Bremer | Iowa | 19017 | 5465 | 79 |
2298574 | 2298574 | 2022-03-12 | Bremer | Iowa | 19017 | 5465 | 79 |
2295322 | 2295322 | 2022-03-11 | Bremer | Iowa | 19017 | 5465 | 79 |
2292070 | 2292070 | 2022-03-10 | Bremer | Iowa | 19017 | 5465 | 79 |
2288818 | 2288818 | 2022-03-09 | Bremer | Iowa | 19017 | 5465 | 79 |
2285567 | 2285567 | 2022-03-08 | Bremer | Iowa | 19017 | 5452 | 79 |
2282315 | 2282315 | 2022-03-07 | Bremer | Iowa | 19017 | 5452 | 79 |
2279062 | 2279062 | 2022-03-06 | Bremer | Iowa | 19017 | 5452 | 79 |
2275809 | 2275809 | 2022-03-05 | Bremer | Iowa | 19017 | 5452 | 79 |
2272556 | 2272556 | 2022-03-04 | Bremer | Iowa | 19017 | 5452 | 79 |
2269304 | 2269304 | 2022-03-03 | Bremer | Iowa | 19017 | 5452 | 79 |
2266051 | 2266051 | 2022-03-02 | Bremer | Iowa | 19017 | 5452 | 79 |
2262800 | 2262800 | 2022-03-01 | Bremer | Iowa | 19017 | 5442 | 79 |
2259549 | 2259549 | 2022-02-28 | Bremer | Iowa | 19017 | 5442 | 79 |
2256298 | 2256298 | 2022-02-27 | Bremer | Iowa | 19017 | 5442 | 79 |
2253047 | 2253047 | 2022-02-26 | Bremer | Iowa | 19017 | 5442 | 79 |
2249796 | 2249796 | 2022-02-25 | Bremer | Iowa | 19017 | 5442 | 79 |
2246545 | 2246545 | 2022-02-24 | Bremer | Iowa | 19017 | 5442 | 79 |
2243294 | 2243294 | 2022-02-23 | Bremer | Iowa | 19017 | 5442 | 79 |
2240043 | 2240043 | 2022-02-22 | Bremer | Iowa | 19017 | 5401 | 79 |
2240119 | 2240119 | 2022-02-22 | Story | Iowa | 19169 | 19303 | 79 |
2236792 | 2236792 | 2022-02-21 | Bremer | Iowa | 19017 | 5401 | 79 |
2236868 | 2236868 | 2022-02-21 | Story | Iowa | 19169 | 19303 | 79 |
2233541 | 2233541 | 2022-02-20 | Bremer | Iowa | 19017 | 5401 | 79 |
2233617 | 2233617 | 2022-02-20 | Story | Iowa | 19169 | 19303 | 79 |
2230290 | 2230290 | 2022-02-19 | Bremer | Iowa | 19017 | 5401 | 79 |
2230366 | 2230366 | 2022-02-19 | Story | Iowa | 19169 | 19303 | 79 |
2227039 | 2227039 | 2022-02-18 | Bremer | Iowa | 19017 | 5401 | 79 |
2227115 | 2227115 | 2022-02-18 | Story | Iowa | 19169 | 19303 | 79 |
2223788 | 2223788 | 2022-02-17 | Bremer | Iowa | 19017 | 5401 | 79 |
2223864 | 2223864 | 2022-02-17 | Story | Iowa | 19169 | 19303 | 79 |
2220537 | 2220537 | 2022-02-16 | Bremer | Iowa | 19017 | 5401 | 79 |
2220613 | 2220613 | 2022-02-16 | Story | Iowa | 19169 | 19303 | 79 |
2217286 | 2217286 | 2022-02-15 | Bremer | Iowa | 19017 | 5351 | 79 |
2214035 | 2214035 | 2022-02-14 | Bremer | Iowa | 19017 | 5351 | 79 |
2210783 | 2210783 | 2022-02-13 | Bremer | Iowa | 19017 | 5351 | 79 |
2207530 | 2207530 | 2022-02-12 | Bremer | Iowa | 19017 | 5351 | 79 |
2204277 | 2204277 | 2022-02-11 | Bremer | Iowa | 19017 | 5351 | 79 |
2201024 | 2201024 | 2022-02-10 | Bremer | Iowa | 19017 | 5351 | 79 |
2197770 | 2197770 | 2022-02-09 | Bremer | Iowa | 19017 | 5351 | 79 |
2149023 | 2149023 | 2022-01-25 | Mahaska | Iowa | 19123 | 4432 | 79 |
2145771 | 2145771 | 2022-01-24 | Mahaska | Iowa | 19123 | 4432 | 79 |
2142516 | 2142516 | 2022-01-23 | Mahaska | Iowa | 19123 | 4432 | 79 |
2139261 | 2139261 | 2022-01-22 | Mahaska | Iowa | 19123 | 4432 | 79 |
2136005 | 2136005 | 2022-01-21 | Mahaska | Iowa | 19123 | 4432 | 79 |
2132753 | 2132753 | 2022-01-20 | Mahaska | Iowa | 19123 | 4432 | 79 |
2129500 | 2129500 | 2022-01-19 | Mahaska | Iowa | 19123 | 4432 | 79 |
1989691 | 1989691 | 2021-12-07 | Harrison | Iowa | 19085 | 2411 | 79 |
1986441 | 1986441 | 2021-12-06 | Harrison | Iowa | 19085 | 2411 | 79 |
1983191 | 1983191 | 2021-12-05 | Harrison | Iowa | 19085 | 2411 | 79 |
1979941 | 1979941 | 2021-12-04 | Harrison | Iowa | 19085 | 2411 | 79 |
1976691 | 1976691 | 2021-12-03 | Harrison | Iowa | 19085 | 2411 | 79 |
1973442 | 1973442 | 2021-12-02 | Harrison | Iowa | 19085 | 2411 | 79 |
1970192 | 1970192 | 2021-12-01 | Harrison | Iowa | 19085 | 2411 | 79 |
1966942 | 1966942 | 2021-11-30 | Harrison | Iowa | 19085 | 2347 | 79 |
1963690 | 1963690 | 2021-11-29 | Harrison | Iowa | 19085 | 2347 | 79 |
1960439 | 1960439 | 2021-11-28 | Harrison | Iowa | 19085 | 2347 | 79 |
1957188 | 1957188 | 2021-11-27 | Harrison | Iowa | 19085 | 2347 | 79 |
1953937 | 1953937 | 2021-11-26 | Harrison | Iowa | 19085 | 2347 | 79 |
1950686 | 1950686 | 2021-11-25 | Harrison | Iowa | 19085 | 2347 | 79 |
1947435 | 1947435 | 2021-11-24 | Harrison | Iowa | 19085 | 2347 | 79 |
1853202 | 1853202 | 2021-10-26 | Jasper | Iowa | 19099 | 5785 | 79 |
1849953 | 1849953 | 2021-10-25 | Jasper | Iowa | 19099 | 5785 | 79 |
1846703 | 1846703 | 2021-10-24 | Jasper | Iowa | 19099 | 5785 | 79 |
1843453 | 1843453 | 2021-10-23 | Jasper | Iowa | 19099 | 5785 | 79 |
1840203 | 1840203 | 2021-10-22 | Jasper | Iowa | 19099 | 5785 | 79 |
1836954 | 1836954 | 2021-10-21 | Jasper | Iowa | 19099 | 5785 | 79 |
1833705 | 1833705 | 2021-10-20 | Jasper | Iowa | 19099 | 5785 | 79 |
1716752 | 1716752 | 2021-09-14 | Marshall | Iowa | 19127 | 5501 | 79 |
1713506 | 1713506 | 2021-09-13 | Marshall | Iowa | 19127 | 5501 | 79 |
1710259 | 1710259 | 2021-09-12 | Marshall | Iowa | 19127 | 5501 | 79 |
1707012 | 1707012 | 2021-09-11 | Marshall | Iowa | 19127 | 5501 | 79 |
1703764 | 1703764 | 2021-09-10 | Marshall | Iowa | 19127 | 5501 | 79 |
1700514 | 1700514 | 2021-09-09 | Marshall | Iowa | 19127 | 5501 | 79 |
1697265 | 1697265 | 2021-09-08 | Marshall | Iowa | 19127 | 5501 | 79 |
1694017 | 1694017 | 2021-09-07 | Marshall | Iowa | 19127 | 5370 | 79 |
1690768 | 1690768 | 2021-09-06 | Marshall | Iowa | 19127 | 5370 | 79 |
1687518 | 1687518 | 2021-09-05 | Marshall | Iowa | 19127 | 5370 | 79 |
1684268 | 1684268 | 2021-09-04 | Marshall | Iowa | 19127 | 5370 | 79 |
1681017 | 1681017 | 2021-09-03 | Marshall | Iowa | 19127 | 5370 | 79 |
1677769 | 1677769 | 2021-09-02 | Marshall | Iowa | 19127 | 5370 | 79 |
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);