ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where deaths = 29 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 |
---|---|---|---|---|---|---|---|
2294167 | 2294167 | 2022-03-10 | Sevier | Utah | 49041 | 5421 | 29 |
1988508 | 1988508 | 2021-12-06 | Wasatch | Utah | 49051 | 6772 | 29 |
1985258 | 1985258 | 2021-12-05 | Wasatch | Utah | 49051 | 6734 | 29 |
1982008 | 1982008 | 2021-12-04 | Wasatch | Utah | 49051 | 6734 | 29 |
1978758 | 1978758 | 2021-12-03 | Wasatch | Utah | 49051 | 6734 | 29 |
1975508 | 1975508 | 2021-12-02 | Wasatch | Utah | 49051 | 6727 | 29 |
1972259 | 1972259 | 2021-12-01 | Wasatch | Utah | 49051 | 6709 | 29 |
1969009 | 1969009 | 2021-11-30 | Wasatch | Utah | 49051 | 6685 | 29 |
1965758 | 1965758 | 2021-11-29 | Wasatch | Utah | 49051 | 6656 | 29 |
1962506 | 1962506 | 2021-11-28 | Wasatch | Utah | 49051 | 6629 | 29 |
1959255 | 1959255 | 2021-11-27 | Wasatch | Utah | 49051 | 6629 | 29 |
1956004 | 1956004 | 2021-11-26 | Wasatch | Utah | 49051 | 6629 | 29 |
1952753 | 1952753 | 2021-11-25 | Wasatch | Utah | 49051 | 6602 | 29 |
1949502 | 1949502 | 2021-11-24 | Wasatch | Utah | 49051 | 6602 | 29 |
1946251 | 1946251 | 2021-11-23 | Wasatch | Utah | 49051 | 6587 | 29 |
1943000 | 1943000 | 2021-11-22 | Wasatch | Utah | 49051 | 6564 | 29 |
1939750 | 1939750 | 2021-11-21 | Wasatch | Utah | 49051 | 6513 | 29 |
1936500 | 1936500 | 2021-11-20 | Wasatch | Utah | 49051 | 6513 | 29 |
1933250 | 1933250 | 2021-11-19 | Wasatch | Utah | 49051 | 6513 | 29 |
1929999 | 1929999 | 2021-11-18 | Wasatch | Utah | 49051 | 6488 | 29 |
1926749 | 1926749 | 2021-11-17 | Wasatch | Utah | 49051 | 6480 | 29 |
1923499 | 1923499 | 2021-11-16 | Wasatch | Utah | 49051 | 6451 | 29 |
1920250 | 1920250 | 2021-11-15 | Wasatch | Utah | 49051 | 6423 | 29 |
1858487 | 1858487 | 2021-10-27 | Carbon | Utah | 49007 | 3072 | 29 |
1738286 | 1738286 | 2021-09-20 | Sanpete | Utah | 49039 | 4799 | 29 |
1735036 | 1735036 | 2021-09-19 | Sanpete | Utah | 49039 | 4799 | 29 |
1731786 | 1731786 | 2021-09-18 | Sanpete | Utah | 49039 | 4799 | 29 |
1728536 | 1728536 | 2021-09-17 | Sanpete | Utah | 49039 | 4799 | 29 |
1725287 | 1725287 | 2021-09-16 | Sanpete | Utah | 49039 | 4762 | 29 |
1722038 | 1722038 | 2021-09-15 | Sanpete | Utah | 49039 | 4762 | 29 |
1718790 | 1718790 | 2021-09-14 | Sanpete | Utah | 49039 | 4745 | 29 |
1692812 | 1692812 | 2021-09-06 | Unknown | Utah | 1154 | 29 | |
1689563 | 1689563 | 2021-09-05 | Unknown | Utah | 1517 | 29 | |
1686313 | 1686313 | 2021-09-04 | Unknown | Utah | 1517 | 29 | |
1683062 | 1683062 | 2021-09-03 | Unknown | Utah | 1536 | 29 | |
1679812 | 1679812 | 2021-09-02 | Unknown | Utah | 1398 | 29 | |
1575863 | 1575863 | 2021-08-01 | Uintah | Utah | 49047 | 3344 | 29 |
1572615 | 1572615 | 2021-07-31 | Uintah | Utah | 49047 | 3344 | 29 |
1569367 | 1569367 | 2021-07-30 | Uintah | Utah | 49047 | 3344 | 29 |
1566119 | 1566119 | 2021-07-29 | Uintah | Utah | 49047 | 3322 | 29 |
1562871 | 1562871 | 2021-07-28 | Uintah | Utah | 49047 | 3310 | 29 |
1536894 | 1536894 | 2021-07-20 | Unknown | Utah | 1235 | 29 | |
1523905 | 1523905 | 2021-07-16 | Unknown | Utah | 1578 | 29 | |
1053146 | 1053146 | 2021-02-21 | Iron | Utah | 49021 | 4882 | 29 |
1049899 | 1049899 | 2021-02-20 | Iron | Utah | 49021 | 4882 | 29 |
1046652 | 1046652 | 2021-02-19 | Iron | Utah | 49021 | 4882 | 29 |
1023946 | 1023946 | 2021-02-12 | Tooele | Utah | 49045 | 6246 | 29 |
1020681 | 1020681 | 2021-02-11 | Cache | Utah | 49005 | 14324 | 29 |
1017436 | 1017436 | 2021-02-10 | Cache | Utah | 49005 | 14276 | 29 |
952523 | 952523 | 2021-01-21 | Box Elder | Utah | 49003 | 4371 | 29 |
949278 | 949278 | 2021-01-20 | Box Elder | Utah | 49003 | 4345 | 29 |
946032 | 946032 | 2021-01-19 | Box Elder | Utah | 49003 | 4312 | 29 |
942785 | 942785 | 2021-01-18 | Box Elder | Utah | 49003 | 4286 | 29 |
939540 | 939540 | 2021-01-17 | Box Elder | Utah | 49003 | 4274 | 29 |
936295 | 936295 | 2021-01-16 | Box Elder | Utah | 49003 | 4266 | 29 |
647517 | 647517 | 2020-10-19 | San Juan | Utah | 49037 | 759 | 29 |
644271 | 644271 | 2020-10-18 | San Juan | Utah | 49037 | 754 | 29 |
641023 | 641023 | 2020-10-17 | San Juan | Utah | 49037 | 753 | 29 |
637776 | 637776 | 2020-10-16 | San Juan | Utah | 49037 | 745 | 29 |
634531 | 634531 | 2020-10-15 | San Juan | Utah | 49037 | 733 | 29 |
631286 | 631286 | 2020-10-14 | San Juan | Utah | 49037 | 732 | 29 |
628042 | 628042 | 2020-10-13 | San Juan | Utah | 49037 | 724 | 29 |
624799 | 624799 | 2020-10-12 | San Juan | Utah | 49037 | 724 | 29 |
621556 | 621556 | 2020-10-11 | San Juan | Utah | 49037 | 722 | 29 |
618313 | 618313 | 2020-10-10 | San Juan | Utah | 49037 | 718 | 29 |
615071 | 615071 | 2020-10-09 | San Juan | Utah | 49037 | 714 | 29 |
611830 | 611830 | 2020-10-08 | San Juan | Utah | 49037 | 713 | 29 |
608588 | 608588 | 2020-10-07 | San Juan | Utah | 49037 | 712 | 29 |
605345 | 605345 | 2020-10-06 | San Juan | Utah | 49037 | 709 | 29 |
602103 | 602103 | 2020-10-05 | San Juan | Utah | 49037 | 707 | 29 |
598860 | 598860 | 2020-10-04 | San Juan | Utah | 49037 | 705 | 29 |
598869 | 598869 | 2020-10-04 | Washington | Utah | 49053 | 3511 | 29 |
595617 | 595617 | 2020-10-03 | San Juan | Utah | 49037 | 704 | 29 |
595626 | 595626 | 2020-10-03 | Washington | Utah | 49053 | 3511 | 29 |
592375 | 592375 | 2020-10-02 | San Juan | Utah | 49037 | 704 | 29 |
592384 | 592384 | 2020-10-02 | Washington | Utah | 49053 | 3449 | 29 |
589135 | 589135 | 2020-10-01 | San Juan | Utah | 49037 | 703 | 29 |
585894 | 585894 | 2020-09-30 | San Juan | Utah | 49037 | 703 | 29 |
582641 | 582641 | 2020-09-29 | Davis | Utah | 49011 | 5215 | 29 |
582654 | 582654 | 2020-09-29 | San Juan | Utah | 49037 | 701 | 29 |
579415 | 579415 | 2020-09-28 | San Juan | Utah | 49037 | 700 | 29 |
576174 | 576174 | 2020-09-27 | San Juan | Utah | 49037 | 700 | 29 |
572930 | 572930 | 2020-09-26 | San Juan | Utah | 49037 | 699 | 29 |
569688 | 569688 | 2020-09-25 | San Juan | Utah | 49037 | 697 | 29 |
566447 | 566447 | 2020-09-24 | San Juan | Utah | 49037 | 695 | 29 |
563206 | 563206 | 2020-09-23 | San Juan | Utah | 49037 | 693 | 29 |
559967 | 559967 | 2020-09-22 | San Juan | Utah | 49037 | 693 | 29 |
556731 | 556731 | 2020-09-21 | San Juan | Utah | 49037 | 690 | 29 |
556742 | 556742 | 2020-09-21 | Weber | Utah | 49057 | 3954 | 29 |
553494 | 553494 | 2020-09-20 | San Juan | Utah | 49037 | 689 | 29 |
553505 | 553505 | 2020-09-20 | Weber | Utah | 49057 | 3941 | 29 |
550255 | 550255 | 2020-09-19 | San Juan | Utah | 49037 | 688 | 29 |
550266 | 550266 | 2020-09-19 | Weber | Utah | 49057 | 3915 | 29 |
547016 | 547016 | 2020-09-18 | San Juan | Utah | 49037 | 684 | 29 |
547027 | 547027 | 2020-09-18 | Weber | Utah | 49057 | 3858 | 29 |
543779 | 543779 | 2020-09-17 | San Juan | Utah | 49037 | 683 | 29 |
543790 | 543790 | 2020-09-17 | Weber | Utah | 49057 | 3794 | 29 |
540543 | 540543 | 2020-09-16 | San Juan | Utah | 49037 | 684 | 29 |
540554 | 540554 | 2020-09-16 | Weber | Utah | 49057 | 3768 | 29 |
537306 | 537306 | 2020-09-15 | San Juan | Utah | 49037 | 684 | 29 |
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);