ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where county = "Colfax", deaths = 1 and state = "New Mexico" 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 |
---|---|---|---|---|---|---|---|
740510 | 740510 | 2020-11-17 | Colfax | New Mexico | 35007 | 101 | 1 |
737265 | 737265 | 2020-11-16 | Colfax | New Mexico | 35007 | 92 | 1 |
734020 | 734020 | 2020-11-15 | Colfax | New Mexico | 35007 | 1 | 1 |
730775 | 730775 | 2020-11-14 | Colfax | New Mexico | 35007 | 82 | 1 |
727531 | 727531 | 2020-11-13 | Colfax | New Mexico | 35007 | 79 | 1 |
724287 | 724287 | 2020-11-12 | Colfax | New Mexico | 35007 | 77 | 1 |
721044 | 721044 | 2020-11-11 | Colfax | New Mexico | 35007 | 74 | 1 |
717801 | 717801 | 2020-11-10 | Colfax | New Mexico | 35007 | 69 | 1 |
714558 | 714558 | 2020-11-09 | Colfax | New Mexico | 35007 | 65 | 1 |
711314 | 711314 | 2020-11-08 | Colfax | New Mexico | 35007 | 63 | 1 |
708070 | 708070 | 2020-11-07 | Colfax | New Mexico | 35007 | 56 | 1 |
704827 | 704827 | 2020-11-06 | Colfax | New Mexico | 35007 | 52 | 1 |
701584 | 701584 | 2020-11-05 | Colfax | New Mexico | 35007 | 49 | 1 |
698340 | 698340 | 2020-11-04 | Colfax | New Mexico | 35007 | 49 | 1 |
695097 | 695097 | 2020-11-03 | Colfax | New Mexico | 35007 | 48 | 1 |
691855 | 691855 | 2020-11-02 | Colfax | New Mexico | 35007 | 46 | 1 |
688611 | 688611 | 2020-11-01 | Colfax | New Mexico | 35007 | 46 | 1 |
685366 | 685366 | 2020-10-31 | Colfax | New Mexico | 35007 | 46 | 1 |
682123 | 682123 | 2020-10-30 | Colfax | New Mexico | 35007 | 46 | 1 |
678880 | 678880 | 2020-10-29 | Colfax | New Mexico | 35007 | 45 | 1 |
675637 | 675637 | 2020-10-28 | Colfax | New Mexico | 35007 | 45 | 1 |
672394 | 672394 | 2020-10-27 | Colfax | New Mexico | 35007 | 44 | 1 |
669152 | 669152 | 2020-10-26 | Colfax | New Mexico | 35007 | 44 | 1 |
665908 | 665908 | 2020-10-25 | Colfax | New Mexico | 35007 | 44 | 1 |
662663 | 662663 | 2020-10-24 | Colfax | New Mexico | 35007 | 44 | 1 |
659419 | 659419 | 2020-10-23 | Colfax | New Mexico | 35007 | 43 | 1 |
656175 | 656175 | 2020-10-22 | Colfax | New Mexico | 35007 | 42 | 1 |
652930 | 652930 | 2020-10-21 | Colfax | New Mexico | 35007 | 41 | 1 |
649685 | 649685 | 2020-10-20 | Colfax | New Mexico | 35007 | 41 | 1 |
646441 | 646441 | 2020-10-19 | Colfax | New Mexico | 35007 | 41 | 1 |
643195 | 643195 | 2020-10-18 | Colfax | New Mexico | 35007 | 41 | 1 |
639947 | 639947 | 2020-10-17 | Colfax | New Mexico | 35007 | 41 | 1 |
636701 | 636701 | 2020-10-16 | Colfax | New Mexico | 35007 | 41 | 1 |
633455 | 633455 | 2020-10-15 | Colfax | New Mexico | 35007 | 41 | 1 |
630210 | 630210 | 2020-10-14 | Colfax | New Mexico | 35007 | 41 | 1 |
626966 | 626966 | 2020-10-13 | Colfax | New Mexico | 35007 | 41 | 1 |
623724 | 623724 | 2020-10-12 | Colfax | New Mexico | 35007 | 41 | 1 |
620481 | 620481 | 2020-10-11 | Colfax | New Mexico | 35007 | 41 | 1 |
617239 | 617239 | 2020-10-10 | Colfax | New Mexico | 35007 | 40 | 1 |
613997 | 613997 | 2020-10-09 | Colfax | New Mexico | 35007 | 40 | 1 |
610756 | 610756 | 2020-10-08 | Colfax | New Mexico | 35007 | 40 | 1 |
607514 | 607514 | 2020-10-07 | Colfax | New Mexico | 35007 | 40 | 1 |
604271 | 604271 | 2020-10-06 | Colfax | New Mexico | 35007 | 39 | 1 |
601029 | 601029 | 2020-10-05 | Colfax | New Mexico | 35007 | 39 | 1 |
597785 | 597785 | 2020-10-04 | Colfax | New Mexico | 35007 | 39 | 1 |
594543 | 594543 | 2020-10-03 | Colfax | New Mexico | 35007 | 39 | 1 |
591302 | 591302 | 2020-10-02 | Colfax | New Mexico | 35007 | 39 | 1 |
588061 | 588061 | 2020-10-01 | Colfax | New Mexico | 35007 | 36 | 1 |
584821 | 584821 | 2020-09-30 | Colfax | New Mexico | 35007 | 36 | 1 |
581580 | 581580 | 2020-09-29 | Colfax | New Mexico | 35007 | 36 | 1 |
578339 | 578339 | 2020-09-28 | Colfax | New Mexico | 35007 | 36 | 1 |
575098 | 575098 | 2020-09-27 | Colfax | New Mexico | 35007 | 36 | 1 |
571855 | 571855 | 2020-09-26 | Colfax | New Mexico | 35007 | 30 | 1 |
568613 | 568613 | 2020-09-25 | Colfax | New Mexico | 35007 | 30 | 1 |
565372 | 565372 | 2020-09-24 | Colfax | New Mexico | 35007 | 29 | 1 |
562131 | 562131 | 2020-09-23 | Colfax | New Mexico | 35007 | 29 | 1 |
558894 | 558894 | 2020-09-22 | Colfax | New Mexico | 35007 | 27 | 1 |
555657 | 555657 | 2020-09-21 | Colfax | New Mexico | 35007 | 27 | 1 |
552419 | 552419 | 2020-09-20 | Colfax | New Mexico | 35007 | 27 | 1 |
549180 | 549180 | 2020-09-19 | Colfax | New Mexico | 35007 | 27 | 1 |
545942 | 545942 | 2020-09-18 | Colfax | New Mexico | 35007 | 27 | 1 |
542705 | 542705 | 2020-09-17 | Colfax | New Mexico | 35007 | 26 | 1 |
539468 | 539468 | 2020-09-16 | Colfax | New Mexico | 35007 | 25 | 1 |
536231 | 536231 | 2020-09-15 | Colfax | New Mexico | 35007 | 25 | 1 |
532996 | 532996 | 2020-09-14 | Colfax | New Mexico | 35007 | 24 | 1 |
529760 | 529760 | 2020-09-13 | Colfax | New Mexico | 35007 | 23 | 1 |
526524 | 526524 | 2020-09-12 | Colfax | New Mexico | 35007 | 23 | 1 |
523288 | 523288 | 2020-09-11 | Colfax | New Mexico | 35007 | 23 | 1 |
520051 | 520051 | 2020-09-10 | Colfax | New Mexico | 35007 | 23 | 1 |
516816 | 516816 | 2020-09-09 | Colfax | New Mexico | 35007 | 23 | 1 |
513582 | 513582 | 2020-09-08 | Colfax | New Mexico | 35007 | 23 | 1 |
510349 | 510349 | 2020-09-07 | Colfax | New Mexico | 35007 | 24 | 1 |
507116 | 507116 | 2020-09-06 | Colfax | New Mexico | 35007 | 24 | 1 |
503884 | 503884 | 2020-09-05 | Colfax | New Mexico | 35007 | 24 | 1 |
500650 | 500650 | 2020-09-04 | Colfax | New Mexico | 35007 | 23 | 1 |
497416 | 497416 | 2020-09-03 | Colfax | New Mexico | 35007 | 22 | 1 |
494183 | 494183 | 2020-09-02 | Colfax | New Mexico | 35007 | 20 | 1 |
490949 | 490949 | 2020-09-01 | Colfax | New Mexico | 35007 | 19 | 1 |
487716 | 487716 | 2020-08-31 | Colfax | New Mexico | 35007 | 19 | 1 |
484482 | 484482 | 2020-08-30 | Colfax | New Mexico | 35007 | 19 | 1 |
481247 | 481247 | 2020-08-29 | Colfax | New Mexico | 35007 | 19 | 1 |
478015 | 478015 | 2020-08-28 | Colfax | New Mexico | 35007 | 19 | 1 |
474782 | 474782 | 2020-08-27 | Colfax | New Mexico | 35007 | 19 | 1 |
471548 | 471548 | 2020-08-26 | Colfax | New Mexico | 35007 | 19 | 1 |
468316 | 468316 | 2020-08-25 | Colfax | New Mexico | 35007 | 19 | 1 |
465088 | 465088 | 2020-08-24 | Colfax | New Mexico | 35007 | 19 | 1 |
461858 | 461858 | 2020-08-23 | Colfax | New Mexico | 35007 | 19 | 1 |
458630 | 458630 | 2020-08-22 | Colfax | New Mexico | 35007 | 19 | 1 |
455403 | 455403 | 2020-08-21 | Colfax | New Mexico | 35007 | 19 | 1 |
452175 | 452175 | 2020-08-20 | Colfax | New Mexico | 35007 | 19 | 1 |
448946 | 448946 | 2020-08-19 | Colfax | New Mexico | 35007 | 19 | 1 |
445719 | 445719 | 2020-08-18 | Colfax | New Mexico | 35007 | 19 | 1 |
442493 | 442493 | 2020-08-17 | Colfax | New Mexico | 35007 | 18 | 1 |
439266 | 439266 | 2020-08-16 | Colfax | New Mexico | 35007 | 18 | 1 |
436041 | 436041 | 2020-08-15 | Colfax | New Mexico | 35007 | 18 | 1 |
432815 | 432815 | 2020-08-14 | Colfax | New Mexico | 35007 | 18 | 1 |
429588 | 429588 | 2020-08-13 | Colfax | New Mexico | 35007 | 18 | 1 |
426364 | 426364 | 2020-08-12 | Colfax | New Mexico | 35007 | 18 | 1 |
423141 | 423141 | 2020-08-11 | Colfax | New Mexico | 35007 | 18 | 1 |
419918 | 419918 | 2020-08-10 | Colfax | New Mexico | 35007 | 18 | 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);