ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 52 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2248640 | 2248640 | 2022-02-24 | Sanpete | Utah | 49039 | 8205 | 52 |
2245389 | 2245389 | 2022-02-23 | Sanpete | Utah | 49039 | 8186 | 52 |
2037267 | 2037267 | 2021-12-21 | Unknown | Utah | 2198 | 52 | |
2034017 | 2034017 | 2021-12-20 | Unknown | Utah | 2143 | 52 | |
1926746 | 1926746 | 2021-11-17 | Uintah | Utah | 49047 | 5386 | 52 |
1923496 | 1923496 | 2021-11-16 | Uintah | Utah | 49047 | 5386 | 52 |
1920247 | 1920247 | 2021-11-15 | Uintah | Utah | 49047 | 5345 | 52 |
1916997 | 1916997 | 2021-11-14 | Uintah | Utah | 49047 | 5345 | 52 |
1913747 | 1913747 | 2021-11-13 | Uintah | Utah | 49047 | 5345 | 52 |
1910497 | 1910497 | 2021-11-12 | Uintah | Utah | 49047 | 5345 | 52 |
1829250 | 1829250 | 2021-10-18 | Iron | Utah | 49021 | 8837 | 52 |
1826001 | 1826001 | 2021-10-17 | Iron | Utah | 49021 | 8837 | 52 |
1822752 | 1822752 | 2021-10-16 | Iron | Utah | 49021 | 8837 | 52 |
1819503 | 1819503 | 2021-10-15 | Iron | Utah | 49021 | 8837 | 52 |
1816254 | 1816254 | 2021-10-14 | Iron | Utah | 49021 | 8814 | 52 |
1813006 | 1813006 | 2021-10-13 | Iron | Utah | 49021 | 8779 | 52 |
1809757 | 1809757 | 2021-10-12 | Iron | Utah | 49021 | 8732 | 52 |
1806507 | 1806507 | 2021-10-11 | Iron | Utah | 49021 | 8626 | 52 |
1803257 | 1803257 | 2021-10-10 | Iron | Utah | 49021 | 8626 | 52 |
1800008 | 1800008 | 2021-10-09 | Iron | Utah | 49021 | 8626 | 52 |
1796759 | 1796759 | 2021-10-08 | Iron | Utah | 49021 | 8626 | 52 |
1793510 | 1793510 | 2021-10-07 | Iron | Utah | 49021 | 8603 | 52 |
1718793 | 1718793 | 2021-09-14 | Tooele | Utah | 49045 | 9706 | 52 |
1715545 | 1715545 | 2021-09-13 | Tooele | Utah | 49045 | 9662 | 52 |
1712299 | 1712299 | 2021-09-12 | Tooele | Utah | 49045 | 9521 | 52 |
1709052 | 1709052 | 2021-09-11 | Tooele | Utah | 49045 | 9521 | 52 |
1705805 | 1705805 | 2021-09-10 | Tooele | Utah | 49045 | 9521 | 52 |
1702555 | 1702555 | 2021-09-09 | Tooele | Utah | 49045 | 9435 | 52 |
1699306 | 1699306 | 2021-09-08 | Tooele | Utah | 49045 | 9355 | 52 |
1696058 | 1696058 | 2021-09-07 | Tooele | Utah | 49045 | 9305 | 52 |
1692810 | 1692810 | 2021-09-06 | Tooele | Utah | 49045 | 9200 | 52 |
1689561 | 1689561 | 2021-09-05 | Tooele | Utah | 49045 | 9200 | 52 |
1686311 | 1686311 | 2021-09-04 | Tooele | Utah | 49045 | 9200 | 52 |
1683060 | 1683060 | 2021-09-03 | Tooele | Utah | 49045 | 9200 | 52 |
1679810 | 1679810 | 2021-09-02 | Tooele | Utah | 49045 | 9155 | 52 |
1585589 | 1585589 | 2021-08-04 | Cache | Utah | 49005 | 17237 | 52 |
1582339 | 1582339 | 2021-08-03 | Cache | Utah | 49005 | 17209 | 52 |
1579090 | 1579090 | 2021-08-02 | Cache | Utah | 49005 | 17186 | 52 |
1575842 | 1575842 | 2021-08-01 | Cache | Utah | 49005 | 17111 | 52 |
1572594 | 1572594 | 2021-07-31 | Cache | Utah | 49005 | 17111 | 52 |
1569346 | 1569346 | 2021-07-30 | Cache | Utah | 49005 | 17111 | 52 |
1566098 | 1566098 | 2021-07-29 | Cache | Utah | 49005 | 17066 | 52 |
1562850 | 1562850 | 2021-07-28 | Cache | Utah | 49005 | 16989 | 52 |
1559602 | 1559602 | 2021-07-27 | Cache | Utah | 49005 | 16969 | 52 |
1556355 | 1556355 | 2021-07-26 | Cache | Utah | 49005 | 16962 | 52 |
1553108 | 1553108 | 2021-07-25 | Cache | Utah | 49005 | 16888 | 52 |
1549861 | 1549861 | 2021-07-24 | Cache | Utah | 49005 | 16888 | 52 |
1546614 | 1546614 | 2021-07-23 | Cache | Utah | 49005 | 16888 | 52 |
1543367 | 1543367 | 2021-07-22 | Cache | Utah | 49005 | 16888 | 52 |
1540119 | 1540119 | 2021-07-21 | Cache | Utah | 49005 | 16854 | 52 |
1536872 | 1536872 | 2021-07-20 | Cache | Utah | 49005 | 16822 | 52 |
1533624 | 1533624 | 2021-07-19 | Cache | Utah | 49005 | 16806 | 52 |
1530377 | 1530377 | 2021-07-18 | Cache | Utah | 49005 | 16753 | 52 |
1527130 | 1527130 | 2021-07-17 | Cache | Utah | 49005 | 16753 | 52 |
1384307 | 1384307 | 2021-06-03 | Box Elder | Utah | 49003 | 5540 | 52 |
774057 | 774057 | 2020-11-27 | Weber | Utah | 49057 | 12265 | 52 |
728593 | 728593 | 2020-11-13 | Davis | Utah | 49011 | 11860 | 52 |
725372 | 725372 | 2020-11-12 | Washington | Utah | 49053 | 6558 | 52 |
722129 | 722129 | 2020-11-11 | Washington | Utah | 49053 | 6384 | 52 |
718886 | 718886 | 2020-11-10 | Washington | Utah | 49053 | 6300 | 52 |
530842 | 530842 | 2020-09-13 | Utah | Utah | 49049 | 13120 | 52 |
527605 | 527605 | 2020-09-12 | Utah | Utah | 49049 | 12816 | 52 |
524369 | 524369 | 2020-09-11 | Utah | Utah | 49049 | 12611 | 52 |
521133 | 521133 | 2020-09-10 | Utah | Utah | 49049 | 12392 | 52 |
144866 | 144866 | 2020-05-14 | Salt Lake | Utah | 49035 | 3609 | 52 |
141869 | 141869 | 2020-05-13 | Salt Lake | Utah | 49035 | 3530 | 52 |
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);