ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where date = "2020-11-06" 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 |
---|---|---|---|---|---|---|---|
705884 | 705884 | 2020-11-06 | Beaver | Utah | 49001 | 100 | 1 |
705885 | 705885 | 2020-11-06 | Box Elder | Utah | 49003 | 1236 | 8 |
705886 | 705886 | 2020-11-06 | Cache | Utah | 49005 | 4772 | 12 |
705887 | 705887 | 2020-11-06 | Carbon | Utah | 49007 | 377 | 2 |
705888 | 705888 | 2020-11-06 | Daggett | Utah | 49009 | 1 | 0 |
705889 | 705889 | 2020-11-06 | Davis | Utah | 49011 | 10047 | 46 |
705890 | 705890 | 2020-11-06 | Duchesne | Utah | 49013 | 230 | 0 |
705891 | 705891 | 2020-11-06 | Emery | Utah | 49015 | 166 | 3 |
705892 | 705892 | 2020-11-06 | Garfield | Utah | 49017 | 120 | 5 |
705893 | 705893 | 2020-11-06 | Grand | Utah | 49019 | 155 | 1 |
705894 | 705894 | 2020-11-06 | Iron | Utah | 49021 | 1056 | 4 |
705895 | 705895 | 2020-11-06 | Juab | Utah | 49023 | 306 | 5 |
705896 | 705896 | 2020-11-06 | Kane | Utah | 49025 | 107 | 1 |
705897 | 705897 | 2020-11-06 | Millard | Utah | 49027 | 294 | 1 |
705898 | 705898 | 2020-11-06 | Morgan | Utah | 49029 | 261 | 0 |
705899 | 705899 | 2020-11-06 | Piute | Utah | 49031 | 31 | 1 |
705900 | 705900 | 2020-11-06 | Rich | Utah | 49033 | 24 | 0 |
705901 | 705901 | 2020-11-06 | Salt Lake | Utah | 49035 | 54332 | 326 |
705902 | 705902 | 2020-11-06 | San Juan | Utah | 49037 | 859 | 30 |
705903 | 705903 | 2020-11-06 | Sanpete | Utah | 49039 | 559 | 2 |
705904 | 705904 | 2020-11-06 | Sevier | Utah | 49041 | 376 | 1 |
705905 | 705905 | 2020-11-06 | Summit | Utah | 49043 | 1638 | 1 |
705906 | 705906 | 2020-11-06 | Tooele | Utah | 49045 | 1753 | 7 |
705907 | 705907 | 2020-11-06 | Uintah | Utah | 49047 | 364 | 0 |
705908 | 705908 | 2020-11-06 | Unknown | Utah | 95 | 5 | |
705909 | 705909 | 2020-11-06 | Utah | Utah | 49049 | 32927 | 93 |
705910 | 705910 | 2020-11-06 | Wasatch | Utah | 49051 | 1317 | 9 |
705911 | 705911 | 2020-11-06 | Washington | Utah | 49053 | 5836 | 49 |
705912 | 705912 | 2020-11-06 | Wayne | Utah | 49055 | 26 | 0 |
705913 | 705913 | 2020-11-06 | Weber | Utah | 49057 | 7929 | 36 |
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);