ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,190 rows where deaths = 32 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Adair 170
- Guthrie 133
- Keokuk 113
- Palo Alto 77
- Lucas 66
- Chickasaw 59
- Davis 59
- Ida 50
- Sac 42
- Union 40
- Grundy 33
- Monona 28
- Butler 18
- Marshall 18
- Monroe 18
- Shelby 16
- Jasper 15
- Mahaska 14
- Winnebago 14
- Jefferson 13
- Poweshiek 11
- Emmet 9
- Lyon 9
- Wright 9
- Buchanan 8
- Cedar 7
- Clarke 7
- Des Moines 7
- Fayette 7
- Franklin 7
- …
state 1
- Iowa · 1,190 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500391 | 2500391 | 2022-05-13 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2500398 | 2500398 | 2022-05-13 | Davis | Iowa | 19051 | 1604 | 32 |
2500431 | 2500431 | 2022-05-13 | Lucas | Iowa | 19117 | 1763 | 32 |
2497133 | 2497133 | 2022-05-12 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2497140 | 2497140 | 2022-05-12 | Davis | Iowa | 19051 | 1604 | 32 |
2497173 | 2497173 | 2022-05-12 | Lucas | Iowa | 19117 | 1763 | 32 |
2493875 | 2493875 | 2022-05-11 | Chickasaw | Iowa | 19037 | 2701 | 32 |
2493882 | 2493882 | 2022-05-11 | Davis | Iowa | 19051 | 1604 | 32 |
2493915 | 2493915 | 2022-05-11 | Lucas | Iowa | 19117 | 1763 | 32 |
2490617 | 2490617 | 2022-05-10 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2490624 | 2490624 | 2022-05-10 | Davis | Iowa | 19051 | 1602 | 32 |
2490657 | 2490657 | 2022-05-10 | Lucas | Iowa | 19117 | 1759 | 32 |
2487360 | 2487360 | 2022-05-09 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2487367 | 2487367 | 2022-05-09 | Davis | Iowa | 19051 | 1602 | 32 |
2487400 | 2487400 | 2022-05-09 | Lucas | Iowa | 19117 | 1759 | 32 |
2484102 | 2484102 | 2022-05-08 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2484109 | 2484109 | 2022-05-08 | Davis | Iowa | 19051 | 1602 | 32 |
2484142 | 2484142 | 2022-05-08 | Lucas | Iowa | 19117 | 1759 | 32 |
2480844 | 2480844 | 2022-05-07 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2480851 | 2480851 | 2022-05-07 | Davis | Iowa | 19051 | 1602 | 32 |
2480884 | 2480884 | 2022-05-07 | Lucas | Iowa | 19117 | 1759 | 32 |
2477586 | 2477586 | 2022-05-06 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2477593 | 2477593 | 2022-05-06 | Davis | Iowa | 19051 | 1602 | 32 |
2477626 | 2477626 | 2022-05-06 | Lucas | Iowa | 19117 | 1759 | 32 |
2474328 | 2474328 | 2022-05-05 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2474335 | 2474335 | 2022-05-05 | Davis | Iowa | 19051 | 1602 | 32 |
2474368 | 2474368 | 2022-05-05 | Lucas | Iowa | 19117 | 1759 | 32 |
2471071 | 2471071 | 2022-05-04 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2471078 | 2471078 | 2022-05-04 | Davis | Iowa | 19051 | 1602 | 32 |
2471111 | 2471111 | 2022-05-04 | Lucas | Iowa | 19117 | 1759 | 32 |
2467815 | 2467815 | 2022-05-03 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2467822 | 2467822 | 2022-05-03 | Davis | Iowa | 19051 | 1601 | 32 |
2467855 | 2467855 | 2022-05-03 | Lucas | Iowa | 19117 | 1755 | 32 |
2464560 | 2464560 | 2022-05-02 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2464567 | 2464567 | 2022-05-02 | Davis | Iowa | 19051 | 1601 | 32 |
2464600 | 2464600 | 2022-05-02 | Lucas | Iowa | 19117 | 1755 | 32 |
2461304 | 2461304 | 2022-05-01 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2461311 | 2461311 | 2022-05-01 | Davis | Iowa | 19051 | 1601 | 32 |
2461344 | 2461344 | 2022-05-01 | Lucas | Iowa | 19117 | 1755 | 32 |
2458048 | 2458048 | 2022-04-30 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2458055 | 2458055 | 2022-04-30 | Davis | Iowa | 19051 | 1601 | 32 |
2458088 | 2458088 | 2022-04-30 | Lucas | Iowa | 19117 | 1755 | 32 |
2454792 | 2454792 | 2022-04-29 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2454799 | 2454799 | 2022-04-29 | Davis | Iowa | 19051 | 1601 | 32 |
2454832 | 2454832 | 2022-04-29 | Lucas | Iowa | 19117 | 1755 | 32 |
2451536 | 2451536 | 2022-04-28 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2451543 | 2451543 | 2022-04-28 | Davis | Iowa | 19051 | 1601 | 32 |
2451576 | 2451576 | 2022-04-28 | Lucas | Iowa | 19117 | 1755 | 32 |
2448280 | 2448280 | 2022-04-27 | Chickasaw | Iowa | 19037 | 2687 | 32 |
2448287 | 2448287 | 2022-04-27 | Davis | Iowa | 19051 | 1601 | 32 |
2448320 | 2448320 | 2022-04-27 | Lucas | Iowa | 19117 | 1755 | 32 |
2445024 | 2445024 | 2022-04-26 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2445031 | 2445031 | 2022-04-26 | Davis | Iowa | 19051 | 1599 | 32 |
2445064 | 2445064 | 2022-04-26 | Lucas | Iowa | 19117 | 1755 | 32 |
2441768 | 2441768 | 2022-04-25 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2441775 | 2441775 | 2022-04-25 | Davis | Iowa | 19051 | 1599 | 32 |
2441808 | 2441808 | 2022-04-25 | Lucas | Iowa | 19117 | 1755 | 32 |
2438512 | 2438512 | 2022-04-24 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2438519 | 2438519 | 2022-04-24 | Davis | Iowa | 19051 | 1599 | 32 |
2438552 | 2438552 | 2022-04-24 | Lucas | Iowa | 19117 | 1755 | 32 |
2435256 | 2435256 | 2022-04-23 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2435263 | 2435263 | 2022-04-23 | Davis | Iowa | 19051 | 1599 | 32 |
2435296 | 2435296 | 2022-04-23 | Lucas | Iowa | 19117 | 1755 | 32 |
2432000 | 2432000 | 2022-04-22 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2432007 | 2432007 | 2022-04-22 | Davis | Iowa | 19051 | 1599 | 32 |
2432040 | 2432040 | 2022-04-22 | Lucas | Iowa | 19117 | 1755 | 32 |
2428744 | 2428744 | 2022-04-21 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2428751 | 2428751 | 2022-04-21 | Davis | Iowa | 19051 | 1599 | 32 |
2428784 | 2428784 | 2022-04-21 | Lucas | Iowa | 19117 | 1755 | 32 |
2425488 | 2425488 | 2022-04-20 | Chickasaw | Iowa | 19037 | 2681 | 32 |
2425495 | 2425495 | 2022-04-20 | Davis | Iowa | 19051 | 1599 | 32 |
2425528 | 2425528 | 2022-04-20 | Lucas | Iowa | 19117 | 1755 | 32 |
2422232 | 2422232 | 2022-04-19 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2422239 | 2422239 | 2022-04-19 | Davis | Iowa | 19051 | 1597 | 32 |
2422272 | 2422272 | 2022-04-19 | Lucas | Iowa | 19117 | 1754 | 32 |
2422294 | 2422294 | 2022-04-19 | Sac | Iowa | 19161 | 2401 | 32 |
2418976 | 2418976 | 2022-04-18 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2418983 | 2418983 | 2022-04-18 | Davis | Iowa | 19051 | 1597 | 32 |
2419016 | 2419016 | 2022-04-18 | Lucas | Iowa | 19117 | 1754 | 32 |
2419038 | 2419038 | 2022-04-18 | Sac | Iowa | 19161 | 2401 | 32 |
2415720 | 2415720 | 2022-04-17 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2415727 | 2415727 | 2022-04-17 | Davis | Iowa | 19051 | 1597 | 32 |
2415760 | 2415760 | 2022-04-17 | Lucas | Iowa | 19117 | 1754 | 32 |
2415782 | 2415782 | 2022-04-17 | Sac | Iowa | 19161 | 2401 | 32 |
2412464 | 2412464 | 2022-04-16 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2412471 | 2412471 | 2022-04-16 | Davis | Iowa | 19051 | 1597 | 32 |
2412504 | 2412504 | 2022-04-16 | Lucas | Iowa | 19117 | 1754 | 32 |
2412526 | 2412526 | 2022-04-16 | Sac | Iowa | 19161 | 2401 | 32 |
2409208 | 2409208 | 2022-04-15 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2409215 | 2409215 | 2022-04-15 | Davis | Iowa | 19051 | 1597 | 32 |
2409248 | 2409248 | 2022-04-15 | Lucas | Iowa | 19117 | 1754 | 32 |
2409270 | 2409270 | 2022-04-15 | Sac | Iowa | 19161 | 2401 | 32 |
2405952 | 2405952 | 2022-04-14 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2405959 | 2405959 | 2022-04-14 | Davis | Iowa | 19051 | 1597 | 32 |
2405992 | 2405992 | 2022-04-14 | Lucas | Iowa | 19117 | 1754 | 32 |
2406014 | 2406014 | 2022-04-14 | Sac | Iowa | 19161 | 2401 | 32 |
2402696 | 2402696 | 2022-04-13 | Chickasaw | Iowa | 19037 | 2679 | 32 |
2402703 | 2402703 | 2022-04-13 | Davis | Iowa | 19051 | 1597 | 32 |
2402736 | 2402736 | 2022-04-13 | Lucas | Iowa | 19117 | 1754 | 32 |
2402758 | 2402758 | 2022-04-13 | Sac | Iowa | 19161 | 2401 | 32 |
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);