ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where date = "2020-07-26" and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
371651 | 371651 | 2020-07-26 | Bernalillo | New Mexico | 35001 | 4405 | 111 |
371652 | 371652 | 2020-07-26 | Catron | New Mexico | 35003 | 4 | 1 |
371653 | 371653 | 2020-07-26 | Chaves | New Mexico | 35005 | 267 | 4 |
371654 | 371654 | 2020-07-26 | Cibola | New Mexico | 35006 | 301 | 17 |
371655 | 371655 | 2020-07-26 | Colfax | New Mexico | 35007 | 12 | 1 |
371656 | 371656 | 2020-07-26 | Curry | New Mexico | 35009 | 379 | 2 |
371657 | 371657 | 2020-07-26 | Doña Ana | New Mexico | 35013 | 2001 | 16 |
371658 | 371658 | 2020-07-26 | Eddy | New Mexico | 35015 | 221 | 2 |
371659 | 371659 | 2020-07-26 | Grant | New Mexico | 35017 | 63 | 1 |
371660 | 371660 | 2020-07-26 | Guadalupe | New Mexico | 35019 | 29 | 0 |
371661 | 371661 | 2020-07-26 | Harding | New Mexico | 35021 | 1 | 0 |
371662 | 371662 | 2020-07-26 | Hidalgo | New Mexico | 35023 | 85 | 0 |
371663 | 371663 | 2020-07-26 | Lea | New Mexico | 35025 | 525 | 2 |
371664 | 371664 | 2020-07-26 | Lincoln | New Mexico | 35027 | 75 | 1 |
371665 | 371665 | 2020-07-26 | Los Alamos | New Mexico | 35028 | 16 | 0 |
371666 | 371666 | 2020-07-26 | Luna | New Mexico | 35029 | 190 | 3 |
371667 | 371667 | 2020-07-26 | McKinley | New Mexico | 35031 | 3909 | 214 |
371668 | 371668 | 2020-07-26 | Mora | New Mexico | 35033 | 6 | 0 |
371669 | 371669 | 2020-07-26 | Otero | New Mexico | 35035 | 1050 | 10 |
371670 | 371670 | 2020-07-26 | Quay | New Mexico | 35037 | 31 | 1 |
371671 | 371671 | 2020-07-26 | Rio Arriba | New Mexico | 35039 | 275 | 3 |
371672 | 371672 | 2020-07-26 | Roosevelt | New Mexico | 35041 | 110 | 1 |
371673 | 371673 | 2020-07-26 | San Juan | New Mexico | 35045 | 2915 | 178 |
371674 | 371674 | 2020-07-26 | San Miguel | New Mexico | 35047 | 39 | 0 |
371675 | 371675 | 2020-07-26 | Sandoval | New Mexico | 35043 | 1009 | 33 |
371676 | 371676 | 2020-07-26 | Santa Fe | New Mexico | 35049 | 498 | 3 |
371677 | 371677 | 2020-07-26 | Sierra | New Mexico | 35051 | 26 | 0 |
371678 | 371678 | 2020-07-26 | Socorro | New Mexico | 35053 | 71 | 5 |
371679 | 371679 | 2020-07-26 | Taos | New Mexico | 35055 | 84 | 1 |
371680 | 371680 | 2020-07-26 | Torrance | New Mexico | 35057 | 95 | 1 |
371681 | 371681 | 2020-07-26 | Union | New Mexico | 35059 | 24 | 0 |
371682 | 371682 | 2020-07-26 | Valencia | New Mexico | 35061 | 337 | 3 |
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);