ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where "date" is on date 2021-11-08 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1896411 | 1896411 | 2021-11-08 | Bernalillo | New Mexico | 35001 | 79097 | 1133 |
1896412 | 1896412 | 2021-11-08 | Catron | New Mexico | 35003 | 235 | 7 |
1896413 | 1896413 | 2021-11-08 | Chaves | New Mexico | 35005 | 13293 | 207 |
1896414 | 1896414 | 2021-11-08 | Cibola | New Mexico | 35006 | 4519 | 145 |
1896415 | 1896415 | 2021-11-08 | Colfax | New Mexico | 35007 | 1592 | 48 |
1896416 | 1896416 | 2021-11-08 | Curry | New Mexico | 35009 | 7535 | 121 |
1896417 | 1896417 | 2021-11-08 | De Baca | New Mexico | 35011 | 276 | 3 |
1896418 | 1896418 | 2021-11-08 | Doña Ana | New Mexico | 35013 | 32208 | 540 |
1896419 | 1896419 | 2021-11-08 | Eddy | New Mexico | 35015 | 11150 | 206 |
1896420 | 1896420 | 2021-11-08 | Grant | New Mexico | 35017 | 3070 | 52 |
1896421 | 1896421 | 2021-11-08 | Guadalupe | New Mexico | 35019 | 881 | 15 |
1896422 | 1896422 | 2021-11-08 | Harding | New Mexico | 35021 | 44 | 3 |
1896423 | 1896423 | 2021-11-08 | Hidalgo | New Mexico | 35023 | 608 | 11 |
1896424 | 1896424 | 2021-11-08 | Lea | New Mexico | 35025 | 14512 | 278 |
1896425 | 1896425 | 2021-11-08 | Lincoln | New Mexico | 35027 | 3179 | 37 |
1896426 | 1896426 | 2021-11-08 | Los Alamos | New Mexico | 35028 | 831 | 9 |
1896427 | 1896427 | 2021-11-08 | Luna | New Mexico | 35029 | 4177 | 96 |
1896428 | 1896428 | 2021-11-08 | McKinley | New Mexico | 35031 | 15614 | 515 |
1896429 | 1896429 | 2021-11-08 | Mora | New Mexico | 35033 | 383 | 11 |
1896430 | 1896430 | 2021-11-08 | Otero | New Mexico | 35035 | 8935 | 105 |
1896431 | 1896431 | 2021-11-08 | Quay | New Mexico | 35037 | 1064 | 23 |
1896432 | 1896432 | 2021-11-08 | Rio Arriba | New Mexico | 35039 | 5233 | 85 |
1896433 | 1896433 | 2021-11-08 | Roosevelt | New Mexico | 35041 | 2833 | 70 |
1896434 | 1896434 | 2021-11-08 | San Juan | New Mexico | 35045 | 23501 | 565 |
1896435 | 1896435 | 2021-11-08 | San Miguel | New Mexico | 35047 | 2723 | 27 |
1896436 | 1896436 | 2021-11-08 | Sandoval | New Mexico | 35043 | 16738 | 276 |
1896437 | 1896437 | 2021-11-08 | Santa Fe | New Mexico | 35049 | 13912 | 174 |
1896438 | 1896438 | 2021-11-08 | Sierra | New Mexico | 35051 | 1121 | 57 |
1896439 | 1896439 | 2021-11-08 | Socorro | New Mexico | 35053 | 1816 | 64 |
1896440 | 1896440 | 2021-11-08 | Taos | New Mexico | 35055 | 2618 | 66 |
1896441 | 1896441 | 2021-11-08 | Torrance | New Mexico | 35057 | 1836 | 20 |
1896442 | 1896442 | 2021-11-08 | Union | New Mexico | 35059 | 571 | 12 |
1896443 | 1896443 | 2021-11-08 | Valencia | New Mexico | 35061 | 9981 | 145 |
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);