ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grant" and fips = 35017 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055328 | 1055328 | 2021-02-22 | Grant | New Mexico | 35017 | 1456 | 34 |
1052081 | 1052081 | 2021-02-21 | Grant | New Mexico | 35017 | 1455 | 34 |
1048834 | 1048834 | 2021-02-20 | Grant | New Mexico | 35017 | 1454 | 34 |
1045588 | 1045588 | 2021-02-19 | Grant | New Mexico | 35017 | 1449 | 34 |
1042343 | 1042343 | 2021-02-18 | Grant | New Mexico | 35017 | 1442 | 34 |
1039098 | 1039098 | 2021-02-17 | Grant | New Mexico | 35017 | 1438 | 33 |
1035853 | 1035853 | 2021-02-16 | Grant | New Mexico | 35017 | 1435 | 33 |
1032608 | 1032608 | 2021-02-15 | Grant | New Mexico | 35017 | 1429 | 33 |
1029361 | 1029361 | 2021-02-14 | Grant | New Mexico | 35017 | 1421 | 33 |
1026115 | 1026115 | 2021-02-13 | Grant | New Mexico | 35017 | 1415 | 33 |
1022870 | 1022870 | 2021-02-12 | Grant | New Mexico | 35017 | 1410 | 32 |
1019625 | 1019625 | 2021-02-11 | Grant | New Mexico | 35017 | 1398 | 32 |
1016380 | 1016380 | 2021-02-10 | Grant | New Mexico | 35017 | 1391 | 31 |
1013135 | 1013135 | 2021-02-09 | Grant | New Mexico | 35017 | 1366 | 31 |
1009890 | 1009890 | 2021-02-08 | Grant | New Mexico | 35017 | 1358 | 31 |
1006643 | 1006643 | 2021-02-07 | Grant | New Mexico | 35017 | 1355 | 31 |
1003397 | 1003397 | 2021-02-06 | Grant | New Mexico | 35017 | 1336 | 30 |
1000152 | 1000152 | 2021-02-05 | Grant | New Mexico | 35017 | 1325 | 30 |
996906 | 996906 | 2021-02-04 | Grant | New Mexico | 35017 | 1315 | 30 |
993660 | 993660 | 2021-02-03 | Grant | New Mexico | 35017 | 1304 | 29 |
990414 | 990414 | 2021-02-02 | Grant | New Mexico | 35017 | 1296 | 28 |
987167 | 987167 | 2021-02-01 | Grant | New Mexico | 35017 | 1292 | 28 |
983920 | 983920 | 2021-01-31 | Grant | New Mexico | 35017 | 1287 | 28 |
980674 | 980674 | 2021-01-30 | Grant | New Mexico | 35017 | 1278 | 28 |
977428 | 977428 | 2021-01-29 | Grant | New Mexico | 35017 | 1270 | 28 |
974183 | 974183 | 2021-01-28 | Grant | New Mexico | 35017 | 1256 | 28 |
970938 | 970938 | 2021-01-27 | Grant | New Mexico | 35017 | 1249 | 28 |
967693 | 967693 | 2021-01-26 | Grant | New Mexico | 35017 | 1244 | 25 |
964449 | 964449 | 2021-01-25 | Grant | New Mexico | 35017 | 1242 | 25 |
961204 | 961204 | 2021-01-24 | Grant | New Mexico | 35017 | 1238 | 25 |
957958 | 957958 | 2021-01-23 | Grant | New Mexico | 35017 | 1234 | 24 |
954713 | 954713 | 2021-01-22 | Grant | New Mexico | 35017 | 1221 | 24 |
951468 | 951468 | 2021-01-21 | Grant | New Mexico | 35017 | 1212 | 23 |
948222 | 948222 | 2021-01-20 | Grant | New Mexico | 35017 | 1206 | 23 |
944975 | 944975 | 2021-01-19 | Grant | New Mexico | 35017 | 1201 | 22 |
941730 | 941730 | 2021-01-18 | Grant | New Mexico | 35017 | 1191 | 22 |
938485 | 938485 | 2021-01-17 | Grant | New Mexico | 35017 | 1185 | 22 |
935240 | 935240 | 2021-01-16 | Grant | New Mexico | 35017 | 1172 | 22 |
931995 | 931995 | 2021-01-15 | Grant | New Mexico | 35017 | 1159 | 22 |
928750 | 928750 | 2021-01-14 | Grant | New Mexico | 35017 | 1145 | 21 |
925504 | 925504 | 2021-01-13 | Grant | New Mexico | 35017 | 1126 | 21 |
922259 | 922259 | 2021-01-12 | Grant | New Mexico | 35017 | 1115 | 20 |
919014 | 919014 | 2021-01-11 | Grant | New Mexico | 35017 | 1107 | 20 |
915769 | 915769 | 2021-01-10 | Grant | New Mexico | 35017 | 1094 | 18 |
912524 | 912524 | 2021-01-09 | Grant | New Mexico | 35017 | 1070 | 17 |
909279 | 909279 | 2021-01-08 | Grant | New Mexico | 35017 | 1050 | 16 |
906033 | 906033 | 2021-01-07 | Grant | New Mexico | 35017 | 1030 | 16 |
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 |
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);