ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where "date" is on date 2020-07-19 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 |
---|---|---|---|---|---|---|---|
349208 | 349208 | 2020-07-19 | Bernalillo | New Mexico | 35001 | 3775 | 100 |
349209 | 349209 | 2020-07-19 | Catron | New Mexico | 35003 | 4 | 1 |
349210 | 349210 | 2020-07-19 | Chaves | New Mexico | 35005 | 197 | 4 |
349211 | 349211 | 2020-07-19 | Cibola | New Mexico | 35006 | 265 | 15 |
349212 | 349212 | 2020-07-19 | Colfax | New Mexico | 35007 | 11 | 1 |
349213 | 349213 | 2020-07-19 | Curry | New Mexico | 35009 | 302 | 1 |
349214 | 349214 | 2020-07-19 | Doña Ana | New Mexico | 35013 | 1728 | 13 |
349215 | 349215 | 2020-07-19 | Eddy | New Mexico | 35015 | 181 | 2 |
349216 | 349216 | 2020-07-19 | Grant | New Mexico | 35017 | 49 | 0 |
349217 | 349217 | 2020-07-19 | Guadalupe | New Mexico | 35019 | 24 | 0 |
349218 | 349218 | 2020-07-19 | Harding | New Mexico | 35021 | 1 | 0 |
349219 | 349219 | 2020-07-19 | Hidalgo | New Mexico | 35023 | 78 | 0 |
349220 | 349220 | 2020-07-19 | Lea | New Mexico | 35025 | 378 | 0 |
349221 | 349221 | 2020-07-19 | Lincoln | New Mexico | 35027 | 36 | 0 |
349222 | 349222 | 2020-07-19 | Los Alamos | New Mexico | 35028 | 14 | 0 |
349223 | 349223 | 2020-07-19 | Luna | New Mexico | 35029 | 145 | 3 |
349224 | 349224 | 2020-07-19 | McKinley | New Mexico | 35031 | 3754 | 199 |
349225 | 349225 | 2020-07-19 | Mora | New Mexico | 35033 | 3 | 0 |
349226 | 349226 | 2020-07-19 | Otero | New Mexico | 35035 | 977 | 10 |
349227 | 349227 | 2020-07-19 | Quay | New Mexico | 35037 | 22 | 1 |
349228 | 349228 | 2020-07-19 | Rio Arriba | New Mexico | 35039 | 199 | 1 |
349229 | 349229 | 2020-07-19 | Roosevelt | New Mexico | 35041 | 89 | 1 |
349230 | 349230 | 2020-07-19 | San Juan | New Mexico | 35045 | 2834 | 176 |
349231 | 349231 | 2020-07-19 | San Miguel | New Mexico | 35047 | 32 | 0 |
349232 | 349232 | 2020-07-19 | Sandoval | New Mexico | 35043 | 919 | 31 |
349233 | 349233 | 2020-07-19 | Santa Fe | New Mexico | 35049 | 418 | 3 |
349234 | 349234 | 2020-07-19 | Sierra | New Mexico | 35051 | 20 | 0 |
349235 | 349235 | 2020-07-19 | Socorro | New Mexico | 35053 | 65 | 5 |
349236 | 349236 | 2020-07-19 | Taos | New Mexico | 35055 | 69 | 1 |
349237 | 349237 | 2020-07-19 | Torrance | New Mexico | 35057 | 94 | 1 |
349238 | 349238 | 2020-07-19 | Union | New Mexico | 35059 | 14 | 0 |
349239 | 349239 | 2020-07-19 | Valencia | New Mexico | 35061 | 274 | 2 |
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);