ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where deaths = 43 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- Utah · 112 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2222616 | 2222616 | 2022-02-16 | Carbon | Utah | 49007 | 5114 | 43 |
2219365 | 2219365 | 2022-02-15 | Carbon | Utah | 49007 | 5109 | 43 |
2216114 | 2216114 | 2022-02-14 | Carbon | Utah | 49007 | 5106 | 43 |
2212863 | 2212863 | 2022-02-13 | Carbon | Utah | 49007 | 5076 | 43 |
2209610 | 2209610 | 2022-02-12 | Carbon | Utah | 49007 | 5076 | 43 |
2206357 | 2206357 | 2022-02-11 | Carbon | Utah | 49007 | 5076 | 43 |
2203104 | 2203104 | 2022-02-10 | Carbon | Utah | 49007 | 5076 | 43 |
2199850 | 2199850 | 2022-02-09 | Carbon | Utah | 49007 | 5065 | 43 |
2196596 | 2196596 | 2022-02-08 | Carbon | Utah | 49007 | 5042 | 43 |
2193342 | 2193342 | 2022-02-07 | Carbon | Utah | 49007 | 5015 | 43 |
2190089 | 2190089 | 2022-02-06 | Carbon | Utah | 49007 | 5015 | 43 |
2186836 | 2186836 | 2022-02-05 | Carbon | Utah | 49007 | 5015 | 43 |
2183583 | 2183583 | 2022-02-04 | Carbon | Utah | 49007 | 5001 | 43 |
2180331 | 2180331 | 2022-02-03 | Carbon | Utah | 49007 | 4963 | 43 |
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 |
2008005 | 2008005 | 2021-12-12 | San Juan | Utah | 49037 | 2781 | 43 |
2008006 | 2008006 | 2021-12-12 | Sanpete | Utah | 49039 | 5828 | 43 |
2004754 | 2004754 | 2021-12-11 | San Juan | Utah | 49037 | 2781 | 43 |
2004755 | 2004755 | 2021-12-11 | Sanpete | Utah | 49039 | 5828 | 43 |
2001503 | 2001503 | 2021-12-10 | San Juan | Utah | 49037 | 2781 | 43 |
2001504 | 2001504 | 2021-12-10 | Sanpete | Utah | 49039 | 5828 | 43 |
1998253 | 1998253 | 2021-12-09 | San Juan | Utah | 49037 | 2778 | 43 |
1998254 | 1998254 | 2021-12-09 | Sanpete | Utah | 49039 | 5819 | 43 |
1995002 | 1995002 | 2021-12-08 | San Juan | Utah | 49037 | 2775 | 43 |
1995003 | 1995003 | 2021-12-08 | Sanpete | Utah | 49039 | 5807 | 43 |
1991751 | 1991751 | 2021-12-07 | San Juan | Utah | 49037 | 2766 | 43 |
1988500 | 1988500 | 2021-12-06 | San Juan | Utah | 49037 | 2764 | 43 |
1985250 | 1985250 | 2021-12-05 | San Juan | Utah | 49037 | 2740 | 43 |
1982000 | 1982000 | 2021-12-04 | San Juan | Utah | 49037 | 2740 | 43 |
1978750 | 1978750 | 2021-12-03 | San Juan | Utah | 49037 | 2740 | 43 |
1975500 | 1975500 | 2021-12-02 | San Juan | Utah | 49037 | 2730 | 43 |
1975506 | 1975506 | 2021-12-02 | Unknown | Utah | 2200 | 43 | |
1972251 | 1972251 | 2021-12-01 | San Juan | Utah | 49037 | 2720 | 43 |
1969001 | 1969001 | 2021-11-30 | San Juan | Utah | 49037 | 2706 | 43 |
1965750 | 1965750 | 2021-11-29 | San Juan | Utah | 49037 | 2703 | 43 |
1962498 | 1962498 | 2021-11-28 | San Juan | Utah | 49037 | 2692 | 43 |
1959247 | 1959247 | 2021-11-27 | San Juan | Utah | 49037 | 2692 | 43 |
1955996 | 1955996 | 2021-11-26 | San Juan | Utah | 49037 | 2692 | 43 |
1952745 | 1952745 | 2021-11-25 | San Juan | Utah | 49037 | 2682 | 43 |
1949494 | 1949494 | 2021-11-24 | San Juan | Utah | 49037 | 2682 | 43 |
1946243 | 1946243 | 2021-11-23 | San Juan | Utah | 49037 | 2667 | 43 |
1942992 | 1942992 | 2021-11-22 | San Juan | Utah | 49037 | 2664 | 43 |
1939742 | 1939742 | 2021-11-21 | San Juan | Utah | 49037 | 2644 | 43 |
1936492 | 1936492 | 2021-11-20 | San Juan | Utah | 49037 | 2644 | 43 |
1933242 | 1933242 | 2021-11-19 | San Juan | Utah | 49037 | 2644 | 43 |
1929991 | 1929991 | 2021-11-18 | San Juan | Utah | 49037 | 2635 | 43 |
1926741 | 1926741 | 2021-11-17 | San Juan | Utah | 49037 | 2620 | 43 |
1923491 | 1923491 | 2021-11-16 | San Juan | Utah | 49037 | 2609 | 43 |
1920242 | 1920242 | 2021-11-15 | San Juan | Utah | 49037 | 2605 | 43 |
1916992 | 1916992 | 2021-11-14 | San Juan | Utah | 49037 | 2588 | 43 |
1913742 | 1913742 | 2021-11-13 | San Juan | Utah | 49037 | 2588 | 43 |
1910492 | 1910492 | 2021-11-12 | San Juan | Utah | 49037 | 2588 | 43 |
1907243 | 1907243 | 2021-11-11 | San Juan | Utah | 49037 | 2567 | 43 |
1903994 | 1903994 | 2021-11-10 | San Juan | Utah | 49037 | 2567 | 43 |
1900744 | 1900744 | 2021-11-09 | San Juan | Utah | 49037 | 2560 | 43 |
1884500 | 1884500 | 2021-11-04 | Unknown | Utah | 2250 | 43 | |
1861756 | 1861756 | 2021-10-28 | Uintah | Utah | 49047 | 5040 | 43 |
1861757 | 1861757 | 2021-10-28 | Unknown | Utah | 2348 | 43 | |
1858507 | 1858507 | 2021-10-27 | Uintah | Utah | 49047 | 5040 | 43 |
1855258 | 1855258 | 2021-10-26 | Uintah | Utah | 49047 | 5016 | 43 |
1852009 | 1852009 | 2021-10-25 | Uintah | Utah | 49047 | 5008 | 43 |
1848759 | 1848759 | 2021-10-24 | Uintah | Utah | 49047 | 4963 | 43 |
1845509 | 1845509 | 2021-10-23 | Uintah | Utah | 49047 | 4963 | 43 |
1842259 | 1842259 | 2021-10-22 | Uintah | Utah | 49047 | 4963 | 43 |
1839010 | 1839010 | 2021-10-21 | Uintah | Utah | 49047 | 4937 | 43 |
1835761 | 1835761 | 2021-10-20 | Uintah | Utah | 49047 | 4937 | 43 |
1832512 | 1832512 | 2021-10-19 | Uintah | Utah | 49047 | 4914 | 43 |
1829263 | 1829263 | 2021-10-18 | Uintah | Utah | 49047 | 4856 | 43 |
1826014 | 1826014 | 2021-10-17 | Uintah | Utah | 49047 | 4856 | 43 |
1822765 | 1822765 | 2021-10-16 | Uintah | Utah | 49047 | 4856 | 43 |
1819516 | 1819516 | 2021-10-15 | Uintah | Utah | 49047 | 4856 | 43 |
1332386 | 1332386 | 2021-05-18 | Tooele | Utah | 49045 | 7327 | 43 |
1329139 | 1329139 | 2021-05-17 | Tooele | Utah | 49045 | 7319 | 43 |
1325893 | 1325893 | 2021-05-16 | Tooele | Utah | 49045 | 7311 | 43 |
1322647 | 1322647 | 2021-05-15 | Tooele | Utah | 49045 | 7299 | 43 |
1319401 | 1319401 | 2021-05-14 | Tooele | Utah | 49045 | 7290 | 43 |
1316153 | 1316153 | 2021-05-13 | Tooele | Utah | 49045 | 7284 | 43 |
1163513 | 1163513 | 2021-03-27 | Cache | Utah | 49005 | 15458 | 43 |
1160264 | 1160264 | 2021-03-26 | Cache | Utah | 49005 | 15441 | 43 |
1157017 | 1157017 | 2021-03-25 | Cache | Utah | 49005 | 15426 | 43 |
1153770 | 1153770 | 2021-03-24 | Cache | Utah | 49005 | 15400 | 43 |
1082347 | 1082347 | 2021-03-02 | Box Elder | Utah | 49003 | 4846 | 43 |
1079101 | 1079101 | 2021-03-01 | Box Elder | Utah | 49003 | 4843 | 43 |
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);