ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25,445 rows where state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 34
- 35001 461
- 35049 461
- 35053 461
- 35043 458
- 35055 455
- 35047 453
- 35013 452
- 35031 452
- 35025 451
- 35045 450
- 35005 449
- 35006 448
- 35009 448
- 35015 447
- 35039 447
- 35041 445
- 35061 445
- 35057 442
- 35003 440
- 35017 440
- 35035 440
- 35027 437
- 35028 437
- 35007 432
- 35029 431
- 35037 430
- 35019 423
- 35021 418
- 35059 416
- 35051 412
- 35023 393
- 35033 340
- 35011 278
- - 62
county 34
- Bernalillo 461
- Santa Fe 461
- Socorro 461
- Sandoval 458
- Taos 455
- San Miguel 453
- Doña Ana 452
- McKinley 452
- Lea 451
- San Juan 450
- Chaves 449
- Cibola 448
- Curry 448
- Eddy 447
- Rio Arriba 447
- Roosevelt 445
- Valencia 445
- Torrance 442
- Catron 440
- Grant 440
- Otero 440
- Lincoln 437
- Los Alamos 437
- Colfax 432
- Luna 431
- Quay 430
- Guadalupe 423
- Harding 418
- Union 416
- Sierra 412
- Hidalgo 393
- Mora 340
- De Baca 278
- Unknown 62
state 1
- New Mexico · 14,354 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418941 | 1418941 | 2021-06-14 | Bernalillo | New Mexico | 35001 | 58790 | 958 |
1418942 | 1418942 | 2021-06-14 | Catron | New Mexico | 35003 | 95 | 5 |
1418943 | 1418943 | 2021-06-14 | Chaves | New Mexico | 35005 | 9285 | 169 |
1418944 | 1418944 | 2021-06-14 | Cibola | New Mexico | 35006 | 3544 | 125 |
1418945 | 1418945 | 2021-06-14 | Colfax | New Mexico | 35007 | 948 | 45 |
1418946 | 1418946 | 2021-06-14 | Curry | New Mexico | 35009 | 5273 | 84 |
1418947 | 1418947 | 2021-06-14 | De Baca | New Mexico | 35011 | 176 | 2 |
1418948 | 1418948 | 2021-06-14 | Doña Ana | New Mexico | 35013 | 25246 | 488 |
1418949 | 1418949 | 2021-06-14 | Eddy | New Mexico | 35015 | 6915 | 140 |
1418950 | 1418950 | 2021-06-14 | Grant | New Mexico | 35017 | 1741 | 41 |
1418951 | 1418951 | 2021-06-14 | Guadalupe | New Mexico | 35019 | 705 | 11 |
1418952 | 1418952 | 2021-06-14 | Harding | New Mexico | 35021 | 12 | 1 |
1418953 | 1418953 | 2021-06-14 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1418954 | 1418954 | 2021-06-14 | Lea | New Mexico | 35025 | 9147 | 196 |
1418955 | 1418955 | 2021-06-14 | Lincoln | New Mexico | 35027 | 1761 | 18 |
1418956 | 1418956 | 2021-06-14 | Los Alamos | New Mexico | 35028 | 534 | 6 |
1418957 | 1418957 | 2021-06-14 | Luna | New Mexico | 35029 | 3370 | 92 |
1418958 | 1418958 | 2021-06-14 | McKinley | New Mexico | 35031 | 12358 | 478 |
1418959 | 1418959 | 2021-06-14 | Mora | New Mexico | 35033 | 173 | 7 |
1418960 | 1418960 | 2021-06-14 | Otero | New Mexico | 35035 | 5207 | 77 |
1418961 | 1418961 | 2021-06-14 | Quay | New Mexico | 35037 | 530 | 10 |
1418962 | 1418962 | 2021-06-14 | Rio Arriba | New Mexico | 35039 | 3730 | 78 |
1418963 | 1418963 | 2021-06-14 | Roosevelt | New Mexico | 35041 | 2019 | 59 |
1418964 | 1418964 | 2021-06-14 | San Juan | New Mexico | 35045 | 15610 | 492 |
1418965 | 1418965 | 2021-06-14 | San Miguel | New Mexico | 35047 | 1387 | 17 |
1418966 | 1418966 | 2021-06-14 | Sandoval | New Mexico | 35043 | 12186 | 241 |
1418967 | 1418967 | 2021-06-14 | Santa Fe | New Mexico | 35049 | 10758 | 149 |
1418968 | 1418968 | 2021-06-14 | Sierra | New Mexico | 35051 | 781 | 52 |
1418969 | 1418969 | 2021-06-14 | Socorro | New Mexico | 35053 | 1323 | 60 |
1418970 | 1418970 | 2021-06-14 | Taos | New Mexico | 35055 | 1697 | 53 |
1418971 | 1418971 | 2021-06-14 | Torrance | New Mexico | 35057 | 1031 | 14 |
1418972 | 1418972 | 2021-06-14 | Union | New Mexico | 35059 | 425 | 10 |
1418973 | 1418973 | 2021-06-14 | Valencia | New Mexico | 35061 | 7149 | 117 |
1415696 | 1415696 | 2021-06-13 | Bernalillo | New Mexico | 35001 | 58733 | 954 |
1415697 | 1415697 | 2021-06-13 | Catron | New Mexico | 35003 | 95 | 5 |
1415698 | 1415698 | 2021-06-13 | Chaves | New Mexico | 35005 | 9274 | 169 |
1415699 | 1415699 | 2021-06-13 | Cibola | New Mexico | 35006 | 3543 | 125 |
1415700 | 1415700 | 2021-06-13 | Colfax | New Mexico | 35007 | 946 | 45 |
1415701 | 1415701 | 2021-06-13 | Curry | New Mexico | 35009 | 5265 | 84 |
1415702 | 1415702 | 2021-06-13 | De Baca | New Mexico | 35011 | 174 | 2 |
1415703 | 1415703 | 2021-06-13 | Doña Ana | New Mexico | 35013 | 25216 | 488 |
1415704 | 1415704 | 2021-06-13 | Eddy | New Mexico | 35015 | 6909 | 140 |
1415705 | 1415705 | 2021-06-13 | Grant | New Mexico | 35017 | 1739 | 41 |
1415706 | 1415706 | 2021-06-13 | Guadalupe | New Mexico | 35019 | 703 | 11 |
1415707 | 1415707 | 2021-06-13 | Harding | New Mexico | 35021 | 12 | 1 |
1415708 | 1415708 | 2021-06-13 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1415709 | 1415709 | 2021-06-13 | Lea | New Mexico | 35025 | 9136 | 196 |
1415710 | 1415710 | 2021-06-13 | Lincoln | New Mexico | 35027 | 1760 | 18 |
1415711 | 1415711 | 2021-06-13 | Los Alamos | New Mexico | 35028 | 534 | 6 |
1415712 | 1415712 | 2021-06-13 | Luna | New Mexico | 35029 | 3363 | 92 |
1415713 | 1415713 | 2021-06-13 | McKinley | New Mexico | 35031 | 12354 | 478 |
1415714 | 1415714 | 2021-06-13 | Mora | New Mexico | 35033 | 173 | 7 |
1415715 | 1415715 | 2021-06-13 | Otero | New Mexico | 35035 | 5201 | 77 |
1415716 | 1415716 | 2021-06-13 | Quay | New Mexico | 35037 | 526 | 10 |
1415717 | 1415717 | 2021-06-13 | Rio Arriba | New Mexico | 35039 | 3723 | 77 |
1415718 | 1415718 | 2021-06-13 | Roosevelt | New Mexico | 35041 | 2017 | 59 |
1415719 | 1415719 | 2021-06-13 | San Juan | New Mexico | 35045 | 15592 | 492 |
1415720 | 1415720 | 2021-06-13 | San Miguel | New Mexico | 35047 | 1384 | 17 |
1415721 | 1415721 | 2021-06-13 | Sandoval | New Mexico | 35043 | 12175 | 241 |
1415722 | 1415722 | 2021-06-13 | Santa Fe | New Mexico | 35049 | 10738 | 149 |
1415723 | 1415723 | 2021-06-13 | Sierra | New Mexico | 35051 | 781 | 52 |
1415724 | 1415724 | 2021-06-13 | Socorro | New Mexico | 35053 | 1323 | 60 |
1415725 | 1415725 | 2021-06-13 | Taos | New Mexico | 35055 | 1695 | 53 |
1415726 | 1415726 | 2021-06-13 | Torrance | New Mexico | 35057 | 1025 | 14 |
1415727 | 1415727 | 2021-06-13 | Union | New Mexico | 35059 | 425 | 10 |
1415728 | 1415728 | 2021-06-13 | Valencia | New Mexico | 35061 | 7145 | 117 |
1412450 | 1412450 | 2021-06-12 | Bernalillo | New Mexico | 35001 | 58733 | 954 |
1412451 | 1412451 | 2021-06-12 | Catron | New Mexico | 35003 | 95 | 5 |
1412452 | 1412452 | 2021-06-12 | Chaves | New Mexico | 35005 | 9274 | 169 |
1412453 | 1412453 | 2021-06-12 | Cibola | New Mexico | 35006 | 3543 | 125 |
1412454 | 1412454 | 2021-06-12 | Colfax | New Mexico | 35007 | 946 | 45 |
1412455 | 1412455 | 2021-06-12 | Curry | New Mexico | 35009 | 5265 | 84 |
1412456 | 1412456 | 2021-06-12 | De Baca | New Mexico | 35011 | 174 | 2 |
1412457 | 1412457 | 2021-06-12 | Doña Ana | New Mexico | 35013 | 25216 | 488 |
1412458 | 1412458 | 2021-06-12 | Eddy | New Mexico | 35015 | 6909 | 140 |
1412459 | 1412459 | 2021-06-12 | Grant | New Mexico | 35017 | 1739 | 41 |
1412460 | 1412460 | 2021-06-12 | Guadalupe | New Mexico | 35019 | 703 | 11 |
1412461 | 1412461 | 2021-06-12 | Harding | New Mexico | 35021 | 12 | 1 |
1412462 | 1412462 | 2021-06-12 | Hidalgo | New Mexico | 35023 | 365 | 9 |
1412463 | 1412463 | 2021-06-12 | Lea | New Mexico | 35025 | 9136 | 196 |
1412464 | 1412464 | 2021-06-12 | Lincoln | New Mexico | 35027 | 1760 | 18 |
1412465 | 1412465 | 2021-06-12 | Los Alamos | New Mexico | 35028 | 534 | 6 |
1412466 | 1412466 | 2021-06-12 | Luna | New Mexico | 35029 | 3363 | 92 |
1412467 | 1412467 | 2021-06-12 | McKinley | New Mexico | 35031 | 12354 | 478 |
1412468 | 1412468 | 2021-06-12 | Mora | New Mexico | 35033 | 173 | 7 |
1412469 | 1412469 | 2021-06-12 | Otero | New Mexico | 35035 | 5201 | 77 |
1412470 | 1412470 | 2021-06-12 | Quay | New Mexico | 35037 | 526 | 10 |
1412471 | 1412471 | 2021-06-12 | Rio Arriba | New Mexico | 35039 | 3723 | 77 |
1412472 | 1412472 | 2021-06-12 | Roosevelt | New Mexico | 35041 | 2017 | 59 |
1412473 | 1412473 | 2021-06-12 | San Juan | New Mexico | 35045 | 15592 | 492 |
1412474 | 1412474 | 2021-06-12 | San Miguel | New Mexico | 35047 | 1384 | 17 |
1412475 | 1412475 | 2021-06-12 | Sandoval | New Mexico | 35043 | 12175 | 241 |
1412476 | 1412476 | 2021-06-12 | Santa Fe | New Mexico | 35049 | 10738 | 149 |
1412477 | 1412477 | 2021-06-12 | Sierra | New Mexico | 35051 | 781 | 52 |
1412478 | 1412478 | 2021-06-12 | Socorro | New Mexico | 35053 | 1323 | 60 |
1412479 | 1412479 | 2021-06-12 | Taos | New Mexico | 35055 | 1695 | 53 |
1412480 | 1412480 | 2021-06-12 | Torrance | New Mexico | 35057 | 1025 | 14 |
1412481 | 1412481 | 2021-06-12 | Union | New Mexico | 35059 | 425 | 10 |
1412482 | 1412482 | 2021-06-12 | Valencia | New Mexico | 35061 | 7145 | 117 |
1409205 | 1409205 | 2021-06-11 | Bernalillo | New Mexico | 35001 | 58733 | 954 |
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);