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

788 rows where fips = 39037 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 · 788 ✖

fips 1

  • 39037 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501662 2501662 2022-05-13 Darke Ohio 39037 12442 239
2498404 2498404 2022-05-12 Darke Ohio 39037 12442 239
2495146 2495146 2022-05-11 Darke Ohio 39037 12422 238
2491888 2491888 2022-05-10 Darke Ohio 39037 12422 238
2488630 2488630 2022-05-09 Darke Ohio 39037 12422 238
2485373 2485373 2022-05-08 Darke Ohio 39037 12422 238
2482115 2482115 2022-05-07 Darke Ohio 39037 12422 238
2478857 2478857 2022-05-06 Darke Ohio 39037 12422 238
2475599 2475599 2022-05-05 Darke Ohio 39037 12422 238
2472342 2472342 2022-05-04 Darke Ohio 39037 12405 238
2469086 2469086 2022-05-03 Darke Ohio 39037 12405 238
2465830 2465830 2022-05-02 Darke Ohio 39037 12405 238
2462575 2462575 2022-05-01 Darke Ohio 39037 12405 238
2459319 2459319 2022-04-30 Darke Ohio 39037 12405 238
2456063 2456063 2022-04-29 Darke Ohio 39037 12405 238
2452807 2452807 2022-04-28 Darke Ohio 39037 12405 238
2449551 2449551 2022-04-27 Darke Ohio 39037 12388 238
2446294 2446294 2022-04-26 Darke Ohio 39037 12388 238
2443039 2443039 2022-04-25 Darke Ohio 39037 12388 238
2439783 2439783 2022-04-24 Darke Ohio 39037 12388 238
2436527 2436527 2022-04-23 Darke Ohio 39037 12388 238
2433271 2433271 2022-04-22 Darke Ohio 39037 12388 238
2430015 2430015 2022-04-21 Darke Ohio 39037 12388 238
2426759 2426759 2022-04-20 Darke Ohio 39037 12381 238
2423503 2423503 2022-04-19 Darke Ohio 39037 12381 238
2420246 2420246 2022-04-18 Darke Ohio 39037 12381 238
2416991 2416991 2022-04-17 Darke Ohio 39037 12381 238
2413735 2413735 2022-04-16 Darke Ohio 39037 12381 238
2410479 2410479 2022-04-15 Darke Ohio 39037 12381 238
2407223 2407223 2022-04-14 Darke Ohio 39037 12381 238
2403967 2403967 2022-04-13 Darke Ohio 39037 12371 236
2400712 2400712 2022-04-12 Darke Ohio 39037 12371 236
2397457 2397457 2022-04-11 Darke Ohio 39037 12371 236
2394202 2394202 2022-04-10 Darke Ohio 39037 12371 236
2390946 2390946 2022-04-09 Darke Ohio 39037 12371 236
2387690 2387690 2022-04-08 Darke Ohio 39037 12371 236
2384435 2384435 2022-04-07 Darke Ohio 39037 12371 236
2381180 2381180 2022-04-06 Darke Ohio 39037 12366 236
2377925 2377925 2022-04-05 Darke Ohio 39037 12366 236
2374671 2374671 2022-04-04 Darke Ohio 39037 12366 236
2371419 2371419 2022-04-03 Darke Ohio 39037 12366 236
2368166 2368166 2022-04-02 Darke Ohio 39037 12366 236
2364913 2364913 2022-04-01 Darke Ohio 39037 12366 236
2361660 2361660 2022-03-31 Darke Ohio 39037 12366 236
2358406 2358406 2022-03-30 Darke Ohio 39037 12360 233
2355152 2355152 2022-03-29 Darke Ohio 39037 12360 233
2351899 2351899 2022-03-28 Darke Ohio 39037 12360 233
2348647 2348647 2022-03-27 Darke Ohio 39037 12360 233
2345394 2345394 2022-03-26 Darke Ohio 39037 12360 233
2342141 2342141 2022-03-25 Darke Ohio 39037 12360 233
2338888 2338888 2022-03-24 Darke Ohio 39037 12360 233
2335634 2335634 2022-03-23 Darke Ohio 39037 12348 233
2332380 2332380 2022-03-22 Darke Ohio 39037 12348 233
2329127 2329127 2022-03-21 Darke Ohio 39037 12348 233
2325875 2325875 2022-03-20 Darke Ohio 39037 12348 233
2322622 2322622 2022-03-19 Darke Ohio 39037 12348 233
2319368 2319368 2022-03-18 Darke Ohio 39037 12348 233
2316114 2316114 2022-03-17 Darke Ohio 39037 12348 233
2312861 2312861 2022-03-16 Darke Ohio 39037 12342 233
2309608 2309608 2022-03-15 Darke Ohio 39037 12342 233
2306355 2306355 2022-03-14 Darke Ohio 39037 12342 233
2303104 2303104 2022-03-13 Darke Ohio 39037 12342 233
2299852 2299852 2022-03-12 Darke Ohio 39037 12342 233
2296600 2296600 2022-03-11 Darke Ohio 39037 12341 233
2293348 2293348 2022-03-10 Darke Ohio 39037 12341 231
2290096 2290096 2022-03-09 Darke Ohio 39037 12340 231
2286844 2286844 2022-03-08 Darke Ohio 39037 12340 231
2283592 2283592 2022-03-07 Darke Ohio 39037 12338 228
2280340 2280340 2022-03-06 Darke Ohio 39037 12336 228
2277087 2277087 2022-03-05 Darke Ohio 39037 12336 228
2273834 2273834 2022-03-04 Darke Ohio 39037 12335 228
2270581 2270581 2022-03-03 Darke Ohio 39037 12333 225
2267329 2267329 2022-03-02 Darke Ohio 39037 12329 225
2264076 2264076 2022-03-01 Darke Ohio 39037 12326 225
2260826 2260826 2022-02-28 Darke Ohio 39037 12322 222
2257575 2257575 2022-02-27 Darke Ohio 39037 12321 222
2254324 2254324 2022-02-26 Darke Ohio 39037 12318 222
2251073 2251073 2022-02-25 Darke Ohio 39037 12312 222
2247822 2247822 2022-02-24 Darke Ohio 39037 12299 220
2244571 2244571 2022-02-23 Darke Ohio 39037 12290 220
2241320 2241320 2022-02-22 Darke Ohio 39037 12283 220
2238069 2238069 2022-02-21 Darke Ohio 39037 12277 216
2234818 2234818 2022-02-20 Darke Ohio 39037 12275 216
2231567 2231567 2022-02-19 Darke Ohio 39037 12267 216
2228316 2228316 2022-02-18 Darke Ohio 39037 12263 216
2225065 2225065 2022-02-17 Darke Ohio 39037 12259 216
2221814 2221814 2022-02-16 Darke Ohio 39037 12254 216
2218563 2218563 2022-02-15 Darke Ohio 39037 12243 216
2215312 2215312 2022-02-14 Darke Ohio 39037 12231 215
2212061 2212061 2022-02-13 Darke Ohio 39037 12220 215
2208808 2208808 2022-02-12 Darke Ohio 39037 12216 215
2205555 2205555 2022-02-11 Darke Ohio 39037 12207 215
2202302 2202302 2022-02-10 Darke Ohio 39037 12196 213
2199048 2199048 2022-02-09 Darke Ohio 39037 12180 213
2195794 2195794 2022-02-08 Darke Ohio 39037 12146 213
2192540 2192540 2022-02-07 Darke Ohio 39037 12132 211
2189286 2189286 2022-02-06 Darke Ohio 39037 12118 211
2186033 2186033 2022-02-05 Darke Ohio 39037 12110 211
2182781 2182781 2022-02-04 Darke Ohio 39037 12093 211
2179529 2179529 2022-02-03 Darke Ohio 39037 12070 206

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