ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where "date" is on date 2020-04-04 and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
32867 | 32867 | 2020-04-04 | Box Elder | Utah | 49003 | 10 | 0 |
32868 | 32868 | 2020-04-04 | Cache | Utah | 49005 | 15 | 0 |
32869 | 32869 | 2020-04-04 | Carbon | Utah | 49007 | 1 | 0 |
32870 | 32870 | 2020-04-04 | Davis | Utah | 49011 | 137 | 2 |
32871 | 32871 | 2020-04-04 | Duchesne | Utah | 49013 | 1 | 0 |
32872 | 32872 | 2020-04-04 | Emery | Utah | 49015 | 1 | 0 |
32873 | 32873 | 2020-04-04 | Garfield | Utah | 49017 | 1 | 0 |
32874 | 32874 | 2020-04-04 | Grand | Utah | 49019 | 1 | 0 |
32875 | 32875 | 2020-04-04 | Iron | Utah | 49021 | 10 | 0 |
32876 | 32876 | 2020-04-04 | Juab | Utah | 49023 | 1 | 0 |
32877 | 32877 | 2020-04-04 | Kane | Utah | 49025 | 1 | 0 |
32878 | 32878 | 2020-04-04 | Millard | Utah | 49027 | 1 | 0 |
32879 | 32879 | 2020-04-04 | Morgan | Utah | 49029 | 3 | 0 |
32880 | 32880 | 2020-04-04 | Salt Lake | Utah | 49035 | 650 | 1 |
32881 | 32881 | 2020-04-04 | San Juan | Utah | 49037 | 5 | 0 |
32882 | 32882 | 2020-04-04 | Summit | Utah | 49043 | 230 | 0 |
32883 | 32883 | 2020-04-04 | Tooele | Utah | 49045 | 17 | 0 |
32884 | 32884 | 2020-04-04 | Uintah | Utah | 49047 | 1 | 0 |
32885 | 32885 | 2020-04-04 | Unknown | Utah | 0 | 4 | |
32886 | 32886 | 2020-04-04 | Utah | Utah | 49049 | 186 | 0 |
32887 | 32887 | 2020-04-04 | Wasatch | Utah | 49051 | 70 | 0 |
32888 | 32888 | 2020-04-04 | Washington | Utah | 49053 | 21 | 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);