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

766 rows where county = "Henry" and state = "Ohio" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Ohio · 766 ✖

fips 1

county 1

  • Henry · 766 ✖
Link rowid date ▲ county state fips cases deaths
2501678 2501678 2022-05-13 Henry Ohio 39069 6485 106
2498420 2498420 2022-05-12 Henry Ohio 39069 6485 106
2495162 2495162 2022-05-11 Henry Ohio 39069 6466 106
2491904 2491904 2022-05-10 Henry Ohio 39069 6466 106
2488646 2488646 2022-05-09 Henry Ohio 39069 6466 106
2485389 2485389 2022-05-08 Henry Ohio 39069 6466 106
2482131 2482131 2022-05-07 Henry Ohio 39069 6466 106
2478873 2478873 2022-05-06 Henry Ohio 39069 6466 106
2475615 2475615 2022-05-05 Henry Ohio 39069 6466 106
2472358 2472358 2022-05-04 Henry Ohio 39069 6449 106
2469102 2469102 2022-05-03 Henry Ohio 39069 6449 106
2465846 2465846 2022-05-02 Henry Ohio 39069 6449 106
2462591 2462591 2022-05-01 Henry Ohio 39069 6449 106
2459335 2459335 2022-04-30 Henry Ohio 39069 6449 106
2456079 2456079 2022-04-29 Henry Ohio 39069 6449 106
2452823 2452823 2022-04-28 Henry Ohio 39069 6449 106
2449567 2449567 2022-04-27 Henry Ohio 39069 6434 106
2446310 2446310 2022-04-26 Henry Ohio 39069 6434 106
2443055 2443055 2022-04-25 Henry Ohio 39069 6434 106
2439799 2439799 2022-04-24 Henry Ohio 39069 6434 106
2436543 2436543 2022-04-23 Henry Ohio 39069 6434 106
2433287 2433287 2022-04-22 Henry Ohio 39069 6434 106
2430031 2430031 2022-04-21 Henry Ohio 39069 6434 106
2426775 2426775 2022-04-20 Henry Ohio 39069 6425 106
2423519 2423519 2022-04-19 Henry Ohio 39069 6425 106
2420262 2420262 2022-04-18 Henry Ohio 39069 6425 106
2417007 2417007 2022-04-17 Henry Ohio 39069 6425 106
2413751 2413751 2022-04-16 Henry Ohio 39069 6425 106
2410495 2410495 2022-04-15 Henry Ohio 39069 6425 106
2407239 2407239 2022-04-14 Henry Ohio 39069 6425 106
2403983 2403983 2022-04-13 Henry Ohio 39069 6424 106
2400728 2400728 2022-04-12 Henry Ohio 39069 6424 106
2397473 2397473 2022-04-11 Henry Ohio 39069 6424 106
2394218 2394218 2022-04-10 Henry Ohio 39069 6424 106
2390962 2390962 2022-04-09 Henry Ohio 39069 6424 106
2387706 2387706 2022-04-08 Henry Ohio 39069 6424 106
2384451 2384451 2022-04-07 Henry Ohio 39069 6424 106
2381196 2381196 2022-04-06 Henry Ohio 39069 6425 106
2377941 2377941 2022-04-05 Henry Ohio 39069 6425 106
2374687 2374687 2022-04-04 Henry Ohio 39069 6425 106
2371435 2371435 2022-04-03 Henry Ohio 39069 6425 106
2368182 2368182 2022-04-02 Henry Ohio 39069 6425 106
2364929 2364929 2022-04-01 Henry Ohio 39069 6425 106
2361676 2361676 2022-03-31 Henry Ohio 39069 6425 106
2358422 2358422 2022-03-30 Henry Ohio 39069 6422 106
2355168 2355168 2022-03-29 Henry Ohio 39069 6422 106
2351915 2351915 2022-03-28 Henry Ohio 39069 6422 106
2348663 2348663 2022-03-27 Henry Ohio 39069 6422 106
2345410 2345410 2022-03-26 Henry Ohio 39069 6422 106
2342157 2342157 2022-03-25 Henry Ohio 39069 6422 106
2338904 2338904 2022-03-24 Henry Ohio 39069 6422 106
2335650 2335650 2022-03-23 Henry Ohio 39069 6418 106
2332396 2332396 2022-03-22 Henry Ohio 39069 6418 106
2329143 2329143 2022-03-21 Henry Ohio 39069 6418 106
2325891 2325891 2022-03-20 Henry Ohio 39069 6418 106
2322638 2322638 2022-03-19 Henry Ohio 39069 6418 106
2319384 2319384 2022-03-18 Henry Ohio 39069 6418 106
2316130 2316130 2022-03-17 Henry Ohio 39069 6418 106
2312877 2312877 2022-03-16 Henry Ohio 39069 6416 106
2309624 2309624 2022-03-15 Henry Ohio 39069 6416 106
2306371 2306371 2022-03-14 Henry Ohio 39069 6416 106
2303120 2303120 2022-03-13 Henry Ohio 39069 6416 106
2299868 2299868 2022-03-12 Henry Ohio 39069 6415 106
2296616 2296616 2022-03-11 Henry Ohio 39069 6417 106
2293364 2293364 2022-03-10 Henry Ohio 39069 6417 106
2290112 2290112 2022-03-09 Henry Ohio 39069 6416 106
2286860 2286860 2022-03-08 Henry Ohio 39069 6416 106
2283608 2283608 2022-03-07 Henry Ohio 39069 6413 106
2280356 2280356 2022-03-06 Henry Ohio 39069 6409 106
2277103 2277103 2022-03-05 Henry Ohio 39069 6409 106
2273850 2273850 2022-03-04 Henry Ohio 39069 6407 106
2270597 2270597 2022-03-03 Henry Ohio 39069 6405 106
2267345 2267345 2022-03-02 Henry Ohio 39069 6403 106
2264092 2264092 2022-03-01 Henry Ohio 39069 6403 106
2260842 2260842 2022-02-28 Henry Ohio 39069 6402 106
2257591 2257591 2022-02-27 Henry Ohio 39069 6401 106
2254340 2254340 2022-02-26 Henry Ohio 39069 6401 106
2251089 2251089 2022-02-25 Henry Ohio 39069 6397 106
2247838 2247838 2022-02-24 Henry Ohio 39069 6395 106
2244587 2244587 2022-02-23 Henry Ohio 39069 6392 106
2241336 2241336 2022-02-22 Henry Ohio 39069 6391 106
2238085 2238085 2022-02-21 Henry Ohio 39069 6382 103
2234834 2234834 2022-02-20 Henry Ohio 39069 6382 103
2231583 2231583 2022-02-19 Henry Ohio 39069 6379 103
2228332 2228332 2022-02-18 Henry Ohio 39069 6374 103
2225081 2225081 2022-02-17 Henry Ohio 39069 6369 102
2221830 2221830 2022-02-16 Henry Ohio 39069 6366 102
2218579 2218579 2022-02-15 Henry Ohio 39069 6360 102
2215328 2215328 2022-02-14 Henry Ohio 39069 6353 100
2212077 2212077 2022-02-13 Henry Ohio 39069 6351 100
2208824 2208824 2022-02-12 Henry Ohio 39069 6346 100
2205571 2205571 2022-02-11 Henry Ohio 39069 6339 100
2202318 2202318 2022-02-10 Henry Ohio 39069 6329 100
2199064 2199064 2022-02-09 Henry Ohio 39069 6327 100
2195810 2195810 2022-02-08 Henry Ohio 39069 6310 100
2192556 2192556 2022-02-07 Henry Ohio 39069 6305 98
2189302 2189302 2022-02-06 Henry Ohio 39069 6297 98
2186049 2186049 2022-02-05 Henry Ohio 39069 6289 98
2182797 2182797 2022-02-04 Henry Ohio 39069 6282 98
2179545 2179545 2022-02-03 Henry Ohio 39069 6275 98

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