ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where fips = 49039 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177096 | 2177096 | 2022-02-02 | Sanpete | Utah | 49039 | 7390 | 48 |
2173843 | 2173843 | 2022-02-01 | Sanpete | Utah | 49039 | 7371 | 48 |
2170591 | 2170591 | 2022-01-31 | Sanpete | Utah | 49039 | 7329 | 48 |
2167337 | 2167337 | 2022-01-30 | Sanpete | Utah | 49039 | 7275 | 48 |
2164082 | 2164082 | 2022-01-29 | Sanpete | Utah | 49039 | 7275 | 48 |
2160827 | 2160827 | 2022-01-28 | Sanpete | Utah | 49039 | 7275 | 48 |
2157571 | 2157571 | 2022-01-27 | Sanpete | Utah | 49039 | 7232 | 48 |
2154318 | 2154318 | 2022-01-26 | Sanpete | Utah | 49039 | 7179 | 47 |
2151066 | 2151066 | 2022-01-25 | Sanpete | Utah | 49039 | 7093 | 47 |
2147814 | 2147814 | 2022-01-24 | Sanpete | Utah | 49039 | 6840 | 46 |
2144560 | 2144560 | 2022-01-23 | Sanpete | Utah | 49039 | 6840 | 46 |
2141305 | 2141305 | 2022-01-22 | Sanpete | Utah | 49039 | 6840 | 46 |
2138049 | 2138049 | 2022-01-21 | Sanpete | Utah | 49039 | 6840 | 46 |
2134795 | 2134795 | 2022-01-20 | Sanpete | Utah | 49039 | 6776 | 45 |
2131543 | 2131543 | 2022-01-19 | Sanpete | Utah | 49039 | 6717 | 45 |
2128289 | 2128289 | 2022-01-18 | Sanpete | Utah | 49039 | 6453 | 45 |
2125037 | 2125037 | 2022-01-17 | Sanpete | Utah | 49039 | 6453 | 45 |
2121785 | 2121785 | 2022-01-16 | Sanpete | Utah | 49039 | 6453 | 45 |
2118533 | 2118533 | 2022-01-15 | Sanpete | Utah | 49039 | 6453 | 45 |
2115281 | 2115281 | 2022-01-14 | Sanpete | Utah | 49039 | 6453 | 45 |
2112029 | 2112029 | 2022-01-13 | Sanpete | Utah | 49039 | 6414 | 45 |
2108777 | 2108777 | 2022-01-12 | Sanpete | Utah | 49039 | 6267 | 44 |
2105526 | 2105526 | 2022-01-11 | Sanpete | Utah | 49039 | 6267 | 44 |
2102275 | 2102275 | 2022-01-10 | Sanpete | Utah | 49039 | 6163 | 44 |
2099024 | 2099024 | 2022-01-09 | Sanpete | Utah | 49039 | 6163 | 44 |
2095772 | 2095772 | 2022-01-08 | Sanpete | Utah | 49039 | 6163 | 44 |
2092520 | 2092520 | 2022-01-07 | Sanpete | Utah | 49039 | 6163 | 44 |
2089268 | 2089268 | 2022-01-06 | Sanpete | Utah | 49039 | 6136 | 44 |
2086017 | 2086017 | 2022-01-05 | Sanpete | Utah | 49039 | 6024 | 44 |
2082765 | 2082765 | 2022-01-04 | Sanpete | Utah | 49039 | 6024 | 44 |
2079513 | 2079513 | 2022-01-03 | Sanpete | Utah | 49039 | 6023 | 44 |
2076262 | 2076262 | 2022-01-02 | Sanpete | Utah | 49039 | 5986 | 44 |
2073011 | 2073011 | 2022-01-01 | Sanpete | Utah | 49039 | 5986 | 44 |
2069760 | 2069760 | 2021-12-31 | Sanpete | Utah | 49039 | 5986 | 44 |
2066509 | 2066509 | 2021-12-30 | Sanpete | Utah | 49039 | 5972 | 43 |
2063259 | 2063259 | 2021-12-29 | Sanpete | Utah | 49039 | 5972 | 43 |
2060009 | 2060009 | 2021-12-28 | Sanpete | Utah | 49039 | 5956 | 43 |
2056760 | 2056760 | 2021-12-27 | Sanpete | Utah | 49039 | 5952 | 43 |
2053511 | 2053511 | 2021-12-26 | Sanpete | Utah | 49039 | 5929 | 43 |
2050261 | 2050261 | 2021-12-25 | Sanpete | Utah | 49039 | 5929 | 43 |
2047011 | 2047011 | 2021-12-24 | Sanpete | Utah | 49039 | 5929 | 43 |
2043761 | 2043761 | 2021-12-23 | Sanpete | Utah | 49039 | 5929 | 43 |
2040512 | 2040512 | 2021-12-22 | Sanpete | Utah | 49039 | 5921 | 43 |
2037262 | 2037262 | 2021-12-21 | Sanpete | Utah | 49039 | 5912 | 43 |
2034012 | 2034012 | 2021-12-20 | Sanpete | Utah | 49039 | 5905 | 43 |
2030762 | 2030762 | 2021-12-19 | Sanpete | Utah | 49039 | 5890 | 43 |
2027511 | 2027511 | 2021-12-18 | Sanpete | Utah | 49039 | 5890 | 43 |
2024260 | 2024260 | 2021-12-17 | Sanpete | Utah | 49039 | 5890 | 43 |
2021009 | 2021009 | 2021-12-16 | Sanpete | Utah | 49039 | 5875 | 43 |
2017758 | 2017758 | 2021-12-15 | Sanpete | Utah | 49039 | 5865 | 43 |
2014508 | 2014508 | 2021-12-14 | Sanpete | Utah | 49039 | 5843 | 43 |
2011257 | 2011257 | 2021-12-13 | Sanpete | Utah | 49039 | 5840 | 43 |
2008006 | 2008006 | 2021-12-12 | Sanpete | Utah | 49039 | 5828 | 43 |
2004755 | 2004755 | 2021-12-11 | Sanpete | Utah | 49039 | 5828 | 43 |
2001504 | 2001504 | 2021-12-10 | Sanpete | Utah | 49039 | 5828 | 43 |
1998254 | 1998254 | 2021-12-09 | Sanpete | Utah | 49039 | 5819 | 43 |
1995003 | 1995003 | 2021-12-08 | Sanpete | Utah | 49039 | 5807 | 43 |
1991752 | 1991752 | 2021-12-07 | Sanpete | Utah | 49039 | 5803 | 42 |
1988501 | 1988501 | 2021-12-06 | Sanpete | Utah | 49039 | 5787 | 40 |
1985251 | 1985251 | 2021-12-05 | Sanpete | Utah | 49039 | 5787 | 40 |
1982001 | 1982001 | 2021-12-04 | Sanpete | Utah | 49039 | 5787 | 40 |
1978751 | 1978751 | 2021-12-03 | Sanpete | Utah | 49039 | 5787 | 40 |
1975501 | 1975501 | 2021-12-02 | Sanpete | Utah | 49039 | 5780 | 40 |
1972252 | 1972252 | 2021-12-01 | Sanpete | Utah | 49039 | 5746 | 40 |
1969002 | 1969002 | 2021-11-30 | Sanpete | Utah | 49039 | 5746 | 40 |
1965751 | 1965751 | 2021-11-29 | Sanpete | Utah | 49039 | 5732 | 40 |
1962499 | 1962499 | 2021-11-28 | Sanpete | Utah | 49039 | 5714 | 40 |
1959248 | 1959248 | 2021-11-27 | Sanpete | Utah | 49039 | 5714 | 40 |
1955997 | 1955997 | 2021-11-26 | Sanpete | Utah | 49039 | 5714 | 40 |
1952746 | 1952746 | 2021-11-25 | Sanpete | Utah | 49039 | 5703 | 40 |
1949495 | 1949495 | 2021-11-24 | Sanpete | Utah | 49039 | 5703 | 40 |
1946244 | 1946244 | 2021-11-23 | Sanpete | Utah | 49039 | 5688 | 40 |
1942993 | 1942993 | 2021-11-22 | Sanpete | Utah | 49039 | 5680 | 40 |
1939743 | 1939743 | 2021-11-21 | Sanpete | Utah | 49039 | 5650 | 40 |
1936493 | 1936493 | 2021-11-20 | Sanpete | Utah | 49039 | 5650 | 40 |
1933243 | 1933243 | 2021-11-19 | Sanpete | Utah | 49039 | 5650 | 40 |
1929992 | 1929992 | 2021-11-18 | Sanpete | Utah | 49039 | 5639 | 40 |
1926742 | 1926742 | 2021-11-17 | Sanpete | Utah | 49039 | 5586 | 40 |
1923492 | 1923492 | 2021-11-16 | Sanpete | Utah | 49039 | 5586 | 40 |
1920243 | 1920243 | 2021-11-15 | Sanpete | Utah | 49039 | 5540 | 39 |
1916993 | 1916993 | 2021-11-14 | Sanpete | Utah | 49039 | 5540 | 39 |
1913743 | 1913743 | 2021-11-13 | Sanpete | Utah | 49039 | 5540 | 39 |
1910493 | 1910493 | 2021-11-12 | Sanpete | Utah | 49039 | 5540 | 39 |
1907244 | 1907244 | 2021-11-11 | Sanpete | Utah | 49039 | 5505 | 39 |
1903995 | 1903995 | 2021-11-10 | Sanpete | Utah | 49039 | 5501 | 39 |
1900745 | 1900745 | 2021-11-09 | Sanpete | Utah | 49039 | 5501 | 39 |
1897495 | 1897495 | 2021-11-08 | Sanpete | Utah | 49039 | 5469 | 39 |
1894245 | 1894245 | 2021-11-07 | Sanpete | Utah | 49039 | 5469 | 39 |
1890995 | 1890995 | 2021-11-06 | Sanpete | Utah | 49039 | 5469 | 39 |
1887745 | 1887745 | 2021-11-05 | Sanpete | Utah | 49039 | 5469 | 39 |
1884495 | 1884495 | 2021-11-04 | Sanpete | Utah | 49039 | 5462 | 39 |
1881246 | 1881246 | 2021-11-03 | Sanpete | Utah | 49039 | 5444 | 39 |
1877997 | 1877997 | 2021-11-02 | Sanpete | Utah | 49039 | 5427 | 39 |
1874748 | 1874748 | 2021-11-01 | Sanpete | Utah | 49039 | 5375 | 39 |
1871499 | 1871499 | 2021-10-31 | Sanpete | Utah | 49039 | 5375 | 39 |
1868250 | 1868250 | 2021-10-30 | Sanpete | Utah | 49039 | 5375 | 39 |
1865001 | 1865001 | 2021-10-29 | Sanpete | Utah | 49039 | 5375 | 39 |
1861752 | 1861752 | 2021-10-28 | Sanpete | Utah | 49039 | 5334 | 39 |
1858503 | 1858503 | 2021-10-27 | Sanpete | Utah | 49039 | 5334 | 39 |
1855254 | 1855254 | 2021-10-26 | Sanpete | Utah | 49039 | 5323 | 39 |
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);