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 2020-11-28 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 |
---|---|---|---|---|---|---|---|
776210 | 776210 | 2020-11-28 | Bernalillo | New Mexico | 35001 | 25847 | 332 |
776211 | 776211 | 2020-11-28 | Catron | New Mexico | 35003 | 35 | 1 |
776212 | 776212 | 2020-11-28 | Chaves | New Mexico | 35005 | 4753 | 39 |
776213 | 776213 | 2020-11-28 | Cibola | New Mexico | 35006 | 2060 | 43 |
776214 | 776214 | 2020-11-28 | Colfax | New Mexico | 35007 | 202 | 3 |
776215 | 776215 | 2020-11-28 | Curry | New Mexico | 35009 | 3124 | 20 |
776216 | 776216 | 2020-11-28 | De Baca | New Mexico | 35011 | 43 | 0 |
776217 | 776217 | 2020-11-28 | Doña Ana | New Mexico | 35013 | 13367 | 183 |
776218 | 776218 | 2020-11-28 | Eddy | New Mexico | 35015 | 2933 | 42 |
776219 | 776219 | 2020-11-28 | Grant | New Mexico | 35017 | 484 | 6 |
776220 | 776220 | 2020-11-28 | Guadalupe | New Mexico | 35019 | 191 | 2 |
776221 | 776221 | 2020-11-28 | Harding | New Mexico | 35021 | 6 | 0 |
776222 | 776222 | 2020-11-28 | Hidalgo | New Mexico | 35023 | 183 | 3 |
776223 | 776223 | 2020-11-28 | Lea | New Mexico | 35025 | 4308 | 43 |
776224 | 776224 | 2020-11-28 | Lincoln | New Mexico | 35027 | 764 | 8 |
776225 | 776225 | 2020-11-28 | Los Alamos | New Mexico | 35028 | 132 | 0 |
776226 | 776226 | 2020-11-28 | Luna | New Mexico | 35029 | 1935 | 25 |
776227 | 776227 | 2020-11-28 | McKinley | New Mexico | 35031 | 6955 | 276 |
776228 | 776228 | 2020-11-28 | Mora | New Mexico | 35033 | 35 | 0 |
776229 | 776229 | 2020-11-28 | Otero | New Mexico | 35035 | 2450 | 24 |
776230 | 776230 | 2020-11-28 | Quay | New Mexico | 35037 | 226 | 4 |
776231 | 776231 | 2020-11-28 | Rio Arriba | New Mexico | 35039 | 1267 | 22 |
776232 | 776232 | 2020-11-28 | Roosevelt | New Mexico | 35041 | 972 | 13 |
776233 | 776233 | 2020-11-28 | San Juan | New Mexico | 35045 | 5835 | 235 |
776234 | 776234 | 2020-11-28 | San Miguel | New Mexico | 35047 | 407 | 2 |
776235 | 776235 | 2020-11-28 | Sandoval | New Mexico | 35043 | 4988 | 79 |
776236 | 776236 | 2020-11-28 | Santa Fe | New Mexico | 35049 | 5068 | 35 |
776237 | 776237 | 2020-11-28 | Sierra | New Mexico | 35051 | 331 | 6 |
776238 | 776238 | 2020-11-28 | Socorro | New Mexico | 35053 | 606 | 27 |
776239 | 776239 | 2020-11-28 | Taos | New Mexico | 35055 | 802 | 22 |
776240 | 776240 | 2020-11-28 | Torrance | New Mexico | 35057 | 339 | 2 |
776241 | 776241 | 2020-11-28 | Union | New Mexico | 35059 | 219 | 4 |
776242 | 776242 | 2020-11-28 | Valencia | New Mexico | 35061 | 3115 | 26 |
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);