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

768 rows where county = "Putnam" and fips = 39137 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

  • 39137 · 768 ✖

county 1

  • Putnam · 768 ✖
Link rowid date ▲ county state fips cases deaths
2501712 2501712 2022-05-13 Putnam Ohio 39137 8492 157
2498454 2498454 2022-05-12 Putnam Ohio 39137 8492 157
2495196 2495196 2022-05-11 Putnam Ohio 39137 8477 157
2491938 2491938 2022-05-10 Putnam Ohio 39137 8477 157
2488680 2488680 2022-05-09 Putnam Ohio 39137 8477 157
2485423 2485423 2022-05-08 Putnam Ohio 39137 8477 157
2482165 2482165 2022-05-07 Putnam Ohio 39137 8477 157
2478907 2478907 2022-05-06 Putnam Ohio 39137 8477 157
2475649 2475649 2022-05-05 Putnam Ohio 39137 8477 157
2472392 2472392 2022-05-04 Putnam Ohio 39137 8465 156
2469136 2469136 2022-05-03 Putnam Ohio 39137 8465 156
2465880 2465880 2022-05-02 Putnam Ohio 39137 8465 156
2462625 2462625 2022-05-01 Putnam Ohio 39137 8465 156
2459369 2459369 2022-04-30 Putnam Ohio 39137 8465 156
2456113 2456113 2022-04-29 Putnam Ohio 39137 8465 156
2452857 2452857 2022-04-28 Putnam Ohio 39137 8465 156
2449601 2449601 2022-04-27 Putnam Ohio 39137 8462 156
2446344 2446344 2022-04-26 Putnam Ohio 39137 8462 156
2443089 2443089 2022-04-25 Putnam Ohio 39137 8462 156
2439833 2439833 2022-04-24 Putnam Ohio 39137 8462 156
2436577 2436577 2022-04-23 Putnam Ohio 39137 8462 156
2433321 2433321 2022-04-22 Putnam Ohio 39137 8462 156
2430065 2430065 2022-04-21 Putnam Ohio 39137 8462 156
2426809 2426809 2022-04-20 Putnam Ohio 39137 8457 156
2423553 2423553 2022-04-19 Putnam Ohio 39137 8457 156
2420296 2420296 2022-04-18 Putnam Ohio 39137 8457 156
2417041 2417041 2022-04-17 Putnam Ohio 39137 8457 156
2413785 2413785 2022-04-16 Putnam Ohio 39137 8457 156
2410529 2410529 2022-04-15 Putnam Ohio 39137 8457 156
2407273 2407273 2022-04-14 Putnam Ohio 39137 8457 156
2404017 2404017 2022-04-13 Putnam Ohio 39137 8449 154
2400762 2400762 2022-04-12 Putnam Ohio 39137 8449 154
2397507 2397507 2022-04-11 Putnam Ohio 39137 8449 154
2394252 2394252 2022-04-10 Putnam Ohio 39137 8449 154
2390996 2390996 2022-04-09 Putnam Ohio 39137 8449 154
2387740 2387740 2022-04-08 Putnam Ohio 39137 8449 154
2384485 2384485 2022-04-07 Putnam Ohio 39137 8449 154
2381230 2381230 2022-04-06 Putnam Ohio 39137 8443 154
2377975 2377975 2022-04-05 Putnam Ohio 39137 8443 154
2374721 2374721 2022-04-04 Putnam Ohio 39137 8443 154
2371469 2371469 2022-04-03 Putnam Ohio 39137 8443 154
2368216 2368216 2022-04-02 Putnam Ohio 39137 8443 154
2364963 2364963 2022-04-01 Putnam Ohio 39137 8443 154
2361710 2361710 2022-03-31 Putnam Ohio 39137 8443 154
2358456 2358456 2022-03-30 Putnam Ohio 39137 8436 154
2355202 2355202 2022-03-29 Putnam Ohio 39137 8436 154
2351949 2351949 2022-03-28 Putnam Ohio 39137 8436 154
2348697 2348697 2022-03-27 Putnam Ohio 39137 8436 154
2345444 2345444 2022-03-26 Putnam Ohio 39137 8436 154
2342191 2342191 2022-03-25 Putnam Ohio 39137 8436 154
2338938 2338938 2022-03-24 Putnam Ohio 39137 8436 154
2335684 2335684 2022-03-23 Putnam Ohio 39137 8435 154
2332430 2332430 2022-03-22 Putnam Ohio 39137 8435 154
2329177 2329177 2022-03-21 Putnam Ohio 39137 8435 154
2325925 2325925 2022-03-20 Putnam Ohio 39137 8435 154
2322672 2322672 2022-03-19 Putnam Ohio 39137 8435 154
2319418 2319418 2022-03-18 Putnam Ohio 39137 8435 154
2316164 2316164 2022-03-17 Putnam Ohio 39137 8435 154
2312911 2312911 2022-03-16 Putnam Ohio 39137 8432 153
2309658 2309658 2022-03-15 Putnam Ohio 39137 8432 153
2306405 2306405 2022-03-14 Putnam Ohio 39137 8432 153
2303154 2303154 2022-03-13 Putnam Ohio 39137 8432 153
2299902 2299902 2022-03-12 Putnam Ohio 39137 8432 153
2296650 2296650 2022-03-11 Putnam Ohio 39137 8432 153
2293398 2293398 2022-03-10 Putnam Ohio 39137 8432 153
2290146 2290146 2022-03-09 Putnam Ohio 39137 8431 153
2286894 2286894 2022-03-08 Putnam Ohio 39137 8429 153
2283642 2283642 2022-03-07 Putnam Ohio 39137 8430 152
2280390 2280390 2022-03-06 Putnam Ohio 39137 8428 152
2277137 2277137 2022-03-05 Putnam Ohio 39137 8427 152
2273884 2273884 2022-03-04 Putnam Ohio 39137 8424 152
2270631 2270631 2022-03-03 Putnam Ohio 39137 8421 152
2267379 2267379 2022-03-02 Putnam Ohio 39137 8419 152
2264126 2264126 2022-03-01 Putnam Ohio 39137 8419 152
2260876 2260876 2022-02-28 Putnam Ohio 39137 8416 151
2257625 2257625 2022-02-27 Putnam Ohio 39137 8416 151
2254374 2254374 2022-02-26 Putnam Ohio 39137 8415 151
2251123 2251123 2022-02-25 Putnam Ohio 39137 8412 151
2247872 2247872 2022-02-24 Putnam Ohio 39137 8410 150
2244621 2244621 2022-02-23 Putnam Ohio 39137 8409 150
2241370 2241370 2022-02-22 Putnam Ohio 39137 8408 150
2238119 2238119 2022-02-21 Putnam Ohio 39137 8405 147
2234868 2234868 2022-02-20 Putnam Ohio 39137 8404 147
2231617 2231617 2022-02-19 Putnam Ohio 39137 8402 147
2228366 2228366 2022-02-18 Putnam Ohio 39137 8396 147
2225115 2225115 2022-02-17 Putnam Ohio 39137 8389 147
2221864 2221864 2022-02-16 Putnam Ohio 39137 8388 147
2218613 2218613 2022-02-15 Putnam Ohio 39137 8387 147
2215362 2215362 2022-02-14 Putnam Ohio 39137 8384 140
2212111 2212111 2022-02-13 Putnam Ohio 39137 8381 140
2208858 2208858 2022-02-12 Putnam Ohio 39137 8377 140
2205605 2205605 2022-02-11 Putnam Ohio 39137 8370 140
2202352 2202352 2022-02-10 Putnam Ohio 39137 8363 140
2199098 2199098 2022-02-09 Putnam Ohio 39137 8353 140
2195844 2195844 2022-02-08 Putnam Ohio 39137 8338 140
2192590 2192590 2022-02-07 Putnam Ohio 39137 8327 140
2189336 2189336 2022-02-06 Putnam Ohio 39137 8326 140
2186083 2186083 2022-02-05 Putnam Ohio 39137 8324 140
2182831 2182831 2022-02-04 Putnam Ohio 39137 8320 140
2179579 2179579 2022-02-03 Putnam Ohio 39137 8309 139

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