ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where date = "2020-09-30" and state = "Utah" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
585876 | 585876 | 2020-09-30 | Beaver | Utah | 49001 | 40 | 0 |
585877 | 585877 | 2020-09-30 | Box Elder | Utah | 49003 | 576 | 5 |
585878 | 585878 | 2020-09-30 | Cache | Utah | 49005 | 2803 | 6 |
585879 | 585879 | 2020-09-30 | Carbon | Utah | 49007 | 134 | 0 |
585880 | 585880 | 2020-09-30 | Daggett | Utah | 49009 | 1 | 0 |
585881 | 585881 | 2020-09-30 | Davis | Utah | 49011 | 5307 | 30 |
585882 | 585882 | 2020-09-30 | Duchesne | Utah | 49013 | 107 | 0 |
585883 | 585883 | 2020-09-30 | Emery | Utah | 49015 | 44 | 0 |
585884 | 585884 | 2020-09-30 | Garfield | Utah | 49017 | 49 | 2 |
585885 | 585885 | 2020-09-30 | Grand | Utah | 49019 | 59 | 1 |
585886 | 585886 | 2020-09-30 | Iron | Utah | 49021 | 761 | 3 |
585887 | 585887 | 2020-09-30 | Juab | Utah | 49023 | 143 | 2 |
585888 | 585888 | 2020-09-30 | Kane | Utah | 49025 | 84 | 1 |
585889 | 585889 | 2020-09-30 | Millard | Utah | 49027 | 191 | 0 |
585890 | 585890 | 2020-09-30 | Morgan | Utah | 49029 | 107 | 0 |
585891 | 585891 | 2020-09-30 | Piute | Utah | 49031 | 9 | 0 |
585892 | 585892 | 2020-09-30 | Rich | Utah | 49033 | 19 | 0 |
585893 | 585893 | 2020-09-30 | Salt Lake | Utah | 49035 | 31700 | 254 |
585894 | 585894 | 2020-09-30 | San Juan | Utah | 49037 | 703 | 29 |
585895 | 585895 | 2020-09-30 | Sanpete | Utah | 49039 | 218 | 1 |
585896 | 585896 | 2020-09-30 | Sevier | Utah | 49041 | 112 | 1 |
585897 | 585897 | 2020-09-30 | Summit | Utah | 49043 | 1022 | 1 |
585898 | 585898 | 2020-09-30 | Tooele | Utah | 49045 | 893 | 0 |
585899 | 585899 | 2020-09-30 | Uintah | Utah | 49047 | 111 | 0 |
585900 | 585900 | 2020-09-30 | Unknown | Utah | 24 | 1 | |
585901 | 585901 | 2020-09-30 | Utah | Utah | 49049 | 19360 | 57 |
585902 | 585902 | 2020-09-30 | Wasatch | Utah | 49051 | 793 | 7 |
585903 | 585903 | 2020-09-30 | Washington | Utah | 49053 | 3370 | 28 |
585904 | 585904 | 2020-09-30 | Wayne | Utah | 49055 | 2 | 0 |
585905 | 585905 | 2020-09-30 | Weber | Utah | 49057 | 4311 | 31 |
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);