ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where "date" is on date 2021-10-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 |
---|---|---|---|---|---|---|---|
1772940 | 1772940 | 2021-10-01 | Bernalillo | New Mexico | 35001 | 71541 | 1071 |
1772941 | 1772941 | 2021-10-01 | Catron | New Mexico | 35003 | 144 | 7 |
1772942 | 1772942 | 2021-10-01 | Chaves | New Mexico | 35005 | 12200 | 190 |
1772943 | 1772943 | 2021-10-01 | Cibola | New Mexico | 35006 | 4010 | 135 |
1772944 | 1772944 | 2021-10-01 | Colfax | New Mexico | 35007 | 1318 | 47 |
1772945 | 1772945 | 2021-10-01 | Curry | New Mexico | 35009 | 7104 | 106 |
1772946 | 1772946 | 2021-10-01 | De Baca | New Mexico | 35011 | 220 | 3 |
1772947 | 1772947 | 2021-10-01 | Doña Ana | New Mexico | 35013 | 28903 | 522 |
1772948 | 1772948 | 2021-10-01 | Eddy | New Mexico | 35015 | 10352 | 184 |
1772949 | 1772949 | 2021-10-01 | Grant | New Mexico | 35017 | 2092 | 48 |
1772950 | 1772950 | 2021-10-01 | Guadalupe | New Mexico | 35019 | 841 | 15 |
1772951 | 1772951 | 2021-10-01 | Harding | New Mexico | 35021 | 16 | 2 |
1772952 | 1772952 | 2021-10-01 | Hidalgo | New Mexico | 35023 | 540 | 11 |
1772953 | 1772953 | 2021-10-01 | Lea | New Mexico | 35025 | 13809 | 249 |
1772954 | 1772954 | 2021-10-01 | Lincoln | New Mexico | 35027 | 2674 | 29 |
1772955 | 1772955 | 2021-10-01 | Los Alamos | New Mexico | 35028 | 668 | 9 |
1772956 | 1772956 | 2021-10-01 | Luna | New Mexico | 35029 | 3794 | 93 |
1772957 | 1772957 | 2021-10-01 | McKinley | New Mexico | 35031 | 13876 | 496 |
1772958 | 1772958 | 2021-10-01 | Mora | New Mexico | 35033 | 302 | 10 |
1772959 | 1772959 | 2021-10-01 | Otero | New Mexico | 35035 | 7086 | 96 |
1772960 | 1772960 | 2021-10-01 | Quay | New Mexico | 35037 | 940 | 14 |
1772961 | 1772961 | 2021-10-01 | Rio Arriba | New Mexico | 35039 | 4511 | 83 |
1772962 | 1772962 | 2021-10-01 | Roosevelt | New Mexico | 35041 | 2583 | 67 |
1772963 | 1772963 | 2021-10-01 | San Juan | New Mexico | 35045 | 18573 | 534 |
1772964 | 1772964 | 2021-10-01 | San Miguel | New Mexico | 35047 | 2385 | 20 |
1772965 | 1772965 | 2021-10-01 | Sandoval | New Mexico | 35043 | 14926 | 264 |
1772966 | 1772966 | 2021-10-01 | Santa Fe | New Mexico | 35049 | 12603 | 165 |
1772967 | 1772967 | 2021-10-01 | Sierra | New Mexico | 35051 | 957 | 54 |
1772968 | 1772968 | 2021-10-01 | Socorro | New Mexico | 35053 | 1600 | 62 |
1772969 | 1772969 | 2021-10-01 | Taos | New Mexico | 35055 | 2225 | 61 |
1772970 | 1772970 | 2021-10-01 | Torrance | New Mexico | 35057 | 1628 | 18 |
1772971 | 1772971 | 2021-10-01 | Union | New Mexico | 35059 | 498 | 11 |
1772972 | 1772972 | 2021-10-01 | Unknown | New Mexico | 13 | 0 | |
1772973 | 1772973 | 2021-10-01 | Valencia | New Mexico | 35061 | 8883 | 138 |
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);