ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where deaths = 48 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Story 173
- Keokuk 59
- Monona 52
- Butler 42
- Monroe 42
- Montgomery 35
- Louisa 29
- Ida 28
- Lyon 28
- Muscatine 24
- Allamakee 22
- Bremer 19
- Boone 14
- Buena Vista 14
- Hardin 14
- Mitchell 14
- Winneshiek 14
- Wright 14
- Washington 13
- Clayton 9
- Carroll 8
- Cass 8
- Jasper 8
- Jones 8
- Adair 7
- Buchanan 7
- Cherokee 7
- Crawford 7
- Fayette 7
- Floyd 7
- …
state 1
- Iowa · 767 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500426 | 2500426 | 2022-05-13 | Keokuk | Iowa | 19107 | 2085 | 48 |
2500439 | 2500439 | 2022-05-13 | Monona | Iowa | 19133 | 1723 | 48 |
2497168 | 2497168 | 2022-05-12 | Keokuk | Iowa | 19107 | 2085 | 48 |
2497181 | 2497181 | 2022-05-12 | Monona | Iowa | 19133 | 1723 | 48 |
2493910 | 2493910 | 2022-05-11 | Keokuk | Iowa | 19107 | 2085 | 48 |
2493923 | 2493923 | 2022-05-11 | Monona | Iowa | 19133 | 1723 | 48 |
2490652 | 2490652 | 2022-05-10 | Keokuk | Iowa | 19107 | 2083 | 48 |
2490665 | 2490665 | 2022-05-10 | Monona | Iowa | 19133 | 1720 | 48 |
2487395 | 2487395 | 2022-05-09 | Keokuk | Iowa | 19107 | 2083 | 48 |
2487408 | 2487408 | 2022-05-09 | Monona | Iowa | 19133 | 1720 | 48 |
2484137 | 2484137 | 2022-05-08 | Keokuk | Iowa | 19107 | 2083 | 48 |
2484150 | 2484150 | 2022-05-08 | Monona | Iowa | 19133 | 1720 | 48 |
2480879 | 2480879 | 2022-05-07 | Keokuk | Iowa | 19107 | 2083 | 48 |
2480892 | 2480892 | 2022-05-07 | Monona | Iowa | 19133 | 1720 | 48 |
2477621 | 2477621 | 2022-05-06 | Keokuk | Iowa | 19107 | 2083 | 48 |
2477634 | 2477634 | 2022-05-06 | Monona | Iowa | 19133 | 1720 | 48 |
2474363 | 2474363 | 2022-05-05 | Keokuk | Iowa | 19107 | 2083 | 48 |
2474376 | 2474376 | 2022-05-05 | Monona | Iowa | 19133 | 1720 | 48 |
2471106 | 2471106 | 2022-05-04 | Keokuk | Iowa | 19107 | 2083 | 48 |
2471119 | 2471119 | 2022-05-04 | Monona | Iowa | 19133 | 1720 | 48 |
2467850 | 2467850 | 2022-05-03 | Keokuk | Iowa | 19107 | 2080 | 48 |
2467863 | 2467863 | 2022-05-03 | Monona | Iowa | 19133 | 1721 | 48 |
2464595 | 2464595 | 2022-05-02 | Keokuk | Iowa | 19107 | 2080 | 48 |
2464608 | 2464608 | 2022-05-02 | Monona | Iowa | 19133 | 1721 | 48 |
2461339 | 2461339 | 2022-05-01 | Keokuk | Iowa | 19107 | 2080 | 48 |
2461352 | 2461352 | 2022-05-01 | Monona | Iowa | 19133 | 1721 | 48 |
2458083 | 2458083 | 2022-04-30 | Keokuk | Iowa | 19107 | 2080 | 48 |
2458096 | 2458096 | 2022-04-30 | Monona | Iowa | 19133 | 1721 | 48 |
2454827 | 2454827 | 2022-04-29 | Keokuk | Iowa | 19107 | 2080 | 48 |
2454840 | 2454840 | 2022-04-29 | Monona | Iowa | 19133 | 1721 | 48 |
2451571 | 2451571 | 2022-04-28 | Keokuk | Iowa | 19107 | 2080 | 48 |
2451584 | 2451584 | 2022-04-28 | Monona | Iowa | 19133 | 1721 | 48 |
2448315 | 2448315 | 2022-04-27 | Keokuk | Iowa | 19107 | 2080 | 48 |
2448328 | 2448328 | 2022-04-27 | Monona | Iowa | 19133 | 1721 | 48 |
2445059 | 2445059 | 2022-04-26 | Keokuk | Iowa | 19107 | 2068 | 48 |
2445072 | 2445072 | 2022-04-26 | Monona | Iowa | 19133 | 1720 | 48 |
2441803 | 2441803 | 2022-04-25 | Keokuk | Iowa | 19107 | 2068 | 48 |
2441816 | 2441816 | 2022-04-25 | Monona | Iowa | 19133 | 1720 | 48 |
2438547 | 2438547 | 2022-04-24 | Keokuk | Iowa | 19107 | 2068 | 48 |
2438560 | 2438560 | 2022-04-24 | Monona | Iowa | 19133 | 1720 | 48 |
2435291 | 2435291 | 2022-04-23 | Keokuk | Iowa | 19107 | 2068 | 48 |
2435304 | 2435304 | 2022-04-23 | Monona | Iowa | 19133 | 1720 | 48 |
2432035 | 2432035 | 2022-04-22 | Keokuk | Iowa | 19107 | 2068 | 48 |
2432048 | 2432048 | 2022-04-22 | Monona | Iowa | 19133 | 1720 | 48 |
2428779 | 2428779 | 2022-04-21 | Keokuk | Iowa | 19107 | 2068 | 48 |
2428792 | 2428792 | 2022-04-21 | Monona | Iowa | 19133 | 1720 | 48 |
2425523 | 2425523 | 2022-04-20 | Keokuk | Iowa | 19107 | 2068 | 48 |
2425536 | 2425536 | 2022-04-20 | Monona | Iowa | 19133 | 1720 | 48 |
2422267 | 2422267 | 2022-04-19 | Keokuk | Iowa | 19107 | 2070 | 48 |
2422280 | 2422280 | 2022-04-19 | Monona | Iowa | 19133 | 1719 | 48 |
2419011 | 2419011 | 2022-04-18 | Keokuk | Iowa | 19107 | 2070 | 48 |
2419024 | 2419024 | 2022-04-18 | Monona | Iowa | 19133 | 1719 | 48 |
2415755 | 2415755 | 2022-04-17 | Keokuk | Iowa | 19107 | 2070 | 48 |
2415768 | 2415768 | 2022-04-17 | Monona | Iowa | 19133 | 1719 | 48 |
2412499 | 2412499 | 2022-04-16 | Keokuk | Iowa | 19107 | 2070 | 48 |
2412512 | 2412512 | 2022-04-16 | Monona | Iowa | 19133 | 1719 | 48 |
2409243 | 2409243 | 2022-04-15 | Keokuk | Iowa | 19107 | 2070 | 48 |
2409256 | 2409256 | 2022-04-15 | Monona | Iowa | 19133 | 1719 | 48 |
2405987 | 2405987 | 2022-04-14 | Keokuk | Iowa | 19107 | 2070 | 48 |
2406000 | 2406000 | 2022-04-14 | Monona | Iowa | 19133 | 1719 | 48 |
2402731 | 2402731 | 2022-04-13 | Keokuk | Iowa | 19107 | 2070 | 48 |
2402744 | 2402744 | 2022-04-13 | Monona | Iowa | 19133 | 1719 | 48 |
2399477 | 2399477 | 2022-04-12 | Keokuk | Iowa | 19107 | 2055 | 48 |
2399490 | 2399490 | 2022-04-12 | Monona | Iowa | 19133 | 1719 | 48 |
2396221 | 2396221 | 2022-04-11 | Keokuk | Iowa | 19107 | 2055 | 48 |
2396234 | 2396234 | 2022-04-11 | Monona | Iowa | 19133 | 1719 | 48 |
2392966 | 2392966 | 2022-04-10 | Keokuk | Iowa | 19107 | 2055 | 48 |
2392979 | 2392979 | 2022-04-10 | Monona | Iowa | 19133 | 1719 | 48 |
2389710 | 2389710 | 2022-04-09 | Keokuk | Iowa | 19107 | 2055 | 48 |
2389723 | 2389723 | 2022-04-09 | Monona | Iowa | 19133 | 1719 | 48 |
2386454 | 2386454 | 2022-04-08 | Keokuk | Iowa | 19107 | 2055 | 48 |
2386467 | 2386467 | 2022-04-08 | Monona | Iowa | 19133 | 1719 | 48 |
2383200 | 2383200 | 2022-04-07 | Keokuk | Iowa | 19107 | 2055 | 48 |
2383213 | 2383213 | 2022-04-07 | Monona | Iowa | 19133 | 1719 | 48 |
2379945 | 2379945 | 2022-04-06 | Keokuk | Iowa | 19107 | 2055 | 48 |
2379958 | 2379958 | 2022-04-06 | Monona | Iowa | 19133 | 1719 | 48 |
2376683 | 2376683 | 2022-04-05 | Ida | Iowa | 19093 | 1800 | 48 |
2376690 | 2376690 | 2022-04-05 | Keokuk | Iowa | 19107 | 2048 | 48 |
2373431 | 2373431 | 2022-04-04 | Ida | Iowa | 19093 | 1800 | 48 |
2373438 | 2373438 | 2022-04-04 | Keokuk | Iowa | 19107 | 2048 | 48 |
2370178 | 2370178 | 2022-04-03 | Ida | Iowa | 19093 | 1800 | 48 |
2370185 | 2370185 | 2022-04-03 | Keokuk | Iowa | 19107 | 2048 | 48 |
2366925 | 2366925 | 2022-04-02 | Ida | Iowa | 19093 | 1800 | 48 |
2366932 | 2366932 | 2022-04-02 | Keokuk | Iowa | 19107 | 2048 | 48 |
2363672 | 2363672 | 2022-04-01 | Ida | Iowa | 19093 | 1800 | 48 |
2363679 | 2363679 | 2022-04-01 | Keokuk | Iowa | 19107 | 2048 | 48 |
2360418 | 2360418 | 2022-03-31 | Ida | Iowa | 19093 | 1800 | 48 |
2360425 | 2360425 | 2022-03-31 | Keokuk | Iowa | 19107 | 2048 | 48 |
2357164 | 2357164 | 2022-03-30 | Ida | Iowa | 19093 | 1800 | 48 |
2357171 | 2357171 | 2022-03-30 | Keokuk | Iowa | 19107 | 2048 | 48 |
2353911 | 2353911 | 2022-03-29 | Ida | Iowa | 19093 | 1799 | 48 |
2353918 | 2353918 | 2022-03-29 | Keokuk | Iowa | 19107 | 2048 | 48 |
2353932 | 2353932 | 2022-03-29 | Monroe | Iowa | 19135 | 1875 | 48 |
2353961 | 2353961 | 2022-03-29 | Winneshiek | Iowa | 19191 | 3806 | 48 |
2350659 | 2350659 | 2022-03-28 | Ida | Iowa | 19093 | 1799 | 48 |
2350666 | 2350666 | 2022-03-28 | Keokuk | Iowa | 19107 | 2048 | 48 |
2350680 | 2350680 | 2022-03-28 | Monroe | Iowa | 19135 | 1875 | 48 |
2350709 | 2350709 | 2022-03-28 | Winneshiek | Iowa | 19191 | 3806 | 48 |
2347406 | 2347406 | 2022-03-27 | Ida | Iowa | 19093 | 1799 | 48 |
2347413 | 2347413 | 2022-03-27 | Keokuk | Iowa | 19107 | 2048 | 48 |
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);