ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Unknown" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177101 | 2177101 | 2022-02-02 | Unknown | Utah | 3928 | 66 | |
2173848 | 2173848 | 2022-02-01 | Unknown | Utah | 3854 | 65 | |
2170596 | 2170596 | 2022-01-31 | Unknown | Utah | 3882 | 65 | |
2167342 | 2167342 | 2022-01-30 | Unknown | Utah | 3528 | 64 | |
2164087 | 2164087 | 2022-01-29 | Unknown | Utah | 3528 | 64 | |
2160832 | 2160832 | 2022-01-28 | Unknown | Utah | 3567 | 64 | |
2157576 | 2157576 | 2022-01-27 | Unknown | Utah | 4006 | 59 | |
2154323 | 2154323 | 2022-01-26 | Unknown | Utah | 3362 | 59 | |
2151071 | 2151071 | 2022-01-25 | Unknown | Utah | 3317 | 58 | |
2147819 | 2147819 | 2022-01-24 | Unknown | Utah | 7374 | 74 | |
2144565 | 2144565 | 2022-01-23 | Unknown | Utah | 2899 | 56 | |
2141310 | 2141310 | 2022-01-22 | Unknown | Utah | 2985 | 56 | |
2138054 | 2138054 | 2022-01-21 | Unknown | Utah | 3033 | 56 | |
2134800 | 2134800 | 2022-01-20 | Unknown | Utah | 3659 | 58 | |
2131548 | 2131548 | 2022-01-19 | Unknown | Utah | 2941 | 57 | |
2128294 | 2128294 | 2022-01-18 | Unknown | Utah | 8187 | 65 | |
2125042 | 2125042 | 2022-01-17 | Unknown | Utah | 2618 | 57 | |
2121790 | 2121790 | 2022-01-16 | Unknown | Utah | 2651 | 57 | |
2118538 | 2118538 | 2022-01-15 | Unknown | Utah | 2750 | 57 | |
2115286 | 2115286 | 2022-01-14 | Unknown | Utah | 3341 | 58 | |
2112034 | 2112034 | 2022-01-13 | Unknown | Utah | 2662 | 57 | |
2108782 | 2108782 | 2022-01-12 | Unknown | Utah | 4862 | 60 | |
2105531 | 2105531 | 2022-01-11 | Unknown | Utah | 3592 | 58 | |
2102280 | 2102280 | 2022-01-10 | Unknown | Utah | 5251 | 66 | |
2099029 | 2099029 | 2022-01-09 | Unknown | Utah | 2420 | 59 | |
2095777 | 2095777 | 2022-01-08 | Unknown | Utah | 2420 | 59 | |
2092525 | 2092525 | 2022-01-07 | Unknown | Utah | 2464 | 59 | |
2089273 | 2089273 | 2022-01-06 | Unknown | Utah | 2312 | 58 | |
2086022 | 2086022 | 2022-01-05 | Unknown | Utah | 4371 | 59 | |
2082770 | 2082770 | 2022-01-04 | Unknown | Utah | 3637 | 58 | |
2079518 | 2079518 | 2022-01-03 | Unknown | Utah | 3167 | 55 | |
2076267 | 2076267 | 2022-01-02 | Unknown | Utah | 2097 | 54 | |
2073016 | 2073016 | 2022-01-01 | Unknown | Utah | 2097 | 54 | |
2069765 | 2069765 | 2021-12-31 | Unknown | Utah | 2097 | 54 | |
2066514 | 2066514 | 2021-12-30 | Unknown | Utah | 3171 | 60 | |
2063264 | 2063264 | 2021-12-29 | Unknown | Utah | 2428 | 56 | |
2060014 | 2060014 | 2021-12-28 | Unknown | Utah | 2184 | 54 | |
2056765 | 2056765 | 2021-12-27 | Unknown | Utah | 2481 | 55 | |
2053516 | 2053516 | 2021-12-26 | Unknown | Utah | 2134 | 53 | |
2050266 | 2050266 | 2021-12-25 | Unknown | Utah | 2134 | 53 | |
2047016 | 2047016 | 2021-12-24 | Unknown | Utah | 2134 | 53 | |
2043766 | 2043766 | 2021-12-23 | Unknown | Utah | 2135 | 53 | |
2040517 | 2040517 | 2021-12-22 | Unknown | Utah | 2149 | 53 | |
2037267 | 2037267 | 2021-12-21 | Unknown | Utah | 2198 | 52 | |
2034017 | 2034017 | 2021-12-20 | Unknown | Utah | 2143 | 52 | |
2030767 | 2030767 | 2021-12-19 | Unknown | Utah | 2095 | 50 | |
2027516 | 2027516 | 2021-12-18 | Unknown | Utah | 2095 | 50 | |
2024265 | 2024265 | 2021-12-17 | Unknown | Utah | 2098 | 50 | |
2021014 | 2021014 | 2021-12-16 | Unknown | Utah | 2210 | 49 | |
2017763 | 2017763 | 2021-12-15 | Unknown | Utah | 2115 | 48 | |
2014513 | 2014513 | 2021-12-14 | Unknown | Utah | 2192 | 51 | |
2011262 | 2011262 | 2021-12-13 | Unknown | Utah | 2111 | 49 | |
2008011 | 2008011 | 2021-12-12 | Unknown | Utah | 2173 | 50 | |
2004760 | 2004760 | 2021-12-11 | Unknown | Utah | 2173 | 50 | |
2001509 | 2001509 | 2021-12-10 | Unknown | Utah | 2177 | 51 | |
1998259 | 1998259 | 2021-12-09 | Unknown | Utah | 2104 | 46 | |
1995008 | 1995008 | 2021-12-08 | Unknown | Utah | 2075 | 47 | |
1991757 | 1991757 | 2021-12-07 | Unknown | Utah | 2085 | 47 | |
1988506 | 1988506 | 2021-12-06 | Unknown | Utah | 2646 | 60 | |
1985256 | 1985256 | 2021-12-05 | Unknown | Utah | 2074 | 44 | |
1982006 | 1982006 | 2021-12-04 | Unknown | Utah | 2074 | 44 | |
1978756 | 1978756 | 2021-12-03 | Unknown | Utah | 2085 | 44 | |
1975506 | 1975506 | 2021-12-02 | Unknown | Utah | 2200 | 43 | |
1972257 | 1972257 | 2021-12-01 | Unknown | Utah | 2386 | 50 | |
1969007 | 1969007 | 2021-11-30 | Unknown | Utah | 2040 | 44 | |
1965756 | 1965756 | 2021-11-29 | Unknown | Utah | 2061 | 42 | |
1962504 | 1962504 | 2021-11-28 | Unknown | Utah | 2153 | 40 | |
1959253 | 1959253 | 2021-11-27 | Unknown | Utah | 2153 | 40 | |
1956002 | 1956002 | 2021-11-26 | Unknown | Utah | 2153 | 40 | |
1952751 | 1952751 | 2021-11-25 | Unknown | Utah | 1988 | 38 | |
1949500 | 1949500 | 2021-11-24 | Unknown | Utah | 2005 | 41 | |
1946249 | 1946249 | 2021-11-23 | Unknown | Utah | 2019 | 41 | |
1942998 | 1942998 | 2021-11-22 | Unknown | Utah | 1990 | 40 | |
1939748 | 1939748 | 2021-11-21 | Unknown | Utah | 1960 | 39 | |
1936498 | 1936498 | 2021-11-20 | Unknown | Utah | 1960 | 39 | |
1933248 | 1933248 | 2021-11-19 | Unknown | Utah | 1983 | 40 | |
1929997 | 1929997 | 2021-11-18 | Unknown | Utah | 2108 | 40 | |
1926747 | 1926747 | 2021-11-17 | Unknown | Utah | 2322 | 44 | |
1923497 | 1923497 | 2021-11-16 | Unknown | Utah | 1927 | 38 | |
1920248 | 1920248 | 2021-11-15 | Unknown | Utah | 2685 | 49 | |
1916998 | 1916998 | 2021-11-14 | Unknown | Utah | 1899 | 38 | |
1913748 | 1913748 | 2021-11-13 | Unknown | Utah | 1899 | 38 | |
1910498 | 1910498 | 2021-11-12 | Unknown | Utah | 1945 | 38 | |
1907249 | 1907249 | 2021-11-11 | Unknown | Utah | 1885 | 38 | |
1904000 | 1904000 | 2021-11-10 | Unknown | Utah | 2187 | 41 | |
1900750 | 1900750 | 2021-11-09 | Unknown | Utah | 1920 | 38 | |
1897500 | 1897500 | 2021-11-08 | Unknown | Utah | 2571 | 41 | |
1894250 | 1894250 | 2021-11-07 | Unknown | Utah | 1792 | 38 | |
1891000 | 1891000 | 2021-11-06 | Unknown | Utah | 1792 | 38 | |
1887750 | 1887750 | 2021-11-05 | Unknown | Utah | 1858 | 41 | |
1884500 | 1884500 | 2021-11-04 | Unknown | Utah | 2250 | 43 | |
1881251 | 1881251 | 2021-11-03 | Unknown | Utah | 2102 | 41 | |
1878002 | 1878002 | 2021-11-02 | Unknown | Utah | 1884 | 39 | |
1874753 | 1874753 | 2021-11-01 | Unknown | Utah | 2478 | 47 | |
1871504 | 1871504 | 2021-10-31 | Unknown | Utah | 1832 | 39 | |
1868255 | 1868255 | 2021-10-30 | Unknown | Utah | 1832 | 39 | |
1865006 | 1865006 | 2021-10-29 | Unknown | Utah | 1862 | 39 | |
1861757 | 1861757 | 2021-10-28 | Unknown | Utah | 2348 | 43 | |
1858508 | 1858508 | 2021-10-27 | Unknown | Utah | 1821 | 39 | |
1855259 | 1855259 | 2021-10-26 | Unknown | Utah | 1804 | 36 |
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);