ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grant" and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
902788 | 902788 | 2021-01-06 | Grant | New Mexico | 35017 | 997 | 15 |
899543 | 899543 | 2021-01-05 | Grant | New Mexico | 35017 | 974 | 15 |
896298 | 896298 | 2021-01-04 | Grant | New Mexico | 35017 | 964 | 15 |
893051 | 893051 | 2021-01-03 | Grant | New Mexico | 35017 | 961 | 15 |
889805 | 889805 | 2021-01-02 | Grant | New Mexico | 35017 | 941 | 15 |
886559 | 886559 | 2021-01-01 | Grant | New Mexico | 35017 | 921 | 15 |
883314 | 883314 | 2020-12-31 | Grant | New Mexico | 35017 | 904 | 13 |
880069 | 880069 | 2020-12-30 | Grant | New Mexico | 35017 | 879 | 13 |
876824 | 876824 | 2020-12-29 | Grant | New Mexico | 35017 | 855 | 13 |
873579 | 873579 | 2020-12-28 | Grant | New Mexico | 35017 | 843 | 13 |
870334 | 870334 | 2020-12-27 | Grant | New Mexico | 35017 | 831 | 13 |
867089 | 867089 | 2020-12-26 | Grant | New Mexico | 35017 | 829 | 12 |
863844 | 863844 | 2020-12-25 | Grant | New Mexico | 35017 | 824 | 12 |
860599 | 860599 | 2020-12-24 | Grant | New Mexico | 35017 | 811 | 10 |
857354 | 857354 | 2020-12-23 | Grant | New Mexico | 35017 | 798 | 10 |
854109 | 854109 | 2020-12-22 | Grant | New Mexico | 35017 | 785 | 9 |
850864 | 850864 | 2020-12-21 | Grant | New Mexico | 35017 | 779 | 9 |
847619 | 847619 | 2020-12-20 | Grant | New Mexico | 35017 | 769 | 9 |
844373 | 844373 | 2020-12-19 | Grant | New Mexico | 35017 | 759 | 9 |
841128 | 841128 | 2020-12-18 | Grant | New Mexico | 35017 | 736 | 9 |
837883 | 837883 | 2020-12-17 | Grant | New Mexico | 35017 | 711 | 9 |
834637 | 834637 | 2020-12-16 | Grant | New Mexico | 35017 | 682 | 9 |
831390 | 831390 | 2020-12-15 | Grant | New Mexico | 35017 | 655 | 8 |
828144 | 828144 | 2020-12-14 | Grant | New Mexico | 35017 | 645 | 8 |
824897 | 824897 | 2020-12-13 | Grant | New Mexico | 35017 | 639 | 8 |
821651 | 821651 | 2020-12-12 | Grant | New Mexico | 35017 | 630 | 8 |
818405 | 818405 | 2020-12-11 | Grant | New Mexico | 35017 | 623 | 7 |
815159 | 815159 | 2020-12-10 | Grant | New Mexico | 35017 | 599 | 7 |
811914 | 811914 | 2020-12-09 | Grant | New Mexico | 35017 | 590 | 7 |
808669 | 808669 | 2020-12-08 | Grant | New Mexico | 35017 | 580 | 7 |
805424 | 805424 | 2020-12-07 | Grant | New Mexico | 35017 | 569 | 7 |
802179 | 802179 | 2020-12-06 | Grant | New Mexico | 35017 | 554 | 7 |
798934 | 798934 | 2020-12-05 | Grant | New Mexico | 35017 | 551 | 7 |
795689 | 795689 | 2020-12-04 | Grant | New Mexico | 35017 | 540 | 7 |
792444 | 792444 | 2020-12-03 | Grant | New Mexico | 35017 | 534 | 7 |
789199 | 789199 | 2020-12-02 | Grant | New Mexico | 35017 | 523 | 7 |
785954 | 785954 | 2020-12-01 | Grant | New Mexico | 35017 | 513 | 7 |
782710 | 782710 | 2020-11-30 | Grant | New Mexico | 35017 | 509 | 6 |
779464 | 779464 | 2020-11-29 | Grant | New Mexico | 35017 | 499 | 6 |
776219 | 776219 | 2020-11-28 | Grant | New Mexico | 35017 | 484 | 6 |
772974 | 772974 | 2020-11-27 | Grant | New Mexico | 35017 | 464 | 6 |
769729 | 769729 | 2020-11-26 | Grant | New Mexico | 35017 | 460 | 6 |
766483 | 766483 | 2020-11-25 | Grant | New Mexico | 35017 | 447 | 6 |
763238 | 763238 | 2020-11-24 | Grant | New Mexico | 35017 | 441 | 6 |
759993 | 759993 | 2020-11-23 | Grant | New Mexico | 35017 | 440 | 6 |
756747 | 756747 | 2020-11-22 | Grant | New Mexico | 35017 | 434 | 6 |
753500 | 753500 | 2020-11-21 | Grant | New Mexico | 35017 | 414 | 6 |
750254 | 750254 | 2020-11-20 | Grant | New Mexico | 35017 | 397 | 6 |
747008 | 747008 | 2020-11-19 | Grant | New Mexico | 35017 | 366 | 6 |
743762 | 743762 | 2020-11-18 | Grant | New Mexico | 35017 | 348 | 6 |
740515 | 740515 | 2020-11-17 | Grant | New Mexico | 35017 | 329 | 6 |
737270 | 737270 | 2020-11-16 | Grant | New Mexico | 35017 | 304 | 6 |
734025 | 734025 | 2020-11-15 | Grant | New Mexico | 35017 | 292 | 6 |
730780 | 730780 | 2020-11-14 | Grant | New Mexico | 35017 | 286 | 6 |
727536 | 727536 | 2020-11-13 | Grant | New Mexico | 35017 | 279 | 5 |
724292 | 724292 | 2020-11-12 | Grant | New Mexico | 35017 | 271 | 5 |
721049 | 721049 | 2020-11-11 | Grant | New Mexico | 35017 | 254 | 5 |
717806 | 717806 | 2020-11-10 | Grant | New Mexico | 35017 | 252 | 5 |
714563 | 714563 | 2020-11-09 | Grant | New Mexico | 35017 | 247 | 5 |
711319 | 711319 | 2020-11-08 | Grant | New Mexico | 35017 | 238 | 4 |
708075 | 708075 | 2020-11-07 | Grant | New Mexico | 35017 | 232 | 4 |
704832 | 704832 | 2020-11-06 | Grant | New Mexico | 35017 | 227 | 4 |
701589 | 701589 | 2020-11-05 | Grant | New Mexico | 35017 | 223 | 4 |
698345 | 698345 | 2020-11-04 | Grant | New Mexico | 35017 | 220 | 4 |
695102 | 695102 | 2020-11-03 | Grant | New Mexico | 35017 | 215 | 4 |
691860 | 691860 | 2020-11-02 | Grant | New Mexico | 35017 | 209 | 4 |
688616 | 688616 | 2020-11-01 | Grant | New Mexico | 35017 | 206 | 4 |
685371 | 685371 | 2020-10-31 | Grant | New Mexico | 35017 | 197 | 4 |
682128 | 682128 | 2020-10-30 | Grant | New Mexico | 35017 | 194 | 4 |
678885 | 678885 | 2020-10-29 | Grant | New Mexico | 35017 | 191 | 4 |
675642 | 675642 | 2020-10-28 | Grant | New Mexico | 35017 | 187 | 3 |
672399 | 672399 | 2020-10-27 | Grant | New Mexico | 35017 | 187 | 3 |
669157 | 669157 | 2020-10-26 | Grant | New Mexico | 35017 | 186 | 3 |
665913 | 665913 | 2020-10-25 | Grant | New Mexico | 35017 | 184 | 3 |
662668 | 662668 | 2020-10-24 | Grant | New Mexico | 35017 | 183 | 3 |
659424 | 659424 | 2020-10-23 | Grant | New Mexico | 35017 | 178 | 3 |
656180 | 656180 | 2020-10-22 | Grant | New Mexico | 35017 | 172 | 3 |
652935 | 652935 | 2020-10-21 | Grant | New Mexico | 35017 | 171 | 3 |
649690 | 649690 | 2020-10-20 | Grant | New Mexico | 35017 | 169 | 2 |
646446 | 646446 | 2020-10-19 | Grant | New Mexico | 35017 | 168 | 2 |
643200 | 643200 | 2020-10-18 | Grant | New Mexico | 35017 | 164 | 2 |
639952 | 639952 | 2020-10-17 | Grant | New Mexico | 35017 | 161 | 2 |
636706 | 636706 | 2020-10-16 | Grant | New Mexico | 35017 | 159 | 2 |
633460 | 633460 | 2020-10-15 | Grant | New Mexico | 35017 | 156 | 2 |
630215 | 630215 | 2020-10-14 | Grant | New Mexico | 35017 | 151 | 2 |
626971 | 626971 | 2020-10-13 | Grant | New Mexico | 35017 | 147 | 2 |
623729 | 623729 | 2020-10-12 | Grant | New Mexico | 35017 | 146 | 2 |
620486 | 620486 | 2020-10-11 | Grant | New Mexico | 35017 | 146 | 2 |
617244 | 617244 | 2020-10-10 | Grant | New Mexico | 35017 | 143 | 2 |
614002 | 614002 | 2020-10-09 | Grant | New Mexico | 35017 | 140 | 2 |
610761 | 610761 | 2020-10-08 | Grant | New Mexico | 35017 | 136 | 2 |
607519 | 607519 | 2020-10-07 | Grant | New Mexico | 35017 | 134 | 2 |
604276 | 604276 | 2020-10-06 | Grant | New Mexico | 35017 | 132 | 2 |
601034 | 601034 | 2020-10-05 | Grant | New Mexico | 35017 | 131 | 2 |
597790 | 597790 | 2020-10-04 | Grant | New Mexico | 35017 | 131 | 2 |
594548 | 594548 | 2020-10-03 | Grant | New Mexico | 35017 | 130 | 2 |
591307 | 591307 | 2020-10-02 | Grant | New Mexico | 35017 | 129 | 2 |
588066 | 588066 | 2020-10-01 | Grant | New Mexico | 35017 | 128 | 2 |
584826 | 584826 | 2020-09-30 | Grant | New Mexico | 35017 | 124 | 2 |
581585 | 581585 | 2020-09-29 | Grant | New Mexico | 35017 | 124 | 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);