ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where deaths = 175 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 |
---|---|---|---|---|---|---|---|
2358395 | 2358395 | 2022-03-30 | Brown | Ohio | 39015 | 11171 | 175 |
2355141 | 2355141 | 2022-03-29 | Brown | Ohio | 39015 | 11171 | 175 |
2351888 | 2351888 | 2022-03-28 | Brown | Ohio | 39015 | 11171 | 175 |
2348636 | 2348636 | 2022-03-27 | Brown | Ohio | 39015 | 11171 | 175 |
2345383 | 2345383 | 2022-03-26 | Brown | Ohio | 39015 | 11171 | 175 |
2342130 | 2342130 | 2022-03-25 | Brown | Ohio | 39015 | 11171 | 175 |
2338877 | 2338877 | 2022-03-24 | Brown | Ohio | 39015 | 11171 | 175 |
2293355 | 2293355 | 2022-03-10 | Fulton | Ohio | 39051 | 10294 | 175 |
2293365 | 2293365 | 2022-03-10 | Highland | Ohio | 39071 | 10590 | 175 |
2290103 | 2290103 | 2022-03-09 | Fulton | Ohio | 39051 | 10295 | 175 |
2290113 | 2290113 | 2022-03-09 | Highland | Ohio | 39071 | 10587 | 175 |
2286851 | 2286851 | 2022-03-08 | Fulton | Ohio | 39051 | 10291 | 175 |
2286861 | 2286861 | 2022-03-08 | Highland | Ohio | 39071 | 10583 | 175 |
2169821 | 2169821 | 2022-01-31 | Preble | Ohio | 39135 | 8917 | 175 |
2166566 | 2166566 | 2022-01-30 | Preble | Ohio | 39135 | 8891 | 175 |
2163311 | 2163311 | 2022-01-29 | Preble | Ohio | 39135 | 8863 | 175 |
2160056 | 2160056 | 2022-01-28 | Preble | Ohio | 39135 | 8804 | 175 |
2133974 | 2133974 | 2022-01-20 | Crawford | Ohio | 39033 | 10172 | 175 |
2130722 | 2130722 | 2022-01-19 | Crawford | Ohio | 39033 | 10062 | 175 |
2127468 | 2127468 | 2022-01-18 | Crawford | Ohio | 39033 | 9949 | 175 |
2124216 | 2124216 | 2022-01-17 | Crawford | Ohio | 39033 | 9854 | 175 |
2120964 | 2120964 | 2022-01-16 | Crawford | Ohio | 39033 | 9806 | 175 |
2117712 | 2117712 | 2022-01-15 | Crawford | Ohio | 39033 | 9697 | 175 |
2114461 | 2114461 | 2022-01-14 | Crawford | Ohio | 39033 | 9505 | 175 |
2088470 | 2088470 | 2022-01-06 | Huron | Ohio | 39077 | 12009 | 175 |
2085219 | 2085219 | 2022-01-05 | Huron | Ohio | 39077 | 11881 | 175 |
2081967 | 2081967 | 2022-01-04 | Huron | Ohio | 39077 | 11774 | 175 |
2055997 | 2055997 | 2021-12-27 | Seneca | Ohio | 39147 | 9704 | 175 |
2052748 | 2052748 | 2021-12-26 | Seneca | Ohio | 39147 | 9688 | 175 |
2049498 | 2049498 | 2021-12-25 | Seneca | Ohio | 39147 | 9648 | 175 |
2046248 | 2046248 | 2021-12-24 | Seneca | Ohio | 39147 | 9648 | 175 |
1987696 | 1987696 | 2021-12-06 | Hancock | Ohio | 39063 | 11659 | 175 |
1984446 | 1984446 | 2021-12-05 | Hancock | Ohio | 39063 | 11623 | 175 |
1981196 | 1981196 | 2021-12-04 | Hancock | Ohio | 39063 | 11587 | 175 |
1977946 | 1977946 | 2021-12-03 | Hancock | Ohio | 39063 | 11529 | 175 |
1974692 | 1974692 | 2021-12-02 | Geauga | Ohio | 39055 | 10863 | 175 |
1971443 | 1971443 | 2021-12-01 | Geauga | Ohio | 39055 | 10804 | 175 |
1968193 | 1968193 | 2021-11-30 | Geauga | Ohio | 39055 | 10726 | 175 |
1838220 | 1838220 | 2021-10-21 | Marion | Ohio | 39101 | 11906 | 175 |
1834971 | 1834971 | 2021-10-20 | Marion | Ohio | 39101 | 11864 | 175 |
1831722 | 1831722 | 2021-10-19 | Marion | Ohio | 39101 | 11831 | 175 |
1828473 | 1828473 | 2021-10-18 | Marion | Ohio | 39101 | 11797 | 175 |
1825224 | 1825224 | 2021-10-17 | Marion | Ohio | 39101 | 11770 | 175 |
1821975 | 1821975 | 2021-10-16 | Marion | Ohio | 39101 | 11760 | 175 |
1818726 | 1818726 | 2021-10-15 | Marion | Ohio | 39101 | 11742 | 175 |
1782958 | 1782958 | 2021-10-04 | Erie | Ohio | 39043 | 10187 | 175 |
1779709 | 1779709 | 2021-10-03 | Erie | Ohio | 39043 | 10157 | 175 |
1776459 | 1776459 | 2021-10-02 | Erie | Ohio | 39043 | 10141 | 175 |
1773209 | 1773209 | 2021-10-01 | Erie | Ohio | 39043 | 10050 | 175 |
1760231 | 1760231 | 2021-09-27 | Jefferson | Ohio | 39081 | 7785 | 175 |
1756983 | 1756983 | 2021-09-26 | Jefferson | Ohio | 39081 | 7736 | 175 |
1753735 | 1753735 | 2021-09-25 | Jefferson | Ohio | 39081 | 7691 | 175 |
1750487 | 1750487 | 2021-09-24 | Jefferson | Ohio | 39081 | 7635 | 175 |
1039350 | 1039350 | 2021-02-17 | Columbiana | Ohio | 39029 | 7942 | 175 |
1039390 | 1039390 | 2021-02-17 | Miami | Ohio | 39109 | 9853 | 175 |
1036105 | 1036105 | 2021-02-16 | Columbiana | Ohio | 39029 | 7932 | 175 |
1036145 | 1036145 | 2021-02-16 | Miami | Ohio | 39109 | 9851 | 175 |
1032860 | 1032860 | 2021-02-15 | Columbiana | Ohio | 39029 | 7911 | 175 |
1032900 | 1032900 | 2021-02-15 | Miami | Ohio | 39109 | 9834 | 175 |
1029614 | 1029614 | 2021-02-14 | Columbiana | Ohio | 39029 | 7902 | 175 |
993982 | 993982 | 2021-02-03 | Wayne | Ohio | 39169 | 7433 | 175 |
990736 | 990736 | 2021-02-02 | Wayne | Ohio | 39169 | 7397 | 175 |
585139 | 585139 | 2020-09-30 | Stark | Ohio | 39151 | 2956 | 175 |
581899 | 581899 | 2020-09-29 | Stark | Ohio | 39151 | 2946 | 175 |
578659 | 578659 | 2020-09-28 | Stark | Ohio | 39151 | 2913 | 175 |
575418 | 575418 | 2020-09-27 | Stark | Ohio | 39151 | 2883 | 175 |
572174 | 572174 | 2020-09-26 | Stark | Ohio | 39151 | 2872 | 175 |
568932 | 568932 | 2020-09-25 | Stark | Ohio | 39151 | 2838 | 175 |
156153 | 156153 | 2020-05-18 | Cuyahoga | Ohio | 39035 | 3410 | 175 |
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);