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-09-01 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
490945 | 490945 | 2020-09-01 | Bernalillo | New Mexico | 35001 | 5838 | 158 |
490946 | 490946 | 2020-09-01 | Catron | New Mexico | 35003 | 5 | 1 |
490947 | 490947 | 2020-09-01 | Chaves | New Mexico | 35005 | 731 | 6 |
490948 | 490948 | 2020-09-01 | Cibola | New Mexico | 35006 | 727 | 20 |
490949 | 490949 | 2020-09-01 | Colfax | New Mexico | 35007 | 19 | 1 |
490950 | 490950 | 2020-09-01 | Curry | New Mexico | 35009 | 675 | 5 |
490951 | 490951 | 2020-09-01 | Doña Ana | New Mexico | 35013 | 2870 | 43 |
490952 | 490952 | 2020-09-01 | Eddy | New Mexico | 35015 | 500 | 5 |
490953 | 490953 | 2020-09-01 | Grant | New Mexico | 35017 | 83 | 2 |
490954 | 490954 | 2020-09-01 | Guadalupe | New Mexico | 35019 | 32 | 1 |
490955 | 490955 | 2020-09-01 | Harding | New Mexico | 35021 | 2 | 0 |
490956 | 490956 | 2020-09-01 | Hidalgo | New Mexico | 35023 | 98 | 2 |
490957 | 490957 | 2020-09-01 | Lea | New Mexico | 35025 | 1136 | 15 |
490958 | 490958 | 2020-09-01 | Lincoln | New Mexico | 35027 | 171 | 2 |
490959 | 490959 | 2020-09-01 | Los Alamos | New Mexico | 35028 | 27 | 0 |
490960 | 490960 | 2020-09-01 | Luna | New Mexico | 35029 | 316 | 5 |
490961 | 490961 | 2020-09-01 | McKinley | New Mexico | 35031 | 4213 | 243 |
490962 | 490962 | 2020-09-01 | Mora | New Mexico | 35033 | 6 | 0 |
490963 | 490963 | 2020-09-01 | Otero | New Mexico | 35035 | 1124 | 12 |
490964 | 490964 | 2020-09-01 | Quay | New Mexico | 35037 | 62 | 2 |
490965 | 490965 | 2020-09-01 | Rio Arriba | New Mexico | 35039 | 358 | 13 |
490966 | 490966 | 2020-09-01 | Roosevelt | New Mexico | 35041 | 201 | 2 |
490967 | 490967 | 2020-09-01 | San Juan | New Mexico | 35045 | 3194 | 191 |
490968 | 490968 | 2020-09-01 | San Miguel | New Mexico | 35047 | 82 | 0 |
490969 | 490969 | 2020-09-01 | Sandoval | New Mexico | 35043 | 1254 | 37 |
490970 | 490970 | 2020-09-01 | Santa Fe | New Mexico | 35049 | 824 | 4 |
490971 | 490971 | 2020-09-01 | Sierra | New Mexico | 35051 | 38 | 1 |
490972 | 490972 | 2020-09-01 | Socorro | New Mexico | 35053 | 77 | 6 |
490973 | 490973 | 2020-09-01 | Taos | New Mexico | 35055 | 115 | 3 |
490974 | 490974 | 2020-09-01 | Torrance | New Mexico | 35057 | 107 | 1 |
490975 | 490975 | 2020-09-01 | Union | New Mexico | 35059 | 32 | 2 |
490976 | 490976 | 2020-09-01 | Valencia | New Mexico | 35061 | 543 | 4 |
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);