ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where "date" is on date 2020-05-27 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 |
---|---|---|---|---|---|---|---|
184233 | 184233 | 2020-05-27 | Box Elder | Utah | 49003 | 26 | 1 |
184234 | 184234 | 2020-05-27 | Cache | Utah | 49005 | 89 | 1 |
184235 | 184235 | 2020-05-27 | Carbon | Utah | 49007 | 11 | 0 |
184236 | 184236 | 2020-05-27 | Davis | Utah | 49011 | 424 | 2 |
184237 | 184237 | 2020-05-27 | Duchesne | Utah | 49013 | 8 | 0 |
184238 | 184238 | 2020-05-27 | Emery | Utah | 49015 | 7 | 0 |
184239 | 184239 | 2020-05-27 | Garfield | Utah | 49017 | 3 | 0 |
184240 | 184240 | 2020-05-27 | Grand | Utah | 49019 | 7 | 0 |
184241 | 184241 | 2020-05-27 | Iron | Utah | 49021 | 46 | 0 |
184242 | 184242 | 2020-05-27 | Juab | Utah | 49023 | 10 | 0 |
184243 | 184243 | 2020-05-27 | Kane | Utah | 49025 | 3 | 0 |
184244 | 184244 | 2020-05-27 | Millard | Utah | 49027 | 6 | 0 |
184245 | 184245 | 2020-05-27 | Morgan | Utah | 49029 | 11 | 0 |
184246 | 184246 | 2020-05-27 | Piute | Utah | 49031 | 2 | 0 |
184247 | 184247 | 2020-05-27 | Salt Lake | Utah | 49035 | 4682 | 71 |
184248 | 184248 | 2020-05-27 | San Juan | Utah | 49037 | 272 | 5 |
184249 | 184249 | 2020-05-27 | Sanpete | Utah | 49039 | 7 | 0 |
184250 | 184250 | 2020-05-27 | Sevier | Utah | 49041 | 8 | 0 |
184251 | 184251 | 2020-05-27 | Summit | Utah | 49043 | 407 | 0 |
184252 | 184252 | 2020-05-27 | Tooele | Utah | 49045 | 115 | 0 |
184253 | 184253 | 2020-05-27 | Uintah | Utah | 49047 | 9 | 0 |
184254 | 184254 | 2020-05-27 | Unknown | Utah | 0 | 4 | |
184255 | 184255 | 2020-05-27 | Utah | Utah | 49049 | 1753 | 15 |
184256 | 184256 | 2020-05-27 | Wasatch | Utah | 49051 | 258 | 1 |
184257 | 184257 | 2020-05-27 | Washington | Utah | 49053 | 283 | 0 |
184258 | 184258 | 2020-05-27 | Weber | Utah | 49057 | 263 | 5 |
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);