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

753 rows where county = "Humboldt" and fips = 19091 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 19091 · 753 ✖

county 1

  • Humboldt · 753 ✖
Link rowid date ▲ county state fips cases deaths
2500418 2500418 2022-05-13 Humboldt Iowa 19091 2635 38
2497160 2497160 2022-05-12 Humboldt Iowa 19091 2635 38
2493902 2493902 2022-05-11 Humboldt Iowa 19091 2635 38
2490644 2490644 2022-05-10 Humboldt Iowa 19091 2627 38
2487387 2487387 2022-05-09 Humboldt Iowa 19091 2627 38
2484129 2484129 2022-05-08 Humboldt Iowa 19091 2627 38
2480871 2480871 2022-05-07 Humboldt Iowa 19091 2627 38
2477613 2477613 2022-05-06 Humboldt Iowa 19091 2627 38
2474355 2474355 2022-05-05 Humboldt Iowa 19091 2627 38
2471098 2471098 2022-05-04 Humboldt Iowa 19091 2627 38
2467842 2467842 2022-05-03 Humboldt Iowa 19091 2622 38
2464587 2464587 2022-05-02 Humboldt Iowa 19091 2622 38
2461331 2461331 2022-05-01 Humboldt Iowa 19091 2622 38
2458075 2458075 2022-04-30 Humboldt Iowa 19091 2622 38
2454819 2454819 2022-04-29 Humboldt Iowa 19091 2622 38
2451563 2451563 2022-04-28 Humboldt Iowa 19091 2622 38
2448307 2448307 2022-04-27 Humboldt Iowa 19091 2622 38
2445051 2445051 2022-04-26 Humboldt Iowa 19091 2609 38
2441795 2441795 2022-04-25 Humboldt Iowa 19091 2609 38
2438539 2438539 2022-04-24 Humboldt Iowa 19091 2609 38
2435283 2435283 2022-04-23 Humboldt Iowa 19091 2609 38
2432027 2432027 2022-04-22 Humboldt Iowa 19091 2609 38
2428771 2428771 2022-04-21 Humboldt Iowa 19091 2609 38
2425515 2425515 2022-04-20 Humboldt Iowa 19091 2609 38
2422259 2422259 2022-04-19 Humboldt Iowa 19091 2610 38
2419003 2419003 2022-04-18 Humboldt Iowa 19091 2610 38
2415747 2415747 2022-04-17 Humboldt Iowa 19091 2610 38
2412491 2412491 2022-04-16 Humboldt Iowa 19091 2610 38
2409235 2409235 2022-04-15 Humboldt Iowa 19091 2610 38
2405979 2405979 2022-04-14 Humboldt Iowa 19091 2610 38
2402723 2402723 2022-04-13 Humboldt Iowa 19091 2610 38
2399469 2399469 2022-04-12 Humboldt Iowa 19091 2610 38
2396213 2396213 2022-04-11 Humboldt Iowa 19091 2610 38
2392958 2392958 2022-04-10 Humboldt Iowa 19091 2610 38
2389702 2389702 2022-04-09 Humboldt Iowa 19091 2610 38
2386446 2386446 2022-04-08 Humboldt Iowa 19091 2610 38
2383192 2383192 2022-04-07 Humboldt Iowa 19091 2610 38
2379937 2379937 2022-04-06 Humboldt Iowa 19091 2610 38
2376682 2376682 2022-04-05 Humboldt Iowa 19091 2610 38
2373430 2373430 2022-04-04 Humboldt Iowa 19091 2610 38
2370177 2370177 2022-04-03 Humboldt Iowa 19091 2610 38
2366924 2366924 2022-04-02 Humboldt Iowa 19091 2610 38
2363671 2363671 2022-04-01 Humboldt Iowa 19091 2610 38
2360417 2360417 2022-03-31 Humboldt Iowa 19091 2610 38
2357163 2357163 2022-03-30 Humboldt Iowa 19091 2610 38
2353910 2353910 2022-03-29 Humboldt Iowa 19091 2610 37
2350658 2350658 2022-03-28 Humboldt Iowa 19091 2610 37
2347405 2347405 2022-03-27 Humboldt Iowa 19091 2610 37
2344152 2344152 2022-03-26 Humboldt Iowa 19091 2610 37
2340899 2340899 2022-03-25 Humboldt Iowa 19091 2610 37
2337646 2337646 2022-03-24 Humboldt Iowa 19091 2610 37
2334392 2334392 2022-03-23 Humboldt Iowa 19091 2610 37
2331138 2331138 2022-03-22 Humboldt Iowa 19091 2609 37
2327886 2327886 2022-03-21 Humboldt Iowa 19091 2609 37
2324633 2324633 2022-03-20 Humboldt Iowa 19091 2609 37
2321379 2321379 2022-03-19 Humboldt Iowa 19091 2609 37
2318125 2318125 2022-03-18 Humboldt Iowa 19091 2609 37
2314872 2314872 2022-03-17 Humboldt Iowa 19091 2609 37
2311619 2311619 2022-03-16 Humboldt Iowa 19091 2609 37
2308366 2308366 2022-03-15 Humboldt Iowa 19091 2609 37
2305115 2305115 2022-03-14 Humboldt Iowa 19091 2609 37
2301863 2301863 2022-03-13 Humboldt Iowa 19091 2609 37
2298611 2298611 2022-03-12 Humboldt Iowa 19091 2609 37
2295359 2295359 2022-03-11 Humboldt Iowa 19091 2609 37
2292107 2292107 2022-03-10 Humboldt Iowa 19091 2609 37
2288855 2288855 2022-03-09 Humboldt Iowa 19091 2609 37
2285604 2285604 2022-03-08 Humboldt Iowa 19091 2601 37
2282352 2282352 2022-03-07 Humboldt Iowa 19091 2601 37
2279099 2279099 2022-03-06 Humboldt Iowa 19091 2601 37
2275846 2275846 2022-03-05 Humboldt Iowa 19091 2601 37
2272593 2272593 2022-03-04 Humboldt Iowa 19091 2601 37
2269341 2269341 2022-03-03 Humboldt Iowa 19091 2601 37
2266088 2266088 2022-03-02 Humboldt Iowa 19091 2601 37
2262837 2262837 2022-03-01 Humboldt Iowa 19091 2599 37
2259586 2259586 2022-02-28 Humboldt Iowa 19091 2599 37
2256335 2256335 2022-02-27 Humboldt Iowa 19091 2599 37
2253084 2253084 2022-02-26 Humboldt Iowa 19091 2599 37
2249833 2249833 2022-02-25 Humboldt Iowa 19091 2599 37
2246582 2246582 2022-02-24 Humboldt Iowa 19091 2599 37
2243331 2243331 2022-02-23 Humboldt Iowa 19091 2599 37
2240080 2240080 2022-02-22 Humboldt Iowa 19091 2585 36
2236829 2236829 2022-02-21 Humboldt Iowa 19091 2585 36
2233578 2233578 2022-02-20 Humboldt Iowa 19091 2585 36
2230327 2230327 2022-02-19 Humboldt Iowa 19091 2585 36
2227076 2227076 2022-02-18 Humboldt Iowa 19091 2585 36
2223825 2223825 2022-02-17 Humboldt Iowa 19091 2585 36
2220574 2220574 2022-02-16 Humboldt Iowa 19091 2585 36
2217323 2217323 2022-02-15 Humboldt Iowa 19091 2572 35
2214072 2214072 2022-02-14 Humboldt Iowa 19091 2572 35
2210820 2210820 2022-02-13 Humboldt Iowa 19091 2572 35
2207567 2207567 2022-02-12 Humboldt Iowa 19091 2572 35
2204314 2204314 2022-02-11 Humboldt Iowa 19091 2572 35
2201061 2201061 2022-02-10 Humboldt Iowa 19091 2572 35
2197807 2197807 2022-02-09 Humboldt Iowa 19091 2572 35
2194553 2194553 2022-02-08 Humboldt Iowa 19091 2549 35
2191299 2191299 2022-02-07 Humboldt Iowa 19091 2549 35
2188046 2188046 2022-02-06 Humboldt Iowa 19091 2549 35
2184793 2184793 2022-02-05 Humboldt Iowa 19091 2549 35
2181541 2181541 2022-02-04 Humboldt Iowa 19091 2549 35
2178290 2178290 2022-02-03 Humboldt Iowa 19091 2549 35

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