ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and fips = 39047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176283 | 2176283 | 2022-02-02 | Fayette | Ohio | 39047 | 7562 | 99 |
2173029 | 2173029 | 2022-02-01 | Fayette | Ohio | 39047 | 7530 | 99 |
2169777 | 2169777 | 2022-01-31 | Fayette | Ohio | 39047 | 7488 | 98 |
2166522 | 2166522 | 2022-01-30 | Fayette | Ohio | 39047 | 7464 | 98 |
2163267 | 2163267 | 2022-01-29 | Fayette | Ohio | 39047 | 7438 | 98 |
2160012 | 2160012 | 2022-01-28 | Fayette | Ohio | 39047 | 7403 | 98 |
2156757 | 2156757 | 2022-01-27 | Fayette | Ohio | 39047 | 7362 | 94 |
2153504 | 2153504 | 2022-01-26 | Fayette | Ohio | 39047 | 7323 | 94 |
2150252 | 2150252 | 2022-01-25 | Fayette | Ohio | 39047 | 7196 | 94 |
2147000 | 2147000 | 2022-01-24 | Fayette | Ohio | 39047 | 7159 | 92 |
2143746 | 2143746 | 2022-01-23 | Fayette | Ohio | 39047 | 7086 | 92 |
2140491 | 2140491 | 2022-01-22 | Fayette | Ohio | 39047 | 7032 | 92 |
2137235 | 2137235 | 2022-01-21 | Fayette | Ohio | 39047 | 6965 | 92 |
2133981 | 2133981 | 2022-01-20 | Fayette | Ohio | 39047 | 6886 | 87 |
2130729 | 2130729 | 2022-01-19 | Fayette | Ohio | 39047 | 6782 | 87 |
2127475 | 2127475 | 2022-01-18 | Fayette | Ohio | 39047 | 6709 | 87 |
2124223 | 2124223 | 2022-01-17 | Fayette | Ohio | 39047 | 6622 | 87 |
2120971 | 2120971 | 2022-01-16 | Fayette | Ohio | 39047 | 6566 | 87 |
2117719 | 2117719 | 2022-01-15 | Fayette | Ohio | 39047 | 6478 | 87 |
2114468 | 2114468 | 2022-01-14 | Fayette | Ohio | 39047 | 6324 | 87 |
2111216 | 2111216 | 2022-01-13 | Fayette | Ohio | 39047 | 6212 | 85 |
2107964 | 2107964 | 2022-01-12 | Fayette | Ohio | 39047 | 6149 | 85 |
2104713 | 2104713 | 2022-01-11 | Fayette | Ohio | 39047 | 6112 | 85 |
2101462 | 2101462 | 2022-01-10 | Fayette | Ohio | 39047 | 6026 | 82 |
2098211 | 2098211 | 2022-01-09 | Fayette | Ohio | 39047 | 5987 | 82 |
2094959 | 2094959 | 2022-01-08 | Fayette | Ohio | 39047 | 5935 | 82 |
2091707 | 2091707 | 2022-01-07 | Fayette | Ohio | 39047 | 5913 | 82 |
2088455 | 2088455 | 2022-01-06 | Fayette | Ohio | 39047 | 5874 | 80 |
2085204 | 2085204 | 2022-01-05 | Fayette | Ohio | 39047 | 5804 | 80 |
2081952 | 2081952 | 2022-01-04 | Fayette | Ohio | 39047 | 5746 | 80 |
2078700 | 2078700 | 2022-01-03 | Fayette | Ohio | 39047 | 5697 | 80 |
2075449 | 2075449 | 2022-01-02 | Fayette | Ohio | 39047 | 5663 | 80 |
2072198 | 2072198 | 2022-01-01 | Fayette | Ohio | 39047 | 5606 | 80 |
2068947 | 2068947 | 2021-12-31 | Fayette | Ohio | 39047 | 5606 | 80 |
2065696 | 2065696 | 2021-12-30 | Fayette | Ohio | 39047 | 5576 | 78 |
2062446 | 2062446 | 2021-12-29 | Fayette | Ohio | 39047 | 5542 | 78 |
2059196 | 2059196 | 2021-12-28 | Fayette | Ohio | 39047 | 5495 | 78 |
2055947 | 2055947 | 2021-12-27 | Fayette | Ohio | 39047 | 5470 | 77 |
2052698 | 2052698 | 2021-12-26 | Fayette | Ohio | 39047 | 5460 | 77 |
2049448 | 2049448 | 2021-12-25 | Fayette | Ohio | 39047 | 5425 | 77 |
2046198 | 2046198 | 2021-12-24 | Fayette | Ohio | 39047 | 5425 | 77 |
2042948 | 2042948 | 2021-12-23 | Fayette | Ohio | 39047 | 5410 | 76 |
2039699 | 2039699 | 2021-12-22 | Fayette | Ohio | 39047 | 5384 | 76 |
2036449 | 2036449 | 2021-12-21 | Fayette | Ohio | 39047 | 5360 | 76 |
2033199 | 2033199 | 2021-12-20 | Fayette | Ohio | 39047 | 5329 | 75 |
2029949 | 2029949 | 2021-12-19 | Fayette | Ohio | 39047 | 5321 | 75 |
2026698 | 2026698 | 2021-12-18 | Fayette | Ohio | 39047 | 5297 | 75 |
2023447 | 2023447 | 2021-12-17 | Fayette | Ohio | 39047 | 5275 | 75 |
2020196 | 2020196 | 2021-12-16 | Fayette | Ohio | 39047 | 5242 | 72 |
2016945 | 2016945 | 2021-12-15 | Fayette | Ohio | 39047 | 5216 | 72 |
2013695 | 2013695 | 2021-12-14 | Fayette | Ohio | 39047 | 5186 | 72 |
2010444 | 2010444 | 2021-12-13 | Fayette | Ohio | 39047 | 5147 | 72 |
2007193 | 2007193 | 2021-12-12 | Fayette | Ohio | 39047 | 5132 | 72 |
2003942 | 2003942 | 2021-12-11 | Fayette | Ohio | 39047 | 5115 | 72 |
2000691 | 2000691 | 2021-12-10 | Fayette | Ohio | 39047 | 5096 | 72 |
1997441 | 1997441 | 2021-12-09 | Fayette | Ohio | 39047 | 5067 | 72 |
1994190 | 1994190 | 2021-12-08 | Fayette | Ohio | 39047 | 5036 | 72 |
1990939 | 1990939 | 2021-12-07 | Fayette | Ohio | 39047 | 5024 | 72 |
1987688 | 1987688 | 2021-12-06 | Fayette | Ohio | 39047 | 4990 | 72 |
1984438 | 1984438 | 2021-12-05 | Fayette | Ohio | 39047 | 4972 | 72 |
1981188 | 1981188 | 2021-12-04 | Fayette | Ohio | 39047 | 4956 | 72 |
1977938 | 1977938 | 2021-12-03 | Fayette | Ohio | 39047 | 4940 | 72 |
1974688 | 1974688 | 2021-12-02 | Fayette | Ohio | 39047 | 4921 | 70 |
1971439 | 1971439 | 2021-12-01 | Fayette | Ohio | 39047 | 4893 | 70 |
1968189 | 1968189 | 2021-11-30 | Fayette | Ohio | 39047 | 4853 | 70 |
1964938 | 1964938 | 2021-11-29 | Fayette | Ohio | 39047 | 4831 | 70 |
1961686 | 1961686 | 2021-11-28 | Fayette | Ohio | 39047 | 4819 | 70 |
1958435 | 1958435 | 2021-11-27 | Fayette | Ohio | 39047 | 4812 | 70 |
1955184 | 1955184 | 2021-11-26 | Fayette | Ohio | 39047 | 4803 | 70 |
1951933 | 1951933 | 2021-11-25 | Fayette | Ohio | 39047 | 4775 | 67 |
1948682 | 1948682 | 2021-11-24 | Fayette | Ohio | 39047 | 4775 | 67 |
1945431 | 1945431 | 2021-11-23 | Fayette | Ohio | 39047 | 4755 | 67 |
1942180 | 1942180 | 2021-11-22 | Fayette | Ohio | 39047 | 4737 | 67 |
1938930 | 1938930 | 2021-11-21 | Fayette | Ohio | 39047 | 4728 | 67 |
1935680 | 1935680 | 2021-11-20 | Fayette | Ohio | 39047 | 4719 | 67 |
1932430 | 1932430 | 2021-11-19 | Fayette | Ohio | 39047 | 4689 | 67 |
1929179 | 1929179 | 2021-11-18 | Fayette | Ohio | 39047 | 4661 | 67 |
1925929 | 1925929 | 2021-11-17 | Fayette | Ohio | 39047 | 4643 | 67 |
1922679 | 1922679 | 2021-11-16 | Fayette | Ohio | 39047 | 4626 | 67 |
1919430 | 1919430 | 2021-11-15 | Fayette | Ohio | 39047 | 4590 | 67 |
1916180 | 1916180 | 2021-11-14 | Fayette | Ohio | 39047 | 4581 | 67 |
1912930 | 1912930 | 2021-11-13 | Fayette | Ohio | 39047 | 4570 | 67 |
1909680 | 1909680 | 2021-11-12 | Fayette | Ohio | 39047 | 4551 | 67 |
1906431 | 1906431 | 2021-11-11 | Fayette | Ohio | 39047 | 4540 | 66 |
1903182 | 1903182 | 2021-11-10 | Fayette | Ohio | 39047 | 4506 | 66 |
1899932 | 1899932 | 2021-11-09 | Fayette | Ohio | 39047 | 4482 | 66 |
1896682 | 1896682 | 2021-11-08 | Fayette | Ohio | 39047 | 4450 | 66 |
1893432 | 1893432 | 2021-11-07 | Fayette | Ohio | 39047 | 4444 | 66 |
1890182 | 1890182 | 2021-11-06 | Fayette | Ohio | 39047 | 4426 | 66 |
1886932 | 1886932 | 2021-11-05 | Fayette | Ohio | 39047 | 4415 | 66 |
1883682 | 1883682 | 2021-11-04 | Fayette | Ohio | 39047 | 4401 | 65 |
1880433 | 1880433 | 2021-11-03 | Fayette | Ohio | 39047 | 4387 | 65 |
1877184 | 1877184 | 2021-11-02 | Fayette | Ohio | 39047 | 4381 | 65 |
1873935 | 1873935 | 2021-11-01 | Fayette | Ohio | 39047 | 4364 | 64 |
1870686 | 1870686 | 2021-10-31 | Fayette | Ohio | 39047 | 4362 | 64 |
1867437 | 1867437 | 2021-10-30 | Fayette | Ohio | 39047 | 4359 | 64 |
1864188 | 1864188 | 2021-10-29 | Fayette | Ohio | 39047 | 4351 | 64 |
1860939 | 1860939 | 2021-10-28 | Fayette | Ohio | 39047 | 4341 | 64 |
1857690 | 1857690 | 2021-10-27 | Fayette | Ohio | 39047 | 4326 | 64 |
1854441 | 1854441 | 2021-10-26 | Fayette | Ohio | 39047 | 4314 | 64 |
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);