latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where state = "New Mexico" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- New Mexico · 33 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Bernalillo | New Mexico | 35001 | 149543 | 1854 | 679121 | 2729 | 220200 |
2022-05-13 | Catron | New Mexico | 35003 | 420 | 14 | 3527 | 3969 | 119081 |
2022-05-13 | Chaves | New Mexico | 35005 | 21774 | 328 | 64615 | 5076 | 336980 |
2022-05-13 | Cibola | New Mexico | 35006 | 8048 | 189 | 26675 | 7085 | 301705 |
2022-05-13 | Colfax | New Mexico | 35007 | 2708 | 65 | 11941 | 5443 | 226781 |
2022-05-13 | Curry | New Mexico | 35009 | 12797 | 198 | 48954 | 4044 | 261408 |
2022-05-13 | De Baca | New Mexico | 35011 | 589 | 6 | 1748 | 3432 | 336956 |
2022-05-13 | Doña Ana | New Mexico | 35013 | 63972 | 773 | 218195 | 3542 | 293187 |
2022-05-13 | Eddy | New Mexico | 35015 | 17069 | 282 | 58460 | 4823 | 291977 |
2022-05-13 | Grant | New Mexico | 35017 | 6748 | 90 | 26998 | 3333 | 249944 |
2022-05-13 | Guadalupe | New Mexico | 35019 | 1482 | 17 | 4300 | 3953 | 344651 |
2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 | 625 | 6400 | 136000 |
2022-05-13 | Hidalgo | New Mexico | 35023 | 1104 | 15 | 4198 | 3573 | 262982 |
2022-05-13 | Lea | New Mexico | 35025 | 20174 | 342 | 71070 | 4812 | 283860 |
2022-05-13 | Lincoln | New Mexico | 35027 | 5296 | 67 | 19572 | 3423 | 270590 |
2022-05-13 | Los Alamos | New Mexico | 35028 | 2880 | 16 | 19369 | 826 | 148691 |
2022-05-13 | Luna | New Mexico | 35029 | 6725 | 129 | 23709 | 5440 | 283647 |
2022-05-13 | McKinley | New Mexico | 35031 | 26007 | 589 | 71367 | 8253 | 364412 |
2022-05-13 | Mora | New Mexico | 35033 | 772 | 18 | 4521 | 3981 | 170758 |
2022-05-13 | Otero | New Mexico | 35035 | 15613 | 187 | 67490 | 2770 | 231337 |
2022-05-13 | Quay | New Mexico | 35037 | 2006 | 54 | 8253 | 6543 | 243063 |
2022-05-13 | Rio Arriba | New Mexico | 35039 | 10047 | 135 | 38921 | 3468 | 258138 |
2022-05-13 | Roosevelt | New Mexico | 35041 | 5023 | 97 | 18500 | 5243 | 271513 |
2022-05-13 | San Juan | New Mexico | 35045 | 40943 | 755 | 123958 | 6090 | 330297 |
2022-05-13 | San Miguel | New Mexico | 35047 | 5926 | 63 | 27277 | 2309 | 217252 |
2022-05-13 | Sandoval | New Mexico | 35043 | 34112 | 436 | 146748 | 2971 | 232452 |
2022-05-13 | Santa Fe | New Mexico | 35049 | 29503 | 287 | 150358 | 1908 | 196218 |
2022-05-13 | Sierra | New Mexico | 35051 | 2048 | 73 | 10791 | 6764 | 189787 |
2022-05-13 | Socorro | New Mexico | 35053 | 3834 | 88 | 16637 | 5289 | 230450 |
2022-05-13 | Taos | New Mexico | 35055 | 5425 | 90 | 32723 | 2750 | 165785 |
2022-05-13 | Torrance | New Mexico | 35057 | 3152 | 56 | 15461 | 3622 | 203867 |
2022-05-13 | Union | New Mexico | 35059 | 1007 | 16 | 4059 | 3941 | 248090 |
2022-05-13 | Valencia | New Mexico | 35061 | 19238 | 276 | 76688 | 3598 | 250860 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;