ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 49005 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177079 | 2177079 | 2022-02-02 | Cache | Utah | 49005 | 35553 | 89 |
2173826 | 2173826 | 2022-02-01 | Cache | Utah | 49005 | 35346 | 89 |
2170574 | 2170574 | 2022-01-31 | Cache | Utah | 49005 | 35293 | 89 |
2167320 | 2167320 | 2022-01-30 | Cache | Utah | 49005 | 34747 | 89 |
2164065 | 2164065 | 2022-01-29 | Cache | Utah | 49005 | 34747 | 89 |
2160810 | 2160810 | 2022-01-28 | Cache | Utah | 49005 | 34747 | 89 |
2157554 | 2157554 | 2022-01-27 | Cache | Utah | 49005 | 34388 | 89 |
2154301 | 2154301 | 2022-01-26 | Cache | Utah | 49005 | 34036 | 89 |
2151049 | 2151049 | 2022-01-25 | Cache | Utah | 49005 | 33712 | 88 |
2147797 | 2147797 | 2022-01-24 | Cache | Utah | 49005 | 32233 | 87 |
2144543 | 2144543 | 2022-01-23 | Cache | Utah | 49005 | 32233 | 87 |
2141288 | 2141288 | 2022-01-22 | Cache | Utah | 49005 | 32233 | 87 |
2138032 | 2138032 | 2022-01-21 | Cache | Utah | 49005 | 32233 | 87 |
2134778 | 2134778 | 2022-01-20 | Cache | Utah | 49005 | 31483 | 87 |
2131526 | 2131526 | 2022-01-19 | Cache | Utah | 49005 | 30947 | 86 |
2128272 | 2128272 | 2022-01-18 | Cache | Utah | 49005 | 28678 | 84 |
2125020 | 2125020 | 2022-01-17 | Cache | Utah | 49005 | 28678 | 84 |
2121768 | 2121768 | 2022-01-16 | Cache | Utah | 49005 | 28678 | 84 |
2118516 | 2118516 | 2022-01-15 | Cache | Utah | 49005 | 28678 | 84 |
2115264 | 2115264 | 2022-01-14 | Cache | Utah | 49005 | 28678 | 84 |
2112012 | 2112012 | 2022-01-13 | Cache | Utah | 49005 | 28408 | 84 |
2108760 | 2108760 | 2022-01-12 | Cache | Utah | 49005 | 27490 | 84 |
2105509 | 2105509 | 2022-01-11 | Cache | Utah | 49005 | 27490 | 84 |
2102258 | 2102258 | 2022-01-10 | Cache | Utah | 49005 | 26686 | 84 |
2099007 | 2099007 | 2022-01-09 | Cache | Utah | 49005 | 26686 | 84 |
2095755 | 2095755 | 2022-01-08 | Cache | Utah | 49005 | 26686 | 84 |
2092503 | 2092503 | 2022-01-07 | Cache | Utah | 49005 | 26686 | 84 |
2089251 | 2089251 | 2022-01-06 | Cache | Utah | 49005 | 26464 | 84 |
2086000 | 2086000 | 2022-01-05 | Cache | Utah | 49005 | 25534 | 84 |
2082748 | 2082748 | 2022-01-04 | Cache | Utah | 49005 | 25533 | 84 |
2079496 | 2079496 | 2022-01-03 | Cache | Utah | 49005 | 25533 | 84 |
2076245 | 2076245 | 2022-01-02 | Cache | Utah | 49005 | 25185 | 84 |
2072994 | 2072994 | 2022-01-01 | Cache | Utah | 49005 | 25185 | 84 |
2069743 | 2069743 | 2021-12-31 | Cache | Utah | 49005 | 25185 | 84 |
2066492 | 2066492 | 2021-12-30 | Cache | Utah | 49005 | 25077 | 84 |
2063242 | 2063242 | 2021-12-29 | Cache | Utah | 49005 | 25077 | 84 |
2059992 | 2059992 | 2021-12-28 | Cache | Utah | 49005 | 24943 | 85 |
2056743 | 2056743 | 2021-12-27 | Cache | Utah | 49005 | 24896 | 85 |
2053494 | 2053494 | 2021-12-26 | Cache | Utah | 49005 | 24702 | 85 |
2050244 | 2050244 | 2021-12-25 | Cache | Utah | 49005 | 24702 | 85 |
2046994 | 2046994 | 2021-12-24 | Cache | Utah | 49005 | 24702 | 85 |
2043744 | 2043744 | 2021-12-23 | Cache | Utah | 49005 | 24702 | 85 |
2040495 | 2040495 | 2021-12-22 | Cache | Utah | 49005 | 24658 | 85 |
2037245 | 2037245 | 2021-12-21 | Cache | Utah | 49005 | 24596 | 85 |
2033995 | 2033995 | 2021-12-20 | Cache | Utah | 49005 | 24570 | 84 |
2030745 | 2030745 | 2021-12-19 | Cache | Utah | 49005 | 24492 | 83 |
2027494 | 2027494 | 2021-12-18 | Cache | Utah | 49005 | 24492 | 83 |
2024243 | 2024243 | 2021-12-17 | Cache | Utah | 49005 | 24492 | 83 |
2020992 | 2020992 | 2021-12-16 | Cache | Utah | 49005 | 24459 | 83 |
2017741 | 2017741 | 2021-12-15 | Cache | Utah | 49005 | 24418 | 83 |
2014491 | 2014491 | 2021-12-14 | Cache | Utah | 49005 | 24367 | 83 |
2011240 | 2011240 | 2021-12-13 | Cache | Utah | 49005 | 24343 | 83 |
2007989 | 2007989 | 2021-12-12 | Cache | Utah | 49005 | 24236 | 82 |
2004738 | 2004738 | 2021-12-11 | Cache | Utah | 49005 | 24236 | 82 |
2001487 | 2001487 | 2021-12-10 | Cache | Utah | 49005 | 24236 | 82 |
1998237 | 1998237 | 2021-12-09 | Cache | Utah | 49005 | 24161 | 82 |
1994986 | 1994986 | 2021-12-08 | Cache | Utah | 49005 | 24105 | 82 |
1991735 | 1991735 | 2021-12-07 | Cache | Utah | 49005 | 24064 | 81 |
1988484 | 1988484 | 2021-12-06 | Cache | Utah | 49005 | 23940 | 79 |
1985234 | 1985234 | 2021-12-05 | Cache | Utah | 49005 | 23940 | 79 |
1981984 | 1981984 | 2021-12-04 | Cache | Utah | 49005 | 23940 | 79 |
1978734 | 1978734 | 2021-12-03 | Cache | Utah | 49005 | 23940 | 79 |
1975484 | 1975484 | 2021-12-02 | Cache | Utah | 49005 | 23879 | 78 |
1972235 | 1972235 | 2021-12-01 | Cache | Utah | 49005 | 23724 | 78 |
1968985 | 1968985 | 2021-11-30 | Cache | Utah | 49005 | 23724 | 78 |
1965734 | 1965734 | 2021-11-29 | Cache | Utah | 49005 | 23695 | 78 |
1962482 | 1962482 | 2021-11-28 | Cache | Utah | 49005 | 23592 | 77 |
1959231 | 1959231 | 2021-11-27 | Cache | Utah | 49005 | 23592 | 77 |
1955980 | 1955980 | 2021-11-26 | Cache | Utah | 49005 | 23592 | 77 |
1952729 | 1952729 | 2021-11-25 | Cache | Utah | 49005 | 23483 | 77 |
1949478 | 1949478 | 2021-11-24 | Cache | Utah | 49005 | 23483 | 77 |
1946227 | 1946227 | 2021-11-23 | Cache | Utah | 49005 | 23390 | 76 |
1942976 | 1942976 | 2021-11-22 | Cache | Utah | 49005 | 23371 | 74 |
1939726 | 1939726 | 2021-11-21 | Cache | Utah | 49005 | 23218 | 74 |
1936476 | 1936476 | 2021-11-20 | Cache | Utah | 49005 | 23218 | 74 |
1933226 | 1933226 | 2021-11-19 | Cache | Utah | 49005 | 23218 | 74 |
1929975 | 1929975 | 2021-11-18 | Cache | Utah | 49005 | 23146 | 73 |
1926725 | 1926725 | 2021-11-17 | Cache | Utah | 49005 | 22969 | 72 |
1923475 | 1923475 | 2021-11-16 | Cache | Utah | 49005 | 22969 | 72 |
1920226 | 1920226 | 2021-11-15 | Cache | Utah | 49005 | 22715 | 72 |
1916976 | 1916976 | 2021-11-14 | Cache | Utah | 49005 | 22715 | 72 |
1913726 | 1913726 | 2021-11-13 | Cache | Utah | 49005 | 22715 | 72 |
1910476 | 1910476 | 2021-11-12 | Cache | Utah | 49005 | 22715 | 72 |
1907227 | 1907227 | 2021-11-11 | Cache | Utah | 49005 | 22570 | 72 |
1903978 | 1903978 | 2021-11-10 | Cache | Utah | 49005 | 22517 | 72 |
1900728 | 1900728 | 2021-11-09 | Cache | Utah | 49005 | 22517 | 72 |
1897478 | 1897478 | 2021-11-08 | Cache | Utah | 49005 | 22330 | 70 |
1894228 | 1894228 | 2021-11-07 | Cache | Utah | 49005 | 22330 | 70 |
1890978 | 1890978 | 2021-11-06 | Cache | Utah | 49005 | 22330 | 70 |
1887728 | 1887728 | 2021-11-05 | Cache | Utah | 49005 | 22330 | 70 |
1884478 | 1884478 | 2021-11-04 | Cache | Utah | 49005 | 22266 | 70 |
1881229 | 1881229 | 2021-11-03 | Cache | Utah | 49005 | 22156 | 68 |
1877980 | 1877980 | 2021-11-02 | Cache | Utah | 49005 | 22082 | 68 |
1874731 | 1874731 | 2021-11-01 | Cache | Utah | 49005 | 21944 | 67 |
1871482 | 1871482 | 2021-10-31 | Cache | Utah | 49005 | 21944 | 67 |
1868233 | 1868233 | 2021-10-30 | Cache | Utah | 49005 | 21944 | 67 |
1864984 | 1864984 | 2021-10-29 | Cache | Utah | 49005 | 21944 | 67 |
1861735 | 1861735 | 2021-10-28 | Cache | Utah | 49005 | 21815 | 66 |
1858486 | 1858486 | 2021-10-27 | Cache | Utah | 49005 | 21815 | 66 |
1855237 | 1855237 | 2021-10-26 | Cache | Utah | 49005 | 21731 | 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);