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 = "Henry" and fips = 21103 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

  • 21103 · 774 ✖

county 1

  • Henry · 774 ✖
Link rowid date ▲ county state fips cases deaths
2500630 2500630 2022-05-13 Henry Kentucky 21103 4836 52
2497372 2497372 2022-05-12 Henry Kentucky 21103 4836 52
2494114 2494114 2022-05-11 Henry Kentucky 21103 4836 52
2490856 2490856 2022-05-10 Henry Kentucky 21103 4836 52
2487599 2487599 2022-05-09 Henry Kentucky 21103 4836 52
2484341 2484341 2022-05-08 Henry Kentucky 21103 4807 52
2481083 2481083 2022-05-07 Henry Kentucky 21103 4807 52
2477825 2477825 2022-05-06 Henry Kentucky 21103 4807 52
2474567 2474567 2022-05-05 Henry Kentucky 21103 4807 52
2471310 2471310 2022-05-04 Henry Kentucky 21103 4807 52
2468054 2468054 2022-05-03 Henry Kentucky 21103 4807 52
2464799 2464799 2022-05-02 Henry Kentucky 21103 4807 52
2461543 2461543 2022-05-01 Henry Kentucky 21103 4783 50
2458287 2458287 2022-04-30 Henry Kentucky 21103 4783 50
2455031 2455031 2022-04-29 Henry Kentucky 21103 4783 50
2451775 2451775 2022-04-28 Henry Kentucky 21103 4783 50
2448519 2448519 2022-04-27 Henry Kentucky 21103 4783 50
2445263 2445263 2022-04-26 Henry Kentucky 21103 4783 50
2442007 2442007 2022-04-25 Henry Kentucky 21103 4783 50
2438751 2438751 2022-04-24 Henry Kentucky 21103 4769 49
2435495 2435495 2022-04-23 Henry Kentucky 21103 4769 49
2432239 2432239 2022-04-22 Henry Kentucky 21103 4769 49
2428983 2428983 2022-04-21 Henry Kentucky 21103 4769 49
2425727 2425727 2022-04-20 Henry Kentucky 21103 4769 49
2422471 2422471 2022-04-19 Henry Kentucky 21103 4769 49
2419215 2419215 2022-04-18 Henry Kentucky 21103 4769 49
2415959 2415959 2022-04-17 Henry Kentucky 21103 4764 49
2412703 2412703 2022-04-16 Henry Kentucky 21103 4764 49
2409447 2409447 2022-04-15 Henry Kentucky 21103 4764 49
2406191 2406191 2022-04-14 Henry Kentucky 21103 4764 49
2402935 2402935 2022-04-13 Henry Kentucky 21103 4764 49
2399681 2399681 2022-04-12 Henry Kentucky 21103 4764 49
2396425 2396425 2022-04-11 Henry Kentucky 21103 4764 49
2393170 2393170 2022-04-10 Henry Kentucky 21103 4760 48
2389914 2389914 2022-04-09 Henry Kentucky 21103 4760 48
2386658 2386658 2022-04-08 Henry Kentucky 21103 4760 48
2383403 2383403 2022-04-07 Henry Kentucky 21103 4760 48
2380148 2380148 2022-04-06 Henry Kentucky 21103 4760 48
2376893 2376893 2022-04-05 Henry Kentucky 21103 4760 48
2373641 2373641 2022-04-04 Henry Kentucky 21103 4760 48
2370388 2370388 2022-04-03 Henry Kentucky 21103 4762 47
2367135 2367135 2022-04-02 Henry Kentucky 21103 4762 47
2363882 2363882 2022-04-01 Henry Kentucky 21103 4762 47
2360628 2360628 2022-03-31 Henry Kentucky 21103 4762 47
2357374 2357374 2022-03-30 Henry Kentucky 21103 4762 47
2354121 2354121 2022-03-29 Henry Kentucky 21103 4762 47
2350869 2350869 2022-03-28 Henry Kentucky 21103 4762 47
2347616 2347616 2022-03-27 Henry Kentucky 21103 4759 47
2344363 2344363 2022-03-26 Henry Kentucky 21103 4759 47
2341110 2341110 2022-03-25 Henry Kentucky 21103 4759 47
2337857 2337857 2022-03-24 Henry Kentucky 21103 4759 47
2334603 2334603 2022-03-23 Henry Kentucky 21103 4759 47
2331349 2331349 2022-03-22 Henry Kentucky 21103 4759 47
2328097 2328097 2022-03-21 Henry Kentucky 21103 4759 47
2324844 2324844 2022-03-20 Henry Kentucky 21103 4750 46
2321590 2321590 2022-03-19 Henry Kentucky 21103 4750 46
2318336 2318336 2022-03-18 Henry Kentucky 21103 4750 46
2315083 2315083 2022-03-17 Henry Kentucky 21103 4750 46
2311830 2311830 2022-03-16 Henry Kentucky 21103 4750 46
2308577 2308577 2022-03-15 Henry Kentucky 21103 4750 46
2305326 2305326 2022-03-14 Henry Kentucky 21103 4750 46
2302074 2302074 2022-03-13 Henry Kentucky 21103 4736 46
2298822 2298822 2022-03-12 Henry Kentucky 21103 4736 46
2295570 2295570 2022-03-11 Henry Kentucky 21103 4736 46
2292318 2292318 2022-03-10 Henry Kentucky 21103 4736 46
2289066 2289066 2022-03-09 Henry Kentucky 21103 4736 46
2285815 2285815 2022-03-08 Henry Kentucky 21103 4736 46
2282563 2282563 2022-03-07 Henry Kentucky 21103 4736 46
2279310 2279310 2022-03-06 Henry Kentucky 21103 4735 46
2276057 2276057 2022-03-05 Henry Kentucky 21103 4735 46
2272804 2272804 2022-03-04 Henry Kentucky 21103 4735 46
2269552 2269552 2022-03-03 Henry Kentucky 21103 4733 46
2266299 2266299 2022-03-02 Henry Kentucky 21103 4731 46
2263048 2263048 2022-03-01 Henry Kentucky 21103 4727 46
2259797 2259797 2022-02-28 Henry Kentucky 21103 4726 46
2256546 2256546 2022-02-27 Henry Kentucky 21103 4723 45
2253295 2253295 2022-02-26 Henry Kentucky 21103 4723 45
2250044 2250044 2022-02-25 Henry Kentucky 21103 4723 45
2246793 2246793 2022-02-24 Henry Kentucky 21103 4721 45
2243542 2243542 2022-02-23 Henry Kentucky 21103 4721 45
2240291 2240291 2022-02-22 Henry Kentucky 21103 4721 45
2237040 2237040 2022-02-21 Henry Kentucky 21103 4709 45
2233789 2233789 2022-02-20 Henry Kentucky 21103 4698 46
2230538 2230538 2022-02-19 Henry Kentucky 21103 4698 46
2227287 2227287 2022-02-18 Henry Kentucky 21103 4698 46
2224036 2224036 2022-02-17 Henry Kentucky 21103 4691 46
2220785 2220785 2022-02-16 Henry Kentucky 21103 4676 46
2217534 2217534 2022-02-15 Henry Kentucky 21103 4667 45
2214283 2214283 2022-02-14 Henry Kentucky 21103 4661 45
2211031 2211031 2022-02-13 Henry Kentucky 21103 4616 45
2207778 2207778 2022-02-12 Henry Kentucky 21103 4616 45
2204525 2204525 2022-02-11 Henry Kentucky 21103 4616 45
2201272 2201272 2022-02-10 Henry Kentucky 21103 4598 44
2198018 2198018 2022-02-09 Henry Kentucky 21103 4588 44
2194764 2194764 2022-02-08 Henry Kentucky 21103 4574 44
2191510 2191510 2022-02-07 Henry Kentucky 21103 4558 44
2188257 2188257 2022-02-06 Henry Kentucky 21103 4529 44
2185004 2185004 2022-02-05 Henry Kentucky 21103 4529 44
2181752 2181752 2022-02-04 Henry Kentucky 21103 4529 44
2178501 2178501 2022-02-03 Henry Kentucky 21103 4517 44

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