ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
177 rows where deaths = 125 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501707 | 2501707 | 2022-05-13 | Perry | Ohio | 39127 | 8356 | 125 |
2498449 | 2498449 | 2022-05-12 | Perry | Ohio | 39127 | 8356 | 125 |
2495191 | 2495191 | 2022-05-11 | Perry | Ohio | 39127 | 8339 | 125 |
2491933 | 2491933 | 2022-05-10 | Perry | Ohio | 39127 | 8339 | 125 |
2488675 | 2488675 | 2022-05-09 | Perry | Ohio | 39127 | 8339 | 125 |
2485418 | 2485418 | 2022-05-08 | Perry | Ohio | 39127 | 8339 | 125 |
2482160 | 2482160 | 2022-05-07 | Perry | Ohio | 39127 | 8339 | 125 |
2478902 | 2478902 | 2022-05-06 | Perry | Ohio | 39127 | 8339 | 125 |
2475644 | 2475644 | 2022-05-05 | Perry | Ohio | 39127 | 8339 | 125 |
2472387 | 2472387 | 2022-05-04 | Perry | Ohio | 39127 | 8326 | 125 |
2469131 | 2469131 | 2022-05-03 | Perry | Ohio | 39127 | 8326 | 125 |
2465875 | 2465875 | 2022-05-02 | Perry | Ohio | 39127 | 8326 | 125 |
2462620 | 2462620 | 2022-05-01 | Perry | Ohio | 39127 | 8326 | 125 |
2459364 | 2459364 | 2022-04-30 | Perry | Ohio | 39127 | 8326 | 125 |
2456108 | 2456108 | 2022-04-29 | Perry | Ohio | 39127 | 8326 | 125 |
2452852 | 2452852 | 2022-04-28 | Perry | Ohio | 39127 | 8326 | 125 |
2449596 | 2449596 | 2022-04-27 | Perry | Ohio | 39127 | 8318 | 125 |
2446339 | 2446339 | 2022-04-26 | Perry | Ohio | 39127 | 8318 | 125 |
2443084 | 2443084 | 2022-04-25 | Perry | Ohio | 39127 | 8318 | 125 |
2439828 | 2439828 | 2022-04-24 | Perry | Ohio | 39127 | 8318 | 125 |
2436572 | 2436572 | 2022-04-23 | Perry | Ohio | 39127 | 8318 | 125 |
2433316 | 2433316 | 2022-04-22 | Perry | Ohio | 39127 | 8318 | 125 |
2430060 | 2430060 | 2022-04-21 | Perry | Ohio | 39127 | 8318 | 125 |
2426767 | 2426767 | 2022-04-20 | Gallia | Ohio | 39053 | 7488 | 125 |
2426804 | 2426804 | 2022-04-20 | Perry | Ohio | 39127 | 8302 | 125 |
2423511 | 2423511 | 2022-04-19 | Gallia | Ohio | 39053 | 7488 | 125 |
2423548 | 2423548 | 2022-04-19 | Perry | Ohio | 39127 | 8302 | 125 |
2420254 | 2420254 | 2022-04-18 | Gallia | Ohio | 39053 | 7488 | 125 |
2420291 | 2420291 | 2022-04-18 | Perry | Ohio | 39127 | 8302 | 125 |
2416999 | 2416999 | 2022-04-17 | Gallia | Ohio | 39053 | 7488 | 125 |
2417036 | 2417036 | 2022-04-17 | Perry | Ohio | 39127 | 8302 | 125 |
2413743 | 2413743 | 2022-04-16 | Gallia | Ohio | 39053 | 7488 | 125 |
2413780 | 2413780 | 2022-04-16 | Perry | Ohio | 39127 | 8302 | 125 |
2410487 | 2410487 | 2022-04-15 | Gallia | Ohio | 39053 | 7488 | 125 |
2410524 | 2410524 | 2022-04-15 | Perry | Ohio | 39127 | 8302 | 125 |
2407231 | 2407231 | 2022-04-14 | Gallia | Ohio | 39053 | 7488 | 125 |
2407268 | 2407268 | 2022-04-14 | Perry | Ohio | 39127 | 8302 | 125 |
2403958 | 2403958 | 2022-04-13 | Carroll | Ohio | 39019 | 5253 | 125 |
2400703 | 2400703 | 2022-04-12 | Carroll | Ohio | 39019 | 5253 | 125 |
2397448 | 2397448 | 2022-04-11 | Carroll | Ohio | 39019 | 5253 | 125 |
2394193 | 2394193 | 2022-04-10 | Carroll | Ohio | 39019 | 5253 | 125 |
2390937 | 2390937 | 2022-04-09 | Carroll | Ohio | 39019 | 5253 | 125 |
2387681 | 2387681 | 2022-04-08 | Carroll | Ohio | 39019 | 5253 | 125 |
2384426 | 2384426 | 2022-04-07 | Carroll | Ohio | 39019 | 5253 | 125 |
2381171 | 2381171 | 2022-04-06 | Carroll | Ohio | 39019 | 5253 | 125 |
2377916 | 2377916 | 2022-04-05 | Carroll | Ohio | 39019 | 5253 | 125 |
2374662 | 2374662 | 2022-04-04 | Carroll | Ohio | 39019 | 5253 | 125 |
2371410 | 2371410 | 2022-04-03 | Carroll | Ohio | 39019 | 5253 | 125 |
2368157 | 2368157 | 2022-04-02 | Carroll | Ohio | 39019 | 5253 | 125 |
2364904 | 2364904 | 2022-04-01 | Carroll | Ohio | 39019 | 5253 | 125 |
2361651 | 2361651 | 2022-03-31 | Carroll | Ohio | 39019 | 5253 | 125 |
2270611 | 2270611 | 2022-03-03 | Madison | Ohio | 39097 | 9614 | 125 |
2267359 | 2267359 | 2022-03-02 | Madison | Ohio | 39097 | 9614 | 125 |
2264106 | 2264106 | 2022-03-01 | Madison | Ohio | 39097 | 9611 | 125 |
2260856 | 2260856 | 2022-02-28 | Madison | Ohio | 39097 | 9607 | 125 |
2257605 | 2257605 | 2022-02-27 | Madison | Ohio | 39097 | 9606 | 125 |
2254354 | 2254354 | 2022-02-26 | Madison | Ohio | 39097 | 9606 | 125 |
2251103 | 2251103 | 2022-02-25 | Madison | Ohio | 39097 | 9604 | 125 |
2238104 | 2238104 | 2022-02-21 | Mercer | Ohio | 39107 | 9618 | 125 |
2234853 | 2234853 | 2022-02-20 | Mercer | Ohio | 39107 | 9613 | 125 |
2231602 | 2231602 | 2022-02-19 | Mercer | Ohio | 39107 | 9613 | 125 |
2228351 | 2228351 | 2022-02-18 | Mercer | Ohio | 39107 | 9603 | 125 |
2225100 | 2225100 | 2022-02-17 | Mercer | Ohio | 39107 | 9598 | 125 |
2221849 | 2221849 | 2022-02-16 | Mercer | Ohio | 39107 | 9593 | 125 |
2218598 | 2218598 | 2022-02-15 | Mercer | Ohio | 39107 | 9586 | 125 |
2179550 | 2179550 | 2022-02-03 | Jackson | Ohio | 39079 | 8366 | 125 |
2176299 | 2176299 | 2022-02-02 | Jackson | Ohio | 39079 | 8315 | 125 |
2173045 | 2173045 | 2022-02-01 | Jackson | Ohio | 39079 | 8254 | 125 |
2169793 | 2169793 | 2022-01-31 | Jackson | Ohio | 39079 | 8198 | 125 |
2169815 | 2169815 | 2022-01-31 | Ottawa | Ohio | 39123 | 8135 | 125 |
2166538 | 2166538 | 2022-01-30 | Jackson | Ohio | 39079 | 8169 | 125 |
2166560 | 2166560 | 2022-01-30 | Ottawa | Ohio | 39123 | 8127 | 125 |
2163283 | 2163283 | 2022-01-29 | Jackson | Ohio | 39079 | 8136 | 125 |
2163305 | 2163305 | 2022-01-29 | Ottawa | Ohio | 39123 | 8107 | 125 |
2160028 | 2160028 | 2022-01-28 | Jackson | Ohio | 39079 | 8069 | 125 |
2160050 | 2160050 | 2022-01-28 | Ottawa | Ohio | 39123 | 8082 | 125 |
2124232 | 2124232 | 2022-01-17 | Hardin | Ohio | 39065 | 6219 | 125 |
2120980 | 2120980 | 2022-01-16 | Hardin | Ohio | 39065 | 6160 | 125 |
2117728 | 2117728 | 2022-01-15 | Hardin | Ohio | 39065 | 6094 | 125 |
2114477 | 2114477 | 2022-01-14 | Hardin | Ohio | 39065 | 5958 | 125 |
2065688 | 2065688 | 2021-12-30 | Coshocton | Ohio | 39031 | 6104 | 125 |
2065692 | 2065692 | 2021-12-30 | Defiance | Ohio | 39039 | 7993 | 125 |
2062438 | 2062438 | 2021-12-29 | Coshocton | Ohio | 39031 | 6084 | 125 |
2062442 | 2062442 | 2021-12-29 | Defiance | Ohio | 39039 | 7973 | 125 |
2059188 | 2059188 | 2021-12-28 | Coshocton | Ohio | 39031 | 6052 | 125 |
2059192 | 2059192 | 2021-12-28 | Defiance | Ohio | 39039 | 7935 | 125 |
2055939 | 2055939 | 2021-12-27 | Coshocton | Ohio | 39031 | 6036 | 125 |
2055943 | 2055943 | 2021-12-27 | Defiance | Ohio | 39039 | 7913 | 125 |
2052690 | 2052690 | 2021-12-26 | Coshocton | Ohio | 39031 | 6026 | 125 |
2052694 | 2052694 | 2021-12-26 | Defiance | Ohio | 39039 | 7910 | 125 |
2049440 | 2049440 | 2021-12-25 | Coshocton | Ohio | 39031 | 6009 | 125 |
2049444 | 2049444 | 2021-12-25 | Defiance | Ohio | 39039 | 7885 | 125 |
2046190 | 2046190 | 2021-12-24 | Coshocton | Ohio | 39031 | 6009 | 125 |
2046194 | 2046194 | 2021-12-24 | Defiance | Ohio | 39039 | 7885 | 125 |
2020208 | 2020208 | 2021-12-16 | Highland | Ohio | 39071 | 7107 | 125 |
2016957 | 2016957 | 2021-12-15 | Highland | Ohio | 39071 | 7050 | 125 |
2013707 | 2013707 | 2021-12-14 | Highland | Ohio | 39071 | 7020 | 125 |
1883733 | 1883733 | 2021-11-04 | Shelby | Ohio | 39149 | 6743 | 125 |
1880484 | 1880484 | 2021-11-03 | Shelby | Ohio | 39149 | 6725 | 125 |
1877235 | 1877235 | 2021-11-02 | Shelby | Ohio | 39149 | 6698 | 125 |
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);