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 308
- 35049 308
- 35053 308
- 35043 305
- 35055 302
- 35047 300
- 35013 299
- 35031 299
- 35025 298
- 35045 297
- 35005 296
- 35006 295
- 35009 295
- 35015 294
- 35039 294
- 35041 292
- 35061 292
- 35057 289
- 35003 287
- 35017 287
- 35035 287
- 35027 284
- 35028 284
- 35007 279
- 35029 278
- 35037 277
- 35019 270
- 35021 265
- 35059 263
- 35051 259
- 35023 240
- 35033 187
- 35011 125
- - 41
county 34
- Bernalillo 308
- Santa Fe 308
- Socorro 308
- Sandoval 305
- Taos 302
- San Miguel 300
- Doña Ana 299
- McKinley 299
- Lea 298
- San Juan 297
- Chaves 296
- Cibola 295
- Curry 295
- Eddy 294
- Rio Arriba 294
- Roosevelt 292
- Valencia 292
- Torrance 289
- Catron 287
- Grant 287
- Otero 287
- Lincoln 284
- Los Alamos 284
- Colfax 279
- Luna 278
- Quay 277
- Guadalupe 270
- Harding 265
- Union 263
- Sierra 259
- Hidalgo 240
- Mora 187
- De Baca 125
- Unknown 41
state 1
- New Mexico · 9,284 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922250 | 922250 | 2021-01-12 | Bernalillo | New Mexico | 35001 | 44923 | 654 |
922251 | 922251 | 2021-01-12 | Catron | New Mexico | 35003 | 66 | 3 |
922252 | 922252 | 2021-01-12 | Chaves | New Mexico | 35005 | 7815 | 111 |
922253 | 922253 | 2021-01-12 | Cibola | New Mexico | 35006 | 3025 | 82 |
922254 | 922254 | 2021-01-12 | Colfax | New Mexico | 35007 | 754 | 27 |
922255 | 922255 | 2021-01-12 | Curry | New Mexico | 35009 | 4394 | 52 |
922256 | 922256 | 2021-01-12 | De Baca | New Mexico | 35011 | 114 | 0 |
922257 | 922257 | 2021-01-12 | Doña Ana | New Mexico | 35013 | 19327 | 307 |
922258 | 922258 | 2021-01-12 | Eddy | New Mexico | 35015 | 5257 | 82 |
922259 | 922259 | 2021-01-12 | Grant | New Mexico | 35017 | 1115 | 20 |
922260 | 922260 | 2021-01-12 | Guadalupe | New Mexico | 35019 | 554 | 6 |
922261 | 922261 | 2021-01-12 | Harding | New Mexico | 35021 | 8 | 0 |
922262 | 922262 | 2021-01-12 | Hidalgo | New Mexico | 35023 | 278 | 9 |
922263 | 922263 | 2021-01-12 | Lea | New Mexico | 35025 | 7595 | 103 |
922264 | 922264 | 2021-01-12 | Lincoln | New Mexico | 35027 | 1178 | 13 |
922265 | 922265 | 2021-01-12 | Los Alamos | New Mexico | 35028 | 350 | 1 |
922266 | 922266 | 2021-01-12 | Luna | New Mexico | 35029 | 2532 | 45 |
922267 | 922267 | 2021-01-12 | McKinley | New Mexico | 35031 | 10631 | 370 |
922268 | 922268 | 2021-01-12 | Mora | New Mexico | 35033 | 134 | 5 |
922269 | 922269 | 2021-01-12 | Otero | New Mexico | 35035 | 3538 | 43 |
922270 | 922270 | 2021-01-12 | Quay | New Mexico | 35037 | 367 | 8 |
922271 | 922271 | 2021-01-12 | Rio Arriba | New Mexico | 35039 | 2727 | 45 |
922272 | 922272 | 2021-01-12 | Roosevelt | New Mexico | 35041 | 1652 | 37 |
922273 | 922273 | 2021-01-12 | San Juan | New Mexico | 35045 | 11664 | 318 |
922274 | 922274 | 2021-01-12 | San Miguel | New Mexico | 35047 | 966 | 6 |
922275 | 922275 | 2021-01-12 | Sandoval | New Mexico | 35043 | 9176 | 148 |
922276 | 922276 | 2021-01-12 | Santa Fe | New Mexico | 35049 | 8351 | 89 |
922277 | 922277 | 2021-01-12 | Sierra | New Mexico | 35051 | 628 | 39 |
922278 | 922278 | 2021-01-12 | Socorro | New Mexico | 35053 | 1011 | 46 |
922279 | 922279 | 2021-01-12 | Taos | New Mexico | 35055 | 1277 | 42 |
922280 | 922280 | 2021-01-12 | Torrance | New Mexico | 35057 | 577 | 8 |
922281 | 922281 | 2021-01-12 | Union | New Mexico | 35059 | 369 | 7 |
922282 | 922282 | 2021-01-12 | Valencia | New Mexico | 35061 | 5621 | 70 |
919005 | 919005 | 2021-01-11 | Bernalillo | New Mexico | 35001 | 44698 | 648 |
919006 | 919006 | 2021-01-11 | Catron | New Mexico | 35003 | 64 | 3 |
919007 | 919007 | 2021-01-11 | Chaves | New Mexico | 35005 | 7779 | 108 |
919008 | 919008 | 2021-01-11 | Cibola | New Mexico | 35006 | 3007 | 81 |
919009 | 919009 | 2021-01-11 | Colfax | New Mexico | 35007 | 751 | 27 |
919010 | 919010 | 2021-01-11 | Curry | New Mexico | 35009 | 4373 | 52 |
919011 | 919011 | 2021-01-11 | De Baca | New Mexico | 35011 | 112 | 0 |
919012 | 919012 | 2021-01-11 | Doña Ana | New Mexico | 35013 | 19223 | 302 |
919013 | 919013 | 2021-01-11 | Eddy | New Mexico | 35015 | 5218 | 82 |
919014 | 919014 | 2021-01-11 | Grant | New Mexico | 35017 | 1107 | 20 |
919015 | 919015 | 2021-01-11 | Guadalupe | New Mexico | 35019 | 553 | 6 |
919016 | 919016 | 2021-01-11 | Harding | New Mexico | 35021 | 8 | 0 |
919017 | 919017 | 2021-01-11 | Hidalgo | New Mexico | 35023 | 278 | 8 |
919018 | 919018 | 2021-01-11 | Lea | New Mexico | 35025 | 7566 | 102 |
919019 | 919019 | 2021-01-11 | Lincoln | New Mexico | 35027 | 1173 | 13 |
919020 | 919020 | 2021-01-11 | Los Alamos | New Mexico | 35028 | 348 | 1 |
919021 | 919021 | 2021-01-11 | Luna | New Mexico | 35029 | 2526 | 45 |
919022 | 919022 | 2021-01-11 | McKinley | New Mexico | 35031 | 10569 | 366 |
919023 | 919023 | 2021-01-11 | Mora | New Mexico | 35033 | 134 | 4 |
919024 | 919024 | 2021-01-11 | Otero | New Mexico | 35035 | 3528 | 43 |
919025 | 919025 | 2021-01-11 | Quay | New Mexico | 35037 | 366 | 8 |
919026 | 919026 | 2021-01-11 | Rio Arriba | New Mexico | 35039 | 2696 | 45 |
919027 | 919027 | 2021-01-11 | Roosevelt | New Mexico | 35041 | 1640 | 35 |
919028 | 919028 | 2021-01-11 | San Juan | New Mexico | 35045 | 11576 | 314 |
919029 | 919029 | 2021-01-11 | San Miguel | New Mexico | 35047 | 960 | 6 |
919030 | 919030 | 2021-01-11 | Sandoval | New Mexico | 35043 | 9087 | 147 |
919031 | 919031 | 2021-01-11 | Santa Fe | New Mexico | 35049 | 8314 | 88 |
919032 | 919032 | 2021-01-11 | Sierra | New Mexico | 35051 | 617 | 39 |
919033 | 919033 | 2021-01-11 | Socorro | New Mexico | 35053 | 1009 | 46 |
919034 | 919034 | 2021-01-11 | Taos | New Mexico | 35055 | 1274 | 42 |
919035 | 919035 | 2021-01-11 | Torrance | New Mexico | 35057 | 574 | 8 |
919036 | 919036 | 2021-01-11 | Union | New Mexico | 35059 | 367 | 7 |
919037 | 919037 | 2021-01-11 | Valencia | New Mexico | 35061 | 5592 | 70 |
915760 | 915760 | 2021-01-10 | Bernalillo | New Mexico | 35001 | 44442 | 644 |
915761 | 915761 | 2021-01-10 | Catron | New Mexico | 35003 | 64 | 3 |
915762 | 915762 | 2021-01-10 | Chaves | New Mexico | 35005 | 7760 | 107 |
915763 | 915763 | 2021-01-10 | Cibola | New Mexico | 35006 | 2985 | 80 |
915764 | 915764 | 2021-01-10 | Colfax | New Mexico | 35007 | 746 | 27 |
915765 | 915765 | 2021-01-10 | Curry | New Mexico | 35009 | 4340 | 52 |
915766 | 915766 | 2021-01-10 | De Baca | New Mexico | 35011 | 112 | 0 |
915767 | 915767 | 2021-01-10 | Doña Ana | New Mexico | 35013 | 19119 | 302 |
915768 | 915768 | 2021-01-10 | Eddy | New Mexico | 35015 | 5184 | 82 |
915769 | 915769 | 2021-01-10 | Grant | New Mexico | 35017 | 1094 | 18 |
915770 | 915770 | 2021-01-10 | Guadalupe | New Mexico | 35019 | 551 | 6 |
915771 | 915771 | 2021-01-10 | Harding | New Mexico | 35021 | 8 | 0 |
915772 | 915772 | 2021-01-10 | Hidalgo | New Mexico | 35023 | 276 | 8 |
915773 | 915773 | 2021-01-10 | Lea | New Mexico | 35025 | 7547 | 100 |
915774 | 915774 | 2021-01-10 | Lincoln | New Mexico | 35027 | 1153 | 13 |
915775 | 915775 | 2021-01-10 | Los Alamos | New Mexico | 35028 | 346 | 1 |
915776 | 915776 | 2021-01-10 | Luna | New Mexico | 35029 | 2505 | 45 |
915777 | 915777 | 2021-01-10 | McKinley | New Mexico | 35031 | 10528 | 365 |
915778 | 915778 | 2021-01-10 | Mora | New Mexico | 35033 | 133 | 4 |
915779 | 915779 | 2021-01-10 | Otero | New Mexico | 35035 | 3488 | 43 |
915780 | 915780 | 2021-01-10 | Quay | New Mexico | 35037 | 363 | 8 |
915781 | 915781 | 2021-01-10 | Rio Arriba | New Mexico | 35039 | 2677 | 45 |
915782 | 915782 | 2021-01-10 | Roosevelt | New Mexico | 35041 | 1625 | 35 |
915783 | 915783 | 2021-01-10 | San Juan | New Mexico | 35045 | 11503 | 314 |
915784 | 915784 | 2021-01-10 | San Miguel | New Mexico | 35047 | 954 | 5 |
915785 | 915785 | 2021-01-10 | Sandoval | New Mexico | 35043 | 9033 | 145 |
915786 | 915786 | 2021-01-10 | Santa Fe | New Mexico | 35049 | 8248 | 87 |
915787 | 915787 | 2021-01-10 | Sierra | New Mexico | 35051 | 617 | 39 |
915788 | 915788 | 2021-01-10 | Socorro | New Mexico | 35053 | 1002 | 46 |
915789 | 915789 | 2021-01-10 | Taos | New Mexico | 35055 | 1262 | 42 |
915790 | 915790 | 2021-01-10 | Torrance | New Mexico | 35057 | 574 | 8 |
915791 | 915791 | 2021-01-10 | Union | New Mexico | 35059 | 366 | 7 |
915792 | 915792 | 2021-01-10 | Valencia | New Mexico | 35061 | 5552 | 70 |
912515 | 912515 | 2021-01-09 | Bernalillo | New Mexico | 35001 | 44177 | 639 |
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);