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

769 rows where fips = 19079 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 · 769 ✖

fips 1

  • 19079 · 769 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500412 2500412 2022-05-13 Hamilton Iowa 19079 3481 72
2497154 2497154 2022-05-12 Hamilton Iowa 19079 3481 72
2493896 2493896 2022-05-11 Hamilton Iowa 19079 3481 72
2490638 2490638 2022-05-10 Hamilton Iowa 19079 3477 72
2487381 2487381 2022-05-09 Hamilton Iowa 19079 3477 72
2484123 2484123 2022-05-08 Hamilton Iowa 19079 3477 72
2480865 2480865 2022-05-07 Hamilton Iowa 19079 3477 72
2477607 2477607 2022-05-06 Hamilton Iowa 19079 3477 72
2474349 2474349 2022-05-05 Hamilton Iowa 19079 3477 72
2471092 2471092 2022-05-04 Hamilton Iowa 19079 3477 72
2467836 2467836 2022-05-03 Hamilton Iowa 19079 3475 72
2464581 2464581 2022-05-02 Hamilton Iowa 19079 3475 72
2461325 2461325 2022-05-01 Hamilton Iowa 19079 3475 72
2458069 2458069 2022-04-30 Hamilton Iowa 19079 3475 72
2454813 2454813 2022-04-29 Hamilton Iowa 19079 3475 72
2451557 2451557 2022-04-28 Hamilton Iowa 19079 3475 72
2448301 2448301 2022-04-27 Hamilton Iowa 19079 3475 72
2445045 2445045 2022-04-26 Hamilton Iowa 19079 3477 72
2441789 2441789 2022-04-25 Hamilton Iowa 19079 3477 72
2438533 2438533 2022-04-24 Hamilton Iowa 19079 3477 72
2435277 2435277 2022-04-23 Hamilton Iowa 19079 3477 72
2432021 2432021 2022-04-22 Hamilton Iowa 19079 3477 72
2428765 2428765 2022-04-21 Hamilton Iowa 19079 3477 72
2425509 2425509 2022-04-20 Hamilton Iowa 19079 3477 72
2422253 2422253 2022-04-19 Hamilton Iowa 19079 3481 72
2418997 2418997 2022-04-18 Hamilton Iowa 19079 3481 72
2415741 2415741 2022-04-17 Hamilton Iowa 19079 3481 72
2412485 2412485 2022-04-16 Hamilton Iowa 19079 3481 72
2409229 2409229 2022-04-15 Hamilton Iowa 19079 3481 72
2405973 2405973 2022-04-14 Hamilton Iowa 19079 3481 72
2402717 2402717 2022-04-13 Hamilton Iowa 19079 3481 72
2399463 2399463 2022-04-12 Hamilton Iowa 19079 3479 72
2396207 2396207 2022-04-11 Hamilton Iowa 19079 3479 72
2392952 2392952 2022-04-10 Hamilton Iowa 19079 3479 72
2389696 2389696 2022-04-09 Hamilton Iowa 19079 3479 72
2386440 2386440 2022-04-08 Hamilton Iowa 19079 3479 72
2383186 2383186 2022-04-07 Hamilton Iowa 19079 3479 72
2379931 2379931 2022-04-06 Hamilton Iowa 19079 3479 72
2376676 2376676 2022-04-05 Hamilton Iowa 19079 3477 72
2373424 2373424 2022-04-04 Hamilton Iowa 19079 3477 72
2370171 2370171 2022-04-03 Hamilton Iowa 19079 3477 72
2366918 2366918 2022-04-02 Hamilton Iowa 19079 3477 72
2363665 2363665 2022-04-01 Hamilton Iowa 19079 3477 72
2360411 2360411 2022-03-31 Hamilton Iowa 19079 3477 72
2357157 2357157 2022-03-30 Hamilton Iowa 19079 3477 72
2353904 2353904 2022-03-29 Hamilton Iowa 19079 3475 72
2350652 2350652 2022-03-28 Hamilton Iowa 19079 3475 72
2347399 2347399 2022-03-27 Hamilton Iowa 19079 3475 72
2344146 2344146 2022-03-26 Hamilton Iowa 19079 3475 72
2340893 2340893 2022-03-25 Hamilton Iowa 19079 3475 72
2337640 2337640 2022-03-24 Hamilton Iowa 19079 3475 72
2334386 2334386 2022-03-23 Hamilton Iowa 19079 3475 72
2331132 2331132 2022-03-22 Hamilton Iowa 19079 3472 72
2327880 2327880 2022-03-21 Hamilton Iowa 19079 3472 72
2324627 2324627 2022-03-20 Hamilton Iowa 19079 3472 72
2321373 2321373 2022-03-19 Hamilton Iowa 19079 3472 72
2318119 2318119 2022-03-18 Hamilton Iowa 19079 3472 72
2314866 2314866 2022-03-17 Hamilton Iowa 19079 3472 72
2311613 2311613 2022-03-16 Hamilton Iowa 19079 3472 72
2308360 2308360 2022-03-15 Hamilton Iowa 19079 3471 72
2305109 2305109 2022-03-14 Hamilton Iowa 19079 3471 72
2301857 2301857 2022-03-13 Hamilton Iowa 19079 3471 72
2298605 2298605 2022-03-12 Hamilton Iowa 19079 3471 72
2295353 2295353 2022-03-11 Hamilton Iowa 19079 3471 72
2292101 2292101 2022-03-10 Hamilton Iowa 19079 3471 72
2288849 2288849 2022-03-09 Hamilton Iowa 19079 3471 72
2285598 2285598 2022-03-08 Hamilton Iowa 19079 3462 70
2282346 2282346 2022-03-07 Hamilton Iowa 19079 3462 70
2279093 2279093 2022-03-06 Hamilton Iowa 19079 3462 70
2275840 2275840 2022-03-05 Hamilton Iowa 19079 3462 70
2272587 2272587 2022-03-04 Hamilton Iowa 19079 3462 70
2269335 2269335 2022-03-03 Hamilton Iowa 19079 3462 70
2266082 2266082 2022-03-02 Hamilton Iowa 19079 3462 70
2262831 2262831 2022-03-01 Hamilton Iowa 19079 3464 70
2259580 2259580 2022-02-28 Hamilton Iowa 19079 3464 70
2256329 2256329 2022-02-27 Hamilton Iowa 19079 3464 70
2253078 2253078 2022-02-26 Hamilton Iowa 19079 3464 70
2249827 2249827 2022-02-25 Hamilton Iowa 19079 3464 70
2246576 2246576 2022-02-24 Hamilton Iowa 19079 3464 70
2243325 2243325 2022-02-23 Hamilton Iowa 19079 3464 70
2240074 2240074 2022-02-22 Hamilton Iowa 19079 3421 69
2236823 2236823 2022-02-21 Hamilton Iowa 19079 3421 69
2233572 2233572 2022-02-20 Hamilton Iowa 19079 3421 69
2230321 2230321 2022-02-19 Hamilton Iowa 19079 3421 69
2227070 2227070 2022-02-18 Hamilton Iowa 19079 3421 69
2223819 2223819 2022-02-17 Hamilton Iowa 19079 3421 69
2220568 2220568 2022-02-16 Hamilton Iowa 19079 3421 69
2217317 2217317 2022-02-15 Hamilton Iowa 19079 3394 67
2214066 2214066 2022-02-14 Hamilton Iowa 19079 3394 67
2210814 2210814 2022-02-13 Hamilton Iowa 19079 3394 67
2207561 2207561 2022-02-12 Hamilton Iowa 19079 3394 67
2204308 2204308 2022-02-11 Hamilton Iowa 19079 3394 67
2201055 2201055 2022-02-10 Hamilton Iowa 19079 3394 67
2197801 2197801 2022-02-09 Hamilton Iowa 19079 3394 67
2194547 2194547 2022-02-08 Hamilton Iowa 19079 3340 66
2191293 2191293 2022-02-07 Hamilton Iowa 19079 3340 66
2188040 2188040 2022-02-06 Hamilton Iowa 19079 3340 66
2184787 2184787 2022-02-05 Hamilton Iowa 19079 3340 66
2181535 2181535 2022-02-04 Hamilton Iowa 19079 3340 66
2178284 2178284 2022-02-03 Hamilton Iowa 19079 3340 66

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