ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
386 rows where deaths = 47 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 |
---|---|---|---|---|---|---|---|
2179593 | 2179593 | 2022-02-03 | Vinton | Ohio | 39163 | 2761 | 47 |
2176342 | 2176342 | 2022-02-02 | Vinton | Ohio | 39163 | 2753 | 47 |
2173088 | 2173088 | 2022-02-01 | Vinton | Ohio | 39163 | 2737 | 47 |
2169836 | 2169836 | 2022-01-31 | Vinton | Ohio | 39163 | 2721 | 47 |
2166581 | 2166581 | 2022-01-30 | Vinton | Ohio | 39163 | 2714 | 47 |
2163326 | 2163326 | 2022-01-29 | Vinton | Ohio | 39163 | 2702 | 47 |
2160071 | 2160071 | 2022-01-28 | Vinton | Ohio | 39163 | 2681 | 47 |
2111250 | 2111250 | 2022-01-13 | Morgan | Ohio | 39115 | 2643 | 47 |
2107998 | 2107998 | 2022-01-12 | Morgan | Ohio | 39115 | 2605 | 47 |
2104747 | 2104747 | 2022-01-11 | Morgan | Ohio | 39115 | 2582 | 47 |
2101496 | 2101496 | 2022-01-10 | Morgan | Ohio | 39115 | 2560 | 47 |
2098245 | 2098245 | 2022-01-09 | Morgan | Ohio | 39115 | 2547 | 47 |
2094993 | 2094993 | 2022-01-08 | Morgan | Ohio | 39115 | 2537 | 47 |
2091741 | 2091741 | 2022-01-07 | Morgan | Ohio | 39115 | 2529 | 47 |
2088489 | 2088489 | 2022-01-06 | Morgan | Ohio | 39115 | 2516 | 47 |
2085238 | 2085238 | 2022-01-05 | Morgan | Ohio | 39115 | 2491 | 47 |
2081986 | 2081986 | 2022-01-04 | Morgan | Ohio | 39115 | 2453 | 47 |
1974725 | 1974725 | 2021-12-02 | Noble | Ohio | 39121 | 2196 | 47 |
1971476 | 1971476 | 2021-12-01 | Noble | Ohio | 39121 | 2191 | 47 |
1968226 | 1968226 | 2021-11-30 | Noble | Ohio | 39121 | 2180 | 47 |
1964975 | 1964975 | 2021-11-29 | Noble | Ohio | 39121 | 2164 | 47 |
1961723 | 1961723 | 2021-11-28 | Noble | Ohio | 39121 | 2163 | 47 |
1958472 | 1958472 | 2021-11-27 | Noble | Ohio | 39121 | 2161 | 47 |
1955221 | 1955221 | 2021-11-26 | Noble | Ohio | 39121 | 2161 | 47 |
1951970 | 1951970 | 2021-11-25 | Noble | Ohio | 39121 | 2146 | 47 |
1948719 | 1948719 | 2021-11-24 | Noble | Ohio | 39121 | 2146 | 47 |
1945468 | 1945468 | 2021-11-23 | Noble | Ohio | 39121 | 2140 | 47 |
1942217 | 1942217 | 2021-11-22 | Noble | Ohio | 39121 | 2135 | 47 |
1942219 | 1942219 | 2021-11-22 | Paulding | Ohio | 39125 | 3105 | 47 |
1938967 | 1938967 | 2021-11-21 | Noble | Ohio | 39121 | 2134 | 47 |
1938969 | 1938969 | 2021-11-21 | Paulding | Ohio | 39125 | 3100 | 47 |
1935717 | 1935717 | 2021-11-20 | Noble | Ohio | 39121 | 2132 | 47 |
1935719 | 1935719 | 2021-11-20 | Paulding | Ohio | 39125 | 3099 | 47 |
1932467 | 1932467 | 2021-11-19 | Noble | Ohio | 39121 | 2131 | 47 |
1932469 | 1932469 | 2021-11-19 | Paulding | Ohio | 39125 | 3087 | 47 |
1929216 | 1929216 | 2021-11-18 | Noble | Ohio | 39121 | 2127 | 47 |
1929218 | 1929218 | 2021-11-18 | Paulding | Ohio | 39125 | 3078 | 47 |
1925966 | 1925966 | 2021-11-17 | Noble | Ohio | 39121 | 2126 | 47 |
1925968 | 1925968 | 2021-11-17 | Paulding | Ohio | 39125 | 3067 | 47 |
1922716 | 1922716 | 2021-11-16 | Noble | Ohio | 39121 | 2121 | 47 |
1922718 | 1922718 | 2021-11-16 | Paulding | Ohio | 39125 | 3050 | 47 |
1919467 | 1919467 | 2021-11-15 | Noble | Ohio | 39121 | 2115 | 47 |
1919469 | 1919469 | 2021-11-15 | Paulding | Ohio | 39125 | 3035 | 47 |
1916217 | 1916217 | 2021-11-14 | Noble | Ohio | 39121 | 2113 | 47 |
1916219 | 1916219 | 2021-11-14 | Paulding | Ohio | 39125 | 3026 | 47 |
1912967 | 1912967 | 2021-11-13 | Noble | Ohio | 39121 | 2112 | 47 |
1912969 | 1912969 | 2021-11-13 | Paulding | Ohio | 39125 | 3016 | 47 |
1909717 | 1909717 | 2021-11-12 | Noble | Ohio | 39121 | 2110 | 47 |
1909719 | 1909719 | 2021-11-12 | Paulding | Ohio | 39125 | 3011 | 47 |
1906468 | 1906468 | 2021-11-11 | Noble | Ohio | 39121 | 2109 | 47 |
1906470 | 1906470 | 2021-11-11 | Paulding | Ohio | 39125 | 2999 | 47 |
1903219 | 1903219 | 2021-11-10 | Noble | Ohio | 39121 | 2102 | 47 |
1903221 | 1903221 | 2021-11-10 | Paulding | Ohio | 39125 | 2989 | 47 |
1899969 | 1899969 | 2021-11-09 | Noble | Ohio | 39121 | 2093 | 47 |
1899971 | 1899971 | 2021-11-09 | Paulding | Ohio | 39125 | 2960 | 47 |
1896719 | 1896719 | 2021-11-08 | Noble | Ohio | 39121 | 2086 | 47 |
1896721 | 1896721 | 2021-11-08 | Paulding | Ohio | 39125 | 2944 | 47 |
1893469 | 1893469 | 2021-11-07 | Noble | Ohio | 39121 | 2082 | 47 |
1893471 | 1893471 | 2021-11-07 | Paulding | Ohio | 39125 | 2935 | 47 |
1890219 | 1890219 | 2021-11-06 | Noble | Ohio | 39121 | 2082 | 47 |
1890221 | 1890221 | 2021-11-06 | Paulding | Ohio | 39125 | 2927 | 47 |
1886969 | 1886969 | 2021-11-05 | Noble | Ohio | 39121 | 2075 | 47 |
1886971 | 1886971 | 2021-11-05 | Paulding | Ohio | 39125 | 2921 | 47 |
1883719 | 1883719 | 2021-11-04 | Noble | Ohio | 39121 | 2069 | 47 |
1883721 | 1883721 | 2021-11-04 | Paulding | Ohio | 39125 | 2910 | 47 |
1880470 | 1880470 | 2021-11-03 | Noble | Ohio | 39121 | 2067 | 47 |
1880472 | 1880472 | 2021-11-03 | Paulding | Ohio | 39125 | 2896 | 47 |
1877221 | 1877221 | 2021-11-02 | Noble | Ohio | 39121 | 2051 | 47 |
1877223 | 1877223 | 2021-11-02 | Paulding | Ohio | 39125 | 2885 | 47 |
1873945 | 1873945 | 2021-11-01 | Harrison | Ohio | 39067 | 1861 | 47 |
1873972 | 1873972 | 2021-11-01 | Noble | Ohio | 39121 | 2046 | 47 |
1873974 | 1873974 | 2021-11-01 | Paulding | Ohio | 39125 | 2873 | 47 |
1870696 | 1870696 | 2021-10-31 | Harrison | Ohio | 39067 | 1855 | 47 |
1870723 | 1870723 | 2021-10-31 | Noble | Ohio | 39121 | 2043 | 47 |
1870725 | 1870725 | 2021-10-31 | Paulding | Ohio | 39125 | 2869 | 47 |
1867447 | 1867447 | 2021-10-30 | Harrison | Ohio | 39067 | 1853 | 47 |
1867474 | 1867474 | 2021-10-30 | Noble | Ohio | 39121 | 2043 | 47 |
1867476 | 1867476 | 2021-10-30 | Paulding | Ohio | 39125 | 2865 | 47 |
1864198 | 1864198 | 2021-10-29 | Harrison | Ohio | 39067 | 1848 | 47 |
1864225 | 1864225 | 2021-10-29 | Noble | Ohio | 39121 | 2035 | 47 |
1864227 | 1864227 | 2021-10-29 | Paulding | Ohio | 39125 | 2857 | 47 |
1860949 | 1860949 | 2021-10-28 | Harrison | Ohio | 39067 | 1843 | 47 |
1860976 | 1860976 | 2021-10-28 | Noble | Ohio | 39121 | 2030 | 47 |
1860978 | 1860978 | 2021-10-28 | Paulding | Ohio | 39125 | 2845 | 47 |
1857700 | 1857700 | 2021-10-27 | Harrison | Ohio | 39067 | 1837 | 47 |
1857727 | 1857727 | 2021-10-27 | Noble | Ohio | 39121 | 2025 | 47 |
1857729 | 1857729 | 2021-10-27 | Paulding | Ohio | 39125 | 2825 | 47 |
1854451 | 1854451 | 2021-10-26 | Harrison | Ohio | 39067 | 1832 | 47 |
1854478 | 1854478 | 2021-10-26 | Noble | Ohio | 39121 | 2020 | 47 |
1854480 | 1854480 | 2021-10-26 | Paulding | Ohio | 39125 | 2820 | 47 |
1851229 | 1851229 | 2021-10-25 | Noble | Ohio | 39121 | 2012 | 47 |
1851231 | 1851231 | 2021-10-25 | Paulding | Ohio | 39125 | 2807 | 47 |
1847979 | 1847979 | 2021-10-24 | Noble | Ohio | 39121 | 2009 | 47 |
1847981 | 1847981 | 2021-10-24 | Paulding | Ohio | 39125 | 2804 | 47 |
1844729 | 1844729 | 2021-10-23 | Noble | Ohio | 39121 | 2003 | 47 |
1844731 | 1844731 | 2021-10-23 | Paulding | Ohio | 39125 | 2803 | 47 |
1841479 | 1841479 | 2021-10-22 | Noble | Ohio | 39121 | 1997 | 47 |
1841481 | 1841481 | 2021-10-22 | Paulding | Ohio | 39125 | 2794 | 47 |
1838232 | 1838232 | 2021-10-21 | Paulding | Ohio | 39125 | 2791 | 47 |
1834983 | 1834983 | 2021-10-20 | Paulding | Ohio | 39125 | 2778 | 47 |
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);