ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

783 rows where county = "Poweshiek" and state = "Iowa" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Iowa · 783 ✖

fips 1

county 1

  • Poweshiek · 783 ✖
Link rowid date ▲ county state fips cases deaths
2500451 2500451 2022-05-13 Poweshiek Iowa 19157 3728 61
2497193 2497193 2022-05-12 Poweshiek Iowa 19157 3728 61
2493935 2493935 2022-05-11 Poweshiek Iowa 19157 3728 61
2490677 2490677 2022-05-10 Poweshiek Iowa 19157 3679 61
2487420 2487420 2022-05-09 Poweshiek Iowa 19157 3679 61
2484162 2484162 2022-05-08 Poweshiek Iowa 19157 3679 61
2480904 2480904 2022-05-07 Poweshiek Iowa 19157 3679 61
2477646 2477646 2022-05-06 Poweshiek Iowa 19157 3679 61
2474388 2474388 2022-05-05 Poweshiek Iowa 19157 3679 61
2471131 2471131 2022-05-04 Poweshiek Iowa 19157 3679 61
2467875 2467875 2022-05-03 Poweshiek Iowa 19157 3663 61
2464620 2464620 2022-05-02 Poweshiek Iowa 19157 3663 61
2461364 2461364 2022-05-01 Poweshiek Iowa 19157 3663 61
2458108 2458108 2022-04-30 Poweshiek Iowa 19157 3663 61
2454852 2454852 2022-04-29 Poweshiek Iowa 19157 3663 61
2451596 2451596 2022-04-28 Poweshiek Iowa 19157 3663 61
2448340 2448340 2022-04-27 Poweshiek Iowa 19157 3663 61
2445084 2445084 2022-04-26 Poweshiek Iowa 19157 3622 61
2441828 2441828 2022-04-25 Poweshiek Iowa 19157 3622 61
2438572 2438572 2022-04-24 Poweshiek Iowa 19157 3622 61
2435316 2435316 2022-04-23 Poweshiek Iowa 19157 3622 61
2432060 2432060 2022-04-22 Poweshiek Iowa 19157 3622 61
2428804 2428804 2022-04-21 Poweshiek Iowa 19157 3622 61
2425548 2425548 2022-04-20 Poweshiek Iowa 19157 3622 61
2422292 2422292 2022-04-19 Poweshiek Iowa 19157 3604 61
2419036 2419036 2022-04-18 Poweshiek Iowa 19157 3604 61
2415780 2415780 2022-04-17 Poweshiek Iowa 19157 3604 61
2412524 2412524 2022-04-16 Poweshiek Iowa 19157 3604 61
2409268 2409268 2022-04-15 Poweshiek Iowa 19157 3604 61
2406012 2406012 2022-04-14 Poweshiek Iowa 19157 3604 61
2402756 2402756 2022-04-13 Poweshiek Iowa 19157 3604 61
2399502 2399502 2022-04-12 Poweshiek Iowa 19157 3601 61
2396246 2396246 2022-04-11 Poweshiek Iowa 19157 3601 61
2392991 2392991 2022-04-10 Poweshiek Iowa 19157 3601 61
2389735 2389735 2022-04-09 Poweshiek Iowa 19157 3601 61
2386479 2386479 2022-04-08 Poweshiek Iowa 19157 3601 61
2383225 2383225 2022-04-07 Poweshiek Iowa 19157 3601 61
2379970 2379970 2022-04-06 Poweshiek Iowa 19157 3601 61
2376715 2376715 2022-04-05 Poweshiek Iowa 19157 3599 61
2373463 2373463 2022-04-04 Poweshiek Iowa 19157 3599 61
2370210 2370210 2022-04-03 Poweshiek Iowa 19157 3599 61
2366957 2366957 2022-04-02 Poweshiek Iowa 19157 3599 61
2363704 2363704 2022-04-01 Poweshiek Iowa 19157 3599 61
2360450 2360450 2022-03-31 Poweshiek Iowa 19157 3599 61
2357196 2357196 2022-03-30 Poweshiek Iowa 19157 3599 61
2353943 2353943 2022-03-29 Poweshiek Iowa 19157 3594 61
2350691 2350691 2022-03-28 Poweshiek Iowa 19157 3594 61
2347438 2347438 2022-03-27 Poweshiek Iowa 19157 3594 61
2344185 2344185 2022-03-26 Poweshiek Iowa 19157 3594 61
2340932 2340932 2022-03-25 Poweshiek Iowa 19157 3594 61
2337679 2337679 2022-03-24 Poweshiek Iowa 19157 3594 61
2334425 2334425 2022-03-23 Poweshiek Iowa 19157 3594 61
2331171 2331171 2022-03-22 Poweshiek Iowa 19157 3568 60
2327919 2327919 2022-03-21 Poweshiek Iowa 19157 3568 60
2324666 2324666 2022-03-20 Poweshiek Iowa 19157 3568 60
2321412 2321412 2022-03-19 Poweshiek Iowa 19157 3568 60
2318158 2318158 2022-03-18 Poweshiek Iowa 19157 3568 60
2314905 2314905 2022-03-17 Poweshiek Iowa 19157 3568 60
2311652 2311652 2022-03-16 Poweshiek Iowa 19157 3568 60
2308399 2308399 2022-03-15 Poweshiek Iowa 19157 3558 60
2305148 2305148 2022-03-14 Poweshiek Iowa 19157 3558 60
2301896 2301896 2022-03-13 Poweshiek Iowa 19157 3558 60
2298644 2298644 2022-03-12 Poweshiek Iowa 19157 3558 60
2295392 2295392 2022-03-11 Poweshiek Iowa 19157 3558 60
2292140 2292140 2022-03-10 Poweshiek Iowa 19157 3558 60
2288888 2288888 2022-03-09 Poweshiek Iowa 19157 3558 60
2285637 2285637 2022-03-08 Poweshiek Iowa 19157 3551 60
2282385 2282385 2022-03-07 Poweshiek Iowa 19157 3551 60
2279132 2279132 2022-03-06 Poweshiek Iowa 19157 3551 60
2275879 2275879 2022-03-05 Poweshiek Iowa 19157 3551 60
2272626 2272626 2022-03-04 Poweshiek Iowa 19157 3551 60
2269374 2269374 2022-03-03 Poweshiek Iowa 19157 3551 60
2266121 2266121 2022-03-02 Poweshiek Iowa 19157 3551 60
2262870 2262870 2022-03-01 Poweshiek Iowa 19157 3525 60
2259619 2259619 2022-02-28 Poweshiek Iowa 19157 3525 60
2256368 2256368 2022-02-27 Poweshiek Iowa 19157 3525 60
2253117 2253117 2022-02-26 Poweshiek Iowa 19157 3525 60
2249866 2249866 2022-02-25 Poweshiek Iowa 19157 3525 60
2246615 2246615 2022-02-24 Poweshiek Iowa 19157 3525 60
2243364 2243364 2022-02-23 Poweshiek Iowa 19157 3525 60
2240113 2240113 2022-02-22 Poweshiek Iowa 19157 3500 56
2236862 2236862 2022-02-21 Poweshiek Iowa 19157 3500 56
2233611 2233611 2022-02-20 Poweshiek Iowa 19157 3500 56
2230360 2230360 2022-02-19 Poweshiek Iowa 19157 3500 56
2227109 2227109 2022-02-18 Poweshiek Iowa 19157 3500 56
2223858 2223858 2022-02-17 Poweshiek Iowa 19157 3500 56
2220607 2220607 2022-02-16 Poweshiek Iowa 19157 3500 56
2217356 2217356 2022-02-15 Poweshiek Iowa 19157 3449 55
2214105 2214105 2022-02-14 Poweshiek Iowa 19157 3449 55
2210853 2210853 2022-02-13 Poweshiek Iowa 19157 3449 55
2207600 2207600 2022-02-12 Poweshiek Iowa 19157 3449 55
2204347 2204347 2022-02-11 Poweshiek Iowa 19157 3449 55
2201094 2201094 2022-02-10 Poweshiek Iowa 19157 3449 55
2197840 2197840 2022-02-09 Poweshiek Iowa 19157 3449 55
2194586 2194586 2022-02-08 Poweshiek Iowa 19157 3374 54
2191332 2191332 2022-02-07 Poweshiek Iowa 19157 3374 54
2188079 2188079 2022-02-06 Poweshiek Iowa 19157 3374 54
2184826 2184826 2022-02-05 Poweshiek Iowa 19157 3374 54
2181574 2181574 2022-02-04 Poweshiek Iowa 19157 3374 54
2178323 2178323 2022-02-03 Poweshiek Iowa 19157 3374 54

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);