ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 39001 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501644 | 2501644 | 2022-05-13 | Adams | Ohio | 39001 | 7022 | 148 |
2498386 | 2498386 | 2022-05-12 | Adams | Ohio | 39001 | 7022 | 148 |
2495128 | 2495128 | 2022-05-11 | Adams | Ohio | 39001 | 6999 | 148 |
2491870 | 2491870 | 2022-05-10 | Adams | Ohio | 39001 | 6999 | 148 |
2488612 | 2488612 | 2022-05-09 | Adams | Ohio | 39001 | 6999 | 148 |
2485355 | 2485355 | 2022-05-08 | Adams | Ohio | 39001 | 6999 | 148 |
2482097 | 2482097 | 2022-05-07 | Adams | Ohio | 39001 | 6999 | 148 |
2478839 | 2478839 | 2022-05-06 | Adams | Ohio | 39001 | 6999 | 148 |
2475581 | 2475581 | 2022-05-05 | Adams | Ohio | 39001 | 6999 | 148 |
2472324 | 2472324 | 2022-05-04 | Adams | Ohio | 39001 | 6986 | 148 |
2469068 | 2469068 | 2022-05-03 | Adams | Ohio | 39001 | 6986 | 148 |
2465812 | 2465812 | 2022-05-02 | Adams | Ohio | 39001 | 6986 | 148 |
2462557 | 2462557 | 2022-05-01 | Adams | Ohio | 39001 | 6986 | 148 |
2459301 | 2459301 | 2022-04-30 | Adams | Ohio | 39001 | 6986 | 148 |
2456045 | 2456045 | 2022-04-29 | Adams | Ohio | 39001 | 6986 | 148 |
2452789 | 2452789 | 2022-04-28 | Adams | Ohio | 39001 | 6986 | 148 |
2449533 | 2449533 | 2022-04-27 | Adams | Ohio | 39001 | 6980 | 148 |
2446276 | 2446276 | 2022-04-26 | Adams | Ohio | 39001 | 6980 | 148 |
2443021 | 2443021 | 2022-04-25 | Adams | Ohio | 39001 | 6980 | 148 |
2439765 | 2439765 | 2022-04-24 | Adams | Ohio | 39001 | 6980 | 148 |
2436509 | 2436509 | 2022-04-23 | Adams | Ohio | 39001 | 6980 | 148 |
2433253 | 2433253 | 2022-04-22 | Adams | Ohio | 39001 | 6980 | 148 |
2429997 | 2429997 | 2022-04-21 | Adams | Ohio | 39001 | 6980 | 148 |
2426741 | 2426741 | 2022-04-20 | Adams | Ohio | 39001 | 6971 | 147 |
2423485 | 2423485 | 2022-04-19 | Adams | Ohio | 39001 | 6971 | 147 |
2420228 | 2420228 | 2022-04-18 | Adams | Ohio | 39001 | 6971 | 147 |
2416973 | 2416973 | 2022-04-17 | Adams | Ohio | 39001 | 6971 | 147 |
2413717 | 2413717 | 2022-04-16 | Adams | Ohio | 39001 | 6971 | 147 |
2410461 | 2410461 | 2022-04-15 | Adams | Ohio | 39001 | 6971 | 147 |
2407205 | 2407205 | 2022-04-14 | Adams | Ohio | 39001 | 6971 | 147 |
2403949 | 2403949 | 2022-04-13 | Adams | Ohio | 39001 | 6966 | 146 |
2400694 | 2400694 | 2022-04-12 | Adams | Ohio | 39001 | 6966 | 146 |
2397439 | 2397439 | 2022-04-11 | Adams | Ohio | 39001 | 6966 | 146 |
2394184 | 2394184 | 2022-04-10 | Adams | Ohio | 39001 | 6966 | 146 |
2390928 | 2390928 | 2022-04-09 | Adams | Ohio | 39001 | 6966 | 146 |
2387672 | 2387672 | 2022-04-08 | Adams | Ohio | 39001 | 6966 | 146 |
2384417 | 2384417 | 2022-04-07 | Adams | Ohio | 39001 | 6966 | 146 |
2381162 | 2381162 | 2022-04-06 | Adams | Ohio | 39001 | 6948 | 145 |
2377907 | 2377907 | 2022-04-05 | Adams | Ohio | 39001 | 6948 | 145 |
2374653 | 2374653 | 2022-04-04 | Adams | Ohio | 39001 | 6948 | 145 |
2371401 | 2371401 | 2022-04-03 | Adams | Ohio | 39001 | 6948 | 145 |
2368148 | 2368148 | 2022-04-02 | Adams | Ohio | 39001 | 6948 | 145 |
2364895 | 2364895 | 2022-04-01 | Adams | Ohio | 39001 | 6948 | 145 |
2361642 | 2361642 | 2022-03-31 | Adams | Ohio | 39001 | 6948 | 145 |
2358388 | 2358388 | 2022-03-30 | Adams | Ohio | 39001 | 6931 | 142 |
2355134 | 2355134 | 2022-03-29 | Adams | Ohio | 39001 | 6931 | 142 |
2351881 | 2351881 | 2022-03-28 | Adams | Ohio | 39001 | 6931 | 142 |
2348629 | 2348629 | 2022-03-27 | Adams | Ohio | 39001 | 6931 | 142 |
2345376 | 2345376 | 2022-03-26 | Adams | Ohio | 39001 | 6931 | 142 |
2342123 | 2342123 | 2022-03-25 | Adams | Ohio | 39001 | 6931 | 142 |
2338870 | 2338870 | 2022-03-24 | Adams | Ohio | 39001 | 6931 | 142 |
2335616 | 2335616 | 2022-03-23 | Adams | Ohio | 39001 | 6918 | 141 |
2332362 | 2332362 | 2022-03-22 | Adams | Ohio | 39001 | 6918 | 141 |
2329109 | 2329109 | 2022-03-21 | Adams | Ohio | 39001 | 6918 | 141 |
2325857 | 2325857 | 2022-03-20 | Adams | Ohio | 39001 | 6918 | 141 |
2322604 | 2322604 | 2022-03-19 | Adams | Ohio | 39001 | 6918 | 141 |
2319350 | 2319350 | 2022-03-18 | Adams | Ohio | 39001 | 6918 | 141 |
2316096 | 2316096 | 2022-03-17 | Adams | Ohio | 39001 | 6918 | 141 |
2312843 | 2312843 | 2022-03-16 | Adams | Ohio | 39001 | 6915 | 141 |
2309590 | 2309590 | 2022-03-15 | Adams | Ohio | 39001 | 6915 | 141 |
2306337 | 2306337 | 2022-03-14 | Adams | Ohio | 39001 | 6915 | 141 |
2303086 | 2303086 | 2022-03-13 | Adams | Ohio | 39001 | 6915 | 141 |
2299834 | 2299834 | 2022-03-12 | Adams | Ohio | 39001 | 6915 | 141 |
2296582 | 2296582 | 2022-03-11 | Adams | Ohio | 39001 | 6917 | 141 |
2293330 | 2293330 | 2022-03-10 | Adams | Ohio | 39001 | 6917 | 139 |
2290078 | 2290078 | 2022-03-09 | Adams | Ohio | 39001 | 6914 | 139 |
2286826 | 2286826 | 2022-03-08 | Adams | Ohio | 39001 | 6910 | 139 |
2283574 | 2283574 | 2022-03-07 | Adams | Ohio | 39001 | 6911 | 138 |
2280322 | 2280322 | 2022-03-06 | Adams | Ohio | 39001 | 6911 | 138 |
2277069 | 2277069 | 2022-03-05 | Adams | Ohio | 39001 | 6911 | 138 |
2273816 | 2273816 | 2022-03-04 | Adams | Ohio | 39001 | 6906 | 138 |
2270563 | 2270563 | 2022-03-03 | Adams | Ohio | 39001 | 6903 | 138 |
2267311 | 2267311 | 2022-03-02 | Adams | Ohio | 39001 | 6899 | 138 |
2264058 | 2264058 | 2022-03-01 | Adams | Ohio | 39001 | 6896 | 138 |
2260808 | 2260808 | 2022-02-28 | Adams | Ohio | 39001 | 6891 | 138 |
2257557 | 2257557 | 2022-02-27 | Adams | Ohio | 39001 | 6889 | 138 |
2254306 | 2254306 | 2022-02-26 | Adams | Ohio | 39001 | 6887 | 138 |
2251055 | 2251055 | 2022-02-25 | Adams | Ohio | 39001 | 6885 | 138 |
2247804 | 2247804 | 2022-02-24 | Adams | Ohio | 39001 | 6872 | 137 |
2244553 | 2244553 | 2022-02-23 | Adams | Ohio | 39001 | 6868 | 137 |
2241302 | 2241302 | 2022-02-22 | Adams | Ohio | 39001 | 6864 | 137 |
2238051 | 2238051 | 2022-02-21 | Adams | Ohio | 39001 | 6857 | 136 |
2234800 | 2234800 | 2022-02-20 | Adams | Ohio | 39001 | 6855 | 136 |
2231549 | 2231549 | 2022-02-19 | Adams | Ohio | 39001 | 6853 | 136 |
2228298 | 2228298 | 2022-02-18 | Adams | Ohio | 39001 | 6850 | 136 |
2225047 | 2225047 | 2022-02-17 | Adams | Ohio | 39001 | 6841 | 136 |
2221796 | 2221796 | 2022-02-16 | Adams | Ohio | 39001 | 6837 | 136 |
2218545 | 2218545 | 2022-02-15 | Adams | Ohio | 39001 | 6819 | 136 |
2215294 | 2215294 | 2022-02-14 | Adams | Ohio | 39001 | 6809 | 134 |
2212043 | 2212043 | 2022-02-13 | Adams | Ohio | 39001 | 6804 | 134 |
2208790 | 2208790 | 2022-02-12 | Adams | Ohio | 39001 | 6796 | 134 |
2205537 | 2205537 | 2022-02-11 | Adams | Ohio | 39001 | 6788 | 134 |
2202284 | 2202284 | 2022-02-10 | Adams | Ohio | 39001 | 6775 | 133 |
2199030 | 2199030 | 2022-02-09 | Adams | Ohio | 39001 | 6757 | 133 |
2195776 | 2195776 | 2022-02-08 | Adams | Ohio | 39001 | 6732 | 133 |
2192522 | 2192522 | 2022-02-07 | Adams | Ohio | 39001 | 6711 | 132 |
2189268 | 2189268 | 2022-02-06 | Adams | Ohio | 39001 | 6690 | 132 |
2186015 | 2186015 | 2022-02-05 | Adams | Ohio | 39001 | 6685 | 132 |
2182763 | 2182763 | 2022-02-04 | Adams | Ohio | 39001 | 6675 | 132 |
2179511 | 2179511 | 2022-02-03 | Adams | Ohio | 39001 | 6667 | 132 |
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);