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

774 rows where county = "Clay" and fips = 19041 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 19041 · 774 ✖

county 1

  • Clay · 774 ✖
Link rowid date ▲ county state fips cases deaths
2500393 2500393 2022-05-13 Clay Iowa 19041 4120 44
2497135 2497135 2022-05-12 Clay Iowa 19041 4120 44
2493877 2493877 2022-05-11 Clay Iowa 19041 4120 44
2490619 2490619 2022-05-10 Clay Iowa 19041 4113 44
2487362 2487362 2022-05-09 Clay Iowa 19041 4113 44
2484104 2484104 2022-05-08 Clay Iowa 19041 4113 44
2480846 2480846 2022-05-07 Clay Iowa 19041 4113 44
2477588 2477588 2022-05-06 Clay Iowa 19041 4113 44
2474330 2474330 2022-05-05 Clay Iowa 19041 4113 44
2471073 2471073 2022-05-04 Clay Iowa 19041 4113 44
2467817 2467817 2022-05-03 Clay Iowa 19041 4107 44
2464562 2464562 2022-05-02 Clay Iowa 19041 4107 44
2461306 2461306 2022-05-01 Clay Iowa 19041 4107 44
2458050 2458050 2022-04-30 Clay Iowa 19041 4107 44
2454794 2454794 2022-04-29 Clay Iowa 19041 4107 44
2451538 2451538 2022-04-28 Clay Iowa 19041 4107 44
2448282 2448282 2022-04-27 Clay Iowa 19041 4107 44
2445026 2445026 2022-04-26 Clay Iowa 19041 4101 44
2441770 2441770 2022-04-25 Clay Iowa 19041 4101 44
2438514 2438514 2022-04-24 Clay Iowa 19041 4101 44
2435258 2435258 2022-04-23 Clay Iowa 19041 4101 44
2432002 2432002 2022-04-22 Clay Iowa 19041 4101 44
2428746 2428746 2022-04-21 Clay Iowa 19041 4101 44
2425490 2425490 2022-04-20 Clay Iowa 19041 4101 44
2422234 2422234 2022-04-19 Clay Iowa 19041 4094 44
2418978 2418978 2022-04-18 Clay Iowa 19041 4094 44
2415722 2415722 2022-04-17 Clay Iowa 19041 4094 44
2412466 2412466 2022-04-16 Clay Iowa 19041 4094 44
2409210 2409210 2022-04-15 Clay Iowa 19041 4094 44
2405954 2405954 2022-04-14 Clay Iowa 19041 4094 44
2402698 2402698 2022-04-13 Clay Iowa 19041 4094 44
2399444 2399444 2022-04-12 Clay Iowa 19041 4094 44
2396188 2396188 2022-04-11 Clay Iowa 19041 4094 44
2392933 2392933 2022-04-10 Clay Iowa 19041 4094 44
2389677 2389677 2022-04-09 Clay Iowa 19041 4094 44
2386421 2386421 2022-04-08 Clay Iowa 19041 4094 44
2383167 2383167 2022-04-07 Clay Iowa 19041 4094 44
2379912 2379912 2022-04-06 Clay Iowa 19041 4094 44
2376657 2376657 2022-04-05 Clay Iowa 19041 4092 43
2373405 2373405 2022-04-04 Clay Iowa 19041 4092 43
2370152 2370152 2022-04-03 Clay Iowa 19041 4092 43
2366899 2366899 2022-04-02 Clay Iowa 19041 4092 43
2363646 2363646 2022-04-01 Clay Iowa 19041 4092 43
2360392 2360392 2022-03-31 Clay Iowa 19041 4092 43
2357138 2357138 2022-03-30 Clay Iowa 19041 4092 43
2353885 2353885 2022-03-29 Clay Iowa 19041 4090 43
2350633 2350633 2022-03-28 Clay Iowa 19041 4090 43
2347380 2347380 2022-03-27 Clay Iowa 19041 4090 43
2344127 2344127 2022-03-26 Clay Iowa 19041 4090 43
2340874 2340874 2022-03-25 Clay Iowa 19041 4090 43
2337621 2337621 2022-03-24 Clay Iowa 19041 4090 43
2334367 2334367 2022-03-23 Clay Iowa 19041 4090 43
2331113 2331113 2022-03-22 Clay Iowa 19041 4089 42
2327861 2327861 2022-03-21 Clay Iowa 19041 4089 42
2324608 2324608 2022-03-20 Clay Iowa 19041 4089 42
2321354 2321354 2022-03-19 Clay Iowa 19041 4089 42
2318100 2318100 2022-03-18 Clay Iowa 19041 4089 42
2314847 2314847 2022-03-17 Clay Iowa 19041 4089 42
2311594 2311594 2022-03-16 Clay Iowa 19041 4089 42
2308341 2308341 2022-03-15 Clay Iowa 19041 4084 42
2305090 2305090 2022-03-14 Clay Iowa 19041 4084 42
2301838 2301838 2022-03-13 Clay Iowa 19041 4084 42
2298586 2298586 2022-03-12 Clay Iowa 19041 4084 42
2295334 2295334 2022-03-11 Clay Iowa 19041 4084 42
2292082 2292082 2022-03-10 Clay Iowa 19041 4084 42
2288830 2288830 2022-03-09 Clay Iowa 19041 4084 42
2285579 2285579 2022-03-08 Clay Iowa 19041 4076 41
2282327 2282327 2022-03-07 Clay Iowa 19041 4076 41
2279074 2279074 2022-03-06 Clay Iowa 19041 4076 41
2275821 2275821 2022-03-05 Clay Iowa 19041 4076 41
2272568 2272568 2022-03-04 Clay Iowa 19041 4076 41
2269316 2269316 2022-03-03 Clay Iowa 19041 4076 41
2266063 2266063 2022-03-02 Clay Iowa 19041 4076 41
2262812 2262812 2022-03-01 Clay Iowa 19041 4056 40
2259561 2259561 2022-02-28 Clay Iowa 19041 4056 40
2256310 2256310 2022-02-27 Clay Iowa 19041 4056 40
2253059 2253059 2022-02-26 Clay Iowa 19041 4056 40
2249808 2249808 2022-02-25 Clay Iowa 19041 4056 40
2246557 2246557 2022-02-24 Clay Iowa 19041 4056 40
2243306 2243306 2022-02-23 Clay Iowa 19041 4056 40
2240055 2240055 2022-02-22 Clay Iowa 19041 4040 40
2236804 2236804 2022-02-21 Clay Iowa 19041 4040 40
2233553 2233553 2022-02-20 Clay Iowa 19041 4040 40
2230302 2230302 2022-02-19 Clay Iowa 19041 4040 40
2227051 2227051 2022-02-18 Clay Iowa 19041 4040 40
2223800 2223800 2022-02-17 Clay Iowa 19041 4040 40
2220549 2220549 2022-02-16 Clay Iowa 19041 4040 40
2217298 2217298 2022-02-15 Clay Iowa 19041 4010 40
2214047 2214047 2022-02-14 Clay Iowa 19041 4010 40
2210795 2210795 2022-02-13 Clay Iowa 19041 4010 40
2207542 2207542 2022-02-12 Clay Iowa 19041 4010 40
2204289 2204289 2022-02-11 Clay Iowa 19041 4010 40
2201036 2201036 2022-02-10 Clay Iowa 19041 4010 40
2197782 2197782 2022-02-09 Clay Iowa 19041 4010 40
2194528 2194528 2022-02-08 Clay Iowa 19041 3940 40
2191274 2191274 2022-02-07 Clay Iowa 19041 3940 40
2188021 2188021 2022-02-06 Clay Iowa 19041 3940 40
2184768 2184768 2022-02-05 Clay Iowa 19041 3940 40
2181516 2181516 2022-02-04 Clay Iowa 19041 3940 40
2178265 2178265 2022-02-03 Clay Iowa 19041 3940 40

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