ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

31 rows where "date" is on date 2020-06-06 and state = "New Mexico" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths

state 1

  • New Mexico · 31 ✖
Link rowid date ▲ county state fips cases deaths
213954 213954 2020-06-06 Bernalillo New Mexico 35001 1575 74
213955 213955 2020-06-06 Catron New Mexico 35003 2 1
213956 213956 2020-06-06 Chaves New Mexico 35005 49 2
213957 213957 2020-06-06 Cibola New Mexico 35006 161 6
213958 213958 2020-06-06 Colfax New Mexico 35007 5 0
213959 213959 2020-06-06 Curry New Mexico 35009 62 0
213960 213960 2020-06-06 Doña Ana New Mexico 35013 569 3
213961 213961 2020-06-06 Eddy New Mexico 35015 30 1
213962 213962 2020-06-06 Grant New Mexico 35017 15 0
213963 213963 2020-06-06 Guadalupe New Mexico 35019 20 0
213964 213964 2020-06-06 Harding New Mexico 35021 1 0
213965 213965 2020-06-06 Hidalgo New Mexico 35023 1 0
213966 213966 2020-06-06 Lea New Mexico 35025 29 0
213967 213967 2020-06-06 Lincoln New Mexico 35027 5 0
213968 213968 2020-06-06 Los Alamos New Mexico 35028 6 0
213969 213969 2020-06-06 Luna New Mexico 35029 11 1
213970 213970 2020-06-06 McKinley New Mexico 35031 2657 129
213971 213971 2020-06-06 Otero New Mexico 35035 600 4
213972 213972 2020-06-06 Quay New Mexico 35037 5 1
213973 213973 2020-06-06 Rio Arriba New Mexico 35039 54 1
213974 213974 2020-06-06 Roosevelt New Mexico 35041 42 0
213975 213975 2020-06-06 San Juan New Mexico 35045 1923 131
213976 213976 2020-06-06 San Miguel New Mexico 35047 15 0
213977 213977 2020-06-06 Sandoval New Mexico 35043 585 27
213978 213978 2020-06-06 Santa Fe New Mexico 35049 151 3
213979 213979 2020-06-06 Sierra New Mexico 35051 1 0
213980 213980 2020-06-06 Socorro New Mexico 35053 55 5
213981 213981 2020-06-06 Taos New Mexico 35055 31 0
213982 213982 2020-06-06 Torrance New Mexico 35057 53 1
213983 213983 2020-06-06 Union New Mexico 35059 5 0
213984 213984 2020-06-06 Valencia New Mexico 35061 82 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);