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

775 rows where county = "Holmes", fips = 39075 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 · 775 ✖

fips 1

  • 39075 · 775 ✖

county 1

  • Holmes · 775 ✖
Link rowid date ▲ county state fips cases deaths
2501681 2501681 2022-05-13 Holmes Ohio 39075 5135 182
2498423 2498423 2022-05-12 Holmes Ohio 39075 5135 182
2495165 2495165 2022-05-11 Holmes Ohio 39075 5127 182
2491907 2491907 2022-05-10 Holmes Ohio 39075 5127 182
2488649 2488649 2022-05-09 Holmes Ohio 39075 5127 182
2485392 2485392 2022-05-08 Holmes Ohio 39075 5127 182
2482134 2482134 2022-05-07 Holmes Ohio 39075 5127 182
2478876 2478876 2022-05-06 Holmes Ohio 39075 5127 182
2475618 2475618 2022-05-05 Holmes Ohio 39075 5127 182
2472361 2472361 2022-05-04 Holmes Ohio 39075 5120 182
2469105 2469105 2022-05-03 Holmes Ohio 39075 5120 182
2465849 2465849 2022-05-02 Holmes Ohio 39075 5120 182
2462594 2462594 2022-05-01 Holmes Ohio 39075 5120 182
2459338 2459338 2022-04-30 Holmes Ohio 39075 5120 182
2456082 2456082 2022-04-29 Holmes Ohio 39075 5120 182
2452826 2452826 2022-04-28 Holmes Ohio 39075 5120 182
2449570 2449570 2022-04-27 Holmes Ohio 39075 5112 182
2446313 2446313 2022-04-26 Holmes Ohio 39075 5112 182
2443058 2443058 2022-04-25 Holmes Ohio 39075 5112 182
2439802 2439802 2022-04-24 Holmes Ohio 39075 5112 182
2436546 2436546 2022-04-23 Holmes Ohio 39075 5112 182
2433290 2433290 2022-04-22 Holmes Ohio 39075 5112 182
2430034 2430034 2022-04-21 Holmes Ohio 39075 5112 182
2426778 2426778 2022-04-20 Holmes Ohio 39075 5109 181
2423522 2423522 2022-04-19 Holmes Ohio 39075 5109 181
2420265 2420265 2022-04-18 Holmes Ohio 39075 5109 181
2417010 2417010 2022-04-17 Holmes Ohio 39075 5109 181
2413754 2413754 2022-04-16 Holmes Ohio 39075 5109 181
2410498 2410498 2022-04-15 Holmes Ohio 39075 5109 181
2407242 2407242 2022-04-14 Holmes Ohio 39075 5109 181
2403986 2403986 2022-04-13 Holmes Ohio 39075 5106 181
2400731 2400731 2022-04-12 Holmes Ohio 39075 5106 181
2397476 2397476 2022-04-11 Holmes Ohio 39075 5106 181
2394221 2394221 2022-04-10 Holmes Ohio 39075 5106 181
2390965 2390965 2022-04-09 Holmes Ohio 39075 5106 181
2387709 2387709 2022-04-08 Holmes Ohio 39075 5106 181
2384454 2384454 2022-04-07 Holmes Ohio 39075 5106 181
2381199 2381199 2022-04-06 Holmes Ohio 39075 5101 181
2377944 2377944 2022-04-05 Holmes Ohio 39075 5101 181
2374690 2374690 2022-04-04 Holmes Ohio 39075 5101 181
2371438 2371438 2022-04-03 Holmes Ohio 39075 5101 181
2368185 2368185 2022-04-02 Holmes Ohio 39075 5101 181
2364932 2364932 2022-04-01 Holmes Ohio 39075 5101 181
2361679 2361679 2022-03-31 Holmes Ohio 39075 5101 181
2358425 2358425 2022-03-30 Holmes Ohio 39075 5099 180
2355171 2355171 2022-03-29 Holmes Ohio 39075 5099 180
2351918 2351918 2022-03-28 Holmes Ohio 39075 5099 180
2348666 2348666 2022-03-27 Holmes Ohio 39075 5099 180
2345413 2345413 2022-03-26 Holmes Ohio 39075 5099 180
2342160 2342160 2022-03-25 Holmes Ohio 39075 5099 180
2338907 2338907 2022-03-24 Holmes Ohio 39075 5099 180
2335653 2335653 2022-03-23 Holmes Ohio 39075 5098 180
2332399 2332399 2022-03-22 Holmes Ohio 39075 5098 180
2329146 2329146 2022-03-21 Holmes Ohio 39075 5098 180
2325894 2325894 2022-03-20 Holmes Ohio 39075 5098 180
2322641 2322641 2022-03-19 Holmes Ohio 39075 5098 180
2319387 2319387 2022-03-18 Holmes Ohio 39075 5098 180
2316133 2316133 2022-03-17 Holmes Ohio 39075 5098 180
2312880 2312880 2022-03-16 Holmes Ohio 39075 5096 180
2309627 2309627 2022-03-15 Holmes Ohio 39075 5096 180
2306374 2306374 2022-03-14 Holmes Ohio 39075 5096 180
2303123 2303123 2022-03-13 Holmes Ohio 39075 5096 180
2299871 2299871 2022-03-12 Holmes Ohio 39075 5096 180
2296619 2296619 2022-03-11 Holmes Ohio 39075 5094 180
2293367 2293367 2022-03-10 Holmes Ohio 39075 5093 180
2290115 2290115 2022-03-09 Holmes Ohio 39075 5091 180
2286863 2286863 2022-03-08 Holmes Ohio 39075 5090 180
2283611 2283611 2022-03-07 Holmes Ohio 39075 5089 180
2280359 2280359 2022-03-06 Holmes Ohio 39075 5090 180
2277106 2277106 2022-03-05 Holmes Ohio 39075 5089 180
2273853 2273853 2022-03-04 Holmes Ohio 39075 5088 180
2270600 2270600 2022-03-03 Holmes Ohio 39075 5085 180
2267348 2267348 2022-03-02 Holmes Ohio 39075 5063 180
2264095 2264095 2022-03-01 Holmes Ohio 39075 5060 180
2260845 2260845 2022-02-28 Holmes Ohio 39075 5060 180
2257594 2257594 2022-02-27 Holmes Ohio 39075 5060 180
2254343 2254343 2022-02-26 Holmes Ohio 39075 5059 180
2251092 2251092 2022-02-25 Holmes Ohio 39075 5058 180
2247841 2247841 2022-02-24 Holmes Ohio 39075 5055 178
2244590 2244590 2022-02-23 Holmes Ohio 39075 5053 178
2241339 2241339 2022-02-22 Holmes Ohio 39075 5049 178
2238088 2238088 2022-02-21 Holmes Ohio 39075 5049 172
2234837 2234837 2022-02-20 Holmes Ohio 39075 5049 172
2231586 2231586 2022-02-19 Holmes Ohio 39075 5049 172
2228335 2228335 2022-02-18 Holmes Ohio 39075 5046 172
2225084 2225084 2022-02-17 Holmes Ohio 39075 5046 172
2221833 2221833 2022-02-16 Holmes Ohio 39075 5041 172
2218582 2218582 2022-02-15 Holmes Ohio 39075 5040 172
2215331 2215331 2022-02-14 Holmes Ohio 39075 5037 172
2212080 2212080 2022-02-13 Holmes Ohio 39075 5035 172
2208827 2208827 2022-02-12 Holmes Ohio 39075 5032 172
2205574 2205574 2022-02-11 Holmes Ohio 39075 5030 172
2202321 2202321 2022-02-10 Holmes Ohio 39075 5027 172
2199067 2199067 2022-02-09 Holmes Ohio 39075 5022 172
2195813 2195813 2022-02-08 Holmes Ohio 39075 5011 172
2192559 2192559 2022-02-07 Holmes Ohio 39075 5009 172
2189305 2189305 2022-02-06 Holmes Ohio 39075 5007 172
2186052 2186052 2022-02-05 Holmes Ohio 39075 5004 172
2182800 2182800 2022-02-04 Holmes Ohio 39075 5004 172
2179548 2179548 2022-02-03 Holmes Ohio 39075 5001 167

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