ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where date = "2021-09-30" 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 |
---|---|---|---|---|---|---|---|
1770755 | 1770755 | 2021-09-30 | Beaver | Utah | 49001 | 968 | 11 |
1770756 | 1770756 | 2021-09-30 | Box Elder | Utah | 49003 | 7522 | 71 |
1770757 | 1770757 | 2021-09-30 | Cache | Utah | 49005 | 20138 | 59 |
1770758 | 1770758 | 2021-09-30 | Carbon | Utah | 49007 | 2509 | 23 |
1770759 | 1770759 | 2021-09-30 | Daggett | Utah | 49009 | 92 | 0 |
1770760 | 1770760 | 2021-09-30 | Davis | Utah | 49011 | 50140 | 241 |
1770761 | 1770761 | 2021-09-30 | Duchesne | Utah | 49013 | 2638 | 14 |
1770762 | 1770762 | 2021-09-30 | Emery | Utah | 49015 | 1277 | 16 |
1770763 | 1770763 | 2021-09-30 | Garfield | Utah | 49017 | 590 | 11 |
1770764 | 1770764 | 2021-09-30 | Grand | Utah | 49019 | 1298 | 4 |
1770765 | 1770765 | 2021-09-30 | Iron | Utah | 49021 | 8382 | 49 |
1770766 | 1770766 | 2021-09-30 | Juab | Utah | 49023 | 1774 | 16 |
1770767 | 1770767 | 2021-09-30 | Kane | Utah | 49025 | 887 | 9 |
1770768 | 1770768 | 2021-09-30 | Millard | Utah | 49027 | 1990 | 23 |
1770769 | 1770769 | 2021-09-30 | Morgan | Utah | 49029 | 1622 | 11 |
1770770 | 1770770 | 2021-09-30 | Piute | Utah | 49031 | 150 | 2 |
1770771 | 1770771 | 2021-09-30 | Rich | Utah | 49033 | 196 | 0 |
1770772 | 1770772 | 2021-09-30 | Salt Lake | Utah | 49035 | 182694 | 1081 |
1770773 | 1770773 | 2021-09-30 | San Juan | Utah | 49037 | 2229 | 40 |
1770774 | 1770774 | 2021-09-30 | Sanpete | Utah | 49039 | 5023 | 31 |
1770775 | 1770775 | 2021-09-30 | Sevier | Utah | 49041 | 3341 | 16 |
1770776 | 1770776 | 2021-09-30 | Summit | Utah | 49043 | 6421 | 18 |
1770777 | 1770777 | 2021-09-30 | Tooele | Utah | 49045 | 10569 | 57 |
1770778 | 1770778 | 2021-09-30 | Uintah | Utah | 49047 | 4537 | 38 |
1770779 | 1770779 | 2021-09-30 | Unknown | Utah | 1783 | 37 | |
1770780 | 1770780 | 2021-09-30 | Utah | Utah | 49049 | 118138 | 503 |
1770781 | 1770781 | 2021-09-30 | Wasatch | Utah | 49051 | 5709 | 27 |
1770782 | 1770782 | 2021-09-30 | Washington | Utah | 49053 | 27197 | 258 |
1770783 | 1770783 | 2021-09-30 | Wayne | Utah | 49055 | 224 | 0 |
1770784 | 1770784 | 2021-09-30 | Weber | Utah | 49057 | 38555 | 266 |
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);