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

782 rows where county = "Hancock" 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 · 782 ✖

fips 1

county 1

  • Hancock · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500413 2500413 2022-05-13 Hancock Iowa 19081 2867 47
2497155 2497155 2022-05-12 Hancock Iowa 19081 2867 47
2493897 2493897 2022-05-11 Hancock Iowa 19081 2867 47
2490639 2490639 2022-05-10 Hancock Iowa 19081 2848 47
2487382 2487382 2022-05-09 Hancock Iowa 19081 2848 47
2484124 2484124 2022-05-08 Hancock Iowa 19081 2848 47
2480866 2480866 2022-05-07 Hancock Iowa 19081 2848 47
2477608 2477608 2022-05-06 Hancock Iowa 19081 2848 47
2474350 2474350 2022-05-05 Hancock Iowa 19081 2848 47
2471093 2471093 2022-05-04 Hancock Iowa 19081 2848 47
2467837 2467837 2022-05-03 Hancock Iowa 19081 2842 47
2464582 2464582 2022-05-02 Hancock Iowa 19081 2842 47
2461326 2461326 2022-05-01 Hancock Iowa 19081 2842 47
2458070 2458070 2022-04-30 Hancock Iowa 19081 2842 47
2454814 2454814 2022-04-29 Hancock Iowa 19081 2842 47
2451558 2451558 2022-04-28 Hancock Iowa 19081 2842 47
2448302 2448302 2022-04-27 Hancock Iowa 19081 2842 47
2445046 2445046 2022-04-26 Hancock Iowa 19081 2840 47
2441790 2441790 2022-04-25 Hancock Iowa 19081 2840 47
2438534 2438534 2022-04-24 Hancock Iowa 19081 2840 47
2435278 2435278 2022-04-23 Hancock Iowa 19081 2840 47
2432022 2432022 2022-04-22 Hancock Iowa 19081 2840 47
2428766 2428766 2022-04-21 Hancock Iowa 19081 2840 47
2425510 2425510 2022-04-20 Hancock Iowa 19081 2840 47
2422254 2422254 2022-04-19 Hancock Iowa 19081 2841 47
2418998 2418998 2022-04-18 Hancock Iowa 19081 2841 47
2415742 2415742 2022-04-17 Hancock Iowa 19081 2841 47
2412486 2412486 2022-04-16 Hancock Iowa 19081 2841 47
2409230 2409230 2022-04-15 Hancock Iowa 19081 2841 47
2405974 2405974 2022-04-14 Hancock Iowa 19081 2841 47
2402718 2402718 2022-04-13 Hancock Iowa 19081 2841 47
2399464 2399464 2022-04-12 Hancock Iowa 19081 2838 47
2396208 2396208 2022-04-11 Hancock Iowa 19081 2838 47
2392953 2392953 2022-04-10 Hancock Iowa 19081 2838 47
2389697 2389697 2022-04-09 Hancock Iowa 19081 2838 47
2386441 2386441 2022-04-08 Hancock Iowa 19081 2838 47
2383187 2383187 2022-04-07 Hancock Iowa 19081 2838 47
2379932 2379932 2022-04-06 Hancock Iowa 19081 2838 47
2376677 2376677 2022-04-05 Hancock Iowa 19081 2835 47
2373425 2373425 2022-04-04 Hancock Iowa 19081 2835 47
2370172 2370172 2022-04-03 Hancock Iowa 19081 2835 47
2366919 2366919 2022-04-02 Hancock Iowa 19081 2835 47
2363666 2363666 2022-04-01 Hancock Iowa 19081 2835 47
2360412 2360412 2022-03-31 Hancock Iowa 19081 2835 47
2357158 2357158 2022-03-30 Hancock Iowa 19081 2835 47
2353905 2353905 2022-03-29 Hancock Iowa 19081 2835 47
2350653 2350653 2022-03-28 Hancock Iowa 19081 2835 47
2347400 2347400 2022-03-27 Hancock Iowa 19081 2835 47
2344147 2344147 2022-03-26 Hancock Iowa 19081 2835 47
2340894 2340894 2022-03-25 Hancock Iowa 19081 2835 47
2337641 2337641 2022-03-24 Hancock Iowa 19081 2835 47
2334387 2334387 2022-03-23 Hancock Iowa 19081 2835 47
2331133 2331133 2022-03-22 Hancock Iowa 19081 2832 47
2327881 2327881 2022-03-21 Hancock Iowa 19081 2832 47
2324628 2324628 2022-03-20 Hancock Iowa 19081 2832 47
2321374 2321374 2022-03-19 Hancock Iowa 19081 2832 47
2318120 2318120 2022-03-18 Hancock Iowa 19081 2832 47
2314867 2314867 2022-03-17 Hancock Iowa 19081 2832 47
2311614 2311614 2022-03-16 Hancock Iowa 19081 2832 47
2308361 2308361 2022-03-15 Hancock Iowa 19081 2830 46
2305110 2305110 2022-03-14 Hancock Iowa 19081 2830 46
2301858 2301858 2022-03-13 Hancock Iowa 19081 2830 46
2298606 2298606 2022-03-12 Hancock Iowa 19081 2830 46
2295354 2295354 2022-03-11 Hancock Iowa 19081 2830 46
2292102 2292102 2022-03-10 Hancock Iowa 19081 2830 46
2288850 2288850 2022-03-09 Hancock Iowa 19081 2830 46
2285599 2285599 2022-03-08 Hancock Iowa 19081 2822 46
2282347 2282347 2022-03-07 Hancock Iowa 19081 2822 46
2279094 2279094 2022-03-06 Hancock Iowa 19081 2822 46
2275841 2275841 2022-03-05 Hancock Iowa 19081 2822 46
2272588 2272588 2022-03-04 Hancock Iowa 19081 2822 46
2269336 2269336 2022-03-03 Hancock Iowa 19081 2822 46
2266083 2266083 2022-03-02 Hancock Iowa 19081 2822 46
2262832 2262832 2022-03-01 Hancock Iowa 19081 2812 46
2259581 2259581 2022-02-28 Hancock Iowa 19081 2812 46
2256330 2256330 2022-02-27 Hancock Iowa 19081 2812 46
2253079 2253079 2022-02-26 Hancock Iowa 19081 2812 46
2249828 2249828 2022-02-25 Hancock Iowa 19081 2812 46
2246577 2246577 2022-02-24 Hancock Iowa 19081 2812 46
2243326 2243326 2022-02-23 Hancock Iowa 19081 2812 46
2240075 2240075 2022-02-22 Hancock Iowa 19081 2795 45
2236824 2236824 2022-02-21 Hancock Iowa 19081 2795 45
2233573 2233573 2022-02-20 Hancock Iowa 19081 2795 45
2230322 2230322 2022-02-19 Hancock Iowa 19081 2795 45
2227071 2227071 2022-02-18 Hancock Iowa 19081 2795 45
2223820 2223820 2022-02-17 Hancock Iowa 19081 2795 45
2220569 2220569 2022-02-16 Hancock Iowa 19081 2795 45
2217318 2217318 2022-02-15 Hancock Iowa 19081 2757 45
2214067 2214067 2022-02-14 Hancock Iowa 19081 2757 45
2210815 2210815 2022-02-13 Hancock Iowa 19081 2757 45
2207562 2207562 2022-02-12 Hancock Iowa 19081 2757 45
2204309 2204309 2022-02-11 Hancock Iowa 19081 2757 45
2201056 2201056 2022-02-10 Hancock Iowa 19081 2757 45
2197802 2197802 2022-02-09 Hancock Iowa 19081 2757 45
2194548 2194548 2022-02-08 Hancock Iowa 19081 2700 45
2191294 2191294 2022-02-07 Hancock Iowa 19081 2700 45
2188041 2188041 2022-02-06 Hancock Iowa 19081 2700 45
2184788 2184788 2022-02-05 Hancock Iowa 19081 2700 45
2181536 2181536 2022-02-04 Hancock Iowa 19081 2700 45
2178285 2178285 2022-02-03 Hancock Iowa 19081 2700 45

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