ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 1 and fips = 49051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
193443 | 193443 | 2020-05-30 | Wasatch | Utah | 49051 | 272 | 1 |
190377 | 190377 | 2020-05-29 | Wasatch | Utah | 49051 | 265 | 1 |
187313 | 187313 | 2020-05-28 | Wasatch | Utah | 49051 | 259 | 1 |
184256 | 184256 | 2020-05-27 | Wasatch | Utah | 49051 | 258 | 1 |
181205 | 181205 | 2020-05-26 | Wasatch | Utah | 49051 | 253 | 1 |
178161 | 178161 | 2020-05-25 | Wasatch | Utah | 49051 | 247 | 1 |
175116 | 175116 | 2020-05-24 | Wasatch | Utah | 49051 | 241 | 1 |
172073 | 172073 | 2020-05-23 | Wasatch | Utah | 49051 | 237 | 1 |
169032 | 169032 | 2020-05-22 | Wasatch | Utah | 49051 | 228 | 1 |
165996 | 165996 | 2020-05-21 | Wasatch | Utah | 49051 | 222 | 1 |
162967 | 162967 | 2020-05-20 | Wasatch | Utah | 49051 | 217 | 1 |
159939 | 159939 | 2020-05-19 | Wasatch | Utah | 49051 | 212 | 1 |
156915 | 156915 | 2020-05-18 | Wasatch | Utah | 49051 | 203 | 1 |
153898 | 153898 | 2020-05-17 | Wasatch | Utah | 49051 | 202 | 1 |
150887 | 150887 | 2020-05-16 | Wasatch | Utah | 49051 | 200 | 1 |
147878 | 147878 | 2020-05-15 | Wasatch | Utah | 49051 | 196 | 1 |
144875 | 144875 | 2020-05-14 | Wasatch | Utah | 49051 | 188 | 1 |
141878 | 141878 | 2020-05-13 | Wasatch | Utah | 49051 | 185 | 1 |
138882 | 138882 | 2020-05-12 | Wasatch | Utah | 49051 | 184 | 1 |
135891 | 135891 | 2020-05-11 | Wasatch | Utah | 49051 | 183 | 1 |
132901 | 132901 | 2020-05-10 | Wasatch | Utah | 49051 | 176 | 1 |
129911 | 129911 | 2020-05-09 | Wasatch | Utah | 49051 | 176 | 1 |
126922 | 126922 | 2020-05-08 | Wasatch | Utah | 49051 | 173 | 1 |
123937 | 123937 | 2020-05-07 | Wasatch | Utah | 49051 | 173 | 1 |
120956 | 120956 | 2020-05-06 | Wasatch | Utah | 49051 | 170 | 1 |
117992 | 117992 | 2020-05-05 | Wasatch | Utah | 49051 | 166 | 1 |
115033 | 115033 | 2020-05-04 | Wasatch | Utah | 49051 | 165 | 1 |
112150 | 112150 | 2020-05-03 | Wasatch | Utah | 49051 | 159 | 1 |
109276 | 109276 | 2020-05-02 | Wasatch | Utah | 49051 | 156 | 1 |
106407 | 106407 | 2020-05-01 | Wasatch | Utah | 49051 | 155 | 1 |
103543 | 103543 | 2020-04-30 | Wasatch | Utah | 49051 | 148 | 1 |
100688 | 100688 | 2020-04-29 | Wasatch | Utah | 49051 | 147 | 1 |
97838 | 97838 | 2020-04-28 | Wasatch | Utah | 49051 | 142 | 1 |
94996 | 94996 | 2020-04-27 | Wasatch | Utah | 49051 | 140 | 1 |
92167 | 92167 | 2020-04-26 | Wasatch | Utah | 49051 | 138 | 1 |
89350 | 89350 | 2020-04-25 | Wasatch | Utah | 49051 | 132 | 1 |
86535 | 86535 | 2020-04-24 | Wasatch | Utah | 49051 | 129 | 1 |
83728 | 83728 | 2020-04-23 | Wasatch | Utah | 49051 | 127 | 1 |
80927 | 80927 | 2020-04-22 | Wasatch | Utah | 49051 | 123 | 1 |
78135 | 78135 | 2020-04-21 | Wasatch | Utah | 49051 | 122 | 1 |
75353 | 75353 | 2020-04-20 | Wasatch | Utah | 49051 | 118 | 1 |
72577 | 72577 | 2020-04-19 | Wasatch | Utah | 49051 | 111 | 1 |
69807 | 69807 | 2020-04-18 | Wasatch | Utah | 49051 | 109 | 1 |
67045 | 67045 | 2020-04-17 | Wasatch | Utah | 49051 | 103 | 1 |
64297 | 64297 | 2020-04-16 | Wasatch | Utah | 49051 | 103 | 1 |
61565 | 61565 | 2020-04-15 | Wasatch | Utah | 49051 | 105 | 1 |
58846 | 58846 | 2020-04-14 | Wasatch | Utah | 49051 | 105 | 1 |
56140 | 56140 | 2020-04-13 | Wasatch | Utah | 49051 | 103 | 1 |
53451 | 53451 | 2020-04-12 | Wasatch | Utah | 49051 | 103 | 1 |
50776 | 50776 | 2020-04-11 | Wasatch | Utah | 49051 | 98 | 1 |
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);