ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 63 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
state 1
- Utah · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1627821 | 1627821 | 2021-08-17 | Daggett | Utah | 49009 | 63 | 0 |
874649 | 874649 | 2020-12-28 | Rich | Utah | 49033 | 63 | 0 |
871403 | 871403 | 2020-12-27 | Piute | Utah | 49031 | 63 | 2 |
871404 | 871404 | 2020-12-27 | Rich | Utah | 49033 | 63 | 0 |
868158 | 868158 | 2020-12-26 | Piute | Utah | 49031 | 63 | 2 |
868159 | 868159 | 2020-12-26 | Rich | Utah | 49033 | 63 | 0 |
864913 | 864913 | 2020-12-25 | Piute | Utah | 49031 | 63 | 2 |
864914 | 864914 | 2020-12-25 | Rich | Utah | 49033 | 63 | 0 |
861668 | 861668 | 2020-12-24 | Piute | Utah | 49031 | 63 | 2 |
861669 | 861669 | 2020-12-24 | Rich | Utah | 49033 | 63 | 0 |
858423 | 858423 | 2020-12-23 | Piute | Utah | 49031 | 63 | 2 |
858424 | 858424 | 2020-12-23 | Rich | Utah | 49033 | 63 | 0 |
855178 | 855178 | 2020-12-22 | Piute | Utah | 49031 | 63 | 2 |
848701 | 848701 | 2020-12-20 | Wayne | Utah | 49055 | 63 | 0 |
845456 | 845456 | 2020-12-19 | Wayne | Utah | 49055 | 63 | 0 |
842210 | 842210 | 2020-12-18 | Wayne | Utah | 49055 | 63 | 0 |
838965 | 838965 | 2020-12-17 | Wayne | Utah | 49055 | 63 | 0 |
835719 | 835719 | 2020-12-16 | Wayne | Utah | 49055 | 63 | 0 |
832473 | 832473 | 2020-12-15 | Wayne | Utah | 49055 | 63 | 0 |
829226 | 829226 | 2020-12-14 | Wayne | Utah | 49055 | 63 | 0 |
615061 | 615061 | 2020-10-09 | Garfield | Utah | 49017 | 63 | 2 |
492015 | 492015 | 2020-09-01 | Kane | Utah | 49025 | 63 | 1 |
488782 | 488782 | 2020-08-31 | Kane | Utah | 49025 | 63 | 1 |
485549 | 485549 | 2020-08-30 | Kane | Utah | 49025 | 63 | 1 |
482314 | 482314 | 2020-08-29 | Kane | Utah | 49025 | 63 | 1 |
479080 | 479080 | 2020-08-28 | Kane | Utah | 49025 | 63 | 1 |
475847 | 475847 | 2020-08-27 | Kane | Utah | 49025 | 63 | 1 |
395229 | 395229 | 2020-08-02 | Juab | Utah | 49023 | 63 | 1 |
392013 | 392013 | 2020-08-01 | Juab | Utah | 49023 | 63 | 1 |
388796 | 388796 | 2020-07-31 | Juab | Utah | 49023 | 63 | 1 |
385579 | 385579 | 2020-07-30 | Juab | Utah | 49023 | 63 | 1 |
153876 | 153876 | 2020-05-17 | Cache | Utah | 49005 | 63 | 0 |
150865 | 150865 | 2020-05-16 | Cache | Utah | 49005 | 63 | 0 |
100684 | 100684 | 2020-04-29 | Tooele | Utah | 49045 | 63 | 0 |
32889 | 32889 | 2020-04-04 | Weber | Utah | 49057 | 63 | 1 |
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);