ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where date = "2020-09-05" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
504939 | 504939 | 2020-09-05 | Beaver | Utah | 49001 | 33 | 0 |
504940 | 504940 | 2020-09-05 | Box Elder | Utah | 49003 | 451 | 5 |
504941 | 504941 | 2020-09-05 | Cache | Utah | 49005 | 2194 | 6 |
504942 | 504942 | 2020-09-05 | Carbon | Utah | 49007 | 85 | 0 |
504943 | 504943 | 2020-09-05 | Davis | Utah | 49011 | 4112 | 25 |
504944 | 504944 | 2020-09-05 | Duchesne | Utah | 49013 | 97 | 0 |
504945 | 504945 | 2020-09-05 | Emery | Utah | 49015 | 23 | 0 |
504946 | 504946 | 2020-09-05 | Garfield | Utah | 49017 | 46 | 2 |
504947 | 504947 | 2020-09-05 | Grand | Utah | 49019 | 57 | 1 |
504948 | 504948 | 2020-09-05 | Iron | Utah | 49021 | 678 | 2 |
504949 | 504949 | 2020-09-05 | Juab | Utah | 49023 | 107 | 1 |
504950 | 504950 | 2020-09-05 | Kane | Utah | 49025 | 67 | 1 |
504951 | 504951 | 2020-09-05 | Millard | Utah | 49027 | 141 | 0 |
504952 | 504952 | 2020-09-05 | Morgan | Utah | 49029 | 81 | 0 |
504953 | 504953 | 2020-09-05 | Piute | Utah | 49031 | 6 | 0 |
504954 | 504954 | 2020-09-05 | Rich | Utah | 49033 | 11 | 0 |
504955 | 504955 | 2020-09-05 | Salt Lake | Utah | 49035 | 24867 | 236 |
504956 | 504956 | 2020-09-05 | San Juan | Utah | 49037 | 671 | 29 |
504957 | 504957 | 2020-09-05 | Sanpete | Utah | 49039 | 174 | 1 |
504958 | 504958 | 2020-09-05 | Sevier | Utah | 49041 | 93 | 1 |
504959 | 504959 | 2020-09-05 | Summit | Utah | 49043 | 873 | 1 |
504960 | 504960 | 2020-09-05 | Tooele | Utah | 49045 | 723 | 0 |
504961 | 504961 | 2020-09-05 | Uintah | Utah | 49047 | 104 | 0 |
504962 | 504962 | 2020-09-05 | Unknown | Utah | 18 | 1 | |
504963 | 504963 | 2020-09-05 | Utah | Utah | 49049 | 11655 | 50 |
504964 | 504964 | 2020-09-05 | Wasatch | Utah | 49051 | 656 | 7 |
504965 | 504965 | 2020-09-05 | Washington | Utah | 49053 | 2896 | 23 |
504966 | 504966 | 2020-09-05 | Wayne | Utah | 49055 | 2 | 0 |
504967 | 504967 | 2020-09-05 | Weber | Utah | 49057 | 3443 | 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);