ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 39131 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501709 | 2501709 | 2022-05-13 | Pike | Ohio | 39131 | 7493 | 123 |
2498451 | 2498451 | 2022-05-12 | Pike | Ohio | 39131 | 7493 | 123 |
2495193 | 2495193 | 2022-05-11 | Pike | Ohio | 39131 | 7476 | 123 |
2491935 | 2491935 | 2022-05-10 | Pike | Ohio | 39131 | 7476 | 123 |
2488677 | 2488677 | 2022-05-09 | Pike | Ohio | 39131 | 7476 | 123 |
2485420 | 2485420 | 2022-05-08 | Pike | Ohio | 39131 | 7476 | 123 |
2482162 | 2482162 | 2022-05-07 | Pike | Ohio | 39131 | 7476 | 123 |
2478904 | 2478904 | 2022-05-06 | Pike | Ohio | 39131 | 7476 | 123 |
2475646 | 2475646 | 2022-05-05 | Pike | Ohio | 39131 | 7476 | 123 |
2472389 | 2472389 | 2022-05-04 | Pike | Ohio | 39131 | 7466 | 122 |
2469133 | 2469133 | 2022-05-03 | Pike | Ohio | 39131 | 7466 | 122 |
2465877 | 2465877 | 2022-05-02 | Pike | Ohio | 39131 | 7466 | 122 |
2462622 | 2462622 | 2022-05-01 | Pike | Ohio | 39131 | 7466 | 122 |
2459366 | 2459366 | 2022-04-30 | Pike | Ohio | 39131 | 7466 | 122 |
2456110 | 2456110 | 2022-04-29 | Pike | Ohio | 39131 | 7466 | 122 |
2452854 | 2452854 | 2022-04-28 | Pike | Ohio | 39131 | 7466 | 122 |
2449598 | 2449598 | 2022-04-27 | Pike | Ohio | 39131 | 7459 | 121 |
2446341 | 2446341 | 2022-04-26 | Pike | Ohio | 39131 | 7459 | 121 |
2443086 | 2443086 | 2022-04-25 | Pike | Ohio | 39131 | 7459 | 121 |
2439830 | 2439830 | 2022-04-24 | Pike | Ohio | 39131 | 7459 | 121 |
2436574 | 2436574 | 2022-04-23 | Pike | Ohio | 39131 | 7459 | 121 |
2433318 | 2433318 | 2022-04-22 | Pike | Ohio | 39131 | 7459 | 121 |
2430062 | 2430062 | 2022-04-21 | Pike | Ohio | 39131 | 7459 | 121 |
2426806 | 2426806 | 2022-04-20 | Pike | Ohio | 39131 | 7458 | 120 |
2423550 | 2423550 | 2022-04-19 | Pike | Ohio | 39131 | 7458 | 120 |
2420293 | 2420293 | 2022-04-18 | Pike | Ohio | 39131 | 7458 | 120 |
2417038 | 2417038 | 2022-04-17 | Pike | Ohio | 39131 | 7458 | 120 |
2413782 | 2413782 | 2022-04-16 | Pike | Ohio | 39131 | 7458 | 120 |
2410526 | 2410526 | 2022-04-15 | Pike | Ohio | 39131 | 7458 | 120 |
2407270 | 2407270 | 2022-04-14 | Pike | Ohio | 39131 | 7458 | 120 |
2404014 | 2404014 | 2022-04-13 | Pike | Ohio | 39131 | 7455 | 120 |
2400759 | 2400759 | 2022-04-12 | Pike | Ohio | 39131 | 7455 | 120 |
2397504 | 2397504 | 2022-04-11 | Pike | Ohio | 39131 | 7455 | 120 |
2394249 | 2394249 | 2022-04-10 | Pike | Ohio | 39131 | 7455 | 120 |
2390993 | 2390993 | 2022-04-09 | Pike | Ohio | 39131 | 7455 | 120 |
2387737 | 2387737 | 2022-04-08 | Pike | Ohio | 39131 | 7455 | 120 |
2384482 | 2384482 | 2022-04-07 | Pike | Ohio | 39131 | 7455 | 120 |
2381227 | 2381227 | 2022-04-06 | Pike | Ohio | 39131 | 7449 | 119 |
2377972 | 2377972 | 2022-04-05 | Pike | Ohio | 39131 | 7449 | 119 |
2374718 | 2374718 | 2022-04-04 | Pike | Ohio | 39131 | 7449 | 119 |
2371466 | 2371466 | 2022-04-03 | Pike | Ohio | 39131 | 7449 | 119 |
2368213 | 2368213 | 2022-04-02 | Pike | Ohio | 39131 | 7449 | 119 |
2364960 | 2364960 | 2022-04-01 | Pike | Ohio | 39131 | 7449 | 119 |
2361707 | 2361707 | 2022-03-31 | Pike | Ohio | 39131 | 7449 | 119 |
2358453 | 2358453 | 2022-03-30 | Pike | Ohio | 39131 | 7446 | 116 |
2355199 | 2355199 | 2022-03-29 | Pike | Ohio | 39131 | 7446 | 116 |
2351946 | 2351946 | 2022-03-28 | Pike | Ohio | 39131 | 7446 | 116 |
2348694 | 2348694 | 2022-03-27 | Pike | Ohio | 39131 | 7446 | 116 |
2345441 | 2345441 | 2022-03-26 | Pike | Ohio | 39131 | 7446 | 116 |
2342188 | 2342188 | 2022-03-25 | Pike | Ohio | 39131 | 7446 | 116 |
2338935 | 2338935 | 2022-03-24 | Pike | Ohio | 39131 | 7446 | 116 |
2335681 | 2335681 | 2022-03-23 | Pike | Ohio | 39131 | 7442 | 114 |
2332427 | 2332427 | 2022-03-22 | Pike | Ohio | 39131 | 7442 | 114 |
2329174 | 2329174 | 2022-03-21 | Pike | Ohio | 39131 | 7442 | 114 |
2325922 | 2325922 | 2022-03-20 | Pike | Ohio | 39131 | 7442 | 114 |
2322669 | 2322669 | 2022-03-19 | Pike | Ohio | 39131 | 7442 | 114 |
2319415 | 2319415 | 2022-03-18 | Pike | Ohio | 39131 | 7442 | 114 |
2316161 | 2316161 | 2022-03-17 | Pike | Ohio | 39131 | 7442 | 114 |
2312908 | 2312908 | 2022-03-16 | Pike | Ohio | 39131 | 7438 | 113 |
2309655 | 2309655 | 2022-03-15 | Pike | Ohio | 39131 | 7438 | 113 |
2306402 | 2306402 | 2022-03-14 | Pike | Ohio | 39131 | 7438 | 113 |
2303151 | 2303151 | 2022-03-13 | Pike | Ohio | 39131 | 7438 | 113 |
2299899 | 2299899 | 2022-03-12 | Pike | Ohio | 39131 | 7438 | 113 |
2296647 | 2296647 | 2022-03-11 | Pike | Ohio | 39131 | 7436 | 113 |
2293395 | 2293395 | 2022-03-10 | Pike | Ohio | 39131 | 7435 | 111 |
2290143 | 2290143 | 2022-03-09 | Pike | Ohio | 39131 | 7433 | 111 |
2286891 | 2286891 | 2022-03-08 | Pike | Ohio | 39131 | 7428 | 111 |
2283639 | 2283639 | 2022-03-07 | Pike | Ohio | 39131 | 7426 | 109 |
2280387 | 2280387 | 2022-03-06 | Pike | Ohio | 39131 | 7421 | 109 |
2277134 | 2277134 | 2022-03-05 | Pike | Ohio | 39131 | 7419 | 109 |
2273881 | 2273881 | 2022-03-04 | Pike | Ohio | 39131 | 7417 | 109 |
2270628 | 2270628 | 2022-03-03 | Pike | Ohio | 39131 | 7413 | 108 |
2267376 | 2267376 | 2022-03-02 | Pike | Ohio | 39131 | 7410 | 108 |
2264123 | 2264123 | 2022-03-01 | Pike | Ohio | 39131 | 7397 | 108 |
2260873 | 2260873 | 2022-02-28 | Pike | Ohio | 39131 | 7392 | 108 |
2257622 | 2257622 | 2022-02-27 | Pike | Ohio | 39131 | 7388 | 108 |
2254371 | 2254371 | 2022-02-26 | Pike | Ohio | 39131 | 7385 | 108 |
2251120 | 2251120 | 2022-02-25 | Pike | Ohio | 39131 | 7380 | 108 |
2247869 | 2247869 | 2022-02-24 | Pike | Ohio | 39131 | 7364 | 106 |
2244618 | 2244618 | 2022-02-23 | Pike | Ohio | 39131 | 7358 | 106 |
2241367 | 2241367 | 2022-02-22 | Pike | Ohio | 39131 | 7351 | 106 |
2238116 | 2238116 | 2022-02-21 | Pike | Ohio | 39131 | 7343 | 102 |
2234865 | 2234865 | 2022-02-20 | Pike | Ohio | 39131 | 7338 | 102 |
2231614 | 2231614 | 2022-02-19 | Pike | Ohio | 39131 | 7327 | 102 |
2228363 | 2228363 | 2022-02-18 | Pike | Ohio | 39131 | 7315 | 102 |
2225112 | 2225112 | 2022-02-17 | Pike | Ohio | 39131 | 7304 | 101 |
2221861 | 2221861 | 2022-02-16 | Pike | Ohio | 39131 | 7298 | 101 |
2218610 | 2218610 | 2022-02-15 | Pike | Ohio | 39131 | 7281 | 101 |
2215359 | 2215359 | 2022-02-14 | Pike | Ohio | 39131 | 7270 | 100 |
2212108 | 2212108 | 2022-02-13 | Pike | Ohio | 39131 | 7265 | 100 |
2208855 | 2208855 | 2022-02-12 | Pike | Ohio | 39131 | 7261 | 100 |
2205602 | 2205602 | 2022-02-11 | Pike | Ohio | 39131 | 7251 | 100 |
2202349 | 2202349 | 2022-02-10 | Pike | Ohio | 39131 | 7233 | 98 |
2199095 | 2199095 | 2022-02-09 | Pike | Ohio | 39131 | 7213 | 98 |
2195841 | 2195841 | 2022-02-08 | Pike | Ohio | 39131 | 7193 | 98 |
2192587 | 2192587 | 2022-02-07 | Pike | Ohio | 39131 | 7166 | 94 |
2189333 | 2189333 | 2022-02-06 | Pike | Ohio | 39131 | 7140 | 94 |
2186080 | 2186080 | 2022-02-05 | Pike | Ohio | 39131 | 7131 | 94 |
2182828 | 2182828 | 2022-02-04 | Pike | Ohio | 39131 | 7112 | 94 |
2179576 | 2179576 | 2022-02-03 | Pike | Ohio | 39131 | 7089 | 93 |
Advanced export
JSON shape: default, array, newline-delimited
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);