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

727 rows where county = "Lucas" and state = "Iowa" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Iowa · 727 ✖

fips 1

county 1

  • Lucas · 727 ✖
Link rowid date ▲ county state fips cases deaths
2500431 2500431 2022-05-13 Lucas Iowa 19117 1763 32
2497173 2497173 2022-05-12 Lucas Iowa 19117 1763 32
2493915 2493915 2022-05-11 Lucas Iowa 19117 1763 32
2490657 2490657 2022-05-10 Lucas Iowa 19117 1759 32
2487400 2487400 2022-05-09 Lucas Iowa 19117 1759 32
2484142 2484142 2022-05-08 Lucas Iowa 19117 1759 32
2480884 2480884 2022-05-07 Lucas Iowa 19117 1759 32
2477626 2477626 2022-05-06 Lucas Iowa 19117 1759 32
2474368 2474368 2022-05-05 Lucas Iowa 19117 1759 32
2471111 2471111 2022-05-04 Lucas Iowa 19117 1759 32
2467855 2467855 2022-05-03 Lucas Iowa 19117 1755 32
2464600 2464600 2022-05-02 Lucas Iowa 19117 1755 32
2461344 2461344 2022-05-01 Lucas Iowa 19117 1755 32
2458088 2458088 2022-04-30 Lucas Iowa 19117 1755 32
2454832 2454832 2022-04-29 Lucas Iowa 19117 1755 32
2451576 2451576 2022-04-28 Lucas Iowa 19117 1755 32
2448320 2448320 2022-04-27 Lucas Iowa 19117 1755 32
2445064 2445064 2022-04-26 Lucas Iowa 19117 1755 32
2441808 2441808 2022-04-25 Lucas Iowa 19117 1755 32
2438552 2438552 2022-04-24 Lucas Iowa 19117 1755 32
2435296 2435296 2022-04-23 Lucas Iowa 19117 1755 32
2432040 2432040 2022-04-22 Lucas Iowa 19117 1755 32
2428784 2428784 2022-04-21 Lucas Iowa 19117 1755 32
2425528 2425528 2022-04-20 Lucas Iowa 19117 1755 32
2422272 2422272 2022-04-19 Lucas Iowa 19117 1754 32
2419016 2419016 2022-04-18 Lucas Iowa 19117 1754 32
2415760 2415760 2022-04-17 Lucas Iowa 19117 1754 32
2412504 2412504 2022-04-16 Lucas Iowa 19117 1754 32
2409248 2409248 2022-04-15 Lucas Iowa 19117 1754 32
2405992 2405992 2022-04-14 Lucas Iowa 19117 1754 32
2402736 2402736 2022-04-13 Lucas Iowa 19117 1754 32
2399482 2399482 2022-04-12 Lucas Iowa 19117 1752 32
2396226 2396226 2022-04-11 Lucas Iowa 19117 1752 32
2392971 2392971 2022-04-10 Lucas Iowa 19117 1752 32
2389715 2389715 2022-04-09 Lucas Iowa 19117 1752 32
2386459 2386459 2022-04-08 Lucas Iowa 19117 1752 32
2383205 2383205 2022-04-07 Lucas Iowa 19117 1752 32
2379950 2379950 2022-04-06 Lucas Iowa 19117 1752 32
2376695 2376695 2022-04-05 Lucas Iowa 19117 1749 32
2373443 2373443 2022-04-04 Lucas Iowa 19117 1749 32
2370190 2370190 2022-04-03 Lucas Iowa 19117 1749 32
2366937 2366937 2022-04-02 Lucas Iowa 19117 1749 32
2363684 2363684 2022-04-01 Lucas Iowa 19117 1749 32
2360430 2360430 2022-03-31 Lucas Iowa 19117 1749 32
2357176 2357176 2022-03-30 Lucas Iowa 19117 1749 32
2353923 2353923 2022-03-29 Lucas Iowa 19117 1748 32
2350671 2350671 2022-03-28 Lucas Iowa 19117 1748 32
2347418 2347418 2022-03-27 Lucas Iowa 19117 1748 32
2344165 2344165 2022-03-26 Lucas Iowa 19117 1748 32
2340912 2340912 2022-03-25 Lucas Iowa 19117 1748 32
2337659 2337659 2022-03-24 Lucas Iowa 19117 1748 32
2334405 2334405 2022-03-23 Lucas Iowa 19117 1748 32
2331151 2331151 2022-03-22 Lucas Iowa 19117 1747 32
2327899 2327899 2022-03-21 Lucas Iowa 19117 1747 32
2324646 2324646 2022-03-20 Lucas Iowa 19117 1747 32
2321392 2321392 2022-03-19 Lucas Iowa 19117 1747 32
2318138 2318138 2022-03-18 Lucas Iowa 19117 1747 32
2314885 2314885 2022-03-17 Lucas Iowa 19117 1747 32
2311632 2311632 2022-03-16 Lucas Iowa 19117 1747 32
2308379 2308379 2022-03-15 Lucas Iowa 19117 1742 32
2305128 2305128 2022-03-14 Lucas Iowa 19117 1742 32
2301876 2301876 2022-03-13 Lucas Iowa 19117 1742 32
2298624 2298624 2022-03-12 Lucas Iowa 19117 1742 32
2295372 2295372 2022-03-11 Lucas Iowa 19117 1742 32
2292120 2292120 2022-03-10 Lucas Iowa 19117 1742 32
2288868 2288868 2022-03-09 Lucas Iowa 19117 1742 32
2285617 2285617 2022-03-08 Lucas Iowa 19117 1737 31
2282365 2282365 2022-03-07 Lucas Iowa 19117 1737 31
2279112 2279112 2022-03-06 Lucas Iowa 19117 1737 31
2275859 2275859 2022-03-05 Lucas Iowa 19117 1737 31
2272606 2272606 2022-03-04 Lucas Iowa 19117 1737 31
2269354 2269354 2022-03-03 Lucas Iowa 19117 1737 31
2266101 2266101 2022-03-02 Lucas Iowa 19117 1737 31
2262850 2262850 2022-03-01 Lucas Iowa 19117 1729 31
2259599 2259599 2022-02-28 Lucas Iowa 19117 1729 31
2256348 2256348 2022-02-27 Lucas Iowa 19117 1729 31
2253097 2253097 2022-02-26 Lucas Iowa 19117 1729 31
2249846 2249846 2022-02-25 Lucas Iowa 19117 1729 31
2246595 2246595 2022-02-24 Lucas Iowa 19117 1729 31
2243344 2243344 2022-02-23 Lucas Iowa 19117 1729 31
2240093 2240093 2022-02-22 Lucas Iowa 19117 1717 31
2236842 2236842 2022-02-21 Lucas Iowa 19117 1717 31
2233591 2233591 2022-02-20 Lucas Iowa 19117 1717 31
2230340 2230340 2022-02-19 Lucas Iowa 19117 1717 31
2227089 2227089 2022-02-18 Lucas Iowa 19117 1717 31
2223838 2223838 2022-02-17 Lucas Iowa 19117 1717 31
2220587 2220587 2022-02-16 Lucas Iowa 19117 1717 31
2217336 2217336 2022-02-15 Lucas Iowa 19117 1696 29
2214085 2214085 2022-02-14 Lucas Iowa 19117 1696 29
2210833 2210833 2022-02-13 Lucas Iowa 19117 1696 29
2207580 2207580 2022-02-12 Lucas Iowa 19117 1696 29
2204327 2204327 2022-02-11 Lucas Iowa 19117 1696 29
2201074 2201074 2022-02-10 Lucas Iowa 19117 1696 29
2197820 2197820 2022-02-09 Lucas Iowa 19117 1696 29
2194566 2194566 2022-02-08 Lucas Iowa 19117 1657 29
2191312 2191312 2022-02-07 Lucas Iowa 19117 1657 29
2188059 2188059 2022-02-06 Lucas Iowa 19117 1657 29
2184806 2184806 2022-02-05 Lucas Iowa 19117 1657 29
2181554 2181554 2022-02-04 Lucas Iowa 19117 1657 29
2178303 2178303 2022-02-03 Lucas Iowa 19117 1657 29

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