ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where deaths = 111 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 |
---|---|---|---|---|---|---|---|
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 |
2270586 | 2270586 | 2022-03-03 | Fayette | Ohio | 39047 | 7752 | 111 |
2267334 | 2267334 | 2022-03-02 | Fayette | Ohio | 39047 | 7749 | 111 |
2264081 | 2264081 | 2022-03-01 | Fayette | Ohio | 39047 | 7748 | 111 |
2238087 | 2238087 | 2022-02-21 | Hocking | Ohio | 39073 | 6469 | 111 |
2234836 | 2234836 | 2022-02-20 | Hocking | Ohio | 39073 | 6464 | 111 |
2231585 | 2231585 | 2022-02-19 | Hocking | Ohio | 39073 | 6461 | 111 |
2228334 | 2228334 | 2022-02-18 | Hocking | Ohio | 39073 | 6455 | 111 |
2225083 | 2225083 | 2022-02-17 | Hocking | Ohio | 39073 | 6451 | 111 |
2221832 | 2221832 | 2022-02-16 | Hocking | Ohio | 39073 | 6444 | 111 |
2218581 | 2218581 | 2022-02-15 | Hocking | Ohio | 39073 | 6431 | 111 |
2215330 | 2215330 | 2022-02-14 | Hocking | Ohio | 39073 | 6426 | 111 |
2212079 | 2212079 | 2022-02-13 | Hocking | Ohio | 39073 | 6421 | 111 |
2208826 | 2208826 | 2022-02-12 | Hocking | Ohio | 39073 | 6419 | 111 |
2205573 | 2205573 | 2022-02-11 | Hocking | Ohio | 39073 | 6407 | 111 |
2202320 | 2202320 | 2022-02-10 | Hocking | Ohio | 39073 | 6386 | 111 |
2199066 | 2199066 | 2022-02-09 | Hocking | Ohio | 39073 | 6377 | 111 |
2195812 | 2195812 | 2022-02-08 | Hocking | Ohio | 39073 | 6361 | 111 |
2169758 | 2169758 | 2022-01-31 | Athens | Ohio | 39009 | 13418 | 111 |
2166503 | 2166503 | 2022-01-30 | Athens | Ohio | 39009 | 13382 | 111 |
2163248 | 2163248 | 2022-01-29 | Athens | Ohio | 39009 | 13340 | 111 |
2159993 | 2159993 | 2022-01-28 | Athens | Ohio | 39009 | 13257 | 111 |
2147025 | 2147025 | 2022-01-24 | Madison | Ohio | 39097 | 9032 | 111 |
2143771 | 2143771 | 2022-01-23 | Madison | Ohio | 39097 | 9007 | 111 |
2140516 | 2140516 | 2022-01-22 | Madison | Ohio | 39097 | 8971 | 111 |
2137260 | 2137260 | 2022-01-21 | Madison | Ohio | 39097 | 8913 | 111 |
2134011 | 2134011 | 2022-01-20 | Mercer | Ohio | 39107 | 8902 | 111 |
2130759 | 2130759 | 2022-01-19 | Mercer | Ohio | 39107 | 8816 | 111 |
2127505 | 2127505 | 2022-01-18 | Mercer | Ohio | 39107 | 8709 | 111 |
2124253 | 2124253 | 2022-01-17 | Mercer | Ohio | 39107 | 8640 | 111 |
2121001 | 2121001 | 2022-01-16 | Mercer | Ohio | 39107 | 8603 | 111 |
2117749 | 2117749 | 2022-01-15 | Mercer | Ohio | 39107 | 8533 | 111 |
2114498 | 2114498 | 2022-01-14 | Mercer | Ohio | 39107 | 8302 | 111 |
2111222 | 2111222 | 2022-01-13 | Guernsey | Ohio | 39059 | 8598 | 111 |
2107970 | 2107970 | 2022-01-12 | Guernsey | Ohio | 39059 | 8493 | 111 |
2104719 | 2104719 | 2022-01-11 | Guernsey | Ohio | 39059 | 8444 | 111 |
2101478 | 2101478 | 2022-01-10 | Jackson | Ohio | 39079 | 6778 | 111 |
2098227 | 2098227 | 2022-01-09 | Jackson | Ohio | 39079 | 6722 | 111 |
2094975 | 2094975 | 2022-01-08 | Jackson | Ohio | 39079 | 6713 | 111 |
2091723 | 2091723 | 2022-01-07 | Jackson | Ohio | 39079 | 6651 | 111 |
2010421 | 2010421 | 2021-12-13 | Adams | Ohio | 39001 | 4738 | 111 |
2007170 | 2007170 | 2021-12-12 | Adams | Ohio | 39001 | 4724 | 111 |
2003919 | 2003919 | 2021-12-11 | Adams | Ohio | 39001 | 4721 | 111 |
2000668 | 2000668 | 2021-12-10 | Adams | Ohio | 39001 | 4705 | 111 |
1997418 | 1997418 | 2021-12-09 | Adams | Ohio | 39001 | 4695 | 111 |
1997433 | 1997433 | 2021-12-09 | Coshocton | Ohio | 39031 | 5786 | 111 |
1994167 | 1994167 | 2021-12-08 | Adams | Ohio | 39001 | 4671 | 111 |
1994182 | 1994182 | 2021-12-08 | Coshocton | Ohio | 39031 | 5757 | 111 |
1990916 | 1990916 | 2021-12-07 | Adams | Ohio | 39001 | 4655 | 111 |
1990931 | 1990931 | 2021-12-07 | Coshocton | Ohio | 39031 | 5733 | 111 |
1987710 | 1987710 | 2021-12-06 | Logan | Ohio | 39091 | 7087 | 111 |
1984460 | 1984460 | 2021-12-05 | Logan | Ohio | 39091 | 7061 | 111 |
1981210 | 1981210 | 2021-12-04 | Logan | Ohio | 39091 | 7045 | 111 |
1977960 | 1977960 | 2021-12-03 | Logan | Ohio | 39091 | 7003 | 111 |
1964940 | 1964940 | 2021-11-29 | Fulton | Ohio | 39051 | 7016 | 111 |
1961688 | 1961688 | 2021-11-28 | Fulton | Ohio | 39051 | 6963 | 111 |
1958437 | 1958437 | 2021-11-27 | Fulton | Ohio | 39051 | 6953 | 111 |
1955186 | 1955186 | 2021-11-26 | Fulton | Ohio | 39051 | 6939 | 111 |
1951915 | 1951915 | 2021-11-25 | Auglaize | Ohio | 39011 | 7644 | 111 |
1951935 | 1951935 | 2021-11-25 | Fulton | Ohio | 39051 | 6905 | 111 |
1948664 | 1948664 | 2021-11-24 | Auglaize | Ohio | 39011 | 7644 | 111 |
1948684 | 1948684 | 2021-11-24 | Fulton | Ohio | 39051 | 6905 | 111 |
1945413 | 1945413 | 2021-11-23 | Auglaize | Ohio | 39011 | 7607 | 111 |
1945433 | 1945433 | 2021-11-23 | Fulton | Ohio | 39051 | 6870 | 111 |
1942162 | 1942162 | 2021-11-22 | Auglaize | Ohio | 39011 | 7566 | 111 |
1938912 | 1938912 | 2021-11-21 | Auglaize | Ohio | 39011 | 7549 | 111 |
1935662 | 1935662 | 2021-11-20 | Auglaize | Ohio | 39011 | 7531 | 111 |
1932412 | 1932412 | 2021-11-19 | Auglaize | Ohio | 39011 | 7499 | 111 |
1929191 | 1929191 | 2021-11-18 | Highland | Ohio | 39071 | 6443 | 111 |
1925941 | 1925941 | 2021-11-17 | Highland | Ohio | 39071 | 6418 | 111 |
1922691 | 1922691 | 2021-11-16 | Highland | Ohio | 39071 | 6377 | 111 |
1919426 | 1919426 | 2021-11-15 | Defiance | Ohio | 39039 | 6823 | 111 |
1919442 | 1919442 | 2021-11-15 | Highland | Ohio | 39071 | 6353 | 111 |
1916176 | 1916176 | 2021-11-14 | Defiance | Ohio | 39039 | 6803 | 111 |
1916192 | 1916192 | 2021-11-14 | Highland | Ohio | 39071 | 6351 | 111 |
1912926 | 1912926 | 2021-11-13 | Defiance | Ohio | 39039 | 6779 | 111 |
1912942 | 1912942 | 2021-11-13 | Highland | Ohio | 39071 | 6328 | 111 |
1909676 | 1909676 | 2021-11-12 | Defiance | Ohio | 39039 | 6748 | 111 |
1909692 | 1909692 | 2021-11-12 | Highland | Ohio | 39071 | 6315 | 111 |
1906427 | 1906427 | 2021-11-11 | Defiance | Ohio | 39039 | 6718 | 111 |
1903178 | 1903178 | 2021-11-10 | Defiance | Ohio | 39039 | 6670 | 111 |
1899928 | 1899928 | 2021-11-09 | Defiance | Ohio | 39039 | 6625 | 111 |
1828497 | 1828497 | 2021-10-18 | Shelby | Ohio | 39149 | 6410 | 111 |
1825248 | 1825248 | 2021-10-17 | Shelby | Ohio | 39149 | 6401 | 111 |
1821999 | 1821999 | 2021-10-16 | Shelby | Ohio | 39149 | 6392 | 111 |
1818750 | 1818750 | 2021-10-15 | Shelby | Ohio | 39149 | 6374 | 111 |
1770005 | 1770005 | 2021-09-30 | Preble | Ohio | 39135 | 5252 | 111 |
1766756 | 1766756 | 2021-09-29 | Preble | Ohio | 39135 | 5183 | 111 |
1763507 | 1763507 | 2021-09-28 | Preble | Ohio | 39135 | 5152 | 111 |
1760228 | 1760228 | 2021-09-27 | Holmes | Ohio | 39075 | 3328 | 111 |
1760258 | 1760258 | 2021-09-27 | Preble | Ohio | 39135 | 5131 | 111 |
1756980 | 1756980 | 2021-09-26 | Holmes | Ohio | 39075 | 3326 | 111 |
1757010 | 1757010 | 2021-09-26 | Preble | Ohio | 39135 | 5123 | 111 |
1753732 | 1753732 | 2021-09-25 | Holmes | Ohio | 39075 | 3321 | 111 |
1753762 | 1753762 | 2021-09-25 | Preble | Ohio | 39135 | 5102 | 111 |
1750484 | 1750484 | 2021-09-24 | Holmes | Ohio | 39075 | 3297 | 111 |
1750514 | 1750514 | 2021-09-24 | Preble | Ohio | 39135 | 5058 | 111 |
1701759 | 1701759 | 2021-09-09 | Lawrence | Ohio | 39087 | 7648 | 111 |
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);