ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8085 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635172 | 635172 | 2020-10-16 | Montrose | Colorado | 8085 | 412 | 13 |
631926 | 631926 | 2020-10-15 | Montrose | Colorado | 8085 | 412 | 13 |
628682 | 628682 | 2020-10-14 | Montrose | Colorado | 8085 | 405 | 13 |
625439 | 625439 | 2020-10-13 | Montrose | Colorado | 8085 | 404 | 13 |
622196 | 622196 | 2020-10-12 | Montrose | Colorado | 8085 | 400 | 13 |
618953 | 618953 | 2020-10-11 | Montrose | Colorado | 8085 | 400 | 13 |
615711 | 615711 | 2020-10-10 | Montrose | Colorado | 8085 | 397 | 13 |
612470 | 612470 | 2020-10-09 | Montrose | Colorado | 8085 | 393 | 13 |
609228 | 609228 | 2020-10-08 | Montrose | Colorado | 8085 | 391 | 13 |
605985 | 605985 | 2020-10-07 | Montrose | Colorado | 8085 | 390 | 13 |
602743 | 602743 | 2020-10-06 | Montrose | Colorado | 8085 | 388 | 13 |
599500 | 599500 | 2020-10-05 | Montrose | Colorado | 8085 | 388 | 13 |
596257 | 596257 | 2020-10-04 | Montrose | Colorado | 8085 | 387 | 13 |
593015 | 593015 | 2020-10-03 | Montrose | Colorado | 8085 | 386 | 13 |
589775 | 589775 | 2020-10-02 | Montrose | Colorado | 8085 | 386 | 13 |
586534 | 586534 | 2020-10-01 | Montrose | Colorado | 8085 | 385 | 13 |
583294 | 583294 | 2020-09-30 | Montrose | Colorado | 8085 | 385 | 13 |
580055 | 580055 | 2020-09-29 | Montrose | Colorado | 8085 | 384 | 13 |
576814 | 576814 | 2020-09-28 | Montrose | Colorado | 8085 | 383 | 13 |
573571 | 573571 | 2020-09-27 | Montrose | Colorado | 8085 | 383 | 13 |
570329 | 570329 | 2020-09-26 | Montrose | Colorado | 8085 | 380 | 13 |
567087 | 567087 | 2020-09-25 | Montrose | Colorado | 8085 | 380 | 13 |
563847 | 563847 | 2020-09-24 | Montrose | Colorado | 8085 | 373 | 13 |
560607 | 560607 | 2020-09-23 | Montrose | Colorado | 8085 | 373 | 13 |
557371 | 557371 | 2020-09-22 | Montrose | Colorado | 8085 | 371 | 13 |
554134 | 554134 | 2020-09-21 | Montrose | Colorado | 8085 | 370 | 13 |
550895 | 550895 | 2020-09-20 | Montrose | Colorado | 8085 | 370 | 13 |
547656 | 547656 | 2020-09-19 | Montrose | Colorado | 8085 | 368 | 13 |
544418 | 544418 | 2020-09-18 | Montrose | Colorado | 8085 | 365 | 13 |
541182 | 541182 | 2020-09-17 | Montrose | Colorado | 8085 | 361 | 13 |
537945 | 537945 | 2020-09-16 | Montrose | Colorado | 8085 | 359 | 13 |
534709 | 534709 | 2020-09-15 | Montrose | Colorado | 8085 | 358 | 13 |
531474 | 531474 | 2020-09-14 | Montrose | Colorado | 8085 | 355 | 13 |
528237 | 528237 | 2020-09-13 | Montrose | Colorado | 8085 | 353 | 13 |
525001 | 525001 | 2020-09-12 | Montrose | Colorado | 8085 | 353 | 13 |
521765 | 521765 | 2020-09-11 | Montrose | Colorado | 8085 | 353 | 13 |
518528 | 518528 | 2020-09-10 | Montrose | Colorado | 8085 | 352 | 13 |
515293 | 515293 | 2020-09-09 | Montrose | Colorado | 8085 | 352 | 13 |
512060 | 512060 | 2020-09-08 | Montrose | Colorado | 8085 | 351 | 13 |
508827 | 508827 | 2020-09-07 | Montrose | Colorado | 8085 | 351 | 13 |
505595 | 505595 | 2020-09-06 | Montrose | Colorado | 8085 | 350 | 13 |
502361 | 502361 | 2020-09-05 | Montrose | Colorado | 8085 | 350 | 13 |
499127 | 499127 | 2020-09-04 | Montrose | Colorado | 8085 | 350 | 13 |
495894 | 495894 | 2020-09-03 | Montrose | Colorado | 8085 | 348 | 13 |
492660 | 492660 | 2020-09-02 | Montrose | Colorado | 8085 | 345 | 13 |
489427 | 489427 | 2020-09-01 | Montrose | Colorado | 8085 | 344 | 13 |
486194 | 486194 | 2020-08-31 | Montrose | Colorado | 8085 | 343 | 13 |
482959 | 482959 | 2020-08-30 | Montrose | Colorado | 8085 | 342 | 13 |
479725 | 479725 | 2020-08-29 | Montrose | Colorado | 8085 | 341 | 13 |
476492 | 476492 | 2020-08-28 | Montrose | Colorado | 8085 | 341 | 13 |
473259 | 473259 | 2020-08-27 | Montrose | Colorado | 8085 | 339 | 13 |
470027 | 470027 | 2020-08-26 | Montrose | Colorado | 8085 | 338 | 13 |
466798 | 466798 | 2020-08-25 | Montrose | Colorado | 8085 | 339 | 13 |
463569 | 463569 | 2020-08-24 | Montrose | Colorado | 8085 | 336 | 13 |
460340 | 460340 | 2020-08-23 | Montrose | Colorado | 8085 | 335 | 13 |
457113 | 457113 | 2020-08-22 | Montrose | Colorado | 8085 | 332 | 13 |
453885 | 453885 | 2020-08-21 | Montrose | Colorado | 8085 | 331 | 13 |
450657 | 450657 | 2020-08-20 | Montrose | Colorado | 8085 | 329 | 13 |
447429 | 447429 | 2020-08-19 | Montrose | Colorado | 8085 | 328 | 13 |
444202 | 444202 | 2020-08-18 | Montrose | Colorado | 8085 | 327 | 13 |
440976 | 440976 | 2020-08-17 | Montrose | Colorado | 8085 | 323 | 13 |
437750 | 437750 | 2020-08-16 | Montrose | Colorado | 8085 | 321 | 13 |
434524 | 434524 | 2020-08-15 | Montrose | Colorado | 8085 | 317 | 13 |
431299 | 431299 | 2020-08-14 | Montrose | Colorado | 8085 | 317 | 13 |
428071 | 428071 | 2020-08-13 | Montrose | Colorado | 8085 | 316 | 13 |
424847 | 424847 | 2020-08-12 | Montrose | Colorado | 8085 | 313 | 13 |
421626 | 421626 | 2020-08-11 | Montrose | Colorado | 8085 | 312 | 13 |
418405 | 418405 | 2020-08-10 | Montrose | Colorado | 8085 | 310 | 13 |
415184 | 415184 | 2020-08-09 | Montrose | Colorado | 8085 | 305 | 13 |
411964 | 411964 | 2020-08-08 | Montrose | Colorado | 8085 | 297 | 13 |
408745 | 408745 | 2020-08-07 | Montrose | Colorado | 8085 | 293 | 13 |
405525 | 405525 | 2020-08-06 | Montrose | Colorado | 8085 | 292 | 13 |
402307 | 402307 | 2020-08-05 | Montrose | Colorado | 8085 | 287 | 13 |
399091 | 399091 | 2020-08-04 | Montrose | Colorado | 8085 | 287 | 13 |
395875 | 395875 | 2020-08-03 | Montrose | Colorado | 8085 | 283 | 13 |
392659 | 392659 | 2020-08-02 | Montrose | Colorado | 8085 | 279 | 13 |
389442 | 389442 | 2020-08-01 | Montrose | Colorado | 8085 | 278 | 13 |
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 |
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);