ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where date = "2020-05-11" 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 |
---|---|---|---|---|---|---|---|
135869 | 135869 | 2020-05-11 | Box Elder | Utah | 49003 | 21 | 1 |
135870 | 135870 | 2020-05-11 | Cache | Utah | 49005 | 59 | 0 |
135871 | 135871 | 2020-05-11 | Carbon | Utah | 49007 | 7 | 0 |
135872 | 135872 | 2020-05-11 | Davis | Utah | 49011 | 338 | 2 |
135873 | 135873 | 2020-05-11 | Duchesne | Utah | 49013 | 9 | 0 |
135874 | 135874 | 2020-05-11 | Emery | Utah | 49015 | 5 | 0 |
135875 | 135875 | 2020-05-11 | Garfield | Utah | 49017 | 3 | 0 |
135876 | 135876 | 2020-05-11 | Grand | Utah | 49019 | 4 | 0 |
135877 | 135877 | 2020-05-11 | Iron | Utah | 49021 | 29 | 0 |
135878 | 135878 | 2020-05-11 | Juab | Utah | 49023 | 8 | 0 |
135879 | 135879 | 2020-05-11 | Kane | Utah | 49025 | 3 | 0 |
135880 | 135880 | 2020-05-11 | Millard | Utah | 49027 | 5 | 0 |
135881 | 135881 | 2020-05-11 | Morgan | Utah | 49029 | 10 | 0 |
135882 | 135882 | 2020-05-11 | Piute | Utah | 49031 | 1 | 0 |
135883 | 135883 | 2020-05-11 | Salt Lake | Utah | 49035 | 3370 | 48 |
135884 | 135884 | 2020-05-11 | San Juan | Utah | 49037 | 149 | 3 |
135885 | 135885 | 2020-05-11 | Sanpete | Utah | 49039 | 6 | 0 |
135886 | 135886 | 2020-05-11 | Sevier | Utah | 49041 | 8 | 0 |
135887 | 135887 | 2020-05-11 | Summit | Utah | 49043 | 386 | 0 |
135888 | 135888 | 2020-05-11 | Tooele | Utah | 49045 | 77 | 0 |
135889 | 135889 | 2020-05-11 | Uintah | Utah | 49047 | 7 | 0 |
135890 | 135890 | 2020-05-11 | Utah | Utah | 49049 | 1358 | 11 |
135891 | 135891 | 2020-05-11 | Wasatch | Utah | 49051 | 183 | 1 |
135892 | 135892 | 2020-05-11 | Washington | Utah | 49053 | 125 | 0 |
135893 | 135893 | 2020-05-11 | Weber | Utah | 49057 | 193 | 2 |
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);