ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where deaths = 2 and fips = 8117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
240429 | 240429 | 2020-06-15 | Summit | Colorado | 8117 | 257 | 2 |
237321 | 237321 | 2020-06-14 | Summit | Colorado | 8117 | 256 | 2 |
234214 | 234214 | 2020-06-13 | Summit | Colorado | 8117 | 256 | 2 |
231108 | 231108 | 2020-06-12 | Summit | Colorado | 8117 | 254 | 2 |
228005 | 228005 | 2020-06-11 | Summit | Colorado | 8117 | 253 | 2 |
224903 | 224903 | 2020-06-10 | Summit | Colorado | 8117 | 252 | 2 |
221808 | 221808 | 2020-06-09 | Summit | Colorado | 8117 | 248 | 2 |
218713 | 218713 | 2020-06-08 | Summit | Colorado | 8117 | 247 | 2 |
215622 | 215622 | 2020-06-07 | Summit | Colorado | 8117 | 248 | 2 |
212535 | 212535 | 2020-06-06 | Summit | Colorado | 8117 | 243 | 2 |
209450 | 209450 | 2020-06-05 | Summit | Colorado | 8117 | 239 | 2 |
206369 | 206369 | 2020-06-04 | Summit | Colorado | 8117 | 239 | 2 |
203289 | 203289 | 2020-06-03 | Summit | Colorado | 8117 | 237 | 2 |
200213 | 200213 | 2020-06-02 | Summit | Colorado | 8117 | 233 | 2 |
197140 | 197140 | 2020-06-01 | Summit | Colorado | 8117 | 231 | 2 |
194070 | 194070 | 2020-05-31 | Summit | Colorado | 8117 | 226 | 2 |
191003 | 191003 | 2020-05-30 | Summit | Colorado | 8117 | 224 | 2 |
187938 | 187938 | 2020-05-29 | Summit | Colorado | 8117 | 219 | 2 |
184882 | 184882 | 2020-05-28 | Summit | Colorado | 8117 | 213 | 2 |
181828 | 181828 | 2020-05-27 | Summit | Colorado | 8117 | 214 | 2 |
178784 | 178784 | 2020-05-26 | Summit | Colorado | 8117 | 212 | 2 |
175740 | 175740 | 2020-05-25 | Summit | Colorado | 8117 | 205 | 2 |
172696 | 172696 | 2020-05-24 | Summit | Colorado | 8117 | 207 | 2 |
169655 | 169655 | 2020-05-23 | Summit | Colorado | 8117 | 203 | 2 |
166618 | 166618 | 2020-05-22 | Summit | Colorado | 8117 | 197 | 2 |
163585 | 163585 | 2020-05-21 | Summit | Colorado | 8117 | 195 | 2 |
160557 | 160557 | 2020-05-20 | Summit | Colorado | 8117 | 194 | 2 |
157531 | 157531 | 2020-05-19 | Summit | Colorado | 8117 | 192 | 2 |
154515 | 154515 | 2020-05-18 | Summit | Colorado | 8117 | 186 | 2 |
151503 | 151503 | 2020-05-17 | Summit | Colorado | 8117 | 183 | 2 |
148494 | 148494 | 2020-05-16 | Summit | Colorado | 8117 | 182 | 2 |
145491 | 145491 | 2020-05-15 | Summit | Colorado | 8117 | 178 | 2 |
142491 | 142491 | 2020-05-14 | Summit | Colorado | 8117 | 175 | 2 |
139495 | 139495 | 2020-05-13 | Summit | Colorado | 8117 | 174 | 2 |
136504 | 136504 | 2020-05-12 | Summit | Colorado | 8117 | 171 | 2 |
133515 | 133515 | 2020-05-11 | Summit | Colorado | 8117 | 169 | 2 |
130524 | 130524 | 2020-05-10 | Summit | Colorado | 8117 | 165 | 2 |
127533 | 127533 | 2020-05-09 | Summit | Colorado | 8117 | 162 | 2 |
124547 | 124547 | 2020-05-08 | Summit | Colorado | 8117 | 156 | 2 |
121567 | 121567 | 2020-05-07 | Summit | Colorado | 8117 | 155 | 2 |
118598 | 118598 | 2020-05-06 | Summit | Colorado | 8117 | 155 | 2 |
115638 | 115638 | 2020-05-05 | Summit | Colorado | 8117 | 151 | 2 |
112755 | 112755 | 2020-05-04 | Summit | Colorado | 8117 | 144 | 2 |
109880 | 109880 | 2020-05-03 | Summit | Colorado | 8117 | 144 | 2 |
107011 | 107011 | 2020-05-02 | Summit | Colorado | 8117 | 136 | 2 |
104146 | 104146 | 2020-05-01 | Summit | Colorado | 8117 | 130 | 2 |
101291 | 101291 | 2020-04-30 | Summit | Colorado | 8117 | 128 | 2 |
98441 | 98441 | 2020-04-29 | Summit | Colorado | 8117 | 121 | 2 |
95596 | 95596 | 2020-04-28 | Summit | Colorado | 8117 | 119 | 2 |
92764 | 92764 | 2020-04-27 | Summit | Colorado | 8117 | 106 | 2 |
89946 | 89946 | 2020-04-26 | Summit | Colorado | 8117 | 105 | 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);