ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Montrose" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386225 | 386225 | 2020-07-31 | Montrose | Colorado | 8085 | 274 | 13 |
383007 | 383007 | 2020-07-30 | Montrose | Colorado | 8085 | 265 | 13 |
379790 | 379790 | 2020-07-29 | Montrose | Colorado | 8085 | 265 | 13 |
376573 | 376573 | 2020-07-28 | Montrose | Colorado | 8085 | 263 | 13 |
373359 | 373359 | 2020-07-27 | Montrose | Colorado | 8085 | 260 | 13 |
370147 | 370147 | 2020-07-26 | Montrose | Colorado | 8085 | 262 | 13 |
366937 | 366937 | 2020-07-25 | Montrose | Colorado | 8085 | 255 | 13 |
363730 | 363730 | 2020-07-24 | Montrose | Colorado | 8085 | 251 | 13 |
360523 | 360523 | 2020-07-23 | Montrose | Colorado | 8085 | 248 | 13 |
357318 | 357318 | 2020-07-22 | Montrose | Colorado | 8085 | 245 | 13 |
354115 | 354115 | 2020-07-21 | Montrose | Colorado | 8085 | 236 | 12 |
350913 | 350913 | 2020-07-20 | Montrose | Colorado | 8085 | 235 | 12 |
347712 | 347712 | 2020-07-19 | Montrose | Colorado | 8085 | 234 | 12 |
344512 | 344512 | 2020-07-18 | Montrose | Colorado | 8085 | 232 | 12 |
341313 | 341313 | 2020-07-17 | Montrose | Colorado | 8085 | 229 | 12 |
338116 | 338116 | 2020-07-16 | Montrose | Colorado | 8085 | 225 | 12 |
334921 | 334921 | 2020-07-15 | Montrose | Colorado | 8085 | 222 | 12 |
331728 | 331728 | 2020-07-14 | Montrose | Colorado | 8085 | 223 | 12 |
328542 | 328542 | 2020-07-13 | Montrose | Colorado | 8085 | 218 | 12 |
325356 | 325356 | 2020-07-12 | Montrose | Colorado | 8085 | 218 | 12 |
322175 | 322175 | 2020-07-11 | Montrose | Colorado | 8085 | 218 | 12 |
318996 | 318996 | 2020-07-10 | Montrose | Colorado | 8085 | 216 | 12 |
315823 | 315823 | 2020-07-09 | Montrose | Colorado | 8085 | 214 | 12 |
312648 | 312648 | 2020-07-08 | Montrose | Colorado | 8085 | 213 | 12 |
309478 | 309478 | 2020-07-07 | Montrose | Colorado | 8085 | 211 | 12 |
306310 | 306310 | 2020-07-06 | Montrose | Colorado | 8085 | 210 | 12 |
303146 | 303146 | 2020-07-05 | Montrose | Colorado | 8085 | 208 | 12 |
299982 | 299982 | 2020-07-04 | Montrose | Colorado | 8085 | 208 | 12 |
296820 | 296820 | 2020-07-03 | Montrose | Colorado | 8085 | 209 | 12 |
293664 | 293664 | 2020-07-02 | Montrose | Colorado | 8085 | 208 | 12 |
290510 | 290510 | 2020-07-01 | Montrose | Colorado | 8085 | 207 | 12 |
287359 | 287359 | 2020-06-30 | Montrose | Colorado | 8085 | 207 | 12 |
284213 | 284213 | 2020-06-29 | Montrose | Colorado | 8085 | 205 | 12 |
281067 | 281067 | 2020-06-28 | Montrose | Colorado | 8085 | 204 | 12 |
277920 | 277920 | 2020-06-27 | Montrose | Colorado | 8085 | 203 | 12 |
274772 | 274772 | 2020-06-26 | Montrose | Colorado | 8085 | 203 | 12 |
271632 | 271632 | 2020-06-25 | Montrose | Colorado | 8085 | 202 | 12 |
268496 | 268496 | 2020-06-24 | Montrose | Colorado | 8085 | 201 | 12 |
265366 | 265366 | 2020-06-23 | Montrose | Colorado | 8085 | 201 | 12 |
262238 | 262238 | 2020-06-22 | Montrose | Colorado | 8085 | 201 | 12 |
259111 | 259111 | 2020-06-21 | Montrose | Colorado | 8085 | 200 | 12 |
255984 | 255984 | 2020-06-20 | Montrose | Colorado | 8085 | 199 | 12 |
252865 | 252865 | 2020-06-19 | Montrose | Colorado | 8085 | 198 | 12 |
249750 | 249750 | 2020-06-18 | Montrose | Colorado | 8085 | 198 | 12 |
246638 | 246638 | 2020-06-17 | Montrose | Colorado | 8085 | 198 | 12 |
243525 | 243525 | 2020-06-16 | Montrose | Colorado | 8085 | 197 | 12 |
240414 | 240414 | 2020-06-15 | Montrose | Colorado | 8085 | 195 | 12 |
237306 | 237306 | 2020-06-14 | Montrose | Colorado | 8085 | 195 | 12 |
234199 | 234199 | 2020-06-13 | Montrose | Colorado | 8085 | 194 | 12 |
231093 | 231093 | 2020-06-12 | Montrose | Colorado | 8085 | 191 | 12 |
227990 | 227990 | 2020-06-11 | Montrose | Colorado | 8085 | 191 | 12 |
224888 | 224888 | 2020-06-10 | Montrose | Colorado | 8085 | 190 | 12 |
221793 | 221793 | 2020-06-09 | Montrose | Colorado | 8085 | 190 | 12 |
218698 | 218698 | 2020-06-08 | Montrose | Colorado | 8085 | 190 | 12 |
215607 | 215607 | 2020-06-07 | Montrose | Colorado | 8085 | 188 | 12 |
212520 | 212520 | 2020-06-06 | Montrose | Colorado | 8085 | 185 | 12 |
209435 | 209435 | 2020-06-05 | Montrose | Colorado | 8085 | 183 | 12 |
206354 | 206354 | 2020-06-04 | Montrose | Colorado | 8085 | 182 | 12 |
203274 | 203274 | 2020-06-03 | Montrose | Colorado | 8085 | 181 | 12 |
200198 | 200198 | 2020-06-02 | Montrose | Colorado | 8085 | 181 | 12 |
197125 | 197125 | 2020-06-01 | Montrose | Colorado | 8085 | 177 | 12 |
194055 | 194055 | 2020-05-31 | Montrose | Colorado | 8085 | 172 | 12 |
190988 | 190988 | 2020-05-30 | Montrose | Colorado | 8085 | 169 | 12 |
187923 | 187923 | 2020-05-29 | Montrose | Colorado | 8085 | 168 | 12 |
184867 | 184867 | 2020-05-28 | Montrose | Colorado | 8085 | 163 | 12 |
181813 | 181813 | 2020-05-27 | Montrose | Colorado | 8085 | 163 | 12 |
178769 | 178769 | 2020-05-26 | Montrose | Colorado | 8085 | 163 | 12 |
175725 | 175725 | 2020-05-25 | Montrose | Colorado | 8085 | 159 | 12 |
172681 | 172681 | 2020-05-24 | Montrose | Colorado | 8085 | 159 | 12 |
169640 | 169640 | 2020-05-23 | Montrose | Colorado | 8085 | 159 | 12 |
166603 | 166603 | 2020-05-22 | Montrose | Colorado | 8085 | 152 | 12 |
163570 | 163570 | 2020-05-21 | Montrose | Colorado | 8085 | 147 | 12 |
160542 | 160542 | 2020-05-20 | Montrose | Colorado | 8085 | 136 | 11 |
157516 | 157516 | 2020-05-19 | Montrose | Colorado | 8085 | 136 | 11 |
154500 | 154500 | 2020-05-18 | Montrose | Colorado | 8085 | 136 | 11 |
151488 | 151488 | 2020-05-17 | Montrose | Colorado | 8085 | 136 | 11 |
148479 | 148479 | 2020-05-16 | Montrose | Colorado | 8085 | 135 | 11 |
145476 | 145476 | 2020-05-15 | Montrose | Colorado | 8085 | 131 | 11 |
142476 | 142476 | 2020-05-14 | Montrose | Colorado | 8085 | 129 | 11 |
139480 | 139480 | 2020-05-13 | Montrose | Colorado | 8085 | 128 | 11 |
136489 | 136489 | 2020-05-12 | Montrose | Colorado | 8085 | 127 | 11 |
133500 | 133500 | 2020-05-11 | Montrose | Colorado | 8085 | 127 | 11 |
130509 | 130509 | 2020-05-10 | Montrose | Colorado | 8085 | 124 | 11 |
127518 | 127518 | 2020-05-09 | Montrose | Colorado | 8085 | 122 | 11 |
124532 | 124532 | 2020-05-08 | Montrose | Colorado | 8085 | 121 | 11 |
121552 | 121552 | 2020-05-07 | Montrose | Colorado | 8085 | 114 | 11 |
118583 | 118583 | 2020-05-06 | Montrose | Colorado | 8085 | 110 | 11 |
115624 | 115624 | 2020-05-05 | Montrose | Colorado | 8085 | 107 | 11 |
112741 | 112741 | 2020-05-04 | Montrose | Colorado | 8085 | 106 | 11 |
109866 | 109866 | 2020-05-03 | Montrose | Colorado | 8085 | 105 | 11 |
106997 | 106997 | 2020-05-02 | Montrose | Colorado | 8085 | 102 | 11 |
104132 | 104132 | 2020-05-01 | Montrose | Colorado | 8085 | 98 | 11 |
101277 | 101277 | 2020-04-30 | Montrose | Colorado | 8085 | 96 | 11 |
98427 | 98427 | 2020-04-29 | Montrose | Colorado | 8085 | 96 | 11 |
95582 | 95582 | 2020-04-28 | Montrose | Colorado | 8085 | 94 | 11 |
92750 | 92750 | 2020-04-27 | Montrose | Colorado | 8085 | 92 | 10 |
89932 | 89932 | 2020-04-26 | Montrose | Colorado | 8085 | 90 | 9 |
87115 | 87115 | 2020-04-25 | Montrose | Colorado | 8085 | 87 | 9 |
84307 | 84307 | 2020-04-24 | Montrose | Colorado | 8085 | 83 | 9 |
81507 | 81507 | 2020-04-23 | Montrose | Colorado | 8085 | 82 | 9 |
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);