ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where "date" is on date 2022-04-23 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2436259 | 2436259 | 2022-04-23 | Bernalillo | New Mexico | 35001 | 147598 | 1819 |
2436260 | 2436260 | 2022-04-23 | Catron | New Mexico | 35003 | 421 | 13 |
2436261 | 2436261 | 2022-04-23 | Chaves | New Mexico | 35005 | 21725 | 323 |
2436262 | 2436262 | 2022-04-23 | Cibola | New Mexico | 35006 | 7914 | 185 |
2436263 | 2436263 | 2022-04-23 | Colfax | New Mexico | 35007 | 2700 | 65 |
2436264 | 2436264 | 2022-04-23 | Curry | New Mexico | 35009 | 12677 | 190 |
2436265 | 2436265 | 2022-04-23 | De Baca | New Mexico | 35011 | 572 | 5 |
2436266 | 2436266 | 2022-04-23 | Doña Ana | New Mexico | 35013 | 63460 | 752 |
2436267 | 2436267 | 2022-04-23 | Eddy | New Mexico | 35015 | 17020 | 277 |
2436268 | 2436268 | 2022-04-23 | Grant | New Mexico | 35017 | 6673 | 87 |
2436269 | 2436269 | 2022-04-23 | Guadalupe | New Mexico | 35019 | 1479 | 17 |
2436270 | 2436270 | 2022-04-23 | Harding | New Mexico | 35021 | 83 | 4 |
2436271 | 2436271 | 2022-04-23 | Hidalgo | New Mexico | 35023 | 1100 | 14 |
2436272 | 2436272 | 2022-04-23 | Lea | New Mexico | 35025 | 20155 | 333 |
2436273 | 2436273 | 2022-04-23 | Lincoln | New Mexico | 35027 | 5253 | 66 |
2436274 | 2436274 | 2022-04-23 | Los Alamos | New Mexico | 35028 | 2781 | 16 |
2436275 | 2436275 | 2022-04-23 | Luna | New Mexico | 35029 | 6716 | 126 |
2436276 | 2436276 | 2022-04-23 | McKinley | New Mexico | 35031 | 25903 | 587 |
2436277 | 2436277 | 2022-04-23 | Mora | New Mexico | 35033 | 764 | 17 |
2436278 | 2436278 | 2022-04-23 | Otero | New Mexico | 35035 | 15549 | 185 |
2436279 | 2436279 | 2022-04-23 | Quay | New Mexico | 35037 | 2004 | 51 |
2436280 | 2436280 | 2022-04-23 | Rio Arriba | New Mexico | 35039 | 9824 | 132 |
2436281 | 2436281 | 2022-04-23 | Roosevelt | New Mexico | 35041 | 5008 | 92 |
2436282 | 2436282 | 2022-04-23 | San Juan | New Mexico | 35045 | 40777 | 745 |
2436283 | 2436283 | 2022-04-23 | San Miguel | New Mexico | 35047 | 5875 | 58 |
2436284 | 2436284 | 2022-04-23 | Sandoval | New Mexico | 35043 | 33672 | 424 |
2436285 | 2436285 | 2022-04-23 | Santa Fe | New Mexico | 35049 | 28863 | 273 |
2436286 | 2436286 | 2022-04-23 | Sierra | New Mexico | 35051 | 2042 | 71 |
2436287 | 2436287 | 2022-04-23 | Socorro | New Mexico | 35053 | 3800 | 87 |
2436288 | 2436288 | 2022-04-23 | Taos | New Mexico | 35055 | 5351 | 90 |
2436289 | 2436289 | 2022-04-23 | Torrance | New Mexico | 35057 | 3133 | 54 |
2436290 | 2436290 | 2022-04-23 | Union | New Mexico | 35059 | 1005 | 16 |
2436291 | 2436291 | 2022-04-23 | Unknown | New Mexico | 30 | 0 | |
2436292 | 2436292 | 2022-04-23 | Valencia | New Mexico | 35061 | 19091 | 270 |
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);