ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
333 rows where deaths = 59 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Allamakee 77
- Clayton 21
- Floyd 21
- Jones 21
- Lee 21
- Appanoose 14
- Benton 14
- Cass 14
- Story 14
- Tama 10
- Jasper 9
- Cerro Gordo 7
- Fayette 7
- Hamilton 7
- Hardin 7
- Jackson 7
- Mahaska 7
- Washington 7
- O'Brien 6
- Black Hawk 5
- Harrison 5
- Marion 4
- Marshall 4
- Muscatine 4
- Bremer 3
- Dallas 3
- Warren 3
- Woodbury 3
- Des Moines 2
- Dubuque 2
- …
state 1
- Iowa · 333 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445008 | 2445008 | 2022-04-26 | Allamakee | Iowa | 19005 | 2869 | 59 |
2441752 | 2441752 | 2022-04-25 | Allamakee | Iowa | 19005 | 2869 | 59 |
2438496 | 2438496 | 2022-04-24 | Allamakee | Iowa | 19005 | 2869 | 59 |
2435240 | 2435240 | 2022-04-23 | Allamakee | Iowa | 19005 | 2869 | 59 |
2431984 | 2431984 | 2022-04-22 | Allamakee | Iowa | 19005 | 2869 | 59 |
2428728 | 2428728 | 2022-04-21 | Allamakee | Iowa | 19005 | 2869 | 59 |
2425472 | 2425472 | 2022-04-20 | Allamakee | Iowa | 19005 | 2869 | 59 |
2422216 | 2422216 | 2022-04-19 | Allamakee | Iowa | 19005 | 2868 | 59 |
2418960 | 2418960 | 2022-04-18 | Allamakee | Iowa | 19005 | 2868 | 59 |
2415704 | 2415704 | 2022-04-17 | Allamakee | Iowa | 19005 | 2868 | 59 |
2412448 | 2412448 | 2022-04-16 | Allamakee | Iowa | 19005 | 2868 | 59 |
2409192 | 2409192 | 2022-04-15 | Allamakee | Iowa | 19005 | 2868 | 59 |
2405936 | 2405936 | 2022-04-14 | Allamakee | Iowa | 19005 | 2868 | 59 |
2402680 | 2402680 | 2022-04-13 | Allamakee | Iowa | 19005 | 2868 | 59 |
2399426 | 2399426 | 2022-04-12 | Allamakee | Iowa | 19005 | 2866 | 59 |
2396170 | 2396170 | 2022-04-11 | Allamakee | Iowa | 19005 | 2866 | 59 |
2392915 | 2392915 | 2022-04-10 | Allamakee | Iowa | 19005 | 2866 | 59 |
2389659 | 2389659 | 2022-04-09 | Allamakee | Iowa | 19005 | 2866 | 59 |
2386403 | 2386403 | 2022-04-08 | Allamakee | Iowa | 19005 | 2866 | 59 |
2383149 | 2383149 | 2022-04-07 | Allamakee | Iowa | 19005 | 2866 | 59 |
2379894 | 2379894 | 2022-04-06 | Allamakee | Iowa | 19005 | 2866 | 59 |
2376639 | 2376639 | 2022-04-05 | Allamakee | Iowa | 19005 | 2861 | 59 |
2373387 | 2373387 | 2022-04-04 | Allamakee | Iowa | 19005 | 2861 | 59 |
2370134 | 2370134 | 2022-04-03 | Allamakee | Iowa | 19005 | 2861 | 59 |
2366881 | 2366881 | 2022-04-02 | Allamakee | Iowa | 19005 | 2861 | 59 |
2363628 | 2363628 | 2022-04-01 | Allamakee | Iowa | 19005 | 2861 | 59 |
2360374 | 2360374 | 2022-03-31 | Allamakee | Iowa | 19005 | 2861 | 59 |
2357120 | 2357120 | 2022-03-30 | Allamakee | Iowa | 19005 | 2861 | 59 |
2353867 | 2353867 | 2022-03-29 | Allamakee | Iowa | 19005 | 2853 | 59 |
2350615 | 2350615 | 2022-03-28 | Allamakee | Iowa | 19005 | 2853 | 59 |
2347362 | 2347362 | 2022-03-27 | Allamakee | Iowa | 19005 | 2853 | 59 |
2344109 | 2344109 | 2022-03-26 | Allamakee | Iowa | 19005 | 2853 | 59 |
2340856 | 2340856 | 2022-03-25 | Allamakee | Iowa | 19005 | 2853 | 59 |
2337603 | 2337603 | 2022-03-24 | Allamakee | Iowa | 19005 | 2853 | 59 |
2334349 | 2334349 | 2022-03-23 | Allamakee | Iowa | 19005 | 2853 | 59 |
2331095 | 2331095 | 2022-03-22 | Allamakee | Iowa | 19005 | 2850 | 59 |
2327843 | 2327843 | 2022-03-21 | Allamakee | Iowa | 19005 | 2850 | 59 |
2324590 | 2324590 | 2022-03-20 | Allamakee | Iowa | 19005 | 2850 | 59 |
2321336 | 2321336 | 2022-03-19 | Allamakee | Iowa | 19005 | 2850 | 59 |
2318082 | 2318082 | 2022-03-18 | Allamakee | Iowa | 19005 | 2850 | 59 |
2314829 | 2314829 | 2022-03-17 | Allamakee | Iowa | 19005 | 2850 | 59 |
2311576 | 2311576 | 2022-03-16 | Allamakee | Iowa | 19005 | 2850 | 59 |
2308323 | 2308323 | 2022-03-15 | Allamakee | Iowa | 19005 | 2846 | 59 |
2308362 | 2308362 | 2022-03-15 | Hardin | Iowa | 19083 | 4105 | 59 |
2305072 | 2305072 | 2022-03-14 | Allamakee | Iowa | 19005 | 2846 | 59 |
2305111 | 2305111 | 2022-03-14 | Hardin | Iowa | 19083 | 4105 | 59 |
2301820 | 2301820 | 2022-03-13 | Allamakee | Iowa | 19005 | 2846 | 59 |
2301859 | 2301859 | 2022-03-13 | Hardin | Iowa | 19083 | 4105 | 59 |
2298568 | 2298568 | 2022-03-12 | Allamakee | Iowa | 19005 | 2846 | 59 |
2298607 | 2298607 | 2022-03-12 | Hardin | Iowa | 19083 | 4105 | 59 |
2295316 | 2295316 | 2022-03-11 | Allamakee | Iowa | 19005 | 2846 | 59 |
2295355 | 2295355 | 2022-03-11 | Hardin | Iowa | 19083 | 4105 | 59 |
2292064 | 2292064 | 2022-03-10 | Allamakee | Iowa | 19005 | 2846 | 59 |
2292103 | 2292103 | 2022-03-10 | Hardin | Iowa | 19083 | 4105 | 59 |
2288812 | 2288812 | 2022-03-09 | Allamakee | Iowa | 19005 | 2846 | 59 |
2288851 | 2288851 | 2022-03-09 | Hardin | Iowa | 19083 | 4105 | 59 |
2285561 | 2285561 | 2022-03-08 | Allamakee | Iowa | 19005 | 2843 | 59 |
2282309 | 2282309 | 2022-03-07 | Allamakee | Iowa | 19005 | 2843 | 59 |
2279056 | 2279056 | 2022-03-06 | Allamakee | Iowa | 19005 | 2843 | 59 |
2275803 | 2275803 | 2022-03-05 | Allamakee | Iowa | 19005 | 2843 | 59 |
2272550 | 2272550 | 2022-03-04 | Allamakee | Iowa | 19005 | 2843 | 59 |
2269298 | 2269298 | 2022-03-03 | Allamakee | Iowa | 19005 | 2843 | 59 |
2266045 | 2266045 | 2022-03-02 | Allamakee | Iowa | 19005 | 2843 | 59 |
2262794 | 2262794 | 2022-03-01 | Allamakee | Iowa | 19005 | 2831 | 59 |
2259543 | 2259543 | 2022-02-28 | Allamakee | Iowa | 19005 | 2831 | 59 |
2256292 | 2256292 | 2022-02-27 | Allamakee | Iowa | 19005 | 2831 | 59 |
2253041 | 2253041 | 2022-02-26 | Allamakee | Iowa | 19005 | 2831 | 59 |
2249790 | 2249790 | 2022-02-25 | Allamakee | Iowa | 19005 | 2831 | 59 |
2246539 | 2246539 | 2022-02-24 | Allamakee | Iowa | 19005 | 2831 | 59 |
2243288 | 2243288 | 2022-02-23 | Allamakee | Iowa | 19005 | 2831 | 59 |
2240037 | 2240037 | 2022-02-22 | Allamakee | Iowa | 19005 | 2809 | 59 |
2236786 | 2236786 | 2022-02-21 | Allamakee | Iowa | 19005 | 2809 | 59 |
2233535 | 2233535 | 2022-02-20 | Allamakee | Iowa | 19005 | 2809 | 59 |
2230284 | 2230284 | 2022-02-19 | Allamakee | Iowa | 19005 | 2809 | 59 |
2227033 | 2227033 | 2022-02-18 | Allamakee | Iowa | 19005 | 2809 | 59 |
2223782 | 2223782 | 2022-02-17 | Allamakee | Iowa | 19005 | 2809 | 59 |
2220531 | 2220531 | 2022-02-16 | Allamakee | Iowa | 19005 | 2809 | 59 |
2217280 | 2217280 | 2022-02-15 | Allamakee | Iowa | 19005 | 2779 | 59 |
2217311 | 2217311 | 2022-02-15 | Floyd | Iowa | 19067 | 3446 | 59 |
2214029 | 2214029 | 2022-02-14 | Allamakee | Iowa | 19005 | 2779 | 59 |
2214060 | 2214060 | 2022-02-14 | Floyd | Iowa | 19067 | 3446 | 59 |
2210777 | 2210777 | 2022-02-13 | Allamakee | Iowa | 19005 | 2779 | 59 |
2210808 | 2210808 | 2022-02-13 | Floyd | Iowa | 19067 | 3446 | 59 |
2207524 | 2207524 | 2022-02-12 | Allamakee | Iowa | 19005 | 2779 | 59 |
2207555 | 2207555 | 2022-02-12 | Floyd | Iowa | 19067 | 3446 | 59 |
2204271 | 2204271 | 2022-02-11 | Allamakee | Iowa | 19005 | 2779 | 59 |
2204302 | 2204302 | 2022-02-11 | Floyd | Iowa | 19067 | 3446 | 59 |
2201018 | 2201018 | 2022-02-10 | Allamakee | Iowa | 19005 | 2779 | 59 |
2201049 | 2201049 | 2022-02-10 | Floyd | Iowa | 19067 | 3446 | 59 |
2197764 | 2197764 | 2022-02-09 | Allamakee | Iowa | 19005 | 2779 | 59 |
2197795 | 2197795 | 2022-02-09 | Floyd | Iowa | 19067 | 3446 | 59 |
2194541 | 2194541 | 2022-02-08 | Floyd | Iowa | 19067 | 3385 | 59 |
2191287 | 2191287 | 2022-02-07 | Floyd | Iowa | 19067 | 3385 | 59 |
2188034 | 2188034 | 2022-02-06 | Floyd | Iowa | 19067 | 3385 | 59 |
2184781 | 2184781 | 2022-02-05 | Floyd | Iowa | 19067 | 3385 | 59 |
2181529 | 2181529 | 2022-02-04 | Floyd | Iowa | 19067 | 3385 | 59 |
2178278 | 2178278 | 2022-02-03 | Floyd | Iowa | 19067 | 3385 | 59 |
2175025 | 2175025 | 2022-02-02 | Floyd | Iowa | 19067 | 3385 | 59 |
2171772 | 2171772 | 2022-02-01 | Floyd | Iowa | 19067 | 3294 | 59 |
2168519 | 2168519 | 2022-01-31 | Floyd | Iowa | 19067 | 3294 | 59 |
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);