ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where "date" is on date 2020-05-15 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
146874 | 146874 | 2020-05-15 | Bernalillo | New Mexico | 35001 | 1180 | 56 |
146875 | 146875 | 2020-05-15 | Catron | New Mexico | 35003 | 2 | 1 |
146876 | 146876 | 2020-05-15 | Chaves | New Mexico | 35005 | 30 | 2 |
146877 | 146877 | 2020-05-15 | Cibola | New Mexico | 35006 | 102 | 4 |
146878 | 146878 | 2020-05-15 | Colfax | New Mexico | 35007 | 5 | 0 |
146879 | 146879 | 2020-05-15 | Curry | New Mexico | 35009 | 36 | 0 |
146880 | 146880 | 2020-05-15 | Doña Ana | New Mexico | 35013 | 281 | 2 |
146881 | 146881 | 2020-05-15 | Eddy | New Mexico | 35015 | 17 | 1 |
146882 | 146882 | 2020-05-15 | Grant | New Mexico | 35017 | 16 | 0 |
146883 | 146883 | 2020-05-15 | Guadalupe | New Mexico | 35019 | 19 | 0 |
146884 | 146884 | 2020-05-15 | Harding | New Mexico | 35021 | 1 | 0 |
146885 | 146885 | 2020-05-15 | Lea | New Mexico | 35025 | 15 | 0 |
146886 | 146886 | 2020-05-15 | Lincoln | New Mexico | 35027 | 2 | 0 |
146887 | 146887 | 2020-05-15 | Los Alamos | New Mexico | 35028 | 6 | 0 |
146888 | 146888 | 2020-05-15 | Luna | New Mexico | 35029 | 8 | 1 |
146889 | 146889 | 2020-05-15 | McKinley | New Mexico | 35031 | 1787 | 69 |
146890 | 146890 | 2020-05-15 | Otero | New Mexico | 35035 | 68 | 1 |
146891 | 146891 | 2020-05-15 | Quay | New Mexico | 35037 | 5 | 1 |
146892 | 146892 | 2020-05-15 | Rio Arriba | New Mexico | 35039 | 30 | 0 |
146893 | 146893 | 2020-05-15 | Roosevelt | New Mexico | 35041 | 14 | 0 |
146894 | 146894 | 2020-05-15 | San Juan | New Mexico | 35045 | 1274 | 84 |
146895 | 146895 | 2020-05-15 | San Miguel | New Mexico | 35047 | 9 | 0 |
146896 | 146896 | 2020-05-15 | Sandoval | New Mexico | 35043 | 483 | 22 |
146897 | 146897 | 2020-05-15 | Santa Fe | New Mexico | 35049 | 114 | 3 |
146898 | 146898 | 2020-05-15 | Sierra | New Mexico | 35051 | 1 | 0 |
146899 | 146899 | 2020-05-15 | Socorro | New Mexico | 35053 | 49 | 4 |
146900 | 146900 | 2020-05-15 | Taos | New Mexico | 35055 | 23 | 0 |
146901 | 146901 | 2020-05-15 | Torrance | New Mexico | 35057 | 19 | 1 |
146902 | 146902 | 2020-05-15 | Union | New Mexico | 35059 | 3 | 0 |
146903 | 146903 | 2020-05-15 | Valencia | New Mexico | 35061 | 63 | 1 |
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);