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-12 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 |
---|---|---|---|---|---|---|---|
137882 | 137882 | 2020-05-12 | Bernalillo | New Mexico | 35001 | 1111 | 50 |
137883 | 137883 | 2020-05-12 | Catron | New Mexico | 35003 | 2 | 1 |
137884 | 137884 | 2020-05-12 | Chaves | New Mexico | 35005 | 28 | 2 |
137885 | 137885 | 2020-05-12 | Cibola | New Mexico | 35006 | 89 | 4 |
137886 | 137886 | 2020-05-12 | Colfax | New Mexico | 35007 | 5 | 0 |
137887 | 137887 | 2020-05-12 | Curry | New Mexico | 35009 | 32 | 0 |
137888 | 137888 | 2020-05-12 | Doña Ana | New Mexico | 35013 | 256 | 2 |
137889 | 137889 | 2020-05-12 | Eddy | New Mexico | 35015 | 14 | 1 |
137890 | 137890 | 2020-05-12 | Grant | New Mexico | 35017 | 15 | 0 |
137891 | 137891 | 2020-05-12 | Guadalupe | New Mexico | 35019 | 17 | 0 |
137892 | 137892 | 2020-05-12 | Harding | New Mexico | 35021 | 1 | 0 |
137893 | 137893 | 2020-05-12 | Lea | New Mexico | 35025 | 15 | 0 |
137894 | 137894 | 2020-05-12 | Lincoln | New Mexico | 35027 | 2 | 0 |
137895 | 137895 | 2020-05-12 | Los Alamos | New Mexico | 35028 | 6 | 0 |
137896 | 137896 | 2020-05-12 | Luna | New Mexico | 35029 | 8 | 1 |
137897 | 137897 | 2020-05-12 | McKinley | New Mexico | 35031 | 1628 | 55 |
137898 | 137898 | 2020-05-12 | Otero | New Mexico | 35035 | 46 | 0 |
137899 | 137899 | 2020-05-12 | Quay | New Mexico | 35037 | 5 | 1 |
137900 | 137900 | 2020-05-12 | Rio Arriba | New Mexico | 35039 | 28 | 0 |
137901 | 137901 | 2020-05-12 | Roosevelt | New Mexico | 35041 | 12 | 0 |
137902 | 137902 | 2020-05-12 | San Juan | New Mexico | 35045 | 1149 | 74 |
137903 | 137903 | 2020-05-12 | San Miguel | New Mexico | 35047 | 7 | 0 |
137904 | 137904 | 2020-05-12 | Sandoval | New Mexico | 35043 | 474 | 21 |
137905 | 137905 | 2020-05-12 | Santa Fe | New Mexico | 35049 | 112 | 2 |
137906 | 137906 | 2020-05-12 | Sierra | New Mexico | 35051 | 1 | 0 |
137907 | 137907 | 2020-05-12 | Socorro | New Mexico | 35053 | 49 | 3 |
137908 | 137908 | 2020-05-12 | Taos | New Mexico | 35055 | 21 | 0 |
137909 | 137909 | 2020-05-12 | Torrance | New Mexico | 35057 | 19 | 1 |
137910 | 137910 | 2020-05-12 | Union | New Mexico | 35059 | 3 | 0 |
137911 | 137911 | 2020-05-12 | Valencia | New Mexico | 35061 | 57 | 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);