ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Union" and fips = 19175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175079 | 2175079 | 2022-02-02 | Union | Iowa | 19175 | 2581 | 46 |
2171826 | 2171826 | 2022-02-01 | Union | Iowa | 19175 | 2506 | 46 |
2168573 | 2168573 | 2022-01-31 | Union | Iowa | 19175 | 2506 | 46 |
2165318 | 2165318 | 2022-01-30 | Union | Iowa | 19175 | 2506 | 46 |
2162063 | 2162063 | 2022-01-29 | Union | Iowa | 19175 | 2506 | 46 |
2158808 | 2158808 | 2022-01-28 | Union | Iowa | 19175 | 2506 | 46 |
2155554 | 2155554 | 2022-01-27 | Union | Iowa | 19175 | 2506 | 46 |
2152301 | 2152301 | 2022-01-26 | Union | Iowa | 19175 | 2506 | 46 |
2149049 | 2149049 | 2022-01-25 | Union | Iowa | 19175 | 2415 | 45 |
2145797 | 2145797 | 2022-01-24 | Union | Iowa | 19175 | 2415 | 45 |
2142542 | 2142542 | 2022-01-23 | Union | Iowa | 19175 | 2415 | 45 |
2139287 | 2139287 | 2022-01-22 | Union | Iowa | 19175 | 2415 | 45 |
2136031 | 2136031 | 2022-01-21 | Union | Iowa | 19175 | 2415 | 45 |
2132779 | 2132779 | 2022-01-20 | Union | Iowa | 19175 | 2415 | 45 |
2129526 | 2129526 | 2022-01-19 | Union | Iowa | 19175 | 2415 | 45 |
2126272 | 2126272 | 2022-01-18 | Union | Iowa | 19175 | 2326 | 45 |
2123020 | 2123020 | 2022-01-17 | Union | Iowa | 19175 | 2326 | 45 |
2119768 | 2119768 | 2022-01-16 | Union | Iowa | 19175 | 2326 | 45 |
2116516 | 2116516 | 2022-01-15 | Union | Iowa | 19175 | 2326 | 45 |
2113265 | 2113265 | 2022-01-14 | Union | Iowa | 19175 | 2326 | 45 |
2110013 | 2110013 | 2022-01-13 | Union | Iowa | 19175 | 2326 | 45 |
2106762 | 2106762 | 2022-01-12 | Union | Iowa | 19175 | 2326 | 45 |
2103511 | 2103511 | 2022-01-11 | Union | Iowa | 19175 | 2249 | 44 |
2100260 | 2100260 | 2022-01-10 | Union | Iowa | 19175 | 2249 | 44 |
2097009 | 2097009 | 2022-01-09 | Union | Iowa | 19175 | 2249 | 44 |
2093757 | 2093757 | 2022-01-08 | Union | Iowa | 19175 | 2249 | 44 |
2090505 | 2090505 | 2022-01-07 | Union | Iowa | 19175 | 2249 | 44 |
2087254 | 2087254 | 2022-01-06 | Union | Iowa | 19175 | 2249 | 44 |
2084002 | 2084002 | 2022-01-05 | Union | Iowa | 19175 | 2249 | 44 |
2080750 | 2080750 | 2022-01-04 | Union | Iowa | 19175 | 2207 | 44 |
2077498 | 2077498 | 2022-01-03 | Union | Iowa | 19175 | 2207 | 44 |
2074247 | 2074247 | 2022-01-02 | Union | Iowa | 19175 | 2207 | 44 |
2070996 | 2070996 | 2022-01-01 | Union | Iowa | 19175 | 2207 | 44 |
2067745 | 2067745 | 2021-12-31 | Union | Iowa | 19175 | 2207 | 44 |
2064494 | 2064494 | 2021-12-30 | Union | Iowa | 19175 | 2207 | 44 |
2061244 | 2061244 | 2021-12-29 | Union | Iowa | 19175 | 2207 | 44 |
2057995 | 2057995 | 2021-12-28 | Union | Iowa | 19175 | 2158 | 44 |
2054746 | 2054746 | 2021-12-27 | Union | Iowa | 19175 | 2158 | 44 |
2051496 | 2051496 | 2021-12-26 | Union | Iowa | 19175 | 2158 | 44 |
2048246 | 2048246 | 2021-12-25 | Union | Iowa | 19175 | 2158 | 44 |
2044996 | 2044996 | 2021-12-24 | Union | Iowa | 19175 | 2158 | 44 |
2041747 | 2041747 | 2021-12-23 | Union | Iowa | 19175 | 2158 | 44 |
2038497 | 2038497 | 2021-12-22 | Union | Iowa | 19175 | 2158 | 44 |
2035247 | 2035247 | 2021-12-21 | Union | Iowa | 19175 | 2100 | 42 |
2031997 | 2031997 | 2021-12-20 | Union | Iowa | 19175 | 2100 | 42 |
2028746 | 2028746 | 2021-12-19 | Union | Iowa | 19175 | 2100 | 42 |
2025495 | 2025495 | 2021-12-18 | Union | Iowa | 19175 | 2100 | 42 |
2022244 | 2022244 | 2021-12-17 | Union | Iowa | 19175 | 2100 | 42 |
2018993 | 2018993 | 2021-12-16 | Union | Iowa | 19175 | 2100 | 42 |
2015743 | 2015743 | 2021-12-15 | Union | Iowa | 19175 | 2100 | 42 |
2012492 | 2012492 | 2021-12-14 | Union | Iowa | 19175 | 2042 | 41 |
2009241 | 2009241 | 2021-12-13 | Union | Iowa | 19175 | 2042 | 41 |
2005990 | 2005990 | 2021-12-12 | Union | Iowa | 19175 | 2042 | 41 |
2002739 | 2002739 | 2021-12-11 | Union | Iowa | 19175 | 2042 | 41 |
1999489 | 1999489 | 2021-12-10 | Union | Iowa | 19175 | 2042 | 41 |
1996238 | 1996238 | 2021-12-09 | Union | Iowa | 19175 | 2042 | 41 |
1992987 | 1992987 | 2021-12-08 | Union | Iowa | 19175 | 2042 | 41 |
1989736 | 1989736 | 2021-12-07 | Union | Iowa | 19175 | 1983 | 41 |
1986486 | 1986486 | 2021-12-06 | Union | Iowa | 19175 | 1983 | 41 |
1983236 | 1983236 | 2021-12-05 | Union | Iowa | 19175 | 1983 | 41 |
1979986 | 1979986 | 2021-12-04 | Union | Iowa | 19175 | 1983 | 41 |
1976736 | 1976736 | 2021-12-03 | Union | Iowa | 19175 | 1983 | 41 |
1973487 | 1973487 | 2021-12-02 | Union | Iowa | 19175 | 1983 | 41 |
1970237 | 1970237 | 2021-12-01 | Union | Iowa | 19175 | 1983 | 41 |
1966987 | 1966987 | 2021-11-30 | Union | Iowa | 19175 | 1925 | 41 |
1963735 | 1963735 | 2021-11-29 | Union | Iowa | 19175 | 1925 | 41 |
1960484 | 1960484 | 2021-11-28 | Union | Iowa | 19175 | 1925 | 41 |
1957233 | 1957233 | 2021-11-27 | Union | Iowa | 19175 | 1925 | 41 |
1953982 | 1953982 | 2021-11-26 | Union | Iowa | 19175 | 1925 | 41 |
1950731 | 1950731 | 2021-11-25 | Union | Iowa | 19175 | 1925 | 41 |
1947480 | 1947480 | 2021-11-24 | Union | Iowa | 19175 | 1925 | 41 |
1944229 | 1944229 | 2021-11-23 | Union | Iowa | 19175 | 1848 | 39 |
1940979 | 1940979 | 2021-11-22 | Union | Iowa | 19175 | 1848 | 39 |
1937729 | 1937729 | 2021-11-21 | Union | Iowa | 19175 | 1848 | 39 |
1934479 | 1934479 | 2021-11-20 | Union | Iowa | 19175 | 1848 | 39 |
1931228 | 1931228 | 2021-11-19 | Union | Iowa | 19175 | 1848 | 39 |
1927977 | 1927977 | 2021-11-18 | Union | Iowa | 19175 | 1848 | 39 |
1924727 | 1924727 | 2021-11-17 | Union | Iowa | 19175 | 1848 | 39 |
1921478 | 1921478 | 2021-11-16 | Union | Iowa | 19175 | 1774 | 38 |
1918228 | 1918228 | 2021-11-15 | Union | Iowa | 19175 | 1774 | 38 |
1914978 | 1914978 | 2021-11-14 | Union | Iowa | 19175 | 1774 | 38 |
1911728 | 1911728 | 2021-11-13 | Union | Iowa | 19175 | 1774 | 38 |
1908479 | 1908479 | 2021-11-12 | Union | Iowa | 19175 | 1774 | 38 |
1905230 | 1905230 | 2021-11-11 | Union | Iowa | 19175 | 1774 | 38 |
1901980 | 1901980 | 2021-11-10 | Union | Iowa | 19175 | 1774 | 38 |
1898730 | 1898730 | 2021-11-09 | Union | Iowa | 19175 | 1703 | 38 |
1895480 | 1895480 | 2021-11-08 | Union | Iowa | 19175 | 1703 | 38 |
1892230 | 1892230 | 2021-11-07 | Union | Iowa | 19175 | 1703 | 38 |
1888980 | 1888980 | 2021-11-06 | Union | Iowa | 19175 | 1703 | 38 |
1885730 | 1885730 | 2021-11-05 | Union | Iowa | 19175 | 1703 | 38 |
1882481 | 1882481 | 2021-11-04 | Union | Iowa | 19175 | 1703 | 38 |
1879232 | 1879232 | 2021-11-03 | Union | Iowa | 19175 | 1703 | 38 |
1875983 | 1875983 | 2021-11-02 | Union | Iowa | 19175 | 1655 | 38 |
1872734 | 1872734 | 2021-11-01 | Union | Iowa | 19175 | 1655 | 38 |
1869485 | 1869485 | 2021-10-31 | Union | Iowa | 19175 | 1655 | 38 |
1866236 | 1866236 | 2021-10-30 | Union | Iowa | 19175 | 1655 | 38 |
1862987 | 1862987 | 2021-10-29 | Union | Iowa | 19175 | 1655 | 38 |
1859738 | 1859738 | 2021-10-28 | Union | Iowa | 19175 | 1655 | 38 |
1856489 | 1856489 | 2021-10-27 | Union | Iowa | 19175 | 1655 | 38 |
1853240 | 1853240 | 2021-10-26 | Union | Iowa | 19175 | 1626 | 37 |
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);