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

33 rows where "date" is on date 2020-11-08 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 · 33 ✖
Link rowid date ▲ county state fips cases deaths
711310 711310 2020-11-08 Bernalillo New Mexico 35001 13768 239
711311 711311 2020-11-08 Catron New Mexico 35003 10 1
711312 711312 2020-11-08 Chaves New Mexico 35005 2771 21
711313 711313 2020-11-08 Cibola New Mexico 35006 1152 28
711314 711314 2020-11-08 Colfax New Mexico 35007 63 1
711315 711315 2020-11-08 Curry New Mexico 35009 1974 13
711316 711316 2020-11-08 De Baca New Mexico 35011 5 0
711317 711317 2020-11-08 Doña Ana New Mexico 35013 8301 102
711318 711318 2020-11-08 Eddy New Mexico 35015 1853 29
711319 711319 2020-11-08 Grant New Mexico 35017 238 4
711320 711320 2020-11-08 Guadalupe New Mexico 35019 57 1
711321 711321 2020-11-08 Harding New Mexico 35021 1 0
711322 711322 2020-11-08 Hidalgo New Mexico 35023 131 2
711323 711323 2020-11-08 Lea New Mexico 35025 2675 33
711324 711324 2020-11-08 Lincoln New Mexico 35027 444 6
711325 711325 2020-11-08 Los Alamos New Mexico 35028 67 0
711326 711326 2020-11-08 Luna New Mexico 35029 1377 15
711327 711327 2020-11-08 McKinley New Mexico 35031 5008 263
711328 711328 2020-11-08 Mora New Mexico 35033 18 0
711329 711329 2020-11-08 Otero New Mexico 35035 1756 17
711330 711330 2020-11-08 Quay New Mexico 35037 129 2
711331 711331 2020-11-08 Rio Arriba New Mexico 35039 641 16
711332 711332 2020-11-08 Roosevelt New Mexico 35041 618 10
711333 711333 2020-11-08 San Juan New Mexico 35045 4112 207
711334 711334 2020-11-08 San Miguel New Mexico 35047 238 0
711335 711335 2020-11-08 Sandoval New Mexico 35043 2446 52
711336 711336 2020-11-08 Santa Fe New Mexico 35049 2497 19
711337 711337 2020-11-08 Sierra New Mexico 35051 160 2
711338 711338 2020-11-08 Socorro New Mexico 35053 324 16
711339 711339 2020-11-08 Taos New Mexico 35055 340 6
711340 711340 2020-11-08 Torrance New Mexico 35057 178 1
711341 711341 2020-11-08 Union New Mexico 35059 57 2
711342 711342 2020-11-08 Valencia New Mexico 35061 1472 10

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