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 220
- 35049 220
- 35053 220
- 35043 217
- 35055 214
- 35047 212
- 35013 211
- 35031 211
- 35025 210
- 35045 209
- 35005 208
- 35006 207
- 35009 207
- 35015 206
- 35039 206
- 35041 204
- 35061 204
- 35057 201
- 35003 199
- 35017 199
- 35035 199
- 35027 196
- 35028 196
- 35007 191
- 35029 190
- 35037 189
- 35019 182
- 35021 177
- 35059 175
- 35051 171
- 35023 152
- 35033 99
- 35011 37
- - 34
county 34
- Bernalillo 220
- Santa Fe 220
- Socorro 220
- Sandoval 217
- Taos 214
- San Miguel 212
- Doña Ana 211
- McKinley 211
- Lea 210
- San Juan 209
- Chaves 208
- Cibola 207
- Curry 207
- Eddy 206
- Rio Arriba 206
- Roosevelt 204
- Valencia 204
- Torrance 201
- Catron 199
- Grant 199
- Otero 199
- Lincoln 196
- Los Alamos 196
- Colfax 191
- Luna 190
- Quay 189
- Guadalupe 182
- Harding 177
- Union 175
- Sierra 171
- Hidalgo 152
- Mora 99
- De Baca 37
- Unknown 34
state 1
- New Mexico · 6,373 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636697 | 636697 | 2020-10-16 | Bernalillo | New Mexico | 35001 | 8605 | 185 |
636698 | 636698 | 2020-10-16 | Catron | New Mexico | 35003 | 9 | 1 |
636699 | 636699 | 2020-10-16 | Chaves | New Mexico | 35005 | 1687 | 17 |
636700 | 636700 | 2020-10-16 | Cibola | New Mexico | 35006 | 821 | 21 |
636701 | 636701 | 2020-10-16 | Colfax | New Mexico | 35007 | 41 | 1 |
636702 | 636702 | 2020-10-16 | Curry | New Mexico | 35009 | 1231 | 8 |
636703 | 636703 | 2020-10-16 | De Baca | New Mexico | 35011 | 1 | 0 |
636704 | 636704 | 2020-10-16 | Doña Ana | New Mexico | 35013 | 4536 | 63 |
636705 | 636705 | 2020-10-16 | Eddy | New Mexico | 35015 | 1125 | 17 |
636706 | 636706 | 2020-10-16 | Grant | New Mexico | 35017 | 159 | 2 |
636707 | 636707 | 2020-10-16 | Guadalupe | New Mexico | 35019 | 37 | 1 |
636708 | 636708 | 2020-10-16 | Harding | New Mexico | 35021 | 1 | 0 |
636709 | 636709 | 2020-10-16 | Hidalgo | New Mexico | 35023 | 111 | 2 |
636710 | 636710 | 2020-10-16 | Lea | New Mexico | 35025 | 1843 | 28 |
636711 | 636711 | 2020-10-16 | Lincoln | New Mexico | 35027 | 283 | 4 |
636712 | 636712 | 2020-10-16 | Los Alamos | New Mexico | 35028 | 37 | 0 |
636713 | 636713 | 2020-10-16 | Luna | New Mexico | 35029 | 558 | 10 |
636714 | 636714 | 2020-10-16 | McKinley | New Mexico | 35031 | 4454 | 260 |
636715 | 636715 | 2020-10-16 | Mora | New Mexico | 35033 | 13 | 0 |
636716 | 636716 | 2020-10-16 | Otero | New Mexico | 35035 | 1317 | 13 |
636717 | 636717 | 2020-10-16 | Quay | New Mexico | 35037 | 86 | 2 |
636718 | 636718 | 2020-10-16 | Rio Arriba | New Mexico | 35039 | 432 | 14 |
636719 | 636719 | 2020-10-16 | Roosevelt | New Mexico | 35041 | 373 | 6 |
636720 | 636720 | 2020-10-16 | San Juan | New Mexico | 35045 | 3565 | 203 |
636721 | 636721 | 2020-10-16 | San Miguel | New Mexico | 35047 | 132 | 0 |
636722 | 636722 | 2020-10-16 | Sandoval | New Mexico | 35043 | 1664 | 43 |
636723 | 636723 | 2020-10-16 | Santa Fe | New Mexico | 35049 | 1313 | 8 |
636724 | 636724 | 2020-10-16 | Sierra | New Mexico | 35051 | 73 | 1 |
636725 | 636725 | 2020-10-16 | Socorro | New Mexico | 35053 | 155 | 7 |
636726 | 636726 | 2020-10-16 | Taos | New Mexico | 35055 | 165 | 4 |
636727 | 636727 | 2020-10-16 | Torrance | New Mexico | 35057 | 135 | 1 |
636728 | 636728 | 2020-10-16 | Union | New Mexico | 35059 | 43 | 2 |
636729 | 636729 | 2020-10-16 | Valencia | New Mexico | 35061 | 765 | 4 |
633451 | 633451 | 2020-10-15 | Bernalillo | New Mexico | 35001 | 8428 | 184 |
633452 | 633452 | 2020-10-15 | Catron | New Mexico | 35003 | 9 | 1 |
633453 | 633453 | 2020-10-15 | Chaves | New Mexico | 35005 | 1664 | 16 |
633454 | 633454 | 2020-10-15 | Cibola | New Mexico | 35006 | 813 | 21 |
633455 | 633455 | 2020-10-15 | Colfax | New Mexico | 35007 | 41 | 1 |
633456 | 633456 | 2020-10-15 | Curry | New Mexico | 35009 | 1155 | 8 |
633457 | 633457 | 2020-10-15 | De Baca | New Mexico | 35011 | 1 | 0 |
633458 | 633458 | 2020-10-15 | Doña Ana | New Mexico | 35013 | 4371 | 63 |
633459 | 633459 | 2020-10-15 | Eddy | New Mexico | 35015 | 1089 | 16 |
633460 | 633460 | 2020-10-15 | Grant | New Mexico | 35017 | 156 | 2 |
633461 | 633461 | 2020-10-15 | Guadalupe | New Mexico | 35019 | 37 | 1 |
633462 | 633462 | 2020-10-15 | Harding | New Mexico | 35021 | 1 | 0 |
633463 | 633463 | 2020-10-15 | Hidalgo | New Mexico | 35023 | 111 | 2 |
633464 | 633464 | 2020-10-15 | Lea | New Mexico | 35025 | 1788 | 28 |
633465 | 633465 | 2020-10-15 | Lincoln | New Mexico | 35027 | 267 | 4 |
633466 | 633466 | 2020-10-15 | Los Alamos | New Mexico | 35028 | 37 | 0 |
633467 | 633467 | 2020-10-15 | Luna | New Mexico | 35029 | 528 | 10 |
633468 | 633468 | 2020-10-15 | McKinley | New Mexico | 35031 | 4449 | 260 |
633469 | 633469 | 2020-10-15 | Mora | New Mexico | 35033 | 12 | 0 |
633470 | 633470 | 2020-10-15 | Otero | New Mexico | 35035 | 1263 | 13 |
633471 | 633471 | 2020-10-15 | Quay | New Mexico | 35037 | 86 | 2 |
633472 | 633472 | 2020-10-15 | Rio Arriba | New Mexico | 35039 | 428 | 14 |
633473 | 633473 | 2020-10-15 | Roosevelt | New Mexico | 35041 | 365 | 5 |
633474 | 633474 | 2020-10-15 | San Juan | New Mexico | 35045 | 3536 | 202 |
633475 | 633475 | 2020-10-15 | San Miguel | New Mexico | 35047 | 128 | 0 |
633476 | 633476 | 2020-10-15 | Sandoval | New Mexico | 35043 | 1622 | 43 |
633477 | 633477 | 2020-10-15 | Santa Fe | New Mexico | 35049 | 1275 | 8 |
633478 | 633478 | 2020-10-15 | Sierra | New Mexico | 35051 | 67 | 1 |
633479 | 633479 | 2020-10-15 | Socorro | New Mexico | 35053 | 148 | 6 |
633480 | 633480 | 2020-10-15 | Taos | New Mexico | 35055 | 164 | 4 |
633481 | 633481 | 2020-10-15 | Torrance | New Mexico | 35057 | 135 | 1 |
633482 | 633482 | 2020-10-15 | Union | New Mexico | 35059 | 42 | 2 |
633483 | 633483 | 2020-10-15 | Valencia | New Mexico | 35061 | 742 | 4 |
630206 | 630206 | 2020-10-14 | Bernalillo | New Mexico | 35001 | 8126 | 184 |
630207 | 630207 | 2020-10-14 | Catron | New Mexico | 35003 | 9 | 1 |
630208 | 630208 | 2020-10-14 | Chaves | New Mexico | 35005 | 1627 | 16 |
630209 | 630209 | 2020-10-14 | Cibola | New Mexico | 35006 | 808 | 21 |
630210 | 630210 | 2020-10-14 | Colfax | New Mexico | 35007 | 41 | 1 |
630211 | 630211 | 2020-10-14 | Curry | New Mexico | 35009 | 1136 | 8 |
630212 | 630212 | 2020-10-14 | De Baca | New Mexico | 35011 | 3 | 0 |
630213 | 630213 | 2020-10-14 | Doña Ana | New Mexico | 35013 | 4280 | 63 |
630214 | 630214 | 2020-10-14 | Eddy | New Mexico | 35015 | 1064 | 16 |
630215 | 630215 | 2020-10-14 | Grant | New Mexico | 35017 | 151 | 2 |
630216 | 630216 | 2020-10-14 | Guadalupe | New Mexico | 35019 | 37 | 1 |
630217 | 630217 | 2020-10-14 | Harding | New Mexico | 35021 | 1 | 0 |
630218 | 630218 | 2020-10-14 | Hidalgo | New Mexico | 35023 | 108 | 2 |
630219 | 630219 | 2020-10-14 | Lea | New Mexico | 35025 | 1759 | 28 |
630220 | 630220 | 2020-10-14 | Lincoln | New Mexico | 35027 | 263 | 4 |
630221 | 630221 | 2020-10-14 | Los Alamos | New Mexico | 35028 | 37 | 0 |
630222 | 630222 | 2020-10-14 | Luna | New Mexico | 35029 | 514 | 9 |
630223 | 630223 | 2020-10-14 | McKinley | New Mexico | 35031 | 4435 | 260 |
630224 | 630224 | 2020-10-14 | Mora | New Mexico | 35033 | 10 | 0 |
630225 | 630225 | 2020-10-14 | Otero | New Mexico | 35035 | 1257 | 13 |
630226 | 630226 | 2020-10-14 | Quay | New Mexico | 35037 | 80 | 2 |
630227 | 630227 | 2020-10-14 | Rio Arriba | New Mexico | 35039 | 427 | 14 |
630228 | 630228 | 2020-10-14 | Roosevelt | New Mexico | 35041 | 359 | 5 |
630229 | 630229 | 2020-10-14 | San Juan | New Mexico | 35045 | 3508 | 202 |
630230 | 630230 | 2020-10-14 | San Miguel | New Mexico | 35047 | 125 | 0 |
630231 | 630231 | 2020-10-14 | Sandoval | New Mexico | 35043 | 1594 | 43 |
630232 | 630232 | 2020-10-14 | Santa Fe | New Mexico | 35049 | 1258 | 8 |
630233 | 630233 | 2020-10-14 | Sierra | New Mexico | 35051 | 67 | 1 |
630234 | 630234 | 2020-10-14 | Socorro | New Mexico | 35053 | 148 | 6 |
630235 | 630235 | 2020-10-14 | Taos | New Mexico | 35055 | 162 | 4 |
630236 | 630236 | 2020-10-14 | Torrance | New Mexico | 35057 | 135 | 1 |
630237 | 630237 | 2020-10-14 | Union | New Mexico | 35059 | 42 | 2 |
630238 | 630238 | 2020-10-14 | Valencia | New Mexico | 35061 | 719 | 4 |
626962 | 626962 | 2020-10-13 | Bernalillo | New Mexico | 35001 | 7926 | 183 |
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);